IBM Support

PM49907: NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS. 12/03/09 PTF PEREMOVE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10
    ENHANCEMENTS.
    

Local fix

  • APPLY PTF.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following enhancements are          *
    *                      delivered:                              *
    *                                                              *
    *                      - MIG can now use the DB2 Cross         *
    *                      Loader to load target objects.          *
    *                      - FLASHCOPY is now an available         *
    *                      option on the LOAD utility where        *
    *                      the LOAD utility options are used.      *
    *                      - Control of ENFORCE on LOAD is now     *
    *                      available.                              *
    *                      - A batch interface to Change           *
    *                      Management (CM batch) has been          *
    *                      added.                                  *
    *                      - ALT has been enhanced to run on       *
    *                      sequences, aliases, synonyms and        *
    *                      procedures.                             *
    *                      - ALT panel ADB27CA 'Alter Objects'     *
    *                      now displays information tailored to    *
    *                      each object type in the new Info1 and   *
    *                      Info2 fields.                           *
    *                      - Within ALT, new object names are      *
    *                      propagated to DDL created for other     *
    *                      altered objects that refer to the       *
    *                      renamed object.                         *
    *                      Message ADB200W 'Table or column names  *
    *                      were changed.' is no longer issued to   *
    *                      remind you to edit any related          *
    *                      objects, and the 'CHG Rqd' column is    *
    *                      removed from panel ADB27CA 'Alter       *
    *                      Objects'. Also, the 'E - Edit DDL'      *
    *                      line command is now only valid on       *
    *                      Views.                                  *
    *                      - Utilities panel ADB2US 'Table         *
    *                      Space Utilities' is enhanced with       *
    *                      the ability to select utilities         *
    *                      at one time.                            *
    *                      - For the recovery of a sequence        *
    *                      restart value, an option has been       *
    *                      added called SEQUENCE RESTART VALUE.    *
    *                      - Change the granularity of the         *
    *                      default LOB and XML templates to        *
    *                      include a reference to the table        *
    *                      (&TNAME) in addition to the space       *
    *                      name.  Space name is not enough to      *
    *                      make this data set unique.              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The following enhancements are provided with this APAR:
    
    - MIG can now use the DB2 Cross Loader to load target
      objects. Use 'Unload method' C to generate migrate
      jobs that uses the DB2 Cross Loader to transfer data
      from the source objects to the target objects.
    
    - FLASHCOPY is now an available option on the LOAD
      utility where LOAD utility options are used. FLASHCOPY
      will force the use of templates and will use templates
      specified in the following order:
    
      1- User-defined templates
      2- FLASHCOPY template contained in ADB2UCUS
      3- ZPARM FLASHCOPY template if present
      4- Default template name
    
    - Control of ENFORCE on LOAD is now available. If utility
      options are specified, ENFORCE can now be set to YES
      which will enforce constraints on LOAD. Keep in mind that
      the sequence of LOADs becomes important and you may
      discard rows if tables are loaded out of sequence. If utility
      options are NOT specified, or if they are specified but
      ENFORCE is not entered, ENFORCE NO will be the default
      used everywhere but in stand-alone LOAD such as the UT
      'Utility selections' option.
    
    - A batch interface to Change Management (CM batch) has been
      added.  This allows a change to be imported, analyzed, run,
      and recovered without using the CM panels.
    
      In chapter 20 'Managing changes to DB2 objects', a new
      section titled 'Making changes using Change Management
      batch interface' has been added to describe this new
      CM batch interface.
    
      In chapter 2 'Activating DB2 Admin', the 'Step 3. Set up to
      use Change Management' section has been updated to
      describe the set up for CM batch.
    
    - ALT has been enhanced to run on sequences, aliases,
      synonyms and procedures. The ALT line command is now
      allowed for these objects so that users can redefine them.
    
    - ALT panel ADB27CA 'Alter Objects' now displays information
      tailored to each object type in the new Info1 and Info2
      fields. For example, for an index the schema and name of the
      associated table or view is shown. For a stored procedure,
      the version, if any, is shown. For a foreign key constraint,
      the dependent table schema and name are shown.
    
    - Within ALT, new object names are propagated to DDL created
      for other altered objects that refer to the renamed object.
      For example: within an ALT session, if you change a table
      name and one of its column names, then alter an index on that
      table that refers to the renamed column, you do not need to
      further alter the index with the new table and column names.
      In related changes:
    
      Message ADB200W 'Table or column names were changed.' is no
      longer issued to remind you to edit any related objects, and
      the 'CHG Rqd' column is removed from panel ADB27CA.  Also,
      the 'E - Edit DDL' line command is now only valid on Views.
    
    - Utilities panel ADB2US is enhanced with the ability to select
      multiple utilities at one time. For example, the user may type
      'C O R' in the primary command line and the job that is built
      will have steps for COPY, REORG, and RUNSTATS.  In addition,
      a new field is introduced to panel ADB2US 'Table Space
      Utilities', which allows the user to define a list of
      utilities that they can process simply by typing 'SM' on the
      primary command line.  The value of the standard maintenance
      field is saved in the user profile and is preserved across
      logons.
    
    - For the recovery of a sequence restart value,  an option has
      been added to the panel ADBP7P 'ALTER Analysis Options'
      ( for ALT ) and ADB2C11A 'Generate Analyze Job' ( for CM )
      called SEQUENCE RESTART VALUE which will allow a user two
      choices, 'O' for Original and 'C' for Computed.  Original
      will recover the RESTART value for a sequence back to its
      original value and Computed will use the DB2 catalog values
      to set RESTART to the next sequence value not cached.  A
      new column in the ADBCHG table called SEQSVLR will be used
      to hold this option's value.
    
    - The default values to the ADBLOBO and ADBXMLO data set
      names in the ADB2UCUS dataset are shipped in SAMP(ADB2UCU7).
    

Problem conclusion

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

  • Enhancements have been delivered.
    

APAR Information

  • APAR number

    PM49907

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-10-12

  • Closed date

    2012-03-10

  • Last modified date

    2012-04-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK76851

Modules/Macros

  •    ADBALOC  ADBALT   ADBA1TC  ADBA1TG  ADBA1TH
    ADBA1TM  ADBA1TP  ADBA1TV  ADBA1TX  ADBBIND  ADBBND02 ADBCCM
    ADBCCMM  ADBCDTS  ADBCDTW  ADBCDTWA ADBCDTWF ADBCHANG ADBCHG04
    ADBCIMU  ADBCIMV  ADBCP    ADBCPRE  ADBCRCC  ADBCRCP  ADBCSRV
    ADBCVC   ADBCVCP  ADBCVCT  ADBCVEX  ADBCVEY  ADBCVIC  ADBCVOB
    ADBCVOC  ADBCVSE  ADBCX10  ADBC08   ADBEALT  ADBEAPI0 ADBECJCL
    ADBEDIAG ADBEMSPI ADBEUSZC ADBE6CF  ADBE6CFU ADBE7JA0 ADBE7LA0
    ADBE7OA0 ADBE7QA0 ADBE7YA0 ADBGAJOB ADBGLUE  ADBHALT  ADBHC11A
    ADBHUS   ADBHUT   ADBHUTC  ADBHUTLC ADBH1DA  ADBH1SAR ADBH1XAR
    ADBH5LEA ADBH6CFV ADBH7AD  ADBH7C   ADBH7CA  ADBH7CON ADBH7C2
    ADBH7J   ADBH7L   ADBH7O   ADBH7P   ADBH7Q   ADBH7Y   ADBH8M
    ADBLOAD  ADBNSPB  ADBPALT  ADBPAXM  ADBPUTLC ADBP7AD  ADBP7CON
    ADBP7J   ADBP7L   ADBP7LA0 ADBP7O   ADBP7OA0 ADBP7P   ADBP7Q
    ADBP7QA0 ADBP7Y   ADBP7YA0 ADBSALT  ADBSCJCL ADBTCHK  ADBTCL
    ADBTEPA  ADBTEPR  ADBTEP2  ADBTREL  ADBTREO  ADBTUNL  ADBU00
    ADB0001  ADB1000  ADB2A2WS ADB2CC   ADB2CCJ  ADB2CCL  ADB2CCU
    ADB2CEX1 ADB2CID  ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT
    ADB2CVC  ADB2C11A ADB2GEN  ADB2GEN2 ADB2LCC  ADB2MSK  ADB2PA
    ADB2PA3  ADB2PA5  ADB2PA6  ADB2RE   ADB2REE  ADB2REG  ADB2REH
    ADB2REM  ADB2REP  ADB2RER  ADB2RES  ADB2RET  ADB2REU  ADB2REY
    ADB2REZ  ADB2U    ADB2UCU7 ADB2UJOB ADB2UOPS ADB2US   ADB2USC
    ADB2USM  ADB2USO  ADB2USU  ADB2USV  ADB2UT   ADB2UTC  ADB2UTCO
    ADB2UTIL ADB2UTLC ADB2UTLX ADB2UTZ  ADB2UXB  ADB2WCL  ADB2WCM
    ADB2WVL  ADB2W1   ADB2W1S  ADB2ZPV  ADB2000  ADB21A   ADB21DA
    ADB21G   ADB21O   ADB21Q   ADB21S   ADB21SAR ADB21T   ADB21TAF
    ADB21VV  ADB21XAS ADB21Y   ADB25    ADB25LD  ADB25LE  ADB25LEA
    ADB25LEZ ADB25TL1 ADB25TL3 ADB26CJ  ADB26CJU ADB26CJV ADB26CL
    ADB26CO  ADB26COQ ADB26COU ADB26COW ADB26CRT ADB26CT  ADB26CTF
    ADB26CTU ADB27AC  ADB27C   ADB27CA  ADB27CAA ADB27CMR ADB27CR
    ADB27C0  ADB28CL  ADB28CR  ADB28DEL ADB28HPL ADB28HPM ADB28LT
    ADB28M   ADB28MC  ADB28MCT ADB28M2  ADB28RL1 ADB28S   ADB28SE
    ADB28T   ADB28XF  ADB34    ADB35    ADB47    ADB5000  ADB53
    ADB6000  ADB78    ADB9000  H0IHA10J
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK76851

       UP12/03/15 P F203

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.



Document information

More support for: DB2 Tools for z/OS
DB2 Administration Tool

Software version: 10.1.0

Reference #: PM49907

Modified date: 03 April 2012


Translate this page: