View previous topic :: View next topic
|
Author |
Message |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Which is better to use DSNTIAUL or IKJFT01 for unload in terms of performance and flexibility?? |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
There is no program called IKJFT01 to unload but you would need to use IKJEFT01 to execute DSNTIAUL |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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... . |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
@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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
You're welcome and good luck!
Suggest you look for the points, Dick & Dave has mentioned, when you proceed further. |
|
Back to top |
|
|
|