Importing data from a backup file

SYSOUT records that have been previously exported to a sequential file can be imported back into the database by using the IMPORT keyword of the DSTUTIL command. Only the records matching the search criteria are imported. See Defining initialization statements for details.

Example:

DSTUTIL IMPORT DDNAME(EQQEXP01) REPLACE(YES)
     SEARCH1(JBIDLK*)

This command imports all SYSOUT records contained in the export file identified by DDNAME EQQEXP01. The only condition specified is a wildcard filter that will match every record in the file:

  JobId  LIKE  '*'

The option REPLACE(YES) means matching records in the database will be overwritten by those imported from the backup file.

You can import separately structured and unstructured data by codifying the command IMPORT with two different ddnames. The import utility recognizes the export data type (structured and unstructured) because of the header record that provides it.

Example

DSTUTIL IMPORT DDNAME(EQQEXPST) REPLACE(YES) ˂- struct. exp. file SEARCH1(JBIDLK*)
DSTUTIL IMPORT DDNAME(EQQEXPUN) REPLACE(YES) ˂- unstruct. exp. file SEARCH1(JBIDLK*)

Note: The command shown above can be used after the whole database, has been reorganized after a previous mass export.