DB2 Server for VSE & VM: Data Restore Guide

Using the SHOWDBS Command

The following is an example of the JCL required in VSE:

Figure 146. JCL to Execute the SHOWDBS command

// JOB SHOWDBS (1) ---> // LIBDEF *,SEARCH=(PRD2.RCVvrm) (2) ---> // EXEC PROC=ARIS71DB (3) ---> // EXEC XTS91001,SIZE=AUTO (4) ---> // MTC REW,SYS006 (5) ---> OPTIONS NOTATION=U (6) ---> SHOWDBS SORT=NAME (7) ---> /*

Statement 1

Specifies the Data Restore library. You must specify the Data Restore library for the SHOWDBS function.

Statement 2

Contains all DLBL for the dbextents.

Statement 3

Executes the program XTS91001.

Statement 4

Rewinds the tape to the first file.

Statement 5

Allows the user to indicate the notation preference, United States or European.

Statement 6

Performs the SHOWDBS function as requested while sorting the output by dbspace name.

Statement 7

Ends the SYSIN file.

The following is an example of an EXEC to use in VM:

Figure 147. VM EXEC to Run the SHOWDBS function

/**/ (1) ---> 'FILEDEF SYSPRINT DISK XTS91001 SYSPRINT A' (2) ---> 'FILEDEF SYSIN DISK SHOWDBS SYSIN A' (3) ---> 'XTS91001'

Statement 1

Specifies the destination of the SYSPRINT file.

Statement 2

Identifies the input source for the SHOWDBS function.

Statement 3

Executes the program XTS91001.

The SYSIN file must contain the following statements:

Figure 148. Input File to Run the SHOWDBS function

(4) ---> OPTIONS NOTATION=U (5) ---> CONTROL DBNAME=dbname (6) ---> SHOWDBS SORT=NAME

Statement 4

Allows you to indicate your notation preference, United States or European.

Statement 5

Specifies the database name.

Statement 6

Performs the SHOWDBS function as requested while sorting the output by dbspace name.