Search results

  1. TomBascom

    Graph-model metaschema for progress codebase - any interest in AI driven code analysis/modernization?

    Yes, the Boston PUG is late September & Early October, Europe is in early November. As James says, time flies, it will be on us before you know it. FWIW, that all _sounds_ wonderful but so has every fad of the last 75 years of computing. Some concrete and digestable examples sure would be nice.
  2. TomBascom

    Named arguments for ABL procedures.

    Concrete examples are always good to argue about.
  3. TomBascom

    Graph-model metaschema for progress codebase - any interest in AI driven code analysis/modernization?

    The easiest way to hunt down the right people and get a conversation going is to attend a PUG.
  4. TomBascom

    Graph-model metaschema for progress codebase - any interest in AI driven code analysis/modernization?

    Forgive me if I am just an old fossil but I am having difficulty understanding the attraction of migrating a schema to neo4j. This approach seems like it might be helpful for OLAP applications or for adding on such functionality but I don't see that there is anything there that would be very...
  5. TomBascom

    Long running transaction by a user and his activity code

    FWIW... I think the difference here is that you are actively investigating something that you already know is a problem. I am a bit more focused on diagnosing a situation that I didn't know about ahead of time. Minor detail: you only get the top of the stack with type "1". You need type "2"...
  6. TomBascom

    Long running transaction by a user and his activity code

    Regarding the client statement cache and "3" vs "1"... The problem that I have with using "3" to try to get to the bottom of a problem is that a lot of problematic code starts off with something like reading a control record. And then it dives into the more complex and problematic stuff. Worse...
  7. TomBascom

    Long running transaction by a user and his activity code

    ProTop has such a watchdog. We do not, however, do anything specific about multiple database situations. You are probably an exception but in our experience that kind of thing will occur in the "main" database first and foremost and it when we disconnect that session the others will follow. If...
  8. TomBascom

    Named arguments for ABL procedures.

    Probably because "the" FOR EACH is awfully optimistic. Sure, you could do stuff with dynamic queries but that's going to be a lot more complex and may introduce performance concerns.
  9. TomBascom

    Long running transaction by a user and his activity code

    Sure. And depending on why and how you are doing this one or the other is more useful. I get it, you don't like "wasting" bunches of updates and the associated latches etc that are never going to actually be read. I don't like that either. However - many people do NOT have thousands of...
  10. TomBascom

    Question Request for Guidance on Upgrading Progress Database from Version 11.7 to 12.8

    "Client networking" is only needed if your connections from PASOE to a database are going to be using the -S connection parameter. If they are shared memory connections you do not need client networking.
  11. TomBascom

    Long running transaction by a user and his activity code

    George said: That depends entirely on your circumstances. Sure, if you have hundreds (or thousands) of remote connections enabling "cachingType = 1" for all of them could be rather painful. ("2" would be even worse...) But if they are all shared memory connections the penalty is pretty...
  12. TomBascom

    Named arguments for ABL procedures.

    Lest anyone think that I am on vacation... OpenEdge 11.1 is ancient, obsolete, and unsupported. You should upgrade. All of OE11 is now ancient & obsolete but 11.7 is a much, much better place to be than 11.1. Since you speak of run time arguments you apparently have source code and a compiler...
  13. TomBascom

    Question AI with Progress / OpenEdge

    It can seem like it is almost all that they talk about these days... not that that is different from anyone else! Can I summarize it? No, I'm much too grouchy. But they sure do talk about it a lot. Come to a PUG and learn more!
  14. TomBascom

    Setup Level II Storage Guide

    Granted there isn't much of an argument to be had. Personally, I like to try to get it close to a useful value primarily because I have a utility that does random sampling of tables by randomly generating RECIDs and I can avoid a lot of wasted effort by having a RPB that is a better fit. But...
  15. TomBascom

    Setup Level II Storage Guide

    A table called "wrkfile" strikes me as something that might be worth discussing. Is this a table that contains temporary data? Do you write a bunch of things there, do something, and then eventually delete all of that data? If you do, then that would be something that could benefit quite a lot...
  16. TomBascom

    Setup Level II Storage Guide

    I wouldn't go so far as to say that mean size is "meaningless". Sure, it is not perfect and there are certainly cases where it doesn't work as well as something else. It is, however, readily available and it works reasonably well in many cases. That's worth quite a lot.
  17. TomBascom

    Restore a DB without audit data

    I haven’t tried this but… you could try restoring and then running proutil truncate area on the audit area. That’s not quite what you are asking for but it might get you the same result. As Rob says though - you should not be keeping large amounts of audit data in your production instance in...
  18. TomBascom

    Question Request for Guidance on Upgrading Progress Database from Version 11.7 to 12.8

    At a very high level... You cannot migrate to PASOE *after* migrating the database. Classic appserver is NOT available on oe12, thus you must migrate your appservers before or during the migration. You DO NOT want to be doing that for the first time the same weekend that you migrate the...
  19. TomBascom

    Question Request for Guidance on Upgrading Progress Database from Version 11.7 to 12.8

    The database upgrade procedure itself is simple and straightforward. All that you need to do is to run "proutil dbname -C conv1112". Of course, as you note, you need test everything and have backups and and a rollback plan. And a whole lot of that is very specific to your particular...
  20. TomBascom

    PASOE - Blocking connection somewhat randomly

    I'm thinking that there must be some error messages. Perhaps you could consider sharing them?
Back
Top