IBM Support

DB2 Net Search Extender text index operations fail with SQL0206N "AUXLOGTABLESCHEMA" is not valid in the context where it is used. SQLSTATE=42703

Troubleshooting


Problem

After migrating from DB2 V9.5 to DB2 V9.7 executing the command , "db2text drop index INDEXSCHEMA.INDDEXNAME for text " will return the following error. CTE0100 A DB2 Operation failed. DB2 information: "42S22" "[IBM][CLI Driver][DB2/NT] SQL0206N "AUXLOGTABLESCHEMA" is not valid in the context where it is used. SQLSTATE=42703

Symptom

Net Search Extender Text Indexes stop working.

Cause

The Net Search Extender Database Migration Program was not run on the failing database.

Diagnosing The Problem

1) db2 connect to database

2) db2 "select eventviewname from db2ext.textindexes"

3) db2 "select * from db2ext.[value from the above select]"

4) look for CTE0100 A DB2 Operation failed. error messages

Resolving The Problem

Run the db2extmdb migration script to migrate the database that are enabled for Net Search Extender using the following syntax:

db2extmdb database-name

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Extenders - Net Search","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7","Edition":"Advanced Enterprise Server;Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPFH","label":"Db2 Net Search Extender"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018

UID

swg21588259

Page Feedback