Try OpenEdge Now
skip to main content
Startup Command and Parameter Reference
Startup Parameter Usage Categories : Client Connection parameters (CC) : Client database connection parameters
 

Client database connection parameters

Use the parameters listed in the following table to control how you connect to a specified database.
If you use the Physical Database Name (-db) parameter to specify more than one database when you start a session, specify the connection parameters for each database after the database name to which they apply and before the next -db parameter. OpenEdge applies database connection parameters only to the previously specified database. For example:
mpro [ -db]db1-name[db1-parameters ] -db db2-name [db2-parameters ]
Note: OpenEdge implicitly specifies the -db parameter for the first database.
You can specify all other parameters anywhere on the command line. If you specify the same parameter more than once, OpenEdge uses the value you provide for the last instance of the parameter.
Syntax
Parameter
Purpose
-1
Single-user Mode1
Starts OpenEdge in single-user mode
-B n
Blocks in Database Buffers2
Specifies the number of database buffer blocks
-B2 n
Blocks in Alternate Buffer Pool3
Specifies the number of buffers in the database Alternate Buffer Pool
-Bp n
Private Read-only Buffers
Requests a number of private read-only buffers
-brl
Bleeding Record Lock
Holds a share lock on a released record used by more than one buffer
-cache filename
Schema Cache File
Reads the database schema from a local file instead of the database
-cp {com-parms|filename}
Communications Parameter File
Overrides preset connection parameters for auto-connect databases
-crStatus n
Crash Recovery Status
Controls how often a crash recovery status message is displayed
-crTXDisplay
Crash Recovery Transaction Display
Displays the transaction table during crash recovery.
-cs n
Cursor Size
Changes the maximum number of index levels
-ct n
Connection Retry Attempts
Defines the number of retries when connecting to a database
-db physical-dbname
Physical Database Name
Identifies one or more databases to connect to at startup
-DataService data-service
DataService
Connects through a NameServer to an ODBC or ORACLE DataServer
-directio
Direct I/O4, 5
Opens all files in unbuffered mode
-dt db-type
Database Type
Identifies the database type
-F
Force Access
Allows access to a damaged database. Call Technical Support before using -F
-H host-name
Host Name
Identifies a remote host
-hash n
Hash Table Entries6
Specifies the number of hash table entries for the buffer pool
-i
No Crash Protection7
Runs OpenEdge without database integrity or recovery
-ipver
Internet Protocol
Specifies the Internet Protocol version
-is
AS/400 Ignore Stamp
Stops a client from comparing time stamps when connection to an AS/400 database
-ld logical-dbname
Logical Database Name
Assigns the logical database name
-Mf n
Delayed BI File Write8, 9
Delays writing the last before-image (BI) file records
-Mm n
Message Buffer Size
Specifies the message buffer size for network client/server protocols
-nohostverify
No Host Verify
Turns off host verification for a Secure Sockets Layer (SSL) connection
-nosessionreuse
No Session Reuse
Avoids the reuse of a Secure Sockets Layer (SSL) session ID
-P password
Password10
Specifies a user password
-Passphrase
Prompt for Passphrase11
When connecting to a database enabled for Transparent Data Encryption, specifies that the user must be prompted for the key store passphrase
-populate
Fast Schema Change
Turns off Fast schema change
-r
Non-reliable I/O12
Enables buffered I/O to the before-image file
-requireusername
Require Username
Requires users starting servers of the AdminServer to provide a valid username and password
-RO
Read-only Media
Opens a database for read-only access
-S { servicename |port-number }
Service Name
Identifies the service and port number to use on the host machine when connecting to a broker process
-Sn
AS/400 Server Program Name
Specifies that the Server program on an AS/400 start with an OpenEdge connection request (SNA only)
-ssl
SSL-based Connection
Specifies a Secure Socket Layer connection
-tstamp
Time Stamp
Uses time stamp information rather than cyclic redundancy (CRC) to enforce consistency between r-code and a schema
-trig {dir-name|lib-name}
Trigger Location
Identifies the directory or library containing the ABL triggers for a database
-U userid
User ID13
Specifies the user ID
jdbc:datadirect:openedge://<ip>:<port>;
databaseName=<dbname>;
truncateTooLarge=<on/all/output/off>;
truncateTooLarge
With its value set to ONor ALL, the parameter allows truncating data exceeding the column size and all operations will be performed on truncated data. If the value is set to OFF, no data is truncated and an error is displayed. If the parameter is set to OUTPUT, all operations will occur on data that is not truncated and truncation is performed only on the output and truncation only happens for columns exceeding maximum size. The default value for the
truncateTooLarge
parameter is OFF. If a value is not specified for this parameter, the value set in the server startup parameter is used.
1 Single-user database connections only; otherwise, use only for server startup.

2 Single-user database connections only; otherwise, use only for server startup.

3 Single-user database connections only; otherwise, use only for server startup.

4 Single-user database connections only; otherwise, use only for server startup.

5 UNIX, Windows only.

6 Single-user database connections only; otherwise, use only for server startup.

7 Single-user database connections only; otherwise, use only for server startup.

8 Single-user database connections only; otherwise, use only for server startup.

9 UNIX, Windows only.

10 Different meaning for non-OpenEdge databases.

11 Single-user database connections only; otherwise, use only for server startup.

12 Single-user database connections only; otherwise, use only for server startup.

13 Different meaning for non-OpenEdge databases.