Oninit cdi / Archive
Talk to an expert →

Re: failed to backup logical logs

Posted in 2000

richard palmer — — source: Informix-list mailing list archive (1991-1998)

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> Ensure the onconfig parameters LTAPEDEV, LTAPEBLK and LTAPESIZE <br>are set then run <i>ontape -a </i>from the Informix shell from the NT server hosting <br>the Informix instance. <br>This will archive the contents of the logs allowing you to finish your import. The <br>parameters listed above can be set while the instance is up -- you do not need <br>to recycle the engine. <p>have a nice day. <p>vanloon wrote: <blockquote TYPE=CITE>Dear IDS users, <p>Recently I installed IDS 7.31 on Windows NT 4.0 SP 5 . <br>I am able to create a database; next I tried with DBimport to load <br>databases. <br>Soon the logical logfiles are full and therefore the server is blocked <br>during taking a checkpoint. <br>I tried to backup the logical log with "onbar -l". This command seems to <br>fail. <br>Still the logical logs are not freed&nbsp; and the server stays blocked. <br>How can I free the logical logs and what is wrong with my "onbar" command? <p>Thanks <p>vanloon@wxs.nl <p>&lt; onstat -a> <p>Informix Dynamic Server Version 7.31.TC4&nbsp;&nbsp;&nbsp; -- On-Line (CKPT REQ) -- Up <br>06:11:32 -- 9536 Kbytes <br>Blocked:CKPT <p>18:17:02&nbsp; Informix Dynamic Server Version 7.31.TC4&nbsp;&nbsp;&nbsp; Software Serial Number <br>AAC#J810402 <br>18:17:04&nbsp; Informix Dynamic Server Initialized -- Shared Memory Initialized. <br>18:17:04&nbsp; Physical Recovery Started. <br>18:17:04&nbsp; Physical Recovery Complete: 3 Pages Restored. <br>18:17:04&nbsp; Logical Recovery Started. <br>18:17:07&nbsp; Logical Recovery Complete. <br>&nbsp;0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks <p>18:17:08&nbsp; Dataskip is now OFF for all dbspaces <br>18:17:08&nbsp; Init operation complete - Mode Online <br>18:17:08&nbsp; On-Line Mode <br>18:17:19&nbsp; Logical Log Files are Full -- Backup is Needed <p>Physical Logging <br>Buffer bufused&nbsp; bufsize&nbsp; numpages numwrits pages/io <br>&nbsp; P-1&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.00 <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; phybegin physize&nbsp; phypos&nbsp;&nbsp; phyused&nbsp; %used <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10003f&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 27&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.00 <p>Logical Logging <br>Buffer bufused&nbsp; bufsize&nbsp; numrecs&nbsp; numpages numwrits recs/pages pages/io <br>&nbsp; L-1&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.0 <br>&nbsp;Subsystem&nbsp;&nbsp;&nbsp; numrecs&nbsp; Log Space used <br>&nbsp;OLDRSAM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32 <p>Buffer Waiting <br>Buffer&nbsp; ioproc&nbsp;&nbsp; flags <br>&nbsp; L-1&nbsp;&nbsp; c19a018&nbsp; 0x1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 <p>address&nbsp; number&nbsp;&nbsp; flags&nbsp;&nbsp;&nbsp; uniqid&nbsp;&nbsp; begin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; size&nbsp;&nbsp;&nbsp;&nbsp; used&nbsp;&nbsp;&nbsp; %used <br>c039be4&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; U------&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100233&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp; 100.00 <br>c039c00&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; U------&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1002b0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp; 100.00 <br>c039c1c&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; U------&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10032d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp; 100.00 <br>c039c38&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; U------&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1003aa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp; 100.00 <br>c039c54&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; U------&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100427&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp; 100.00 <br>c039c70&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; U------&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1004a4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp; 100.00 <br>c039c8c&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; U------&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100521&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp; 100.00 <br>c039ca8&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; U------&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10059e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp; 100.00 <br>c039cc4&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; U------&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10061b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp; 32.00 <br>c039ce0&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; U---C-L&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100698&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp; 100.00 <p>Profile <br>dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached <br>20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90.00&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.00 <br>isamtot&nbsp; open&nbsp;&nbsp;&nbsp;&nbsp; start&nbsp;&nbsp;&nbsp; read&nbsp;&nbsp;&nbsp;&nbsp; write&nbsp;&nbsp;&nbsp; rewrite&nbsp; delete&nbsp;&nbsp; commit <br>rollbk <br>26&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 <br>gp_read&nbsp; gp_write gp_rewrt gp_del&nbsp;&nbsp; gp_alloc gp_free&nbsp; gp_curs <br>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 <br>ovlock&nbsp;&nbsp; ovuserthread ovbuff&nbsp;&nbsp; usercpu&nbsp; syscpu&nbsp;&nbsp; numckpts flushes <br>0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.90&nbsp;&nbsp;&nbsp;&nbsp; 1.07&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 <br>bufwaits lokwaits lockreqs deadlks&n