Re: Blocked:CKPT-dbimport hangs

> 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 ***. > > ... > So it looks like it is running a checkpoint every couple of > seconds, which would help me understand why I get Blocked:Ckpt > from onstat -p. > > I really have no clue why it is trying to run a checkpoint so often. > > Could somebody help me? Your physical log file is too small. If you look at the 'onstat -l' output, you see that the physical log is 75% full. Any time physical log gets to 75%, it forces a checkpoint. 500 pages is a very small physical log, hence it fills up very quickly. Also, for performance reasons it is best to move your physical log out of the root dbspace and into a dbspace of its own. At the same time, you can expand the physical log. Of course, if 500 pages reaches 75% in one or two seconds, you'd have to make a very large (~50,000 pages) to get your checkpoints about two minutes apart. > Sorry for the verbose email, but I really want to get this db > migrated, and figured more info the better. It's rare for anyone to complain about too much info. Mark Collins mcollins@us.dhl.com