active log file number

udbdb2 · #1 (**permalink**) 10-31-06, 19:30

Is there anyway to find the active log other than "fist active" in system catalog tables ?
TIA

ARWinner · #2 (**permalink**) 11-01-06, 08:23

Please specify DB2 version and OS.

Under DB2 8.x for LUW, you can use the GET DB CFG command.

HTH

Andy

oraora · #3 (**permalink**) 11-01-06, 16:14

What we are looking for is some system tables we can query if those tables are keeping track of active/archive log file numbers.

ARWinner · #4 (**permalink**) 11-01-06, 16:35

As far as I know, there is no table in the catalog that contains this. Since you are on 8.2, you can do this:

CALL SYSPROC.GET_DB_CONFIG()
SELECT LOGHEAD from SESSION.DB_CONFIG FETCH FIRST 1 ROW ONLY

HTH

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech