Re: loading large *.unl file into database with logging

---- you wrote: > I have this problem where we have a table with millions of rows we no longer > need, we only need the last 500,000 rows or so. I planned on writting a > script for our operators to run out of hours which would; > > 1. unload the data we want to retain. > 2. drop the existing table > 3. create the table with no indexes > 4. load the *.unl file into the empty table > 5. add the indexes. > > The problem I have is that we have unbuffered logging enabled on this > database, and loading this one file causes the log space to be exhausted. > > I know that I can use ontape -n <database name> to turn logging off, and > later enable it again using ontape -s -l 0 -n <database name>. I was > wondering if there was a way to perform this load without disabling logging > only for that particular table, similar to the WITH NO LOG option for temp > tables. Sure Dude, but only with version 7.31 or 8.x. They are called RAW tables and they are not logged. Once you have loaded the table you can convert it to a STANDARD table, which is logged. I don't think you can have contraints defined though. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com