<No Subject Supplied>

>From naomi Wed Jun 30 11:02:55 MST 1993 remote from qip From: naomi@qip (Naomi Walker) Message-Id: <9306301802.AA24837@qip> Received: from qip by misty.anasazi.com; Wed, 30 Jun 93 11:02:57 MST Received: by qip (5.61/1.2) (from naomi (Naomi Walker) to informix-list@rmy.emory.edu) id AA24837; Wed, 30 Jun 93 11:02:55 -0700 Subject: Re: logging To: informix-list@rmy.emory.edu (Informix List) Date: Wed, 30 Jun 93 11:02:55 MST In-Reply-To: <9306301616.AA00193@rmy.rmy.emory.edu>; from "carlton@alexis.attmail.com" at Jun 30, 93 4:08 pm X-Mailer: ELM [version 2.3 PL11] Content-Type: text Content-Length: 2251 > I can't remember the 4.1 OnLine syntax but in 5.0 you can with the "-l" flag. > > *HOWEVER* be aware of the following: > creating the db with logging from the beginning could be a big mistake. > The engine will begin a transaction from the beginning of the load and > will begin to fill the logical logs with the changes from the > transaction. The transaction will not be committed until the dbimport > is completed and as a result the logs wont be released even though they > have been archived off through a tbtape -c command. So you better have > PLENTY of logs for the load. > > It doesn't really make alot of sense (IMHO) to load with logs enabled for the > load anyway. You're going to want to do a level-0 archive as soon as you're > done with the load anyway so just do the following: > do your dbimport without the "-l" flag to get your database in. (BTW, > on the file you'll use for the import, created by the dbexport > utility, you can-and should-move the "***load table***" marker > from below any index statements for a table to just above the index > statements for that table. It's faster to load a table then create > the indexes than to load an indexed table) > go into the tbmonitor > take the engine to quiescent mode I have found it much easier to use tbtape to turn logging on and off. tbtape -s -N dbname turns logging off (tbtape asks you to do an archive. I change the archive device to /dev/null, and do a fake level 2 archive) tbtape -s -U dbname turns unbuffered logging on tbtape -s -B dbname turns buffered logging on All this can be done with the engine online. > change the archive tape device to /dev/null > run a level-0 archive -- with /dev/null device it's done in about 10 > seconds > change the archive tape to what ever you need it to be > change the logging on the database > put the engine back online if needed > run another level-0 archive. This will give you the image of the > engine and db you want. > -- Naomi Walker (aka N7FSA) naomi@anasazi.com Phoenix, Arizona To get the full value of joy, you must have someone to divide it with. ---Mark Twain