For DB2/UDB, a good place to start would be to get the database manager's settings:

db2 get dbm cfg


Also, for any databases created (after establishing a connection to that database)

db2 get db cfg for yourdatabasenamegoeshere

DB2 is much less complicated to get your arms around than Oracle.

It's a piece of cake!
Michelle

-----Original Message-----
From: Joe Philip
[Email address protected]
Sent: Tuesday, May 18, 2004 6:55 AM
To: LazyDBA Discussion
Subject: documenting the DB2 environment


I am new to DB2 (moving from Oracle to DB2). I am trying to document our
new DB2 environment. Do any of you have a format/basic environment details
template which you can share with me.

Basically, I am looking for what items to document.

For example, in an Oracle world, I document things like: SGA size, OFA
compliance, redo log multiplexed or not, databases in archive log mode,
location of redo and archive logs, control files, types of backups (offline,
online, export etc.)





---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe, e-mail: [Email address protected]
For additional commands, e-mail: [Email address protected]


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