PM32913: ADDRESS SQL/PA PROBLEMS DYNAMICALLY CREATE PLAN TABLE, OPTION 1.7 PROCESS QMF NOT WORKING, UNABLE TO RUN STORED PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• * Unable to create plan table dynamically when using batch,
  stored procedures, or ANLCSPA if using a database other
    than ANLDBASE or a table space other than ANLSPACE
  
  * Option 1.7 process QMF statement is not working
  
  * Unable to run stored procedure with out ANLUSER0.REGISTRY
  
  * SQL function from ANLPPKGE, ANLPPLAN returns blank row
  
  * TABLES function from ANLPPKGE, ANLPPLAN returns to panel
    with no results
  
  * Modified message wording and corrected typographical errors
  
  * SQL PA not started or hanging when called from Query Monitor
  
  * Invalid blocksize when viewing workfile
  
  * Internal conversion error from character to numeric when using
    ORDER BY QUERYNO
  
  * ANLPTABL showing more tables than selected
  
  * Missing a statement when comparing a package
  
  * Added step to customization for dropping DB2 objects
  
  * Error in ANLCRE8J when customized library does not match the
    installation hlq
  
  * Customization failed to allocate SANLCLST to SYSPROC
  
  *  IKJ56500I COMMAND ANLIQM NOT FOUND
      The PTF will return ANLIQM relationship.
  
     ** The HOLDDATA from the PTF does not mention that to
        make this change effective, you must regenerate
        the customization JOBS, in TCz, and submit the job
        that creates the new CLIST ANLIQM.
  
  * File handling modification in ANLCHECK
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 All users of SQL Performance Analyzer v4.1.  *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      This APAR addresses several issues.     *
  *                      See the APAR text for details.          *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• Apply the PTF for problem resolution.
  

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:

  UK67615

Modules/Macros

• ANL$$SEQ ANLALLOC ANLCAFSP ANLCBTCH ANLCDBRM
  ANLCFILA ANLCFILE ANLCFIND ANLCHECK ANLCIGO  ANLCLODS ANLCRE8D
  ANLCRE8I ANLCRE8J ANLCRE8L ANLCRNE1 ANLCRNS1 ANLCRNS2 ANLCRNT1
  ANLCRNT2 ANLCSPA  ANLDROPD ANLEEE   ANLGOV1  ANLMAIN  ANLPQMF
  ANLPRCC  ANLPRCR  ANLPREC  ANLPRER  ANLQMF   ANLQMFCL ANLQMONC
  ANLSQLPA ANLSTCC  ANLSTCR  ANLSTEC  ANLSTER  ANLSTPC  ANLSTPR
  ANLTSO   ANLWLMSP
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R410 PSY UK67615

     UP11/05/24 P F105

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.