OpenLink UDA Wiki Web

UdaWikiWeb.ConfigureProgressIsolationLevels

  • Topic
  • Discussion
    • UdaWikiWeb.ConfigureProgressIsolationLevels(Last) -- DAVWikiAdmin? , 2008-06-03 17:29:43 Edit
    [TXT]
    [PLAIN]
    [DOCBOOK]
    WebDAV System Administrator 2008-06-03 16:29:43

    Configure Progress User Level Transaction Isolation Levels

    Use the following instructions to configure Progress User Level Transaction Isolation Levels.

    Single-Tier (Lite) Windows

    1. Log in to the machine that hosts OpenLink's Single-Tier (Lite Drivers).

    2. Launch your ODBC Data Sources Administrator.

    3. Locate your OpenLink DSN.

    4. Click the Configure button.

    5. Scroll through the configuration screens until you find the "Default Transaction Isolation" drop-down.

    6. select the desired isolation level.

    Multi-Tier Unix

    1. Login to the machine that contains your OpenLink Multi-Tier server components.

    2. Use the sh or bash command to open a bourne or bash shell.

    3. cd into the root of your OpenLink installation.

    4. Execute this command: . ./openlink.sh

    5. cd into the bin sub-directory of your OpenLink installation.

    6. Use a text editor to open the oplrqb.ini file.

    7. Locate the [Environment PROGRESS] section that applies to you. For example: 

    [Environment PROGRESS100SQL]
DLC                = /dbs3/progress/32bit/v10.1a
PROCFG             = /dbs3/progress/32bit/v10.1a/progress.cfg
CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading oplrvc.sql
LD_LIBRARY_PATH   = /dbs3/progress/32bit/v10.1a/lib
;SHLIB_PATH        = /dbs/dlc10/lib     ; Find HP/UX shared libraries
;LIBPATH           = /dbs/dlc10/lib     ; Find AIX shared libraries
;SQL_CLIENT_CHARSET = UTF-8             ; Uncomment for Unicode connection


    8. Add the following variable to the list: DEFAULT_TXN_ISOLATION

    9. Set the variable to one of the following values:

    READ_UNCOMMITTED
    READ_COMMITTED
    REPEATABLE_READ
    SERIALIZABLE

    10. Save your changes and exit the file.

    16. Reinitialize or restart the OpenLink Request Broker service.

    Multi-Tier Windows

    1. Login to the machine that contains your OpenLink server components installation.

    2. Use Notepad to open the oplrqb.ini file that appears in the bin sub-directory of the OpenLink installation.

    3. Locate the [Environment PROGRESS] section that applies to you. For example: 

    [Environment PROGRESS100SQL]
DLC                = /dbs3/progress/32bit/v10.1a
PROCFG             = /dbs3/progress/32bit/v10.1a/progress.cfg
CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading oplrvc.sql
LD_LIBRARY_PATH   = /dbs3/progress/32bit/v10.1a/lib
;SHLIB_PATH        = /dbs/dlc10/lib     ; Find HP/UX shared libraries
;LIBPATH           = /dbs/dlc10/lib     ; Find AIX shared libraries
;SQL_CLIENT_CHARSET = UTF-8             ; Uncomment for Unicode connection


    4. Add the following variable to the list: DEFAULT_TXN_ISOLATION

    5. Set the variable to one of the following values:

    READ_UNCOMMITTED
    READ_COMMITTED
    REPEATABLE_READ
    SERIALIZABLE

    6. Save your changes and exit the file.

    7. Open your Windows Control Panel.

    8. Locate the Services utlity. (It may be in the Administrative Tools sub-folder.)

    9. Launch Services.

    10. Locate the OpenLink Request Broker Service in the list box.

    11. Restart the OpenLink Request Broker service.