The example below lists all storage pools in the database.
Figure 216. SYSPRINT File of Data Restore SHOWPOOL
XTS9-143 CONTROL DBNAME=SQLVSE02
XTS9-143 SHOWPOOL
XTS9-143 /*
XTS9-100 Data restore feature VERSION 7.1.0
XTS9-313 DB2 for VSE & VM Version 7 processed
XTS9-143 ****************************************************************
XTS9-203 Pool= 1 First dbextent= 1 Pool is RECOVERABLE
XTS9-203 Pool= 2 First dbextent= 2 Pool is RECOVERABLE
XTS9-203 Pool= 3 First dbextent= 3 Pool is RECOVERABLE
XTS9-203 Pool= 4 First dbextent= 4 Pool is RECOVERABLE
XTS9-203 Pool= 5 First dbextent= 5 Pool is RECOVERABLE
XTS9-203 Pool= 6 First dbextent= 6 Pool is RECOVERABLE
XTS9-203 Pool= 7 First dbextent= 7 Pool is RECOVERABLE
XTS9-203 Pool= 8 First dbextent= 8 Pool is RECOVERABLE
XTS9-203 Pool= 9 First dbextent= 9 Pool is RECOVERABLE
XTS9-203 Pool= 10 First dbextent= 10 Pool is RECOVERABLE
XTS9-203 Pool= 11 First dbextent= 11 Pool is RECOVERABLE
XTS9-203 Pool= 12 First dbextent= 12 Pool is RECOVERABLE
XTS9-203 Pool= 13 First dbextent= 13 Pool is RECOVERABLE
XTS9-203 Pool= 14 First dbextent= 14 Pool is RECOVERABLE
XTS9-143 ****************************************************************
XTS9-204 Dbextent= 1 Pool= 1 Next dbextent=NONE
XTS9-204 Dbextent= 2 Pool= 2 Next dbextent=NONE
XTS9-204 Dbextent= 3 Pool= 3 Next dbextent=NONE
XTS9-204 Dbextent= 4 Pool= 4 Next dbextent=NONE
XTS9-204 Dbextent= 5 Pool= 5 Next dbextent=NONE
XTS9-204 Dbextent= 6 Pool= 6 Next dbextent=NONE
XTS9-204 Dbextent= 7 Pool= 7 Next dbextent=NONE
XTS9-204 Dbextent= 8 Pool= 8 Next dbextent=NONE
XTS9-204 Dbextent= 9 Pool= 9 Next dbextent=NONE
XTS9-204 Dbextent= 10 Pool= 10 Next dbextent=NONE
XTS9-204 Dbextent= 11 Pool= 11 Next dbextent=NONE
XTS9-204 Dbextent= 12 Pool= 12 Next dbextent=NONE
XTS9-204 Dbextent= 13 Pool= 13 Next dbextent=NONE
XTS9-204 Dbextent= 14 Pool= 14 Next dbextent=NONE
XTS9-143 ****************************************************************
XTS9-007 Processing successfully completed