MVSFORUMS.com

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Could anyone help me in how to load the data into the tables using IMAGE copies (full imagecopies), using DSNTIAUL or any alternative method.

Thanks in advance.
_________________
Satya

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

satyenderd,

Pls chk the below link.

http://www.mvsforums.com/helpboards/viewtopic.php?t=3923&highlight=load+table+dsntiaul

Eric.C.Bakke · Posted: Wed Jul 16, 2008 7:15 am Post subject:

If you have access to DB2 utilities, check the ibm utility manuals. DSNTIAUL is a sample cobol program that uses dynamic sql. A load will be slower using this method than DB2 LOAD utility using NO LOG. If you're doing a few hundred rows, DSNTIAUL is fine but if you're doing thousands to millions of rows, it's not the best solution. There are other 3rd-party utility products that your shop might have such as BMC & CA's Platinum. These will perform better than DSNTIAUL too.
_________________
Eric C. Bakke
Senior DB2 DBA

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Thanks for your response.
I will check and let you know if i get any errors.
_________________
Satya