Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Tuning my DB2 program for performance

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

New User


Joined: 13 Oct 2006
Posts: 15

PostPosted: Thu Oct 26, 2006 10:52 am    Post subject: Tuning my DB2 program for performance
Reply with quote

Hi,

I have a COBOL program which accesses a DB2 table.The High Level Functionality is as follows...

> I read a full table into a cursor.
> Process the data (all rows) top to bottom one-by-one
> If the data from a row satisfies a particular condition, I need to delete that row from the table.
> Continue the above three steps until we reach end of cursor.

My concern is that what will happen if

> ...my program abends.Will it have to start looking into the table right from the beginning? ( Is there any sort of checkpointing in DB2 as it is in IMS )
> What will happen if there is any conflict for table usage with any other program? (Do we have any provisions for Hold on table as we have in IMS)

I will be thankful if I get some help with the above questions of mine.

Regards,
Raman
Back to top
View user's profile Send private message

surya_pathaus

Active User


Joined: 28 Aug 2006
Posts: 110

PostPosted: Thu Oct 26, 2006 1:56 pm    Post subject: Re: Tuning my DB2 program for performance
Reply with quote

Hi Raman,

We have BMC utility which take care of abends and checkpoints.
If commit count is given as 1000 then first checkpoint will be generated at 1000record and 2nd checkpoint at 2000.

If program abends at 2500 row i.e, after checkpoint 2 and before checkpoint 3 then BMC will restart the program after checkpoint 2.
This avoids reading all the records.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Fri Oct 27, 2006 8:27 am    Post subject: Re: Tuning my DB2 program for performance
Reply with quote

Raman... See what manual says on this...
Back to top
View user's profile Send private message
Itanium

Active User


Joined: 22 Jan 2006
Posts: 114
Location: India

PostPosted: Fri Oct 27, 2006 8:11 pm    Post subject:
Reply with quote

Hi Raman,
Can you check if this is feasible for you to do.
1# Unload the table into a Flat File
2# Extract only the required records using Sort
3# Reload the Flat File into the table

This would reduce the READ/DELETE overhead to DB2 and this will be faster than your process.

Thanks,
Itanium.
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
No new posts The same REXX program doesnt work for... jackzhang75 CLIST & REXX 5 Wed Dec 06, 2017 2:51 am
No new posts Calling IKJEFT01 program from Rexx upendrasri CLIST & REXX 8 Wed Nov 15, 2017 4:27 pm
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us