-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: -f|-file <file>|<file_id>|<file_id1>-<file_id2>|<file_list>

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

-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 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