Search results

  1. Rob Fitzpatrick

    Progress Editor Temporary file

    This sounds awfully familiar. There was a similar discussion recently, here: https://www.progresstalk.com/threads/progress-editor.202254/ Your options are going to depend on your OpenEdge release, which you haven't mentioned.
  2. Rob Fitzpatrick

    Progress Editor Temporary file

    Procedure Editor unsaved buffers are transient by design. And even if you could get .ped files to stick around, they are files in the user's file system that they have permission to delete, so it still wouldn't fulfill any meaningful audit requirement. So it seems your real requirement is that...
  3. Rob Fitzpatrick

    purge and resize db

    Here is a little more material for your upcoming discussion. OpenEdge 11.7 will be retired in a little over a year from now, in April 2025. https://docs.progress.com/bundle/openedge-life-cycle/page/OpenEdge-Life-Cycle.html Progress has moved OpenEdge to a long-term support (LTS) model, where...
  4. Rob Fitzpatrick

    purge and resize db

    I don't think you have described your database structure in detail yet, e.g. whether your application data is in Type 1 or Type 2 storage areas. This is relevant for this discussion, as they do space management differently. What is the issue that makes you set on freeing space for growth...
  5. Rob Fitzpatrick

    purge and resize db

    Your table and LOB data lives in record blocks (sometimes called "RM blocks"). Once a block is formatted as a record block, it remains a record block. Even if you delete all the record fragments it contains, while the the record block is in a sense logically empty, its block type does not...
  6. Rob Fitzpatrick

    DB Parameters -S

    For future reference, in Windows the services file is %windir%\System32\drivers\etc\services. In Unix systems it is /etc/services. It is a mapping of service names to TCP or UDP port numbers. The -S parameter, when used on a database broker, is what makes it a login broker. The broker binds...
  7. Rob Fitzpatrick

    Macros, run an Excel macro from 4GL

    Good way to perform code injection in an application. ;)
  8. Rob Fitzpatrick

    Ideas for caching a table?

    It should! Accessing data in the buffer pool is of course faster than incurring database server disk I/O to page it into the buffer pool first, but it is far from being free just because it is memory-resident. I doubt that using -B2 will help in this case. Currently, that control record's...
  9. Rob Fitzpatrick

    Audit Trail Functionality in Progress OpenEdge 10.02 B

    It's not clear to me whether your questions are about OpenEdge Auditing capabilities in general, or about some QAD-specific implementation of it. If it is the latter, then this isn't the appropriate forum. It depends on what you mean by "access". OpenEdge Auditing (OEA) can audit system...
  10. Rob Fitzpatrick

    _proapsv high CPU usage in Redhat 6.6 (Resolved)

    Note: proadsv is the Admin service _proapsv is a Classic App Server agent As to what is happening in those App Servers, I don't know. The first thing to do is check your App Server logs. You might also want to revisit your database parameter values. For example, -Mpb larger than -Mn doesn't...
  11. Rob Fitzpatrick

    Locking up when inactive?

    Agreed, that 778/735 happens when there is a network disruption and the client disconnects from the database.
  12. Rob Fitzpatrick

    Error: could not recognize argument: localhost (301) Why?

    Glad to hear it. We've all been there. It's often easier for someone else to see the bug you've been staring at for a while without seeing it. Asking for help is a good way to get unstuck and make more productive use of your time, even if it's a little humbling sometimes.
  13. Rob Fitzpatrick

    Question After Imaging Files

    I think the "past musings" will suffice for now. However: Amen. The "A" in "DBA" doesn't mean "just lookin' around". We change stuff too.
  14. Rob Fitzpatrick

    Question After Imaging Files

    Some past musings on OE Auditing: https://www.progresstalk.com/threads/progress-auditing.122722/
  15. Rob Fitzpatrick

    Question After Imaging Files

    That tool is related to OE Auditing. My point was that it is just one tiny part of it.
  16. Rob Fitzpatrick

    Question After Imaging Files

    I've written here at some length about OE Auditing in the past. It involves extra work (reads, writes, BI/AI note volume), and work isn't free. It has a computational and storage cost. But that isn't a reason to avoid it; compliance requirements trump performance desires. And performance...
  17. Rob Fitzpatrick

    Question After Imaging Files

    CDC was introduced in 11.7. "Reporting CUDs" isn't much of a business requirement. If you were asking me personally, I'd want much more of an explanation of what you want to accomplish before recommending a solution. But I am confident that solution wouldn't involve parsing aimage scan...
  18. Rob Fitzpatrick

    DB Viewer

    If you want an OpenEdge data viewer, give Patrick Tingen's DataDigger a try. GitHub - patrickTingen/DataDigger: A dynamic dataviewer for your Progress / OpenEdge databases
  19. Rob Fitzpatrick

    Progress Openedge 11.6 with it's own java components

    $DLC/properties/java.properties only exists in OE 12.1 and later, according to the referenced article. It also mentions, for earlier releases, a file called $DLC/properties/JavaTools.properties that must be modified if you use OEE or OEM.
Back
Top