IBM Support

PK97669: MISCELLANEOUS FIXES FOR DB2 RECOVERY EXPERT V2.2

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This APAR addresses following problems:
    1) Prevent EMC Snap to online backup volumes when
        performing a System Backup using SNAP Volume.
     2) Instruction #2 has been updated for samplib members
        ARY#IVP, ARY#RBA, ARY#RBAC, ARY#VOLS, ARYBIND8, ARYBIND9,
        ARYV220.
     3) Error messages (ARYS021E, ARYS166E and ARYS167E) -
        Missing volumes may occur when doing a system backup.
     4) Unable to PF3/Cancel out of panel ARY$MVOL using
        Subsystem Analysis and Configuration
     5) Bad recovery plan for XML / LOB spaces with multiple
        related tablespaces when not all spaces were copied at
        same LRSN/RBA.
     6) Message "ARYS324I" doesn't include
        'Tablespace Indexspace dbname.spacename' like it should
        according to user guide.
     7) GUI is listing cloned table under recovered objects
        when only the base table was recovered.
     8) Error message ARYF002E - there is the difference between
        the real text and text from UG.
        This PTF will match text from the users guide.
     9) Invalid character in generated image copy DSN when using
        lowercase ID when logging onto GUI.
    10) ARYDDL8 needs comments updated to include DB2 v9 CM/ENFM.
    11) Add more detailed instructions for arysj001
        configuration job.
    12) DSNT408I SQLCODE = -4700, ERROR recreating object in v8 CM.
    13) ARYCPY1 missing new TS when copying the
        Schema Level Repository.
    14) JCL ERROR can occur if ARY#PARM contains long PDS
        library name.
    15) OWNER card needs to be added to all packages in ARYBND71,
        ARYBND81, and ARYBND91.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 Recovery Expert Users                *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR addresses following problems: *
    *                      1. Prevent EMC Snap to online backup    *
    *                         volumes when performing a System     *
    *                         Backup using SNAP Volume.            *
    *                      2. Instruction #2 has been updated for  *
    *                         samplib members ARY#IVP, ARY#RBA,    *
    *                         ARY#RBAC, ARY#VOLS, ARYBIND8,        *
    *                         ARYBIND9, ARYV220.                   *
    *                      3. Error messages (ARYS021E, ARYS166E   *
    *                         and ARYS167E) - Missing volumes may  *
    *                         occur when doing a system backup.    *
    *                      4. Unable to PF3/Cancel out of panel    *
    *                         ARY$MVOL using Subsystem Analysis    *
    *                         and Configuration                    *
    *                      5. Bad recovery plan for XML / LOB      *
    *                         spaces with multiple related         *
    *                         tablespaces when not all spaces      *
    *                         were copied at same LRSN/RBA.        *
    *                      6. Message "ARYS324I" doesn't include   *
    *                         'Tablespace Indexspace               *
    *                         dbname.spacename' like it should     *
    *                         according to user guide.             *
    *                      7. GUI is listing cloned table under    *
    *                         recovered objects when only the      *
    *                         base table was recovered.            *
    *                      8. Error message ARYF002E - there is    *
    *                         the difference between the real      *
    *                         text and text from UG.               *
    *                         This PTF will match text from the    *
    *                         users guide.                         *
    *                      9. Invalid character in generated       *
    *                         image copy DSN when using            *
    *                         lowercase ID when logging            *
    *                          onto GUI.                           *
    *                      10. ARYDDL8 needs comments updated to   *
    *                          include DB2 v9 CM/ENFM.             *
    *                      11. Add more  detailed instructions     *
    *                          for arysj001 configuration job.     *
    *                      12. DSNT408I SQLCODE = -4700, ERROR     *
    *                          recreating object in v8 CM.13.      *
    *                          ARYCPY1 missing new TS when         *
    *                          copying the Schema Level            *
    *                          Repository.                         *
    *                      14. JCL ERROR can occur if ARY#PARM     *
    *                          contains long PDS library name.     *
    *                      15. OWNER card needs to be added to     *
    *                          all packages in ARYBND71, ARYBND81, *
    *                          and ARYBND91.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Code changes have been made to correct these isues
    

Problem conclusion

  • APPLY PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK97669

  • Reported component name

    DB2 REC EXPERT

  • Reported component ID

    5697H7400

  • Reported release

    220

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-01

  • Closed date

    2009-12-04

  • Last modified date

    2010-01-05

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

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

    UK52602

Modules/Macros

  • ARY$BPRU ARY$BPRV ARY$BSAU ARY$CAF  ARY$MAIN
    ARY$MVOL ARY$POOL ARY$SSID ARY$SSVD ARY$SYSL ARY$VAL  ARY#AL
    
    ***This field was truncated.  To obtain the full apar record, please contact your local support center.***
    

Publications Referenced
SC19254800    

Fix information

  • Fixed component name

    DB2 REC EXPERT

  • Fixed component ID

    5697H7400

Applicable component levels

  • R220 PSY UK52602

       UP09/12/15 P F912

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":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQTW","label":"Db2 Recovery Expert"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.2.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 January 2010