dbimport fails because of phantom root locks
Posted in 1999
running hpux 10.2 and informix 7.3 with
data replication
i;ve dbexported my database in question, modified the
schema sql (added several indexes to tables), and
dropped the existing database.
while running dbimport to recreate the database (no logging),
twice it has hung up because of waiting for a lock
while creating a third index on large (once on ~3 million, the
other time on ~8 million rows) tables.
the 3 indexes are on separate, single columns.
i'm running dbimport as user informix and while
dbimport is running, root creates a lock on the
table being indexed. there are NO root jobs
specificly accessing this database and no users
trying to access it either. looking at onstat -u
shows that my informix user session is waiting on
a lock and the sysmaster.syslocks table indicates
that root owns a lock on the table! root never
releases the lock (checked overnight). also
the root session that owns the lock cannot be
onmode -z'd.
i'm currently importing the database without creating
the indexes, but i'll need to create them sometime.
where is root coming from to create a lock?
(at least once during the import data replication
stopped but restarted on it's own)
thanks in advance
james paul
jhp@awips1.abrfc.noaa.gov
Sent via Deja.com http://www.deja.com/
Before you buy.