Search results

It's working fine, now. Thanks once again for your valuable help. Ron.

That you very much. That makes sense. Clearly I should have examined the Progress example more carefully. Cheers, Ron.

I'm still stuck. I found and read the Progress doc where it said that an external procedure was needed - and changed the test code accordingly - but the behaviour hasn't changed at all. The part of the main test procedure is now: DO i = 1 TO 3: ASSIGN db = LDBNAME(i). IF db = ? THEN...

Aha! Thank you for that. Now that you've pointed it out - I remember that important detail! Cheers, Ron.

Hi - I hope someone can help me. I've used with the _Lock and other VST tables before without trouble - but I'm having a problem in a multi-DB environment using DICTDB. I have used DICTDB before - but not with VSTs. I'm testing on a 9.1D environment (old, yes, but that's what I've been given -...

Tom - thank you very much - a very informative document!

I already collect LOTS of stats for the in-house servers - but not at the remote sites. But I like your idea of checking for contiguous records in the same block. I can do that. Thanks for the idea!

Yep - I'm with you. But the trouble is I don't know what are the "offending tables". That's why I'd like to be able to get scatter factors of sections of tables. I think that whereas tabanalys says every table is "great" - some big - frequently-accessed - tables may be very disorganised in...

Yes - quite aware of the type II storage areas - and the advantages of using them. But rolling-out the upgrades to Linux/Progress 10.2B at very remote sites is a pretty slow process. Most sites will have to "suffer" remaining with Progress 9.1D (and type I storage areas) for up to two years, so...

Hi, I'm working with a system that is widely dispersed - over 200 small servers over a large geographical area. Most are UnixWare / Progress 9.1D - but migration is under-way to Linux / Progress 10.2B. (All licences at remote sites are Workgroup; AI is in use everywhere.) During the past year...

I'm preparing to dump/reload a large number of DBs that have not been dumped/reloaded for a long time (in many cases since Progress 7). The version of Progress is now 9.1E - under AIX 5.3 During testing I get a failure loading a table: Start DATE/TIME for edi-func-key Thu 03 Mar 11 21:55:43...

Sorry for the delay ... I had another problem. My scripts do binary dumps, with: $DLC/bin/proutil -RO $DBFILE -C dump $tab $dumpdir I just did a "manual" dump of all tables using the Procedure Editor. It gave no errors - BUT every single table dumped zero records! Obviously there is a...

I have scripts originally developed to D/L Progress 9.1D DBs under Solaris 8. I recently tweeked them for a new environment with Unixware ... no problem. I'm now tweeking them again for a different environment with 9.1E under AIX 5.3 - but have struck trouble. The new environment has MANY...

Thank you VERY much, Tom. That is certainly helpful. I now have an explanation - and another reason to get Progress updated to a later release!! Cheers, Ron.

Hi ... I've come across a problem that has me stumped. I hope someone can help me! I have developed a system for doing "unattended" dumps/reloads at remote sites. There are a little over 200 sites - each using Progress 9.1D ("SP00") on Unixware. Yes - I know it's all "really old". I've made...

After a little work - I got this code working OK. SO ... I can extract the current sequence values from the database. BUT ... how can I get them back IN - without using the Procedure Editor?? I am dealing with dumping/reloading many databases at remote sites (over 200). Using the Procedure...

Thanks ... but I found the answer in the Progress manual "Progress External Program Interfaces " The problem appears to be that Progress senses EOF after each receive (of a request) - which makes the current loop exit. So - you have to re-open the pipe each time, like this: REPEAT: INPUT...

Yep - named pipes are what I've been experimenting with - but without success. (BTW - I've used named pipes in the past between scripts without a problem.) Here is what I've been playing with: ksh script: # cat test.ksh #!/usr/bin/ksh93 export ASK=/tmp/ask export REPLY=/tmp/reply function...

I'm working with Progress 9.1D and Unixware. I want to have a 4GL program that acts as a "server". A Korn shell script will give it data requests - and the 4GL program will respond with the results. I've experimented - but can't seem to find a way to get this to work. Can anyone suggest a...

Thanks <sboarduk> for the link to get top - I now have it. Tom: sar -r gives the same value for "available unused memory" as top - and the value does look "reasonable". Are you sure sar -r is no good? What would you suggest instead?