[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Progress Startup Parameters by Versions

  • Thread starter George Potemkin
  • Start date
Status
Not open for further replies.
G

George Potemkin

Guest
12.1 as of Aug 26, 2019 + -defrdlogentrytypes A single entry or comma delimited list of logging entry types for the deferred log buffer. The default is the 4GLTrace log entry type. See docs.progress.com/.../Use-deferred-logging-in-PAS-for-OpenEdge.html or $DLC/servers/pasoe/conf/openedge.properties.README + -defrdlogginglevel Logging level for messages into the deferred log buffer. 0 - No log file written 1 - Error only 2 - Basic 3 - Verbose 4 - Extended + -defrdlognumlines The maximum number of lines of log information that may be written to the deferred log buffer, shared by all ABL sessions in an agent. The default value is 0, which disables the feature. + -dynqrySSJ Dynamic Queries Server-side Join? Parameter is not supported by a login broker. Release 12.1 is enhanced to perform server-side joins for dynamic queries. Certain queries that join multiple tables are now resolved in the database server rather than the client. The dynamic query server-side join capability is available in a multi-threaded database server for certain queries containing up to 10 tables in the same logical database. At this time server-side joins for dynamic queries are limited to queries that are FORWARD-ONLY, with NO-LOCK. + - zDontFlushErrors Related to a deferred logging? + -zdsreuse Database startup defaults changed - various startup parameter defaults are updated to improve the overall performance of the OpenEdge database. The impacted parameters are: Parameter Old New value -aibufs 20 64 -bibufs 20 64 -lruskips 0 100 -lru2skips 0 100 -pica 64K 128K -prefetchDelay 0 1 -prefetchFactor 0 100 -prefetchNumRecs 16 64 -prefetchPriority 0 1 -Mm 1024 8192 -Mxs 16K 32K The consistency checks can be enabled on more granular level: -AreaCheck Area block consistency check in area "" (-AreaCheck): (14017) | Only one -AreaCheck may be specified. (15383) -TableCheck Record block consistency check in table "", partitionID (-TableCheck): (14019) | Only one -TableCheck may be specified. (15384) -IndexCheck Index block consistency check in index "", partitionID (-IndexCheck): (14018) | Only one -IndexCheck may be specified. (15385) 2 old parameters are now reported by _DbParams: -cstackPrintopt and -diagProc 38 old algorithmic db startup parameters became modifiable in 12.1: Ver Mod _DbParams 12.1.0 85 140 12.0.0 47 138 11.7.5 43 128 11.6.4 21 103 11.5.0 21 98 Increasing parameters that require the resources: Expected for OE 12.1: -ecsize, -secsize, -numCheckPointStats but not implemeted. History and the plans: 10.2B %s increasing lock table size (-L) from %i to %i. (13979) 10.2B %s increasing buffer pools size (-B) from %i to %i. (13980) 10.2B %s increasing bi buffer pool (-bibufs) from %i to %i. (13981) 10.2B %s increasing ai buffer pool (-aibufs) from %i to %i. (13982) 10.2B %s increasing excess shared memory (-Mxs) from %j to %j. (13983) 11.4 %s increasing object mapping cache (-omsize) from %l to %l. (17732) 11.7 %s increasing CDC cache size (-cdcsize) from %j to %j. (18608) 12.1 %s increasing encryption cache size (-ecsize) from %i to %i. (19454) 12.1 %s increasing security cache size (-secsize) from %i to %i. (19455) 12.1 %s increasing maximum number of users (-n) from %i to %i. (19456) 12.1 %s increasing table statistics limit (-tablerangesize) from %i to %i. (19471) 12.1 %s increasing index statistics limit (-indexrangesize) from %i to %i. (19472) 12.1 %s increasing user table statistics limit (-usertablerangesize) from %i to %i. (19473) 12.1 %s increasing user index statistics limit (-userindexrangesize) from %i to %i. (19474) 12.1 %s increasing lob statistics limit (-lobrangesize) from %i to %i. (19484) 12.1 %s increasing user lob statistics limit (-userlobrangesize) from %i to %i. (19485) 12.1 %s increasing pica queue size(-pica) from %i from %i. (19506) Typo: from %i from %i. (19506)

Continue reading...
 
Status
Not open for further replies.
Top