Upgrade DB2 Text Search from v9.7 to v10.5.5

[Gregor Kovač]

Hi!

I have installed DB2 v10.5.5 on Ubuntu 32-bit. I did a restore of a database from v9.7.5 64-bit.
Everything is OK, except for the Text Search:
- running CALL SYSPROC.SYSTS_UPGRADE_CATALOG('en_US',?) says that the catalog is already up to date
- running CALL SYSPROC.SYSTS_UPGRADE_INDEX('en_US', ?) says CIE0320E Table space "" does not exist.

Now I cannot drop existing indexes, .....
For example: for db2ts "UPDATE INDEX INDX.WEB4 FOR TEXT CONNECT TO TESTDB" I get "SQL0206N "SERVERID" is not valid in the context where it is used. SQLSTATE=42703"

Any pointers how this can be solved?

Best regards,
Kovi

[Gregor Kovač]

Dne sreda, 10. junij 2015 13.08.45 UTC+2 je oseba Gregor Kovač napisala:

I ended up doing this:
- remote all text search indexes on source database
- disable text search on source database
- do a backup
- restore on target system
- enable text search on target database
- create all text search indexes on target database

[shra...@gmail.com]

I have been trying to upgrade my 9.7.7 db to 10.5.5 along with text search.But every time I get stuck at the same place

ADM4003E The UPGRADE DATABASE command failed to upgrade the DB2 Text Search
catalogs or indexes due to an error in stored procedure
"SYSPROC.SYSTS_UPGRADE_CATALOG".

And when I try to run the procedures I am getting

db2 "CALL SYSPROC.SYSTS_UPGRADE_CATALOG('en_US',?)"
SQL20427N An error occurred during a text search administration procedure or
command. The error message is "CIE0213W The DB2 Text Search catalog has been
upgraded to the current". SQLSTATE=38H14


db2 "CALL SYSPROC.SYSTS_UPGRADE_INDEX('en_US', ?)"
SQL20427N An error occurred during a text search administration procedure or
command. The error message is "CIE0320E Table space "" does not exist. ".
SQLSTATE=38H14


and my text search version shows

db2 "SELECT substr(value,1,15) FROM sysibmts.systsdefaults WHERE name='VERSION'"

1
---------------
DB2 10.05.0004

It should be 10.05.0005 not for.

Please suggest

[Gregor Kovač]

Dne petek, 14. avgust 2015 14.11.45 UTC+2 je oseba shra...@gmail.com napisala:

I've been struggling with this also and at the end I did it like this:
- drop all text search indexed and disable database for text search
- install 10.5.5
- upgrade database to 10.5.5
- enable database fro text search
- recreate all text search indexes

This worked for me and I hope it will work for you too.