Recent content by shaw22

  1. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Hi Tom, It still locks up. I am trying to figure out if there is a pattern - like in a particular customer or type of service. I will keep you posted
  2. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Tom Thank You for the detailed instructions and handholding through the process! Cringer / Rob Thank you for your comments/help Attached is the documentation of the process I followed - it may help someone else
  3. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Thank You Rob. Tom, I have finished the dump and reload. Will let you know if there are any issues tomorrow once the office staff works on it Thank You very much for your help!
  4. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Hi Tom, See attached dbanalysis from olddb and the newdb. All record count matches except table _User. Do I need to export user table separate and import it ? (there is difference in blocks, size, %utilized - can I safely ignore that? Also, can i now delete the tssr08.? in e:\solution and...
  5. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Hi Tom, reindexing done. Log file attached Is there a way to get a listing of all tables and the number of records in each table?. I want to make sure I reloaded all table records by comparing the olddb to the newdb after reload
  6. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Is there a way to get a listing of all tables and the number of records in each table?. I want to make sure I reloaded all table records by comparing the olddb to the newdb after reload
  7. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Good Morning Tom I was able to create an empty database and make a backup I am running the binary dump now - see attached batchfile While that is running, I have a question on the .lg (log file?) - see attached - the log file starts in 2011 and has grown to 430MB (while the database...
  8. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Also please clarify prodb syntax - see below prodb program is in dlc\bin folder. production database tssr08.df is in e:\solution folder
  9. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Hi Tom, I can only dump data definitions - Select all tables with F5 * and dump data definitions to bkuptssr.df (File size 876,424) (original database size 596,115,456 tssr08.db) I don't see option to dump data and definition together?
  10. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Hi Tom, mpro and pro are not in the installation folders. ProDb is there. See the list of files in the install folders \DLC and \SOLUTION. Where can I get the mpro and pro files? Thanks
  11. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Hi Tom, I was out sick for three days. Thanks for the detailed instructions - I will try the dump and reload this weekend. >>> "We have been experiencing lockups when we search for customers..." is awfully vague. What, exactly, is happening? Are there error messages? <<<< We have an option in...
  12. S

    *URGENT* Progress 8.3E Database dump and reload to get rid of errors and to optimize performance - Application Service Solutions

    Hi Cringer, I removed the control numbers Progress version is 8.3E -Where do I find the service pack info -Windows 2003 -I haven't tried anything - don't know how to do the dump and reload -Errors are attached in my first message on this thread Thanks
Top