Prev: Special Register Scope
Next: International Journal of Electronics, Information and Systems (IJEIS) Call for Paper
From: Troels Arvin on 29 Dec 2009 16:39
Hello,

I'm trying to upgrade a DB2 v. 9.5.4 (AIX 64 bit) to version 9.7.1.
However, db2ckupgrade complains:
ADM4104E One or more databases are enabled for XML Extender. You must
remove the XML Extender functionality from the instance and databases
before upgrading. Please refer to the DB2 Information Center for
details on the steps to upgrade XML Extender including how to disable
XML Extender in databases.

I have no problem removing the XML Extender (someone before me
installed it, and it's not being used). However, I can't remove it.
First, I tried:
dxxadm disable_db DBNAME
DXXA002I Connecting to database "DBNAME".
DXXA035I XML Extender is disabling database "DBNAME". Please wait.
SQL0818N A timestamp conflict occurred. SQLSTATE=51003
DXXM001W A DB2 error occurred.
DXXG001E An internal error occurred in build "Jul 29 2009/05:03:17",
file "dxxsuwo.sqx", and line "346".

Next, I've tried, as instance owner, in the ~/sqllib/bnd directory::
db2 bind @dxxbind.lst
This went well.
But:
dxxadm disable_db DBNAME
DXXA002I Connecting to database "DBNAME".
DXXA035I XML Extender is disabling database "DBNAME". Please wait.
SQL0204N "DB2XML.DXXSHREDXML100MB" is an undefined name.
SQLSTATE=42704
DXXM001W A DB2 error occurred.
DXXA007E Cannot disable database "DBNAME".

Tried re-enabling XML Extender, and then disabling it again, but this
didn't work, either:
dxxadm enable_db DBNAME
DXXA002I Connecting to database "DBNAME".
DXXA005I Enabling database "DBNAME". Please wait.
DXXA070W The database has already been enabled.
bash-3.00$ dxxadm disable_db DBNAME
DXXA002I Connecting to database "DBNAME".
DXXA035I XML Extender is disabling database "DBNAME". Please wait.
SQL0204N "DB2XML.DXXSHREDXML100MB" is an undefined name.
SQLSTATE=42704
DXXM001W A DB2 error occurred.
DXXA007E Cannot disable database "DBNAME".

Argh! How do I get rid of the XML Extender?

--
Troels
From: Troels Arvin on 29 Dec 2009 17:07
On 29 Dec., 22:39, I wrote:
> Argh! How do I get rid of the XML Extender?

The following document helped:
http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21376442

--
Troels
 | 
Pages: 1
Prev: Special Register Scope
Next: International Journal of Electronics, Information and Systems (IJEIS) Call for Paper