List of Contributions

SangGyu Jeong

Infrasoft

Contact Details

Infrasoft

My Content

1 to 20 of 50+ total
Posted By SangGyu Jeong Apr 9, 2020 9:57 PM
Found In Egroup: Informix
\ view thread
@Sergio Peres I've run a routine based on your code. I hope the results below will help. /work2/INFORMIX/1210FC13/skjeong]cat myproc1.sql DROP PROCEDURE MYPROC1(); CREATE PROCEDURE MYPROC1() DEFINE tabela VARCHAR(20); DEFINE comando VARCHAR(100); DEFINE string VARCHAR(100); DEFINE airc_dir VARCHAR(100); ...
Posted By SangGyu Jeong Apr 9, 2020 2:08 AM
Found In Egroup: Informix
\ view thread
Hello ABeMie, MTK is no longer provided by IBM. MTK has been replaced by IDMT and Database Conversion Workbench, but Informix is not supported. In fact, there are a number of alternative migration tools, such as Linked Server, IBM CDC, Oracle Gateway, and DG4ODBC. If you need version 2.0.5.1 that I have, ...
Posted By SangGyu Jeong Apr 8, 2020 9:43 PM
Found In Egroup: Informix
\ view thread
Hi Sergio, It seems that using UNLOAD or OUTPUT in the routine causes an error. So I searched on Google and used the external table as below. https://stackoverflow.com/questions/31992388/using-an-unload-statement-in-an-informix-stored-procedure Perhaps soon someone else will come up with another great ...
Posted By SangGyu Jeong Apr 7, 2020 9:58 PM
Found In Egroup: Db2 On Premise and Cloud
\ view thread
Hi Rinni, I think it's better to ask the Optim forums or IBM support for help here. I've had some experience with Optim, but I don't know what caused this. There was an article I asked about the same error a long time ago, but there is no solution. https://www.ibm.com/mysupport/s/question/0D50z00006 ...
Posted By SangGyu Jeong Apr 6, 2020 7:31 AM
Found In Egroup: Informix
\ view thread
@Neville Monteiro ​ When the 25572 error message occurs, the oserr number is displayed in the online log file as shown below. I think it might help to guess the cause based on the error number. 13:00:00 listener-thread: err = -25572: oserr = 98: errstr = : Network driver cannot bind a name to the port. ...
Posted By SangGyu Jeong Apr 5, 2020 10:18 PM
Found In Egroup: Db2 On Premise and Cloud
\ view thread
Since there is no view in db2 that shows detailed information about the predicate, I think the problem should be approached by checking many table scans with the mon_get_table function and finding a query that uses the table. And even if it is possible to create an index based on predicate, I think you ...
Posted By SangGyu Jeong Apr 5, 2020 11:24 AM
Found In Egroup: Informix
\ view thread
Hi Neville, What is the OS error in the -25572 error? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Apr 4, 2020 10:57 PM
Found In Egroup: Db2 On Premise and Cloud
\ view thread
@Anurag Agrawal Db2 does not provide a view like sys.col_usage$. To create a proper index, why not use the MON_GET functions to track queries that cause many table scans? The link below will be a good reference. https://datageek.blog/en/2012/11/28/db2-table-scans/​ ------------------------------ SangGyu ...
Posted By SangGyu Jeong Apr 3, 2020 10:38 AM
Found In Egroup: Informix
\ view thread
It is not a document directly related to this issue, but according to the documents below, the 1041 and 1042 options are only recognized by the DataDirect driver. http://media.datadirect.com/download/docs/slnk/6_0/distgde/call.html https://www.ibm.com/support/pages/apar/JR29115 ------------------------------ ...
Posted By SangGyu Jeong Apr 3, 2020 8:37 AM
Found In Egroup: Informix
\ view thread
Hi Ramon, There seems to be no problem with the contents of the odbc.ini file.. Was this a setting that worked well in the past? How about using the odbc driver provided by mstr? Perhaps the odbc driver is in the path /opt/mstr/MicroStrategy/install/lib. Below are the documents I found in the mstr community. ...
Posted By SangGyu Jeong Apr 1, 2020 8:31 PM
Found In Egroup: Informix
\ view thread
@Mark Collins I'm not sure if the Continuing Support Offering option is still available, but if so, I think it would be possible to contact IBM for this issue. https://www.ibm.com/support/pages/informix-continuing-support-offering ​ ------------------------------ SangGyu Jeong Software Engineer Infrasoft ...
Posted By SangGyu Jeong Apr 1, 2020 10:03 AM
Found In Egroup: Informix
\ view thread
@Boycho Velkov ​ There was a phrase in the machine notes about the Mapped user feature limitation! From the machine notes in 11.70, the contents are listed, but so far, I have never had any doubts that it won't work on Windows. ------------------------------ SangGyu Jeong Software Engineer Infrasoft ...
Posted By SangGyu Jeong Apr 1, 2020 4:01 AM
Found In Egroup: Informix
\ view thread
Hi David, Since the first article on this forum is less than a year old, I think it's rare that the search results will be helpful when compared to the previous iiug forum. For discussions about using zfs, please read the previous forum article and Art's blog post, or I'm sure you'll get a great answer ...
Posted By SangGyu Jeong Mar 31, 2020 12:34 PM
Found In Egroup: Informix
\ view thread
Hi Martin. Thank you for sharing your test results. It is strange to display the /etc directory in the error 26729 message even in the Windows environment. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Mar 31, 2020 12:20 PM
Found In Egroup: Informix
\ view thread
The upgrade from version 11.50 to version 14.10 may have quite a lot to consider. I hope you have a smooth upgrade! ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Posted By SangGyu Jeong Mar 31, 2020 11:54 AM
Found In Egroup: Informix
\ view thread
@iliyan iliev The 'informix' user is automatically created when Informix is installed. In the Windows environment, users cannot be created using the CREATE USER statement, so the user account of the OS must be used. ​​ ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, ...
Posted By SangGyu Jeong Mar 31, 2020 9:46 AM
Found In Egroup: Informix
\ view thread
Hi iliyan, Did you create and use a user in Informix in the Windows environment? I thought the usermapping feature would work on Windows so far, but if you look at the 'Internal users' page in the knowledge center, there is no explanation on how to set it up on Windows. https://www.ibm.com/support/k ...
Posted By SangGyu Jeong Mar 30, 2020 9:12 PM
Found In Egroup: Informix
\ view thread
Hi Mark, I have tested doing ontape backup using local encryption key. When creating a local encryption key, I referenced the article below. https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.bar.doc/ids_bar_local_encryption_key.htm The results show that the encrypted backup file is compressed ...
Posted By SangGyu Jeong Mar 26, 2020 10:45 PM
Found In Egroup: Informix
\ view thread
Hi Jessica, As I tested on Red Hat 8.1, if ncurses6 is already installed, the bulidsmi script works fine after creating a symbolic link for ncurses5 as shown below. ln -s /usr/lib64/libncurses.so.6 /usr/lib64/libncurses.so.5 ln -s /usr/lib64/libtinfo.so.6 /usr/lib64/libtinfo.so.5 However, it is recommended ...
Posted By SangGyu Jeong Mar 26, 2020 8:40 PM
Found In Egroup: Informix
\ view thread
Hi Jacob, I stumbled across iiug presentations in 2019 and came across On versions 14.10.xC2 and 12.10.xc14 and above, onstat -g ppf shows the name corresponding to the "low" partition number. Is this what you are looking for? I don't know how to get this information under version 12.10.xC14. IBM Informix ...