ONCONFIG for logical logs to disk

What should the ONCONFIG file look like if you plan to save logical logs to disk? Can the logical logs be sent to a unix directory? or does it have to be a block device? In either case, what should the values of the LTAPEDEV, LTAPEBLK and LTAPESIZE be?

Paul Jazwierski <uszko@earthlink.net> writes: > What should the ONCONFIG file look like if you plan to save logical logs > to disk? Can the logical logs be sent to a unix directory? or does it > have to be a block device? In either case, what should the values of the > LTAPEDEV, LTAPEBLK and LTAPESIZE be? You can set TAPEDEV and LTAPEDEV to a file (ie. /opt/informix/ltapedev_file). (You _will_ be asked to change tape when LTAPESIZE is met...) LTAPEBLK should probably bet the blocksize of your filesystem, and you _should_ rotate the logfile (a move and a touch could work, a _guess_ informix writes to the inode...). LTAPESIZE should be _less_ than your filesystems "max filesize". Thomas

I imagine what you're trying to say is that you want to back up the logical logs to disk, because the logical logs already reside on disk. The ONCONFIG file simply provides the number and size of the logical logs. When you first initialize your instance, all logical logs are created in rootdbs. It's up to you to place them in another dbspace afterwards. The parameters LTAPEDEV, LTAPEBLK, and LTAPESIZE only correspond to the ontape utility, which can be used to backup your logical logs. Ideally, ontape is used to back up to tape, not to disk. It can be done to disk, but it's tricky since unix filesystems only allow a limit of 2GB. If you want to back up your logical logs to disk, you can look into using onbar and a storage manager such as ISM (Informix Storage Manager). Onbar comes with versions 7.3x and up, so if you have at least that version, you can configure onbar to back up your logical logs as well as your archives to disk. Then you won't have to even worry about your tape parameters in your ONCONFIG, except to make sure that your LTAPEDEV doesn't point to /dev/null. Paul Jazwierski wrote: > What should the ONCONFIG file look like if you plan to save logical logs > to disk? Can the logical logs be sent to a unix directory? or does it > have to be a block device? In either case, what should the values of the > LTAPEDEV, LTAPEBLK and LTAPESIZE be? -- Phillip Tien Database Administrator Whole Foods Market, Inc. Sometimes I think you have to march right in and demand your rights, even if you don't know what your rights are, or who the person is you're talking to. Then on the way out, slam the door.