IBM Mainframe Forum

I have requirement to sort huge data(may be 3000 rows) in batch CICS.. Please let me know any efficient way to do it.,. As of now i tried to feed all the row in DB2 and extract(used auto generated unique key and task ID as key) in order by class. But the tran keeps on going down with deadlock issues.

... in batch CICS ...

OK for the beginner forum,
but a bit more clarity in Your questions will help You to get better answers

Sorry for the confusion here is the details…
I have requirement to sort huge data(may be 3000 rows) in CICS(It is a CICS program with no map defined for the tran.. the tran is triggered by MQ and program runs in the CICS and post a reply message in MQ.. without user interference... Please let me know any efficient way to do it.,. As of now I tried to feed all the rows in to a DB2 table (used auto generated unique key and task ID as key for the table) and extracted using order by class. But the tran keeps on going down with deadlock issues.