Recent content by Patrice Perrot

You could try to ignore them

Take care of LOB if you use the ulimit . Defect # OCTA-31889 : "Binary dump fails with errors (9201) and (14624) when ulimit hit on AIX." (Status : Ready To Develop ) when dumping a table with a Clob or Blob.

Hi Ron, Depending on your system , you will be able or not to use the following trick. I dump my "big" tables in a filesystem which use an "old" jfs ( limited to 2Gb) . So each time the dump file reach the 2Gb, it creates automatically a new dump file . So i am able to dump and load the same...

Hi George I am using this type of function where I can select the user and the "activity" (Lock, access ,read on table index or lob) I want to analyze . Each time the ativity of a user is above the threshold between Tx and Tx+1 (0.005 sec between them), I record its full call-satck (Tx and...

Hi Ron, So -- it all looks good except that it seems that sometimes (when index changes are involved) a re-index would be needed, and (I suppose) that means taking the system down (albeit for a fairly short period). => Idxactivate could be used to avoid the downtime. I have a question that...

Which user are you using to run 'grant select, update, insert,delete on PUB."' + _file._file-name + '" to ~"dario" ' This user should be allow to do it (like Sysprogress) Patrice

Hi The error message seems to be on the FIND FIRST darwin.cupbackconv . You can add a no-error on it to avoid the message.

If you like adventure, complexity (not too much) , ... you could have a look at Nectar's breakout session at the last PUG on Online Dump-load . (The ZERO downtime Production Dump and load - PUG Challenge) It will allow you to: - Dump-Load on line - Change your RPB for each table - have small...

Sorry, I do not think it will work... The backup will restore each records in its current block number (it does not eliminate the empty blocks) You will have the same number of blocks in each areas (even if you could use different extent size or number ). If you run an idxbuild you will lost...

If you enable the Audit Feature , you will probably have to increase the -L .

Hi I don't see the Audit-field in your xml. Patrice

format "->,>>>,>>9.99999"

totally agree with Tom and Rob

Hi Tom, They have to specify the -S XXXX to connect one of the broker If they specify "-S fbbj92-srv " for the 4GL connections and " -S fbbj92-srvsql " for the SQL connections , there is no mixed .

I think it could work without the "-ServerType" (to avoid the "warning") , you always specify the good "-S " for your connection so they will be done on the good dedicated broker. "-S fbbj92-srv " for the 4GL connections and " -S fbbj92-srvsql " for the SQL connections ,