PH67082: This APAR contains enhancements in the DISPLAY BLOCKER command and the BLOCKING_THREADS table function.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR contains enhancements in the -DISPLAY BLOCKERS
  command and the BLOCKING_THREADS table function.
  
  1. Drain locks (SUBTYPE '14', '15' and '16') will be processed
  by the -DISPLAY BLOCKERS command and the BLOCKING_THREADS table
  function.
  
  2. The partition number of partition level claims will be
  available in the PAGENUM_OR_RID column in the BLOCKING_THREADS
  table function and the lines with the "PAGE/RID" header in
  the output of the -DISPLAY BLOCKERS command.
  
  3. When the OBID column refers to an index page set object
  descriptor, the NAME column will be the index space name
  rather than the index name.
  
  4. The product identifier (PRDID) in DBINFO structure was set
  according to Db2 12 values but not to Db2 13 values. With this
  APAR, PRDID in DBINFO is fixed to set according to Db2 13
  values to support future enhancements in the BLOCKING_THREADS
  table function.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Db2 for z/OS users of -DISPLAY BLOCKERS      *
  *                 command, BLOCKING_THREADS table              *
  *                 function and any routines that process       *
  *                 the product identifier (PRDID) in the        *
  *                 DBINFO structure.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR contains enhancements to      *
  *                      the -DISPLAY BLOCKERS command and       *
  *                      the BLOCKING_THREADS table function.    *
  *                                                              *
  *                      The product identifier (PRDID) in       *
  *                      DBINFO structure, which is an input to  *
  *                      any external UDF/stored procedure, was  *
  *                      incorrectly set to Db2 12 values.       *
  ****************************************************************
  This APAR contains enhancements in the -DISPLAY BLOCKERS
  command and the BLOCKING_THREADS table function.
  
  1. The following drain locks will now be reported by the
  -DISPLAY BLOCKERS command and the BLOCKING_THREADS table
  function:
    CS drain lock - subtype '14'
    RR drain lock - subtype '15'
    WR drain lock - subtype '16'
  
  2. The partition number of partition level claims will now be
  reported in the PAGENUM_OR_RID column in the BLOCKING_THREADS
  table function and the lines with the "PAGE/RID" header in
  the output of the -DISPLAY BLOCKERS command.
  
  3. When the OBID column refers to an index page set object
  descriptor, the NAME column will now reflect the index space
  name rather than the index name.
  
  4. When the OBID column refers to an index page set object
  descriptor, the QUALIFIER column returned by the
  BLOCKING_THREADS function will now reflect the database name
  rather than the index schema.
  
  5. The -DISPLAY BLOCKERS command without the DETAIL option will
  now display a new maximum of 8000 locks and claims. The limit
  was previously 5000.
  
  Additionally, the product identifier (PRDID) in DBINFO
  structure, which is an input to any external UDF/stored
  procedure, was set incorrectly to Db2 12 values. With this
  APAR, PRDID in DBINFO is set according to Db2 13 values.
  

Problem conclusion

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:

  UO04364

Modules/Macros

• DSN9SCN2 DSN9SCNA DSNDIFCA DSNDWQAL DSNF9DIR DSNFCDIR DSNFUDIR
  DSNFUDRA DSNTLIDE DSNUGDBL DSNUMSGA DSNWARDS DSNXEFDA DSNXKEX2
  DSNXKEXT DSNXKRP3 DSNXKRPT DSNXOEXH DSNXOOS2 DSNXOSTP DSNXOTIR
  DSNZACMD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO04364

     UP25/08/08 P F508  

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.