Jan 30 2010
IC65925: Uninstallation of DB2 does not remove DB2 reserved service/port entries in Windows services file
After uninstalling DB2 via Windows Add/Remove programs or via db2unins, the DB2 reserved service/port entries remain in the
Archive for January, 2010
Jan 29 2010
IC65912: INCORRECT RESULTS DUE TO WRONG TQ OPERATION PRODUCED BY NODONUMBER/DBPARTITIONNUM SCALAR FUNCTION.
A query with nodenumber/dbpartitionnum scalar function might return incorrect results. The query may fail to collect rows
Jan 29 2010
IC65893: INCLUDE FOLDER IN DSDRIVER PACKAGE FOR SUN(AMD/SPARC) 32 ARCHITECTURE MISSING
The include folder, containing the header files necessary for compilation of the Open source Drivers is missing under dsdriver
Jan 28 2010
DB2 9 for z/OS technical information has moved
The technical information and manuals for DB2 9 for z/OS have moved to: http://www.ibm.com/support/docview.wss?rs=64&uid=swg27011656
Jan 27 2010
SQL0289N during a table reorg. DB2 reorg does not use the temporary tablespace specified in USE option of the REORG command.
In a specific scenario, users have received error SQL0289N when performing a reorg on a table. The temporary tablespace name in the error message, as well as in the db2diag.log, was found to be different than the tablespace specified in the USE option of the REORG command. This document explains the reason behind such behavior.
Jan 25 2010
PM05218: ABND04E RC00C90101 DSNIZMOS 5002 ERQUAL5002 DURING BIND WITH UK53070 (V8) / UK53071 (v9) APPLIED 10/01/15 PTF PECHANGE
During abend, DB2 was trying to insert a record into a catalog table SYSIBM.SYSTABAUTH. According to the DDL of SYSTABAUTH,
Jan 23 2010
PM05776: -START DB COMMAND ABEND04E RC00C90110 DSNIGETN ERQUAL5009
-START DB(DTO$DRWY) SPACENAM(JY2) ACCESS(RW) command issued abend4E rc00C90110 DSNIGETN erqual5009.
Jan 23 2010
PM04032: THE ABEND0C4 00000038 AT DSNGEPLC+15CC AND DB2 CRASH BY 00F30801 WHILE A DDL. 09/12/23 PTF PEREMOVE
Dump Title: PDB1,ABND=0C4 PIC38 U=STY2 ,M=(C),C=910.EDM -DSNGEPLC,M=DSNTFRCV,LOC=DSNGEDM DSNGEPLC OFFSET15CC
Jan 23 2010
PK74870: COLLECTION OF COMMIT DIAGNOSTIC INFORMATION.
Collection of COMMIT diagnostic information
Jan 23 2010
PM05644: ABEND0C4 RC04 AT DSNXRSTP OFFSET 7D5E WHEN IFCID 221 TURN ON IFCID221
DUMP TITLE: “DCT2,ABND=0C4-00000004,U=DMA8B1 ,M=(N),C=910.RDS