Could we make the 'cachekey' column the primary key in the 'cache_status' table?
Article ID: KB0072770
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
For a 'cache_status' table belonging to any data source in TIBCO Data Virtualization, could we make the 'cachekey' column the primary key in the table?
Issue/Introduction
Could we make the 'cachekey' column the primary key in the 'cache_status' table?
Resolution
The cachekey column values are not meant to be unique.
In a given cache_status table the combination of the values of the following columns should be unique:
1. clusterid (nullable)
2. serverid (not nullable)
3. cachekey (not nullable)
Feedback
Yes
No
Powered by
