Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Determining the table space of a table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Vinay Pushpala

New User


Joined: 06 Nov 2013
Posts: 21
Location: India

PostPosted: Fri May 23, 2014 7:53 pm    Post subject: Determining the table space of a table
Reply with quote

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
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Fri May 23, 2014 8:08 pm    Post subject: Reply to: Determining the table space of a table
Reply with quote

Actually, my readng of it is that it is not type LOB (or member or large)
Back to top
View user's profile Send private message
Vinay Pushpala

New User


Joined: 06 Nov 2013
Posts: 21
Location: India

PostPosted: Mon May 26, 2014 12:38 pm    Post subject:
Reply with quote

@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
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 186
Location: chennai

PostPosted: Tue May 27, 2014 10:44 pm    Post subject: Reply to: Determining the table space of a table
Reply with quote

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
View user's profile Send private message
singhju

New User


Joined: 01 Dec 2010
Posts: 25
Location: Gurgaon

PostPosted: Wed Jun 18, 2014 4:41 pm    Post subject:
Reply with quote

Yes, it is segmented table space.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Wed Jun 18, 2014 9:17 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm
No new posts Getting soc4 on internal table in cobol abdulrafi COBOL Programming 13 Fri May 06, 2016 3:39 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us