Oninit® Archive
Results for “SEC_DR_BUFS”
HDR : Primary et secondary OS Comptability ?
Hello, I red here (http://www.informix-dba.com/2010/08/informix-hdr-will-save-your-butt.html) that for HDR, primary and secondary servers can be on différents Opérating Systems, is there a compatibility matrix ? For my case i have a primary on AIX ans maybe a future one on Linux…
Technological Differences between HDR & RSS
We want to use HDR, as we can then switch HDR to Primary. Is there any technological difference between HDR & RSS, that might impact Transaction Processing on Primary Instance. Thanks.…
version 11 in plae upgrade and HDR
Tom Lehr wrote: > Hello All > This is a RTFM manual question, I know, but I am going to put this > out there anyway, especially since I think all of our upgrades in the > past have been new hardware migrations and I want to be sure as there > was some doubt in house . > > In the…
No Trust/No HDR?
Is it necessary to use either a hosts.equiv or .rhosts file to maintain a "trust" between two hosts which are members of an HDR pair? Is there any _secure_ method to establish and maintain the trust which the informixserver recognizes aside from using a dated technique that has …
Informix: oncheck -pr in Fast Recovery mode
Not seeing this behavior with my secondaries nor in the code. The error is expected if neither in quiescent nor in online mode nor in recovery mode on a secondary, so it should work in your scenario. Can we learn server (and oncheck) version? ------------------------------ …
DRDA redirection to HDR primary
Hi Gerd. Thanks, but the purpose of this thread is to get automated HDR fail-over redirection working without Connection Manager. ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Drop table with no-logging mode
Hello Nasiha, you are aware that no-logging tables are not transferred to the secondary server, so HDR does not work for no-logging tables? Regards the hanging HDR server you should open a case. Regards, Henri ------------------------------ Henri Cujass leolo IT, CTO Germany IBM …
Replication of Informix
Gerd I don't believe that matters. If you wanted to keep your HDR traffic separate from your user traffic, an option would be to create the HDR connection with an INFORMIXSERVER setting defined as part of DBSERVERALIASES and operating through a different port. Koonjul, Is port 16…
Simple Large Object Replication
Juan: TEXT and BYTE data types do replicate but only if the column is defined IN TABLE not in a blobspace. So, all you have to do is to move the TEXT column(s) from the blobspace to tablespace and poof, they will replicate! ------------------------------ Art S. Kagel, President a…
HDR
Hello all, I'm doing the HDR setup on my personal laptop with IDS 11.50(OLD ONE) for learning purpose. I created two server on VMWARE and did FIREWALL off and both server can ping to each other. I'm facing problem when I go to create 2ndary Server. I've attached the doc for the s…
Promoting RSS nodes
1. Promote ifxdb03 to HDR secondary. onmode -d secondary ifxdb01 2) Promote ifxdb03 from HDR secondary to primary onmode -d make primary ifxdb03 3) Promote ifxdb04 from RSS to HDR secondary onmode -d secondary ifxdb03 ------------------------------ Nagaraju Inturi --------------…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Take Primary and RSS down and up, w/o reinitialize
You can take the servers down and back up in any order you need to UNLESS you have DRAUTO is set to 2. In that case you have to take the secondary down first and bring the primary up first. Otherwise the secondary will upgrade itself to primary mode.…
How to tell if logs are caught up in HDR
"onstat -g dri" on both , hdr and primary to check if they are sync'ed Also, you can see in the logs messages like "DR: Secondary server needs failure recovery" "Start Logical Recovery - Start Log ..." When you'll see "DR: HDR secondary server operational" then primary and HDR ar…
RSS Encryption Performance Hit?
Since RSS is a special case of HDR, does ENCRYPT_HDR also have to be set? DG…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Issue with statistics
We have a primary and a secondary. The secondary is a reporting server, and when one of the report creators adds a table to the sql query, the performance of the report grinds to a halt. It ran fast before adding this table to the query. Is there some way I can check to see what…
set up a secondary server tutorial info?
IDS 12.10.FC9 (workgroup edition) Windows Server 2012 r2 Hi, We have one informix instance for our production database system. I'm about to set up a secondary server for the first time. This will be for failover should the primary server fail, but will be unavailable for sql re…
reading committed data on hdr
We are using informix IDS 12.1 with an HDR in near_sync mode. Some applications read data from hdr. We found that uncommitted data is also read n hdr that some times rollaback and information delivered at that instance does not recoincile. One solution might be keep the hdr in fu…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Re: HDR Question
Back in business. Did a reboot and it must have freed up the port. Now back to trying to get HDR going.…
HDR Configuration
Hi Friends, After a lot of study and IIUG members help, we are ready to implement HDR in production environment. But I need your help to get move forward to successfully implement HDR without any issues. Which is the best approach to get high performance and without any data lo…
HDR scenarios
Dear Informix Guru's I have successfully implemented High availability HDR in Windows environment with auto switch-over using Connection manager with the IIUG members help. Especially Mr. ART Now pulling my hair with some sort of scenarios, which i mentioned below, because of f…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Secondary stuck in Fast Recovery
I just want to double check that this is what has happened. I backed up and restored my primary. Does this mean that I also need to restore the secondary, even though I didn't touch it? The log on the secondary when I tried to start HDR is saying two servers out of sync. To re-…
Informix HDR
Hi, I'm currently running Informix HDR (IDS 12.10FC8 on Windows server 2012 R2) in Async Mode. I just have a few questions: In Async Mode, the log is flushed to disk without waiting for a confirmation from the Secondary. What happens if a transaction is committed on the Primar…
DRAUTO
Hi, we have a primary and secondary server, that we look after in Informix 11.5FC6. Our client wants to take down the primary for an hour this weekend. I see DRAUTO is set to 1 which I have read that means the secondary will switch to primary mode, and then revert back to second…
Switching HDR to RSS replication
This is a follow up to my earlier post on IIUG (July 19, 2017): HDR-Distance and Latency Our HDR distance is changing from 40 miles (NEAR) to 1200 miles (FAR) after 2 months. After testing with a set of simple update/delete statements on triggerred and non-triggerred tables I co…
New Channel of Informix Server (Tech)
Hi guys There is a new channel of Informix Server in Spanish , enjoy It -Install , Backup , Restore , HDR and more. https://www.youtube.com/channel/UCVGD_IAhd0VGntXiSh_E6ew Best regards Luis devecua.com…
Differentiate OLTP&OLAP from 1 Application Server
Hello Everyone, I need some valuable information regarding the below scenario. At present we are having one Application server using for OLTP as well as OLAP. lets say it as app_serv. We have one dedicated standalone IDS database server which connects application server (app_se…
connection is not establishing between servers
I am facing an issue while connecting between servers using DBACCESS. Environment : Windows server 2008 R2. two INFORMIXSERVER: primary and secondary. Service port for primary : primaryport 50005/tcp. Service port for secondary: secondary port 50006/tcp. From primary DBACCESS i…
Rebuid sysmaster database and effects in a HDR/RSS
Hello I need rebuild sysmaster database in our production instance. I think running the "$INFORMIXDIR/etc/buildsmi" script will not cause problems with our HDR/RSS instances, but I'm not sure. Anyone know if there is any kind of incompatibility (rebuilding sysmaster) with an H…
Re: RE: HDR replication setup on Windows
Hi, Did you got the information on HDR implementation on Windows. If, could you help me on this. I have stuck at this point since last three weeks.…
HDR Implementation
Hi All While HDR implementation on Unix My scenario: 1. Two different servers with identical hardware and software. 2. Installed IDS on both servers. 3. Created Instances manually with all onconfig, sqlhost, environment variables set. 4. set all HDR related parameters in oncon…
HDR implementation on Windows server 2012 R2
Hi Every one. Hope all are doing well. I need a assistance in implementing HDR in Windows environment. My OS is : Windows server 2012 R2. Can anyone plz provide the key parameters to implement HDR in windows environment. I had implemented in Linux environment. its successfully…
HDR Implementaion
Hello All, Need a Fast response. Thank you Advance. On implementing HDR I have strucked at one point. My Environment: Primary Server Name : primary Secondary Server Name : hdr_secondary I had configured all the paramenters in oncongif, sqlhost, services, hosts, host.equiv. I…
Log reader to get transactions - failed HDR Primar
Solaris 10 IDS 11.50.FC5 SPARC 64 I have a primary server and a secondary server. The primary server eventually crashed, and we failed over to the secondary server. I told everyone that the data should be current on the secondary, but now I am being told that it appears that i…
Configuring HDR
We have a primary and secondary setup in PROD that I am trying to mimic in dev with version 11.5 I watched Lesters webinar, and he mentions the use of an rhost file. On other searches, I see some people use hosts.equiv file When I look for both of these in our PROD environment,…
HDR Solution
Hi, Currently we have used informix IBM Informix Dynamic Server Version 11.50.FC8GE workgroup edition running on hpux. Our production load already full utilize during peak hour. To reduce load on production server, we plan to separated process to another server, means OLTP proce…
CDC vs ER
Hi, our customer wants replicate data to oracle and informix server. For oracle wants use CDC and for informix too. Do you have somebody experience with replication over CDC ? 1.informix to oracle and other database system 2.informix to informix. I'm interested also to compare p…
DBSERVERNAME in an HDR environment
Hi, In an HDR Environment, the DBSERVERNAME of the primary server must be the same of the secondary server or they must be diferent ? I asking this because I have synonyms in and external server pointing to the primary server, but in the case th primary fail and the secondary be…
DBSERVERNAME in an HDR Environment
Hi, In an HDR Environment, the DBSERVERNAME of the primary server must be the same of the secondary or they must be differents ? Thanks in advance.…
Upgrading to Informix 12.10.FC6 with HDR
I am planning an Informix server upgrade from v11.70.FC7 to 12.10.FC6. I have a read-only secondary server replicating in HDR. (HP-UX 11.31.ia64) Questions: I start by breaking the replication and bringing both sides down. 1. Do I upgrade Informix on the Primary and the Second…
Promote RSS to HDR
Hi, how can we promote an RSS secondary server to be HDR secondary server in order to give users the right to only do their reportings on this server and keep all OLTP transaction on the primary.…
Convert RSS to HDR secondary
Hi, how can we promote an RSS secondary server to be HDR secondary server in order to give users the right to only do their reportings on this server and keep all OLTP transaction on the primary.…
HDR - export on secondary
On an existing HDR (11.70) I'd like running an export on the secondary node while the primary server still needs to continue running. On secondary node: onmode -d standard perform the export onmode -d secondary (HDR should start re-syncing) Any suggestions or recommendation…
updatable SDS
I just found the answer: The only isolation modes that are not supported at the Secondary server are REPEATABLE READ and CURSOR STABILITY.…
Load by External table commit interval
No, I have an RSS server, if I turn the table to raw, unfortunately the load does not replicate to the secondary server unless is there a way to replicate this load with an other mechanism.…
Data loading quesiton
I will figure out the loading time with standard table without HDR on this thursday or friday. My Ids VERSION is 12.10FC6. currently DRINTERVAL is 0,HDR is near_sync; and I will do the testing according your suggestion, convert it to RSS before loading ,and conver it back to HDR …
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
HDR Secondary - backup question
Solaris 10 IDS 11.50.FC6 Is it possible to take an "ontape" backup of a secondary server while replicating, or do I need to change the secondary server to "Standard" mode to back it up? If I have to change it to "standard", will I be able to change it back to secondary without r…
Informix upgrade path
OK and Thank you very much ! yes I'm planing to initialize completly new engine - I 'm also planning to make also from stand alone server to SD secondary in Linux cluster.…
RSS/HDT Sec - Different Query Plans???
Could this bug apply to you? IC92934 INDEX MAY NOT BE USED ON SECONDARY SERVERS FOLLOWING TABLE ALTER It is fixed in 11.70.FC7W3 and presumably later 12.10 fix packs, otherwise restarting the secondary is the workaround.…
tuning HDR
Hi, A customer use HDR in IDS 10.They use async mode and DRINTERVAL is 30. database is unbuffered. a batch job run below two sql. 1, insert into A select * from B where condition; 2,delete from b where condition; they found those SQL become 10 times slow after using HDR. How to t…
Error -225 when configuring RSS
Im sorry, I found the problem. The comand is for the primary server. On the secondary server the command is: onmode -d RSS <primary server> (without "add") Regards !…
HA Checkpoint Trigger
The physical logging performed on the primary is not necessarily going = to be the same as it is on the secondary. A common reason for this is the= creation of an index. Consider that the primary may be doing a checkpoint as the index is bei= ng created during the final phase o…
Replicate
Hi, We set up an replication from aix to suse. How can I know if all the data are replicating correctly ? Thanks in advance. Enviado desde mi iPhone…
HDR
Hi Scenario: 1. Primary failed 2. Secondary changed to Primary. 3. Primary initial Recovery (Step 1). 4. Can Sincronice from Secondary to Primary initial ? Comments Please. -- Saludos Cordiales Rubén Dután Gerente APLEXT CIA. LTDA. Soluciones AX-ERP & TIC www.aplext.com.ec …
Wakeup RSS Server
Jacques, It is not an updateable HDR secondary, just RO. On one of the latest occurrences the secondary recorded a ping timeout followed by -28852 which implies a network error. It then followed with DR_ERR set to -1 , DR Turned off on secondary server. The primary just recorded…
SQLHOSTS for HDR
What are the benefits to defining groups in sqlhosts for an HDR pair? I have had some issues with multiple instances (each with an HDR secondary on a separate server) where I left the group definitions out and came across some unexpected behavior when dealing with failover. After…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Setup HDR
Informix = IBM Informix Dynamic Server Version 11.70.FC7GE Unix = HP-UX rafdr B.11.31 I am trying to set up HDR between two servers. After I successfully ran the command "onmode -d primary serverA" , I ran the command "onmode -d secondary serverB" I then get the following messag…
Connection Manager - Sessions Terminate Abnormally
let me rephrase, I have 3 instances - ifx1, ifx2, ifx3 and then each of these has a designated HDR secondary. sorry for the confusion…
Re: HDR error in secondary server
Hi, Well something is a bit odd on the target server storage root chunk. The assertion failure file shows two I/Os - one that caused the bfput error and then one for all the I/O. So, you should get two identical pages back - you don't! page 000000009da71000: 00000000 010046da …
Error Secondary server HDR
Hello Someone knows. why Did this error happen? 08:35:18 Assert Failed: Page Check Error in bfput 08:35:18 IBM Informix Dynamic Server Version 12.10.FC3WE 08:35:18 Who: Session(29, informix@sermirror, 0, 0x56d90038) Thread(58, xchg_2.0, 56d59fa8, 13) File: rsdebug.c Line: 1172 …
Error HDR
Hello There I have the following error in secondary server 16:50:58 Start Logical Recovery - Start Log 9539, End Log ? 16:50:58 Starting Log Position - 9539 0x47832e4 16:51:03 Started processing open transactions on secondary during startup 16:51:03 Finished processing open trans…
HDR
Dear folks For HDR I need de same version of OS & IDS -- Saludos Cordiales Rubén Dután Gerente APLEXT CIA. LTDA. Soluciones AX-ERP & TIC www.aplext.com.ec -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que est…
RAW tables vs. HDR Replication
Hello everybody, I use RAW tables in my transaccional database to overcome concurrent updates on the same row. (f.e.: counters tables). Im planning to implement HDR replication on my database server. Raw tables do not replicate their data into secondary HDR server since DML sent…
Secondary HDR physical move
Earlier today we physically moved our secondary server to a different rack. We first stopped the connection manager, then Informix, then shutdown the machine. After doing the physical move, we powered up the server, then started Informix via "oninit -s". The online.log shows seve…
Swapping HDR
Hello, IDS 11.70.FC7W3X3 AIX 6.1 I thought this should have been simple and maybe it still is... I want to swap modes in HDR. In other words, I want my secondary to become my primary and my primary to become my secondary. I have DRAUTO set to 0 and I do NOT want to have to res…
Álter Add fragment on HDR environment
Hello: I tried to alter fragmentation on a hdr environment with no succes due long transaction. Shall I change this database to non logging and try to alter? Shall I unset hdr, do the alter and set hdr environment? Regards…
compression and ER
Folks, When a table is compressed and ER replicated, assume the data compression ratio is 80% on the table, do you think the ER data volume in network for that datable could be reduced by 80%? or compression will not change ER traffic volume ? Thanks, Frank --001a11c2f4e6312cd…
Upgrading IDS version on PRI need rebuilt HDR/RSS?
Hi All, I have a question related to informix upgrade. If I am running Primary, HDR & RSS, then when i upgrade the primary informix version (from IDS 11.70 FC4 to FC7), then HDR & RSS remain intact or not? And does it requires the rebuilding of HDR & RSS again using level-0 back…
Promoting RSS Secondary?
I admit bad form in continuing to reply to my own posts. However... could it be as simple as retiring the original RSS primary, bringing C (an RSS secondary server) to standard and executing 'onmode -d add RSS <server D>' on it. Then, on D (what was the other RSS secondary) exec…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
BlobSpace replication
Hello, I read somewhere that blobspace in not replicated with HDR, is it true ? and if so what informix technology to use to do so ? Thank you :)…
can we have to hdr servers ?
In fact i will use it for backuping the production. Is the rss read. Only. Likr hdr ?…
HDR question
IBM Informix Dynamic Server Version 11.50.FC8W2 Redhat Enterprise Linux 5 I have a server that is running in standard mode with 1 RSS attached. I can I do the following without bring the engine(s) down On standard onmode -d primary <rss name> on RSS onmode -d secondary <prim…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
HPL unload on secondary HDR
We have a backup script that does HPL unloads on certain tables throughout the day. When I run the scripts on an HDR secondary however, it hangs for a bit, then times out with error "Cannot open database 'sysmaster@servershm' - SQL error -25588, ISAM error 2". The strange part is…
Strange HDR behaviour
We are using IDS 12.10.FC1 and Solaris 11.1 Sparc and experience a strange behaviour with HDR. After i started HDR by performing a physical restore onto the secondary server i got the message "DR: HDR secondary server operational" which means that everything is ok. Now, everytim…
redundant connection manager configuration using H
correct. since PRIMARY always has zero latency, so most time Connection Manager will route client application to the PRIMARY. if you want use secondaries and low the connections to the PRIMARY, you can define cm_sla1 as SLA cm_sla1 DBSERVERS=(RSS,HDR),PRIMARY if all RSS and HDR…
Extract data from Secondary server Slow
Hi All, Is there a way to make my select statement faster? i'm using this in my ETL but it is running slow.. SELECT CARD.CARDID ,CUST.HHOLDID ,CUST.PHONENUM ,CUST.FIRSTNAME ,CUST.LASTNAME ,CUST.STATUS ,CUST.CUSTTYPE ,CUST.AIR ,CUST.FASTFID ,CARD.CARDC FROM CARDX CARD …
Auditing HDR server
good evening, can we audit an hdr server ? which is, by definition, on read only mode :) thanks in advance…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Some strategy to resize logical-logs in HDR
Thanks a lot, I am even more impressed about Informix HDR features now. Regards, Keith!…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Re: Effect of SAN-level replication on Informix
On Tuesday, July 31, 2012 1:54:40 PM UTC-6, red_valsen wrote: > Does anyone have experience with SAN-level replication and its effect on Informix, especially with respect to disaster recovery/restore? We're examining different redundancy schemes of our environment across a WAN u…
Upgrading HDR to 11.70
Hello All, IDS 11.50.FC8W2 on Hp-Ux 11.23 I have gone through a post for upgrading to 11.70, just want some one to help me with sequence of steps. 1) Make the HDR standalone 2) Upgrade the Primary to 11.70 3) Level 0 backup on primary 4) Upgrade the HDR to 11.70 5) Restore the…
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…
HDR in Windows
I need do an HDR in two instance in windows. How I do it. Thanks Wanderlei…
HDR and ER Running Together
Lets try again, this may be easier to read !! Set up is as follows: IDS 9.4 on AIX 5.3 --> ER over LAN --> IDS 10 on Solaris 2.8 | |-> IDS 11 on Solaris 2.10 V Sync HDR over WAN | V IDS 9.4 on AIX 5.3 Note ER is Primary to Secondary (one way). With this setup I am seeing line…
HDR and ER Running Together
Set up is as follows: IDS 9.4 on AIX 5.3 ----------> ER over LAN -----------> IDS 10 on Solaris 2.8 | |------> IDS 11 on Solaris 2.10 V Sync HDR over WAN | V IDS 9.4 on AIX 5.3 Note ER is Primary to Secondary (one way). With this setup I am seeing lines in the error log o…
Query Performance on HDR instance
Recently we have faced a scenario, a query was running quite fast on primary instance but performing poorly on HDR instance. The execution plan on both instances were different as well. After running "update stats" on tables involved in query, the execution plan on HDR become sam…
HDR Setup
I "was" in the middle of setting up HDR between a pair of AIX 5.3 servers running IDS 9.4.FC6 (upgrade planned), but have just noticed in the Admin Ref that the servers should be quiescent when issuing the onmpde -d primary/secondary 'server name' commands. This requirement isn't…
enterprise replication cdr suspend
If you suspend the replicate, then that will cause any replicated transactions containing that replicated table to be 'split'. Part of t= he transaction will be applied now and part will be later. That can cause= issues during the apply if you are using referential integrity. S…
Re: HDR Secondary Server stuck in fast recovery
Did you be able to solve this? Thanks…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
HDR question once again
Hi All, I have a Solaris 7 + IDS 9.4UC6 as primary and a secondary server (Solaris 7 + IDS 9.4UC6. It is running smoothly and fine. However, my boss inquire from me if it's possible to have the following setup: 1. Primary server (IDS 9.4UC6 + Solaris 7) Secondary Server (IDS 11…
HDR not working
Newbie to Informix Cannot get HDR to work. Can anyone help? Thanks Derrick Muller Secondary stays in Fast Recovery mode. Here are configurations for both primary (runix) and secondary (backix) Running SLE 11, IDS 11.70 PRIMARY hostname:dm_runix Instance: ol_dm_runix service: …
IDS 9.4 UC6 Solaris 7 Replication question
Hi Art/Madison, Just additional question, If i perform a backup from the secondary, is my procedure correct?. Assuming the primary is down and unable to startup and needs restore. on Secondary server. 1. set the secondary as primary server (onmode -d primary servername) onst…
Speed discrepancy between prod and a lab
I've been over-looking the HDR Remote Secondary that prod has, so I should add that we have one. I don't think it can account for a 25% speed difference. The other production environment has the same type of HDR, and we don't see the speed discrepancy with it.…
HDR-Connectivity issue
try to test your connection first from primary to secondary server dbaccess> databases > connect. If you cannot, check the setup, sqlhosts and authentication. If you can connect to the secondary server,you can setup by onmode -d primary <secondary server>…
HDR & RSS
Hi, I am trying to find out which is the best way to have an Standby IDS server a long distance away. I have IDS 11.10 on windows with actual database data 250GB. On Live IDS server we use onbar and TSM for whole system backup. Our database is in logging mode but we don;t need t…
DR Default Isolation Level in SDS Secondary
Hi I have a question because DR is default in SDS Secondary Server, how i can setup LC like a Default Isolation mode in SDS Secondary Server?.…
HDR- good pratices with secondary server
I am ready to set up HDR between our production instance and disaster recovery (DR). The secondary will be read-only. I have successfully tested switching the Primary between standard and primary modes (and shutdown). I have faced problems with switching the secondary to standard…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Could I execute ontape,onbar oronunload on HDR SEC
Hi, I want to reduce the workload in the primary server. Could I execute ontape,onbar or onunload on HDR Secondary server? thanks for your time.…
Could I execute ontape/onbar/onunload on HDR SEC
Hi, I want to reduce the workload in HDR primary server? Could I execute ontape,onbar or onunload on HDR Secondary server? thanks for your time.…
HDR setup- Network driver system error
Just to be clear. You cannot use a shared memory connection in HDR, etc as DBSERVERNAME. You may use it in DBSERVERALIASES. My HDR is operational. I have identified the problem ( with tips from Madison) and posted below.…
blobs and HDR
Is it still true in 11.5 and/or 11.7 that you can't have HDR of a blob space? Is there a way to work around that? Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors A computer lets you make more mistakes faster than any inv…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
Error re-Starting SDS Secondary server
IDS 11.50 FC8X4 Linux I have an SDS secondary server that I started up last week. Today I made a configuration change and stopped/ restarted the server. When it attempted to restart, I got the following "Logical Log File not found." error. 08:36:02 Logical Log File not found. 0…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
DB Restore From HDR Files
Hi, We are using IDS 11.50 FC6 & 11.50 FC7 on solaris sparc. We have tested the following Case 1: We've shutdown HDR and taken its dbspace files (OS files) and re-stored (using oninit -v -S) it to another machine/instance, and it was successful. Case 2: While the HDR was opera…
same ports in Primary , HDR and RSS
hi, I have a plan to use same ports at Primary, HDR and RSS servers. Is there any implication or availability or performance overhead. Kindly share the findings. anees…
ER error
Replication is working. data replicated fine. On Tue, May 3, 2011 at 3:55 PM, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > If I am reading it right > cdr finderr 1 > 1 A connection does not yet exist for the given server. > Is replication actually working ? > > > > **********…
Problem with HDR
I have upgraded my database from 11.5.FC6 to 11.5.FC7 but facing some issues with HDR. Its observed that when HDR is lagging behind the primary there are number of sessions goes into " G waiting on write of the logical log buffer" and primary goes slow and lot of load on primary …
how to do a full restore at HDR primary server
ids 9.40 , HDR Primary & secondary at normal status. Can I do a full restore 'ontape -r' at primary server. Is that will affect HDR functioning after ? Or I should restart the HDR setup steps ?…
How to failback in HDR?
My DR_AUTO is set to 0, manual. I'm able to get replication going from my primary server to my secondary. I'm able to effectively failover to my secondary, changing secondary informixserver mode to standalone, and successfully pointing users' applications (with attendant appser…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
HDR secondary move
Dear All, We are moving a server having Informix secondary server from one data centre to another. It is a 5 day process. Version 7.31 , OS HP-UX 11.11 While bringing up the Secondary instance I will check the following: 1) Check for last logical log in the secondary (in onli…
HDR licenses
Hello, Does HDR (standby server) require a separate Informix license? Can anyone point me to a documentation that deals with that issue? Thanks…
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…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
v11 in place migration
hello all the thought was to take a shot at a v11 in place migration without doing a complete restore of secondary (HDR). we are on v10.fc9 and are going to v11.fc7 running AIX 5.30 under a HACMP cluster on partitions on i595. thinking to just shut down the secondary server (n…
hdr and statistics
Ever since I started HDR on a second server, the statistics have been different. After a db restart, sometimes onstat shows statistics on the primary server and the secondary shows as zeroed out, sometimes the opposite. Then it stays that way to another restart. Can't figure out …
Switch RSS secondary back to Primary
The switch back to re-establish the Primary-Secondary HDR pair after a failover is documented and the scripts to do this are in $INFORMIXDIR/bin (hdrmkpri.sh* hdrmksec.sh*). Are there similar scripts available to re-establish a Primary-RSS secondary server after a failover to the…
HDR failing
Hi All, I got this message from the primary that the replication failed... Please see below 19:54:42 listener-thread: err = -25582: oserr = 9: errstr = : Network connection is broken. System error = 9. 19:56:21 DR: ping timeout 19:56:21 DR: Receive error 19:56:21 ASF Echo-Threa…
HDR startup on secondary server
I do the 'ontape -p' followed by 'onmode -d primary <SecSrvr>' on primary followed by 'omode -d secondary <PriSrvr>' on the secondary server. The following lines from 'tail -f online.log' on the Secondary server ( no issues on the Primary server). Not sure why I am getting the Sy…
HDR Error
I keep getting an error when I attempt to turn on HDR on my secondary server with "onmode -d secondary <primaryserver>." The informixserver message log reads: 16:26:23 DR: Reservation of the last logical log for log backup turned off 16:26:23 DR: new type = secondary, primary…
HDR Problem
Hi All, I've take the whole day configuring the HDR but it didn't work. I have the same machine and OS configuration. This is the procedure i've done so far: on Primary server, i have this configuration Primary sqlhosts #Primary ipc_ross1 onipcshm ross1 ipcshm ol_ross1 onsoc…
HDR not working
Hi all, It's my first time to configure a replicated machines. I'm using the same machine specification (all hardware), same IDS 11.5, same all up to the configuration. I also performed a backup using ontape -s -L 0 and ontape -r in secondary. on primary server, i performed on…
IDS V11.50FC5: AUS error.
yes, in a HDR system..…
grant select,insert update,delete on tabs on HDR
Hi All, Just a question regarding granting access to a user on HDR. I did the ff: 1. grant connect to username; 2. grant connect,insert, delete, update on table as owner. Question, Will the HDR (secondary) automatically sync what i have done on primary? Kindly let me know if…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Question on HDR
Hi All, Just a question on HDR of Informix.. The scenario is the DB primary server went down. The secondary server is up and running. The replication is fine before the primary shuts down. Here are the questions: 1. Is the Secondary server will function right away as the Prim…
New in HDR - Secondary server insconsistent mode
Hi All, I'm new in HDR of Informix. on primary server, the chunks status are all in "PO-----" mode. While on Secondary server, when i do 'onstat -d', is shows "PI-----", which is inconsistent. Is it normal because the Sec server is on recovery mode? I've check the replication an…
Start Replicate for huge tables
Hi all, I have to start new ER replicates with tables up to 400 Millions rows. I want to avoid to unload/load the tables because I have problems with piping the data with HPL. Furthermore I had to stop all transactions to ensure that the data the same on both servers before star…
HDR
Hi Would anyone tell me on a HDR pair in IDS 7.31, if I bring down the primary server (say for 2 hours appx for maintenance ) and make the secondary server as STANDARD, after primary server comes up, do I need to restore logical logs from secondary server? I want to bring the …
onbar backup exited 151
Thanks Martin, You are right... Secondary Server can't be backup... Upon reading most all informix forums and your confirmation. Regards.…
RSS problem
Hi! IDS 11.50FC4 Sun Solaris I have Primary, Secondary HDR and RSS servers. When I run: 1. Stop HDR (onmode -d standard) 2. After 50 or more logical log files completed I start HDR - onmode - d primary ... 3. While logical files send to Secondary HDR, new logical log files compl…
HDR
I'm getting ready to turn on HDR between our production site and our D/R site located 7 miles away. We are running Jenzabar CX on Informix 10 and HPUX 11i v2. Our 2 servers are connected via a 20 MB pipe. I've gone through the documentation but I have some questions below. We hav…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
program failing in secondary server
Hi. In a SDS environment there is a difference between inserts and puts. In the primary instance the program works correctly but in the secondary it fails with and trying to insert null value in a column that don't accept nulls.…
I/O writes
Hi Art, These stats are of a primary node in HDR cluster with 1 secondary and 2 RSS nodes. Does HDR also has non-blocking checkpoints?…
HDR
Hello, I'm getting ready to set up Informix HDR between our primary server and our secondary server at our D/R site. We are running Informix 10.00.HC5 on HPUX. Both servers are HP 9000 systems (rp7410). I've been getting some ideas from another University who has implemented HDR…
HDR recovery in asynchronous mode
So can someone tell what is "dr.lostfound" for? Is there something related to "dr.lostfound" w.r.t. HDR recovery…
hdr - update stats on secondary
hi all to settle an internal discussion - update stats on secondary server - necessary? the mechanism - stats move over from primary? thanks tom…
HDR (crash recovery)
Hi, We conducted a test to see the business impact if primary server crashes in an HDR. We inserted 200 independant inserts in a table. And killed the informix instance session (got from "onstat -g glo" command). Here are our findings: After crash of primary server the table on s…
SQLTRACE on HDR Secondary
Is there a trick to get SQLTRACE to work on the HDR Secondary. We use our secondary for some read only applications and would like to be able to analyze the queries with SQLTRACE. This is for HDR, but also wonder if SQLTRACE works for RSS and SDS Read Only Secondaries? IDS 11.…
RESTORE SECONDARY HDR LET INCONSISTENT CHUNKS
$ONCONFIG while DRINTERVAL > 0 is asynchronous, the secondary server's chunk always PI(except tempdbs). DRINTERVAL = 0 is synchronous.…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
Monitor HDR
Informix 11: We run HDR and I see waits on logbf0, logbf1. I think it's something to do with log shipping to secondary node. Is there a way to look at to make sure that log shipping is not the issue why I see some of the high response times on the user sessions. How can I monito…
Enterprise Replication backup question...
This is to answer my own question. I believe the original dba that set this up simply decided not to do backups on the secondary server due to space limitations. Hence this is not a good design and will need to be addressed. Thanks. Will…
DRTIMEOUT not working as expected?
We are unable to get our required result with provided value (75 second) and as a result secondary server become online (read/write) within few second. We need to force secondary server at least 5 minute to become online (read/write).…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Tables of type raw
Is there a way to create a table with type raw on HDR primary? I get the following: 19844: Tables of type raw are not allowed in a logged database on an HDR primary server.…
Building Indexs on Primary Server
Informix 11: We have HDR servers, I am seeing that creating an index on table of 100M rows takes more than 16hrs. Could it be because of HDR secondary server trying to build the index at the same time? We have PDQ priority set to 100 and PSORT_NPROCS set to 4…
High Performance Loader on Replicated Database?
Hi All, We are running informix 10FC6. I was wondering if we can run the high performance loader on a replicated database for unloading/loading data. Since a replicated database for informix 10FC6 is read only I assume that loading will not work. But how about unloading? Thanks…
HDR systems
Informix 11 Is there a way to determine which system is currently up among HDR secondary or primary?…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
How I can to change status from SDS secondary to Primary.
Hello All. I have my testing environment. I have server1 is primary server and server2 is SDS secondary server and one Connection Manager Arbitrator. When I shutdown my primary server, Connection Manager switches my application to the SDS secondary server. After that my server2 b…
Re: active-active DB
Mohit Anchlia said: > As far as I remember from presentation it's something like HDR, only that > the other node is not read only. It could be used to update data. ER can do everything HDR can do (and more) but in update-anywhere mode. This is old technology. With Redirected Wr…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
RE: HDR on IDS WE
Has anyone added HDR to a WE instance. I was wondering on what the process is once licenses have been purchased. Is there HDR software that you download to install on top of a WE installation or what? Once it is installed, does it operate just like EE when setting up HDR? Larry…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Two Questions on Restarting HDR (critical data undamaged)
Informix 10 Solaris 10 We have recently started using HDR, and are planning a test. The test will be to simulate a failure of the primary by doing an onmode -k. Our secondary has DRAUTO set to 0, so we will manually change the secondary to Standard. QUESTION #1: Can we do thi…
Informix Continuous Availalbility Feature Demo
This marketing video of IDS HDR, SDS, RSS and Updatable Secondary Nodes came in on my Google alerts this morning. http://www.cocktail-server.com/informix-caf/ Andrew…
Execute HPL
Hi all ... is possible execute HPL in Informix HDR ??? Thanks _________________________________________________________________ Descargá ya gratis y viví la experiencia Windows Live. http://www.descubrewindowslive.com/latam/index.html…
HDR Performance
I want to know - How to measure/estimate the Network Bandwidth for a HDR pair over a WAN ? - What will happen to the performance of the Primary server if Network slows down ? - If Primary fails during high trasaction processing will the Secondary be in Sync - Are there too…
Informix HDR and ER
Dear All, I am in the process of setting up Informix HDR on IDS 11. I need your inputs and assistance. Can you please give me the steps to configure HDR. Also would like to know whether the main requirement for HDR is two servers with identical configuration or can we setup HDR …
replication HDR
Hi, Last night I recycled informix engine 10.00 FC7 (which is also primary in hdr pair) and brought back up in half a minute. It sent replication failure immediately on secondary server online message. but when I brought primary back online, it gave this message in online: DR: F…
HDR secondary database
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > Behalf Of SUNITA RAINA > Sent: Friday, February 29, 2008 11:02 AM > To: ids@iiug.org > Subject: HDR secondary database [11464] > > Hi, > > We are required to reboot our database server wh…
One temp space fills and 4gl fails
Everett -- This is the primary server in an HDR pair, could that have something to do with it not filling the temp table round-robin?…
backup replicated database
Hi, Can somebody tell me if replicated (read-only) database on HDR can be backed up ontape? or is it only primary can be backed up? Thanks, Sunita…
HDR - resuming secondary
SUNITA RAINA wrote: > Hi, > > I had to bounce my primary database which is replicated to another database > (secondary, read-only) on another box. When I bounced the primary database, it > broke the replication with secondary. when I ran onstat -g dri to check > replication statu…
alter statement in HDR scenerio
Hi All, I would like to add something, As you know Secondary server/box in replication is in Read-Only mode. On primary server one can always give DDLs for create table, alter table but not on Secondary. Changes made on primary are applied to Secondary using Logical Logs. Thank…
HDR questions
Couple of questions on HDR for the wise. We are at the testing stage of an ODBC-based application and want to test failover. HDR was working fine until I shut down both the instances and set DRAUTO to 1 on both sides; now the primary and secondary just say they can't find one a…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
How HDR resync after network connection resumes
With "RETAIN_TYPE" is set to 1, HDR would be reestablished from secondary server when old primary is up once again. When the logical log backup has been performed on secondary server, how the oustanding logical log could be retrieved for resync to old primary server? 1) Do I ne…
HDR failure handling on network disconnection
As I know that HDR is working by HDR buffer for transferring primary data to secondary data. But what if the failure of network connection occurrs intermittently and the primary physical log was backed up to tape for freeing its space, how the informix data server handles it? Wil…
HDR to more than one secondary
Client wants to do HDR to two backup servers. Can this be done? They're going to be on 10, possibly moving to 11 Q3-ish 2008. Thanks Andy…
ER's cdr stop & cdr suspend
HI, Folks, Just a curious question, According the doc, "cdr stop" will stop capturing data to be replciated, "cdr suspend" will continue capturing data but not sending . Form our test, ER still captures data to be replicated even after you run "cdr stop" and it will replicate i…
HDR quirk?
IDS 10.00.UC4 RedHat AS 3 U 8 Re-org a table under HDR with the following quirky result: tab_b created like tab_a with new extent sizing tab_b loaded from tab_a without indices create one index on tab_b applications accessing HDR secondary stopped applications accessing HDR pri…
What is ids11 new function RSS for?
Hi, also in the Administrator's Guide there is a section that is partially copied here: Differences Between an RS Secondary Server and HDR An RS secondary server is similar in many ways to an HDR secondary server. Logs are sent to the RS secondary server in much the same…
IDS 10 Replication Logs
Not sure I understand the question. Are you asking what user SQL was processed on the primary to cause data on the replicant to be modified or what SQL was generated by the primary internally to update the data on the replicant? Either way, the answer, I think, is the same. ER d…
OFF_RECVRY_THREADS and ON_RECVRY_THREADS
Does these parameters help in logical log recovery. I was wondering if increasing ON_RECVRY_THREADS help in HDR on secondary server.…
HDR recommendations
Could somebody tell me their experiences about HDR. I am reading about HDR to see where we can improve. We ran our tests and the performance was less than .5 of what we generally get. Do things like log file size make difference ? Would increasing memory help ? We have huge blobs…
how - replication
We have HP Integrity rx4640, HP-UX B.11.23 operating system running IDS 9.4 We want to establish replication server using IDS 9.4 Our data size right now is 50GB and data growth is 50MB per day Would you all help me give explanation for our replication? What is requirement and ho…
DR: Cannot connect to primary server
Hi Everett, That partially worked. The onmode -d primary sci01sectcp command on the primary now gives me the following: 10:24:18 DR: Primary to Primary 10:24:18 DR: new type = primary, secondary server name = sci01sectcp 10:24:20 DR: Primary server connected 10:24:21 DR: Second…
HDR or storage remote mirroring, which is better?
I like to make a Diaster Recovery system, and just wondering which system I should choose:Informix HDR or storage remote mirroring . storage company told me that remote mirrroring can copy primary server's modifying block to the secondary server immediately. The functions that r…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Server Secondary
Hi all: In an architecture Informix HDR it is possible to create temporary tables in the secondary server ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
Types of dbspaces
Hi all: In INFORMIX+HDR that types of dbspaces support ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
DDL with HDR
We have an Informix 10 system with an HDR mirror, and we are having trouble with DDL statements getting "non-exclusive access" errors. We have a piece of software that is used by many organisations, and each organisation has a seperate database on the server. When we have a new …
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
IDS down while log back. is it a bug?
The 'onstat -l' showing it's a HDR secondary server. Wondering, are you trying to log backup on secondary server? When you use HDR, you must back up logical-log and storage spaces only on the primary database server. -Sanjit Chakraborty…
HDR Transaction
Hi Guys, I got a enviroment with HDR in two AIX maxhines. What is the rule for backup logs in secondary server? I try to start a logical log backup and, the only situation it was finished with sucess, the secondary server was turned to standard mode. What is the problem if I don…
HDR Connectivity (IDS 10.0)
Hi Dileep, Check if you can connect to primary server from the secondary server host. When Primary server is online, try connecting to it using dbaccess from secondary server host. You could also try using different port # for primary and secondary servers. - Nilesh - "DILEEP…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Data Replication
Hi, We are using the IDS 7.31 of informix on TRU64 unix. We have a Primary db. server which replicates to secondary db. server. In case of a failure with the primary server. (OS level, Disk error ), is there any way to configure the database onconfig parameter to ensure that th…
Re: Informix transactional replication
Davorin Kremenjas wrote: > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > news:45AFD3D4.5090706@bloomberg.net... > >> 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 …
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 …
mystery server in HDR
Hello all, upon bouncing our secondary server, the log shows it is trying to connect to a primary server that does not exist! we have searched the secondary server itself, system tables, etc and cannot find a reference to this mystery server we are on ids 10 fc5 on AIX 5.3 usin…
changing HDR dbserver names
IDS 10.00.UC5 on RHEL3 2.4.21 kernel Is it possible to change the dbserver names used for HDR without reinitializing HDR? For example, a while ago I initialized HDR like so: physical restore of serverB from backup of serverA onmode -d primary serverB onmode -d secondary server…
HDR Question
>From IBM Informix Tech Notes, why would you want to do this? Problem This article describes how to disable parallel clearing of the physical and logical logs on the secondary of a HDR pair during its logical recovery. Solution Q. How do you disable par…
ontape on various system
I want to make replicate system for IDS 9.40 FC5 from HP itanium machine to IBM p series machine can I use ontape utilitiy to backup data from HP machine and restore data to IBM machine? thanks…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: HDR questions
"bozon" <curtis@crowson1.com> wrote in message news:1153751331.455151.291640@s13g2000cwa.googlegroups.com... > You can't make the secondary go into standard mode. It has to stay in > secondary mode. This makes sense to me. > So, if onunload works on a secondary then you would e…
HDR questions
> What about backing up without marking the database as backed up? Isn't > that a new feature of informix 10? ontape -F in think. > > Would this allow a backup to be done on the secondary, because it isn't > updating the system tables? > > > > Yes you can run ontape on the secon…
HDR and Indexes
Most of the folks using HDR know about the create index issue. Can I have honest reaction on this issue? Thx…
Re: Need info on blobspace blobs
We use blobspace blobs. Recently we have decided to implement HDR for that server. Now we are looking for a way to replicate our BYTE columns. It will be very useful for us if HDR can support blobspace blobs. Madison Pruet wrote: > I need an idea of the number of customers who a…
Replication from Informix to MySQL
Is there any product out there that does replication from Informix to MySQL. There use to be a product Ominireplicator by Praxis that did trigger based replication before ER was even available, but I could not find any information on them. My client is looking to replicate from …
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Re: Long checkpoint woe
Hey, I just noticed this is part of HDR. The checkpoint has to wait for the secondary server to write to disk. This could be your bottleneck also. Make sure the network connection between the two server is good. Are the disks the same on the secondary? Take the secondary server…
HDR on win2k
Hi All, Is anyone out there successfully running Informix 9.4 HDR on win2k (with tape backup or with out tape backup systems). I am getting an error "unable to change server type" after I type "onmode -d secondary pri_server_name". Thanks, Bes…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
Re: Defrag large fragmented table in 7.32
Coming in v.Next. I seem to remember seeming something about online upgrades whilst HDR is in use for v.Next but I can't find the slide again on IBM's website...…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
RE: HDR Sync/Async mode
We've run HDR in sync mode across a dedicated link, didn't notice any performance issues.…
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
HDR Sync/Async mode
Could I do a quick survey to see how many folks are using HDR Sync mode and how many are using HDR Async - and why? Thanks M.P.…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Fied wtlist gt 0 _ onstat -k
Hi Masters: What is the query to get wtlist > 0 onstat -k IBM Informix Dynamic Server Version 7.31.UD7W4 -- On-Line -- Up 2 days Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 80e20b70 0 cd6a6f08 0 S 100002 204 0 820b9958 d62b1a38 d62b4cd8 80e2d280 HDR+X b0001…
Oracle to Informix Data Replication
Hi, Can you please tell me what is the best way to replicate data from Oracle to Informix in real time? Thanks Nitin…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Mirror / Raw device / Informix
High Availability data replication?…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: No future for DB2
>> >> No, partitioning is not included in DB2 Workgroup Edition. You can't even >> do simple replications in DB2 without purchasing a separate product. >> > > We have been discussing here primarily DB2 for Linux/UNIX/Windows right? > This is not true. Replication is included free…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
ontape problem. pls help
You are getting this warning because Primary server is trying to connect to Secondary, but secondary is not yet initialized. You can ignore it, or wait for secondary to restore from backup before you register HDR on primary (onmode -d primary sec_server). -Ajay…
HDR problems
Hello , Iam doing a HDR for 2 informix servers on HP-UX :- Informix Dynamic Server Version 7.31.FD6 -- On-Line -- Up 33 days 07:46:25 - - 661824 Kbytes But when I was doing a ontape -p on secondary server , it showed or asked me "do you want to restore a level-1 backup ?" ...I …
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Replication question...
I'd definitely agree with that. I think Smart LOBs are replicated in HDR when they are logged, but they are so slow we can't use them with logging on! Regards, Donny superboer wrote: > > enable HDR for (s) blobs in sbpaces and blobspaces. >…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Restoring a level-1 backup at a later date?
To all those who suggested we use HDR for this; there was a small bell ringing at the back of my mind and eventually I worked out why. You CANNOT USE HDR TO REPLICATE BLOBSPACES!!!!!!!!!!!!!!! (At least in IDS9.30 anyway). Why oh why oh why the hell not? Malc (seething 'cos we'd…
detection of primary server failure
HDR IDS 921UC4 In this version DRAUTO has been disabled. Now it is only manual. How can secondary server detect the failure of primary server in the shortest possible time without involving a script to poll. I want the detection as fast as possible for minimum downtime so that …
HDR issues
All, I had a peculiar problem with HDR last night. We had a software = upgrade, which made some changes to the db schema (columns added, indexes created). In order to = facilitate this,=20 I shut down the secondary server until the everything was complete. = When I started up th…
HDR feedback
Just a little bit of feedback (for those interested). A while back I posted a reply to an HDR mail, saying that we have loads of problems with HDR, and I was about to give up on using HDR. We kept loosing the link between the 2, and I kept rebuilding the secondary server. W…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
HDR Logging
Hi, I need to configure HDR on two IBM AIX servers running IDS 9.40 I cannot use Transaction Logging. Will HDR work without having Bufferd/Unbufferd logging enabled? Thanks Trevor…
HDR question
Hi all, Is there anyone know which SMI table keep track of the Last DR CKPT info? sysdri tables from sysmaster database doesn't contains the info. I need to know what is the current log id that being replicated to the secondary server. Informix Dynamic Server Version 7.31.UC2 …
HDR Interval
Hi, I'm wanting to implement HDR between two IBM AIX servers running Informix 9.4 UC3. I have 53 (2mb) logical logs. I've been asked to have a replication period of 1 hour DRINTERVAL of 3600. We do an ontape -c on the primary server. Would there be a problem if all the logical …
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: HDR: MULTISET gives -626 on secondary
This is a limitation on using extensibility on HDR secondary. I think workaround mentioned in release notes will work (provided you wait for DRTIMEOUT after running the query on primary).…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
HDR using encryption with CSM ??
HDR is using full duplex protocol. The CSM is using half duplex. That means that HDR can not be using encryption. "rvb" <rvbon@gmx.de> wrote in message news:6e9a0040.0407060058.a949384@posting.google.com... > Madison, > > I isolated HDR communication with option s=6 as follows…
Re: HDR with Synchronous replication
There is an important thing to consider if you choose to use HDR . The secondary server must be a "Stand By" Server. By "Stand By" i mean that, no hard work like dss queries on the secondary server, because checkpoint between servers are synchronous (regardless DRINTERVAL's val…
HDR on Windows 2000
Has anyone tried HDR on Windows 2000. Is it even available. Version can be either 9.3 or 9.4. Thanks. Ravi…
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…
Informix HDR Replication
Can you give us the stack of onmode_monitor thread when server is hanging during state change (off-secondary to standard). onstat -g dri output will also be useful. When DR is on, you can not switch secondary server to standard mode. To bring the server to standard mode, you nee…
HDR Question
Officially, you need identical engines and operating systems to use HDR. However, during an upgrade, we tested and used HDR between identical 7.31 versions with the primary on solaris 8 and the secondary on solaris 7. Has anyone tried using HDR between 9.40 versions, one on sola…
Question on Enterprise Replication
Hello all, I have a question regarding Informix Enterprise Replication (ER), also known as CDR. We have several instances involved in a replication scheme right now and are looking to add a lot more to it. The scheme is a little complicated but I will try to simplify: Instance…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
HDR running oncheck command on secondary server
Hi there!, I would like to know experiences running oncheck -cD and cI on the secondary server of HDR pair. I have seen strange behaviour after running onchecks on the secondary server, and it also hung the primary as well. FYI, 2 Sun Fire 6800 Solaris 8 9.30.FC5 12 cpus HDR …
Type of Replication to be used.
HDR is the simplest and easiest replication to set up for DR. It maintains an exact replica of the production server. The DR server must be just like production server. ER is typically used for replicating subsets of production data so setting it up for replication of the entire …
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Informix data files interchangable btw Unix & Win?
Hi, What kind of Data Files ? (DB Chunks ?). If DB Chunks, it's not possible. Try DBEXPORT and FTP to Windows and DBIMPORT or (table level) Unload to file Load from file or (replicate transactions) Use Replication (CDR)…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Whatcha' wanta have?????
How much is Madison paying you? LOL Rob Vorbroker --- Ben Thompson <ben@nomonitorsoftspamthanks.com> wrote: > Art S. Kagel wrote: > > > - Support for multiple HDR replicants. > > This would be a boon for us as it would remove the > need for ER. The > ability to use HDR+ER togethe…
Re: Whatcha' wanta have?????
Art S. Kagel wrote: > - Support for multiple HDR replicants. This would be a boon for us as it would remove the need for ER. The ability to use HDR+ER together is useful but an all-HDR solution would be a nirvana. HDR is just so much easier to use and set up. Ben.…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
RE: Simple HDR question
> -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org] On Behalf Of Davis Kwong > Sent: Wednesday, February 04, 2004 11:46 AM > To: Dirk Moolman > Cc: informix-list@iiug.org; owner-informix-list@iiug.org > Subject: Re: Simple …
ER : cannot drop one table
Good morning/evening, We use ER to replicate whole databases between servers: - primary (root server) : IDS 9.40.UC2 - secondary (leaf server) : IDS 9.30.FC3 Now we want to drop and recreate one replicated table, but we can not drop the table on the secondary server: we get the…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Informix Work Group DATA Replication Need Information (URGENT)
Hi All, I'm working with Informix Work Group 7.31 TD1 on W2K. I cannot operate the data replication on this version. After consulting with informix support i was informed that this version (IDS WG ) don't support data replication. I this correct ? Is there someone working on th…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
HDR Secondary Server stuck in fast recovery
Hi, I am running the HDR feature with IDS 9.40 UC2 on Sun Solaris. I'm having the following problem when I try starting HDR for the first time on a busy system. Here are the steps I carry out: On the Primary Server ( starts off in online standard mode): 1. Run a full Backup of…
about HDR
This is a multi-part message in MIME format. ------=_NextPart_000_05EF_01C3BD8A.4C96BEB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there. Is there a way for me to get the HDR kit? Maybe a url to = download? Best regards, Mar…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
HDR
hi, We are trying to setup HDR (using IDS 7.31UD3X5a) on NCR UNIX. The two enviroments are configured identically. HDR starts successfully (We also created databases and table and everything works fine), when we try to simulate a failure on the primary (onmode -ky), then the sec…
alternative ...that can work similar to ER ...
hello group: I have a situation where my ER replication backs up(fails) frequently due to weak network links. Is there a way to have informix communicate changes to a plugin or external program, the idea being to log the data to some other files to be transferred and restored. …
RE: IDS 9.x workgroup server
According to IBM's website, data replication is no longer restricted, but you must purchase separate licenses for each server in the cluster.…
HDR & backups
Informix 9.30 Solaris 8 We are planning to do the following: Have a primary server, and then use HDR to replicate this server onto a secondary server. Question: Can I do my backups by only running them on the secondary server? I haven't done this before, and 1 question popp…
HDR & backups
Informix 9.30 Solaris 8 We are planning to do the following: Have a primary server, and then use HDR to replicate this server onto a secondary server. Question: Can I do my backups by only running them on the secondary server? I haven't done this before, and 1 question popp…
Re: Clarification on ONBAR restore.....
You could try using HDR - once the level 0 has been restored to the new server (physical restore only) initiate HDR. All logged activity will be replicated to the new server. Once you are happy with the new server, switch it to standard mode, point the users at it, and then you c…
Restarting HDR
I know i've asked everything there was to this but here's some more. My server is set up for 20 logical log files. Assume the uniq ids are also from 1 to 20. I backed up my instance yesterday night and it has logical logs 14 and 15. I will restore it on the secondary today nigh…
hdr hang
Hello, ids 9.30uc1 on unixware 7.x. hdr seems to be hang when checkpoint increase on my secondary server (>200). I increase drtimeout on primary to the maximum checkpoint value. It doesn't solve the problem. hdr need to be stop an restart frequently. Any possible tuning and moni…
HDR sites
Hi, Did anyone affected by the blackout have the secondary outside of the blackout area?…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
HDR , logs
Hi all, (linux, 940UC2) cause of batchjob problems I have to disable HDR during job. The batch job needs ~45 logs with 10 MB, what is the better way, increas size of logs to 20MB or increase logs to 100, I have 50 logs! Thanks Sven…
HDR
Hi, I have an async HDR running under 940UC2 and linux! Wenn I am running a batchjob, a lot of tables are created and some indicies and so on, there is always a DR: Send error created, and some indicies are not transfered to secondary, and because of that some locks not disapear,…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
hdr installation
Hi all, I have to identical Severs on Linux and INF940UC2! both have two NIC 1x global LAN, 1x HDR LAN(direct LINK) with user informix I am able to connect from each of them to the other with no password. after HDR restore an the secondary the HDR won't establish. What is wr…
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…
replication
Hi, Check the last couple of checkpoints on the primary and secondary servers - they should be within seconds of each other (assuming the clocks on the two boxes are in sync). HTH -- Phil@oninit.com…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
RE: is hdr on?
Not to worry, Alex. The "Last DR Ckpt" discrepancy is a "cosmetic" bug in some versions. Can't remember the bug number, but it is fixed in later versions. What you see in the message logs confirms that HDR is still running. The "server operational" messages are the keys. HTH…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Re: is hdr on?
Thanks for reply. This is a message log fragment. As if hdr on? --------------------------------------------------------------------------- server1: 12:12:50 Informix Dynamic Server Initialized -- Shared Memory Initialized. 12:12:50 DR: Logs already cleared 12:12:50 DR: Try…
is hdr on?
Hi ! I have 2 Informix servers (7.31UC7) with HDR - server1 and server2. Is HDR on? --------------------------------------------------------------------------- server1: [informix@server1]$onstat -g dri Informix Dynamic Server Version 7.31.UC7 -- On-Line (Prim) -- Up 23 day…
Re: secondary server
The engine won't let you! The secondary is already in effect a backup of the primary, plus you are taking Level 0 archives of the primary (aren't you?). A level 0 of the secondary will serve no purpose. f.abelli <f.abelli@corsicaferries.com> wrote in message news:bb7vid$6o744$1…
HDR questions
We're running IDS versions 9.21.UC5 and 9.30.UC3, both on Sun Solaris = 2.8 We currently use "smart-blob" dbspaces (sbspace) for xml data storage. = Does HDR support sbspaces? Terrence Mullins Sr Database Administrator WagerWorks.com…
secondary server
hi, i'm using HDR with Aix5.1 and IFX 7.31 i want to make Level 0 backups on the secondary server. can i do it ???…
Informix Disaster Recovery Strategy
All, Thanks for the input. It looks like HDR is the way to go. We have a fairly flexible recovery period and most of the data is entered data enry staff. Now I just need to figure out how to implement HDR.…
hdr not working
Hi, We have a HDR setup here. We rebooted the secondary server and then we could no longer make the HDR work. The error message in the primary server is: 19:18:36 DR: Failure recovery error (2) 19:18:37 DR: Turned off on primary server 19:18:38 Checkpoint Completed: duration was…
Question
The simplest workaround is to move your blob data into a dbspace. Rudy Arnel CUETO <acueto@apme-ops.dhl.com> wrote in message > We have set-up, and are currently testing, our Informix > High-Availabilty Data Replication using two servers (primary and > secondary). So far, w…
Replication
We are considering using some method of data replication/failover. Some of the options we have considered are Informix Enterprise Replication, Informix Data Replication, Legato, and Veritas. I would like to hear from users with experience on any of those methods regarding the ea…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Data replication
Does anyone have experience with data replication? Specifically data replication using asynchronous replication? Sent via Deja.com http://www.deja.com/ Before you buy.…
Informix Data Replication
Has anyone used Informix Data Replication extensively? I work for a corporation who is considering using this Informix product and would like to find out specifically, how agent uses the logs to replicate and also and overhead or speed issues related to it's use. thanks Sent vi…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Replication 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…
data replication
After running secondary server with ontape -p and onmode -d secondary xxx, i receive following message in message log: 05:11:59 Process exited with return code 134: /bin/sh /bin/sh -c /inf/bin/ infxalrm 2 15 "Data Replication failure." "DR: Secondary server operational" what do…
RE: replication
Check out High-availability Data Replication (HDR) in chapters 29-30 in the Administrator's Guide, or look at the chapters "What is Data Replication?" and "Using Data Replication" at http://www.informix.com/answers/oldsite/answers/pubs/pdf/7862b.pdf HTH, Paul Mosser -----Origin…
Re: informix replication
From: bmccready@my-deja.com > >Has anyone used Informix replication to replicate data between remote >sites? Not personally. >Is it very difficult? Does it require other software for example with >Sybase >you need to use their Replication Server if you want to do hot standby >…
informix replication
Has anyone used Informix replication to replicate data between remote sites? Is it very difficult? Does it require other software for example with Sybase you need to use their Replication Server if you want to do hot standby replication. Any information on Informix's replicatio…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Datareplication: resync of secondary server very slow
Hi, We have installed data replication with Workgroup Server 7.31.UC5. We simulated a secondary server failure, continuing work on the primary until the logical logs had to be backed up (all logs full, ontape - c). After some time we restarted the secondary. It asked for the lo…
HDR incremental backups?
Why should only level 0 backups be used with HDR databases and not incremental? Thanks Sue…
Using Secondary Server in Data-Replication (Informix Workgroup server)
I've made an IDS Workgroup Edition 7.31.UC6A to replicate it's contens to another equal Unix/IDS-instance. Setup is made according "Informix-OnLine Dynamic Server"-book and seems to be ok (both Primary and Secondary Servers are up and operational). Databases in Primary Server are…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
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…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Split AIX mirror to bring up HDR replacation
Has anyone split an AIX mirrored VG, to bring up HDR replication. If so what are the steps. -- Kevin H. Hunt khhunt@triplecrownsvc.com…
EDR + SBLOB
Hi guys, as IDS 2000 doesn't support data replication of SBLOB data types, do you have any hints about how to replicate this types of data ? I need SBLOB types 'cause I have to use Excalibur text datablade and I need to have at least 2 servers online for an update-anywhere data…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication and PeopleSoft
Art, It might be worth asking this on the Peoplemix mailing list. > Anyone have any experiences with using HDR or ER with PeopleSoft?…
HDR
Having problems initiating HDR. Platform specifics: IBM RS6000 h70 AIX 4.3.3.0 IDS 2000 9.20.UC3 Archive and Restore accomplished using onbar and the Informix Storage Manager. Problem occurs when trying to restore the archive created from the primary server on the secondary serv…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
SE and Data Replication
Greeting. Does anyone know if any version of SE supports data replication? Thanks, Dick Brieck…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
IDS replication Solaris->Linux
Madison Pruet <mpruet@informix.com> wrote in message news:38B1A9B9.9183BF5D@informix.com... > ER can be used between solaris and Linux, HDR will not work. What's "ER"? Sorry to be a thicko, but I've only heard of CDR and HDR - and I know that I can't use CDR because of the seri…
System catalogue
Sounds like HDR to me. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!…
Data Replication
I want to start Data Replication between Informix IDS 7.3 on AIX 4.0 and Informix IDS 7.3 on Windows NT 4.0. Please provide me details to perform DR. Any kown issue about these DR is also welcome. I will appreciate an early feedback, please. Sent via Deja.com http://www.deja.co…
Data Replication
I want to start Data Replication between Informix IDS 7.3 on AIX 4.0 and Informix IDS 7.3 on Windows NT 4.0. Please provide me details to perform DR. Any kown issue about these DR is also welcome. I will appreciate an early feedback, please. Sent via Deja.com http://www.deja.co…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
temporary
The secondary in a HDR setup will let you create implicit temp tables. -- Kevin H. Hunt khhunt@hunts.com…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
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…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Replications in OWS 7.31
I have OnLine Workgroup Server 7.31 with a data replication. I have application (stored procedure) on the secondary server. When secondary server starts updating during executing the application I receives incorrect data. Can the application see that the secondary database serve…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Ontape on secondary server
We have a HDR replication between two IBM RS6000 server running AIX 4.3.2. The server version is IDS 7.30. When I log on as user informix and run ontape -s on the secondary server I get the following error message:- "server is in a incompatible state or user authentication faile…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
RE: Replication setup on NT platform
Are there messages in any of the Informix messages logs? What message do you get when you replicate the "wrong" way? It sound like one half of the security to allow access is not configured or half of the replication? (Security in the Domain controllers). Murray Wood -----Orig…
Replication setup on NT platform
Hi everyone, Currently our development is trying to setup a replication between two NT 4.0 (Service-pack 3) servers in different domains. The database version that installed on these two machines are 7.30 TC7. We have found that there is no problem replication data between two …
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Replication to MySQL
We are considering using MySQL as a read-only platform accessible through the Web. Can anyone tell me if the Informix replicator is able to replicate subsets of data to MySQL? Thank you…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
IDS 7.30 Linux ed. - Unpleasant surprise
Hi! I planned to use IDS 7.30 Linux ed. with HDR. But after unsuccessful try to install it I discovered in release notes that replications in IDS 7.30 Linux ed. are not supported at all. (oh, yes for $99 can I expect HDR!?) Any idea when (and if at all) will be replications sup…
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…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
RE: 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
There are two supported methods of replication with IDS, HDR (High Avaliability Data Replication) and ER (Enterprise Replication). ER is sometimes also called CDR (Contineous Data Replication). Basically the difference between the two is that HDR replicates a mirror image betwe…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
RE: high availability data replication examples??
Whoa -- the $INFORMIXDIR/demo/cdrapi programs are for ER (Enterprise Replication), also know as CDR (Continuous Data Replication). This relatively new type of replication is completely different from the older HDR (High-availability Data Replication). The best place to find out…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
? on DATA REPLICATION
Hi there !! I have couple of questions for new DATA REPLICATION site here... 1> Do I really need to have mirrored chunks in DR ? 2> Do I really need to have mirrored chunks on Secondary server ?? Thanks in advacne Girish -----------== Posted via Deja News, The Discussion Ne…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Transparent data recovery...
I was wondering if anyone has found a good solution for a client-transparent automatic fail over to a secondary server if the primary goes down and back again. We are currently using HDR, but while the secondary database assumes the primary role, there is no means for the client…
Re: Informix RDBMS & Replication
Infodata wrote: > > Dear Folks, > > We want to use replication feature of Informix RDBMS. > > Can anyone give their opinion about this feature? > > Does Informix supports bi-directional replication also? Anybody tried it? > > For two Informix engines, do we need same version and …
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
Re: Replication w/ Workgroup edition
Hi, I think Workgroup Replication (IDS-Workgroup Edition replication) works only in one direction (from dbserver machines to the central server) and in this case the central server must be an IDS (not workgroup) that supports Enterprise Replication. The configuration you want mus…
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Re: Replication of limited data
jfanders@my-dejanews.com wrote: > > I have a need to replicate limited data changes that occur in a database to a > second database. The two databases reside on the same machine. For example > when 100 of the 500 tables in database "A" change (through an update, insert, > or de…
Re: Replication of limited data
>I have a need to replicate limited data changes that occur in a database to a >second database. The two databases reside on the same machine. For example >when 100 of the 500 tables in database "A" change (through an update, insert, >or delete) I would like to replicate those …
Replication of limited data
I have a need to replicate limited data changes that occur in a database to a second database. The two databases reside on the same machine. For example when 100 of the 500 tables in database "A" change (through an update, insert, or delete) I would like to replicate those chan…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Data-Replication... anyone?
Good morning group :> In the company I work for there are currently 5 Informix servers doing data replication on some tables using Informix CDR. Introducing a 6th server in (IMHO) exactly the same way leads to the following problem: The new server can replicated data with 4 of…
HDR
Hi I am trying to establish HDR between to of my 7.23UC7 Informix servers. I can connect the primary to the secondary vice versa, but my secondary server is sleeping forever on recovery. Following are the outputs from the 2 servers: Primary: 10:28:03 DR: new type = primary, se…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Data replication and 3rd party Storage Manager
I would to hear from anyone who is using Data Replication and 3rd party storage manager software. Would like discuss problems and how to tackle them. Thanks in advance. Nilesh Kunvarji…
Data Replication
We are in the process of setting up a system which will consist of 19 seperate sites connected through Frame Relay. Each of these sites will have an Informix SE Database which we need to keep synchronized with all the other sites. The way we would like to synchronize the databa…
Re: Replication
On 26 Jan 1998 13:28:09 -0500, Craig.Lanford@alltel.com wrote: Guys, I have played with this and it works. In one place in the manual it says you have to start all over again. Then in another place it says you can switch the backup server back to secondary. (Yes Art, I have to…
Re: Replication
>Hi, >i am working with SCO Open Server 5.0 and OnLine DS 7.22 UC2. >One Server (Server A) is my primary Server, the othe (Server B) is the >secondary Server. Replication works well, but after stopping Server A >with "onmode -ky", i have problems with my secondary Server: >1. O…
Replication
Hi, i am working with SCO Open Server 5.0 and OnLine DS 7.22 UC2. One Server (Server A) is my primary Server, the othe (Server B) is the secondary Server. Replication works well, but after stopping Server A with "onmode -ky", i have problems with my secondary Server: 1. On the …
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
Replication setup problem
Hi, secondary server hangs in Recovery Mode! We have ODS 7.22 UC2 on both machines, and SCO 5.0 All Things are identical and we start with 1. an archive Levele 0 on machine A (the primary server). 2. on machine A: Log.Log Backup 3. on machine A: onmode -d primary machine_b 4. …
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
HDR
Recently we encountered a similar problem. Our primary DB was running on an HP K9000 (120Mhz) and secondary DB on an HP K9000 (180Mhz). After many OS upgrades (recommended by Informix support), the problem was still not resolved. We then moved the primary DB to an HP K9000 (180…
HDR
I have a question about HDR on the Informix online workgroup server for Unix v. 7.12 (irix). We have completed the preliminary tasks -- Both machines are O2s running Irix 6.3, We replicated chunks and dataspaces identically on the second machine, assigned a temp dbspace on both …
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Replication on INFORMIX ?
Clem Akins wrote: > > Bharat asks: > [...] > my quez are : (as seen at page 236, Unleashed Informix by John Mc.Nally, > Glenn Miller, SAMS Publishing) > [...] > >do we need this .... I mean actually this is a mirroring ... not a > >replication enginee ... right? > > Had you bough…
Re: Data Replication
Few things I've done or noticed (online 7.11uc1 for Solaris 2.4) 1.- you might want to get a separate nic for the servers just for DR and have them on their own little hub (or just attach them directly to each other). A few times somebody wants to copy files from one server to…
Re: Data Replication
On 29 Oct 1997 11:38:19 -0500, dotto@themoneystore.com (Dave Otto) wrote: > Has or is anybody using data replication, either as a disaster recovery option, > or as a development if so could you please send me details on comms used > and performance of the primary server, are you…
FW: Data Replication
} -----Original Message----- } From: Peter Abbott } Sent: 29 October 1997 16:58 } To: 'Dave Otto' } Subject: RE: Data Replication } } We are currently using OnLine V7.23 on a Sequent Symmetry 2000 } dynix/ptx 4.0 } } } -----Original Message----- } From: Dave Otto [SMTP:dotto@them…
Re: Data Replication
Informix version, H/W, O/S version, (optionally) target please... -d At 15:23 10/29/97 +0000, Peter Abbott wrote: } } }Dear all } }Has or is anybody using data replication, either as a disaster recovery }option, or as a development }if so could you please send me details on com…
Data Replication
Dear all Has or is anybody using data replication, either as a disaster recovery option, or as a development if so could you please send me details on comms used and performance of the primary server, are you using synchronous or asynchronous, was is difficult to set up etc Th…
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…
Re: Enterprise Replication
> implemented Enterprise Replication. then I have a question. > >The question is .. what is role of 'cdragt', 'onsrvapd', 'snmpdm'? > >I thought that above each deamon must exist for data replication. > >but, I removed each deamon('cdragt', 'onsrvapd', 'snmpdm') using command >'k…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Replication
Hi, This is regarding the data replication query by m.l.wilson. CDR supports only with Informix DSA v7.22 and above. It is pretty good with horizontal and vertical sub-set replications. It also got a Windows NT replication manager to work with though the command line option is …
Data Replication & Service Guard
All, Scenario Server1 is running and is replicated on Server3. Server1 crashes and due to having Service Guard software in place immediately switches to Server2. Server two should then sync with Server3 leaving us in the same state as we were before any failures. However the …
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Data replication configuration
In earlier versions, at least, onstat -g dri as a status line at the beginning which indicates Online(Prim.) if the server is running or attempting data replication. That and the description of the Paired server should indicate whether you have Replication that is off or that it…
Re: Data replication configuration
Jean-Francois wrote: > Hello, Hi, > > I am working on online 7.13 and I would like to monitor data replication. > > I know system tables sysdri and sysdrcb but I am looking for the place > where is stored if data replication is set or not. > > In fact, onstat -g dri gives the …
Data replication configuration
Hello, I am working on online 7.13 and I would like to monitor data replication. I know system tables sysdri and sysdrcb but I am looking for the place where is stored if data replication is set or not. In fact, onstat -g dri gives the same piece of information if data replica…
Re: Replication for Archiving ? Is it possible ?
In article <337c4ef6.10528509@ct-news.iafrica.com>, Henry <henryk@mda.co.za> writes >Many log-based data replication systems allow to select, on per-table >basis, transaction types replicated to other databases. This can be >used as a vehicle to implement an archiving facility w…
Replication for Archiving ? Is it possible ?
Many log-based data replication systems allow to select, on per-table basis, transaction types replicated to other databases. This can be used as a vehicle to implement an archiving facility where all inserts and updates are replicated, but the deletes are not. In that way a sm…
Re: Data Replication Implementation
Hi, Upgrading to ODS ver 7.22 should do the trick ... It has replication features that even span different platforms Hope this helps, Zandy…
Re: Data Replication Implementation
datamas wrote: } } At 10:29 24/04/97 -0400, you wrote: } >datamas wrote: } >> } >> Hi Friends, } >> } >> I am having two HP machines } >> } >> 1. HP K200-Production System, Dual Processor, 196 MB RAM } >> } >> 2. HP 827-Disaster Recovery System, Single Processor, 128 MB RAM } >> …
Re: Data Replication Implementation
In article <5jn3qp$bet@cssun.mathcs.emory.edu>, datamas@kuwait.net (datamas) wrote: > > Hi Friends, > > I am having two HP machines > > 1. HP K200-Production System, Dual Processor, 196 MB RAM > > 2. HP 827-Disaster Recovery System, Single Processor, 128 MB RAM > > By any chanc…
Re: Data Replication Implementation
datamas wrote: > > Hi Friends, > > I am having two HP machines > > 1. HP K200-Production System, Dual Processor, 196 MB RAM > > 2. HP 827-Disaster Recovery System, Single Processor, 128 MB RAM > > By any chance is it possible to go for Data Replication. Informix ver is 7.x > DSA …
Re: Data Replication Implementation
datamas wrote: } } Hi Friends, } } I am having two HP machines } } 1. HP K200-Production System, Dual Processor, 196 MB RAM } } 2. HP 827-Disaster Recovery System, Single Processor, 128 MB RAM } } By any chance is it possible to go for Data Replication. Informix ver is 7.x } DSA …
Data Replication Implementation
Hi Friends, I am having two HP machines 1. HP K200-Production System, Dual Processor, 196 MB RAM 2. HP 827-Disaster Recovery System, Single Processor, 128 MB RAM By any chance is it possible to go for Data Replication. Informix ver is 7.x DSA on both the machines and O/S is a…
Data Replication with INFORMIX Databases
We need to design a Data Replication system between our Informix Databases. The best product that we have found in the software market has been OmniReplicator by Praxis International, but it doesn't support our platforms and versions of Unix and Informix. We have Intel-platforms…
Re: Ingress - Informix replication
Baskaran Aluru wrote: > > Does anybody know any good tools for Ingress to Informix data replication? > > Thanks in advance. Praxis International and their product OmniEnterprise will provide master/slave replication for this pair of products I think. Give their WEB site a look. …
Ingress - Informix replication
Does anybody know any good tools for Ingress to Informix data replication? Thanks in advance.…
Continous data replication.
Some time ago, I heard about something called Continous Data Replication (CDR), a concept for geographically distributed databases to maintain integrity over a (reasonably) low bandwidth network. In version 7.20, there is something called HDR (High-availability Data Replication),…
Data replication 7.20UC1
Hello everyone, We started to experiment a little with data replication using two online 7.20 UC.1 servers. Just standard replication with a primary and secondary server that are identical. We are experiencing two problems: - checkpoints do become very long every once and a whil…
RE: Continuous Data Replication
Has anyone been able to get CDR to work on a HP box. We are running HPUX 10.10 and are not able to get the Rep Manager to create the syscdr database? Has anyone had a similar experience? TIA S. Valiente DBA TNT Australia Ltd…
Re: Data Replication ? Diff between CDR and current replication
On 24 Jan 97 at 15:35, Manickam R Muthukumar wrote: > What will be the difference between the > current Informix data replication and upcoming > (hopefully very soon) Continuous Data > Replication(CDR). What are the > advantages/disadvantages and how easy/difficult to > configu…
Replication Tool for Informix ?
Hey folks, I need some information about existing tools or conceptional solutions for asynchronous replication of (parts of) Databases under Informix Online 7.10. Information about solutions on other RDBMSs (Oracle, DB2, Sybase, SQLServer etc.) is also very welcome! I've heard …
Informix Version 7.20.UC3 Upgrade Question
I have two questions: Is anyone having any problems with this version on HP-UX 10.10? And second, Is anyone (reguardless of platform) using this version with data replication? Your responses are deeply appreciated. David Pavao Wall Data Inc.…
Re: Oracle vs Informix comparison
You wrote: > >In article <589udr$mgk@svna0001.clipper.ssb.com>, Stephen A Tahmosh ><tahmossx@itd.ssb.com> writes >>Why is replication off of the logs automatically better than that provided via >>stored procedures and triggers? >>All data (almost) is logged - not all data is repl…
Re: Data Replication Delay
I experience this same problem on two HP9000 H60 running 7.12.UC1. Under certain conditions (depends on your application), DR can hang. To be specific, we use our secondary server as an online-querying engine for reports/users, and when long queries were performed, DR's priorit…
Data Replication Delay
System: HP9000 K200 512MB Memory 400MB Swap Space 20 Gig Disk Informix: Online Version 7.12.UC1 We have two of the above systems, one is the primary server and the other is the secondary server. Our checkpoints occur ever 5 minutes and take 0 seconds (occas…
Re: Oracle vs Informix comparison
Actually what really happens in Oracle replication is: 1. Application updates one table. 2. Trigger fires to record the fact that some replication will need to be done. 3. Application commits and end user happily continues work. At some point in time after the application commi…
Re: Oracle vs Informix comparison
On 6 Dec 96 at 20:08, Stephen A Tahmosh wrote: > Why is replication off of the logs automatically better than that provided via stored procedures and triggers? > All data (almost) is logged - not all data is replicated (usually). > Triggers/Stored Procedures can be defined only…
Re: Oracle vs Informix comparison
In article <589udr$mgk@svna0001.clipper.ssb.com>, Stephen A Tahmosh <tahmossx@itd.ssb.com> writes >Why is replication off of the logs automatically better than that provided via >stored procedures and triggers? >All data (almost) is logged - not all data is replicated (usually). …
Secondary getting slower
We are running Informix 7.13 online on an HP 9000/K400 with HP-UX10.01. We use data replication. We using primary as the production environment and the secondary as the report server to make some reports. But as a period of time, secondary getting slower and slower. Each time…
Re: Data Replication problem
Jerry Tan wrote: > > Hi, > I am using 7.10.UD2 on DG AviiON 8500 with DG/UX > to run data replication. If I shutdown both servers and turn them on > later. Do I need re-setup data replication again? > > Could everyone help me? Thanks! > > -----------------------…
Re: Data Replication problem
Jerry Tan wrote: > > Hi, > I am using 7.10.UD2 on DG AviiON 8500 with DG/UX > to run data replication. If I shutdown both servers and turn them on > later. Do I need re-setup data replication again? > > Could everyone help me? Thanks! > > -----------------------…
Data Replication problem
Hi, I am using 7.10.UD2 on DG AviiON 8500 with DG/UX to run data replication. If I shutdown both servers and turn them on later. Do I need re-setup data replication again? Could everyone help me? Thanks! ----------------------------------------------------------------------…
Re: INFORMIX Data Replication
Kevin Fortenberry wrote: > > Is anyone using INFORMIX's Data Replication in production or have done > some extensive testing on this matter. I'm using INFORMIX DSA 7.13 on > Digital UNIX 3.2D in a development environment. I'm about to start > testing this feature, but would app…
INFORMIX Data Replication
Is anyone using INFORMIX's Data Replication in production or have done some extensive testing on this matter. I'm using INFORMIX DSA 7.13 on Digital UNIX 3.2D in a development environment. I'm about to start testing this feature, but would appreciate some pointers,info,experien…
Re: Data Replication
Juan R. Guzman wrote: > > Srinivas Reddy wrote: > > > > Hi, > > > > ... > > As I mentioned in the beginning I am using 7.20 UC2 on HP K400 with HP-UX > > 10.10 I do not have any problems. ( I still have a problem, that is, I can > > not run any commands like 'dbschema', 'dbexpor…
Re: Data Replication
Hi, As every one know in this world, I am still waiting for a reply from informix gurus ( are you listening ?). I got some guesses, but I do not wanted any guessess. What ever they guess, I want them to make it as informix stand on this issue. WAIT AND SEE. As soon as I get som…
Re: Data Replication
Srinivas Reddy wrote: > > Hi, > > ... > As I mentioned in the beginning I am using 7.20 UC2 on HP K400 with HP-UX > 10.10 I do not have any problems. ( I still have a problem, that is, I can > not run any commands like 'dbschema', 'dbexport' on secondary while HDR > is on, talki…
Re: Data Replication
Hi, Please correct me if I am wrong, > When you take down the primary server and want to make the secondary server > standard, it is possible. Here is how you do it. > 1. Take your primary down. > 2. Secondary recieves a DR Error, but stays on-line. This will be in Re…
Re: Data Replication
Hi, It looks like I made the assumption that you are using 'auto' switchover. If you are using Manual you need to turn the secondary to standard manually. Sometimes, for unknown reasons, it fails. You restore the secondary and repeat the above steps it works fine. ( I could not…
Re: Data Replication
Hi, The very first thing is it is not DHR. It should be HDR (High-availability Data Replication). (assuming it is a typo). We are using HDR still in development and test environment. H/W -- HP K400s with HP-UX 10.10 Informix --- OL 7.20 1. When primary goes down (or you bri…
Re: Data Replication
pjhaveri wrote: > > Hi, > Sorry for late reply. I am using 7.11UC2. We are testing replication. > It is DHR. And asysnchronous mode. > > - I was trying to test if primary goes down, whether I can use seconadry as a > standard server and when primary is up, whether I can change s…
Re: Data Replication
Hi, Sorry for late reply. I am using 7.11UC2. We are testing replication. It is DHR. And asysnchronous mode. - I was trying to test if primary goes down, whether I can use seconadry as a standard server and when primary is up, whether I can change seconadry-which was standard t…
Re: Data Replication
pjhaveri wrote: > > Hi, > > We are trying Replication between 2 cities. I wanted some information about > this. Anyone is using replication, what are the problems you have faced. And > what type synchronous or asynchronous mode is preferable ? > > your input would be greatly app…
Re: Data Replication
Hi, Which replication you are planning to use ? i.e. is it HDR or CDR ? It must be HDR ( CDR is still in beta. Informix: Is this correct ?). The basic requirements are; 1. The h/w, OS and informix ver. should be identical on both the machines. 2. You should have reliable networ…
Data Replication
Hi, We are trying Replication between 2 cities. I wanted some information about this. Anyone is using replication, what are the problems you have faced. And what type synchronous or asynchronous mode is preferable ? your input would be greatly appreciated! Thanks and Regards,…
DATA REPLICATION After a Failure
Hi, Informix DSA Ver 7.11 UC2. We are trying Data Replication. If Primary server fails we need to follow following steps to restart Replication. Steps discussed in I-On-line Dynamic Server Admin. guide (V 7.1) for Restarting Data Replication after critical media failure on the …
DATA REPLICATION After a Failure
Hi, Steps discussed in I-On-line Dynamic Server Admin. guide (V 7.1) for Restarting Data Replication after critical media failure on the primary database server when DRAUTO = 0 are as follows : 1. The original secondary database server was changed to a standard server, Bring th…
Data replication
Has anyone tried it with Workgroup Server 7.x for Windows NT? I need the same server to be both publisher and subscriber. Is it = possible? Thanks in advance, --=20 Pedro Proen=E7a =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=…
Re: Data Replication
Brian Hampson wrote: > > We are about to change hardware platforms for our UNIX (same OS, just > Intel, instead of 88K), and are considering letting Informix do the hard > work for us. Could we use DATA replication from the DB on one platform > to effectively CREATE the DB on th…
Data Replication
We are about to change hardware platforms for our UNIX (same OS, just Intel, instead of 88K), and are considering letting Informix do the hard work for us. Could we use DATA replication from the DB on one platform to effectively CREATE the DB on the other platform, and hence avo…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Data Replication
Juan R. Guzman wrote: > As for problems, I've only encountered two. We do a dbexport every night on the > secondary machine and once in a while Informix corrupts a date on a record. I > know this because the dbexport complains about the date format and then we have > to reinit…
Re: Data Replication
DM Rao wrote: > > Hai, > Did anybody implement Informix's Data Replication?. > Are there any special considerations I need to take for setup?. > Are there any pitfalls or loopholes or drawbacks with this product ?. > > Please throw some light on the above queries. > > Thanks in a…
Re: Data Replication
Please include me in on this response Thanks!!!!!! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov OR …
Data Replication
Hai, Did anybody implement Informix's Data Replication?. Are there any special considerations I need to take for setup?. Are there any pitfalls or loopholes or drawbacks with this product ?. Please throw some light on the above queries. Thanks in advance DM…
Secondary Server gets stucked during Replication
Has anybody encountered the following problem with data replication. When we have a very high load on a primary server, the secondary server starts using almost 100% of the CPU. Eventually the primary server decides that the replication is down and continues…
Re: Data replication = Fault Tolerance?
Hi, I have used data replicaiton features in 7.1 version. U should set up the servers in REVERSE_TYPE mode. This will ensure that the secondary becomes primary( or standard ) when your primary server goes down. The secondary becomes primary after the primary transferrs the logi…
Data replication = Fault Tolerance?
Hi all. We use Informix Online (soon to be 7.1) and are interested in fault tolerant systems. We already intend to mirror our disks at the Unix level, but would also like a primary / secondary system setup whereby if, for example a processor board or memory chip blows up, then …
Re:Informix's Data Replication Policy
You can find details of the Informix replication offerings in a white paper published by Informix. It is available on the internet. http://www.informix.com/informix/corpinfo/zines/whitpprs/datarep/datarep.htm On 20 Mar 1996, Daniel Carbajal wrote: > And somebody detail the Dat…
DataMirror Launches New Transformational Replication Website
DataMirror Corporation is unveiling its home on the Internet. The company is a Toronto, Canada based developer of software focused on the problems of data replication across heterogeneous hardware and database platforms. It produces DataMirror/400, an intelligent, transformation…
Re: Data Replication
Melvin Mariney wrote: > If I understand your question, I believe you are asking if you can > make the secondary server the primary when the original primary has > crashed and the answer is yes. There are three parameters in 7.1 HDR > that controls what happens when a the primary…
Re: Data Replication
scheer@stadt-mh.de (Dirch Scheer) wrote: >Hi Bill, >is it possible to make the secondary server to the primary after the primary >server had crashed. Is it very difficult to switch the secondary server? >We want to use replication to make our databases more reliable. The server…
Re: Data Replication
In article <4i0jni$8e1@news.informix.com>, glidden@informix.com (Bill Glidden) wrote: >Tamara Winburn (tamara@shop.internet.net) wrote: > >: Assuming that there is a defined PRIMARY and a SECONDARY my question is this. > >: Knowing that the two machines are always syncing to e…
Informix's Data Replication Policy
Could somebody (preferably somebody from Informix) tell me what Informix's official policy regarding hardware and software setup should be when it comes to DR. At first informix told us it was same hardware and same OS (this is when Online 7.10 first came out) no ifs, ands or bu…
Re: Data Replication
Tamara, OmniReplicator from Praxis supports bidirectional replication between Informix databases (plus a few others). See our web page: www.praxisint.com James…
Re: Data Replication
Tamara Winburn (tamara@shop.internet.net) wrote: : Assuming that there is a defined PRIMARY and a SECONDARY my question is this. : Knowing that the two machines are always syncing to each other, data : inserted from users on the net into the PRIMARY database/server will sync to…
Data Replication
TGIF, everyone! I will be attempting soon to setup two servers, a PRIMARY and a SECONDARY that will replicate each other. To be honest, have no idea where to start, so I thought I would start with the vast majority. I have two Solaris 2.5 machines that at this time are running …
REPLICATION SERVER
REPLICATION SERVER ******************** Few months ago we had posted a news about out Global Replication server that replicates data among hetrogeneous databases online and real time maintainig transactional consistency an…
Re: Data Replication
Sanjay, Sorry, I can't actually help you, but with 18 posts to cdi I'd say you've got data replication pretty well covered :-) In article <4enc4b$8fp@cssun.mathcs.emory.edu>, SOHO!dpsanjay@whitestone.raileurope.com (Sanjay Kumar) wrote: > >We r trying to implement the data repl…
Re: Data Replication
In article <4enfu7$b99@cssun.mathcs.emory.edu> SOHO!dpsanjay@whitestone.raileurope.com (Sanjay Kumar) writes: You seem to be pretty good at data replication, was it 17 of the same messages or 16??? >Path: aztec.co.za!iafrica.com!pipex-sa.net!plug.news.pipex.net!pipex!nielsen.co…
Data Replication
We are running 7.11UC1 on DEC Alpha machine. Recently, we tried to build a test client application which uses the data replication features. It tries to reconnect the database in case of an error. We keep getting the error 25580. Any ideas or suggestions are welcome. Thanx ___…
Data Replication
We are running 7.11UC1 on DEC Alpha machine. Recently, we tried to build a test client application which uses the data replication features. It tries to reconnect the database in case of an error. We keep getting the error 25580. Any ideas or suggestions are welcome. Thanx ___…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a lot …
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Data Replication
We r trying to implement the data replication in our client applications. Can someone please send me the sample code ( calling and called functions ) to do it ? I am not sure what to check for before calling the function which "reconnects" to the secondary server. Thanx a…
Re: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)
heabrujac@aol.com (Heabrujac) wrote: >I have worked with both Sybase's and Oracle's replication methods. And >replicate data can become inconsistent with both systems. Oracle uses a >set of deferred transaction tables and job queues. The two phase commit >ensures delivery of …
Re: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)
I have worked with both Sybase's and Oracle's replication methods. And replicate data can become inconsistent with both systems. Oracle uses a set of deferred transaction tables and job queues. The two phase commit ensures delivery of a deferred transaction to a replicate site…
Data Replication
We r planning to implement the data replication strategy in our client applications. I would appreciate any and every kind of feeback on this issue. Thanx ____________ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. 226 Westchester Ave | Office : (914) 681 32…
Data Replication under Solaris
I am currently investigating setting up data replication under Solaris 2.4 and Informix 7.11. Has anybody done this successfully? Has anybody got any advice? Paul Watson International Factors Ltd…
Data Replication .....
We are trying to setup data replication between two sparc systems running Online 7.10 over a slow link (56KB) between New York & Hong Kong. What happens is that the primary server locks up from time to time which I presume is due to the log writes ( we are using unbuffered loggin…
ESQL & Data Replication
I am trying to determine the necessary steps I need to make to switch over from a primary to secondary database within my dynamic ESQL (C) code. I use INFORMIXSERVER environment variable for the primary, and DBPATH for secondary. What error codes return when a switch over occur…
Question on data base replication
I am considering the use of data base replication facilities to bring multiple data bases at different physical locations consistent. It would be very much appreciated that anyone can advise me whether it is reliable and with good performance to make use of this facility for my …
Re: Continuous Data Replication
Hi, Continuous Data Replication (CDR) is not currently available according to Informix it will be due Q2 of 96. At the Informix User Conference Gary Kelley spoke on HDR and their future product (CDR).…
Continuous Data Replication
Does anyone know if Informix can support this? -- Graeme Burnett PGP Mail preferred D50459D9 Key on public keyserver. 08 D1 34 87 6E 35 C8 BB D7 C6 BC CE 6B 03 2F 26…
Re: Replication and Locks
I don't know what you have been reading but I replicate tables on numerous data warehouses under oracle and have none of the problems you identify. Look in the oracle server admin guide under SNAPSHOTS! The trigger is there for you already (I dont have thousands of triggers), i…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
Re: Replication and Locks
With Sybase Replication Server there are no locks aquired. The Sybase Replication Server reads the transaction log with a process called the Log Transaction Manager (LTM). The LTM then sends the "atomic" transaction to the Replication Server process which then sends it to the r…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Replication and Locks
Can anybody post information on replication servers? What is the exact purpose of these servers: Is it for performance, or for recovery incase of a crash? In our current project we plan to use replication servers for performance ie. Data will be accessed simultaneously from these…
data replication
In reply to Mr Bill Stackhouse <sbill@informix.com>: [ confirmation of replication service not being able to work across platforms with different byte orderings ] Thanks Bill. But I regret to say that restriction is fatal in our case ;( > We to provied transaltion of datastr…
data replication
Hello Informixers, We have a DG AViiON running DG/UX and a 486 running SCO/UNIX. Informix 5.x runs on both platforms. We want the 486 to serve as a fall back when the AViiON fails. How can we do it? I tried restoring a set of db archive + logical logs saved on the AViiON o…
Discrete Data Replication
Subject: Discrete Data Replication Newsgroups: comp.databases.informix Summary: Keywords: I am looking for detailed, technical information about the type of replication in OnLine7.1 called "Discrete Data Replication". BTW, I didn't find info on this on the Web server of Informix…
Data replication
Hello, I would like to make my database robust. Currently I am running disk mirroring on Informix5.0. I have in mind using HP Switchover to replicate my servers, but I have no idea as to what is the effect on the database. Do I then still need disk mirroring or would Switchov…
Re: INFORMIX ON-LINE REPLICATION
yoramk@segovia.fcmc.com (Yoram Kochol (Technology Grp)) writes: > Does someone knows anything about the REPLICATION ability of the >ON-LINE engine ? and in detail regarding Ver. 6 / 7 / 7.1 or >even 8. In a nutshell, there are two types of replication for Informix-Online 7.1: …
Data Replication article recently posted
there was a recent article on data replication that was posted but before i could download it, it was deleted... any idea where i can get this article again...? thanks...…
HDR and Blobs
IDS 9.4 on HP-UX 11.11 We have been trying to get HDR running, and we have blobs located in blob pages. The following pages from the Admin Guide make it clear that blobs in blob pages will not be replicated. It does not seem to say that you can't use HDR, simply that the blobs…