Skip to Content
Former Member
Feb 24, 2014 at 01:48 PM

Disable log files in DB2



I installed a SAP ERP 6.0 EHP7 in Windows Server 2012 with DB2 database (version 10.1). I need to run the SGEN transaction which create a lot of log files... so how can I disable the transaction logs / archive logs in DB2 database such as I do for example in Oracle databases using the following NOARCHIVELOG mode command switch::

login as ora<sid>

sqlplus "/as sysdba"

startup mount;

alter database noarchivelog;

alter database open;

Then start SAP and by this way archive log is off.

I can also verify that whether databse is in archive log mode or noarchive log mode by below command: select log_mode from v$database;

How to do this for the DB2 databases?! Can you tell me please?

Thank you in advance,

samid raif