表信息

dbschema -ss 命令会检索有关分段表、锁定方式以及扩展数据块大小的信息。

以下 dbschema 输出显示了为分段表指定的表达式。

{ 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”;

以下 dbschema 输出显示有关分区分段表中的分区的信息。

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;