Search results

@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...

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/