Unanswered: Database read access while dbexport is running
I'm new to this forum and new to informix databases. I've got a - I guess - simple question I wasn't able to find an answer for.
Can I execute reading queries while dbexport is running? Do I need a special user for this, e.g. a user with read-only rights?
Background: An backup system sends me a status mail with this content:
-425 - Database is currently opened by another user.
-107 - ISAM error: record is locked.
and I guess that the reason is an open connection from a user with write rights. Is this correct?
Thanks for your reply, Mike.
Unfortunately, I don't know in which cases a database is locked exclusively.
Do I prevent dbexport from obtaining an exlusive lock if I have an open connection with a read-only user?
I'm afraid, you are not able to prevent it. Dbexport command uses lock mechanism to protect the data and keep it consistent, it dosn't check users rights, only active connections. I would be nice if IBM could add a new switch to dbexport command, that allows to choose lock mode. DBA's are rather clerver and they know what they are doing.
You can use onunload instead of dbexport. Onunload is much faster than dbexport, but it has many more constraints placed on it than dbexport has. There are advantages and disadvantages to both commands, onunload locks the database in shared mode while it is running, but it can only spit out to