rdb

The rdb command lists RDB objects and database table spaces for workflow isolated regions.

RDB objects are used to specify where region queues, indexes, rosters, and logs are created (in a table space, for example). Use the administration console to specify different table spaces where the workflow data will be stored. To use isolated region recovery, configure one or more separate table spaces for that isolated region data.

Syntax

rdb l | r [entity [option]]

Parameters

l (list)
Entity Option Description
o (objects) <isolated_region_number> Displays the RDB objects and table spaces for the specified isolated region.

You are prompted for an isolated region number if you did not enter one. Assigned table spaces or rdb objects for the isolated region are listed.
t (table spaces) <isolated_region_number> Displays the table spaces used by the specified isolated region.

You are prompted for an isolated region number if you did not enter one. Table spaces are listed only if table spaces exist in the isolated region.
r (regions) <table_space_name> Displays the numbers of the regions that use the table space.

You are prompted for a table space if you did not enter one. The regions that are used by the table space are then listed.
isolated_region_number can be one of the following:
<CR>
Press carriage return (blank entry) to display the values for the default isolated region.
<region#>
Enter an isolated region number to display the values for that isolated region.
0
Enter 0 to display the values for the global isolated region.
-1
Enter -1 to display the values for all regions.

table_space_name is the name of the table space in the database.

r (resolve)
<name-of-object>
Displays the table space.

Example

Table 1. Examples of tablespace usage.
Description Name of object Example Location (table space)
Default configuration pe_data vwdata_fg
Custom configurations
  • Isolated region 5 data
  • Isolated region 5 table
  • Isolated region 5 roster
  • pe_data.5
  • pe_data.5.table
  • pe_data.5.roster
  • TS5
  • TS5T
  • TS5R
In this configuration, all data for isolated region 5 is in TS5, except isolated region 5 queues and rosters. These are in TS5T and TS5R. The event log data for isolated region 5 is undefined, so it is in TS5.
rdb l o -1
Displays all objects of all regions.
rdb l t 5
Displays all table spaces used by isolated region 5.
rdb l r TS5
Displays all regions using (sharing) TS5.
rdb r pe_data.5.table
Displays the isolated region 5 table data.