IBM Traveler
Latest News from IBM
The latest updates about DB2 for z/OS

-
PH58573: CASTOUT ABEND04E 00C20263 DSNB5SPC OFFSET00DDA
This apar has been opened for diagnostic purposes, when Db2 pages are left in the GBP after the object has been converted to -
PH58491: QUERY WITH SELECT DISTINCT AND OPTIMIZE FOR 1 ROW/FETCH FIRST 1 ROW CLAUSE,DB2 MAY FAVOR 'O' ACCESS WHICH CAUSE POOR PERFORMANCE
For query with SELECT DISTINCT and OPTIMIZE FOR 1 ROW / FETCH FIRST 1 ROW clause, Db2 may favor 'O' access on a table -
PH58432: REORG SERVICEABILITY
Reorg serviceability apar to validate records length returned from DFSORT during UNLOAD/RELOAD phase when using ZSORT=YES -
PH58379: CORRECTION OF MINVALUE OF SYSIBM.DSNSEQ_EVENTID SEQUENCE
MINVALUE of SYSIBM.DSNSEQ_EVENTID sequence is incorrectly set to 10000 instead of 1000. SYSIBM.DSNSEQ_EVENTID sequence is used to -
PH58456: NON-ONLINE CHANGEABLE ZPARM CATALOG CAN BE CHANGED BY SET SYSPARM LOAD COMMAND
CUSTOMER ACCIDENTALLY ISSUED SET SYSPARM LOAD COMMAND WITH OTHER Db2 SUBSYSTEM ZPARM LOAD MODULE. -
PH58448: ABEND04E RC00E70005 AT DSNXISB2 P942 DURING INTERNAL BIND FOR ALTER PROCEDURE
ABEND04E RC00E70005 at DSNXISB2 P942 during ALTER PROCEDURE processing. ALTER PROCEDURE was doing an internal BIND of the -
PH58409: UNNECESSARY ENTRY IN SYSPACKDEP FOR INDEX ON EXPRESSION
Catalog Table SYSIBM.SYSPACKDEP is showing a dependency of a package on a unique index that should not be used during -
PH58195: DB2 FOR Z/OS V13 DSN1SMFP UTILITY DOESN'T FORMAT V13 SMF RECORDS
After the migration of Db2 for z/OS to version 13 the Db2 Utility DSN2SMFP doesn't format the V13 SMF Records. -
PH58403: ABEND04E 00C90101 IN DSNISRTW 5064
Running complex query with multiple DISTINCT operators ABEND04E RC00C90101 in DSNISRTW ERQUAL5064 can occur on -
PH58324: MISSING CHECK CONDITION DATAREPEATFACTORF=0 FOR DSN_VIRTUAL_INDEXES.DATAREPEATFACTORF
DSN_VIRTUAL_INDEXES is defined with the following check constraint on the column DATAREPEATFACTORF