A fix is available
APAR status
Closed as program error.
Error description
SQLCODE204 on DLC.SLOG table can occur when using shadow repository. When a user sets the following in their Exception profile: * Display Statistics Reports and/or Perform Statistics Maintenance? Y * and option 10(SLOG), is selected, the following message can be issued FEC801E Pgm: HAA#ESTI Stmt: 01549 Type: OPEN DSNT408I SQLCODE = -204, ERROR: DLC.SLOG IS AN UNDEFINED NAME
Local fix
Create the repository tables with the default creator of DLC.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Automation Tool. * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE204 on DLC.SLOG table can occur * * when using shadow repository. * * When a user sets the following in their * * Exception profile: * * * Display Statistics Reports and/or * * Perform Statistics Maintenance? Y * * * and option 10(SLOG), is selected, * * the following message can be issued: * * FEC801E Pgm: HAA#ESTI Stmt: 01549 * * Type: OPEN * * DSNT408I SQLCODE = -204, * * ERROR: DLC.SLOG IS AN UNDEFINED NAME * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK48302
Reported component name
DB2 AUTOMATION
Reported component ID
5697G6300
Reported release
220
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-07-03
Closed date
2007-09-26
Last modified date
2007-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK29625
Modules/Macros
HAA$OPRU HAA#ESTI
Fix information
Fixed component name
DB2 AUTOMATION
Fixed component ID
5697G6300
Applicable component levels
R220 PSY UK29625
UP07/09/28 P F709
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUWB","label":"IBM Db2 Automation Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"220","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"220","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 October 2007