How can I ensure that only 1 user picks up 1 record?

piglet · New User Joined: 05 Sep 2006 Posts: 6

Problem: I have a cursor in my CICS program. This screen is being accessed by multiple users.

Question: How can I ensure that only 1 user picks up 1 record?

ofer71 · Posted: Tue Sep 05, 2006 10:45 am

VSAM? DB2? TS Queue? TD Queue? IMS? ADABAS?

O.

piglet · New User Joined: 05 Sep 2006 Posts: 6

It is for DB2

ofer71 · Posted: Tue Sep 05, 2006 11:19 am

Ok, now for the second question: What do you mean by "picks up"? For read only? For update?

O.

piglet · New User Joined: 05 Sep 2006 Posts: 6

it is for update

ofer71 · Posted: Tue Sep 05, 2006 11:47 am

As far as I know, one of DB2's roles as RDBMS is to ensure that only one record can be updated in single point of time.

O.

piglet · New User Joined: 05 Sep 2006 Posts: 6

That is right.

But when the records are being fetched from the DB2 tables, there is a possibility of 2 people getting the same record.

jajuhby · New User Joined: 05 Sep 2006 Posts: 2

Hi everybody,

I also have the exact same problem: I need to be able to serialize access/rights to the database table for every task currently running. That way, if, for example, several people perform an action (at almost the same time) that requires a write or a read from one database table, these database transactions will be processed correctly (ie, one at a time, in the correct order).

I was told that the CICS ENQ/DEQ commands will help achieve this. Does anyone know how to use these commands in conjunction with database tables?