PI23319: DENU MEMBER ADBREST DOES NOT MENTION THE REQUIREMENT TO INCLUDE THE SADBLLIB LIBRARY IN THE WLM STEPLIB WHEN USING CC/390

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' install process does not
  document the need for the SADBLLIB library's inclusion in the
  STEPLIB in the Work Load Manager (WLM)-managed stored procedure
  address space for the use by Control Center for OS/390 (CC/390).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and IBM Tools Customizer for        *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Reverse Engineering job template    *
  *                      member ADBREST has been updated with    *
  *                      the following instructions:             *
  *                                                              *
  *                      Instructions:                           *
  *                      To use Reverse Engineering from         *
  *                      additional software products, such      *
  *                      as Control Center for OS/390 (CC/390),  *
  *                      submit this sample job to create the    *
  *                      Reverse Engineering stored procedure    *
  *                      ADB2RE, the required temporary tables,  *
  *                      and BIND PACKAGE for the stored         *
  *                      procedure on the DB2 subsystem that     *
  *                      will use this facility.                 *
  *                                                              *
  *                      You then need to copy load module       *
  *                      members ADB2RE and ADB2LM from the      *
  *                      SADBLLIB load library to one of the     *
  *                      libraries defined as STEPLIB in         *
  *                      the Work Load Manager (WLM)-managed     *
  *                      stored procedure address space.         *
  *                      The ADB2RE stored procedure             *
  *                      dynamically allocates output data       *
  *                      sets, as specified by the CC/390 user.  *
  *                      This requires the stored procedure to   *
  *                      be defined with SECURITY USER.          *
  *                      Procedures with this security parameter *
  *                      cannot run in the non-WLM-managed       *
  *                      stored procedure address space          *
  *                      (ssidSPAS), but must run in a           *
  *                      WLM-managed stored procedure address    *
  *                      space.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The Reverse Engineering job template member ADBREST has been
  updated with the following instructions:
  
  Instructions:
  To use Reverse Engineering from additional software products,
  such as Control Center for OS/390 (CC/390), submit this sample
  job to create the Reverse Engineering stored procedure ADB2RE,
  the required temporary tables, and BIND PACKAGE for the stored
  procedure on the DB2 subsystem that will use this facility.
  
  You then need to copy load module members ADB2RE and ADB2LM
  from the SADBLLIB load library to one of the libraries
  defined as STEPLIB in the Work Load Manager (WLM)-managed
  stored procedure address space.  The ADB2RE stored procedure
  dynamically allocates output data sets, as specified by the
  CC/390 user.  This requires the stored procedure to be defined
  with SECURITY USER.  Procedures with this security parameter
  cannot run in the non-WLM-managed stored procedure address
  space (ssidSPAS), but must run in a WLM-managed stored
  procedure address space.
  

Problem conclusion

• Problem has been resolved.
  
  Changes to the DB2 Object Comparison Tool User's Guide and
  Reference, Version 10, Release 2 can be found here:
  
  http://www-01.ibm.com/support/docview.wss?uid=swg27041313
  
  Changes to the DB2 Object Comparison Tool User's Guide and
  Reference, Version 11, Release 1 can be found here:
  
  http://www-01.ibm.com/support/knowledgecenter/api/content/
  SSAUZ9_11.1.0/com.ibm.db2tools.adb111.doc.ug/topics/
  adbu__activating_rev-eng_102.htm
  

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:

  UI20890 UI20891

Modules/Macros

•    ADBREST
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI20890

     UP14/08/29 P F408

• RB10 PSY UI20891

     UP14/08/29 P F408

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.