MVSFORUMS.com

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

I have a situation where in an operator is currently updating a record from CICS/Web screen and while this update is going on, Batch job tries to unload Table.

Now, Currently we don't retrieve the record being updated since it is locked and we want to retrieve the being updated.

We are fine even if the we get record in old state before it was updated. i.e. record in its initial state before updation.

kolusu · Posted: Wed Aug 27, 2008 3:04 pm Post subject:

rajen,

Code the SQL the clause WITH UR in the unload sysin and you will get the initial state record.

Kolusu

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Kolusu,
I did try that earlier.

Unload query is

SELECT Col1,Col2
from table
where condition
for fetch only with ur;

Actually that's the first option I tried but still it is not retrieving record being hold for update.

Thanks,

kolusu · Posted: Thu Aug 28, 2008 11:02 am Post subject:

rajen,

May be by the time unload got hold of the record your where clause has omitted it?

Kolusu

dbzTHEdinosauer · Posted: Thu Aug 28, 2008 11:11 am Post subject:

what utility are you using?

maybe it is not sophisticated enough to handle the situation.
_________________
Dick Brenholtz
American living in Varel, Germany

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Dick,
we are using PLATINUM.

Kolusu,
Even though we unload based on timestamp value, the record in question would still be qualify for WHERE Clause.

Thanks,

dbzTHEdinosauer · Posted: Fri Aug 29, 2008 2:29 am Post subject:

PLATINUM is capable of this; sounds like you need to look at the doc (or what until an experienced PLATINUM user answers), or ask your support people.
_________________
Dick Brenholtz
American living in Varel, Germany

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Dick,
I knew PLATINUM is capable of doing this and I think (though not positive) it can be achieved with Unload Card Parameter but none of the option seems to be working.

jsharon1248 · Posted: Fri Aug 29, 2008 10:06 am Post subject:

Have you tried this with DB2's UNLOAD or DSNTIAUL? Some of the 3rd party products go through the back door and read the underlying VSAM datasets directly. I'd try something from IBM if you can't resolve this with CA's product.

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Hi,
I did try DSNTIAUL. And by back door if you mean ACCESSING VSAM datasets then I guess I have tried that.

That was SHRLEVEL EXTENSION option if i have not misunderstood you.

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

FYI...

Sorry forgot to mention I even tried SHRLEVEL VSAM as well.

It didn't work either.