DB2 FOR LUW / DB2FORLUW / 970 - DB2

Using the a vendor library with admin_move_table function as 
follows: 
call admin_move_table('MYSCHEMA', 'SRC_TABLE', 'TARGET_TABLE', 
'COPY_USE_LOAD COPY YES LOAD /usr/lib/libnsrdb2.so', 'MOVE') 
 
receives : 
SQL3025N  A parameter specifying a filename or path is not 
valid. 
 
This error is usually raised if the vendor library is not 
accessible to the fenced user ID, but in version 9.7 FP9 this 
error will be raised as soon as a vendor library is specified. 
 
To circumvent the issue, there are 2 possibilities : 
1) declare c1 cursor for select * from myschema.src_table 
    load from c1 of cursor messages load.msg  replace into 
myschema.target_table copy yes load /usr/lib/libnsrdb2.so 
 
2) admin_move_table() call using  "COPY_USE_LOAD COPY YES LOAD 
/tmp"

**************************************************************** 
* USERS AFFECTED:                                              * 
* version 9.7 FP9 only is impacted                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.7 Fix pack 10                           * 
****************************************************************

First fixed in version 9.7 Fix pack 10

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.06.2014
10.11.2014
10.11.2014

9.7.FP10