Search results

If you have 8 Kb blocksize, "-B 80000" is about 625 Mb. i.e. more memory than you have fitted. With TRU64 unix the kernel parameter "ubc-maxpercent" defaults to 100% and "ubc-minpercent" defaults to 10% . Worth checking out if only to make sure that you have left at least 10% of memory for...

The external way would be to use proutil. Ours takes 20 mins to analyse 100 million records in a 27 Gb database. e.g. proutil -C tabanalys -db database_name.db > myanalysis.lst

Suitable general unix permissions for Progress ".r" are "-rw-r--r--" . Only the owner can update the ".r" code and everyone can read the ".r" code. Unix execute permission are only relevant to programs or scripts which can be executed by unix. For example the unix script "pro" and the...

Your Progress "PROTERMCAP" environment variable will point to a file with default name "$DLC/protermcap" which contains the mapping for all supported terminal types. Beware that lines starting ":tc=" point to the label of more mapping and that some keys have multiple names. In my "protermcap"...

Refreshing a test Progress 8 database 1) Do not overwrite <testdatabase.db> files - this file contains the file structure of the test database. Try unix "strings" on the file to see what I mean. Note that the structure in <testdatabase.st> is only ever read when you create the database and...

In addition to upping "ulimit" you usually have to change the filesystem to handle files larger than 2Gb. e.g. In HPUX "fsadm -F vxfs -o largefiles /dev/...". However the 2Gb limits in unix usually extend to backup software. Breaking the "probkup" files down to multiple files of size < 2Gb is...

Test database at Progress 8 The unix backup to tape is only valid if the database was down for the duration of the backup. A unix backup containing open database files is useless. A Progress 8 database pauses during "probkup" so i.m.h.o. you might as well stop the database before running...

BI Cluster size change successful Hi Krokodile We finally changed the 27 Gb Progress 8 database on Sunday to coincide with a schema change. The order or events was: 1) Shut down LIVEDB database 2) Stop AI on the LIVEDB rfutil LIVEDB -C aimage end Also stop auto-copying AI files to the DR...

Progress 8.3B and 8.3D. HPUX 11.00 and 11.11 . Multiple databases, multiple computers. Largest database 26 Gb with 8k block size; -B=80000 blocks; 3*APW; 1*BIW; 1*AIW. Checkpoint interval is down to < 10 seconds at peak times on largest database. I believe I need to increase BI cluster size...

Try the ksh builtin "whence". This tells you where the script would be found down the current path if you didn't type any of the full hierarchic name. This quick approach only works if you rely on $PATH to find the script. (To detect other common ways of calling the script you'd need to look...