Hi,
I need some help. I am trying to load a table using the load command. The extracted data file, script both reside on the server. Whenever I run the command I am getting the error as
SQL3025N A parameter specifying a filename or path is not valid.
The SQL command is
load from ship_info.ixf of ixf replace into "ABCD".ship statistics yes with distribution and detailed indexes all nonrecoverable cpu_parallelism 3
I have put this sql in a script file called ld_test.sql and will get the error when I execute the script as
db2 -tvf ld_test.sql
The strange thing is, when I run same scripts on another database which is on the same instance, it works fine. But only on this database it is giving the error. The user is same for both the databases and he is in SYSADM group.
Any suggestion to make this to work is highly appreciated.
Thanks in advance
I need some help. I am trying to load a table using the load command. The extracted data file, script both reside on the server. Whenever I run the command I am getting the error as
SQL3025N A parameter specifying a filename or path is not valid.
The SQL command is
load from ship_info.ixf of ixf replace into "ABCD".ship statistics yes with distribution and detailed indexes all nonrecoverable cpu_parallelism 3
I have put this sql in a script file called ld_test.sql and will get the error when I execute the script as
db2 -tvf ld_test.sql
The strange thing is, when I run same scripts on another database which is on the same instance, it works fine. But only on this database it is giving the error. The user is same for both the databases and he is in SYSADM group.
Any suggestion to make this to work is highly appreciated.
Thanks in advance