A fix is available
APAR status
Closed as new function.
Error description
This APAR adds toleration for DB2 V9. Additionally, DATAWK and SORTWK datasets have been removed for INDEX REORG utility. These datasets are not required for the INDEX REORG utility. In order to avoid SQLCODE -206 ( SQLCODE206 ), please edit and execute sample HAA#DDL5. This DDL alters table OBJECT_V13 to add the column PROCESS_CLONES. We missed putting this in the ++HOLD in PTF UK22381. * SQLCODE180 (-180) importing an obj.profile: - from a system with the DB2 v9 toleration code - to a system that does not have the DB2 v9 toleration code. The DB2 V9 toleration code has a new column, PROCESS_CLONES. This new column was added in the middle of the Object Profile. The problem is that maintenance levels prior to V9 Toleration do not recognize this new layout. The only solution is to update the systems where the import is being performed to the V9 Toleration maintenance. The customer must have the V9 toleration maintenance on the target system if it was present on the source system.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Automation Tool. * **************************************************************** * PROBLEM DESCRIPTION: This APAR adds toleration for DB2 V9. * * Additionally, DATAWK and SORTWK * * datasets have been removed for INDEX * * REORG utility. These datasets are not * * required for the INDEX REORG utility. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
Temporary fix
Comments
APPLY the PTF.
APAR Information
APAR number
PK34100
Reported component name
DB2 AUTOMATION
Reported component ID
5697G6300
Reported release
220
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2006-11-03
Closed date
2007-02-20
Last modified date
2007-07-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
HAA$ABKP HAA$ACES HAA$ADMN HAA$ADM1 HAA$ADM2 HAA$ALLC HAA$APFT HAA$APRD HAA$ARST HAA$ASTK HAA$BCHJ HAA$BCPY HAA$BDSN HAA$BGDG HAA$BJBC HAA$BJBN HAA$BMSD HAA$BMSG HAA$BPRD HAA$BRST HAA$BSAU HAA$BULD HAA$BULJ HAA$BUTA HAA$BUTB HAA$BUTC HAA$BUTD HAA$BUTE HAA$BUTG HAA$BUTH HAA$BUTI HAA$BUTJ HAA$BUTM HAA$BUTP HAA$BUTQ HAA$BUTR HAA$BUTS HAA$BUTT HAA$BUTU HAA$BUTV HAA$BUTX HAA$BUT2 HAA$CALL HAA$CHAR HAA$CRID HAA$CTCM HAA$CVT HAA$DB2V HAA$DLCR HAA$DLOG HAA$DMCF HAA$DMCM HAA$DMID HAA$DMMN HAA$DMMV HAA$DMPS HAA$DMSG HAA$DMVS HAA$DMWR HAA$DSET HAA$DXCA HAA$DXCS HAA$DXDB HAA$DXDE HAA$DXDN HAA$DXDS HAA$DXEG HAA$DXEL HAA$DXEQ HAA$DXES HAA$DXEU HAA$DXEV HAA$DXIS HAA$DXLD HAA$DXLT HAA$DXMN HAA$DXQV HAA$DXSG HAA$DXTS HAA$DXVA HAA$DXVD HAA$DXVL HAA$DXVM HAA$DXVR HAA$DXVV HAA$EDIT HAA$EDTI HAA$EDTT HAA$EDT2 HAA$EPRC HAA$EPRD HAA$EPRU HAA$EPUX HAA$EQRY HAA$ERRS HAA$ERST HAA$ESRM HAA$ESRP HAA$ESTM HAA$ETRG HAA$EXCP HAA94 H25H220J
Fix information
Fixed component name
DB2 AUTOMATION
Fixed component ID
5697G6300
Applicable component levels
R220 PSY UK22381
UP07/03/07 P F703
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:
12 February 2021