List of Contributions

Stefan Wilfling

Contact Details

My Content

1 to 20 of 29 total

RE: Find currently executed/running sessions

Posted By Stefan Wilfling Tue January 23, 2024 07:55 AM
Found In Egroup: Informix \ view thread
Hi! In this case I can say, that alll "cond wait*" is "idle" for JDBC-Connections? ------------------------------ Kind Regards Stefan ------------------------------

RE: Find currently executed/running sessions

Posted By Stefan Wilfling Tue January 23, 2024 04:14 AM
Found In Egroup: Informix \ view thread
Hi! Thank, good Idea. I works good, but I get many "cond wait netnorm"-Sessions. ("cond wait netnorm" - description found I here) I think this are JDBC-Sessions, where the last (java.sql) Statement aren´t closed? ------------------------------ Kind Regards Stefan -------------------- ...

Find currently executed/running sessions

Posted By Stefan Wilfling Fri January 19, 2024 10:36 AM
Found In Egroup: Informix \ view thread
Hi! We have a select to get the currently running statements: SELECT syssqlstat.sqs_dbname ,ROUND (systcblst.cpu_time, 1) ,syssqlstat.sqs_statement ,systcblst.state ,systcblst.statedetail ,systcblst.tid ,systcblst.name ,sysopendb.odb_dbname ,syssessions.feprogram FROM sysmaster:syssessions ...

Details to "WARNING: Detected slow or failing DNS service response XX time(s)."

Posted By Stefan Wilfling Fri August 11, 2023 04:49 AM
Found In Egroup: Informix \ view thread
Hi! Does anyone have more detailed information on "WARNING: Detected slow or failing DNS service response XX time(s)." What is the threshhold for "slow"? Can I activate any logging, to get the slow DNS-Response (Windows)? What I currently now (or think to now) from the ...

RE: Technote on Log4j vulnerability in Informix

Posted By Stefan Wilfling Mon December 20, 2021 02:03 AM
Found In Egroup: Informix \ view thread
Hi! Be careful, because the solution (-Dlog4j2.formatMsgNoLookups=true) is out of date. Look at: https://logging.apache.org/log4j/2.x/: Without updating to log4j 2.17.0, it doesn´t help in all cases. ------------------------------ Kind Regards Stefan ------------------------------

RE: JDBC: Can´t store big Intervals

Posted By Stefan Wilfling Fri January 15, 2021 09:05 AM
Found In Egroup: Informix \ view thread
Hi! I hope so (this part of the code is about 20 years old). It worked good (but this was the first column with more than 3 digits). ------------------------------ Kind Regards Stefan ------------------------------

RE: JDBC: Can´t store big Intervals

Posted By Stefan Wilfling Fri January 15, 2021 09:03 AM
Found In Egroup: Informix \ view thread
Hi! Thanks for that. But this means for the general solution: Read the exact datatype-definition from database (before insert/update) When the value in some situations is greater than value XY, then I should use an other constructor. (There are many unknown combinations to check). ...

JDBC: Can´t store big Intervals

Posted By Stefan Wilfling Fri January 15, 2021 04:03 AM
Found In Egroup: Informix \ view thread
Hi! I have a problem with an interval field. Currently I have a field "INTERVAL HOUR(3) TO MINUTE". Our customer wants to store 2600 hours in this field (estimated time for a project). I changed the field to "INTERVAL HOUR(5) TO MINUTE" and thought, it´s done. But,when I try to ...

RE: JDBC driver download

Posted By Stefan Wilfling Fri September 25, 2020 01:18 AM
Found In Egroup: Informix \ view thread
Hi! The easiest way is to download it direct from mvnrepository: https://mvnrepository.com/artifact/com.ibm.informix/jdbc/4.50.4.1 ------------------------------ Kind Regards Stefan ------------------------------

Get Explain over JDBC-Connection

Posted By Stefan Wilfling Tue August 18, 2020 08:23 AM
Found In Egroup: Informix \ view thread
Hi! I try to get the explain-file over JDBC (because not all developers have access to the db-servers). Following commands: "SET EXPLAIN FILE TO '" + fileName + "' " "SET EXPLAIN OFF" "SELECT FILETOBLOB('" + fileName + "', 'server')" --Read the file as ResultSet ...

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

Posted By Stefan Wilfling Tue August 18, 2020 02:03 AM
Found In Egroup: Informix \ view thread
Hi! Some questions to this (because we also reach in near future the serial-end): a) What happens, when you reach the end of the positive Integer (2,147,483,647). Is the next serial value negative (-2,147,483,647)? Or b) Conversion from serial to serial8 Is this an in-place-alter ...

RE: informix@IP: Incorrect password or user informix@IP is not known on the database server.

Posted By Stefan Wilfling Fri June 05, 2020 10:52 AM
Found In Egroup: Informix \ view thread
Hi! How do you try to connect to the database server? dbaccess/jdbc/odbc? Have you tried to connect with "DOMAIN\informix"? ------------------------------ Kind Regards Stefan ------------------------------

Reading functional index from systables

Posted By Stefan Wilfling Mon May 11, 2020 01:19 PM
Found In Egroup: Informix \ view thread
Hi! I´m currently trying to read the information of an functional index from the systables. The only way I find out, was to use the indexkeyarray_out(sysindices.indexkeys) - Function. But I found no official documentation for this (only errors after upgrade). Only this page here: getting functional ...

RE: Select with Ignore-Case

Posted By Stefan Wilfling Fri May 08, 2020 03:20 AM
Found In Egroup: Informix \ view thread
Hi! >I wanted to make sure you realize that it is not the whole database that becomes case insensitive - only the columns of type NCHAR, NVARCHAR Thanks for the info. This could be also a solution. But you can only do this at database creation? We have some very big databases TBs and we can´t ...

RE: Select with Ignore-Case

Posted By Stefan Wilfling Thu May 07, 2020 11:59 AM
Found In Egroup: Informix \ view thread
Hi! >I don't understand why you think that you need a separate indexing function for every column that you want to index. Yes and this was my mistake! And I´m happy, that I was wrong. ;-) ------------------------------ Kind Regards Stefan ------------------------------

RE: Select with Ignore-Case

Posted By Stefan Wilfling Thu May 07, 2020 11:56 AM
Found In Egroup: Informix \ view thread
Hi! Thanks. That looks like a good solution. I changed the function to one "my-lower" and so we can always use the the same name. Index-Size One question to the size of the index: 796bytes is the maximum at 4k pages. Does this mean, that every entry in the index has 796bytes when I have ...

RE: Select with Ignore-Case

Posted By Stefan Wilfling Thu May 07, 2020 04:47 AM
Found In Egroup: Informix \ view thread
Hi! Let´s make an example: CREATE TABLE Persons ( LastName varchar(128,30), FirstName varchar(128,20), Address varchar(255), City char(50), info lvarchar(500), id serial ); When I want to lower-search for this 5 columns, I need the following functions: create function my_lower_varchar128_30( ...

Select with Ignore-Case

Posted By Stefan Wilfling Thu May 07, 2020 03:35 AM
Found In Egroup: Informix \ view thread
Hi! We often need Selects with ignore-Case (e.g. searching for a Name). So our solution is always a lower(column) in the query. This works fine, but this is always a database-killer at big tables. I know hat I can make a complete Case-Insensitive-Database, but that´s too much. Functional-Index ...

RE: Using IfxSmartTrigger on utf8 database

Posted By Stefan Wilfling Fri April 24, 2020 02:03 AM
Found In Egroup: Informix \ view thread
Hi! Now I tested with/without DB_LOCALE/CLIENT_LOCALE in the URL: Without DB_LOCALE the connect doesn´t work With/Without CLIENT_LOCALE I get the same result: Wrong encoding -> So I don´t need the CLIENT_LOCALE in the url. For my test that means: I only need the DB_LOCALE ...

RE: Using IfxSmartTrigger on utf8 database

Posted By Stefan Wilfling Thu April 23, 2020 12:35 PM
Found In Egroup: Informix \ view thread
Hi! Many Thanks. Now it works. There´s only one problem with the encoding: I get the wrong value for a String for special characters: I´ve updated the value to "üOö" and the Result at the String is "üO". I think this is double-encoded. But this is not so important for me, because I only ...