PK78851: MESSAGE FEC801E PGM: HAA#ERTI STMT: 01043 TYPE: SET CURRENT SQLID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Message may be incorrectly issued.
  
  FEC801E Pgm: HAA#ERTI Stmt: 01043 Type: SET CURRENT SQLID
  DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME
  Xxxxxxxx.xxxxxxxx.HAA#ERTI.xxxxxxxxxxxxxx
  NOT FOUND IN PLAN xxxxxxxxx. REASON 03
  
  This can occur when using Real Time Statistics exceptions.
  

Local fix

• BIND the HAA#ERTI package into collection #package# as in this
  Example:
  
  BIND PACKAGE (#package#) -
  MEMBER (HAA#ERTI) -
  QUALIFIER (SYSIBM) -
  OWNER (#userid#) -
  ACTION (REPLACE) -
  DYNAMICRULES (RUN) -
  ENCODING (EBCDIC) -
  EXPLAIN (NO) -
  ISOLATION (CS) -
  VALIDATE (RUN)
  
  Where
  #package# is the collection name from the -805 error message
  #owner# is the userid used for the customized Automation Tool
          sample bind job.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Message may be incorrectly issued.      *
  *                      FEC801E Pgm: HAA#ERTI Stmt: 01043       *
  *                       Type: SET CURRENT SQLID                *
  *                      DSNT408I SQLCODE = -805, ERROR: DBRM    *
  *                       OR PACKAGE NAME                        *
  *                       Xxxxxxxx.xxxxxxxx.                     *
  *                       HAA#ERTI.xxxxxxxxxxxxxx NOT FOUND IN   *
  *                      PLAN xxxxxxxxx. REASON 03               *
  *                      This can occur when using Real Time     *
  *                      Statistics exceptions.                  *
  ****************************************************************
  * 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:

  UK47560

Modules/Macros

•    HAA$EXCP HAA#EDAY HAA#ERSH HAA#ERSI HAA#ERSU
  HAA#ERTI HAA#ESCP HAA#ESTI HAA#ETGI HAA@UREP
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK47560

     UP09/06/24 P F906

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.