Blocked checkpoint ...

IDS 11.50.fc4 Aix 6 I had a situation today where an underlying symbolic link was missing ... Engine came up .. put the warning in the online.log ... Eventually the system became Hung ... waiting on a checkpoint ... ONSPACEDOWN was set to 2 in the onconfig ... Here is the question, after I re-established the link, would there have been a command where I could force the checkpoint ... Something to tell the engine it was there now? I tried onmode -c, onmode -l and such .. with no luck. Eventually brought the engine downand back up ..... Any help for a future situation would be appreciated ... Also, what is the "real World" setting of the ONSPACEDOWN parameter? Peter Peter Logan Senior Database Administrator Phone: 616/878-8309

The ONDBSPACEDOWN parameter is typically set to 1 (abort) on OLTP and most DSS systems and often to 0 (mark space down and continue) on DW systems. On an OLTP system you do not want the server to be online if any disk is unusable, with the exception of temp dbspaces. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Sun, Aug 23, 2009 at 8:14 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > IDS 11.50.fc4 > Aix 6 > > I had a situation today where an underlying symbolic link was missing ... > Engine came up .. put the warning in the online.log ... Eventually the > system became Hung ... waiting on a checkpoint ... ONSPACEDOWN was set to > 2 in the onconfig ... Here is the question, after I re-established the > link, would there have been a command where I could force the checkpoint > .... Something to tell the engine it was there now? I tried onmode -c, > onmode -l and such .. with no luck. Eventually brought the engine down> and back up ..... Any help for a future situation would be appreciated > .... > > Also, what is the "real World" setting of the ONSPACEDOWN parameter? > > Peter > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0023545bd6586f1dbf0471d05f48