MVSFORUMS.com

jayan.r · Beginner Joined: 16 Jan 2006 Posts: 4 Topics: 2

I have the following scenario in one of the application.

A CICS transaction invokes a program which in turn does a LINK on another program. The invoking program and invoked porgram may be running in differennt CICS regions.
Now because of the limitation in the CICS DFHCOMMAREA of 32K the existing application is passing around 28K bytes. These info it obtains after SELECT from DB2 tables.
Now what our application does is that since it has more that 28K to FETCH after receiving data from first LINK it does a Second Link to Fetch the remaining Data. Now Again this involves SELECT DB2 tables.
So because of the two LINK I feel the performance is not good.

I was thinking like I will use one LINK and write all the info to a TSQ. Then fetch the data from TSQ in the main programme.

What do you think.

Please let me know the probable errors in my Design..

Manas Biswal · Posted: Mon Jan 23, 2006 10:00 am Post subject:

jayan.r,

28K of data is a huge amount of data. What are you doing about that data. It is difficult to imagine that you are displaying that amount of data on the screen. If not, then why CICS.
If your only purpose is to retrieve data from two different DB2 subsystems on different lpars, then there are better ways to do it.

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

batu544 · Beginner Joined: 02 Aug 2005 Posts: 75 Topics: 27

jayan.r,

if U want to pass a huge amount of data between two CICS systems , then u can use CICS Business Transaction Services ( BTS).

U can check this link. it may helps u ....

http://www-306.ibm.com/software/htp/cics/library/whitepapers/BigCommarea.pdf

Thanks,
_________________
Regards,
batu

jayan.r · Beginner Joined: 16 Jan 2006 Posts: 4 Topics: 2

Hi Manas,
The requirement is such that all the Data is required. Now I am asked to come up with a solution which will save MIPS. SO I am thinkking in this direction.

My reason for such thinking are as follows.
1) It avoids 2 calls
2) The Db2 thread need to be created only once.

More over I beleive that accessing TSQ will be easier..

Meanwhile I am also going through the link given by Batu544..

Thanks...
Your inputs are most welcome..

jayan.r · Beginner Joined: 16 Jan 2006 Posts: 4 Topics: 2

Hi,
Can the members please add their point of views on the subject..

Now I think I am stuck up with the idea..
Because the programs are written using CoolGen and CoolGen as such does not write to TSQ. So I have to use external progarms to write to TSQ's. which again menas that I have to use EXEC CICS LINK from the CoolGen programs to the External programs ... and again I am in trouble..