I have sucessfully restored db2 V8.1 AIX backup on SPARC Solaris
machine, but I am having problems creating a table because a nickname
with the same name exists in target schema.
When I try to drop a nickname I get:
db2 => drop nickname RESDATA.ORG
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL10013N The specified library "libdb2drda.a" could not be loaded.
SQLSTATE=42724
db2 =>
Library "libdb2drda.a" exists only on AIX platform and besides having
a different name, it is located in different directory than on
Solaris:
AIX /usr/opt/db2_08_01/lib/libdb2drda.a
Solaris /opt/IBM/db2/V8.1/lib/ libdb2drda.so
I managed to drop existing DRDA wrapper made on AIX and created a new
one with correct Solaris library, but I get the same error as before
when dropping nickname.
Unfortunately it is not possible to force drop a nickname or rename it
to a less meaningfull name so it does not conflict with the table I am
trying to create.
Does anyone have a solution or workaround for this issue ?
>> Stay informed about: restored db on solaris from aix - SQL10013N with drop nick..