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: 1737
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 XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm


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