12-22-03, 22:46 #1Registered User
- Join Date
- Dec 2003
Unanswered: How can I clear the DB2 Transaction log
How can I empty the log.
one more thing, following is my DB cfg, it was supposed to use 'cycle log' but why I always get 'log full' message.
thanks a lot
Degree of parallelism (DFT_DEGREE) = 1
Log retain for recovery status = NO
User exit for logging status = NO
Log file size (4KB) (LOGFILSIZ) = 1000
Number of primary log files (LOGPRIMARY) = 3
Number of secondary log files (LOGSECOND) = 2
[db]$ db2 "refresh table fact6d1pcube"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0964C The transaction log for the database is full. SQLSTATE=57011
12-22-03, 23:05 #2Registered User
- Join Date
- May 2003
The circular logs can be reused after all transactions have committed. If the amount of logging in a unit of work of an SQL statement (commit scope) is too large for the log size you specified, you will get the error you received. You need to increase the number of logs (I would double them), and the size of each log (I would increase the size by a factor of 10). That would make each log file 40 MB, which is not much disk space.M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390