|
View previous topic :: View next topic
|
| Author |
Message |
sreedhar79in
New User
Joined: 01 Aug 2006
Posts: 2
|
|
|
|
| Aim going to RE-ORG the tables,so i want to check the DB2 table Extents(How many space it occupy).I don't know the command to find the DB2 table extents. |
|
| Back to top |
|
 |
MFRASHEED
Active User
Joined: 14 Jun 2005
Posts: 186
Location: USA
|
|
|
|
In DB2 catalog table SYSIBM.SYSTABLEPART look for column EXTENTS
which provide the information.
Another way is via PLATINUM utility:
Enter the TABLESPACE name and use LC (LISTCAT) and look for column XT:
| Code: |
RQTSL R11 ------------ RC/Q Table Space List ------------ 05-08-2007 09:28
COMMAND ===> SCROLL ===> PAGE
DB2 Object ===> TS Option ===> L
Table Space ===> TESTTS Creator ===> * Where => N
Data Base ===> * Grantor ===> *
Loc: LOCAL ---------- SSID: DBTU ----------xxxx ---- LINE 01 OF 18 >
CMD NAME CREATOR CREATEDBY DATABASE BPOOL PART PGZ STS N. TBLS
_LC____ TESTTS DBXX DBXX TESTDB01 BP3 4 4K A 1
|
|
|
| Back to top |
|
|
Frederic Lavoie
New User
Joined: 07 May 2007
Posts: 6
Location: Ottawa
|
|
|
|
| I think a stospace should has been ran prior to update the information in the catalog. |
|
| Back to top |
|
|
|
|
