-f dbshow

This BRSPACE function  shows information on objects in the database. For more information, see:

Function options:

·        -c|-class: specifies the class of database information to be shown

Syntax: -c|-class <info_class>

<info_class> can be:

Ў        dbstate shows database instance status

Ў        dbparam shows database parameters

Ў        tsinfo  shows tablespaces

Ў        dfinfo  shows data files

Ў        rfinfo  shows redo log files

Ў        cfinfo  shows control files

Ў        dvinfo  shows disk volumes

Ў        tbinfo  shows tables

Ў        idinfo  shows indexes

Ў        tpinfo  shows table partitions

Ў        ipinfo  shows index partitions

Ў        sginfo  shows segments

Ў        seinfo  shows segment extents

Ў        feinfo  shows free extents

Default: dbstate

·        -f|-file: specifies the data file name(s)

Syntax: -f|-file <file>|<file_id>|<file_id1>-<file_id2>|<file_list>

Default: all files

·        -i|-index: specifies the index name(s)

Syntax: -i|-index [<owner>.]<index>|[<owner>.]<prefix>%|%|
[<owner>.]<prefix>*|*|<index_list>]

Wildcards: “%” and “*” both mean final selection

For more information on selection wildcards, see “Selecting Objects” in Segment Management with BR*Tools.

Default: all indexes

·        -l|-log: logs database information shown

Default: do not log

·        -n|-instance: specifies the database instance name(s)

Syntax: -n|-instance <instance>|<instance_list>

Default: all database instances

·        -o|-owner: specifies the SAP owner of the tables or indexes

Syntax:-o|-owner <owner>|<owner_list>

<owner> specifies the name of the SAP owner

Default: all SAP owners

·        -p|-parameter: specifies which database parameters are to be shown

Syntax: -p|-parameter <parameter>|<parameter_list>

<parameter> or <parameter_list> specifies the parameter(s)

Default: all parameters

·        -s|-tablespace: specifies the tablespace name for the objects to be shown

Syntax: -s|-tablespace <tablespace>|<tablespace_list>

<tablespace> or <tablespace_list> specifies the tablespace(s)

Default: all tablespaces

·        -t|-table: specifies the table name(s) of the objects to be shown

Syntax: -t|-table [<owner>.]<table>|[<owner>.]<prefix>%|%|
[<owner>.]<prefix>*|*|<table_list>]

Wildcards: “%” and “*” both mean final selection

For more information on selection wildcards, see “Selecting Objects” in Segment Management with BR*Tools.

Default: all tables