PK45469: IN SQLPA PANEL ANLOPUT RECEIVE ERROR 9001 & "DS DOES NOT EXIST" INSTEAD OF GENERATING NEW REPORT DS AS ELSEWHERE IN PANELS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IN SQLPA panel ANLOPUT supply a valid dsname for the output
  file, expecting SQLPA to generate a new ds if it does not
  already exist. Instead receive:
  THE DATASET YOU HAVE SELECTED FOR USAGE DOES NOT EXIST.
  CHECK YOUR SPELLING AND REENTER REQUIRED DATASET NAME. DATASET
  NAME NOT FOUND IS: "ds.name".
  The SQL PA error code set by this message is:  9001
  ADDITIONAL SYMPTOMS:
  1) Starting SQLPA R310 dialog panels via ANLSTART CLIST
     may result in various memory related errors such as
     abend878 RC10 if the customer's system LE RUNTIME default
     options do not include ANY, to allow use of storage above
     the 16m line. This apar will provide a SQLPA module version
     of CEEUOPT for the SQLPA main ISPF dialogs.
  2) Sqlcode -199 199 and -104 104 errors.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS OF IBM SQL Performance Analyzer    *
  ****************************************************************
  * PROBLEM DESCRIPTION: IN SQLPA panel ANLOPUT supply a valid   *
  *                      dsname for the outputfile, expecting    *
  *                      SQLPA to generate a new ds if it does   *
  *                      not already exist. Instead receive:     *
  *                      THE DATASET YOUHAVE SELECTED FOR        *
  *                      USAGE DOES NOT EXIST.                   *
  *                      CHECK YOUR SPELLING AND REENTER         *
  *                      REQUIRED DATASET NAME. DATASETNAME NOT  *
  *                      FOUND IS: "ds.name".                    *
  *                      The SQL PA error code set by this       *
  *                      message is:9001                         *
  *                      ADDITIONAL SYMPTOMS:                    *
  *                      1) Starting SQLPA R310 dialog panels    *
  *                         via ANLSTART CLIST may result in     *
  *                         various memory related errors such   *
  *                         as abend878 RC10 if the customer's   *
  *                         system LE RUNTIME default options    *
  *                         do not include ANY,to allow use of   *
  *                         storage above   the 16m line.        *
  *                         This apar will provide a SQLPA       *
  *                         module version   of CEEUOPT          *
  *                         for theSQLPA main ISPF dialogs.      *
  *                      2) Sqlcode-199 199 and -104 104 errors. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changes have been made to address
  these issues. SQLPA module version of
  CEEUOPT for the SQLPA main ISPF
  dialogs is provided.
  

Problem conclusion

• Apply PTF.
  

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:

  UK26088

Modules/Macros

• ANLCAT31 ANLCOBC  ANLCOBR  ANLINIT  ANLPGM31
  ANLPLIC  ANLPLIR  ANLPRC3C ANLPRC3R ANLPRE3C ANLPRE3R ANLQMF31
  ANLSTC3C ANLSTC3R ANLSTE3C ANLSTE3R ANLSTP3C ANLSTP3R ANLWIF31
  H1D0310J
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R310 PSY UK26088

     UP07/06/16 P F706

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.