DB2 Server for VSE & VM: Data Restore Guide

SHOWDBS



>>-SHOWDBS----+-----------------+------------------------------><
              '-SORT--+-NAME-+--'
                      +-DBNO-+
                      '-PCT--'

Purpose

Use the SHOWDBS command to provide information such as the header, data or index pages available in a dbspace when the server is offline or online.

The Data Restore SHOWDBS executes a SHOW DBSPACE function while the database is online or offline.

Operands

SORT
Use this parameter to obtain sorted output. This parameter is optional.

PCT
Displays the results sorted by dbspaces having the highest percentage of used data or index pages.

NAME
Displays results sorted by dbspace name.

DBNO
Displays the results sorted by dbspace number.

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