Search results

  1. TomBascom

    Question Timeout in a linux environment

    Auditors... the last refuge ;) If it were me I would go back to them and ask for an actionable definition of "idle". I would then ask for clarifications for each of the various bullet points above. I'd be especially anxious for them to provide their expert advice on making the very difficult...
  2. TomBascom

    Multi Table Dynamic Query. -rereadnolock causing read issues.

    The only way to actually guarantee that you "always get the latest version of the records" and keep it that way is to read them with a lock. And if you think you had performance problems before... :( Your static code already has at least some opportunity for drift from "the latest version"...
  3. TomBascom

    Question Timeout in a linux environment

    The version of RH is interesting but the version of Progress is much more interesting. Given the ancient release of RH I'm going to guess that you are ashamed to admit to running Progress v9. No, there is no startup parameter to timeout idle users. Nor is there any simple, easy and reliable...
  4. TomBascom

    Resolved Question on transaction

    On line 506 you have a FIND statement without a lock specified. This makes it a SHARE-LOCK. There is no TRANSACTION block, no FOR and no "update buffer". /************* BUDGETS DAI : VFGDAI ***************/ IF cDAtype <> "0":U THEN DO: FIND FIRST VFGDAI WHERE VFGDAI.dainum...
  5. TomBascom

    Resolved Question on transaction

    I misspoke about XREF - for transaction and buffer scope you just need a plain old LIST listing. That will show you the code with line numbers and it includes a section at the end showing what block (and line#) each transaction and buffer is scoped to. You want transactions and buffers to be...
  6. TomBascom

    Resolved Question on transaction

    Your code is infested with app builder pre-processor cruft, include files, upper case keywords and FIND FIRST. My eyes are bleeding! What does "when I'm coming back to my triggers" mean? What is the evidence that you still have active locks? Have you compiled this code with the XREF option...
  7. TomBascom

    Question Shared memory in use.

    Rob is absolutely correct. You should not be learning and testing in your production environment. That is a train wreck waiting to happen. The error that you report is basically telling you that your shutdown command failed. The .lg file corresponding to that database should explain why...
  8. TomBascom

    Answered Maximum Number of Clients Per Server (-Ma) calculates its own limit?

    If -Ma is not specified it will default as described. You get some pretty crazy numbers that way. One of OEM's more "charming" features is, as Rob describes, the occasional use of 0 and blank as placeholders for "use the default value". One of OEM's even more charming features is that...
  9. TomBascom

    How to find out if record is locked

    You cannot succeed by checking for locks before executing your update. There is always a period of time between the checking and the update when someone else could lock the data. The reverse is also true - any locks that you happen to find could be released right after you find them and you...
  10. TomBascom

    Resolved Question on transaction

    You are not showing the code that actually does the work. But the fact that you claim to still have locks tells me that you have not correctly implemented my advice. Show the real code and we can probably tell you where you have left the righteous path. And, no, RELEASE is not the solution.
  11. TomBascom

    Datadigger program

    Maybe I am overlooking it but I do not see the actual error messages that you refer to. We probably cannot help you unless you share the exact errors that you are receiving.
  12. TomBascom

    How to find out if record is locked

    That is not how locks and transactions work. Querying system tables is not an appropriate strategy. Aside from all of the performance issues and the difficulty of actually finding the records associated with your dataset -- the lock state of the records can very easily change between the time...
  13. TomBascom

    Incremental backup same size as full backup

    While I do not doubt that someone told you that you cannot upgrade it is almost certainly a fairy tale. Many times that is indeed the knee jerk reply that a vendor's first line support will feed you. That does not make it true. Unless the product is orphaned AND you do not have the source...
  14. TomBascom

    Incremental backup same size as full backup

    oe12 is the current release. oe10 is ancient, obsolete and there aren't going to be any bug fixes for it. You should be able to dump & load 19GB in a couple of hours without even trying very hard. Those numbers you quote sound like numbers from circa 1990 hardware.
  15. TomBascom

    Sequence Limits

    Your database block and your filesystem block do not have to be the same size. It is, however, strongly recommended that the db block not be smaller than the fs block -- so a db block of 8k and an fs block of 4k is ok.
  16. TomBascom

    Game of Life

    I must be avoiding "work" or something ;)
  17. TomBascom

    Sequence Limits

    Offhand I don't know. I do know that Rich has talked about supporting multiple sequence blocks. But it isn't anything that I've needed to worry about and I've not seen it mentioned in any release notes. OTOH I haven't been looking for it. Also - nobody should be using block sizes less than 4096.
  18. TomBascom

    Game of Life

    Why connect it to Excel? Why not just use 4gl widgets?
  19. TomBascom

    I need some advise

    According to the most recent (March 2018) price list I have handy, enterprise db licenses range from $640 per "named user" to $1,180 per "access agent" (minimum 25). Or $39,785 per CPU. The license model that you have should be on the invoice. Pricing in euros is usually higher than dollars...
  20. TomBascom

    I need some advise

    It is a very good idea to gather information before talking to a sales person. An uninformed consumer is an easy mark. Before you know it you will be buying all sorts of crap you have no actual need for. FWIW 950 euro/user does not strike me as obviously outrageous. But the details might...
Top