Hi Raoul,
LIST TABLESPACES [SHOW DETAIL]
db2 LIST TABLESPACES show detail
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 140000
Useable pages = 139968
Used pages = 37696
Free pages = 102272
High water mark (pages) = 39232
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 2
LIST TABLESPACE CONTAINERS FOR tablespace-id [SHOW DETAIL]
db2 LIST TABLESPACE CONTAINERS FOR 0 show detail
Tablespace Containers for Tablespace 0
Container ID = 0
Name =
/db2/DWP/dwpdata/p01/SYSCATSPACE.container001
Type = File
Total pages = 70000
Useable pages = 69984
Accessible = Yes
Container ID = 1
Name =
/db2/DWP/dwpdata/p01/SYSCATSPACE.container002
Type = File
Total pages = 70000
Useable pages = 69984
Accessible = Yes
Best regards
Joachim M�ller
--
DOUGLAS Informatik & Service GmbH
Datenbankmanagement
Douglas Holding AG, Kabeler Str. 4, 58099 Hagen
Tel.:+49-2331-690-249,Fax:+49-2331-690-78-249
Mobile: +49-170-2221-249
--------------------------------+----------------------------------------------------------------------------
[EMAIL PROTECTED]|
nair.com| An: [EMAIL PROTECTED]
Gesendet von:| Kopie: [EMAIL PROTECTED]
[EMAIL PROTECTED]| Thema: [DB2EUG] container
rg|
|
|
10.02.2003 15:53|
Bitte antworten an|
Raoul.Joemman|
|
--------------------------------+----------------------------------------------------------------------------
Hi all,
We use DB2 v7.2 on AIX.
I want to now the location of the container for a tablespace. I see the
location if I use control center.
But I want to use the location from a ksh script.
I tried "db2 list tablespaces show detail", and I searched the catalog
"syscat.tablespaces". But I didn't
find it.
How do I find out the location for the container?
Regards
Raoul
*****************************************************************
This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only.
If you are not the addressee, you are notified that no part of
the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail
or attachment is strictly prohibited, and may be unlawful.
If you have received this e-mail by error, please notify the
sender immediately by return e-mail, and delete this message.
Martinair Holland N.V., its subsidiaries and/or its employees
shall not be liable for the incorrect or incomplete transmission
of this e-mail or any attachments, nor responsible for any
delay in receipt.
*****************************************************************
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
