QUSRBRM.BACKUP_HISTORY_OBJECT View
The QUSRBRM.BACKUP_HISTORY_OBJECT view shows BRMS saved object information for the system.
The values returned for the columns in this view are similar to the values returned by the Work with Media Information (WRKMEDIBRM) command, option 9, showing the saved object information saved by BRMS.
You must have object level detail specified with *YES or *OBJ on the BRMS backup to have saved object information.
Authorization:
The authorization ID of the statement must include the following privileges:
*OBJOPR and *READ authority to the QUSRBRM/BKU_OBJ *FILE object.
Result Table
The following table describes the columns in the view. The schema is QUSRBRM.
Column Name | System Column Name | Data Type | Description |
SAVED_ITEM | SAVED_ITEM | VARCHAR(10) | The name of the library, list or special value that was saved. |
SAVED_OBJECT | OBJECT | VARCHAR(12) | The name of the object that was saved. |
SAVED_OBJECT_TYPE | OBJ_TYPE | VARCHAR(8) Nullable | The type of saved object is displayed. The possible values are:
Contains the null value if the saved object type is unknown. |
SAVED_OBJECT_ATTRIBUTE | OBJ_ATTR | VARCHAR(10) | The attribute of the object that was saved. |
SAVED_OBJECT_OWNER | OBJ_OWNER | VARCHAR(10) | The owner of the object that was saved. |
SAVE_TYPE | SAVE_TYPE | VARCHAR(5) Nullable | Displays the type of save performed. The possible values are:
Contains the null value if the item has never been saved before. |
SAVE_COMMAND | SAVECMD | VARCHAR(10) | The save command that was used for this save process is displayed. |
COMMAND_START_TIME | CMDSTRTIM | TIMESTAMP(0) Nullable | The timestamp the backup command was started. Contains the null value when the timestamp is not set. |
SAVE_TIMESTAMP | SAVTIMSTMP | TIMESTAMP(0) Nullable | The timestamp the save started. Contains the null value when the timestamp is not set. |
QUALIFIED_JOB_NAME | QUAL_JOB | VARCHAR(28) | The qualified name of the job that performed the save. |
VOLUME_SERIAL | VOLSERIAL | VARCHAR(6) | Specifies the volume serial identifier of the media containing the saved data. The possible values are:
|
BEGINNING_VOLUME_SERIAL | BEGVOLSER | VARCHAR(6) Nullable | The beginning volume serial identifier of the first volume Contains the null value if the saved item was saved to a save file. |
VOLUME_SEQUENCE_NUMBER | VOLSEQNUM | INTEGER | The volume sequence number in the set. |
DEVICE_NAMES | DEVICES | VARCHAR(43) | The device names used by the backup for this control group. The possible values are:
Note: The string contains 10 character blank separated device names, up to a maximum of 4. |
REFERENCE_TIMESTAMP | REFTIMSTMP | TIMESTAMP(0) Nullable | The reference timestamp for objects in the saved item that were saved as a result of an incremental save is displayed. Contains the null value when an incremental save was not processed. |
EXPIRATION | EXPIRATION | VARCHAR(10) Nullable | When the volume expires. The possible values are:
Contains the null value when the EXPIRATION_DATE column has a specific date. |
VERSION_NUMBER | VERSION | INTEGER Nullable | The volume version number of the saved item, when EXPIRATION is set to VERSION. The number of versions can range from 1 - 365. Contains the null value when the EXPIRATION column is not set to VERSION. |
EXPIRATION_DATE | EXPIREDATE | DATE Nullable | When the volume expires. The possible values are:
Contains the null value when the EXPIRATION column is set. |
OBJECTS_SAVED | SAVED | BIGINT | The number of objects saved. |
OBJECTS_NOT_SAVED | NOTSAVED | BIGINT | The number of objects not saved. |
SAVE_SIZE | SAVE_SIZE | BIGINT | The number of bytes saved. |
FILE_SEQUENCE_NUMBER | FILESEQNUM | BIGINT | The file number of the first media volume is displayed for the first media file that contains this saved item. |
MEDIA_FILE_NUMBER | MEDFILNUM | INTEGER | The the media file number of the saved item that is part of a parallel set. If the saved item is not a member of a parallel set, the media file number is one for serial and tape and optical media and is zero for save files. |
TOTAL_MEDIA_FILES | TOTMEDFIL | INTEGER | The total number of sets that make up the parallel set. If the saved item is not a member of a parallel set, the number of volume sets is one for serial and tape and optical media and is zero for save files.
|
PACKAGE_NUMBER | PACKAGENUM | INTEGER | The package number assigned to the saved item. A package is a group of related media files. This allows separate save operations to be tied to one entity of related objects from one or multiple save operations. |
PACKAGE_TOTAL | PACKAGETOT | INTEGER | The total number of packages in a group of related media files. |
MEDIA_CLASS | MEDIACLASS | VARCHAR(10) Nullable | The media class that was used for the save. Contains the null value if the media class value was not set. |
MOVE_POLICY | MOVEPOLICY | VARCHAR(10) Nullable | The name of the move policy that was used when the saved item was saved is displayed. Contains the null value if a move policy was not set. |
BACKUP_SYSTEM | SYSTEM | VARCHAR(17) | The name of the system where the backup was performed. Note: The system format is nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name. |
CONTROL_GROUP | CGNAME | VARCHAR(10) Nullable | The name of the control group that was backed up. Contains the null value if the backup item was not part of a control group. |
ASP_DEVICE_NAME | ASPDEVNAM | VARCHAR(10) Nullable | The auxiliary storage pool name where the saved item resided when the save operation occurred is displayed. Contains the null value if the backup item does not require the field. |
ASP_NUMBER | ASP_NUMBER | INTEGER | The auxiliary storage pool number where the saved item resided when the save operation occurred. |
SAVED_RELEASE | SAVEDRLS | VARCHAR(6) | The release of the operating system on which the save was performed. |
TARGET_RELEASE | TARGETRLS |
Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.