Creating indexes on Data Source based on the details provided in an index file is only supported if data source format is not SQL.

book

Article ID: KB0090543

calendar_today

Updated On:

Products Versions
TIBCO Collaborative Information Manager -
Not Applicable -

Description

Resolution:
Description:
============
After placing the index file under “$MQ_COMMON_DIR\enterprise\datasource\datasourcename.idx”,  the indexes will not be created if the datasource format is SQL

Environment:
============
TIBCO Collaborative Information Manager (CIM) 8.2.0

Symptoms:
=========
Indexes are not created on the datasource table even when details provided in an index file.

Cause:
======

This feature is not supported if datasource format is SQL.

Resolution:
===========
If the datasource format is SQL, this feature is not supported. Manually create the indexes.

Issue/Introduction

Creating indexes on Data Source based on the details provided in an index file is only supported if data source format is not SQL.