PI66296: SP ADMIN_COMMAND_DB2 DOES NOT DISPLAY INDOUBT THREADS WHEN SPECIFY THE THIRD VARIABLE AS 'THD'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ENV : DB2 for z/os 11.1
  The customer wants to use a Java program to invoke the Stored
  Procedure ADMIN_COMMAND_DB2 to basically show the Indoubt
  threads on a Java distributed Enviroment.  During operation,
  when  DB2_CMD  '-DISPLAY THREAD(*) TYPE(INDOUBT) LIMIT(*)' are
  passed on the first  input variable and PARSE_TYPE  'THD' passed
  on the third input Variable of this SP, he cannot get the
  information of indoubt threads when they indeed exist.
  

Local fix

• Workaround: We can get the indoubt threads when specify the
  third variable as "" in Java
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 users of the DB2-supplied stored procedure   *
  *                 SYSPROC.ADMIN_COMMAND_DB2                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: ADMIN_COMMAND_DB2 does not return the   *
  *                      parsed information about indoubt or     *
  *                      postponed threads that exist in a       *
  *                      DB2 11 for z/OS subsystem.              *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  DB2 11 for z/OS increased the length of URID from CHAR(12)
  to CHAR(20). URID is an RBA of the DB2 recovery log which
  points to the beginning of recovery logging for an indoubt
  or postponed thread. This new URID length resulted in a
  change in the output format of the -DISPLAY THREAD command
  for indoubt and postponed threads. Specifically, this
  header line:
  
    COORDINATOR          STATUS      RESET URID         AUTHID
               <-  15  ->                      <-  9  ->
                 spaces                          spaces
  
  that follows the message "DSNV406I - INDOUBT THREADS -" or
  the message "DSNV431I - POSTPONED ABORT THREADS -"
  is reformatted to:
  
    COORDINATOR          STATUS      RESET URID         AUTHID
               <-  10  ->                      <- 17  ->
                 spaces                          spaces
  
  Since ADMIN_COMMAND_DB2 does not recognize this new header
  format as it scans the -DISPLAY THREAD command output, it
  does not extract any data following this header and
  therefore does not return anything in the result table
  SYSIBM.DB2_THREAD_STATUS.
  

Problem conclusion

• In response, this APAR implements the following changes:
  (1) DB2 11:
      (a) Modifies the stored procedure ADMIN_COMMAND_DB2 to
          handle the new V11 output format of the -DISPLAY
          THREAD command for indoubt and postponed threads.
      (b) Modifies the result table SYSIBM.DB2_THREAD_STATUS,
          which is returned by ADMIN_COMMAND_DB2 and is
          populated with the parsed data from the -DISPLAY
          THREAD command output. The length of the URID
          column in this table is increased from CHAR(12) to
          CHAR(20).
  
  (2) DB2 10:
      In a mixed release data sharing group with DB2 10 and
      DB2 11 members, a user can connect to a DB2 10
      member and call ADMIN_COMMAND_DB2 to issue a -DISPLAY
      THREAD command against a DB2 11 member. In this case,
      ADMIN_COMMAND_DB2 must be able to process the V11
      format of the command output.
  
      The following changes are made in DB2 10 to support a
      mixed release data sharing group with DB2 10 and
      DB2 11 members:
      (a) Modifies the stored procedure ADMIN_COMMAND_DB2 to
          handle the V11 output format of the -DISPLAY
          THREAD command.
      (b) Modifies the result table SYSIBM.DB2_THREAD_STATUS
          and makes it identical to SYSIBM.DB2_THREAD_STATUS
          in DB2 11. That is, the following columns in this
          table are modified as follows:
  
                          FROM           TO
                          ----           --
          URID           CHAR(12)      CHAR(20)
          WORKSTATION    CHAR(18)      VARCHAR(255)
          USERID         CHAR(16)      VARCHAR(128)
          APPLICATION    CHAR(32)      VARCHAR(255)
          ACCOUNTING     CHAR(247)     VARCHAR(255)
  

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:

  UI42893 UI42894 PI84488

Modules/Macros

• DSN@DMCD DSN@DMCW DSN@RIN  DSNADMCA DSNADMCB
  DSNADMCD DSNADMCW DSNTESR  DSNTRIN  HDBAA10J
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI42893

     UP16/12/15 P F612

• RB10 PSY UI42894

     UP16/12/15 P F612

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.