PI20275: BUILD JOB LOOP ON SQL ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After an Automation Tool build job receives error:
  + FEC801E Pgm: HAA#TS10 Stmt: 01079 Type: OPEN
  + DSNT408I SQLCODE = -911, ERROR: THE CURRENT UNIT OF WORK HAS
  + BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON 00C9008E,
  +TYPE OF  RESOURCE  00000304, AND RESOURCE NAME DSNDB06
  +.SYSTSTPT.X'00000C23'.X '10'
  .
  A loop can occur while continuously issuing message:
  + FEC801E Pgm: HAA#TS10 Stmt: 01144 Type: FETCH ROWSET NEXT
  + DSNT408I SQLCODE = -501, ERROR: THE CURSOR IDENTIFIED IN A
  +  FETCH OR CLOSE  STATEMENT IS NOT OPEN
  .
  Additional Symptom:
  Build job looping on -805 SQL error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: After an Automation Tool build job      *
  *                      receives error:                         *
  *                      + FEC801E Pgm: HAA#TS10 Stmt: 01079     *
  *                       Type: OPEN                             *
  *                      + DSNT408I SQLCODE = -911, ERROR: THE   *
  *                       CURRENT UNIT OF WORK HAS               *
  *                      + BEEN ROLLED BACK DUE TO DEADLOCK OR   *
  *                       TIMEOUT. REASON 00C9008E,              *
  *                      +TYPE OF  RESOURCE  00000304, AND       *
  *                       RESOURCE NAME DSNDB06                  *
  *                      +.SYSTSTPT.X'00000C23'.X '10'           *
  *                      A loop can occur while continuously     *
  *                      issuing message:                        *
  *                      + FEC801E Pgm: HAA#TS10 Stmt: 01144     *
  *                       Type: FETCH ROWSET NEXT                *
  *                      + DSNT408I SQLCODE = -501, ERROR: THE   *
  *                       CURSOR IDENTIFIED IN A                 *
  *                      +  FETCH OR CLOSE  STATEMENT IS NOT     *
  *                       OPEN                                   *
  *                      Additional Symptom:                     *
  *                      Build job looping on -805 SQL 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:

  UI20691

Modules/Macros

•    HAA#TS10 HAA#TS8  HAA#TS9
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R410 PSY UI20691

     UP14/08/27 P F408

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.