Transaction Log Mode

Sophie Hsiao · #1 (**permalink**) 02-23-04, 14:56

Hi all,

Can anybody tell me how I can check the value of 'Transaction Log Mode' in DB2 V7.2 on AIX platform?

Thank you so much !!

Sophie

Marcus_A · #2 (**permalink**) 02-23-04, 15:05

Do a:

GET DATABASE CONFIGURATION FOR database-alias SHOW DETAIL

If the following parameters are set like below, you have circular logging. If either one of these parms is set, you have forward recovery enabled.

Log retain for recovery status = NO
User exit for logging status =

See the Command Rerference for more information on this command.

Sophie Hsiao · #3 (**permalink**) 02-24-04, 10:45

Thank you so much !!

Internet Services

Web Development

Digital Marketing

Consumer Tech