Page 1 of 1

QUIESCE EXCLUSIVE STATE

Posted: Thu Jun 17, 2004 1:56 pm
by Marley777
Hello has anyone ever had to deal with a QUIESCE EXCLUSIVE STATE error? We aborted a job but locks were not released. Also does anyone know at what point Datastage ask db2 to apply the exclusive lock? If a load goes belly up and a lock is still out there, who has authority to realease lock?


Your help is greatly appreciated.

Re: QUIESCE EXCLUSIVE STATE

Posted: Fri Jun 18, 2004 5:41 am
by Eric
RStone wrote: who has authority to realease lock?
I would guess the DB2 user you are using plus other users that have been given extra priviliges, you'll have to talk to you DB2 DBA to know who else can perform this function.

Posted: Fri Jun 18, 2004 8:56 am
by denzilsyb
hallo RStone

this page


http://publib.boulder.ibm.com/infocente ... 002003.htm

explains the command to reset a QuIeScE StAte