| View previous topic :: View next topic |
| Author |
Message |
satyenderd
Beginner
Joined: 26 Aug 2005
Posts: 144
Topics: 73
|
 Posted: Mon Jul 07, 2008 2:49 pm Post subject: How to know the dataset name of Tablespace name thru FA |
 |
|
How to know the dataset name of the tablespace name using File-aid or R/C Query?
Thanks in advance
_________________
Satya |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12399
Topics: 75
Location: San Jose
|
| Posted: Tue Jul 08, 2008 10:34 am Post subject: |
|
|
satyenderd,
Query the sysibm.systables |
|
| Back to top |
|
|
Eric.C.Bakke
Beginner
Joined: 14 Jul 2008
Posts: 15
Topics: 0
Location: Plano, TX
|
| Posted: Mon Jul 14, 2008 12:23 pm Post subject: |
|
|
If you're talking about the linear VSAM dataset name of the tablespace, this can't be obtained from a simple query of sysibm.systables as stated by kolusu  .
The format of the VSAM Cluster dataset is as follows:
catname.DSNDBC.dbname.spname.I0001.Annn
~ or ~
catname.DSNDBC.dbname.spname.J0001.Annn
You can only get the 3rd and 4th nodes of the dataset which are the dbname, and tsname columns in sysibm.systables for a given table where name = 'your table name'.
To get the 1st node, query vcatname from sysibm.systablepart for the dbname and tsname found in sysibm.systables. The 2nd node is always DSNDBC for the cluster and DSNDBD for the data.
The 5th node is set to 'I0001' initially but can be renamed by DB2 Re-org Tablespace utilities during the switch phase to 'J0001' if the tablespace was online re-organized.
The last (6th) node of the dataset varies depending on the type of tablespace (simple, segmented, or partitioned). For simple and segmented, it will always start with 'A001' and increment by 1 depending on the amount of data in the tablespace.
Hope that helps and is what you were looking for. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
