DB2 Server for VSE & VM: Data Restore Guide


Using the SHOWDBS Function

The example below lists all dbspaces in the database with a summary.

Figure 215. SYSPRINT File of Data Restore SHOWDBS

 XTS9-143 OPTIONS CONFIRM=NO
 XTS9-143 CONTROL BASE=S35VMDB1
 XTS9-143 SHOWDBS
 XTS9-143 /*
 XTS9-100 Data Restore feature VERSION 7.1.0
 XTS9-313 DB2 for VSE & VM Version 7 processed
 XTS9-601 DATE:17/06/96  TIME:15:02:28
 --------------------------------------------------------------------------------
 XTS9-014 Pool 1 Dbno   1 Name SYS0001          Pages    12.800 Header 8 Index 60
 
 XTS9-019          Header       Data      Index
 XTS9-020          ------  ---------  ---------
 XTS9-018 Maximum       8      5.112      7.680
 XTS9-015 Reserved      1         87         54
 XTS9-016 Used          1         86         54
 XTS9-017 %Used      12,5        1,6        0,7
 ---------------------------------------------------------------------------------
 XTS9-014 Pool 1 Dbno   2 Name SYS0002           Pages     2.048 Header 8 Index  0
 
 XTS9-019          Header       Data      Index
 XTS9-020          ------  ---------  ---------
 XTS9-018 Maximum       8      2.040          0
 XTS9-015 Reserved      6         55          0
 XTS9-016 Used          6         53          0
 XTS9-017 %Used      75,0        2,5        0,0
 ---------------------------------------------------------------------------------
  .. more pools in between ....
 ---------------------------------------------------------------------------------
 XTS9-601 DATE:17/06/96  TIME:15:02:28
 XTS9-022 Pool:001
 XTS9-023 ========
 XTS9-024         Dbno Dbspacename         Reserved      Used     Empty
 XTS9-025         ---- ------------------ --------- --------- ---------
 XTS9-021            5 SAMPLE                    20        12         8
 XTS9-021            2 SYS0002                   61        59         2
 XTS9-021            4 ISQL                       8         7         1
 XTS9-021            1 SYS0001                  142       141         1
 XTS9-026                                 --------- --------- ---------
 XTS9-027 Total pool:  1                        231       219        12
 XTS9-601 DATE:17/06/96  TIME:15:02:28
 XTS9-007 Processing successfully completed


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]