Search results

Oracle and some other RDBMS environments allocate a fixed amount of storage based on the column definition. Progress uses variable length for everything.

Interesting, it seems to be a continuing trend to remove BLOB's from databases. Just curious, is it because people are tired of backing up the BLOB data with the db and when the db is restored for testing the BLOB data is there as well ?

I don't know of a way to shrink a storage area without a D&L. Are you looking to move the blobs to a different storage area ? We hit a bug in 10.2x where you must load the blob into the same area number it came from in a dump and load. I don't know if that is fixed in 11. We moved some...

Use showcfg to see what products you have licensed. Replication plus is an additional charge. After you upgrade to 10.2B try to get Service Pack 6 or newer - 8 would be the latest. after the db is upgraded to 10.2B, there are options to move tables from schema area to a new Type II storage...

1 item I ran into that slowed down the index rebuild was I had tables with a word index in multiple areas. Areas containing a word index will not use multiple threads, so I moved all tables with word indexes to their own area.

I have not heard of that issue before. Does each read of the view produce a new connection to the database ? Does this only happen when reading from the view or would it happen if you read from a table as well ?

We have had a similar issue with the error 1422 and we run idxfix and it finds no errors. In that case our problem was with a unique index on the table. We ended up with null values in a column which had a unique index defined for it. Progress will let you create a unique index on a column...

I can't see the attachment, but 1422 errors are related to index issues. We fix with idxfix - option 3.

I think that disk queue is an issue. I would look to somehow lower the disk queue - whether by moving files or adding disk. Do the disks have write cache ? That is probably another long discussion. Pages / sec is activity reading from disk and loading the contents into memory. That is...

My best guess would be there is an IO bottle neck. Have you used perfmon to see the queue size on the disks that are holding the databases ? Does processing an XML file require writes to multiple tables and to more than 1 of the 3 databases? Do you collect table stats to see the read / write...

if you have excel - do you have Access ? I know you can import records from Progress into Access. I have not tried with Excel. I also don't know what you mean by Links.

If you have 2 databases with different tables, then a simple dump and load into a new database with Type II storage areas. If you have 2 databases with the same table names and the same fields then follow RHD's advice and check for unique key violations and potential performance issues when...

You can check the timestamp on the properties files in $DLC/properties, they were probably updated. There is also $DLC/bin/java_env.

OK - we just had one arrive for a POC. I'll try to post our results.

Rob - can you post your initial thoughts on the storage ?

running a table or database analysis on a regular schedule will allow you to see growth.

What does the database log show ? Is one of the servers going down and that is why all the connection failures ? You can look at those with promon R&D -> 2 -> 2.

maybe a batch file that runs every 15 minutes and uses "net session" to list the users connected to the shared folder. Won't help this time, but next time you would have a history of users on the shared folder.

port 20931 is the default for the admin server right ? Looks like the errors above are from trying to start the admin server and it is already running? I'm guessing the databases are set to auto start the databases. Without some info from the db logs, I can't offer much more.

setup perfmon to monitor disk queues where the database and backups reside. compare the values during the slowdown to when there is normal operations.