(1)使用如下语句:
select * from sysptnext
where pe_partnum = <myPartitionNumber>;
或
select *, hex(pe_partnum) hex_partnum from sysptnext
where hex(pe_partnum) = <myHexPartitionNumber>;
例如:
select * from sysptnext
where pe_partnum = 15728642;
或
select *, hex(pe_partnum) hex_partnum from sysptnext
where hex(pe_partnum) = '0x00F00002';
(2)使用如下语句: select * from systabextents where te_partnum = <myPartitionNumber>; 或 select *, hex(te_partnum) hex_partnum from systabextents
where hex(te_partnum) = <myHexPartitionNumber>; 例如: select * from systabextents
where te_partnum = 15728642; 或 select *, hex(te_partnum) hex_partnum from systabextents
where hex(te_partnum) = '0x00F00002';
添加新评论0 条评论