PI67689: ISSUES WITH THE DB2 CMD DISPLAY ACCELERATOR(ID) DETAIL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• issues with the DB2 CMD DISPLAY ACCELERATOR(id) DETAIL
  
  -DIS ACCEL(AC*) DETAIL => returns the details only for the 1st
  accelerator
  
  -DIS ACCEL(ACC1, ACC2) DETAIL => returns the details only
  for the 1st accelerator in the list
  
  -DIS ACCEL(ACC1,ACC2,ACC3) DETAIL => run into a loop in
  DSNX8CDA +304C 07/01/15 UI29040
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 users who use IBM DB2 Analytics              *
  *                 Accelerator and run DIS ACCEL DET command.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 command -DIS ACCEL DET gives wrong  *
  *                      output or gets into looping condition   *
  *                      when there is more than one accelerator *
  *                      involved. Here are some examples of     *
  *                      -DIS ACCEL DET commands that can        *
  *                      produce wrong result or looping         *
  *                      condition :                             *
  *                      -DIS ACCEL(AC*) DETAIL                  *
  *                      -DIS ACCEL(ACC1, ACC2) DETAIL           *
  *                      -DIS ACCEL(ACC1,ACC2,ACC3) DETAIL       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Wrong output or looping for DIS ACCEL DET command might occur
  when there are more than one accelerators, examples:
  -DB2ADIS ACCEL(AC*) DETAIL
   details for 1ST accelerator only
  -DB2ADIS ACCEL(ACC1, ACC2) DETAIL
   details for 1ST accelerator only
  -DB2ADIS ACCEL(ACC1,ACC2,ACC3) DETAIL
   looping in dsnx8cda
  It is because the accelrator list was handled incorrectly when
  there is more than one accelerators.
  

Problem conclusion

• DB2 is fixed to handle -DB2 ACCEL DET command correctly when
  there is more than one accelerator involved in the accelerator
  list. There is no more missing accelerator detail information
  or looping condition.
  Additional keywords: IDAAV4R1/K IDAAV5R1/K
  

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:

  UI42237 UI42238

Modules/Macros

• DSNX8CDA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI42237

     UP16/11/17 P F611

• RB10 PSY UI42238

     UP16/11/17 P F611

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.