Hi all,

Am currently trying to write a "generic" or "universal" that I can use for both
Oracle and DB2 to do some sort of history growth plus recording some database
information bit.

Am done with the Oracle flavour and is now currently doing the DB2 flavour, can
someone tell me what is the equivalence of the following DB2 information that I
am looking for:

I got the INSTANCE_NAME, and DATABASE_NAME sorted, I want to know if I can get
these other informations via any DB2 commands:

CREATED - that is when was the database created, reset, etc.
LOG_MODE - is the database in NOARCHIVELOG or ARCHIVELGO
PLATFORM_NAME - the server info that is running on, can possibly get away with
this using uname
OPEN_MODE - in Oracle, this is whether the database is READ-WRITE or MOUNTED
like when it is a standby database

Disregard, RUNNO and RUNTIME, they're user-defined. Thanks in advance.


SQL> desc info_database
Name Null? Type
----------------------------------------- -------- ----------------------------
INSTANCE_NAME VARCHAR2(16)
DATABASE_NAME VARCHAR2(30)
CREATED DATE
LOG_MODE VARCHAR2(12)
PLATFORM_NAME VARCHAR2(101)
OPEN_MODE VARCHAR2(10)
RUNNO NUMBER
RUNTIME DATE



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