Threads from 2013
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Signed a petition
Hi! I just signed the petition "Let Hotel Phones Dial 911 Easily: Help Enact Kari's Law" on Change.org. I found it important enough to sign and promote. Check it out yourself and if you think it is important then please sign it too. Here's the link: http://www.change.org/petit…
Logical log backup
Folks, IDS11.50FC8 , Linux We have a couple of boxes , all are setup to do automatic logical backup. Once the current log is full, it triggers the alarm procedure to start a backup. It works great. But, The interesting thing is, some servers do not always backup a full logical…
After I run statistics any system table update
Hi All, Please let me know if i run statistics using below command after I have completed statistics any system table is getting update UPDATE STATISTICS FOR TABLE <Table Name> Version: 11.50 FC9 Thank you Regards Baskaran --001a113490fa5e866304edf2b37d…
Creating an External table
Hi All, I am trying to create an external table in informix as: create external table test_table(cols varchar(10)) using ( datafiles('C:/sample.txt'), format 'delimited', deluxe); but it gives me the error "[Error Code: -26174, SQL State: IX000] Incorrect DATAFILE entry C:/sam…
connection manager 'detect lost connection' every
Hi, I have an Informix 12.10.FC1WE cluster containing a primary HDR, secondary HDR, and an RSS. Each of the servers have connection manager running (all with the same SLAs). Recently, I've started getting email alerts from the RSS that look like this: Subject: rmca_cm_rssnet : …
Re: storage pool configuration.
OK, here's the deal: - Chunks are marked as extendable or not extendable. Extendable means it is possible to make the underlying file bigger if needed (so no RAW chunks can be extendable). If it is extendable there is not current limit on the maximum size. The only configurable i…
storage pool configuration.
Hi, ifx 11.70 FC7 . AIX 6.1 I'm studying the best way to use the storage pool at v11.70 . Today we use v11.50 , I'm planning our migration to 11.70 and my desire is allow informix automatically admin my chunks growing and try start with "best" way already configured... I have n…
Infomix serial data type incremenst by ten?
I have encountered a problem with the serial data type in one table in my production enviroment. From what I´ve learned from the documentation and Google what i have encountered should be impossible. The column is an id defined with the serial data type a unique index and a prima…
Informix install - could not find libjava.so
HP Itanium HP UX B.11.31 U ia64 IDS Version 11.70.FC7GE Good Day, Iam trying to install IDS11.70.FCGE on a HP Itanium server. When I run ./ids_install I get the following message : "Error: could not find libjava.so Error: could not find Java 2 Runtime Environment." How can I…
Do system tables get locked during truncates?
We have IDS 11.5.FC5 on our servers. We have been running a reload of Datawarehouse tables every night by truncating and Inserting the data for a few tables by pulling it from another database on a different server. The target db is local and readonly but still we revoke access t…
IIUG2014 Conference Update
Hi Everyone! The IIUG2014 CPC met at the JW Marriott in Miami, FL this weekend to prepare for the 2014 conference. I thought I would give an update on where we are at and pass along my experience with the city and hotel since this will be a new location for a lot of us in April.…
Rate Informix!
Community: There is a new rate your product website, pikimal (pronounced pick-em-all). Currently Informix ranks #5 behind DB2. Go rate your favorite database: http://pikimal.com/database-management-software Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advan…
Temp Space Page Size
Hi, We are running 11.70.FC7W2 on Solaris. I saw there was some discussion last year regarding temp space and using a page size larger than 2k. Is there a current recommendation for an OLTP system in terms of what page size to use for temp spaces ? Will the pages in 16k page siz…
Sending Audit files with ftp
Hi to All i want to send files generated by informix auditing system to another server with ftp, sftp .... (doesn't matter), and i want to do it only if the file has reached his size limit is there a way to on informix automatically (events) ? or i have to do some scripts ? tha…
CHKPTINTVL inconsistent
11.70.FC4 AIX RTO_SERVER_RESTART 0 AUTO_CKPTS 1 CKPTINTVL 300 I have noticed that on a production HDR instance the checkpoint interval is not staying true around the 300 seconds interval. It seems to switch back and forth from 300s to 900s then to 600s, with the only noticeable…
Informix connection manager
G'day All, Can someone give me a clue on deriving values to be used in ODBC within the context of following connection manager example ? If so that would be a great help in a situation where training will not be avaialble to cover up such topics. I am going through IBM Informix…
SQLCMD 89.00 ins the IIUG Software Repository
Jonathan Leffler has given us an updated version of SQLCMD Check it out at http://www.iiug.org/software/repository_news.html and http://www.iiug.org/software/index_all.html#sqlcmd-89.00 Thanks Jonathan! If you wish to contribute to the repository please visit http://www.iiu…
ISAM error: illegal key descriptor (too many parts
IDS 11.50 FC2 HP UX 11.23 Noticed below errors while running onchecks on a couple of databases. Dropped and re-created the indexe. Would like to know the cause for these bad index pages. Data in these tables are 10 years old. HP confirmed no hardware issue. Everything seems to b…
hpl load in HDR cluster - "Cannot express load to
Hi, I have a new (empty) table in our cluster that I need to populate with about 3.7 million rows. I have these in the standard pipe delimited format and ready for importing. On the primary, I created the hpl load job, but when I go to run it I get the following output: Cannot …
IDS ... TSM
IDS 11.70,.fc3xc Aix 5.3 TSM 6.3 I asked a question the other day about TSM and IDS .. here is what I have found. When a dbspace was dropped from informix, nothing indicated to the sysutils database that this had happened. Thus in the TSM world, that file for the dbspace is stil…
Reading informix backup from tape drive
Hi All, I have requirements as below and my current server using ontape backup. My standby server need to restore this backup but the issue is my standby server doesn't have tape drive and needs to read this file to filesystem and then restore to tape. Is there any option to d…
IDS with TSM
IDS 11.70.fc3xc Aix 5.3 TSM 6.3, api 5.3.2 We have the situation where onsmsync doesn't mark the expired log backups such, thus they are never deleted in TSM. The TSM admin claims that all is set up according to the IBM documentation...and no errors are generated when onsmsync r…
SPL variant / not variant - performance
Hi, I like and use with some frequency the stackexchange "world" and few Informix questions are made there. This question in special stirred up my curiosity: http://stackoverflow.com/questions/20362107/informix-spl-function-somewhat-varia nt Basically the question is : A SQL wi…
RE: Qwerky Stored Procedure issue
I am running two Sun servers running Solaris 10 and IDS 11.50.FC7. I have an interesting situation. I am starting to gather more information, but I was wondering if anyone may have experienced this and can give me an idea of what to look for. An application developer created a …
does this mean a dropped network connection
I started to receive these errors the last couple of days, due they mean that a user was running some sql when the network connection got dropped or other network problems? 09:09:29 ASF Echo-Thread Server: asfcode = -25580: oserr = 32: errstr = : System error occurred in network…
In-Place Upgrade of Informix 11.1 to 12.10
I want to know what are the things I should take considerations when it comes to upgrading 11.1 (Production) to 12.10? I only tried doing it on an 11.5 demo server, since 11.1 is not supported anymore. I'd appreciate any kind of help. Thanks in advance.…
Pros & Cons for text datatype.
Hello , I am using IDS11.50FC8W3 for Solaris, now i want to use text data type for some tables. kindly provide me pros & cons for text data type. Thanks.…
RE: HDR replication with data encryption
I am running two Sun servers running Solaris 10 and IDS 11.50.FC7. We have been performing replication locally, and so we have never really discussed encrypting the data between the servers. We have since set up a server at another office, and I am wondering if it is possible, a…
Install fix
HI, Previously I install the server (11.50FC8)and clientsdk in the same directory. Recently I want to install the server 11.50FC9,Do I need to compile the ESQL/C application again ? THANKS FOR YOUR TIME…
Informix Server Health Check
Hi, I am running a health check on our Informix 11.70 server. We are checking for things like making sure we are not reaching any limits e.g. max row per fragment, max pages per fragment, any integer columns not reaching the limit. Just wondering, are there any health check scr…
how to quit the internal Informix users group?
Hi there, I would like to quit the internal Informix users group but not see the procedure of it, please let me know to achieve it? Thanks Jun…
tunables and settings for IDS 11.5 on a ZFS file
Anyone have knowledge of how I should set OS tunables or any other settings(variables, ZFS files system settings) for a new installation of 11.5 on a Solaris 10 zone, with the Informix instance(about 4TB in size) residing on a cooked ZFS file system? I'm having trouble getting an…
index on tables rows
spatial db IBM Informix Dynamic Server Version 11.50.UC9 S S Name Linux OS Release 2.6.18-348.12.1.el5 OS Node Name wldbp655 OS Version #1 SMP Mon Jul 1 17:54:12 EDT 2013 OS Machine x86_64 spatial.8.21.UC5 question on indexes should an index have rows in it . we have a table w…
Removing Distributions Following Informix Upgrade
All, We are upgrading a large instance from IDS 9.40FC5 to IDS11.70.FC6. I have seen various comments on how to remove old distributions immediately after the upgrade. Is it safe to truncate the sysdistrib table in order to remove all old distributions, or should we run "update…
Help about ALTER TABLE tablename drop VERCOLS
Hello, my friends. Informix 11.50.FC9W2GE, in linux_64 RedHat boxes (a cluster, with one HDR, and one SDS boxes). I am trying to find something more specific about drop VERCOLS, but nothing found in the manuals yet. If I start that command in one huge table (in OLTP system with…
Logical Log backup
I would like to take logical log backup and I have given ontape -c L and it is taking continuous backup but I would like to run cron job and needs to complete job if any logical backup. May I use ontape -a L? I need to run once a day. If in case may be logical logs more after I h…
Re: oninit -v Cannot start server
Just to thank all the people who helped me, a very big THANK YOU ALL : Lloyd,Art and Sasha I got the Instance up and running after the Unix Admins set the SUID and GUID bit on the oninit file as Art suggested. -rwsr-sr-- 1 root informix 24313497 Oct 23 12:56 /opt/informix/infmx…
Running oninit as root on AIX
Hello, I have installed Informix 11.50fc9 on a couple of AIX boxes, one with AIX 5.3 and one with AIX 7.1 (both 64-bit). When I run oninit as root on either box, it shows up as being run as user informix when I do a ps -ef | grep oninit. I want it to be shown as being run as root…
Using Informix ODBC with connection manager
Hi Guys, We are going to use Informix connection manager to manage connectivity among our database instances (Primary, HDR and RSS) as per following article but I am not sure what I will be using as ODBC settings as host name, service etc. because, when connection manager manage…
Very large instances
IDS 11.70FC5 on RHEL 64-bit: We're running OK with about 110GB buggers and 90G SHMVIRTSIZE. We tried allocating some of an extra 256GB of RAM recently added to the server. We increased the huge pages by 70GB (sysctl -w vm.nr_hugepages=145000), and tried using 60GB of that for i…
RE: oninit -v Cannot start server
If your OS is HP-UX than, login as root and 1. In file /etc/ privgroup add lines: -g CHOWN informix MLOCK 2. /sbin/rc1.d/S400set_prvgrp start ( restart ) Good luck! -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FLIP VAN WYNGA…
dbWorker3
Folks, IDS11.50 FC8, redHat Linux 6. Recently(after reverted) , dbWorker3 session ( see below) could dump/assert failed a couple of times daily..... Not very familiar to dbWorker3. Can we manage it ? Is it controllable ? Thanks, Frank [informix@stephanie tmp]$ more af.47b852…
Re: Cursor not Open [32004]
The first return statement inside the loop needs to have the "WITH RESUME" clause appended to it if you want to return more than a single "row" from the function. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.…
[Error Code:-259,SQL State:24000]Cursor not Open
Hi, I am executing a query which is using a function to return some value as input to the query. If i am executing the query on the local databases, it is working fine. However, when i execute the same query in the distributed environment, then i am getting the following error…
Oracle in the news
When asked on the news this morning who was to blame for the Obamacare disaster the Oregon Senator only said one word - Oracle Cheers Paul -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as re…
Re: User Specific Auditing
Hi, One way of doing this is to apply an extra audit mask to all the users you do want to audit, rather than trying to approach it from the other end. Maybe you know this already and are trying to avoid having to do this? It means of course that you need to integrate your audit…
Re: HDR question
It was the question. I was pretty sure I could do it, but just wanted to get some confirmation. Thanks! On 11/21/2013 4:25 PM, Art Kagel wrote: > Are you asking if you can do that while both instances remain online? Then > answer is yes you can. If you are asserting that, I don…
HDR question
IBM Informix Dynamic Server Version 11.50.FC8W2 Redhat Enterprise Linux 5 I have a server that is running in standard mode with 1 RSS attached. I can I do the following without bring the engine(s) down On standard onmode -d primary <rss name> on RSS onmode -d secondary <prim…
onstat -g rea output question
Hello Folks, IDS 11.70.FX7W2X9 OS AIX 6 Wondering what the significance of an * after the value under the vp-class column is. IE..."18cpu*". Thanx, Dan…
adding first sblob space
HPUX 11iv2 (11.31) BL870c Integrity server Informix 11.70.FC4 Our person responsible for Cognos has asked we add some sblob space so Cognos can use it when generating and processing reports. We currently don't have any sblob space in our instant. Besides the onspace commands, w…
oninit -v Cannot start server
Good Day All, Hardware : Itanium 2 9000 series IDS : 11.70.FC7GE When I try to start IDS I get the following message: You must be the owner of this server to start it. : Shared memory: permission denied. Reading configuration file '/inf11.50/etc/onconfig_trn'...succeeded WA…
Excalibur Blade data returns
Hi All, The Excalibur blade is rarely discussed here, but I see some recent posts, so I'm hoping someone is using it and can offer assistance. We are storing Word docs in our database (Informix 11.5.FC5 running on Solaris 10) and are attempting to use the Excalibur blade to sear…
999: Not implemented yet.
Hi All, I am having a strange problem while executing the following query. Please note that i have two instances on the same machine and i am trying to execute this query from 1st instance and i accesses the database of the 2nd instance. Can someone help me by telling that if …
aus_work_info
Folks, IDS11.50 FC8, Redhat Linux. A couple of days ago, we reverted IDS from 11.70 FC7 back to 11.50 FC8. Today we did a inplace upgrade of OS of Linux from Redhat Linux 5 to 6. When I started database, the error shows, SCHAPI: [Auto Update Statistics Evaluation 38-14] Error…
mutex wait bld ref co
While performing some performance test for an OLTP type load, we are receiving " mutex wait bld ref co" message in "onstat -g ath" output. Can someone tell what is it? and how to avoid or minimize such waits Informix IDS 11.50FC8W3 on Solaris…
Reversion 11.70 to 11.50
Hi, Folks, I am reverting IDS11.70 FC7 back to 11.50FC8. Linux redhat 5 Lot of outstanding in-place Alters need be handled first( see below) Some tables have many columns , not sure which columns need dummy- update. Any idea to have a fast script/SQL to find these outstanding…
MS Sql to informix migration
Hi All, any can let me know is there any tool to migrate MS Sql to informix except IBM migration tool kit Thanks pushpa…
Taking Interviews for Informix DBA at Sears Holdin
If interested, please contact: Sri Chava 248-463-1149(W) 248-850-6235(BB) Thanks, ******************************************************************************** ********** Ernie Knox Sr. Technical Specialist, I&TG - IT Operations & Governance Sears Holdings Management Corp 33…
Unable to grant select on view to user (error:302)
Hi Technical Support Team, I am using IDS 11.70 FC7 on AIX. I am having a very strange situtation. I have an instance which is having views which are using the synonyms (pointing to another database). Now, I want to grant the select permissions on a view using it owner but it …
User Specific Auditing
We have enabled informix auditing using onaudit utility. Currently we enabled it only for DDL changes, for achieving this we used _require mask. Now we want to audit DML for all users except application user (say app_user). When we use user specific auditing (in term of auditing…
onmode -BC 1
All, I need to allocate a very large smart blobspace to a client's instance (11.50.FC8 AIX ) that has expanded chunks disabled. Since the size of this blobspace needs to be 512 gigs, I need to have expanded chunks enabled since I don't want to allocate a whole bunch of 2 gig chu…
IWA vs Teradata
Hi all, I m trying to get a picture of the potential of IWA verses its competitors. One of the big players in the "big data" field is Teradata, but I can't seem to find any unbiased, independent information on the competitiveness of the product. Are there any benchmarks or artic…
Chunk Size
Hello Group, Do you have a recommendation on what to set the raw chunk size? Currently we are using raw devices and are split into 2GB chunks. Our storage admins would prefer to give us larger chunk sizes for future disk allocation and want us to recommend a chunk size. Is there…
Backup which is good on-bar or on-tape
Please let me know which method is best. I know if we use tape device on-tape is only option. I have external storage and which is good way whether on-bar or on-tape. I have tried use on-tape and able to backup. Please let me know which method is better Thank you --001a11c3704…
Crystal/Informix error
Ran into a strange problem. We're trying to use Crystal Reports as a reporting tool for a customer. We can connect to the database and get a list of tables but when adding the table to the report we get an error reading "Query Engine Error: 'HY000:[Informix][Informix ODBC Driver]…
Database in (LONGTX) need identify case user
Hi All, i have informix 11.70.FC6X5 some time database hang with LONGTX can i track the case user at this point and is there any way to avoid this issue also in this point if i restart the engine it's taking long time to come online (it's in fast recovery status long time). Tha…
DR: Needed to send a ping message but failed. 1
Hi All, I am running IDS 11.70 FC7 on AIX server. I am running primary, HDR (async) and RSS server, I have noticed an increase in the frequency of following messages: DR: Needed to send a ping message but failed. 1 I have checked the network connectivity between primary and s…
DR: Needed to send a ping message but failed. 1
Hi All, I am running IDS 11.70 FC7 on AIX server. I am running primary, HDR (async) and RSS server, I have noticed an increase in the frequency of following messages: DR: Needed to send a ping message but failed. 1 I have checked the network connectivity between primary and s…
Sysdistrib behavior: 11.50 versus 11.70
Interesting behavior I noticed between 11.50 and 11.70 regarding the sysdistrib table. On 11.50.FC9XA if I run dostats on a table, it updates the sysdistrib for that table. If I run it on 11.70.FC3, it does not. I have to run dostats with the -L and then re-run the dostats for th…
Quickie HDR Question
Hey Folks, IDS 11.70.FC7W2X9 OS AIX 6 I have what seems to be a silly question but I need to make sure before this Friday... With DRAUTO=0, I take my primary offline and want my secondary to become new primary. onmode -d make primary <name>. Do I give this it's own name or the…
Error 229 with XPS
We are running Informix XPS 8.21.UD2X2 on AIX 4.3.3.0. Recently I dropped a couple of tables and recreated them with the same permissions and then loaded the data back into them. Now we have a script that is getting stuck on a delete statement. The user has the same permissions o…
Creating and Dropping Trusted Context
Dear All I seem to be having trouble understanding how trusted contexts work. I thought understood them, but started to get some strange issued once I created on and started connecting through the INFORMIX_PDO driver. Although I don't believe PHP, PDO or the underlying ODBC are …
IIUG Conference 2014
Registration is open for the 2014 IIUG Conference! Haven't not attended the IIUG Conference in the past because the content wasn't relevant to you? Well, this is the year to start! New Informix features, like MongoDB API and JSON support and the ability to create hybrid applicat…
Problems adding a new column referencing other
Hi Everybody: I've got a problems adding a new column in this environment: create table T1 ( id_T1 integer not null primary key, name char(50) not null, other char(50) not null, ); create table T2 ( id_T2 integer not null primary key, id_fk integer, salary integer not nu…
Cost of ALTER table
Hi, All, IDS11.50 FC8, Redhat Linux 5. Seems the following types of ALTER to enlarge a column width of some BIG tables(100 millions of rows), ALTER TABLE ds_archive01 MODIFY check_sum varchar(128); can incur excessive amount of disk consumption !! Any comments or suggestions…
Informix Connection Manager - SIG 11
I have a VM setup with Connection manager pointing to an HDR pair on separate VMs. On rare occasions, I've had the Connection Manager daemon shutdown with no warning. The error in the logs shows it received a SIG 11 - 10:11:08 Connection Manager process 25654 received signal 11, …
IDS 11.75 Port Restrictions
I recently moved two Informix Online servers from Solaris to a RHEL4 System running IDS 7.50 UC5. I changed the port assignments for 2 dbservers in the services file from the 1531 to 60182, and 1532 to 60183 respectively. The ip address of the server is 192.168.0.251. The comma…
IIUG website ...
... has seemed quite sluggish for a month or two. (Has it been ported to DB2? ;-)) Maybe we need to run UPDATE STATISTICS ...?…
IBM Informix Enterprise Hypervisor Edition
Has anyone looked at this? I was asked about it by one of my customers, who had had a visit from an IBM account manager. I've had a good luck at the various official literature but just wondered if anyone has any real-world experience of its benefits. I see it comes at a small …
Getting 23705 error in XPS
We are running Informix 8.21.UD2X2 XPS on AIX 4.3.3.0. We are trying to look at data in the tables, but on certain tables we are getting the following error message: 23705: Could not open file: (cosvr, file, errno)=(1,/<tablename>.unload,13) The finder indicates that the server…
Update to utils2_ak
Folks: There is a new release of utils2_ak which includes a new myschema feature and a new utility - dbmove.ec. The update also include a couple of minor bug fixes. The new --dependency-order option in myschema will order tables such that dependent tables follow the table(s) up…
Informix on Solaris 11
Hi, We are migrating our Informix 11.70.FC7W2 from Solaris 10 to Solaris 11. We are having an issue if we set RESIDENT to -1 we cannot bring up the engine as it keeps crashing. If we set it to 0 or 1 the engine comes up ok. Anyone have any ideas on this? historically we have alw…
Informix Connection Manager - USEALIASES
I have 3 VMs setup - 1 w/Connection Manager, and the other 2 being a HDR pair. I'm noticing in the logs that CM tries to use all the DBSERVERALIASES that I have defined in the HDR pair ONCONFIG. Under the CM CONFIG, I have USEALIASES=OFF; so I'm a little confused as to why I am s…
Re: Enterprise Replication recovery slow on Solari
Art, Is there any issue of running Informix on T-series machine? Which series is observed a better choice for Informix (both for OLTP and OLAP systems), is it X-series, M-series....…
Limit Access through ODBC
Hi all I am currently using the IDS 11.5 and most of my user are connecting through ODBC from windows with a specific database ID. But we also have some developer/user who is using the operating system accounts to access the informix DB through ODBC. Currently we are using the…
Informix to Oracle interface
We have IDS 10 on a Sun box running Solaris 5.9, and want to be able to access an Oracle table on another machine from within Informix. Specifically, we want to be able to make a view in the Informix database that points to this external Oracle table. Is this possible, and if so,…
How to insert multiple lines in lvarchar column
Informix Version : V12.FC1 Platform : Linux Susue 11 Table structure: create table abc ( id varchar(36) not null, desc varchar(50), java_script lvarchar(4000), other_script lvarchar(4000), have_script smallint ) I have following sample flat file (migrating from oracle) an…
DBA Demand
Quick question: Is the demand for Informix DBAs increasing, decreasing or staying the same? When IBM bought Informix, it looked like they were going to kill it, and I got out of the field, but it looks like Informix is coming back. Any thoughts? Cheers, Harold Luse, Owner TGR So…
Re: Cooked files vs. raw partitions
So far on this thread, raw seems to be the overwhelming choice, but I would like to hear some feedback based on my specific configuration. We're in the process of bringing up a new production P750 with 32 cores against a Hitachi HUS-VM with 54TB of flash storage connected over 8…
Triggers
Hello all, I have an Informix database with a Primary, HDR secondary and a RSS. I have written a trigger and procedure to update a column in the table when a row is inserted in the table, here is the code: CREATE PROCEDURE OpenRecInsertProc(openrecnum int) DEFINE host VARCHAR(…
Add column
Folks, IDS 11.70 A big table with hundreds of millions rows. When adding a column, from performance point of view, any potential preference or difference .... if the column would be added at front, at end or in the middle of existing columns? Thanks, Frank --047d7b5d4e3c53391…
Sessions Connection Info
Hi, I am running Informix 11.70.FC7W2. We have 1 DBSERVERNAME and 3 DBSERVERALIASES defined. How can I tell from the DB side which NAME the sessions are connected to? --Dave --089e01493e161914c004e96f50f5…
Add a column to a big table
Folks, IDS 11.70 A big table with hundreds of millions rows. When adding a column, from performance point of view, any potential preference or difference .... if the column would be added at front, at end or in the middle of existing columns? Thanks, Frank --001a11c29e9cb41d3…
Restoring stratgies
We use 2 archiving strategies in production (SP)- level 0 archives of instance(using ontape) and onunloads. The reason for doing onunloads by database is because we have 4 Informix instances on our Dev box- SD, ST, SO, SB. The difference between the instances is in the chunk name…
listener-thread: err = -25573: oserr = 72
IDS: IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim) -- Up 3 days 04:39:41 -- 6209616 Kbytes OSLEVEL: AIX 6.1.0.0 Need any thoughts on this error we have received. Has anyone else received and diagnosed the problem/error? Is the Stack Trace a new standard for thi…
dbaccess long identifiers
Hi all We are looking for a way to configure dbaccess to not cut tablesnames after 18 characters. It's not even possible to see tablenames shorter than 18 characters if the owner is displayed before the tablename. That's always the case if you are not owner of the table. BTW, i…
ODBC Download Site?
Hey Folks, I know this is in the wrong place but I don;t know where else to go right now. I need to download the latest odbc drivers and cannot find them in passport advantage. Can someone please point me in the right direction? Thanx, Dan…
Checkpoint causes Db to "freeze"
Hi All, Has anyone encountered this issue? i'm running OLTP on an IDS 9.4 and AIX 5. I'm having problem on isolating the problem. When a checkpoint is being performed, the system hangs for 1-3 minutes. PHYSDBS physdbs0000 # Location (dbspace) of physical log PHYSFILE 100000 # P…
Stored Procedure Error
Hi, I've written a procedure to return a concatenated version of multiple comments records for each distinct account reference. When I execute it I get an "Invalid Day in date" error message. The two fields used in the procedure are character fields (23 & 70) are the size of the…
OAT installation and source
I want to install OAT on windows 7. Please let me know where to download and how to install Thank you --047d7b3432704662c004e9421a73…
user maintenance informix database
Hi All, How informix database user creation? Do we need to create OS user for the database access? Thank you very much --001a11c23c88aef16704e90659cb…
RE: Disk setup
Solaris 10 IDS 11.5.FC7 - Growth I remember similar questions being asked in the past, but I can't remember what the concenseous was. I am being given a cabinet with 12-146GB disks to be used as raw storage for a database. The SA is asking how I want it presented....RAID 0, RAID…
Installation error in Itanium server 11.31
Hi, I got the below error at the time of installation IBM Informix Dynamic Server Version 11.50 Bundle will be installed in the following location: /app/informix_server with the following features: IBM Informix Client-SDK Version 3.50 IBM Informix Dynamic Server Version 11.5…
Nasty, unexpected cluster problem
We have a MACH11 cluster defined. It has an SDS Primary, an SDS secondary, and 2 RSSs. The SLA is defined thus: CLUSTER gcgob1_db LOCAL SLA Connections Service/Protocol Rule ob1_oltp_1 234463 ob1_oltp/onsoctcp DBSERVERS=primary ob1_obbo_1 0 ob1_obbo/onsoctcp DBSERVERS=SDS,primar…
System Administration Certification 11.70
Hi All I am working towards the getting the IBM Certified System Administrator for 11.70. I wondering what resources other than the IBM information centre were available as study material? I have found old material here for the version 11 exam here:- http://www.ibm.com/develop…
Who is using a smartblobspace
Hi! Version 11.70.FC7 Does anybody know how I can find out which tables are using a specific smartblobspace? I can tell that the space is being used but the only way I have found so far to find out who is using it is to browse all schemas and look for blob/clob declarations an…
Dbaccess display
Hey everyeone, The new default dbaccess display compacts the table names down to so few characters you can't even read the names. Is there a way to force it to go back to two columns for the display instead of three. Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org Internatio…
VB6 connection string to ids 11.5 64bit failing
Hi I have previously successfully connected VB6 to and IDS 32 bit databases. I am now on a 64 bit machine and have IDS 11.5 on this. I created a ODBC connection with success using the "IBM INORMIX ODBC DRIVER (64bit). However i cannot connect using VB6 , please see the connecti…
tuning RSS
We're bringing up some RSS servers and pushing them all to one box on smaller instances that (in the case of DR) will be moved to larger boxes not currently available. How much smaller can I make these "catcher" RSS secondaries? We've had them smaller before, but they seemed too …
HACMP issues while failing over
IDS11.50.FC9 AIX6.1 During fail over and at each reboot of the OS, Informix resolved to the= wrong IP address if we have one IP address in the same range on each interface. To correct, =A0we moved one of the IP addresses to the other interface = so both IP are on the same inter…
ER & CPU Sizing Question
Informix 11.50 or 11.70 Ultimate editions / AIX 720 platform. Client wants to implement an offsite DR site using ER one way replication. This implementation will be for DR only, no users will be allowed access to this server. The primary server has about 600+ max concurrent user…
Warning: The storage pool is out of space
Hello All, I am using the IDS 11.70 FC4, and I am not using the automatic storage pool provisioning feature. But, I have seen this message in the online.log file. I have enough free space available in the dbspaces. Can someone explain that why this warning msg has appeared an…
Warning: The storage pool is out of space
Hello All, I am using the IDS 11.70 FC4, and I am not using the automatic storage pool provisioning feature. But, I have seen this message in the online.log file. I have enough free space available in the dbspaces. Can someone explain that why this warning msg has appeared an…
Error -1215 Value exceeds limit of INTEGER precisi
Folks, IDS11.70 FC7, Linux Redhat 5 Any idea how to catch the session who caused the error in online log file? Thanks, Frank 09:39:52 Maximum server connections 348 09:39:52 Checkpoint Statistics - Avg. Txn Block Time 0.005, # Txns blocked 4, Plog used 19337, Llog used 111149…
Revoke All x Drop View
Hi folks, Does anybody here saw anything like that: I executed a routine to revoke a lot previleges and some of my views simply desapeared? Is it possible ? If yes, when ? Thanks a lot, André Luiz Rufino…
Option for audit logging new sessions
We have a need to log all created sessions (successful logins only) to an external file (session id, date/time, hostname, username, etc). Is there an audit log configuration somewhere that we can use to do this? Thanks -Justin…
Drop Views x Revoke
Hi folks, Does anybody here saw anything like that: I executed a routine to revoke a lot previleges and some of my views simply desapeared? Is it possible ? If yes, when ? Thanks a lot, André Luiz Rufino…
Remote database connection failed
Hi All, I have modified /etc/services and /etc/sqlhost file pointing to the instance and try to access through application but gives error to connect. Any suggestion or advise on this cat /users/wksogrp/cm172895/cmt001_err_17150_cm172895_whx003n.log The following diagnostic inf…
Performance Impact after storage migration
Hello All, IDS 11.50.FC8W2 on HP-UX B.11.31 U ia64 Recently we have upgraded our storage and the hp boxes and since then we see intermittent performance issues. onstat -g ckp AUTO_CKPTS=On RTO_SERVER_RESTART=180 seconds Estimated recovery time 1304 seconds We observed that th…
CDR_LOG_LAG_ACTION shutdown issues
Hello, I have an Enterprise Replication setup in a lab environment, and I am specifically testing to see if setting CDR_LOG_LAG_ACTION to shutdown will turn off replication when the replay position is in danger of being overrun. I have three 256MB logical log files, and I pulled…
ixbar file info vs netbackup savesets
Hello! Two things: First, does anyone have an explanation for the ixbar file columns in 11.50.FC7? There are 21 columns on this version, and I only know the description detailed here in the IIUG (http://www.iiug.org/onbar/ixbar.html). And does any one know how to cross reference …
slow response loading table for spatial db
Calling spatial db experts please ! IBM Informix Dynamic Server Version 11.50.UC9 OS Name Linux OS Release 2.6.18-308.el5 OS Node Name hvgreyst25 OS Version #1 SMP Fri Jan 27 17:17:51 EST 2012 OS Machine x86_64 arcCatalogue 10 loading shape files the db is buffered. Wriing dat…
Re: btscanner running v/s ready
Thank you Jack. Yes. I have to wait till they decide to upgrade to 11.5/11.7. I did see my other linux server with IDS 11.7 it does show the info. you provided. Thank you for your help.…
Re: btscanner running v/s ready
10? 10 is eol last time I checked. j. On Oct 7, 2013, at 3:25 PM, John Miller iii <miller3@us.ibm.com> wrote: > If you are really interested in how many times it has run and for how = long=20 > it has run on the CPU VPs then=20 > take a look at onstat -g cpu | grep btscanner. …
long transaction - raw table
IDS 11.70.fc3xc Aix 6.1 I have a large table that I'm trying to load ... about 1.8B rows ... the table has no indexes ... is fragmented over 44 dbspaces ... altered to raw .. While trying to insert into the table ... insert into table_1 select * from database2@instance2:table_…
btscanner running v/s ready
Hi, Where could I find info on "btscanner 0" seen on the "onstat -g act" and "onstat -g rea" output. I would like to know more info and the difference, correlation as to when it becomes ready and when it becomes running. === IBM Informix Dynamic Server Version 9.40.FC3 -- On-L…
Informix server installation
Dear All, Why informix installation using root id on the UNIX server? Is there reason for this? Thank you very much --001a11c3799c540ad704e82852d4…
The server did not respond within 5 seconds
All, We are getting following message while running onstat command. "The server did not respond within 5 seconds. Timing out." We are running IDS 11.50FC8W3 on SUN OS on T5140 server. can any one help me to resolving this issue. Thanks in advance.…
Fw: archecker
Aix 6.1 IDS 11.70.fc3xc I'm trying to use archecker to restore a 2 billion row table ... below is the ac_schema file I'm using. The table is fragmented ... this sql is from a dbschema ... without the extent info ... I'm getting a syntax error at line 26 column 24, which is the f…
matches and like
I am using IDS 11.50 and just noticed an odd thing with matches and like. Querying a table with a character field containing values shorter than the field length like "xxxx " will not match matches "* *" or match like "% %". They will match "* " and "% " though. Might this be a b…
Informix ODBC Error: Read error occured during con
We have Informix 12.10 installed on RHEL 6. ODBC connection is configured on Windows 2003 using IIS6. On our webpages we are getting "Read error occured during connection attempt". Everything works fine on the RHEL server where we have hosted a php application on Apache. During…
stopping a server dynamically
Hi to all, I have the ids server with two names (a servername and an alias). Each one.is. reachable via a different network. I want to know if there is a way to stop the the alias dynamically without stopping the whole server . I use informix 11.50 ultimate edition on aix 5.3 Th…
Timeseries AggregateRange
IDS 12.1.xc1 When using the AggregateRange function, it returns a row (as noted in the documentation). However, I would like to return in tabular format. It appears that this does not work. It looks as if the return value of AggregateRange is not a row. e.g. select AggregateR…
Logical logs - push or pull?
Good morning folks, We have implemented On-Bar with the CommVault Simpana storage manager (love it so far!). I'm wondering if there is any advantage either way to a) letting Informix backup the logical logs through ALARMPROGRAM (push) or b) scheduling periodic logical log backup…
ER queue data
Folks, IDS11.70 FC7, RedHat Linux 5 These days, we are really struggling with Informix ER replication, it just queues data there ( see below, a three site replication Anywhere). The problem started after we upgraded from IDS11.50 FC8 . We were happy with IDS11.50 FC8 and had n…
Message Log Verbosity
Hello, We recently upgraded to Informix 11.70.FC7W2 (from 11.50). Every time we kill a session we now get a line in the message log as shown below. Is there any way to tweak what messages get logged? We have a background process that kills idle sessions so these messages are clu…
Archive - Restore
Hi Folks. Dummy question. May I restore a archive that was made in 11.5 FC9WE to a 11.5 FC9DE 64 ? Thanks, André…
Software for Informix DBA
All, I planned to study DBA stuff for Informix software.Which edition from below list I need to download.I can use Windows 86 bit or Linux 32 bit environment. Please help. Informix Developer Edition (no-charge database) Informix Innovator-C Edition (no-charge database) Inform…
Software download for Informix DBA
All, I planned to study DBA stuff for Informix software.Which edition from below list I need to download.I can use Windows 86 bit or Linux 32 bit environment. Informix Developer Edition (no-charge database) Informix Innovator-C Edition (no-charge database) Informix Enterprise…
Can't create table or database but no error shows
Hello, I have problem with our informix installation (on Windows 2008 R2 machine). When I try to create table inside existing database (by SQL query) nothing happends When I try to create database in existing dbspace (bySQL query) nothing happedns By "nothing happends" i mean t…
Problem while Performing a Logical Restore?
Hello All, I am testing a scenario of logical recovery of HDR-secondary using IDS 11.70 FC7. I have taken the backup using "ontape" from primary server and restored it on secondary DB server using "ontape". Please note that primary is confugred for automatice logs backup using…
Slow Response in INNER query
Hello everyone, We are using Informix 10 UC5 on AIX 5.3 and facing following issue: ################################################################################ ############### ## QUERY-1 - BELOW QUERY TAKES 4 MINUTES TO EXECUTES WHEN TABLE2 CONTAINS ONLY SINGLE RECORD #####…
Why codeset conversion peroformed when DB_LOCALE=C
When I connect the application to the Database server with the settings as DB_LOCALE=CLIENT_LOCALE=en_us.utf8 and do the record insertion, it showed the error message "Invalid byte in codset conversion input". According to manuals, when DB_LOCALE=CLIENT_LOCALE on the client side,…
Testing (2)
Please ignore - test e-mail ________________________________ NOTE: This e-mail message is subject to the MTN Group disclaimer see http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx…
stopping a server dynamically
Hi to all, I have the ids server with two names (a servername and an alias). Each one.is. reachable via a different network. I want to know if there is a way to stop the the alias dynamically without stopping the whole server . I use informix 11.50 ultimate edition on aix 5.3 Th…
Installation question
Hi, Folks, Assume we have a bunch of boxes with exactly identical hardware and software( same Linux OS, same every thing...). Solution 1: Give s fresh installation on each box( run ids_install on each box) Solution2: run ids_install on only ONE box, then Tar the installed $I…
RSS Feed Formatting
Sorry for the off-topic post, but I haven't seen any other good ways to ask about this. The content of this forum is amazingly useful and I want to follow all the discussions using the RSS feed, but I cannot get the formatting to display properly. Even when I view the feed conte…
IDS install failing
I am trying to install IDS 7.11 FC5 on an AIX server *****:/usr/informix/SERVER/doc#> uname -a AIX ***** 1 6 00CA27A04C00 But if fails right at the beginning. At first I was missing 2 libraries, but they are now installed: *****:/usr/informix/SERVER/doc#> lslpp -L bos.adt.incl…
onstat -g nif
Folks, What might be the possibilities that will generate "RUN,BLOCK " in the State column of the output? We have significant ER data replication slowness issue... Thanks, Frank onstat -g nif IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line -- Up 09:53:53 -- 8359540 …
onbar -v
IDS 11.50FC6 on AIX 5.3. I've taken over management of a newly-migrated system. It's not that big, perhaps 300GB distributed across a bumper 106 dbspaces. It's backed up with onbar using Netbackup. A level 0 takes about an hour. We're required to run a "verify". This is taking…
Connection Manager - Automated Failover
I am in the middle of stress tests against a HDR pair (Primary + Updateable). I took down the primary and waited for CM to start the automated failover; it didn't. CM said "Arbitrator detected majority of secondarys are still connected." Please note that I had already tested the …
how stop jre unpack
This concerns IBM Informix Dynamic Server Version 12.10.TC1IE on Window Server 2008R2 . The windows event logs show this several times a day. Activation context generation failed for "c:\\\\informix\\\\jre\\\\jre\\\\bin\\\\unpack.dll".Error in manifest or policy file "c:\\\\info…
if there is any way we can trace or log CSDK calls
IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number AAA#B000000 IBM/Informix-Client SDK Version 3.50.FC9 if there is any way we can trace or log CSDK calls. We are getting -25582 & -404 errors returned from the CSDK to DBD::Informix (Perl) but tcpdump shows ther…
Re: sqlca.sqlerrd [31509]
OK, if sqlca.sqlerrd[2] is zero then no rows were updated. By ANSI Standard rules, it is not an error to update zero rows nor to delete zero rows so this is the only way to know that your update didn't do anything - check the count in sqlca.sqlerrd[2] to see if the number of rows…
sqlca.sqlerrd[2]
HI, a customer write a multithread application to update some record in the same table, per thread update some records. they found the update sql execute successful.bu the sqlca.sqlerrd[2] (row) is zero . why? if they justly ran only one update sql ,the sqlca.sqlerrd[2] (row) is…
How to know Informix Server Name
Hello friends: I have a question!!! I have a machine with SCO Linux. This server have installed Informix Standard Engine 4.1, but i don't know informix server name. I've seen the cofiguration files but all are incorrect and INFORMIXSEVER too. Is there any way to know this name…
placing tables in db based on user login
IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number AAA#B000000 we are using dbmoto to transfer data to sequal server. Dbmoto creates tables in the dbspace where the db is created. We cant configure dbmoto to create tables in space of our choice Is there a way i…
Trusted host file (/etc/hosts.equiv) cache marked
Folks, DIS11.70FC7 with ER replication, Redhat Linux 5 Any comments on the follwoing error in log? Thanks, Frank 19:36:41 WARNING: mt_aio_wait: errno == EINVAL 19:36:41 Error : Trusted host file (/etc/hosts.equiv) cannot be opened for caching. 19:36:41 Error : Trusted host fi…
informix: 503 too many tables locked
Hi everyone! since couple of days one of our applications has started to recive this error message. The only information I could find about this error is that Informix user has a hard coded limit of the number of tables he/she can lock. It is 32 tables. Is it really so? Can we s…
CSDK 4.10.TC2 non developer edition
This might be a stupid question, but I can't seem to find a CSDK download for 4.10.xC2 that isn't marked as development edition. Is there such a thing as a non-developer version, and if so, what are the differences between the two? I'm looking for a package to deploy to end users…
Blobspace Logging
IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number AAA#B000000 I am looking for some clarification on Blobspace Logging. I find thus in man pages The database server logs blobspace data, but the data does not pass through either shared memory or the logical-log…
is there sys table where index names kept
IBM Informix Dynamic Server Version 11.50.UC9 Software Serial Number AAA#B00000 is there are table where index names are kept. in the sysmaster db or anywjhere else…
spin locks
This is the output of onstat g spi . What is po_lock below? Do the numbers look high or is it not possible to answer without more info ? This is on Windows server 2008 R2 SP1. IBM Informix Dynamic Server Version 12.10.TC1IE -- On-Line -- Up 09:04:41 -- 733952 Kbytes Spin locks …
12.10.xC2: MongoDB compatibility
Anyone using or investigating MongoDB? -bash-3.2$ mongo --nodb MongoDB shell version: 2.4.6 > db_mongo = connect("localhost:50000/test") connecting to: localhost:50000/test test > db_informix = connect("localhost:27017/stores") connecting to: localhost:27017/stores stores > db_m…
Blocked Check point
I am running informix 11.70.FC5 on AIX 6.1 and am experiencing a blocked checkpoint There are plenty of logs available and the current log file is not full. We do not have transaction loggin switched on for the database and so there is no long transactions Nothing out of the o…
partitioning performance
IDS 11.70.fc3xc Aix 6.1 Having to rework some fragmentation that was designed several years ago .. and had a question .... in a fragment by expression clause...arethe following going to perform the same ... fragment by expression transaction_date between '01/01/2014' and '01/15…
syslock on missing session
All, I have a table in which I can insert and select, but can't delete or update. I have run this statement, which I use to detected hung sessions (usually a transaction that gets stuck open for some reason): select ss.sid, ss.username, ss.hostname, ss.tty, trim(dbsname), trim(…
error syscdcv1 CDC_ERROR_CODE = -83717
Machine Configuration.... OS Name Linux OS Release 2.6.18-348.12.1.el5 OS Node Name wldbt635 OS Version #1 SMP Mon Jul 1 17:54:12 EDT 2013 OS Machine x86_64 IBM Informix Dynamic Server Version 11.50.UC9 Software Serial Number AAA#B000000 we are using a product dbmoto to connect…
system table to keep track of dependent views?
Hi All, I am trying to find the list of dependent objects used in the views. So can someone share the query or procedure which will list all the dependent objects used in the body of the views? Or if there exists any system table, then kindly let me know. I am using IDS 11.70 …
Cannot insert the utf8 data into database
I have created the database of DB_LOCALE = en_us.utf8 on the AIX system. My DB is informix dynamic server 10.00.FC5. My job is to convert the Big5 tables of a old database into a new database of UTF8. I used the c# program to convert the Big5 chinese characters into unicode (UT…
How to know if a session is hanged already?
Hi All, IDS9.4 OS=Solaris I just want to ask how can i know if a certain session already hanged? I'm seeing just : 7924171 sqlexec 9651b320 Y--P--- 2264 cond wait(netnorm) 7924168 sqlexec a4059ff0 Y--P--- 2264 cond wait(netnorm) 7924166 sqlexec 991169f8 Y--P--- 2264 cond wait(n…
distributed query & blob
IDS 11.50.FC8 , IBM INFORMIX-4GL Version 7.50.FC3X4 Q. getting the following error trying to retrieve a blob data type from an external informix logged database. fglrun testnetimage.42m Program stopped at 'testnetimage.4gl', line number 29. SQL statement error number -9270. Typ…
alter fragment attach ...
ids 11.70.fc3xc aix 6.1 Looking to move some fragmented tables around .. and before figuring out exactly what we are doing I was doing a simple test with detach and attach .. So, here is my question ... I have a table fragmented over 40 periods ... Took the indexes off the tabl…
when use IfxDataReader.GetIfxDateTime to NULL valu
When use IfxDataReader.GetIfxDateTime method to read a NULL value field, it showed the error message "specified cast not valid" something like that. What should I do ? Use IfxDataReader["field name"].ToString() to check the length of the field before, and then, if = 0, set null…
Invalid byte in codeset conversion input
When I insert the string (which is converted to UTF8 from Big5) into the database (DB_LOCALE on the server side =en_us.UTF8), it showed the error message "Invalid byte in codeset conversion input". In fact, there is one character not in unicode in the string. The DB_LOCALE and C…
How to get list of onbar backups using TSM
Dear All, I am new to TSM, I have configured the Informix DB server which backups to TSM using Onbar. The backups are working fine as show in the onbar log. Now, I need to get a list of all succesfull backups for this server, so that I could select the appropriate backup for re…
not enough free disk to restore
Hi to all I don t have enoygh space to put my l0 and l1 to restore a production instance on a test machine, i can compress lo and li files, so they can fit in this space but is the a war to decompress these files and restore the instance Thans in advance…
not enough free disk to restore
Hi to all I don t have enoygh space to put my l0 and l1 to restore a production instance on a test machine, i can compress lo and li files, so they can fit in this space but is the a war to decompress these files and restore the instance Thans in advance…
Parsing XML in IDS
We are using IDS 11.50 on AIX and have a table that is defined as follows: CREATE TABLE xpath_test ( id SMALLINT NOT NULL, xml_string clob ); The id column is the PK. The other column contains the xml document. id 1 xml_string <?xml version="1.0"?> <?xml-stylesheet type="tex…
character_length for utf8
We are working on utf8 characters and using following test case to find number of characters or string length: create table test(col varchar(50)); select col, length(col), character_length(col), substr(col,1,3), substr(col,1,1), col[1,3] from test; 南大街 9 9 …
standalone dbaccess
Does anyone know if you can install a standalone dbaccess? or how to do it? I've been messing with this for two days now and the only thing I get is Unknown error message 32370. Thanks, Nate…
Re: Error building 'sysmaster' database
Yes, I already set necessary environment variables and source them before I run oninit command. setenv INFORMIXDIR /usr/informix1 setenv INFORMIXSERVER lvhoan setenv ONCONFIG onconfig_lvhoan setenv INFORMIXSQLHOSTS ${INFORMIXDIR}/etc/sqlhosts_lvhoan setenv LD_LIBRARY_PATH ${LD_L…
Error building 'sysmaster' database
Hello everyone, I am a new user with informix. I am trying to configure and initialize informix server. But I have the error with "oninit -ivy" command. The message in online logs as the following: 17:31:16 Error building 'sysmaster' database. 17:31:16 See '/tmp/buildsmi.26451'…
Awful Trip
Hi, I'm writing this with tears in my eyes,my family and I came down here to Manila, Philippines for a short vacation. unfortunately,we were mugged at the park of the hotel where we stayed,all cash, credit card and cell phone were stolen off us but luckily for us we still have ou…
CPUs spike
Hi all, We have IDS 11.50.FC8GE runs in HP-UX 11.11. The server has four CPUs and it has been running quite well for the last few years. The server has only IDS installed and nothing else. Few days ago, users reported that they are having performance issue. We look around in the …
locked mutexes!
Hi, I had some user sessions in locked mutexes onstat -g lmx Locked mutexes: 8777 c00000019a5c0f30 uselock0 2708810 0 8778 c00000019a619f30 uselock1 1683484 0 8779 c00000019a620f30 uselock2 2708811 0 I was able to trace those sessions using holder thread id and they were doing…
table being reported as not present by application
achine Configuration.... OS Name Linux OS Release 2.6.32-358.6.2.el6.x86_64 OS Node Name wldbp654 OS Version #1 SMP Tue May 14 15:48:21 EDT 2013 OS Machine x86_64 IBM Informix Dynamic Server Version 11.50.FC9 S The probem Since Migrating from Unix to Linux we are getting lots of…
client process arguments
Hi everybody, Do you know how to get client process's arguments from any sysmaster table? sysmaster:syssessions.peprogram only tells the client process name, but not its arguements. Here you have an example: In this case client process name is /.../.../fglgo. (Does not show i…
delimiter
IDS 11.70.fc3xc aix 6.1 I know a question very similar was asked about this the other day .. but I don't recall seeing the answer .. Here is my situation .. using external tables to unload a bunch of data via a pipe to the 'nzload' utility of Netezza. The issue is that I have th…
Update Statistics Problem
Hi, We have a installation in a client that have many databases, these databases have the origin in a Informix SE, v 2.10 ¿?, more than 20 years ago, we have migrated S.O. and Informix several times in this time... From SE we migrate to Online 9.40.UCx with dbexport/dbimport, th…
ODBC Driver for a Win32 App on a Windows7 64 Bit
Hi to all, I Have an old legacy win32 application than uses ODBC driver for conecting to informix server. Now I have several Windows7 64 bit workstations and I have not been able to configure the connection for my old application. I tried with clientsdk.4.10.TC1IDE, clientsdk.3…
logical logs not being read by ontape or onbar
Informix v10.00.FC10 Sun solaris 5.10 I have an instance where neither ontape or onbar appears to read the logical logs when trying to do a logical log backup to Netbackup in the case of onbar or to a file system in the case of ontape. Any ideas why? Please don´t comment about t…
sysdistrib question
I'm looking at sysdistrib to see when to run stats(using dostats Thanks Art ;)) and I was going to key it off of the nupdates, ninserts, ndeletes columns. I don't think they are what I though they were though. The numbers don't match up to be the actual number of each since the t…
Problem with ER replication
All, Informix V11.70.FC2 Sun Solaris 5.10 I have an ER environment with 11 instances involved. 10 instances feed 1 instance. The 10 instances are on one machine and the 11th on another. Last night the main source instance ( and the notional master instance ) was taken offline. …
out of shared memory?
HPUX 11.31 HP BL870c integer server 24GB memeory Informix 11.70.FC4 Starting about two weeks ago we are getting out of memory errors from time to time. Up until the problem start the config file was not changed for about a year. Twice we have gotten af files from this. We get t…
Unload via OpenAdmin Task Scheduler
Is it possible to unload an Informix table using the OpenAdmin Task Scheduler? I have created a task with the execution statement as unload to Turret_DnB_Table.txt delimiter "|" select sales_off from livturdb:turret_ar_dnb_table; Thank you John…
Block Size
Hi, We are running Informix 11.50.FC6 on Solaris 10. We are testing a new flash array storage solution. They are telling us we will get best performance if we do our DB writes in 4k block sizes. Is there any way in Informix to define the block sizes? If I understand correctly, t…
IDS 9.4 taking time to shutdown
Hi All, I would like to ask about why IDS 9.4UC6 is taking time to shutdown. It's has replication. When i perform a restart of the primary it takes me 1 to 1.5 hours to shutdown the primary database. onmode -c; >>>>> This takes a lot, 1 hour. onmode -ky; >>>> kill and yes to al…
repack
In IDS11.5 , I want to to do reorg. if a table has 2 extent,Do repack can reduce the extent to 1? thanks for your time.…