PI96808: ALTER COLUMN RUN ON AN IDENTITY COLUMN IN A TABLE WITH VERSIONING CAUSES AN ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ALTER COLUMN run on an identity column in a table with
  versioning causes an error like this:
  CZ61325W SQL Error in Module CKZ06100
  DSNT408I SQLCODE = -20180, ERROR: COLUMN TECHNICAL_KEY IN TABLE
  _TBCREATOR_.TBNAME CAN NOT BE ALTERED AS SPECIFIE
  DSNT418I SQLSTATE = 428FR SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNXIALC SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD = 5 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
  DSNT416I SQLERRD = X'00000005' X'00000000' X'00000000'
  X'FFFFFFFF'
  X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
  CKZ76713E Subtask 01, SQL Error Executing Create Object DDL,
  RC=X'00000058, RS=X'00000000
  where _TBCREATOR_ - table creator and _TBNAME_ - table name.
  This fix eliminates this error.
  

Local fix

• 1) Drop versioning before the cloning:
  ALTER TABLE "TBCREATOR"."TBNAME_BASE"
  DROP VERSIONING;
  COMMIT;
  2) Complete the cloning.
  3) Restore versioning after the cloning:
  ALTER TABLE "TBCREATOR"."TBNAME_BASE"
  ADD VERSIONING
  USE HISTORY TABLE "TBCREATOR"."TBNAME_HISTORY";
  COMMIT;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: ALTER COLUMN run on an identity column  *
  *                      in a table with versioning causes an    *
  *                      error like this:                        *
  *                      CZ61325W SQL Error in Module CKZ06100   *
  *                      DSNT408I SQLCODE = -20180, ERROR:       *
  *                       COLUMN TECHNICAL_KEY IN TABLE          *
  *                       _TBCREATOR_.TBNAME CAN NOT BE ALTERED  *
  *                       AS SPECIFIE                            *
  *                      DSNT418I SQLSTATE = 428FR SQLSTATE      *
  *                       RETURN CODE                            *
  *                      DSNT415I SQLERRP = DSNXIALC SQL         *
  *                       PROCEDURE DETECTING ERROR              *
  *                      DSNT416I SQLERRD = 5 0 0 -1 0 0 SQL     *
  *                       DIAGNOSTIC INFORMATION                 *
  *                      DSNT416I SQLERRD = X'00000005'          *
  *                       X'00000000' X'00000000'  X'FFFFFFFF'   *
  *                       X'00000000' X'00000000' SQL            *
  *                       DIAGNOSTIC INFORMATION                 *
  *                      CKZ76713E Subtask 01, SQL Error         *
  *                       Executing Create Object DDL,           *
  *                       RC=X'00000058, RS=X'00000000           *
  *                      where _TBCREATOR_ - table creator       *
  *                      and _TBNAME_ - table name.              *
  *                      This fix eliminates this error.         *
  ****************************************************************
  * 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:

  UI55393

Modules/Macros

•    CKZBAKS  CKZBAKT  CKZBBKS  CKZBBKT  CKZBTS
  CKZCALNC CKZCAL9C CKZCAQNC CKZCAQ1C CKZCATM  CKZCATMO CKZCCTNC
  CKZCCT9C CKZCDB9C CKZCDPNC CKZCDTNC CKZCDT0C CKZCDT1C CKZCDT9C
  CKZCFNNC CKZCFN0C CKZCFN9C CKZCHECK CKZCIXNC CKZCIX0C CKZCIX2C
  CKZCIX9C CKZCMTNC CKZCMT0C CKZCPKNC CKZCPK0C CKZCPK1C CKZCPK9C
  CKZCPLNC CKZCPL0C CKZCPL1C CKZCPL9C CKZCRL2C CKZCRL9C CKZCRO9C
  CKZCRTNC CKZCSG9C CKZCSNNC CKZCSN9C CKZCSPNC CKZCSP9C CKZCSQNC
  CKZCSQ1C CKZCSQ9C CKZCTBNC CKZCTB0C CKZCTB1C CKZCTB2C CKZCTB9C
  CKZCTRNC CKZCTR0C CKZCTR9C CKZCTSNC CKZCTS0C CKZCTS2C CKZCTS9C
  CKZCVANC CKZCVA1C CKZCVTNC CKZCVT0C CKZCVT9C CKZCXANC CKZCXT9C
  CKZFCEXP CKZFCFTC CKZFGNCL CKZFLOG2 CKZFNORM CKZ00610 CKZ00992
  HCKZ320
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI55393

     UP18/04/25 P F804

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.