Cannot alocate Physical Log

HI I have a 9.30FC2 instance under Solaris and after a power failure crash, I try to put on-line the instance, but it fail with the message 'Cannot alocate Physical log 50000 avalible 23650'. I check with 'onstat -d' my rootdbs chunk: 146a6e028 1 1 1 75000 68730 PO- /infx_psam/ligas/rootdbs_prod this output show the sufficient space for allocate my phys log, but when I run an 'oncheck -pe' I see this: rootdbs:'informix'.TBLSpace 30238 200 FREE 30438 2144 rootdbs:'informix'.TBLSpace 32582 200 FREE 32782 1968 rootdbs:'informix'.TBLSpace 34750 200 FREE 34950 2112 rootdbs:'informix'.TBLSpace 37062 200 FREE 37262 2112 rootdbs:'informix'.TBLSpace 39374 200 FREE 39574 2112 rootdbs:'informix'.TBLSpace 41686 200 FREE 41886 2272 rootdbs:'informix'.TBLSpace 44158 200 FREE 44358 1984 rootdbs:'informix'.TBLSpace 46342 200 FREE 46542 2232 rootdbs:'informix'.TBLSpace 48774 200 FREE 48974 2176 rootdbs:'informix'.TBLSpace 51150 200 FREE 51350 23650 Total Used: 6270 Total Free: 68730 I can see that my free space is not contiguos, then my workaround was move the phys log to other dbspaces, but I don't know if it's possible to compaq again all the fragments in my root dbspaces. Other question: the crash can caused this problem? thanks

If there were many logged temp tables in the rootdb dbspace at the time of the crash, some older versions were not good about cleaning up temp tables left around after a crash. FYI: You REALLY should plan on upgrading to a current release of Informix. IDS 9.30 was released circa 2000 and went out of support several years ago. If you were on a supported release IBM could help you clean up. As it stands, you may have to export all of your databases, initialize the server, and rebuild/reload everything from scratch. The current release, 11.70.xC2 is probably a good 30% faster then 9.30 to boot with lots of new features you are missing out on that make it easier to manage your server. 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 Wed, Apr 6, 2011 at 11:40 AM, JULIO FLORES < j-gerardo.flores.olvera@hp.com> wrote: > HI > > I have a 9.30FC2 instance under Solaris and after a power failure crash, I > try > to put on-line the instance, but it fail with the message 'Cannot alocate > Physical log 50000 avalible 23650'. > > I check with 'onstat -d' my rootdbs chunk: > > 146a6e028 1 1 1 75000 68730 PO- /infx_psam/ligas/rootdbs_prod > > this output show the sufficient space for allocate my phys log, but when I > run > an 'oncheck -pe' I see this: > > rootdbs:'informix'.TBLSpace 30238 200 > FREE 30438 2144 > rootdbs:'informix'.TBLSpace 32582 200 > FREE 32782 1968 > rootdbs:'informix'.TBLSpace 34750 200 > FREE 34950 2112 > rootdbs:'informix'.TBLSpace 37062 200 > FREE 37262 2112 > rootdbs:'informix'.TBLSpace 39374 200 > FREE 39574 2112 > rootdbs:'informix'.TBLSpace 41686 200 > FREE 41886 2272 > rootdbs:'informix'.TBLSpace 44158 200 > FREE 44358 1984 > rootdbs:'informix'.TBLSpace 46342 200 > FREE 46542 2232 > rootdbs:'informix'.TBLSpace 48774 200 > FREE 48974 2176 > rootdbs:'informix'.TBLSpace 51150 200 > FREE 51350 23650 > > Total Used: 6270 > Total Free: 68730 > > I can see that my free space is not contiguos, then my workaround was move > the > phys log to other dbspaces, but I don't know if it's possible to compaq > again > all the fragments in my root dbspaces. > > Other question: the crash can caused this problem? > > thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf3071c9dc92e60b04a041fa9d