Search results

List your version of OE and the version you are migrating to. Going from 1 server to another ? Do you know the amount of time required to dump, load and rebuild the indexes on the large table. We had a similar issue about 15 years ago on 9.1a when we were moving from one server to another and...

1. If you follow your steps, AI would be off when you take an offline backup so option #1 can't happen. If you take a backup with AI enabled, you must have at least 1 empty extent because the backup will switch AI extents. I only took online backups with AI enabled - I am not sure if probkup...

AIX has filemon which is very handy when trying to track down I/O items. Windows has something similar so if you are familiar with that one.

it is common to replace probkup with snapshots and its a question commonly asked, well common for OE db topics... when applying AI files to a snapshot, you will need to learn how to use the aisequence option of proutil. probkup could still be used on the weekend until everyone feels...

On RedHat we use sar -r -R to see what % of memory is in use. That seems to work better for us than trying to look at swap column in top output.

In my experience the broker log would normally show the no servers available error. What do the server logs show ? Also can you start additional app servers so if one gets hung, there is another to handle future requests ? You can enable verbose logging on the app servers and that should help...

You can add extents to the live DB or the Hotspare DB without having to recreate the hotspare db. "We have to add a new extent by end of next week which will force us to recreate the hotspare db"

you can't truncate the stand by database's BI file and then continue to apply AI files to it.

usually the large bi growth is caused by an older character based application that allows a user to start a transaction while sitting in a screen. The user leaves that transaction open for hours, causing the BI file to grow. Check the active transaction screen in promon - R&D -> 1 -> 4 -> 3...

The broker log should show an error in the log if there are no available app server agents. It is a good idea to scan that log for errors. Do you allow the broker to spawn more agents if needed ? asbman -query will show the status of the app server agents. You need to see what state the app...

If fixing the code isn't an option and you still want to remove idle users holding an active transaction, you should get a list of users with an active transaction not all database users. The different flavors of linux or unix will provide an OS command to tell you how long a user is idle. One...

we run a batch asbman -query and check the output to make sure there are some app server agents showing AVAILABLE status.

you might want to stop the admin server and restart it. In the *NIX world you can kill the admin server with a TERM signal and then restart it and the admin server will restart and connect back with the running ubroker processes. I don't know if something like that is possible with Windows by...

You can use the proutil conv utility to convert the database to 11, then using OE 11 start moving tables to new type II storage areas. Version 11 can use multiple threads with the binary dumps, might be helpful.

If sql drop table will work then use that, but I don't remember if it was available in 9.1E. Make sure you remember to commit after the drop table and make a copy of the table schema. You don't want delete table via data dictionary. It might be faster to binary dump the 3 tables that share the...

Funny - Zerto is now being used as well. proquiet the db at night before batch processing begins. I think we snooze a minute here OS Snap of database using SAN tools. proquiet disable OS Snap of database is restored once a week and AI's are applied to make sure db backup is valid. this...

Most of the files in $DLC/bin/_* have the setuid bit set. You can look at the Progress KB to verify. If the setuid bit isn't set for some of the progress executables, you can get errors when running some utilities. In our environment, if the setuid bit isn't set the following will return an...

How many physical reads and physical writes is the database trying to do when performance is slow. Does the database checkpoint during that slow time ? Was there new code introduced during the time when the performance issue was noticed ? Disk IO and new code are good places to start...

We used to have the issue you have described, after upgrading to 11.5.1 I don't think we have had one in 16 months. Check the OS to see if the process had spawned another process and it is waiting on that to complete. If so terminating the child process can allow the parent to exit on its own.

What Tom said - write to fixed extents as much as possible during the load. I recommend putting tables with word indexes in their own area to avoid a single threaded data scan during the idxbuild. The more memory you can allocate to the idxbuild operation - the TF parameter - the better. The...