List of Contributions

Ramon Rey

Contact Details

My Content

1 to 20 of 33 total
Posted By Ramon Rey Tue December 14, 2021 10:49 AM
Found In Egroup: Informix
\ view thread
Problem with OAT is that it is Flash based, and unless you install an older version of your browser, it wont be useful (or it would be partially useful). Ramon ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Fri November 12, 2021 11:16 AM
Found In Egroup: Informix
\ view thread
However, flags need to be unset from syslicenseinfo. I'm thinking that the database(s) would need to be exported, the instance to be reinitialized and the database imported back to get rid of any flags. ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Fri November 12, 2021 09:59 AM
Found In Egroup: Informix
\ view thread
Howdy! Wondering if anyone knows what are the licensing considerations for InformixHQ? I know people who are running 11.7, obviously no longer under support. with that in mind, and considering that HQ might work with 11.70, HQ could be extracted from, say, the IIUG development edition of IDS 14.10, ...
Posted By Ramon Rey Fri November 12, 2021 09:47 AM
Found In Egroup: Informix
\ view thread
I was afraid that was the case. If so, Informix needs to be uninstalled with the uninstall executable, then reinstalled. Thanks for the valuable info! Cheers! ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Thu November 11, 2021 02:14 PM
Found In Egroup: Informix
\ view thread
Hey Mike, Thanks for the checks. I'll run them to verify. Nonetheless, I understand that it is included in the IDS 12.10 Advanced Enterprise Edition and Advanced Developer Edition, but it is an optional add-on for the Informix Enterprise edition, least as per Carlton here: https://www.iiug.org/en/ ...
Posted By Ramon Rey Thu November 11, 2021 10:51 AM
Found In Egroup: Informix
\ view thread
Need to uninstall the Storage Optimization optional add-on feature on IDS 12.10, but I can't seem to find the documentation on how to do so any where in the IBM/HCL docs. Any one knows? Thanks in advance! ------------------------------ Ramon ------------------------------
Posted By Ramon Rey Thu August 05, 2021 12:11 PM
Found In Egroup: Informix
\ view thread
Amit, You did mention "the table names are in a loop", which means this repeats over and over until all the tables have been processed. The problem is that the unload file IS HARDCODED, and will be overwritten over and over until all tables are processed, and I'm not sure that's what you want. Perhaps ...
Posted By Ramon Rey Thu June 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 the ...
Posted By Ramon Rey Thu June 17, 2021 11:39 AM
Found In Egroup: Informix
\ view thread
Found it! Look for an additional email from iiug (IIUG-events ) with the actual link. R ------------------------------ Ramon Rey ------------------------------
Posted By Ramon Rey Thu June 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 Thu June 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 Fri June 11, 2021 09: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 Wed April 28, 2021 05: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 Tue April 20, 2021 03: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 Tue April 20, 2021 02: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 ...
Posted By Ramon Rey Tue April 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 Fri April 16, 2021 09: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 Wed March 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 ...
Posted By Ramon Rey Tue February 23, 2021 09: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 Fri February 05, 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 ------------------------------