PI81715: CC/VM LOOPS ON UNHANDLED IBM TAPE MANAGER MESSAGES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following problems are addressed with this APAR
  1) When an Archive set is expired, the recovery process loops on
  the error message EUMTAP0530E from IBM Tape Manager
  2) Control Center left the database in STATUS = Startup, SQMODE=
  Recovery failure. You must go into Control Center and change the
  Status to NORMAL
  NORMAL.
  3) After failed recovery, ARCHHIST file marked the expired tapes
  as 'Recovered', but they were not actually used.
  4) After failed recovery, Status information indicates that the
  RECOVERY of TEST2 has completed successfully!
  5) When IBM Tape manager is not available, the recovery process
  loops on the error message EUMTAP0085E
  6) Recovery with server in log mode 'Y', returns message
  SQMA0045I "ERROR trying to update TEST2 TAPES file.
  ARCHHIST File not updated"
  7) Changed CC/VM tape set initialization from server startup
  to initiation of an Archive.
  8) Modified Recovery Restore Report to annotate expired tape
  sets or tape sets not in TAPES file
  

Local fix

• Available from Change Team
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL Control Center for VM users who use IBM  *
  *                 Tape Manager.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following problems are addressed    *
  *                      with this APAR                          *
  *                      1) When an Archive set is expired,      *
  *                      the recovery process loops on the       *
  *                      error message EUMTAP0530E from          *
  *                      IBM Tape Manager                        *
  *                      2) Control Center left the database in  *
  *                      STATUS = Startup, SQMODE= Recovery      *
  *                      failure.                                *
  *                      You must go into Control Center and     *
  *                      change the Status to NORMAL & NORMAL.   *
  *                      3) After failed recovery, ARCHHIST      *
  *                      file marked the expired tapes as        *
  *                      'Recovered', but were not actually      *
  *                      used.                                   *
  *                      4) After failed recovery, Status        *
  *                      information indicates that the          *
  *                      RECOVERY of TEST2 has completed         *
  *                      successfully!                           *
  *                      5) When IBM Tape manager is not         *
  *                      available, the recovery process loops   *
  *                      on the error message EUMTAP0085E.       *
  *                      6) Recovery with server in log mode 'Y' *
  *                      returns message SQMA0045I "ERROR        *
  *                      trying to update TEST2 TAPES file.      *
  *                      ARCHHIST File not updated"              *
  *                      7) Moved CC/VM tape set initialization  *
  *                      from server startup to initiationof     *
  *                      an Archive.                             *
  *                      8) Modified Recovery Restore Reportto   *
  *                      annotate when tape sets are expired or  *
  *                      tape sets are not in TAPES file         *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changed to address Control Center problems when
  working with IBM Tape Manager
  

Problem conclusion

• All the changes that needs to be part of the publications
  are listed below.
  Control Center Operations Guide for VM
  Chapter 17 Database Archiving and Recovery Tools
  Section: Selecting a Restore Set
  From: Figure 108 allows you to select one of the valid restore
  sets that were displayed in the earlier report. The restore
  sets will always be numbered from 1 up, from the most recent
  archive to the oldest.
  To: Figure 108 allows you to select one of the valid restore
  sets that were displayed in the earlier report. The restore
  sets will always be numbered from 1 up, from the most recent
  archive to the oldest.
  Review this report for any 'EXPIRED' ot 'NOTFOUND' tape sets
  and investigate.  Using these tapes may cause Recovery Failure.
  

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:

  UI49826

Modules/Macros

• DATABASE DBSTART  SQMARPUR SQMA025I SQMA045I SQMDFDEF SQMIT074
  SQMIT085 SQMIT530 SQMRECTQ
  

Fix information

• Fixed component name

  DB2 CONTROL CEN

• Fixed component ID

  5697F4206

Applicable component levels

• R730 PSN UI49826

     UP17/08/28 P 1708

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.