Re: Verifying a tables LOCK MODE
Try adding the -ss option on dbschema and it will show up!
The -ss stands for server specific so it will also show what
dbspace the tables reside in.
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov
DTSI, Inc.
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Wed, 4 Sep 1996 DMurray370@aol.com wrote:
} HI:
}
} In order to reduce the number of "dead-locks" on my INFORMIX 7.11 database,
} I've attempted to change one of the tables from page to row level locking.
} After I did this I ran DBSCHEMA to verify that the change had actually taken.
} I wasn't able to locate the ALTER TABLE XXX LOCK MODE (ROW) anywhere in the
} schema. I'm not certain that the lock mode for this table was actuallly
} changed or not. Shouldn't DBSCHEMA report on a tables LOCK MODE if it isn't
} set to the (page) default? If not, how can I check on a tables LOCK MODE??
}
} I'd appreciate any info you could provide me with!
}
} Thank you
} Dave
}