IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 number

    PI66296

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-24

  • Closed date

    2016-11-22

  • Last modified date

    2017-07-13

  • 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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
13 July 2017