Find the Performance of cobol db2 program

komal · New User Joined: 09 May 2005 Posts: 17

Hi All,

I am writing one cobol db2 program. In that prog, I am retriving 10,000 records from source table and updating the target table with those 10,000 records(assume both source table and target tables keys were matched).

Now I want to know the performance of that program in the sence how many records/sec or /min is it updating.

Shall I've to use any other tool to find out this?

Anybody plz help me.

Komal

MainframeHelp4_u · New User Joined: 15 Aug 2006 Posts: 25

To Check the performance of a PGM, there is Tool "STROBE".

Specially delaing with the Large no of records, I prefer, Take a unload of Source Table & Target Table First.

Second: PGM write the business Logic as required.

then Finally u can use LOAD the TARGET table..

This is Good & Great Approach as per my understanding..

If STROBE is there at your installation, u can use tool.. u can refer some online search engine sites.. for u r referece on STROBE.

Still looking for clarifications, write back in forum for more info..

Cheers
Sri

komal · New User Joined: 09 May 2005 Posts: 17

Hello Sri

Thank You for u'r rply

I'm having strobe at my side but i dont know how to use it

As U know my requiremnet, plz help me to go thru the strobe options so that i'll complete my work for now. I'll refer the manual later.

thanq
komal

MainframeHelp4_u · New User Joined: 15 Aug 2006 Posts: 25

Please find the enclosed Docs on STROBE.

Let me know u r comments after reading the DOcs..

Cheers
Sri

MainframeHelp4_u · New User Joined: 15 Aug 2006 Posts: 25

Please try to implement the way, I told alreay with FLAT files then LOAD in to the Table, instead of STROBE.. If u r dealing with miliions of rows around 5+ millions of rows, then use STROBE.

For 10000 rows nothing is required. U can directly implement the changes in the PGM by using the TABLE.

Cheers
Sri