PK28915: CREATE INDEX STATEMENT IS NOT POPULATING THE INDEX.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Truncation problem with variable length clist when creating an
  index causing the index name to not get populated in the CREATE
  statement.
  WHAT-IF not creating index.
  Additional Symptoms:
  1. WHAT-IF not restoring statistics. Message is received
     that statistics are restored but the catalog shows the
     original statistics.
  .
  2) IEF861I FOLLOWING RESERVED DATA SET NAMES UNAVAILABLE TO APLY
    when trying to allocate the SANLSTAT ds from the SQLPA panel
    ANLSTAT.
  3) Invalid syntax when ANLALL is invoked.
     A command entered or contained in a CLIST has invalid syntax.
     Circumvention:
     Edit the ANLALL clist and add /* on line 40 in the begining
     of the line.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 SQL Performance Analyzer.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Truncation problem with variable length *
  *                      clist when creating an index causing    *
  *                      the index name to not get populated in  *
  *                      the CREATE statement. WHAT-IF not       *
  *                      creating index.                         *
  *                      Additional Symptoms:                    *
  *                      1. WHAT-IF not restoring statistics.    *
  *                       Message is received that statistics    *
  *                       are restored but the catalog shows the *
  *                       original statistics.                   *
  *                      2. IEF861I FOLLOWING RESERVED DATA SET  *
  *                       NAMES UNAVAILABLE TO APLY when trying  *
  *                       to allocate the SANLSTAT ds from the   *
  *                       SQLPA panel ANLSTAT.                   *
  *                      3. Invalid syntax when ANLALL is        *
  *                       invoked. A command entered or          *
  *                       contained in a CLIST has invalid       *
  *                       syntax. Circumvention: Edit the ANLALL *
  *                       clist and add slash asterisk on line   *
  *                       40 in the begining of the line.        *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  For V3R1 only:
  1. WHAT-IF not creating index (PMR 19798 and 30122)
  2. WHAT-IF restore table / index  statistics fails (PMR 25339)
  3. Data set <userid>.anl310.sanlstat not being freed after
   member JOBCARD is newly created (PMR 21476)
  

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:

  UK17408

Modules/Macros

• ANLALL   ANLJCL   ANLNEW1  ANLNUX   ANLWIF31
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R310 PSY UK17408

     UP06/08/29 P F608

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.