List of Contributions

Paul Watson

Oninit

Contact Details

My Content

1 to 20 of 50+ total
Posted By Paul Watson Jul 22, 2020 6:05 PM
Found In Egroup: Informix
\ view thread
AFAIK it will only report if there was something to do Cheers Paul
Posted By Paul Watson Jul 22, 2020 1:04 PM
Found In Egroup: Informix
\ view thread
Can you initialize the engine on the serve, outside of ifxlcone ?
Posted By Paul Watson Jul 22, 2020 12:32 PM
Found In Egroup: Informix
\ view thread
Run ipcs and see if there are any segments - they will start with 0x52. Onclean –ky should clean them out for you Cheers Paul
Posted By Paul Watson Jul 22, 2020 11:19 AM
Found In Egroup: Informix
\ view thread
Had a customer with 200GB+ rootdbs, nulling and recreating took forever My standard restore scripts use the onstat –d to make sure all the files are in place and correct size before the actual ontape starts. But a mute point with raw devices Remember with encryption you will need to remove the ...
Posted By Paul Watson Jul 22, 2020 10:48 AM
Found In Egroup: Informix
\ view thread
Select length(blob) from table Will give you the size of the actual blob
Posted By Paul Watson Jul 22, 2020 10:42 AM
Found In Egroup: Informix
\ view thread
As part of the process then switch FULL_DISK_INET to zero, something like .. Sed –I "s/^FULL_DISK_INIT[[:space:]].*/FULL_DISK_INIT 0/" $(INFORMIXDIR)/etc/onconfig.$(ONCONFIG) or something like dd if=/dev/zero of=<ROOTDBS> bs=2048 count=100 –o notrunc If rootdbs is large then null'ing out ...
Posted By Paul Watson Jul 22, 2020 10:09 AM
Found In Egroup: Informix
\ view thread
Not just a cut-and-paste issue for the "-d", not all "-" are not created equal
Posted By Paul Watson Jul 21, 2020 6:29 PM
Found In Egroup: Informix
\ view thread
idsdb00105650 ( IT32529 ) : With extended Checkpoint/Log reserved pages and encryption at rest with rootdbs encrypted, server may fail to come online
Posted By Paul Watson Jul 21, 2020 6:28 PM
Found In Egroup: Informix
\ view thread
My bad, the bug is logical corruption after restart with encryption and SSL active with server create with ifxclone
Posted By Paul Watson Jul 21, 2020 6:16 PM
Found In Egroup: Informix
\ view thread
And it doesn't work over an SSL link – forget the bug ID – might be fixed in 14.10.FC4 Cheers Paul
Posted By Paul Watson Jul 16, 2020 12:04 PM
Found In Egroup: Informix
\ view thread
Don't use the BOOLEAN datatype – nasty horrible slow datatype invented by Satan
Posted By Paul Watson Jul 16, 2020 9:08 AM
Found In Egroup: Informix
\ view thread
I think it has got tighter, but I have restored with minor version differences in the past.
Posted By Paul Watson Jul 15, 2020 6:56 PM
Found In Egroup: Informix
\ view thread
Have you thought about using archecker to access the tables. Again not sure of limitations of archecker in 11.50 Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit®️ is a registered trademark of Oninit LLC
Posted By Paul Watson Jul 15, 2020 6:50 PM
Found In Egroup: Informix
\ view thread
If they have the install for aix/solaris (or Linux) then ER the data over - subject to the ER limitations of 11.5 Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit®️ is a registered trademark of Oninit LLC
Posted By Paul Watson Jul 15, 2020 11:26 AM
Found In Egroup: Informix
\ view thread
There is no need to upgrade the 11.5 to use ER
Posted By Paul Watson Jul 15, 2020 8:58 AM
Found In Egroup: Informix
\ view thread
I think that is JL's code
Posted By Paul Watson Jul 13, 2020 10:29 AM
Found In Egroup: Informix
\ view thread
I've been using this for years #include <stdlib.h> #include "mi.h" void udr_srand(mi_integer seed, MI_FPARAM *fparam) ( (void) fparam; srand(seed); ) mi_integer udr_rand(MI_FPARAM *fparam) ( (void) fparam; return rand(); ) mi_integer udr_get ...
Posted By Paul Watson Jul 10, 2020 11:02 AM
Found In Egroup: Informix
\ view thread
Don't think that always works, or at least it hasn't in my experience [Best pic I have seen of you in many years :-P ]
Posted By Paul Watson Jul 10, 2020 10:31 AM
Found In Egroup: Informix
\ view thread
Throw an onclean –ky betwee the onmode –yuck (-ky or whatever you use) and on the onint –vw Cheers Paul