show boundary

Shows the data partition boundaries stored in the DASD, or a count of boundaries for each compareset.

Syntax

show boundary [compareset_name]

Parameters

compareset_name – the name of the compareset for which data partition boundaries are shown.
Use the optional wildcards to filter compareset names.

Examples

Example 1 – shows the data partition boundaries stored in the DASD:

show boundary
go

The returned result is:

COMPARESET BOUNDARIES
---------- ----------
cmpset_orders       8
cmpset_orders1      8
cmpset_orders2      8

Example 2 – shows the data partition boundaries that match the compareset name filter *orders*:
```
show boundary *orders*
go
```
The returned result is:
```
COMPARESET   BOUNDARIES
--------------   ----------
cmpset_orders      8
 
```

Example 3 – shows the data partition boundaries for a compareset named "cmpset_orders":

show boundary cmpset_orders
go

The returned result is:

KEY NAME        TYPE
--- ----------  -------
0   order_id  INTEGER


BOUNDARY POSITION KEY VALUE
-------- -------- --- -------
0        1000     0   1001000
1        2000     0   1002000
2        3000     0   1003000
3        4000     0   1004000
4        5000     0   1005000
5        6000     0   1006000
6        7000     0   1007000
7        8000     0   1008000