Author Archives: Julian

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