MVSFORUMS.com

key · Beginner Joined: 29 Dec 2005 Posts: 19 Topics: 6

Hi ,

I need help on following topic.

We had found 6 databases (DB2 & IMS) using customer related activities. This is the only input we have. From this, we have to know how many programs used these 6 databases.

Is there any kind of tools available for this? Because we have approximately around 24000 thousand programs which mixed up of PL1, COBOL and Assembler.

Also, if you are providing information about How to proceed in this situation will be more helpful for me.

Kindly let me know.

Regards,
Karthik

kolusu · Posted: Fri May 05, 2006 4:33 am Post subject:

key,

The title is quite misleading. Please post the approriate forum. This belongs to "utilities" forum. Search the source PDS for the strings "sql" for DB2 "dli" for IMS using option 3.15

Hope this helps...

Cheers

Kolusu

Ps: Edited the topic title and moved to "utilities" forum
_________________
Kolusu
www.linkedin.com/in/kolusu

Bithead · Posted: Fri May 05, 2006 9:32 am Post subject:

For DB2, look at table SYSIBM.SYSPLANDEP. For IMS, you can look at the PSB and ACB libraries for the PSB (This does not give the program but it is a start).

key · Beginner Joined: 29 Dec 2005 Posts: 19 Topics: 6

Thanks much for the replies.

This will be helpful for me in the initial manual search approach.

Also, I want to know, is there any tool is available to do this? Can you provide some tool names?

Regards,
Karthik

Bithead · Posted: Fri May 05, 2006 9:56 am Post subject:

I am not aware of any tool.