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
 

 

IKJFT01 Vs DSNTIAUL

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

Senior Member


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

PostPosted: Fri May 25, 2012 7:48 pm    Post subject: IKJFT01 Vs DSNTIAUL
Reply with quote

Which is better to use DSNTIAUL or IKJFT01 for unload in terms of performance and flexibility??
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Fri May 25, 2012 7:58 pm    Post subject:
Reply with quote

There is no program called IKJFT01 to unload but you would need to use IKJEFT01 to execute DSNTIAUL
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Fri May 25, 2012 8:05 pm    Post subject: Re: IKJFT01 Vs DSNTIAUL
Reply with quote

Rohit Umarjikar wrote:
Which is better to use DSNTIAUL or IKJFT01 for unload in terms of performance and flexibility??

Neither; unless you are trying to do something really outré, you are better off using a utility such as, e.g. BMC Unload+.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue May 29, 2012 12:56 pm    Post subject:
Reply with quote

IKJEFT01 is the TSO/E program. It is also called as TMP, Terminal Monitor Program. You use it whenever you wish to perform a TSO function within a batch job. It allows you to perform any TSO function. IKJEFT01 allows you to run programs written in CLIST and/or TSO/E REXX. You can also invoke other environments, such as ISPF , allowing you to run ISPF Dialogs in a batch environment. It also allows invoking DB2 commands. (After all DB2 is just another sub-system under zOS.)

On the other hand and from the manuals, DSNTIAUL, is a sample unload program for DB2. This program, which is written in assembler language, is a simple alternative to the UNLOAD utility. It unloads some or all rows from up to 100 DB2 tables. With DSNTIAUL, you can unload data of any DB2 built-in data type or distinct type.

Now with that said - your comparison does not stand on any practical grounds. What is that you might get after comparison?

Possibly a better comparison could have been among DSNTIAUL, DSNTIAD, DSNTEP2 and/or DSNTEP4 -- but I leave it to you. Curiosity kills... icon_smile.gif.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


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

PostPosted: Tue May 29, 2012 8:47 pm    Post subject:
Reply with quote

@Anuj: Thanks for the details. Exactly I would look up more and come up with the actual stats.
Thank you other as well.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue May 29, 2012 8:54 pm    Post subject:
Reply with quote

Hello,

Quote:
Which is better to use DSNTIAUL or IKJFT01 for unload in terms of performance and flexibility??
How does your organization define "better"?

To get more suggestions, you need to specify what you are specifically going to consider. Each tool has good uses. Which one to use depends on the requirement.

Are these unloads to be used to load another database somewhere or are these intended to be backups?
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 645
Location: Pennsylvania

PostPosted: Wed May 30, 2012 1:03 am    Post subject:
Reply with quote

Quote:
Exactly I would look up more and come up with the actual stats.


What I would do is code both (several) methods and test with the same data.

Make sure to do a large enough amount to show any differences.

Run your tests and compile 'actual statistics' for your system.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed May 30, 2012 3:43 pm    Post subject:
Reply with quote

You're welcome and good luck! icon_smile.gif

Suggest you look for the points, Dick & Dave has mentioned, when you proceed further.
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 Unload from Table with DSNTIAUL delim... suzeet DB2 1 Wed Dec 17, 2014 6:25 pm
No new posts Can you suppress NULLIF char for DSNT... HammerTime DB2 1 Tue Dec 09, 2014 10:00 pm
No new posts SQL QUERY to unload XML rec from DB2 ... gopikrishnan1984 DB2 10 Wed Dec 11, 2013 1:13 pm
No new posts Difference between INZUTILB and DSNTI... rexx77 DB2 1 Tue Mar 26, 2013 7:38 pm
No new posts Check number of deleted records in DS... Rishi Trehan DB2 4 Thu Feb 23, 2012 9:34 pm


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