Search results

Morning, Progress v10.2B on redhat. got a strange situation and hoping that I might get some suggestions from this forum. We use 3 production databases for each of our customers and do a full online backup every evening. Checking the logfiles shows that the smallest of the 3 databases is...

Morning, thanks for the input, it's helped clarify a few things and given some good ideas. I've run a couple of test scripts to look at transferring the backup files in parallel rather than in series and it knocks off about 2/3 rd's of the transfer time so we're well pleased with this gain...

Thanks for the response Tom, no it's not read-only. we apply various data updates once the reporting database is built, but I think we'd be okay have to keep the Saturday night full-backup and start rebuilding the database every night from this, applying the increasing number of incrementals...

Afternoon all, v10.2b on linux. we're looking to change our db backup routine and would appreciate some input as regards the new plan. Currently, we've got 3 live databases running 24/7 with AI (which is mananged by the AI archiver). We do a full online backup every evening, transferring the...

Morning, thanks for the information. Happy with the explanations posted - I wouldn't have expected the HWM to reflect deleted records, but if the -com option is skipping empty space below the HWM that explains why it could be smaller. Solved. Regards, DG

Afternoon 'talkers, OE 10.2A on Red Hat. We've got a database (8 kb blocksize), which we do a full backup of every evening. For information, the backup is done online, with the -com option. We've noticed that the most recent backup was about 17 blocks smaller than the previous backup. Given...

Afternoon cj_brandt, the answer to your last question is yes. (Un)fortunately, we've now bounced the database (some other issues occurred as well) so I can't check these. Got to admit I didn't bother checking for the logout message in the db logfile. As for the _connect table, I was only...

Morning, OpenEdge 10.2A on redhat. we've got a user who was disconnected via promon, but who still has an entry appearing in the promon record locking screen, but the transaction doesn't appear in the active transactions screen. Trying to figure out how to go about freeing the record...

Morning 'talkers, openedge 102A on Red Hat Linux 4.1 Database has largeFiles enabled, and a blocksize of 8k. ulimit shows "unlimited". We've currently got a variable extent of about 2.5Gb, so I'd like to know what size this file could reach ? TIA, Danish.

Thanks Tom. v6 ? Good to see we're keeping on top of our startup parameters :)

thanks RHD. that'll do for me.

Afternoon 'talkers, Openedge 10.2A. We're currently reviewing some of our pf files, and came across one which defined a "-e" startup parameter. Had a look through the documentation and the kb without success. There is a -E parameter (European format) but we would not be using this, so...

Afternoon 'Talkers, hoping someone might be able to help withthe error message below which has suddenly started appearing on our web development system: "CGI Error The specified CGI application misbehaved by not returning a complete set of HTTP headers." TIA, DanishGambit.

Afternoon 'talkers, while having a look at some vst's today, noticed that the checkpoint vst (_checkpoint) has a start time and length field - both of which contain date time stamps and I'm curious about the length of time between the end of one checkpoint and the start of the next. e.g...

Morning 'talkers, OE 10.2A on redhat. we had an issue over the weekend whereby the database server ran out of disk space on the partition where we keep the webspeed log files. The webspeed server logfile had reached 52Gb and blew the partition. Given that I'd previously setup the...

Morning 'Dude, thanks for the prompt response. Yep, I was looking to tune the cluster size as we are seeing some small checkpoint intervals during our peak usage times. I know there are few absolutes with respect to tuning, but I was after some opinions on whether having 40'ish BI...

Morning 'Talkers, hoping for some advice on BI Clusters. Did some checking recently, and found we had 2,017 BI clusters (each of 512kb) on one of our databases, and 42 BI clusters (each of 2,096kb) on another. Just wondering what sort of numbers you'd be hoping to see on your databases...

Afternoon 'Dude, thanks for the info - killed the process and that did the job. Yep, I'd come across the logfile threshold and number of logfiles while looking into the problem and hope to use these to prevent this happening again. Regards, DG.

Afternoon 'talkers, OE10.2A on redhat. we've currently got a situation were the writes to a webspeed server logfile are continuing despite the fact we've shut the webspeed brokers. Just wondering if anyone has come across a similar situation ? If so, how did you deal with it. TIA, DG.

Afternoon again, problem solved - nothing to do with the backups - the issue was that the script used to restore the spare database starts after-imaging and ai management. Should've spotted it sooner :-( thanks anyway.