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: 1651
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 TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Submit job from Cobol with input data abdulrafi COBOL Programming 4 Wed Feb 01, 2017 12:41 pm


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