PI56821: STORED PROCEDURE ADB2RE FAILS WHEN SQL_DSNAME SPECIFIES PDS WITH AN 8-CHAR MEMBER NAME OR WHEN SQL_MEMBER OPTION USED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Store Procedure
  ADB2RE fails when in the
  SQL_DSNAME specifies a PDS member name that is 8
  character long.
  Example parameters passed:
  SQL_OUTFLAG="PS",SQL_DSNAME="XXXXXX.XXXX.XXX(XXXXXXXX)";
  In addition:
  The SQL_MEMBER option does not work.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who call Reverse Engineering        *
  *                 stored procedure ADB2RE 'Revoke              *
  *                 Distinct Type Privileges'.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When calling Reverse Engineering        *
  *                      stored procedure ADB2RE, the            *
  *                      following issues are observed:          *
  *                                                              *
  *                      1. When SQL_DSNAME or RPT_DSNAME        *
  *                      specifies a PDS with a member name      *
  *                      of 8 characters, DB2 Admin fails        *
  *                      with return code 8 / RC=8.              *
  *                                                              *
  *                      2. When SQL_MEMBER or RPT_MEMBER is     *
  *                      specified, ADB2RE fails with return     *
  *                      code 8 / RC=8.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When calling Reverse Engineering stored procedure ADB2RE,
  the following issues are observed:
  
  1. When SQL_DSNAME or RPT_DSNAME specifies a PDS with a
  member name of 8 characters, ADB2RE fails with RC=8.
  
  For example, SQL_DSNAME="ABC.DEF.GHI(TEST0001)"
  
  2. When SQL_MEMBER or RPT_MEMBER is specified, ADB2RE fails
  with RC=8.
  
  For example,
  SQL_DSNAME="ABC.DEF.GHI",SQL_MEMBER='TEST01'
  

Problem conclusion

• Problems have been resolved.
  

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:

  UI38780 UI38781

Modules/Macros

•    ADB2CDC  ADB2DEP  ADB2RE   ADB2REE  ADB2REG
  ADB2REH  ADB2REM  ADB2REP  ADB2RER  ADB2RES  ADB2RET  ADB2REU
  ADB2REY  ADB2RS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI38780

     UP16/06/22 P F606

• RB20 PSY UI38781

     UP16/06/22 P F606

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.