PH07200: DB2 ADMINISTRATION TOOL - INCORRECT COMPARE OF INLINE LENGTH CAUSES SQL -270

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A comparison of a partitioned non-UTS results in adding
  partitions to the table space. When Analyzing the change in CM,
  the Inline length of a few columns is reported and these change
  statements appear in the WSL:
  
   Column A_DATEI
     (A)Inline length changed from 0 to 25
   Column A_RUECKFRAGE
     (A)Inline length changed from 0 to 25
  
  Trying to Run the change results in an SQL -270, ERROR:
  FUNCTION NOT SUPPORTED for
  
  ALTER TABLE BMI00.TBMI025_LIEFERUNGARCHIV
    ALTER COLUMN A_DATEI
      SET INLINE LENGTH 25 ;
  
  The DB2 SQL Error Guide states:
  INLINE LENGTH is not allowed for the LOB column because the
  table space is not a universal table space.
  
  This APAR will correct the typing of the table space and there
  will be no Comparison of the Inline length attribute as a
  result.
  
  SQLCODE -270 / SQLCODEN270
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS who use Change Management to import     *
  *                 and analyze a change or users of Db2 Object  *
  *                 Comparison Tool for z/OS.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Running a change results in an SQLCODE  *
  *                      =-270 / SQLCODEN270.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A comparison of a partitioned non-UTS results in adding
  partitions to the table space. When Analyzing the change,
  the Inline length of a column is reported as changed without
  intention of being changed and these change statements
  appear in the WSL. Running the change results in an
  SQLCODE=-270.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI62304

Modules/Macros

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI62304

     UP19/04/05 P F904

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.