This Process is only valid for Versions 9.x and higher where it is possible to have a total bi file size greater than 2 GB. 1. Take a Progress backup of the database as it is now. Use the PROBKUP command with the -norecover parameter. example: probkup db-name destination-device -norecover If there is enough space… Leer más »
/etc/profile PATH=$PATH:/opt/dlc11/bin: export PATH DLC=/opt/dlc11 export DLC JAVA_HOME=/usr/java export JAVA_HOME – Open the dbname.st file and check to see if path for the database is correct. If not, fix the path on the dbnam.st file, then run the prostrct repair as $DLC/bin/102dbutils/102b05_dbutil prostrct repair dbname – Truncate bi file for 10.2B database using proutil command… Leer más »
incrementar checkpoints dbfinanzas bi log cluster size to 16 MB. proutil dbbasename -C truncate bi bi -bi 16384 set bi log block size to 8 kb. proutil dbbasename-C truncate bi -biblocksize 8 Set -bibufs to 25. -spin 6000*#procesadores AIW 5 o más
The following is extracted from the v8 documentation. Before-image I/O Before-imaging is always enabled to let PROGRESS recover transactions if the system fails. This mechanism is extremely important for database reliability, but it creates a significant amount of I/O that can affect performance. In addition, before-image I/O is usually the first and most likely cause… Leer más »
1) Editar msngrs.properties y ubroker.properties Para remoto AGREGAR PortNumber, hostName y location # [NameServer.NS1] srvrLogFile=$WRKDIR/NS1.ns.log environment=NS1 autoStart=0 PortNumber=5163 hostName=192.168.1.2 location=remote 192.168.1.2 ( Dirección del appserver NS1) 2) Copiar para evitar el error del ubroker cp msngrs.properties ubroker.properties 3) Listo
You must dump & load in order to reconfigure to type 2 storage. Type II storage areas — for data, for indexes and LOBs , if you have any word indexes put those in their own storage area also. NOTHING EXCEPT SCHEMA should be in the schema area. In order for an area to be… Leer más »
Printable View INFORMATION Article Number 000012531 Environment Progress 9.x OpenEdge 10.x IBM AIX UNIX Enterprise Database License OpenEdge Category: Configuration OpenEdge Category: Database OpenEdge Database Category: Monitoring/Promon OpenEdge Database Category: Performance Question/Problem Description Database hanging periodically Overall performance of the databases decreases It takes a long time to login in the application when users already… Leer más »
http://knowledgebase.progress.com/articles/Article/P99089?popup=true Article Number 000022572 Environment All Supported Operating Systems OpenEdge 10.x, 11.x OpenEdge Server Technology Category: AdminServer Question/Problem Description How to increase or modify java heap size for the Admin Server in OpenEdge ? How to increase java memory for Admin Server in OpenEdge? How to set the JVMARGS in Release 10? How to… Leer más »
Article Number 000034388 Environment OpenEdge 10.2B06 OpenEdge 11.1 Question/Problem Description JAVA-LANG Nullpointer Exeption on starting database agent after installing 10.2B SP6 The database is started and can be connected to OpenEdge Explorer shows the database as not running Clarifying Information Database Agent started without issues in 10.2B05 Only databases with a specific servergroup defined fail… Leer más »
Resolution To create a SQL DBA and hide all Progress Schema tables and views from the public do the following: PRECAUTIONS: A. Take a backup of the database prior to making any changes. B. Test on a copy or test database prior to making changes to the Production database. 1. Enable the SYSPROGRESS sql DBA by registering/adding the user SYSPROGRESS via the 4GL… Leer más »