PH59530: DDL INCORRECTLY SETTING FLAGS FOR NODELT AND NOBEFORE WHEN PSB BUILT WHICH INCLUDES DEDB WITH CHANGE DATA CAPTURE SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• System using CATALOG and MACB, with CATALOG populated by
  Catalog Populate Utility, DDL used to create Program View
  ( PSB ) which includes DEDB PCB with Change Data Capture active
  but NODLET and NOBEFORE were *NOT* specified in original DBD.
  DMBXTNDL and DMBXTNBF flag bits end up getting set incorrectly
  due to error in interpreting Catalog data, and as a result,
  no Type 99 records are produced for deletes using this PSB.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All V15 IMS users of DDL                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * User specifies their DBD definition to get the database      *
  * change capture log record type X'99' recording the DB DLI    *
  * DELETE (DLET) segment activities but never get one in        *
  * operation.                                                   *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * INSTALL CORRECTIVE SERVICE FOR APAR/PTF                      *
  ****************************************************************
  User uses Gen to define DBD, then later uses DDL to alter the
  referencing PSB to get the DLET log X'99' as default. DDL does
  not preserve the user initial default setting to produce the
  DLET log as expected.
  

Problem conclusion

• DFS3DBDG Internal DBDGEN process for DDL caller:
  ensure translating correctly the setting of the data change
  capture options DLET and BEFORE in DBD generation into catalog.
  DLET Y|N and BEFORE Y|N specification is whether to capture the
  DLI delete and replace activities into the data change capture
  log record X'99.
  
  DFS3BB00 and DFS3BB10 runtime block builders for DDL caller:
  ensure the following user specified Exit data options in the DBD
  block are converted correctly to the Exit flags in DMB Exit
  description block:
   FLD is DEDB field information capture.
   INPOS is ISRT call twin data information capture.
   SSPCMD is fastpath subset pointers command codes information
  capture.
  
  IMSDDL/K
  

Temporary fix

• *********
  * HIPER *
  *********
  *********
  * HIPER   *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI95980

Modules/Macros

• DFS3BB10 DFS3BB00 DFS3DBDG
  

Fix information

• Fixed component name

  IMS V15

• Fixed component ID

  5635A0600

Applicable component levels

• R500 PSY UI95980

     UP24/03/08 P F403 ¢

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.