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?
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)
Issue/Introduction
Could we make the 'cachekey' column the primary key in the 'cache_status' table?
Feedback
Yes
No
Powered by
