Search results

Dear lord help me for knowing this :-( In the ancient days array extents were not mapped to individual fields.. you had to use the PRO_ELEMENT function to specify which array extent(s) you want from a virtual delimited column. Progress KB - How to view one element from a Progress array field...

Since everybody else helped with the DB settings.. :cool: Run vmo -a to check the values of: minperm maxperm maxclient strict_maxclient strict_maxperm If you were previously on AIX 5 or if someone felt they knew better those parameters might be wrong for a database server. If you have nmon...

I might be a little biased but I think it is Infor SX.e :D

I did a fair amount of testing with ext3 and ext4 on Linux (Amazon - Redhat branch). From an OE perspective I didn't see any real performance benefits to take the perceived "risk" of using ext4. Of course YMMV. I doubt you would run into any actual issues with ext4 though as it is quite widely used.

That is one good argument for getting a cost based optimizer in the 4GL :-)

Just a small add to what Rob said (all great advice).. It is possible you have some other queries that are causing the excessive reads without showing a WHOLE-INDEX in the XREF. You could have a FOR EACH with equality matches on status and/or type but range matches on other columns. So the...

You already have good advice about how to configure the OE database to help with your issue. I would like to suggest you look into the close and dispose methods for Crystal Reports so that you actually disconnect from the database after the report is run :-)

Fabio wasn't suggesting that you permanently remove the NO-ERROR... just for the purpose of testing so you could see the error. Like they have said... the difference is a FIND FIRST will only try and find the first record that satisfies the WHERE and will only throw an error if nothing matches...

It has been about 100 years since I have done this... but I believe it should still work. Make a new startup procedure that contains the following code: ON CREATE OF <yourtable> DO: MESSAGE PROGRAM-NAME(1) PROGRAM-NAME(2) PROGRAM-NAME(3) PROGRAM-NAME(4) PROGRAM-NAME(5) PROGRAM-NAME(6)...

I think we are going in a bit of a circle here :-) Writing to tape in general is not reliable. - In your exact scenario (probkup to disk then copying those files to tape) -red makes no sense at all. - Depending on your OS, backup software and tape drive model you do have a variety of options...

My point was... although -red is mostly useless when writing with probkup to disk. The concept of CRC blocks and redundancy when writing to tape is still very valid. Tapes are fragile things and the last thing you need is a useless backup. It really doesn't matter if your probackup file is 100%...

Everything is a trade off when it comes to backups and performance and errors can still happen (reading or writing). That being said... I haven't use -red in probably 20 years. Assuming you are testing restores and AI roll forwards on a regular basis you should be fine without -red. Any...

If you moving from 9.1E you might as well go to 11.6.2 instead of 11.3.... and make sure you are moving to a 64 bit version of OE for the database server (to match your 64 bit OS). The short version of why Type II areas are better than Type I areas... Type II areas make sure that a single...

Never ever run your database on a remote device. Ever. Just don't. I have no idea if 9.1D was supported on Solaris 10 or not. The remote/nfs mount for the DB is the likely cause of most of your issues. Stop doing that ASAP.

Make sure you get better monitoring in place like Tom suggests. A replication target doesn't really help if it isn't live. Posting the exact error messages and current state would be really helpful for us to help you. If your target DB is able to be started.. make sure the agent is started...

Just echoing what everybody else is telling you... if you have ever used -F against this database you MUST do a dump and load and try and salvage what you can. Everything else is just a series of hacks to get into the database. If you care about your job and/or this data you need to schedule...

What evidence do you have that Progress or DataDirect is the issue and not MySQL or another process? Meaning what kind of tracking/monitoring do you have in place for the Windows Server to show which processes are using which percentages of memory, CPU and disk resources. That should be your...

Progress KB - Is there a better way to recover from a schema lock time out issue ? That KB has a program that scrapes the output from promon. As far as I know there isn't an associated VST to get the same information.

One of the many perils of being on an ancient unsupported version of OE is not being able to use new versions of operating systems. Running V9 inside of a VM might not work well for you either. It depends on how well the VM mimics the older OS version.

The following RAID levels should only exist (imo).. 10,1,50 and 5. Anything else is just asking for tragedy. I am still trying to encourage a certain former employer to embrace the joys of internal SSD for their databases. Not much luck so far because managers just love SAN storage. Not that...