IC87897: DB2 MAY ABEND IN CREATE PROCEDURE IF THE DATABASE CONFIGURATION AUTO_REVAL SET TO DEFERRED_FORCE

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When the database configuration AUTO_REVAL is set to
  DEFERRED_FORCE, an invalid
  database object can be created but marked with invalid. If the
  compilation of a
  CREATE PROCEDURE statement when AUTO_REVAL=DEFERRED_FORCE
  returns an error, the
  attempt to create the procedure may cause DB2 to abend with the
  following call stack:
  
  sqlriSectInvoke entry [eduid 836 eduname db2agent]
  | sqlriddl entry [eduid 836 eduname db2agent]
  | | sqlri_ddl_common entry [eduid 836 eduname db2agent]
  | | | sqlri_ddl_get_section entry [eduid 836 eduname db2agent]
  | | | | sqlra_get_var data [probe 160]
  | | | | | sqlra_find_var entry [eduid 836 eduname db2agent]
  | | | | | | sqlra_compile_var data [probe 15150]
  | | | | | | | sqlnn_cmpl entry [eduid 836 eduname db2agent]
  | | | | | | | | sqlnp_main_id data [probe 3]
  | | | | | | | | | sqlnq_create_with_error entry [eduid 836
  eduname db2agent]
  | | | | | | | | | | sqlnq_ddl_end_stmt entry [eduid 836 eduname
  db2agent]
  | | | | | | | | | | | sqlnq_fcs::fix_untyped_fcs entry [eduid
  836 eduname db2agent]
  | | | | | | | | | | | | sqloEDUExceptionFilter entry [eduid 836
  eduname db2agent]
  | | | | | | | | | | | | | pdStartFODC entry [eduid 836 eduname
  db2agent]
  
  Local Fix:
  None
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 version 10.0.1.2.                             *
  ****************************************************************
  

Problem conclusion

• Upgrade to DB2 version 10.0.1.2.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IC82720

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• R970 PSN

     UP

• R970 PSY

     UP

• RA10 PSN

     UP

• RA10 PSY

     UP