A fix is available
APAR status
Closed as new function.
Error description
DB2 Automation Tool R220 to provide DB2 V9 exploitation support as follows: . 1. NOT LOGGED Table space Support The SCOPE parameter has been added to the COPY utility option panel AA$UTSC and HAA$VTSC. The valid values for this option are ALL and PENDING. ALL is the default. . 2. Online Rebuild Index The options for the online REBUILD INDEX have been added to the REBUILD INDEX functionality under the RECOVER utility screens. The option to specify an online REBUILD INDEX appears on the revised Recover Utility Profile Options screen. . 3. Histogram Statistics Enhance the RUNSTATS utility to gather statistics based on histograms, populate the DB2 catalog tables, and allow the binder to utilize those statistics in choosing access paths. Histogram Statistics is a way of summarizing data distribution on an interval scale (either discrete or continuous). It divides up the range of possible values in a dataset into quantiles, for which a set of statistics parameters are collected. . 4. Clone table A new option "Process Cloned Tables" has been added to panels HAA$OTL9 and HAA$OIL9. If "Y" is selected, the object profile will act only on cloned objects. . 5. Outage Analysis Items Enhance the RECOVER utility to use past generation image copies without going through fallback processing first. . 6. Online REORG Various changes to the Online REORG utility. . 7. LOB REORG With this enhancement, LOBs will be extracted from the existing LOB table space and inserted into a new shadow data set. Once this process is complete, DB2 will switch to use the shadow data set as the new LOB table space and normal access will resume. This is consistent with the REORG process that occurs on non-LOB spaces. . 8. Utility Template Switching If the build options specify to generate templates, the template switching keyword will be added. If build options specify not to generate templates, DB2 Automation Tool will generate the DDs as it currently does. . 9. MODIFY RECOVERY Various changes to the MODIFY function dealing with the RECOVERY aspect. . 10. Partition By Growth This organization allows DB2 to support large tables (up to 128 TB) without requiring the presence of a partitioning key. . 11. Volume Based Utility This line item takes advantage of new features provided by the z/OS Version 1 Release 8 DFSMShsm services. The BACKUP SYSTEM utility and the RESTORE SYSTEM UTILITY will be extended to allow for the management and the restoration of dumps on tape volumes of the system-level backups. TheRECOVER utility will be enhanced to have the ability to use a system-level backup on disk or a system-level backup that has been dumped to tape as the recovery base for a single object or a list of objects. . 12. V9 Disaster Recovery Support New catalog tablespaces and indexes have been introduced to DB2 V9. These new objects must be considered for recovery purposes. Changes as directed in the DB2 V9 Utilities Guide and Reference will be implemented. 13. XML Support A new XML column type has been added in DB2 V9. Like LOB columns, XML columns have their own associated table space, separate from the base table space. 14. Collect All RUNSTATS Statistics for an Exception Profile With this enhancement option selected, RUNSTATS parameters will be created to collect statistics for tablespaces and indexes, and associated table/column statistics as well, i.e., all RUNSTATS statistics, for objects in the objects profiles. 15. New REAL TIME STATS TABLES DB2 V9 creates new real-time statistics tables in the DB2 catalog (SYSIBM.SYSTABLESPACESTATS and SYSIBM.SYSINDEXSPACESTATS). DB2 Automation Tool's exception processing accesses these new tables if running under a DB2 V9 subsystem rather than the user-defined TABLESPACESTATS and INDEXSPACESTATS tables. 16. TOLOGPOINT keyword could be duplicated in error When the object profile contains multiple tablespaces, the resultingJCL could contain multiple TOLOGPOINT keywords, causing a JCL error.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Automation Tool. * **************************************************************** * PROBLEM DESCRIPTION: DB2 Automation Tool R220 to provide DB2 * * V9 exploitation support as follows: * * 1. NOT LOGGED Table space Support The * * SCOPE parameter has been added to the * * COPY utility option panel AA$UTSC and * * HAA$VTSC. The valid values for this * * option are ALL and PENDING. ALL is the * * default. * * 2. Online Rebuild Index The * * options for the online REBUILD INDEX * * have been added to the REBUILD INDEX * * functionality under the RECOVER utility * * screens. The option to specify an * * online REBUILD INDEX appears on the * * revised Recover Utility Profile Options * * screen. * * 3. Histogram Statistics Enhance the * * RUNSTATS utility to gather statistics * * based on histograms, populate the DB2 * * catalog tables, and allow the binder to * * utilize those statistics in choosing * * access paths. Histogram Statistics is * * a way of summarizing data distribution * * on an interval scale (either discrete * * or continuous). It divides up the range * * of possible values in a dataset into * * quantiles, for which a set of * * statistics parameters are collected. * * 4. Clone table A new option "Process * * Cloned Tables" has been added to panels * * HAA$OTL9 and HAA$OIL9. If "Y" is * * selected, the object profile will act * * only on cloned objects. * * 5. Outage Analysis Items Enhance the * * RECOVER utility to use past generation * * image copies without going through * * fallback processing first. * * 6. Online REORG Various changes to the * * Online REORG utility. * * 7. LOB REORG With this enhancement, * * LOBs will be extracted from the * * existing LOB table space and inserted * * into a new shadow data set. Once this * * process is complete, DB2 will switch to * * use the shadow data set as the new LOB * * table space and normal access will * * resume. This is consistent with the * * REORG process that occurs on non-LOB * * spaces. * * 8. Utility Template Switching * * If the build options specify to * * generate templates, the template * * switching keyword will be added. If * * build options specify not to generate * * templates, DB2 Automation Tool will * * generate the DDs as it currently does. * * 9. MODIFY RECOVERY Various changes to * * the MODIFY function dealing with the * * RECOVERY aspect. * * 10. Partition By Growth This * * organization allows DB2 to support * * large tables (up to 128 TB) without * * requiring the presence of a * * partitioning key. * * 11. Volume Based Utility This line item * * takes advantage of new features * * provided by the z/OS Version 1 Release * * 8 DFSMShsm services. The BACKUP SYSTEM * * utility and the RESTORE SYSTEM UTILITY * * will be extended to allow for the * * management and the restoration of dumps * * on tape volumes of the system-level * * backups. TheRECOVER utility will be * * enhanced to have the ability to use a * * system-level backup on disk or a * * system-level backup that has been * * dumped to tape as the recovery base for * * a single object or a list of objects. * * 12. V9 Disaster Recovery Support New * * catalog tablespaces and indexes have * * been introduced to DB2 V9. These new * * objects must be considered for recovery * * purposes. Changes as directed in the * * DB2 V9 Utilities Guide and Reference * * will be implemented. * * 13. XML Support A new XML column type * * has been added in DB2 V9. Like LOB * * columns, XML columns have their own * * associated table space, separate from * * the base table space. * * 14. Collect All RUNSTATS Statistics for * * an Exception Profile With this * * enhancement option selected, RUNSTATS * * parameters will be created to collect * * statistics for tablespaces and indexes, * * and associated table/column statistics * * as well, i.e., all RUNSTATS statistics, * * for objects in the objects profiles. * * 15. New REAL TIME STATS TABLES DB2 V9 * * creates new real-time statistics tables * * in the DB2 catalog * * (SYSIBM.SYSTABLESPACESTATS and * * SYSIBM.SYSINDEXSPACESTATS). DB2 * * Automation Tool's exception processing * * accesses these new tables if running * * under a DB2 V9 subsystem rather than * * the user-defined TABLESPACESTATS and * * INDEXSPACESTATS tables. * * 16. TOLOGPOINT keyword could be * * duplicated in error When the object * * profile contains multiple tablespaces, * * the resultingJCL could contain multiple * * TOLOGPOINT keywords, causing a JCL * * error. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
Temporary fix
Comments
APPLY the PTF.
APAR Information
APAR number
PK40423
Reported component name
DB2 AUTOMATION
Reported component ID
5697G6300
Reported release
220
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-03-01
Closed date
2007-09-12
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:
Modules/Macros
HAA$ALLC HAA$BCPY HAA$BDSN HAA$BGDG HAA$BMSG HAA$BPRD HAA$BULD HAA$BULJ HAA$BUTA HAA$BUTB HAA$BUTC HAA$BUTE HAA$BUTG HAA$BUTH HAA$BUTI HAA$BUTM HAA$BUTP HAA$BUTQ HAA$BUTR HAA$BUTS HAA$BUTT HAA$BUTU HAA$BUTV HAA$BUTX HAA$BUT2 HAA$CRID HAA$ETRG HAA$EXCP HAA$EXPF HAA$IMPF HAA$JBRK HAA$MAIN HAA$OPRE HAA$OPRI HAA$OPRT HAA$OPRU HAA$PITS HAA$RICC HAA$SCOP HAA$TVOL HAA$UC2C HAA$UDOP HAA$UIOP HAA$UIPC HAA$UMOD HAA$UOPC HAA$UOPE HAA$UOPT HAA$URBO HAA$URCB HAA$URCC HAA$URCE HAA$URCF HAA$URCL HAA$URCV HAA$UREA HAA$UREO HAA$URPR HAA$UTSC HAA$VIOP HAA$VIPC HAA$VOPC HAA$VOPE HAA$VRBO HAA#BCLR HAA#BCTC HAA#BIND HAA#BPRI HAA#DDL HAA#DDLA HAA#DDL5 HAA#DDL8 HAA#EMCS HAA#EMIC HAA#EMID HAA#ERSH HAA#ERSI HAA#IDC1 HAA#JPRI HAA#OBEX HAA#OPRI HAA#REF HAA#SCPY HAA#UPRI HAA#UTED HAA#UTLL HAA#UTOB HAA#UTOP HAA@CCUP HAA@PROF HAA@UREP HAABCHJ HAABTSOC HAAH0275 HAAH0897 HAALISTC HAAMODFC HAAQUIEC HAARBLDC HAARCVRC HAAREPRC HAARUNSJ HAASAMPP HAAV22C HAA34 HAA43 HAA50 HAA502E HAA94 HAA948I HAA949I
Fix information
Fixed component name
DB2 AUTOMATION
Fixed component ID
5697G6300
Applicable component levels
R220 PSY UK29137
UP07/09/20 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:
12 February 2021