Updates to IBM® DB2® Utilities Enhancement Tool for z/OS® V2.2 User's Guide (SC19-3417-03)

Product documentation


Abstract

Updates that apply to IBM® DB2® Utilities Enhancement Tool for z/OS® V2.2 User's Guide (SC19-3417-03)

Content

The most recent update is listed first.




Update 1
Date of change: September 24, 2014
Change description:
Change description: DB2 UET no longer uses the work database and table space for a dynamically created mapping table. The product now uses an implicit database and table space for the mapping table. This change removes the potential for -911 SQL code on mapping table creation if another job has a lock on the work table space.
Topics:
1. "Worksheets: Gathering parameter values for Tools Customizer"
2. "Started task initialization options"
3. "DISCARDTO keywords"
4. "Automatically creating mapping tables (REORG TABLESPACE utility enhancements)"
5. "Implementing the REORG TABLESPACE utility enhancements"
6. "Viewing system status"
7. "Display System Status panel fields"
8. "Overriding started task initialization options"


Topic: "Worksheets: Gathering parameter values for Tools Customizer"
    In "Required parameters section," revise parameter description to read as follows:

    Work database name
    The name of the database in which you want to store work objects that are created for the extended functionality of the CHECK DATA utility.


Topic: "Started task initialization options"
    Revise option descriptions to read as follows:

    WORK_DATABASE_BUFFERPOOL=“bufferpool_name”
    (Optional) Indicates the name of the buffer pool that you want to use for the work objects that
    are created for the extended functionality of the CHECK DATA utility. The default value is BP0.

    WORK_DATABASE_NAME=“database_name”
    (Required) Indicates the name of the database in which you want to store work objects that
    are created for the extended functionality of the CHECK DATA utility. This database name must be different from the one in which you store the DB2 UET audit and logging tables. When you customized DB2 UET using the Tools Customizer, you specified a work database name for the primary subsystem. The Tools Customizer included that name in the appropriate CREATE DATABASE statement within the A0OBJCAA DDL member that it generated for the primary subsystem and for each additional subsystem that you defined during customization. No default value is provided.

    WORK_DATABASE_STOGROUP=“storage_group_name”
    (Optional) Indicates the unique name of the DB2 STOGROUP that you want to
    use for the work objects that are created for the extended functionality of the CHECK DATA utility. The default value is “SYSDEFLT” (the DB2 default storage group).


Topic: "DISCARDTO keywords"
    Revise option descriptions to read as follows:

    WORK_DATABASE_NAME
    Displays the name of the database in which you store work objects that are created for the extended functionality of the CHECK DATA utility.

    WORK_DATABASE_STOGROUP
    Displays the name of the DB2 STOGROUP that is used for work objects that are created for the extended functionality of the CHECK DATA utility.

    WORK_DATABASE_BUFFERPOOL
    Displays the name of the buffer pool that is used for work objects that are created for the extended functionality of the CHECK DATA utility.


Topic: "Automatically creating mapping tables (REORG TABLESPACE utility enhancements)"
    • Remove references to the WORK_DATABASE_NAME started task initialization option.
    • Revise the description of the enhancement to read as follows:

      This enhancement is implemented through the use of the DSNUTILB intercept. You must create a DSNUTILB intercept policy that specifies the DB2 subsystem or subsystems on which to enable the automatic creation of mapping tables.

      DB2 UET can automatically size and create a mapping table and mapping-table index whenever DSNUTILB invokes the REORG TABLESPACE utility with the SHRLEVEL CHANGE option. DB2 UET inserts the DDL for creating the mapping table and mapping-table index. The DDL directs DB2 to implicitly create a unique database and table space for each concurrent utility job. DB2 UET also inserts the DDL for dropping these objects at the appropriate locations within the input data set that DSNUTILB receives.

Topic: "Implementing the REORG TABLESPACE utility enhancements"
    • Remove references to the WORK_DATABASE_NAME started task initialization option.
    • Revise "Before you begin" to read as follows:

      Ensure that the started task initialization option OVERRIDE_MAPPING_TABLE is set appropriately. To replace any existing MAPPINGTABLE specification that you manually defined for the utility with the MAPPINGTABLE specifications that DB2 UET can generate, set the OVERRIDE_MAPPING_TABLE option to YES.

      Ensure that you have current statistics for the object to be reorganized so that the mapping table is sized appropriately.


Topic: "Viewing system status"
    Revise field names in figure "Display System Status panel" to read as follows:

    Work bufferpool name. . : BP0
    Work database name. . . : ABPGG01T
    Work stogroup name. . . : SYSDEFLT

Topic: "Display System Status panel fields"
    Revise field descriptions to read as follows:

    Work bufferpool name
    Displays the name of the buffer pool that is used for work objects that are created for the extended functionality of the CHECK DATA utility. You specify this value in the started task initialization options member by using the WORK_DATABASE_BUFFERPOOL option.

    Work database name
    Displays the name of the database in which you store work objects that are created for the extended functionality of the CHECK DATA utility. You specify this value in the started task initialization options member by using the WORK_DATABASE_NAME option.

    Work stogroup name
    Displays the name of the DB2 STOGROUP that is used for work objects that are created for the extended functionality of the CHECK DATA utility. You specify this value in the started task initialization options member by using the WORK_DATABASE_STOGROUP option.


Topic: "Overriding started task initialization options"
    Revise field names in figure "Control System panel" to read as follows:

    Work bufferpool name. . : BP0
    Work database name. . . : ABPGG01T
    Work stogroup name. . . : SYSDEFLT

Related information

IBM Knowledge Center

Publication number

SC19-3417-03

Copyright date

2014

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 Tools for z/OS
DB2 Utilities Enhancement Tool

Software version:

2.2.0

Operating system(s):

z/OS

Reference #:

7038584

Modified date:

2014-10-03

Translate my page

Machine Translation

Content navigation