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

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.