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

Don't think you can run sysmod if any users are connected to the database.

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.