Search results

you can use progress auditing to record the before and after values of fields in a table. You don't need to write any programs or create additional triggers.

Article Number 000040228 The message can be ignored if there are no fields listed below it in the form: <tablename>.<fieldname>

I would recommend looking at the pfactor option to idxbuild. By default idxbuild packs all the index entries tight and fills 100% of the space. Now when records are updated, the database must do a block split to create the new index entries - a block split is very expensive. A pfactor of 80%...

Our 10.2B databases have been moved from 1 datacenter to another using vmware and vmotion. To accomplish this requires writing the server's memory to disk and then replicating that - so the IO performance of a system configured to do this is reduced. The more memory added to the server, the...

Progress Article Number 000019780 There is no way within Progress to control the TCP/IP timeout. This keepalive timeout can only be controlled by parameters within the TCP/IP layer. Changing the timeout value will affect all other processes relying on TCP/IP

If you want Progress support, you'll need to look at the Platform Availability and Lifecycle Guides. http://communities.progress.com/pcom/docs/DOC-32338

I like to run a table analysis on the old server and then again on the new server to make sure my table counts match. If you use a binary dump and load, remember to grab the sequence values and the _user table. If you use SQL items, there are a few more steps to move that data. Pay special...

I don't understand why you don't think the -Bt would help you if you have problems with temp file activity. It doesn't matter if you are using 32 or 64 bit, you can allocate -Bt buffers. A client parameter "-t" will allow you to view the temp files in the current working directory or where...

we did this a year or 2 back on an AIX system - OE was 10.2B and Oracle was 10g. There was only 1 database about 50gb to migrate so we did everything manually. converted the schema to Progress - about 150 tables. dumped the tables to CSV file and then loaded using the bulk loader. built the...

If you have problems using proutil, do you think it is wise to attempt a dump and load ? That probably sounded rude, but it wasn't supposed to be. Lots of things can go wrong with a dump and load so practice A LOT. A lazy man's approach to dump and load for performance reasons is - Do you...

if a client's temp file is lost / destroyed, their session will end and the server will back out any open transactions they had. The client's temp file that usually gets the most activity is the DBI files which hold the temp tables. There is a -Bt parameter that will allocate memory to hold...

app server - defined in $DLC/properties/ubroker.properties

Electronic Doc - OpenEdge Management and OpenEdge Explorer - Getting Started. Using the Console Starting OEM or OEE Logging on If you are logging on for the first time, type the user name admin and the password admin

I have the Progress OE 10 documentation. There is a OE Management and OE Explorer section. There is a section called Setting Up OE Management or OE Explorer for the first time. From another post it sounds like you have OE 11, but I would expect the doc to be similar.

OE Explorer comes free with 10.2B, as long as your license for 10.2B isn't expired, you should still be able to run OE Explorer. The Fathom product now called OEM requires a license. Have you gone through the steps to setup OE Explorer ? Is the admin server running ? The default port is 9090...

Has OEM ever worked or is this a first attempt ? Is the admin server still running ? Need to look in your logs - admserv.log is a good place to start. Do you see the following line in your admserv.log [4/2/13 11:23:25 AM] [3] [Fathom] Listening for HTTP connections on port 9090

If you have AI enabled (and you should), you can keep AI enabled by activating the indexes with idxactivate instead of idxbuild. This comes in very handy if you are keeping a standby copy of the database in a separate physical location which is kept up to date by applying AI logs. If idxbuild...

This is a common question so searching the forum or using a search engine should provide a lot of info. The basics for accessing a database via SQL 92 are a port the database is listening on and a user with SQL rights. proserve "dbname" -S 12345 should bring up the db with a listener on port...

The performance probably isn't so much about the vendor - 3par or EVA, but how the storage is configured. It usually comes down to RAID level and cache. Instead of talking about backup times, how about a corrupt index on a frequently used table and have to run idxbuild to get the system...

applying structure changes will depend on if you use fixed length extents or variable length extents. If your prod db writes to variable length extents, then the new extent is simply added in between adding AI files to the warm spare. Almost all OE databases write to var length extents. If...