Hi DB2 gurus,
I am very new to DB2, I would like to place these two question :
1) The ' log file ' information like log file name, location, its size from the tables/views, but not from this command ' GET DATABASE CONFIGURATION ' .

2) The instance information like name , status, uptime from a table or view.


Thanks in advance.
Regards
Chenna

Sorry,
I missed this:

How to get the log and Instance information from a table/view.

Regards
Chenna

Hi,

You can use the Configure Database Logging Wizard available from the control center-- >tools-->wizards options to see the necessary information.

You can use the below command to get the instance information.

get dbm cfg

Hope that helps

nitin

Thank You Nitin.

DB2 doesn't store the Instance or Log file information in a table . am I right ?
My intention was to get the log/instance info from a table or a view.
Is it possible to get the same?

Regards
Chenna

If you are on V8, you may be able to use table functions for a few of these ...

HTH

Sathyaram