Category Archives: Techie Tips

How many DB2 for z/OS Stored Procedure Applications?

As always, the answer to this is “it depends”! However, here are some basic rules of thumb that you may find useful: • Define an application environment specifically for your Java stored procedures. This should have NUMTCB set to a … Continue reading

Share
Posted in DB2, IBM, Information Management, Julian Stuhler, System Z, Techie Tips | Tagged , , , , | Comments Off on How many DB2 for z/OS Stored Procedure Applications?

DB2 for z/OS Plan Stability

One of the major headaches all DB2 users face when upgrading to a new release is the possibility of access path regression. In order to benefit from enhancements to the optimiser, plans and packages need to be rebound under the … Continue reading

Share
Posted in DB2, IBM, Information Management, Julian Stuhler, System Z, Techie Tips | Tagged , , , , , , | Comments Off on DB2 for z/OS Plan Stability

IP Addresses of Database Connections

Ever needed to track down those pesky connections to a database you’re trying to backup? No idea how to work out who is constantly connected to a database via Command Centre? Well, below is a simple guide to finding out … Continue reading

Share
Posted in DB2, Paul Stoker, Techie Tips | Tagged , , | Comments Off on IP Addresses of Database Connections

RESTORE.EXE Updated – 64-bit DB2 Support

As the title says, restore.exe (automated redirected restore with TSM support) has been tested against DB2 UDB V8.2 on Windows 2003 Server 64-bit (64-bit instance) and works. Next port will be to Linux 32-bit. Porting to 64-bit will be problematic … Continue reading

Share
Posted in DB2, IBM, Information Management, James Gill, Linux, Techie Tips, Uncategorized | Tagged , , , , , , | Comments Off on RESTORE.EXE Updated – 64-bit DB2 Support

DB2 9.5 not available for Linux on IA64

For those of you using Linux on the Itanium-64 bit (IA64) platform, note that DB2 9.5 is not available for Linux on IA64. The last supported DB2 version for Linux on IA64 is DB2 9. This is because Linux on … Continue reading

Share
Posted in Techie Tips | Tagged , , , , | Comments Off on DB2 9.5 not available for Linux on IA64