home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList