Re: Moving txn log between machines
Scott Boake <scott@palan.uucp> writes - ( S> = Scott, T> = me ) S> Is there a way with the 4.1 On-Line I can tell it to start a new transaction S> log file without interuppting operations? T> T> With standard engine, yup: T> T> START DATABASE foobar WITH LOG IN "/usr/trans_log" Sorry, I misunderstood. You can only restart the log if no-one else has got the DB open. If you can ensure a gap of a few seconds where the DB is closed by all, no problem. Otherwise, problem. S> If I archive the [OnLine Logs] to disk, can this be a normal S> disk file? Can I give it a S> bogus tape dev name to write to a normal file this way? I get the impression that this is just fine if you do an auto-backup, and all the logs fit (in the file you've named) on the disk partition. If it asks you to change tapes, you're stuck. I.e. specify a large tape size in the tbmonitor screen. I don't see an automatic way of doing this, tho'. Any takers ? I suppose you could write the whole lot down a named pipe and write new files every 10MBytes or so, but you'd have to do the exact compliment to get the stuff back. Seriously ugly. Also, does the other DB have to be waiting in "restore" mode ? S> The drives will be SCSI on a caching host adapter. Both machines will also S> have duplxed SCSI systems. Two HAs, two HDs. But totaly seperate from one S> another. There will be approx 20 scanning stations for shipping (the whole S> use of this system) connected to digiboard cluster controllers. In case of a S> failure of machine A, pull three cables and attach them to machine B. And S> this looks like we'll do it with AB switches. Now we gotta keep the data S> base in line. S> Our through put is kinda low. On an average station, they handle a package S> every 10-15 seconds. So 20x4 = 80. transactions/min. S> The DB size is about 400 MB now. I can see it doubling within S> a year. S> Scott Boake Palantir Systems, Inc. S> scott@palan 5030 - 78th Ave N Ste 11 S> (813) 544-8152 Pinellas Park, FL 34665 -- Cheers - Tony. ____________________________________________________________________________ Tony Heskett: theskett@lhr-sys.ssf-sys.dhl.com | Vox: (+44) 81 747 8330 DHL Systems : Kings House, Great West Road, TW8 9HS | Fax: (+44) 81 747 0875