By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,190 Members | 777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,190 IT Pros & Developers. It's quick & easy.

db2load remote database

P: n/a
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
Share this Question
Share on Google+
7 Replies


P: n/a
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

P: n/a

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

P: n/a
In article <11**********************@i3g2000cwc.googlegroups. com>,
te*********@gmail.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_LOCATION), check the
tbmove.sqc sample in your <DB2_PATH>\samples\c directory.
Sep 22 '06 #4

P: n/a
For remote db, you should use
db2 load client from ....
There must be similar api.
Gert van der Kooij wrote:
In article <11**********************@i3g2000cwc.googlegroups. com>,
te*********@gmail.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_LOCATION), check the
tbmove.sqc sample in your <DB2_PATH>\samples\c directory.
Sep 22 '06 #5

P: n/a
In article <11**********************@m73g2000cwd.googlegroups .com>,
sh*******@gmail.com says...
Gert van der Kooij wrote:
In article <11**********************@i3g2000cwc.googlegroups. com>,
te*********@gmail.com says...
>
Knut Stolze wrote:
.....

You have to set the right options (SQLU_CLIENT_LOCATION), check the
tbmove.sqc sample in your <DB2_PATH>\samples\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

P: n/a

Thanks guys.

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

Gert van der Kooij wrote:
In article <11**********************@m73g2000cwd.googlegroups .com>,
sh*******@gmail.com says...
Gert van der Kooij wrote:
In article <11**********************@i3g2000cwc.googlegroups. com>,
te*********@gmail.com says...

Knut Stolze wrote:
....
>
You have to set the right options (SQLU_CLIENT_LOCATION), check the
tbmove.sqc sample in your <DB2_PATH>\samples\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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.