SAVE_FILE_INFO view

The SAVE_FILE_INFO view returns general information about save files. Detailed information for save files that contain Integrated File System data is not returned.

The information returned is similar to the detail available through the Display Save File (DSPSAVF) CL command and the List Save File (QSRLSAVF) API.

Authorization: The caller must have:

*USE authority to the library containing the save file, and
*USE authority to the save file.

The following table describes the columns in the view. The system name is SAVF_INFO. The schema is QSYS2.

Table 1. SAVE_FILE_INFO view
Column Name	System Column Name	Data Type	Description
SAVE_FILE_LIBRARY	SAVF_LIB	VARCHAR(10)	Name of the library that contains the save file.
SAVE_FILE	SAVF	VARCHAR(10)	Name of the save file.
OBJECTS_SAVED	OBJECTS	INTEGER	The number of objects saved for the library.
MEMBERS_SAVED	MEMBERS	INTEGER	The number of members saved for the library.
ACCESS_PATHS_SAVED	ACC_PATHS	INTEGER	The number of logical file access paths saved for the library.
SPOOLED_FILES_SAVED	SPLFS	INTEGER	The number of spooled files saved in the save file.
SAVE_COMMAND	SAVE_CMD	VARCHAR(9) Nullable	The save command that was used for the save operation. QSYS Contents of the save file were created by the operating system by using a function other than the CL commands. SAV Save directories and integrated file system objects. Information about the content of this save file is not returned. SAVCFG Save configuration information. SAVCHGOBJ Save objects that changed since the date and time specified on the referenced date parameter. SAVDLO Save documents or folders located in library QDOC. SAVLIB Save a library. SAVLICPGM Save licensed programs. SAVOBJ Save an object or group of objects from the same library. SAVSECDTA Save objects required for the security function. Contains the null value if the save file is empty.
SAVE_TIMESTAMP	SAVED	TIMESTAMP(0) Nullable	The date and time when the objects were saved. Contains the null value if the save file is empty or SAVE_COMMAND is SAV.
DATA_COMPRESSED	COMPRESSED	VARCHAR(3) Nullable	Whether the data was saved in compressed format. NO The data is not compressed. YES The data is compressed. Contains the null value if the save file is empty or SAVE_COMMAND is SAV.
SAVE_WHILE_ACTIVE	SAVEACTIVE	VARCHAR(8) Nullable	Whether objects in the library were allowed to be updated while they were being saved. LIB Objects in the library were allowed to be saved while they were in use by another job. All objects in the library reached a checkpoint together. They were saved in a consistent state in relationship to each other. NO Objects in the library were not allowed to be saved while they were in use by another job. SYNCLIB Objects in the library were saved while in use by another job. All of the objects and all of the libraries in the save operation reached a checkpoint together. The objects and the libraries were saved in a consistent state in relationship to each other. SYSDFN Objects that were in use were saved if they were released within the time specified on the SAVACTWAIT parameter. Objects in the library may have reached a checkpoint at different times. They might not be in a consistent state in relationship to each other. Objects in the library were saved while in use by another job. *YES Document library objects were allowed to be saved while they were in use by another job. Contains the null value if the save file is empty or SAVE_COMMAND is SAV.
SYNCHRONIZATION_ID	SYNC_ID	VARCHAR(10) Nullable	The name that was used to synchronize checkpoints for more than one save while active operation. Contains the null value if the save file is empty, SAVE_COMMAND is SAV, or if no synchronization name was used for the save.
EARLIEST_POSSIBLE_RELEASE	EARLY_REL	CHAR(6) Nullable	The earliest release level of the operating system on which the objects can be restored in VxRxMx format. Contains the null value if the save file is empty or SAVE_COMMAND is SAV.
LIBRARY_NAME	LIBRARY	VARCHAR(10) Nullable	The name of the library from which the objects were saved. Contains the null value if the save file is empty or SAVE_COMMAND is SAV.
PRIVATE_AUTHORITIES	PRIV_AUTHS	VARCHAR(3) Nullable	Whether the save operation specified that private authorities should be saved with the objects. NO Objects were saved without their private authorities. YES Objects were saved with their private authorities. Contains the null value if the save file is empty or SAVE_COMMAND is SAV.
SERIAL_NUMBER	SERIAL	VARCHAR(8) Nullable	The serial number of the system on which the save was performed. Contains the null value if the serial number is not available or the save file is empty or SAVE_COMMAND is SAV.
SAVE_FILE_RECORDS	SAVF_REC	BIGINT Nullable	The number of records used to contain the saved information in the save file. Contains the null value if SAVE_COMMAND is SAV.
IASP_NUMBER	IASPNUMBER	INTEGER Nullable	The auxiliary storage pool (ASP) of the library when it was saved. Contains the null value if the save file is empty or SAVE_COMMAND is SAV.
IASP_NAME	IASPNAME	VARCHAR(10) Nullable	The name of the independent auxiliary storage pool (ASP) device of the library when it was saved. Can contain the special value *SYSBAS. Contains the null value if the save file is empty or SAVE_COMMAND is SAV.

Example

Find all the save files in library BACKUP used to save objects from APPLIB.

SELECT SAVE_FILE_LIBRARY, SAVE_FILE, SAVE_TIMESTAMP, OBJECTS_SAVED 
  FROM QSYS2.SAVE_FILE_INFO 
  WHERE SAVE_FILE_LIBRARY = 'BACKUP' AND
        LIBRARY_NAME = 'APPLIB';