PI67088: IMPROVEMENTS FOR CREATING PHYSICAL AND VIRTUAL INDEXES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When creating a physical or virtual index, a list of all columns
  for the chosen table are displayed.  As many index columns as
  DB2 will allow can be selected for the creation of the index.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of SQLPA v510 who create indexes.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Maximum columns for a new index is five *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Maximum columns for a new index is five.
  

Problem conclusion

• Apply the PTF to be able to create indexes with more than five
  columns.
  

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:

  UI42960

Modules/Macros

•    ANLBATCH ANLBNDGR ANLCFILE ANLCHECK ANLCKTBL
  ANLCNUX  ANLDPRM  ANLEEE   ANLGPRM  ANLGPST  ANLH08   ANLH09
  ANLJCRE8 ANLMAIN  ANLNUXD  ANLPHA10 ANLPICP  ANLPIDD  ANLPIQLR
  ANLPITP  ANLPNOTB ANLPNUXR ANLPNUXV ANLPNUX1 ANLPNUX2 ANLPRCR
  ANLPRER  ANLPTCM  ANLPTLD  ANLPTRP  ANLPTSM  ANLQMF   ANLSQLPA
  ANLTSO   ANLWIF   ANLWIFF  ANL07    ANL09    ANL12    H1D0510J
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI42960

     UP16/12/06 P F612

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.