(Judy Fainor) Organizations need to work with production data for test purposes. The amount of data or type of data needed to satisfy test requirements will vary depending on the focus of the test cases. Depending on the requirements of the testing initiatives (that is, performance, boundary conditi

(Susan Butala and Priamo Persichetti) Learn how to configure DB2 V9.7 for SSL on the Windows platform. After configuring DB2 for SSL, you can use DB2 client applications that also support SSL to connect to the DB2 database through the SSL protocol. One such client application example is WebSphere Ap

(Frank Fillmore) Database recovery logs have been around for a long time. They support rolling back transactions that abend – providing a logical unit of work (LUW). The also provide roll-forward recovery so that if a database crashes, a full backup restored can be supplemented by all of the trans

(Michael Sansoterra) In my prior tip, I covered a new feature provided in the i7.1 technology refresh 4 update that allows a INSERT/SELECT statement to insert data into a local DB2 for i table from a query against a remote DB2 database. In this tip, I will cover a method that can be used to query mu

(Kendrick Ren, Yuan Gao, Robert Heath and Cliff Leung) Access-plan changes can happen at any point during the database-application or data-server maintenance lifecycle. It is important for DBAs to handle these changes quickly and effectively. However, most DBAs lack tools to deal with access-plan ch

(Philip) So have you ever seen this error message, and it might be an intermittent fault which makes it an even better problem to try and solve:

(Lockwood Lyon) There are two distinct methods for physically partitioning data. Horizontal partitioning is the most common data partitioning option. With this technique, the database designer physically separates the data into multiple datasets. Each dataset is a partition, and each contains rows w

(Sorin Iszlai) LAN networking devices, like host adapters and Ethernet switches, have evolved over the last few years, making it possible to achieve throughput as high as 40Gbps and network latency below one microsecond.

(Troy Coleman) As Willie Favero notes, a growing number of IBM Redbooks are now available in EPUB format.

(Philip) This time I was asked by our marketing bods to come up with something that made the dates in the SQL that is merged into our marketing and informational emails (glorified mail merge) from a dd/mm/yyyy (13/06/2012) or yyyy-mm-dd (2012-06-13) to a ddth MMM YYYY so becomes 13th June 2012.