db2 load command

[georgejibin]

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 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.

Thanks
Jib