Oninit® Archive
Results for “CDR_SERIAL”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
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 …
ESQL/C 15 and sqlca.sqlerrd[1] for new BIGSERIAL
Thank you Art for creating INFX-I-655! Obviously, saving another round-trip with the server to execute an additional SELECT DBINFO('bigserial') would be great! For those which do not use SERIAL/BIGSERIAL columns: Getting the new generated number after INSERT is a must for applica…
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…
dbexport failure
Note I say, "resolved", not "solved". I just don't have time to work all the details. This was a side-bar to the process of getting myexport to work properly in our system, which, itself, was a sidebar to another task. I feel like I have encountered stack overflow! Anyway, the…
IDS 12.10 on Ubuntu 14.04 LTS Server
Hi, The logfile after install, see below. Thanks. Guy 19:28:20 Parameter's user-configured value was adjusted. (DS_MAX_SCANS) 19:28:20 Parameter's user-configured value was adjusted. (ONLIDX_MAXMEM) 19:28:20 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY) 19:…
getting the serial value
Hi If using Embedded SQL/C, he should check sqlca.sqlerrd[1] to know the last inserted serial value. http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.es qlc.doc/esqlc214.htm | sqlerrd | array of 6 int4s | [0] | After a successful PREPARE statementfo…
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…
Infomix serial data type incremenst by ten?
Look in your ONCONFIG file for the parameter CDR_SERIAL and unset it. This is used to adjust serial, serial8, and bigserial types to skip numbers on Enterprise Replication (ER) servers so that each server generates an independent set of serial values. You will probably see that i…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
SERIAL behavior CDR_SERIAL
OS : AIX Version : Informix 11.7 xC5 Environment : Flexible Grib Rule of replication : Apply all for all server. My client is intended to move their existing DB from XXXX to Informix 11.7(Flexible Grib) environment. There uses lots of auto numbering as their primary key (simila…
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…
ER & HDR and CDR_SERIAL reset.
11.50 FC8 AIX 6.1 A & B servers are exisiting update anywhere servers between themselves. CDR_SERIAL on A is 2,2, CDR_SERIAL on B is 2,1 C was recently added as a HDR updatable secondary to A. ( C will eventually become the new A once all applications are migrated over.) The H…
dbimport logging how to stop
thanks for that info Fernando We use enterprise replication here, Would logging of smart blobs be needed for that ?…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
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…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
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…
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 ?…
CDR Serial question
To guarantee uniqueness across all servers, CDR_SERIAL onconfig parameter must be configured at all ER servers. Please check documentation for details on CDR_SERIAL onconfig parameter. http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp The other approach is to use s…
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…
Error -19816: Cannot perform this operation on a
The error message/code has nothing to do with your HDR replication which permits dropping a table. Either the table in question is defined as a replicated table using Enterprise Replication or there is an active Change Data Capture (CDC) session open that is using the CDC API to …
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?…
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…
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…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
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…
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 …
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
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…
Informix data types
Just wondering if there is a way to reinitialize a column of serial data type. Let's say we have a table with and id column of serial data type. If the current value of thie column is 300, is there a way to make it restart from 1? If not, I know we can create a sequence to simula…
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: Long checkpoints
On Sep 10, 4:47 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > askel wrote: > > Hello there, > > > I've been reading about long checkpoints issue for a while but haven't > > found solution for our case. > > > We're using IDS 9.40.FC6 on Solaris 9 for OLTP. It is Sun Fir…
Long checkpoints
askel wrote: > Hello there, > > I've been reading about long checkpoints issue for a while but haven't > found solution for our case. > > We're using IDS 9.40.FC6 on Solaris 9 for OLTP. It is Sun Fire V1280 > with 8 UltraSPARC-III+ 1.2 GHz and 16 Gb of RAM on board. The database …
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…
CDR_SERIAL Question
Platform: IDS 10 FC5 on Solaris 10 Server 'A' replicating with Server 'B' in ER "update anywhwere" configuration. Server A CDR_SERIAL = 2,1 Server B CDR_SERIAL = 3,2 Server A is used as the primary database server and server B is a failover site. The problem is that server A …
Methods for moving serial-keyed data from one serv
Jarrod Teale wrote: As Jarrod points out, if the target database is empty, no problems with the copy at all. If there are existing rows in the target tables which may clash on the serial column with the rows being copied, then you'll have to write a custom copy/import tool to ac…
Re: cdr_serial issue
Thanks. I got this working and I understand now why they did it this way. You don't want every table to automatically burn serials just because you have the CDR_SERIAL id turned on. I wish you could specify serial id parameters like you can specify sequences. I can't be the only…
Re: cdr_serial issue
>From: bozon <curtis@crowson1.com> If you didn't have to worry about synch'ing between servers, you would have a simple sequence number and you can just use that... Why not have a numeric string that represents the server id. (lets say 4 digits.) Then you have a sequence number…
cdr_serial issue
I made a mistake about cdr_serial I assumed that it would work regardless of whether ER was on or not. This doesn't seem to be the case. I need to spread out my serial IDs like CDR_SERIAL does. Is there a way to get the functionality of CDR_SERIAL without actually replicating? …
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…
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: Duplicate serial in Informix 7.2.3
The schema is something like this: create table myTableA ( fieldA smallint not null , fieldB serial not null , ... fieldN smallint not null, unique (fieldB) ); alter table myTableA add constraint (foreign key (fieldB) references myTableB ); So I hav…
Re: Duplicate serial in Informix 7.2.3
>From: "Keith Simmons" <smiley73@googlemail.com> [SNIP]> > I'll admit I've never set up a serial column outside of dbaccess, so I've > > always had a backing index. > > (What can I say, I'm lazy... ;-) > > > > However... > > [SNIP] > >However, it you then do a manual insert of 5 …
Re: Duplicate serial in Informix 7.2.3
On 26/07/07, Ian Michael Gumby <im_gumby@hotmail.com> wrote: > > > > >From: "mark.scranton@gmail.com" <mark.scranton@gmail.com> > > > >Uh guys....yes, Roy HAS nailed it. For G to reinforce that it will > >"*NEVER* ... (no duh!)" happen is absolutely untrue. Serial datatypes > >ha…
Duplicate serial in Informix 7.2.3
>From: "Art S. Kagel" <art.kagel@gmail.com> >On Jul 25, 2:18 pm, pedro <pedro.e.sa...@gmail.com> wrote: > > Hi, > > > > I've developed an webservice application which accesses an informix > > database. > > When the service is invoked, the application executes some business > > lo…
Optimizer Question
Yoo could lose light scans by making buffers too big. j. >From: Mary Gregory <mary.gregory@rheem.com> >Date: 2007/06/06 Wed AM 09:07:04 CDT >To: ids@iiug.org >Subject: Optimizer Question [9297] >Could the addition of memory to IDS (BUFFERS, SHMVIRTSIZE) cause the >optimizer to…
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…
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: temp tables and serial columns
Jonathan Leffler schrieb: > Bill Hamilton wrote: >> But that does not answer the question: "Is there a practical use for a >> serial column in a temp table?" >> Perhaps there are times when you don't want to use a sequence >> generator and the serial could be useful? > > For a lo…
RE: temp tables and serial columns
Good.I have no problem with specifying all columns most of the time.BTW, "select x from foo order by 1 into temp t" works for me on 9.4 .Also, BTW, your methodology of specifying all columns in the temp is cool until the dba adds a column to the main table that is not nullable. T…
RE: temp tables and serial columns
Art said:> I reprimand ANYONE here who writes SELECT * or INSERT INTO tablename VALUES > ... (ie without a column list). Such queries are doomed to blow up when the > schema has to be changed to add or drop a column ...> Point taken. I do list all columns in production code.It m…
RE: temp tables and serial columns
That would be nice.Or just allow something like:"select * from foo into temp t serialasint;"A serial should be integer in the temp.A serial8 should be int8.If the table does not have a serial or you did not select it, then the serialasint gets ignored.> Subject: RE: temp tables a…
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…
Serial Column Informix 10.x
This may help. Frank IBM Informix JDBC Driver provides support for the Informix SERIAL and SERIAL8 data types through the methods *getSerial()* and *getSerial8()*, which are part of the implementation of the *java.sql.Statement* interface. Because the SERIAL and SERIAL8 data t…
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…
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 …
Autogenerated keys
What type of 'auto generated key'? Is this a serial column, serial 8 column, or an integer inserted using a sequence? Please provide specifics. If a serial or serial8 are you inserting specific values or a '0' permitting a server assigned value? Art S. Kagel ----- Original Mess…
Re: select * from (select * from bob) and other easy stuff
On Tue, 2006-09-26 at 11:55 -0700, internetuser wrote: > Adam Tauno Williams wrote: > > I don't know, this always made perfect sense to me. A "serial" data > > type's serial-ness can't be preserved through a virtual table. > But while a "serial" may be something interesting bef…
Re: How to retrieve the generated serial id from a batch of inserts
Gabriel Belingueres wrote: > Hi, > >>From Java (using JDBC) I can execute an INSERT statement on a table > which its PK is of a SERIAL datatype, and to retrieve the just > generated pk, I execute the following select: > > select dbinfo('sqlca.sqlerrd1') from systables where tabid…
Performance issue after 732 to 94fc6 upgrade
Hi, Try setting OPTCOMPIND to 2 in case your queries are optimized for 7.3x. MAX_PDQPRIO should be 100 in case you want to use PDQ when your machine is executing only one heavy task. Also DS_TOTAL_MEMORY should not be limited in this case (empty param). Maybe this helps. Marcu…
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…
Enterprise Replication Conflict Notification
My company is in the process of implementing a 7 instance, update-anywhere ER topology using timestamp conflict resolution. We have decided that we want/need to know when and if a conflict occurs. I asked an IBM resource if IDS offered an alert of some mechanism for trapping the…
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…
RE: ER and row_id
Thank you Andreas. This is the information I was looking for. Mike > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org] On Behalf Of Andreas Legner > Sent: Tuesday, September 20, 2005 3:27 PM > To: informix-list@iiug.org > S…
ER and row_id
That is exactly what CDR_SERIAL is meant for :-) Mike Badar wrote: > Greetings, > > Is it possible to maintain unique row_id's across 3 nodes using ER? One > idea I have is to use a SERIAL column registered as USER maintained for > their ROW_ID; the idea would be to use the CD…
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…
SERIAL8 on a Fragmented Table
CDR_SERIAL will kick in for non-ER sites as well. Basically it makes the serial and serial-8 column function more like a sequence generator. M.P. "Chris S" <cjsommer@gmail.com> wrote in message news:1123011840.207629.302780@g44g2000cwa.googlegroups.com... > No, I checked the O…
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: …
Trigger to enforce uniqueness across databases
Another resolution to this sort of situation that I have used is to have a composite primary key, col1 char(5) default "siteX"/"siteY", col2 serial any subsequent jkoin columns require a 2 column join. Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<W3Fgd.6421$…
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…
Re: IDS9.4/AIX5.2 performace degradation
I have an IBM Redbook pdf with advices for tunning AIX 5L parameters for improving performance on DB2 , IDS and Oracle . I cand send it directly to your email if you want. (3.4 Megabytes). Regards ----- Original Message ----- From: "Art S. Kagel" <kagel@bloomberg.net> To: <in…
Re: IDS9.4/AIX5.2 performace degradation
Dalibor, A piece of tuning advice that has many times hit this list, is that you should have one CLEANER per LRU. So, having LRUS = 8 implies that you should have CLEANERS=8 also, to keep up with the overhead. Ben Thompson wrote: > Dalibor Krleza wrote: > > I may have missed i…
Re: IDS9.4/AIX5.2 performace degradation
Dalibor Krleza wrote: I may have missed it in your long post, but I didn't see anything about disc layouts or number of CPUs. Also I may have missed it as well but I couldn't see any output from "onstat -g iof" or "onstat -g iov". I have commented on your onconfig anyway. > OK …
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…
Re: Insert a return a Serial Column Value
Dan, If you create a SERIAL column in your table, and then insert 0 into that column, this will generate a serial number. You can then use db_info() to find out the value that was inserted by an insert statement. I added a serial column to your table, modified your insert state…
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
Hello, I'm replicating the table1 on Serv1 to another table2 on Serv2 with ER. No Problem. But, If I add a trigger on the target table2 to copy this one on another table3 under the same database with the following CREATE TRIGGER test_er INSERT ON dwmd_bran_53 REFERENCING NEW a…
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: Informix Performance
Middle of the night... Maybe batch jobs are running which are retaining locks for a long time and the users are running into those locks? "Daniel Castro" <daniel.castro@feliciorocho.org.br> wrote in message news:f86fe5d3.0402261055.34916f88@posting.google.com... > Hi, > > I am …
RE: Informix Performance
> -----Original Message----- > From: daniel.castro@feliciorocho.org.br > [SMTP:daniel.castro@feliciorocho.org.br] > Sent: Thursday, February 26, 2004 1:55 PM > To: informix-list@iiug.org > Subject: Informix Performance > > Hi, > > I am having informix performance problems. I don�…
Informix Performance
Application? OS? Hardware, esp amount of physical memory? Profile of usage of application: eg times of heavy online use; times of batch job runs etc? Output of onstat -g iov also please. "Daniel Castro" <daniel.castro@feliciorocho.org.br> wrote in message news:f86fe5d3.04022610…
SERIAL data type...
Hi, All! How I can to reduce current value of SERIAL column generator? I can to increase current value of SERIAL only...:( -- Sauron…
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…
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.…
Serial field value range?
Jonathan Leffler wrote: > rkusenet wrote: >> "William Fields" <Bill_Fields@azb.uscourts.gov> wrote: >>>In Visual FoxPro, our Integer field datatype can range >>> from -2147483647 to >>>2147483647 >>> >>>What is the range for the Informix Serial field datatype? >>> Also, has it >>…
Re: Sequences
Take a look at IDS 9.40. Its got sequences. Sequences are a generic sort of thing (sequences of numbers. You can have as many as you like.) we copied from Oracle. More dynamic than the generated columns of DB2. Dick Snoke Consulting IT Specialist (certified) IBM Data Management …
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…
Serial ID in replication
We are using Informix Version 9.20 in a two-way replicated environment. We are having some trouble with unique serial identifiers. Since you cannot use serial columns in replication for unique primary keys we set up a separate system for generating serial keys that are machine/da…
RE: Serial Column (workaround found)
Yes, SERIAL can be use (as an input field) in a lookup form (i assume that you meant a form generated using the ISQL;Form;Generate function). However, my intention is to allow the user to key in a value in the SERIAL feild (during INPUT) so that they can UPDATE the record. Inste…
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.…
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…
Re: MS ACCSS wierd problem..
From: "Sinha, Niraj" <niraj.sinha@BondBook.com> > >I am having problem in updating one of our tables through MSACCSS. >Let us say that the table name is ACCOUNT and the schema is : > >accountnum serial not null, >firmnum integer not null, >accountname char(10) not null, >. >. >. …
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…
Enterprise Rep on NT
sean.kelsey@2020log.com wrote: > We have 2 NT servers 4.0 SP6 running Enterprise Replication on IDS > 7.31.TC6. For simplicity sake, we have one table that is causing a > little trouble. Lets call this the 'transaction' table. > > The transaction table has the following columns:…
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: 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…
SERIAL wrap-around
See for yourself! create table junk ( junk1 serial ); insert into junk values (3); insert into junk values (2147483647); insert into junk values (0); insert into junk values (0); insert into junk values (0); select * from junk; drop table junk; Note : A serial colum…
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…
Number Generation
MA wrote: > Hi All: > > I'm generating a number using an **algorithm**. I want > to make sure after generating every number, it should > not be a previously generated number. > > If I generate a number and look it up in the database > and come to know that it's already generated…
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…
Re: Question2: Informix 4GL Programming
> > I'm still playing with this but, what's the implication for an > insert into a table with a serial column, when the 4GL program examines the SQLCA > record to get the serial number generated by the insert will it get the > right one? What about writing the inserting function…
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 …
Re: rowid and trigger
Use a SERIAL type column instead. ROWIDs are an internal value and will not be maintained across any unloar/reload or reorganization of the table 1 so you will be in trouble in the future. Just add a SERIAL column to table 1, insert zero (0) into the serial column in table 1, a…
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…
Re: Err 239 on Insert to serial column
Stuart, we got this error once in our NT development database. (It has never happened in production (Solaris). I don't know if the platform has anything to do with it or not.) Our code always inserts the serial with 0, yet one day it hiccuped on us. Checked the database to se…
RE: Err 239 on Insert to serial column
Hi Can I comment on the last message When forcing a value into a serial column say 100, the new value when using 0 will always be 101. e.g. starting on a new table called tableX SQL VALUES ON DATABASE…
Err 239 on Insert to serial column
In article <7u31ml$r4c$1@news4.svr.pol.co.uk>, Stuart Worrall <Stuart@sw orrall.freeserve.co.uk> writes >Hello, > >I have recently been presented with a problem whereby the error 239 is >generated from dbaccess when trying to insert a row. ie INSERT INTO XXXXX >VALUES (0,"DDF",1,…
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: Primary Key...Is One Required?
Bonnie >Is it necessary to have a primary key for a table? Not really, but if you are implementing referential integrity from another table, then you do. In this case, it is better to create a named unique index since that is easier to manage. >According to Informix Documentati…
Re: Primary Key...Is One Required?
Bonnie, On Wed, 2 Jun 1999, Bonnie Annelin wrote: > I have a question regarding primary keys for tables. Is it necessary to > have a primary key for a table? No. > According to Informix Documentation, > if a primary key does not exist for a table, a primary key is composed > …
Re: Primary Key...Is One Required?
Bonnie Annelin wrote: > > I have a question regarding primary keys for tables. Is it necessary to > have a primary key for a table? According to Informix Documentation, > if a primary key does not exist for a table, a primary key is composed > of all columns taken together. …
Primary Key...Is One Required?
I have a question regarding primary keys for tables. Is it necessary to have a primary key for a table? According to Informix Documentation, if a primary key does not exist for a table, a primary key is composed of all columns taken together. Does this mean that Informix aut…
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…
Re: Stored procedure problem
This is really my point of view. I wanted just to point out the difference between dbinfo() and the sysmaster query. Thank You, Octav On Wed, Feb 10, 1999 at 02:28:53PM -0500, Art S. Kagel wrote: > Octav Chiriac wrote: > > > I'm just not sure how accurate is this sysmaster > > …
Re: Stored procedure problem
Octav Chiriac wrote: > I'm just not sure how accurate is this sysmaster > query in a multiuser environment. > Does it return MY last generated serial value ? No. The sysmaster query returns the current next serial number NOT the number you just inserted. To get that value you…
Re: Stored procedure problem
You can use the dbinfo('sqlca.sqlerrd1') function to retrieve the last generated serial value after an INSERT. Hope this help, Octav On Wed, Feb 10, 1999 at 03:07:19PM +0800, Organo, Norman wrote: > Hi Informix-list, > > How do you get the newest/highest value of a serial colum…
Re: how to speed up SE and DS
> Talking about Informix SE, (I think it's the same for OnLine), I know that > many indexes slow every INSERTs, UPDATEs and DELETEs (as the indexes have to > be modified too). > The rowsize has a little effect too and any CONSTRAINTs on columns may > generate extra-controls on th…
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…
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…
Re: Informix JDBC Question
===================== Pavel Kazakov On Fri, 10 Jul 1998, Pavel Kazakov wrote: > > > Vic Siddiqi wrote: > > > Hi all, > > > > I am writing a simple JDBC based application talking with Informix > > database. I have written informix esql based applications in the past > > where I …
Re: Informix JDBC Question
Vic Siddiqi wrote: > Hi all, > > I am writing a simple JDBC based application talking with Informix > database. I have written informix esql based applications in the past > where I can get the value of a serial field that was generated by > Informix > when I did an insert into …
Informix JDBC Question
Hi all, I am writing a simple JDBC based application talking with Informix database. I have written informix esql based applications in the past where I can get the value of a serial field that was generated by Informix when I did an insert into a column (declared of type seria)…
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: Indexing problem
> I have a table in Informix Online Dynamic Server 7.2 with 6 columns and > 10,000 rows. I created a composite unique index on two columns ( one is > serial with not null and the other integer with not null) and dupls index > on integer column. In a select query Iam comparing se…
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…
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 …
Re: Serial
In article <01bd327d$5a33ffe0$84f7f5c8@compaq-4126>, "�rico Ver�ssimo da Silva" <erico@nvc.com.br> wrote: > > Does anybody know how to initialize a serial column? Without dropping the > table, I mean... The problem is that I need to delete all rows in a given > table but my pri…
Re: INFORMIX & DATA TYPE SERIAL: Questions
Art S. Kagel wrote: > > sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > > > Hi all, > > Some questions on how Informix handles the "Serial(n)" data type. > > > 1. How is the "next serial number" calculated ? why do I sometimes see different > > behaviour(s), fo…
Re: INFORMIX & DATA TYPE SERIAL: Questions
sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > Hi all, > Some questions on how Informix handles the "Serial(n)" data type. > 1. How is the "next serial number" calculated ? why do I sometimes see different > behaviour(s), for eg, if we have 5 rows, numbered …
Re: Q: Old version of INFOMIX, buggy-auto increment?
On Sun, 16 Nov 1997, Michael Segel wrote: > Brian Middlebro' wrote: > > > > Did old versions of INformix have a bug that would skip > > serialized values, that the database auto-increments? > > Well, its not really a bug. Its a feature. > > If you try entering a row with a non-ze…
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: How to get next serial value
Sally Woolrich <sally.woolrich@exxcelsis.co.uk> wrote: :In article <340a6716.1325636@gate.idg.no>, Nils Myklebust :<Nils.Myklebust@idg.no> writes ...snip... :>2. You can use the mechanism in 1. to implement a sequence generator :>using a table that contains nothing but one colum…
Re: SERIAL Columns
>From: Diane Taylor <dtaylor@octa.net> >Date: Thu, 28 Aug 1997 08:46:00 -0700 >X-Informix-List-Id: <list.16237> > >There is a thread running regarding serial numbers. > >I believe there is a misconception that serial numbers assume >uniqueness. Where this is logical, I do not be…
Re: Changing serial value
Here's how I see serial columns: They're essentially not null integer columns with an added functionality so that if you insert a zero value the actual value will be one more than the highest value previously inserted. A table can have only one serial column. Also, once a value …
Re: Changing serial value
----- Begin Included Message ----- If you want to be able to control the value inserted, you need to use a different data type. If you are just trying to clone a record, exclude the "serial" column from the insert. You cannot specify the value of a serial column. -d At 10:14…
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: Getting Serial Value
Tauren Mills wrote: > Am I missing something? Is there a way to return the value that the > SERIAL column gets set to? Or is there a way to at least return the > ROWID of the newly inserted column? I'm using an "INSERT INTO > customers" statement to insert a new row will all …
Re: VB app and Serialized Column - Help?
Carl, Find the last SERIAL generated in SQLCA.SQLERRD[2]. Alan alan.cowan@autodesk.com ______________________________ Reply Separator _________________________________ Subject: VB app and Serialized Column - Help? Author: "Carl Fulton" <carl_fulton@mail.amsinc.com> at INTERNET …
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 …
Visual Cafe w/Informix
1) Does anyone have a piece of Visual Cafe code that has a select statement with a where clause and the use of a screen input field as the host variable (e.g., SELECT ssn from employee WHERE lastname = ?)? 2) Does anyone have some Visual Cafe code that inserts into a table with …
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: SERIAL: how to SELECT generated number?
Andreas Schubert wrote: > > Is there a way to get by SELECT statement the content of SQLERRD[2] -- the > generated serial number after INSERT? (not in ESQL environment, must be > single SQL query). I'm not sure why you don't just reference SQLCA.SQLERRD[2]. Otherwise, you can fe…
Re: Free format text searches ?
"Steven Wort" <SWort@globalnet.co.uk> wrote: >Can anyone tell me how to do free format text searches across multiple >columns and tables. > >What I am looking for is the ability to automatically generate a keyword >index on textual data as it is entered to the DB, so that subsequ…
Re: Stored procedure problems
See my comment in your code: Roger Hernandez wrote: } } I am trying to create stored procedure which will insert a row into a } table which has a serial column, and will return me the generated values } by using DBINFO. Any ideas why its not working (its returing a huge } negat…
Stored procedure problems
I am trying to create stored procedure which will insert a row into a table which has a serial column, and will return me the generated values by using DBINFO. Any ideas why its not working (its returing a huge negative number)?: CREATE PROCEDURE sp_prov_srvc (p_sub_id INT, p_s…
Re: Unique identifiers
In reply to Christian Hoj's email about Unique identifiers, on 5 Oct 96 Hi Christian, > Hi there! > > Does Informix have a built-in function to generate unique ID-numbers? I > need to be sure that I get a different number each time I call the > function, because the values are…
Re: Unique identifiers
Use a SERIAL datatype in the database. The stores database does this when adding customers, orders. > Hi there! > > Does Informix have a built-in function to generate unique ID-numbers? I > need to be sure that I get a different number each time I call the > function, because t…
Re: Unique identifiers
> Does Informix have a built-in function to generate unique ID-numbers? I > need to be sure that I get a different number each time I call the > function, because the values are to be entered into a column with an > unique index. Informix has a built-in datatype called SERIAL th…
RE: Unique identifiers
> Christian Hoj asked: > Does Informix have a built-in function to generate unique ID-numbers? I > need to be sure that I get a different number each time I call the > function, because the values are to be entered into a column with an > unique index. Try using the datatype SER…
Re: Unique identifiers
Christian Hoj <christian_hoj@saxotech.dk> wrote: :Hi there! :Does Informix have a built-in function to generate unique ID-numbers? I :need to be sure that I get a different number each time I call the :function, because the values are to be entered into a column with an :unique…
Re: Serial Datatypes
Vikram wrote: > > To all : > > I am trying to insert rows into three tables A, B & C in one > transaction. > > Table A contains a serial field. (Say the last row inserted has a value > 100 in this field) > > Now if for some reason a transaction is rolled back, the serial field > …
The Secret of Serial Fields
Malcolm Weallans wrote: > > I'd always assumed that INFORMIX added 1 to the MAX value of an index and > pre-set this value when the table was generated. Reading the manuals > does not give any help on this. Perhaps somebody from INFORMIX should > tell us how it's done. > ******…
Re: duplicating a record in SPL
You'd like to do: INSERT INTO Table1 SELECT 0, Col2, Col3 FROM Table WHERE Col1 = value; You can't refer to the target table of the INSERT in the SELECT statement, so life gets harder... SELECT * FROM Table WHERE Col1 = value INTO TEMP T1; INSERT INTO Table SELECT 0, Col2, Col…
Re: Reading a Column After Insert
Rajendra Singh wrote: > > In ESQL/C, how do you read a column from a row that was just inserted? > In particular, I am interested in reading the contents of a serial > column after I have done an insert. > > Thanks! > --- > Rajendra Singh, B. Sc. (Rajendra_Singh@msn.com) > "What …
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: Accessing Informix through ODBC
} } I am inserting rows into an Informix table which has a serial } } column from a client program which is accessing the Informix DB } } thru a ODBC driver (Q+E). After the insert operation, how do I } } get the serial number that was generated without giving an SQL } } to get t…
Powerbuilder and serial values
(Gee, I hope this only gets sent out once!) I have a customer using PowerBuilder (3.0B) to maintain an Informix table. The table has a serial column as its primary key. The question is, when new rows are inserted, by PowerBuilder, what is the best way to populate the data w…
Re: NewEra, Supertables, and SERIAL
Gregory Lynn Wood (lynnwood@crash.cts.com) wrote: : I have a table that contains a serial for its primary key. : When I set up a supertable in newera and go to insert a : new row, it leaves this column blank. If I try to apply the : row, it does not add that row, but it also does…
Re: how to create an index on serial column
> jaswant@highland.eng.octel.com (Jaswant Bhardwaj) writes: > > Hi > i'm new to informix, so please forgive if it is > a very trival question (i'm sure it is). > > > i have serial number column and i want to create an index > on it since performance is slow. i ca…
Re: Reset values in serial datatype
> Subject: Reset values in serial datatype > Date: 23 Feb 1995 05:51:06 GMT > Reply-To: dbaresrc@xmission.xmission.com (DBA Resources) > Organization: XMission Public Access Internet (801 539 0900) > > I thought I had read in here a discussion about resetting the starting > value…
Re: DATA TYPES
> > Which data type is most suitable for serial numbers that you expect to > hit 100,000 and more in the course of at least 2 years. Integer is > definately out for a column data type since it will max out and roll > over at about 37600 something. You will get some interesting qu…
Help: Overrideable serial numbers in forms?
I'm modifying an Informix form, for Informix 2.1(?) running on an Interactive Unix 386 box. I know it's a very old version, but that can't be helped right now. The problem is that when entering a new row, I want a field with a serial number, which has a new automatically genera…
Re: How do we get serial field starting values for a table using dbschema.
Succinctly, No. The starting value for a SERIAL column is not preserved anywhere. Once any data has been inserted, there is no way for any of the software to tell what value was set. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: shyam@robadome.co…
serial columns (was <No Subject Supplied>)
Asserts the usually-reliable Dave Snyder: > The only way I can think of getting a serial filed to > start over is to enter 2,147,483,647 records or drop/recreate > the table. Similarly quoth Dan Guillory, > If memory serves me correct, you have to drop the table and recreate i…
4.10.U2 SE was Re: <No Subject Supplied>
Note: Mark, please use a subject when you post. It makes it difficult to track particular issues w/o an applicable subject. Dave Snyder writes: |> Mark Heringslake writes: |> } Hello Fellow Netters..... |> } |> } I am running 4.10U2 version of Informix SE... |> } |> Good, …
Thanx for help with serial insert in ESQL/C
hi, Here is the solution to the problem that I posted. Thanx to all who responded to my post. Here is the solution and once again thanx to every one who responded. I appreciate your help. Solution: ---------------------------------------------------------------------- Check ou…
Re: Reversal of Records
Jeffrey F. Lawhorn writes: > > > [ text deleted ] > > The reason for this is the reason that SERIAL exists - it provides > > an automatically generated primary key. The only implied > > requirements are that a type SERIAL be UNIQUE and NOT NULL. > > In addition, a quick review o…
Re: Reversal of Records
>> > [ text deleted ] >> > The reason for this is the reason that SERIAL exists - it provides >> > an automatically generated primary key. The only implied >> > requirements are that a type SERIAL be UNIQUE and NOT NULL. >> > In addition, a quick review of several Informix 4.0 m…
Re: Reversal of Records (fwd)
> > OK people, my turn. Nobody has yet mentioned VIEWS. Why can't you set > up a view of the form > > CREATE VIEW viewtab AS > SELECT * FROM tab > ORDER BY serial > > You can then use this view in Perform for both inserting and retrieving, > and of course it will also wo…