To close open tables after processing data, set the following value:

 

TABLECACHE=0

 

CONNX caches tables automatically to save reconnect time.

 

 

Note: By default, CONNX keeps logical links open to any table/file that is accessed during the lifetime of a connection. For flat file data sources, such as RMS, VSAM, C-ISAM, DISAM, Micro Focus, Dataflex, and PowerFlex, TableCache controls how CONNX opens and closes the underlying data file.
 

For relational databases, such as DB2, Oracle, and SQL Server, for example, TableCache has very little impact because relational tables do not need to be "opened".

 

When TableCache is set to 0,  CONNX opens the file in the appropriate access mode when necessary, and closes the file as soon as it is no longer needed.

 

When TableCache is set to 1, the first time a query is executed that accesses a table in a given mode (either read only, or read/write), CONNX opens that file in the specified mode, and keeps the file open for the duration of the connection.  When TableCache is enabled, the amount of memory used by the data server is increased.

 

For backward compatibility, the setting of 2 and 1 have the same meaning.
 

 

Default = 2.

 

Environment: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  TABLECACHE

Unix Registry Setting: CONNX.TABLECACHE