Oninit® Archive
Results for “FAILOVER_TX_TIMEOUT”
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 …
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
Kenneth: Remember that the DRDA protocol is not the native Informix connectivity protocol, SQLI is. DRDA is the native DB2 protocol and it does not recognize either CM or SQLHOSTS group entries for connection failover. There is no way to fix that as this protocol is owned by the …
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 ------------------------------…
What prevents a RSS to roll forward as fast as its primary?
Dennis: Tuning Informix on Power is a complex subject, but, in general, secondaries work best if the secondary is identical to the primary. Otherwise, assuming those resources are needed on the primary for normal operations, how will you survive if the secondary has to become the…
Informix HA Cluster and CM
I need to setup a HA cluster with replication. We are able to replica and test failover both ways on node1 and node2. HOw do I get a cluster server on these 2 nodes. so that the Connection Mgr is able to control failover and route connections to the new active node? Do I need to…
restore through STDIO
Hello. Unless you are trying to create an RSS node on your cluster, I don't see any benefits in using zip/unzip. 1-huge cpu consumption in a serialized method. 2-your network link should be already a high speed to accomodate your primary load for HDR replication. 3-if you are dea…
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…
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 ------------------------------…
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…
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…
configure sds with raw device
Hello. Informix SDS depends on a cluster filesystem, managed by your OS to work. I think this article will give you some more details: https://www-01.ibm.com/support/docview.wss?uid=swg21623842 Just remember that SDS in read/write mode need according licensing. If you will use …
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…
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.…
locks persists while client app is down
If you confirm that the locks belong to Global Transactions (aka xa transactions), then there is no direct way to clear them without a restart (and they will probably survive the restart??). One way is checking the RFE in: http://www.ibm.com/developerworks/rfe/execute?use_case=v…
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…
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…
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…
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
Since CM is arbitrating the failover, drauto value is 3, so it's another case compared to what you've told me. Yes, it's possible to switch when drauto is 2 but my case is different:drauto 3 - proxy mode…
Compress Repack Slow Performance
Dear All, Have an instance of Informix 11.7.FC4 that runs on AIX PowerHA Cluster, IBM POWER machines, with 64 logical cores, 160GB or RAM memory and FC storage. Have a total of 600GB of chunks, containing few big tables within 1 DB (100GB (100mil records), 70GB, 50GB) fragmented…
Re: jdbc connect to cluster
I must be doing something wrong, with both cm up everything works ok always. When I turn one cm down I get exceptions randomly. Am I missing something else to force the swtich in case of failover? jdbc:informix-sqli:informixserver=ifx_lab_ps;SQLH_TYPE=FILE;SQLH_FILE=/opt/infor m…
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)…
new features about dynamic parameter added in 12.1
Attention, this is not documented. For Informix 12.10, another way you can get the list is to use the cf_flags column on syscfgtab to determine which onconfig parameters are dynamic: SELECT cf_name FROM sysmaster:syscfgtab WHERE bitand(cf_flags,'0x1') = 0 --removes Unsupported p…
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 …
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 --…
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
Flip: Whoa! I've heard of salespeople streching the truth, but this is a bald faced lie! Or more than one actually. Either the salesman is lying to you or his management lied to him! I'm sure someone from IBM will join this thread, but for now here is the truth as I know it: - …
Logical log size
Hi, the size of a single logical log file should be set in a way to not lose much data when it comes to the most severe condition that you would have to restore a database system which is down and inaccessible (so you cannot get any more the active log using salvage logs). We h…
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…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Re: Sysmaster - Tabelas Temporária
On 20/01/14 17:20, Fernando Nunes wrote: > I'm not absolutely sure I got your requirement correctly... You say: > > "a program that runs once .... keep the session alive": > You cannot keep a session alive without a program running. > > Then you say: > "I need to drop temporary t…
Using Informix ODBC with connection manager
Hello. As soon as you implement your CM, it will be a "network gateway" for your production cluster (and maybe redirect your connections to any cluster node, according to your CM defined policy). So, your ODBC connection will be changed from your database, to your CM hostname/p…
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.…
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…
redundant connection manager configuration using H
Hello. I would suggest you to search in Member Area, IIUG Conference materials have several presentations about CMs usage, including advanced cluster, with more than 1 CM for failover process. I hope it helps to give you a better idea for your specific needs. But in case you s…
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…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Re: HDR Reconstruction (with ER :-))
Keith, this is exactly the scenario described. As long as the logs on the remaining server have wrapped (ie the newest log on the down/recovered server is still online on the surviving server, then you can make this recovered server the secondary by running the onmode -s primary…
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…
SQL/Optimizer Question
Just eyeballing the schema provided I am guessing you will get 16 rows per 2KB data page. assumed row size of 120 bytes. WHERE i_case_relation_cd = 3 is currently evaluated to return 98,108 rows while we do not have the statistics on the table, the cluster value would indicate h…
Lost data
You said something, specifically that Informix does not loose data. And in past posts I'm sure you explained a lot more in a lot more detail. And I wrote you already said it. I just gave some clues to specific problems that could cause the effect mentioned by the OP... Probably I…
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 …
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
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…
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…
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 …
HDR question once again
Jack: You are missing a lot. A bit of recent history then. Informix from version 7.10 through 7.31 and 9.10 through version 10.00, supported two overall replication types: 1. HDR or High availability Data Replication - This supported one read/write primary server and one read-…
Informix Clustered Indexes
On Tue, Jan 31, 2012 at 07:53, Tom Lehr <tomcaml@gmail.com> wrote: > Have been doing some reading about clustered indexing and wondering > what experiences other folks have had with them? > We currently do not use them in our high transaction OLTP world and am > a bit wary due t…
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.…
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…
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…
SDS and SAN Storage
On Aug 12, 8:21 pm, rpa <ruediger.pa...@t-online.de> wrote: > Hi all > > what is possible and what is the best way to create chunks on a SAN- > Storage (NetApp) for SDS. > We are planning for IDS 11.50 database installations with SDS feature. > > OS will be LINUX (SLES or UBUN…
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…
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…
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…
RE: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
> From: domusonline@gmail.com > Subject: Re: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this? > Date: Mon, 7 Dec 2009 23:14:12 +0000 > To: informix-list@iiug.org > > Ian Michael Gumby wrote: > > I have to agree that the issue is interesting…
MACH 11 questions
Zev, Can you draw me a picture? While the active SDS node must be using the same shared disk as the primary, there is nothing which says that the secondary node (HDR/RSS) = can not be using a different shared disk. And since the amount of time to start up a SDS node is fairly s…
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…
ANYONE KNOW IDS USERS OR CONSULTING FIRMS IN NYC
I am looking for work in the New York City metro area. Can anyone refer me to an end-user or a consulting firm?.. below is my resume: Frank J. Rotolo, frank.pr@msn.com _______________________________________________________________________________ Summary: Over twenty six years…
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 …
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…
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…
Re: 11.50.xC4 Compression with workgroup edition?
An easy way to distinguish between IBM (DB2 and IDS) compression and Oracle compression is to look at e.g. an employee table with, say names and addresses and other junk (like salaries ;-) Block compressions wins, as Mark points out, in fast changing data. Global compression wins…
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 …
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…
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? …
Re: Smoke and mirrors...
On Oct 12, 2:20 pm, InDeep <ind...@indeep.com> wrote: > Ian Michael Gumby wrote: > > To your point. Yes IDS will perform much better that either Oracle or > > DB2 in a VM environment. > > Let's not make sweeping statements without facts. I have been happy with IDS > so far on VM…
Re: Smoke and mirrors...
Ian Michael Gumby wrote: > To your point. Yes IDS will perform much better that either Oracle or > DB2 in a VM environment. Let's not make sweeping statements without facts. I have been happy with IDS so far on VMware Fusion on my Macbook Pro, but I have not had a history of ex…
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…
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…
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…
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
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > ROBERT ROMERO > Sent: Thursday, May 08, 2008 1:59 PM > To: ids@iiug.org > Subject: Re: Managing IDS in IBM HACMP environment [12053] > > Appreciate the comments. > > We are plan…
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…
table level lock
Guo, Denny wrote: > Thanks Art, > > Say the lock been hold by poorly behaved applications for a long period, > can we do something on database side in case we can not restart the > application? > Say issue some command to rollback or commit the transaction. The key > problem is t…
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: Optimizer Issues with 10.00.xC8
Another point of confusion that has me summoning the UPDATE STATISTICS gods. As a reminder, my test table ("foo") looks consists of five columns, col1-col5. Col1, Col2, and Col3 are integers, while Col4 and Col5 are character fields. I have a unique index on (Col1, Col3) and a…
High Extent Tables.
Quick question: 1. If I create a clustered index and drop it on a table with high extents, will that reorganize it and reduce the extents or 2. Do I have to unload the data, drop the table, re-create the table, and re-load the data or 3. Should I rename the original table to a…
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…
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…
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
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 during an HDR failure. Switch back to secondary when restartin…
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…
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…
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…
IDS is busy all the time
Art, Thanks for offering this help, I now solved the problem by restoring the database. And: We do use you dostats, was a misspelling of mine. What I found out, which might interest others is the following: We had a crash of the server, at a point in time where the session in qu…
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166401364.229016@bubbleator.drizzle.com... >> Tambi Dude wrote: >>> "DA Morgan" <damorgan@psoug.org> wrote in message >>> news:1166388023.574809@bubbleator.drizzle.com... >>>> How one defines quality is…
HP-UX PA-RISC/Itanium
HP claims that HP-UX maintains high degree of compatibility between PA-RISC and Itanium based system. Here is the quote from document they published on their website (http://h21007.www2.hp.com/dspp/tech/tech_TechDocumentDetailPage_IDX/1,1701,9928 ,00.html): "One of the design go…
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/…
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: 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.…
Free space...Clustered Data
Urich Ann wrote: > Do many companies use clustering indexes...via table data ordered by a > key (clustered)? > > Is there a performance boost in Informix when the data is clustered -- > and then retrieved via cluster sequence? The performance benefit is marginal - and debatable.…
Re: IDS 10 erratic run times
"Neil Truby" <neil.truby@ardenta.com> wrote in message news:3pliprFb403pU1@individual.net... > IDS 10.0FC3 on Solaris 2.9 > >>> This is a brand new server which we are preparing to migrate a v9 system >>> to. > Over the past few weeks I have run multiple dbimports from more-or-le…
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…
Re: Manually Unlocking records in IDS
... unless it's a global XA transaction "Art S. Kagel" <kagel@bloomberg.net> a �crit dans le message de news:42CAAF2E.6020406@bloomberg.net... > JoeT wrote: > > Hi... > > > > I have a PHP application under development and have an annoying > > problem. > > > > I am purposely tryin…
Re: No future for DB2
Comments in-line. Obnoxio The Clown wrote: > DA Morgan said: > >>Larry wrote: >> >>>I don't think you could convince the Oracle marketing people of that for >>>the temporary periods when they have been in the lead ... >> >>I agree. But then I can't imagine why any serious techno…
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: Manually Unlocking records in IDS
JoeT wrote: > Hi... > > I have a PHP application under development and have an annoying > problem. > > I am purposely trying to kill the code (testing) and sometimes when I > trap an error, I'm getting codes bad of 244 and 107, saying that a > record is locked. I can't do anythin…
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: Update Statistics
The order I run update statistics is 1) MEDIUM DISTRIBUTIONS ONLY, 2) HIGH for first column in an index, 3) LOW for all other columns in an index, 4) UPDATE STATISTICS FOR PROCEDURE <procname> Is this still the recommended order? Regards Colin >From: "Andrew Ford" <andrewfor…
Re: Update Statistics
Yeah. I've got all of that. But is it true that running update statistics high (or medium) without the 'distributions only' clause does the work of low (building statistics) plus some extra stuff (building distributions). I've been putting a lot of work and thought into optimi…
RE: Update Statistics
Update statistics low doesn't build distributions, the way high does. It compiles information about the structure of the indices (depth, leaf nodes, clustered-ness, second-highest and second-lowest values, etc), and places them in systables, sysindexes (or sysindices, in IDS 9.4.…
Re: XPS
"Mark Townsend" <markbtownsend@comcast.net> wrote > Oracle was using three pricing metrics in those days - unlimited user > pricing based on the MHz of the CPUs, named users and concurrent user. > > In 2000 the unlimited user pricing for Oracle Standard Edititon was $15 > per MH…
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…
Re: serial and sequential scan
superboer7@planet.nl (superboer) wrote in message news:<bb790a36.0502160532.2c2ac371@posting.google.com>... > where is OPTCOMPIND set to???? if 2 then set it to 0 > > or > > export OPTCOMPIND=0 > > start dbaccess with your problem qry. > > Superboer. > > > > "Bill Dare" <dareb@je…
Re: serial and sequential scan
hajek@nspuh.cz wrote: UPDATE STATISTICS MEDIUM FOR TABLE... Is insufficient. Unlike HIGH and LOW, MEDIUM does NOT update the systables, syscolumns, and sysindexes records. It is the information in the latter that IDS uses to determine the cost of using a particular index. I …
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'?…
Re: dostats with ANSI logged database?
On Fri, 10 Sep 2004 13:56:14 -0400, Roy Mercer wrote: > Art, > > I did not change anything from your source. I just compiled it straight > from the IIUG. I run this as "informix" but the tables are all owned by > sysadm. The first table it stops on "psdbowner" has an owner o…
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: 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: Views question?
Comments in-line. rkusenet wrote: > "Mark Townsend" <markbtownsend@comcast.net> wrote > >>Hey - I'm the bug, fat buzztard. Anyhow, still no winner. I believe both >>of these do have Alter Table Drop Column. So who could it be ? Lets >>think about this for awhile. Are we all thi…
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…
Re: An interesting meeting with IBM
"Andy Kent" <andykent.bristol1095@virgin.net> wrote in message news:ac5fb36.0404080205.28a8b515@posting.google.com... > Data, > > Yes, I've worked with Oracle. > > Not sure why you ask. > I needed to get answers first before proceeding. Most of the time when people say they will…
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…
Confused by "Database" concept in Informix
Chris Bullivant wrote: > My background is in Oracle. I've been working on some Informix DB's > for about 18 months but without any formal training. Congratulations for surviving without the formal training. A little bit of it would help you a lot, though. I recommend an admin…
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.…
Re: Anyone seen this behaviour before ?
TBP <TheBIgPotatoe@Nospam.Nothere.Co.Uk> wrote in message news:<brn87n$vi0$1@sp15en20.hursley.ibm.com>... > mad_villan wrote: > > I have a HDR pair which were working fine up until lately. The primary > > runs in a veritas clustered environment - secondary is standalone. > > Conf…
Anyone seen this behaviour before ?
I have a HDR pair which were working fine up until lately. The primary runs in a veritas clustered environment - secondary is standalone. Configuration is fine. However, when i recently failed over to the second node in the cluster the instance came up cleanly BUT there was a con…
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.…
oncheck -me Feature Request
OK, I've collected the comments of the discussion on oncheck -me, and my own correspondence with contact, and these are the results of my investigations: 1- oncheck -me was never intended for general release 2- it was not completed internally and is not completely safe, meaning…
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…
AWAITING YOUR RESPONES
This is a multi-part message in MIME format --b4433c0d-cded-4954-bda4-88422ad1fcf3 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Good Day, With warm heart I offer my friendship, and my greetings, and I hope this letter meets you in goo…
AWAITING YOUR RESPONES
This is a multi-part message in MIME format --b4433c0d-cded-4954-bda4-88422ad1fcf3 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Good Day, With warm heart I offer my friendship, and my greetings, and I hope this letter meets you in goo…
force engine to use indexes
Because your update statistics indicate that the data is highly unordered and will result in multiple hits for the same data page. Because of that, it is mathematically faster to do a sequential scan of the data pages and sort them than it is to hit the same data pages multiple …
sequences
Artem Goncharuk wrote in message <949d61$20s9$1@nl.novosoft.ru>... > >Can you give me the routine code, please. The problem is that my >application works with several databases in unified way. So it is not >a porting from Oracle to Informix generally... Sigh* Database independen…
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…
Avoiding rebuilding of indexes
<Jinu.Joseph@citicorp.com> > We operate on a database of size 22 GB. For operational efficiency and > speed it was suggested that the indexes be dropped and recreated on a > weekly basis. Now the problem is that this takes 7 hours, and we dont > have that much time. So there are …
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 …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: NUMCPUVPS
mmmmm In addtion to what the others said.... Are you running KAIO? If you are do the following echo "_ncols/D"|adb -k /stand/vmunix /dev/kmem If this going up at all be worried, if it's going up real fast be very worried. It measures the number of collisions ie the number o…
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…
Access Tables from Different Database
Kit Ming wrote: > > Hi all, > > I'm trying to write a program which works with 2 databases and has the > following algorithms. Could you please give some leads to me on how to > code this in Informix ESQL/C. As I understands that we cannot open > connection for 2 database simu…
IDS 9.20 in a Clustered Environment
Hi All, Has anybody implemented or used IDS 9.20 in a clustered environment? I would particularly like information regarding its uses as a High-Availability and Scalability Solution. Any information will be greatly appreciated. Thanks, DOn…
ODBC connectivity with EDS
Hello Admins, I having a problem connecting to my EDS environement running in a clustered environment. I have SDK (2.40 TC1) in my windows NT workstations and when I do Ilogin demo and try to connect to the EDs database I get -952 error. I have a IDS 7.31 enviroment in the sa…
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…
Re: Writing files with stored procedures
In that case, can't you just do something like: system "echo something >>xyzzy"; >>> Arnaud ANDRIEUX <arnaud.andrieux@aql.fr> 06/13/00 12:43pm >>> Hi Jonathan ! Jonathan Leffler wrote: > Watch out for databases with transactions where you want the log message > to survive a r…
Re: Writing files with stored procedures
Hi Jonathan ! Jonathan Leffler wrote: > Watch out for databases with transactions where you want the log message > to survive a rollback operation... The purpose of my logs is only to track each call to a procedure, regardless to the execution of this procedure. So I don't hav…
RE:
From: SAMPATH <sampath@gulfins.com.kw> > Its not RAID. Its a cluster software as series of disks will be >in a box accessed by differenct Unix servers. Thanks. I believe the technical term is "disk farm" :-) OK, as long as it's not RAID 5, you're over hurdle no 1. Now for hur…
Re:
From: SAMPATH <sampath@gulfins.com.kw> > > We're having IDS 7.3 running on Alpha 4100. All DBspaces are raw >partitions and mirrored. We are planning to move the disks out of >machine and put them as a disk array with clustering software from >Compaq. 5 disks + 1 emergency disk. …
RE:
Hi, Its not RAID. Its a cluster software as series of disks will be in a box accessed by differenct Unix servers. Thanks. Sam > -----Original Message----- > From: Obnoxio The Clown [SMTP:obnoxio@hotmail.com] > Sent: 01 June, 2000 11:44 � > To: sampath@gulfins.com.kw; informix…
Posting from the Informix-list
Hi, We're having IDS 7.3 running on Alpha 4100. All DBspaces are raw partitions and mirrored. We are planning to move the disks out of machine and put them as a disk array with clustering software from Compaq. 5 disks + 1 emergency disk. Has anyone tried this before? If one of 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: Top Databases Used
Well it depends on all what you will be doing with your database. OLTP "based stuff" Informix, no doubt, fastest in the market at oltp with little or no headaches. Warehousing data of 1 terabyte or more, Teradata, period. Easy to manage, DBA's dream. "Stuff's not running fast…
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 …
Re: informix, linux and beowulf
Informix does NOT use that kind of clustering as is present in Beowulf. The Informix clustered product, XPS or IDS 8.xx, uses multiple co-servers in two distinct ways. 1) It can spread a database, indeed even a single table, across multiple coservers on the same or on different…
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…
Borland Delphi and Informix
Hello everybody, we have huge performance problems on our 2-node Sun-Cluster with Informix: Environment: Sun E4500, 6 CPU's, 1GB Memory (primary host for database) Sun E3500, 4 CPU's, 1GB Memory (secondary host for takeover) 4 A5000-Diskarrays with 14 9,2GB disks each connec…
Informix ESQL C Problems on AIX
paul_montgomery@my-deja.com wrote: > > Hi, I am new to Informix's ESQL C APIs and > have run into some problems on AIX. The biggest > problem is that I can't seem to perform a select, > iterate the results and then perform another > select based on some values from the first …
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…
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…
IDS on NT feasability
This is an OLTP or DSS system? For a 50GB system, personally, I'd opt for some kind of UNIX. NT just chugs its heart out and as was mentioned, is more expensive the bigger it gets. Of course, you could pilot the system on both NT and a UNIX of some kind. IBM has good NT, in …
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…
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…
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…
A question about Indexing.
Vijith Gunawardhana wrote: > > Hi > > In my work environment we are using Informix Dynamic Server AD and XP > Options 8.2. > Seems that nobody else has taken a crack at this, so I'll have a go (and try to leave my prejudices at the door :-)). > > Here they don't use indexes at …
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…
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…
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…
RE: -710 Error in Multithreaded Informix 7.24 UCX5 on HP-UX 10.20
We also had this problem and figured out that when we did a HPL it changed the constraints and indexes, loaded the data and then changed the constraints and indexes back to what they were defined originally. -----Original Message----- From: Art S. Kagel [SMTP:kagel@bloomberg.n…
-710 Error in Multithreaded Informix 7.24 UCX5 on HP-UX 10.20
Jim Maus wrote: > > My multi-threaded Informix esql process received a -710 (table-name has been > dropped, altered, or renamed) error. The process was using a prepared > statement to fetch using a cursor. The source table was not dropped, > altered, or renamed. I cant reproduce…
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…
What means are cursor types?? where are manuals??
Chang-Woo Park wrote: > > cursor is id of rows of table.(as I know...) > > I have found cursors that found sequential, scroll, hold, and update > > but I don't understand four types of cursor > > what means are cursor types?? where are manual?? The manuals are online at the Info…
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…
isolation level question ?
steffy lin wrote: > > Hi, > > I know the difference between the cursor stabililty and repeatable > read, but what I need is to lock only the latest row fetched (as > cursor stability) and the lock is released only when the transaction > commits or rolls back , not when the cur…
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…
Re: Informix v7.24 on HP-UX 10.20
Hi Dave, 7.30.UC6-1 is available on HP-UX 10.20, David... P.S.: here is a the list of bugs corrected since 7.30.UC5 (maybe not critical bugs but the list is quite impressive). We solved several problems by migrating from UC2 to UC6 (I asked for UC5 but informix sent UC6. W…
sql server vs. informix
June Rigsbee wrote: > > My company is looking for a database for our intranet and extranet > data. The debate is between Informix and SQL server. We use Informix > already for our accounting system. However, we are adopting a lot of > Microsoft products as we migrate to web-ba…
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…
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: Errors 568 and 569.
Milen Metodiev wrote: > > Hi, > > Is there any way to connect to a database without logs from a database with > logs? I have a message : > 568: Cannot reference an external database without logging. No. Having said that, for versions of ESQL/C after 7.20, you can use a separate…
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?
We're also running SE-Databases and there is only one way to downsize the dat and idx file sizes: unload, drop, load or an dbexport/dbimport. My solution for this problem is to do a weekly dbexport/dbimport in cron. If greater/more lecks in your dat / idx files, this will slow d…
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…
Re: Data Warehousing Tools - To Bundle Or Not to Bundle?
I'll take a stab at this. We're a fortune 500 company and have Sticker Shock Disorder from the prices some companies are asking for their products. Not to say it's not worth it, yeh, you get what you pay for, but. We have survived on our existing Oracle database with MS Access…
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 Release
REDWOOD SHORES, Calif., Jan. 12 /PRNewswire/ -- Oracle Corp. (Nasdaq: ORCL - news) today announced Oracle(R) "Quick Snatch," a worldwide Informix conversion program, offering Informix customers, as well as other database customers around the globe, a exciting and challenging migr…
Re: Informix Directions
Has anyone out there been working with Informix since the late '80s? Remember how they simply dumped VMS support back then? Seth "Tim Schaefer" <tschaefe@mindspring.com> writes: >Yeah, um, but I heard that the SCO porting of Informix is over. There = >will be >no more SC…
Re: Informix Directions
Yeah, um, but I heard that the SCO porting of Informix is over. There = will be no more SCO ports, and Informix is dumping the small end. What does this do to the market, and in particular, my career path? It = goes in the dumper to stay with Informix. Apparently this is prob…
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…
Re: De-fragmenting tables. Some questions
An even easier way is to use the "ALTER FRAGMENT ... INIT ... " to rebuild the taregt table wherever you want. For a big table I'd do it at odd hours with logging off so you don't get bit by a long transaction. Greg Thomas J. Girsch wrote: > > Expanding on Art's expansion on …
Re: De-fragmenting tables. Some questions
Expanding on Art's expansion on David's suggestion: A quick-and-dirty way I used to use to defragment tables was to do an ALTER TABLE NEXT SIZE to set the next extent size sufficiently high, and then do ALTER INDEX <pick-an-index> TO CLUSTER. Be warned, though, that this method…
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…
Re: High Water Mark Question
Hi, LTXHWM - When the total number of filled logs reaches this amount, any transactions that started in the oldest logfile are marked as long transactions and are forced to roll back LTXEHWM - When the total number of filled logs reaches this amount, all processes except long t…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Chris Curvey wrote: > > > If you have row level locking, the first select stmt will lock one row. > > As the primary key is 4 bytes you can potentially put 4-500 keys on any > > page (if you have 2K pages). In a page lock system (like Sybase and > > MSSQL) the probability of a us…
Re: Question on Update Statistics
[This followup was posted to comp.databases.informix and a copy was sent to the cited author.] In article <19971107041400.XAA11881@ladder01.news.aol.com>, kponn@aol.com says... > Hi > > If I want to run update statistics on busy tables, can I do the following: > > 1. select tabn…
Re: [Q] How do I force usage of index
Daniel Williams <#danny@uk.ibm.com> wrote in article <341014AA.41C6@uk.ibm.com>... > > Is there any way I can force usage of the indexes to see if it makes any > > difference (presuming that the the query optimizer has decided not to > > use them for some reason) ? > > Have you r…
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: script or spl for update statistics
In article <5ujprh$mcu@cssun.mathcs.emory.edu>, zeljan@laus.hr says... > Hi, > > in Informix Guide To SQL Syntax there is recommendation for updating > statistics: > 1) run update statistics with distributions only > 2) run update statistics high for columns with indexes > 3) run…
Re: character-based tools on NT?
Joe Lumbley wrote: > > I've recently installed 7.22 ODS on Windows 4.0 and was very surprised > to find that onmonitor is no longer included on the CD. Since it's a 4GL- > based application, just copying an executable from an older system does no good. > > The "command center" G…
Re: WHENEVER ANY ERROR
>From: Jim Young <jim_young@choicehotels.com> >Date: Fri, 08 Aug 1997 14:19:03 -0700 >X-Informix-List-Id: <news.41439> > >[...] > My approach to error handling is to use "whenever any error continue" > at the top of every 4gl module. I then use a library function that I > …
Re: Informix and Clustering
Nils Myklebust wrote: > > 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. SUN, …
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…
Powersoft/Informix jobs Dallas
My company, S2 Systems, Inc., is a wholly-owned subsidiary of Stratus computers. We're a typical computer manufacturer culture, 3 wks paid vacation, good pay and benefits, no drug tests, etc. In short, a place where we value your abilities. We're looking for a Powerbuilder per…
Re: Help: Reducing Extents -Reply
Just a comment about Gregs posting. I have also used fragment to rewrite a non-fragmented table in place. I have found afterwards a high likelihood of receiving 243/172 errors on such tables. This seems to be reduced if they are [de]fragmented into a different dbspace that they…
Re: Help: Reducing Extents
Chad, after increasing the NEXTSIZE in systables (don't worry too much about the first extent, it'll tend to be coalesced pretty well unless you have a lot of fragmented tables in the same dbspace). two methods not mentioned are: 1. use onunload/onload - it's waaaay faster tha…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <862264236.20961@dejanews.com>, Brenda Muller <muller.brenda@primestar.tci.com> writes: > > >plans like clustered SMP systems with fiber between the boxes, > > >or some NUMA-like MPP systems with "memory" connectivity > > >between boxes (I still don't see how that woul…
Re: What INFORMIX product shall I use?
In article <335b1c95.5192566@gate.idg.no>, Nils Myklebust <Nils.Myklebust@idg.no> writes > >SE is still a very interesting alternative though. OWS is supposed to >be the replacement, and will give you a substantial performance >increase. However Informix still have quite a way to…
Re: RDBMS Server Performance Expectations
In article <j00encnqwjp.fsf@cs20.cs.auckland.ac.nz>, John Hamer <j- hamer@cs20.cs.auckland.ac.nz> writes > >I'm working on a MIS project which has some scalability issues with >its RDBMS, so I'm looking for comments from users of other RDBMS >platforms. I don't have any experienc…
Foreign keys and indexes
We use a mixture of foreign keys and application managed referential integrity, depending on our application. I prefer application managed RI on our larger databases because it is more efficient. We have some very large tables with highly duplicate values on the child columns t…
Re: ***Bitmapped Indexing API Beta - Now Available***
Patrick Gainer <gainer@64k.com> wrote: >Deon du Plessis wrote: >> 3) THE ROUTINES OVERCOME THE PROBLEMS ASSOCIATED WITH HIGH CARDINALITY >> >> DATA. This is basically acheived by breaking the data into sections. >> If there is no data in a particular section, a BM for that secti…
Re: cluster index
I agree with Billy et al regarding the process for updating. I thought I might add that we use clustered indexes as a means of database maintenance. Every so often we will suspend use of the database, run appropriate clustered index creates, and then remove the indexes on compl…
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: Locking outside COMMIT WORK
Bryan Tonnet wrote: > > In <3250B368.717A@netcomuk.co.uk> Ian Goddard <igoddard@netcomuk.co.uk> writes: > > The reason I use a select into temp (with repeatable read), rather than a > hold cursor, is that I think a cursor will only read (and lock) the rows > as they are accessed,…
Re: Indexes and Stored Commands/Procedures
On 12 Sep 1996 01:49:06 GMT, sammers@pop03.ca.us.ibm.net (crunch) wrote: > >General question on indexes. > > IMHO tables (with indexes) that have high volumes of insert and >delete operations need to be re-index periodically, else 'bad' things >will happen. Please comment. Hi, W…
Re: Turn Transactions on?
Darin Strait (71540.3036@compuserve.com) wrote: : Why would I not want to turn on the transaction log? (I assume that this : option was not exercised for some good reason and isn't the result of : someone forgetting about it.) I can see no mandatory reason for not having transac…
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…
Re: ESQL/C cursor looping
Allen W. Jantzen wrote: > > In ESQL/C when I am cycling through the rows returned by a cursor, if > an error occurs on the fetch (say, SQLCODE=-244 record locked), does > it make any sense to attempt to keep fetching additional rows?? > It depends on your application. Do you int…
Re: Informix, Sybase, Oracle or MS SQL server
> : Sybase: > : Liked dealing with them but it seems that they have some serious > : problems--no row-level locking, no two-phase commit. I like their > There's another thread in here kicking around row level vs page level locking. > It pops up periodically. I have not found …
Re: Log files in Online 5.x
> Can anybody tell me an easier method for changing th logfile size on > I-Online 5.x than unloading the whole database and reloading it with a > new size? When we went through and redesigned the dbspaces and table > distribution, we brought the system back up with very small log…
PRESS: EDS' dbINTELLECT TECHNOLOGIES & INFORMIX FORM STRATEGIC
EDS' dbINTELLECT TECHNOLOGIES AND INFORMIX SOFTWARE FORM STRATEGIC=20 RELATIONSHIP MENLO PARK, Calif. (April 8, 1996) -- Informix Software, Inc.,=20 (NASDAQ: IFMX) the leading provider of parallel processing database=20 technology, today announced that EDS dbINTELLECT(SM) (dbI)…
Re: Large table extents
Cheryl Kendricks wrote: > > Yes to question 1. Yet, if you have an index and set up query correctly > to use index it will use it. But once a table becomes highly fragmentted > either due to delete or insertions it is a good idea to unload and reload > the table. Or if you have …
Re: Large table extents
On Wed, 13 Mar 1996, Cheryl Kendricks wrote: } Yes to question 1. Yet, if you have an index and set up query correctly } to use index it will use it. But once a table becomes highly fragmentted } either due to delete or insertions it is a good idea to unload and reload } the ta…
Re: Large table extents
Yes to question 1. Yet, if you have an index and set up query correctly to use index it will use it. But once a table becomes highly fragmentted either due to delete or insertions it is a good idea to unload and reload the table. Or if you have enough space within the dbspace ju…
Re: Clustered indexes - again
} >So given these responses I am confused. Does leaving an index } >clustered effect future inserts/updates etc? } } >Robert Clark } } } > } >-------------------------------------------------------------- } >e-mail: robert@clark.netkonect.co.uk } >snail: 12 Balvernie Grove, Wan…
Re: Clustered indexes - again
On Wed, 13 Mar 1996, tolly brumbelow wrote: } robert@clark.netkonect.co.uk (Robert Clark) wrote: } } >OK, } } >I have now had a few responses to my original Q about clustered } >indexes - thanks to all of you. } } >Dan Madvig (d-madvig@bethel.edu) said: } >> If you leave it chus…
Re: Clustered indexes - again
robert@clark.netkonect.co.uk (Robert Clark) wrote: >OK, >I have now had a few responses to my original Q about clustered >indexes - thanks to all of you. >Dan Madvig (d-madvig@bethel.edu) said: >> If you leave it chustered, then every time the index changes >> the engine has t…
Re: To log or not to log, that is the question.
The advantages of using logging for non-transaction oriented databases means that you can recover from archives to the point of the last committed operation very easily. And you only get fast recovery on logged databases. You would never find it necessary to repeat a lot of dat…
Consistant database using archive 0 question
johnyc@mainelink.net wrote: >Our DBA and I are having a discussion regarding the consistancy of a database >that is archived. > >Issue: Informix provides the capability to do a complete archive if a >database while it is in use. > >Question: Can this database be restored witho…
Consistant database using archive 0 question
Our DBA and I are having a discussion regarding the consistancy of a database that is archived. Issue: Informix provides the capability to do a complete archive if a database while it is in use. Question: Can this database be restored without any logfiles (ie to a test enviro…
RDBMS reliability on DEC Alpha OSF/1
We are presently using Informix 7.1 (ud1) on a central database server for a bond trading system. Our hardware is a DEC alpha 2100 (4 smp) running OSF/1 version 3.2. We have about 15 tables that are used for transactions, and most of them see transaction rates of about five ins…
PRESS - INFORMIX AND SIEBEL SYSTEMS ANNOUNCE STRATEGIC PARTNERSHIP IN SALES AUTOMATION MARKET
INFORMIX AND SIEBEL SYSTEMS ANNOUNCE STRATEGIC PARTNERSHIP IN SALES AUTOMATION MARKET MENLO PARK, Calif. (Nov. 1, 1995) -- Informix Software, Inc., (NASDAQ: IFMX) the leading provider of parallel processing database technology, today announced a new strategic partnership agreeme…
Informix and Siebel Systems Announce Strategic Partnership
INFORMIX AND SIEBEL SYSTEMS ANNOUNCE STRATEGIC PARTNERSHIP IN SALES AUTOMATION MARKET MENLO PARK, Calif. (Nov. 1, 1995) -- Informix Software, Inc., (NASDAQ: IFMX) the leading provider of parallel processing database technology, today announced a new strategic partnership agreem…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
performance is the least reason to choose oracle over sypbase, ingres, informix. even if sybase and oracle were the same, oracle is superior in so many ways that it defies description. consider the mass of client tools, media tools, internet tools, and the presence of "row level…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Sorry...I can't resist... To paraphrase a certain executive: "We're faster, cheaper, better. Cool. Think about it. Then buy SYBASE." >For an apples to apples comparison consider the following: > > DBMS Platform CPUs TPC-Cs Cost/Transaction > ----…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
For an apples to apples comparison consider the following: DBMS Platform CPUs TPC-Cs Cost/Transaction ------- ----------- ------- ----------- ---------------- Sybase HP T500 12 5,600+ $390 Oracle HP T500 12 5,369 $535 …
** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
REDWOOD SHORES, Calif., Oct. 27 /PRNewswire/ via First! -- Today, Oracle Corp. announced a record-breaking TPC-C open systems benchmark, 9414 tpmC, surpassing the existing performance record, also held by the Oracle7 database. Oracle7's new record is more than two times faster …
Re: Care and feeding of OnLine
Okay, I was hoping that by being vague, I would get a wider range of responses. I see now, though, that I was too vague. I'll try again to get the ball rolling. What my client-oriented customer is looking for is some simple steps they can perform to keep their OnLine da…
Re: VLDB - for real?
What is a VLDB? Used to be 10GB, now it's 100GB, soon it will be 1TB. And the Intel 8086 used to be an adequate processor for most end-user computing. It's all relative. There's probably a corallary to Moore's Law in regard to database size. About the same time that Informix ann…
Re: Informix disk mirroring -- what good is it?
Interesting... Page cleaners also die when a controller is swamped by device requests. Are you sure the disk actually went bad? Informix recommends limiting the number of page cleaners based on the number of disk controllers. What release of 5.0 were you running (tbstat -V)? 5…
Informix disk mirroring -- what good is it?
We are running INFORMIX/Online 5.0 with INFORMIX based mirroring on an HP 9000 G40 running HP-UX 9.04. When we initially installed the software we discussed the tradeoffs of HP-UX LVM based mirroring and the INFORMIX database engine based mirroring. We explored this issue with …
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?…
Re: Clustered Indices
In article jql@ixnews3.ix.netcom.com, tcummins@ix.netcom.com (Tim Cummins) writes: >In <3p6toh$ojl@cssun.mathcs.emory.edu> phr@fmsc.com.au (Peter Harris) >writes: >> >>I have RTFM but I am still a tad mystified, when do you use clustered >>indices and when do you avoid them? what…
Re: adjacent row delete bug
} From: kwa@mtatm.mt.att.com (K.ANDERSON(MT5756)XXXX) } [...] } We are now seeing the problem with NON-adjacent rows. I am assuming we } are banging up against another bug. } } Does anyone know a another like bug ?? } Maybe it's not a bug. Are you using the default page lock mo…
Re: Miagrating Data from SE to ONline Engine
Ruchi Patel (.Ruchi_Patel@avid.avid.com) wrote: : I am miagrating Data From SE to Online Engine. I am going to use : DBEXPORT and DBIMPORT to do this eventually. Right now, I am using : Unload and Load statement to load tables into Online. Some of these : tables are very large an…
Re: Need help: zombie user threads
In article <3gffop$1k5@cssun.mathcs.emory.edu> calvinng@technet.sg (Calvin Ng) writes: >From: calvinng@technet.sg (Calvin Ng) >Subject: Re: Need help: zombie user threads >Date: 29 Jan 1995 02:23:05 -0500 >On Fri, 27 Jan 1995, Rolf Saalfrank wrote: >> We have a problem with our…
Data deletion in Informix
In Message-Id: <3d3v5v$lkc@raffles.technet.sg> sgs@technet.sg (Alan Chen) writes: > If I have done a mass deletion on tables, when I do a tbstat -d , I don't see > the space being free up. Is it the space was free logically but not > physically ?? The space is still allocated f…
Re: Loading ASCII data
: No way it will be taking 6 locks. You're probably getting both a long ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ : transaction and lock exhaustion at the same time. Unless, of course your rows are about 12K wide! (he says, following up on his own post***) -- ------------------------…
Re: Loading ASCII data
Dan Madvig - Bethel College & Sem. (daniel@genesis.admin.bethel.edu) wrote: : Anybody know how many locks are used per row when one is loading data : into a table? I'm trying to load 110,000 rows from a pipe-delimited : ASCII file into a table. Depends on whether you are using …
Re: Lockups!
Informix Sysadmin (informix@asl3.asl-labs.bc.ca) wrote: : On Wed, 26 Oct 1994, David Coburn wrote: : > What is in the log when this happens? Anything? : Nothing...just the fact that it has been more than the normal time span : since the last checkpoint. <snip> : The big prob…
Re: Table load fails - "Cannot close blob"
Paul Kiesel (kiesel@vishnu.ueci.com) wrote: : Gentleman and Ladies, : On a nightly basis we are unloading data from one table on a remote : system, transmitting the data to our local system, and loading the : data into an analogous table on our local system. : The following error…
Re: What affects performance?
In article <CqsC5J.H96@rosebud.strinc.com> amw@rosebud.strinc.com (Allen M. White) writes: >In article <2sk35o$80v@goshen.connected.com>, >Kurt Schmidt <slores@goshen.connected.com> wrote: >>In article <Cqq0no.9x9@boi.hp.com>, Jack Parker <jparker@boi.hp.com> wrote: >>> >>>But mo…
Re: What affects performance?
In article <2sk35o$80v@goshen.connected.com>, Kurt Schmidt <slores@goshen.connected.com> wrote: >In article <Cqq0no.9x9@boi.hp.com>, Jack Parker <jparker@boi.hp.com> wrote: >> >>But more seriously, Paul and the other posters made some very valid points. >>What the original reques…
Re: Record Locking
Suresh Kumar Bathini (bathini@netcom.com) wrote: : Hi There: : I have two clients in their transactions as below. : Client1----> : begin work : fetch a record R1 : : ..... : update R1 : commit work : Client2-----> : begin work : fetch a record R1 : update R…
Re: Logical Logs question
Steve Brown (steveb@sr.hp.com) wrote: : We are running ONLINE 5.02 UC1 on a HP9000 series 867 under HPUX 9.04. : Our tbconfig said LOGFILES 6 : LOGSIZE 500 : LOGSMAX 6 : These logs are defined in the root dbspace. : : We have been ru…
Re: Transaction Locks
Sampath Shrinivasan (sampath@netcom.com) wrote: : We are running Informix SE 5.o on Unisys U6000/100 using SVR4.0.1.2. : Oflate we are having some problem with the updates in a transaction. Whenever : the number of row updates in a transaction go beyond a couple of hundred : reco…
Re: Why this Long Transaction?
Jim Burks (jburks@promus.com) wrote: : In article <jlumbleyCKH6Hy.19r@netcom.com> jlumbley@netcom.com (Joe Lumbley) writes: : >Folks, : > : >I've run across something I'm not sure about and thought maybe the : >accumulated nettelligence could figure it out. : > My stuff deleted …
Re: Why this Long Transaction?
Ken Miles (kenm@vcd.hp.com) wrote: : Joe Lumbley (jlumbley@netcom.com) wrote: : > Folks, Deleted my blah.blah, blah.... : I'm following up two days after the original post and hope you are not : still in "fast recovery" but these symptoms bear a very strong resemblance : to a d…
Re: Why this Long Transaction?
Joe Lumbley (jlumbley@netcom.com) wrote: > Folks, > Twelve hours ago my large database was shut down ungracefully, with > a monster insert operation going on. About 2 million rows in the table, > but I don't know how many were actually inserted. On restart, we went into > that …
Re: Why this long transaction?
Dave Kosenko (davek@informix.com) wrote: : (Joe Lumbley) writes: : (Running into a long transaction, curious as to why) : |> Appropriate tbstat data follows: : The user and profile section (tbstat -up) would be helpful in trying to : figure this out. : (tbstat output deleted) …
Why this Long Transaction?
Folks, I've run across something I'm not sure about and thought maybe the accumulated nettelligence could figure it out. Twelve hours ago my large database was shut down ungracefully, with a monster insert operation going on. About 2 million rows in the table, but I don't know…
Re: Use of log files to update other On-Line Servers?
Adam M Broun (brouna@world.std.com) wrote: : I am trying to get a feel for whether the following scenario is possible : under Informix: : We are designing a system involving a large number (40-50) separate : Informix servers scattered over a state, with a larger, central system …
Re: What does sysindexes.clust contain?
graeme@pyra.co.uk (Graeme Sargent) writes: : Who can tell me what the numbers in the sysindexes.clust column mean? : : I realise that low numbers mean clustered and high numbers mean : unclustered, but what does (eg) 4000 mean? 4000 whats? Is 4000 : acceptably low or unacceptab…
What does sysindexes.clust contain?
Who can tell me what the numbers in the sysindexes.clust column mean? I realise that low numbers mean clustered and high numbers mean unclustered, but what does (eg) 4000 mean? 4000 whats? Is 4000 acceptably low or unacceptably high? If one wishes to write a utility which tro…
Re: #defines in 4gl
In article <1ttg96INNiat@emory.mathcs.emory.edu> archer!ciesla@stairs.att.com writes: } For years, I've wished 4GL had a feature that would allow the } use of #define, #ifdef, #else, #include, . . . } } Has anyone figured out a way to do this in spite of Informix? And you folks …
Re: Clustering Support
In <51882@shamash.cdc.com> map@svl.cdc.com (Mark Peters) writes: >I'm trying to put together a table showing the database systems that >support clustering and the open-systems hardware platforms they >support it on. I've found that Oracle supports clustering via >the Parallel S…
Re: Relational Systems set back DP
While Mr. Baker makes some very interesting - and valid - points about what relational databases are *in fact*, there are a couple of points with which I take exception. He writes: > As a designer of commercial manufacturing applications on IBM mainframes in > the late 1960s an…
Re: Informix Remote Mirror Disk
Jim Gordon <jgordon@ssf-sys.DHL.COM> writes: > Bill Williams in X-Informix-List-Id: <list.267> appears to consider > that remote mirroring of data should not be implemented as it will > affect performance of the database. True, but that is not the essence of my argument. …