Table information

The dbschema -ss command retrieves information about fragmented tables, the lock mode, and extent sizes.

The following dbschema output shows the expressions specified for fragmented table.

{ TABLE “sallyc".t1 row size = 8 number of columns = 1 index size = 0 }
create table “sallyc?.t1
(
c1 integer
) fragment by expression
(c1 < 100 ) in db1 ,
((c1 >= 100 ) AND (c1 < 200 ) ) in db2 ,
remainder in db4
extent size 16 next size 16 lock mode page;
revoke all on “sallyc".t1 from “public";

The following dbschema output shows information about partitions in partition-fragmented tables.

DBSCHEMA Schema Utility grant dba to "sqlqa";
{ TABLE "sqlqa".t1 row size = 24 number of columns = 2 index size = 13 }
create table "sqlqa".t1 
(
c1 integer,
c2 char(20)
)
fragment by expression 
partition part_1 (c1 = 10 ) in dbs1 ,
partition part_2 (c1 = 20 ) in dbs1 ,
partition part_3 (c1 = 30 ) in dbs1 ,
partition part_4 (c1 = 40 ) in dbs1 ,
partition part_5 (c1 = 50 ) in dbs1 
extent size 16  next size 16 lock mode page;