text extenders error can't find indexes

[wayne mcfadden]

Hi,
I'm stumped. Our text extenders stopped working on one database. I
think that i'm missing something simple here.
The column is enabled...
but when you do an index status
it doesn't know anything about it.

Any thoughts?

Thanks
Wayne

db2tx => connect to ball user fdsafasdf using asdfdsadsaf
Database Connection Information
Database product = DB2/6000 07.02.0008
SQL authorization ID = DB2INST1
Local database alias = BALL

db2tx => ENABLE DATABASE

DES0765N The database is already enabled for DB2 Text Extender.

db2tx => enable text column catentdesc LONGDESCRIPTION HANDLE
DESCRIPTION

DES0779I Indexing has been started successfully. To check indexing
status use 'GET INDEX STATUS'.

DB2TX=> get index status catentdesc handle DESCRIPTION

DES0324N The DB2 Text Extender text index name in the text handle is
not known.

db2tx => enable text column catentdesc LONGDESCRIPTION HANDLE
DESCRIPTION

Database Connection Information
Database product = DB2/6000 07.02.0008
SQL authorization ID = DB2INST1
Local database alias = BALL

DES0736N 'DESCRIPTION' is already a handle column in table
'DB2INST1.CATENTDESC.'

db2tx => get index status catentdesc handle DESCRIPTION

DES0324N The DB2 Text Extender text index name in the text handle is
not known.

db2tx =>
db2 => SELECT SUBSTR(tablename, 1,15), SUBSTR(handlename,1,15),
indexname FROM db2tx.textcolumns

1 2 INDEXNAME
--------------- --------------- ---------
CATENTDESC - IX422811
CATENTDESC DESCRIPTION IX422811

2 record(s) selected.