Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Confession of the Month

One-way street in DB2 9

Confession Supplied by Phil Grainger - Cogito/Grainger Database Solutions  DB2 9 has removed the ability to create new simple table spaces - even though (luckily) the ones we have already in existence will still continue to be supported for the foreseeable future. This does, however, leave DBAs with a tricky problem - and a problem that doesn't really have a satisfactory solution. Once you have migrated to DB2 9 you can no longer create simple tables paces. If you try and execute some DDL perhaps that would have created a si...[more about One-way street]

DB2 pureScale - Insert Load & Replication

Published 21 July 2010 - by Clair Ross

Following on from James Gill’s recent blog post about the Coupling Facility today I’m sharing with you our experiences of working with Insert Load & Replication in DB2 pureScale. In order to test the load capacity of the IBM DB2 pureScale machine we needed some test data and lots of it!  Being somewhat familiar with the capabilities of the CF on z/OS I knew that a few thousand records would not be enough.After some checking about, I decided to “stand on the shoulders of giants” and use the EMPLOYEE table fr...[more about DB2 pureScale]

Upcoming Articles

Best Practices for DB2 LUW

 
Website designed and built by Accent Design Geeks