Threads from 2017
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Re: Syntax error on Informix server 10.00FC1 [....
Love you too! j. > On Dec 29, 2017, at 4:29 AM, Spokey Wheeler <spokey.wheeler@gmail.com> wrote: > > Ooh, bitch! > > Sent from my iPad > >> On 28 Dec 2017, at 22:29, Jack Parker <jack.parker4@verizon.net> wrote: >> >> Are you saying that Spokey still is? ;-) >> >> j. >> >>> On …
Re: Syntax error on Informix server 10.00FC1 [....
Ooh, bitch! Sent from my iPad > On 28 Dec 2017, at 22:29, Jack Parker <jack.parker4@verizon.net> wrote: > > Are you saying that Spokey still is? ;-) > > j. > >> On Dec 28, 2017, at 5:24 PM, Jonathan Leffler <jonathan.leffler@gmail.com> > wrote: >> >> No. >> >> 'Have you tried U…
Re: Syntax error on Informix server 10.00FC1 [....
No, its an old joke Sent from my iPad > On 28 Dec 2017, at 21:17, Henri Moukouri <h.moukouri@moukouri.net> wrote: > > Do you think it has anything to do with that ? > Sent from Samsung tablet > -------- Message d'origine --------De : Spokey Wheeler > <spokey.wheeler@gmail.com> …
Re: Syntax error on Informix server 10.00FC1 [....
Of course, I know it has nothing to do with the issue. Hence my reply "Do you think ...", for mails that only focus on jokes ! On 12/28/2017 11:24:11 PM, "Jonathan Leffler" <jonathan.leffler@gmail.com> wrote: >No. > >'Have you tried UPDATE STATISTICS?' is an old joke on the Inf…
Re: Syntax error on Informix server 10.00FC1 [....
Are you saying that Spokey still is? ;-) j. > On Dec 28, 2017, at 5:24 PM, Jonathan Leffler <jonathan.leffler@gmail.com> wrote: > > No. > > 'Have you tried UPDATE STATISTICS?' is an old joke on the Informix mailing > lists. > It used to be valid advice/question for older server…
Re: Syntax error on Informix server 10.00FC1 [....
No. 'Have you tried UPDATE STATISTICS?' is an old joke on the Informix mailing lists. It used to be valid advice/question for older servers, and was often given as a jocular response to questions that were unintelligible. As advice, it is less relevant these days. On Thu, Dec 2…
Re: Syntax error on Informix server 10.00FC1 [....
Do you think it has anything to do with that ? Sent from Samsung tablet -------- Message d'origine --------De : Spokey Wheeler <spokey.wheeler@gmail.com> Date : 28/12/2017 21:34 (GMT+01:00) À : ids@iiug.org Objet : Re: Syntax error on Informix server 10.00FC1 [.... [40433] Have y…
Re: Syntax error on Informix server 10.00FC1 [....
Have you tried UPDATE STATISTICS? Sent from my iPad > On 28 Dec 2017, at 17:18, Henri Moukouri <h.moukouri@moukouri.net> wrote: > > $¨®¼+"²Ø^jÛZr ±Êâ¦Ñh®Ë«zØ^º+i×¢÷«²*'×^ô¢½v×L"VÞvÞ{azw > > > ******************************************************************************* > F…
Re: Syntax error on Informix server 10.00FC1 [....
Henri Still no attachment ?? can you paste it into the email body. Keith On 28 December 2017 at 17:28, Henri Moukouri <h.moukouri@moukouri.net> wrote: > Hi, > > Sorry, this is the attached script. > > For sure, the upgrade to version 11.70 or 12.10 will be done in the near > f…
Re: Syntax error on Informix server 10.00FC1
Hi, Here's the script : CREATE PROCEDURE XXXXX () DEFINE f_table_name VARCHAR(30); DEFINE f_column_name VARCHAR(60); DEFINE sql_stmt CHAR(1000); --utilise pour construire la requete dynamique LET f_table_name = ""; LET f_column_name = ""; LET sql_stmt = ""; insert into d…
cdr check replicate set
Hi, IDS 11.70.FC8. We use â cdr check replset ..... â to repair some unsynced tables. My questions are, 1) Is it possible to skip some tables( since it might take long time for big tables)? 2) Tips to speed up the re-sync job Thanks Frank…
Re: Syntax error on Informix server 10.00FC1 [....
Hi, Sorry, this is the attached script. For sure, the upgrade to version 11.70 or 12.10 will be done in the near future, but I actually have to run the script on IDSV10. So, could you please show me how to convert it to run on IDSV10 ? Best Regards, Henri MOUKOURI On 12/28/…
Re: Syntax error on Informix server 10.00FC1 [....
On Thu, Dec 28, 2017 at 09:19 Henri Moukouri <h.moukouri@moukouri.net> wrote: > $¨®¼Ââ +"²Ã^jÃZr ±Ãâ¦Ãh®Ã«zÃ^ºË+iâ÷«²*'Ã^ô¢½vÃL"âVÃvâ°ÃÅ {azwÅ¡ Thatâs not normal SQL. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>…
Re: Syntax error on Informix server 10.00FC1 [4042
$¨®¼+"²Ø^jÛZr ±Êâ¦Ñh®Ë«zØ^º+i×¢÷«²*'×^ô¢½v×L"VÞvÞ{azw…
Syntax error on Informix server 10.00FC1
Hi, I have attached a script which runs without any problem on Informix server version 11. On Informix V10.00FC1, running the same script through dbaccess, I have the followingerror message "201 : A syntax error has occured" and the cursor is pointing on immediatekeyword in execu…
New Informix Training Opportunities for 2018
Folks, Happy Holidays and Best Wishes for the New Year. We are pleased to announce our Informix Training Schedule for 2018. We are the best place to get your Informix training. All classes are taught by IBM Champions with over 30 years of Informix DBA and Performance Tuning Exp…
Waiting for Next Logical Log File to be Freed
I'm stuck and I can't bring my database up: [informix@slnxstmaibfsbfp01 ~]$ onstat - IBM Informix Dynamic Server Version 11.70.FC4 -- Fast Recovery (CKPT REQ) -- Up 00:06:08 -- 250712 Kbytes Blocked:CKPT DYNAMIC_LOG [informix@slnxstmaibfsbfp01 ~]$ onstat -d IBM Informix Dynami…
Re: RE: SQL Performance question
Thank you John. Yes, the tempdbs created with "T" option and the create temp with no log. I compared all the other statistics information. I found the bufwrite happened on load data into temp table and create index on temp table. From sqltrace The original sql take 0.180462442…
SQL Performance question
Hi, I am working SQL tuning case, after I re-writed the sql with temp table. It reduced bufreads of sql from 68,000 to 37,000, but it increased bufwrites from 31 to 480. This sql will execute several million times daily in our system. My question is how can I evaluate the chang…
Re: Informix Best Practices Webcast - Getting Star
Hi, Getting Started with Informix Enterprise Replication by Thomas Beebe - Informix Best Practices Webcast Replay is available at YouTube: https://youtu.be/QMcctXAlhkg Regards - Lester On 12/5/17 9:22 PM, Lester Knutsen wrote: > Folks, > > > Our next Informix Best Practices We…
error initializing 11.70.FC9
IDS 11.70.FC9 HP-UX 11.31 PA-RISC I did a standard installation (as root) of 11.70.FC9 in a separate directory on our test server. In the past, I have always set up a quick test instance anytime I install a new version, load the stores7 database, and run a few SQL statements to …
Where's "tristarm" ?
Hi, Who/what is "tristarm"? Interesting items in the latest Informix documentation...some developers local repository path leaked out in the docs? A consequence of the new automated packaging during the release process which includes auto-generated release/machine notes? I …
IDS 12.1 Installs without jvm library files
All, Does anyone know if it causes an issue with IDS 12.1 to install the product WITHOUT the JRE library files under ${INFORMIXDIR}/jvm? Thanks, Bob…
Informix Tecnical Support
Has anyone encountered the following error after trying to sign in when trying to open a new service request with Informix TS ? (Evidently the legacy application is being swapped out to a new "support" experience.) Yikes we didn't catch all of that. The system received a reque…
Informix and thin provisioning
Hi all: We have several huge sbspaces in one of our instances (12.10FC7). After deleting almost all the blob rows contained in it Informix is showing the sbspaces as almost empty. But, from the storage point of view, no changes have been shown. As per aour tests, the problem is…
dbaccessdemo and the blob columns in catalog table
Hi Folks. I seem to be about to get into an Informix gig again so I'm active here again. In the stores_demo database, the only table with blob columns is catalog, with columns cat_descr (text) and cat_picture (binary). I wanted to test a function involving the lengths of the bl…
DB2
Hi, a few months ago, I saw a post on here that mentioned DB2 help as well on here, but I can't find the post or anything about that. Is that available here or am I out to lunch? :)…
Cannot read from sysprocplan
Hi, we are seeing an error through an application when it tries to do a select on the database, but if we go on the server and use dbaccess, the select statement works. Anybody know anything about these errors? 12/08-09:22:26.211 [01] <002:0001:> (01) ==> inf_exec_stmt: (-211,-1…
IDS software bundle for REHL on IBM power systems
Hello everyone, I am looking for the IDS 12.10 software bundle for redhat linux 7 operating system for IBM power systems. Is our IDS supports for this requirement?…
Soundex function
Hello Is there any soundex function in informix to update a field with the data returned by this function? Thanks…
Informix Best Practices Webcast - Getting Started
Folks, Our next Informix Best Practices Webcast is on Getting Started with Informix Enterprise Replication by Thomas Beebe - Thursday, December 14, 2017 at 2:00pm EST Please register for the Webcast at: http://advancedatatools.com/Informix/NextWebcast.html Regards - Lester --…
Authentication with certificates
Hello everyone, I'm trying to figure out how I can use certificate authentication to connect to IDS 12.10. Does anyone have experience with this challenge or can tell me if it's even possible? Thank you for all Replies. Kind regards. Jochen…
IDS 11.70 dbaccess generates Illegal character msg
Greetings, We are experiencing an issue in our environment periodically where dbaccess generates a SQL -34389 "Illegal character has been found in the input string" error. This does not occur regularly but occurs every once in a while when invoking vi through dbaccess. We are r…
How to find Index corruption and repair if any
Could any one please help me immediately on how to find whether index is corrupted or not and if so what is the way to repair. It will be more helpful when your response is fast.…
IDS installation error
Hi, I m trying to install IDS 12.10 FC8AEE on UBUNTU 17.10 in console mode. I m getting an error as below, Installing... ------------- [=================|=================|=================|=================] [-----------------|-----------------|-----------------|-------------…
RSS bring up secondary problem
Dear all, Trying to restore an instance (recreate rss on backup location however once finished and do onmode -d RSS myprim i do onstat -g rss on the primary I am getting an error: idsrssesbsoc Active Connected 3000939,-1 N I use ontape to STDIO, pigz and ssh to the remote mach…
In Place Alters and Upgrade plans
IDS 11.50.FC6 HP-UX 11.31 PA-RISC As you can see above, we're on 11.50, and needing to upgrade before end-of-life. Because we're on PA-RISC, we can only upgrade to 11.70. Looking at the Migration manual, it states that best practice calls for removing any outstanding in-place a…
Make Primary in an HDR pair READ ONLY
Solaris 10 IDS 11.50.FC5 ________________________________ I read on the IIUG site that there is no way to make a database READ ONLY (exception being the Secondary in an HDR pair). Is this still true? I want to still be able to read the data from the Primary database, but I do …
RSS sync problem 3 pages left in rootdbs
Dear All, Running a production db IDS11.7FC4 on AIX 7.1 Have 2 RSS servers one of them real time the other with 1/2h delay Today I had a problem, I ended up on the production site with 3 free pages on the production server. The RSS sync that has no delay was stopped. I did re…
RSS does not apply logs
hello, I have the following situation. I would be very pleased if somebody could put a light into this. Thanks a lot, JUAN Primary: amc1_rss RSS server: amc4_rss RSS DeLAY_APPLY 5M Why does RSS secondary not apply logs up to 116024, having long past the 5 minutes delay config…
Next Informix Best Practices Webcast - Schema Desi
Folks, Please join us for our next Informix Best Practices Webcast, this Thursday at 2:00pm Schema Design Tips by Art Kagel, our next Informix Best Practices Webcast on Thursday, November 30, 2017 2:00pm EST Arts session will cover comparing similar data types. A review of nor…
Informix backup to cloud - vendors ???
Hi friends. A recent doubt: Even in 11.70 releases, we can configure TAPEDEV to a cloud storage provider. My doubt is that the only mentioned is Amazon S3. Documentation specifies nothing about "cloud provider". Is it the only one available? Could I use IBM cloud, or any other…
Backing up Logs
I haven't set up automatic backups of my logs yet, so while doing all this troubleshooting, they have filled. In the past, I have run ontape -a but now when I do that, it is asking me to mount a tape, and hit continue, and of course, I just want them to write to disk. I have LT…
Misconceptions about Update Statistics
Has anyone here perhaps written an article about the Misconceptions of Update Statistics ? I am getting so tired of Developers telling me how Update Stats is the fix for EVERYTHING. Don't think the detail is necessary, but we run: IDS 12.10.FC9W1 AIX 7 Regards Dirk…
DBAccess
Does DBAccess write its errors in a log somewhere?…
Download specific version of Innovator-C?
Does IBM only allow download of the current version of Innovator-C? I want to download a specific version to try to reproduce an issue, but I can only find 12.10FC9IE? I'm looking for 12.10FC8IE. Any info is appreciated. Thanks -Pete McDonnell…
Re: HDR Question
I ran onclean -ky I looked in the services file, and nothing else in there uses 1115 There aren't any files in /INFORMIXTMP unless I initialize the instance with oninit, and then there is one file in there which goes away when I run onmode -yuck I'm kinda lost now. Not sure what…
Re: HDR Question
Ok, I will look at that. I see in the message log that it says:Cannot locate upgrade1210FC9Stcp service/tcp in /etc/services In that services file, I have upgrade1210FC9Stcp 1115/tcp It also says cannot bind to the port (upgrade1210FC9Stcp) on the host (xxx) for the server (upg…
HDR Question
Hi, if you have serverA as the primary and serverB as the secondary. For the Services file configuration, do you just need one entry on serverB that says what port serverA can communicate on or do both servers need an entry in their services file. So, it would be: name from DBS…
Webcast
Folks: I will be doing another Webcast session as part of the Advanced DataTools Informix Best Practices Webcast series on Thursday, November 30, 2017 at 2:00PM EST. The subject will be: Schema Design Tips Register at: https://lnkd.in/d7yGhhW Art Art S. Kagel, President and P…
storesdemo
Hi, I'm still trying to connect a few dots here... I just installed 12.10.FC9. I ran dbaccessdemo, and it created the demo database. Where does this get stored? Does it automatically find my datadbs chunk?…
Installing IDS in UBUNTU 17.04
Hi all, I m trying to install IDS 12.10 FC8AEE LIN-x86_64 in Ubuntu 17.04 its showing error like "cannot execute binary file" please help m on this. Thanks.…
BACKUP_FILTER
Hey everyone, I am running RHEL 6 Linux with Informix 11.70. I would like to use the backup filter to encrypt my backups to file system. I am told the there are free encryption products already installed on Red-Hat, can any one tell me what they are? Specifically what would I rep…
Clear out temp space?
Informix 12.10FC3 Solaris 10 1/13 I had a user complaint, this morning, about running out of temp space when executing a query. I checked and noticed a few dozen system generated SORT tables, etc. The interesting thing was that Server Studio showed all of them as empty, yet the…
Schema Design Tips by Art Kagel, our next Informix
Schema Design Tips by Art Kagel, our next Informix Best Practices Webcast on Thursday, November 30, 2017 2:00pm EST Arts session will cover comparing similar data types. A review of normalization. Implementing difficult relationships and much more. Please register here - http:/…
Latest IIUG Insider - RFE...
Hi, Not sure if this will help the people interested, but in any case.. In the latest IIUG Insider, there is a new section for "hot RFEs". One of them is requesting a way to map a session with a listener... It's possible, but slow.... Please check the following script: https:/…
IDS CRASH WHEN INSTALLING UDR
Hi IIUG Users, I'm having a big problem when install a java UDR. The system crash each time i execute the "install_jar" routine. My instance specs: - IDS 11.70FC9 - Red Hat 5.6 Message Log extract: 10:07:46 Booting Language <java> from module <$INFORMIXDIR/extend/krakatoa/lmj…
fail to restore with ontape (buffer is short)
The message of error is: invoke_alarm(): INFO: 1000 bytes in buffer but need 1317 errno 28 Should be increase the swap in the operating system, this happens with HP-UX Success!!…
contention on dstpool
Hi, I run 'onstat -g spi | sort -nr -k 2 |head -20 , and the output show high contention on dstpool,currently the ds_hashsize is 31, ds_poolsize is 127, How to tune those two parameter, Do anyone has any guideline ? thanks.…
sqlcode -458 error
Hi, Our application recently encountered hang outs and slowdown because of the sqlcode 458 error and the devs are pinpointing the query below that was causing the error. select count(*) from table where column1 ='result1' and column2='result2' and column3='result3'; The que…
Which Informix Version To Download?
Hi, I have a Linux redhat server 64 bit. I want to download the free version of Informix 12.1, but am having a hard time to figure out which one I download on the IBM website. Any ideas?…
AIX Thin Client to IFMX
Need recommendations for an AIX-based thin client to simply benchmark queries to an IFMX engine. Nothing "informix" on the box. Want to avoid having to use jdbc or the like - just a direct connection to the engine to time queries. Razor and Squirrel appear to have Linux flavors, …
Informix 12.1 Blocking Checkpoints
Hi, We are using Informix 12.1 and it seems that we are encountering blocking transactions in our installation. From what I've read, blocking transactions should no longer occur during checkpoints. Here are snippets from our online.log From here, you could see that there are a…
HDR Configuration
Hi Friends, After a lot of study and IIUG members help, we are ready to implement HDR in production environment. But I need your help to get move forward to successfully implement HDR without any issues. Which is the best approach to get high performance and without any data lo…
More questions about backups and restores
Hi All, I've made it to the point where I can successfully do a back up of my production system, copy all the files to the backup machine and then perform a load to the backup machine. I use ISM as storage manager. Here is my question. On the backup system and I do a physical re…
Raw or block devices?
Managing a lot of chunks using raw devices is a hard job, so what kind of disk setup you recomend for better performance? Is pointing chunks to block devices a better alternative? Or another setup? Do you recomend using LVM or pointing links direct to the devices (/dev/disk/by-i…
Smart Large Objects issue
Dear Guru's Our IDS version : 12.10FC8 Environment: Windows 2012 R2 Middle layer: JBOSS AS6.1, JAVA 1.7 Application : web-based application We are facing an issue in our production server which make application hang. Temporary restarting the application server to work. Appli…
XBSA Error: (BSAGetObject) during restore
Hi All, I've been working at learning to do restores from our production environment to our back up environment. The goal is to have the environment running in a continuous logical log restore state until needed. Well I'm having an issue getting started after issuing the onbar r…
Blog: New features in Informix v12.10.xC9
http://informix-myview.blogspot.com/2017/10/new-features-in-informix-1210xc9.htm l Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are…
"output to" question
Hi All, I am having an issue with the following code output to /opt/gim2usr/scripts/nbupstat1.sql without headings select "UPDATE STATISTICS MEDIUM FOR TABLE "||trim(tabname)||";" from systables where .... when the output string exceeds 65 characters the line is split example:…
RE: Threat : swth:sbt subclass lpgsrc ol 796 UTF-8
If memory servers me correctly this has to do with = looking at log pages for replication and nothing to do with Memo= ry pages. lpsrc --> Log Page Source. John Miller =0A=0A =0A-------- Original Mes= sage -------- =0ASubject: Threat : swth:sbt_subclass_lpgsrc_ol_796 [401=…
Threat : swth:sbt_subclass_lpgsrc_ol_796
Platform : AIX 7 Informix version: 11.70.FC7W3XC Config : 1 primary, 1 secondary and 4 RSS Note : We do turn on the large page on AIX level I run onstat -g rea -r 1 and occasionally see the threat name swth:sbt_subclass_lpgsrc_ol_796 Questions: 1) What is this thread and the p…
HDR scenarios
Dear Informix Guru's I have successfully implemented High availability HDR in Windows environment with auto switch-over using Connection manager with the IIUG members help. Especially Mr. ART Now pulling my hair with some sort of scenarios, which i mentioned below, because of f…
Webcast replay - #Informix Best Practice Informix
Folks, Great Webcast replay - #Informix Best Practice Informix Query Performance Tuning Basics by Mike Walker, on YouTube at: https://youtu.be/wmVVWF2PWZ0 or on our web site at: http://advancedatatools.com/Informix/Webcasts.html Our next Informix Best Practices is by Art Kagel …
Server restores
Hi All, I'm cutting my teeth on doing back up and restores. Today I did a full system restore from or production machine to a new machine we will be using as the back up after more testing is done. Today I used the command /opt/informix/bin/onbar r to restore the the server and …
SQLI protocol
Does anyone here know of good documentation on the SQLI protocol? If so, how do I access it. Thank you…
Can I bring informix up/down from another computer
Hey Folks, IDS 11.70.FC8 AIX 7.2 I was just wondering if there is a way to bring Informix down from another computer? We have had incidents where memory issues prevented us from forking a process and it would be nice to shut down gracefully. thanx, dan…
Fatal error in ADM VP
Hi, We have a Linux ids 11.70fc8 server, that is where we replicate our databases. In this server the backplane of the array fail. We replace the part, but now informix doesn't start. In the log we see this message: Fatal error in ADM VP, Then PANIC: Attempting to bring system do…
Next Webcast - Informix Query Performance Tuning B
Folks, Next Webcast - Informix Best Practice - Informix Query Performance Tuning Basics by IBM Champion Mike Walker Thursday - Thursday, October 26, 2017 at 2:00pm EST This session will cover some of the basics of Informix Tuning, with a focus on monitoring and tuning of querie…
25590: Authentication error.
Hello OS Version : CentOS release 6.9 Informix version : IDS 12.10.FC9TL We are having issues connecting to our Informix database through dbaccess Users created locally on the server can connect successfully to the database. However all 'Active Directory ' users receive error me…
Help with Windows AD and SLES IDS
Hello community, first post here and sorry I'm a newbie in this topic. I have a SLES-Server with IDS, windows server 2012 r2 with AD and some windows clients and a own domain. I've read the paper about http://www-1.ibm.com/support/docview.wss?rs=0&uid=swg21405613 I've some qu…
Retoring the onbar backup
Hi friends, I want to restore our onbar backup from linux server to windows server, our onbar backup is scheduled through OAT.what is the procedure to restore?. Please help me on this. Thanks…
Is PDQ only for DSS?
Hello all!! IBM's docs says "Parallel database query (PDQ) is a database server feature that can improve performance dramatically when the server processes queries that decision-support applications initiate." (source: https://www.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/c…
insert in locked table
We used similar script as following to replace a table with new table(existing table was approaching to max pages limit). Both tables are locked and an insert statement with maximum serial column value from existing table is inserted in new table to keep the serial in accordance …
My Sysmaster Webcast Replay and Scripts
Friends, Webcast Replay - Using the Sysmaster database to perform an Informix Server Heath Check,by Lester Knutsen. On Youtube: https://youtu.be/3w83w1kc2gk The scripts and slides are on: http://advancedatatools.com/Informix/Webcasts.html Next Webcast - Informix Best Practice…
Need help with my instance names
We took over an informix server about a year ago...and I'm still working on figuring how everything works. Today, I'm looking to see how the logs are backed up and where. When I log into my linux server, I see two folders: 11.50 and 11.50.FC6. Does this mean there are two insta…
AW: Which dbspace does a database occupy
Dbaccess dialog dbaccess - Database - Select - Info - Dbspace Shows the dbspace where the database initially was created. Tables are created there if not specified otherwise. HTH Reinhard -----Ursprüngliche Nachricht----- Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org…
locks persists while client app is down
We are running IDS 12.1 FC6 on Solaris. Last day a unix box residing java applications gone irresponsive due to high load on it. We restarted the machine but there were locks even the applications were down (these applications maintain jdbc connection pool with IDS database). We …
vmware or rhev Informix virtualization
They want me to create new sds Informix clusters in virtual machines. In your experience, which one would you choose? vmware of rhev? They also suggested me that I put one node under vmware and the other under rhev in case one platform falls... They need to share a disk for the…
number of when clauses in create trigger statement
Is it legal to have more than one WHEN in a create trigger statement? I am trying to run this SQL: create trigger "dba".t_up_loc_sb44 update of location on shelf_bin referencing old as oldval new as newval for each row when(oldval.location = '44' and newval.location <> '44' …
Could not position within a table
Dear Friends, Since one year we are facing the below issue which cant be able to find the root cause. Please help on this. Informix: 12.10 FC8 OS: Windows 2012 R2. Application : Java 1.6 Issue 1: NEURA_BIACH [09 Oct 2017 09:14:23: ERROR : org.hibernate.util.JDBCExceptionReporte…
Auditing 'EXSP' events
Informix 12.10 Solaris 10 I am attempting to use onaudit to monitor the execution of stored procedures. I have enabled auditing, with a default mask of 'EXSP'. I'm getting a lot of data, and seems to be mostly working. EXCEPT, that the ausit log does not show any record of a c…
Normal user in informix group
Hi, When I add a new user to the so, it is necesary to add this user to the informix group? Thanks in advance.…
SPL procid=0?
IDS 12.10 Solaris 10 I mentioned this as a sort of aside in a previous post, but have been unable to determine any answer from further research. Before I open a tech support case, just trying one more time, here. Does anyone know what is meant by a procid=0? I have enabled aud…
Download of Informix 9.21FC7
Does anyone have or know how to get Informix 9.21FC7 download? Also is there a way to tell from an Informix backup file what OS the backup was taken on? This is an audit requirement and all they have is an Informix ontape backup, no other information. Thanks, Jeff…
line number of exception in stored procedure
Is there anyway to determine the line number where a stored procedure encounters an exception? Occasionally I run into an issue where a Decimal variable is not large enough to contain the data it receives and a SQL error is returned from the procedure. I would like to collect t…
Shell to make dbexports
Hi, I making a shell to dbexport all my databases. I first put an onmode -uy line,then onmode -jy line My question is, where and how many time do I need to put an sleep ??? Line to make sure all sesions are terminated, before I put the dbexport cicle lines ? Thanks in advance.…
Re: Monitoring SPL Executions?
I simply pull from "onstat -g prc" ... my watcher runs constantly and picks up any and all SPLs (seen before or new), tallying them so I always have a datetime|procname|executions_at_that_time record. This actually came in handy recently to find most used SPLs - never thought it …
Informix text indexer
I'm starting to read about excalibur datablade for indexing documents and the Lucene text type fields indexer. Someone is using or used any of these two?…
Re: Looking for experiences with the ILMT
Those of you running Informix in sub-capacity mode, I interested in your experiences with the IBM licensing tool monitoring = your environment =E2=80=94 the ILMT. Resources required A separate server or VM with a couple of cpus and a few Gig of memory should be fine. Installati…
Re: Outrageous Extent sizes
Hi All, To wrap up this topic: After working with HCL, we discovered a mismatch between the Next Size value in dbschema (and appropriately, in systables) versus 'oncheck -pT' (and thus sysmaster:sysptnhdr). As the Next Size is automatically doubled, the new value is stored in sys…
Re: Issue in production server.
Mukesh, How are you accessing your SLOBs? We use the BTS blade, and have been told that it is incompatible with DBEXPORT/DBIMPORT. (even the -ss doesn't work.) When we want to transfer the specific db between servers, we need to drop the indexes, transfer the data, and then recr…
Re: Which dbspace does a database occupy
> This good tool "onmonitor" seems to go away in 12.10 (in basic > installation?).Simple script is the best way but the problem is we don't > usually walk around remembering the syntax.How about oncheck -pe? > Let's go GreenThis email contains 100% recycled electrons. oncheck -p…
Re: Deleting millons of rows
Thanks, I find a criteria by a column that has a number thats is growing and it delete very fast. I already delete 20,0000,000 and I only need to delete 15,000,000 more millions. > El 26/09/2017, a las 08:45, DOUG LAWRY <douglawry@hotmail.com> escribió: > > Hi Jorge. > > The sta…
Re: Stop receiving IDS emails
Dear all,Please unsubscribe me from your mailing list.Thanks & Kind Regards. From: ABRAR RASHID <mabrar@i2cinc.com> To: ids@iiug.org Sent: Thursday, 28 September 2017, 19:08 Subject: Re: script for ontake backup in multiple files [40002] Backup size reaches to 1T with is OS Lim…
Re: script for ontake backup in multiple files
You're using the old script that makes backup complicated. What is the reason that you need to break the backup into multiple files?You can just do ontape backup to directory and Informix will name your backup files automagically including your logical logs. Let's go GreenThis e…
Re: script for ontake backup in multiple files
Why to multiple files? Use 'ontpae -s -L $level -t STDIO > outfile' and save all the echo '0\\ \\ \\ ....', mounting, touching, chmod'ing and chown'ing. Could then split outfile if required - for whatever reason. Could also compress outfile while creating: ... -t STDIO | gzip…
script for ontake backup in multiple files
Hi, We need to take backup (ontape) in multiple files using bash script . we are using IDS12.10FC7. currently we are using following script but it is not working properly. 1). Main script. i=inst_name level=0 . /inst_name TAP_FILE=`onstat -c|grep "^TAPEDEV" | awk '{print $2}'`…
Looking for experiences with the ILMT
Those of you running Informix in sub-capacity mode, I=E2=80=99m = interested in your experiences with the IBM licensing tool monitoring = your environment =E2=80=94 the ILMT. Resources required, installation = and ongoing administration, experience using, value derived etc. Pleas…
Deleting millons of rows
Hi, I need to delete a lot of records of one table, but I got the long transaction aborted error. Is there a way to delete this records without changing the log transaction mode of the database? Thanks in advance.…
Which dbspace does a database occupy
IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen…
More Free Informix Best Practices Webcasts
Folks, We have more Free Informix Best Practices Webcasts... *** Using the Sysmaster database to perform an Informix Server Heath Check by Lester Knutsen - Thursday, October 5, 2017 at 2:00pm EST This is the latest update to my talk on Exploring the Sysmaster database. We will…
Table level restore archecker fails -1226
Dear all, Have been trying for a while to restore 1 single table from ontape using archecker. However i am getting -1226 both when i restore in the table or when i restore to external file. (http://www-01.ibm.com/support/docview.wss?uid=swg21655476#) When I do the last I am get…
Reset audit file number?
Solaris 10 IDS 12.10FC3 Is there a way to reset the audit file number? For example, say the current audit log file is "<INFORMIXSERVER>.7". Say I desire to reset the sequence number, and have the next audit file be "<INFORMIXSERVER.0", and then continue to increment from there …
Archecker single table restore compressed ontape
Hi, AIX 7.1 IDS 11.7FC4. I have a nightly cron that runs the following ontape backup: # ontape -t STDIO -s -L 0 > /backup/backup # onstat -c |grep -i filter BACKUP_FILTER /usr/bin/gzip RESTORE_FILTER /usr/bin/gunzip messages in the log that rootdbs, datadbs ... started ... …
How Do I Unsub From This List?
Regards Errol Sent from my T-Mobile 4G LTE Device…
Monitoring SPL Executions?
Solaris 10 Informix 12.10FC3 Today I was asked if we can monitor the execution of SPLs. Specifically, the requester wants a list of all SPLs executed in the preceding 24 hours, and the number of times each was executed. I didn't see any Server Studio reports that addressed thi…
Recommend Informix Training
Hi, we will be installing Informix 12.1. We currently use 11.5 I'm looking for some recommendations of companies that offer remote training(Our company doesn't like to pay travel). I need a course on best practices, and settings required to optimize the out of box setup. I can …
Is it just me...?
Or is 12.10.FC9DE on MacOS X really, REALLY unstable? It runs for a while after I bring it up, but eventually it stops responding and I start getting -908 errors. This has only started happening since I upgraded from FC8DE. Any thoughts?…
Re-building Indexes in production server
How to rebuild all indexes created on tables can anyone give the steps plz…
RE: Rovoke insert permission but still can insert
Did you log off and back in?? I have seen this before where user didn't have permission and then we granted them and still didn't work until they log off and back in then they were good. Bruce Simms Data Base Services TALX, Provider of Equifax Workforce Solutions 2330 Ball Driv…
Issue in production server.
Hi Floks, Yesterday night I have done a activity that, Moving Live production server to New server. All the config parameters are set properly as like existing one and installed same version of informix IDS 12.10 FC8. Using DBEXPORT and DBIMPORT we have moved the data. Now the …
Rovoke insert permission but still can insert
I have issued these commands: revoke dba from rafael; revoke resource from rafael; revoke all on tmp_rosas from rafael; grant select on tmp_rosas to rafael; grant insert on tmp_rosas to rafael; revoke insert on tmp_rosas from rafael; But the user rafael is be ing able to insert…
Re: Moving Production server to another server
If we do DBexport and DBimport, will all the procedures we work fine for reports or we need to compile again to work…
Moving Production server to another server
Hi floks, I have big task today, Due to some issues with production server, we need to change the Existing production server to New server. So I have Installed same version of IDS as a previous production server to new Server. I have a doubt here. Taking dbexport backup of pro…
IDS 12.10.FC9 for Windows OS 64 bit
Hi I want install informix in Windows platform (Windows Server 2012 R2) 64 bit. Im trying to download through passport advantage. But not able to track the bundle. I got "Informix_Enterprise_12.10.FC9W1_WIN_x86_64_IFix.zip". With this iFix can I install Informix freshly?…
Secondary stuck in Fast Recovery
Ok guys, I need your help again ugh. So I have this dev setup Ive been working on. Sounded simple. I have two Version 11.5F9DE instances running with a primary and secondary set with HDR replication running. I wanted to try a FULL and DIFFERENTIAL backup and restore on the pri…
jdbc connection error
Hi I need some help I'm using IDS12.10FC4 and I'm testing connect to informix using jdbc but I get this message com.informix.asf.IfxASFException code-set conversion function failed due to illegal sequence or invalid value and locale value is en_US.819 why i get this message?…
RE: Re: RE: RE: Issues With Restore [39872]
Benji, What is your TAPEBLK set to?? You might test with it set at 256 and compare times. BSimms34@gmail.com IBM Champions -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BENJI LONG Sent: Thursday, September 14, 2017 1:31 PM To:…
Issues With Restore
Hi, this is a dev box. I made a backup and am now trying a restore, which has gotten me into a circle of issues I used ontape -p and it asks for the file, I say y to restore, n to logs, n to differential backup etc. I actually have a level 0 and level 1 backup, but just want to …
Informix HDR
Hi, I'm currently running Informix HDR (IDS 12.10FC8 on Windows server 2012 R2) in Async Mode. I just have a few questions: In Async Mode, the log is flushed to disk without waiting for a confirmation from the Secondary. What happens if a transaction is committed on the Primar…
Bug in MacOSX IDS 12.10FC9DE (but probably other M
Since it=E2=80=99s community supported, I don=E2=80=99t really know how = else to report this defect. The provided script rest_listener_start.sh : #!/bin/sh ${INFORMIXDIR}/extend/krakatoa/jre/bin/java \\\\ -cp = ${INFORMIXDIR}/bin/jsonListener.jar:${INFORMIXDIR}/nosql_sdk/tomca…
AW: Monitoring data throughput
Sorry, version 12.10.FC4/FC8 on Solaris 10 Von: Fernando Nunes [mailto:domusonline@gmail.com] Gesendet: Donnerstag, 14. September 2017 12:18 An: Habichtsberg, Reinhard Cc: ids@iiug.org; informix-list@iiug.org Betreff: Re: Monitoring data throughput Version?... Since version 11.…
Re: Monitoring data throughput
Version?... Since version 11.50 you have on sysmaster: { network IO Information } create table informix.sysnetworkio ( net_id int, { Net ID } sid int, { session id } net_netscb int8, { address of netscb } net_client_type int, { client type } net_client_name char(12), { cl…
Monitoring data throughput
Hi all I'm looking for a way to monitor the data throughput a session generates. I cannot find nothing useful among the onstat commands or the sysmaster tables. Also the monitors of ServerStudio and Sentinel don't help with this question. I'm particularly interested in measurin…
Multiple DRDA setup
Hi Gurus, I'm trying to test JDBC (onsoctcp) and DRDA (drsoctcp). JDBC works fine using jdbc.url = jdbc:informix-sqli:DATABASE=DBname;INFORMIXSERVER=Instance;SQLH_TYPE=FILE;SQLH_F ILE=/opt/informix/etc/sqlhosts; Is it possible to do the same for DRDA? I can test via testconnec…
Archecker logical table-level restore on 11.70.FC7
Greetings, I am attempting to do a table level restore on IDS 11.70.FC7GE and passed the logical restore options to archecker but I get the message below that I can only do a physical restore. The IDS documentation (Backup and Restore Guide) implies this option works with a sto…
Backup Help
Hi, I have a test Informix instance setup. I am testing doing a level 0 backup. The database is very small, yet it seems to be running for over an hour now. When I run onstat -m, I see it says Level0 Archive started on rootdbs, logdbs, datadbs I thought it must have completed s…
CSDK version
Hi floks, What is the latest version of CSDK for Windows 64 bit environment. I am uisng " CSDK_4.10.FC6_WIN-x86_64_Fixpack " . Is this a latest or any update?…
Rename Server with Informix
Dear Friends: I need to rename a server that has Windows 2008 Server and Informix 7.31TD6 installed. It is not linked to a domain. My question is whether you can rename the server, and the Informix instance so you do not have to reinstall the engine. Thank you for your attenti…
DRAUTO
Hi, we have a primary and secondary server, that we look after in Informix 11.5FC6. Our client wants to take down the primary for an hour this weekend. I see DRAUTO is set to 1 which I have read that means the secondary will switch to primary mode, and then revert back to second…
NEW EXTERNAL TABLE QUESTION
Hi All, I am seeing a strange behavior with an external table. if I do a select * from the table I get all the rows and columns returned. If I try to use a where clause on the table and say "where ISSUER_CUSIP is not null" I get the -217 error that the column is not in the table.…
Informix training for Database Administrators
Folks, Last chance to register for our Informix Course in September 18-21, 2017 - Informix for Database Administrators, training course. We have one space left. You can take the course online on the web from your desk, or attend in person at our training center in Virginia. All…
keep-alive in sqlhosts
Hi all, we have the problem that longer lasting remote client sessions on informix databases are interrupted by the firewalls, particulary when no packets were sent. It's possible to configure the port on the firewall to extend the time before the connection is interrupted. The …
Export backup while database is in ONLINE mode
Hello All, Is it possible to take the dbexport backup while the dataabse is in On-Line mode. if so, how is it possible?…
Informix in a Virtual Machine Webcast Replay
Folks, My Webcast Replay is available on YouTube. Webcast - Informix Best Practices - Running Informix in a Virtual Machine by Lester Knutsen - Thursday, August 31, 2017 at 2:00pm EST Virtual Machines have many advantages and disadvantages. This Webcast will explore the best p…
unable to do continuous log replay
Hi IIUG, I've done startup of my instance via 'oninit -vPHY' , it showed that the instance is in Fast Recovery mode, however, if i try to do continuous log restore via "ontape -l -C", error shows: ================ Logical restore failed There are no DBspaces or BLOBspaces to rec…
Remote table schema
I'm looking for a way for developers to be able to get table schemas similar to dbschema but from a remote server. The development server only has the CSDK which doesn't have dbschema. Thanks for any help, Chris…
Re: Exchange of Data between Informix and SQL-Serv
Is this a one time operation or an ongoing operation? If it is a one time operation then I'd suggest an unload/reload using the easiest tools available. That might involve writing a program and/or using scripts to format the data. But if this is an ongoing operation, then I'd s…
Error allocating temporary clob file on Innovator
Hello! We're getting Error: 8359: Function (extractvalueclob) Error allocating temporary clob file. trying to use SELECT EXTRACTVALUE(xml,'/doc/number') FROM TABLE_WITH_A_XML_COLUMN. In the online.log we got the message: Warning: The IBM IDS Innovator-C Edition license restrict…
Exchange of Data between Informix and SQL-Server
Hi all, I'm looking for help with the exchange of data between Informix 12.10 and SQL Server. They want to extract data from Informix Databases to SQL Server, working on the data and put them back to Informix. They tried to use ODBC and OLEDB connection what seems rather slow. …
error using an external table as part of a delete
Hi All, I have two tables, gwk_lng_rng_sql is a regular informix database table and gwk_lng_rng_sql_ext is an external table. I am trying to delete any rows in the regular informix table that do not exist in the external table. Each of the three methods provided below return an e…
Re: Mails don't appear in the list
It's nearly a year ago I complained that my own mails and posts I sent to or posted in this group are not showing up in the mailing list I receive. The mails I receive from other list-members has the sender ids-bounces@iiug.org or informix-list-bounces@iiug.org. Other obviously…
Running Informix in a Virtual Machine - Free Webca
Folks, We have an exciting Free Webcast for Informix Users this week. Webcast - Informix Best Practices - Running Informix in a Virtual Machine by Lester Knutsen - Thursday, August 31, 2017 at 2:00pm EST Virtual Machines have many advantages and disadvantages. This Webcast wil…
Chunk must have owner-id informix
Hi, After a fail electricity power, we restar the server, then got this error: The chunk must have owner-id and group-id informix I list the chunk and see that it has owner and group informix. Any ideas? Thanks in advance.…
SELECT FOR UPDATE and triggers
Hi, I am having a problem with triggers which I do not understand: * I have two tables, lets call them a & b. * Table b has a trigger which (for simplicity calls "UPDATE a SET some_field=42") on UPDATES/INSERTS (you name it). * Now I call "SELECT * FROM a FOR UPDATE" which acqu…
Any HDR restrictions on Informix Innovator C?
I am trying to find a better product to use for development. We keep reaching the max connection limitation with Developers Edition. -- Will chat again soon, Kate katedarts@gmail.com…
usage of oledb
Hi all, we are working on a data warehouse project which will be implemented with MS SQLServer. Now the guys from software development urge me to run the coledbp.sql script on the sysmaster database. They want to use a OLEDB Linked Server in Microsoft® SQL Server to allow retrie…
Creation of another IDS instance
Dear All, In my CentOS 7 linux server we installed IDS 12.10FC8. Now we need another instance for another database project. How to do this. I am very new to Informix. 1. What steps need to follow. 2. What are the prerequisites. 3. How to differentiate both configuration files l…
External table error
Hi All, I have received a 16 column .csv file that I wanted to create an external table to access the data. I am having issues with an -26168 error. I did some testing by creating a single column and single row data file. It is in unix format and I can see the "end of line" char…
Outrageous Extent sizes
Hi All, Yesterday, I added a 5GB chunk to a 76GB dbspace. The dbspace usually uses 5GB in about a year. This morning, I received warnings that the dbspace was nearly full, and when I checked, the *entire* dbspace had been allocated -- 0 bytes free. 5 GB in ONE DAY! Using Server…
Opaque data types and the wire listener
All, I hope I am not being REALLY stupid here - but please do tell me if I = am. 12.10.FC9DE We extensively use an opaque data type guid It is implemented as a blade from some code IBM distributed It works perfectly (tm) Now some users need to access the tables that contain…
how to give IP based grants in Informix
Hi, I want to grant IP based grants in informix? e.g grant select to username@192.168.X.X; is there any way to bind grants with user name and IP.…
Logical Log Sizing
Hey Folks, IDS 11.70.FC8XC4 AIX 7.2 The short of it is that I am looking for some logical log sizing suggestions. Let me explain what I am facing I have 644 logical logs sized at 100Mg each. On most days I will use approx. 200 of these. On peak days, I will use 600 thus the to…
Install Informix 12
Hello folks, OS Platform : Centos 7 IDS version: 12.10.UC9 Trying to install Informix 12.10.UC9 on a Linux Centos 7 and kept getting same error message Missing license file LA_in Missing license file LI_in Tried it also on Centos 6, same result Any idea on what could be the p…
Thousands -27001 errors
Hi, I've noticed that we have around 25 thousands -27001 errors in online.log after I checked the database because of an EG crash in IIB. EG crashed because it couldn't lock a table in informix they said. Because of this I saw all the network errors , which started since 2 days a…
Remote UDR call return 1: Not owner
Hello, I have simple UDR Cartur@marylin:/home/artur$ myschema -d bluebird@testel -f clock_gettime_realtime CREATE FUNCTION clock_gettime_realtime () returning datetime year to fraction(5) external name '/opt/informix/udr/time.so(mi_clock_gettime_realtime)' language C; GRAN…
New security check?
Folks: I renamed oninit and replaced it with a script that sets the environment then runs the renamed oninit binary. Wanted this to make certain that a manual restart has the correct environment settings. On startup using either the script or the renamed oninit the engine compl…
12.10FC8 to 12.10FC9
Hello Team, Appreciating HCL people, happy to hear the new release. Im new to Informix. Can anyone suggest how to upgrade from IDS 12.10FC8 to IDS 12.10FC9. What are the steps involved any documentation?…
How many user connections is Innovator-C limited t
And if possible, can you point me to where IBM has that documented on a web site? -- Will chat again soon, Kate katedarts@gmail.com…
Free Webcast - Running Informix in a Virtual Machi
Folks, We have two more exciting Free Webcasts for Informix Users Informix Best Practices - Running Informix in a Virtual Machine by Lester Knutsen - Thursday, August 31, 2017 at 2:00pm EST Virtual Machines have many advantages and disadvantages. This Webcast will explore the …
cdr autoconf serv failed...
Hallo everyone. I have two servers with Informix 12.10.U8 (Linux) and I want to make an "update anywere" ER between then. Local network, no firewalls, CDR_AUTO_DISCOVER = 1 on both servers. host1: - INFORMIXSERVER=server1 - sqlhosts: g_1 group - - i=1 server1 onsoctcp host1 9088…
Informix with Netbackup
I am looking for users that are using Netbackup to do archive and logical=20 log backups. How is Netbackup configured and does it handle the loigical log backup=20 load efficiently? How frequently do the logical logs get backed up on a=20 busy system? Does it have a dedicated net…
Switching HDR to RSS replication
This is a follow up to my earlier post on IIUG (July 19, 2017): HDR-Distance and Latency Our HDR distance is changing from 40 miles (NEAR) to 1200 miles (FAR) after 2 months. After testing with a set of simple update/delete statements on triggerred and non-triggerred tables I co…
How to monitor wait conditions and times
Have a complex application. Want to monitor when a thread has a wait condition and for how long it lasts. systhreads table has the below columns. The th_startwait column allows the wait time to be calculated. Have not been able to determine how th_conwait can be interpreted. Do…
Transaction table not shrinking with deletions
Hi all, We have a table that logs application transactions. We also cull those transaction records that are older than 30days, with the standard "delete from the-table where it's 30days or older". However our dbspace keeps growing and a 'repack shrink' does not appear to recove…
Is database versioning possible in IDS 12.10 FC8?
Is database versioning possible in IDS 12.10 FC8. How it works. How to Version the informix database. Please help on this…
identify what is allocating memory
Hi , How identify what/who is consuming memory in a specific virtual memory segment ? With onstat -g ses , there is no session with high memory allocated. The amount of users sessions is keeping at regular average... No buffers pool was allocated automatically (I check with onst…
sysmaster - change locale?
Hi, Just for curiosity . Is possible initialize the instance and set sysmaster for a different locale ? Since no matter the *_LOCALE variables, it and all others sys* databases are always created with en_US.* locale.... Regards…
Informix crashing without a message
Hi, I had recently an event when informix server crashed without writing in online.log or OS logs IBM Informix Dynamic Server Version 12.10.FC7X9AEE -- On-Line -- Up 1 days 07:45:44 -- 10595476 Kbytes What I've never seen or noticed is the "openp free list override 1024" line a…
Re: Connection Manager setup (Windoze)
Im also facing with this issue. Did any one got the solution for this.…
Informix Learning Opportunities
Folks, We have two Informix Courses in September, one for new Informix DBAs and one for Advanced Informix DBAs on Performance Tuning. The Advanced class is taught by Lester Knutsen and Art Kagel. If you are a new Informix user or an experienced Informix DBA, we have a course for…
Starting Connection Manager fails
after doing all the configuration settings for Connection Manager, while initialising the connection Manager as a service using the below command: oncmsm -i -c configuration_file. I have tried using the path also: oncmsm -i -c D:\\\\informixCSDK\\\\etc\\\\cmsm.cfg. Error: Erro…
vmware shared disk
I'm mounting an sds Informix cluster in vmware. VMware 6 allows 2 methods for showing shared RAW disk between virtual machines: - RDM physical compatibility mode - RDM virtual compatibility mode The fisical compatibility mode seems like a normal shared disk. And the virtual comp…
Free Webcast - Informix Auditing 7/27/17 @ 2PM EDT
Be sure to register the next free webcast "Informix Auditing", presented by Mike Walker on Thursday, 7/27/17 at 2 PM EDT. This webcast will show how to set up Informix Auditing (a free-to-use feature included with Informix), and what it can do. Register at: http://advancedatato…
HDR- Distance and Latency
We have our production and DR (disaster) data center 40 miles apart in the Chicago area. Informix production data is replicating to DR using HDR. Now our DR servers are moving to Austin, TX almost 1200 miles away. Informix 12.10.FC6 on HP-UX 11.31 ia64 Questions: 1. Is there si…
onpassword utility related to Connection Mnager.
Encrypt the password file with the onpassword utility and an encryption key. I Used a text editor to create an ASCII text file(password.txt) containing the server names, user names, and passwords for all servers in the cluster.(on the host where CM is running). Eg. #Dbserver nam…
Connection Manager Automatic Failover
Several years back we tried to implement automatic failover on a cluster handled by 2 Connection Managers instances , this was on 11.5, but we had some horrors moments like ending up with 2 primaries getting updates simultaneously without communicating with each other. Since then…
Is it possible to implement HDR
Hello All My production server consists of two different rootdbs chunks. Is it possible to implement the HDR in this scenario, because while using ONTAPE to taking backup and for physical restore we are getting an ambiguity in chunks. how to resolve this. I think the only way …
Onunload error opening TBLspace
IDS 11.50.FC5 Solaris 10 - SPARC I am trying to do an onunload on a database. I have done this numerous times on other similar databases. On this database and a second database in the same instance, when I try to do an onunload, it starts to wright to tape (disk). After a while…
Re: Smart Blob Space Size
Hi. We're monitoring the %space free for all dbspaces/sbspaces to be used for OVO using next script: SELECT d.name dbspace, SUM(chksize) as espacio, CASE WHEN is_sbspace =1 THEN SUM(chksize)-SUM(udfree) WHEN is_sbspace =0 THEN SUM(chksize)-SUM(nfree) END as ocupado , CASE WH…
Connection Manager for HDR in Windows server
Dear all, I really appreciate for your fast responses. I followed the example from below link to configure connection manager. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/i ds_admin_1173.htm Due to lack of understanding on some points mention…
Unable to join informixcommunity.com
Hi all. I don't really expect anyone on this group (outside IBM and HCL) to be able to help with this but I do hope to address anyone who has a similar issue. I don't know how many of y'all were able participate in (or just listen to) the HCL presentation given by Pradeep Mutha…
varchar data type question
HI, A customer use ESQL/C to write the application, they want to change some data type from char to varchar, the customer want to know whether the running result will be changed ? What's the internal difference between char and varchar data type with ESQL/C? thanks for your ti…
Best Practice to upgrade edition (not version)
I have a system currently installed with 12.10FC8W1 Express Edition (OS is Red Hat Enterprise Linux 7.3 x86_64). I need to change the Informix Edition to be Workgroup but I am staying with the same version. What is the recommended way to accomplish this - is it still to install t…
New Channel of Informix Server (Tech)
Hi guys There is a new channel of Informix Server in Spanish , enjoy It -Install , Backup , Restore , HDR and more. https://www.youtube.com/channel/UCVGD_IAhd0VGntXiSh_E6ew Best regards Luis devecua.com…
Should we close an opened cursor?
If we open a cursor, should that be closed? If we don't close it, will it impact performance?…
SET EXPLAIN PLAN
Hello, I am using SET EXPLAIN ON before executing any query to see the cost of the query, but it is not generating any output file. Im using data studio editor. I tried SET EXPLAIN TO <'path/filename'>. how to generate set explain plan can you provide the steps please Thank …
Functions taking more time execute
Hello Friends, Thanks for all who are responding for every query and who are very much active in this group. I am posing a strange question. I have a select query which retries only one day data from a lakhs of records. it takes an execution time of less than 50 milliseconds. …
sid vs pid
What is the difference between the sid and the pid (in the syssessions table of the sysmaster database)? I assume that sid stands for session ID and pid for process ID. If that is correct, then a session could have more than one process running at a time. Is that right?…