Search results

I forgot to mention that "limited logins" allows to start promon. It would be interesting to know if it's possible to identify "limited logins" inside promon (as we can do for a proquiet point).

Progress OpenEdge Release 11.7 build 2182 SP15 on Linux 35 replication server startups per 2025. 7 times it started with limited logins. I tried my best to find out the patterns but I see nothing. DB Size: 7205 GB Size of the AI files locked while RPLS was not running is the hundreds GBs.

Scenario: Replication server is stopped on a source database for a few hours (4-20 hours). When we start a replication server again it may write to a database log: (-----) Enabled limited logins. instead of: (-----) Enabled default logins. It's V11.7. I guess since V12.8 the messages are...

Three lists of wait names from V9.1A executable: REC SCHE TRAN RGET DBRD DBWR DBBK BKSH BKEX BIRD BIWR AIWR IDLE IDLE TXS TXB TXX TXE BUFF REC SCH TRAN DBSI RGET DBRD DBWR DBBK BKSH BKEX BIRD BIWR AIRD AIWR IDLE IDLE TXE TXE REC SCH TRAN DBSI RGET DBRD DBWR DBBK BKSH BKEX BIRD BIWR...

Hi Patrice, I see the number "3" after "TXE" and "OE10" in your data. Some old Progress versions reported the TXE lock waits as _Connect-Wait = "TXE" and _Connect-Wait1 = 1, 2, 3. My "collection" of "Blocked Clients" in promon: 4137 root REMC/ABL TXE 3 20513147...

I would like to programmatically bind _Connect-Wait to _Resrc-Name. Basically _Connect-Wait returns a short name of resource queue a process is waiting for. _Resrc-Name is a full name of the same resource. So the list of the names would be enough. Both match to the wait codes: %GSYSTEM ERROR...

There appear to be two error message stacks: &SCOPED-DEFINE MaxNumber 32767 DEFINE VARIABLE i AS INTEGER NO-UNDO. DEFINE VARIABLE e AS CHARACTER NO-UNDO. /* Put a message in the message stack */ ASSIGN _MSG = {&MaxNumber}. /* without NO-ERROR - in the stack: */ DO ON ERROR UNDO, LEAVE: ASSIGN...

There are two signals that we can control our response to inside a Progress session: SIGINT (2) - Terminal interrupt signal. = Ctrl-C SIGPIPE (13) - Write on a pipe with no one to read it. The SIGPIPE signal causes a session to issue the message 140: ** Pipe to subprocess has been broken...

It turned out, the utility was documented in Database Administration V10.0A (2003 year) DBUTIL CMPDB qualifier Allows you to compare two databases. dbutil cmpdb db-name1 db-name2 [-t|-l|-l2] db-name1 Name of the first database to be compared. db-name2 Name of the second database to be...

Cmpdb is a useful tool for finding out the secrets of the Schema Area, for example. ;)

cmpdb exists at least since Progress V5. It was a separate executable at the beginning but later in V9 the option became a part of the _dbutil. Most recent changes were done in V11.3 (if we can trust $DLC/prohelp/msgdata). After asking the question I remembered the correct syntax: proutil (or...

Can anyone remind me how to run ‘proutil -C cmpdb’? proutil -C cmpdb -help proutil <db-name> -C cmpdb <db-name1> <db-name2> [ -t | -l | -l2 ] [ -Passphrase ] But I’m getting: Invalid cmpdb option: <db-name1> And with anything as <db-name>: You must supply a database name. (940)

"LogRead is a GUI utility to read, query, sort, merge and translate log files from all Progress components (e.g. AdminServer, AppServer, Messenger). It is provided as a diagnostic utility to assist in the analysis of log files." LogRead Version 2.0 (Jun 17, 2021)...

Does anyone know where to find documentation for Progress log files (AppServer, WebSpeed, clientlog etc)? LogRead program has the handlers for 27 log types but these programs mainly read timestamps and message text ignoring other fields in the lines.

DBI file is the only one created in $Extend\$Deleted. Other Progress temp files are visible on Windows even if a session is not use the -t parameter.

I will split your question into 3 parts: 1. Should you do a d&l? 2,906,790,153 is the total size of records in your database; 4,440,358,912 is their footprint on the disk. Even laptops have much more RAM. You can put the whole database in memory and this will completely eliminate disk I/O. 2...

I added "Size" column from pt.viewB2.txt as the "Blocks" column to tabanalys. Also I added a few columns based on the formulas: Block Size = Blocks * 8128 where 8128 = dbblocksize - 64 Usage% = (Record) Size / Block Size * 100% Dev Symmetry = (Max - Mean) / (Mean - Min) Dev Ratio = (Max - Min)...

Wow! I did not know that proutil -C viewB2 supports the -csoutput -verbose parameters. At least since version 11.7! This does not documented even in V12.8. Thanks, Patrick!

@PatrickTingen Can you upload the -csoutput files instead of tabanalys?

Almost all databases have the tables with the updates/creates ratio close to 1 (or even higher /integer/ number) no matter how long is a sampling interval. Or it's close to an integer number only on the intervals when the creates are very high. In 99.9% cases it means the programming issue - the...