Search results

  1. R

    OE REPL

    Ive used replication in various db products, I was once an escalation engineer at Microsoft for transactional replication, fathom replication is the most stable replication solution i've used. Its trivial to set up and administer and provides metrics via vsts so you can visualize via windows...
  2. R

    Partitioning for archiving

    The purge was being done from the days of type 1 storage areas and spinning disks, the vendor traditionally did the dump and reload possibly due to lack of knowledge from the dbas and likely due to tradition, someone once mentioned an issue with the data dictionary as the reason why the dbas...
  3. R

    Partitioning for archiving

    Every December we delete about 200,000 records from our DB, each record takes about 3 seconds to delete via a vendor supplied deletion tool and the process runs out of hours and at weekends, this is followed up by a dump and reload/reindex on new year's eve run by the vendor. This process...
  4. R

    Question Unable to create socket. errno=2 (781)

    Can you telnet to the server port from the client? Or use powershell test-netconnection -computername -port
  5. R

    Question Real Time Data Replication for BI Reporting

    One of the companies in our group is using auditing to do this, they parse the audit table for updated records and then read the changed records in to SQL server.
  6. R

    Reliability

    I've been administering a progress db with replication for 18 months now and since 11.7.3 I can't say a bad word about it, it's ridiculously reliable. Sure there are things id like to see such as the promon screens turned into individual programs I can schedule (I also have vsts so it's...
  7. R

    Proutil dbname -C idxbuild all is not work utf-8 problem (11.6.4)

    You need to install a utf8 word break table Documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dvint/compiling,-storing,-and-applying-the-utf-8-word-.html
Top