Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Find the Performance of cobol db2 program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
komal

New User


Joined: 09 May 2005
Posts: 18

PostPosted: Wed Aug 23, 2006 9:12 pm    Post subject: Find the Performance of cobol db2 program
Reply with quote

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
Back to top
View user's profile Send private message

MainframeHelp4_u

New User


Joined: 15 Aug 2006
Posts: 25

PostPosted: Wed Aug 23, 2006 11:42 pm    Post subject: Performance check
Reply with quote

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
Back to top
View user's profile Send private message
komal

New User


Joined: 09 May 2005
Posts: 18

PostPosted: Tue Aug 29, 2006 9:48 pm    Post subject: Re: Want to know the performance ofo ne coboldb2 program
Reply with quote

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
Back to top
View user's profile Send private message
MainframeHelp4_u

New User


Joined: 15 Aug 2006
Posts: 25

PostPosted: Wed Aug 30, 2006 12:34 am    Post subject: Strobe Document
Reply with quote

Please find the enclosed Docs on STROBE.

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

Cheers
Sri
Back to top
View user's profile Send private message
MainframeHelp4_u

New User


Joined: 15 Aug 2006
Posts: 25

PostPosted: Wed Aug 30, 2006 12:38 am    Post subject: performance
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Cobol GUI (like Editor) Kala Mainframe COBOL Programming 14 Wed May 10, 2017 12:30 pm
No new posts IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us