Problem with Transaction-Log (SQLSTATE 57011) 
Author Message
 Problem with Transaction-Log (SQLSTATE 57011)
Hi,

Ive a new problem with my DB2 6.1, running on RedHat 6.1.
At importing some DEL-Files (size 27726623), I get an SQLSTATE 57011
(Transaction log full).
How to solve this problem, btw. to override the transaction log?

THX

Tom

+++ alles Gute +++ Tom

--- Scott me up Beamy ---



Fri, 22 Aug 2003 22:15:16 GMT
 Problem with Transaction-Log (SQLSTATE 57011)

Use the COMMITCOUNT on the import to commit more often.  You can also:
- use LOAD (LOAD is not logged by default)
- allocate more log space
Quote:

> Hi,

> Ive a new problem with my DB2 6.1, running on RedHat 6.1.
> At importing some DEL-Files (size 27726623), I get an SQLSTATE 57011
> (Transaction log full).
> How to solve this problem, btw. to override the transaction log?

> THX

> Tom

> +++ alles Gute +++ Tom

> --- Scott me up Beamy ---



Fri, 22 Aug 2003 23:10:35 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL1219N error / SQLSTATE=57011

2. How to cure SQLSTATE=57011 error?

3. transaction log size problem

4. Sql 7 , large transaction log problem.

5. msdb Transaction Log Problem

6. Database & Transaction Log On Same Device..Problem

7. odd transaction log problem

8. transaction log backup problems

9. SP2 on SQL2k and Win2K Cluster Transaction log backup problem

10. transaction log backup problem...

11. Problems with Transaction Log

12. Error logging unnaffected by transactions (like autonomous transaction in Oracle)


 
Powered by phpBB® Forum Software