Disable Archive log files in db2

jagadeesh_db2 · #1 (**permalink**) 05-09-11, 03:00

Hi All,

I want to disable Archive Log in DB2 V9 in Windows. What is the procedure to disable this.
I did some R&D on that but its not clear to me.

Thanks in advance
Jagadeesh

n_i · #2 (**permalink**) 05-09-11, 08:01

Set LOGARCHMETH1 to OFF

jamiforyou · #3 (**permalink**) 05-17-11, 03:13

Quote:

Originally Posted by jagadeesh_db2

Hi All,

I want to disable Archive Log in DB2 V9 in Windows. What is the procedure to disable this.
I did some R&D on that but its not clear to me.

Thanks in advance
Jagadeesh

you can use below mention command to disable archive log

update db cfg for (database name) using logarchmeth1 off

Jamil

Internet Services

Web Development

Digital Marketing

Consumer Tech