Search results

There are noticeable performance boosts in 10.2B with SP03 and SP07, so getting to SP08 will be worth the effort.

Does your live system already support ODBC connections ? Configuring ODBC connections to a live db and then running update stats on a regular basis is a noticeable amount of work. After that is setup, I haven't seen much of an impact on read only ODBC connections. I have not had to support ODBC...

Depending on your version of OE and the parameter "allowruntimeupdates" in the ubroker.properties file, you might be able to lower the logging level online. I don't recall if cat /dev/null > log will actually release the space without having to stop the app server.

you could tell them that those permissions don't meet your company's security standards. Usually saying something about their setup fails our company's security audit is the best motivation I have with vendors.

Is the schema the same in the 2 databases you are testing ? Is auditing enabled on both or neither ?

I have been around a couple applications that used the Oracle DataServer. The application can be updated to make the reads perform acceptable, but we weren't able to get large updates to process quickly. If there were 100 records to update, the Oracle DataServer would send them to Oracle as...

OpenEdge Communities have some chatter. Seems like most of the posts relating to databases are coming from the Asia region. We tried to start / revive the Progress User Group for the Midwest region in the U.S.A., but it didn't last.

Does Progress still give the job title of Evangelist ? 20 years ago a Progress team came to the company I worked for and one of their business cards had Progress Evangelist as the job title.

Verify what software you have licensed for Progress. If you are on windows, I think there is a showcfg icon in the OpenEdge or Progress folder, on *NIX systems you can just type showcfg. If you have a 4gl dev license or possible some other license you might be able to write some basic 4gl code...

For your third question - Companies I saw were using Database Auditing to track records that had been updated. The changed records were queried and then dumped out each day, querying that data was not efficient. This type of use is better managed with Change Data Capture.

If you log on to the server using the account that created the db, then that account is the default admin and you can grant SQL permissions. Another option is to create the sys user for the db. There are articles in the Progress KB that explain how to do this. Just search for how to grant SQL...

if you had the entire db log, it would show the user that initially created the db. That is probably the admin user you are looking for. is this database on windows or unix ? What OE version is the database ? what are you trying to accomplish after you obtain this admin user? grant SQL...

enabling client logging or generating client protrace files should help look at the call stack to see if it is what you expect.

Triggers if needed would have to be written for Oracle, but the rest of the schema translates over fairly simply. The data can be exported and then loaded into Oracle via ascii dump, or you can attach Oracle to Progress and pull the data over via SQL - well you can do this with Oracle 11g and OE...

I was in a situation where it was worth the risk of reading the _Lock table every 3 minutes so we could track down user locking issues. I would recommend checking the total number of locks before attempting to read the _Lock table. If the total number of locks exceeded a certain value (I...

For tables that weren't large enough to justify their own SA, we grouped them by RPB, we have 32, 64 and 128. We also created an area for tables with word indexes - done for performance during index rebuild. When we started using the lruskips, the B2 wasn't as big of a performance boost. It...

I believe ubroker.properties has the properties for the ubroker components and database properties are in conmgr.properties file.

you can change the logging level property on the app server to show the programs being executed. you can generate a stack trace on the app servers that are hung and that will show the last program executed.

One change that will help track the activity of the database, is to increase Number of indexes included in statistics collection (-indexrangesize): 50 Number of tables included in statistics collection (-tablerangesize): 50 Get the number of user tables and their indexes and then update the...

As Rob stated - its hard to give recommendations to fix or correct a problem, when we don't know what the problem is. Just that you now have faster hardware and more memory. If you want to use more memory, increase the -B parameter and maybe start using the Alternate Buffer Pool - B2. I would...