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

[TomBascom]

proutil dbname -C dbanalys > dbname.txt

 

[shaw22]

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

 

[TomBascom]

proutil dbname -C dbanalys > dbname.txt

 

[shaw22]

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 replace it with the newly created database.

bkuptssr.bi rename to tssr08.bi
bkuptssr.db rename to tssr08.db
bkuptssr.df rename to tssr08.df
bkuptssr.lg rename to tssr08.lg

 

[shaw22]

attached is the comparison. please review and comment

 

[TomBascom]

Yes, you can safely ignore the differences in utilization etc. Those are an expected result of dumping and reloading.

Unfortunately you cannot binary dump _user. You should be able to do a dictionary dump of it though.

I wouldn’t delete the old db until I have thoroughly tested the application with the new one. And even then I would just do something like rename the directory and keep it around for a while - just in case something comes up…

 

[Rob Fitzpatrick]

To dump _user there is a separate menu item: Admin, Dump Data and Definitions, User Table Contents... .

 

[shaw22]

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!

 

[Cecil]

Recommendation is to document this process in detail, just in case you (or someone else) need to do this exercise again.

 

[shaw22]

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

 

[TomBascom]

Has the reorganized database resolved your “locking up” issues?

 

[shaw22]

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