PK90889: CKZ24621E SQL EXEC IMM FAILED, SQLCODE: -4706 SQLSTATE: 530A4 SQLCODE4706

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users running job CKZDSQL may find command DB2SQL gets the
  following error:
  CKZ24631I ALTER PROCEDURE CSPARR.UPDATE_AUDIT1 WLM ENVIRONMENT
  Z91CWLM1
  CKZ24621E SQL EXEC IMM FAILED, SQLCODE: -4706 SQLSTATE: 530A4
  DSNT408I SQLCODE = -4706, ERROR: ALTER PROCEDURE STATEMENT
  CANNOT BE PROCESSED BECAUSE THE OPTIONS
  IN EFFECT (ENVID 23) ARE NOT THE SAME AS THE ONES THAT WERE IN
  EFFECT (ENVID 26) WHEN THE
  PROCEDURE OR VERSION WAS FIRST DEFINED
  DSNT418I SQLSTATE = 530A4 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNXIANR SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD = 35 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
  DSNT416I SQLERRD = X'00000023' X'00000000' X'00000000'
  X'FFFFFFFF' X'00000000' X'00000000'
  SQL DIAGNOSTIC INFORMATION
  where
  xxxx.UPDATE_AUDIT1 is a SQL native stored procedure.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users running job CKZDSQL may find      *
  *                      command DB2SQL gets the following       *
  *                      error:                                  *
  *                      CKZ24631I ALTER PROCEDURE               *
  *                      CSPARR.UPDATE_AUDIT1 WLM ENVIRONMENT    *
  *                      Z91CWLM1                                *
  *                      CKZ24621E SQL EXEC IMM FAILED, SQLCODE: *
  *                      -4706 SQLSTATE: 530A4                   *
  *                      DSNT408I SQLCODE = -4706, ERROR: ALTER  *
  *                      PROCEDURE STATEMENT CANNOT BE PROCESSED *
  *                      BECAUSE THE OPTIONS IN EFFECT (ENVID    *
  *                      23) ARE NOT THE SAME AS THE ONES THAT   *
  *                      WERE IN EFFECT (ENVID 26) WHEN THE      *
  *                      PROCEDURE OR VERSION WAS FIRST DEFINED  *
  *                      DSNT418I SQLSTATE = 530A4 SQLSTATE      *
  *                      RETURN CODE                             *
  *                      DSNT415I SQLERRP = DSNXIANR SQL         *
  *                      PROCEDURE DETECTING ERROR               *
  *                      DSNT416I SQLERRD = 35 0 0 -1 0 0 SQL    *
  *                      DIAGNOSTIC INFORMATION                  *
  *                      DSNT416I SQLERRD = X'00000023'          *
  *                      X'00000000' X'00000000'                 *
  *                      X'FFFFFFFF' X'00000000' X'00000000'     *
  *                      SQL DIAGNOSTIC INFORMATION              *
  *                      where xxxx.UPDATE_AUDIT1 is a SQL       *
  *                      native stored procedure.                *
  ****************************************************************
  * 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:

Modules/Macros

•    CKZ00246
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R210 PSY UK50855

     UP09/10/10 P F910

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.