List of Contributions

SangGyu Jeong

Infrasoft

Contact Details

Infrasoft

My Content

1 to 20 of 50+ total
Posted By SangGyu Jeong Jul 21, 2020 12:18 PM
Found In Egroup: Informix
\ view thread
Hi Daniil, My customer also had an assert failture and 959/172 error as below when adding a column in version 12.10.FC11. [SQL] ALTER TABLE CONF_ONT_AID ADD CARDTYPE int; [Error Code] -959 & -172 -959 The current transaction has been rolled back due to an internal error. -172 ISAM error: Unexpected ...
Posted By SangGyu Jeong Jul 21, 2020 4:20 AM
Found In Egroup: Informix
\ view thread
Hi Gaurav, I found it. Thank you. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jul 20, 2020 10:14 AM
Found In Egroup: Informix
\ view thread
Hi Jessica, Thank you for sharing the webinar video. Where can I get the slides? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jul 16, 2020 9:09 AM
Found In Egroup: Informix
\ view thread
Using archecker is a great idea. I'll try it on the test server. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jul 15, 2020 6:14 PM
Found In Egroup: Informix
\ view thread
Thanks Eric, My customer is considering transitioning to AIX or Solaris because HP-UX will end support in 2025. Sadly, there are no plans to invest in Informix. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jul 15, 2020 6:01 PM
Found In Egroup: Informix
\ view thread
Thanks Paul. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jul 15, 2020 11:14 AM
Found In Egroup: Informix
\ view thread
I would like to know if it is possible to restore to Solaris or AIX with an onbar backup taken on Informix in an HP-UX environment. I answered my customer that it was impossible... Is it possible? The Informix version is 11.5 and the backup software is EMC Networker. In the document below, there is an ...
Posted By SangGyu Jeong Jul 14, 2020 11:22 AM
Found In Egroup: Informix
\ view thread
@Carlton Doe I want to make the most of the unknown or undocumented features. I'm looking forward to the webcast!​ ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jul 14, 2020 2:03 AM
Found In Egroup: Informix
\ view thread
Hi Gaurav, My customer is using version 12.10.FC6WE. They want to know how to avoid automatic index creation when certain queries are executed. I know that the autoindex feature cannot be controlled, but I just wanted to know if there are any related parameters. They'd better tune the query (or use ...
Posted By SangGyu Jeong Jul 13, 2020 10:54 PM
Found In Egroup: Informix
\ view thread
Hello Marc, Built-in function for generating random numbers are not provided, so you can write your own routine, but wouldn't it be better to install and use the DBMS_RANDOM package? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------- ...
Posted By SangGyu Jeong Jul 13, 2020 8:32 PM
Found In Egroup: Informix
\ view thread
Hi, I would like to know if there is a way to prevent autoindex from being constructed when executing a query. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jul 9, 2020 9:03 PM
Found In Egroup: Informix
\ view thread
Hello Gary, As you mentioned, it seems that the internal index created by the primary key or foreign key is stored in the database's primary dbspace. I think it is better to create a pk or fk index by specifying the dbspace of the desired pagesize, and specify the index name in the constraint. -- creating ...
Posted By SangGyu Jeong Jul 9, 2020 7:49 PM
Found In Egroup: Informix
\ view thread
Hi Snorri, A little explanation can be found in the onstat -g cfg full option. [informix@db2 ids1410fc4w1]$ onstat -g cfg full MSG_DATE IBM Informix Dynamic Server Version 14.10.FC4W1DE -- On-Line -- Up 15 days 10:17:52 -- 2631308 Kbytes Configuration Parameter Info id name type maxlen units rsvd ...
Posted By SangGyu Jeong Jul 9, 2020 9:43 AM
Found In Egroup: Informix
\ view thread
As Paul mentioned, you can find a description of USE_DTENV in the link. I've seen similar question from another community, so I remember that environment variable. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.glsug.doc/ids_gug_085.htm ------------------------------ SangGyu Jeong ...
Posted By SangGyu Jeong Jul 9, 2020 7:32 AM
Found In Egroup: Informix
\ view thread
Hello Marc, You can do this by setting the USE_DTENV and GL_DATETIME environment variables. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.glsug.doc/ids_gug_085.htm [informix@db2 ids1410fc3]$ onstat - IBM Informix Dynamic Server Version 14.10.FC3IE -- On-Line -- Up 15 days 21:10:35 ...
Posted By SangGyu Jeong Jul 1, 2020 8:40 AM
Found In Egroup: Informix
\ view thread
Anyway, the set explain statement, and ifx_explain and bson_explain functions are not executed normally, so it seems that the Informix server will need to be restarted soon. Wouldn't that error occur after restarting the Informix server? ------------------------------ SangGyu Jeong Software Engineer ...
Posted By SangGyu Jeong Jul 1, 2020 8:34 AM
Found In Egroup: Informix
\ view thread
Hi Art, Thank you for answer. The set explain statements in the screenshot are executed by the informix user on the DB server. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Jul 1, 2020 4:33 AM
Found In Egroup: Informix
\ view thread
Hi All, My customer is using Informix 12.10.FC6WE and when they try set explain on statement they get 534 error. Below is a screenshot that reproduces the error. The set explain statement worked fine a few weeks ago. A customer has been checking query plans with InformixHQ recently, will calling ...
Posted By SangGyu Jeong Jun 29, 2020 11:00 PM
Found In Egroup: Informix
\ view thread
Thanks you Art, In the machine notes for Informix 11.50.xC8, AIX 7.1 is mentioned. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.50.0/com.ibm.relnotes.doc/ifx_1150xc8/mach/ids_machine_notes_11.50.aix64.html So, I would like to advise my customer to install 11.50.FC8 or higher. ----------- ...
Posted By SangGyu Jeong Jun 29, 2020 10:44 PM
Found In Egroup: Informix
\ view thread
Thank you Paul. Of course, the customer and I know that this version of Informix is not supported by IBM. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------