Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

restored db on solaris from aix - SQL10013N with drop nick..

 
   Database Help (Home) -> DB2 RSS
Next:  Sunday Dec 21 2008  
Author Message
senad.jahic

External


Since: Dec 21, 2008
Posts: 1



(Msg. 1) Posted: Sun Dec 21, 2008 10:27 am
Post subject: restored db on solaris from aix - SQL10013N with drop nickname
Archived from groups: comp>databases>ibm-db2 (more info?)

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.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
db2 procedure in solaris - Here are two simple stored procedures which were there in a database on a SOLARIS machine, one with an input parameter and the other with no parameter. From a Linux DB2 client command prompt, the call to stored procedure with no parameter works fine wher...

DROP PACKAGE with hex zeroes - I accidentally created a package with a VERSION string that contains hex zeroes in it. Specifically: SELECT hex(pkgversion) as hexver FROM SYSCAT.PACKAGES where pkgschema = 'VSEUSER' and pkgname = 'CICSDD18'; HEXVER..

DB2 UDB LUW 8.2:clp 32 bit connect to 64 bit engine - Environment: DB2 UDB LUW (AIX) 8.2 Database instance: test migration to 64 bit Clients: 32 bit, embedded sql, db2 clp When PATH/LIBPATH point to the 32 lib environment (/usr/opt/db2_08_01/bin and (/usr/opt/db2_08_01/lib) db2..

How to reterive the last 5 records in a table? - Hi I have a table which contains number of rows. I want to fetch the last 5 records from the table. I know for the first 'n' records we can use FETCH FIRST n ROWS ONLY command. But i want to fetch last 5 records. Can any one help in this... ..

"FIND" command is narrowed - In the ISPF editor I am using, for a particullar PO Dataset I am getting the result of FIND statement narrowed down to the colums 48-56. i.e. if I give "FIND 'TO' ALL", the result I am getting as "CHARS 'TO' - found 239 times within colum...
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]