%META:TOPICPARENT{name="ServerAgentAdministration"}% ==Server Agent Administration== === Progress === When configuring a Progress database agent the critical configuration items are: * Database Identification - this is an actual database name e.g "demo" or "isports", which identifies the actual Progress database file that you want to be connected with. This is the value that you enter into the "Database Name" field of either your Admin Assistant form or wizard dialog. If you choose to have database identification take at the client rather than server, you enter this value into the "Database Name" field or connection attribute when configuring your OpenLink client. Progress provides a number of environment variables for configuring database clients, the basic set required for successfully connecting your database agent to an Progress database server are tabulated below: Table: 1. Default Rule Book settings |**Rule Book Section & parameters**|**Default Rule Book Settings**|**Notes**| |[Environment PROGRESS8]||| |DLC=|/dbs/dlc8|Must be full path to the Progress dlc directory.| |PROCFG=|/dbs/dlc8/progress.cfg|Must be the full path and filename to the progress.cfg file. This parameter is optional. Use it if the license file can not be found.| |TABLEVIEW=||Must be the full path and filename to the table view file (tableview.dat). See detailed TABLEVIEW document for more information| |TABLEVIEW_QUALIFIER=|Y|Add owner information to select statement| |DEADLOCK_TIMEOUT=|60|Seconds to wait for lock to release.| |INSERT_LOGICAL=|Y|Rewrite character TRUE/FALSE to logical| |UPDATE_LOGICAL=|Y|Rewrite character TRUE/FALSE to logical| |SPACE_QUOTE_IDENTIFIER=|Y |If the SPACE_QUOTE_IDENTIFIER keyword is unset, it defaults to true, i.e., a space is returned as the quote character. To make the driver return an empty string for the quote character, this keyword must be set to N. Most applications work properly with the default behavior (SPACE_QUOTE_IDENTIFIER = Y). Known exceptions include some versions of Microsoft Visio, the Microsoft SQL Server DTS Wizard and Business Objects.| |MIN_FIELD_LEN=||Minimum length for char field or expression.| |MAX_FIELD_LEN=||Minimum length for char field or expression.| To connect to multiple databases through a single OpenLink client connection and/or to make use array type columns you must run the OpenLink provided "setup.p" utility. Please refer to the setup.p document for detailed information on the use of this script. ====Configuring Progress Session Resources==== You can control default behavior and progress server session resource allocation by entering standard progress session parameters in the "Server Options" field within the Admin Assistant's database agent configuration wizard dialogs or forms. The following values are set for you by default at installation time and displayed as depicted below within the "Server Options" fields of the Admin Assistant Forms and Wizard dialogs. {{{ -T /tmp -d mdy -TB 31 -TM 31 }}} ====Database Agent Specific Issues==== Progress database servers support sockets and shared memory based methods of Inter Process Communication (IPC), unfortunately the shared memory approach which is much faster than sockets and the preferred approach by many users bears a cost of version incompatibility. This implies that your OpenLink database agents need to be an exact version match with your backend Progress database server in order to successfully initiate shared memory based database sessions (note: these agents are built using the Progress Embedded SQL package). ====Rebuilding Progress Database agents==== To get around the issue explained above OpenLink provides a relinkable library and script file that enables you to build an OpenLink database agent that has an exact match to the version of Progress that you have installed. See the section below on Relinking Progress Agents for details. If shared memory based IPC isn't an issue for you then start your Progress server with the -S, -N, and -H options indicating the use of a sockets based Progress database server. This mode of operation is Progress version independent. ====Application Server & 3-Tier Architecture Configuration===== There may be situations in which you are unable to install your OpenLink Request Broker and Database Agents on the same machine as the one hosting your Progress database server. Irrespective of the reasons that lead you to this scenario, it is possible to configure your OpenLink database agents hosted on your Application Server machine such that they connect to a remote Progress database on your Database Server machine using Progress database specific networking (Progress Client Networking) as opposed to OpenLink's Database Independent Networking. The end result being a 3-tier distributed OpenLink architecture in which the communication between OpenLink clients and database agents use OpenLink Database independent Networking, while the communication between the Progress database agent and the Progress database server uses Progress Client Networking. Configuration Steps: Assuming you have a Progress Database Server machine called "mainserver2" that has a sockets based Progress Server process running, you would enter the following (assuming a TCP/IP based network): 1. Ensure that you have a usable connection to Progress using its native networking (Progress Client Networking) using the following remote database connection parameters: {{{ -S mainserver2 -H mainserver -N tcp . }}} 2. Add the following values to the "Connect Options" field within the Admin Assistant Forms or Wizards used to configure your database agent in the Rulebook. If you choose to set this value on the client simply enter the same value into to the "Options" attribute associated with the configuration of your OpenLink client (see OpenLink ODBC or JDBC or UDBC client configuration for more details): {{{ -S mainserver2 -H mainserver -N tcp }}} {{{ See Also: Progress Connection Trouble Shooting }}} {{{ See Also: Application Server Architecture for various illustrations of distributed client-server architectures supported by OpenLink database agent }}} ====Unicode Configuration==== See the [[Unicode section]] for configuration details.