List of Contributions

Ramon Rey

Contact Details

My Content

1 to 16 of 16 total
Posted By Ramon Rey Mar 10, 2021 11:28 AM
Found In Egroup: Informix
\ view thread
Hello Cherry, I'm in the middle of working an issue (unrelated) about InformixHQ, and the engineer seem to stress about us running Java 1.8, so I'd say you are in the right track. Also, do watch the min and max memory allocations for the JVM, Xms and Xmx. I'm still testing it in my environment, but setting ...
Posted By Ramon Rey Feb 23, 2021 9:54 AM
Found In Egroup: Informix
\ view thread
@John Lengyel , I know I might be asking for much, but how about better documentation on ALL the tables in the sysmaster? Since I'm feeling a bit needy, how about IBM publishing the OFFICIAL SMI queries for each onstat ​command? ^_^ Thanks! Ramon ------------------------------ Ramon Rey ------------ ...
Posted By Ramon Rey Feb 5, 2021 10:52 AM
Found In Egroup: Informix
\ view thread
Andreas, Yes, isql is being used in a remote host. I'll test it on the local host to the DB server with dbaccess and report back. And, it is another DB on the same DB server. R ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Feb 4, 2021 9:40 AM
Found In Egroup: Informix
\ view thread
Hello @Art Kagel , On one hand, the table did get created and populated. On the other, I don't like weird errors when running in production. Would I be safe to assume that if I create a logged table, I wouldn't get the error? EDIT: I did remove the raw from the create table , and it still returns the ...
Posted By Ramon Rey Feb 3, 2021 4:20 PM
Found In Egroup: Informix
\ view thread
Howdy! I ran a SQL script, where I created a raw table as select statement, did so using isql from a client server, and I got this weird message where it should have said table created: Unknown error message 966. Any clue as to what might have happened? Thanks in advance. Ramón DB Server: IDS 12.10.FC10AEE ...
Posted By Ramon Rey Nov 27, 2020 12:38 PM
Found In Egroup: Informix
\ view thread
Hello John, I think this page explains it pretty well, alas, it covers up to version 12.10: https://www.ibm.com/support/pages/ibm-informix-version-number My 0.02 Ramón ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Nov 16, 2020 9:24 AM
Found In Egroup: Informix
\ view thread
John, Syssessions is a view made off of the join of sysscblst and sysrstcb tables. The user host info comes from the sysscblst table. To my knowledge, there is no other place in the sysmaster that holds the hostname from the connecting session. As for sources outside the database, you could try chasing ...
Posted By Ramon Rey Nov 11, 2020 9:34 AM
Found In Egroup: Informix
\ view thread
Hello John: Not sure I understand your question. You want the hostname for a session with hostname = ::ffff:2? That seems to be a malformed address. Please clarify. Nonetheless, you can get the session and host along with other goodies from the syssessions in the sysmaster. https://www.ibm.com/suppo ...
Posted By Ramon Rey Nov 6, 2020 9:12 AM
Found In Egroup: Informix
\ view thread
Agreed. And should have happened in a PC/laptop on which the login user has admin rights. In my case, my laptop is a corporate laptop on which I don't have admin rights, which I believe to be the culprit for this issue. Something to keep in mind. Thanks again @Sheshnarayan Agrawal ! Cheers! R​ ----- ...
Posted By Ramon Rey Nov 5, 2020 11:28 AM
Found In Egroup: Informix
\ view thread
I did find and solve the issue!!! I needed to add INFORMIXDIR as a system environment variable!: - Close all setnet32 and Connect Test Demo. - Look for "edit the system environment variables". You'll need to be an admin or have an admin acct and password to do so. This will bring up the system properties ...
Posted By Ramon Rey Nov 5, 2020 10:51 AM
Found In Egroup: Informix
\ view thread
Also Shesh... when I click "apply and test connector" I get this other error! (please see attached screenshot). Once more, thanks for your help! R ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Nov 5, 2020 10:46 AM
Found In Egroup: Informix
\ view thread
Hello Shesh, I've gone to the ODBC Data Source Administration in Windows to create the DSN. I've done so, with the " Use Server Database Locale" box checked. Now I get this error (please see attached screenshot). Thank you so much for your help! R ------------------------------ Ramon Rey ------- ...
Posted By Ramon Rey Nov 5, 2020 9:08 AM
Found In Egroup: Informix
\ view thread
Hello Shesh, Thanks for the reply... unfortunately, it didn't work. R ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Nov 3, 2020 3:26 PM
Found In Egroup: Informix
\ view thread
Greetings and salutations! I'm trying to setup an ODBC connection from my Windows 10 client to a Linux Informix DB Server. Having setup the appropriate server and host information in the Setnet32 app I'm getting an "Unspecified System Error = -23101" when trying to get the database list from the server ...
Posted By Ramon Rey Oct 16, 2020 9:10 AM
Found In Egroup: Informix
\ view thread
Thanks Doug! That's great help! R ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Oct 15, 2020 12:16 PM
Found In Egroup: Informix
\ view thread
Howdy! Just wondering what would be the adequate specs (CPU, memory, disk, etc) for a RHEL host running InformixHQ exclusively. This instance will be keeping tabs on 25 Production servers initially, and we want to save 6 to 12 months worth of metrics in the repository. Planning to install IDS 14.10.FC4. ...