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

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 Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Feb 18, 2013 at 2:21 PM, malc_p <iiug@perrior.net> wrote: > Hi there > I'm concious this is an old unsupported IDS version (IDS 9.30HC5) but as > part of a migration I have to do a proof of concept. > > We've got the dbserver installed on a virtualised platform (basically > it's a direct lift from $PARENT_COMPANY's installation copied onto the > target machine and the installserver/RUN_AS_ROOT.server stages run). > > It initialises OK and I can create the databases and extra chunks we > need etc etc but when I come to dbimport our exported databases, it gets > so far and the we get the dreaded "Blocked:CKPT" message on onstat -u. > Trying onmode -c results in the "Checkpoint has stalled and is not > complete" message. > > We're loading the dbimport with no logging mode set, and have 50 AIO > VPs, which should be sufficient. onstat -u for the dbimport thread is > showing "---PX--". > > Any clues please? Yes I know this is not a standard procedure... > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >