db2_load

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_load

Post by admin »

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
<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_load

Post by admin »

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
<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_load

Post by admin »

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
<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