UK DB2 User Group Minutes, December 2004

These are the presentations from the December meeting of the UK DB2 User Group, which was held on December 2nd 2004 at IBM South Bank in London.

IBM Announcements	Pav Kumar-Chatterjee, IBM	zipped Powerpoint, 345Kb
A Light in the Dark for the Optimizer - Using DSTATS and V8 RUNSTATS enhancements the intelligent way	Dirk Johann, Software Engineering	zipped Acrobat, 1,244Kb
Book Review - Eaton & Cialini: High Availability Guide for DB2	Tim Carver, ACC Solutions	zipped Powerpoint, 17Kb
Exploiting DB2 for LUW V8 for Real! (Please see slides 101 onwards for the material Phil presented at our meeting)	Phil Nelson, ScotDB Ltd.	zipped Acrobat, 1,851Kb
DB2 II 8.2 Q Replication & Event Publishing - an Elevator Tale	Pav Kumar-Chatterjee, IBM	Zipped Powerpoint, 1,813Kb
Get Ready for V8 - Why to Care for BINDs and REBINDs	Ralf Neumann, Software Engineering	zipped Acrobat, 1,347Kb
What's New in V8 for Application Developers Part 1	Phil Grainger, CA	zipped Powerpoint, 260Kb

Following the meeting, IBM provided these answers to questions which were raised during their Product Announcments session:

When will the Security redbook be published?
The residency for the Security redbook has finished, we do not have a date for publication yet.

Are there any issues with upgrading CICS to TS3.1 w.r.t DB2 V8 - any good/bad points?
There are no external changes to the CICS-DB2 adapter for CICS TS V3.1. These are the required DB2 PTFs that we were aware of at the time of the announcement. Note that there are still a large number of customers at CICS TS V1.3, so as they look to migrate to V3.1, they will be able to exploit the features for DB2 that were introduced in CICS TS V2.2 and V2.3 - namely Open Transaction Environment (OTE) for thread safe programs using DB2, DB2 group attach, and support for DB2 restart light.

DB2 Universal Database(r) Server for OS/390(r) V6.1 (5645-DB2)
For SQLJ/JDBC support, with PTF for APAR PQ84783
Does not support DB2 Group Attach

DB2 Universal Database Server for OS/390 V7.1 (5675-DB2)
For SQLJ/JDBC support, with PTFs for APARs PQ84783 and 86525
For DB2 Group Attach, with APARs PQ44614, PQ45691, and PQ45692

DB2 Universal Database for z/OS, V8.1 (5625-DB2)
For SQLJ/JDBC support, with PTFs for APARs PQ84783 and 86525