Re: [5.03 ADMIN] increasing Logical Logs

J. David Schronce (david@stat_edi.cssnet.sanford.nc.us) wrote: : newby question #432: : I'm running Online 5.03 with a tbconfig file that was setup by my : VAR when we got this machine. It has WAY to few and WAY too small : logical logs specified. : I've modified tbconfig, archived, stopped informix, rebooted, : restarted informix, etc... in all kinds of combinations, but the number : and size of logical logs remains unchanged... : H E L P !!!! : A cookbook explanation of the process of having modifications to : tbconfig actually affect the engine would be _GREATLY_ appreciated. : I've read the Admin guide until it no longer makes sense... David, Just modifying the tbconfig files won't do it. You've got to actually create the logfiles, either using tbmonitor, parameters, logfiles options or by using the tbparam program. After you create the new logs, you need to do an archive to make them effective. You can **only** increase the number of logs, not the size. You have a maximum of about 60 logs. If this doesn't give you enough logfile space, you'll have to reinitialize the database, which is essentially a complete db format and system rebuild.....not for the novice. Note that you can set your archive device to /dev/null and make the archives happen immediately. Joe : __ _ _ __ _ >> : | \\ __ ___ ___ __| | / _| __| |_ _ _ ___ _ _ __ ___ << : | | / _' \\ ' | / _' | \\_ \\/ _| ' \\| '_/ _ \\ ' \\/ _/ -_) C|~~| : |__/\\__,_|\\_/|_\\__,_| |__/\\__|_||_|_| \\___/_||_\\__\\___| `--' -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) Dallas, Texas author of: INFORMIX DBA Survival Guide from Prentice-Hall/Informix Press ISBN 0-13-124314-4 (12431-3) Now available in bookstores orders: orders@prenhall.com (515) 284-6761 fax (515) 284-2607 ----------------------------------------------------------------------------