home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT02497 Status: Closed

ADMIN_MOVE_TABLE FUNCTION RECIEVES SQL3025N AFTER UPGRADE TO VERSION 10.1
FP4

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
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 10.1 FP4 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"
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 10.1 Fix Pack 5                           * 
****************************************************************
Local Fix:
Solution
First fixed in version 10.1 Fix Pack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
12.06.2014
16.07.2015
16.07.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList