PK30301: WILDCARDS NOT WORKING.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Wildcards not working for "Collect statistics" using the FINDALL
  on DB2 V7.
  Additional Symptoms:
  1. STEPLIB for the "Apply statistics" fails with unavailable
     dataset.
  2. The JCL ANLSTAT had the wrong BLKSIZE for the OUTSTAT data
  set.
  3. The CLIST ANLCOLL when dynamically building the CONTROL data
     set when using the FINDALL had a typo.  It showed FINDALL SP
     when it should have been FINDALL TS.
  4. The CLIST ANLCOLL and ANLAPPLY was not correctly building the
     dynamic JCL needed. It was always using the same JCL no
     matter what changes were requested through the panels.
  5. DB2 load library dd not being added to the JCL for an
     APPLY.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 SQL Performance Analyzer.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Wildcards not working for "Collect      *
  *                      statistics" using the FINDALL on DB2    *
  *                      V7.                                     *
  *                      Additional Symptoms:                    *
  *                      1. STEPLIB for the "Apply statistics"   *
  *                      fails with unavailable dataset.         *
  *                      2. The JCL ANLSTAT had the wrong        *
  *                      BLKSIZE for the OUTSTAT data set.       *
  *                      3. The CLIST ANLCOLL when dynamically   *
  *                      building the CONTROL data set when      *
  *                      using the FINDALL had a typo.  It       *
  *                      showed FINDALL SP when it should have   *
  *                      been FINDALL TS.                        *
  *                      4. The CLIST ANLCOLL and ANLAPPLY was   *
  *                      not correctly building the dynamic JCL  *
  *                      needed. It was always using the same    *
  *                      JCL no matter what changes were         *
  *                      requested through the panels.           *
  *                      5. DB2 load library dd not being added  *
  *                      to the JCL for an APPLY.                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the 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:

  UK17856

Modules/Macros

• ANLANOTE ANLAPPLY ANLCAT31 ANLCNOTE ANLCOLL
  ANLNOTE  ANLPNOTE ANLSTAT
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R310 PSY UK17856

     UP06/09/14 P F609

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.