DB2 bulk loads

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

DB2 bulk loads

Post by admin »

I'm using DataStage version 6.0, on a windows server. We are doing
loads to DB2 on a mainframe. Is there a good way to do bulk loads,
replacing the entire table, other than using the DB2 Stage to do 1 insert
at a time?


Eric
----------
99% of lawyers give the rest a bad name.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

DB2 bulk loads

Post by admin »

Eric,
there is a stage named UDBLoad, which uses a DB2 utilitary to do this. All yu have to do is to fill the properties tab.
Good luck,
Alex

-----Mensagem original-----
De: Eric.Roufs@stpaul.com [mailto:Eric.Roufs@stpaul.com]
Enviada em: Thursday, February 26, 2004 5:11 PM
Para: DataStage Users Discussion List
Assunto: DB2 bulk loads



I'm using DataStage version 6.0, on a windows server. We are doing
loads to DB2 on a mainframe. Is there a good way to do bulk loads,
replacing the entire table, other than using the DB2 Stage to do 1 insert
at a time?


Eric
----------
99% of lawyers give the rest a bad name.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

DB2 bulk loads

Post by admin »

I was thinking we had tried that stage about 6 months ago, and had
some problems with it. I'll give it a shot again, though. Thanks! :>
Can that stage add to the table as well, or simply overwrite what's out
there?


Eric
----------
99% of lawyers give the rest a bad name.




"Alex Martins"
To: "DataStage Users Discussion List"
Sent by:
datastage-users-bounces cc:
@oliver.com Subject: RES: DB2 bulk loads


02/27/2004 10:03 AM
Please respond to
DataStage Users
Discussion List






Eric,
there is a stage named UDBLoad, which uses a DB2 utilitary to do this. All
yu have to do is to fill the properties tab.
Good luck,
Alex

-----Mensagem original-----
De: Eric.Roufs@stpaul.com [mailto:Eric.Roufs@stpaul.com]
Enviada em: Thursday, February 26, 2004 5:11 PM
Para: DataStage Users Discussion List
Assunto: DB2 bulk loads



I'm using DataStage version 6.0, on a windows server. We are doing
loads to DB2 on a mainframe. Is there a good way to do bulk loads,
replacing the entire table, other than using the DB2 Stage to do 1 insert
at a time?


Eric
----------
99% of lawyers give the rest a bad name.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users





_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

DB2 bulk loads

Post by admin »

I haven't tried it or checked into, but I would really be surprised if the
UDBLoad stage supports mainframe DB2.

Here's what I would do:
Have your mainframe DB2 DBA write a JCL job to load the DB2 table (you can
replace the current contents or append rows to it). Have him/her schedule
the load job in the mainframe job scheduling tool so that it gets executed
based on landing a file. Create a sequential file output from your DataStage
server job with whatever format your DBA prefers (fixed width or delimited).
Ftp the sequential file to the mainframe host. You may want to have your DBA
add a step to his JCL to ftp the load results back to your DataStage server,
so you can verify its success.

Mike

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
Eric.Roufs@stpaul.com
Sent: Friday, February 27, 2004 8:35 AM
To: DataStage Users Discussion List
Subject: Re: RES: DB2 bulk loads



I was thinking we had tried that stage about 6 months ago, and had
some problems with it. I'll give it a shot again, though. Thanks! :>
Can that stage add to the table as well, or simply overwrite what's out
there?


Eric
----------
99% of lawyers give the rest a bad name.




"Alex Martins"
To: "DataStage
Users Discussion List"
Sent by:

datastage-users-bounces cc:
@oliver.com Subject: RES: DB2 bulk
loads


02/27/2004 10:03 AM
Please respond to
DataStage Users
Discussion List






Eric,
there is a stage named UDBLoad, which uses a DB2 utilitary to do this. All
yu have to do is to fill the properties tab.
Good luck,
Alex

-----Mensagem original-----
De: Eric.Roufs@stpaul.com [mailto:Eric.Roufs@stpaul.com]
Enviada em: Thursday, February 26, 2004 5:11 PM
Para: DataStage Users Discussion List
Assunto: DB2 bulk loads



I'm using DataStage version 6.0, on a windows server. We are doing
loads to DB2 on a mainframe. Is there a good way to do bulk loads,
replacing the entire table, other than using the DB2 Stage to do 1 insert
at a time?


Eric
----------
99% of lawyers give the rest a bad name.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users





_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

DB2 bulk loads

Post by admin »

I know it works on as400.
It can append or overwrite.

-----Mensagem original-----
De: Mike [mailto:dwarchitect@comcast.net]
Enviada em: Friday, February 27, 2004 2:46 PM
Para: DataStage Users Discussion List
Assunto: RE: RES: DB2 bulk loads


I haven't tried it or checked into, but I would really be surprised if the
UDBLoad stage supports mainframe DB2.

Here's what I would do:
Have your mainframe DB2 DBA write a JCL job to load the DB2 table (you can
replace the current contents or append rows to it). Have him/her schedule
the load job in the mainframe job scheduling tool so that it gets executed
based on landing a file. Create a sequential file output from your DataStage
server job with whatever format your DBA prefers (fixed width or delimited).
Ftp the sequential file to the mainframe host. You may want to have your DBA
add a step to his JCL to ftp the load results back to your DataStage server,
so you can verify its success.

Mike

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
Eric.Roufs@stpaul.com
Sent: Friday, February 27, 2004 8:35 AM
To: DataStage Users Discussion List
Subject: Re: RES: DB2 bulk loads



I was thinking we had tried that stage about 6 months ago, and had
some problems with it. I'll give it a shot again, though. Thanks! :>
Can that stage add to the table as well, or simply overwrite what's out
there?


Eric
----------
99% of lawyers give the rest a bad name.




"Alex Martins"
To: "DataStage
Users Discussion List"
Sent by:

datastage-users-bounces cc:
@oliver.com Subject: RES: DB2 bulk
loads


02/27/2004 10:03 AM
Please respond to
DataStage Users
Discussion List






Eric,
there is a stage named UDBLoad, which uses a DB2 utilitary to do this. All
yu have to do is to fill the properties tab.
Good luck,
Alex

-----Mensagem original-----
De: Eric.Roufs@stpaul.com [mailto:Eric.Roufs@stpaul.com]
Enviada em: Thursday, February 26, 2004 5:11 PM
Para: DataStage Users Discussion List
Assunto: DB2 bulk loads



I'm using DataStage version 6.0, on a windows server. We are doing
loads to DB2 on a mainframe. Is there a good way to do bulk loads,
replacing the entire table, other than using the DB2 Stage to do 1 insert
at a time?


Eric
----------
99% of lawyers give the rest a bad name.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users





_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked