Hello all,
Im trying to load db2 from a remote server using the "db2 Bulk" stage in n PX 7.0. when i try to execute it i fails for this reasons
DB2_UDB_Load_42,0: Warning: DB2_UDB_Load_42: SQL6024E Table or index "BSACT" is not defined on node "0".
DB2_UDB_Load_42,0: Warning: DB2_UDB_Load_42: ERROR occurred : loading table, SQLCODE -6024
does anyone has an idea on how to invkoke db2 load from a remote server or if there are examples or scripts i could mimic.
i will appreciate any suggestions.
Thanks
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
db2_load
db2_load
<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.
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.
db2_load
Are you loading to DB2 on a Windows server?
Bill Kraft
Database Administrator
Ameritas Life Insurance Corp.
(402) 467-7241
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
Bill Kraft
Database Administrator
Ameritas Life Insurance Corp.
(402) 467-7241
_______________________________________________
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.
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.
db2_load
No. Im loading on sun solaris 9. Etl server (sun) ---> udb server (sun)
-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Bill Kraft
Sent: Tuesday, February 24, 2004 1:10 PM
To: DataStage Users Discussion List
Subject: Re: db2_load
Are you loading to DB2 on a Windows server?
Bill Kraft
Database Administrator
Ameritas Life Insurance Corp.
(402) 467-7241
_______________________________________________
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
-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Bill Kraft
Sent: Tuesday, February 24, 2004 1:10 PM
To: DataStage Users Discussion List
Subject: Re: db2_load
Are you loading to DB2 on a Windows server?
Bill Kraft
Database Administrator
Ameritas Life Insurance Corp.
(402) 467-7241
_______________________________________________
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.
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.