Search results

No - assuming your PATH is set correctly and includes $DLC & $DLC/bin, then dbtool <path to db you want to access> will work fine.

You need to set the LD_LIBRARY_PATH in your profile. Each OS has a slightly different variable for this, but I believe that is the correct one for linux. export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$DLC/lib

have you considered progress auditing which can do that for you ?

Dump and Load steps and hints are one of the most common progress topics there is. The info should be easy to find with a web search. If you are starting from the very beginning, you will probably use 40 hours to research, script, test and implement the dump and load - figuring on a database...

must have a license which allows development go to the $DLC/src look if prodict directory exist - if not create with extractpl prodict.pl look at load_df.p

The recommended way to upgrade an older ubroker.properties file to a newer version is: 1. Save a copy of the old ubroker.properties file 2. Rename the current ubroker.properties file 3. Copy the ubroker.properties file from the older version in 4. Stop and restart the AdminServer...

Why not just time them and see ? If the tables are in the same area, they are large, and there are few other tables in the same area - then a table analysis might be the best option. If the tables are smaller - less than 1 million records or in a large area with lots of other tables, then an SQL...

thanks Rob - I was making this way too hard....

Progress 10.2B0606 Linux and HP hardware I am a DBA - not a developer... I need to simulate a user connecting to a database with auditing enabled and then kill the session in less than half a second. I can get the pid from _MyConnect and the pid field. I am trying to use the UNIX or OS-COMMAND...

One other item we just noticed. In both cases the AI with the incorrect timestamp was produced - AI notes were written as a result of work being done in the data dictionary involving schema changes. There was no other users in the database - only AI notes produced were a result of schema work.

While applying AI logs to 2 separate databases in the last couple months, the roll foward has hit a timestamp error and we are unable to continue applying AI logs. The scan of the AI log shows it is a legit AI log, but the timestamp the next AI file expects is wrong - it doesn't match the...

If you are trying to squeeze performance out of the database - adding CPU's usually doesn't help much. Do you know what the disk io activity is while the db is running ? Do you know what the database server and client parameters are ? Do you know how much activity the database has during a...

asbman for the app server has a -kill. I thought the emergency shutdown killed all the connected sessions and didn't back out any transactions before shutdown. The transaction backout is handled during the next database startup. I did a test of proshut -F on a copy of the sports database and...

I'd probably change the -vs or volume size to something larger. Maybe another option would be to first run a probkup with -scan and -estimate to try and determine how big the backup would be. Then build the rst file based on the results of the estimate.

Re: "ai files roll- forward" I'll add some comments - I'm not sure what the steps above were supposed to accomplish. Step 5 - why did your backups skip from go1 to go3? Step 12 - your backup failed because Progress wasn't able to switch to a free AI extent - go.a1 is still full. Step 18 & 22 -...

If you remove a lock file with the original session still connected to the database, then another user can connect to the db while the first session remains logged in. Now you have 2 users using the database in single user mode and you can get timestamp issues when one user logs out and then...

Can you kill the pid of the session that was using the database in single user mode ? That would be better than removing the lk file.

You need to build indexes after a binary load because the index entries are not created during the binary load process.

what does windows perfmon show on the disk queue for the drives being read from and written to ?

Our policy is to not install hot fixes unless it is an emergency. If I thought the issue for the agents stuck in SENDING mode was related to a Progress bug, I would try to upgrade to the most recent version of OE - not just a hot fix on my current version. If you are having a problem when...