Tuesday, January 16, 2007

IBM DB2 for z/OS Technotes

Hi DB2 user,

Here is a set of DB2 for z/OS Technotes available IBM website:

- How to get more extents without a DB2 outage?
http://www.ibm.com/support/docview.wss?uid=swg21051882

- Advantages of using CREATE INDEX with DEFER YES and then REBUILD INDEX?
http://www.ibm.com/support/docview.wss?uid=swg21251608

- What kind of performance enhancement is disabled if the outer join performance enhancement is turned off?
http://www.ibm.com/support/docview.wss?uid=swg21008980

- Empty DBRMLIB member after compiling with Enterprise COBOL using the CoProcessor and DB2 V8
http://www.ibm.com/support/docview.wss?uid=swg21239703

- Access Path Performance Issues
http://www.ibm.com/support/docview.wss?uid=swg21206998

- How can I keep DB2 for z/OS stored procedures address spaces (SPAS) that are managed by Workload Manager (WLM) from taking over the system?
http://www.ibm.com/support/docview.wss?uid=swg21239743

- Using the RELEASE(DEALLOCATE) bind option and one plan
http://www.ibm.com/support/docview.wss?uid=swg21114814

- Nested Stored Procedures
http://www.ibm.com/support/docview.wss?uid=swg21114994


Regards,

DB2usa.