Recent content by George Potemkin

To find the root cause ones need: 1. to gather as much information as possible; 2. to have a qualified support team who is able to analyze the huge volume of the collected information; 3. to be lucky to get the answers after the minimal number of the incidents or to be patient to continue an...

All 5 old WS agents (PIDs 14181,14184,14192,14195,14201) died with memory violation between 08:23:21 and 08:23:38 All 5 new WS agents (PIDs 31660,31673,31687,31697,31707) were LOCKED. The reason must be common to them. > also during this time java update was going on. Just curious what the...

Oops! That is why I don't like the numbers! My friend the promon confirms: 1-Single, 2-Stack, 3-One Time

Disagree is my second name. :cool: CachingType = 1 methord: You set the value only once and check the statement cache serially - at t1, t2, t3 etc time. Let’s, every minute. You will get the call stacks on all borders of stat intervals. CachingType = 3 methord: I set CachingType = 3 at t1...

@TomBascom You know the customer of ours who taught me to be very careful about the code that is proposed to run in the production environment. :-) Does anyone have a code to monitor the long running transactions they can share? Long transaction watchdog? I know there is a simple code in Dan...

BTW, if a process rolls back the long transaction then the changes of _UserLock, _UserTableStat and _Trans are the only useful information we can get. proGetStack will not report a call stack.

How often the client statement cache is updated? Once per db request? How many db requests per second does an active client generate? The hundred times? The thousands? Each update of the statement cache creates an extra USR latch lock. Each cache update /may/ create an extra disk io - if a call...

I don't have a ready-to-run code example but the idea is simple: /* ipConnectUsr is a user number */ FOR FIRST DICTDB._Connect NO-LOCK WHERE DICTDB._Connect._Connect-Id EQ ipConnectUsr + 1 TRANSACTION: FIND CURRENT DICTDB._Connect EXCLUSIVE-LOCK. ASSIGN...

BTW, you can't get the program names while a transaction is in an undo phase. Neither with _Connect-Cache* nor with kill -SIGUSR1. I guess the same is true for a subtransaction undo but I did not check it.

You can use: _Connect._Connect-Cache* to get the program name run by the user. _UserLock._UserLock-Table - inte[512] -> Table # _UserTableStat with the increments of _UserTableStat-update or _UserTableStat-create -> _UserTableStat-Num = Table # Since 11.7: _Trans: no increments of...

_Area._Area-attrib is a bitmap and only a few of its 32 bits seemed to be currently used by Progress. Development could dedicate another 3 bits to set the prohibitions for the object types per area level. And Data Dictionary could check these bits. Dreams... We agree - each area should store...

Holy war started! ;-) Arguments to use RPB 1 for the index areas: 1) It's the only way to mark an area to be used for indexes only. We can write a program that will issue a warning if it finds the objects of the other types than the indexes; 2) If someone puts a table in area with RPB 1 and the...

What is the maximum size that can be expected from a field named “ship-city”? For example, the alternate name of Bangkok is 168 character long and it’s mentioned in Guinness Book of Records. Field size statistics from a database somewhere in America ;-) Size Cnt 2332 7 1058 1 1053 1 1051 1...

Or a presentation for then next Progress Conference! I’m glad that now there is a modern guidance about object assignment that we can refer to. > LOBs are inherently large, so it doesn't make sense to me to have an area for miscellaneous LOBs 1. LOBs are the records whose minimal size is ten...

I missed this point. Thanks! > if record sizes are quite uniform LOBs are quite opposite!