DISC

Contents | What's New | Quick Links

 

ODXNET

Introduction

Software Installation

Concepts and Design

Designing Applications

Omnidex Environments

SQL Reference

Omnidex API's

Utilities

Interfaces

Performance Guide

Troubleshooting Guide

Appendix

 

 

ODXNET Configuration File

Pooled ProcessesODXNET

 

The ODXNET configuration file contains settings used by Omnidex Network Server (ODXNET) for a listener process. Many of the settings have defaults that will be used if a configuration file is not provided, however, some of ODXNET's most powerful features require this file and will be disabled without it.

  • The ODXNET configuration file is required when using ODXNET as a Windows NT service and enabling NSADMIN (Network Services Administrator).
  • Application specific and environment specific pooled processes are defined in the configuration file.

Setup

Syntax

Windows Service

Interactive Process

Pooled Processes

Configuration File

Settings

The configuration file is passed to ODXNET as an argument at the command prompt.

odxnet /users/data/flatfile/oa/odxs1232.cfg

 

Configuration File Settings

General | Security | Application | Debug | NSAdmin

 

General Section

[General]

PortId=7555

; Specifies port number that client users specify in their
; data source files and where odxnet listens for socket
; connection requests


MaxSonProcesses=120

; Specifies maximum number of son processes this server will allow

InitialBufferSizes=512

; Specifies the initial size in Kbytes of send, receive and compress buffers


SkipProcessPooling=0

; Skip creating process pools for each application


HostAddrLookupOK=1

; Allows DNS lookup of incoming clients

IdleTimeOut=10

; Value in minutes to timeout an idle connected process.
; Zero means it will never timeout.

 

top

Security Section

[Security]

;UseSSL=0 future!
; Enable use of Secured Socket Layer

 

top

Application Section

[Applications]

; Application choices are:
;ODXODBC=Omnidex ODBC Driver
;ODXJDBC=Omnidex JDBC Driver
;OMNIACCESS=Omnidex Access API

; Complete the Applications section by listing each application name and description.
; For each Application, provide a section for it and as a minimum, the Library and
; Routine names.

 

top

[ODXODBC]

LibraryName=odxdbcnet

; Library name where the connect and transmit interface routines are kept.

TransmitRoutineName=odbc_transmit

; Routine name


[ODXODBC Environments]

; Fill this section with a list of various environments you wish to track

SAMPLE=My sample database

[ODXODBC SAMPLE]

StartupInfo=$SECTION

; Specifies Datasource to preconnect to

UsePooledProcesses=1

; Flag to determine if Pooled Processes are used
; 0 Don't start or use pooled processes for this application
; 1 Start pooled processes for this application

InitialProcessCount=10

; Number of processes to startup

ProcessLimit=60

; Maximum number of pooled processes allowed for this application

GrowthThreshold%=80

; Trigger to indicate more processes should be started;
; Happens when this percentage of the process that have started
; are owned by clients.

Growth%=20

; Amount of processes to grow by when GrowthThreshold% is reached.
; Number of processes added is Growth Percent of number of processes already
; started up to the ConnectionLimit.

ReUseProcesses=1

; Flag to determine if application processes are reused.
; 0 Don't reuse processes, instead start a new process
; 1 Reuse processes

[ODXODBC SAMPLE StartupInfo]

; This section contains information used by ODXODBC when starting on the server

EnvName=C:\omnidex\oa\oracle\orders.env

; specifies env file to preconnect to. Leaving blank will skip preconnection
; Ignored when *not* a pooled process, i.e. when its a new process

;Options=

;Username=
; username to pass to oaconnect
; Ignored when *not* a pooled process, i.e. when its a new process

;Password=
; password to give oaconnect
; Ignored when *not* a pooled process, i.e. when its a new process

;SQL="select * from customers where customer_no=1 with opt=none"
; sql statement must be enclosed in quotes.

 

top


[ODXJDBC]

LibraryName=odxdbcnet

; Library name where the connect and transmit interface routines are kept.

TransmitRoutineName=jdbc_transmit

; Routine name

 

[ODXJDBC Environments]

; Fill this section with a list of various environments you wish to track

SAMPLE=My sample database

[ODXJDBC SAMPLE]


StartupInfo=$SECTION

; Specifies Datasource to preconnect to

UsePooledProcesses=1

; Flag to determine if Pooled Processes are used
; 0 Don't start or use pooled processes for this application
; 1 Start pooled processes for this application

InitialProcessCount=10

; Number of processes to startup

ProcessLimit=60

; Maximum number of pooled processes allowed for this application

GrowthThreshold%=80

; Trigger to indicate more processes should be started;
; Happens when this percentage of the process that have started
; are owned by clients.

Growth%=20

; Amount of processes to grow by when GrowthThreshold% is reached.
; Number of processes added is Growth Percent of number of processes already
; started up to the ConnectionLimit.

ReUseProcesses=1

; Flag to determine if application processes are reused.
; 0 Don't reuse processes, instead start a new process
; 1 Reuse processes

[ODXJDBC SAMPLE StartupInfo]

; This section contains information used by ODXODBC when starting on the server

EnvName=C:\omnidex\oa\oracle\orders.env

; specifies env file to preconnect to. Leaving blank will skip preconnection
; Ignored when *not* a pooled process, i.e. when its a new process

;Options=

;Username=
; username to pass to oaconnect
; Ignored when *not* a pooled process, i.e. when its a new process

;Password=
; password to give oaconnect
; Ignored when *not* a pooled process, i.e. when its a new process

;SQL="select * from customers where customer_no=1 with opt=none"
; sql statement must be enclosed in quotes.

 

top

[OMNIACCESS]

LibraryName=odxNSoa

; Library name where the connect and transmit interface routines are kept.

TransmitRoutineName=NSOATransmit

; Routine name

[OMNIACCESS Environments]

; Fill this section with a list of various environments you wish to track

ORDERS=My orders database

[OMNIACCESS ORDERS]


StartupInfo=$SECTION

; Specify $SECTION and then build a corresponding section, or
; just put the startup parms here (if they fit)

UsePooledProcesses=1

; Flag to determine if Pooled Processes are used
; 0 Don't start or use pooled processes for this application
; 1 Start pooled processes for this application

InitialProcessCount=10

; Number of processes to startup

ProcessLimit=60

; Maximum number of pooled processes allowed for this application

GrowthThreshold%=80

; Trigger to indicate more processes should be started;
; Happens when this percentage of the process that have started
; are owned by clients.

Growth%=20

; Amount of processes to grow by when GrowthThreshold% is reached.
; Number of processes added is Growth Percent of number of processes already
; started up to the ConnectionLimit.

ReUseProcesses=1

; Flag to determine if application processes are reused.
; 0 Don't reuse processes, instead start a new process
; 1 Reuse processes

 

top

[OMNIACCESS ORDERS StartupInfo]

; This section contains information used by nsoa when starting on the server

EnvName=C:\omnidex\oa\oracle\orders.env

; specifies env file to preconnect to. Leaving blank will skip preconnection
; Ignored when *not* a pooled process, i.e. when its a new process


DSTagName=ORDERS

;Username=
; username to pass to oaconnect
; Ignored when *not* a pooled process, i.e. when its a new process

;Password=
; password to give oaconnect
; Ignored when *not* a pooled process, i.e. when its a new process

;Options=


PreDescribe=1

; Flag indicates if oaexecsql calls are to be followed with a
; predescribe cache-call
; 0 Don't pre-cache describe info
; 1 Do perform describe and pre-cache


PreFetchRows=10

; Flag indicates if oaexecsql calls are also followed by a fetch call of the
; a certain number of initial records.
; 0 No records will be pre-fetched
; n Number of records to pre-fetch


AutoDataFlip=1

; Flag indicates whether or not the raw data fetched is "byte-flipped" automatically
; when the host and client have differing endian formats
; 0 No Byte flipping occurs
; 1 Byte flipping handled automatically

 

top

NSAdmin Section

[NSAdmin]

Security=1

; Force password for NSAdmin access to odxnet

Password=xyz

; Configured password for NSAdmin access

 

 

;OADEBUG=
; Use this setting to turn on oa debugging (future)

top

Dynamic Information Systems Corporation - Omnidex Version 3.8 Build 6 J15.03-Copyright © 2003

DISC | Documentation Home