Edwin,
Use the db2look utility for example
db2look -l -x -e -a -d dbname >ddl.out
more ddl.out
Tom

-----Original Message-----
From: Edwin Uy
[mailto:db2udbdba-ezmlmshield-x31454021.[Email address protected]
Sent: 29 September 2004 11:29
To: LazyDBA Discussion
Subject: DB/Instance


Hi all,

Does anyone out there have a script that I can use to list the
configuration of my INSTANCE/DATABASE, even just for the database, i.e.,
what tablespaces are in my database, what datafiles are included in each
tablespaces etc.,

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


***************************************************************
The information transmitted in this email is intended for the
addressee only and may contain confidential and/or
privileged material. Any review,retransmission,dissemination,
reliance upon or other use of, this information by persons
or entities other than the addressee is prohibited.
If you received this in error, please contact the sender and
delete the material.

This message has been swept by Anti-Virus software
***************************************************************


DB2 & UDB email list listserv db2-l LazyDBA home page