|
View previous topic :: View next topic
|
| Author |
Message |
Vinay Pushpala
New User
Joined: 06 Nov 2013
Posts: 21
Location: India
|
|
|
|
Hi all,
I have been working on IMS for 2 years & I am a little weak in DB2 right now.
I am trying to find out the table space of a table.
The following is the DDL of the table:
| Code: |
SET CURRENT SQLID='ABCDEF';
CREATE TABLESPACE TABLE1
IN CPEDFIG
USING STOGROUP CPEDFIG
PRIQTY 3000 SECQTY 752
ERASE NO
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
SEGSIZE 4
BUFFERPOOL BP0
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
COMMIT;
|
The above DDL has SEG SIZE parameter greater than 0.
Is it a Segmented table space ?
If so, I can see the following information in DB2 admin panel.
| Code: |
TS owner : ABCDEF TS name : TABLE1
Created by : IN1234 Created Timestamp : 2002-04-23-15.5
Max rows/page : 255 Altered Timestamp : 2002-04-23-15.5
Descriptor ID : 532 TS ID (PSID) : 533 Database
Partitions : Not part. Page size KB : 4 Tables in
Segment size : 4 Encod. scheme : E Lock max
SBCS CCSID : 0 DBCS CCSID : 0 Mixed CCS
Clone : No Max partitions: 0
Table space type : Not MEMBER, Large, or LOB
Table space status : Available
TS allocation status : Table space was explicitly created
Buffer pool name : BP0
Lock size for TS : ANY - Lock scope is determined by DB2
Close rule for data set : Y - Data sets are closed after use
Erase rule for data set : N - Data sets are not erased by DROP |
In the above parameters, the type says it is of LOB.
Could anyone help me on determining the kind of table space the above one is ?
If the information is not sufficient, I would post it in the page if needed. |
|
| Back to top |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
| Actually, my readng of it is that it is not type LOB (or member or large) |
|
| Back to top |
|
|
Vinay Pushpala
New User
Joined: 06 Nov 2013
Posts: 21
Location: India
|
|
|
|
@Nic, Thanks for your view..
But when the SEGSIZE is more than 0, (when it has a value, in multiples of 4) it should be Segmented Table Space right ? |
|
| Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008
Posts: 193
Location: chennai
|
|
|
|
As Nic mentioned, it is not a LOB ts. For getting more clarity, you can query the SYSIBM.SYSTABLESPACE table and check for the column 'TYPE'. As per the DB2 manual
TYPE CHAR(1) NOT NULL WITH DEFAULT
The type of table space:
blank The table space was created without any of the following options: DSSIZE, LARGE, LOB, and MEMBER CLUSTER.
I The table space was defined with the MEMBER CLUSTER option and is not greater than 64 gigabytes.
K The table space was defined with the MEMBER CLUSTER option and can be greater than 64 gigabytes.
L The table space can be greater than 64 gigabytes.
O The table space was defined with the LOB option (the table space is a LOB table space). |
|
| Back to top |
|
|
singhju
New User
Joined: 01 Dec 2010
Posts: 25
Location: Gurgaon
|
|
|
|
| Yes, it is segmented table space. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| If you have a BMC utility then you can find it there and I am sure the other tools does provide thatas well .However, why don't you just send an email and ask to the corresponding DBA's at your shop as they can tell you exactly what you want? |
|
| Back to top |
|
|
|
|
