Search results

NTP drifts the clock in the background which is harmless for trivial adjustments. Most unix "date" functions contain an adjustment "date -a" function which drifts the clock. This is safe with Progress for time adjustments of a few minutes. Do not put an absolute date in with unix "date" without...

Digital unix has a new name. Try asking HP about Tru64 unix 4.0F , making it clear which DEC Alpha server model, the media type required, and which unix licence codes you have. The kernel tuning for Progress 9 should be similar to the older unix.

Try this syntax. proutil -C dbanalys -db <database> > logfile.log Also check that ${PATH} includes ${DLC} and ${DLC}/bin . You may have to set them in the script. To check the interactive environment use unix "env" command. Also write a one-line cron to capture the output of unix "env"...

The simple answer is no. Your backup strategy is good - probkup to disc then tape backup. To avoid overwriting your latest probkup to disc you will need sufficient free disc space for an emergency restore of an old probkup from tape.

The date format mismatch is probably caused by a mismatch of database startup parameters for the old and new databases. When we had this problem, we had dumped the database tables in multi-user with a custom ".pf" but loaded the tables in single-user with the default /opt/dlc/startup.pf ...

If you have multiple ".df" files and you don't know what order to apply them you can get an idea of the database creation order from the Index Number. output to /tmp/indexordertest2.lst . FOR EACH _Index: FIND _File OF _Index. DISPLAY _File-name _Idx-num _Index-name. END. cat...

No problem visible here No problem visible here. "SHR" is a shared "L" (lock). i.e. nobody else can change this record while either of these two sessions are accessing the record. There is no queue "Q" (or even the infamous upgrade to exclusive lock "U") on this locks display.

Off topic BI stall One day this will save your life. You need to set -bithold (to say 800 Mb) and -bistall. BTW, the best single throughput improvement (at the expense of BI file size) is to up the BI cluster size. Try looking at PROMON database checkpoints - if you are in the thousands not...

Needs a DBA with detailed knowledge of Areas. Please do check disc space in the disc partition containing allpedi.d11: cd /allp/db/data00/ df -k . # i.e. df<space><hyphen>k<space><period>

In the error message "offset" would be 2147467264 (i.e. fractionally less than 2 Gb) if you had hit 2 Gb limit. The file descriptor "fd 448" seems very high - but I don't know what is normal on Linux. A suggestion: Progress opens every file in the database structure for every local user...

Maximum number of databases connection allowed? (Ignoring licence considerations). Webspeed makes remote connections. See promon/"shared resources". Maximum remote connections is value of "-Ma" multiplied by "-Mn". The value of "-n" must be higher than this derived figure because "-n"...

Resolved I've now had a good and comprehensive reply from Progress Corporation by voice and email. Registration for the Progress Knowledge Centre hasn't started yet. As you guys already knew, it was a temporary fault. ... methyl

Big Brother must have been watching. The "you do not have permission" messages when looking up obscure Progress Error Numbers has stopped. My #1450 message was indeed caused by a chronic memory leak under Windows NT. Topic closed. Even if I haven't had a reply to the request for permission...

Anybody managed to get a password the Progress Knowledgebase? I've had no reply to email requests for a password. We do have a valid contract.

I agree with Tom. Go big and forget about it. Using "promon" , "kmtune", and "glance" you can find out the important numbers. Find out how many semaphores each database is using with the "promon" hidden menu: R&D, 1 (status), 13 (shared resources). My highest "semaphores allocated" figure is...

Here's an old MSDOS technique to blank an open file which still works with W2K. Never tried this technique with Progress, so back up first! (Or you could install unix). By the way, the blank "echo" command mentioned above is an enquiry as to the current state of MSDOS "command echo" rather...

Not tried this with Progress 9. With Progress 8.3 the only option is method 3. Tried method 2 once and it ignored the structure file and created a single volume database!

There are many ways to get a short dump. A bad or empty primary index is one. Note that proutil dumps in primary index order. If you can take the database down, try a database analysis (proutil -C dbanalys) to get a basic check of the database and a definitive record count. Run an index check...

Remember that the units of "-B" are database blocks. Post does not state the database blocksize (try promon Database Status enquiry). If you have the usual 8k blocksize, a -B of 300,000 would try (and fail) to maintain 2.2 Gb of shared memory. Very large "-B" values can cause the system to...

10054 is a winsock error number for "Connection reset by peer". Common causes are: poor network connection, network firewall, or PC firewall.