Hi,

I need to import delimited text file into a table. The error message was: "SQL0964C The transaction log for the database is full. SQLSTATE=57011"

I did the following:
1. alter table ABC activate not logged initially /* Turn off logging first */
2. import from <file> of del insert into ABC /* Insert the table */

Why do I still have log full problem?

Thank you very much!
Ado


DB CFG:
LOGPRIMARY = 3
LOGSECOND = 100
LOGFILSIZ = 1024


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