PDA

View Full Version : Ingres Release OI 1.2/01 (hp8.us5/00) - IPM

mikejf
06-04-02, 03:09
Hi

Does anyone know how to get a listing of ingres iidbdb locks ? I keep getting error E_US_0014 database not available when trying to do a sysmod. Since this job runs at 2AM I cant interactivley use ipm. I want to run a script to display locks.

Any advice gratefully received at mike_frampton@hotmail.com

cheers

Mike F
tees
07-16-02, 13:30
Don't think you can run sysmod if any users are connected to the database.
fouellet
10-09-02, 14:58
The iidbdb catalogs are in use as soon as someone uses one of the databases, or someones uses accessdb or any other administration tool.
Therefore no sysmod is possible unless no user is around.