dbschema locking the system

[[e-mail]]

HP-UX B.11.11 U 9000/800 2262126760 unlimited-user license

IBM Informix Dynamic Server Version 11.50.FC3 Software Serial Number AAA#B000000

Hello all,
I am having an issue when I run the dbschema command during the online day.

It runs for what I would consider "too long" for very small tables and locks out all user access whilst executing.

This is the command I am running.....

dbschema -ddbname -ttabname -ss tabname.sql

Is there something I should be doing that prevents these issues?

[BeGooden-IT Vercelletto]

Hi,


this is strange. dbschema normally ONLY puts a SHARED lock on the "dbschemaed" database.

running dbschema should not have any impact unless some other users want to put an exclusive lock on the same database.

Do you have "SET LOCK MODE TO WAIT" in the applications running ?

did you check the lock conflicts ?

I do not have your version, but I do not see why 11.50 xC3 would behave differently

Post by ***@googlemail.com
HP-UX B.11.11 U 9000/800 2262126760 unlimited-user license
IBM Informix Dynamic Server Version 11.50.FC3 Software Serial Number AAA#B000000
Hello all,
I am having an issue when I run the dbschema command during the online day.
It runs for what I would consider "too long" for very small tables and locks out all user access whilst executing.
This is the command I am running.....
dbschema -ddbname -ttabname -ss tabname.sql
Is there something I should be doing that prevents these issues?