Oninit® Archive
Results for “onstat -g cmsm”
Re: Senior Oracle DBA now Learning Informix by Request
Obnoxio The Clown wrote: > DA Morgan said: > >> Best selling (may be the result of) Best quality. > > Well, as a theoretical possibility, sure. But give me five examples of > where the market leader is demonstrably and unequivocally also the best > quality. > >> How one defines q…
deleting rows physical
Art S. Kagel wrote: > > goermet wrote: > > > > I had think so, but it isn't so in the reality > > > > goermet > > > > WF Software schrieb in Nachricht ... > > >In article <76oegi$pci$1@news.online.de>, goermet@online.de (online) > > >wrote: > > > > > >> I have following problem: …
Created raw table in Perl program but it vanished when I exit program
Greetings y'all. This is a big mystery for me and I hope there are enough users of the Perl DBI::Informix module to recognize this problem. Consider this code in a Perl variable: create raw table $wtab_name as select date(ins_dtime) ins_date, hex(rowid) row_address from $target_t…
DRDA redirection to HDR primary
I was recently unable to work out how to do this directly on latest IDS 14.10. I am about to write a technical article on a work-around using Connection Manager, but that involves more effort and failure points. Does anyone know how to construct a DRDA client configuration so tha…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Question of dostats
Yes. Many dostats rune used two connections egging you cannot do over a shared memory connection. There is an option to use a shared memory connection but then you can only process one database per run. Art ------------------------------ Art S. Kagel, President and Principal Con…
Updated utils2_ak package available
Woops, sorry, you can always find the latest release of my utilities on my web site, free to download and use, at: My Utilities ASK Database Management remove preview My Utilities Utils2_ak is my primary package of utilities. This is the November 24, 2023 release. Included: dbpin…
Informix HA Cluster and CM
The cluster is an Informix concept, nothing to do with Linux clusters. The connection manager will connect to each server in the Informix cluster and determine it's role Primary.SDS,HDR,RSS One connection manager will be the "Active Arbitrator" and if it cannot contact the primar…
onstat -g ses returns "Changing data structure forced command termination"
David: I don't know the APAR. It happens with even a single client connection that has executed no SQL at all. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
Update to utils2_ak
Yes, you can always download the latest utils2_ak from my web site at: My Utilities I uploaded an update that included a fix to a very old bug in dostats_ng.ec and new features in dostats_ng.ec and myschema on Dec. 21. ASK Database Management remove preview My Utilities Included:…
HDR shutdown and Restart
Just a side issue: You should ONLY use DRAUTO set to 2 if the network connection between the primary and secondary is ABSOLUTELY reliable to avoid the possibility of suffering from the "two brain problem". It is better to use Connection Manager to handle upgrading a secondary aut…
NETTYPE connections per thread
Keeping in mind that the number of connections is auto-expanding, and also my other notes from your previous post/question, if you approach or surpass the efficiency zone (500-700 active connections per listener), responsiveness to user requests will seem to be slow although once…
Bizarre CM/Connectivity Issue on 12.10.FC14
All: I think I'm zeroing in on something here as I test more. First, by setting up a test CM and enabling logging, I can see that even when the connection hangs, the connection manager logs the attempt and onstat -g cmsm shows the connection count go up. So it's making it as …
Connection Manager using SSL
I am trying to connect connection manager (conman1) to the IDS (mambaps) using SSL. I have configured the IDS correctly and tested through dbaccess from the connection manager server and from a windows machine with ODBC and it connects with no problems. My issue is when I try to …
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Connection Manager Redundancy with DRDA Connection
I have two Connection managers configured with two SLA entries using REDIRECT, one for the native SQLI connection (onsoctcp) and one for DRDA connection (drsoctcp) connection to just on IDS for testing. Everything looks good between the connection managers and the IDS. When I tes…
Update to utils2_ak
I have uploaded a new release of my utils2_ak package to my web site at: My Utilities ASK Database Management remove preview My Utilities Included: myexport - Drop in replacement for dbexport dbping.ec - Tests connections and reports connection time as well as the actual host and…
configure sds with raw device
Hello Alexandre, Thank you for your reply. As you mentioned, we will only use the SDS node for failover purposes. And now the storage used by Informix is only made up of raw devices and it is difficult to migrate to the cluster file system. We also do not have a license for so…
Connection Managers not forwarding connections
Hi, We had an upgrade for the whole informix cluster and after bringing up all the servers , couldn't resync HDR with primary because it was always causing checkpoint blocked on the primary. Afterwards, I noticed that the connection managers aren't forwarding traffic, restarted t…
Connection MAnager error
Hi, I am trying to create one connection manager with ClientSDK 4.10.FC10 and using one primary and one RSS, but I am having some errors 4001 and 1002 when I try to start it: ALARM 4001 unable to connect to Informix server srvinfx12_net from srvifxcm error -951 ALARM 1002 Error…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
HDR is not working
Dear All, In our environment we have configured HDR. it is successfully configured. Today unexpectedly primary server got physically restarted with unknown reason. But as per HDR setup application should redirect to secondary server, which has not happened, still the secondary s…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Starting Connection Manager fails
after doing all the configuration settings for Connection Manager, while initialising the connection Manager as a service using the below command: oncmsm -i -c configuration_file. I have tried using the path also: oncmsm -i -c D:\\\\informixCSDK\\\\etc\\\\cmsm.cfg. Error: Erro…
Connection Manager Automatic Failover
Several years back we tried to implement automatic failover on a cluster handled by 2 Connection Managers instances , this was on 11.5, but we had some horrors moments like ending up with 2 primaries getting updates simultaneously without communicating with each other. Since then…
Connection Manager for HDR in Windows server
Thanks Mr.Art But still little confusion. On the host of each client application, create an sqlhosts file entry for each service-level agreement (SLA) in each Connection Manager configuration file. My SLA is sla_1, which is configured in the connection manager cmsm.cfg file. n…
Differentiate OLTP&OLAP from 1 Application Server
That's ok fine. I will pass separate data source links to application if i have not used the connection manager But I want to use Connection Manager to both database servers for automatic failover. we need to create a cluster group for both database servers and supply the cluste…
Connection Manager configuration
Hi All, I implemented High availability data replication (HDR) on my two dedicated servers. They are working fine. Presently they are configured as manual switchover. Now we want to make this a automatic failover. I had searched in goolge and finally came to know that is Connect…
Switching HDR / Primary
Hello. I would also use the steps suggested by Art Kagel, in case of manual failover. Please be aware that 11.70.xC8 (your next release) has several APARs related to high availability features, so I would also recommend you to check them first, possibly avoiding any cluster mal…
dbexport on RSS Secondary
Im running IDS 12.10.FC6 on SLES 11 SP 4 with a primary and RSS secondary on separate boxes. At http://www.oninit.com/presentations/v117.pdf I see the following: Enhancements To Dbschema, Dbexport & Dbimport It is now possible to use the dbschema and dbimport utilities on all …
Re: jdbc connect to cluster
Thanks a lot, I managed to configure it. Another question related to this. I created a group made of 2 connection managers. Is there a way to control the fail over of one of the conection managers in the group so that people connecting to it won't end in the cm that is down?.…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
connection Manager
Hi All How exactly connection manager works with ? Can anyone help me configure connection manager, I have heard that it has some bugs, is this so? Thanks Jaya…
Setting up SDS cluster
HP-UX B.11.31 IDS 11.70.FC8W1 Setnet 4.10.TC5 Hi All When I start the connection manager and try to connect from a Ilogin I get a -908 error. I have checked the port setting on both client and server match but still get this error. Any advice will be appreciated. thnx…
Informix temp spaces
Hi Vladimir, If you have RSS servers: For HDR, RSS, and SDS secondary servers in a high-availability cluster, logical logging on temporary tables should always be disabled by setting the TEMPTAB_NOLOG configuration parameter to 1. So, you can remove last 4 temporary dbspaces w…
Connection Manager
Started Connection Manager successfully. It is pointing to 2 servers (Primary/Secondary HDR). I log into the secondary server and run 'onstat -g cmsm'. It shows me the connection manager name/version, cluster name, even failover arbitrator/order/timeout details. It completely lea…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Connection Manager - Sessions Terminate Abnormally
3 Informix instances setup on a HDR pair w/Connection Manager. When I shutdown Connection Manager, I look at the database online logs and see some of the instances successfully de-registering from Connection Manager; whereas others terminate abnormally. What factors would cause t…
HDR & Connection Manager
Informix 11.7 FC7, CSDK 3.70 FC7 I have a HDR pair with 3 instances setup with Connection Manager. Primary/HDR run on separate Linux boxes; as well as Connection Manager. I triggered a failover and all 3 instances on the primary were failed over to the HDR server, now the new-Pri…
Informix on HP MoonShot
When HP announced its new ARM32 and ARM64 based Moonshot micro-server yesterday there was only one commercial database that already supported the platform: IBM Informix. Today there still is only one. Imagine running your relational or JSON collection database on a server built …
Informix/Oracle
I think it's clear that these are just made up reasons that might work on less clued-up customers or ones who favour Oracle in any case. It's FUD. A quick google found this roadmap presentation for VNext+ and VNext++. http://www.informix.nu/pagang/Informix_v12_1_Highlights-RoadM…
Recommended log rotation setup for online.log and
Hi, I'd like to do daily rotations our online log and our connection manager log. I noticed that there is a task name 'online_log_rotate' that will manage the online log, but I don't see one for managing the connection manager log. I'd like to avoid having multiple log rotation …
upgrading 11.70 to 12.10
================================================================================ == ================================================================================ == Link - http://www.ibm.com/developerworks/data/library/techarticle/dm-1304overview/ Migration to Informix 12.10 …
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
connection manager 'detect lost connection' every
Hi, I have an Informix 12.10.FC1WE cluster containing a primary HDR, secondary HDR, and an RSS. Each of the servers have connection manager running (all with the same SLAs). Recently, I've started getting email alerts from the RSS that look like this: Subject: rmca_cm_rssnet : …
Informix connection manager
G'day All, Can someone give me a clue on deriving values to be used in ODBC within the context of following connection manager example ? If so that would be a great help in a situation where training will not be avaialble to cover up such topics. I am going through IBM Informix…
Using Informix ODBC with connection manager
Hi Guys, We are going to use Informix connection manager to manage connectivity among our database instances (Primary, HDR and RSS) as per following article but I am not sure what I will be using as ODBC settings as host name, service etc. because, when connection manager manage…
Informix Connection Manager - SIG 11
I have a VM setup with Connection manager pointing to an HDR pair on separate VMs. On rare occasions, I've had the Connection Manager daemon shutdown with no warning. The error in the logs shows it received a SIG 11 - 10:11:08 Connection Manager process 25654 received signal 11, …
Informix Connection Manager - USEALIASES
I have 3 VMs setup - 1 w/Connection Manager, and the other 2 being a HDR pair. I'm noticing in the logs that CM tries to use all the DBSERVERALIASES that I have defined in the HDR pair ONCONFIG. Under the CM CONFIG, I have USEALIASES=OFF; so I'm a little confused as to why I am s…
VB6 connection string to ids 11.5 64bit failing
Thanks - but when i go to control panel:Admin Tools : Data Sources , l can see the DSN within the 'system DSN' tab. And the connection is successful. By the way : the error message is run-time error '-2147467259 (80004005') Microsoft [ODBC driver manager] data source name not …
Connection Manager - Automated Failover
I am in the middle of stress tests against a HDR pair (Primary + Updateable). I took down the primary and waited for CM to start the automated failover; it didn't. CM said "Arbitrator detected majority of secondarys are still connected." Please note that I had already tested the …
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
SLA Not Working with Kerberos Enabled Service
Dear All, I am running the Informix IDS 11.70 FC4 at AIX 64-bit OS. I have a connection manager, in which I wanted to configure an SLA which should use the DBSERVERALIAS, which is configured with kerberos authentication. My connection manager and DB server are running on the s…
How to connect Java/JDBC with Connection Manager
Hello All, Can someone share any link, which could specify how to connect a java (JDBC) application to the connection manager. Actually, I am running two redundant connection manager having 2 SLA's in each CM file. Below you will find the details of the configuration. Now, I w…
connection manager SLA point to DBALIAS not workin
http://www-01.ibm.com/support/docview.wss?uid=swg21635513 a technote for Configuring the Connection Manager for PAM Authentication Thanks…
windows odbc connection to connection manager grou
I have 3 connection manager (Linux) instances whose SLA's are in a group in sqlhosts (group option c=1). When I run dbaccess on any of those machines, the SLA group is listed as an option, and I can connect to the group (it will round-robin my connection to one of the connection …
redundant connection manager configuration using H
I'm looking specifically at a MACH11 cluster. So then, if I was to just make things simple and do this: SLA cm_sla1 DBSERVERS=(RSS,primary,HDR) Then the HQ connection manager would realize that the RSS is high latency and avoid giving it out, and the remote site connection man…
Connection Manager setup (Windoze)
We are trying to setup the CM on a windows server and are getting errors returned in the log : 14:18:24 Connection Manager name is tms_primarycm1 14:18:24 Starting Connection Manager... 14:18:24 Get server smart_grid information failed, Connection Manager stopped 14:18:24 Error …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Using ifxclone to setup HDR
Thanks Madison, so what I did was correct. A big thanks to IBM for coming up with this feature. I am trying to setup Connection Manager in our environment for one production database server which has HDR and RSS. Is there any guidelines/best practices from IBM for setting up Co…
client connection to a multi connection manager sy
Hello I have one java application that connects to informix server through connection managers, but even when I have more that one connection manager, when one of the fails I cannot connect anymore with my java application. I have two connection managers , and two informix data…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
Connection manager resilience
I'm trying to set up a group of Connection Managers. On the Connection Manager server sqlhosts looks like this: # Underlying Instance Connections idsmach1db_app group - - i=1 idsmach1db1_app onsoctcp idsmach1db1 idsmach1db1_app g=idsmach1db_app idsmach1db2_app onsoctcp idsmach1…
dotnet and connection manager
HI, A partner write the application using dotnet. currently they use HDR on IDS11.50 FC8,but they don't use connection manager. Do anybody know whether connection manger could reroute the connection request from DOTNET? thanke for your time.…
limit user connection to IDS
The only limit for Informix connections is memory. But depending on your connection types, you could limit on the OS side. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosp…
how many concurrent users access informix
Art, as a matter of interest, how are you managing to get Innovator-C servers "sharing data with two Enterprise Edition central servers" considering the unavailability of remote-database connectivity in Innovator-C?…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Connection Manager
I have setup an RSS server but I am having problems getting it working properly with Connection Manager. Here is what I am running. IDS 11.70.FC4GE CSDK 3.70.FC4DE ServerA - Primary server ServerB - SDS ServerC - RSS The connection Manager config file is - NAME conn_man LOG 2…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
dbserver name "group" doesn't connect from Windows
From Unix /Linux: dbaccess database@database_group .... That works. From Windows: (Get -25555, saying it isn't in sqlhosts file... But the group is in the registry sqlhosts file.) ilogin and testing odbc connection to database server group ... Does not work. Unix sqlhost file…
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…
Connection Manager in 3.7 CSDK and IDS 11.50
Anyone know if it is safe to run the latest and greatest Connection Manager from Panther with IDS 11.50? I assume oncmsm is backwards compatible, just want to make sure. Thanks, Andrew…
Concurrent Database Maintenance?
OK..more questions! Informix on Linux. I read on one site that Informix does not allow concurrent index reorgs...that you have to drop table indexes and rebuilt them (ALTER INDEX CLUSTER). I dont know if it was an outdated website. Can anyone tell me if this is still true and …
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
CONNECTION MANAGER WINDOWS
Olá amigos, Hello friends, PROBLEMAS COM O CONNECTION MANAGER NO WINDOWS ============================================= PROBLEMS WITH CONNECTION MANAGER ON WINDOWS =========================================== Estou montando 3 servidores rodando SUSE LINUX com Informix 11.50.FC6 …
OAT and MACH clusters
Linux 5, IDS 11.50 FC6W4 I have setup an HDR primary and secondary, and I can connect to both using OAT, but when I search for a MACH cluster, it doesn't find any. I am not using the connection manager. Is that possibly why OAT doesn't see them as a MACH cluster? Jamie…
More Connection Manager fun
informix-list-bounces@iiug.org wrote on 05/30/2010 06:12:56 AM: > From: "Neil Truby" <neil.truby@ardenta.com> > To: informix-list@iiug.org > Date: 05/30/2010 06:15 AM > Subject: More Connection Manager fun > Sent by: informix-list-bounces@iiug.org > > IDS 11.5FC6 on Centos 5.4 > …
Re: in place alters (script/output) issue
??? not according to the migration guide when doing an in place migration Upgrading Dynamic Server (In-place Migration) In-place migration upgrades Dynamic Server directly to the current version by installing the product in a new directory, copying a few configuration files, an…
RE: IBM Informix - Continuous Availability White Paper
> Date: Wed, 21 Apr 2010 00:32:08 -0400 > From: lester@advancedatatools.com > To: informix-list@iiug.org; waiug-members@iiug.org > Subject: IBM Informix - Continuous Availability White Paper > > IBM Informix - Continuous Availability White Paper > LOL... Now that's funny. For …
Database and ColdFusion connections
Hello all, We use ColdFusion (CF) as the web front end and informix version 10.fc9 on aix 5.3. It looks like CF manages the pooled connections and threads hitting the database just fine when the results are returned according to the time out setting. However, the problem is whe…
IDS, BTS datablade and HDR
I am not sure which version of the server you are using, but if you check the release notes of 11.50.xC3 or later you will find the following: Basic Text Search DataBlade=AE module Supports High-Availability Cluste= rs =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D…
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…
SDS Mach 11
kate said: > When you are using SDS with Mach 11, how does Informix balance the load > across multiple pieces of hardware that are all using SDS to share a disk? > I assume through connection manager, but I would like to understand the > logic of how it determines how to send a t…
RE: Connection Manager and I4GL
Sigh. KISS applies. 4GL apps are client/server. You may want to consider some sort of DNS / host mapping solution. That is, your application connects to the server via hostname. If the heart beat of the host goes down, your DNS system catches the alert and the secondary's IP a…
Re: Connection Manager and I4GL
On 14/08/2009 13:57, Keith Simmons wrote: > 2009/8/14 Ian Goddard<goddai01@hotmail.co.uk>: x-list >> > I am the admin, but as the DR machine is on a different physical site > with separate sub-netting this is a non-starter. AIX !!! so linux/hp > solutions are no good. > There is …
Re: Connection Manager and I4GL
Keith Simmons wrote: > 2009/8/14 Jonathan Leffler <jonathan.leffler@gmail.com>: >> On Aug 13, 6:16 am, Keith Simmons <smile...@googlemail.com> wrote: >>> All >>> >>> Following 'recent' issues (this week and 15 months ago !!) management >>> have decided we need some fail-over mech…
Re: Connection Manager and I4GL
Just for fun, a few months ago I tested I4GL + oncmsm on Linux and works fine! Here, I just install the last version of CSDK at different directory of I4GL and configure the CSDK directory first on the LD_LIBRARY_PATH enviroment... Regards Cesar --- Em qui, 13/8/09, Obnoxio Th…
Re: Connection Manager and I4GL
Keith Simmons wrote: > 2009/8/13 Obnoxio The Clown <obnoxio@serendipita.com>: >> Keith Simmons wrote: >>> All >>> >>> Following 'recent' issues (this week and 15 months ago !!) management >>> have decided we need some fail-over mechanism in place for when the >>> database 'locks …
Re: Connection Manager and I4GL
2009/8/13 Obnoxio The Clown <obnoxio@serendipita.com>: > Keith Simmons wrote: >> All >> >> Following 'recent' issues (this week and 15 months ago !!) management >> have decided we need some fail-over mechanism in place for when the >> database 'locks up'. >> IDS HDR is the obviou…
Re: Connection Manager and I4GL
Keith Simmons wrote: > All > > Following 'recent' issues (this week and 15 months ago !!) management > have decided we need some fail-over mechanism in place for when the > database 'locks up'. > IDS HDR is the obvious candidate but I need to get my head around how > an applicati…
Connection Manager and I4GL
All Following 'recent' issues (this week and 15 months ago !!) management have decided we need some fail-over mechanism in place for when the database 'locks up'. IDS HDR is the obvious candidate but I need to get my head around how an application can seamlessly fail-over from p…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
RE: Select error: SQL error -208: Memory Allocatio
LARRY SORENSEN wrote: > We do NOT use ODBC to connect but rather connect directly using the Informix > drivers. I say this because when we install the client components (Crystal > runtime, Powerbulder runtime, Informix drivers and Datadental client) we then > run the Informix set…
How to configure Connection Manager for a protocol onsocssl?
Hello, gurus! Does anyone know how to configure Connection Manager for a protocol onsocssl? Dbaccess has established connection directly to the server for a protocol onsocssl without any problems. When CM has started, it started succesfully, but when I want to connect via SLA, C…
local area connection!
Dray wrote: > OS is Win Xp Pro > "Dray" <dray@dray.com> wrote in message news:gvj9a8$8nb$1@ss408.t-com.hr... >> We added another lan card on the computer(informix server), but now we >> have slower connection on database! Each card has it own ip range! On a >> local server connec…
RESTORE SECONDARY HDR LET INCONSISTENT CHUNKS
HI EVERYBODY! I HAD A PROBLEM WITH A HDR SECONDARY SERVER A WEEK AGO. THEN, WE PEROFORMED A RESTORE (BACKUP FROM PRIMARY TO ARCHIVE, FTP TO SECONDARY, ONSTAT -P SECONDARY),THEN WE CONFIGURED THE PAIR (ONMODE -D), THE ONLINE.LOG SEEMS NOT RECORD AN ERROR WHILE WAS IN PHYSICAL REC…
Connection Manager Cluster
Hi, We are facing a couple of problems with Connection manager cluster. We are runing two Connection Manager instances on different machines. And both are grouped in the sqlhosts file of Connection Manager. like g_oltp group - - e=oltp2 oltp ontlitcp 192.168.0.16 9991 g=g_oltp o…
Re: Connection Manager - restrict connections
Tom wrote: I think to do what you are trying to do that you will need to use the password file. The second column has an alias to use in place of the HA_ALIAS. > On May 14, 11:47 am, Tom <tlow...@munis.com> wrote: >> On May 14, 4:57 am, theBP <th...@Usenet-News.Net> wrote: >> …
Connection Manager - restrict connections
Greetings all, In a world where multiple DBSERVERALIAS values exist, is there a way to restrict which ones the Connection Manager tries to establish connections through? As a brief example, If I have these values in the ONCONFIG file: DBSERVERNAME aspbeL1 DBSERVERALIASES hdr1P…
Re: Connection manager redirect
What kind of error clients are getting ? Regards, Nilesh., ids-bounces@iiug.org wrote on 05/05/2009 05:08:25 PM: > [image removed] > > Connection manager redirect [15681] > > VIVIAN JONES > > to: > > ids > > 05/05/2009 05:09 PM > > Sent by: > > ids-bounces@iiug.org > > Please …
Connection manager parametrs
Can anyone help us out that we are not able to find detailed documentation about informix connection manager like what are the optional parameters to define SLA. And what does timeout value in FOC of connection manager mean? regards, Kamran…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
connect through java using group_name con mgr
Kamran: If you want to access all nodes as a group, you could modify and add a mach_group to the oncmsm's sqlhosts as below. g_mach group - - e=ids_net_RSS ids_net_primary ontlitcp 192.168.0.16 sql_net_primary g=g_mach ids_net_secondary ontlitcp 192.168.0.15 sql_net_secondary g…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Connection Manager Behaviour - Feedback Request
Hi, I am currently in discussion with R&D about how Connection Manager behaves, and what behaviour customers want. So, given the following environment, using the sqlhosts as a central reference point (and yes, it IS big), where I have Two MACH11 clusters Each Cluster has 1…
SLA listener failed Connection Manager shutdown
The machine name and service for the connection manager is defining the= listener threads for the CM, not for the server. I don't think that you can have different IP addresses for two SLA comi= ng from the same connection manager. ------------------------------------- Madison…
Shared Disk Secondary
Look at the whitepaper from HP (http://h20195.www2.hp.com/V2/GetPDF.aspx/4AA1-7936ENW.pdf) which discusses the rich high availability features of IDS 11.1 and how to integrate them with the cluster solution HP ServiceGuard and a cluster filesystem.…
Question for Connection manager and SDS
I have 2 question for IDS11.50 SDS 1. What is the machanism of Connect Manger to select the dabase server ? Round robin , random ? For example : SLA CMport=(dbport1+dbport2+dbport3) Can we set up the additional rule for CM such as use dbport1 40%, dbport2 30%, dbport3 30% ? 2…
How to conect Java Aplication using Connection Mgr
Hello, I am unable to connect database using connection manger, setting for connection manager is as follows. Values in password file. ------------------------ ids_net_mcp_test02 - informix informix ids_net_mcp_test_rep02 - informix informix ids_net_mcp_rss1 - informix informix…
Connection Pool
Hello everybody! I have been looking for this issue for some hours and I wasn't able to find anything. How can I use the connection pool for IDS 9.4? I'm developing in C# of Visual Studio .NET. Until now I have been using Oracle. And to use the connection pool, I only had to u…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
HA : What is the best ?
Hi, I have two Intel Xeon 5160 rack boxes (2 x Dual-Core, 4GB Ram, 5 HD, 2 LAN ports) to run Win2K3 Server on which I plan to install IDS 11.50 xC2.xx for about 60 users. Considerations I have to address : High Availability, IDS license type/cost, "near-zero" IDS administration…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Hardware advice please
"R Rhodes" <rosie@bullysoft.co.uk> wrote in message news:299485d5-551f-48a9-bb5d-edcd02a0d3c7@x35g2000hsb.googlegroups.com... > Hi all, > I am looking for advice on what servers to buy to replace our existing > informix db servers. > We have to replace them, because they are dino…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
How I can to change status from SDS secondary to Primary.
rootdbs@gmail.com wrote: >> Question --- why is it necessary to revert the server status? You are >> using the connection manager, so you could configure an SLA to point to >> the current primary. > > I don�t think about it. > But I think that not only SLA need configure. Sqlh…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
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.…
Cheetah2 connection manager and failover arbitrator
IDS 11.50.UC1 Red Hat Linux 5 Simple HDR environment 1 Primary - 1 Secondary I'm taking a look at the connection manager and failover arbitrator shipped with the CSDK in IDS 11.50 and am wondering if there is a better way to recover from a Primary server failure that doesn't req…
Managing IDS in IBM HACMP environment
Appreciate the comments. We are planning to use HDR but this will be to our Disaster Recovery Site. The use of HACMP at the Primary site is mainly to have high availability in case of any hardware failure and for system maintenance.The cluster is already setup and shared logical…
Management Articles, Web Seminars, More
Management Articles, Web Seminars, More Access thousands of business articles, Webcasts, e-learning, best practices, case studies and more. http://www.health3.com.cn/health/Management.htm Corporate Knowledge Sharing Find management solutions for your company in the directories a…
Re: question about mach11 capabilities
Thanks Art, I figured it had to be ER, but wasn't sure how it would work. So basically I would have to reorg each ER server ( or er group ) separately and let it catch back up. Lots of work on a weekend type reorg, but at least no downtime. :-)) Thanks. ----- Original Message …
Re: question about mach11 capabilities
Floyd Wellershaus wrote: > Hi, > I was just reading the white paper on ids11 availability and have a > question. > The solutions seem explicitly cover every scenario except one. > If I need to reorg a very large table that the application needs, but > I don't want to take any out…
Re: current informix white papers ?
Fernando Nunes wrote: > DA Morgan wrote: > >> Floyd Wellershaus wrote: >> >>> My company is seriously thinking of going to Oracle and using >>> RAC/DataGuard for their high availability solution. >>> I know Informix can compete with this, as I'm pretty sure Cheetah has >>> the la…
Windows XP Helper
Windows XP help and tips to increase your productivity and help solve computer problems. Topics include Tweak UI, account management, remote desktop connections, using printers, removing spyware on Windows XP systems, DOS and Batch Files, and more. http://online-windows-xp.blogsp…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Getting a bite of the Apple?
http://www.internetnews.com/bus-news/article.php/3721921 IBM's IDS to Support Mac Platform By Larry Barrett Maybe it's just a cat thing. IBM on Wednesday announced its Informix Dynamic Server (IDS) will support the Mac OS X 10.5 operating system, a.k.a. 'Leopard' beginning wit…
Getting a bite of the Apple?
http://www.internetnews.com/bus-news/article.php/3721921 IBM's IDS to Support Mac Platform By Larry Barrett Maybe it's just a cat thing. IBM on Wednesday announced its Informix Dynamic Server (IDS) will support the Mac OS X 10.5 operating system, a.k.a. 'Leopard' beginning wit…
Connect to IDS from Open Office 2.3.1
My turn to need some help. I am trying to connect to an IDS database from Open Office v 2.3.1 using an ODBC connection. From this PC I can connect to the DB natively and I can also query the DB using RazorSQL connected via ODBC. I have created an ODBC connection in Open Office…
Informix Cluster HDR and Hearbeat2
OK, here you go with anold e-mail from 31-Aug-2007: ----------------------------------------------------------------- Sending on behalf of Lars D. Forseth (lars@forseth.de): ----------------------------------------------------------------- Hi there! My name is Lars Daniel Forse…
Re: RAC in Informix by year end?
Data Cruncher wrote: > Taken from DBTA magazine. > > Did I read this correctly? Does it mean that by year end Informix > will offer RAC. > > ============================================= > HDR, RSS and SDS servers and even ER can be combined in any way to > provide a sophisticate…
Re: RAC in Informix by year end?
Data Cruncher wrote: > Taken from DBTA magazine. > > Did I read this correctly? Does it mean that by year end Informix > will offer RAC. > > ============================================= > HDR, RSS and SDS servers and even ER can be combined in any way to > provide a sophisticate…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: Informix beats Oracle
Excellent!! Thanks Andrew. Andrew Ford wrote: > IDS HDR has auto failover via the DRAUTO onconfig parameter: > > 0 signifies OFF = Do not automatically switch the server type in the HDR > environment. > > 1 signifies RETAIN_TYPE = Automatically switch secondary to standard duri…
Re: Informix beats Oracle
Tool wrote: > Quick question for you Fernando or anyone else... > > With the introduction of MACH11, do you still need a secondary product > for HA > such as HP Serviceguard, or Red Hat Cluster Manager or other HA product > on the > machine at the OS level if there are no other a…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
IDS agent for Sun HA cluster
> We've installed IDS on a Sun Cluster. It works really well, but one > irritation is we haven't got the Informix agent to work. We've followed > through the instructions in the IBM IDS High Availability and Sun Cluster > 3.x document (written for IDS v9 but we are assured 10 i…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Using IDS on VMware
DAVID FRASER said: > Actually, the more I think about it, we need on-line realtime data server > and > 4gl (and linux environement) replication, not High Availability fail-over > (as > provided by HDR). So I am looking for a solution based on VMware to > replicate > my entire ser…
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…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Informix connection to SQL Server
cboccio@yahoo.com.br wrote: > Hi all, > > Does anyone knows how to connect a SQL Server from an Informix Database > installed on a Linux machine ? > > Tks, > > Regards, > > Eduardo > Informix Enterprise Gateway Manager…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: 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!…
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.…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Re: Database market share 2004
rkusenet wrote: > http://www.eweek.com/article2/0,1759,1820667,00.asp > > > > > The database market grew by 10.3 percent in 2004, fueled largely by hunger for business > intelligence and analytics, according to numbers released by the Gartner Group on Monday. > With 34.1 percent …
Database market share 2004
http://www.eweek.com/article2/0,1759,1820667,00.asp The database market grew by 10.3 percent in 2004, fueled largely by hunger for business intelligence and analytics, according to numbers released by the Gartner Group on Monday. With 34.1 percent of the overall market, IBM hold…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Sun Cluster Agent for INFX version 10
Informix Sun Cluster agent is tested/certified with 9.X and 10.X ( SC 3.X) Regards, Mahesh Dashora Development Manager (Backup Restore, High Availability and Utilities) Database Development Information Management Division 4100 Bohannon Drive Menlo Park, CA - 94025 email: maheshd@…
RE: HA cluster on SCO Open Server
Martin Bouzek wrote >>> > >>> our company needs to setup an high availability cluster on two > >>>machines running SCO Open Server and Informix. Does > anybody have any > >>>experience with such configuration or at least can anybody > point me > >>>where to find more informatio…
Re: HA cluster on SCO Open Server
Obnoxio The Chav wrote: > Martin Bouzek said: > >>Hello all, >> >> our company needs to setup an high availability cluster on >>two machines running SCO Open Server and Informix. Does anybody have >>any experience with such configuration or at least can anybody point me >>where t…
HA cluster on SCO Open Server
Hello all, our company needs to setup an high availability cluster on two machines running SCO Open Server and Informix. Does anybody have any experience with such configuration or at least can anybody point me where to find more information about supported HW minimal versions …
Re: HA cluster on SCO Open Server
Martin Bouzek said: > Hello all, > > our company needs to setup an high availability cluster on > two machines running SCO Open Server and Informix. Does anybody have > any experience with such configuration or at least can anybody point me > where to find more information about…
cluster
hi all, is this possible to build a cluster with 2 informix (IDS 9.x) DB (load balancing,high availability..)? what must i look at ?…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: can run HDR and ER simultaneously on the same server IDS 9.20??
Another solution would be to migrate databases to a mainframe (we have thought at IBM ZSeries) and to use a storage IBM (storage are own OS for replication) at main location and also another mainframe with storage at disaster recovery center. In this case we have thought to use t…
RE: IBM website Informix pages / Workgroup edition
I received this from IBM in February this year in response to a similar question on licensing: "...IDS 9.3 & 9.4 High Availability/Failover In idle standby or active standby, you must acquire the correct number of Server, Processor and Concurrent Session use authorizatio…
RE: IBM website Informix pages / Workgroup edition
comments in-line. "Everett Mills" <eemills@nationalbeef.com> wrote in message news:ce6d1r$j09$1@news.xmission.com... > > Isn't this contradictory? From IBM's site (reference below): > > One area: > > Informix Dynamic Server V9.4 Workgroup Edition features and attributes > includ…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
RE: HDR with Synchronous replication
Guys- FYI- HDR is now LEGAL in WGE. You just have to buy an additional server license for your secondary ($686 last time I looked). From the IBM website: Informix Dynamic Server V9.4 Workgroup Edition features and attributes include: High availability Point-in-time instance…
Re: database market share 2003
Everything is up for grabs Daniel, that's what newsgroups are all about. If you understand the Informix world, you'll understand my statement, especially in the context of the Informix newsgroup. Informix people have had several servers to choose from over the years, but no one…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Connect to Informix 7.2 from jodbc
Hy guys, I�m try to connect using the jodbc driver in solaris S.O in the Informix database 7.2, but I don�t know What port can I use. Somebody could me help ? Thanks a lot Ricardo Pardo Atento Brasil S/A AVAYA Call Management System Administrator sending to informix-list…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
-951 error connecting to Informix SE for Windows
Informix SE 7.25.TC3 for Windows. I am trying to connect to the machine from a remote machine using DBACCESS. If I connect using my "normal" Win2k user (the one I login to on this machine)... I connect fine. However, if I try to connect using another user I added to this machi…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: Company thought DB2 will be better than Oracle.
The issue of transparent reroute of the connection when the IP address gets moved is something we are working on (i.e. writing code to solve). Ian wrote: > Noons wrote: > >> Blair Adamache <badamache@2muchspam.yahoo.com> wrote in message >> news:<bk7qnv$igs$1@hanover.torolab.ib…
Re: Company thought DB2 will be better than Oracle.
Blair Adamache <badamache@2muchspam.yahoo.com> wrote in message news:<bk7qnv$igs$1@hanover.torolab.ibm.com>... > For more formal approaches, DB2 supports High Availability through the > following packages / methods: > > HACMP on AIX > Microsoft Cluster server on Windows > Sun Clu…
Re: Company thought DB2 will be better than Oracle.
We are certainly looking at and protoythe high availability through replication (HDR) technology we acquired with Informix. We also appreciate that xferring the ip address in some transparent way is desirable. DB2 also supports split/mirror: http://www7b.boulder.ibm.com/dmdd/lib…
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…
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…
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…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
Re: IDS on HACMP
This is a multi-part message in MIME format. --------------55F7CC0E714E518848B71DB6 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit HI, I know of a site that has this setup. How it was configured was we had a mirror copy of informix installed (includi…
IDS on HACMP
Hi, Currently I'm handling IDS 7.3 on R/S 6000 F50 machine. My company want to upgrade the system for the purpose of availability. Therefore they wanted to implement High Availability Clustering Multi Processor (HACMP) meaning that they will put another server that will share th…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Problems with ole-db connection
I'm trying to make an ado connection (through ole-db) from an application running Windows 95 client, to an IDS 7.31 server running on NT. The middleware I'm using is SequeLink from Merant. Any attempt to connect to the server fails with a handshake problem. Merant tell me that th…
Re: High-Availability For Informix
From: Don Ignacio <dignacio@openratings.com> > >Anybody out there can suggest some high-availability solutions using >Informix. >Something like an automatic switch over. Really, about the easiest and most robust way of doing this is to use HDR. ER is a lot of work (even if it is…
Re: High-Availability For Informix
Hi, We are currently using IDS 9.2 on a Sun E45000. In this Informix version they removed the DRAUTO configuration parameter, which basically tells the secondary server what to do in case the primary server fails. This parameter is existing in 7.x. The easiest way to overcome t…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
RE: Cluster with informix.
I agree -- I don't think a cluster is really worth it. We have a very critical app. running on a small HP K460 box (2 Gb memory, 70 Gb disk, 4 CPU), connected via HDR to a similarly-configured K400 box. The two boxes are several hundred miles apart, and yet replication to the s…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Issue with query path chosen by Informix 7.20 UC2 optimizer ***Help*** :*(
We're running Informix OnLine 7.20 UC2 in an HP-UX 10.10 environment and one of our more simplistic two table join queries seems to be being mis-optimized. The query is listed below: SELECT * FROM product_vendor, product WHERE prod_upc_num = pdvn_upc_num …
How to choose a DB
Tim Schaefer wrote: > > Mark, > > My comments below... > [Snip} Tim - we have had this conversation before. > You can use Informix's 4GL or whatever to link to the engine, and the > engine takes care of the details of bringing back the query. 'Bringing back the query' - it's i…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Extents
> I need to expand the extents for most or all of our tables in our db. What > would be the best way to go about this? > > The only obvious idea I have for now is to do a dbexport, edit the output to > reflect larger extents, drop all tables and then do a dbimport? Yes, definite…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
Informix Client SDK - Powerbuilder 6.x (Urgent)
Hi! I have the Informix Client SDK installed on a Windows95 workstation and ultimately would like to conenct PowerBuilder6.5.x to an Informix Database on a server running SCO Unixware. Residing on the server is Informix SQL 4.14 and Informix (DB) SE 5.3. I cannot connect to the…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Re: Largest Informix Database size
David Williams wrote: > Of course you could probably scale further if you have the hardware, > if 176 is possible I wonder what the limit is, Tim? > > David Williams David, XPS is unlimited in a cluster context, but limited on each coserver in the same context as a typical…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
two access to 2 differents informix Database - 2 acc�s � un 2 bases Informix diff�rentes
I want configure Informix Cli -SDK to connect two database informix on same server : /manager/base/manager.dbs and /perso/my/test.dbs. -------------------------------------------------------------- Je veux configurer le driver de Informix Cli-SDK pour me connecter � 2 bases …
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Informix Database Administrator
If your looking to advance your career and work for a dynamic company....look no furthur. We have a client in the South Jersey area (10 minutes north of Cherry Hill) with an immediate opening for an Informix DBA to work in their Information Technology Department. They are seeki…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
IDS refuse connection on NT when connected to Internet?
The strangest thing; I just noticed that whenever I connect to Internet, I can't connect to my IDS 7.3.TC7 on NT (connection refused - Agent_log: Attempt to connect to database server (%s) failed.) As soon as I disconnect from internet, connect works. But IECC does not work (S…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
RE: Dsn-less connection to informix
Can you connect via ilogin? Can you make a connection with a DSN? If not then your connection string isn't the problem. If you can connect then it is your connection string. Try tracing a DSN and DSN less connection (via odbc manager) and compare. Kang U wrote in message <7eh11…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: How to reduce SE .dat & .idx file sizes?
In article <353F881E.15476F01@fullcompass.com>, Alan W. Jurgensen <alan@fullcompass.com> writes >hiya, > >we're running informix SE version 7.X on AIX RS/6000. I have some >development databases I want to trim the DB file sizes down on... >deleteing old records does nothing to r…
How to reduce SE .dat & .idx file sizes?
hiya, we're running informix SE version 7.X on AIX RS/6000. I have some development databases I want to trim the DB file sizes down on... deleteing old records does nothing to reduce the file sizes... I've read in the Faq: 6.8 Space reclamation In the good old days of SE, a t…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
PRESS:RECORD-BREAKING ONE TERABYTE TPC-D BENCHMARK UNDERSCORES
RECORD-BREAKING ONE TERABYTE TPC-D BENCHMARK UNDERSCORES INFORMIX'S LEADING-EDGE DATA WAREHOUSING SOLUTIONS Informix/Sun Microsystems Demonstrate Ongoing Industry Leadership, Competitive Pricing for Performance-critical Business Solutions MENLO PARK, Calif. (FEBRUARY 25, 1998) …
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
PARALLEL Processing Connection, January meeting notice
January 12th ... Boris Klots starts off the new year with a detailed description of the Oracle relational database system. This important application can be used in an exclusive or shared mode, i.e. one or multiple Oracle instances, respectively. The shared mode allows concurrent…
Re: Multi Thread App
David Williams wrote: > In article <68tpjb$q9j@cssun.mathcs.emory.edu>, "Art S. Kagel" > <kagel@ns1.bloomberg.com> writes > >On Tue, 6 Jan 1998, Alexander Jaremenko wrote: > >You use the CONNECT TO ... AS <connection name> statement repeatedly with > >different connection names…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
ODS in Sun HA environment
Greetings, We are looking at installing ODS 7.23 on a High Availability system using Sun's HA software running Solaris 2.5. The cluster has two Sun Ultra 3000's with disk farm's attached to each server. One of the servers is used as the primary DB server and in case of failure…
New Era and Crystal reports
Is anyone using the New Era Crystal report class in either 16 or 32 bit mode ? Have you managed to get it to work ? Are there any problems ? Are you using native or ODBC connection ? Regards Nick Woodruff Topas (UK) Ltd nwoodruff@topas.co.uk…
NewEra 3.0 TE1 - Window Painter default connect to DB.
Hi all, Just managed to connect to our remote Standard engine 5 database through window painter on SCO Unix. Un-fortunately, each time I load up window painter I have to connect to the database manually. Can I auto connect to a default database? Our make it prompt with options…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: Informix and Clustering
Informix and NCR have some special cooperative solutions to this used successfully by several customers. There was even a setion on this at the reasent user conference that your local Informix office may be able to get information on for you. NilsL@simac.nl (Nils van der Laan) w…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Connection problem
I am trying to connect to my Informix box with Space Manager (I have Informix OnLine Workgroup Server on a NT4.0 SP2 box). I get an error message saying I can't connect to <server>. Now I can connect with the Database Manager. I have no clue to where to look to try and correct…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <5j6eju$h25@omni2.voicenet.com>, gray@voicenet.com (Scott Gray) wrote: > > In article <33538a45.29051694@news.jax.mindspring.com>, > Reid Fleming <RFleming@aol.com> wrote: > >Dave Raddatz <raddatz@austin.ibm.com> wrote: > > > >>Steve Phelan wrote: > >> > >>I think La…
Re: CLI 2.5 setup???
Thanks for all your suggestions so far. I have managed to figure out that the ODBC is not the problem. I have been able to connect to the database using Crystal Reports and ODBC. There must be something with the application. I will try to find out how the programmers coded the …
Re: free up disk space
Wendy, The answer to your question, depends on the use of the table. What I mean is that the "Create cluster" or "Alter index to cluster" statements will rebuild the table, compacting all rows and freeing disk space taken up by deleted rows while the table is still active and a…
pb/informix interface
I'm no powerbuilder expert but I'm curious to know if anyone else has encountered this problem. We have Powerbuilder running on Client pc's connected to Informix Online 7.12 running on SCO Openserver. As the domain names expand we have run into a limit in connecting from one sy…
Re: Indexes and Stored Commands/Procedures
Sammers, It is always good to re-index periodically, because that will remove all the holes in the pages and also update the statistics page(clustered index only). In some cases the holes in the pages could also aid in good performance because the server does'nt have to do frequ…
Re: SCO not recommended for high number of users.
jparker@boi.hp.com (Jack Parker) wrote: :> :> > My point here is that the current numbers *seem* to show better :> > results - substantially better - than most medium sized risc based :> > Unix servers, including the K-series from HP. Currently it's simply :> > an interesting ob…
Re: SCO not recommended for high number of users.
Nils Myklebust (Nils.Myklebust@ccmail.telemax.no) wrote: : jparker@hpbs3645.boi.hp.com (Jack Parker) wrote: : Jack, the following isn't written so much to disagrea with you as : to give others in the group some new information. You may have noticed that I'm very reluctantly dra…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
PRESS: INFORMIX SUPPORTS DIGITAL TRUCLUSTERS 64-BIT SOLUTIONS
INFORMIX SUPPORTS DIGITAL TRUCLUSTERS 64-BIT SOLUTIONS MENLO PARK, Calif., (April 17, 1996) -- Informix Software, Inc. (NASDAQ:IFMX), the leading provider of innovative database technology, today announced its support of Digital Equipment Corporations new UNIX TruCluster Solutio…
Tips on a highly available & scalable dbms needed
We are trying to select a relational database that will have the following properties: - Windows NT compatible: use native NT threads, and not be just a Unix-port to NT. Plus all of the product (tools, APIs, etc.) must function in the NT environment. - Scalable: up to 100 milli…
PRESS - INFORMIX INTRODUCES ONLINE EXTENDED PARALLEL SERVER
INFORMIX INTRODUCES ONLINE EXTENDED PARALLEL SERVER Industry-Leading Dynamic Scalable Architecture Extended to Clustered SMP and MPP Environments New Parallel Server and Best-in-Class Partnerships Offer Today's Most Powerful Data Warehousing Solution SAN JOSE, Calif., (July 18…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
ANNOUNCE [ODBC Router for Mac/NT]
FOR IMMEDIATE RELEASE Contact: Thomas Gray AUGUST SOFTWARE CORPORATION 23232 Peralta Drive. Suite 202 Laguna Hills, California USA 92653-1437 Telephone (714) 454-9007 x443 Fax (714) 454-9032 North-American FAXBACK Service (714) 454-9007 x411 AppleLink CompuServe…
PRESS Development Platforms To Include AT&T Global Information Solutions and IBM Massively Parallel Solutions
Informix to Deliver Parallel Technology for Loosely Coupled Clusters and Massively Parallel Systems Development Platforms To Include AT&T Global Information Solutions and IBM Massively Parallel Solutions Commercial Parallel Processing Conference, Chicago, Ill. (Sept. 12, 1994)…