Oninit cdi / Archive
Talk to an expert →

Stream Queue for onbar/ontape

Posted in 2011

Topics: Backup & Restore, Versions, Editions & End-of-Life

Roy Mercer — — source: Usenet: comp.databases.informix

IBM Informix Dynamic Server Version 11.50.FC4WE AIX 6.1.0.0.-1^2 Using onstat -g stq you can monitor the Stream Queue for the backup. I can control the number of buffers for onbar using BAR_NB_XPORT_COUNT For ontape I am only showing 4 Queues. How can I adjust or tune the number of Stream Queues for ontape? I remember John Miller III had a presentation about onstat -g stq. onstat -g stq output: IBM Informix Dynamic Server Version 11.50.FC4WE -- On-Line -- Up 27 days 20:01:03 -- 7149584 Kbytes Stream Queue: (session 32087 cnt 4) 0:7000000c5c6f400 1:7000000cabad400 2:7000000d4528400 3:7000000cf100400 Full Queue: (cnt 3 waiters 0) 0:0 1:7000000cf100400 2:7000000c5c6f400 Empty Queue: (cnt 0 waiters 1)

↪ replying to Roy Mercer
jrenaut — — source: Usenet: comp.databases.informix

On Aug 26, 11:35 am, Roy Mercer <roy.mer...@gmail.com> wrote: > IBM Informix Dynamic Server Version 11.50.FC4WE > AIX 6.1.0.0.-1^2 > > Using onstat -g stq you can monitor the Stream Queue for the backup. > I can control the number of buffers for onbar using BAR_NB_XPORT_COUNT > > For ontape I am only showing 4 Queues. > How can I adjust or tune the number of Stream Queues for ontape? > > I remember John Miller III had a presentation about onstat -g stq. > > onstat -g stq output: > IBM Informix Dynamic Server Version 11.50.FC4WE -- On-Line -- Up 27 > days 20:01:03 -- 7149584 Kbytes> > Stream Queue: (session 32087 cnt 4)  0:7000000c5c6f400 > 1:7000000cabad400  2:7000000d4528400  3:7000000cf100400 >  Full Queue:  (cnt 3  waiters 0)  0:0  1:7000000cf100400 > 2:7000000c5c6f400 >  Empty Queue: (cnt 0  waiters 1) I believe it can be modified using the env variable ARCHIVE_BUF_COUNT. It looks like it takes an integer number with a range of valid values of 3 - 99. Try setting that env variable before kicking off ontape and see if that affects the onstat -g stq output. I believe it should. Jacques Renaut IBM Informix Advanced Support APD Team

↪ replying to jrenaut
Roy Mercer — — source: Usenet: comp.databases.informix

On Aug 26, 12:10 pm, jrenaut <jpren...@yahoo.com> wrote: > On Aug 26, 11:35 am, Roy Mercer <roy.mer...@gmail.com> wrote: > > > > > > > IBM Informix Dynamic Server Version 11.50.FC4WE > > AIX 6.1.0.0.-1^2 > > > Using onstat -g stq you can monitor the Stream Queue for the backup. > > I can control the number of buffers for onbar using BAR_NB_XPORT_COUNT > > > For ontape I am only showing 4 Queues. > > How can I adjust or tune the number of Stream Queues for ontape? > > > I remember John Miller III had a presentation about onstat -g stq. > > > onstat -g stq output: > > IBM Informix Dynamic Server Version 11.50.FC4WE -- On-Line -- Up 27 > > days 20:01:03 -- 7149584 Kbytes> > > Stream Queue: (session 32087 cnt 4)  0:7000000c5c6f400 > > 1:7000000cabad400  2:7000000d4528400  3:7000000cf100400 > >  Full Queue:  (cnt 3  waiters 0)  0:0  1:7000000cf100400 > > 2:7000000c5c6f400 > >  Empty Queue: (cnt 0  waiters 1) > > I believe it can be modified using the env variable > ARCHIVE_BUF_COUNT.  It looks like it takes an integer number with a > range of valid values of 3 - 99.  Try setting that env variable before > kicking off ontape and see if that affects the onstat -g stq output. > I believe it should. > > Jacques Renaut > IBM Informix Advanced Support > APD Team- Hide quoted text - > > - Show quoted text - Jacques, Yes, that is it and it worked. Thanks

Related threads

Glossary