Oninit® Archive
Results for “onstat -g rep”
Re: ER error defining template
It is the 'desc' in the 'create unique index' statement which is causing this error at master replicate creation. I've logged a new bug for this. Andreas…
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 ------------------------------…
Slower 4GL Row by Row Inserts and Deletes on 14.10
Are you using any replication? ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------…
char_length() behaviour between 12.10.FC11 vs 12.10.FC14
I've replicated this behavior in 12.10.FC14 on my end. It does not occur in 14.10.FC4W1 ------------------------------ TOM GIRSCH ------------------------------…
Bizarre CM/Connectivity Issue on 12.10.FC14
Additional update: I've replicated this on 14.10.FC3 ------------------------------ TOM GIRSCH ------------------------------…
Table and index defragment
Let us know about those 'loopback replication' problems. There was a thread recently on " Asynchronous post commit triggers & loopback replication ERROR " that started out with a loopback replication definition problem, maybe that can help too. Andreas ---------------------------…
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…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
SDS Replication and VMware VMFS
Hello, Ihac who wants to implement SDS replication using two Vmware Linux virtual machines. Does VMFS support SDS replication? Thanks a lot for your answers. JOHN.…
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)…
Replicate
Hi, We set up an replication from aix to suse. How can I know if all the data are replicating correctly ? Thanks in advance. Enviado desde mi iPhone…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix/Oracle
tgsc.localdomain pts/1 mr --> /home/john 376) onstat - IBM Informix Dynamic Server Version 11.70.UC4GE -- On-Line -- Up 735 days 04:39: 06 -- 1043692 Kbytes tgsc.localdomain pts/1 mr --> /home/john 377) 'nuff said -----Original Message----- From: ids-bounces@iiug.org [mailto:…
ER insert /delete ONLY
HI, Folks, I just want to have a quick check also wish to get some experience if possible. Can we just set ER to replicate Insert and Delete( DO NOT replicate Update )? Thanks Frank --001a11c30e226cf20704fc4aba48…
define replicate error in ER
Folks, IDS11.50 FC8. When I run a cdr deifine to define replicate, I saw this. I am concerned both errors, especially the second error: CDR GC: cache cleanup for replicate failed. Any comments? Thanks, Frank 15:36:25 Warning - Table noaa:informix.ds_head_cs is replicated a…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
BlobSpace replication
Hello, I read somewhere that blobspace in not replicated with HDR, is it true ? and if so what informix technology to use to do so ? Thank you :)…
Switching RSS Servers
Hi Everyone, IDS 11.70.FC7W3X3 O/S AIX 6.1 I have a scenario in which I have 3 servers in RSS replication, rss1 is the "primary" where the other 2 get their changes from rss2 is a replicate of rss1 rss3 is a replicate of rss1 My question is if rss1 goes down for any reason, c…
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.…
Table Replication
hi, I need some advice or sample to do table replication on ids 11.70FC1. i already create 2 informix instance, dev1 and dev2. Some table on dev1 and dev2 like "customer" table already create at dev1 and dev2 with same column.What we need to do now, customer table must be have …
Replication issues
I have two separate servers with two similar but separate issues. Both involve Secondary servers in a DR setup. Both are due to a power outage that caused these servers to power down without Informix being shut down. For the first server, here is the error log: 16:19:21 Event a…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Is there such as thing in Informix: "database" lev
We all know instance level replication has been available for a long time, what about just to replicate one database? Thank you in advance for the info. Regards…
Re: ifxclone
Hi Laurie, Data changes that occur during the clone process are not copied. When you start the new ER node, it should sync up the replicates. Not sure on the final disposition of the replicates. You may need to try it, but I don't think it does what you want. I think when serv…
Cloning and Replication
We currently have and ER domain with both IDS 11.7 servers and IDS 11.5 servers. We are migrating away from all 11.5 servers and replacing with 11.7 (on new hardware). I want to use ifx_clone.. and set up a grid. I understand that I need to remove the 11.5 servers from the dom…
replication question
informix 11.70.FCx Sun solaris bla bla bla A silly question as its Christmas. Below is an extract from the IBM website regarding SQL statements permitted to be run when Enterprise Replication is active. I have a requirement to create an index on a replicated table. However a col…
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,…
ER - How many times a table has been replicated
This might be important: 11.70.xC4 replicating to 11.50.xC3 Andrew…
Flexible Grid and ER
yeah that's what's in there. I can cross connect to select/update/insert but cannot add replication.…
dbimport logging how to stop
thanks for that info Fernando We use enterprise replication here, Would logging of smart blobs be needed for that ?…
replicate changed columns
In IDS11.50 doc, it says about the replicating changed columns( not full row replication): ........................ You cannot use update-anywhere replication; doing so can result in inconsistent conflict resolution. ........................ What are the scenarios where it ca…
Innovator-C is now available!
The README file indicates the following about Replication! Changes to Replication in Informix 11.70.xC5 Innovator-C edition For 11.70.xC5, Informix Innovator-C edition no longer supports Enterprise Replication (ER) or High-availability data replication (HDR). If you were using r…
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…
Enterpreise Replication (consolidation)
Hi, i dont think i get it wrong. The Replicates define the "direction" of replicated Data. The root/leaf nodes just define, which catalogue information (syscdr) is spread among your ER-Domain. A root server can be a Primary OR a Read-Only, or BOTH at the same time. (if such a …
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 …
Enterprise Replication
I plan to use Enterprise Replication for replicating information amongst multiple IDS instances. Regarding this I had few queries: a) Can there be two different sets of replicates configured between different nodes. For e.g. consider the below scenario: i) Replicate 1 - Nodes A…
Looking for CDR Jump Start
Look here... How to set up Enterprise Replication for the first time https://www-304.ibm.com/support/docview.wss?uid=swg21153338…
Enterprise Replication
Hello All Fairly new to the ER world and when i peruse the catalog for ER training it mentions this: -Database Design Issues - Correct database design issues that can negatively impact replication: Serial keys, Cascading deletes, Triggers, Accumulators What are Accumulat…
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…
Replication problem
Informix 11.7FC2 Solaris 10 Hi All, I am getting the following message in the online log: "09:29:20 CDR RQM: rqmSbOpen() failed for KEY (18/67873/0x29fc198/0x0) dberror=12097 thread 116 queue trg_send" When I do onstat -g rqm brief I can see that the transaction to one of the…
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.…
ER error
If I am reading it right cdr finderr 1 1 A connection does not yet exist for the given server. Is replication actually working ?…
ER errors after 11.7 FC2 upgrade
HP-UX 11.23 64bit OSes on both ends of the replication…
Enterprise replication replicating instance on sam
afraid that has not worked. The format I used has worked before on host to host replicates…
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…
Creation of a replicate
We upgraded from 10.00.FC8 to 11.50.FC6. We had a replicate built on the following table: CREATE TABLE "informix".my_history ( mydate VARCHAR(20,0), user CHAR(20), program CHAR(20), recordtype CHAR(20), data CHAR(255), mykey CHAR(2…
Replication Question
Can you add an ER node to more than one domain? I have an ER server sync'd to one domain - all servers are IDS11.5. I need to replicate data to one of these servers from another domain of servers which are IDS 10. If I issue the command 'cdr define server --init g_IDS15 --sync…
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…
Replication
Does anyone know if you still have to use primary keys if using ER in v11.50.fc5? If so, is there a release where it is no longer a requirement. Thanks in advance for any info.... Peter Logan Senior Database Administrator Phone: 616/878-8309…
Enterprise Replication issues
You're confusing topology with replication ... ;-) You define the endpoints of replication when defining the replicates. = You define the topology when defining the servers. If you want to replicate from a to [b,c], then you need to define a sin= gle replicate with three nodes,…
replicating databases in the same instance
Does anyone know if you can replicate databases in the same instance ? From the mesage i am getting it looks like you cant see error message below replicate: res_accept_survey command failed -- duplicate server or replicate (53) there is no replicate of that name so I assume th…
Moving tables to another IDS
As I'm not to familar with HPL I'm wondering if I can launch a load task while the replicate is active…
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…
How to delete Enterprise Replication
Hi everybody! A client, LONG time ago, configured Enterprise Replication from a main server to a test server. After they finished their tests, they stopped the replication and did nothing else. Now, years later, I have to alter a replicated table, I get 19989: Enterprise Repl…
HDR
Hi All, Thanx for you suggestions. Reversal of Replication is a fantastic idea Thanx again Prabal…
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…
Error Replication
Hello, We are using IDS 7.31 on Solaris 8 and Windows NT4. The solaris server is defined as a root server for Enterprise Replication. The servers NT4 are defined as leaf servers (12 servers). We changed the structure of a table (changed 1 zone from char(30) into char(100) and ad…
ANSI and Replication
Has anyone out there every replicated from an ANSI database? I assume it has to be done from an ANSI to an ANSI, but would love input from anyone who knows. Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors A computer lets…
Informix Replication
Hi, I encounter problems when doing replication. I created new tables on 2 databases and I had to define the replicates for those 2 databases. This is the command I ran: cdr define repl -AR -C timestamp -S tran -i A_per_nrwu_grp_part2_C1 \\\\ "my_hq@grp_30_wart:dwafdba.per_nrwu_g…
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 …
Determining which version of IDS has been installe
Let me clarify that there is no difference in the Workgroup or Enterprise software packages. The TAR file you get in either case is identical. Also the OP mentions entering licensing information during the install; I don't think I've entered a software key or other licensing info…
Table replication
Hi, WE database1 & database2.In database 1,we table1 with column a,b,c with unique index on a,b,c (no primary key constraint).We need to replicate the table 1 to database2 as reptable1 with column i,a,b,c with unique index on i,a,b,c (no primary constraint)? Please advise that …
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…
Informix Replication
I'm looking at setting up replication with HDR (High Availability Data Replication) between our production HP 9000 and our D/R HP 9000. We are running HPUX 11.23 and Informix 10.00.HC5. In the past, I've used the Ignite process from HP to make a bootable backup tape of production…
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…
Enterprise Replication db recovery
Hi. I have a database that uses Enterprise Replication (at least it appears to be ER as opposed to High Availability Replication) based upon the use of "cdr" commmands and CDR* onconfig parms. It is a simple setup though. It is ONEWAY with only a subset of tables being replicated…
Enterprise Replication General Error
Hi folks, Is it possible to replicate from one instance to another on the same physical machine? I created one replication server OK but I'm getting "command failed -- General Error (-1) (-1)" when running cdr define server on the second replication server. Cheers R…
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…
Trigger and replication
Hi ! Are using IDS 10.00.FC8 on HP-UX. I have the following scenario: On server A a table is replicated using ER to server B On server B there is a trigger on the table that updates a table on server C. An update of the table on server A is replicated to the table on server …
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
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.…
replication HDR
Hi, Last night I recycled informix engine 10.00 FC7 (which is also primary in hdr pair) and brought back up in half a minute. It sent replication failure immediately on secondary server online message. but when I brought primary back online, it gave this message in online: DR: F…
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…
Replication question
IDS 10FC6 HP-UX 11.11 My server went into DDR Block mode last night.. in the process of getting the rest of my systems back online, the instance got re-started. There was a bunch of data in the recv queue on the recieving server that finally got processed, but it appears tha…
Replication to SQL Server
What is the most efficient way to synchronize/replicate from Informix (IDS 9.4 Solaris) to SQL Server?…
Replication Round Table Blog
I posted the wrong URL. The replication round table blog is located at http://www.ibm.com/developerworks/blogs/page/roundrep…
ER - Replicate in ALTERMODE state
Hi all, We use ER between 10.00.UC4 servers. One of our replicates remains in ALTERMODE state, so that it is not possible to update the table replicated through that replicate. We updating the table, we get the error 19992: "-19992 Cannot perform insert/delete/update operatio…
how - replication
We have HP Integrity rx4640, HP-UX B.11.23 operating system running IDS 9.4 We want to establish replication server using IDS 9.4 Our data size right now is 50GB and data growth is 50MB per day Would you all help me give explanation for our replication? What is requirement and ho…
RE: Enterprise Replication question
Jarrod Teale wrote: > Any chance of some assistance with this? I've had a further look and I > can't make the -e option work anywhere in my ER replicates, from > starting new ones to changing existing ones or through the use of a > replicate set. > > Is there something I'm missin…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Informix HDR from V7.3 to V10
Hi everybody, anyone try to replicate from a Informix V7.3 to a V10 or the oposite way?? We have to migrate from v7.3 to v10 and for a secure back we want have another instance "up to date". So the possibilities are: A Primary V7.3 replicating V10 or a Primary V10 replicating…
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…
cdr: 9.21 <-> 9.40
Hi all, can 9.21 and 9.40 version replicate (via cdr)??? regards.…
Re: Problem with ER : cdr sync replicate
The 'cdr sync replicate' finally wors... if I use a specific syntax: cdr sync replicate --master=g_root --repl=My_Repl --extratargetrows=delete g_leaf -> segmentation fault cdr sync replicate -m g_root --repl=My_Repl --extratargetrows=delete g_leaf -> segmentation fault cdr sy…
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…
ER
Hi guys, Informix 10, Solaris 10 is the following situation possbile with Enterprise Replication: create table A (id integer, des char(10)); create table B (num smallint, name varchar(40)); create table C (seq integer, title varchar (40)); I want to replicate first column o…
Replication Query
We have our card systems running in Informix with database replication. O/S :SCO Unix 3.2v5.0.6. Informix Version : 7.31 UD4 Senario: Due to a network issue the Primary Server cannot see the Secondary Server for some time. Network is establised after some time. Observation : T…
Data Replication
Hi, We are using the IDS 7.31 of informix on TRU64 unix. We have a Primary db. server which replicates to secondary db. server. In case of a failure with the primary server. (OS level, Disk error ), is there any way to configure the database onconfig parameter to ensure that th…
Informix transactional replication
mladen.spoljaric@gmail.com wrote: > Hi all! > > Since I'm new to Informix, I'd like to get quick info to take furder > steps in learning about and finally setting up transactional > replication in a way that is supported on MS SQL Server. > Can transactional replication based on …
Re: ER error defining template
It is the 'desc' in the 'create unique index' statement which is causing this error at master replicate creation. I've logged a new bug for this. Andreas…
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…
problems with ER & triggers
In short ... "Results of triggered actions from a replicate are not replicated" This is to avoid the potential of infinite replicate => trigger => replicate => trigger => replicate etc. :P…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
RE: IDS for Solaris x86
Interesting... We're still able to get support for IDS 7.x for Solaris 9 on x86 (for a price). % uname -X System = SunOS Release = 5.9 Machine = i86pc % onstat -V Informix Dynamic Server Version 7.31.UD7X6 (I suppose "inexpensive" depends on your point of view. I'll certainly…
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…
Oracle to Informix Data Replication
Hi, Can you please tell me what is the best way to replicate data from Oracle to Informix in real time? Thanks Nitin…
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!…
Mirror / Raw device / Informix
High Availability data replication?…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: No future for DB2
Madison Pruet apparently said,on my timestamp of 4/08/2005 5:23 AM: > > By the way - since it appears that you have rather limited knowledge about > replication solutions, Sybase replication works by replication the > procedural calls made on the source. Therefor, Sybase replica…
Re: No future for DB2
HansF wrote: > On Mon, 01 Aug 2005 00:10:29 -0700, Noons interested us by writing: > > >>DA Morgan wrote: >> >>>Madison Pruet wrote: >>> >>>>I didn't know that Oracle replication was available on the standard edition. >>>>I thought that it was only available on the enterprise edi…
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: dbload insert, update, delete
you may want to look at Enterprice replication to accomplish this; it will eliminate all your manual labour. Superboer.…
Enterprise Replication
IDS 9.4 (Linux) Hi all, I wonder if it's possible to replicate a complete database without replicating each table itself. We are using a tool which creates new tables, but we can't automatically specify the replication command for that new tables from outside that tool. We alwa…
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…
Re: Replication question...
Not tried replication with IDS 10 so far. Sorry for the ignorance. Would be excellent to have tools/scripts to monitor replication and an option to send emails to admin in case of some thing wrong.…
Replication question...
Just a quick question. What would be some really cool things for us to add to IDS replication?…
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…
Replication Problems
ids 9.4fc4 hp 11i pa-risc 64 bit We attempted to start replication on 7 tables. When we did this our processing went completely in the ditch. We went from using 25 (200 meg each) logical logs to using over 300 (200 meg each) logical logs for a normal nights processing. On the …
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
RE: Any assistance appreciated: Dynamic Server Initialisation Fai
Neil, The result of the restore was such that onbar reported that it had completed all of the DBSpaces, without error, and when it was instantiating to online mode it vanished, the message log did not record any errors, no af.* or shmem.* files were generated. Yet the instance …
onspaces and replication
hello all! i have infx 9.40 with replication in HP-UX 11i environment. unix admin create new raw spaces and i need to run onspaces and start the process for some new databases. question is , if R1 is primary and R3 is secondary, do i just run onspaces on R1 and this replicates t…
Workgroup Replication/Synchronisation
Jürgen I am aware that WE does not have HDR or ER, that is why I am asking for other solutions. Kind Regards Ian Logan From: <jrotter@paninfo.com> To: <ian.logan@straker.com> Sent: Friday, December 03, 2004 12:46 PM Subject: Replication Could you please give me some advice on…
Informix Replication
Hi All Can anyone give me some advice as to the best way to implement replication with the workgroup version of Informix? Also does anyone have any experience of SyncML? Many Thanks Ian Logan…
replication error
hi, I use ids 7.3 and replication between two identical servers master and = slave. sometimes when a record insert into master, the slave's interfaces file = gives an error; 0:18:22 CDR CDRDS: transaction aborted (All rows in a transaction = defined withrow scope were rejected) …
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'?…
workgroup replication
Why not workgroup replication for IDS 9.x?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Checking the replication
Hi! I need a better way to compare tables. This works, but it only shows the number of rows and will show 0 if the replication has been successful: select count (*) t from datadb@instance:table into temp t; select count (*) h from datadb@instance2:table into temp h; select t.t…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Replication problems
I am trying to use Enterprise Replication on 2 HP servers. It seemed to work fine for a few hours. It came down and when I bring Informix up I get the following message and then Informix comes down. (Both systems are the same level of OS and Informix.) 17:57:01 On-Line Mode …
RE: Informix licenses
Norm, I think the are two ways to do that: 1. Try to find Your license agreement 2. Dump the serial number with 'onstat -V' (smth like 'ABC#J123456) and try to contact Informix sales rep (or even support engineer) to ask them to find this information in their database by the ser…
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.…
ISDN & Enterprise Replication
Hello, I'm doing some tests with Enterprise Replication of INFormix. When I defined the replication for UGnd1 and MisterX, I have a big problem. The ISDN Line is never released even if no replication is done. That is not a good idea for the telecom bill :-) Here are the comman…
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…
Enterprise Replication
HAVE 4 9.30uc5 servers running update anywhere er. This has worked great for over a year. We are trying to add a 5th box running 9.4 to be a target only report server. Everytime we cut on replication the original boxes go haywire. Please let me know any info you may have to su…
Enterprise Replication
We have 4 boxes ABCD running Update anywhere replication Informix 9.3 uc5. This has worked very well for the past 1 1/2 year but we have now need to add a 5th server target only running 9.4. When we hook this server up and start the replicates we hose the ABCD boxes and often c…
Informix data files interchangable btw Unix & Win?
Hi, What kind of Data Files ? (DB Chunks ?). If DB Chunks, it's not possible. Try DBEXPORT and FTP to Windows and DBIMPORT or (table level) Unload to file Load from file or (replicate transactions) Use Replication (CDR)…
informix enterprise replication
BART DE TANDT wrote > I have 4 servers. > > 1 + 2 -> setup hdr > 3 -> central > 4 -> upper level > > I defined a replication between 1-2 group and the central > group. This replication works just fine. > I also defined a replication between 3 and 4 . This > replication also work…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Fwd: KAIO con HPUX 11 [265]
Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > angruiz@coomevamail.com wrote: > > Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > > > > > snip > >> > > > > > > Holas muy bien.. tengo una duda yo puedo tener varios kio (KAI…
Re: Fwd: KAIO con HPUX 11 [265]
Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > angruiz@coomevamail.com wrote: > > Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > > > > > snip > >> > > > > > > Holas muy bien.. tengo una duda yo puedo tener varios kio (KAI…
Re: Fwd: KAIO con HPUX 11 [265]
Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > angruiz@coomevamail.com wrote: > > Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > > > > > snip > >> > > > > > > Holas muy bien.. tengo una duda yo puedo tener varios kio (KAI…
Re: Fwd: KAIO con HPUX 11 [265]
Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > angruiz@coomevamail.com wrote: > > ----- Mensaje reenviado de "ANGEL MARIA...." <angruiz@coomevamail.com> > ----- > > Fecha: Mon, 9 Feb 2004 10:44:02 -0500 (EST) > > De: "ANGEL MARIA...." <angru…
Re: Fwd: KAIO con HPUX 11 [265]
Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>: > angruiz@coomevamail.com wrote: > > ----- Mensaje reenviado de "ANGEL MARIA...." <angruiz@coomevamail.com> > ----- > > Fecha: Mon, 9 Feb 2004 10:44:02 -0500 (EST) > > De: "ANGEL MARIA...." <angru…
HRD replication
Hi, everybody, We're getting a very strange error when we try to establish the HDR data replication: SECONDARY: informix@db-2:~$ tail -f online.log 12:40:59 Checkpoint Completed: duration was 0 seconds. 12:40:59 Checkpoint loguniq 7071, logpos 0x1081a0c4 19:19:21 DR: new t…
HRD replication
Hi, everybody, We're getting a very strange error when we try to establish the HDR data replication: SECONDARY: informix@db-2:~$ tail -f online.log 12:40:59 Checkpoint Completed: duration was 0 seconds. 12:40:59 Checkpoint loguniq 7071, logpos 0x1081a0c4 19:19:21 DR: new t…
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…
Replication and Ontape
A very simple question here. I'm using Informix 9.21 UC 5 on Sun Solaris. Can I use ontape to do a level 0 backup and log backups on the secondary ? In the event of failure, I assume I can use these on the primary. I have not seen any documentation contrary to what I am trying t…
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…
Replication Issue
Hello All, We are trying to setup a replication between two informix database servers and we have struck up in a issue which we are not able to solve. We would be grateful if any of you can help us in solving out. The issue is We have a two server ol_server1 and ol_server2 we…
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: IDS 9.x workgroup server
According to IBM's website, data replication is no longer restricted, but you must purchase separate licenses for each server in the cluster.…
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…
RE: replication
from tomL > Hello, > Is there a command that will return what type of replication is being > run? > > also, what is the best way to check that replication is in sync? > i have run onstat -g dri but this seems to only tell me if it is > turned on/off and the LAST DR CKPT values d…
offline replication
Hi. We're developing a database application for administrative tasks and we need to replicate our main database thru a few sites. The problem is that those sites won't be on-line and need to insert/update regional data (it's not necessary that the new data are available immediate…
replication
Hello, Is there a command that will return what type of replication is being run? also, what is the best way to check that replication is in sync? i have run onstat -g dri but this seems to only tell me if it is turned on/off and the LAST DR CKPT values do not match between prim…
Enterprise replication
Hello everyone, I'm trying to define an Enterprise Replication system between: - A siemens server (ReliantUNIX-N 5.45 B2005 RM400 4/1024 R10000) Informix 7.31.UD2X4 which is the source server and - A Sun server (5.8 Generic_108528-20 sun4u sparc SUNW,Sun-Fire-880) Informix 9.30.…
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…
Data synchronization
Thanks for the answers. I finally found a Sybase product that supports replication between heterogeneous databases including Informix.…
Replication planing..
Hi Everyone!! There are somebody how know a replication plan for IDS 9.x, (HDR) or any documentation about this Regards. Luis Arturo López Caballero Proyecto ASARE - Modulo Base Mexico D.F. Tel. 01(55)52294400 Ext. 85705…
Informix + DRBD
Hi all, We are replicating an Informix IDS 2000 database in another server, using DRBD replication software. Seems to run well. Has anyone tried this architecture and experiencing problems ? Philippe.…
Replication
We are considering using some method of data replication/failover. Some of the options we have considered are Informix Enterprise Replication, Informix Data Replication, Legato, and Veritas. I would like to hear from users with experience on any of those methods regarding the ea…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Data replication
Does anyone have experience with data replication? Specifically data replication using asynchronous replication? Sent via Deja.com http://www.deja.com/ Before you buy.…
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…
Replication between Informix Dynamic Server 7.31 and SQL Server 7
Hello, Is replication between SQL and IDS possible? If yes, what is the way to do it? Regards, Jan…
replication
We are running informix 7.24, on a mirrored and replicated database. We use additional software to take care of the table replication. I would like to set up two test boxes, one primary and the other a replicator(using the stores7 demo database). Does informix have the built in…
informix replication
Has anyone used Informix replication to replicate data between remote sites? Is it very difficult? Does it require other software for example with Sybase you need to use their Replication Server if you want to do hot standby replication. Any information on Informix's replicatio…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: 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…
Re: Performance comparison btn Informix and SQL Server
Further to my own post... From: "Obnoxio The Clown" <obnoxio@hotmail.com> > >From: Ming-Chuan Wu <wu@dvs1.informatik.tu-darmstadt.de> >> >>recently I have set up an experimental environment for performance >>evaluation among DBMSs, such as Informix, MS SQL Server 7.0, Oracle 8 a…
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?…
Reliability of Informix
Hi, Group What is the equivalent of Oracle Standby Server in Informix IDS2000 ? Is replication the only selection ? Harry…
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…
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
hi while replicating wiht the command "onmode -d primary "servername" it gives the following error "DR: UNABLE TO CHANGE SERVER TYPE" any clues????? rajiv * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and parti…
Replication
i am trying to replicate informix on NT Servers and WorkStations,but unable to find REPhost file to detect the servers.Do i need to add this file separetly or it is installed by Replication manager during installation.Secondly i would like to know the precise steps for replicati…
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: Question about replication
From: tkimnguyen@my-deja.com > >My reading of Informix replication is that it is log based, and this >type of replication architecture has a number of deficiencies. Informix >replication will probably meet your requirements in a two server >scenario, but you might want to have a…
SE and Data Replication
Greeting. Does anyone know if any version of SE supports data replication? Thanks, Dick Brieck…
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…
Replication Manager
Hello, I'm testing Enterprise Replication. I installed Replication Manager on a NT 4.0 workstation. I want to replicate from one server (on_nat4_tcp) to another server (on_dev2_tcp). Both servers are UNISYS UNIX servers. The installation and configuration of RM went fine. But wh…
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…
DataExchanger avilable for informix
DataExchanger 4.0 available for migration replication synchronisation for E business Mobile computing Datawarehousing and Application integration at www.dataexchanger.com…
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…
Data Replication
In article <3890BDE1.9E283668@sportingnews.com>, jmaes@sportingnews.com wrote: > > What kinda of DR? Enterprise replication, HD replication. Everything > you need to know is in your manuals. > ER (Enterprise Replication) is the replication you will need. HDR is not supported…
Re: [help again!]Informix Server no response!
Paul, I was able to find PAN, but was unable to find any cases concerning this problem. You need to contact tech support and open a case with them. Even if the person that you talk to currently does not have 7.31TC2, they can get it Also, the case notes act as a 'folder' of th…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
How many licenses do I need?
In article <80se20$9q4$1@news.xmission.com>, Ortiz Manuel <mortiz@gtireecu.com> wrote: > > 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_01BF306A.A18CC68C > Con…
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…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
ER vs HDR
A few questions on these replication :- 1. What's the difference between this two replication ? 2. Is it TRUE that ER can replicate regardless of OS / Engine Setup ? 3. What's the basic requirement for ER ? Lastly, is there any guide step by step guide on how to setu…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Question about replication...
Hi ! Is it possible to use replication (ODS 7.23 on AIX) without Enterprise Replication Manager? How to define replicate, participant etc. without this tool? Thanks for answers, Jarek B.…
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…
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…
replication
Can anyone give me explanation of the difference between data replication enterprise replication.…
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…
replication
Someone with experience with database-repliction out there ?…
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…
Re: KAIO and Informix and HP-UX 11.0
> I suppose that a message should appear in MSGPATH (i.e., online.log) when > Informix starts which indicate that kaio is enabled also onstat -g ioq, > iov or ath doesn't show anything about kaio or kio Yes, you should see a message in the IDS log when the engine is brought up. …
Replication
Hi! Has anyone tried to work with replication between IDS-Personal Edition and IDS on NT or UNIX (any knid of replication)? If yes, please let me know. First of all I would like to know if it's possible, what versions of IDS are more recomended, stuff like that. Thank you, Sebas…
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?…
RE: Performance degraded after detaching indexes / fragmentation
Two things come to mind. First; You may consider striping your disk array. This usually helps with I/O performance, but I don't know if it will make as dramatic of a change as you seem to be needing. Second; Did you update statistics after you made the changes? This may help cons…
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.…
Replication: only during insert/update
I wonder if it is possible to setup Informix replication to replicate data ONLY when inserting/update records from the primary server but not when deleting records?…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Re: Replication Question
>I have a general replication question. Do any database venders have >a many to many replication system. I know informix has one to many. > >I have no use for this just curiosity. > >Thanx >Bryan > Enterprise Replication supports many to many replication as well as one to many. …
Replication Question
I have a general replication question. Do any database venders have a many to many replication system. I know informix has one to many. I have no use for this just curiosity. Thanx Bryan Reply to bsapot@gundaker.com…
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 …
Replication
Does anyone knows any other methods to replicate the database besides HDR/ER?…
Replication
Does anyone know what the best way to check one table in an informix database, compare it with a table in another informix database, and if there is new data in the first table, append only the new data to the second table? And I need to do this from perl. If you have any sampl…
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…
Replication on UNIX
Does anybody know if Workgroup Replication works on UNIX or it is available only for Windows NT?…
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: CDR -database replication
Deepa Sankaranarayan wrote: > > Hi > How do I replicate an entire database using CDR? I used the sample API > programs for replication of tables. Do I HAVE to replicate one table at > a time. I have around 8000 tables. Pls help > > Deepa Deepa, I think you had better use the HDR…
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…
Replication
Howdy, We are running Baan Version 4b with Informix 7.23 UC4 on HP-UX 10.20. We are considering setting up "Update anywhere replication" using a 2 meg pipe to another site. This would in theory resolve most of our Disaster Recovery / HA issues. Any information about the fol…
Replication
Howdy, We are running Baan Version 4b with Informix 7.23 UC4 on HP-UX 10.20. We are considering setting up "Update anywhere replication" using a 2 meg pipe to another site. This would in theory resolve most of our Disaster Recovery / HA issues. Any information about the fol…
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.…
Replication
Hi, i am working with SCO Open Server 5.0 and OnLine DS 7.22 UC2. One Server (Server A) is my primary Server, the othe (Server B) is the secondary Server. Replication works well, but after stopping Server A with "onmode -ky", i have problems with my secondary Server: 1. On the …
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…
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…
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…
Replication
Hi, This is regarding the data replication query by m.l.wilson. CDR supports only with Informix DSA v7.22 and above. It is pretty good with horizontal and vertical sub-set replications. It also got a Windows NT replication manager to work with though the command line option is …
replication
greetings, Can someone tell me what tools that Informix has available for data replication in version 7.23? I know of CDR (continuous data replication), HDR (high availablity data replication) and ER (enterprise replication). Are some of these products version specific? I am…
replication
Greetings.... I am interested in the functional differences in CDR (Continuous Data Replication) and ER (Enterprise Replication). Our site (Informix 7.23,Solaris 2.5.1 on Sparc Enterprise 3000's) is looking at a primary web server and a primary database server with high avail…
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…
Any expiriance with CDR
Does any one has any expiriense with informix replication ? I need information on how reliable it is Thanks for any help David…
Re: license and user count
In article <5m1v4l$tp@cssun.mathcs.emory.edu>, djames@statsci.com (Daniel James) wrote: >Nils Myklebust wrote: >> :How do you count the number of users currently attached to informix versus >> :the number of licensed users you have available. i.e. How do you tell when >> :you…
High Perf. Loader & Replication
Hello, Is there anyway to tell the high performance loader to do it's work without affecting replication, i.e. begin work without replication? Or would I have to stop a replicate in order to use pload without replicating? Thanks Pete Stiglich -------------------==== Post…
Using Replication Manager on ODS 7.22
Can someone please guide me as how can i setup informix Data replication ...…
Replication
Hi, I would like to know if the replication is always a database (master) to a database (read only) ? I would like to have one database master and 4 databases (read only). Is it possible ? Could we have one database read/write and use the replicat…
Ingress - Informix replication
Does anybody know any good tools for Ingress to Informix data replication? Thanks in advance.…
Replication
Hi all. I have a client who is considering using the Informix replicator to perform around 250 transactions per hour over a WAN. As I have no knowledge of the product, could smoebody please give me their experiences of it's good and bad points? TIA NIck Wadge Seer Systems Ltd…
Relication
Does anyone know of any problems or bugs with the 7.20 replication? I have a rs6000 590 (single processor) aix 4.1.4. Thanks…
Replication
What's the latest buzz on replication? I went forth to the informix.com web site to learn more, but did not find anything. And checked the manuals, of course. :-) I'm specifically looking for some kind of comparison information or specs on INFORMIX vs SQLServer vs Oracle. ( …
Database replication - where to start
Is there a FAQ regarding setting up database replication? Many thanks in advance.…
Replication
Hi, Im designing a distributed information system for which I will need to incorporate replication among a number of users' workstations. The workstations will be either continually connected via ethernet LAN, or at times disconnected via laptop link. Im having difficulty gettin…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: System tuning
This is a multi-part message in MIME format. --------------64177A585579 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Informix Sysadmin wrote: > We have been having performance nightmares, so we have been attempting to > modify some parameters, howe…
Re: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)
>While with the two-phased commit strategy you can be sure that all >replicate databases are consistent at any given time with the primary, >performance does suffer and the possibility of transaction rollback at >all sites increases with each replicate database entered into the >…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a lot …
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Re: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)
heabrujac@aol.com (Heabrujac) wrote: >I have worked with both Sybase's and Oracle's replication methods. And >replicate data can become inconsistent with both systems. Oracle uses a >set of deferred transaction tables and job queues. The two phase commit >ensures delivery of …
Re: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)
I have worked with both Sybase's and Oracle's replication methods. And replicate data can become inconsistent with both systems. Oracle uses a set of deferred transaction tables and job queues. The two phase commit ensures delivery of a deferred transaction to a replicate site…
Data Replication
We r planning to implement the data replication strategy in our client applications. I would appreciate any and every kind of feeback on this issue. Thanx ____________ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. 226 Westchester Ave | Office : (914) 681 32…
Replication Servers.
Dear All, I have a customer who's data is critical enough to warrant the cost of a replication server, and who are big enough to afford it. Both Informix Online 7 and HP/ux 10 offer this, both are relatively recent. Has anybody out there used either of these in anger? Anybody c…
Replication Server
This is for a friend of mine. Send all questions and/or queries to my e-mail address and I'll forward it to him. Thanks, ********************************************************************** Replication Server ***************************…
Data Replication .....
We are trying to setup data replication between two sparc systems running Online 7.10 over a slow link (56KB) between New York & Hong Kong. What happens is that the primary server locks up from time to time which I presume is due to the log writes ( we are using unbuffered loggin…
Re: Question about database replication
>do I need transaction logging to replicate a database over a WAN? >If not, what is transfered to synchronize the replication? You must have logging to implement replication -- it is the log buffers that are sent from the primary to the secondary, and this is how changes are app…
RE: Selective data replication across WANs
Full system replication is all that is available. Maybe Praxis has a product to automate replication of subsets of Informix databases? Dan…
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?…
data replication
Hello Informixers, We have a DG AViiON running DG/UX and a 486 running SCO/UNIX. Informix 5.x runs on both platforms. We want the 486 to serve as a fall back when the AViiON fails. How can we do it? I tried restoring a set of db archive + logical logs saved on the AViiON o…
Re: Performance Monitoring
ctaberman@cix.compulink.co.uk ("Colin Taberman") wrote: > > > Does anyone know of any monitoring tools / packages which are available > for Informix OnLine v6. I am looking specifically for any utilities which > may be available to report for information available from the Inform…
Data replication
Hello, I would like to make my database robust. Currently I am running disk mirroring on Informix5.0. I have in mind using HP Switchover to replicate my servers, but I have no idea as to what is the effect on the database. Do I then still need disk mirroring or would Switchov…
Re: REPLIICATION VENDORS
See my posting in comp.databases.ingres on this topic. CA-Ingres Replicator *I believe* is the only production replication functionality out today that offers table and row-level replication. Sybase offers instance-level (e.g. replicate entire db), and is coming out with table …
Re: INFORMIX ON-LINE REPLICATION
I can tell you that 7.10 supports only instance-level replication.…
Table Replication
Hello out there, yesterday I have read an article about Oracle V7.1. One of the new features are replication of tables. Now I want to know if such a feature will also be supported by any INFORMIX version. Any hints are appreciated... Dirch -- +-------------------------------…
Synchronous replication
I see in the Technical Brief for the Dynamic Server 6.0 a mention of the ability to remotely replicate databases both asynchronously and SYNCHRONOUSLY. The latter would be a unique capability. Does anyone know what this really means? -- Jonathan Edwards edwards@intranet.com …