Search results

The bkLastBiNote field is not used, but is there any rumor as to what it was intended for? Block (the bunch of records) vs an address of some recovery note?

May I ask? If we would be able to change the space management algorithms... When new fragment is added to a first block on RM chain and now the free space of the block is less than the toss limit, would you remove the block from the chain immediately or let the next record create to do that? I...

RMBLK: 0040 numdir: 0x02 2 0041 freedir: 0xfd 253 0042 free: 0x1f8c 8076 0044 entry # 0: 0x1fef 8175 0046 entry # 1: 0x1fd4 8148 "numdir" and "freedir" are 1 byte fixed fields. "free" is 2 bytes. Offset...

You are correct: free space in data block is decreased by RECORD-LENGTH(new record fragment) + 4 bytes: 2 bytes in a record offset directory and another 2 bytes store the size of record fragment. I'm tempting to call these 2 bytes of fragment's size plus the fragment's body itself as a "record"...

Grumbling about Create Limit is continued... I know for sure that Progress technical support has an internal utility that scans AI files and reports the sizes of the recovery notes. The variable part of the sizes of RL_RMCHG notes is directly related to the change the record’s sizes. Progress...

@Rob Fitzpatrick Hi Rob, I agree that 65 is more accurate estimation than 64. Cluster size: Richard Banville suggested to use a cluster size of 64 for index areas. However, I don’t understand the explanation. https://community-archive.progress.com/forums/00018/14487.html Should we always set...

Hi Tom, > it works reasonably well in many cases. Sure, the mean size works, for example, for the “eco” table: Table Records Min Max Mean PUB.eco 10 215 234 216 But Min/Max record sizes would work equally well in this case as well. Mean size does not work for the LOB...

For record sizes I used to check the "deviation ratio": Dev = (Max - Mean) / (Mean - Min) Table Records Min Max Mean Dev PUB.notes 276431 43 13795 248 66.08 PUB._File 361 284 3201 416 21.10 PUB.eco 10 215 234 216 18.00 PUB._Field 7097 250 1782 338...

> I purposely don't have a precise definition for very large tables, i.e. tables that warrant their own areas. This is a trade-off between manageability and complexity, and different DBAs may decide this differently based on their needs. A very large table, in the mind of a DBA with a 50 GB...

Since 11.4 you can use the -csoutput -verbose parameters with proutil -C dbanalys. No needs to parse dbanalys output anymore. Unfortunately dbanalys was and is still a poor tool to analysis data storage. You can improve it a bit by adding data from other sources. I'm combining data from...

Insufficient disk space or Write access denied with error 291 when lots of disk space is available https://community.progress.com/s/article/insufficient-disk-space-or-write-access-denied-with-error-291-when-lots-of-disk-space-is-available Cause There are many "old" temporary files present in...

Are there a lot of records in the mfg-tagm table? It looks like it's a sorting of BY phrase that causes the error. What is the -T directory?

Can you check debug-list of get_stock_detail inv/inv310spsx3p.p? What is a operator in line 6684?

Is the error 291 the only one that is reported in db log? No errors 6072?

Exactly. xcode is a part of any development version of OpenEdge. I guess the evaluation versions include it as well. The size of the file: 10.2B 47,456 11.7 54,472 12.2 54,984 12.8 57,368 It's not exactly the same but I still believe the xcode.exe works for all versions.

Start a session with the -rx option and Data Administration will allow you to dump data definition files. Run-time license allows to compile the xcoded sources. "Encrypted Compiler Mode" = "the -rx client startup parameter". Do you have xcode.exe in DLC directory? Update: I can be wrong but...

What version of the operating system? Can you install the recent evaluation version of OpenEdge? Then you can convert your database and dump data using new version. Do you have a run-time license installed? Then you can dump and upload the .df files. And somebody can compile the dump programs...

SUPPROMSGS/gre contains only 2 df's: gre851.df CODEPAGE-NAME IBM851 COLLATION-NAME GREEK gre1253.df CODEPAGE-NAME 1253 COLLATION-NAME GREEK Both these codepages you are already used. Internet gives other codepages for Greek language: 737 Code page 737 - Wikipedia 869 Code page 869 -...

Long time ago I wrote a script (logsem.sh) to read the database login semaphore. It was tested only on Linux and AIX but not on HP-UX. I don't know if HP-UX has the commands to get the requested information but why not? When nobody can't connect a database it's good idea to check what is going...

Some self-service process tried to log out. It took the USR latch and freed the slot in Connection Table. Then something gone wrong - the process hung and did not release the latch. I bet the process was still running while you tried to stop the database. For such situations watchdog can't...