DB2 - Problembeschreibung
Problem IT02497 | Status: Geschlossen |
ADMIN_MOVE_TABLE FUNCTION RECIEVES SQL3025N AFTER UPGRADE TO VERSION 10.1 FP4 | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to version 10.1 Fix Pack 5 * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in version 10.1 Fix Pack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.06.2014 16.07.2015 16.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |