Fwd: Re: IDS 9.30 on a virtualised HP-UX platform; "Checkpoint Stalled"

On 18/02/2013 19:39, Art Kagel wrote: > What does onstat -l show? If you are dbimporting an export that was > made without the -ss option then all tables are created with minimum > extent sizing which will cause thousands of new extents to be added to > the tables during the dbimport and extents ARE logged regardless of > the logging state of the database. So, you may be running out of > logical log space. > > Art > > Art S. Kagel Hi Art no, onstat -l is showing no real usage: Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-1 0 16 67828 2319 336 29.2 6.9 Subsystem numrecs Log Space used OLDRSAM 67828 4354504 address number flags uniqid begin size used %used d76b4c90 1 U-B---- 1 10148f 5000 5000 100.00 d76b4cc8 2 U---C-L 2 102817 5000 539 10.78 d76b4d00 3 A------ 0 103b9f 5000 0 0.00 d76b4d38 4 A------ 0 104f27 5000 0 0.00 d76b4d70 5 A------ 0 1062af 5000 0 0.00 also, onstat -g act only shows the belowand never changes: (onstat -u is showing no increases in reads or writes either): Informix Dynamic Server Version 9.30.HC5 -- On-Line (CKPT REQ) -- Up 01:18:00 -- 372220 Kbytes Blocked:CKPT Running threads: tid tcb rstcb prty status vp-class name 56 d7e2a730 0 2 running 1cpu sm_poll 57 d7f8e798 0 2 running 59soc soctcppoll