List of Contributions

Andreas Seifert

CURSOR Software AG

Contact Details

CURSOR Software AG

My Content

1 to 17 of 17 total

RE: Mystery flag in syslogs/syslogfil

Posted By Andreas Seifert Wed October 18, 2023 03:56 AM
Found In Egroup: Informix \ view thread
Hello Jacob, syslogs is a view on syslogfil. The flags are also documented there. 0x4000 = Log file contains the last checkpoint written https://www.ibm.com/docs/en/informix-servers/14.10?topic=tables-syslogfil-table Regards Andreas ------------------------------ Andreas ...

RE: CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables

Posted By Andreas Seifert Mon October 11, 2021 02:10 AM
Found In Egroup: Informix \ view thread
Hello Saeid, I think the CDR buffer was not empty when stopping the instance for the update. The error looks like this one: https://www.ibm.com/support/pages/apar/IT38543 cdr cleanstart also seems to be the only way to fix the problem. Before the update you can check if the syscdr tables trg_send_stxn ...

RE: Problems with temporary dbspaces

Posted By Andreas Seifert Tue September 14, 2021 02:08 AM
Found In Egroup: Informix \ view thread
Hello, The documentation says that DBSPACETEMP must not be longer than 254 characters. Whether Informix then truncates or ignores the list is not documented. Try to bring the list under 254 characters. 'A list of dbspaces. The length of the list cannot exceed 254 characters.' If the statement ...

RE: Linux Informix ODBC driver

Posted By Andreas Seifert Fri September 10, 2021 04:23 AM
Found In Egroup: Informix \ view thread
Hello Mark, In my CSDK 4.10.FC15 and 4.50.FC5 the Informix ODBC drivers are present. I tested under 4.50.FC5 the ODBC connection with the cli demo and it works with the soctcp port. But on non rpm systems, according to machine notes, you have to install and initialize rpm, before installation. ...

RE: Tracing single session

Posted By Andreas Seifert Wed September 01, 2021 02:35 AM
Found In Egroup: Informix \ view thread
Hello Jason, If onmode -Y or task('onmode', 'Y', ..... ) does not produce any output (more precisely no file) it can also be due to error IT31262. If you execute the command several times with different filenames, Informix uses the 1st filename also for later calls with other sessions. The safest ...

RE: InformixHQ repository

Posted By Andreas Seifert Wed August 25, 2021 04:56 AM
Found In Egroup: Informix \ view thread
Hello Sh To, The repository is a normal Informix instance. Only the database needs to be created. InformixHQ creates the tables itself. My database runs fine with buffered log and DB_LOCALE en_us.819 ------------------------------ Andreas Seifert CURSOR Software AG http://www.admin-scout.com ...

RE: InformixHQ repository

Posted By Andreas Seifert Wed August 25, 2021 03:30 AM
Found In Egroup: Informix \ view thread
Hello, Yes, a repository DB is necessary. It is best to use your own Innovator-C instance for this. Then the productive instance is not stressed and it remains free. The Developer Edition reaches its session limit with 3 monitored instances. Whether this is okay from a licensing point of view is debatable. ...

RE: Informix Client CSDK Parameters

Posted By Andreas Seifert Tue July 27, 2021 06:07 AM
Found In Egroup: Informix \ view thread
Hi Miguel, A while ago we had a case with such an issue. As a result, a new environment variable was created that can be used to set the transfer buffer size for TEXT data types. For us, the variable was built into the .NET provider and ODBC. I don't know if it works for other connection types. ...

RE: IDS 14.10.FC5 on Ubuntu 20.04 - can't start shm listener

Posted By Andreas Seifert Wed March 03, 2021 07:18 AM
Found In Egroup: Informix \ view thread
The problem is a systemd problem. You can help yourself with rc.local or your own small systemd unit. ------------------------------ Andreas Seifert CURSOR Software AG http://www.admin-scout.com ------------------------------

RE: IDS 14.10.FC5 on Ubuntu 20.04 - can't start shm listener

Posted By Andreas Seifert Wed March 03, 2021 03:01 AM
Found In Egroup: Informix \ view thread
This is a problem of Ubuntu 20.04. After the kernel variables are set, kernel modules are still loaded which change settings again. The problem can be solved by calling a sysctl -p again in a later rc file, e.g. in rc.local if rc.local is active. You can read more about this here: https://bugs. ...

RE: 14.10.FC4W1 Windows installation problem

Posted By Andreas Seifert Mon October 19, 2020 04:12 AM
Found In Egroup: Informix \ view thread
Hello Hrvoje, For this I have a PMR - TS004159305. The problem is a bug IT33566. But there is a simple workaround. I have seen the problem with new installations of 14.10.FC4W1 on Windows 2019 on 2 different machines. Please check the folder %INFORMIXDIR%/lib If you found a directory called ...

RE: CREATE DATABASE and DB_LOCALE

Posted By Andreas Seifert Wed September 30, 2020 03:44 AM
Found In Egroup: Informix \ view thread
Hi Seb, Recently I found: execute function sysadmin:task('create database', ... ); https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.adref.doc/ids_sapi_127.htm Here you can explicitly specify all data like logmode, DBSpace and DB_LOCALE. There is no confusion with the set ...

RE: New RFE: Improvement in the check for high serial values

Posted By Andreas Seifert Wed August 19, 2020 01:47 AM
Found In Egroup: Informix \ view thread
Thanks Art, this is the easiest way to reset the values. But our Admin-Scout is a tool for other companies to monitor their Informix instances. This solution requires the necessary discipline from our customers to make these statements in addition. Unfortunately this cannot be done afterwards. I will ...

RE: New RFE: Improvement in the check for high serial values

Posted By Andreas Seifert Tue August 18, 2020 06:09 AM
Found In Egroup: Informix \ view thread
Hello Ben, Thanks for the tip. Testing the syscolumns seems to be the only way to solve the problem at the moment. The check is for our Informix administration tool Admin-Scout. There the check runs in a sensor in the sysadmin database and generate alarms when the limits are exceeded. Unfortunately ...

RE: New RFE: Improvement in the check for high serial values

Posted By Andreas Seifert Tue August 18, 2020 02:42 AM
Found In Egroup: Informix \ view thread
Hi, a) When you reach the maximum serial value, Informix starts at 1 again when you insert with 0 as value. If you have a unique index on the field, you will get an error on the first existing value: -239 Could not insert new row - duplicate value in a UNIQUE INDEX column otherwise there ...

RE: New RFE: Improvement in the check for high serial values

Posted By Andreas Seifert Mon August 17, 2020 05:14 AM
Found In Egroup: Informix \ view thread
You're right. It's good to read properly. I must have been reading "Informix server" here instead of "Information server". Unfortunately the platform cannot be changed anymore, so I had to create a new RFE and also changed the link in my first post. https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-383 ...

New RFE: Improvement in the check for high serial values

Posted By Andreas Seifert Fri August 14, 2020 10:26 AM
Found In Egroup: Informix \ view thread
Hi, I have raised new RFE: https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-383--> updated link It's hard to check if you reach the upper limit of your serials. This improvement would make it much easier and is certainly easy to implement. Please vote for this RFE to be realized. Thanks ...