PI97334: OBJECT COMPARE CHANGE MANAGEMENT ANALYZE INVALID PCTFREE FOR UPDATE WITH ZPARM PCTFREE_UPD AUTO SQLCODE -644 / SQLNCODE644

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Where ZPARM PCTFREE_UPD is set to AUTO, and PCTFREE FOR UPDATE
  is not set in the source DDL, COMPARE or Change Management may
  generate a change with ALTER TABLESPACE DDL specifying PCTFREE
  FOR UPDATE  -2.  When this change is imported and another
  analyze is run, the result is DDL generated with PCTFREE FOR
  UPDATE specified at -11111.  If a VALIDATE WSL step is run, the
  results may be:
  DSNT408I SQLCODE = -644, ERROR:  INVALID VALUE SPECIFIED FOR
  KEYWORD OR CLAUSE PCTFREE IN STATEMENT CREATE OR ALTER
                        DSNT418I SQLSTATE   = 42615 SQLSTATE
  RETURN CODE                   DSNT415I SQLERRP    = DSNHSM4A
  SQL PROCEDURE DETECTING ERROR
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 or DB2 Object Comparison Tool for            *
  *                 z/OS who use Change Management               *
  *                 or Object Compare to compare DDL             *
  *                 to the catalog objects created by the        *
  *                 same DDL.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When ZPARM PCTFREE_UPD is               *
  *                      AUTO, and DDL (without PCTFREE          *
  *                      FOR UPDATE specified) is compared       *
  *                      with the catalog objects created by     *
  *                      the same DDL, the generated             *
  *                      PCTFREE FOR UPDATE value is             *
  *                      incorrect.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  With ZPARM-PARAMETER PCTFREE_UPD set to
  AUTO, a compare of DDL (without PCTFREE FOR
  UPDATE specified) with the catalog objects created by
  the same DDL generates a change which includes ALTER
  statements such as the following (for each partition):
  
  ALTER TABLESPACE database-name.tablespace-name
  ALTER PARTITION 1
  ALTER PCTFREE FOR UPDATE -2 ;
  
  When the change is imported and another analyze is run,
  the result is DDL generated with:
  
  ALTER PCTFREE FOR UPDATE -11111
  
  If a VALIDATE WSL step is run, or if the run job is actually
  executed, the result may be SQLCODE -644 / SQLNCODE644:
  
  DSNT408I SQLCODE = -644, ERROR: INVALID VALUE SPECIFIED
  FOR KEYWORD OR CLAUSE PCTFREE IN STATEMENT CREATE OR ALTER
  DSNT418I SQLSTATE = 42615
  SQLSTATE RETURN CODE
  

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:

  UI57121 UI57122

Modules/Macros

•    ADB2CMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI57121

     UP18/07/13 P F807

• RC10 PSY UI57122

     UP18/07/13 P F807

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.