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 know datasets belonging to the particular tablespace

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

New User


Joined: 27 May 2005
Posts: 88

PostPosted: Sun Oct 29, 2006 9:46 am    Post subject: How to know datasets belonging to the particular tablespace
Reply with quote

Hi all,

when i get -904 error i can see the Dataset related to the particular tablespace/index space.


is there any other way to know the datasets belonging to the particular tablespace/indexspace without tools and with tools(we have platinum,qmf,spufi) in our project


Cheers..prasad
Back to top
View user's profile Send private message

hariavinash

New User


Joined: 04 Jan 2006
Posts: 64

PostPosted: Mon Oct 30, 2006 7:53 pm    Post subject:
Reply with quote

look for the TSNAME field in the SYSIBM.SYSTABLES TABLE.

cheers
Back to top
View user's profile Send private message
surya_pathaus

Active User


Joined: 28 Aug 2006
Posts: 110

PostPosted: Tue Oct 31, 2006 6:56 pm    Post subject: Re: How to know datasets belonging to the particular tablesp
Reply with quote

Hi,

In Platinum select option 1.
This is under "Database Administration"
1 RC/QUERY.

Then you will get the screen where you need to mention your table name

DB2 Object ===> T
Option ===> L
Item Name ===> Table Name
Creator ===> DB2xxxx

It will give you Table space details.

If you give Option ===> I then you will get Index space details.
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 REXX to get the all datasets name parasmalik20 CLIST & REXX 5 Tue Jul 18, 2017 9:10 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm
No new posts DUMP DATASETS VS TRACE DATASETS! lind sh CICS 4 Tue Dec 06, 2016 11:31 pm
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm


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