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
 

 

How to find Table-space and Index-space files for a table?

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

New User


Joined: 20 Jun 2015
Posts: 26
Location: INDIA

PostPosted: Wed Feb 03, 2016 6:16 pm    Post subject: How to find Table-space and Index-space files for a table?
Reply with quote

Hi all,

I have a huge list of tables for which I am required to find the table-space and index-space files. Currently I am using BMC tool to find this information.

There are SYSIBM.SYSTABLESPACE and SYSIBM.SYSINDEXES tables. I believe there is a pattern for the names of relevant VSAM files. If there is a method I can use these details from these tables and form the file names, it will be great. I wouldn't argue to stick to my assumption if you advise me another efficient way to achieve this.

Kindly share your expertise.

Thanks,
Sivaguru
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Thu Feb 04, 2016 9:46 am    Post subject:
Reply with quote

Talk to your DBA they should know the HLQ of those datasets.
Also, There should be an option within BMC to find those filenames. I am not sure though.

But, having said that just curious what are going to do knowing the file names.
Back to top
View user's profile Send private message
venksiv

New User


Joined: 20 Jun 2015
Posts: 26
Location: INDIA

PostPosted: Thu Feb 04, 2016 6:55 pm    Post subject:
Reply with quote

Thanks for your suggestion, Pandora-Box.

I am going to calculate the space occupied by these particular tables for another analysis.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Thu Feb 04, 2016 8:20 pm    Post subject:
Reply with quote

I get it the EXTENTS will be needed and watched by DBAs regular intervals

As said get in touch with DBA they should be able to assist you
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Fri Feb 12, 2016 5:40 pm    Post subject:
Reply with quote

http://itknowledgeexchange.techtarget.com/itanswers/tables-in-db2-z-os/

Quote:
high level qualifier . DSNDBx . data base name . space name . I000x. A00x
where
high level qualifier depends on your installation and VCAT name, and DB2 STOGRP definitions
Back to top
View user's profile Send private message
venksiv

New User


Joined: 20 Jun 2015
Posts: 26
Location: INDIA

PostPosted: Fri Feb 12, 2016 9:08 pm    Post subject: Reply to: How to find Table-space and Index-space files for a table?
Reply with quote

Hi GuyC,

100% true. To find this, I took 4-5 table names, found their table space names from systables and compared to the dataset BMC tool displayed for 'ds' line command. That pattern matches to your answer.

Thank you so much for your response. This is brilliant!

I will have to do the same for index space datasets and use it for further analysis.
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 High CPU consumption Job using IAM fi... aswinir JCL & VSAM 8 Thu Dec 01, 2016 8:28 pm
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm
No new posts Find out a active PGM jpsager JCL & VSAM 10 Fri Oct 07, 2016 4:32 pm


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