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