List of Contributions

Ramon Rey

Contact Details

My Content

1 to 20 of 26 total
Posted By Ramon Rey Jun 17, 2021 11:59 AM
Found In Egroup: Informix
\ view thread
In my case and specific version (IDS 12.10.FC12), if I follow the sequence, and do an update on a row afterwards, the bug ( APAR IT36873 - https://www.ibm.com/support/pages/apar/IT36873) would force me to do a hard reboot of the machine, as the box would become completely frozen within 30 seconds of ...
Posted By Ramon Rey Jun 17, 2021 11:39 AM
Found In Egroup: Informix
\ view thread
Found it! Look for an additional email from iiug (IIUG-events <IIUG-events@iiug.org>) with the actual link. R ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Jun 17, 2021 11:31 AM
Found In Egroup: Informix
\ view thread
Mike, There is a link to register, then it redirects you to the iiug website to complete registration, which I've done. After that I never received an email with a link. R ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Jun 17, 2021 11:17 AM
Found In Egroup: Informix
\ view thread
Hello all, I was wondering if any one has any way to communicate with Cindy Lichtenauer, and let her know that her invite to the Latest enhancements in IBM Informix 14.10xC6 Webcast has no links in it. Same for the upcoming kernel, ER and SQL features, and IHQ and Backup from RS secondary webcasts. ...
Posted By Ramon Rey Jun 11, 2021 9:12 AM
Found In Egroup: Informix
\ view thread
Yes, that is the correct sequence! I would add to resolve the In-Place Alter, as, depending on your version, you might run into APAR IT36873: in-place alter table can lead to a flood of page out-of-seq errors in online.log when using CDC, which will freeze your system forcing for a hard reboot. I found ...
Posted By Ramon Rey Apr 28, 2021 5:31 PM
Found In Egroup: Informix
\ view thread
Sergio, Install the latest and greatest (which I think is 14.10.FC5, that comes with HQ 1.4), make a tar file of the $INFORMIXDIR/hq directory, and extract it in the servers you want to monitor. Remember, HQ comes standard with 14.10 and above, but you can monitor 12.10 and above with support from IBM/HCL. ...
Posted By Ramon Rey Apr 20, 2021 3:12 PM
Found In Egroup: Informix
\ view thread
Why oh why didn't occur to me to check in the sysmaster? ^_^ Thanks Art! R ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Apr 20, 2021 2:28 PM
Found In Egroup: Informix
\ view thread
Thanks Art and Paul, What I actually need to find is: Has a dbspace had its "sp_sizes modified", as per "EXECUTE FUNCTION task('modify dbspace sp_sizes', '3', '60000', '10000');"? If so, what were the create, extend and max extend sizes and/or percentages set to? I figure since the "EXECUTE ...
Posted By Ramon Rey Apr 20, 2021 11:46 AM
Found In Egroup: Informix
\ view thread
Howdy y'all! I understand what needs to be done to do make a dbspace auto extendable: Mark the chunk(s) extendable: DATABASE sysadmin; EXECUTE FUNCTION task("modify chunk extendable", "12");​​ Set the SP_THRESHOLD onconfig setting. Change how often the mon_low_storage task runs: DATABASE ...
Posted By Ramon Rey Apr 16, 2021 9:25 AM
Found In Egroup: Informix
\ view thread
Yes. Just copy the $INFORMIXDIR/hq directory from an IDS 14.10 installation to your 12.10 installation. I'd suggest 14.10.FC5 as it has the latest HQ release (1.4). As I was told by IBM support, HQ version 1.8 is coming with 14.10.FC6. Do watch for free/available memory. R ------------------------------ ...
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 ...