A fix is available
APAR status
Closed as program error.
Error description
Negative SQLCODE811 on Automation Tool Build. * This APAR will correct a -811 SQL error on a Automation Tool build job. Depending on the DB2 version, the error can occur in modules HAA#ERT8, HAA#ERT9, or HAA#ERTA and on tables SYSIBM.INDEXSPACESTATS or SYSIBM.TABLESPACESTATS (DB2 V8), or SYSIBM.SYSINDEXSPACESTATS or SYSIBM.SYSTABLESPACESTATS (DB2 V9 and DB2 V10).
Local fix
For DB2 V9, if module HAA#ERT9 is at APAR level PM16607, apply the following ZAP to correct the -811 error: //AMASPZAP EXEC PGM=AMASPZAP //SYSLIB DD DISP=SHR,DSN=hlq.SHAALOAD //SYSPRINT DD SYSOUT=* //SYSIN DD * NAME HAA#ERTI HAA#ERT9 VER 1206 9101,A2CB VER 120A A714,0008 REP 120A A7F4,0008 ** Contact support for a work around ZAP for other DB2 versions or a different level of module HAA#ERT9.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Automation Tool. * **************************************************************** * PROBLEM DESCRIPTION: Negative SQLCODE811 on Automation Tool * * Build. * * * * * This APAR will correct a -811 SQL error * * on a Automation Tool build job. * * Depending on the DB2 version, the error * * can occur in modules HAA#ERT8, * * HAA#ERT9, or HAA#ERTA and on tables * * SYSIBM.INDEXSPACESTATS or * * SYSIBM.TABLESPACESTATS (DB2 V8), or * * SYSIBM.SYSINDEXSPACESTATS or * * SYSIBM.SYSTABLESPACESTATS (DB2 V9 * * and DB2 V10). * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM45746
Reported component name
DB2 AUTOMATION
Reported component ID
5697G6300
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-08-15
Closed date
2011-09-01
Last modified date
2011-10-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK71546
Modules/Macros
HAA#ERTA HAA#ERTI HAA#ERT8 HAA#ERT9
Fix information
Fixed component name
DB2 AUTOMATION
Fixed component ID
5697G6300
Applicable component levels
R310 PSY UK71546
UP11/09/08 P F109
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":"3.1.0","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":"3.1.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 October 2011