Search results

I like to keep tables with word indexes in a separate area as well as their indexes. If you decide to enable auditing, I like a separate area for tables and indexes.

There are entries in the Progress KB about shutting down a database remotely and possible error messages that appear - such as yours. If a remote shutdown request is made from an older version of Progress the shutdown request is denied, but a different error message is displayed: Shutdown...

I believe you need to look at the links to the Progress KB that were provided above. The progress kb includes OEM screenshots for how to configure the database to support SQL connections.

you need to post the startup parameters for the database.

you should mention the version of OE that you will be using. Depending on the version of OE, you have different options available dealing with activating indexes.

It might be related to the min, max and initial value. Starting with a version in OE 10, I believe the initial value can no longer match the max value when creating a sequence. There is info on this in the KB.

I agree with MadDBA, have a process to restore backups from disk and apply an AI or 2 on occasion and drop red, probkup is slow enough already. I haven' t used probkup for a db larger than 50gb in several years, proquiet and then the SAN tools to get our backups is so much faster and less...

1. You would get a performance boost by switching to a db block size of 4096 or 8192. On windows we use 4096, and 8192 on the rest. 2. I think it is time to ask the hardware team to look for issues. 3. I don't understand the reason to have your databases on remote share. 4. I don't know if...

The Progress KB states 1 idxbuild if you use convchar and 2 if you don't. In 10.2B08 there are many performance improvements made to the idxbuild utility. If your index rebuild was taking several hours, you could see a 50% reduction or more in time. The improvements first appeared in...

Go ahead and dump all the tables just as a test to see if all the tables can be read and accessed. Restoring a database backup doesn't recreate the database from scratch, that is why a D&L is recommended. If you are a bit nervous about performing a D&L, look at the Progress KB or search...

If you have corrupted the master block of an area, then you should consider running a dump and load to create a new db. dump the existing tables from the database with the corruption in the master block. Create a new database and load the tables into it.

another option you might have is to dump the data via SQL.

as a test, add a variable length extent without specifying the name to bi or ai or db and see if prostrct knows the proper name to give the new extent. b . a . ...

1. The default OS user id you are referring to is the account that was used to create the database. if the database log has never been trimmed, you could look in the db log to see what user created the db. you can simulate by creating a copy of the sports db, serve it with a port and then...

I would stop the admin server, make a backup of ubroker.properties, update to ubroker.properties using vi or a text editor on windows, then start admin server, then use asconfig to check the syntax of your new definition. sqlexp is a command line sql query tool. OE Explorer is a gui tool...

A couple items are helpful to share your Progress / OpenEdge version and your OS platform. So you have a prod server with a prod app server working fine. You have a clone of the prod server and you want to create an app server on the cloned server, the prod definition is there, but you want to...

readprobe was to measure reads from database buffers. the atm benchmark was to stress disk io.

is there a large amount of records being created / updated in the tests where the performance is slower ? You might have built the indexes to 100% utilized so now there are a large number of split blocks when an index is updated.

You should be able to start the db with an SQL broker and then pull the data out. I would recommend looking over the OpenEdge / Progress knowledge base. there are multiple entries for people trying to do this. If your database came from a vendor as part of a software package they provided, it...

A 1.6tb db on a 32 bit database. You are probably chewing up your disk resources on reads... Would be interested to know what promon shows or the VST show for disk reads and OS Disk Reads for each minute for 30 minutes. Might change the lruskips from 5 to something larger - 50 or 100 I think...