DB2 Server for VSE & VM: Data Restore Guide

Using the SHOWPOOL Command

The following is an example of using JCL to execute the SHOWPOOL command.

Figure 152. Sample of JCL (VSE) to execute SHOWPOOL

// JOB SHOWPOOL (1) ---> // LIBDEF *,SEARCH=(PRD2.RCVvrm) (2) ---> // EXEC PROC=ARIS71DB (3) ---> // EXEC XTS91001,SIZE=AUTO (4) ---> SHOWPOOL /*

Statement 1

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

Statement 2

Contains all DLBL for DBEXTENTS.

Statement 3

Executes the program XTS91001.

Statement 4

Process the SHOWPOOL command.

Sample Procedure(VM)

Figure 153. Sample VM procedure for running the SHOWPOOL function

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

Statement 1

Specifies the destination of the SYSPRINT file.

Statement 2

Identifies the input source for the SHOWPOOL function.

Statement 3

Executes the program XTS91001.

The SYSIN file must contain the following statements:

Figure 154. Sample input file for running the SHOWPOOL function

(4) ---> CONTROL DBNAME=dbname (5) ---> SHOWPOOL

Statement 4

Specifies the database name.

Statement 5

performs the SHOWPOOL function.