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
 

 

DB2 unload utility VS COBOL program

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

New User


Joined: 17 Mar 2008
Posts: 16
Location: India

PostPosted: Thu Nov 20, 2014 5:44 pm    Post subject: DB2 unload utility VS COBOL program
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

Senior Member


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

PostPosted: Fri Nov 21, 2014 4:04 am    Post subject:
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: 16
Location: India

PostPosted: Fri Nov 21, 2014 9:59 pm    Post subject: Reply to: DB2 unload utility VS COBOL program
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    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 DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
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 COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm


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