What is the normal behavior followed by "Use Default Cache Database" optioned in TDV clustered environment?

What is the normal behavior followed by "Use Default Cache Database" optioned in TDV clustered environment?

book

Article ID: KB0080125

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.6 and higher

Description

What is the normal behavior followed by "Use Default Cache Database" optioned in TDV clustered environment?

Issue/Introduction

This articles is about the normal behavior followed by "Use Default Cache Database" optioned in TDV clustered environment.

Environment

All operating systems

Resolution

When the option  "Use Default Cache Database" is used for caching in a clustered environment, the cache refresh request will be hit on all the nodes in the cluster.
The default database used by the TDV is PostgresSQL 9.1. This behavior is by design.
Hence, it is always advised not to use the option "Use Default Cache Database" database in production environment.
External DB's can be used for storing the cached data. When using external databases for caching, create cache_status and cache_tracking tables at the data source configuration.