Which is the best way to unload a table?

sendhilkumaran · New User Joined: 15 Apr 2010 Posts: 8 Location: chennai

Hi Experts!

What is the advantage/disadvantage of using DB2 fileaid option 3.7.2 over the utilities like IKJEFT01, DSNUTILB and INZUTIL?

Anuj Dhawan · Posted: Thu Apr 22, 2010 5:45 pm

Nothing much; depends on your needs and what you want to use and what is available. File-Aid is paid-for-product utility, you know.

sushanth bobby · Posted: Thu Apr 22, 2010 5:48 pm

Hi Sendhil,

Welcome to ibmmainframes!

Post Title : Which is the best way to unload a table ?
Use UNLOAD or if you have FASTUNLOAD use it ?

What is the advantage/disadvantage of using DB2 fileaid option 3.7.2 over the utilities like IKJEFT01, DSNUTILB and INZUTIL?

For Advantages... you can click here

For Disadvantages, try using other products available and come back. You might find something....

Elaborate you queestion, you will get better answer....

Thanks,
Sushanth

sendhilkumaran · New User Joined: 15 Apr 2010 Posts: 8 Location: chennai

Hi Shushanth,

Thanks for your reply!

Actually, I have a idea of developing tool which unload/load a table using DSNUTILB utility. Before that I wanted to check the existing tool's(Fileaid Option 3.7.2) advantage and disadvantage and wanted to confirm is it really necessary to go for a tool.

sushanth bobby · Posted: Thu Apr 22, 2010 7:59 pm

Sendhil,

We have in-house tool move(unload & load) data between multiple databases in DEV.
Screen Entry will be Source database & Target database.

Sushanth