Oninit® Archive
Results for “CDR_SUPPRESS_ATSRISWARN”
Enterprise Replication
We are starting to set up Enterprise Replication with IDS and IWS 7.30.tc2 on NT 4.0 servers. We had three server participating in our replication scheme and things seemed to be going well, until... I came in after a weekend and the were no humans logged on, but there were 195 …
Simple Large Object Replication
Hi Juan Luis, in case "not yet decided which kiind of" should also include ER (Enterprise Replication) and they'd decide for that, they could even keep their blobspace blobs. (And ER also supports non-logged smart blobs.) It really depends on what they want to achieve... Andreas…
cdr check returns sql -201 error
When I execute the cdr check commamd I get a -201 (SQL Syntax error) returned. This is so weird because I have many replicates on this server and database that work normally. I tried deleting and re-defining the replicate but it didn't make any difference. Any ideas? I've includ…
invalid replicate state change
I need some help activating two replicates on one of my instances. uname -a Linux psdb10rpr 2.6.32-431.17.1.el6.x86_64 #1 SMP Fri Apr 11 17:27:00 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux crt01rf: onstat - IBM Informix Dynamic Server Version 12.10.FC4 -- On-Line -- Up 44 days 00…
ER time to define a replicate in 11.50 and 12.10
OK. Today, I am able to do a test /verification on this again. [informix@maggie ER_benchmark]$ onstat -version Program Name: onstat Build Version: 12.10.FC4W1X1 Build Number: N028 Build Host: lxvm-l172 Build OS: Linux 2.6.18-128.el5 Build Date: Tue Sep 16 15:07:24 CDT 2014 Build…
ER Domain behaviour
Hi All, Sorry in advance if I'm posting something obvious (busy, stressed, mostly little sleep), but I'm getting something I didn't expect. Setting up Replication - 11.70.FC8 server A - group 1 - machine x server B - group 2 - machine y server C - group 3 - machine z init A (R…
Informix upgrade
>> Only if the Workgroup license doesn't cover something from Enterprise that you actually use. Enterprise replication would be an example. Everett is wholly correct, but a better example might have been the use of table fragmentation, permitted in Enterprise, not available in W…
Question about ER queues
Look at the queues are both ends, are you seeing ris/ats files being generated ? Is the queue increasing ? MP rule of thumb the problem is usually the target Cheers Paul > Informix V11.70.FC2 > Sun Solaris 10 > > All, > > I have a question about Enterprise Replication queues. I…
cdr sync question
All, Informix 11.70.FC2 on Solaris 10. I have an ER environment with 10 source instances replicating to 1 destination instance. The destination instance has 2 databases. One for data from UTF8 databases and the other for the rest. I have a particular table that has the same num…
Problem with "cdr modify repl"
Hi. Informix Ultimate 11.70.UC5X4 OS: Suse Linux Enterprise Server 11 SP1 We want to change the modifications of a replicate with the following Syntax: "cdr modify repl -Ctimestamp -Ry -Srow replname" Here we get an error message: command failed -- fatal server error (100) Out…
ER - How many times a table has been replicated
I'm trying to find out which tables are most active in Enterprise Replication, anyone have any ideas? Am I just missing something really obvious? Thanks, Andrew…
Flexible Grid and ER
'cdr define server', '--ats=/tmp/ats', '--ris=/tmp/ris', '--atsrisformat=text', ' --init g_batman' 'cdr', 'define grid Gotham g_batman ' 'cdr define server', '--ats=/tmp', '--ris=/tmp', '--atsr isformat=text', '--leaf', '--sync=g_batman --init g_waynemanor' 'cdr define server…
dbimport logging how to stop
thanks for that info Fernando We use enterprise replication here, Would logging of smart blobs be needed for that ?…
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…
Anyone familiar with this ER error ?
two transactions failed with an "Unknown stream option with discard bit" error. CDR 49 on what appears to be an update operation. Anyone know what this error message is about ? Judging by the ?|?|? .. it appears that the pk and it's row data vanished or something. ---- RIS ----…
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…
ontape level zero format
Gzip or Compress isn't good enough? Gzip compresses an ontape backup down to nearly 10% of its original size. Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-807-SQL5(7755) AIM: Iamwyza Google+ Profile jonathon.wy…
LOGSIZE change not being picked up
I recently increased the size of the LOGSIZE value in my system. Over the weekend I had a chance to bounce the database (along with the system) during a hardware change. However when looking at onstat -l. it is still showing the log size being 5k pages (which is definitely not th…
Enterprise Replication Problem
Hello Informix-Users. OS: SLES11, SP2 We want to migrate from IDS 7.31.UD10X1 to Informix Ultimate 11.70.UC5 and in this context we set up an Testenvironment which should be a copy of our productive System. In this Testenvironment we`ve got a problem with Enterprise Replication…
HDR & RSS
Have you looked at enterprise replication? I reckon enterprise replication is the way to go. Very easy to keep in sync,and easty fix if it gets out of sync. If you have are not keeping the logs ,that is have device set to /dev/null why bother to log at all doesnt make sense ?…
enterprise rep cdr repair ats fails
IBM Informix Dynamic Server Version 11.50.FC6 HP-UX wuasp132 B.11.23 U 9000/800 any er experts out there can help please Trying to repair replicate using cdr repair cdr repair ats ats.ec_ap_uat_wlg.ec_ap_uat_akl.D_3.110623_10:20:06.2 ATS or RIS file format error at line 10 nea…
ontape/on-bar compatibility between PA-RISC & IA64
Jeff, Thanks for the info, and especially for the link. Brad…
Enterprise replication replicating instance on sam
hello folks IBM Informix Dynamic Server Version 11.50.FC6 Using enterprise replication update anywhere conflict resolution Looking for some advice on the following. I have two servers running replication fine replicating between phyical servers wuast130 and auast120. on server w…
SQL Error 195 after CDR DEFINE SERVER
Hi MP! Follow my g_u01h CDR variables: CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 5 CDR_QUEUEMEM 8192 CDR_NIFCOMPRESS 0 CDR_SERIAL 10,1 CDR_DBSPACE rootdbs CDR_QHDR_DBSPACE erdbs CDR_QDATA_SBSPACE ersbs CDR_SUPPRESS_ATSRISWARN 2,3,4 CDR_MAX_DYNAMIC_LOGS 62 The g_u01h CDR chunks are OK…
IDS Error: CDR DEFINE SERVER
Hi! I have instaled the IDS v. 10.00.FC8W4X7 in AIX 6, and i execute with user informix the command: "cdr define server --ats=$INFORMIXDIR/tmp/ats --ris=$INFORMIXDIR/tmp/ris --sync=g_db1 --init g_db" IDS return this error: "command failed -- General Error (-1) (-1)" Os parâm…
Erro ao executar CDR DEFINE SERVER
Boa tarde a todos! Tenho instalado o IDS v. 10.00.FC8W4X7 em uma AIX 6, e ao executar com o usuário informix o comando: "cdr define server --ats=$INFORMIXDIR/tmp/ats --ris=$INFORMIXDIR/tmp/ris --sync=g_db1 --init g_db" o IDS retorna o erro: "command failed -- General Error (-…
PHP / PDO_IBM
This may, or may not, be the place to ask, but as google has thus far failed me... I'm attempting to get PDO_IBM setup in PHP 5.2 in IIS 7 on windows 2008 R2. As I understand it, PDO_INFORMIX is no longer a maintained product and thus is no longer distributed with the CSDK. Now …
ER Replication question
IDS11.5FC7 We have been running replication on IDS10 for quite some time with no problems. Recently, we moved one of our databases to new servers with IDS 11.5. I am constantly seeing ATS failures on these new servers. It looks like the CDR process is trying to post child record…
Error -19816: Cannot perform this operation on a
We are not using Enterprise Replication, just HDR. We have CDC but there is no CDC sessions running on the server. Where else should I look? Thanks for the response.…
DBA position open
Paddy Power in Dublin Ireland is looking for a very senior Informix DBA. Here's a URL to their job request: http://tbe.taleo.net/NA2/ats/careers/requisition.jsp?org=PADDYPOWER&cws=1&rid=47 76 I'm not involved, just passing it along. Art Art S. Kagel Advanced DataTools (www.ad…
DBA position open
Paddy Power in Dublin Ireland is looking for a very senior Informix DBA. Here's a URL to their job request: http://tbe.taleo.net/NA2/ats/careers/requisition.jsp?org=PADDYPOWER&cws=1&rid=4776 I'm not involved, just passing it along. Art Art S. Kagel Advanced DataTools (www.adv…
Money Formating
Is there a simple way to format a money column in SQL? (eg, I want it to come out as $###,###.##) I know concatenating an empty string to a money field puts in th $ but not the commas. I saw the DBMONEY environment variable, but didn't understand the syntax, so that might just be…
using ? in "in"
Anyone know if it's possible to use the ? placeholder in a "in(?)" statement? Specifically I'm attempting this in perl. Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcol…
wildcard in replace function?
Is it possible to use a wildcard in the replace function? I was trying something like this: replace(value, "*@", "") which would replace everything up to and including the @ with nothing. But no dice. I also tried % but that didn't fly either. Thoughts? Jonathon Wyza CX & CBO…
Environment variables being ignored
Could be you were in a different shell type? (bash vs csh for example) Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================== SLES 11x6…
DBSPACETEMP fills up..what's used next?
Why not increase your temp space and/or fix the queries that are eating it all up? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================…
Enterprise Replication systems
It states the systems must be homogeneous..what happens if you need to do an OS update (upgrade levels) or even update the IDS? Do you have to take all systems down to do this? Also, I read something similar for HDR...is that the same?…
ontape restore question
Does the temp space need to be the same on between 2 instances to do an ontape restore? (I know the rest of the dbspaces need to be, but I was wondering if temp needed to be) Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel Coll…
Restore from one server to another using ontape?
If I have 2 servers with identical architecture but different chunk sizes for the db spaces is it possible to do an ontape backup from one to another? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: …
Index on temporary table?
Is it possible to create an index on a temporary table? I have a script that creates a temporary table worth of data and then does a great deal of selects and parsing of the data inside of it. I was thinking of putting an index on a few key columns in the table to speed it up but…
Enterprise Replication help - urgent
Hi, I have two machines, RHEL4, IDS 11.50.UC5X2 is a ER Leaf node, RHEL4 IDS 11.50.UC5 is the ER Enterprise node. The leaf node is in collect mode and won't transfer any data back to the ER node (we have replicates running both ways and neither are processing at the moment). I ne…
IDS on a virtual machine
I thought I remembered reading or hearing at some point that there were some special settings for IDS 11.5 in order for it to function well on a VM, but I can't seem to find any references. Am I right in remembering or am I crazy, or both? Jonathon Wyza CX & CBORD System Adminis…
HDR Information
I'm getting ready to start working on setting up HDR and have gone searching google for information about doing so. There seems to be a wealth of it out there, but I'm wondering if there is one in particular that would be classified as " the best ". Jonathon Wyza CX & CBORD Syst…
Update Statistics
If the AUS evaluator is run and says x number of tables need stats updated, then AUS runs and no-one touches the database, shouldn't the number that the evaluator says are needed decrease? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computi…
Alert in OAT
I have seen this show up every day after the update statistics refresh task runs. TASK NAME Auto Update Statistics Refresh LOCATION ERROR -206 The specified table (aus_work_dist) is not in the database. ERROR -111 ISAM error: no record found. We don't have that table in our dat…
Raw Devices
Read all of the posts for the last 3 days on this list serve to get a fairly good idea of all the advantages. Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu =…
Performance issue with ZFS
Why not raw? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================== SLES 11x64 & IDS 11.50.FC6 "Don't document the problem, fix it." -…
Analyzing Data from OAT
I recently installed OAT and have begun to watch sql activity to find things that may not be working right. I came across a query that according to the system had a 10817 second response time. The detail statistics don't show anything that would be out of the ordinary and the qu…
Primary Key vs Unique Constraint
Is the primary difference between primary key and unique constraint that primary keys can be used with foreign keys and unique constraints can't? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwy…
IDS 10 -> 11.5
Is there a good set of pages somewhere that let you know about the new stuff that 11.5 gives you over 10? We recently upgraded to 11.5 and I really want to know about all the stuff it offers that 10 didn't. Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Admi…
OAT Download
This is probably *not* the right place to ask this, but trying to find the right line to ask IBM on their website is aggravating. We recently upgraded to IDS 11.5 and I'm interested in installing OAT. I went to download it from IBM's website but using their download tool results…
Perform Screens in Color?
Is it possible to have perform screens in color (other than setting a generic foreground/background for the whole screen)? I've been looking high and low for documentation on all the functions/features of perform screens but to no avail. Thanks in advance. Jonathon Wyza CX & CB…
Enterprise Replication issues
Hi, IDS version 11.50.FC6 OS version: Solaris 10 I have 3 servers A, B and C A is replicating to B using Enterprise Replication B is replicating to C using Enterprise Replication From B to C, I replicate only a subset of tables with a different structure. When I insert a n…
replicating databases in the same instance
I forgot to say we are using enterprise replication and only want to replicate some tables…
replication migration pronb 11.10 to 11.5
hello ,Folks hoping someone can help here I have mirgated fom informix 11.10 to 11.50. Replication no longer works. I have run concdr.sh 11.10 11.50 as stated by release notes,still no joy. Has anyone else struck this problem. When i revert back to 11.10 replication still does no…
ER errors
Hi all, IDS 11.50.FC5 and IDS 11.50.FC5W2 I tried to start a new replicate with synchronisation. The table holds about 2 Million rows on the primary. On the secondary grp_db5 the table was just created and empty. Here are the commands and the results: cdr define repl -c grp_s…
RE: How to delete Enterprise Replication
You may have to bring down the engine and then bring it back up using oninit -D, which prevents the replication treads from starting, then you should be able to drop the syscdr database. Then depending on how tangled up it was, you may have to grind through each database and mak…
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…
How to setup ER using 3 different servers
All I have 3 servers A B and C. I have already ER setup between A and C Server A -------- SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- amvs_ser_sec 11 Active Connected 0 Aug 6 16:47:18 caesium_replserv 66 …
Can't reorg a replicated table
I am using Enterprise Replication (cdr) and I need to reorg a replicated table. (out of extents) I created a new table and loaded it using HDL. Now I need to drop the replicated table and rename the new table. But informix will not drop the table - non exclusive access - I tried …
Re: ER question
bozon wrote: > On Feb 18, 4:19 pm, Madison Pruet <mpru...@verizon.net> wrote: >> bozon wrote: >>> On Feb 18, 2:37 pm, Madison Pruet <mpru...@verizon.net> wrote: >>>> bozon wrote: >>>>> OK, I getting better with ER but I still don't have a clue about some >>>>> things. I can't see…
ER question
On Feb 18, 4:19 pm, Madison Pruet <mpru...@verizon.net> wrote: > bozon wrote: > > On Feb 18, 2:37 pm, Madison Pruet <mpru...@verizon.net> wrote: > >> bozon wrote: > >>> OK, I getting better with ER but I still don't have a clue about some > >>> things. I can't seem to make the fo…
ER Error Enterprise Replication
Enterprise Replication is giving the following message when I do a simple cdr list server ndl12:ndl12a common_reporting$ cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------…
Problem with ER replication
Hello, We are using IDS 7.31.UD1 with Enterprise Replication. We added 4 columns to a table that is replicated, and now got the error "CDR:23 (Error: Internal error (buffer too small for stored procedure arguments))". Is there a limit in the row size of replicated tables? Thank…
Re: Using ER for Migration from 10.0 to 11.5
> Davorin, > > HPL over named pipes is definintely how I got the data over there in the first place, so no problem there. But letting transactions > spool on the source server while I transfer data and build indexes and constraints scares my boss. Mostly because we had problems…
Using ER for Migration from 10.0 to 11.5
> Andrew, > > personally, I'd stay away from both "cdr check" and "cdr sync" for big > tables (not officially supported on v10, only in v>=11, AFAIK). > Crashed my production instances with both. Admittedly, few versions > ago (now running IDS10.FC8W2) but haven't had courage (no…
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…
Re: Enterprise Replication and locking
Jarrod, You can have different lock mode for each participant. To avoid possible locking issues due to page level lock, you could use CDR_DSLOCKWAIT configuration parameter, it specifies the number of seconds ER should wait for the locks to be released. Regards, Nilesh informi…
IDS 10 Replication Logs
Hi All, I am using IDS-10 on two servers and configured enterprise replication on it. Replication is working perfectly fine. If I want to see the SQL processed on primary server which will initiate data to be replicated on target site, please advice where and how can I find thes…
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…
Problem with ER
IDS 10.00.FC6 Solaris 10 I'm currently defining Enterprise Replication. I have a table (table1) that I want to replicate into table2. The first replicate is: cdr define replicate -C ignore --fullrow n --floatieee --ats --ris replic1 \\\\ "P db1@grpm:informix.table1" \\\\ "selec…
RE: Enterprise Replication question
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 missing here? Do I need to turn this …
Enterprise Replication question
Hi, Running 10.00.UC3 -> 10.00.UC3 replication, both on RedHat EL 4 I set up a one-way replicate to transfer data and it works beautifully (Go Informix) but I forgot to set the frequency option in the replicate. I've now set it to the right thing, using cdr modify replicate but…
Re: Error in Enterprise Replication
On 16 May, 14:12, "Navaid Arif" <navaid.a...@access.net.pk> wrote: > Hi All, > I have increased the number of logical logs by adding 9 more logical logs of 20MB each. Now I have 20 logical logs. But the problem is that after performing some table load activity all logs have b…
Re: Error in Enterprise Replication
On 3 May, 07:49, "Navaid Arif" <navaid.a...@access.net.pk> wrote: > Dear All, > I am already using following setting. Should I increase LTXHWM and LTXEHWM to some higher value like 100 or 120 ? > Actually at source side of Replication environment, We are using a vendor applic…
Logical Logs in Enterprise Replication
Hi All, I am using Enterprise Replication on IDS10 UC5. I have 33 Logical Logs for IDS, each of 5000 pages i.e. 20,000KB. Test >onstat -l IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 09:00:11 -- 81408 Kbytes Physical Logging Buffer bufu…
Re: Error in Enterprise Replication
Hi all, Actually, I am using the application which is apparently using dbaccess in the background. For some reason, I cannot ask my vendor to change the application therefore, I am using the other way around i.e. adding more logs or freeing previous logs which are used and ba…
RE: Error in Enterprise Replication
Navaid, You need to load the data in smaller chunks. You are opening a transaction at the beginning of the insert and then you start inserting records, these inserts are getting put into the logical logs. You cannot wrap around the opening of the transaction, "BEGIN WORK". …
Re: Error in Enterprise Replication
Hi All, I have increased the number of logical logs by adding 9 more logical logs of 20MB each. Now I have 20 logical logs. But the problem is that after performing some table load activity all logs have become 100% used. At this stage, no application is running even I have r…
Re: Error in Enterprise Replication
Dear All, I am already using following setting. Should I increase LTXHWM and LTXEHWM to some higher value like 100 or 120 ? Actually at source side of Replication environment, We are using a vendor application which is not using dbload or other utility and I cannot force my v…
Re: Error in Enterprise Replication
On 02/05/07, Navaid Arif <navaid.arif@access.net.pk> wrote: > > Hi All, > I am using IDS 10 UC5 and during testing of Enterprise Replication > facing following problem: Anyone have any idea about it? > > > SQL: New Run Modify Use-editor Output Choose Save Info Drop …
Error in Enterprise Replication
Hi All, I am using IDS 10 UC5 and during testing of Enterprise Replication facing following problem: Anyone have any idea about it? SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit Modify the current SQL statements using the SQL editor.…
Information required regarding ENTERPRISE REPLICAT
Hi All, I am planning to implement Enterprise Replication in my Production environment. I just wanted to know, are there any limitations for adding number of replicates in ER regardless of Network connectivity? And what are the points which I should take care of. Also advice wha…
Re: Abnormal behaviour of Enterprise Replication
On 17/04/07, Navaid Arif <navaid.arif@access.net.pk> wrote: > Hi All, > > I created the database having table "merchtbl" with "no logging" option two > years back and enabled UN-BUFFERED Logging on this database recently. My > question is, how can I enable unbuffered logging on t…
ER error :Could not read from received stream
HI, Madison, Folks, ISD10 UC5 AIX 5.3 What is the possible reason for the following error? ER servers have been successfully started and connected between two sties. Interesting is that update can be replicated from site1 to site2, but NOT vice-versa(see between). Thanks, Fra…
Abnormal behaviour of Enterprise Replication
Hi All, I am running IDS10 UC5 on AIX5. And successfully configured ER-Replication on both Primary Server (srvtest) and Target Server (eftdr). Replicates rp72_dralways and rp72_merchtbl are successfully added but replication is working only on rp72_dralways successfully, othe…
Enterprise replication errors
Hi, I'm setting up Enterprise Replication as a primary target between 2 servers I've defined my replicate servers and my replicates and started the replication. When I update a record on the master, the information is sent to the slave server. However, the transaction is rejected…
Re: Splitting logical logs
news.arcor.de wrote: > IDS 9.4 WE, Sola�ris 9 > > Hi everybody, > > we use to back up our logical logs using "ontape -c", for example in a file > named "trans.log". > As a consequence, when restoring a Level-0 backup using ontape -r, we can > only restore *all* logical logs con…
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…
Splitting logical logs
IDS 9.4 WE, Sola�ris 9 Hi everybody, we use to back up our logical logs using "ontape -c", for example in a file named "trans.log". As a consequence, when restoring a Level-0 backup using ontape -r, we can only restore *all* logical logs contained in the trans.log or *no* logic…
Re: IDS Performance Problem
I am going to be setting up replication (HADR) between to Linux boxes running RH Enterprise 4.0 and IDS 10.00.FC5. Do storage backups have to run on the slave server when in slave mode? Or only when in master mode? Thanks Peter…
ER crash
HI, Folks, AIX5.3, IDS UC5. the scenario is, (1) define a pair of update-anywhere ER replication server between two separate boxes, (2) define a replicate, some thing like , cdr define replicate --conflict=always --ats --ris abc_test_repl \\\\ "noaa@osdint1_grp:informix.abc_t…
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: CDR CHECK -R returns error
Hi Yes i have created the extra checksum functions for blob and clob, and i've checked that the checksum.c file that i've compiled is the one located here: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0604pruet/ so im pretty sure im running with the correct …
error on define ER replicate
Hi, The following definition is successfull if I use "ignore" conflict rule, but falied if choose "always-apply"(see attached info), any idea? Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version:…
ER replicate creation err
Hello, Program Name: onstat Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8 I am creating replciaes, cdr define replicate --conflict=timestamp --ats --ris ds_chksum_repl \\\…
Enterprise Replication error when attempting to delete a replicate
Bogdan Botez wrote: > Hello, > > When attempting to delete a replicate, the following error is raised: > > $ cdr del repl r_bln_db_b0400_db_sk57 > command failed -- Attempt to perform invalid operation including > shadow replicates > (122) The shadow replicate should eventually …
ER transactions queuing, NIF in BLOCK state
I can see that there are transactions in receive queue but it does not look like they are being applied. There is nothing to speak of in any of my other queues on this server, the sendq occassionally has a transaction in it. What could be causing the received transactions to appe…
CDR questions
Hi people !! I have 2 questions about ER in Informix 9.40: 1 - I am testing ER in a same host, using Linux and Informix 9.40, but I am receiving the followin error during the cdr define server: (I was using: cdr define server --init --ats=/tmp/ats --ris=/tmp/ris <group name>) "…
RE: ER Problem
Madison Thanks for replying. Raised a support call on this as well (73443.999.866). Sent some log detailsas requested, but onstat -g ath wasn't asked for. Support suggested I ran cdr stop, cdr start on the target which I duly did and all is now running satis. Replicated rows app…
ER Problem
All ER on AIX 5.3 IDS 9.40.FC6 replicating (source to target) selected tables to Solaris 5.8 IDS 7.31.FD6X1. After running out of locks on the target box (due to a massive delete independent of ER on a table outside of the ER environment) and a long transaction rollback (due to …
Re: ER - inital data loading problems
Yo estoy replicandodos bases de datos y no utilizo templates, solo creo replicas y las sincronizo. cdr define Server - -init g_hofman10UC4 cdr modif. Server -ats=/opt/informix/ats -ris=/opt/informix/ris ghofman10 dr define server --connect=calamar10_ER --init --sync=ghofman10UC4…
Enterprise Replication between 9.40 and 10.00
Hi I'm trying to add in a new 10.00.FC4 (RHEL AS4) server into an Enterprise Replication environment that already has 2 servers running 9.40.FC2 (Tru64 5.1B), but when I issue the cdr define server command from the sync_server, I get the following error: connect to g_bsids2b fa…
ER - inital data loading problems
"Madison Pruet" <mpruet@comcast.net> wrote in message news:5LGdnZsQl8VROIjZnZ2dnUVZ_sKdnZ2d@comcast.com... > Can I see the exact commands that you used? Here they are: -- on primary server cdr define server --idle=500 --init g_debian -- on targets cdr define server --idle=500…
Enterprise Replication Conflict Notification
The scenario that I was think of is the one where two users, each on different servers, modify the same row during the same point in time. They may modify seperate columns of the same row but since we are doing full row replication, a requirement for update anywhere ER, the whole…
Re: ER and ats/ris Files
Madison Pruet wrote: > It's been quite some time since I used it.... > > -------------------------------------------------------------------- > #include <stdio.h> > #include <stdarg.h> ... Nice code, two comments: On 9.30 and 9.40 hangs all queries with er group name (with 10 no…
RE: ER and ats/ris Files
Madison Thanks for this. Bit beyond my C skills to risk tonight, I will catch up using sql comparisons, but this is certainly something I will follow up with over the next few days, get it compiled and test. Can't remember at the moment, is there something like this built into 9…
ER and ats/ris Files
All IDS 7.31 on Solaris I'm using ER to replicate selected tables in a primary/target environment. Due to an oversight one of the dbspaces filled up. I've added space but am left with almost 5000 ats/ris files detailing failed inserts/update/deletes. Is there a (simple) way of e…
Re: informix market share
"DA Morgan" <damorgan@psoug.org> wrote in message news:1133072683.547964@yasure... > xiaoxin wrote: > > The list price of IDS is about 20% more than oracle EE. No one is > > more expensive than oracle, when it comes to database. > > But wouldn't a more accurate comparison of IDS …
Re: ER between different versions
Hi, ER (Enterprise Replication, aka CDR): yes. And just to be clear: HDR (High avalability Data Replication): no. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 11/24/2005 07:55:57 AM: …
Enterprise Replication, hour syncronization
Hi all, I should implement an installation of Informix ER with 12 servers. I'm afraid of the right syncronization between all the 12 servers, 8 Linux SUSE, 4 Linux SUSE on VMWare and 4 Windows OS that accomodate the virtual machines. About the hour sync: how many seconds/minute…
Enterprise Replication restore concerns
I am in the process of implementing a 7-node update anywhere ER solution. My management has successful posed a few questions that I cannot answer and can't seem to find any literature on. Question #1 If a cold restore has to be done on a specific node and the last logical log wa…
ER licensing
Willem, There is no additionnal license for Enterprise Replication if you have an IDS Enterprise Edition. If you have a Workgroup Edition, contact IBM. see this URL : http://www-306.ibm.com/software/data/informix/ids/enterprise/ Regards. ________________________________ Phili…
cdr_deltab tables/sync up tables
Mostly in the v10 documentation. In v10, we have the ability to 1) re-try from the ATS/RIS files. Also, we are planning on enabling some additional functionality in the UC4 interim which should further enhance the ability to check for inconsistant data as well as automatically r…
ER replication failures from 9.30.FC5 to 10.00.FC3
DL Redden schrieb: > First off I know 9.30.FC5 is out of service, so save > your breath. Regardless we still have it production on > a few servers and are trying to migrate onto > 10.00.FC3. An older version means: Fewer features, fewer bugs... > Topology is: > > P=9.30 > T=10.0…
RE: ER between two databases in the same instance
Some people might disagree with me, but it would be nice to have, even if just for marketing purposes. Imagine someone asking this question when comparing databases. Can your database do this ? It just makes the database so much more flexible. Question is, can Oracle do thi…
Re: ER between two databases in the same instance
Seems to me that it should be something that is available. I'm sure that there is a good reason why it is not but I would have assumed that it could be done if I did not no better. If available I'm sure that lots of folks would find a user for it although I cannot say that I, pre…
Re: ER between two databases in the same instance
Question for the group as a whole... How important is this functionality? "cristizaharioiu" <cristizaharioiu@gmail.com> wrote in message news:1125990751.160483.46740@g14g2000cwa.googlegroups.com... > Hello, > > Can I define a replicate for a table between two databases in the sa…
ER between two databases in the same instance
Hello, Can I define a replicate for a table between two databases in the same instance (the same group) ? Here is the replicate : cdr define repl -C ignore --scope=transaction --immed --ats --ris r_tabela_test "P bd_test_1@g_scot79:informix.tabela_test" "select * from tabela…
Re: No future for DB2
Madison Pruet wrote: > Since the IBM Informix Enterprise Replication uses less than 10% of the > total resources, it is simply easier to replicate the whole DB. And since > disks are so cheap now, I would have difficulty not justifying having a > multi-node grid like arrangement…
Re: No future for DB2
"Madison Pruet" <mpruet@comcast.net> wrote > Since the IBM Informix Enterprise Replication uses less than 10% of the > total resources, it is simply easier to replicate the whole DB. And since > disks are so cheap now, I would have difficulty not justifying having a > multi-nod…
Re: No future for DB2
"bka" <badamache@yahoo.com> wrote in message news:1122867226.713664.145680@z14g2000cwz.googlegroups.com... > Replicaton to/from Oracle has nothing do with Enterprise and/or > standard edition - to replicate to Oracle or SQL Server, you need IBM > Information Integator. > On mina…
Re: No future for DB2
Replicaton to/from Oracle has nothing do with Enterprise and/or standard edition - to replicate to Oracle or SQL Server, you need IBM Information Integator.…
Re: Enterprise Replication
Jonathan Leffler wrote: > Marquis de Bogier wrote: > >> IDS 9.4 (Linux) >> >> 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 replicatio…
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…
Re: Informix Enterprise Replication
Dear All, I opened a case with Informix regarding this issue. They came back to me today and said it was a known bug with Solaris 8 and IDS 7.31.UD1, that was fixed in UD3. So my plan now is to upgarde Informix. Thanks again to all who tried to help. Regards Alex "Alex Daman"…
RE: Informix Enterprise Replication
Dirk Moolman > > Sorry, meant to say "save" ......... d'oh ! > > On Behalf Of Dirk Moolman > Sent: 16 February 2005 11:43 AM > > Just to safe yourself possible headaches - make sure your > Solaris patches are not old / out dated - caused LOTS of > problems for me ! We fort t…
RE: Informix Enterprise Replication
Sorry, meant to say "save" ......... d'oh ! -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Dirk Moolman Sent: 16 February 2005 11:43 AM To: Alex Daman Cc: informix-list@iiug.org Subject: RE: Informix Enterprise…
RE: Informix Enterprise Replication
Just to safe yourself possible headaches - make sure your Solaris patches are not old / out dated - caused LOTS of problems for me ! -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Alex Daman Sent: 16 February 2005…
RE: Informix Enterprise Replication
You should use the group server (g_pocmel instead of pocmel). Uri -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Alex Daman Sent: Wednesday, February 16, 2005 9:09 AM To: informix-list@iiug.org Subject: Informix En…
Re: Informix Enterprise Replication
Alex Daman said: > > No matter what cdr command I run, I get this type of response back. My > INFORMIXSERVER variable is of course set, however I think the problem lies > somewhere else. Very frustrated at the moment Other commands work OK? Like onstat, onmode, etc.? -- Bye no…
Informix Enterprise Replication
Hi All, Is there anyone out there who has setup ER on 7.31.UD1. Im trying to implement a proof of concept for replicating two of our sites. Im runnig with Online 7.31.UD1 on Sun Solaris platform. I have configured my sqlhosts files according to the Replication guide, see below: …
Enterprise replication-unable to initialize server
I have three servers: server1 IDS 9.30 server2 IDS 9.30 server3 IDS 9.40 Server 1 and 2 are currently doing update anywhere replication, I want to add server 3. This is my define script: cdr define server -c omagrs -A /tmp/ats -R /tmp/ats -I omagrs -S omaha Here's what the log…
error cdr define repl
hello all! I try to define a new replicate using cdr define repl and I receive next error in online.log: 11:14:06 CDR Queuer: rqmQueueTxn (1000/0/0x2886/0x0) failed on CNTRL 11:14:06 CDR GC: operation sparse control message queue failed (error 0). the command is: cdr define…
replication error
Try using: cdr modify server --ats=dir --ris=dir server All failed transactions will be logged on dir. cdr modify server usage: cdr modify server [-i min] [-A dir] [-R dir] [-m p | r] [-l on|off] server -c server --connect=server connect to server -i min --idle=min idle timeou…
How to stop Enterprise Replication on IDS7.3
Hi all I was tesing Enterprise Replication on IDS7.3. I have implemented ER on one table and it is working well. Now am unable to remove it successfully. Kindly help me out Regards Abdul Haleem…
Enterprise Replication no start or stop
Hello everybody, I have a problem with enterprice replication. Informix version is 9.30.UC2W8 I delete server from replication and now i can't do anything. When I run command: "cdr start" the answer is that it's already active (63) when I run command: "cdr stop" the message is…
Replication (different OS-es and IDS versions )
Hello, I have 2 IDS 7.3/Uniware servers working with replication enabled. I would like to migrate one of them to 9.4/AIX and then to enable enterpsrise replication with the second IDS 7.3/Unixware server. I could not find unequivocal answer in Informix Enterprise Replication G…
Strange characters in ATS file
IFX version = IDS 9.40.UC2 OS version = Solaris 8 We have recently upgraded from IDS 9.3 to IDS 9.4.UC2. Since then I noted funny characters in the ATS files created by the replication server when aborts occurs. I have created a replicate for the following table: create table …
Enterprise Replication: Serverstate = Quiescent
Hi all, IDS 7.31 UD4 SCO Unix 3.2 5.0.6 'cdr list serv' on server olms152cdr shows: olco234cdr 20 Quiescent Connected Jul 10 23:03:16 2004 'cdr list serv' on Server olco234cdr shows: olms152cdr 13 Active Connected Jul 10 23:03:17 2004 Serverstate…
Database replication with 9.4
brett wrote: > Hi all > > Has anybody used the data replication feature of IDS 9.4 ? > > For the manual it looks very exciting and will provide the solution > for our proposed redundant database site. I've used Enterprise Replication (ER) with 7ish engines and so have many peop…
Re: Extremly long checkpoints: How to find the reason and solve the
I don't have the DSS Query right now, as a matter a fact , I don't even work on the same company where I had that problem. In that time, the decision was to migrate to Enterprise Replication because of this problem and primary because of the replication granularity flexibility al…
Alter Fragment on a table in syscdr
Hallo, I have a large table "trg_send_sbuf" in dbspace "cdrquedbs" belonging to the database syscdr (Enterprise Replication). The table has 1 GB with no rows. Can I do an ALTER FRAGMENT ON trg_send_sbuf INIT IN <cdrquedbs>; to reclaim the space without any trouble with ER. Mus…
Enterprise Replication & Triggers
Are you sure that the replicate has ATS/RIS turned on. The server might have it enabled, but unless the replicated has it turned on, you will not get anything. "Bj" <Bruxelles.Jette@caramail.com> wrote in message news:89d8947b.0405101328.68bb1b20@posting.google.com... > Hello M…
Enterprise Replication : Restrictions
Hello, I have 2 questions when using Enterprise Replication : 1 - In the case of consolidation, is it possible to replicate table from the primary to table from the target which will have one column more containing the name of the primary. It is useful when we have a lot of pri…
Q: continous restore at remote instance?
"Davorin Kremenjas" <davorin.kremenjas@inet.hr> wrote in message news:c6qvtv$ffe$1@bagan.srce.hr... > Hello. > I searched old posts for a possible solution to the problem I have but > without success. > The summary is this: is there a possibility to continously restore > transact…
RE: ISDN & Enterprise Replication
Bj Although ER is possible over ISDN I am not sure I would recommend it. You either need the line continuously available (as you have found) as the servers communicate with each other every few minutes even if there is nothing to send, or you request replication to store up the …
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…
Informix Enterprise Replication
Hi Everybody, One of my cleint wants to syncronize the data in two servers which are at different locations and both the servers should be online so that users can use the servers. I have suggested them to have enterprise replication done on these two servers. They want to go f…
Re: An interesting meeting with IBM
I forgot to mention that work is being done in Enterprise Replication so that re-synchronisation is much easier. Getting that initial sync, and then maintaining it when schems changes, is the only real hassle with ER at the moment.…
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…
another enterprise replication
1/ Is it possible to replicate a table to anothet table ? The new table has more fields and maybe another primary key ? 2/ I have a HDR pair in my EDR replication. This works fine. When I put my primary (hdr) off, and place my secondary to accept all connections (onmode -d stand…
enterprise replication question
Hello, 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 works fine. But when I insert a new…
informix enterprise replication
Hello, 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 works fine. But when I insert a new…
Re: CDR27 warning message in a transaction for a 2 way replication table
There's a CDR:27 buried in here... Source server is 7.31.FD1A, and the target is 7.31.UC6 TXH Source ID:0 / Name:*UNKNOWN* / CommitTime: TXH Target ID:8 / Name:webuat_grp / ReceiveTime:04-01-19 12:13:15 ---------- RRH Row:1 / Collection Id: 524371 / Replicate Id: 524371 / Table…
Re: Undefined replicate crashes IDS
Yes - this is probably bug 155787. I'm really sticking my neck out on offering this workarround, so I need you to be very careful. Otherwise, you will be forced to delete ER on all of your nodes and re-establish it. You might be able to get arround the problem by setting the A…
Any Research Available Comparing Network Traffic of Synonyms and
Does anyone know of (or has conducted him/herself) any research = comparing the network traffic that results from queries against a = database through the use of a synonym (tieing one table from one = instance to another) to that traffic that results from replicating = (through e…
ER problem HPUX - Linux
We are using Informix ER to replicate about 40 tables tween two different Informix Servers. The 'Publisher' runs the database on a HPUX server with version 7.31 of informix and the 'receiver' runs the databases on a Linux server with also version 7.31 of Informix. Things seemed …
RE: Errors in ATS and RIS files of Enterprise Replication
Vadim Yezhakov asked > > Prompt me please, where can i read more about errors, which included > into aborted transaction spooling files (ATS) and row information > spooling files (RIS). > For example: i see such errors: > TXH CDR:101 (Error in retrieving the replicate's attribut…
Errors in ATS and RIS files of Enterprise Replication
Prompt me please, where can i read more about errors, which included into aborted transaction spooling files (ATS) and row information spooling files (RIS). For example: i see such errors: TXH CDR:101 (Error in retrieving the replicate's attributes) / SQL:0 / ISAM:0 TXH CDR:45 (E…
Replicate rows problem. (TXH CDR:45 Error: Could not read from received stream)
Hi. I have replicate source-tables to target-tables. Some records not replicates. In ATS file i see such error: TXH Source ID:21 / Name:g_whrhouse / CommitTime:03-10-16 02:45:35 TXH Target ID:8 / Name:g_almwhr / ReceiveTime:03-10-16 02:44:44 TXH Number of rows processed when tran…
RE: Enterprise Replication question
>Josh Marshall wrote > > I've got Enterprise Replication working nicely with a table > on Informix 9.40, > but I'm wanting to replicate the whole database between the > two servers. > > There is a situation where tables can be dynamically created > and I want these > to automatic…
Re: Enterprise Replication question
Hi Josh. How about using HDR(High-Availability Data Replication) ? See refer to http://www-3.ibm.com/software/data/informix/pubs/library/ids_9.html You may see Admin guide. (Chapter 19). Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Josh Marshall <josh@w…
Enterprise Replication question
Hi everyone, I've got Enterprise Replication working nicely with a table on Informix 9.40, but I'm wanting to replicate the whole database between the two servers. There is a situation where tables can be dynamically created and I want these to automatically be included in the …
Enterprise Replication - Primary Key
Hi everybody, I am in charge of administering two AIX 4.3.3/RS6000 IBM Servers with Informix 7.31 running on each one. After one week of research and night work I got my two servers configured for Enterprise Replication (tmp-ats and tmp-fis filesystems, sqlhost group definition, …
Enterprise Replication questions
I've been assigned the task of coming up with a way of not loosing a = single transaction in case of a physical disaster at the location of our database servers = (and backup servers). =20 To achieve this, I'm thinking of using ER in a many to one mode. That = is, replicating ma…
offline replication
But Enterprise Replication can give us a 'transportable' copy (in tape or disk file) of the data needed to be updated rather than try to connect to any other server to make the updates by itself? That's our main problem: we can't have connected our servers (for geographical reas…
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.…
IDS 9.3 Enterprise Replication
Hi, I have problems to define server for Enterprise Replication running IDS 9.3 on W2K. Command line: "cdr define server --init g_server1" returns an error: "command failed -- Smart blob space specified for the send/receive queue does not exist (107)" Server and server_group bot…
enterprise replication
Hi all, I am trying to set up enterprise replication between two servers. Sqlhosts files of both the servers contain same information. Both servers are using tlitcp connections. I started one server as a replication server. But when I try to start the second server as a replicat…
Re: Using Preprinted FOrms
At 11:09 01/01/22 -0500, Lucky Leavell [RIS] wrote: Hi Lucky. > 2. How would one send a hard FF (0x0C) in the report output? Please use the following syntax. print ascii 12 See also Informix Reference Manual 5-31 Built-in Functions and Operators. Regards. -- Tsutomu Ogiwara…
Re: UPDATE STATISTICS Question
Lucky Leavell [RIS] wrote in message ... >Informix 7.31 > > In the Performance Guide (or was it the SQL Syntax Guide), it states > that one should use HIGH for the entire table on small tables. Just > what qualifies as a "small" table: 1000 rows? 100,000 rows? ?? > Actua…
Enterprise Replication log
Enterprise Replication does not have a seperate set of logs. It snoops from the normal logical log file buffers. It only snoops from the log files themselve during recovery or if for some reason it falls behind.…
RE: ROWIDs ???
Correct me if I am wrong. AFAIK "Alter table add rowids" on fragmented tables will be unique. Agreed, rowids is not a good practice. -----Original Message----- From: Murray Wood [mailto:murray@quanta.co.nz] Sent: Wednesday, 10 January, 2001 1:26 AM To: informix-list@iiug.org Su…
RE: ROWIDs ???
Correct this is not good practice. Far better to use the primary key, or a unique key / index when it exists. Moreover (with fragmentation) rowid may not be unique. -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Be…
RE: Checking for Orphans
--- "Marley, Peter" <peter.marley@acco-uk.co.uk> > wrote: >You could always use NOT EXISTS instead of NOT IN which is a dam site >faster. Which dam site did you have in mind? Roosevelt? Hoover?.... > >Peter >__________________________________ >Peter Marley >Data Warehouse Devel…
RE: Checking for Orphans
You could always use NOT EXISTS instead of NOT IN which is a dam site faster. Peter __________________________________ Peter Marley Data Warehouse Developer, Acco Europe Tel: +44 (0)1296 732184 Fax: +44 (0)1296 732185 email: peter.marley@acco-uk.co.uk <mailto:peter.marley@acc…
ROWIDs ???
"Lucky Leavell [RIS]" wrote: > > Version 7.31 > OS: AIX 4.3.3 > > I am fairly new to the Informix 4GL world and notice a lot of the extant > programs use ROWID to access/update rows in tables. Is this considered a > good programming practice? (Ingres had the concept of TIDs - tu…
Re: UPDATE STATISTICS Question
Good Question and one I would love to see someone from Informix answer. It really wasn't that long ago that a 3-500 MB Database was considered large. Snicker if you will but it's true. Now we talk in Terrabytes of data. Is a small table anything less than a GIG...or one that ha…
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…
Enterprise replication
--------------61BA173DE4C37191D4A7B827 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I am trying to setup Enterprise replication on my HP-UX 11. I have a problem when i run "cdr start repl -c g_test1". The error is "connect to -g_test1 fail…
Replication blobs questions .
Hi all. We are migrating to IIF.2000 with WebDatablade. The WebDatablade store the pages in Sblobspaces. We want a High Available System, to do this we use HDR but we read at manuals and * Adminintrator's Guide for Informix Dynamic Server.2000 ver 9.2 ----Important: The databas…
Replication conflicting with constraints
For Enterprise Replication... onstat -g ddr display the snoopy/replay position onstat -g grp display information about the grouper onstat -g rqm display information about the queues onstat -g nif information about network transfer of replicated data onstat -g dss inform…
replication
Enterprise Replication offers the ability to replicate at a smaller granularity than at an instance level, but I would not recommend using ER on any version less than 7.31UC4. However, I do not understand your question fully. If you are currently using additional software to do…
informix replication
Informix has two replication strageties. The first (HDR) provides mirror image replication. Basically the source instance is replicated onto the target instance. This provides High Availability with a rather low latency. Also it is fairly easy to setup. However it does have …
Enterprise Replication
_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please not…
Re: Handing ATS/RIS files on CDR
Dhanesh K Veedu wrote: > Informix Gurus, > > May be the second time i'm sending this.... > > I just would like to know, as a DBA, what do you do with the ATS/RIS files. > Are they just informational files??... just discard it or.... Look at them. There may be errors or simple …
Handing ATS/RIS files on CDR
Informix Gurus, May be the second time i'm sending this.... I just would like to know, as a DBA, what do you do with the ATS/RIS files. Are they just informational files??... just discard it or.... Is there any specific way to implement different time zones, if the ER servers …
Handling ATS/RIS files on CDR
Hello, How do you handle the ATS/RIS files created in CDR? Do you normally apply manually or just leave it as it is. Thanks Dhanesh ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com…
Re: replication problem
G�khan: Do you have ATS and RIS enabled? If so, check on the target instance for the logs. Post the logs along with "cdr list repl <replicate name, ...>, and we can help you. Steve Romankiw ----- Original Message ----- From: G�khan Fidan To: informix-list@iiug.org Sent: Wedn…
Re: Reliability of Informix
From: "Harry Sheng" <harry@ss8networks.com> > >What is the equivalent of Oracle Standby Server in Informix IDS2000 ? >Is replication the only selection ? I don't know it, but judging by the name it sounds like HDR (High Availability Data Replication). You can also use Enterpris…
ER time synchronization
This message addressed more towards sysadmins on UNIX, but since I am stuck with DB admin and sysadmin... Running Enterprise Replication on 2 different servers: what will be good solution to synchronize time between'em? xntpd? if someone had experience - please, reply? Regards, …
BLOB replication on IDS 9.20.UC.1 - how to
Hi group, I'm using Informix Dynamic Server and I've read that enterprise data replication doesn't support BLOB replication. Is possible to turn around that problem? Thanks in advance Auri…
Distributed database question
> > Please, do tell me - what is distributed database? To simplify, one examble of a distributed database is set up by two or more databases replying each other. Please see Guide to Informix Enterprise Replication (on Answers online of course). Hope this can help you. Dennis.…
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…
Re: Replication Manager
Have you installed server agent on the Unix box? Jin. Informatica wrote: > 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 se…
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…
Enterprise Replication Problems on Linux Redhat 6.1
Well, I worked with some of the Linux Platform Engineers during the testing of 9.21, so I guess that I qualify for having run 9.21 ER on the Linux platform. The error that you are getting occurs during the commit of the DataSync transaction on the target system. (The DataSync t…
Enterprise Replication on Linux woes..
I'm having a lot of trouble getting Informix 9.21 Enterprise Replication up and running under Redhat Linux 6.1 I have setup 3 machines JEFF, MOE, LISA to replicate in UPDATE ANYWHERE mode a table called USER_OBJECTS. I'm just following instructions from the Guide to Informix En…
Enterprise Replication
Hello, We're thinking about running ER between 2 machines at each of 2 sites. We'd only update on one server at a time -- the other 3 servers are backups only. I've got some questions on ER: a) There seems to be very few postings on the subject to this group. Does …
How can I speed up the 'drop index' command?
Hi Its the first time for me posting a question to the group, so here goes. Running IDS7.31 with Enterprise Replication active, how can I export my databases without having to shutdown replication. Cheers Folks h.straker@videonetworks.com…
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: Baan and Informix Enterprise Replication
This is another wonderful feature of Baan, their tables doesn't have Primary Key and their indexes are over the hash fields. Theoretically you can create the Primary Key directly through Informix... but this is an impossible mission due to the great number of tables. ******…
Baan and Informix Enterprise Replication
Hi Is someone using or have setup Baan with Informix Enterprise Replication? We intend to setup Informix Enterprise Replication between two servers. I am told by someone that Enterprise Replication may not work with Baan because of primary key constraint. Shall be grateful on …
Need some Information about Enterprise Data Replication
Hi, I need detail information about the Enterprise Data Replication and how is it implemented in Informix. Please get back to me ASAP. Thanking you in anticipation Regards & TIA, Kumar ______________________________________________________ Get Your Private, Free Email at http…
Error in installing Enterprise Replication Manager
Hi When I am trying to install Enterprise Replication Manager on Windows98, I get the following error. Couldn't load CDRINS.DLL I have already I-Connect on my PC and it is wroking fine. Any suggestions ? Thanks in advance. Muhammad Usman Sent via Deja.com http://www.dej…
ER vs HDR
Wu <wuyf@tm.net.my> writes: > 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 ? Nope. > 3. What's the basic requirement for ER ? Look at the do…
Enterprise Replication - Questions on monitoring Replication
Hello all, We have been using ER now for around 3-4 months and have found the manuals and information supplied rather limiting. We have two sets of two Sun Solaris boxes running replication (one set as test, the second is live). We have managed to set up the servers and replic…
Enterprise Replication
My company is looking into Enterprise Replication for Informix 7.23 for a hot site backup. My first 2 questions are: Is this an appropriate vehicle for a hot site backup? Do we need the same type of server ( or another server with the same power) in order to replicate the entire…
Re: CDR Conflict Resolution
Hello Katja, My first question is why do you wish to add timestamp conflict resolution? Here is my (limited) understanding on how the conflict resolution works. Update conflicts occur when a row is updated on both ends, with timestamp conflict resolution the rows have addition …
Informix IDS 7.30 to 7.31 (Informix has replied please upgrade)
Hi all, Informix have given us the usual response upgrade to version ....... My client has just been through two upgrades in the last 2 months, so this response is wearing thin. We are currently running IDS 7.30.UC5 on our Sun sparc Ultra-enterprise and Sun sparc Ultra-5. We ar…
HDR and enterprise replication
Does anyone know the difference between HDR and enterprise replication? It seems they both exist in version 7.3, but only HDR is available in 9.14. Thanks in advance, david.tamburin@protegrity.com…
Does anyone know how to monitor ER?
Hello we have recently set up Enterprise Replication between to SUN Sparc boxes configured with IDS 7.30.UC5. We need to know how we can monitor the effectiveness of the replication and how we can monitor the send and recieve queues (i.e. No of transactions / Mb). Thanks, Step…
RE: replication
The older HDR, or High-availability Data Replication, replicates everything in one instance over to another instance (log-based replication); very robust, very simple to set up and administer, but rather restrictive; single primary to single secondary only (secondary is in read-o…
replication
Can anyone give me explanation of the difference between data replication enterprise replication.…
Re: Replication on 7.24.UC5
Bill, You will need to specify what type of replication you have in mind. 7.24.UC5 supports Enterprise Replication as well as HDR. Just an FYI - 7.31 is now available and ER sites should be quite pleased with the improvements that we have made with that level. Bill Spencer wr…
ONSTAT
HI folks, looking for help using onstat -g que I would like to know if Enterprise Replication is working I don't know the meaning of this output.. Any help will be really appreciated. Thanks Javier Puente…
ENTERPRISE REPLICATION
Hi Informixs, I need some help in enterprise replication. I had worked with it since HDR, but now I have got some problems. I have a Primary_target replication scheme using a central server and four remote destinations with a 64kbps satelital connection. Sometimes replication j…
Enterprise Replication
I'm trying to set up ER to replicate data between IDS 7.3 and IWS 7.3 on Windows 4.0 servers. When I start repman I get the error 406. Finderr says this is a memory allocation error, but I don;t believe this to be the case. Does someone have an idea what I've missed. I've sca…
Re: IDS Workgroup Edition
In article <729vhj$qv4$1@nnrp1.dejanews.com>, jshaley@my-dejanews.com wrote: >Thanks, Peter. > >I found this document early on in my search, but some of the marketing >verbage makes more sense now that I know something about the product. > >It looks like HADR is the replication f…
Re: CDR-Errors as seen in RIS-Files
In article <36229239.1EB2A4B4@uni-bonn.de>, sboehme@debis.com wrote: > Hi Community! > > I guess this question is quite stupid, but ... > > I have six instances of Informix Dynamic Server 7.30 on a Unix (Sinix) > operating system. I perform Informix Enterprise replication betwe…
Re: CDR-Errors as seen in RIS-Files
Okay, I appreciate Your comments, but ... First, I`m interested in the CDR-Errors in RIS-Files. I know how to look up SQL and ISAM-Errors. Second, these CDR-Errors in the RIS-Files are not corresponding with the CDR-Errors in $INFORMIXDIR/incl/esql/cdrerr.h. Here is a typical …
Re: CDR-Errors as seen in RIS-Files
>I have six instances of Informix Dynamic Server 7.30 on a Unix (Sinix) >operating system. I perform Informix Enterprise replication between >these instances. In the replication system, I use ATS/RIS-Errorspooling. >Each RIS-file contains at least one set of data together with a …
CDR-Errors as seen in RIS-Files
Hi Community! I guess this question is quite stupid, but ... I have six instances of Informix Dynamic Server 7.30 on a Unix (Sinix) operating system. I perform Informix Enterprise replication between these instances. In the replication system, I use ATS/RIS-Errorspooling. Each …
Compuware EcoTools and Platinum ProVision
Does anyone happen to know if Compuware's Ecotools and/or Platinum Provision monitor XPS or Enterprise Replication? I am doing some consultant work for a customer of ours. Any information would be greatly appreciated. Thanks Adam Wright ITAG…
Enterprise Replication
Has anyone out there set up Enterprise Replication in such a way that deletions on the source table are ignored on the target table? In our particular scenario we would like to replicate any inserts or updates to a particular table from the source to the target. However, we want…
Enterprise Replication
Hi there! I have been investigating Enterprise Replication and found that there appear to be two methods (not unrelated) that one can use to configure an ER environment: Use the NT admin tool or use the CDR (old name) API calls. Is there another way, such as some SPL I can't fi…
Re: ACE to 4GL
Jonathan Knight wrote: > > Has anyone come across a tool to convert an ACE report to a 4GL > automatically? I'd thought I'd ask before reinventing the wheel. > > Jon > > Jon Knight > > Rebus Insurance Systems Ltd, 120 Leman Street, London, E1 8EU > Tel: 0171 488 4080 jkni…
Enterprise Replication
Hello fellow informix users I have a really weird problem with replication. I have to replication groups defined on different servers. cdr server one comes up just fine but cdr server two shows itself in quiescent mode. The instance itself is on-line and you can access the datab…
Re: Entreprise Replication
><mike_lebrun@email.domtar.com> wrote: >> >> Hello All, >> >> I'm having problems setting up Entreprise Replication: >> >> I have my snmp daemon running, and the cdragt sub-agent. Everything works >> great for one server: I can declare one server to ER, and define a >> replicat…
Re: Entreprise Replication
In article <6frjbr$gde$1@newsbell.bellglobal.com>, "Mike Lebrun" <mike_lebrun@email.domtar.com> wrote: > > Hello All, > > I'm having problems setting up Entreprise Replication: > > I have my snmp daemon running, and the cdragt sub-agent. Everything works > great for one server…
Enterprise Replication
Hello, Does anybody have experience with Enterprise Replication for Informix 7.23 Dynamic server? We've followed installation, as far as we know, to a T... running informix's snmpd on an HPUX 10.20 machine. We've got cdragt up and running, but everytime we try to connect with …
Fw: Enterprise Data Replication
---------- }Subject:: Enterprise Data Replication } Date: Friday, October 17, 1997 1:04 PM } } I was wondering how other corporations handled the security implications } when doing enterprise data replication, which requires hosts participating } in the replication to be fully tr…
Enterprise Replication
--------------8239C8961BAD1F313A3F5DA4 Content-Type: text/plain; charset=EUC-KR Content-Transfer-Encoding: 8bit I want to know something about Enterprise Replication I am currently using Enterprise Replication Manager(Platform winnt4.0) and Informix OnLine 7.23 for Solaris 2.5.…
Re: replication
Hello Maria, > I am interested in the functional differences in CDR (Continuous Data > Replication) and ER (Enterprise Replication). Informix originally called their "new" data replication product CDR (Continuous Data Replication) during the beta release. During the beta proc…
Onbar restore to a different machine.
I am trying to figure out how to back one AIX system running ODS 7.23 using onbar and ADSM and restore this backup to another AIX system also running ODS 7.23 and then setup up the systems in a replicated fashion using Informix replication(NOT enterprise replication). Help of any…
Re: Bug/Issue Tracking Sys
Microsoft produced an 'Anomoly Tracking System' (Search fot ATS) JP wrote in article <33E06183.507B@csil.ie>... >Does anyone know of an available bug tracking system (on an Access DB >preferably). Something really simple, which updates the DB with details >of latest modificati…
REPLICATION MANAGER
Hi folks, I am trying Enterprise Replication, I have installed the Replication Manager software in a NT-Workstation. When i start Replication Manager i define the sqlhosts as c:\\informix\\repman\\repman.txt, where repman.txt is sqlhosts (file from unix server). According to ER …
ENTERPRISE REPLICATION
Hi folks, Trying to configure the informix Enterprise Replication, I do have a problem. According to Informix documentation (Informix SNMP Subagent Guide) is required a master daemon of SNMP in the machine of the database server. I have a SUN Sparc 5 with Solaris 2.5 and my SUN …
Re: Parallel Database Solutions
Hi Jeff, Jeff Rochlin wrote: > Is anyone aware of a solution for Informix that will allow two servers > to access the same instance of a database at the same time ? No. This will not be possible anytime in the near future, sorry. > How about a database replication scheme that …
Enterprise Replication
Anyone out there using Informixs Enterprise replication? I am looking at using the tool to update other databases (some non-Informix) on a scheduled basis. I would be interested in your comments, information etc.. ----------------------------------------------------- Maria L. W…
Re: Semaphores on scounix
Randy Harbison wrote: > > We are having an ongoing problem with our ATS machine locking up. > Each time this occurs, it appears that the semaphores appear as > shown below. I would like to either eliminate or charge this area > as being associated with the problem. All response…
Re: INGRES --> CA-Ingres - and now ?
On Sat, 2 Mar 1996, Udo wrote: > what's your experience 1 1/2 year after the takeover ? > > nice to hear anything. > 1. Tech support has been a vast improvement. We used to have only upgrades + Advisor as we are a small shop and simply could not afford premium support. Now, w…
Re: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)
>Actually, Oracle allows 2 phased commit and asynchronos replication. It >depends upon what you want to do. Having a choice is a good thing. Sometimes >one wants to require enterprise wide consistency (2 phase commit) and other >times asynchronos replication will be most appro…
Re: Which Unix DBMS?
On Thu, 29 Jun 1995, Bass Chorng wrote: > Larry Miller (lmiller@netcom.com) wrote: > : Hi, folks-- > > : A friend here needs to justify his choice of database systems running > : under Unix. Anybody know of a FAQ or other sources on features, pros, and > : cons of the different…
I_OnLine 5.00 & 5.01
I've got a big problem with OnLine engine versions 5.01UD2 & 5.02UD2 (database with no log). After several hours,while 30-40 users access database it stops with message: Cannot open or create a temporary file (-229) Deadlock detected - possible deadlock This error should appear…
ANSI & Intergraph RIS continued...
RIS (Relational Interface System) >code change. In order to acheive this level of functionality, >Intergraph needed to come up with some level of consistency >among the various database vendors that would allow this scheme >to work. ANSI-mode was the solution. This mode ensur…
ANSI & Intergraph RIS
In response to Hugh Grierson's question as to why Intergraph requires ANSI-mode databases for their RIS product. RIS is the solution that Intergraph developed that would allow them to write their CAD application's database interface to be common among all of the supported underl…
Re: Non-ANSI Informix databases and Intergraph
->From: hugh@nezsdc.icl.co.nz (Hugh Grierson) ->Subject: Non-ANSI Informix databases and Intergraph ->Date: Wed, 1 Jun 94 02:43:40 GMT ->Organization: Fujitsu New Zealand, Local Government Group -> ->ANSI-mode Informix databases. Interesting things. There's no BEGIN ->WORK stat…
Non-ANSI Informix databases and Intergraph
ANSI-mode Informix databases. Interesting things. There's no BEGIN WORK statement, and you must always specify the table owner as a part of its name. So given a million or so lines of code developed under Standard Engine and now running happily on both SE and non-ANSI Online s…
Re: database independence
In article nj0@emory.mathcs.emory.edu, brrankin@auckland.aussy.ingr.com (brent) writes: >Hi > >Just to add something to the conversation, > >beware of the various informix modes (buffered, ansi etc) >We have a case over here in New Zealand where a customer has an informix >ansi d…
Re: database independence
Hi Just to add something to the conversation, beware of the various informix modes (buffered, ansi etc) We have a case over here in New Zealand where a customer has an informix ansi database with our application (RIS) talking to it. The customer also has another informix datab…