DIA8309C Log file was full and DB2 IMPORT

22 June,2010 by Jack Vamvas

Running the DB2 IMPORT statement below :
"import from MYTable.ixf of ixf messages msg.txt INSERT INTO MYSCHEMA.MYTABLE"
the error response in the DB2DIAG.LOG was :

Error from Import/Export or Load Processing
"Log File has reached its saturation point"
DIA8309C Log file was full.

One solution to this problem , is to use COMMITCOUNT , this allows a COMMIT after every n records are imported.
By amending the initial sql statement to :
"import from MYTable.ixf of ixf commitcount 100 messages msg.txt INSERT INTO MYSCHEMA.MYTABLE"
this allowed the the commitment after every 100 rows

 Ref:Jack Vamvas(http://www.dba-db2.com)

 

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DIA8309C Log file was full and DB2 IMPORT

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright