rdb

This command lists RDB objects and database tablespaces for workflow isolated regions.

RDB objects are used to specify where region queues, indexes, rosters, and logs are created (in a tablespace, for example). Use Process Task Manager to specify different tablespaces where the workflow data will be stored. To use region recovery, configure one or more separate tablespaces for that region data. See Isolated region recovery overview for additional information.

Syntax

rdb l | r [entity [option]]

Parameters

(list)

entity option description
o objects) <region-num> Displays the RDB Objects and tablespaces for the specified region.
t (tablespaces) <region-num> Displays the tablespaces used by the specified region.
r (regions) <tablespace-name> Displays the numbers of the regions that use the tablespace.

region-num can be one of the following:

<CR> Press carriage return (blank entry) to display the values for the default region.
<region#> Enter a region number to display the values for that region.
0 Enter 0 to display the values for the global region.
-1 Enter -1 to display the values for all regions.

tablespace-name is the name of the tablespace in the database.

(resolve)
<name-of-object> Displays the tablespace.

Examples

Description Name of object Example Location (tablespace)
Default configuration pe_data vwdata_fg

Custom configurations

Region 5 data

 

pe_data.5

 

TS5

Region 5 table pe_data.5.table TS5T
Region 5 roster pe_data.5.roster TS5R
     

In this configuration, all data for isolated Region 5 is in TS5, except Region 5 queues and rosters. These are in TS5T and TS5R. The event log data for 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 tablespaces used by Region 5.

rdb l r TS5

Displays all regions using (sharing) TS5.

rdb r pe_data.5.table

Displays the Region 5 table data.