Looks like it is a huge file. You might want to try doing the import in
stages. I mean, split your input file and then do it.

On Wed, January 16, 2008 2:57 pm, ado wrote:
> 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
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>



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