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"
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,