Recent content by TheMadDBA

  1. TheMadDBA

    Resolved Question About Sysprogress Use Locking _sec-authentication-domain

    The SQL engine will put a share lock on several of the underscore tables depending on the version of OE. That session needs to be issuing a COMMIT or a ROLLBACK.. regardless of the transaction isolation level. If it is truly just sitting around then it should be leaving the session. On the plus...
  2. TheMadDBA

    Backup Is Very Slow.

    Look into the iostat command on AIX. There are options to track disk IO and total throughput on the host. You can run a sample during the fast backup and during the slow backup and the results should be pretty clear. There are also a host of vmo and ioo options that control how memory is used...
  3. TheMadDBA

    What Is Meaning Here Order 20 And Order 30

    One thing that will matter if the order is changed.. if you so simple exports of data (export Monitor) from the table and try and import it again with different field orders you are likely to get errors or logical data corruption at the least. But essentially it should be something you ignore...
  4. TheMadDBA

    Question Status Default In Windows Vs Tty

    No offense... but the first basic mistake was trying to use V8.3. It was released in 2001 and is very much a dead product, several more full releases have come and gone since then. V11.7 is the newest version with V12 around the corner. It is a miracle that it even works on any version of...
  5. TheMadDBA

    Question Url Shortner Service

    Google URL Shortener
  6. TheMadDBA

    Cgiip Vs Wsisa

    The short version is... the CGI interface is pretty simple and rock solid. The WSISA interface is a little more buggy and had (maybe still has) memory leaks. I would spend more time looking into the startup/code/network side of things than CGI vs WSISA. I would bet there is something there that...
  7. TheMadDBA

    No More Available App Servers - Need To Find Program(s) That Are Hanging

    I prefer the stacktrace method that Tom suggested.. it works every time without a ton of logs to parse. It will also show you any orphaned persistent procedures.
  8. TheMadDBA

    Substitute Function Consumes More Time

    yeah... exactly where is all of this data to concatenate coming from? If you are really doing the loop as show above.. the string is getting longer and longer on each iteration as you pass it to the substitute function... where the concat is not doing that. Exactly how much data (length of the...
  9. TheMadDBA

    Substitute Function Consumes More Time

    Crazy thought here.. you seem to be able to run the profiler.. so why not actually profile the entire code and see where you are actually spending your time.
  10. TheMadDBA

    Querying From A Linked Server On An Indexed Date Range Seems To Force Table Scan

    Is your where clause literally WHERE 04/23/17 <= tranDate AND tranDate <= 04/25/17? If so... don't do that. Use tranDate between startdate and endate or (tranDate >= startdate and tranDate <= enddate). Also see this KB to see how to enable/disable SQL query plan logging ---> Progress KB -...
  11. TheMadDBA

    Question Truncating The After Image Archival Log File

    There isn't a prolog style option because that would make too much sense :D The rather complicated workaround is available here Progress KB - How to archive the AIMGT after image archival log file online? On the plus side my largest archival log is 11MB.. about 4 months of data with AI pulls...
  12. TheMadDBA

    Configuring Oe Replication Plus For Dummies With Openedge Explorer

    I would suggest that you keep the replication port/broker distinct from your 4GL/SQL traffic.
  13. TheMadDBA

    How To Convert Type I To Type Ii Databases .step By Step

    Are you interviewing for a new job?
  14. TheMadDBA

    _mprshut - Why?

    The ps command (depending on your OS) will include all memory for a process.. including any shared memory like the buffer pool.
  15. TheMadDBA

    Question Software Upgrades / Db Changes To Large Tables

    Like Rob said.. indexes are your most likely culprit. Schema versioning should take care of the new columns almost instantly in modern versions. In older versions I seem to recall some issues with default values causing actual writes though.
Top