Re: DB2LOOK & Tablespace Cont

When it was created, was any path (USING) clause specfied? There is a 
default it will use. I just tried the command and did get the USING data, 
and I know I specified the data when I created the database. DB2 
v7.1.0.68


JG> I am executing the following command:

JG> db2look -d database -e -l -o database.out

JG> and when the create tablespace ddl is generated I get the following
JG> which is missing all of the container information.

JG> CREATE REGULAR TABLESPACE USERSPACE1 IN NODEGROUP DATA_NODE_9 PAGESIZE
JG> 4096 MANAGED BY SYSTEM
JG> EXTENTSIZE 16
JG> PREFETCHSIZE 32
JG> BUFFERPOOL IBMDEFAULTBP
JG> OVERHEAD 24.100000
JG> TRANSFERRATE 0.900000;

JG> Any help would be appreciated.

Edward Lipson via Relaynet.org Moondog
[EMAIL PROTECTED] [EMAIL PROTECTED]
---
 þ MM 1.1 #0361 þ Fact of life #15: Heads bleed, walls don't.