"K" to "M" Configuration Settings
KEEPDASHES
If set to 0, the dashes and dots in imported column and table names are replaced with underscores.
Default - KEEPDASHES = 1
Example
With KEEPDASHES = 0, table.name becomes table_name when imported.
Environments - Client
Configuration Manager: CONNX Settings; Current Key CONNX\CDD Options
KEEPHYPHENS
If set to 1, all Adabas SYSOBJH imports will keep their hyphenated names when imported into the CDD.
Default - KEEPHYPHENS = 0 (hyphens are not retained during import procedures)
Environments - Client, Windows, Unix, Adabas
Configuration Manager: CONNX Settings; Current Key = CONNX\Adabas; Key Value/Value Name = KEEPHYPHENS
Unix Environment Variable: KEEPHYPHENS
KEEPGROUPS
For Adabas, during FTP Import, typically the high level group name is not imported. The only imported fields those that make up the group (PE). If this setting is set to 1, the group fields themselves are also imported.
Default - KEEPGROUPS = 0
Environments - Client, Server,Windows, Mainframe, Unix, Adabas
Configuration Manager: CONNX Settings; Current Key = CONNX\Adabas; Key Value/Value Name = KEEPGROUPS
Unix Environment Variable: KEEPGROUPS
Started Task:KEEPGROUPS
CICS: KEEPGROUPS
LICENSESERVER
The name of the server hosting the CONNX License server.
Environments - Client, Windows, Unix
Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name = LICENSESERVER
Unix Registry Setting: CONNX.LICENSESERVER
LICENSESERVERPORT
The port used to connect to the CONNX License server.
Default - LICENSESERVERRPORT = 7501
Environments - Client, Windows, Unix
Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name = LICENSESERVERPORT
Unix Registry Setting: CONNX.LICENSESERVERPORT
LICENSESOURCE
This setting is used by the CONNX Installation utility and does not need to be edited. This specifies the location of the source license files that was specified during the last installation.
LISTENQUOTA
This setting determines the maximum TCP/IP backlog of sockets for the VSAM server running under CICS. Used as a parameter to the listen command. This setting only applies on CICS systems.
This option should not be changed unless instructed by CONNX Technical Support.
Default - LISTENQUOTA = 5
Environments - Server
CICS: CNXBARNARD
LOGLOC
Use LOGLOC to change the default CONNX JDBC server log file location. Usage:
LOGLOC = <directory path>
Default - Current working directory (C:\CONNX32\)
Environments - Client, Windows, Unix
Configuration Manager: CONNX Settings; Current Key = JDBC; Key Value/Value Name = LOGLOC
Unix Configuration Setting: JDBC.LOGLOC
LOWERCASEONLY
If set to 1, this setting forces column and table names to appear in lowercase on import.
Default - LOWERCASEONLY = 0
Environments - Client, Windows, Unix
Configuration Manager: CONNX Settings; Current Key = CONNXCDD\OPTIONS; Key Value/Value Name = LOWERCASEONLY
Unix Registry Setting: CONNXCDD.OPTIONS.LOWERCASEONLY
LSNDEBUG
This setting configures tracing for the listener process. Possible values are 0 to 3. The log messages are written to cnxrun.log.
0 | Logging is disabled. |
1 | Minimal logging level. |
2 | Moderate logging level. |
3 | Full logging level. |
Default - LSNDEBUG = 0 (Logging is disabled)
Environments - Client, Server, Windows, Unix, Mainframe
Configuration Manager: CONNX Settings; Current Key = CONNX, Key Value/Value Name = LSNDEBUG
Unix Client Registry Setting: CONNX.LSNDEBUG
Unix Server Environment Variable: LSNDEBUG
Started Task: LSNDEBUG
CICS: LSNDEBUG
MAPFILEINCREMENTSIZE
This setting determines the extension size of a memory mapped file for holding temporary results.
Default - MAPFILEINCREMENTSIZE = 16000000
Environments - Client, Windows, Unix
Configuration Manager: CONNX Settings; Current Key = CONNX, Key Value/Value Name = MAPFILEINCREMENTSIZE
Unix Registry Setting: CONNX.MAPFILEINCREMENTSIZE
MAXARRAYCOUNT
This Adabas setting determines the default maximum number of occurences for an MU or PE during the import process. If the MU or PE occurrence count exceeds the old maximum of 192, please increase this value to the new maximum, up to the size of 65535.
If this value is changed, the table must be re-imported in order to see the effect
Default - MAXARRAYCOUNT = 192
Environments - Windows
Configuration Manager: CONNX Settings; Current Key = CONNX/Adabas; Key Value/Value Name = MAXARRAYCOUNT
MAXROWSCOMPARED
This setting can prevent runaway queries in non-relational databases.
If set to a non zero value, when a search is performed, CONNX searches the number of records specified in MAXROWSCOMPARED. If there is a match (at least one record returned), the entire database is searched. If there no match (no records returned), the search stops and an error is returned. Usage:
MAXROWSCOMPARED = value
Default - MAXROWSCOMPARED = 0 (disabled)
Environments - Server, Windows, Unix, Mainframe
Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name = MAXROWSCOMPARED
Unix Environment Variable: MAXROWSCOMPARED
Started Task: MAXROWSCOMPARED
CICS: MAXROWSCOMPARED
MAXROWSFETCHED
You can use this setting to define the number of rows that are read by the database table in a single query scan. Usage:
MAXROWSFETCHED = value
Default - MAXROWSFETCHED = 0
See
MAXROWSFETCHEDFAIL to determine whether MAXROWSFETCHED queriers should terminate normally or generate an error message.
Environments - Server, Windows, Unix, Mainframe
Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name = MAXROWSFETCHED
Unix Environment Variable: MAXROWSFETCHED
Started Task: MAXROWSFETCHED
CICS: MAXROWSFETCHED
MAXROWSFETCHEDFAIL
This setting determines whether a
MAXROWSFETCHED query terminates normally or generates an error.
0 | Once the database has read the number of rows specified by
MAXROWSFETCHED, the query will terminate normally. |
1 | Once the database has read the number of rows specified by
MAXROWSFETCHED, the query will generate an error message. |
Default - MAXROWSFETCHEDFAIL = 1
Environments - Server, Windows, Unix, Mainframe
Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name = MAXROWSFETCHEDFAIL
Unix Environment Variable: MAXROWSFETCHEDFAIL
Started Task: MAXROWSFETCHEDFAIL
CICS: MAXROWSFETCHEDFAIL
MAXSOCKET
This setting determines the maximum number of TCP/IP sockets to be used by the data server, and the maximum socket backlog to be used in the listen command.
This option should not be changed unless instructed by CONNX Technical Support.
Default - MAXSOCKET = 1204 (can vary by operating system)
Environments - Server
Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name = MAXSOCKET
Unix Environment Variable: MAXSOCKET
VMS Logical: MAXSOCKET
Started Task: MAXSOCKET
CICS: MAXSOCKET
MISMATCHON
When performing a SYSOBJH IMPORT, there might be cases where the parser has difficulty with a DDM and translates it as a mismatch, so that "false" error messages are produced.
Set this setting to 0 to eliminate these error messages. Use this setting only when such "false" error messages appear.
Default - MISMATCHON = 1
Environments - Client, Windows, Unix, Adabas
Configuration Manager: CONNX Settings; Current Key = CONNX\Adabas; Key Value/Value Name = MISMATCHON
Unix Registry Setting: CONNX.ADABAS.MISMATCHON
MIXEDCASEGRAMMAR
When performing an Adabas import on a file that has a mixed case FDT, set this value to 1 to import the short names the same case as the FDT. Setting the value to 0 will cause the short names to be imported as upper case regardless of the case in the FDT.
Default - MIXEDCASEGRAMMAR = 0
Environments - Client, Windows, Unix, Adabas
Configuration Manager: CONNX Settings; Current Key = CONNX\Adabas; Key Value/Value Name = MIXEDCASEGRAMMAR
Unix Registry Setting: CONNX.ADABAS.MIXEDCASEGRAMMAR
MULTIFETCH
If non zero, this setting instructs Adabas SQL Gateway to request that a read command returns multiple records.
Default - MULTIFETCH = 1
Environments - Client, Server,Windows, Mainframe, Unix, Adabas
Configuration Manager: CONNX Settings; Current Key = CONNX\Adabas; Key Value/Value Name = MULTIFETCH
Unix Environment Variable: MULTIFETCH
Started Task: MULTIFETCH
CICS: MULTIFETCH
MUPESUPPORT
If non zero, this setting enables MUs within Periodic Groups to be represented in a new Relational Table. They will have an additional CONNX virtual column ("cnxarraycolumn") that represents the occurrence of the Periodic Group.
Default - MUPESUPPORT = 1
Environments - Client, Windows, Unix, Adabas
Configuration Manager: CONNX Settings; Current Key = CONNX\Adabas; Key Value/Value Name = MUPESUPPORT
Unix Registry Setting: CONNX.ADABAS.MUPESUPPORT