Search results

Hi Experts, I have a problem and I do not know where exactly it is. Our billing application is running over Progress 9.1D SP06 Database on HP-UX 11. Two days the billing process is painfully slow also the production of bill into a text files. I do not pretend to be deeply familiar with the...

Hi, I have database with 128 records per block and 8K database block size. I’ve created new database designed with 64 records per block and 8K database block size. Now I’m trying to restore old database (128 rec/block) into new database (64 rec/block) but there is error message “Records per...

Hi Casper, Sorry for some moment I understood the information wrong, yes I saw in database documentation that the number is 256 so the current situation is not so criticle. The factor for the table sized 25.1 G is 4.0, table size 16G is 3.0 Ivan

Hi Casper, Sorry for the late answer I was out of the office for some time. So dump and load was never performed on the our database and thats why it is so big currently. My strategy also is based on your rule, but unfortunately wneh the database was created previous DBAs does not separated...

Hi Casper, Thanks for your answer, I will check again maximum # of extents, I really hope that I’m wrong. Before starting to move tables I’ve read this article but actually I find this way too risky . About BI files, there was actually vastly growing, but when I started to move next table I...

Hello Experts! I’m facing with problem which I actually don’t know how to solve. We are using Progress 9.1D SP6 on HP_UX11 Server, and currently DB size is 175 GB, initially the database is started with one storage area and index area, now the last table extent in the table area is file number...