A question about "TBLSPACE TBLSPACE"
Dear All...
while I run "onmode -pe" , I see a lot of tables and their extensions ,
I know what "physical page","logical page","Partition partnum" means ,
for example, the partnum of stores7:customer is 0x200251 , it means that
the partition page of stores7:customer is in dbspace 2,and the
logical page number of "TBLSPACE TBLSPACE" would be page 0x251 ,and then
match this number to the "oncheck -pe" output,
count the "TBLSPACE TBLSPACE" Start and Length with patience,
you'll get the exact physical page address of the stores7:customer's
partition page ~~
The following is the "TBLSPACE TBLSPACE" part of the "oncheck -pe" output ,
TBLSPACE TBLSPACE 13 50
TBLSPACE TBLSPACE 232475 50
TBLSPACE TBLSPACE 232981 50
TBLSPACE TBLSPACE 3 50(chunk2)
TBLSPACE TBLSPACE 602 50
TBLSPACE TBLSPACE 24712 50
TBLSPACE TBLSPACE 30866 50
TBLSPACE TBLSPACE 33452 50
TBLSPACE TBLSPACE 40507 50
TBLSPACE TBLSPACE 41234 50
TBLSPACE TBLSPACE 42248 50
TBLSPACE TBLSPACE 160405 50
TBLSPACE TBLSPACE 194759 50
TBLSPACE TBLSPACE 195561 50
TBLSPACE TBLSPACE 543208 50
TBLSPACE TBLSPACE 544043 50
TBLSPACE TBLSPACE 546213 50
TBLSPACE TBLSPACE 550183 50
TBLSPACE TBLSPACE 565425 50
TBLSPACE TBLSPACE 568475 100
What I am curious is that , the "TBLSPACE TBLSPACE" is which table's Extents ?!
for example : oncheck -pt stores7:customer showes
Extents
Logical Page Physical Page Size
0 284cf3 8
It showes this table has only one Extends,which has 8 pages in it,
so , I think there maybe exist a table , which I can do
oncehck -pt DBS:TBS , and then showes "TBLSPACE TBLSPACE" above as
Extends output !!~~
Forgive me for poor english , any comments are welcome ~~
Sorry ... I get it ~~~~
oncheck -pt 0x100001 , oncheck -pt 0x200001to get the "TBLSPACE TBLSPACE" of dbspace 1 and 2 ~~~
Sorry again ..
The tablespace tablespace tracks the actual tables.
Paul Watson
Tel: +1 913-400-2620
Mob: +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
If you want to improve, be content to be thought foolish and stupid.
It is better to be criticized by a wise person than to be praised by a fool.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MARS
CHEN
Sent: Tuesday, August 26, 2008 10:19 PM
To: ids@iiug.org
Subject: A question about "TBLSPACE TBLSPACE" [13217]
Dear All...
while I run "onmode -pe" , I see a lot of tables and their extensions ,
I know what "physical page","logical page","Partition partnum" means ,
for example, the partnum of stores7:customer is 0x200251 , it means that
the partition page of stores7:customer is in dbspace 2,and the
logical page number of "TBLSPACE TBLSPACE" would be page 0x251 ,and then
match this number to the "oncheck -pe" output,
count the "TBLSPACE TBLSPACE" Start and Length with patience,
you'll get the exact physical page address of the stores7:customer's
partition page ~~
The following is the "TBLSPACE TBLSPACE" part of the "oncheck -pe" output ,
TBLSPACE TBLSPACE 13 50
TBLSPACE TBLSPACE 232475 50
TBLSPACE TBLSPACE 232981 50
TBLSPACE TBLSPACE 3 50(chunk2)
TBLSPACE TBLSPACE 602 50
TBLSPACE TBLSPACE 24712 50
TBLSPACE TBLSPACE 30866 50
TBLSPACE TBLSPACE 33452 50
TBLSPACE TBLSPACE 40507 50
TBLSPACE TBLSPACE 41234 50
TBLSPACE TBLSPACE 42248 50
TBLSPACE TBLSPACE 160405 50
TBLSPACE TBLSPACE 194759 50
TBLSPACE TBLSPACE 195561 50
TBLSPACE TBLSPACE 543208 50
TBLSPACE TBLSPACE 544043 50
TBLSPACE TBLSPACE 546213 50
TBLSPACE TBLSPACE 550183 50
TBLSPACE TBLSPACE 565425 50
TBLSPACE TBLSPACE 568475 100
What I am curious is that , the "TBLSPACE TBLSPACE" is which table's Extents
?!
for example : oncheck -pt stores7:customer showes
Extents
Logical Page Physical Page Size
0 284cf3 8
It showes this table has only one Extends,which has 8 pages in it,
so , I think there maybe exist a table , which I can do
oncehck -pt DBS:TBS , and then showes "TBLSPACE TBLSPACE" above as
Extends output !!~~
Forgive me for poor english , any comments are welcome ~~
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.