The QUSRBRM.BACKUP_HISTORY_SPOOLED_FILE view shows BRMS saved item information for spooled files backed up on the system.

The values returned for the columns in this view are similar to the values returned by the Work with Spooled Files (WRKSPLFBRM) command.

You must have object level detail specified with *YES and Save spooled file data *ALL on the BRMS backup to have saved item information for spooled files.

Authorization:

The authorization ID of the statement must include the following privileges:

*OBJOPR and *READ authority to the QUSRBRM/BKU_SPLF *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
OUTPUT_QUEUE_LIBRARY	OUTQLIB	VARCHAR(10)	The name of the library containing the spooled files.
OUTPUT_QUEUE	OUTQUEUE	VARCHAR(10)	The output queue that contained the spooled file when it was saved.
SPOOLED_FILE_NAME	SPLNAME	VARCHAR(10)	The name of the spooled file that was saved.
SPOOLED_FILE_QUALIFIED_JOB	SPLQUALJOB	VARCHAR(28)	The qualified name of the job that created the spooled file.
SPOOLED_FILE_NUMBER	SPLNUM	INTEGER	The number of the spooled file.
SPOOLED_FILE_USER_DATA	SPLUSRDTA	VARCHAR(10)	The user specified data the describes the spooled file.
SAVED_ITEM	SAVED_ITEM	VARCHAR(10)	The name of the library, list or special value that was saved.
SAVED_ITEM_TYPE	ITEM_TYPE	VARCHAR(5)	The type of saved item is displayed. The possible values are: SPLF The save item is a spooled file. LIST The saved item is from a backup list.
SAVE_TYPE	SAVE_TYPE	VARCHAR(5) Nullable	Displays the type of save performed. The possible values are: ARC Save part of archive processing. CUML The save was an incremental save including all objects that have been changed since the last full save. DAOSF The save was a full Domino Attached and Object Service (DAOS) backup. DAOSI The save was an incremental Domino Attached and Object Service (DAOS) backup. FILE The save is the result of a native IBM i save command (non-BRMS). FULL The save was a full save. INCR The save was an incremental save includes all objects that have been changed since the last incremental save. LTSONL The save was a result of a full online backup of a Lotus server. LTSINC The save was a result of a full online backup of a Lotus server and subsequent incremental online backups. QBRM The save of BRMS media information stored in the QUSRBRM library. 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: SAVF The saved item was saved to a save file. volume-serial* The name of the volume serial used for tape or optical.
BEGINNING_VOLUME_SERIAL	BEGVOLSER	VARCHAR(6) Nullable	The beginning volume serial identifier of the first volume in a volume set is displayed. 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: SAVF Save files are being used. device-names* The names of the devices. 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: PERM The was assigned permanent retention status. VERSION The volume expiration is using versions. EXPVERSION The saved item is an expired version. 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: expiration-date The date that the volume expires. 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	VARCHAR(6)	The release of the operating system on which you intend to restore the objects being saved.
SAVE_OBJECT_DETAIL	SAVOBJDTL	VARCHAR(3)	Whether object detail was kept when the saved item was saved. The possible values are: NO Indicates that the saved item was not saved with object level detail. YES Indicates that the saved item was saved with object level detail.
SAVE_STATUS	SAVESTATUS	VARCHAR(3)	Whether the saved item was saved successfully. The possible values are: NO Indicates that the saved item was not saved. YES Indicates that the saved item saved successfully.
DUPLICATE_SAVED_ITEM	DUPLICATE	VARCHAR(3)	Whether the saved item is a duplicate of another saved item as a result of a duplication operation. The possible values are: NO Indicates that the saved item is not a duplicate of another saved item. YES Indicates that the saved item is duplicate of another saved item.
DUPLICATE_NUMBER	DUPNUMBER	INTEGER Nullable	Displays the duplicate number of the saved item. Contains the null value when DUPLICATE_SAVED_ITEM is NO.
DUPLICATION_RESUME_KEY	DUPRSMKEY	VARCHAR(6) Nullable	Displays the duplication resume key for the saved item. This key can be used with the Resume key (RSMKEY) parameter on the Duplicate Media using BRM (DUPMEDBRM) command to resume duplication of the saved item if the duplication operation ended with errors. Contains the null value is the resume key is not set.
MARK_FOR_DUPLICATION	MARKFORDUP	VARCHAR(3)	Whether the saved item is marked for duplication. The possible values are: NO Indicates that the saved item is not marked for duplication. YES Indicates that the saved item is marked for duplication.
PRIVATE_AUTHORITIES	PRIVAUTH	VARCHAR(3)	Whether the private authorities were saved with the objects for the saved item. The possible values are: NO No private authorities were saved. YES Private authorities were saved for each object that is saved.
SAVE_ACCESS_PATHS	SAVACCPTH	VARCHAR(3)	Whether the logical file access paths that are dependent on the physical files being saved are also saved. The access paths are saved only if all members on the logical file access paths were saved with the objects for the saved item. The possible values are: NO Only those objects specified on the command are saved. No logical file access paths are saved. YES The selected physical files and all logical file access paths over them are saved.
DATA_COMPRESSION	DTACOMPRES	VARCHAR(3)	Whether data compression is used. The possible values are: NO No data compression is performed. YES Data compression was performed
DATA_COMPACTION	DTACOMPACT	VARCHAR(3)	Whether data compaction is used. The possible values are: NO No data compaction is performed. YES Data compaction is performed if the data is saved to tape and all devices used for the backup support the compaction feature.
ENCRYPTED	ENCRYPTED	VARCHAR(3)	Whether an encrypted save was performed. The possible values are: NO Indicates that the saved item was not encrypted during the save. YES Indicates that the saved item was encrypted.
DATA_FILE_LABEL	DTAFILLBL	VARCHAR(17) Nullable	The data file identifiers of the data files on the tape whose labels are shown are displayed. The data file identifier are stored on the label ahead of the data in the file. Contains the null value when a tape device was not used for the save.
OPTICAL_DIRECTORY_NAME	OPTDIRNAME	VARCHAR(250) Nullable	Displays the directory on the optical volume that was used, if the save operation was to an optical device. Contains the null value when an optical device was not used for the save.
SAVE_SAVEFILE_CONTENTS	SAVSAVF	VARCHAR(3)	Whether the description of a save file, or both the description and the contents of a save file, are saved. The possible values are: NO Only the description of a save file is saved. YES The description and contents of a save file are saved.
SAVEFILE_NAME	SAVFNAME	VARCHAR(10) Nullable	The name of the save file that this saved item was saved to as a result of a save operation. Contains the null value when the save was to tape or optical.
SAVEFILE_LIBRARY	SAVFLIB	VARCHAR(10) Nullable	The name of the library that contains the save file. Contains the null value when the save was to tape or optical.
SAVEFILE_EXPIRATION	SAVFEXP	DATE Nullable	When the save files expires. The possible values are: expiration-date The date that the save file expires. Contains the null value when the saved item is not saved to a save file.
SAVE_SAVEFILE_TO_TAPE	SAVSAVFTAP	VARCHAR(3)	For save file objects, whether the description of a save file, or both the description and the contents of a save file, are saved on the tape or in another save file. The possible values are: NO Only the description of a save file is saved. YES The description and contents of save files are saved.
SAVE_SPOOLED_FILE_DATA	SAVSPLDTA	VARCHAR(3)	Whether to save the spooled file data and attributes for saved output queues. The possible values are: NO No spooled file data or attributes are saved with saved output queues. YES All available spooled file data and attributes are saved with saved output queues.
ERROR_MESSAGE_IDENTIFIER	ERRORMSGID	VARCHAR(7) Nullable	The error message ID for the saved item if there was an error when the saved item was saved is displayed. Contains the null value if the saved item was saved successfully and there is no error message.
KEYSTORE_FILE	KEYFILE	VARCHAR(10) Nullable	The name of the database file that stores the operational keys that are used for encryption on the backup.
KEYSTORE_LIBRARY	KEYLIBRARY	VARCHAR(10) Nullable	The name of the library containing key store file used for encryption on the backup.
KEYSTORE_LABEL	KEYLABEL	VARCHAR(32) Nullable	The name of the unique identifier of the key record in a key store file used for encryption on the backup.
TEXT	TEXT	VARCHAR(50) Nullable	The text description for the saved item if it existed at the time of the save and if the object was saved successfully saved, or the text of the error message if the saved item was not saved successfully. Contains the null value when no text existed at the time of the save.

Examples

Example 1 - Show the spooled files in most recent backup of output queue QPRINT and the volumes used

SELECT MAX(COMMAND_START_TIME) AS SAVED_TIME,
       SPOOLED_FILE_NAME,
       OUTQLIB,
       OUTPUT_QUEUE,
       BEGVOLSER,
       VOLUME_SERIAL
    FROM QUSRBRM.BACKUP_HISTORY_SPOOLED_FILE
    WHERE OUTPUT_QUEUE = 'QPRINT'
    GROUP BY SPOOLED_FILE_NAME,
             OUTQLIB,
             OUTPUT_QUEUE,
             BEGVOLSER,
             VOLUME_SERIAL;

Example output:

SAVED_TIME	SPOOLED_FILE_NAME	OUTQLIB	OUTPUT_QUEUE	BEGVOLSER	VOLUME_SERIAL
2025-05-15 07:52:08	QPDSPJOB	QGPL	QPRINT	004027	004027
2025-05-15 07:52:08	QZSRHTTPTR	QGPL	QPRINT	004027	004027
2025-05-15 07:52:08	QPJOBLOG	QGPL	QPRINT	004027	004027
2025-05-15 07:52:08	THEPGM	QGPL	QPRINT	004027	004027
2025-05-15 07:52:08	QPRINT	QGPL	QPRINT	004027	004027
2025-05-15 07:52:08	QPSRVDMP	QGPL	QPRINT	004027	004027

Example 2 - Find the spooled files for output queue QPRINT ordered by save size descending

SELECT COMMAND_START_TIME,
       SPOOLED_FILE_NAME,
       OUTQLIB,
       OUTPUT_QUEUE,
       SAVE_SIZE
    FROM QUSRBRM.BACKUP_HISTORY_SPOOLED_FILE
    WHERE OUTPUT_QUEUE = 'QPRINT'
    ORDER BY SAVE_SIZE DESC;

COMMAND_START_TIME	SPOOLED_FILE_NAME	OUTQLIB	OUTPUT_QUEUE	SAVED_SIZE
2025-05-15 07:49:03	QPJOBLOG	QGPL	QPRINT	54546432
2025-05-15 07:49:03	QPJOBLOG	QGPL	QPRINT	54546432
2025-05-15 07:52:08	QPJOBLOG	QGPL	QPRINT	54546432
2025-05-15 07:52:08	QPJOBLOG	QGPL	QPRINT	54546432
2025-05-15 07:49:03	QPJOBLOG	QGPL	QPRINT	39866368
2025-05-15 07:52:08	QPJOBLOG	QGPL	QPRINT	39866368
2025-05-15 07:49:03	QPJOBLOG	QGPL	QPRINT	12652544
2025-05-15 07:49:03	QPJOBLOG	QGPL	QPRINT	12652544
2025-05-15 07:52:08	QPJOBLOG	QGPL	QPRINT	12652544

IBM Partnership

QUSRBRM.BACKUP_HISTORY_SPOOLED_FILE View

Examples

Example 1 - Show the spooled files in most recent backup of output queue QPRINT and the volumes used

Example 2 - Find the spooled files for output queue QPRINT ordered by save size descending