Results 1 to 1 of 1
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
- 01-31-2007 #1
- Join Date
- Jan 2007
db2 load command
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 schema.abc (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.