(Martin Adams, Evan Jardine-Skinner and Martin Smithson) This article shows you two ways to populate WebSphere Service Registry and Repository (hereafter called Service Registry) with existing web services information. Part 1 shows you how to use a sample Java application to load information from a

(Craig S. Mullins) The access paths formulated by the DB2 optimizer during the BIND and REBIND processes are critical to your application performance. It is these access paths that determine not only how DB2 data is accessed by your program, but how efficiently it is accessed.

(Scott Hayes) 100% of our studio audience learned something! Today’s presentations were fantastic! We had seven LUW themed contestants! You can learn about ADMIN_MOVE_TABLE, monitoring and tuning static SQL, reclaiming space with db2dart, solving a complex DB2 DPF performance issue, the change event

(Jack Vamvas) Question: Why do some sql queries use a read-only clause? Is there any performance gain by using the read only clause?

(Dave Beulke) The complexity of the systems, databases and applications continues to get worse. Getting a clear understanding of all the existing applications’ processing, dependencies, and workloads only gets more complicated and difficult to understand.

(Kwai Wong) DB2 10.1 provides significant usability, performance, serviceability, and database administration enhancements for database statistics. In this article, learn about the significant performance enhancements to the RUNSTATS facility.

(Michael Sansoterra) IBM i 7.1 and its various incremental releases have introduced many great new features in DB2 for i. Many of the features have been covered in Four Hundred Guru tips. This tip will cover some of the less exciting, yet important features that may have gone unnoticed. Best of all,

(Robert Catterall) For the asterisk at the end of the this blog entry’s title, you could substitute, “If what you think is based on what you’ve likely read or heard about this feature up till now.”

(Ember Crooks) It doesn’t happen as often as it used to, but it is still possible that you might miss installing a custom install component when you install DB2 and need to go back and install it later. I recently had to do this with the APPLICATION_DEVELOPMENT_TOOLS feature, and thought I’d share t

(David Shute) Learn different methods to secure a JSON payload transmitted in a REST-based architecture. These methods preserve the privacy of the payload regardless of the transport protocol. You will also learn how to encrypt both the entire payload or only select elements.