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

db2 load command

P: 2
Hi All,

Needed help regarding the db2 load command.

I am trying to load the data into a db2 table from a text file executed from UNIX shell prompt as below.

db2 "LOAD CLIENT FROM '/application/xyz/abc.Txt' OF DEL MODIFIED BY CODEPAGE=1252 P (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) INSERT INTO (m,n,o) NONRECOVERABLE INDEXING MODE AUTOSELECT"

where 'abc' is the table name, abc.txt is the text file from where i am loading the data.
once the above command is executed the process is stuck for a long time. The db2 is not able to read from the above mentioned directory '/application/xyz/abc.Txt' .

The directory 'xyz' is a mounted directory which is being shared from a different server which has only root privilages.
Is there any ways i can resolve this issue?
Any help regarding the same will be appreciated.

Oct 13 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.