We have couple of agents synchronizing Notes data with Db2 Tables. We are running it as nightly scheduled agents now. The client wants it to be manual process in future. They want 2 buttons available on the default view which can be clicked by the users when ever they need to synchronize data with Db2. Our users work on local replicas and replicate their changes once a day.
- Will there be an issue if 25 guys try to run the same agent manually at the same time ?
Note: Db2 connection is through LSXLC with a single username & password.
-
Is there any way not to lock the notes windows when they click the button and manually run the agent ?
-
Is there a way to lock the Db2 tables untill the first guy finishes running his agent ?
Pls advice me.
Raj
Subject: Suggestions on Manual Agents accessing Db2 Table
Hi,you can lock the DB2 table till the first agent finish the execution by executing ‘Lock’ sql statement.
But side effect of using ‘Lock’ statement is no body else will be able to access this table at that time so other user may get error.
Second option is use proper DB2 isloation level to lock the row. if you run the query with isloation level , db2 will lock selected record(s) until it get updated, rollbacked or committed.
Subject: Thanks Jitendra
Thanks Jitendra. Will try these options today and will update this posting.
Raj
Subject: RE: Thanks Jitendra
Hi Rajesh, Are you in Singapore?
Subject: RE: Thanks Jitendra
Ilinga sir. neenga NLB/Housing board Moorthya ?
Subject: RE: Thanks Jitendra
Yes. We were with HDB for some time.