473,602 Members | 2,872 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

db2load remote database

Hi,

I want to know if it is possible to load(using the db2load API) into a
remote database. By remote database i mean one that i have cataloged.
Any parameters that need to be changed ?

TIA

Sep 21 '06 #1
7 4707
Vivek wrote:
Hi,

I want to know if it is possible to load(using the db2load API) into a
remote database. By remote database i mean one that i have cataloged.
Any parameters that need to be changed ?
The db2Load API requires that you are connected to the database you want to
load the data into. Given that you already cataloged it, connect to the DB
and then run db2Load.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Sep 21 '06 #2

Knut Stolze wrote:
Vivek wrote:
Hi,

I want to know if it is possible to load(using the db2load API) into a
remote database. By remote database i mean one that i have cataloged.
Any parameters that need to be changed ?

The db2Load API requires that you are connected to the database you want to
load the data into. Given that you already cataloged it, connect to the DB
and then run db2Load.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
I tried it and i get the folloing error:

"SQL3508N Error in accessing a file or path of type 'TEMP_FILE' during
load or load query. Reason code: '1'." Path: C:/

Sep 22 '06 #3
In article <11************ **********@i3g2 000cwc.googlegr oups.com>,
te*********@gma il.com says...
>
Knut Stolze wrote:
Vivek wrote:
Hi,
>
I want to know if it is possible to load(using the db2load API) into a
remote database. By remote database i mean one that i have cataloged.
Any parameters that need to be changed ?
The db2Load API requires that you are connected to the database you want to
load the data into. Given that you already cataloged it, connect to the DB
and then run db2Load.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

I tried it and i get the folloing error:

"SQL3508N Error in accessing a file or path of type 'TEMP_FILE' during
load or load query. Reason code: '1'." Path: C:/

You have to set the right options (SQLU_CLIENT_LO CATION), check the
tbmove.sqc sample in your <DB2_PATH>\samp les\c directory.
Sep 22 '06 #4
For remote db, you should use
db2 load client from ....
There must be similar api.
Gert van der Kooij wrote:
In article <11************ **********@i3g2 000cwc.googlegr oups.com>,
te*********@gma il.com says...

Knut Stolze wrote:
Vivek wrote:
>
Hi,

I want to know if it is possible to load(using the db2load API) into a
remote database. By remote database i mean one that i have cataloged.
Any parameters that need to be changed ?
>
The db2Load API requires that you are connected to the database you want to
load the data into. Given that you already cataloged it, connect to the DB
and then run db2Load.
>
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
I tried it and i get the folloing error:

"SQL3508N Error in accessing a file or path of type 'TEMP_FILE' during
load or load query. Reason code: '1'." Path: C:/

You have to set the right options (SQLU_CLIENT_LO CATION), check the
tbmove.sqc sample in your <DB2_PATH>\samp les\c directory.
Sep 22 '06 #5
In article <11************ **********@m73g 2000cwd.googleg roups.com>,
sh*******@gmail .com says...
Gert van der Kooij wrote:
In article <11************ **********@i3g2 000cwc.googlegr oups.com>,
te*********@gma il.com says...
>
Knut Stolze wrote:
.....

You have to set the right options (SQLU_CLIENT_LO CATION), check the
tbmove.sqc sample in your <DB2_PATH>\samp les\c directory.


For remote db, you should use
db2 load client from ....
There must be similar api.
No, it's the same API (db2Load). It just needs the right options as I
said in my previous post.
Sep 22 '06 #6

Thanks guys.

I was able to load into the remote database by setting the "media_type "
parameter in the api to SQLU_CLIENT_LOC ATION.

Gert van der Kooij wrote:
In article <11************ **********@m73g 2000cwd.googleg roups.com>,
sh*******@gmail .com says...
Gert van der Kooij wrote:
In article <11************ **********@i3g2 000cwc.googlegr oups.com>,
te*********@gma il.com says...

Knut Stolze wrote:
....
>
You have to set the right options (SQLU_CLIENT_LO CATION), check the
tbmove.sqc sample in your <DB2_PATH>\samp les\c directory.

For remote db, you should use
db2 load client from ....
There must be similar api.

No, it's the same API (db2Load). It just needs the right options as I
said in my previous post.
Sep 25 '06 #7
Vivek wrote:
>
Knut Stolze wrote:
>Vivek wrote:
Hi,

I want to know if it is possible to load(using the db2load API) into a
remote database. By remote database i mean one that i have cataloged.
Any parameters that need to be changed ?

The db2Load API requires that you are connected to the database you want
to
load the data into. Given that you already cataloged it, connect to the
DB and then run db2Load.

I tried it and i get the folloing error:

"SQL3508N Error in accessing a file or path of type 'TEMP_FILE' during
load or load query. Reason code: '1'." Path: C:/
RC=1 stands for:

1 Unable to open the file.

This could be caused by an incorrect file name or insufficient
authority to access the file/directory. Correct the problem and
either restart or rerun the load.

The load temporary file could have been destroyed or the
database could have been restored from an earlier backup. Load
restart is not supported under these circumstances. Use load
terminate to bring the table out of load pending state.
Have you verified that the permissions are correct?
What exactly did you try to do?
And also always important: Which DB2 version and platform are you using?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Sep 26 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
7074
by: Douglas Harber | last post by:
If I have DB2 8.1 (FP5, I believe, but not relevant to my question...I hope) installed on my desktop, do I have what I need to connect to a remote DB2 server (also running 8.1 FP5) from my desktop machine? I assume, perhaps naively, that all the parts are there but I've spent several hours trying to grasp how to go about accessing the remote server. Specifically, I'm trying to create and populate databases on the remote server from...
3
1658
by: nekiv90 | last post by:
Greetings, We need to initial load hundreds of tables from within programs. We try to run several programs that call the DB2LOAD in parallel (to load different tables of course) in order to speed up the process. However, the program that completes the DB2LOAD first appears to cancel the subsequent DB2LOAD by other programs. No obvious error found in db2diag.log.
1
8256
by: UDBDBA | last post by:
Hi: How can one call SYSPROC.DB2LOAD procedure within a SQL stored procedure. I get the following error: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0418N A statement contains a use of a parameter marker that is not valid. LINE NUMBER=48. SQLSTATE=42610.
0
983
by: Suresh | last post by:
Hi All I am tring to call SYSPROC.DB2LOAD stored procedure from DB2 UDB 8.2. Command editor. i used the follwoing syntax... CALL DB2LOAD (1,NULL,'LOAD CLIENT FROM "/home/db2inst1/Suresh/LoadCards.txt" OF DEL MODIFIED BY CODEPAGE=850 COLDEL0x09 METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) MESSAGES "/home/db2inst1/Suresh/LoadMessage.txt" INSERT INTO CUSTOMER.CARD (SUPPORTERID, CARDNUMBER, EXPDATE, TERMINATIONDATE, CARDTYPECODE,
3
2678
by: Pakna | last post by:
Hello, I have what may be a beginner's question regarding DB2. How does one access a remote table on a remote database via SQL? What is the command string, is there an equivalent of Oracle DBLINK? I hope I was clear. If there are more information that I need to supply, please do tell me. Thank you very much for your replies
0
1172
by: anils | last post by:
I am trying to implement db2Load in C#, using PInvoke looking at the sample C programe which has Dbconn() & db2Load() methods I could find db2Load in db2app.dll, I could not find Dbconn() method in any Dll's Any pointer to this or input as to how to implement & help in this regards is much appriciated. thanks & regards Anil
2
2087
by: Tor Inge Rislaa | last post by:
Database on remote server On the remote server where my ASP.NET application is located there is no SQL Server or SQL Server Express. When I test my application locally it works fine because I have the SQL Server Express 2005 on my computer, but when I deploy it I am getting error message telling me that there are some problems connecting to the database. I have done the preparation on my SQL Server to allow remote connection to the...
2
1512
by: Vivek | last post by:
Hi, Iam using the db2load API to write data to a table. I see that by default the load process creates/overwrites the msgfile. Is there a way to change this behaviour so that messages are appended to an exisiting msg file. Thanks, Vivek
0
1364
by: Vivek | last post by:
Hi, Ive written a test program for loading data into a table using the db2Load api. It works fine except when i specify COPY = YES USE TSM. Ive set the aforementioned attribute in the api by the following line of code: if(useTsm == 'Y' || useTsm == 'y') { loadParms.piCopyTargetList = &copyMediaList;
0
8270
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6730
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5870
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5440
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3901
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3944
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2424
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1511
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1256
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.