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

Syntax: -c|-class <info_class>

<info_class> can be:

Default: dbstate

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

Syntax: all_cf|all_df|all_dv|all_rf|<file>|<file_id>|

<file_id1>-<file_id2>|<file_list>|<sapdata_dir>|sapdata<N>|

sapraw|<win_drive>:|+<asm_disk>

where:

all_df means all data files

all_rf means all redo log files

all_cf means all control files

all_dv means all disk volumes

Default: all files

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

Syntax: -i|-index all|allsel|[<owner>.]<index>|

[<owner>.][<prefix>]%[<suffix>]|

[<owner>.][<prefix>]*[<suffix>]|<index_list>

where:

all or “%” means preselect

allsel or “*” means final select:

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

Default: all indexes

-ip|-indpart all|allsel|[[<owner>.]<index>.]<partition>|[[<owner>.]<index>.][<prefix>]%[<suffix>]|

[[<owner>.]<index>.][<prefix>]*[<suffix>]|<indpart_list>

where:

all or allsel means selection of all index partitions

'%' or '*' means selection of wildcards

Default: all index partitions

-l|-log: logs database information shown

Default: do not log

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

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

all_inst: all database instances

Default: all database instances

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

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

<owner> specifies the name of the SAP owner

all_own: all database owners

Default: all SAP owners

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

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

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

all_par: all database parameters

Default: all parameters

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

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

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

all_ts: all tablespaces

Default: all tablespaces

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

Syntax: -t|-table all|allsel|[<owner>.]<table>|

[<owner>.][<prefix>]%[<suffix>]|

[<owner>.][<prefix>]*[<suffix>]|<table_list>

where:

all or “%” means preselect

allsel or “*” means final select:

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

Default: all tables

-tp|-tabpart: specifies the table partition name

Syntax: -tp|-tabpart all|allsel|[[<owner>.]<table>.]<partition>|

[[<owner>.]<table>.][<prefix>]%[<suffix>]|

[[<owner>.]<table>.][<prefix>]*[<suffix>]|<tabpart_list>

where:

all or allsel means selection of table partitions

'%' or '*' means selection of wildcards

Default: all table partitions