CONNX Data Integration Suite 14.8.0 | Administration Guide | CONNX Configuration Settings | CONNX Configuration Settings Reference | "K" to "M" Configuration Settings
 
"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