I would include

1) db2set -all

2) Buffer pool size (select * from syscat.bufferpools)

to Victor's list ...


Sathyaram Sannasi
www.db2click.com
http://www.idug.org/forums/UserForumHome.asp


-----Original Message-----
From: Victor Michelle (Michelle)
[Email address protected]
Sent: 18 May 2004 15:20
To: LazyDBA Discussion
Subject: RE: documenting the DB2 environment


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]



---------------------------------------------------------------------
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]

**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of HPI Limited. If you are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited. If you received this email in
error, please immediately notify [Email address protected]

This message has been scanned by Panda Anti-Virus. Recipients are advised to
apply their own virus checks to this message on delivery.
**********************************************************************



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