Re: Blocked:CKPT-dbimport hangs

Olaf <bjv@wsx.wsex.com> wrote: One thing is obvious from your 'onstat -l' (and from very frequent checkpoints also) - your physical log is 75% full. > Physical Logging > Buffer bufused bufsize numpages numwrits pages/io > P-2 0 16 26285 1734 15.16 > phybegin physize phypos phyused %used > 10003f 500 38 375 75.00 You need to increase the size of physical log, but remember that physical log sizing depends on all activity on your instance and you will need to take care of other parameters and tune them to have short checkpoint duration. So, change > PHYSFILE 1000 # Physical log file size (Kbytes) and be ready to change also LRU_MAX_DIRTY, LRU_MIN_DIRTY, CLEANERS, etc. There are also some other parameters that you should check: - why ROOTDBS is so large? - why you're not using DBSPACETEMP - why LBU_PRESERVE is 0 It is also interesting to understand why you have SHMVIRTSIZE < SHMADD(from my experience with HP-UX :-) BTW what hardware/OS you are using? > From checking the archives, it seems perhaps my problem is running > dbimport from a tape that I also have set as my LTAPEDEV and TAPEDEV. What you will do if logical logs will fill up? Are you using logging? For this particular case I will change LTAPEDEV to /dev/null. Afterwards everything depends on your backup/restore strategy. HTH Vardan > Hello All, > > I am having trouble using dbimport to import from tape a ~2gig DB. > > The DB is from an export on Online 5.07.UC1 SCO OS5.04. > > I am trying to run the import on IDS 7.30.UC6 Sun OS 5.6. > > When I run the import it loads 3 small tables, perms, rowlock, pagelock. > > Tell you the truth, I do not what those tables are, but I imagine Informix uses them for the DB. > > After it loads the first 3 tables, it begins loading a table with a 1st extent size of 175000k. > > It seems to hange at *** load table ***. > > > onstat -p reveals: > ------------------> > Informix Dynamic Server Version 7.30.UC6 -- On-Line (CKPT REQ) -- Up 00:18:27 -- 155456 Kbytes > Blocked:CKPT > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 15 0 180867 99.99 16992 16446 100927 83.16 > > isamtot open start read write rewrite delete commit rollbk > 92879 368 359 458 45709 6 1 12 0 > > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs > 0 0 0 0 0 0 0 > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 8.22 0.91 22 44 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 0 0 1122 0 0 22 493 16 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 0 0 0 0 0 > > onstat -m reveals: > ------------------> > Informix Dynamic Server Version 7.30.UC6 -- On-Line (CKPT REQ) -- Up 00:19:14 -- 155456 Kbytes > Blocked:CKPT > > Message Log File: /usr/local/informix/online.log > 19:19:42 Checkpoint Completed: duration was 2 seconds. > 19:19:44 Checkpoint Completed: duration was 2 seconds. > 19:19:46 Checkpoint Completed: duration was 1 seconds. > 19:19:47 Checkpoint Completed: duration was 1 seconds. > 19:19:49 Checkpoint Completed: duration was 2 seconds. > 19:19:51 Checkpoint Completed: duration was 1 seconds. > 19:19:53 Checkpoint Completed: duration was 1 seconds. > 19:19:54 Checkpoint Completed: duration was 2 seconds. > 19:19:56 Checkpoint Completed: duration was 1 seconds. > 19:19:58 Checkpoint Completed: duration was 1 seconds. > 19:19:59 Checkpoint Completed: duration was 2 seconds. > 19:20:01 Checkpoint Completed: duration was 1 seconds. > 19:20:03 Checkpoint Completed: duration was 1 seconds. > 19:20:05 Checkpoint Completed: duration was 1 seconds. > 19:20:06 Checkpoint Completed: duration was 2 seconds. > 19:20:08 Checkpoint Completed: duration was 1 seconds. > 19:20:10 Checkpoint Completed: duration was 1 seconds. > 19:20:11 Checkpoint Completed: duration was 1 seconds. > 19:20:13 Checkpoint Completed: duration was 2 seconds. > 19:20:15 Checkpoint Completed: duration was 1 seconds.> > > > onstat -l reveals: > ------------------> > Informix Dynamic Server Version 7.30.UC6 -- On-Line (CKPT REQ) -- Up 00:19:53 -- 155456 Kbytes > Blocked:CKPT > > Physical Logging > Buffer bufused bufsize numpages numwrits pages/io > P-2 0 16 26285 1734 15.16 > phybegin physize phypos phyused %used > 10003f 500 38 375 75.00 > > Logical Logging > Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io > L-3 0 16 1467 126 75 11.6 1.7 > Subsystem numrecs Log Space used > OLDRSAM 1467 113324 > > address number flags uniqid begin size used %used > a155bb8 1 U---C-L 1 100233 6250 1673 26.77 > a155bd4 2 F------ 0 101a9d 6250 0 0.00 > a155bf0 3 F------ 0 103307 6250 0 0.00 > a155c0c 4 F------ 0 104b71 6250 0 0.00 > a155c28 5 F------ 0 1063db 6250 0 0.00 > a155c44 6 F------ 0 107c45 6250 0 0.00 > a155c60 7 F------ 0 1094af 6250 0 0.00 > a155c7c 8 F------ 0 10ad19 6250 0 0.00 > a155c98 9 F------ 0 10c583 6250 0 0.00 > a155cb4 10 F------ 0 10dded 6250 0 0.00 > a155cd0 11 F------ 0 10f657 6250 0 0.00 > a155cec 12 F------ 0 110ec1 6250 0 0.00 > a155d08 13 F------ 0 11272b 6250 0 0.00 > a155d24 14 F------ 0 113f95 6250 0 0.00 > a155d40 15 F------ 0 1157ff 6250 0 0.00 > a155d5c 16 F------ 0 117069 6250 0 0.00 > a155d78 17 F------ 0 1188d3 6250 0 0.00 > a155d94 18 F------ 0 11a13d 6250 0 0.00 > a155db0 19 F------ 0 11b9a7 6250 0 0.00 > a155dcc 20 F------ 0 11d211 6250 0 0.00 > a155de8 21 F------ 0 11ea7b 6250 0 0.00 > a155e04 22 F------ 0 1202e5 6250 0 0.00 > a155e20 23 F------ 0 121b4f 6250 0 0.00 > a155e3c 24 F------ 0 1233b9 6250 0 0.00 > a155e58 25 F------ 0 124c23 6250 0 0.00 > a155e74 26 F------ 0 12648d 6250 0 0.00 > a155e90 27 F------ 0 127cf7 6250 0 0.00 > a155eac 28 F------ 0 129561 6250 0