resource name |
manual in which it is documented |
executable in which it has meaning |
description |
|
RTRDB |
RTRDB |
Specifies the protocol to be used between the RTRDB and arbitrator. If arbitrator_protocol is supplied, then so must arbitrator_service. The permitted values are: poly -
the standard Polyhedra client-server protocol (the arbitrator will be implemented as a Polyhedra database, with one record for each server in a special table); ose - a simple OSE signal based protocol that does not require the arbitrator to be a Polyhedra database or require a TCP/IP stack to be available; tcp - a simple TCP/IP based protocol that does not require the arbitrator to be a Polyhedra database; and, linx - a simple LINX based protocol that does not require the arbitrator to be a Polyhedra database. poly and tcp are supported on all platforms; the other options are platform-specific. |
|
RTRDB |
RTRDB |
Specifies the service by which the RTRDB connects to the arbitrator. If arbitrator_service is supplied, then the value of arbitrator_protocol determines how arbitrator_service is interpreted: poly - arbitrator_service contains either a standard Polyhedra data service name or a comma-separated list of data service names (this is the default: this protocol will be used if no value is supplied for the arbitrator_protocol resource); ose - arbitrator_service contains the name of the arbitrator process; tcp - arbitrator_service contains a TCP/IP port number; and, linx - arbitrator_service contains a LINX endpoint name. This resource is only required if the RTRDB is running as part of a fault tolerant configuration. |
|
ODBC DBI |
ODBC DBI |
Specifies the character set used for translating Unicode columns in the host database. The only acceptable values are ASCII and UTF-8. The default value is ASCII. |
|
RTRDB |
RTRDB |
Specifies the character set used by the SQL CHAR and VARCHAR and CL STRING data types. The allowable values are ASCII and UTF-8. The default value is ASCII. |
|
CL reference |
RTRDB |
A Boolean resource used to disable the execution of CL. If set to true, no CL will be executed. For CL running in the RTRDB, the SQL SEND command will not have any effect. The default value is false. |
|
CL reference |
CLC
RTRDB |
A Boolean resource that disables the use of the CL reserved words added in version 2.3. If set to true, the words catch, locate, throw and try will not be reserved. The default value is false, enabling the use of the new keywords. |
|
CL reference |
CLC
RTRDB |
The name of a CL class to instantiate as the run-time exception handler. The class specified must be derived from the predefined class ExceptionHandler. This is used to override the default behaviour of CL when it encounters a run-time error. See Utility Classes for more information. |
|
CL reference |
CLC |
The name of a CL class to be instantiated for the purpose of holding globally accessible attributes. If present, a single instance of the class is created before any other object. This object can be accessed from any CL handler using the special variable global. |
|
CL reference |
RTRDB |
A boolean resource used to suppress the execution of CL on a standby or replica database. The default is false. |
|
CL reference |
CLC
RTRDB |
A Boolean resource provided for backwards compatibility. If set to true, the CL bit functions operate on 32-bits rather than 64-bits, truncating their arguments to 32-bits and sign extending their result to 64-bits. The default is false. |
|
CL reference |
CLC
RTRDB |
A comma-separated list of CL source files to be loaded by CL on start up. The names can be specified with or without a path. If no path is given, the library is searched for in the list of CL library directories set up by the cl_library_path resource and the current directory. |
|
CL reference |
CLC
RTRDB |
A comma-separated list of directory paths. Whenever CL loads a library file it looks for it in each of the directories specified in this list. If it cannot find it in any of those directories, it then looks in the current directory. |
|
RTRDB |
RTRDB |
The maximum amount of memory in bytes that may be allocated by the CL sub-system. If this limit is exceeded then the RTRDB will attempt to recover by resetting the CL sub-system. This memory will be included in the memory_limit resource if that is set. A zero value indicates the default behaviour of no CL memory limit. |
|
CLC |
CLC |
This resource specifies a .bcl file into which compiled CL is to be saved. Note that bcl files produced in this way are not portable to different platforms or different versions of Polyhedra. |
|
CL reference |
CLC
RTRDB |
An integer resource specifying a stack size limit in bytes. If any CL thread uses more stack than the specified limit, a stack-overflow run-time exception is raised. The default value is 0, which specifies no limit. The limit is only checked each time a handler is called. |
|
User Guide |
CLC
ODBC DBI
RTRDB
SQLC
|
A string resource containing the address(es) of a Polyhedra server or service. This specifies the access point(s) by which clients connect to the database service. This must be defined for a server. A client requires this resource if it is to connect to a server.
|
|
CLC |
CLC |
A string resource containing the address of a Polyhedra server. See Section 4 of the Polyhedra User's Guide for detailed explanation of this resource. |
|
ODBC DBI |
ODBC DBI |
A string resource containing the address of the Polyhedra server. This specifies the name by which the server is known to the clients. See section 4 of the Polyhedra User's Guide for detailed explanation of this resource. |
|
RTRDB |
RTRDB |
A string resource containing the address of the Polyhedra server. This specifies the name by which the server is known to the clients. See section 4 of the Polyhedra User's Guide for detailed explanation of this resource. |
|
ODBC DBI |
ODBC DBI |
Specifies the ODBC data source name (DSN) used to establish connection to the host database. |
|
RTRDB |
RTRDB |
A string resource which conveys the name of an alternative table to be used for storing client connection details (see dataconnection class in the utility classes manual). |
|
RTRDB |
RTRDB |
A string resource which conveys the name of an alternative table to be used for storing data service listening port details (see dataport class in the utility classes manual) |
|
RTRDB |
RTRDB |
A string resource which conveys the name of an alternative table to be used to show current active queries (see the dataquery class in the utility classes manual) |
|
RTRDB |
RTRDB |
A string resource which conveys the name of an alternative table to be used for defining criteria for monitoring active queries (see the dataquerymonitor class in the utility classes manual) |
|
ODBC DBI |
ODBC DBI |
An integer resource specifying the level of output generated for debugging purposes. The default value is 0, indicating that no debug output is generated. A value of 1 causes catalogue information and query trace debug to be generated. |
|
Debugger |
CLC RTRDB |
This is specified by the RTRDB (or CLC) to which the telnet session is to connect. There is no default value. |
|
Debugger |
CLC RTRDB |
The name of a file containing a sequence of commands that are automatically executed when a debugging session is initiated. |
|
ODBC DBI |
ODBC DBI |
An integer resource that specifies the default polling interval in seconds for active queries. The default value is 600. This can be overridden on a per table basis using the poll_periods resource. |
|
RTRDB |
RTRDB |
(Flash DBMS only) The default maximum number of pages that may be allocated for a table. A value of 0 specifies that the number of pages is unlimited. The default value is 0. The value may be overridden using the WITH MAX table constraint. |
|
RTRDB |
RTRDB |
(Flash DBMS only) The default number of pages allocated for a table when it is created. The default value is 10. The value may be overridden using the WITH MIN table constraint. |
|
DVI |
RTRDB |
By default, a datum associated with a schedule is polled on database startup or when the datum is created. If the resource is set to true, the datum is first polled at the next time determined by the schedule record. |
|
DVI |
RTRDB |
A boolean resource which, if set to true, allows force write of a datum to be sent to driver even though a writeable column is null. |
|
DVI |
RTRDB |
If this resource is set to true then the initial write of a datum's values is sent with the registration message for the datum instead of being sent separately. This can reduce the time taken to initialise an RTRDB with many datums. Not all drivers support this protocol; setting it for drivers that do not support this functionality may cause the driver to crash. |
|
DVI |
RTRDB |
If this resource is set to true then the initial write of a datum's values when it is created in the RTRDB is suppressed. Setting this value to true can improve performance when many datums are created at once. |
|
DVI |
RTRDB |
Suppresses the comparison of datum updates sent from the driver to the RTRDB. This means that CL handlers in the RTRDB will be able to see all updates that the driver has sent rather than just seeing the changed values. |
|
DVI |
RTRDB |
Monitors all system and driver specific columns in order to prevent the user from updating read-only columns. Allows writes to be sent to the driver as soon as column is updated (rather than waiting for forcewrite to be set to true). |
|
SQLC |
SQLC |
This is used in conjunction with the edit command. It holds the name of the editor to be invoked. The default is vi. |
|
RTRDB |
RTRDB |
(Polyhedra IMDB only) A boolean resource which if set activates the journalling capability of the RTRDB. The default value is false unless journal_service is specified in which case the default it true. |
|
RTRDB |
RTRDB |
A Boolean resource that when set (the default is true) activates the parallel memory allocation scheme. This scheme improves performance by efficiently providing memory to client sessions within the RTRDB. Setting this resource to false may reduce memory usage at the expense of performance. The parallel memory allocation scheme requires the allocator library (liballoc.a on Linux) to be linked into the RTRDB. The default RTRDB executable includes this library. |
|
RTRDB |
RTRDB |
(Polyhedra IMDB only) A Boolean resource which if set activates the parallel transaction mode. |
|
User Guide |
CLC
RTRDB
SQLC
|
A string resource which can be set to indicate the "local" environment for a component. When data connection monitoring is enabled, this value appears in the env attribute of the DataConnection class (see Utility Classes manual). |
|
CLC |
CLC |
An environment string applied when connecting to a database. See section 4 of the Polyhedra users manual for further details. |
|
SQLC |
SQLC |
An environment string applied when connecting to a database. See section 4 of the Polyhedra users manual for further details. |
|
RTRDB |
RTRDB |
Specifies the levels of detail in the error text supplied with a transaction or query failure. The default value is 1. |
|
fileutil |
fileutil |
A boolean resource indicating whether the utility should attempt to convert the file into one with the current format. The default for this resource is false. This resource takes precedence over that of the newfilename resource if there a conflict over whether or not the utility should attempt to convert a file. If this resource is set to true when the resource newfilename is not specified then a warning message will be generated and an output filename will be used which is unique within the local directory.If this resource is set to true when a file written in the current format is being read then a warning message will be generated. |
|
fileutil |
fileutil |
A string resource giving the name of the file which contains Historic data. This resource is compulsory. |
|
RTRDB |
RTRDB |
(Flash DBMS only) The amount of RAM reserved for the database cache and other necessary runtime information in bytes. The default value is 20480. The RTRDB will not start-up if the cache size specified is too small. |
|
RTRDB |
RTRDB |
(Flash DBMS only) This resource optionally specifies a Polyhedra IMDB load file. The Flash DBMS database file (as specified normally with load_file) is initialised with the contents of this file. There are a number of unsupported configurations that will cause the RTRDB to terminate: the RTRDB is in FT mode; the load file contains any functionality not supported by Flash DBMS (e.g. domains, arrays); the load file contains journalled records (i.e. the load file must be created by a “SAVE INTO”); and, the load file contains CL and CL is enabled in the RTRDB (if CL is disabled, the CL in the load file is ignored). This conversion functionality requires the optional Fault Tolerance module. Please see the linking instructions for the relevant platform for how to link in this module. |
|
RTRDB |
RTRDB |
(Flash DBMS only) The number of pages by which the size of the database file is increased when it is required to grow. A value of 0 specifies that the file cannot grow in size. The default value is 100. The resource is used when a database file is created or an existing database file is loaded. |
|
RTRDB |
RTRDB |
(Flash DBMS only) The maximum size of the database file in pages. A value of 0 specifies that the size of the file is unlimited. The default value is 0. |
|
RTRDB |
RTRDB |
(Flash DBMS only) The size of the database file in pages. The default value is 100. The resource is used when a database file is created and when the flash_shrink_file resource is set. This resource is ignored when an existing database file is used. |
|
RTRDB |
RTRDB |
(Flash DBMS only) The page size of the created database file in bytes. Acceptable values are 512, 1024, 2048, 4096 and 8192. The default value is 1024. The RTRDB will not start-up if an invalid page size is specified. For optimal performance, the page size must be a multiple of the block size used by the Flash memory. This resource is ignored when an existing database file is used. |
|
RTRDB |
RTRDB |
(Flash DBMS only) A Boolean resource specifying whether to shrink the database file. A value of “true” specifies that an attempt is made to reduce the size of the database file when it is loaded. The default value is ‘false’. The resource can be used in conjunction with the flash_file_size resource to shrink a database file to a given size. Note that this functionality depends on a file system's ability to truncate files and may not work correctly on all file systems (for example some OSE file systems). |
|
RTRDB |
RTRDB |
(Flash DBMS only) A string resource that defines a file to receive database changes in swap file mode. The setting of this resource enables swap file mode. The value is affected by the load_file_directory resource. When set the load file is not written to, changes are written to the swap file in a non durable fashion and the number of writes to the file are minimised. |
|
User Guide |
CLC
RTRDB
SQLC
|
A boolean resource which if set to true causes fault tolerance to be enabled when connecting as a client. The default is false. |
|
User Guide |
CLC
RTRDB
SQLC
|
Specifies an interval in milliseconds between heartbeat messages. When connected, the client sends heartbeat messages to the server at this interval. The default value is 5000. |
|
User Guide |
CLC
RTRDB
SQLC
|
Specifies a period in milliseconds within which the client expects a reply to a heartbeat message. If no reply is received in this period, the service is considered to have failed. The default value is 5000. |
|
User Guide |
CLC
RTRDB
SQLC
|
Specifies the number of times an attempt is made to connect to a service before the service is considered to be unavailable. The default value is 0. |
|
User Guide |
CLC
RTRDB
SQLC
|
Specifies the interval in milliseconds between connection attempts. The default value is 0. |
|
Embedded |
RTRDB |
Where to read files from. Requires additional code to be attached to the database server. |
|
Embedded |
RTRDB |
for use with ftp_host resource |
|
Embedded |
RTRDB |
for use with ftp_host resource |
|
SQLC |
SQLC |
Specifies the name of a file containing SQLC and SQL commands that will be read and submitted when the client has connected. The client will terminate once the SQL has been included. |
|
historian |
RTRDB |
A boolean resource with a default value of false. If set, the Historian in a fault tolerant standby or a replica will request that it should be sent historical log file and archive file data in a compressed form during initial start-up. |
|
RTRDB |
RTRDB |
Specifies the number of times an attempt is made by a replica RTRDB to connect to the journal service of a master or replica RTRDB. A value of 0 specifies an unlimited number of attempts. The default value is 10. Once a replica RTRDB has established its first connection, it will make an unlimited number of attempts to connect and reconnect to a standby or second replica RTRDB, irrespective of the setting of this resource. |
|
RTRDB |
RTRDB |
Specify in milliseconds the interval between connection attempts to a master or standby RTRDB made by a replica RTRDB. The default value is 5000. |
|
RTRDB |
RTRDB |
Specifies in milliseconds the timeout for each connection attempt made by a standby or replica RTRDB. The default is 10000. |
|
RTRDB |
RTRDB |
Specifies in seconds the timeout that a replica RTRDB uses when waiting for a standby RTRDB to be promoted to master. The default value is 60. A replica RTRDB terminates if it loses connection to the replication service whilst obtaining its initial snapshot. |
|
RTRDB |
RTRDB |
Specifies in milliseconds the interval a journal server uses between checking its journal connections for heartbeat failure. A value of 0 disables checking. The default value is 1000. A journal server is aware of the heartbeat settings used by a journal client and if no heartbeat or other message is received within twice the specified interval, the server assumes the connection has failed and disconnects the client. |
|
RTRDB |
RTRDB |
Specifies in milliseconds the interval between journal heartbeat messages. When a journal client is connected, it sends heartbeat messages to the server at this interval. A value of 0 disables heartbeats. The default value is 1000. |
|
RTRDB |
RTRDB |
Specifies in milliseconds a period within which a journal client expects a server to reply to a heartbeat message. If no reply or other message is received within this period, the client assumes the connection has failed and disconnects from the server. A value of 0 disables heartbeats. The default value is 5000. |
|
RTRDB |
RTRDB |
Specifies a timeout in milliseconds. A standby or replica database will wait for twice this period for new data before terminating when loading the initial snapshot from the master RTRDB. It will also wait for twice this period for the connection to master to be broken before terminating. The default value is 60000. |
|
RTRDB |
RTRDB |
Specifies the number of transaction data buffers (each of size 4K bytes) that can be queued for journaling. If the queue fills up (due to not being emptied quickly enough), the next transaction will be blocked until there is room in the queue. The default value is 1000. When increasing the queue size you must be aware of the extra memory requirements. Each slot in the queue takes up 8 bytes on 32-bit platforms and 16 bytes on 64-bit platforms. An extra 4K bytes is used for each occupied slot. |
|
RTRDB |
RTRDB |
Specifies the maximum replication depth permitted for a particular configuration. The resource is only read by a standalone or master RTRDB and is communicated to and acted upon in any connected replica RTRDB. The default value is 2. A replica RTRDB will error and terminate if it reports a replication depth equal to the maximum replication depth and it is providing a journal service. |
|
RTRDB |
RTRDB |
Specifies the name of the data service on which the RTRDB listens for journal connections. Note that setting journal_service also enables the journalling capabilities of the RTRDB (see enable_journalling). |
|
RTRDB |
RTRDB |
Specifies the number of transaction data buffers (each of size 4K bytes) that can be queued for sending to each standby and replica database. By default if the queue fills up (due to not being emptied quickly enough), the connection to the standby or replica will be disconnected. The default value is 1000. A value of 0 specifies that the queue blocks until the data has been sent. When increasing the queue size you must be aware of the extra memory requirements. Each slot in the queue takes up 8 bytes on 32-bit platforms and 16 bytes on 64-bit platforms. An extra 4K bytes is used for each occupied slot. |
|
CLC |
CLC |
This resource specifies a .bcl file to load on startup. The file contains compiled CL. If the cl_library resource is set, then that resource takes precedence. |
|
RTRDB |
RTRDB |
This resource specifies a .dat file to load on start up. In Polyhedra IMDB, this file is overwritten whenever the contents of the database is saved to disk. In the Flash DBMS product, If the file does not exist when the RTRDB starts-up, it is created. If it already exists, and is a valid database file, it is used. If no value is supplied for this resource, a default name of ‘poly.fdb’ is used, but any existing file named ‘poly.fdb’ is ignored and overwritten. This behaviour emulates that of the IMDB product as much as possible. |
|
RTRDB |
RTRDB |
Specifies the directory containing the journal files (and the Flash DBMS swap file if applicable). Defaults to the current directory. |
|
historian |
RTRDB |
A boolean resource with a default value of true. When set to false, the Historian in a fault tolerant standby will not attempt to recover data from local log files which may not be stored elsewhere. |
|
historian |
RTRDB |
A string resource giving the default Historian directory. The Historian uses this directory to load and save all history data and archive files unless specifically directed otherwise. If omitted, the default directory is the current directory. |
|
historian |
RTRDB |
A boolean resource with a default value of false. If set, the Historian will automatically adjust the compression period which is an exact multiple of one day when that period straddles a transition between standard and daylight saving time so that the compression period starts at the same local time of day. |
|
historian |
RTRDB |
A boolean resource with a default value of false. If set, the Historian will store the timestamp of each logged raw event with the maximum available granularity rather than recording an increment of centiseconds from the last full timestamp. Note when used with a fault tolerant configuration the resource should be set the same on every RTRDB (master, standby and replicas). |
|
historian |
RTRDB |
An integer resource with a default value of 0. This controls the production of statistics relating to Historian start-up, output by either a fault tolerant standby or a replica. The value of the resource specifies the level of detail included in the statistics as follows: 0 (the default value) - no statistics are output; 1 - summary statistics are output when start-up has completed that includes the time taken to start-up, the number of bytes transferred and the number of files synchronised, with subtotals for log and archive files; and, 2 - in addition to the summary statistics, progress statistics are output during the start-up. When the initial database snapshot has been transferred a message is output that includes the number of bytes transferred. Each time a file is transferred a message is output that includes the name of the file, the number of bytes synchronised so far, with percentages against total bytes, and number of files synchronised so far, with subtotals for log and archive files and a comparison against total number of files. |
|
historian |
RTRDB |
An integer resource that sizes the pool of threads available to service requests from streaming API clients. |
|
RTRDB |
RTRDB |
The memory usage limit (in bytes) above which the RTRDB will attempt to reduce memory usage as defined in the section on Memory Exhaustion Recovery in the RTRDB reference manual. A zero value indicates the default behaviour of no memory limit. This resource differs from the (deprecated) memory_usage_limit resource in that it will attempt to recover from the low-memory situation. |
|
RTRDB |
RTRDB |
This is deprecated and will be removed from a future release. If non-zero, this specifies in bytes a level of memory usage that if exceeded will cause the RTRDB to automatically terminate. When non-persistent memory usage exceeds the specified limit, the RTRDB generates a warning and performs an automatic termination at its earliest opportunity. Before doing so and also during the process of terminating its non-persistent memory usage may further exceed the limit. This feature is only available if fast memory allocation is used. The pre-built RTRDB executables do not use fast memory allocation and so the RTRDB must be re-linked to use this resource. On 64-bit systems a value greater than 2^32 is interpreted correctly. |
|
RTRDB |
RTRDB |
An integer resource specifying the number of entries allocated in each internal message queue used by the RTRDB. Changing this value will affect the memory allocated by the RTRDB for client sessions. Note that setting the value too low may degrade the performance of the RTRDB. The default value is 1000. It is an error to set msg_queue_size to less than 2. |
|
fileutil |
fileutil |
A string resource giving the name of any output file. If this resource is specified then the utility will attempt to convert the file being read into one with the name given unless the fileconvert resource is set to false. In this case a warning message will be generated and no conversion will be attempted. If there is an existing file with the given name then a different filename will be used and a warning message will be generated. |
|
RTRDB |
RTRDB |
Specifies the name of the journal service on which the other RTRDB listens for connections. This resource is only required when configuring a fault tolerant system. Note that other_journal_service is ignored when using the OSE signal based arbitrator protocol. Instead, the journal service of the master database is supplied in the message from the arbitrator. |
|
User Guide |
CLC
ODBC DBI
RTRDB
SQLC
|
A password used to authenticate the user specified by the username resource and establish a session on the client connection defined by the data_service resource. This is only required if security is enabled on the database. |
|
CLC |
CLC |
A password used for authentication when connecting to a database with security enabled. See Section 4 of the Polyhedra users guide for further details. |
|
ODBC DBI |
ODBC DBI |
The password used to connect to the host database. Although connection to some host databases may not require a username and password, a value for this resource must be supplied. |
|
RTRDB |
RTRDB |
Specifies the method by which passwords are protected. If security is not enabled then the resource has no discernible effect. The default value is 0. |
|
SQLC |
SQLC |
A password used for authentication when connecting to a database with security enabled. See Section 4 of the Polyhedra users guide for further details. |
|
ODBC DBI |
ODBC DBI |
Specifies polling periods for individual tables. The value is a semicolon separated list of table poll period settings. For tables not included in the list, the value specified by the default_poll_period resource is used. |
|
RTRDB |
RTRDB |
A Boolean resource that changes the way active queries are handled by the database. Normally, when updates are reported to a client, the server only sends the changed attributes. When this resource is set to true, the all the attributes are also transmitted, regardless of whether they are changed. This affects the behaviour observed by all clients, and so should be used with caution, and only when use is being made of the callback API. The default is false. |
|
RTRDB |
RTRDB |
A Boolean resource that changes the way active queries are handled by the database. Normally, when updates are reported to a client, the server only sends the changed attributes. When this resource is set to true, the primary key attributes are also transmitted, regardless of whether they are changed. This affects the behaviour observed by all clients, and so should be used with caution, and only when use is being made of the callback API. The default is false. |
|
ODBC DBI |
ODBC DBI |
A Boolean resource provided for backwards compatibility. If set to true, all queries return integer expressions as 32-bit. The default is false. |
|
RTRDB |
RTRDB |
A Boolean resource provided for backwards compatibility. If set to true, all queries return integer expressions as 32-bit. The default is false. |
|
ODBC DBI |
ODBC DBI |
Specifies either the full path name of the query processor executable or just the name of the executable. In the latter case, the PATH system environment variable is used to locate the executable. The default is qp. |
|
ODBC DBI |
ODBC DBI |
Specifies the number of milliseconds the ODBC DBI waits before attempting to connect to the query processor. The default value is 5000. |
|
ODBC DBI |
ODBC DBI |
An integer resource specifying the number of query processors used by the ODBC DBI for processing queries. The default is 1 |
|
ODBC DBI |
ODBC DBI |
An integer resource specifying the first port number of the range of sequential port numbers allocated to each query processor by the ODBC DBI. The default is 10000. |
|
fileutil |
fileutil |
A boolean resource indicating whether the file conversion utility will perform its action with only minimal output. The default for this resource is false. If this resource is set to false then the utility will display the file contents. |
|
fileutil |
fileutil |
A boolean resource indicating whether the file conversion utility will quit immediately once it has completed its actions. The default for this resource is false. This resource only has any material effect on Windows platforms. |
|
RTRDB |
RTRDB |
Specifies a UDP port to which a single four-byte message (“POLY”) is sent when the database is ready to accept client connections. This resource is optional. |
|
RTRDB |
RTRDB |
Specifies the number of transaction data buffers (each of size 4K bytes) that can be queued in the replica. If the queue fills up (due to it not being emptied quick enough), data from the server will be blocked until there is room in the queue, which can cause data to queue up at the server and eventually the replica connection to be closed. The default value is 1000. Values less than 1000 are ignored. When increasing the queue size you must be aware of the extra memory requirements. Each slot in the queue takes up 4 bytes which when occupied also uses an extra 4K per slot. |
|
RTRDB |
RTRDB |
(Polyhedra IMDB only) Specifies the name of the journal service(s) to which an RTRDB running in replica mode connects to obtain its journal stream. Use of the resource implies the RTRDB is running in replica mode. |
|
CLC |
CLC |
CLC starts the application by creating a single instance of this class. This resource is compulsory. |
|
CLC |
CLC |
A Boolean resource (default false) indicating whether transactions should be submitted in safe-commit mode. |
|
RTRDB |
RTRDB |
A boolean resource (with default false) indicating whether transactions performed through the internal connection or using a dataservice object should be submitted in safe-commit mode. |
|
SQLC |
SQLC |
A boolean resource (default false) indicating whether transactions should be submitted in safe-commit mode. The resource is ignored when executing a CALL command. |
|
RTRDB |
RTRDB |
The number of bytes that an individual client session may use before the RTRDB takes steps to reduce the memory consumption of the session – as defined in the section on Memory Exhaustion Recovery in the RTRDB reference manual. The memory accounted for by a client session is included in the total limited by the memory_limit resource. A zero value indicates the default behaviour of no session memory limit. |
|
RTRDB |
RTRDB |
A boolean resource which if true forces the journal file to be saved on shutdown. Applies even if journaling is disabled. The default is false. |
|
RTRDB |
RTRDB |
A boolean resource which if true sets the default table column persistence to transient rather than persistent. The default is false. |
|
RTRDB |
RTRDB |
A boolean resource which if true disables the SQL reserved words LIMIT and OFFSET that were introduced in Polyhedra 8.3. Note that the functionality associated with these reserved words is also disabled. This resource is provided as a migration aid and may be withdrawn in later versions of Polyhedra. |
|
ODBC DBI |
ODBC DBI |
The name of a textual file containing the prototypes of the SQL functions supported by the host database. |
|
DVI |
RTRDB |
A boolean resource which, if set to true, prevents the DVI from creating DVI tables at start up. |
|
RTRDB |
RTRDB |
A boolean resource which if true prevents CL source being loaded and executed. The default is false. |
|
DVI |
RTRDB |
A boolean resource which, if set to true, prevents the DVI from running. |
|
DVI |
RTRDB |
A boolean resource which, if set to true, prevents automatic initialisation of built in DVI drivers. |
|
RTRDB |
RTRDB |
(Polyhedra IMDB only) A boolean resource which if true disables the Historian subsystem. The default value is false. |
|
RTRDB |
RTRDB |
(Polyhedra IMDB only) A boolean resource which if true prevents a standby RTRDB from writing a snapshot when it connects to the master RTRDB. The resource only has any effect if journalling is disabled. The default value is false. |
|
RTRDB |
RTRDB |
A boolean resource which if true enables the setting of the SO_KEEPALIVE socket option on client TCP socket connections accepted by the RTRDB. The default value is false. |
|
RTRDB |
RTRDB |
An integer resource specifying the initial number of database threads. The default value is 1. It is an error to set thread_pool_initial to less than 1 or greater than thread_pool_limit. |
|
RTRDB |
RTRDB |
An integer resource specifying the maximum number of database threads. The default value is 1024. It is an error to set thread_pool_limit to less than thread_pool_initial. |
|
RTRDB |
RTRDB |
An integer resource specifying the number of database threads. This specifies a fixed size thread pool and is an alternative to setting both thread_pool_initial and thread_pool_limit to the same value. It is an error to set thread_pool_size and either thread_pool_initial or thread_pool_limit. |
|
ODBC DBI |
ODBC DBI |
An integer resource specifying the number of query processors used by the ODBC DBI for processing transactions. The default is 1. |
|
CLC |
CLC |
Specifies the type of Polyhedra component to be executed. It must be set to clc to run the CLC. This resource is compulsory. |
|
fileutil |
fileutil |
This is used to specify the type of Polyhedra component to be executed. If it is supplied then it must be set to fileutil. |
|
ODBC DBI |
ODBC DBI |
Specifies the type of Polyhedra component to be executed. It must be set to dbi. This resource is compulsory. |
|
RTRDB |
RTRDB |
This is used to specify the type of Polyhedra component to be executed. It must be set to rtrdb. This resource is compulsory. |
|
SQLC |
SQLC |
This is used to specify the type of Polyhedra component to be executed. It must be set to sqlc. This resource is compulsory. |
|
fileutil |
fileutil |
A boolean resource indicating whether the utility should attempt to convert the file from an ASCII to Unicode. That is, from one using the ASCII character set to one using the UTF-8 character set. If this resource is set to true, the file specified by the filename resource is converted to use the UTF-8 character set. The file is converted without writing a new file. If the file contains any 8-bit ASCII (top-bit set) character data, an error is generated and the file is not converted. |
|
ODBC DBI |
ODBC DBI |
A boolean resource specifying whether to use unique indexes as pseudo primary keys. |
|
CLC |
CLC |
A username used for authentication when connecting to a database with security enabled. See Section 4 of the Polyhedra users guide for further details. |
|
ODBC DBI |
ODBC DBI |
The username used to connect to the host database. Although connection to some host databases may not require a username and password, a value for this resource must be supplied. |
|
SQLC |
SQLC |
A username used for authentication when connecting to a database with security enabled. See Section 4 of the Polyhedra users guide for further details. |