• Topic
  • Discussion
  • UdaWikiWeb.RulesBookSettingsGeneric(Last) -- Owiki? , 2016-08-19 15:00:53 Edit owiki 2016-08-19 15:00:53

    Multi-Tier Rulebook Settings: [generic_agentname]

    Each Database Agent will have a section that is typically called "generic_" followed by a database label. For example: [generic_virt], [generic_odbc], [generic_db2].

    Parameter Default Comment
    Program name of the executable to run
    Environment specify Environment section to use
    CommandLine commandline options (optional)
    ServerOptions force DBMS-specific client options (optional)
    Directory where to chdir before starting the Agent
    Database force name of the database (optional)
    ConnectOptions force DBMS-specific connect options (optional)
    UserID force userid (optional)
    Password force password (optional)
    ReadOnly No force read-only mode (optional)
    OpsysLogin No when set to Yes, the Request Broker will do an operating system login before spawning. This implies ReUse = ifsame user. (optional)
    NeedsCLI (VMS only) Use CLI to spawn the agent
    ReUse never Defines how an agent will be re-used. See below for details of the ReUse Parameter.

    CommandLine parameter

    The CommandLine value can include any or all of the following options:

    • +noautocommit -- This means that all connections routed (by the mapping rules) through this agent section will have autocommit behaviour turned off. This is useful if your client-side application relies on manual commits of its transactions; you can define a mapping rule to match only that application and add +noautocommit, while other applications use a different agent section.
    • +maxrows -- This defines the maximum number of rows to fetch from any query.
    • +initsql -- Specifies a file with a set of SQL statements to execute immediately when each connection is established. For example, this can be useful to set transaction isolation levels, if your application assumes them to be set a specific way.
    • +jetfix -- This enables various workarounds for operation with the Microsoft Jet Engine, e.g., through MS Access or MS Query. Particularly, data type mappings may be changed for greater accuracy using these applications.
    • +norowsetlimit -- This disables any rowset-size limit; it is useful in cursor operations on large tables.

    ReUse parameter

    always is implied by all values other than never.
    When is agent re-used
    never never reuse this instance (default)
    always always try to reuse this instance
    upto <n> allow at most n connection to the same instance
    ifreadonly allow only read-only requests
    ifsame database group connection requests that alias to the same database
    ifsame process group connections with the same calling process id (pid)
    ifsame options group connections specifying the same connect options
    ifsame application group connections from same application alias
    ifsame user group connections from the same username
    ifsame machine group connections from the same client host
    ifsame opsys group connections from the same operating system

    Referenced by...