rdb

This 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 Process Task Manager to specify different table spaces where the workflow data will be stored. To use region recovery, configure one or more separate table spaces 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 table spaces for the specified region.
t (table spaces) <region-num> Displays the table spaces used by the specified region.
r (regions) <table-space-name> Displays the numbers of the regions that use the table space.

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.

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

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

Examples

Description Name of object Example Location (table space)
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 table spaces 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.