List of Contributions

Sh To

Contact Details

My Content

1 to 20 of 50+ total

RE: HDR to Standard

Posted By Sh To Sun April 21, 2024 12:12 AM
Found In Egroup: Informix \ view thread
Hello everyone and thanks for your help ------------------------------ Samuel To ------------------------------

HDR to Standard

Posted By Sh To Tue April 16, 2024 01:16 AM
Found In Egroup: Informix \ view thread
Hello, We have an HA array with primary, HDR, RSS We'd like to disconnect the HDR and make it standard But depends on this doc the condition is: Database server type can be changed from secondary to standard only if HDR is turned off on the secondary database server. HDR is turned off when either ...

RE: Changing RSS IP

Posted By Sh To Sun January 14, 2024 12:43 AM
Found In Egroup: Informix \ view thread
OK Thanks ------------------------------ Samuel To ------------------------------

RE: Changing RSS IP

Posted By Sh To Wed January 10, 2024 07:38 AM
Found In Egroup: Informix \ view thread
Thanks ------------------------------ Samuel To ------------------------------

RE: Changing RSS IP

Posted By Sh To Wed January 10, 2024 07:22 AM
Found In Egroup: Informix \ view thread
Hi, We don't use DNS but /etc/hosts that could work ? ------------------------------ Samuel To ------------------------------

Changing RSS IP

Posted By Sh To Wed January 10, 2024 12:35 AM
Found In Egroup: Informix \ view thread
Hello We need to change IP on our RSS server. Is it possible to reconnect with the main server without resetting informix (main server) ? Thanks ------------------------------ Samuel ------------------------------

RE: Long transaction aborted

Posted By Sh To Mon December 11, 2023 08:40 AM
Found In Egroup: Informix \ view thread
BUT, normally an alter table statement, just appending columns should work in-place without running into a long transaction, because only the schema is changed and the data is left untouched. alter table scan_ans add times LVARCHAR(300); You have any idea why apparently this runs into ...

RE: Long transaction aborted

Posted By Sh To Mon December 11, 2023 08:16 AM
Found In Egroup: Informix \ view thread
OK Also In this way I'll need to re-initiate the HDR/RSS servers isn't it ? ------------------------------ Samuel To ------------------------------

RE: Long transaction aborted

Posted By Sh To Mon December 11, 2023 08:14 AM
Found In Egroup: Informix \ view thread
So maybe there is another problem The dev guy add the field without populating the new field alter table scan_ans add times LVARCHAR(300); I added 50 LL (200 > 250) and i saw that they are filled immediately after running the statement ------------------------------ Samuel ...

Long transaction aborted

Posted By Sh To Mon December 11, 2023 07:34 AM
Found In Egroup: Informix \ view thread
Hello, Adding a field on a 24 millions rows table fails on [Code: -458, SQL State: IX000] Long transaction aborted. [Script position: 1108 - 1110] [Code: -12204, SQL State: IX000] RSAM error: Long transaction detected. [Script position: 1108 - 1110] I could add logical ...

RE: backup fail - 14.10.FC4W1

Posted By Sh To Thu November 09, 2023 06:59 AM
Found In Egroup: Informix \ view thread
Fine, thanks ------------------------------ Samuel To ------------------------------

RE: backup fail - 14.10.FC4W1

Posted By Sh To Thu November 09, 2023 04:08 AM
Found In Egroup: Informix \ view thread
OK Thanks ------------------------------ Samuel To ------------------------------

RE: backup fail - 14.10.FC4W1

Posted By Sh To Thu November 09, 2023 03:40 AM
Found In Egroup: Informix \ view thread
Hello Scot I'll restart informix. But I still have a question, could I know which ones to kill " If you have any from users that are not logged in or running processes, kill those off first. " When the owners are root or informix ? Thanks att1 > ...

backup fail - 14.10.FC4W1

Posted By Sh To Thu November 09, 2023 01:44 AM
Found In Egroup: Informix \ view thread
Hello, Our backup stops to work (dev environment) RHEL 7.9 informix 14.10.FC4W1 There was no change before the backup failed no restart (440 days up) I if try manually ontape -s -L 0 >> $HOME/ontape.log 2>&1 this is what i get: ontape.log ...

RE: Client configuration - SSL connection to informix

Posted By Sh To Mon March 13, 2023 02:16 AM
Found In Egroup: Informix \ view thread
Thanks ------------------------------ Samuel To ------------------------------

Client configuration - SSL connection to informix

Posted By Sh To Sun March 12, 2023 03:11 AM
Found In Egroup: Informix \ view thread
Hello, I know that it s not a question for this forum (it s not an Informix problem), but does anyone have a link to a documentation that explains how to connect to Informix on an SSL port from: from a Linux client with JDBC and a windows client ODBC ...

RE: SSL connection to IDS

Posted By Sh To Wed March 01, 2023 07:06 AM
Found In Egroup: Informix \ view thread
Hello, That is why one would encrypt the connections between the primary and secondary. With SSL like this ? https://www.ibm.com/docs/en/informix-servers/12.10?topic=protocol-configuring-server-instance-secure-sockets-layer-connections ------------------------------ ...

SSL connection to IDS

Posted By Sh To Wed March 01, 2023 02:32 AM
Found In Egroup: Informix \ view thread
Hello, I see that there are two protocols for SSL connection https://www.ibm.com/docs/en/informix-servers/12.10?topic=protocol-configuring-server-instance-secure-sockets-layer-connections I suppose that "drsocssl protocol for DRDA connections" is for HDR,RSS,… Are there any easily ...

HA - Switch between Primary and RSS

Posted By Sh To Mon August 22, 2022 08:01 AM
Found In Egroup: Informix \ view thread
Hello, Is it possible to switch HA types between Primary and RSS as we can to do with Primary and HDR We have a set of three servers (without Connection Manager) Primary / HDR / RSS (on remote site) And we'd like to do this (for testing purpose): Primary -> RSS ...

RE: Bringing down and up a HA cluster

Posted By Sh To Wed August 17, 2022 01:19 AM
Found In Egroup: Informix \ view thread
thank you all ------------------------------ Samuel To ------------------------------