Oninit cdi / Archive
Talk to an expert →

Speed of Block

Posted in 2009

Topics: Storage & Space Management, Stored Procedures & SPL, Server Administration, Logging & Checkpoints, Platform-Specific Issues

brucemarchu@aol.com — — source: Usenet: comp.databases.informix

Hi, I am being asked to inquire if there is a way to decrease the block time during a BCV backup on?an IDS 11.5 FC2X@?database on an HP-UX ia64.? the typical?procedure being used is: 1. onmode? ?-l???????????? to roll logical log forward 2. onmode? -c???????????? force a checkpoint 3. onmode? -c??block?? to get ready for BCV split 4.?BVC split is done 5. onmode? -c? unblock??? to free up database for processing The database has over 100 dbspaces.?? Are there any ideas or suggestions? Thanks, Bruce

↪ replying to brucemarchu@aol.com
theBP — — source: Usenet: comp.databases.informix

brucemarchu@aol.com wrote: > Hi, > > I am being asked to inquire if there is a way to decrease the block time > during a BCV backup on an IDS 11.5 FC2X@ database on an HP-UX ia64. the > typical procedure being used is: > 1. onmode -l to roll logical log forward > 2. onmode -c force a checkpoint > 3. onmode -c block to get ready for BCV split > 4. BVC split is done > 5. onmode -c unblock to free up database for processing > > The database has over 100 dbspaces. Are there any ideas or suggestions? > > Thanks, > Bruce > > ------------------------------------------------------------------------ > *A Good Credit Score is 700 or Above. See yours in just 2 easy steps! > <http://pr.atwola.com/promoclk/100126575x1218822736x1201267884/aol?redir=http:%2F%2Fwww.freecreditreport.com%2Fpm%2Fdefault.aspx%3Fsc%3D668072%26hmpgID%3D62%26bcd%3DfebemailfooterNO62>* > Well, provide some timings : > 1. onmode -l to roll logical log forward 2 seconds? > 2. onmode -c force a checkpoint 2 seconds? > 3. onmode -c block to get ready for BCV split 2 seconds? > 4. BVC split is done 2 seconds? > 5. onmode -c unblock to free up database for processing 2 seconds? How fast do you want it to go?

↪ replying to brucemarchu@aol.com
Neil Truby — — source: Usenet: comp.databases.informix

<brucemarchu@aol.com> wrote in message news:mailman.317.1235756526.1831.informix-list@iiug.org... Hi, >> I am being asked to inquire if there is a way to decrease the block time >> during a BCV backup on an IDS 11.5 FC2X@ database on an HP-UX ia64. the >> typical procedure being used is: 1. onmode -l to roll logical log forward 2. onmode -c force a checkpoint 3. onmode -c block to get ready for BCV split 4. BVC split is done 5. onmode -c unblock to free up database for processing >> The database has over 100 dbspaces. Are there any ideas or suggestions? First of all, I'm thrilled to see another user with Informix on Itanic! We sold a large amount of Informix into a customer last year, who's since gone live, and really struggled event with IBM's help to find *any* customers using IDS on ia64. I'd be interested in swapping experiences on a private exchange ... As to your question, I don't know any way. Your question implies that you have problems. Here's mine from a typical night (last night): 02:02:55 2708 buffers dirty 02:02:55 oldest lsn loguniq 5501, logpos 0x4ca9018 02:02:55 2299 dirty pages are to be flushed 02:02:56 dskflush() took 1 seconds 02:02:56 wait4critex() took 0 seconds 02:02:56 409 buffers dirty 02:02:56 oldest lsn loguniq 5501, logpos 0x4ca9018 02:02:56 safe_dskflush() took 0 seconds 02:02:56 Checkpoint Completed: duration was 1 seconds. 02:02:56 Checkpoint loguniq 5501, logpos 0xa1fd018, timestamp: 0x9be332ef 02:02:56 Maximum server connections 4048 02:02:56 Buffer manager: starting coarse downgrades. 02:02:56 Dynamic Server blocked. 02:02:58 Buffer manager: finished coarse downgrades. Starting threshold adjustments. 02:02:58 Buffer manager: finished threshold adjustments. 02:02:59 Dynamic Server unblocked. so, 3 seconds blocked. Are you getting much longer times? rgds N

↪ replying to Neil Truby
Fernando Nunes — — source: Usenet: comp.databases.informix

Neil Truby wrote: > First of all, I'm thrilled to see another user with Informix on Itanic! > We sold a large amount of Informix into a customer last year, who's > since gone live, and really struggled event with IBM's help to find > *any* customers using IDS on ia64. I'd be interested in swapping > experiences on a private exchange ... > I will use it in a few weeks/months time... Customer decision... not mine of course :) Feel free to contact me. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

Glossary