MVSFORUMS.com

bade_miya · Beginner Joined: 10 Dec 2003 Posts: 110 Topics: 38

Hi Experts,

We have an IMS BMP program which calls a DB2 module to read config from the DB2 tables. We are trying to reuse the same module for one of our online solutions. But as DB2 call is significantly increasing the response time, we are looking for other options to provide the configuration parameters to the program.

One option which we thought is to define the configs in an array and include that as a copybook to the program. But when a new config needs to be added, the program should be recompiled.

The second option was to provide the configs to the program through input files. But I learned that IMS MPP cannot access input files. (Is that true? Not even GSAMs?). Given that we do not want to recompile the program every time a new config is added, can anyone think of any other alternatives? (Creating a new IMS DB for storing configs is not an option because client has voted against it).

Thanks
bade_miya

dbzTHEdinosauer · Posted: Wed Aug 04, 2010 9:41 am Post subject:

well, I would solve the db2 access problem.
don't tell me. you created the config db2 table(s) based on SAP standards.

the config access should be at most two primary keys selects.

but on another note: 4.1.5 Comparison of different techniques for sharing data
NOTE BIEN: Table 18. Techniques for sharing keyed data
_________________
Dick Brenholtz
American living in Varel, Germany

Anuj Dhawan · Posted: Wed Aug 04, 2010 11:15 am Post subject: Re: IMS MPP Input

Anuj Dhawan · Posted: Wed Aug 04, 2010 11:18 am Post subject:

Ok, one second -- you first said

kolusu · Posted: Wed Aug 04, 2010 11:19 am Post subject: Re: IMS MPP Input

Anuj Dhawan · Posted: Wed Aug 04, 2010 11:29 am Post subject:

Kolusu,

Please check: http://publib.boulder.ibm.com/infocenter/radhelp/v6r0m1/index.jsp?topic=/com.ibm.etools.egl.doc/topics/ceglasm0450.html and look for IMS runtime support.
_________________
Regards,
Anuj

kolusu · Posted: Wed Aug 04, 2010 11:42 am Post subject:

bade_miya · Beginner Joined: 10 Dec 2003 Posts: 110 Topics: 38

Thanks dbzTHEdinosauer, Anuj and Kolusu.

We have TableBase in our shop and I heard that for online IMS programs, it is 18-22 times faster than DB2. That is the option we are researching right now. Has anyone worked with tablebase for online IMS programs previously?

Anuj,

Sorry if I was not clear. We have an "existing IMS BMP program" which uses DB2. we are working on a "new IMS MPP program" for which we need to give config input.
I was not talking about EGL, so I don't think that will help me.

Thanks & Regards
bade_miya.

Nic Clouston · Posted: Wed Aug 04, 2010 11:28 pm Post subject:

I don't think it matters whether the program is IMS/DB2/batch/BMP or online as far as TableBae is concerned. Check out the TableBase manuals. From what I recall they are readable. I have them, I think, but I am about to go to work (non-IT Crying or Very sad

) so do not have time to look up the info. I may try tonight.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

bade_miya · Beginner Joined: 10 Dec 2003 Posts: 110 Topics: 38

Hi All,

I have got a manual for Tablebase and it claims to support IMS online programs as well. So we have decided to go with Tablebase. I will come back and post if proved otherwise. Thanks for the answers.

Thanks & Regards
bade_miya