Search results

BTW, 11.7.10 update provides a. Additional Usr latch protection at logout and login, b. Additional checking for USR latch at user disconnect c. Additional information is written to the database lg file should these be encountered This information is recorded in the following public Articles...

Most likely, a login semaphore or USR latch was locked. promon -F would connect the database (like proshut -F did) and would allow to find out a process that hold the USR latch. If it was the login semaphore, then OS commands would help.

Use the "try and check" method. For Greek: CODEPAGE-CONVERT(string, "UTF-8", "1253"). If the conversion corrupts data then use "IBM851" instead of "1253".

What is the value of SEESION:CPSTREAM? I18N: Code Pages and Possible Conversions Baltic - 1257 Greek - 1253, IBM851 Western Europe (*) - 1252, ISO8859-1, IS8859-15, IBM850, IBM037, IBM273, IBM277, IBM278 *German

Recent thread: https://www.progresstalk.com/threads/getting-details-from-ai-files.203024/

IMHO, _Servers._SrvParam-* is a minor problem compared to the _ActBuffer._Buffer-<block_types> disaster.

DbParam.p merges _DbParams and _Servers.._SrvParam-* for version 11.5 and higher or imitates _DbParams for versions before 11.5.

Wouldn't it be easy to get the non-default startup parameters using _DbParams VST (since v11.5)? BTW, it’s easy to write a program-watchdog that would persistently monitor the online changes of the startup parameters. I’m not sure if DBAs are often changing the parameters online. But if they do...

How often were the latch conflicts resolved during the spinning phase - without getting the naps? The quotes from above: "Every transaction in ATM tests locks the (MTX) latch exactly 8 times and forces to nap on the latch 0.30 times in average." "MTX latch was busy only 14% of the time." So at...

> The -spin value does not seem to have any effect. What did I miss? Stupid me! The contribution of the spinning phase was expected about 100 nanoseconds or 0.1 ms. Only bonehead will set the -nap to the hundreds ms! I added the results for the -spin 9999999 - the max value allowed to be set...

Let’s assume a latch is locked 100 ms. What the -spin value we need for the spinning to take the same 100 ms? Idea of the test: Let’s lock the MTX latch by enabling the quiet point. Start a transaction that does not update a database but just creates and deletes an entry in the transaction...

How to estimate how long the db buffers are locked in atm tests? It’s easy. When a process need to change the RM chain it should update the table’s object block. While the block is exclusively locked by this process all other processes that would like to read the block using the BKSH lock will...

> I would collect the statistics of all transaction durations in milliseconds (the count and msec fields in temp-table). Let’s name them as the stat records. Other fields of these records: Checkpoint counter – check the number of checkpoints before and after transaction. If the number is...

If I were brave enough to fix Gus's code, I would collect the statistics of all transaction durations in milliseconds (the count and msec fields in temp-table). Expected distribution for the tests with large number of users: 3% (or less) of all transactions will be committed in 1 ms or faster...

atm4.p nhist = random (1, 4). /* now do one transaction */ txStartMs = etime. do for account, branch, teller, history1 transaction: /* retrieve and update account */ find account where account.id = theAccount exclusive-lock. assign account.balance =...

If I were running tests, I would do it like this: 1. Change the number of users in the range from 1 to 100. What number of users will provide the maximum number of transactions per second? Expectation: the highest result will be with 4-6 users provided the number of CPUs is larger than this...

> Pomon's "Status: Blocked Clients" says - there are no long buffer lock queues other than in "History1 Table" area. I bet the first record created in the ATM transactions is the history table. Indeed, the notes for the history1 table are the first ones in the transactions. 4GL code from...

Another question about the internals of Progress transactions. First the fact – the recovery notes are generated by a client’s session. Even by a remote client that sends each recovery note to its server using a separate network message. The recovery notes can be generated, of course, only when...

And the Blocked Clients chat shows the wave-like changes - up and down – where the period of the changes is about 30 seconds. There are no database startup parameter with the dimension of the seconds that would match the periods of these cycles. How about the phases of the database operations...

150 users ATM test. ATM can use 4 history tables. I would run such test to check how it will spread the waits between the tables.