Oninit® Archive
Results for “HA_FOC_ORDER”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
Re: Senior Oracle DBA now Learning Informix by Request
Obnoxio The Clown wrote: > DA Morgan said: > >> Best selling (may be the result of) Best quality. > > Well, as a theoretical possibility, sure. But give me five examples of > where the market leader is demonstrably and unequivocally also the best > quality. > >> How one defines q…
deleting rows physical
Art S. Kagel wrote: > > goermet wrote: > > > > I had think so, but it isn't so in the reality > > > > goermet > > > > WF Software schrieb in Nachricht ... > > >In article <76oegi$pci$1@news.online.de>, goermet@online.de (online) > > >wrote: > > > > > >> I have following problem: …
Created raw table in Perl program but it vanished when I exit program
Greetings y'all. This is a big mystery for me and I hope there are enough users of the Perl DBI::Informix module to recognize this problem. Consider this code in a Perl variable: create raw table $wtab_name as select date(ins_dtime) ins_date, hex(rowid) row_address from $target_t…
Connection Manager - spelling of DISABLED not checked for FOC
Just saying … spell DISABLED wrong under FOC and nothing reported BUT failover can be performed by CM … and lo - two headed PRI. Having two CMs in failover for two clusters and they seem real flaky on startup as regards consistent behaviour (I.e. sometimes works, sometimes doesn'…
DRDA redirection to HDR primary
I was recently unable to work out how to do this directly on latest IDS 14.10. I am about to write a technical article on a work-around using Connection Manager, but that involves more effort and failure points. Does anyone know how to construct a DRDA client configuration so tha…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Question of dostats
Yes. Many dostats rune used two connections egging you cannot do over a shared memory connection. There is an option to use a shared memory connection but then you can only process one database per run. Art ------------------------------ Art S. Kagel, President and Principal Con…
Updated utils2_ak package available
Woops, sorry, you can always find the latest release of my utilities on my web site, free to download and use, at: My Utilities ASK Database Management remove preview My Utilities Utils2_ak is my primary package of utilities. This is the November 24, 2023 release. Included: dbpin…
Informix HA Cluster and CM
The cluster is an Informix concept, nothing to do with Linux clusters. The connection manager will connect to each server in the Informix cluster and determine it's role Primary.SDS,HDR,RSS One connection manager will be the "Active Arbitrator" and if it cannot contact the primar…
onstat -g ses returns "Changing data structure forced command termination"
David: I don't know the APAR. It happens with even a single client connection that has executed no SQL at all. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
Manual Switch Primary , Secondary while RSS exist
Hi I have a client running IBM Informix 12.14 in RedHat 7.6. They have IDS Primary & IDs Secondary in HQ Data Centre while IDS RSS in DRC Data Centre. I didnt setup Control Manager. All this while I'm using manual via onmode command. I always refer Art Kagel document how to sw…
Update to utils2_ak
Yes, you can always download the latest utils2_ak from my web site at: My Utilities I uploaded an update that included a fix to a very old bug in dostats_ng.ec and new features in dostats_ng.ec and myschema on Dec. 21. ASK Database Management remove preview My Utilities Included:…
HDR shutdown and Restart
Just a side issue: You should ONLY use DRAUTO set to 2 if the network connection between the primary and secondary is ABSOLUTELY reliable to avoid the possibility of suffering from the "two brain problem". It is better to use Connection Manager to handle upgrading a secondary aut…
Things That Should Never Happen
Already done. The connected CMs also dropped out during that window, but did NOT initiate a failover, even though failover was enabled. ------------------------------ TOM GIRSCH ------------------------------…
NETTYPE connections per thread
Keeping in mind that the number of connections is auto-expanding, and also my other notes from your previous post/question, if you approach or surpass the efficiency zone (500-700 active connections per listener), responsiveness to user requests will seem to be slow although once…
Automated HDR/RSS Failover
Good Morning Informixland, IDS 12.10.FC9AEE AIX 7.2 We typically have failover exercises between data centers and I have a set of manual procedures that work quite well (saving the secondarieshowever it is time to automate. I amwondering if anyone else has done this and how. The…
Connection Manager using SSL
I am trying to connect connection manager (conman1) to the IDS (mambaps) using SSL. I have configured the IDS correctly and tested through dbaccess from the connection manager server and from a windows machine with ODBC and it connects with no problems. My issue is when I try to …
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Connection Manager Redundancy with DRDA Connection
I have two Connection managers configured with two SLA entries using REDIRECT, one for the native SQLI connection (onsoctcp) and one for DRDA connection (drsoctcp) connection to just on IDS for testing. Everything looks good between the connection managers and the IDS. When I tes…
Update to utils2_ak
I have uploaded a new release of my utils2_ak package to my web site at: My Utilities ASK Database Management remove preview My Utilities Included: myexport - Drop in replacement for dbexport dbping.ec - Tests connections and reports connection time as well as the actual host and…
configure sds with raw device
Hello Alexandre, Thank you for your reply. As you mentioned, we will only use the SDS node for failover purposes. And now the storage used by Informix is only made up of raw devices and it is difficult to migrate to the cluster file system. We also do not have a license for so…
Connection Managers not forwarding connections
Hi, We had an upgrade for the whole informix cluster and after bringing up all the servers , couldn't resync HDR with primary because it was always causing checkpoint blocked on the primary. Afterwards, I noticed that the connection managers aren't forwarding traffic, restarted t…
IBM Data Server Provider for .NET HDR Failover
We are using the IBM Data Server Provider for .NET with our Windows client applications and are trying to configure it to use the Connection Manager to handle auto fail-over when our primary goes down. With the Informix .Net Provider one may configure a fail-over server group na…
Connection MAnager error
Hi, I am trying to create one connection manager with ClientSDK 4.10.FC10 and using one primary and one RSS, but I am having some errors 4001 and 1002 when I try to start it: ALARM 4001 unable to connect to Informix server srvinfx12_net from srvifxcm error -951 ALARM 1002 Error…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Starting Connection Manager fails
Change INFORMIXSERVER in the CM configuration file (cmsm.cfg) from "dbservers" to "dbserv_g" the group defining the two actual servers. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Dis…
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…
Connection Manager for HDR in Windows server
Thanks Mr.Art But still little confusion. On the host of each client application, create an sqlhosts file entry for each service-level agreement (SLA) in each Connection Manager configuration file. My SLA is sla_1, which is configured in the connection manager cmsm.cfg file. n…
Differentiate OLTP&OLAP from 1 Application Server
That's ok fine. I will pass separate data source links to application if i have not used the connection manager But I want to use Connection Manager to both database servers for automatic failover. we need to create a cluster group for both database servers and supply the cluste…
Rebuid sysmaster database and effects in a HDR/RSS
HDR set is successfully done. Thanks for your support. Now I need to configure Connection Manager for automatic failover process. I gone through all IBM websites. but tough to understand. Could any one help me on this. only between two servers. Primary and secondary…
Connection Manager configuration
Hi All, I implemented High availability data replication (HDR) on my two dedicated servers. They are working fine. Presently they are configured as manual switchover. Now we want to make this a automatic failover. I had searched in goolge and finally came to know that is Connect…
Automatic Failure in HDR Setup
Thanks for your response. Is there any other than cmsm.cfg.sample to configure for automatic failover.…
sqlhosts file
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } I wouldn't use a shared memory connection because of the issues that it will cause if a failover is required. Clie…
Switching Primary and Secondary with CM's
R Mchael,You may not need to bring down CM and apps at all if you set it up this way. Pay attention to 3 configuration files: onconfig, sqlhosts, your_cmconfigfile.cfg (both primary and secondary should be almost identical anyway). * The onconfig files should have: Primary's onco…
Switching HDR / Primary
Hello. I would also use the steps suggested by Art Kagel, in case of manual failover. Please be aware that 11.70.xC8 (your next release) has several APARs related to high availability features, so I would also recommend you to check them first, possibly avoiding any cluster mal…
dbexport on RSS Secondary
Im running IDS 12.10.FC6 on SLES 11 SP 4 with a primary and RSS secondary on separate boxes. At http://www.oninit.com/presentations/v117.pdf I see the following: Enhancements To Dbschema, Dbexport & Dbimport It is now possible to use the dbschema and dbimport utilities on all …
DRDA issue via Connection manager
Hi Gurus, Need help in coniguring the Connection Managers using DRDA. We've already setup but it's failing. Can someone please analyze the below configuration we used? Client sqlhosts configuration ====================== # INFORMIXSERVER ifx_cluster group - - i=10,e=svru2bqaqt…
Re: jdbc connect to cluster
Thanks a lot, I managed to configure it. Another question related to this. I created a group made of 2 connection managers. Is there a way to control the fail over of one of the conection managers in the group so that people connecting to it won't end in the cm that is down?.…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
connection Manager
Hi All How exactly connection manager works with ? Can anyone help me configure connection manager, I have heard that it has some bugs, is this so? Thanks Jaya…
HDR,RSS and ER
Hello all, I will be implementing ER in the very near future and have an ok grasp on the basics I think. The current setup is with a Primary Node, a Secondary node running an HDR instance, and a Tertiary Node running RSS. The ER configuration will be from the Primary node to the …
Setting up SDS cluster
Flip: I do not see the actual servers in the SQLHOSTS entries you specified, they have to be there. Are they missing or did you just not copy them in? Also there has to be some reference to the actual server names somewhere in the the cm.cfg either by name or by using a group na…
Informix temp spaces
Hi Vladimir, If you have RSS servers: For HDR, RSS, and SDS secondary servers in a high-availability cluster, logical logging on temporary tables should always be disabled by setting the TEMPTAB_NOLOG configuration parameter to 1. So, you can remove last 4 temporary dbspaces w…
Connection Manager
Started Connection Manager successfully. It is pointing to 2 servers (Primary/Secondary HDR). I log into the secondary server and run 'onstat -g cmsm'. It shows me the connection manager name/version, cluster name, even failover arbitrator/order/timeout details. It completely lea…
SQLHOSTS for HDR
What are the benefits to defining groups in sqlhosts for an HDR pair? I have had some issues with multiple instances (each with an HDR secondary on a separate server) where I left the group definitions out and came across some unexpected behavior when dealing with failover. After…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Connection Manager - Sessions Terminate Abnormally
3 Informix instances setup on a HDR pair w/Connection Manager. When I shutdown Connection Manager, I look at the database online logs and see some of the instances successfully de-registering from Connection Manager; whereas others terminate abnormally. What factors would cause t…
HDR & Connection Manager
Informix 11.7 FC7, CSDK 3.70 FC7 I have a HDR pair with 3 instances setup with Connection Manager. Primary/HDR run on separate Linux boxes; as well as Connection Manager. I triggered a failover and all 3 instances on the primary were failed over to the HDR server, now the new-Pri…
Informix on HP MoonShot
When HP announced its new ARM32 and ARM64 based Moonshot micro-server yesterday there was only one commercial database that already supported the platform: IBM Informix. Today there still is only one. Imagine running your relational or JSON collection database on a server built …
Informix/Oracle
I think it's clear that these are just made up reasons that might work on less clued-up customers or ones who favour Oracle in any case. It's FUD. A quick google found this roadmap presentation for VNext+ and VNext++. http://www.informix.nu/pagang/Informix_v12_1_Highlights-RoadM…
Adding a Chunk in a Cluster
A failover cluster as in only one is online at a time and the disks it will look at at failover time are mirrored from one system to the other using disk or SAN level mirroring? That should work. Honestly, I trust Informix HDR far more than any disk mirror based failover cluster…
Swapping HDR
Hello, Walter. DRAUTO should be used only for automatic failover purposes, without CM. If you have a CM, or you don´t have (like my actual environment) a full high availability environment, it is recommended to do a manual failover (hdrmk* scripts). I have a secondary site for c…
Recommended log rotation setup for online.log and
Hi, I'd like to do daily rotations our online log and our connection manager log. I noticed that there is a task name 'online_log_rotate' that will manage the online log, but I don't see one for managing the connection manager log. I'd like to avoid having multiple log rotation …
upgrading 11.70 to 12.10
================================================================================ == ================================================================================ == Link - http://www.ibm.com/developerworks/data/library/techarticle/dm-1304overview/ Migration to Informix 12.10 …
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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 : …
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…
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…
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, …
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…
VB6 connection string to ids 11.5 64bit failing
Thanks - but when i go to control panel:Admin Tools : Data Sources , l can see the DSN within the 'system DSN' tab. And the connection is successful. By the way : the error message is run-time error '-2147467259 (80004005') Microsoft [ODBC driver manager] data source name not …
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 …
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
SLA Not Working with Kerberos Enabled Service
Dear All, I am running the Informix IDS 11.70 FC4 at AIX 64-bit OS. I have a connection manager, in which I wanted to configure an SLA which should use the DBSERVERALIAS, which is configured with kerberos authentication. My connection manager and DB server are running on the s…
How to connect Java/JDBC with Connection Manager
OK, so, oltp doesn't have a port because it is a group entry. You can define a group in the PC's registry and define an OLTP DSN on it, so you may be able to use JDBC using a DSN, but I do not know how to connect to a group using a JDBC connection string describing the connection…
Replication with multiple network interfaces
The ER connection should be the only thing in the ER group - if you wa= nt to restrict the connections that ER is to use. Generally the only time that it makes sense to have multiple entries in= the ER group is for failover. The ER port on the secondary servers should = be in th…
connection manager SLA point to DBALIAS not workin
http://www-01.ibm.com/support/docview.wss?uid=swg21635513 a technote for Configuring the Connection Manager for PAM Authentication Thanks…
windows odbc connection to connection manager grou
I have 3 connection manager (Linux) instances whose SLA's are in a group in sqlhosts (group option c=1). When I run dbaccess on any of those machines, the SLA group is listed as an option, and I can connect to the group (it will round-robin my connection to one of the connection …
redundant connection manager configuration using H
I'm looking specifically at a MACH11 cluster. So then, if I was to just make things simple and do this: SLA cm_sla1 DBSERVERS=(RSS,primary,HDR) Then the HQ connection manager would realize that the RSS is high latency and avoid giving it out, and the remote site connection man…
cmsm in a cluster + switchover? DRAUTO=1+3 ???
Hello. He have a cluster, version 11.50 (plans to upgrade soon) with one primary, one SDS, and one HDR. I have a simple question, but didn´t find the answer yet, so maybe someone could help me. If I enable DRAUTO=1, I can easily see the changes rolling from hdr secondary to pri…
connection redirection with HDR secondary
Ok, for automatically client redirect connection, you should use Connection Manager. You should use DRAUTO=3, instead, after configuring connection manager rules. Connection Manager is bundled into CSDK, in newer versions (3.70+). Check this page for further examples (11.50, bu…
Connection Manager setup (Windoze)
We are trying to setup the CM on a windows server and are getting errors returned in the log : 14:18:24 Connection Manager name is tms_primarycm1 14:18:24 Starting Connection Manager... 14:18:24 Get server smart_grid information failed, Connection Manager stopped 14:18:24 Error …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Using ifxclone to setup HDR
Thanks Madison, so what I did was correct. A big thanks to IBM for coming up with this feature. I am trying to setup Connection Manager in our environment for one production database server which has HDR and RSS. Is there any guidelines/best practices from IBM for setting up Co…
Effect of SAN-level replication on Informix
Does anyone have experience with SAN-level replication and its effect on Informix, especially with respect to disaster recovery/restore? We're examining different redundancy schemes of our environment across a WAN using Redhat Linux 4/5/6, Hitachi SANs, VMware and Informix (and …
CM not obeying FOC
Hi All, I am building a prototype of Informix Cluster with a primary node and a HDR secondary initially, using connection manager. On connection manager machine (ar-prdwhm01), I export INFORMIXSERVER=auf_prep_odb and then starts connection manager (oncmsm -c cmconfig). Connecti…
client connection to a multi connection manager sy
Fernando: This is a link to the IBM Technote article that explains how to make a windows client PC aware of a group entry for failover between two connection managers or servers: http://www-01.ibm.com/support/docview.wss?uid=swg21447622 Art Art S. Kagel Advanced DataTools (ww…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
Connection manager resilience
I'm trying to set up a group of Connection Managers. On the Connection Manager server sqlhosts looks like this: # Underlying Instance Connections idsmach1db_app group - - i=1 idsmach1db1_app onsoctcp idsmach1db1 idsmach1db1_app g=idsmach1db_app idsmach1db2_app onsoctcp idsmach1…
Failover setup
We have production databases, informix 11.10.FC2 on SLES 10, currently w/o failover servers. We are deciding upon the type of failover setup (HDR/ER) to be set for these servers. Some databases are in "no logging" mode (due to business requirements) while some are using blobspace…
dotnet and connection manager
HI, A partner write the application using dotnet. currently they use HDR on IDS11.50 FC8,but they don't use connection manager. Do anybody know whether connection manger could reroute the connection request from DOTNET? thanke for your time.…
limit user connection to IDS
The only limit for Informix connections is memory. But depending on your connection types, you could limit on the OS side. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosp…
how many concurrent users access informix
Art, as a matter of interest, how are you managing to get Innovator-C servers "sharing data with two Enterprise Edition central servers" considering the unavailability of remote-database connectivity in Innovator-C?…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Connection Manager
I have setup an RSS server but I am having problems getting it working properly with Connection Manager. Here is what I am running. IDS 11.70.FC4GE CSDK 3.70.FC4DE ServerA - Primary server ServerB - SDS ServerC - RSS The connection Manager config file is - NAME conn_man LOG 2…
HDR/ER mixed environment testing
hello we are working in development on adding ER to our existing HDR system (version 11.50.FC7 on AIX 6.1). However, when trying to test failover scenarios we are running into a problem making the secondary a primary and having the ER instance hook up to it and move forward. It …
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
dbserver name "group" doesn't connect from Windows
From Unix /Linux: dbaccess database@database_group .... That works. From Windows: (Get -25555, saying it isn't in sqlhosts file... But the group is in the registry sqlhosts file.) ilogin and testing odbc connection to database server group ... Does not work. Unix sqlhost file…
RE: HDR+Connection Manager in intermittent network scenario
Thanks for the advice, I'll give it a try. -Nate PS: I'm new to this list, and the Informix-list Digest emails I get say to include the message number in square brackets in the subject line. I don't see this number anywhere -- am I doing something wrong? ______________________…
RE: HDR+Connection Manager in intermittent network scenario
Cesar, I must have missed the FAILOVER_CALLBACK parameter in the docs. Thanks for pointing it out, I'll take a look. Speaking more generally to both you and Pravin, I must confess, I haven't experimented much with DRAUTO set to 0 or 1. The impression I got from the documentation…
Re: HDR+Connection Manager in intermittent network scenario
I agree with Paul, especially if you have the CM managing failover, but even if not it's a very good idea! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep i…
RE: HDR+Connection Manager in intermittent network scenario
> On 12/03/2010 07:46 PM, Nate Woodward wrote: > > I'm trying to acheive high availability without data loss. I have an > HDR > > pair configured with a connection manager on each box for redundancy. > > Clients are pointed at an sqlhosts group with the connection managers > in >…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
Re: HDR+Connection Manager in intermittent network scenario
Hi Nate, I guess the manual failover (DRAUTO=0) is the best configuration for HADR and CM environment for handling the conditions described by you in you mail below. (dealing with network issues) Hi Cesar, This look like a little different behavior than in the earlier version …
Re: HDR+Connection Manager in intermittent network scenario
Nate, you will found information about this on the manuals. Check for DRAUTO, FAILOVER_CALLBACK... Just sharing a issues what I got with IFX 11.50 FC7W1GE + CM 3.50 FC7, Linux. On environment with similar configuration, using HDR, I have trouble with CM FOC and DRAUTO configura…
HDR+Connection Manager in intermittent network scenario
I'm trying to acheive high availability without data loss. I have an HDR pair configured with a connection manager on each box for redundancy. Clients are pointed at an sqlhosts group with the connection managers in them, and the connection managers are configured to redirect the…
ER out of sync
On 12 нов, 19:51, "Jonny...@Usenet-News.net" <Jonny...@Usenet- News.net> wrote: > Hmmm ... are ALL your replicates Primary / Receive only? Yes. > Can you on the standby server do dbaccess / connect / "Standy instance" > using any of the DBSERVERNAME / DBSERVERALIAS / group name…
Connection Manager in 3.7 CSDK and IDS 11.50
Anyone know if it is safe to run the latest and greatest Connection Manager from Panther with IDS 11.50? I assume oncmsm is backwards compatible, just want to make sure. Thanks, Andrew…
Concurrent Database Maintenance?
OK..more questions! Informix on Linux. I read on one site that Informix does not allow concurrent index reorgs...that you have to drop table indexes and rebuilt them (ALTER INDEX CLUSTER). I dont know if it was an outdated website. Can anyone tell me if this is still true and …
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
RE: Failover question (Solved)
In case anyone else wants to know how to do this: When the primary server server1 goes down: 1. Change server2 (the RSS secondary) to a standalone server – onmode -d standard. Once server1 (the old primary) is fixed do the following: 1. (Optional) Stop the connection ma…
Re: Failover question
The standard method is to bring up the old primary, make it an RSS secondary to the new primary, then, once it has caught up, reverse them making the old primary primary again and the original RSS secondary secondary again. The second part will have to be done during a maintenan…
Failover question
Scenario: Client has a primary server and an RSS server and the primary goes down. The RSS server is changed to standard to allow clients to continue to connect. Is there a way of bring up the old primary and revert the new primary back to an RSS server without major interruptio…
CONNECTION MANAGER WINDOWS
Olá amigos, Hello friends, PROBLEMAS COM O CONNECTION MANAGER NO WINDOWS ============================================= PROBLEMS WITH CONNECTION MANAGER ON WINDOWS =========================================== Estou montando 3 servidores rodando SUSE LINUX com Informix 11.50.FC6 …
OAT and MACH clusters
Linux 5, IDS 11.50 FC6W4 I have setup an HDR primary and secondary, and I can connect to both using OAT, but when I search for a MACH cluster, it doesn't find any. I am not using the connection manager. Is that possibly why OAT doesn't see them as a MACH cluster? Jamie…
More Connection Manager fun
IDS 11.5FC6 on Centos 5.4 I've set up 2 Connection Managers and a 2-node SDS cluster. When I get to run dbaccess on the client I get to see ALL possible connections; ie the path to the relevant IDS instance twice, once for each Connection Manager in the Connection Manager clust…
Switch RSS secondary back to Primary
The switch back to re-establish the Primary-Secondary HDR pair after a failover is documented and the scripts to do this are in $INFORMIXDIR/bin (hdrmkpri.sh* hdrmksec.sh*). Are there similar scripts available to re-establish a Primary-RSS secondary server after a failover to the…
Re: in place alters (script/output) issue
??? not according to the migration guide when doing an in place migration Upgrading Dynamic Server (In-place Migration) In-place migration upgrades Dynamic Server directly to the current version by installing the product in a new directory, copying a few configuration files, an…
RE: IBM Informix - Continuous Availability White Paper
> Date: Wed, 21 Apr 2010 00:32:08 -0400 > From: lester@advancedatatools.com > To: informix-list@iiug.org; waiug-members@iiug.org > Subject: IBM Informix - Continuous Availability White Paper > > IBM Informix - Continuous Availability White Paper > LOL... Now that's funny. For …
Reverting from HDR failover to secondary
I did a simple test of HDR failover from primary server to the secondary server. I shutdown the primary (onmode -yuk) and after 30 secs (setup in connection manager config file) the old secondary became the new primary server. What are the exact steps to restore to my original HD…
Database and ColdFusion connections
Hello all, We use ColdFusion (CF) as the web front end and informix version 10.fc9 on aix 5.3. It looks like CF manages the pooled connections and threads hitting the database just fine when the results are returned according to the time out setting. However, the problem is whe…
IDS, BTS datablade and HDR
I am not sure which version of the server you are using, but if you check the release notes of 11.50.xC3 or later you will find the following: Basic Text Search DataBlade=AE module Supports High-Availability Cluste= rs =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D…
MACH 11 questions
Hi, Greatly appreciated if someone can be of assistance in a couple of questions I was recently asked on MACH 11 running IDS 11.50. 1) is it possible to have an SDS node against an HDR or RSS node? The reason this is being requested is to have a physical DR site consisting of a…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Question on HDR
ids-bounces@iiug.org wrote on 10/20/2009 09:57:03 PM: > [image removed] > > Question on HDR [17643] > > JACK PAPA > > to: > > ids > > 10/20/2009 09:58 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hi All, > > Just a question on HDR of Informix.. > > The …
SDS Mach 11
kate said: > When you are using SDS with Mach 11, how does Informix balance the load > across multiple pieces of hardware that are all using SDS to share a disk? > I assume through connection manager, but I would like to understand the > logic of how it determines how to send a t…
RE: Connection Manager and I4GL
Sigh. KISS applies. 4GL apps are client/server. You may want to consider some sort of DNS / host mapping solution. That is, your application connects to the server via hostname. If the heart beat of the host goes down, your DNS system catches the alert and the secondary's IP a…
Re: Connection Manager and I4GL
On 14/08/2009 13:57, Keith Simmons wrote: > 2009/8/14 Ian Goddard<goddai01@hotmail.co.uk>: x-list >> > I am the admin, but as the DR machine is on a different physical site > with separate sub-netting this is a non-starter. AIX !!! so linux/hp > solutions are no good. > There is …
Re: Connection Manager and I4GL
Keith Simmons wrote: > 2009/8/14 Jonathan Leffler <jonathan.leffler@gmail.com>: >> On Aug 13, 6:16 am, Keith Simmons <smile...@googlemail.com> wrote: >>> All >>> >>> Following 'recent' issues (this week and 15 months ago !!) management >>> have decided we need some fail-over mech…
Re: Connection Manager and I4GL
Just for fun, a few months ago I tested I4GL + oncmsm on Linux and works fine! Here, I just install the last version of CSDK at different directory of I4GL and configure the CSDK directory first on the LD_LIBRARY_PATH enviroment... Regards Cesar --- Em qui, 13/8/09, Obnoxio Th…
Re: Connection Manager and I4GL
Keith Simmons wrote: > 2009/8/13 Obnoxio The Clown <obnoxio@serendipita.com>: >> Keith Simmons wrote: >>> All >>> >>> Following 'recent' issues (this week and 15 months ago !!) management >>> have decided we need some fail-over mechanism in place for when the >>> database 'locks …
Re: Connection Manager and I4GL
2009/8/13 Obnoxio The Clown <obnoxio@serendipita.com>: > Keith Simmons wrote: >> All >> >> Following 'recent' issues (this week and 15 months ago !!) management >> have decided we need some fail-over mechanism in place for when the >> database 'locks up'. >> IDS HDR is the obviou…
Re: Connection Manager and I4GL
Keith Simmons wrote: > All > > Following 'recent' issues (this week and 15 months ago !!) management > have decided we need some fail-over mechanism in place for when the > database 'locks up'. > IDS HDR is the obvious candidate but I need to get my head around how > an applicati…
Connection Manager and I4GL
All Following 'recent' issues (this week and 15 months ago !!) management have decided we need some fail-over mechanism in place for when the database 'locks up'. IDS HDR is the obvious candidate but I need to get my head around how an application can seamlessly fail-over from p…
Re: SDS performance
Alexander wrote: > Hello everybody, > > Our is planning to upgrade IDS from 9.4 to 11.50 along with hardware > upgrade which includes FC attached disk array that will be shared by > two servers. It looks like we can try to use what is called Sared-Disk- > Secondary server. > > I'…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
RE: Select error: SQL error -208: Memory Allocatio
LARRY SORENSEN wrote: > We do NOT use ODBC to connect but rather connect directly using the Informix > drivers. I say this because when we install the client components (Crystal > runtime, Powerbulder runtime, Informix drivers and Datadental client) we then > run the Informix set…
How to config J/Foundation for multiple instances
And, that is what I did: moved jre to /usr/lib/informix and recreated the IDS.11.50.FC3-JRE1.5 symlink to it. Now any version 11.5 package that happens to be on that node thru failover, or during upgrades to other nodes will have no problem. But, it still bugs me that I can't ch…
How to configure Connection Manager for a protocol onsocssl?
Hello, gurus! Does anyone know how to configure Connection Manager for a protocol onsocssl? Dbaccess has established connection directly to the server for a protocol onsocssl without any problems. When CM has started, it started succesfully, but when I want to connect via SLA, C…
local area connection!
Dray wrote: > OS is Win Xp Pro > "Dray" <dray@dray.com> wrote in message news:gvj9a8$8nb$1@ss408.t-com.hr... >> We added another lan card on the computer(informix server), but now we >> have slower connection on database! Each card has it own ip range! On a >> local server connec…
Connection Manager Cluster
>Hi, >in addition to my previous post. We tperformed several tests and noted that if we have two Connection >Manager instances say CM1 and CM2. If CM1 was started first and CM2 later, then after restart of database >instance CM1 get registered but CM2 fails to detect database ins…
Re: Connection Manager - restrict connections
Tom wrote: I think to do what you are trying to do that you will need to use the password file. The second column has an alias to use in place of the HA_ALIAS. > On May 14, 11:47 am, Tom <tlow...@munis.com> wrote: >> On May 14, 4:57 am, theBP <th...@Usenet-News.Net> wrote: >> …
Connection Manager - restrict connections
Tom wrote: > On May 12, 3:05 pm, Tom <tlow...@munis.com> wrote: >> On May 12, 2:11 pm, theBP <th...@Usenet-News.Net> wrote: >> >> >> >> >> >>> Tom wrote: >>>> Greetings all, >>>> In a world where multiple DBSERVERALIAS values exist, is there a way >>>> to restrict which ones the …
Re: Connection manager redirect
What kind of error clients are getting ? Regards, Nilesh., ids-bounces@iiug.org wrote on 05/05/2009 05:08:25 PM: > [image removed] > > Connection manager redirect [15681] > > VIVIAN JONES > > to: > > ids > > 05/05/2009 05:09 PM > > Sent by: > > ids-bounces@iiug.org > > Please …
Connection manager parametrs
Can anyone help us out that we are not able to find detailed documentation about informix connection manager like what are the optional parameters to define SLA. And what does timeout value in FOC of connection manager mean? regards, Kamran…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
connect through java using group_name con mgr
Sorry my mistake, I am unable to access that file through java( as it is on network ad i tried to access it without help of some web/application server). Here is another issue I am facing. I used following connection strings with variation in informixserver values: A => "jdbc:i…
Connectiom Manager help needed
Greetings, I am getting an error when attempting to start the second CM in the following configuration: 2 identical IBM P6-550 servers, AIX 6.1, IDS 11.5.FC3 (server asp5_be is the Primary and asp6_be is the HDR in an HDR pair) oncmsm_1.cfg (on asp5_be) NAME oncsm_1 …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Connection Manager Behaviour - Feedback Request
Hi, I am currently in discussion with R&D about how Connection Manager behaves, and what behaviour customers want. So, given the following environment, using the sqlhosts as a central reference point (and yes, it IS big), where I have Two MACH11 clusters Each Cluster has 1…
SLA listener failed Connection Manager shutdown
...Yes.. You are right .. thanks.. > To: ids@iiug.org > From: mpruet@us.ibm.com > Subject: Re: SLA listener failed Connection Manager shu.... [15033] > Date: Thu, 26 Feb 2009 19:34:18 -0500 > > The machine name and service for the connection manager is defining the= > > listener…
Shared Disk Secondary
Look at the whitepaper from HP (http://h20195.www2.hp.com/V2/GetPDF.aspx/4AA1-7936ENW.pdf) which discusses the rich high availability features of IDS 11.1 and how to integrate them with the cluster solution HP ServiceGuard and a cluster filesystem.…
Question for Connection manager and SDS
I have 2 question for IDS11.50 SDS 1. What is the machanism of Connect Manger to select the dabase server ? Round robin , random ? For example : SLA CMport=(dbport1+dbport2+dbport3) Can we set up the additional rule for CM such as use dbport1 40%, dbport2 30%, dbport3 30% ? 2…
How to conect Java Aplication using Connection Mgr
Hello, I am unable to connect database using connection manger, setting for connection manager is as follows. Values in password file. ------------------------ ids_net_mcp_test02 - informix informix ids_net_mcp_test_rep02 - informix informix ids_net_mcp_rss1 - informix informix…
general IDS 10 FC9 install questions?
Hey everyone. I have some basic IDS Fc9 install kind of general questions... I have tried finding answers on this and believe it or not have not been able to.... Has anyone installed IDS 10 FC9 on any unix machine? If so do know what the size of the informix install tar file is? …
Connection Pool
Hello everybody! I have been looking for this issue for some hours and I wasn't able to find anything. How can I use the connection pool for IDS 9.4? I'm developing in C# of Visual Studio .NET. Until now I have been using Oracle. And to use the connection pool, I only had to u…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
HA : What is the best ?
Hi, I have two Intel Xeon 5160 rack boxes (2 x Dual-Core, 4GB Ram, 5 HD, 2 LAN ports) to run Win2K3 Server on which I plan to install IDS 11.50 xC2.xx for about 60 users. Considerations I have to address : High Availability, IDS license type/cost, "near-zero" IDS administration…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Hardware advice please
"R Rhodes" <rosie@bullysoft.co.uk> wrote in message news:299485d5-551f-48a9-bb5d-edcd02a0d3c7@x35g2000hsb.googlegroups.com... > Hi all, > I am looking for advice on what servers to buy to replace our existing > informix db servers. > We have to replace them, because they are dino…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
How I can to change status from SDS secondary to Primary.
rootdbs@gmail.com wrote: >> Question --- why is it necessary to revert the server status? You are >> using the connection manager, so you could configure an SLA to point to >> the current primary. > > I don�t think about it. > But I think that not only SLA need configure. Sqlh…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Re: Ok, call me silly...
In article <1213380586.945676@bubbleator.drizzle.com>, DA Morgan says... >No: Not my point at all. My point, the only point I've been making in >this thread, is that IBM is not giving Informix the respect it deserves. > And that by putting following features in Informix and not…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: Cheetah2 connection manager and failover arbitrator
I thought it would work that way but apparently it doesn't. I've opened a defect for the issues you noticed. Thank you for pointing that out. Regards, Nilesh informix-list-bounces@iiug.org wrote on 06/09/2008 02:08:54 PM: > > ----- Original Message ----- > From: Nilesh Ozarkar…
Re: Cheetah2 connection manager and failover arbitrator
"Art Kagel" <art.kagel@gmail.com> wrote in message news:mailman.1204.1212948745.20610.informix-list@iiug.org... >> [Daniel] You cannot be this dense and still hold a chair at a major >> University! >> Among other posts that I saw, I said Informix Dynamic Server Shared Disk >> Se…
Re: Cheetah2 connection manager and failover arbitrator
----- Original Message ----- From: Nilesh Ozarkar To: Andrew Ford Cc: informix-list@iiug.org ; informix-list-bounces@iiug.org Sent: Monday, June 09, 2008 11:13 AM Subject: Re: Cheetah2 connection manager and failover arbitrator > I think so - depends on how you configure SLA. To…
Re: Cheetah2 connection manager and failover arbitrator
Is IDS SDS equivalent to RAC? Nope! But, lets make sure we understand the market that IDS SDS is aimed at. SDS (like HDR) is aimed at the 2 node active/active paradigm. Its aimed at applications which do mostly reads. Horizontal scaling for reads is at 100%... for writes... well…
Re: Cheetah2 connection manager and failover arbitrator
informix-list-bounces@iiug.org wrote on 06/09/2008 09:54:41 AM: > ----- Original Message ----- > From: "Andrew Ford" <aford@networkip.net> > To: <informix-list@iiug.org> > Sent: Friday, June 06, 2008 12:53 PM > Subject: Cheetah2 connection manager and failover arbitrator > > > >…
Re: Cheetah2 connection manager and failover arbitrator
----- Original Message ----- From: "DA Morgan" <damorgan@psoug.org> Newsgroups: comp.databases.informix To: <informix-list@iiug.org> Sent: Sunday, June 08, 2008 5:02 PM Subject: Re: Cheetah2 connection manager and failover arbitrator > I would suggest the Oracle newsgroup is the…
Re: Cheetah2 connection manager and failover arbitrator
----- Original Message ----- From: "Andrew Ford" <aford@networkip.net> To: <informix-list@iiug.org> Sent: Friday, June 06, 2008 12:53 PM Subject: Cheetah2 connection manager and failover arbitrator > IDS 11.50.UC1 > Red Hat Linux 5 > Simple HDR environment 1 Primary - 1 Secondar…
RE: Cheetah2 connection manager and failover arbitrator
Sebastian, Norma J. said: > Tom Kyte Wow! Is he still around? He was good value, a bit like Mark Townsend, but with a sense of humour. :o) -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got th…
Cheetah2 connection manager and failover arbitrator
IDS 11.50.UC1 Red Hat Linux 5 Simple HDR environment 1 Primary - 1 Secondary I'm taking a look at the connection manager and failover arbitrator shipped with the CSDK in IDS 11.50 and am wondering if there is a better way to recover from a Primary server failure that doesn't req…
Managing IDS in IBM HACMP environment
Appreciate the comments. We are planning to use HDR but this will be to our Disaster Recovery Site. The use of HACMP at the Primary site is mainly to have high availability in case of any hardware failure and for system maintenance.The cluster is already setup and shared logical…
Re: So now Informix has RAC
On 29 Apr, 22:44, dcrunch...@aim.com wrote: > http://www.eweek.com/c/a/Database/IBM-UnCages-Cheetah-2-Data-Server/ > > "IDS (Informix Dynamic Sever) 11.5, code-named "Cheetah 2," builds on the > failover-recovery capabilities of its predecessor by now supporting full > read/write…
Management Articles, Web Seminars, More
Management Articles, Web Seminars, More Access thousands of business articles, Webcasts, e-learning, best practices, case studies and more. http://www.health3.com.cn/health/Management.htm Corporate Knowledge Sharing Find management solutions for your company in the directories a…
Re: iDS-On-iPhone
Obnoxio The Clown wrote: > InDeep said: >> Has anyone ported or installed IDS to the iPhone? >> >> >> What is the current buzz? Is it possible? >> >> Any other databases jumping in to the iPhone? > > Get a grip man, it's a phone and not even a very good one. > Yeah but if I clu…
Re: question about mach11 capabilities
Thanks Art, I figured it had to be ER, but wasn't sure how it would work. So basically I would have to reorg each ER server ( or er group ) separately and let it catch back up. Lots of work on a weekend type reorg, but at least no downtime. :-)) Thanks. ----- Original Message …
Re: question about mach11 capabilities
Floyd Wellershaus wrote: > Hi, > I was just reading the white paper on ids11 availability and have a > question. > The solutions seem explicitly cover every scenario except one. > If I need to reorg a very large table that the application needs, but > I don't want to take any out…
Re: current informix white papers ?
Fernando Nunes wrote: > DA Morgan wrote: > >> Floyd Wellershaus wrote: >> >>> My company is seriously thinking of going to Oracle and using >>> RAC/DataGuard for their high availability solution. >>> I know Informix can compete with this, as I'm pretty sure Cheetah has >>> the la…
Windows XP Helper
Windows XP help and tips to increase your productivity and help solve computer problems. Topics include Tweak UI, account management, remote desktop connections, using printers, removing spyware on Windows XP systems, DOS and Batch Files, and more. http://online-windows-xp.blogsp…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Getting a bite of the Apple?
http://www.internetnews.com/bus-news/article.php/3721921 IBM's IDS to Support Mac Platform By Larry Barrett Maybe it's just a cat thing. IBM on Wednesday announced its Informix Dynamic Server (IDS) will support the Mac OS X 10.5 operating system, a.k.a. 'Leopard' beginning wit…
Getting a bite of the Apple?
http://www.internetnews.com/bus-news/article.php/3721921 IBM's IDS to Support Mac Platform By Larry Barrett Maybe it's just a cat thing. IBM on Wednesday announced its Informix Dynamic Server (IDS) will support the Mac OS X 10.5 operating system, a.k.a. 'Leopard' beginning wit…
Connect to IDS from Open Office 2.3.1
My turn to need some help. I am trying to connect to an IDS database from Open Office v 2.3.1 using an ODBC connection. From this PC I can connect to the DB natively and I can also query the DB using RazorSQL connected via ODBC. I have created an ODBC connection in Open Office…
How to Setup IDS for all IPs
Martin Fuerderer wrote: > Hi Art, > You do mention DBPATH and 'methods' but I think the focus on: "... the Secondary can keep running using its own IP-address. Then of course the clients will have to use that IP-address for the re-connect after failover." Doesn't make it clear…
Informix Cluster HDR and Hearbeat2
OK, here you go with anold e-mail from 31-Aug-2007: ----------------------------------------------------------------- Sending on behalf of Lars D. Forseth (lars@forseth.de): ----------------------------------------------------------------- Hi there! My name is Lars Daniel Forse…
Re: RAC in Informix by year end?
Data Cruncher wrote: > Taken from DBTA magazine. > > Did I read this correctly? Does it mean that by year end Informix > will offer RAC. > > ============================================= > HDR, RSS and SDS servers and even ER can be combined in any way to > provide a sophisticate…
Re: RAC in Informix by year end?
Data Cruncher wrote: > Taken from DBTA magazine. > > Did I read this correctly? Does it mean that by year end Informix > will offer RAC. > > ============================================= > HDR, RSS and SDS servers and even ER can be combined in any way to > provide a sophisticate…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
DR failover server
Hello all: This is my first posting. We are running IDS 9.40.HC3 on HP-UX B.11.11 with a small EMC RAID array and I am working on a disaster recovery document. We currently have 2 servers (dev and prod) and will be moving the dev server to a disaster recovery site which has a T3 …
Re: Informix beats Oracle
Excellent!! Thanks Andrew. Andrew Ford wrote: > IDS HDR has auto failover via the DRAUTO onconfig parameter: > > 0 signifies OFF = Do not automatically switch the server type in the HDR > environment. > > 1 signifies RETAIN_TYPE = Automatically switch secondary to standard duri…
Re: Informix beats Oracle
Tool wrote: > Quick question for you Fernando or anyone else... > > With the introduction of MACH11, do you still need a secondary product > for HA > such as HP Serviceguard, or Red Hat Cluster Manager or other HA product > on the > machine at the OS level if there are no other a…
Storage Area Network Fails for Unix/Netware
We want to run our Informix 9.40 database on a SAN, and we've tried this using an HBA fiber-optic (dual channel) card, with HP Secure-Path failover software. This has worked, to a point, except that each time a SAN controller fails for any reason, the Linux-based Informix server…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
IDS agent for Sun HA cluster
> We've installed IDS on a Sun Cluster. It works really well, but one > irritation is we haven't got the Informix agent to work. We've followed > through the instructions in the IBM IDS High Availability and Sun Cluster > 3.x document (written for IDS v9 but we are assured 10 i…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Using IDS on VMware
DAVID FRASER said: > Actually, the more I think about it, we need on-line realtime data server > and > 4gl (and linux environement) replication, not High Availability fail-over > (as > provided by HDR). So I am looking for a solution based on VMware to > replicate > my entire ser…
mystery server in HDR
Hello all, upon bouncing our secondary server, the log shows it is trying to connect to a primary server that does not exist! we have searched the secondary server itself, system tables, etc and cannot find a reference to this mystery server we are on ids 10 fc5 on AIX 5.3 usin…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: Mirror or Raid1? Replication or DRBD?
Got HDR running so far, looking good ... except for when I tried to do a failover, the failover did work out, but I couldn't get the boxes to switch back over to the original setup... guess I still need to do some testing ... Tnx for now!…
Re: Dumb DBA mistakes
How about this: A site I am aware of set up a pair of machines with Sun's failover and the DB data disks on swingable drives. However they put the IDS installation and all of the config files on local drives. Of course, duplicated on both sides. Don't get ahead of me here! N…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Informix connection to SQL Server
cboccio@yahoo.com.br wrote: > Hi all, > > Does anyone knows how to connect a SQL Server from an Informix Database > installed on a Linux machine ? > > Tks, > > Regards, > > Eduardo > Informix Enterprise Gateway Manager…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: Another IDS Feature Request
Madison Pruet wrote: > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > news:43E0E317.2080907@bloomberg.net... > >>bozon wrote: >> >>>Art S. Kagel wrote: >>> >>> >>>>bozon wrote: >>>> >>>> >>>>>It would help us. I think it would be a feature that would really fit >>>>>in w…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Probably a dumb question but...
Guys (particularly IBMers)- Since Apple is porting its OS to Intel processors and since Mac OS is really just a GUI sitting on top of UNIX... It shouldn't be much of a stretch to take the Linux port of IDS and create a Mac port. Is there a snowball's chance in Hades that IBM wo…
IDS cluster
Dirk Moolman wrote: > My company is talking about moving IDS on SUN, to IDS on Linux - and > also clustering the servers. > > The only failover I know (on the Informix side), is ER and HDR. Is > clustering possible on Linux ? > > > (they mentioned having 2 DB servers and 2 appli…
Re: Informix in the news! Part Deux... RANT TIME
Davorin Kremenjas said: > > OK, people, please tell me what "FOC" means, so I can understand what > you're > talking about :) > Thanks! Free Of Charge. > "Maelwys Filidh" <lleu@hotmail.com> wrote in message > news:dns2ha$6b8$1@news.xmission.com... > >> I did hear from a US cont…
Re: Informix in the news! Part Deux... RANT TIME
OK, people, please tell me what "FOC" means, so I can understand what you're talking about :) Thanks! "Maelwys Filidh" <lleu@hotmail.com> wrote in message news:dns2ha$6b8$1@news.xmission.com... > I did hear from a US contact that IBM were making Express FOC, to compete > with O…
Re: Informix in the news! Part Deux... RANT TIME
Don't get mad at me but Isn't that number Tech Support rather than Sales? If you want sales I can recommend a WorldWide Contact danilo@us.ibm.com Danilo Novelli WW Informix Sales Information Management IBM Software Group I have met him at the Uk Usergroup meeting and at the Wo…
RE: Informix in the news! Part Deux... RANT TIME
Hi, Well, to increase, or even maintain good old IDS market share may I make a radical suggestion? Here it is: Put people calling about Informix through to someone who knows the first thing about it. Even someone who has heard of it would be a major improvement. Having heard (v…
RE: Informix in the news! Part Deux... RANT TIME
Hi, Well, to increase, or even maintain good old IDS market share may I make a radical suggestion? Here it is: Put people calling about Informix through to someone who knows the first thing about it. Even someone who has heard of it would be a major improvement. Having heard (v…
Re: 2xSMP vs RAC for failover - was Re: informix market share
DA Morgan said: > > Serge Rielau wrote: > >> Duly noted. Thoughts for the road: If you use a 2 node cluster and one >> goes down you're dead unless you kept load very low when the RAC system >> is up. That is the 2 node RAC cluster competes with a 2x4 SMP box which >> of course w…
Re: 2xSMP vs RAC for failover - was Re: informix market share
Serge Rielau wrote: > Duly noted. Thoughts for the road: If you use a 2 node cluster and one > goes down you're dead unless you kept load very low when the RAC system > is up. That is the 2 node RAC cluster competes with a 2x4 SMP box which > of course will price hardware wise t…
Re: 2xSMP vs RAC for failover - was Re: informix market share
DA Morgan said: > > Serge Rielau wrote: >> DA Morgan wrote: >> >>> Serge Rielau wrote: >>> >>>> *chuckle*And there always will be because SMP scales better than RAC >>>> (more CPUs needed) and RAC is cited as a major contributer to Linux >>>> licenses... it ain't free. >>> >>> >>…
2xSMP vs RAC for failover - was Re: informix market share
DA Morgan wrote: > Serge Rielau wrote: > >> *chuckle*And there always will be because SMP scales better than RAC >> (more CPUs needed) and RAC is cited as a major contributer to Linux >> licenses... it ain't free. > > > Of course if you also want transparent failover with that bi…
Re: informix market share
Serge Rielau wrote: > *chuckle*And there always will be because SMP scales better than RAC > (more CPUs needed) and RAC is cited as a major contributer to Linux > licenses... it ain't free. Of course if you also want transparent failover with that big SMP box you get to buy at …
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: Multiple HDR secondaries...
Common uses I can recall hearing of for this kind of capability: (1) One secondary current (for 'normal' failover), plus one secondary with delayed replay (for errant transaction protection). (2) One local secondary for more convenient failover, plus a remote secondary for less…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Re: Database market share 2004
rkusenet wrote: > http://www.eweek.com/article2/0,1759,1820667,00.asp > > > > > The database market grew by 10.3 percent in 2004, fueled largely by hunger for business > intelligence and analytics, according to numbers released by the Gartner Group on Monday. > With 34.1 percent …
Database market share 2004
http://www.eweek.com/article2/0,1759,1820667,00.asp The database market grew by 10.3 percent in 2004, fueled largely by hunger for business intelligence and analytics, according to numbers released by the Gartner Group on Monday. With 34.1 percent of the overall market, IBM hold…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Sun Cluster Agent for INFX version 10
Informix Sun Cluster agent is tested/certified with 9.X and 10.X ( SC 3.X) Regards, Mahesh Dashora Development Manager (Backup Restore, High Availability and Utilities) Database Development Information Management Division 4100 Bohannon Drive Menlo Park, CA - 94025 email: maheshd@…
RE: HA cluster on SCO Open Server
Martin Bouzek wrote >>> > >>> our company needs to setup an high availability cluster on two > >>>machines running SCO Open Server and Informix. Does > anybody have any > >>>experience with such configuration or at least can anybody > point me > >>>where to find more informatio…
Re: HA cluster on SCO Open Server
Obnoxio The Chav wrote: > Martin Bouzek said: > >>Hello all, >> >> our company needs to setup an high availability cluster on >>two machines running SCO Open Server and Informix. Does anybody have >>any experience with such configuration or at least can anybody point me >>where t…
HA cluster on SCO Open Server
Hello all, our company needs to setup an high availability cluster on two machines running SCO Open Server and Informix. Does anybody have any experience with such configuration or at least can anybody point me where to find more information about supported HW minimal versions …
Re: HA cluster on SCO Open Server
Martin Bouzek said: > Hello all, > > our company needs to setup an high availability cluster on > two machines running SCO Open Server and Informix. Does anybody have > any experience with such configuration or at least can anybody point me > where to find more information about…
cluster
hi all, is this possible to build a cluster with 2 informix (IDS 9.x) DB (load balancing,high availability..)? what must i look at ?…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: can run HDR and ER simultaneously on the same server IDS 9.20??
Another solution would be to migrate databases to a mainframe (we have thought at IBM ZSeries) and to use a storage IBM (storage are own OS for replication) at main location and also another mainframe with storage at disaster recovery center. In this case we have thought to use t…
RE: IBM website Informix pages / Workgroup edition
I received this from IBM in February this year in response to a similar question on licensing: "...IDS 9.3 & 9.4 High Availability/Failover In idle standby or active standby, you must acquire the correct number of Server, Processor and Concurrent Session use authorizatio…
RE: IBM website Informix pages / Workgroup edition
comments in-line. "Everett Mills" <eemills@nationalbeef.com> wrote in message news:ce6d1r$j09$1@news.xmission.com... > > Isn't this contradictory? From IBM's site (reference below): > > One area: > > Informix Dynamic Server V9.4 Workgroup Edition features and attributes > includ…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
HDR for high availability
How many customers use HDR for high availability purpose. Meaning, they use it for failover when the primary node goes down. If possible, can those customers contact me off-line. Thanks. Ravi…
RE: HDR with Synchronous replication
Guys- FYI- HDR is now LEGAL in WGE. You just have to buy an additional server license for your secondary ($686 last time I looked). From the IBM website: Informix Dynamic Server V9.4 Workgroup Edition features and attributes include: High availability Point-in-time instance…
Re: database market share 2003
Everything is up for grabs Daniel, that's what newsgroups are all about. If you understand the Informix world, you'll understand my statement, especially in the context of the Informix newsgroup. Informix people have had several servers to choose from over the years, but no one…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Connect to Informix 7.2 from jodbc
Hy guys, I�m try to connect using the jodbc driver in solaris S.O in the Informix database 7.2, but I don�t know What port can I use. Somebody could me help ? Thanks a lot Ricardo Pardo Atento Brasil S/A AVAYA Call Management System Administrator sending to informix-list…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Oracle 10G
Obnoxio The Clown wrote: > What are you talking about? You talked about hash partitioned tables, not > transparent failover. And many different types of partitioning have been in > IDS for years. You then tried to imply some sort of grid-ness, because > these might be on differe…
-951 error connecting to Informix SE for Windows
Informix SE 7.25.TC3 for Windows. I am trying to connect to the machine from a remote machine using DBACCESS. If I connect using my "normal" Win2k user (the one I login to on this machine)... I connect fine. However, if I try to connect using another user I added to this machi…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
RE: Changing hostname / IP address
Five Cats wrote > > >DNS contains a wonderful, underused facility called ALIAS records. > > It would be so wonderful if the site was using DNS. They are > not, hence > the problem! Most unixes have the facility of an IP alias that does this locally. In Tru64(RIP) it is - ifc…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: Company thought DB2 will be better than Oracle.
The issue of transparent reroute of the connection when the IP address gets moved is something we are working on (i.e. writing code to solve). Ian wrote: > Noons wrote: > >> Blair Adamache <badamache@2muchspam.yahoo.com> wrote in message >> news:<bk7qnv$igs$1@hanover.torolab.ib…
Re: Company thought DB2 will be better than Oracle.
Blair Adamache <badamache@2muchspam.yahoo.com> wrote in message news:<bk7qnv$igs$1@hanover.torolab.ibm.com>... > For more formal approaches, DB2 supports High Availability through the > following packages / methods: > > HACMP on AIX > Microsoft Cluster server on Windows > Sun Clu…
Re: Company thought DB2 will be better than Oracle.
We are certainly looking at and protoythe high availability through replication (HDR) technology we acquired with Informix. We also appreciate that xferring the ip address in some transparent way is desirable. DB2 also supports split/mirror: http://www7b.boulder.ibm.com/dmdd/lib…
Taking care of Fail Back in HDR
Again this is another surprise for me in Informix that failover is not automatic. In fact they expect the application logic to be written keeping replication in mind. How crappy is that ? For all the guys that use HDR how do you take care of the primary going down ? The manual m…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Re.continuity
Hi everybody, IDS.9.3 uc3/ AIX 5.1 with HACMP, during the failover we have outage of 3.5 mins. Is there any option or any technology recommended to avoid the outage of 3.5 mins and have the continuity in the service. Thanks in advance. Sushil.. ________________________________…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
RE: failover
Check out Informix's High-availability Data Replication (HDR). You can RTFineM about it in the two "Data Replication" chapters in the Admin Guide. HDR works well, is easy to set up and maintain, and is very reliable. HTH, Paul Mosser -----Original Message----- From: ajhowell@m…
failover
We are on Informix 7.30.UC3 and Solaris 7. We are considering Legato or Veritas for a high-availability/failover solution. Any comments or opinions regarding either of these options (reliability, ease of use, etc) or a different option would be greatly appreciated. Thanks! Sen…
RE: Clustered Servers
Not a problem, but you will only have Informix active on any one member at a time. In a 2 member config, the second member will can only be used as a failover instance. In other words: Mem1: Informix instance 1, Database/Instance 1 Mem2: Informix failover instance 1, Database/In…
Replication
We are considering using some method of data replication/failover. Some of the options we have considered are Informix Enterprise Replication, Informix Data Replication, Legato, and Veritas. I would like to hear from users with experience on any of those methods regarding the ea…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: Eliminate ontape? failover issue
From: lopez@abqato.abq.sc.philips.com > >Strange. Trying that, We get a message saying the transaction log can not >be >dumped to /dev/null. If you set LTAPEDEV to /dev/null, it automatically backs up logical logs as they fill up. But running ontape -a does produce an error. >R…
Re: Alpha Cluster + Informix ?
Hannes Visagie wrote: > > Hi all > > Anybody experience with Informix on Compaq Alpha set up as cluster. ? Yes, but only set up for failover. Shared disks, etc. > Can you set up INF to use all members processing power ? {Single DB} I think you need to look at IDS-EPO (version …
Eliminate ontape? failover issue
WE are moving an application suite to a HP server cluster which offers the MC Service Guard to move the suite of tools as one "package" to an other server of the cluster in the event of a failure on the home server. We are thinking about what to do with the tape drive and tape th…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
Re: IDS on HACMP
This is a multi-part message in MIME format. --------------55F7CC0E714E518848B71DB6 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit HI, I know of a site that has this setup. How it was configured was we had a mirror copy of informix installed (includi…
IDS on HACMP
Hi, Currently I'm handling IDS 7.3 on R/S 6000 F50 machine. My company want to upgrade the system for the purpose of availability. Therefore they wanted to implement High Availability Clustering Multi Processor (HACMP) meaning that they will put another server that will share th…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Problems with ole-db connection
I'm trying to make an ado connection (through ole-db) from an application running Windows 95 client, to an IDS 7.31 server running on NT. The middleware I'm using is SequeLink from Merant. Any attempt to connect to the server fails with a handshake problem. Merant tell me that th…
Re: High-Availability For Informix
From: Don Ignacio <dignacio@openratings.com> > >Anybody out there can suggest some high-availability solutions using >Informix. >Something like an automatic switch over. Really, about the easiest and most robust way of doing this is to use HDR. ER is a lot of work (even if it is…
Re: High-Availability For Informix
Hi, We are currently using IDS 9.2 on a Sun E45000. In this Informix version they removed the DRAUTO configuration parameter, which basically tells the secondary server what to do in case the primary server fails. This parameter is existing in 7.x. The easiest way to overcome t…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
RE: Cluster with informix.
I agree -- I don't think a cluster is really worth it. We have a very critical app. running on a small HP K460 box (2 Gb memory, 70 Gb disk, 4 CPU), connected via HDR to a similarly-configured K400 box. The two boxes are several hundred miles apart, and yet replication to the s…
RE: Informix and HP MC/ServiceGuard implementation
We are in the process now. So far, I am leaning toward Informix HDR replication for the database failover and using MC/Serviceguard for application failovers. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and …
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Issue with query path chosen by Informix 7.20 UC2 optimizer ***Help*** :*(
We're running Informix OnLine 7.20 UC2 in an HP-UX 10.10 environment and one of our more simplistic two table join queries seems to be being mis-optimized. The query is listed below: SELECT * FROM product_vendor, product WHERE prod_upc_num = pdvn_upc_num …
How to choose a DB
Tim Schaefer wrote: > > Mark, > > My comments below... > [Snip} Tim - we have had this conversation before. > You can use Informix's 4GL or whatever to link to the engine, and the > engine takes care of the details of bringing back the query. 'Bringing back the query' - it's i…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Extents
> I need to expand the extents for most or all of our tables in our db. What > would be the best way to go about this? > > The only obvious idea I have for now is to do a dbexport, edit the output to > reflect larger extents, drop all tables and then do a dbimport? Yes, definite…
Software FailOver
Hi, does anyone now if informix dynamic server can do a software failover without hardware clustering ? We are planning to use two servers with replication. The Clients should see one server. In case of failur, the standby server should take over client requests. Thanks in adwan…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
Informix Client SDK - Powerbuilder 6.x (Urgent)
Hi! I have the Informix Client SDK installed on a Windows95 workstation and ultimately would like to conenct PowerBuilder6.5.x to an Informix Database on a server running SCO Unixware. Residing on the server is Informix SQL 4.14 and Informix (DB) SE 5.3. I cannot connect to the…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Re: Largest Informix Database size
David Williams wrote: > Of course you could probably scale further if you have the hardware, > if 176 is possible I wonder what the limit is, Tim? > > David Williams David, XPS is unlimited in a cluster context, but limited on each coserver in the same context as a typical…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
two access to 2 differents informix Database - 2 acc�s � un 2 bases Informix diff�rentes
I want configure Informix Cli -SDK to connect two database informix on same server : /manager/base/manager.dbs and /perso/my/test.dbs. -------------------------------------------------------------- Je veux configurer le driver de Informix Cli-SDK pour me connecter � 2 bases …
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Anyone using HDR with SAP?
I am considering using HDR to provide a "hot site" backup for my 24x7 SAP production database. I would appreciate input from anyone who has done this already. Has it worked as expected? Have you experienced failover to secondary and back again? How do your application servers get…
Informix Database Administrator
If your looking to advance your career and work for a dynamic company....look no furthur. We have a client in the South Jersey area (10 minutes north of Cherry Hill) with an immediate opening for an Informix DBA to work in their Information Technology Department. They are seeki…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
IDS refuse connection on NT when connected to Internet?
The strangest thing; I just noticed that whenever I connect to Internet, I can't connect to my IDS 7.3.TC7 on NT (connection refused - Agent_log: Attempt to connect to database server (%s) failed.) As soon as I disconnect from internet, connect works. But IECC does not work (S…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
RE: Dsn-less connection to informix
Can you connect via ilogin? Can you make a connection with a DSN? If not then your connection string isn't the problem. If you can connect then it is your connection string. Try tracing a DSN and DSN less connection (via odbc manager) and compare. Kang U wrote in message <7eh11…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Re: Connectivity help needed
You may need to investigate the use of I-NET ( Informix NET ) and CLI ( Call Level Interface ). I-NET is an sqlexecd daemon that sits on the Unix server waiting for client requests usually from CLI which sits on your PC. CLI SDK ( software development kit ) is available FOC from…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: How to reduce SE .dat & .idx file sizes?
In article <353F881E.15476F01@fullcompass.com>, Alan W. Jurgensen <alan@fullcompass.com> writes >hiya, > >we're running informix SE version 7.X on AIX RS/6000. I have some >development databases I want to trim the DB file sizes down on... >deleteing old records does nothing to r…
How to reduce SE .dat & .idx file sizes?
hiya, we're running informix SE version 7.X on AIX RS/6000. I have some development databases I want to trim the DB file sizes down on... deleteing old records does nothing to reduce the file sizes... I've read in the Faq: 6.8 Space reclamation In the good old days of SE, a t…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
PRESS:RECORD-BREAKING ONE TERABYTE TPC-D BENCHMARK UNDERSCORES
RECORD-BREAKING ONE TERABYTE TPC-D BENCHMARK UNDERSCORES INFORMIX'S LEADING-EDGE DATA WAREHOUSING SOLUTIONS Informix/Sun Microsystems Demonstrate Ongoing Industry Leadership, Competitive Pricing for Performance-critical Business Solutions MENLO PARK, Calif. (FEBRUARY 25, 1998) …
XPS failover
All, Can anyone tell me how Informix XPS handles failover? The XPS Tech Brief on Informix's website describes Informix XPS on a clustered system as having an Informix database server (called a coserver) running on each node of a cluster. Each coserver then has access to its own…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
PARALLEL Processing Connection, January meeting notice
January 12th ... Boris Klots starts off the new year with a detailed description of the Oracle relational database system. This important application can be used in an exclusive or shared mode, i.e. one or multiple Oracle instances, respectively. The shared mode allows concurrent…
Re: Multi Thread App
David Williams wrote: > In article <68tpjb$q9j@cssun.mathcs.emory.edu>, "Art S. Kagel" > <kagel@ns1.bloomberg.com> writes > >On Tue, 6 Jan 1998, Alexander Jaremenko wrote: > >You use the CONNECT TO ... AS <connection name> statement repeatedly with > >different connection names…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
ODS in Sun HA environment
Greetings, We are looking at installing ODS 7.23 on a High Availability system using Sun's HA software running Solaris 2.5. The cluster has two Sun Ultra 3000's with disk farm's attached to each server. One of the servers is used as the primary DB server and in case of failure…
New Era and Crystal reports
Is anyone using the New Era Crystal report class in either 16 or 32 bit mode ? Have you managed to get it to work ? Are there any problems ? Are you using native or ODBC connection ? Regards Nick Woodruff Topas (UK) Ltd nwoodruff@topas.co.uk…
NewEra 3.0 TE1 - Window Painter default connect to DB.
Hi all, Just managed to connect to our remote Standard engine 5 database through window painter on SCO Unix. Un-fortunately, each time I load up window painter I have to connect to the database manually. Can I auto connect to a default database? Our make it prompt with options…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: Informix and Clustering
Informix and NCR have some special cooperative solutions to this used successfully by several customers. There was even a setion on this at the reasent user conference that your local Informix office may be able to get information on for you. NilsL@simac.nl (Nils van der Laan) w…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Connection problem
I am trying to connect to my Informix box with Space Manager (I have Informix OnLine Workgroup Server on a NT4.0 SP2 box). I get an error message saying I can't connect to <server>. Now I can connect with the Database Manager. I have no clue to where to look to try and correct…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <5j6eju$h25@omni2.voicenet.com>, gray@voicenet.com (Scott Gray) wrote: > > In article <33538a45.29051694@news.jax.mindspring.com>, > Reid Fleming <RFleming@aol.com> wrote: > >Dave Raddatz <raddatz@austin.ibm.com> wrote: > > > >>Steve Phelan wrote: > >> > >>I think La…
Re: CLI 2.5 setup???
Thanks for all your suggestions so far. I have managed to figure out that the ODBC is not the problem. I have been able to connect to the database using Crystal Reports and ODBC. There must be something with the application. I will try to find out how the programmers coded the …
Re: free up disk space
Wendy, The answer to your question, depends on the use of the table. What I mean is that the "Create cluster" or "Alter index to cluster" statements will rebuild the table, compacting all rows and freeing disk space taken up by deleted rows while the table is still active and a…
pb/informix interface
I'm no powerbuilder expert but I'm curious to know if anyone else has encountered this problem. We have Powerbuilder running on Client pc's connected to Informix Online 7.12 running on SCO Openserver. As the domain names expand we have run into a limit in connecting from one sy…
Need help with hp volume management and Informix
Greetings, I work with a large non profit relief and development organization that uses informix7.2 on a hp9000 version 10.10 of the os. We have created for each db space a hard link to logical volume within a volume group. So what we have is 30 volume groups with 30 logical vol…
Re: Indexes and Stored Commands/Procedures
Sammers, It is always good to re-index periodically, because that will remove all the holes in the pages and also update the statistics page(clustered index only). In some cases the holes in the pages could also aid in good performance because the server does'nt have to do frequ…
Re: SCO not recommended for high number of users.
jparker@boi.hp.com (Jack Parker) wrote: :> :> > My point here is that the current numbers *seem* to show better :> > results - substantially better - than most medium sized risc based :> > Unix servers, including the K-series from HP. Currently it's simply :> > an interesting ob…
Re: SCO not recommended for high number of users.
Nils Myklebust (Nils.Myklebust@ccmail.telemax.no) wrote: : jparker@hpbs3645.boi.hp.com (Jack Parker) wrote: : Jack, the following isn't written so much to disagrea with you as : to give others in the group some new information. You may have noticed that I'm very reluctantly dra…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
PRESS: INFORMIX SUPPORTS DIGITAL TRUCLUSTERS 64-BIT SOLUTIONS
INFORMIX SUPPORTS DIGITAL TRUCLUSTERS 64-BIT SOLUTIONS MENLO PARK, Calif., (April 17, 1996) -- Informix Software, Inc. (NASDAQ:IFMX), the leading provider of innovative database technology, today announced its support of Digital Equipment Corporations new UNIX TruCluster Solutio…
Tips on a highly available & scalable dbms needed
We are trying to select a relational database that will have the following properties: - Windows NT compatible: use native NT threads, and not be just a Unix-port to NT. Plus all of the product (tools, APIs, etc.) must function in the NT environment. - Scalable: up to 100 milli…
PRESS - INFORMIX INTRODUCES ONLINE EXTENDED PARALLEL SERVER
INFORMIX INTRODUCES ONLINE EXTENDED PARALLEL SERVER Industry-Leading Dynamic Scalable Architecture Extended to Clustered SMP and MPP Environments New Parallel Server and Best-in-Class Partnerships Offer Today's Most Powerful Data Warehousing Solution SAN JOSE, Calif., (July 18…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
ANNOUNCE [ODBC Router for Mac/NT]
FOR IMMEDIATE RELEASE Contact: Thomas Gray AUGUST SOFTWARE CORPORATION 23232 Peralta Drive. Suite 202 Laguna Hills, California USA 92653-1437 Telephone (714) 454-9007 x443 Fax (714) 454-9032 North-American FAXBACK Service (714) 454-9007 x411 AppleLink CompuServe…
PRESS Development Platforms To Include AT&T Global Information Solutions and IBM Massively Parallel Solutions
Informix to Deliver Parallel Technology for Loosely Coupled Clusters and Massively Parallel Systems Development Platforms To Include AT&T Global Information Solutions and IBM Massively Parallel Solutions Commercial Parallel Processing Conference, Chicago, Ill. (Sept. 12, 1994)…