Updates to DB2 Automation Tool, Version 3.1 User's Guide

Product documentation


Abstract

Updates that apply to DB2® Automation Tool for z/OS® Version 3.1 User's Guide (SC19-2456-02)

Content

The most recent update is listed first.




Update 5
Date of change: 1/09/2012
Change description: The following PDF describes the changes:

haa-5859_multipleFREQVALforRUNSTATS.pdf
haa-5859_multipleFREQVALforRUNSTATS.pdf




Update 4
Date of change: 7/27/2011
Topic: "Setting REORG options" (in Chapter 4, Creating utility profiles)
Change description: Support for PARALLEL keyword for REORG TABLESPACE syntax was added. Add the following field description to the Reorg Utility Profile Options panel description:

Parallel
(DB2 Version 9.1 NFM or later; for DB2 Version 9.1 NFM, DB2 APAR PM25525
must be applied.) Type Y to specify that if multiple partitions for an individual table space exist in the LISTDEF list, they will be processed in parallel on a single invocation of the REORG utility. Y is the default. Type N to specify that if multiple partitions for an individual table space exist in the LISTDEF list, they will be processed serially (one at a time) on individual invocations of the REORG utility. Specify PARALLEL NO when insufficient system resources are available to process a large number of partitions in parallel. The keyword will not be generated if LISTDEFs are not specified.



Update 3
Date of change: 7/27/2011
Topic: Multiple
Change description: Several changes were made to support DB10 utility syntax.

1. Topic "Reallocation options" (in Chapter 4, Creating utility profiles)

Add the following to the Reallocation options screen field descriptions:

DROP Pending Changes
(DB2 10 NFM and later only) This option allows DROP PENDING CHANGES syntax in the DB2 ALTER statement. To include this syntax, you must:

1) Specify Y or O in this field.
2) In the job profile, include an exception profile that specifies the PENDING_DEF_CHGS exception condition. Objects that meet this exception criteria will have DROP PENDING CHANGES syntax included on the ALTER statement.

All pending definition changes for the table space are dropped before reallocating the space. This option also drops all pending definition changes for any indexes within the table space. AREOR states for the table space and associated indexes will be retained. If you specify Y, Dataset Manager cannot be used for the reallocation. If you specify N in this field, DROP PENDING CHANGES syntax is not included in the ALTER. If you specify O in this field, only DROP PENDING CHANGES syntax is generated and no other values on the panel are verified and/or required except the Use Dataset Manager to Reallocate field.

2. Topic "Object" (in Chapter 5, Creating exception profiles, under “Statistics types on the Update Exceptions Profile Display”)

Add the following to Table 5. Statistics type: Object:

PENDING_DEF_CHGS: Triggers an object if it has any pending definition changes.

3. Topic "DB2 Display Status" (in Chapter 5, Creating exception profiles, under “Statistics types on the Update Exceptions Profile Display”)

Add the following to Table 14. Statistics type: DB2 Display Status:

STATUS_AREOR: The object is in the advisory REORG-pending status and needs reorganization to apply pending definition changes.


4. Topic " Messages" (in Chapter 16, Troubleshooting)

HAA538E Invalid Combination - You have asked to DROP Pending Changes. However, you have also specified to Use Dataset Manager. DB2 must be used to DROP Pending Changes. One of these fields must be set to No
Explanation: The Use Dataset Manager to Reallocate field was set to Y and the DROP Pending Changes field was set to Y or O.
User response: DB2 must be used to drop pending changes. If you want to drop pending changes for your selected objects, you must set Use Dataset Manager to Reallocate to No. Otherwise, a warning message will be issued when you attempt to build the job.

HAAB540W Reallocate with Dataset Manager turned off when DROPping Pending Changes. DB2 ALTER must be used to DROP Pending Changes
Explanation: Use of Dataset Manager for reallocation was specified in combination with DROP Pending Changes. This combination is not allowed. DB2 ALTER must be used for reallocation when pending changes will be dropped. Reallocation with Dataset Manager was turned off.
User response: None required.

HAAB544W DROP Pending Changes will not be generated because there is no exception profile in the job
Explanation: DROP pending changes was requested for an object in a reallocation utility profile, but an exception profile that specifies the PENDING_DEF_CHGS exception condition was not included in the job profile. The DROP pending changes request is ignored.
User response: If pending changes should be dropped for objects, include an exception profile with the PENDING_DEF_CHGS exception condition in the job profile.




Update 2
Date of change:
7/27/2011
Topic: Multiple
Change description: Several changes were made to support DB10 utility syntax.

1. Topic " Specifying RUNSTATS TABLE column statistics" (in Chapter 3, Creating object profiles)
The RUNSTATS TABLE COLUMN STATISTICS panel was modified to allow an editable column called Include Sample. When you enter Y in this field, the Update Runstats Sample Specification window is displayed. The following fields are on this window:

Sample
Enter the percentage of rows to sample when collecting non-indexed column statistics.

TableSample
(DB2 10 and above) Indicate how statistics are collected on a sample of data pages from the table. Unless the optional REPEATABLE clause is specified, each execution will result in different sample of the table. This option is only valid on non-LOB, single-table table spaces. When AUTO is specified, RUNSTATS determines the sampling rate based on the size of the table. A value in the range of .01 - 100.00 represents a sampling percentage.

Repeatable
(DB2 10 and above) If you want repeated executions of RUNSTATS to return the same sample, enter a positive integer that represents a seed value in determining sampling.


2. Topic "Setting RECOVER options" (in Chapter 4, Creating utility profiles)
The Enforce field was added to the Recover Utility Profile options panel. In addition, the VERIFYSET field was added to the Recover Utility Profile Options panel and removed from the Recover Utility Log Options panel.

Add the following field descriptions to this topic:

Enforce
(DB2 10 and later) Specify whether CHKP and ACHKP pending states are set for a point-in-time recovery when only a subset of the related objects (Base, LOB, XML, and RI) have been recovered to a point in time. Type Y in this field to set CHKP and ACHKP pending states when only a subset of related objects are recovered. Type N in this field to avoid setting CHKP and ACHKP pending states when only a subset of related objects are recovered.

Verifyset
(DB2 10 and later) Specify whether RECOVER is to verify that all related objects required for a point-in-time recovery are included. VERIFYSET will only be generated at build time if the Log RBA/LRSN field is specified. Type Y in this field to verify that all required objects are included. Type N in this field to avoid recovering objects that have changed since the last recovery point.

3. Topic "Recovery to a point in time" (in Chapter 4, Creating utility profiles)
The Verifyset field description was removed from this topic and from the figure.

4. Topics "Recovery using the log " and “Recovery using the RESTOREBEFORE keyword” (in Chapter 4, Creating utility profiles)
Figures were updated to reflect the removal of the Verifyset keyword.


5. Topic "RUNSTATS options" (in Chapter 4, Creating utility profiles)
Add the TableSample and Repeatable fields to the Runstats Options panel, and the following field description:

TableSample
(DB2 10 and later) Specify how statistics on a sample of data pages from the table will be collected. Unless the optional REPEATABLE clause is specified, each execution will result in different sample of table. This option is only valid on non-LOB, single-table table spaces. When AUTO is specified, RUNSTATS determines the sampling rate based on the size of the table. A value in the range of .01 - 100.00 represents a sampling percentage.

Repeatable
(DB2 10 and later) If you want repeated executions of RUNSTATS to return the same sample, enter a positive integer that represents a seed value in determining sampling.


6. Topic " Setting REORG options" (in Chapter 4, Creating utility profiles)
The Rowformat field was added to the Reorg Utility Profile Options panel. Add the following field description:

Rowformat
(DB2 Version 9.1 and later) Specify the output row format of the affected table space or partition. It has no effect on LOB, XML, catalog, directory, and universal table spaces involved in a clone relationship. Specify B for Basic Row Format. Specify R for Reorder Row Format.

7. Topic " Setting REPAIR options" (in Chapter 4, Creating utility profiles)
The following fields were added to the Repair options panel:

No Advisory Reorg Pending
(DB2 10 and later) Specify Y to reset the advisory REORG-pending (AREOR) status of the specified table space or index. This option can only be used if Process is set to S.

No Advisory Reorg Pending*
(DB2 Version 8 and later) Specify Y to reset the advisory REORG-pending (AREOR*) status of the specified table space or index. This option can only be used if Process is set to S.

Rebuild Pending
(DB2 10 and later) Specify Y to set the REBUILD-pending (RBDP) status on the specified index. This option can only used if Process is set to S.

Page Set Rebuild Pending
(DB2 Version 9.1 and later) Specify Y to set the PAGE SET REBUILD-pending (PSRBD) status on the specified index. This option can only used if Process is set to S.

8. Topic " REBIND options" (in Chapter 4, Creating utility profiles)
The following fields were added to the Rebind Utility profile options panel:

Access Path Retain Duplicate
(DB2 10 and later) This option allows you to specify whether you want DB2 to retain an old package copy when access paths of the old copy are identical. This option only applies when PLANMGMT(BASIC) or PLANMGMT(EXTENDED) bind options are in effect. Type Y to retain the old package copy. Type N to discard the old package copy. If this field is blank, the previous value will be used.

Switch
(DB2 10 and later) Using this option restores all previous or original package information in the catalog tables and directory to that of the specified package copy. This allows you to fall back to an older copy of a package in the event of a performance regression. This option cannot be specified with any other rebind option.
P: Switch to Previous package information.
O: Switch to Original package information.

9. Topic " Messages" (in Chapter 16, Troubleshooting)

HAAM534E Switch must be "O"riginal, "P"revious, or Blank(existing value)

Explanation: Switch restores all previous or original package/plan information in the catalog and directory to that of the specified package/plan copy. This option allows fallback to an older copy in the event of a performance regression.
User response: Set this field to P for Previous or O for Original.


HAAM535E: Switch option may not be specified with any other rebind option.
Explanation: The Switch rebind option may not be specified with any other rebind option.
User response: Either remove the Switch option or remove all other rebind options.

HAAM537E Access Path Retain Duplicate only applies when Plan Management is Basic or Extended
Explanation: You specified Access Path Retain Duplicate REBIND option. This is only valid when Plan Management is Basic or Extended.
User response: Either remove the Access Path Retain Duplicate option or change Plan Management to Basic or Extended.

HAA484E Invalid value. Specify AUTO, or a decimal number between 0.01 - 100.00 with a maximum precision of 2
Explanation: An invalid value was entered in the Tablesample field.
User response: Enter "Auto" or a value in range .01 - 100.00.


HAA485I There are no Sample Specifications to view
Explanation: An attempt to view Sample specifications was performed, but no Sample specifications exist.
User response: None required.


HAA486E Sample and Table Sample are mutually exclusive
Explanation: You may not specify both Sample and Table Sample.
User response: Please specify Sample or Table Sample, not both.


HAA487E Repeatable is only valid when Table Sample is specified
Explanation: Repeatable can only be specified if Table Sample is specified.
User response: Either specify a Table Sample value or remove the Repeatable value.


HAA578E Rowformat must be B - BRF or R - RRF
Explanation: An invalid value was entered in the Rowformat field. This field specifies the output row format in the affected table space or partition. Rowformat does not affect LOB, catalog, directory, XML and universal table spaces in a clone relationship.
User response: Change the value to (B)RF or (R)RF.


HAAB386W space_type creator|database space_name partition_number TableSample will not be included for this LOB table space
Explanation: The TABLESAMPLE keyword is not valid for a LOB table space and will not be included for the space listed in the message.
User response: None required.

HAAB387W space_type creator|database space_name partition_number TableSample will not be included for this table space since it contains more than 1 table
Explanation: TableSample was specified for the RUNSTATS utility, but TableSample is not valid for table spaces that contain than one table. The keyword will not be included.
User response: None required.


Update 1
Date of change: March 1, 2011
Topic: Messages
Change description: The following message was added in support of APAR PM33384.

HAA536E Threshold unit type invalid without threshold value
Explanation: A threshold unit type was specified but without specifying a threshold value.
User response: Either clear the unit type or supply a threshold value.

Related information

DB2 Automation Tool

Publication number

SC19-2456-01

Copyright date

1996, 2010

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 Tools for z/OS
DB2 Automation Tool

Software version:

3.1.0

Operating system(s):

z/OS

Reference #:

7019166

Modified date:

2011-03-14

Translate my page

Machine Translation

Content navigation