A fix is available
APAR status
Closed as program error.
Error description
This APAR contains the following enhancements: 1) TCz DDLX/Y jobs: Add new columns for LOB/XML in OBJECTS_V13 table 2) Specify the processing of XML or LOB on the LISTDEF utility statement for image copies. 3) Add new fields for LOB/XML on panel HAA$OTL9 4) Panels HAA$OPRU and HAA$OPRE (object profile panels) modified to allow XML/LOBs to be exploded 5) FL 505 Support - provide support for new "NONE" keyword for RUNSTATS utility (panel HAA$STSM) 6) Convert Reorg TS to use new dataset definition interface for SYSPUNCH 7) Convert Reorg TS to use dataset definition interface for SYSREC 8) Add support for new XML & LOB columns to IMPORT/EXPORT 9) Improve error message HAAM560E to include the error scenario when SDYXLOAD is not defined in the HAA CLIST even though IBM DB2 Utilities Solution Pack is already purchased and configured. Inform user of possible cause, for example, checking CLIST.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users * **************************************************************** * PROBLEM DESCRIPTION: This APAR contains the following fixes: * * 1. TCz DDLX/Y jobs: Add new columns * * for LOB/XML in OBJECTS_V13 table * * 2. Specify the processing of XML or LOB * * on the LISTDEF utility statement for * * image copies. * * 3. Add new fields for LOB/XML on panel * * HAA$OTL9 * * 4. Panels HAA$OPRU and HAA$OPRE (object * * profile panels) modified to allow * * XML/LOBs to be exploded * * 5. FL 505 Support - provide support for * * new "NONE" keyword for RUNSTATS * * utility (panel HAA$STSM) * * 6. Convert Reorg TS to use new dataset * * definition interface for SYSPUNCH * * 7. Convert Reorg TS to use dataset * * definition interface for SYSREC * * 8. Add support for new XML & LOB * * columns to IMPORT/EXPORT * * 9. Improve error message HAAM560E to * * include the error scenario when * * SDYXLOAD is not defined in the HAA * * CLIST even though IBM DB2 Utilities * * Solution Pack is already purchased * * and configured. Inform user of * * possible cause, for example, * * checking CLIST. * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** .
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH16375
Reported component name
DB2 AUTOMATION
Reported component ID
5697G6300
Reported release
430
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-09-03
Closed date
2019-10-16
Last modified date
2019-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI65918
Modules/Macros
HAA#ACTR HAA#ADMJ HAA#AGEN HAA#AOBP HAA#AOIM HAA#AUTO HAA#AUXR HAA#BCLR HAA#BCTC HAA#BIND HAA#BND HAA#BPRI HAA#BRS HAA#BSQL HAA#BST7 HAA#BST8 HAA#BSTS HAA#BTMP HAA#BULD HAA#CDCL HAA#CL HAA#CL64 HAA#CL7 HAA#CL8 HAA#CPM HAA#CQMP HAA#DB2V HAA#DCMD HAA#DISP HAA#DMAL HAA#DMSQ HAA#DXCI HAA#DXCL HAA#DXCT HAA#DXDB HAA#DXDI HAA#DXDN HAA#DXDS HAA#DXDT HAA#DXES HAA#DXEV HAA#DXI2 HAA#DXIN HAA#DXIS HAA#DXQD HAA#DXQN HAA#DXQS HAA#DXSG HAA#DXSI HAA#DXST HAA#DXSV HAA#DXT2 HAA#DXTS HAA#DXVD HAA#ECDS HAA#ECIC HAA#EDAY HAA#EDSP HAA#EIDA HAA#EMCS HAA#EMIC HAA#EMID HAA#EOTR HAA#EPRI HAA#ERSH HAA#ERSI HAA#ERSU HAA#ERT8 HAA#ERT9 HAA#ERTA HAA#ERTI HAA#ESCP HAA#ESTI HAA#ETGI HAA#EVSP HAA#EXCS HAA#EXUX HAA#HPCD HAA#HPSC HAA#ICP7 HAA#ICP8 HAA#ICPO HAA#ILOB HAA#IOPF HAA#IX HAA#IX10 HAA#IX12 HAA#IX7 HAA#IX8 HAA#IX9 HAA#IXN8 HAA#IXP8 HAA#IXP9 HAA#IXPT HAA#JPRI HAA#LDEP HAA#LOB7 HAA#LOB8 HAA#LOBC HAA#LPIO HAA#LRPT HAA#MAIN HAA#MPRI HAA#NTFB HAA#NTFE HAA#NTFI HAA#NTFJ HAA#NTFM HAA#NTFS HAA#NTFU HAA#OBEX HAA#OPCL HAA#OPRI HAA#OPVD HAA#OUT2 HAA#PDEP HAA#PITC HAA#PITS HAA#PLOG HAA#POST HAA#PRE HAA#PRSE HAA#RALR HAA#RCFS HAA#RH HAA#RH10 HAA#RI HAA#RIO HAA#RIV7 HAA#RIV8 HAA#RIX HAA#RM24 HAA#SCHD HAA#SCPY HAA#SETP HAA#SETR HAA#SKCL HAA#SQL3 HAA#SQLE HAA#SYMR HAA#TABL HAA#TB HAA#TB7 HAA#TB8 HAA#TBPT HAA#TP HAA#TP10 HAA#TS HAA#TS10 HAA#TS12 HAA#TS7 HAA#TS8 HAA#TS9 HAA#TSS HAA#TSSA HAA#UOPC HAA#UPRI HAA#URDT HAA#UTED HAA#UTLL HAA#UTOB HAA#UTOP HAA#VERT HAA#VSAM HAA#XMLC HAA#YARC HAA#YCAL HAA#YCTL HAA#YDEL HAA$ABKP HAA$ACES HAA$ACTR HAA$ADM1 HAA$ADM2 HAA$ADM4 HAA$ADM5 HAA$ADM6 HAA$ADM7 HAA$ADMD HAA$ADMN HAA$ADMS HAA$ADMU HAA$ADMW HAA$ADRV HAA$ADSD HAA$ALLC HAA$ALRG HAA$ALRO HAA$ALRP HAA$ALRT HAA$ANST HAA$AOIM HAA$AOSP HAA$APAR HAA$APFT HAA$APRD HAA$ARST HAA$ASIM HAA$ASMU HAA$ASTK HAA$ATRH HAA$BCHJ HAA$BCPY HAA$BDSN HAA$BGDG HAA$BJBC HAA$BJBN HAA$BMSD HAA$BMSG HAA$BPRD HAA$BRST HAA$BSAU HAA$BSHU HAA$BSUU HAA$BULD HAA$BULJ HAA$BUT2 HAA$BUTA HAA$BUTB HAA$BUTC HAA$BUTD HAA$BUTE HAA$BUTG HAA$BUTH HAA$BUTI HAA$BUTJ HAA$BUTK HAA$BUTL HAA$BUTM HAA$BUTP HAA$BUTQ HAA$BUTR HAA$BUTS HAA$BUTT HAA$BUTU HAA$BUTV HAA$BUTW HAA$BUTX HAA$BUTZ HAA$CALL HAA$CHAR HAA$CQMD HAA$CRID HAA$CTCM HAA$CVT
Fix information
Fixed component name
DB2 AUTOMATION
Fixed component ID
5697G6300
Applicable component levels
R430 PSY UI65918
UP19/10/22 P F910
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":"4.3.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":"4.3.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 November 2019