PK13161: ADMIN TOOL COMMANDS TO DISTRIBUTED SUBSYSTEMS GIVES INCONSISTENT RESULTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Display Thread, and other DB2 commands give inconsistent results
  and the wrong DB2 level for the distributed subsystem.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who        *
  *                 connect to a DB2 V8 system  (from any        *
  *                 level)  and  issue  DB2 commands, may        *
  *                 be affected.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The commands  to Distributed  subsystem *
  *                      gave inconsistent results.              *
  *                      .*                                      *
  *                      Stored procedure  ADB2RCP  was   linked *
  *                      with   CAF  (DSNALI).   That   produced *
  *                      unpredictable results  and  abends when *
  *                      the stored procedure was defined on DB2 *
  *                      V8.                                     *
  *                      .*                                      *
  *                      ADB2RCP  has  been relinked  with RRSAF *
  *                      (DSNRLI).  The old copy of the  ADB2RCP *
  *                      needs  to  be deleted first and,  then, *
  *                      the new copy can be introduced.         *
  *                      .*                                      *
  *                      This APAR will change stored  procedure *
  *                      ADB2RCP from   being   a  DB2   managed *
  *                      stored  procedure to   a  WLM   managed *
  *                      stored  procedure.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Display Thread, and other DB2 commands gave inconsistent results
  and the wrong DB2 level for the distributed subsystem.
  

Problem conclusion

• Apply the fix.
  

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:

  UK14857

Modules/Macros

•    ADB2RCP  H0IH710J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK14857

     UP06/06/16 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.