DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Thu Feb 26, 2004 2:11 pm Reply with quote    Back to top    

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

_________________
PLEASE READ
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
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Fri Feb 27, 2004 7:03 am Reply with quote    Back to top    

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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Fri Feb 27, 2004 7:34 am Reply with quote    Back to top    

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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Fri Feb 27, 2004 11:45 am Reply with quote    Back to top    

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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Fri Feb 27, 2004 12:06 pm Reply with quote    Back to top    

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

_________________
PLEASE READ
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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours