Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# Setting Database Connection Options

Line 9 contains the settings that iProcess Engine uses to connect to the database. (The following example is for a TIBCO iProcess Engine for Windows).

    3\swpro\swuser\swpro\\sw-servers\0

Individual entries are separated by a backslash character (\). The following table describes the meaning of each entry.

Setting Database Connection Options in the staffpms File

Position | Example | Description | Notes
1 | `3` | iProcess Engine type | This field must always be `3` for a database version.
2 | `swpro` | iProcess Engine database background user | The name of the database login (for SQL Server or Oracle) or UNIX account (for DB2) that iProcess Engine uses for background access to the iProcess Engine database schema. Note: This login/account must be the same login/account as the iProcess Engine database schema owner (specified in position 4).
3 | `swuser` | iProcess Engine database user | The name of the database login (for SQL Server or Oracle) or UNIX account (for DB2) that iProcess Engine uses for other access to the iProcess Engine database schema.
4 | `swpro` | iProcess Engine database schema owner | The name of the database login (for SQL Server or Oracle) or UNIX account (for DB2) that owns the iProcess Engine database schema.
5 | `null` | Oracle database TNS identifier | The Oracle TNS identifier that iProcess Engine uses to connect to the Oracle instance holding the iProcess Engine database tables. This is the appropriate SERVICE_NAME entry in the `tnsnames.ora` file, which is located in the `ORACLE_HOME``\network\admin` directory). If a TNS identifier is not defined, iProcess Engine will attempt to connect to the local Oracle instance, and Oracle Transparent Application Failover (TAF) will not be supported. Note: This entry is only used if iProcess Engine uses an Oracle database.
6 | `sw-servers` | ODBC Data Source (SQL) or Database Alias (DB2) | The name of the ODBC data source (for SQL Server) or Database Alias (for DB2) that iProcess Engine uses to connect to the database. Note: This entry is not used if iProcess Engine uses an Oracle database.
7 | `0` | Reserved | This field is reserved for future use by iProcess Engine.

Note | For more information about connecting to databases, see the appropriate iProcess Engine installation guide.

## Changing Database Connection Passwords

If you need to change the passwords that the iProcess Engine database schema owner or iProcess Engine database user use to connect to the database, follow this procedure:

| 1. | Log in to iProcess Engine as an Administrator.

| 2. | Stop iProcess Engine.

| 3. | Enter the following command:

    SWDIR\util\swconfig -u

The following prompt is displayed:

    =================================================================
    TIBCO(R) iProcess Suite  - Configuration Utility
    Copyright (c) 2001-2012, TIBCO Software Inc.
    =================================================================
    Please enter a new Background User Password, ('Q' to quit)

| 4. | Enter the new password for the iProcess Engine database schema owner (the login/account defined in position 4 of line 9 of the `staffpms` file).

The following prompt is displayed.

    Please enter a new Foreground User Password, ('Q' to quit) :

| 5. | Enter the new password for the iProcess Engine database user (the login/account defined in position 3 of line 9 of the `staffpms` file).

The `swconfig` utility terminates and displays the following message.

    Now log onto the Database and change the passwords

| 6. | Change the corresponding passwords for these users in the database (for Oracle or SQL Server) or UNIX (for DB2). See your database/UNIX documentation for more information about how to do this.

| 7. | Restart iProcess Engine.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.