PH65327: LISTDSI FAILS WITH REASON CODE 0019 DUE TO MULTI-VOLUME DATASET IN SQL PA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQL PA creates a multi-volume dataset (ANLEEE.SQL), which causes
  an error when executing the LISTDSI command:
  
  TSO/E statement LISTDSI 'hlq.ANLEEE.SQL' failed. Reason code =
  0019
  
  * Correct the data set and restart SQL PA.
  
  Steps to Reproduce:
  
  Make sure that multivolume is disabled in TSO
  
  Open SQL PA and navigate to:
  
  
  1 Basic DB2 SQL PA Processing
  
  1 Process packages from the DB2 system catalog
  
  Perform an explain on a package.
  
  Exit SQL PA.
  
  Re-enter SQL PA
  
  Observe the error message.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 SQL Performance Analyzer        *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Disabling allocation of multi-volume SQL PA report datasets.
  

Problem conclusion

• Multi-volume reports datasets were disabled.
  

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:

  UO02501 UO02502

Modules/Macros

• ANLCFILE ANLCIGO  ANLICRE8 ANLPADMN ANLPAOPT ANLPBTCH
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UO02502

     UP25/03/26 P F503

• R520 PSY UO02501

     UP25/03/26 P F503

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.