Progress Startup Parameters. =========================== Version 1.2, May 23, 2000 by George Potemkin (potemkin@csbi.ru) Notes. ===== 1. The list contains server and client startup parameters as well as parameters for some Progress utilities. 2. Where it is possible I will narrow down the origin of parameter to the Progress patch number. 3. Plus(+) sign after Progress version means that parameter was introduced in that release. Minus(-) sign respectively means that parameter was obsolete. 4. Abbreviation "pkb" refers to a Progress knowledge base article. Abbreviation "msg" refers to a Progress message number. Acknowledgements. ================ The Progress Email Group was a great source of information for creation of this document. Several people have been kind enough to share their knowledge: Dmitri Levin (d_levin@hotmail.com) Geoff Crawford (geoff@innov8cs.com) Grant Maizels (grant.maizels@cogita.com.au) Bob Brennan (bbrennan@integratedmfg.com) Undocumented Parameters of the Releases before V7.3B. ==================================================== 6.X + -, European Numeric Format (the same as -E) 6.X + -PF Parameter File (the same as -pf) 6.X + -! Fast Track Message File Fast Track Message File contains any text data. The bounds of the data records are defined by an index table stored in the file header. You can refer to any record by the include file syntax {!}. Msg ## 1722-1725 say: The -! feature is a temporary feature for Version 6 PROGRESS only. It WILL NOT be supported in future version of PROGRESS. De facto, this feature is available up to V9. 6.X + -synchronous Enables Synchronous Debug Mode. 6.X + -Mxs Shared Memory Overflow Size. Default: -n * 300 bytes. 6.X + -I Total Private Buffers. Pkb 5633 Default: 2 * -n, Range: 0 - 32000, Type: Broker Parameter PROGRESS tries to use private buffers for read-only operation thereby reducing competition for shared buffers; In V7/8/9 PROGRESS still allocates the private buffers. Set -I 0 in startup.pf. 6.X + -O Private Buffers Default: 0, Range: 0 - (-I), Type: Connection Parameter 6.3 + -nap Nap Time / Initial Latch Sleep Time Default: 10 ms before V7.3C and 20 ms in V7.3 and up. Range: 10-500 ms. When a process is trying (-spin tries) to acquire a latch and fails then it naps -nap ms. See promon -> R&D -> 'debghb' -> Administrative Functions -> Adjust Latch Options -> Initial latch sleep time. 6.3 + -napinc Nap Time Increments Default: 2 times The nap time is multiple by a value of the -napinc when a process naps -napstep times (i.g. 20,40,80,160,...). 6.3 + -napmax Maximum Nap Time (pkb 16518) Default: 5000 (100 with V7.3C-??? - Progress bug, it should be 5000). The maximum value to which a nap time can increase. 6.3 + -napstep Maximum Increment Steps When a process naps -napstep times the nap time is increased by a value of the -napinc. 6.3 + -lkhash Lock Table Hash. Default value is a prime number greater than 1/8 the -L value where the prime number is sourced from an internal PROGRESS array (30 entries) from 13 to 98407 with values increasing in a geometric progression using the approximate ratio 1 to 1.4. The prime number table is identical in versions 6.3, 7 and 8. The same table is used for the -hash parameter (pkb 15385). Each entry uses 12 bytes of the shared memory. Pkb 15956 or 16580. 6.3 + -ixlru Index Block LRU Recycle Limit Default value: 0, Range: 0-99 This is an experimental feature that is designed to give index blocks preference over data blocks in the buffer ageing algorithm. The idea is that when index block finds its way to the tail end of the lru chain, we put it back on the front and let it age again before replacing it. The recycle limit controls how many times it gets to go around. See: promon -> R&D -> debghb -> Startup Parameters Set: promon -> R&D -> debghb -> Administrative Functions -> Adjust Page Writer Options -> Index block recycle limit 6.3 + -znohint Turn off ALL hints sent to ORACLE; Pkb 16306 6.3 + -znotrim Don't trim trailing blanks in where clause. ORACLE DataServer; Pkb 13078 5.X + -zod Don't use ORACLE TRUNC for date in where clause; Pkb 12384. 6.X + -zo Shows SQL code that Progress generates and sends off to ORACLE. The -zo is not supported in V7.3C+. In V8 this feature has been replaced with query tuning paramter qt_debug (-Dsrv qt_debug,SQL). 6.2 + -zp Issue a message 1408: The id of this process is . 7.3A + -zcache Issue a message 821: Reading schema cache for database... 7.3A + -zr Ignore R-Code File / Forces Session Compile. Msg 2887 7.3A + -zqil Query Index Listing (msg 1848). Local char clients. Details: http://www.geocities.com/d_levin/dlc/zqil.html 7.3A + -zqilv The same as -zqil parameter but with LEAF info. 7.3A + -zn Disable the special meaning of the leading underscore ("_"). By default: - Progress does not allow to create the temp-tables, fields, variables, etc with the names begining with "_". - For the procedures with names beginning with "_" Progress applies the same rule as for all procedures when -q parameter is used. 7.X + -m4 prosql: oidrvr32.exe -SV -S -m4 -Mi -pf 7.X + -cgw Compatible R-Codes (Oracle DataServer). V7: Deals with the queries that use ORACLE tables with a progress_recid column (Pkb 17397). The procedures compiled with (without) -cgw must be run with (without) -cgw (Msg 2721, 2722). V8: To generate r-code with a Version 8.0B client that an 8.0A client can also run, you must specify the Compatible (-cgw) parameter when you start your 8.0B session to compile and save the r-code. If code references DATE columns that are mapped to the CHARACTER data type, you will not be able to generate compatible r-code, even if you specify -cgw. 6.X only -K Keystroke Capture/Playback. Pkb 5985. Record keystrokes: -K record Interactive Playback: -K playback keyfile.mstr keyfile.gen Batch Playback: -K batch keyfile.mstr keyfile.gen where is your master file originally recorded, is where the results of playback will be stored. TERM environment variable must be the same as what you set to record. 7.3A + -QA Quality Assurance Layer (Character mode only) Record keystrokes: -QA record Play back the keystrokes: -QA playback Report window creation: -QA log -QA option sets the time in seconds since the start of the UNIX epoch to 0. The start of the UNIX epoch is 00:00 1/1/1970 GMT. Connection Parameters (that define an process to connect to). ============================================================ 7.X + -SV Open Interface Driver Connection The -N,-H,-S,-m2,-Mm,-nb,-NL,-Nv,-pp parameters followed the -SV parameter belong to OIB/OID. If a Parameter File (-pf) startup parameter is included in the -SV parameter list, all parameters in the file, up to the first -db parameter, are part of the -SV parameter list. However, all parameters after and including the first -db in the parameter file are ignored, and are not passed to OIDs. 6.X + -Gw Directs PROGRESS to shut down DataServer Broker. Msg 3663. Ie. the -N,-H,-S parameters followed the -Gw parameter belong to a DataServer Broker. 8.1A + -AS Directs PROGRESS to shut down AppServer Broker. Pkb 16288. ie. the -N,-H,-S parameters followed the -AS parameter belong to a AppServer Broker. 8.1A + -web WebSpeed Broker Connection Ie. _wta -web -wtbname -wtbport -wtaminport 9.0A + -svub Indicates using unified broker service. See below. Changes by release. ================== 7.3B as of June 1995 -------------------- 7.3B + -ininame Initialization File 7.3B + -brl Bleeding Record Lock (pkb 13881, 15160) 7.3B + -dictexps Dictionary Expressions 7.3B + -checkdbe Check Double-byte Enabled 7.3B + -nocheckdbe No Check DBE 7.3B + -cpprint Printer Code Page 7.3B + -cprcodein Read Rcode Code Page 7.3B + -cprcodeout Write Rcode Code Page 7.3C01 as of Oct 12 1995 ------------------------ No changes. 7.3E as of Apr 17 1997 ---------------------- No changes. 7.3E15 ---------------------- 7.3E15 + -tcponly Prevent the NLM server from starting up the SPX protocol. Pkb 19632 8.0A as of Nov 1995 ------------------- 8.0A + -cplog Log File Code Page 8.0A + -fldisable Field List Disable 8.0A + -noindexhint Index Hint 8.0A + -nojoinbysqldb Server Join 8.0A + -noSQLbyserver SELECT Pass Through Disable 8.0A + -OUTPUT Redirects the output from a Progress batch session to a file. Pkb 16768. 8.0A + -rbcpreportin Report Code Page In 8.0A + -rbcpreportout Report Code Page Out 8.0A + -rbcpudfin UDF Code Page In 8.0A + -rbcpudfout UDF Code Page Out 8.0A + -rbdel Report Engine Record Delete 8.0A + -rbfile Report Engine File -rbfile rbrun.txt This can be used when running prore.exe from the command line. _printrb.p must first be run to generate the rbrun.txt. This is intended for internal testing only. 8.0A + -rbP Encoded Password (documented in V9) 8.0A + -rbstatfile Report Status File 8.0A + -rbtable Report Engine Table Name 8.0A + -rbtag Report Tag 8.0A + -rbupds Report Update Status 8.0A + -SQLlogging OID Server Connection (OID, AppServer) 8.0A + -zpfnet ? 8.0A + -zbfs ? 8.0A + -zfl Field List Reports (msg 4164, 4165) Writes to a database log file debugging messages about re-reading a field-list records and reports a number of records read. 8.0B as of Jul 10 1996 ---------------------- 8.0B -spin PROGRESS implemented -spin on NT (Michael Furgal) 8.0B -directio Became supported on all platforms (Michael Furgal) 8.0B + -basekey Registry Base Key 8.0B + -evtlevel Event Level. There is EVTLEVEL environment variable. 8.0B + -hardlimit Hard Limit for -D,-nb,-mmax,-l. Pkb 16387 8.0B + -mux 0 Turn off mtlkmux() and mtfrmux() when -spin has been set. Msgs 3717, 3718, 5797. 8.0B + -portnumber ? Obsolete in V8.1A 8.0B + -znosavepoints No Save Points 8.1A02 as of Dec 9 1996 ----------------------- 8.1A - -portnumber Introduced in V8.0B. 8.1A + -AS Directs PROGRESS to shut down AppServer Broker. Pkb 16288 8.1A + -con Connect Procedure 8.1A + -dis Disconnect Procedure 8.1A + -lkwtmo Lock Time Out 8.1A + -logfile Log File (compserv.lg) 8.1A + -logname Event Name 8.1A + -Mpte Shared Memory Page Table Entry Optimization Digital UNIX. Msg 5556. Rewritten in V8.3A. 8.1A + -trace Trace (AppServer) 8.1A + -web WebSpeed Agent Connection 8.1A + -weblogerror Broker Error Log File 8.1A + -wtamaxport Agent Maximum Port Number 8.1A + -wtaminport Agent Minimum Port Number 8.1A + -wtbport Broker Port Number 8.1A + -zcompsrvrbuf ? 8.1A + -znw ? 8.1C06 as of Jul 06 1998 ------------------------ 8.1A03-8.1C06 + -ASID ? 8.2A as of Apr 28 1997 ---------------------- 8.2A -Mpte VLM64 Page Table Entry Optimization (Digital UNIX) Syntax was changed: an argument is not need anymore. 8.2A + -blocksize Block Size (PROSTRCT Utility) 8.2A + -groupdelay Group Delay (Turning tips: pkb 18003) 8.2A + -index Index (PROUTIL DUMP Qualifier) 8.2A + -Mpb Maximum Servers per Broker 8.2A + -maxport Max Dynamic Server Port 8.2A + -minport Min Dynamic Server Port 8.2A + -Mms AAppServer Maximum Maintained Prestart Counter 8.2A + -Ms AppServer Maximum Prestart Counter 8.2A + -populate Disable Fast Schema Changes 8.2A + -nopopulate Enable Fast Schema Changes 8.2A + -norecover Disable DB Recovery with Off-line Backup. Pkb 17553 8.2A + -tscope ? 8.2A + -zprofile Profiler Config File: http://www.peg.com/utilities.html 8.2C as of Feb 23 1998 ---------------------- 8.2B-8.2C + -noreorder No Join Reorder (Report Builder, pkb 19119) This option may help increase performance on reports that contain SQL using the implicit join syntax. 8.2C09 as of Sep 03 1998 ------------------------ 8.2C09 + -nofixdate From: Brian K. Maher To: peg@peg.com Subject: PATCH: 8.2C07 for Win32 (95,NT) Date: 10/08/1998 Progress failed to properly adjust a date format using 4 digit years when using the -d ydm, -d dmy and -d mdy startup parameters. Date formats will now be rearranged to correspond to the -d startup parameter. The -nofixdate startup parameter can be used to disable this change if required. --- The -nofixdate parameter resolves the memory violation problem with the code: DEFINE VARIABLE v-date AS DATE. MESSAGE "Enter date" UPDATE v-date. --- Date: 24 Nov 1998 From: mattg@progress.com (Matt Gilarde) Subject: Re: Update date field on message line To: peg@peg.com The MESSAGE UPDATE bug has been fixed in a recent 8.3A patch. There should be no need to use -nofixdate once you have the patch. Matt Gilarde - PSC Development --- 8.3A as of Aug 05 1998 ---------------------- 8.3A -noshm No Shared Memory on Server. Obsolete. Starts a single server for a database rather than a broker. The clients can connect to a database only using the -H, -S parameters. In V8.3/9.0 the connection ends with the errors: The server or the system has no more resources. Try a larger -n. (748) ** Server rejected login. (700) 8.3A + -bistall BI File Threshold Stall 8.3A + -bithold Recovery Log Threshold. The value is rounded down to the nearest cluster (Britt Johnston) 8.3A + -indexbase Index Base 8.3A + -indexlimit Index Limit 8.3A + -tablebase Table Base 8.3A + -tablelimit Table Limit 8.3A + -semsets Semaphore Sets 8.3A + -p21 Prophet 21 for C-ISAM Dataserver. Obsolete in V9.0A 8.3A + -rbfilenodel Don't delete p#####RB.TXT file (V8.3B readme.wri) 8.3A + -rbexpjoins Forces RB to use explicit join syntax for inner joins (readme.wri) 8.3A + -rbclearxactions Pkb # 17016: When printing or previewing a new transaction is started. This new transaction will not end unless a new startup parameter is used. This new parameter is -rbclearxactions and should be specified on the command line where Report Builder is started or in the rbstart.pf file. 8.3A + -rbzsqldump This will create a log file c:\foo\sql.log which contains all of the ESQL generated by Report Builder for a report. The directory c:\foo must exist before Report Builder is run with this parameter. This is also intended for internal testing only. (Angela Albert from PSC Tech Support) 8.3A + -rbcltoolong ? 8.3A04 as of Oct 19 1998 ------------------------ 8.3A04 + -rbtabledb Specify which database contains the RBREPORT table (or whatever table is specified with the -rbtable parameter). Pkb 19145, V8.3B readme.wri. 8.3A04 + -portableframes Portable Frames Portableframes was an attempt to make for portable r-code across operating/windowing systems. If you have shared frames and compile your code on different platforms (a.p compiled on machine1, b.p compiled on machine2), and you don't use -portableframes, you will have errors*). There is another error if you do use the option under 8.3B. Glen West (gwest@physio-control.com) --- *) Bug 98-09-15-066: Shared frame layouts do not match for frame . (683) 8.3B as of Jan 29 1999 ---------------------- 8.3B -maxport Applied to Application Broker (not in V8.2 - pkb 18382) 8.3B -minport Applied to Application Broker 8.3B + -apsvnap ? Obsolete in V9.0A 8.3B + -devevent ? Obsolete in V9.0A, re-added in V9.0B 8.3B + -rereadnolock Re-read No-Lock (pkb 19063) Patches 8.3B07 and 9.0B04 fix the bugs (issue# 19990408-006, 19990617-017) caused by the -rereadnolock parameter when you use a browser. 8.3B12 (AIX), 8.3B14 (Win32) --------------------------- 8.3B + -Msc Allows correct messaging between OID and small client. Issue #19980706-005: -Mm 16000 will core or GPF when using SQL select statements. 8.3C ---- 8.3C + -Moi ? 8.3C + -noshvarfix ? Exist in V9.1A as well 8.3C + -tgb ? 8.3C01 (Compaq Tru64), 8.3C03 (Sun Solaris) as May 04 2000 ---------------------------------------------------------- 8.3C + -noinactiveidx Prevent the compiler selecting inactive indexes. Issue # 20000405-004 Pkb 19825: Starting a client session with this parameter will force the compiler to only select active indexes when compiling source code. This removes the need for an index to be deleted from the database when trying to control the indexes that are selected by the compiler. 9.0A03 as of Mar 06 1999 ------------------------ 9.0A ACCESS=ALL It's the default for all databases started with ProControl and the AdminServer (Mike Furgal). 9.0A - -apsvnap Introduced in V8.3B 9.0A - -devevent Introduced in V8.3B, re-added in V9.0B 9.0A - -p21 Introduced in V8.3A 9.0A - -portableframes Introduced in V8.3A04 9.0A -Nv Network Version. Introduced in V6.2F. 12 (for V5/V6 database) is the highest (and the only) number you can use. 20 (for V7 database) is not supported. Pkb 18900 9.0A -a After-Image File Name. The -a parameter is only valid with rfutil -C roll forward. 9.0A -g Before-Image File Name is obsolete, 9.0A - -indexbase It's a first time when PSC renames the parameters! 9.0A - -indexlimit ... and lose a way in V9.1 9.0A - -tablebase 9.0A - -tablelimit 9.0A + -baseindex Index Base Replace -indexbase 9.0A + -indexrangesize Index Range Size Replace -indexlimit 9.0A + -basetable Table Base Replace -tablebase 9.0A + -tablerangesize Table Range Size Replace -tablelimit 9.0A + -adminport AdminServer Port 9.0A + -AppService Application Service Name 9.0A + -Bp Private Read-only Buffers 9.0A + -classpath SQL-92 Server Java Classpath 9.0A + -DataService Data Service. Connect a client through a NameServer to the broker. See also the -nonameserver parameter. 9.0A + -debugalert Sets SESSION:DEBUG-ALERT to YES. Documented in V9.1. 9.0A + -list Obtaining Storage Area Descriptions Using PROREST 9.0A + -m5 ? 9.0A + -nonameserver The same as -DataService "none". . ReadEng.hlp: For diagnostic purposes only, it is acceptable to bypass the NameServer connection and connect directly to the broker instance. To do this, specify the reserved DataService name "none" as follows: -DataService none 9.0A + -omsize Storage Object Cache Size (msg 8527) 9.0A + -profile Profiler Config File (enhanced -zprofile). See %DLC%\src\samples\profiler\readme.doc 9.0A + -properties Configuration Properties File (conmgr.properties) 9.0A + -relative Suppresses conversion of a Relative Path Database (pkb 19027) with a procopy. By default, new database'll have the full paths embeded. Note: prodb = procopy -silent -relative. CREATE DATABASE statement allow to create RPDB based on an .st file. 9.0A + -servergroup Server Group Name 9.0A + -svrefresh ? 9.0A + -svub Indicates using unified broker service ReadEng.hlp -> Index -> 3.6.1 Configuring in the Explorer Framework on NT 8. To continue configuring the broker, choose the Server Parameters tab and provide the required information: Server Parameters - The -svub parameter is required for a broker connection in the Progress Explorer framework. 4.2.5 Starting the DataServer in the Explorer Framework and Connecting a Client If you do not set the required -Dsrv SVUB,1 and optional -DataService data-service connection parameters as described in this section, the client is assumed to be configured for a standard Progress broker and the -H and -S parameters are used to locate a probrkr executable on the appropriate host machine. By setting the SVUB parameter on, you redirect the -H and -S parameters to locate the appropriate NameServer and/or broker for the Progress Explorer on the host machine. 9.0A + -ubpid UBroker PID no. needed by agents at startup 9.0A + -ubpropfile UBroker properties file name (ie. ubroker.properties) 9.0A + -Wb ? 9.0A + -wss Windows Single Session 9.0A + -wtainstance Web Agent instance number, needed when starting agent 9.0A + -wtbname WebSpeed Broker Name as specified on broker's startup with the -i parameter. Used to start a WebSpeed Agent or to pass back to the name server. 9.0A + -yr4def Date Default Format with Four Digit Years (pkb 18505) 9.0A + -z92 ? 9.0A + -zallowdlc Allowes to connect (at command line only) to a database in $DLC. Otherwise you'll get the message 1379. 9.0B as of May 08 1999 ---------------------- 9.0B + -devevent ? Exist from V8.3B, deleted in 9.0A 9.0B -basetable Default is now set to 1. 9.0B -tablerangesize Default is now set to 50. 9.0B -baseindex Default is now set to 1. 9.0B -indexrangesize Default is now set to 50. At run time, you can change the table base or the index base: e.g. find first _StatBase. assign _TableBase=51 _IndexBase=21. 9.0B02-9.0B15 (9.0B11 as of Sep 15 1999 - for Win32) ------------------------ 9.0B + -nolkctr Issue # 19990910-030: To alleviate the problem of a large number of error 395's (warning - pcondb for db %s has lkctr %d) being written to AppServer log file, introduce a startup parameter to turn off error 395. 9.1A02 as of March 22, 2000 -------------------------- 9.1A - -baseindex V9.1 drops the V9.0 set of parameters 9.1A - -basetable and re-introduced the V8.3 set. 9.1A - -indexrangesize Bug number 20000523-004 9.1A - -tablerangesize Note that V9.1A2B01 supports both V8.3 and V9.0 sets. 9.1A + -indexbase V9.1 re-introduced the V8.3 set of parameters. 9.1A + -indexlimit See note above. 9.1A + -tablebase 9.1A + -tablelimit 9.1A + -asyncinterval ? 9.1A + -asyncqueuesize Async Queue Size (AppServer's client). 9.1A + -isnoconv Initial Value Segment No Convert. (Compile-Time) 9.1A + -noshvarfix ? 9.1A + -numdec Fractional Separator 9.1A + -numsep Thousands Separator 9.1A + -ttwrdrul Temp-table word-break rule (undocumented). Default value is the default rules (0). 9.1A + -wtbhostname ? 9.1A + -zgenkwlist ? 9.1A + -znnic ?