IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

DB2 unload utility VS COBOL program


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
Dinesh Manivannan

New User


Joined: 17 Mar 2008
Posts: 17
Location: India

PostPosted: Thu Nov 20, 2014 5:44 pm
Reply with quote

Hi all,

I have a requirement to generate 2 reports. We can use two methods to generate the report file.

1) Using 3 Cursors in a COBOL program. One cursor will be used to generate one report file. Other two cursors will be used to generate another report file.

2) Use two unload steps executing DSNUTILB. One report will be generated from one query directly. Other 2 queries will be joined to create another unload query.

When both are executed, they are taking less time since the development environment does not have much data.

Questions:
a) Which method is the best to use? I assume that utility will be more effective than the program.
b) Any way to determine which is the best solution?

Note: Tables used in the queries are used day long by some of the online programs.

Need the legends help on this!

Thanks
Dinesh M
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2503
Location: NY,USA

PostPosted: Fri Nov 21, 2014 4:04 am
Reply with quote

Quote:
Which method is the best to use? I assume that utility will be more effective than the program.
-- Yes

Quote:
b) Any way to determine which is the best solution?
-- load the actual data and test in dev env and see the stats or talk to the performance group or DBA.

However, if you can do a unload of these tables and use a SORT on them to make your reports then that would be efficient as you don't want your online disturbed by more accesing these tables in batch.
Back to top
View user's profile Send private message
Dinesh Manivannan

New User


Joined: 17 Mar 2008
Posts: 17
Location: India

PostPosted: Fri Nov 21, 2014 9:59 pm
Reply with quote

Thanks a lot.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts JCL for replacing code in Cobol JCL & VSAM 8
No new posts COBOL VS SORT Utility for file format... COBOL Programming 6
This topic is locked: you cannot edit posts or make replies. Sample CICS Webservices Program CICS 1
No new posts XML Parsing in COBOL creating "h... COBOL Programming 0
No new posts Calling Rexx program from Cobol CLIST & REXX 12

Back to Top