|
View previous topic :: View next topic
|
| Author |
Message |
EnjoyMF
New User
Joined: 27 May 2005
Posts: 88
|
|
|
|
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 |
|
 |
hariavinash
New User
Joined: 04 Jan 2006
Posts: 64
|
|
|
|
look for the TSNAME field in the SYSIBM.SYSTABLES TABLE.
cheers |
|
| Back to top |
|
|
surya_pathaus
Active User
Joined: 28 Aug 2006
Posts: 110
|
|
|
|
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 |
|
|
|
|
