(Jan Koblenzer) A Quick Tour on using IBM Optim to archive off DB2 z/OS data.

(Vinay) This article gives overview on DB2 system objects and helps DB2 developers to know detail description about each system objects.

(Paolo Bruni, Mike Bracey, Rubina Goolamhussen, Ravikumar Kalyanasundaram and Bart Steegmans) Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data integrity. However, locking is just one of th

(Willie Favero) I just mentioned the REXX exec that assist you getting from private protocol to DRDA. When that job is executed, it is possible that long times may be experienced. APAR PK44544 supplies some optional DB2 catalog indexes to help improve its performance.

(Robert Catterall) With the end of the year in sight, it’s a good time to tie up loose ends, as we say here in the USA. Thus it is that I’ve decided to focus, in this last post to my blog in 2009, on indexes as they pertain to DB2 for z/OS partitioned tables. That subject qualifies as a “loose […]

(Rebecca Bond) If you haven’t used db2audit yet due to concerns about performance or perceptions that the setup options are inflexible, I would encourage you to re-consider enabling it when you make the move to DB2 9.7.

(Paolo Bruni, Mike Bracey, Rubina Goolamhussen, Ravikumar Kalyanasundaram and Bart Steegmans) Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data integrity. However, locking is just one of th

(Willie Favero) You’ve been hearing for a while now about how DB2’s private protocol is going to be deprecated (don’t you just love that word?) in DB2 9 for z/OS with support being removed in a future release. Hopefully, through the use of the REXX tool DSNTP2DP, made available to assist you moving

(Conor O’Mahony) Earlier this month, Oracle issued a press release regarding their latest results for the SAP® Business Intelligence-Data Mart (BI-D) Standard Application Benchmark. In the press release, Oracle claim that the new Oracle Database result surpasses the best IBM DB2 result by more than

(Priya Baliga and Anjali Betawadkar-Norwood) Optimization guidelines are a powerful tool that enable you to influence key execution plan decisions, including table access methods, index selection, join methods, and join orders. In the IBM DB2 Version 9.7 for Linux, UNIX, and Windows release, the opt