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

  • cfinfo shows control files

  • dbowner shows database owners

  • dbparam shows database parameters

  • dbstate shows database instance status

  • dfinfo shows data files

  • dvinfo shows disk volumes

  • fbstate shows flashback database status

  • feinfo shows free extents

  • idinfo shows indexes

  • ipinfo shows index partitions

  • rfinfo shows redo log files

  • seinfo shows segment extents

  • sginfo shows segments

  • tbinfo shows tables

  • tpinfo shows table partitions

  • tsinfo shows tablespaces

  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