Good Morning:

You need to make a time-consuming in a DB2 database, which generates a lot of logs which is unnecessary, as the logs off


Thanks

What is your question/problem?

Thanks

I do not Know the command for disable the logs, until finish an activity, that generate lot logs unnecesary

OS is . AIX

Check this technote:
https://www-304.ibm.com/support/docv...id=swg21215818

logs records are not unnecessary. Any DBMS writes out log records for any change to the database in order to ensure recoverability and integrity. If you have a process that is writing a ton of log records and is causing your logs to fill, but they cannot be archived, because your thread is still running, that is another issue. There are a couple of ways around that issue. Have you considered LOAD? If it is a process that for some reason you feel cannot be handled with load, then issue periodic commits during your processing to free up the log files.
Dave