PH51495: DDL GENERATION BATCH UTILITY DOESN'T PROPERLY HANDLE DBDCAT(Z*);AND PSBCAT(Z*);

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DDL Generation Batch Utility doesn't properly handle
  DBDCAT(Z*);
  and
  PSBCAT(Z*);
  It creates an incorrect upper range condition for this in
  the SSA:
  
  Resource     AT     Elapsed     CPU    Details
  --------  --------- --------  -------- ------------------
  DFSCD000      869ms    429us     141us GE
  C8C5C1C4  C5D94040  4DD9C8C4  D9E2C5D8 *HEADER  (RHDRSEQ*
  40C7C5C4  C2C44040  404040E9  40404040 * GEDBD     Z    *
  40404050  D9C8C4D9  E2C5D840  D3E3C4C2 *   &RHDRSEQ LTDB*
  C4404040  4040AD40  40404040  40405D   *D             ) *
  
  You can see in the BMC MainView IMS trace output, that the
  upper rangevalue for the DBD name starts with x'AD', which
  is less than EBCDIC "A" (x'C1'). So this GU call (or the
  SQL query triggeringthis GU call) willnever return a
  segment, even if there are DBDs / PSBs starting with "Z"
  in the Catalog.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IMS V15 users using the Universal Drivers attempting to  *
  * generate DDL statements from IMS PSB and DBD sources or from *
  * IMS catalog metadata.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DDL Generation Batch utility has the following problems:     *
  * . When "DBDCAT(Z*);" and "PSBCAT(Z*);" are specified as      *
  * input, the utility makes an incorrect query to the IMS       *
  * catalog so no resource is returned and DDL statements are    *
  * not generated,                                               *
  * . When DBD source with COMPRTN=(TDBKMPX0,DATA) is converted  *
  * to DDL, there is no space to separate the compression        *
  * routine name and the keyword "WITH DATA" in the EDITPROC     *
  * attribute.                                                   *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The driver version number for this APAR is 15149.
  

Problem conclusion

• 1. The utility now issues a correct query to the IMS catalog so
  that resources start with Z in their names are processed and DDL
  statements are generated for them.
  2. In the DDL statements being generated, a space is added
  between the compression routine name and the keyword "WITH DATA"
  in the EDITPROC attribute.
  

Temporary fix

Comments

APAR Information

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

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

  UI91080

Modules/Macros

• DFSUDBJL DFSUTM   DFSUDB   DFSUDBJA DFSUDBLC DFSUDBXA
  

Fix information

• Fixed component name

  IMS V15

• Fixed component ID

  5635A0600

Applicable component levels

• R506 PSY UI91080

     UP23/04/05 P F304

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.