PK10085: ABENDU4038 LOOP DURING VALIDATE OF WSL FOR ALC INSERT COLUMN ON TABLE WITH RI CONSTRAINT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Admin Tool a request to VALIDATE a WSL ( Work Statement
  List ) can fail with abendu4038 loop in adb2wvl exec. WSL was
  built from ALC insert column into a table with RI ( Referential
  Integrity ) constraint.
  .
  Error messages appear similar to:
  .
  User abend 4,038 dec occurred processing command 'DSN     '.
  Validate wsl exec ADB2WVL ended
  FUNCTION = ADB2WVL, LINE 241: Signal error
  
  RC       = 4038
  ...
  Error processing Referential constraint DB06.AZVE2T
    DB06.AZVEIT AZVE2K01 in a DROP statement:
    Object does not exist
  Error processing Referential constraint DB06.AZVE2T
    DB06.AZVEIT AZVE2K01 in a DROP statement:
    Object dropped many times
  Error processing Table DB06.AZVEIT in a CREATE
    statement:Object already exists
  .
  Last 3 error messages repeated many times in joblog.
  .
  Additional symptoms: accept sqlcode206 sqlcoden206
  206
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADministration Tool, who use    *
  *                 WSL  Validation  for Work Statement Lists    *
  *                 that  contain utility control statements,    *
  *                 may be affected.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: A request to VALIDATE a  Work Statement *
  *                      List ( WSL ) can fail with ABEND  U4038 *
  *                      loop  in  ADB2WVL  exec. WSL was  built *
  *                      from  ALC insert  column  into  a table *
  *                      with RI constraint.                     *
  *                      .*                                      *
  *                      Work Statement List Validation may loop *
  *                      when a  statement  in  a Work Statement *
  *                      List member contains a  utility control *
  *                      statement where  the  statement type is *
  *                      blank instead of UTL.                   *
  *                      .*                                      *
  *                      Under  certain conditions, execution of *
  *                      the  WSL  Validate  function can result *
  *                      in an ONCODE 3809 in the order_triggers *
  *                      routine in ADB2REP. (R710 only)         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• The last utility  control  statement  stored  into a Work
  Statement List was sometimes  saved  with  the  statement
  type field set to blanks instead of  UTL.  This  resulted
  in a loop during Work Statement List Validation.
  .*
  It  has  been  fixed  to properly set the statement type
  when rows are added to a Work Statement List member, the
  statement type has been set properly.
  .*
  The Work Statement List Validation has been fixed  to not
  loop when  processing  a  Work Statement List member that
  has a missing statement type.
  .*
  Another problem has been solved: ignoring -206 sqlcode
  .*
  For  R710,  the  ADB2REE  has  been  changed  so that the
  trigger_max variable is initialized to 0.
  

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

•    ADB2A2WS ADB2RE   ADB2REE  ADB2REZ  ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK07436

     UP05/09/27 P F509

• R710 PSY UK07437

     UP05/09/27 P F509

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.