List of Contributions

Paul Watson

Oninit

Contact Details

My Content

1 to 20 of 50+ total
Posted By Paul Watson Mon March 04, 2024 07:45 AM
Found In Egroup: Informix
\ view thread
If the VP is mandatory then you should get an error indicating that if it can't be found. On 3/4/2024 2:30 AM, Dennis Melnikov via IBM TechXchange Community wrote: An idsxmlvp virtual processor is declared to be created automatically the first time an XML function is used. However, there is no idsxmlvp ...
Posted By Paul Watson Fri March 01, 2024 10:38 AM
Found In Egroup: Informix
\ view thread
Just a memory issue, if it is repeatable I would separate into separate SQLs (if possible). You are not going to get IBM to fix this, but might be a known stack Cheers Paul On 3/1/2024 9:32 AM, Dennis Melnikov via IBM TechXchange Community wrote: Hi, IBM Informix Dynamic Server Version 11.70.FC5XE ...
Posted By Paul Watson Thu February 22, 2024 11:19 AM
Found In Egroup: Informix
\ view thread
Should of added, I tend to avoid very large syncs during busy times CheersPaul Paul WatsonOninit LLC +1-913-387-7529www.oninit.comOninit®️ is a registered trademark of Oninit LLC ...
Posted By Paul Watson Thu February 22, 2024 11:14 AM
Found In Egroup: Informix
\ view thread
I have never had a issue with using sync on live systems and getting trans lost. I have always assume the 'live' transactions are delayed but..... never looked Cheers Oauk On 2/22/2024 9:52 AM, Milan Rafaj via IBM TechXchange Community wrote: Hello, I need to clarify how to use cdr sync cdr ...
Posted By Paul Watson Mon February 05, 2024 04:36 PM
Found In Egroup: Informix
\ view thread
They are not in the schema ? On 2/5/2024 3:33 PM, Jeffrey Filippi via IBM TechXchange Community wrote: We get these messages in the online.logs daily. We want to remove them, but I cannot find them. One of the issues is that in the directory... -posted to the "Informix" group
Posted By Paul Watson Fri January 26, 2024 10:56 AM
Found In Egroup: Informix
\ view thread
Or select DBINFO('onedb' 'full') for the OneDB version On 1/25/2024 7:16 PM, Art Kagel via IBM TechXchange Community wrote: You can check the version equivalence between OneDB and IDS by querying DBINFO('version','full') It reports the Informix level versions from...
Posted By Paul Watson Wed January 24, 2024 11:43 AM
Found In Egroup: Informix
\ view thread
Have you tried installing the libcrypt compatibility layer ? That has libcrypt.so.1 as a separate library On 1/24/2024 10:37 AM, Sebastien FLAESCH via IBM TechXchange Community wrote: Thanks for your answers! I would definitively not suggest our customers to create a symbolic link libcrypt.so.2 ...
Posted By Paul Watson Wed January 17, 2024 03:46 PM
Found In Egroup: Informix
\ view thread
Not in DBINFO ? On 1/17/2024 2:43 PM, Jared Heath via IBM TechXchange Community wrote: I've spend a couple days searching the documentation and I can't find how to get the equivalent of sqlca.sqlerrd[2] out of .NET Core Informix...
Posted By Paul Watson Wed December 20, 2023 09:04 AM
Found In Egroup: Informix
\ view thread
you have open ODBC isql on the path before the informix isql - first guess anyway Cheers Paul On 12/20/2023 7:57 AM, Jacob Salomon via IBM TechXchange Community wrote: Thanks, Jan. Dbaccess comes with the engine anyway. But as a curiosity I tried to run isql and got the message to run: ...
Posted By Paul Watson Thu November 02, 2023 05:09 AM
Found In Egroup: Informix
\ view thread
Query plan would be useful On 11/2/2023 4:06 AM, Indika Jinadasa via IBM TechXchange Community wrote: Dear Friends, We are using IDS 14X and the below SQL query is taking high query cost even if it perform INDEX path. Could you pl help us to...
Posted By Paul Watson Mon October 23, 2023 11:17 AM
Found In Egroup: Informix
\ view thread
The Blade Mangler should remove the blade completely but I am not aware of any method to remove the blade management tables other than just a plain drop -- Paul Watson Oninit www.oninit.com Tel: +1 913 364 0360 Cell: +1 913 387 7529 Oninit?? is a registered trademark of Oninit LLC If you want to improve, ...
Posted By Paul Watson Tue October 17, 2023 01:18 PM
Found In Egroup: Informix
\ view thread
Maybe something do with the onmode -p -x cpu functionality ? Pure guess Cheers Paul On 10/17/2023 12:15 PM, Doug Lawry via IBM TechXchange Community wrote: If you run "kill -1" (SIGHUP or "hangup") on an "oninit" process, it writes a small assert file and full stack trace for that VP, but ...
Posted By Paul Watson Thu October 12, 2023 02:25 PM
Found In Egroup: Informix
\ view thread
Documented 'feature' - https://www.ibm.com/docs/en/informix-servers/12.10?topic=expressions-coalesce-function Cannot be a host variable or a BYTE or TEXT object On 10/12/2023 1:09 PM, Sebastien FLAESCH via IBM TechXchange Community wrote: Hello! Seems that the nice COALESCE() SQL function ...
Posted By Paul Watson Sun September 03, 2023 06:23 AM
Found In Egroup: Informix
\ view thread
It's just an application so should just work, I have not compiled it with OneDB CSDK but with Informix CSDK it will connect to OneDB CheersPaul Paul WatsonOninit LLC +1-913-387-7529www.oninit.comOninit®️ is a registered trademark of Oninit LLC ...
Posted By Paul Watson Fri August 25, 2023 02:53 PM
Found In Egroup: Informix
\ view thread
The should be on the IIUG site at some point. As the moment I am not aware on 14.10.latest and OneDB 2.latest having any functional differences. The client layers are different though. If you don't want to compile into the engine you could use 4gl and the Aubit compiler ? On 8/25/2023 ...
Posted By Paul Watson Tue August 15, 2023 12:28 PM
Found In Egroup: Informix
\ view thread
Create an SPL that returns f1[1,10] and use that in the index definition On 8/15/2023 11:25 AM, Snorri Bergmann via IBM TechXchange Community wrote: Greetings. I'm running Version 14.10.FC9W1 on Linux. I tried this for fun: create table t1 (f1 char(100)); create index my_ix on t1 (f1[1,10]... ...
Posted By Paul Watson Tue August 15, 2023 12:23 PM
Found In Egroup: Informix
\ view thread
under VMS I thought was 512bytes at the underlying level but presented as 8K On 8/15/2023 11:12 AM, Jacob Salomon via IBM TechXchange Community wrote: Paul said:> With XPS you can specify the PAGESIZE in the ONCONFIG, the AIX XPS system I look after is 8K Hi Paul. That's actually a pretty cool... ...
Posted By Paul Watson Tue August 15, 2023 09:16 AM
Found In Egroup: Informix
\ view thread
With XPS you can specify the PAGESIZE in the ONCONFIG, the AIX XPS system I look after is 8K On 8/14/2023 6:46 PM, Art Kagel via IBM TechXchange Community wrote: Jacob: All the Informix servers I have encountered in the past 15 years or so have all had a default page size of 2K. I recall that ...
Posted By Paul Watson Fri August 11, 2023 09:14 AM
Found In Egroup: Informix
\ view thread
slow_DNS is reported when looking at the hostname takes more time than the allotted time in milliseconds to get the info. By default REPORT_SLOW_DNS_THRESHOLD=200 You can change this value by updating the entry in onconfig. Everytime a hostname lookup takes more than 200 milliseconds it adds 1 to ...
Posted By Paul Watson Wed August 09, 2023 03:27 PM
Found In Egroup: Informix
\ view thread
dbs_partn is mutex on the partition number of the database tblspace. It is the same that partition number of the tables (tblspaces). On 8/9/2023 2:19 PM, Dennis Melnikov via IBM TechXchange Community wrote: Hi, IDS 11.70.FC5XE, AIX 7.1 Sometimes we encounter a situation when many sessions are ...