RE: When is it safe to kill -9 an unkillable sqlturbo?
Along with step 3. below care should also be taken that the process is not
holding any latches.
Dilip
At 12:56 14/11/96 -0800, you wrote:
}When killing an sqlturbo process you should follow these steps:
}
}1) Kill the front-end (application) first.
}2) If the sqlturbo is still around after a minute, perform a tbmode -z
} on the session.
}3) If the session still won't die, run an onstat -u and look at the
} flags for the session. As long as there isn't an X (critical write)
} in progress, it's safe to kill -9 the sqlturbo.
}4) If there's a critical write in progress, killing the sqlturbo process
} will automatically bring the engine down. This is to prevent data
} corruption.
}
} There is no way to terminate an sqlturbo process if it's in a
} critical write without bringing down the engine.
}
}Troy
}
}