Page 1 of 1

db2_load

Posted: Tue Feb 24, 2004 12:58 pm
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

db2_load

Posted: Tue Feb 24, 2004 1:10 pm
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

db2_load

Posted: Tue Feb 24, 2004 1:12 pm
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