A fix is available
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 number
PK78851
Reported component name
DB2 AUTOMATION
Reported component ID
5697G6300
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2009-01-16
Closed date
2009-06-18
Last modified date
2009-07-01
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310"}]
Document Information
Modified date:
30 March 2021