Hi,
we are having an issue with DB checkpoints. We managed to have zero buffers flushed on the checkpoints, but still we experience a freeze of 15 to 30 seconds during a checkpoint.
platform : AIX 4.3.3
progress :9.1B20
DB block size : 4 Kb
BI block size : 16K
BI cluster size : 16 MB
AI block size : 8k
2 APW's
1 BIW,
1 AIW,
-B 300000
-spin 1000
checkpoint promon output :
06/05/02 Checkpoints
11:48:49
Ckpt ------ Database Writes ------
No. Time Len Dirty CPT Q Scan APW Q Flushes
380 11:38:50 0 9617 7749 0 0 0
379 11:28:03 647 8939 8933 817 0 0
378 11:16:44 679 9997 9997 605 0 0
377 11:03:37 787 10116 10134 325 0 0
376 10:53:24 613 8928 8952 849 0 0
375 10:44:28 536 11228 11252 254 0 0
374 10:33:19 669 10420 10445 581 0 0
373 10:22:27 652 10681 10706 415 0 0
Could this be the unix SYNC issue ?
Trying a "time sync" gives results varying from 15-30 seconds.
What steps can be taken next to improve this situation and has somebody experience with this kind of issue ?
TIA.
Jurgen Van Bouchaute
ICSAT nv.
we are having an issue with DB checkpoints. We managed to have zero buffers flushed on the checkpoints, but still we experience a freeze of 15 to 30 seconds during a checkpoint.
platform : AIX 4.3.3
progress :9.1B20
DB block size : 4 Kb
BI block size : 16K
BI cluster size : 16 MB
AI block size : 8k
2 APW's
1 BIW,
1 AIW,
-B 300000
-spin 1000
checkpoint promon output :
06/05/02 Checkpoints
11:48:49
Ckpt ------ Database Writes ------
No. Time Len Dirty CPT Q Scan APW Q Flushes
380 11:38:50 0 9617 7749 0 0 0
379 11:28:03 647 8939 8933 817 0 0
378 11:16:44 679 9997 9997 605 0 0
377 11:03:37 787 10116 10134 325 0 0
376 10:53:24 613 8928 8952 849 0 0
375 10:44:28 536 11228 11252 254 0 0
374 10:33:19 669 10420 10445 581 0 0
373 10:22:27 652 10681 10706 415 0 0
Could this be the unix SYNC issue ?
Trying a "time sync" gives results varying from 15-30 seconds.
What steps can be taken next to improve this situation and has somebody experience with this kind of issue ?
TIA.
Jurgen Van Bouchaute
ICSAT nv.