IBM Traveler

Latest News from IBM

The latest updates about DB2 for z/OS
DB2 for z/OS

  1. 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

  2. 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

  3. PH58432: REORG SERVICEABILITY

    Reorg serviceability apar to validate records length returned from DFSORT during UNLOAD/RELOAD phase when using ZSORT=YES

  4. 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

  5. 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.

  6. 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

  7. 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

  8. 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.

  9. PH58403: ABEND04E 00C90101 IN DSNISRTW 5064

    Running complex query with multiple DISTINCT operators ABEND04E RC00C90101 in DSNISRTW ERQUAL5064 can occur on

  10. 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