PQ65989: VOLUME STATE INFORMATION DIFFERS BETWEEN Q DRM AND Q DRM <VOLNAME>

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The state information for a DRM volume is different when using
  Q DRM or Q DRM <volname>
  Results from QUERY DRM:
   ...
   ARP901     Vault     06/03/2002 06:48:26
   ARP899     Vault     06/03/2002 06:48:34
  Results from QUERY DRM ARP901:
   ARP901     Vault retrieve   06/03/2002 06:48:26
  Results from
  "select * from drmedia where volume_name='ARP901'":
   VOLUME_NAME: ARP901
         STATE: VAULT
      UPD_DATE: 2002-06-03 06:48:26.000000
      LOCATION: Keller Schrank
  STGPOOL_NAME:
      LIB_NAME:
       VOLTYPE: DBBackup
  

Local fix

• use Q DRM <volname>
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Any TSM server users of DRM.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The QUERY/MOVE DRMEDIA <volume_name>    *
  *                      may incorrectly indicate that a         *
  *                      database backup volume is in            *
  *                      VAULTRETRIEVE state.                    *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply fix in PTF.                            *
  ****************************************************************
  The QUERY/MOVE DRMEDIA <volume_name>
  may incorrectly indicate that a
  database backup volume is in
  VAULTRETRIEVE state.
  
  DRM indicates that a database backup
  volume is in VAULTRETRIEVE if the
  volume is at the vault , and it is
  associated with a database backup
  series that is expired.
  A  full plus incremental or snapshot
  database backup series is eligible
  for expiration if all
  the following conditions are met:
   - The age of the last volume of the
     series has exceeded the
     expiration value of the SET
     DRMDBBACKUPEXPIREDAYS command
   - The series is not the latest full
     plus incremental database backup
     series or snapshot database backup
     series
   - For volumes that are not virtual
     volumes, all the volumes in the
     series are in the VAULT state.
  
  Customers using the QUERY/MOVE
  DRMEDIA <volume_name> to process
  database backup volumes that are at
  the VAULT may find that the state
  assigned to some of volumes is
  VAULTRETRIEVE before the their
  database backup series is eligible
  for expiration. This problem may
  occur when:
    - the volume name entered with the
      QUERY or MOVE DRMEDIA commands
      is fully specified,
    - the age of the volume has exceed
      the expiration value of the
      SET DRMDBBACKUPEXPIREDAYS
      command, but the age of
      the last volume of the series
      has NOT.
  
  The problem described here does not
  apply to the QUERY DRM command,
  the QUERY DRMEDIA <volume_name> or
  MOVE DRMEDIA <volume_name>
  command when the parameter
  <volume_name> contains wildcard
  characters, or the SQL SELECT
  command used to obtain information
  from the DRMEDIA table.
  

Problem conclusion

• The TSM/DRM code was fixed to report the correct volume state.
  

Temporary fix

Comments

APAR Information

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

  IC34037

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

Fix information

• Fixed component name

  TSM FOR OS/390

• Fixed component ID

  5698ISMVS

Applicable component levels

• R510 PSY UQ73281

     UP03/01/28 P F301

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.