Hi everyone, First time post here. I'm guessing this is an old topic, but
having trouble finding the right answer.

I have a small table with about 100,000 rows. If I do "delete from
table_name" it fails with the "TTSQL error -964:[DataDirect][ODBC DB2 Wire
Protocol driver][UDB DB2 for Windows, UNIX, and Linux] The transaction log
for the database is full." error message.

I can selectively delete small groups of records until I get it down to
around 10.000 rows, then sometimes it will let me finish with the 'delete
from table'.

I've got the following cfg (which was just changed from values 1024, 3, 2):

Log file size (4KB) (LOGFILSIZ) = 4096
Number of primary log files (LOGPRIMARY) = 10
Number of secondary log files (LOGSECOND) = 5

with logs files as shown:

/db2/db2inst1/db2inst1/NODE0000/SQL00002/SQLOGDIR
$ ls -l
total 40080
-rw------- 1 db2inst1 db2iadm1 4104192 Jun 26 09:52 S0000000.LOG
-rw------- 1 db2inst1 db2iadm1 4104192 Jun 26 09:42 S0000001.LOG
-rw------- 1 db2inst1 db2iadm1 4104192 Jun 26 09:43 S0000002.LOG
-rw------- 1 db2inst1 db2iadm1 4104192 Jun 26 09:43 S0000003.LOG
-rw------- 1 db2inst1 db2iadm1 4104192 Jun 26 09:43 S0000004.LOG

Does DB2 have to be bounced for the changes to take effect? Is there a
cleaner way to manage the transaction logs? I'm also having trouble
loading mass rows (around 200,000) into the tables.

Thanks!

Gary P. Canedy
Database Analyst
ProMutual Group
(617) 757-6775





-----------------------------------------------------------
This email and any files transmitted with it are intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. If you received this email in error, please
contact the sender immediately and delete this email from your system. If
you are not the named addressee, you should not disseminate, distribute,
print, or copy the email, or take any action in reliance on its contents.


DB2 & UDB email list listserv db2-l LazyDBA home page