PM67515: MISCELLANEOUS FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Recovering a partition by growth TS to previous definition of
  segmented, table DDL generates with PARTITION BY SIZE
     parameter which causes the DDL to fail with DSNT408I
     SQLCODE = -763, ERROR: INVALID TABLE SPACE NAME
    tablespacename.
  2. Error message "ARYS118E - Error obtaining HSM backup
     information."  may occur if the Backup Token ends in a FF.
     The Token gets chopped off during HSM reporting when the
     Token ends in FF and then when we parse through the report
     after a backup looking for that particular token we do not
     find it and then issue the ARYS118E error.
  3. Error allocating temp file when running multiple DB2 system
     backup jobs at the same time. This can possibly result in
     error message:
      ARYS173E - Allocate failed for dsn.
  4. Misspelled 'Storage Gorups' in 'Recovery Plan Generation
     Options' window (browser client)
  5. When using LBDR if "Start/End Timestamp" values on ARYGODLS
     panel (Object Definition Levels Selection) have been set to
     an earlier timestamp than earliest available DB2 log
    timestamp, agent can terminate with 'ARYY001S - The agent at
    2001:21:21:55::22 has unexpectedly disconnected.'
  6. Browser client - ability to select multiple rows on the
     messages window to be able to delete those messages in bulk
    rather than one-by-one.
  7. When producing recovery plans for partitioned tablespaces
     which have been image copied using Recovery Experts Fast
    Replication Image copy feature, a S0C4 abend can occur. The
     abend is in module ARYLJGTP.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: User of DB2 Recovery Expert for Z/OS.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Recovering a partition by growth     *
  *                      TS to previous definition of segmented, *
  *                      table DDL generates with PARTITION BY   *
  *                      SIZE parameter which causes the DDL to  *
  *                      fail with DSNT408I SQLCODE = -763,      *
  *                      ERROR: INVALID TABLE SPACE NAME         *
  *                      tablespacename.                         *
  *                      2. Error message "ARYS118E - Error      *
  *                      obtaining HSM backup information."      *
  *                      may occur if the Backup Token ends in   *
  *                      a FF. The Token gets chopped off during *
  *                      HSM reporting when the Token ends in    *
  *                      FF and then when we parse through the   *
  *                      report after a backup looking for that  *
  *                      particular token we do not find it and  *
  *                      then issue the ARYS118E error.          *
  *                      3. Error allocating temp file when      *
  *                      running multiple DB2 system backup      *
  *                      jobs at the same time. This can         *
  *                      possibly result in error message:       *
  *                      ARYS173E - Allocate failed for dsn.     *
  *                      4. Misspelled 'Storage Gorups' in       *
  *                      'Recovery Plan Generation Options'      *
  *                      window (browser client)                 *
  *                      5. When using LBDR if "Start/End        *
  *                      Timestamp" values on ARYGODLS           *
  *                      panel (Object Definition Levels         *
  *                      Selection) have been set to             *
  *                      an earlier timestamp than earliest      *
  *                      available DB2 log timestamp, agent      *
  *                      can terminate with 'ARYY001S - The      *
  *                      agent at 2001:21:21:55::22 has          *
  *                      unexpectedly disconnected.'             *
  *                      6. Browser client - ability to select   *
  *                      multiple rows on the messages window    *
  *                      to be able to delete those messages     *
  *                      in bulk rather than one-by-one.         *
  *                      7. When producing recovery plans for    *
  *                      partitioned tablespaces which have been *
  *                      image copied using Recovery Experts     *
  *                      Fast Replication Image copy feature,    *
  *                      a S0C4 abend can occur. The abend is    *
  *                      in module ARYLJGTP.                     *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

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

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

  UK80302

Modules/Macros

• ARY$REC2 ARY$RE92 ARY#ALSL ARY#ALUP ARY#BSQL
  ARY#HCHK ARY#LBID ARY#LSQL ARY#OBEX ARY#OBIO ARY#ONDX ARY#PE
  
  ***This field was truncated.  To obtain the full apar record, please contact your local support center.***
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R310 PSY UK80302

     UP12/07/23 P F207

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.