PK73949: FIELD SIZES ARE TOO SHORT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Not enough space in the LIBRARY NAME fields on panels
  ANLPPARM and ANLPSYST to contain the dataset name.
  ADDITIONAL SYMPTOMS
  1. ANL2001E Fatal SQL Error encountered during Explain / Catalog
     access.
     DSNT408I SQLCODE = -303, ERROR:  A VALUE CANNOT BE ASSIGNED
     TO OUTPUT HOST VARIABLE NUMBER 10 BECAUSE THE DATA TYPES ARE
     NOT COMPARABLE.
     DSNT418I SQLSTATE   = 42806 SQLSTATE RETURN CODE
  2. On an EXPLAIN of a VIEW the index that is showing as an
     alternate index is not an index for the same table as the
     index that is used.
  3. SQLPA module ANLWIF31 uses the LOGGED ON userid,
     rather than the CURRENT SQLID as set by the user
     in the SQLPA interactive panels, when running the
     CREATE/DROP index feature, leading to SQLCODEn551
     -551 error.
  4) Error message ANL1043E issued when blocksize of DBRM
     member to be explained is greater than 32,000.
   ANL1043E DBRM member 'name' had a read error and cannot be
   processed.
   Return Code =     8 Reason =     0 Info =     8
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of SQLPA.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Not enough space in the LIBRARY NAME    *
  *                      fields on panels ANLPPARM and ANLPSYST  *
  *                      to contain the dataset name.            *
  *                                                              *
  *                      ADDITIONAL SYMPTOMS                     *
  *                      1. ANL2001E Fatal SQL Error encountered *
  *                         during Explain / Catalog access.     *
  *                         DSNT408I SQLCODE = -303, ERROR:      *
  *                         A VALUE CANNOT BE ASSIGNED TO OUTPUT *
  *                         HOST VARIABLE NUMBER 10 BECAUSE THE  *
  *                         DATA TYPES ARE NOT COMPARABLE.       *
  *                         DSNT418I SQLSTATE   = 42806 SQLSTATE *
  *                         RETURN CODE.                         *
  *                      2. On an EXPLAIN of a VIEW the index    *
  *                         that is showing as an alternate      *
  *                         index is not an index for the same   *
  *                         table as the index that is used.     *
  *                      3. SQLPA module ANLWIF31 uses the       *
  *                         LOGGED ON userid, rather than the    *
  *                         CURRENT SQLID as set by the user in  *
  *                         the SQLPA interactive panels, when   *
  *                         running the CREATE/DROP index        *
  *                         feature, leading to SQLCODEn551      *
  *                         -551 error.                          *
  *                      4. Error message ANL1043E issued when   *
  *                         blocksize of DBRM member to be       *
  *                         explained is greater than 32,000.    *
  *                         ANL1043E DBRM member 'name' had a    *
  *                         read error and cannot be processed.  *
  *                         Return Code = 8 Reason = 0 Info = 8  *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * 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:

  UK41674

Modules/Macros

•    ANLCNUX  ANLPGM31 ANLPHB15 ANLPHB16 ANLPORPT
  ANLPPARM ANLPRC3C ANLPRC3R ANLPRE3C ANLPRE3R ANLPSYST ANLQMF31
  ANLWIF31
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R320 PSY UK41674

     UP08/12/10 P F812

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.