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 |