Progress
Startup Command and Parameter
Reference


Client Database Connection Parameters

Use the parameters listed in Table 3–8 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, as shown. Progress applies database connection parameters only to the previously specified database:

NOTE: Progress implicitly specifies the -db parameter for the first database.

mpro [ -db] db1-name [ db1-parameters ] -db db2-name [ db2-parameters ] 

You can specify all other parameters anywhere on the command line. If you specify the same parameter more than once, Progress uses the value you provide for the last instance of the parameter.

Table 3–8: Client Database Connection Parameters
Description
Syntax
Purpose
Single-user Mode 1
-1
Start Progress in single-user mode.
Blocks in Database Buffers 1
-B n
Specify the number of database buffer blocks.
Private Read-only Buffers
-Bp n
Request a number of private read-only buffers.
Bleeding Record Lock
-brl
Hold a share lock on a released record used by more than one buffer.
Schema Cache File
-cache filename
Read the database schema from a local file instead of the database.
Communications Parameter File
-cp { com-parms| filename }
Override preset connection parameters for auto-connect databases.
Cursor Size
-cs n
Change the maximum number of index levels.
Physical Database Name
-db physical-dbname
Identify one or more databases to connect to at startup.
DataService
-DataService data-service
Connect through a NameServer to an ODBC or ORACLE DataServer.
Direct I/O 1, 2
-directio
Open all files in unbuffered mode.
Database Type
-dt db-type
Identify the database type.
Force Access
-F
Allow access to a damaged database. Call Technical Support before using -F.
Host Name
TCP: -H host-name
SNA: PLU= plu-name
Identify a remote host.
Number of Databases
-h n
Specify the maximum number of databases that can be connected.
Hash Table Entries 1
-hash n
Specify the number of hash table entries for the buffer pool.
No Crash Protection 1
-i
Run Progress without database integrity or recovery.
AS/400 Ignore Stamp
-is
Stop a client from comparing time stamps when connecting to an AS/400 database.
Logical Database Name
-ld logical-dbname
Assign the logical database name.
Delayed BI File Write 1, 2
-Mf n
Delay writing the last before-image (BI) file records.
Network Type
-N network-type
Specify the network communications protocol.
Password 3
-P password
Specify a user password.
Fast Schema Change
-populate
Turn off Fast schema change.
Non-reliable I/O 1
-r
Enable buffered I/O to the before-image file.
Read-only Media
-RO
Open a database for read-only access.
Service Name
-S { servicename | port-number }
Identify the service and port number to use on the host machine when connecting to a broker process.
AS/400 Server Program Name
-Sn
Specify that the Server program on an AS/400 start with a Progress connection request (SNA only).
Trigger Location
-trig { dir-name | lib-name }
Identify the directory or library containing the 4GL triggers for a database.
User ID 3
-U userid
Specify the user ID.
  1. Single-user database connections only; otherwise, use only for server startup.
  2. UNIX, NT only.
  3. Different meaning for non-Progress databases.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095