Oninit® Archive
Results for “CDR_QDATA_SBSPACE”
myimport Problem
Thanks to a boost from Art, this problem is resolved. I admit i should have realized it myself. The answer is turn off logging in the sbspace: 'onspaces -ch <sbspace> -Df "LOGGING=OFF"' . Then, after successful import, turn it back on. The syntax issues that seem caused by som…
Enterprise Replication
We are starting to set up Enterprise Replication with IDS and IWS 7.30.tc2 on NT 4.0 servers. We had three server participating in our replication scheme and things seemed to be going well, until... I came in after a weekend and the were no humans logged on, but there were 195 …
SBSPACE Chunk error
Hello All, We are working on IDS 14.10 and yesterday we created SBSPACES everything was fine, but we are getting multiple alerts for SBSPACE chunks down.But in real chunks are ONLINE. After SBSPACE Full backup didn't run . I'm sharing the screenshot for related to my Queries. Onc…
SBSPACE
Hello All, Need one suggestion, we are having Informix cluster environment with Primary, Secondary and RSS nodes on IDS14.10 . We have to create a new SBSPACE, as I know we need to make change in ONCONFIG file by adding SBSPACE parameter for new SBSPACE name. So can we do it by u…
Extending chunk capacity
Hi Jose, from your description I'm assuming we're talking raw chunks here, as opposed to file system files? One difference this would make: the extension operation would be much faster as it wouldn't have to "inflate" a file. So the chunk wouldn't be blocked for so long for othe…
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 ------------------------------…
Syncing data using cdr sync
Thank you Paul, good experience, relation of sync and live txn is not clearly documented. Sufficient number of logical logs, CDR_QDATA_SBSPACE a SHM would be a must as well for syncing big databases. Milan Raf Senior Lead, Infrastructure/Cloud Architecture Kyndryl Consult +420 73…
What prevents a RSS to roll forward as fast as its primary?
Hi, So in order of the flow we have: Primary Current Log Page:543836,63218 Next log page to send(log id,page): 543813,121374 Last log page acked(log id,page): 543813,120349 Pending Log Pages to be ACKed: 1032 Approximate Log Page Backlog:3015340 RSS Last log page received(log id,…
Simple Large Object Replication
Hi Juan Luis, in case "not yet decided which kiind of" should also include ER (Enterprise Replication) and they'd decide for that, they could even keep their blobspace blobs. (And ER also supports non-logged smart blobs.) It really depends on what they want to achieve... Andreas…
Is there a way to check the sbspace usage by table?
Hello All, I want to know the usage of sbspace by table. In the case of BLOBspace, it is possible to check the usage for each table with the oncheck -pe command. ---- checking utilization for table using BLOBspace $ dbschema -d testdb -t mycatalog ... create table "informix".myca…
Smart Blob Metadata Queries?
Can anyone let me know how to determine the metadata defaults for an SBSpace in code? I know that I can get that from "onstat -g smb" but I want to be able to query the info using SQL or UDR API functions. Anyone? ------------------------------ Art Kagel -------------------------…
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…
Spaces and Spindles: Thought Experiment
IDS 12.10.FC12 Solaris 10 1/13 Consider a new Informix instance with db/sbspaces (all 1 chunk) as follows: 1) dbspace for the database catalog and data tables; 2) dbspace for indexes (16K pages); 3) sbspace for sblobs (photos-- relatively infrequently accessed); 4) root dbspace …
enumerate contents of sbspace?
IDS 12.10FC12 Solaris 10 1/13 How might it be possible to exhaustively enumerate all objects within a given sbspace? That is, for each object in the specified sbspace, list the database, table, and column which is associated with that object? Thank you. DG…
prevent automatic generation of sbspace
How can I prevent automatic generation of SBSPACE and automatic registration of BTS-Modul ? IDS 12.10.FC12 My Instance has no SBSPACE and no datablade is registered in any database. If a 'normal' user with connect right runs (can be accidental) a SQL-Statement like 'SELECT xxx FR…
Moving SLOB columns to another sbspace
Hello everybody! We want to move several SLOB columns(CLOB-BLOB) from different tables whom reside in a same sbspace to a new sbspace for each table for backup purpose (to launch parallel backups and reduce the time takes the backup), for this goal, we want to know the approxima…
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…
Could not do a physical-order read to fetch next r
I have increased the buffers and set the SHMTOTAL to the nearby by max value. When i rum the oncheck -ce we got an error for sbspace ERROR: Could not obtain lock for Partnum I have ran the onspaces -cl sbspace but the error occurs again.…
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.…
Informix and thin provisioning
Luis, Can you get downtime to run oncheck -cS on just the affected sbspace? [1]https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ib m.adref.doc/ids_adr_0381.htm Luis/Andreas, The documentation above seems wrong, surely it should read as follows " The -cs opt…
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
Beni: Yes, after restoring the primary instance you will need to back up the primary server and restore it to the secondary IDS instance in order to reinitiate HDR. Good luck! Best regards, Martin M. Graney Queues Enforth Development, Inc. This electronic message contains inf…
Smart Large Objects Mystery?
Informix 12.10 Solaris 10 I have been dealing with these things a lot, recently, and there is a lot about them I don't understand. However, I would ask about one thing in this post. Situation: I had an sbspace that was nearly full. With some guidance from this forum and Inform…
Usable space available in an sbspace?
Informix 12.10 Solaris 10 I'm finding it challenging to be working with sblobs and sbspaces. Even the terminology is a bit confusing to me. For example, A BYTE type is a blob, but a BLOB type is not a blob but a smart blob. Or maybe I have that wrong. But, that's a rabbit trail.…
Replace sbspace with larger?
Informix 12.10 Solaris 10 I have an sbspace consisting of one chunk (symbolic link). I would like to replace that drive and make a much larger sbspace (still only one chunk). Will the following work for replacing the sbspace (a "last checkpoint" restore is acceptable): 1) Do a …
sbspace size insufficient after dbexport/dbimport
The page size of the sbspace in both instances is identical. DG…
CDR_QDATA_SBSPACE
Hi, I have a dbspace specified in the CDR_QDATA_SBSPACE. Acoording with the onstat -d command, It has 262144 of space and 113534 of free space. It has ben working about one year with any problem, but in the last 2 weeks, I see the free space has ben reducing drastically My Que…
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)…
ER CDR_QDATA_SBSSPACE
Hi Peter. You can try cdr check paging -R But look for any fixpack, also, and upgrade your 11.50 instances as soon as possible, that should solve your issue quicker. Best regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Informati…
cdr_qdata_sbspace
Aix 5.3 IDS 11.50.fc4 I have ER set up between the above system ... and another system Aix 7.1, IDS 12.1.fc5. On the 11.50 system the dbspace defined by the above parameter continues to grow. Seems as if it's not cleaning things up. On the other system that is part of the ER, it…
oncheck & BTS index
Thanks Mark! That sort of explains what we are seeing -- except that the second running of the oncheck, within minutes of the first, still grabbed a bunch of logical logs even though it should have been a no-op. However, there was no dbspace usage changes, so that seems correct. …
CDR question on big transaction
The blocked state is a signal for the source node not to send any other= transactions until the existing replicated transactions have been processed. It it triggered when 1/2 of the existing receive queue spac= e has been filled. The transfer of the transaction currently being t…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
VERY slow BTS index build
Hi Michael, I believe SBSPACETEMP is a list of sbspaces. I am know that BTS will accept a list of sbspaces, but it only uses one of the spaces listed, as documented in BTS: A temporary sbspace that is specified by the SBSPACETEMP configuration parameter. The temporary sbspace w…
Unable to drop sbspace
Hi there, I've informix dataserver Version 9.40.FC9 on AIX server. When trying to remove a sbspace I got the following messages : #onspaces -d siglob1dbs1 WARNING: Dropping a sbspace. Do you really want to continue? (y/n)y The sbspace contains smart large objects. To drop this s…
Informix upgrade
>> Only if the Workgroup license doesn't cover something from Enterprise that you actually use. Enterprise replication would be an example. Everett is wholly correct, but a better example might have been the use of table fragmentation, permitted in Enterprise, not available in W…
Who is using a smartblobspace
Thanks Art and Alexandre. Tried both suggestions with the following results: - the select does show a correct result if you have used a PUT IN, if not the data ends up in the default SBSPACE (which is the problem in my case) and there is nothing in syscolattribs. - the oncheck…
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.…
Bitmap is wrong for partp in sbspace
Hello, we have a problem with inserting/updating SBLOBs in one of four sbspace. There are many AFs in online log (all AFs describes the same issue): ========================== 15:55:10 IBM Informix Dynamic Server Version 11.70.FC3 Software Serial Number AAA#B000000 15:55:10 As…
ER network replication state
When we have a large transaction, or a large blob to replicate, if the queue mem size is about to be exceeded, then we do two things, 1) we sp= ool the transaction to disk and 2) notify the source not to send any new transactions until the large transaction is processed. This is …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Unable to start the storage space backup: Smart La
Hello, I'm running IDS 11.50.FC9W1 on Solaris 10, and doing level 0 backup and encountering this error, note that, with "whole system" backup, this error does not so up?? So basically, the only one dbspace that did not get backed up is this smart large object dbspace, (sbdbspace)…
ER queue question
Hi, we are using ER to replicate some tables from one to another database server. Version on both is 11.70.FC5. Now I see some replicates where the QUEUE SIZE does not change. My experience is that the QUEUE SIZE always tends to zero. cdr list repl | grep QUEUE QUEUE SIZE: 0 …
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
ER - How many times a table has been replicated
I'm trying to find out which tables are most active in Enterprise Replication, anyone have any ideas? Am I just missing something really obvious? Thanks, Andrew…
Re: Creating a table with BLOB in a SBSpace
I used the command to create table in sbspace successfully. for example: CREATE TABLE sys_datastore1 ( trans_ref NVARCHAR(32) NOT NULL, trans_data BLOB, PRIMARY KEY (trans_ref) CONSTRAINT sql1xxx2 ) put trans_data in (sbsp1) But you should create sbspace sbsp1 first.…
dbimport logging how to stop
thanks for that info Fernando We use enterprise replication here, Would logging of smart blobs be needed for that ?…
Innovator-C is now available!
The README file indicates the following about Replication! Changes to Replication in Informix 11.70.xC5 Innovator-C edition For 11.70.xC5, Informix Innovator-C edition no longer supports Enterprise Replication (ER) or High-availability data replication (HDR). If you were using r…
1024 incomplete connections at this time.
Original Post: Well that message is coming from the listener thread doing a comparison that is has (in you case) 1024 incoming connections it hasn't gotten to at that particular moment. So basically at the tci/ip layer there's 1024 or more, incoming connection requests queued up…
how to let IDS engine push out queried data ?
Take a look at the Change Data Capture API (CDC). With it you can register an application to be notified when data changes. This is lower overhead than using triggers for the same effect. To do it with triggers, you would write a C or Java UDR that would be called from within th…
ER and sbspace Logging Mode
(-----11.50+ versions-----) Supposing you´re going to rebuild your ER sbspace, you will need to stop your ER, but that doesn´t need to rebuild your ER domain, in my opinion. (I might be wrong, but the only structures ER stores on sbspaces are the control queues, so if you don´t …
Basic Text Search
Hi, Environment. Basic Text Search Blade Linux, IDS 11.70.FC4, BTS 3.00 Questions. 1. Any idea how much temporary sbspace is required to built a BTS index on a varchar(70) column with 5 million rows ? - I have allocated 4GB of temporary sbspace and still not enough. 2. Any …
Re: Summary: Error on IWA initialization:Assert SE
Hi, Have you created an sbspace (sbspace1 in the example below) and have the following entry in your $ONCONFIG? If you have to create and add the entry to $ONCONFIG, you do need to restart the server. SBSPACENAME sbspace1 # Default sbspace name http://publib.boulder.ibm.com/in…
Migrating from 7.31 to 11.70 with ER?
I'm looking into performing a migration from 7.31 to 11.70 with ER. I'm not even sure this is possible, although from what I've read it seems to be feasible. I'm now reading through this IBM doc, http://www-01.ibm.com/support/docview.wss?uid=swg21153338 and I'm reading about h…
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 …
Enterprise Replication queues
Each server has one send queue, but multiple send threads and each send thread can be at a different point in the send queue. There would be no impact on the delivery to one server if another server has a slow network. M.P. From: "GURPREET SACHDEVA" <gusachde@cisco.com> To: i…
Safely de-allocate cores?
original post: DS 11.5 FC8W2 on SPARC Solaris 10. We have a Solaris VM ("Container") running with 68 cores. 4 or 5 Informix instances run on here. We wish to de-allocate 4 cores from the VM for IBM Informix licensing reasons. We're pondering whether we can safely do this dynami…
Enterprise Replication
I plan to use Enterprise Replication for replicating information amongst multiple IDS instances. Regarding this I had few queries: a) Can there be two different sets of replicates configured between different nodes. For e.g. consider the below scenario: i) Replicate 1 - Nodes A…
Looking for CDR Jump Start
Look here... How to set up Enterprise Replication for the first time https://www-304.ibm.com/support/docview.wss?uid=swg21153338…
Spatial Data
hello reading thru the manual states that the ONCONFIG parameters for SBSPACENAME and SYSSBSPACENAME must be set for the default sbspace. We are running an HDR pair and have the parameters set on the Primary Server - does it also need to be set on the Secondary Instance ? thank…
Enterprise Replication
Hello All Fairly new to the ER world and when i peruse the catalog for ER training it mentions this: -Database Design Issues - Correct database design issues that can negatively impact replication: Serial keys, Cascading deletes, Triggers, Accumulators What are Accumulat…
ER performance
The block simply means that it is processing a large transaction. The receive queue is fairly full and a block is sent to the source nodes to let them know not to send anything until the receive queue has been processed. This could be the result of a large object such as a blob b…
HDR and clob/blob/byte/text/ etc.
I just want to verify I have this right. If you use a SBSpace or a BLOBSPace - they are not logged, therefore you cannot use HDR on that database. Is that correct? So if you are using the BTS datablade - even if it is on Character or varchar fields, you can use HDR because you …
HDR & RSS
Have you looked at enterprise replication? I reckon enterprise replication is the way to go. Very easy to keep in sync,and easty fix if it gets out of sync. If you have are not keeping the logs ,that is have device set to /dev/null why bother to log at all doesnt make sense ?…
Informix question
Hi, I have two confused question. 1 When a update SQL will update totally 3 pages in bufferpool? How many mutex IDS will allocate for this thread in the buffer-head entry in the buffer table? 2. What the temporary sbspace will be used for? thanks for your time.…
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…
Extending SBLOBSpace
I think I may have created my (development) Informix database server with too small a SBLOBSpace, so I am trying to extend it. (My current file sbspace.000 is only 1024K in size) Using the command C:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70> onspaces -a sbspace -p C:\\\\IFM…
Error IndexInput read past EOF using index BTS
The server message log shows that it ran out of sbspace, although the error message on the command line is a bit obscure. The message will change in further versions to something like that FSE IO write error. The sbspace %s might be full, check the online.log (where %s is the n…
log usage with ER and blobs
General recommendation is to configure one logging and one non-logging sbspace for CDR queue smart blob space. This way smaller size txns gets spooled to logging sbspace and larger txns gets spooled to non-logging sbspace. CDR_QDATA_SBSPACE accepts multiple sbspace names. Thank…
enterprise replication log usage
Log usage at target server is due to queuing blob data into receive queue smartblob space. Looks like sbspace configured for CDR_QDATA_SBSPACE is a logging sbspace. At source server, ER do not queue blob space data into sendq (exception is partition blob data). Data is directly …
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
freeing sbspace space
I have a table with 3 columns, one is a blob held in a sbspace; the sbspace was filling up so I purged out old records and did a level 0 backup. I was looking at utilization of the spaces and chunks using ServerStudio. The sbspace shows as being allocated even though there were n…
Enterprise replication replicating instance on sam
hello folks IBM Informix Dynamic Server Version 11.50.FC6 Using enterprise replication update anywhere conflict resolution Looking for some advice on the following. I have two servers running replication fine replicating between phyical servers wuast130 and auast120. on server w…
Blob size from SQL
I have a table with a blob column (that is stored in a sbspace). Is there a way to do something like: SELECT * FROM <table> WHERE SIZE(<blob_col>) = 12345; I have tried that and also using "LENGTH()" instead of size. No go. Is there a way to do this using SQL? Thank you. DG…
Error -19816: Cannot perform this operation on a
We are not using Enterprise Replication, just HDR. We have CDC but there is no CDC sessions running on the server. Where else should I look? Thanks for the response.…
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…
Enterprise Replication systems
It states the systems must be homogeneous..what happens if you need to do an OS update (upgrade levels) or even update the IDS? Do you have to take all systems down to do this? Also, I read something similar for HDR...is that the same?…
RE: Enterprise Replication help - urgent
PMR logged - 03969,999,796 - now I wait for IBM to ring back :) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Madison Pruet Sent: Tuesday, 24 August 2010 2:45 a.m. To: ids@iiug.org Subject: Re: Enterprise Replication help - urge…
RE: Enterprise Replication help - urgent
Thread 205 is gone (disappeared with the engine bounce) As it was heading into the night here in New Zealand, I threw a whole heap of space at the smart blob space and said "sort it in the morning". My first task when I get in to work (about an hour away) is to raise a case with …
Enterprise Replication help - urgent
Hi, I have two machines, RHEL4, IDS 11.50.UC5X2 is a ER Leaf node, RHEL4 IDS 11.50.UC5 is the ER Enterprise node. The leaf node is in collect mode and won't transfer any data back to the ER node (we have replicates running both ways and neither are processing at the moment). I ne…
Enterprise Replication help - urgent
Hi, I have two machines, RHEL4, IDS 11.50.UC5X2 is a ER Leaf node, RHEL4 IDS 11.50.UC5 is the ER Enterprise node. The leaf node is in collect mode and won't transfer any data back to the ER node (we have replicates running both ways and neither are processing at the moment). I ne…
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…
Enterprise Replication issues
Hi, IDS version 11.50.FC6 OS version: Solaris 10 I have 3 servers A, B and C A is replicating to B using Enterprise Replication B is replicating to C using Enterprise Replication From B to C, I replicate only a subset of tables with a different structure. When I insert a n…
replicating databases in the same instance
I forgot to say we are using enterprise replication and only want to replicate some tables…
replication migration pronb 11.10 to 11.5
hello ,Folks hoping someone can help here I have mirgated fom informix 11.10 to 11.50. Replication no longer works. I have run concdr.sh 11.10 11.50 as stated by release notes,still no joy. Has anyone else struck this problem. When i revert back to 11.10 replication still does no…
cannot drop a chunk from sbspace used for enterpri
Hi, We're using IDS 9.40.UC6 on Redhat 7.3 (i386), and are using ER to replicate some tables, using CDR_QDATA_SBSPACE ersbspace . I'm trying to drop one of the chunks from this sbspace but am getting this error: [informix@das-chcgate-pri informix]$ onspaces -d ersbspace -p /op…
Re: Freeing up sbspace
On Jan 25, 4:27 pm, "Laurie Gustin" <lgus...@utah.gov> wrote: > IDS 11.5 FC5 > Linux x86 > > I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space. > It didn't seem to free up any space. Is there something special that needs …
Re: Freeing up sbspace
On 25 Jan, 22:27, "Laurie Gustin" <lgus...@utah.gov> wrote: > IDS 11.5 FC5 > Linux x86 > > I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space. > It didn't seem to free up any space. Is there something special that needs to…
Freeing up sbspace
IDS 11.5 FC5 Linux x86 I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space. It didn't seem to free up any space. Is there something special that needs to be done to free up the space for re-use? I had to add another chunk t…
Freeing up sbspace
IDS 11.5 FC5 Linux x86 I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space. It didn't seem to free up any space. Is there something special that needs to be done to free up the space for re-use? I had to add another chunk…
IDS, BTS datablade and HDR
what is an sbspace? Can you point me to some documentation?…
Re: HDR Replication Requirements
Ahh I understand now.. are the disk requirements in HDR the same as in ER ?(transaction record dbspace, row data sbspaces). the manual dosn't specifically say they are needed.…
Onbar problem
Hi we have got another onbar problem : In the middle of a sbspace-backup , onbar was cut down by a sanswitch-port malfunction and now it looks like the archive-flag for the sbspace has been permanently set. When i try to start another backup on this instance , bar_act.log says…
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…
Informix size & sbspace location for BLOB & BLOBS
Does anybody know how to get the size and sbspace location of BLOB/ CLOB data using the embedded C functions of ifx_lo_specget_extsz() & ifx_lo_specget_sbspace() ? for an example, who might have a table such as; create table xxx ( first_col integer, sec_col "informix".…
RE: How to delete Enterprise Replication
You may have to bring down the engine and then bring it back up using oninit -D, which prevents the replication treads from starting, then you should be able to drop the syscdr database. Then depending on how tangled up it was, you may have to grind through each database and mak…
How to delete Enterprise Replication
Hi everybody! A client, LONG time ago, configured Enterprise Replication from a main server to a test server. After they finished their tests, they stopped the replication and did nothing else. Now, years later, I have to alter a replicated table, I get 19989: Enterprise Repl…
IDS- How to find sbspace storage utilization
I was trying to find out the storage utilized by dbspace,sbspace and blobspace. I have executed the following query in dbaccess select c.pagesize pagesize,d.name dbspace,c.chksize totalpages,c.nfree freepages, c.fname filename from syschunks c, sysdbspaces d where d.dbsnum = c.d…
Re: Fwd: inserting blobs
Thanks Johnathan yup you're right, they just need to read it out in a select statement ( against another field ). Thanks for the advice. From what I've been reading up tonight I'll make sbspace and use put clause. It sounds like the developers should use an esql/c routine to est…
Creating a table with BLOB in a SBSpace
Hi everyone! Version of IDS: 11.50 FC5 OS: HP-UX 11.11 I'm trying to create a table with a BYTE datatype in a SBSpace. When i run the DDL statement on DBAccess, i've got the following error: CREATE TABLE TB_ANEXO_GUIA_1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCH…
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…
Can't reorg a replicated table
I am using Enterprise Replication (cdr) and I need to reorg a replicated table. (out of extents) I created a new table and loaded it using HDL. Now I need to drop the replicated table and rename the new table. But informix will not drop the table - non exclusive access - I tried …
query on sbspace/blobspace
I have the following requirements: 1) I need to identify all the tables which have columns TEXT/BYTE/CLOB/BLOB 2) I need to find out the columns of type TEXT/BYTE/CLOB/BLOB is using which Blobspace/Sbspace to store data. 3) I should be able to execute an SQL query and get the …
more observations when testing V11.50.UC4
On 2 June, 18:38, Richard Kofler <richard.kof...@chello.at> wrote: > Hello fellows, > > today I gave sysadmin and friends a second look. > I found this techarticle to be VERY helpful:https://www.ibm.com/developerworks/data/library/techarticle/dm-0709si... > > Still I miss some go…
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 …
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…
Hibernate, Informix and two phase commit
LOïC COUTURIER wrote: > Hi guys, > > I'm searching for information about Informix using Hibernate and the two phase > commit. > > I would like to know if someone has already used that. > > I know that Informix can be used with two phase commit but I don't know if > Hibernate can.…
SBSPACE FULL
I have a sbspace with 50GB. I stored 100,000 and recived a message of space full. I created the sbspace with 25 chunks of 2GB each, with the default options. this objects store only 5MB in File System. How can I calculate the space used for each object in my sbspace?. The mess…
ER Error Enterprise Replication
Enterprise Replication is giving the following message when I do a simple cdr list server ndl12:ndl12a common_reporting$ cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------…
Problem with ER replication
Hello, We are using IDS 7.31.UD1 with Enterprise Replication. We added 4 columns to a table that is replicated, and now got the error "CDR:23 (Error: Internal error (buffer too small for stored procedure arguments))". Is there a limit in the row size of replicated tables? Thank…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
Enterprise Replication db recovery
Hi. I have a database that uses Enterprise Replication (at least it appears to be ER as opposed to High Availability Replication) based upon the use of "cdr" commmands and CDR* onconfig parms. It is a simple setup though. It is ONEWAY with only a subset of tables being replicated…
Enterprise Replication General Error
Hi folks, Is it possible to replicate from one instance to another on the same physical machine? I created one replication server OK but I'm getting "command failed -- General Error (-1) (-1)" when running cdr define server on the second replication server. Cheers R…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Long checkpoints
askel wrote: > Hello there, > > I've been reading about long checkpoints issue for a while but haven't > found solution for our case. > > We're using IDS 9.40.FC6 on Solaris 9 for OLTP. It is Sun Fire V1280 > with 8 UltraSPARC-III+ 1.2 GHz and 16 Gb of RAM on board. The database …
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…
Re: Enterprise Replication and locking
Jarrod, You can have different lock mode for each participant. To avoid possible locking issues due to page level lock, you could use CDR_DSLOCKWAIT configuration parameter, it specifies the number of seconds ER should wait for the locks to be released. Regards, Nilesh informi…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: error 12115 and how to delete a smart blob
Davorin Kremenjas ha scritto: > If you have no idea what I'm talking about, THEN DON'T DO THIS, > PLEASE! Talk to IBM Tech Support instead. > And don't mention my advice to them :-) Yes, i have idea... but my sbspace are raw device, and if i do something wrong with the db man…
ER Issue - txns stuck in send queue
Hi, we are using IDS ver 9.21.UC5XF (AIX 5.2 talking to AIX 4.3.3),(yeah, I know, I don't wanna hear "it's old, upgrade", we will be upgrading this year, long story), using ER. We had a system crash monday and had to end up rebuilding ER via the CDRBLOCKOUT steps. We were able to…
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…
Doubts about replication
Hello, folks!!! I´m in a hurry, testing a primary-target based replication using IDS 9.4. That´s all working fine, except that when my replicated db instance is down (offline), my sbspace fill so fast that I had to adjust it. After I resized it, I made several tests again, and it…
IDS 10 Replication Logs
Hi All, I am using IDS-10 on two servers and configured enterprise replication on it. Replication is working perfectly fine. If I want to see the SQL processed on primary server which will initiate data to be replicated on target site, please advice where and how can I find thes…
ER - Replicate in ALTERMODE state
Hi all, We use ER between 10.00.UC4 servers. One of our replicates remains in ALTERMODE state, so that it is not possible to update the table replicated through that replicate. We updating the table, we get the error 19992: "-19992 Cannot perform insert/delete/update operatio…
SBSpace
Hi all, i have a problem when creating a table into a fresh SBSpace. i use IDS 9.40 UC5 over AIX. i created an sbspace using : ------------------------------------------------------------ onspaces -c -S sb_1 -p /dev/chk2 -o 0 -s 1024000 ------------------------------------------…
used up all locks
No, but it queues one message for each time any user tries to acquire any lock until the table is free. Alarm messages are processed one at a time. Since each message requires a process fork/exec so the messages queue up much faster than the queue is drained. Look at my alarm han…
RE: Enterprise Replication question
Any chance of some assistance with this? I've had a further look and I can't make the -e option work anywhere in my ER replicates, from starting new ones to changing existing ones or through the use of a replicate set. Is there something I'm missing here? Do I need to turn this …
Enterprise Replication question
Hi, Running 10.00.UC3 -> 10.00.UC3 replication, both on RedHat EL 4 I set up a one-way replicate to transfer data and it works beautifully (Go Informix) but I forgot to set the frequency option in the replicate. I've now set it to the right thing, using cdr modify replicate but…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Optimizer Question
Yoo could lose light scans by making buffers too big. j. >From: Mary Gregory <mary.gregory@rheem.com> >Date: 2007/06/06 Wed AM 09:07:04 CDT >To: ids@iiug.org >Subject: Optimizer Question [9297] >Could the addition of memory to IDS (BUFFERS, SHMVIRTSIZE) cause the >optimizer to…
Re: Error in Enterprise Replication
On 16 May, 14:12, "Navaid Arif" <navaid.a...@access.net.pk> wrote: > Hi All, > I have increased the number of logical logs by adding 9 more logical logs of 20MB each. Now I have 20 logical logs. But the problem is that after performing some table load activity all logs have b…
Re: Error in Enterprise Replication
On 3 May, 07:49, "Navaid Arif" <navaid.a...@access.net.pk> wrote: > Dear All, > I am already using following setting. Should I increase LTXHWM and LTXEHWM to some higher value like 100 or 120 ? > Actually at source side of Replication environment, We are using a vendor applic…
Logical Logs in Enterprise Replication
Hi All, I am using Enterprise Replication on IDS10 UC5. I have 33 Logical Logs for IDS, each of 5000 pages i.e. 20,000KB. Test >onstat -l IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 09:00:11 -- 81408 Kbytes Physical Logging Buffer bufu…
Re: 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…
Re: Error in Enterprise Replication
Hi all, Actually, I am using the application which is apparently using dbaccess in the background. For some reason, I cannot ask my vendor to change the application therefore, I am using the other way around i.e. adding more logs or freeing previous logs which are used and ba…
RE: Error in Enterprise Replication
Navaid, You need to load the data in smaller chunks. You are opening a transaction at the beginning of the insert and then you start inserting records, these inserts are getting put into the logical logs. You cannot wrap around the opening of the transaction, "BEGIN WORK". …
Re: Error in Enterprise Replication
Hi All, I have increased the number of logical logs by adding 9 more logical logs of 20MB each. Now I have 20 logical logs. But the problem is that after performing some table load activity all logs have become 100% used. At this stage, no application is running even I have r…
Re: Error in Enterprise Replication
Dear All, I am already using following setting. Should I increase LTXHWM and LTXEHWM to some higher value like 100 or 120 ? Actually at source side of Replication environment, We are using a vendor application which is not using dbload or other utility and I cannot force my v…
Re: Error in Enterprise Replication
On 02/05/07, Navaid Arif <navaid.arif@access.net.pk> wrote: > > Hi All, > I am using IDS 10 UC5 and during testing of Enterprise Replication > facing following problem: Anyone have any idea about it? > > > SQL: New Run Modify Use-editor Output Choose Save Info Drop …
Error in Enterprise Replication
Hi All, I am using IDS 10 UC5 and during testing of Enterprise Replication facing following problem: Anyone have any idea about it? SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit Modify the current SQL statements using the SQL editor.…
Information required regarding ENTERPRISE REPLICAT
Hi All, I am planning to implement Enterprise Replication in my Production environment. I just wanted to know, are there any limitations for adding number of replicates in ER regardless of Network connectivity? And what are the points which I should take care of. Also advice wha…
Abnormal behaviour of Enterprise Replication
Hi All, I am running IDS10 UC5 on AIX5. And successfully configured ER-Replication on both Primary Server (srvtest) and Target Server (eftdr). Replicates rp72_dralways and rp72_merchtbl are successfully added but replication is working only on rp72_dralways successfully, othe…
Enterprise replication errors
Hi, I'm setting up Enterprise Replication as a primary target between 2 servers I've defined my replicate servers and my replicates and started the replication. When I update a record on the master, the information is sent to the slave server. However, the transaction is rejected…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
ER
Hi guys, Informix 10, Solaris 10 is the following situation possbile with Enterprise Replication: create table A (id integer, des char(10)); create table B (num smallint, name varchar(40)); create table C (seq integer, title varchar (40)); I want to replicate first column o…
Re: Replication Newbie Question
On Feb 16, 9:15 am, "Laurie Gustin" <LGUS...@utah.gov> wrote: > I learned that one possibility for replication delay may be that I am replicating data from a blobspace, and that process was very slow. That seemed ok, except that now the send q has been growing for over 24 hours…
Re: Replication Newbie Question
Check the queue stats using onstat -g rqm at source. And receive stats using onstat -g rcv on target. Although servers are active, check if replicates are active using 'cdr list repl' and verify the state. Regards, Nilesh "Laurie Gustin" <lgustin@utah.gov> Sent by: informix-li…
Replication Newbie Question
IDS10 FC5 HP-UX 11.11 I have a quick question about replication. I have ER running between two servers and the queue on the sending server just keeps getting larger. It appears that the 2 servers are communicating, but how do I get the queue to write/flush so it doesnt just k…
Re: IDS Performance Problem
I am going to be setting up replication (HADR) between to Linux boxes running RH Enterprise 4.0 and IDS 10.00.FC5. Do storage backups have to run on the slave server when in slave mode? Or only when in master mode? Thanks Peter…
ER warning
Does anyone know the meaning/importance of this ER warning? 10:11:43 DR Warning: Non logged Smart-Large-Object write in replqdbs Is my CDR_QDATA_SBSPACE configured incorrectly? IDS 10.0.UC5 on RHEL3 Thanks, Andrew…
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 …
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…
ER transactions queuing, NIF in BLOCK state
DL Redden wrote: > One of our servers in a 4-way update anywhere ER topology is currently > not staying caught up, i.e. transactions from the other three servers > are queueing but slowly getting sent and applied. The culprit seems to > be the network interface. An onstat -g nif …
rootdbs full error
You should now think about sending the send AND receive queues to a dbspace other than rootdbs. If you do not define separate dbspaces for those two while configuring for replication they will be defaulted to rootdbs. jp "Mustafa Sert" <msert@meteor.gov .tr> To Sent by: ids@…
Performance issue after 732 to 94fc6 upgrade
Hi, Try setting OPTCOMPIND to 2 in case your queries are optimized for 7.3x. MAX_PDQPRIO should be 100 in case you want to use PDQ when your machine is executing only one heavy task. Also DS_TOTAL_MEMORY should not be limited in this case (empty param). Maybe this helps. Marcu…
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 …
DataBlade Manager
ah - thanks - i am seeing that now - we created an sbspace after getting this error : blademgr: ERROR: DataBlade spatial.8.20.FC2 could not be registered in database test_data. select SE_TestSbspace("SBSPACENAME") from informix.systables where tabname='systables'; You must def…
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?…
Informix 9.4 and JMS
I have an Informix database and a MySQL database. I want to monitor operations on some of my Informix tables. Whenever one of these tabes is modified, I want to send a message to a JMS queue so that a Java program will be able to read this JMS queue and therefore update the MySQL…
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/…
Enterprise Replication between 9.40 and 10.00
Hi I'm trying to add in a new 10.00.FC4 (RHEL AS4) server into an Enterprise Replication environment that already has 2 servers running 9.40.FC2 (Tru64 5.1B), but when I issue the cdr define server command from the sync_server, I get the following error: connect to g_bsids2b fa…
RE: What???
1. Does anyone here use Timeseries and real time loader apart from that clown? 2. Where are the manuals? 3. Why does IDS need to be bounced when using Real Time Loader when the table schema changes or the table storage gets moved (sbspace/dbspace??). 4. I understand Timeseries…
Enterprise Replication Conflict Notification
My company is in the process of implementing a 7 instance, update-anywhere ER topology using timestamp conflict resolution. We have decided that we want/need to know when and if a conflict occurs. I asked an IBM resource if IDS offered an alert of some mechanism for trapping the…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: informix market share
"DA Morgan" <damorgan@psoug.org> wrote in message news:1133072683.547964@yasure... > xiaoxin wrote: > > The list price of IDS is about 20% more than oracle EE. No one is > > more expensive than oracle, when it comes to database. > > But wouldn't a more accurate comparison of IDS …
Re: ER between different versions
Hi, ER (Enterprise Replication, aka CDR): yes. And just to be clear: HDR (High avalability Data Replication): no. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 11/24/2005 07:55:57 AM: …
Enterprise Replication, hour syncronization
Hi all, I should implement an installation of Informix ER with 12 servers. I'm afraid of the right syncronization between all the 12 servers, 8 Linux SUSE, 4 Linux SUSE on VMWare and 4 Windows OS that accomodate the virtual machines. About the hour sync: how many seconds/minute…
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 …
Enterprise Replication restore concerns
I am in the process of implementing a 7-node update anywhere ER solution. My management has successful posed a few questions that I cannot answer and can't seem to find any literature on. Question #1 If a cold restore has to be done on a specific node and the last logical log wa…
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.…
ER licensing
Willem, There is no additionnal license for Enterprise Replication if you have an IDS Enterprise Edition. If you have a Workgroup Edition, contact IBM. see this URL : http://www-306.ibm.com/software/data/informix/ids/enterprise/ Regards. ________________________________ Phili…
Rows in syscdr - tables
We had some race conditions with ACK management which caused us to not properly clean up some transactions in the send queue. My guess is that is what you are seeing. If you bounced the server, they should go away. If you want, you could also examine the progress tables to see…
Re: No future for DB2
Madison Pruet wrote: > Since the IBM Informix Enterprise Replication uses less than 10% of the > total resources, it is simply easier to replicate the whole DB. And since > disks are so cheap now, I would have difficulty not justifying having a > multi-node grid like arrangement…
Re: No future for DB2
"Madison Pruet" <mpruet@comcast.net> wrote > Since the IBM Informix Enterprise Replication uses less than 10% of the > total resources, it is simply easier to replicate the whole DB. And since > disks are so cheap now, I would have difficulty not justifying having a > multi-nod…
Re: No future for DB2
"bka" <badamache@yahoo.com> wrote in message news:1122867226.713664.145680@z14g2000cwz.googlegroups.com... > Replicaton to/from Oracle has nothing do with Enterprise and/or > standard edition - to replicate to Oracle or SQL Server, you need IBM > Information Integator. > On mina…
Re: No future for DB2
Replicaton to/from Oracle has nothing do with Enterprise and/or standard edition - to replicate to Oracle or SQL Server, you need IBM Information Integator.…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Re: Enterprise Replication
Jonathan Leffler wrote: > Marquis de Bogier wrote: > >> IDS 9.4 (Linux) >> >> I wonder if it's possible to replicate a complete database without >> replicating each table itself. >> We are using a tool which creates new tables, but we can't automatically >> specify the replicatio…
Enterprise Replication
IDS 9.4 (Linux) Hi all, I wonder if it's possible to replicate a complete database without replicating each table itself. We are using a tool which creates new tables, but we can't automatically specify the replication command for that new tables from outside that tool. We alwa…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Informix Enterprise Replication
Dear All, I opened a case with Informix regarding this issue. They came back to me today and said it was a known bug with Solaris 8 and IDS 7.31.UD1, that was fixed in UD3. So my plan now is to upgarde Informix. Thanks again to all who tried to help. Regards Alex "Alex Daman"…
RE: Informix Enterprise Replication
Dirk Moolman > > Sorry, meant to say "save" ......... d'oh ! > > On Behalf Of Dirk Moolman > Sent: 16 February 2005 11:43 AM > > Just to safe yourself possible headaches - make sure your > Solaris patches are not old / out dated - caused LOTS of > problems for me ! We fort t…
RE: Informix Enterprise Replication
Sorry, meant to say "save" ......... d'oh ! -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Dirk Moolman Sent: 16 February 2005 11:43 AM To: Alex Daman Cc: informix-list@iiug.org Subject: RE: Informix Enterprise…
RE: Informix Enterprise Replication
Just to safe yourself possible headaches - make sure your Solaris patches are not old / out dated - caused LOTS of problems for me ! -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Alex Daman Sent: 16 February 2005…
RE: Informix Enterprise Replication
You should use the group server (g_pocmel instead of pocmel). Uri -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Alex Daman Sent: Wednesday, February 16, 2005 9:09 AM To: informix-list@iiug.org Subject: Informix En…
Re: Informix Enterprise Replication
Alex Daman said: > > No matter what cdr command I run, I get this type of response back. My > INFORMIXSERVER variable is of course set, however I think the problem lies > somewhere else. Very frustrated at the moment Other commands work OK? Like onstat, onmode, etc.? -- Bye no…
Informix Enterprise Replication
Hi All, Is there anyone out there who has setup ER on 7.31.UD1. Im trying to implement a proof of concept for replicating two of our sites. Im runnig with Online 7.31.UD1 on Sun Solaris platform. I have configured my sqlhosts files according to the Replication guide, see below: …
error cdr define repl
Since this is an error while creating a sparse control message, I suspect that the problem is being encountered trying to forward the control message to one of the leaf servers. Are you defining the replicate on the root node? Is the error occuring on the root node or on one of…
Re: Trouble dropping the syscdr database
Andreas Legner <fake@xx.yy.de> wrote in message news:<315hoaF37e30tU1@individual.net>... > wonder what would need so much log space when dropping syscdr ... non empty sendq (trg_send_stxn > table), ... ??? Without any other information, I'd bet that it's due to having to remove …
RE: informix begginer on xp
Art, Is the rootsize big enough?.... Doing the basics... 51.2MB - 2 MB physlog = 49.2MB - 12MB logs = 37.2 MB. I think that's big enough in the olden days for a tiny engine on unix, but I know nothing of windows installs, and I think it was stated this is a 9.4 engine. Will i…
Re: informix begginer on xp
How are you trying to initialize it? ie what are you running? Did it hang during installation, or is it subsequent attempts to initialize that hang? Just making sure you're not trying to run oninit directly from the command line, UNIX style. Also if you run "onstat -m" from an …
How to stop Enterprise Replication on IDS7.3
Hi all I was tesing Enterprise Replication on IDS7.3. I have implemented ER on one table and it is working well. Now am unable to remove it successfully. Kindly help me out Regards Abdul Haleem…
Re: ER and inplace upgrade 7.31 to 9.40
See below... "Andrew Hamm" <ahamm@mail.com> wrote in message news:<2t90hoF1sngogU1@uni-berlin.de>... > Hi folks > > I need to upgrade 7.31 to 9.40 on servers which partake in Enterprise > Replication. We did a test server, and it barfed because of a few things: > > 1) needs new …
Re: ER and inplace upgrade 7.31 to 9.40
1) Drain the queue 2) run cdr stop 3) migrate the server to 9.4 4) Add the sbspace for the queue 5) modify onconfig to point to the new sbspace 6) run cdrcon 7) run cdr start ER migration is an external process because the server must be on 9.4 with the sbspace existing prior to…
RE: ER and inplace upgrade 7.31 to 9.40
=20 =20Andrew=20Hamm=20wrote >=20Hi=20folks >=20 >=20I=20need=20to=20upgrade=207.31=20to=209.40=20on=20servers=20which=20pa= rtake=20in=20 >=20Enterprise=20Replication.=20We=20did=20a=20test=20server,=20and=20it=20= barfed=20 >=20because=20of=20a=20few=20things: >=20 >=201)=20n…
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'?…
Delete table from nonexistent sbspace
I don't now how it is happen. Informix version is 9.30.UC2W8 I can't drop database "syscdr". It has only one table "control_send_stxn" on nonexistent sbspace. When I try drop database, I have message: 214: Cannot remove file for table. 110: ISAM error: end or beginning of the f…
Enterprise Replication no start or stop
Hello everybody, I have a problem with enterprice replication. Informix version is 9.30.UC2W8 I delete server from replication and now i can't do anything. When I run command: "cdr start" the answer is that it's already active (63) when I run command: "cdr stop" the message is…
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: Checking the replication
See below.... "Colin Bull" <Colin.Bull@videonetworks.com> wrote in message news:cfa6vu$l74$1@news.xmission.com... > > Madison Pruet wrote > > > I will be giving a replication tutorial at the user > > conference which will include various ways to verify > > replication tables are…
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…
Replication (different OS-es and IDS versions )
Hello, I have 2 IDS 7.3/Uniware servers working with replication enabled. I would like to migrate one of them to 9.4/AIX and then to enable enterpsrise replication with the second IDS 7.3/Unixware server. I could not find unequivocal answer in Informix Enterprise Replication G…
RE: How to find usage for sbspace
Hi. Try. http://www-106.ibm.com/developerworks/db2/zones/informix/library/techarticle/db_sblob.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: R�Eiger M�hl <ruediger.maehl@web.de> >Reply-To: R�Eiger M�hl <ruediger.maehl@web.de> >To: informix-list@iiug.org …
How to find usage for sbspace
Hi folks, I know how to find the size and free size of a dbspace, but how do I get these numbers for sbspaces? (We just got a new server, which uses sbspaces) IDS 9.40, Windows 2000 and Linux (SuSE SLES7). Any help is really appreciated, R�diger…
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…
Enterprise Replication: Serverstate = Quiescent
Hi all, IDS 7.31 UD4 SCO Unix 3.2 5.0.6 'cdr list serv' on server olms152cdr shows: olco234cdr 20 Quiescent Connected Jul 10 23:03:16 2004 'cdr list serv' on Server olco234cdr shows: olms152cdr 13 Active Connected Jul 10 23:03:17 2004 Serverstate…
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…
Database replication with 9.4
brett wrote: > Hi all > > Has anybody used the data replication feature of IDS 9.4 ? > > For the manual it looks very exciting and will provide the solution > for our proposed redundant database site. I've used Enterprise Replication (ER) with 7ish engines and so have many peop…
Re: Extremly long checkpoints: How to find the reason and solve the
I don't have the DSS Query right now, as a matter a fact , I don't even work on the same company where I had that problem. In that time, the decision was to migrate to Enterprise Replication because of this problem and primary because of the replication granularity flexibility al…
Re: Alter Fragment on a table in syscdr
If the table is empty, then the cluster index will be faster than dropping the table. The cost of a cluster index is that we have to scan and sort the table. If there is nothing in the table, then all we have to do is to create a new (and empty) partition. "Heinz Weitkamp" <he…
AW: Alter Fragment on a table in syscdr
Thank you, Madison Pruet. Another question: Can I do: (because it's faster) cdr stop dbschema -d syscdr -t trg_send_sbuf -ss > file Drop the table and than create the table new cdr start without any trouble with ER to reclaim the space. (IDS 7.31UD4) Thank you. Heinz Weitkamp…
Alter Fragment on a table in syscdr
Hallo, I have a large table "trg_send_sbuf" in dbspace "cdrquedbs" belonging to the database syscdr (Enterprise Replication). The table has 1 GB with no rows. Can I do an ALTER FRAGMENT ON trg_send_sbuf INIT IN <cdrquedbs>; to reclaim the space without any trouble with ER. Mus…
Enterprise Replication & Triggers
Hello, I'm replicating the table1 on Serv1 to another table2 on Serv2 with ER. No Problem. But, If I add a trigger on the target table2 to copy this one on another table3 under the same database with the following CREATE TRIGGER test_er INSERT ON dwmd_bran_53 REFERENCING NEW a…
Enterprise Replication : Restrictions
Hello, I have 2 questions when using Enterprise Replication : 1 - In the case of consolidation, is it possible to replicate table from the primary to table from the target which will have one column more containing the name of the primary. It is useful when we have a lot of pri…
Q: continous restore at remote instance?
"Davorin Kremenjas" <davorin.kremenjas@inet.hr> wrote in message news:c6qvtv$ffe$1@bagan.srce.hr... > Hello. > I searched old posts for a possible solution to the problem I have but > without success. > The summary is this: is there a possibility to continously restore > transact…
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.…
RE: ISDN & Enterprise Replication
Bj Although ER is possible over ISDN I am not sure I would recommend it. You either need the line continuously available (as you have found) as the servers communicate with each other every few minutes even if there is nothing to send, or you request replication to store up the …
ISDN & Enterprise Replication
Hello, I'm doing some tests with Enterprise Replication of INFormix. When I defined the replication for UGnd1 and MisterX, I have a big problem. The ISDN Line is never released even if no replication is done. That is not a good idea for the telecom bill :-) Here are the comman…
Long checkpoints on AIX/IDS7.31/IBM Shark
Willem Roos wrote: > List, > > We have very sporadic, very long checkpoints on our IBM RS/6000 boxes > (AIX 4.3.3, IDS 7.31.UD4) connected to an IBM Shark (2105-F20), eg. 66 > seconds to write away 2772 KB. Normally checkpoints are 0 - 1 seconds > for 10 - 20 MB: > > $ onstat -c…
RE: Dirty page queues during a checkpoint (WAS: The old raw devices chestnut)
Thanks Bill, Found it in 7.3 manual also, p 11-53, identical paragraph as in 9.4 manual: "During a chunk write, each page-cleaner thread is assigned to one or more chunks. Each page-cleaner thread reads through the buffer headers and creates an array of pointers to pages that a…
RE: Dirty page queues during a checkpoint (WAS: The old raw devic
http://publibfi.boulder.ibm.com/epubs/pdf/ct1ucna.pdf Page 7-44 for chunk writes, which are the type of writes that are done during page flushing. Regards, Bill > -----Original Message----- > From: Willem Roos [SMTP:wroos@shoprite.co.za] > Sent: Friday, April 16, 2004 5:13 AM …
Dirty page queues during a checkpoint (WAS: The old raw devices chestnut)
They're queued in LRU queues as they become dirty, and then during the checkpoint each chunk with stuff to be written gets assigned to a page cleaner and within the chunk the pages are sorted into sector order prior to writing. So it's highly possible that not all the chunks (and…
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 Enterprise Replication
Hi Everybody, One of my cleint wants to syncronize the data in two servers which are at different locations and both the servers should be online so that users can use the servers. I have suggested them to have enterprise replication done on these two servers. They want to go f…
Re: An interesting meeting with IBM
I forgot to mention that work is being done in Enterprise Replication so that re-synchronisation is much easier. Getting that initial sync, and then maintaining it when schems changes, is the only real hassle with ER at the moment.…
Enterprise Replication
HAVE 4 9.30uc5 servers running update anywhere er. This has worked great for over a year. We are trying to add a 5th box running 9.4 to be a target only report server. Everytime we cut on replication the original boxes go haywire. Please let me know any info you may have to su…
Enterprise Replication
We have 4 boxes ABCD running Update anywhere replication Informix 9.3 uc5. This has worked very well for the past 1 1/2 year but we have now need to add a 5th server target only running 9.4. When we hook this server up and start the replicates we hose the ABCD boxes and often c…
Where to put logs in a RAUD 1+0 system
I'm about to configure a brand new, fast RAID 1+0-based system which will use logged sbspaces. Conventional (JABOD-based) wisdom tells me to put the logs on a separate device to the busy storage spaces. But, on a 5-disk array, does this idea justify holding back one disk for the …
Performance is getting worst after turn on the LRUAGE
"miyaki" <lcib@yahoo.com> wrote in message news:c487qm$lbf$1@terabinaries.xmission.com... > > Hi all, > > Due to the Bug 121515 where the LRU Queues get clogged > with index pages, I have used the LRUAGE=1. Having the > LRUAGE enabled, the buffer pool now being filled up by > oth…
another enterprise replication
1/ Is it possible to replicate a table to anothet table ? The new table has more fields and maybe another primary key ? 2/ I have a HDR pair in my EDR replication. This works fine. When I put my primary (hdr) off, and place my secondary to accept all connections (onmode -d stand…
enterprise replication question
Hello, I have 4 servers. 1 + 2 -> setup hdr 3 -> central 4 -> upper level I defined a replication between 1-2 group and the central group. This replication works just fine. I also defined a replication between 3 and 4 . This replication also works fine. But when I insert a new…
informix enterprise replication
Hello, I have 4 servers. 1 + 2 -> setup hdr 3 -> central 4 -> upper level I defined a replication between 1-2 group and the central group. This replication works just fine. I also defined a replication between 3 and 4 . This replication also works fine. But when I insert a new…
Re: [Informix 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: how to tune buffer allocated to index data?
LRAGE=1 resolves the problem in 7.31. Its never been "fixed". New buffer management code in 9.X means the problem doesn't repro. "Simmons, Keith" <keith.simmons@office2office.biz> wrote in message news:<c2s2cq$c0u$1@terabinaries.xmission.com>... > Miyaki > > You are encounterin…
RE: how to tune buffer allocated to index data?
Miyaki You are encountering Bug 121515 where the LRU Queues get clogged with index pages rather than being used for data pages. Work around is to export the environmental variable LRUAGE=1 in the session you use to start the engine. I'm not sure at which version this was fixed (…
Re: Informix Performance
Middle of the night... Maybe batch jobs are running which are retaining locks for a long time and the users are running into those locks? "Daniel Castro" <daniel.castro@feliciorocho.org.br> wrote in message news:f86fe5d3.0402261055.34916f88@posting.google.com... > Hi, > > I am …
Informix Performance
Application? OS? Hardware, esp amount of physical memory? Profile of usage of application: eg times of heavy online use; times of batch job runs etc? Output of onstat -g iov also please. "Daniel Castro" <daniel.castro@feliciorocho.org.br> wrote in message news:f86fe5d3.04022610…
problem of sbspace
Hi all, I am using IDS 9.21. Recently, one of my metadata area of sbspace chunk run out of space, and I have to add additional chunk on this sbspace. However, the user data area of the original sbspace chunk is only about half full, and the database nolonger write any data to th…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Any Research Available Comparing Network Traffic of Synonyms and
Does anyone know of (or has conducted him/herself) any research = comparing the network traffic that results from queries against a = database through the use of a synonym (tieing one table from one = instance to another) to that traffic that results from replicating = (through e…
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.…
ER trouble
We're going to need a bit more information. The message log file should contain some information as to why it went down. I suspect that the queue to the leaf server got full, but would like to see the online log at least before making any statements. "Rastislav Janac" <rastisla…
RE: Enterprise Replication question
>Josh Marshall wrote > > I've got Enterprise Replication working nicely with a table > on Informix 9.40, > but I'm wanting to replicate the whole database between the > two servers. > > There is a situation where tables can be dynamically created > and I want these > to automatic…
Re: Enterprise Replication question
Hi Josh. How about using HDR(High-Availability Data Replication) ? See refer to http://www-3.ibm.com/software/data/informix/pubs/library/ids_9.html You may see Admin guide. (Chapter 19). Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Josh Marshall <josh@w…
Enterprise Replication question
Hi everyone, I've got Enterprise Replication working nicely with a table on Informix 9.40, but I'm wanting to replicate the whole database between the two servers. There is a situation where tables can be dynamically created and I want these to automatically be included in the …
Clarification on SBSPACES
Hi We have informix Database 9.2 running on Solaris, ad our database is registered with datablades, which we are not using at all. As i am going to set up a new server , i have exported the database and changed the .sql file removed all the scrap except what needs for our Data…
Enterprise Replication - Primary Key
Hi everybody, I am in charge of administering two AIX 4.3.3/RS6000 IBM Servers with Informix 7.31 running on each one. After one week of research and night work I got my two servers configured for Enterprise Replication (tmp-ats and tmp-fis filesystems, sqlhost group definition, …
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Enterprise Replication questions
I've been assigned the task of coming up with a way of not loosing a = single transaction in case of a physical disaster at the location of our database servers = (and backup servers). =20 To achieve this, I'm thinking of using ER in a many to one mode. That = is, replicating ma…
Re: Onbar Backup?
Venkatesh, Well, the backup speed is dependant on the type of tape drive you have. For a DLT7000 you should get about 40-50 GB/hour. Backing-up to a disk storage unit is the fastest speed you will ever get, so you can benchmark against this. The Informix "arc_very_old_page" bug…
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
tomL wrote: > > Is there a command that will return what type of replication is being > run? If you run onstat - then if you see something like: Informix Dynamic Server Version 7.31.UC5 -- On-Line (Prim) -- Up 62 days 20:28:42 -- 53248 Kbytes or Informix Dynamic Serv…
Enterprise replication
Hello everyone, I'm trying to define an Enterprise Replication system between: - A siemens server (ReliantUNIX-N 5.45 B2005 RM400 4/1024 R10000) Informix 7.31.UD2X4 which is the source server and - A Sun server (5.8 Generic_108528-20 sun4u sparc SUNW,Sun-Fire-880) Informix 9.30.…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
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…
Re: Smart Large Objects: Sbspace is full
I suggest adding new chunks to img_db01, img_db02 dbspaces and no new dbspaces. I don't know how you have been able to add a new table with the same name. You should be used ALTER TABLE. Regards, Guillermo. ----- Original Message ----- From: "Mark" <kbl@net-yan.com> To: <inform…
Smart Large Objects: Sbspace is full
At first, I created following table to store PDF data in column img_doc. create table img ( img_key varchar(40), img_no integer, img_doc "informix".blob, ) PUT img_doc in ( img_db01, img_db02 ); Sometimes later, SBspace img_db01 and img_db02 were ful…
Re: ER: send queue grows
The bulk of the stuff in the queue are the data changes for the transaction. Prior to 9.3, the bulk was stored in partition blobs within the stable queue space. With 9.3 this was moved to a smartblob space. smartblobs are reclaimed by the smartblob space when the smartblob is d…
ER: send queue grows
Hi all. We have 3 servers using ER: - Server A, primary, IDS 9.21.UC4,Linux - Server B1, target, IDS 9.21.UC4, Linux - Server B2, target, IDS 9.30.FC3, Solaris 8 The 3 replication servers have been created with the send and receive queues in a dbspace called "physdbs". On each…
RE: "Slow System" Problem
Are you sure you are bottlenecked on CPU? Check sar when this happens to make sure. If that's the case, you can track the most active sessions by looking at which ones show up on the active queue(onstat -g act) most often. That can be a problem if you have a lot of users and s…
Need to talk to someone about SMART BLOB SPACES & map data.
Need to talk to someone experienced with SBSPACES and determining what to set the metadata parameters to. Have a client who is loading a bunch of map layer data into an Informix database to use with ESRI's SDE toolset. The actual data in the smart blob space seems small but the…
Need to talk to someone about SMART BLOB SPACES & map data.
Need to talk to someone experienced with SBSPACES and determining what to set the metadata parameters to. Have a client who is loading a bunch of map layer data into an Informix database to use with ESRI's SDE toolset. The actual data in the smart blob space seems small but the…
IDS 9.3 Enterprise Replication
You need to check the onconfig for the CDR smart blob entry. This is the "CDR_QDATA_SBSPACE" entry. In 9.3, the stable queue has been moved into a smartblob. If there is no entry in CDR_QDATA_SBSPACE or the value in the CDR_QDATA_SBSPACE entry does not exist, then you will run i…
enterprise replication
Hi all, I am trying to set up enterprise replication between two servers. Sqlhosts files of both the servers contain same information. Both servers are using tlitcp connections. I started one server as a replication server. But when I try to start the second server as a replicat…
What's happening inside the oninit process ?
Something I look at to find out who is hogging all the servers resources is the ready queue. When a system gets bottlenecked on CPU you will start having threads show up on the ready queue. I figure the more times a single thread shows up on the ready queue, it's likely this th…
Enterprise Replication log
Enterprise Replication does not have a seperate set of logs. It snoops from the normal logical log file buffers. It only snoops from the log files themselve during recovery or if for some reason it falls behind.…
sbspaces
I need some help with sbspaces and the information that is presented from onstat -d and the data in syschunks. When I issue a onstat -d, it appears I have lots of free space in my sbspace's. However, when I query the syschunks table looking at the nfree column, it appears I hav…
Replication
We are considering using some method of data replication/failover. Some of the options we have considered are Informix Enterprise Replication, Informix Data Replication, Legato, and Veritas. I would like to hear from users with experience on any of those methods regarding the ea…
Enterprise replication
--------------61BA173DE4C37191D4A7B827 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I am trying to setup Enterprise replication on my HP-UX 11. I have a problem when i run "cdr start repl -c g_test1". The error is "connect to -g_test1 fail…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
9.20v 's sbspce diffrent from 9.14v's sbspace?
HI? I have a question. is IIF2000 9.20 sbspce different from Universal Server 9.14 sbspace?…
Replication blobs questions .
Hi all. We are migrating to IIF.2000 with WebDatablade. The WebDatablade store the pages in Sblobspaces. We want a High Available System, to do this we use HDR but we read at manuals and * Adminintrator's Guide for Informix Dynamic Server.2000 ver 9.2 ----Important: The databas…
Replication conflicting with constraints
For Enterprise Replication... onstat -g ddr display the snoopy/replay position onstat -g grp display information about the grouper onstat -g rqm display information about the queues onstat -g nif information about network transfer of replicated data onstat -g dss inform…
replication
Enterprise Replication offers the ability to replicate at a smaller granularity than at an instance level, but I would not recommend using ER on any version less than 7.31UC4. However, I do not understand your question fully. If you are currently using additional software to do…
informix replication
Informix has two replication strageties. The first (HDR) provides mirror image replication. Basically the source instance is replicated onto the target instance. This provides High Availability with a rather low latency. Also it is fairly easy to setup. However it does have …
Enterprise Replication
_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please not…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: can a report (write using informix-4gl) be printed out by using laser printer ?how?
fly wrote: > i would like to know that whether is it possible to use a laser printer to > print out a report that already writen using informix 4gl? > if possible, how can i make it? > does it need other softwares to help me to make it? > if it does,what's the software that is su…
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…
ER time synchronization
This message addressed more towards sysadmins on UNIX, but since I am stuck with DB admin and sysadmin... Running Enterprise Replication on 2 different servers: what will be good solution to synchronize time between'em? xntpd? if someone had experience - please, reply? Regards, …
BLOB replication on IDS 9.20.UC.1 - how to
Hi group, I'm using Informix Dynamic Server and I've read that enterprise data replication doesn't support BLOB replication. Is possible to turn around that problem? Thanks in advance Auri…
Re: Newbie question on logs
Try "ontape -s -L 0" with LTAPEDEV in nul after that ontape -a, then start again to configure if the problems persist send us the file bar_ol_instancename.log Bye On 5 Jun 2000, at 11:12, PS wrote: > I tried all possibilities of onbar, but still the logs are not marked as > ba…
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…
Distributed database question
> > Please, do tell me - what is distributed database? To simplify, one examble of a distributed database is set up by two or more databases replying each other. Please see Guide to Informix Enterprise Replication (on Answers online of course). Hope this can help you. Dennis.…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: Question about replication
From: tkimnguyen@my-deja.com > >My reading of Informix replication is that it is log based, and this >type of replication architecture has a number of deficiencies. Informix >replication will probably meet your requirements in a two server >scenario, but you might want to have a…
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…
Re: Replication Manager
Have you installed server agent on the Unix box? Jin. Informatica wrote: > Hello, > > I'm testing Enterprise Replication. I installed Replication Manager on a NT > 4.0 workstation. > I want to replicate from one server (on_nat4_tcp) to another server > (on_dev2_tcp). > Both se…
Replication Manager
Hello, I'm testing Enterprise Replication. I installed Replication Manager on a NT 4.0 workstation. I want to replicate from one server (on_nat4_tcp) to another server (on_dev2_tcp). Both servers are UNISYS UNIX servers. The installation and configuration of RM went fine. But wh…
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…
Enterprise Replication
Hello, We're thinking about running ER between 2 machines at each of 2 sites. We'd only update on one server at a time -- the other 3 servers are backups only. I've got some questions on ER: a) There seems to be very few postings on the subject to this group. Does …
How can I speed up the 'drop index' command?
Hi Its the first time for me posting a question to the group, so here goes. Running IDS7.31 with Enterprise Replication active, how can I export my databases without having to shutdown replication. Cheers Folks h.straker@videonetworks.com…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Data Replication
In article <3890BDE1.9E283668@sportingnews.com>, jmaes@sportingnews.com wrote: > > What kinda of DR? Enterprise replication, HD replication. Everything > you need to know is in your manuals. > ER (Enterprise Replication) is the replication you will need. HDR is not supported…
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…
Re: Baan and Informix Enterprise Replication
This is another wonderful feature of Baan, their tables doesn't have Primary Key and their indexes are over the hash fields. Theoretically you can create the Primary Key directly through Informix... but this is an impossible mission due to the great number of tables. ******…
Baan and Informix Enterprise Replication
Hi Is someone using or have setup Baan with Informix Enterprise Replication? We intend to setup Informix Enterprise Replication between two servers. I am told by someone that Enterprise Replication may not work with Baan because of primary key constraint. Shall be grateful on …
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…
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…
Error in installing Enterprise Replication Manager
Hi When I am trying to install Enterprise Replication Manager on Windows98, I get the following error. Couldn't load CDRINS.DLL I have already I-Connect on my PC and it is wroking fine. Any suggestions ? Thanks in advance. Muhammad Usman Sent via Deja.com http://www.dej…
Re: 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…
RE: ER help
Thanks for the advice, replication is now running. Apparently my problem was INFORMIXSERVER must be set to a tcp connection. Anyway. Now I just need to know the drawbacks of using ER. Can anyone tell me what kind of overhead is associated with ER (like send, receive queues, s…
ER vs HDR
Wu <wuyf@tm.net.my> writes: > A few questions on these replication :- > > 1. What's the difference between this two replication ? > > 2. Is it TRUE that ER can replicate regardless of OS / Engine Setup ? Nope. > 3. What's the basic requirement for ER ? Look at the do…
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…
Enterprise Replication - Questions on monitoring Replication
Hello all, We have been using ER now for around 3-4 months and have found the manuals and information supplied rather limiting. We have two sets of two Sun Solaris boxes running replication (one set as test, the second is live). We have managed to set up the servers and replic…
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.…
Enterprise Replication
My company is looking into Enterprise Replication for Informix 7.23 for a hot site backup. My first 2 questions are: Is this an appropriate vehicle for a hot site backup? Do we need the same type of server ( or another server with the same power) in order to replicate the entire…
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…
can't drop chunk from sbspace
hi all! i'm using solaris 2.5.1 with IUS 9.14.UC3 I don't know why I can't drop a chunk from a sbspace. with onstat -d , i choose to drop the chunk from clientsbsp3 > onstat -d INFORMIX-Universal Server Version 9.14.UC3 -- On-Line -- Up 7 days 11:19:15 -- 92872 Kbytes Dbspace…
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…
don't understand sbspace
hi all I'm using 9.14UC3 on solaris 2.5.1 when I monitor my sbspace by two differents ways . I got two differents results. by using onstat -d, here is my display: > onstat -d INFORMIX-Universal Server Version 9.14.UC3 -- On-Line -- Up 1 days 01:11:56 -- 91960 Kbytes Dbspac…
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.…
Informix IDS 7.30 to 7.31 (Informix has replied please upgrade)
Hi all, Informix have given us the usual response upgrade to version ....... My client has just been through two upgrades in the last 2 months, so this response is wearing thin. We are currently running IDS 7.30.UC5 on our Sun sparc Ultra-enterprise and Sun sparc Ultra-5. We ar…
HDR and enterprise replication
Does anyone know the difference between HDR and enterprise replication? It seems they both exist in version 7.3, but only HDR is available in 9.14. Thanks in advance, david.tamburin@protegrity.com…
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…
Does anyone know how to monitor ER?
Hello we have recently set up Enterprise Replication between to SUN Sparc boxes configured with IDS 7.30.UC5. We need to know how we can monitor the effectiveness of the replication and how we can monitor the send and recieve queues (i.e. No of transactions / Mb). Thanks, Step…
RE: HP-UX 10.20 , Informix 7.30 - advice needed
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_000_01BEA390.33834894 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit ****** Message from InterSc…
RE: replication
The older HDR, or High-availability Data Replication, replicates everything in one instance over to another instance (log-based replication); very robust, very simple to set up and administer, but rather restrictive; single primary to single secondary only (secondary is in read-o…
replication
Can anyone give me explanation of the difference between data replication enterprise replication.…
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: Replication on 7.24.UC5
Bill, You will need to specify what type of replication you have in mind. 7.24.UC5 supports Enterprise Replication as well as HDR. Just an FYI - 7.31 is now available and ER sites should be quite pleased with the improvements that we have made with that level. Bill Spencer wr…
IUS9.13: SBSPACE full
Hi, I'm storing some images on a SBSPACE. And as it became full (or almost), I don't know how can I free the pages in order to re-use the sbspace. I have droped the tables and database that uses it but it seems that it doesn't free the pages. Also, I've changed to the next logic…
ONSTAT
HI folks, looking for help using onstat -g que I would like to know if Enterprise Replication is working I don't know the meaning of this output.. Any help will be really appreciated. Thanks Javier Puente…
OnBar Parameter BAR_NB_XPORT_COUNT
Just a few hints about BAR_NB_XPORT_COUNT & BAR_NB_XPORT_SIZE. 1. The number of buffer allocated for sending data for a single onbar process to/from the storage manager. If you have 4 onbar process, you will have 4 * BAR_NB_XPORT_COUNT buffer allo…
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…
ENTERPRISE REPLICATION
Hi Informixs, I need some help in enterprise replication. I had worked with it since HDR, but now I have got some problems. I have a Primary_target replication scheme using a central server and four remote destinations with a 64kbps satelital connection. Sometimes replication j…
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…
Enterprise Replication
I'm trying to set up ER to replicate data between IDS 7.3 and IWS 7.3 on Windows 4.0 servers. When I start repman I get the error 406. Finderr says this is a memory allocation error, but I don;t believe this to be the case. Does someone have an idea what I've missed. I've sca…
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: Informix Performance
Speaking of this, when the 'User thread Status' shows 'Y--P---' it indicates that the process is waiting on a 'condition'. It often seems this indicates the process is waiting on some input from a user process via the network. However, this may not always be true. Is there a w…
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 …
Re: IDS Workgroup Edition
In article <729vhj$qv4$1@nnrp1.dejanews.com>, jshaley@my-dejanews.com wrote: >Thanks, Peter. > >I found this document early on in my search, but some of the marketing >verbage makes more sense now that I know something about the product. > >It looks like HADR is the replication f…
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…
Compuware EcoTools and Platinum ProVision
Does anyone happen to know if Compuware's Ecotools and/or Platinum Provision monitor XPS or Enterprise Replication? I am doing some consultant work for a customer of ours. Any information would be greatly appreciated. Thanks Adam Wright ITAG…
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…
Enterprise Replication
Has anyone out there set up Enterprise Replication in such a way that deletions on the source table are ignored on the target table? In our particular scenario we would like to replicate any inserts or updates to a particular table from the source to the target. However, we want…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Enterprise Replication
Hi there! I have been investigating Enterprise Replication and found that there appear to be two methods (not unrelated) that one can use to configure an ER environment: Use the NT admin tool or use the CDR (old name) API calls. Is there another way, such as some SPL I can't fi…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
help : about sbspace
I want to know how to use insert clause about sbspace. Many case, must use environment variable SBSPACE_NAME in onconfig file. Also can use 'create clause', some columns have CLOB type to be indicated to use what sbspace like follows. create table abc (col1 int primary key, co…
Enterprise Replication
Hello fellow informix users I have a really weird problem with replication. I have to replication groups defined on different servers. cdr server one comes up just fine but cdr server two shows itself in quiescent mode. The instance itself is on-line and you can access the datab…
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…
help : How to insert into sbspace.
If want to use CLOB or BLOB in informix, must create and use sbspace. I didn't setting the default sbspace variable SBSPACENAME in onconfig file, and I had to set it explicitly at table create time. like, CREATE TABLE mytable ( col1 INT PRIMARY KEY, col2 CLOB …
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.…
Enterprise Replication
Hello, Does anybody have experience with Enterprise Replication for Informix 7.23 Dynamic server? We've followed installation, as far as we know, to a T... running informix's snmpd on an HPUX 10.20 machine. We've got cdragt up and running, but everytime we try to connect with …
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: DBTEMP variable and sorted rows
> There are about 150 MB of free disk space. We're only sorting about > 10,000 rows. > Could it be some file system limitation? Are the files really created in $DBTEMP or is a (root-)dbspace used instead ? (you could check the free space in sbspaces using an "onstat -d" frequent…
Enterprise Replication Problem
Hello, I am having a problem with transactions being backed up in the send queue on the primary and not being transitted to the target system. I get the follwoing error messages in the message log ..05:39:38 CDR NIF site Forced connection abort-clean_up has failed cleanup s…
Fw: Enterprise Data Replication
---------- }Subject:: Enterprise Data Replication } Date: Friday, October 17, 1997 1:04 PM } } I was wondering how other corporations handled the security implications } when doing enterprise data replication, which requires hosts participating } in the replication to be fully tr…
Enterprise Replication
--------------8239C8961BAD1F313A3F5DA4 Content-Type: text/plain; charset=EUC-KR Content-Transfer-Encoding: 8bit I want to know something about Enterprise Replication I am currently using Enterprise Replication Manager(Platform winnt4.0) and Informix OnLine 7.23 for Solaris 2.5.…
Re: gfd virtual processor class...
: I was looking through the output of "onstat -g ioq", and it occurs to me : I don't have a clue what VP type "gfd" is (see snippet below). Can : anybody clue me in?? It's not a VP type. It's an I/O queue. I think it's Global File Descriptor (or something like that). Basica…
Re: Ready Queue
Are you using PDQ? Send your onconfig file as well as the output of t he onstat that concerns you. -Bill } } This is a multi-part message in MIME format. } --------------A4489FA28C25AB102697661A } Content-Type: text/plain; charset=us-ascii } Content-Transfer-Encoding: 7bit } } I…
Re: Runaway Informix SQL Processes. Need Help!!
In article <19970906041300.AAA08963@ladder02.news.aol.com>, Paynesys <paynesys@aol.com> writes > > I ran the UNIX vmstat & sar commands and discovered that our > system's CPU idle time was at 0%. I then did a ps -ef and > discovered two processes ( SQL queries via dbaccess ) tha…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: Automatic paging
There is generic paging software available which will send out pages from a modem. You simply queue a page w/ a message, and the software dials out via mode to your paging service provider. It's pretty straightforward stuff. So you can have your crontab running an `awk` script…
Re: Automatic paging
Cosmo Lee wrote: > > There is generic paging software available which will send out pages > from a modem. You simply queue a page w/ a message, and the software > dials out via mode to your paging service provider. It's pretty > straightforward stuff. > > So you can have your c…
Re: replication
Hello Maria, > I am interested in the functional differences in CDR (Continuous Data > Replication) and ER (Enterprise Replication). Informix originally called their "new" data replication product CDR (Continuous Data Replication) during the beta release. During the beta proc…
Onbar restore to a different machine.
I am trying to figure out how to back one AIX system running ODS 7.23 using onbar and ADSM and restore this backup to another AIX system also running ODS 7.23 and then setup up the systems in a replicated fashion using Informix replication(NOT enterprise replication). Help of any…
REPLICATION MANAGER
Hi folks, I am trying Enterprise Replication, I have installed the Replication Manager software in a NT-Workstation. When i start Replication Manager i define the sqlhosts as c:\\informix\\repman\\repman.txt, where repman.txt is sqlhosts (file from unix server). According to ER …
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…
IUS 9.0 problem with lost smartBlobspace
Hi Is there a way to drop a table, wich has an lld_lob row that points to an lost sbspace. (diskcrash) When I try to drop the table, always an error about an lost objectreference occurs. Greetings -- Philipp Gruenig Tecno Software Molerweg 42 2540 Grenchen Switzerland…
ENTERPRISE REPLICATION
Hi folks, Trying to configure the informix Enterprise Replication, I do have a problem. According to Informix documentation (Informix SNMP Subagent Guide) is required a master daemon of SNMP in the machine of the database server. I have a SUN Sparc 5 with Solaris 2.5 and my SUN …
Re: Parallel Database Solutions
Hi Jeff, Jeff Rochlin wrote: > Is anyone aware of a solution for Informix that will allow two servers > to access the same instance of a database at the same time ? No. This will not be possible anytime in the near future, sorry. > How about a database replication scheme that …
Re: Error -130
Klaus Voss wrote: > > David Williams wrote: > > > In article <33AE579D.D38FEC73@pixelpark.com>, Klaus Voss > > <voss@pixelpark.com> writes > > >The creation of a database in a Sbspace fails with ISAM ERROR > > -130: no > > >such dbspace, > > >although the Sbspace exists accordin…
Re: Error -130
In article <33AE579D.D38FEC73@pixelpark.com>, Klaus Voss <voss@pixelpark.com> writes >The creation of a database in a Sbspace fails with ISAM ERROR -130: no >such dbspace, >although the Sbspace exists according to onstat -d . The >oncheck-utility doesn't report any >error too.…
Enterprise Replication
Anyone out there using Informixs Enterprise replication? I am looking at using the tool to update other databases (some non-Informix) on a scheduled basis. I would be interested in your comments, information etc.. ----------------------------------------------------- Maria L. W…
Error -130
The creation of a database in a Sbspace fails with ISAM ERROR -130: no such dbspace, although the Sbspace exists according to onstat -d . The oncheck-utility doesn't report any error too. (Informix version is IUS 9.10.UC1 for Solaris) Thanks. Klaus…
Re: Faxing from Informix running under SCO 4.3v2.3
My USD$.02: VSI*FAX is a good solution, even better if set up correctly. You can easily set it to email the faxer upon successfully sending or failing to send (but not both; at least not simply) the fax. It also saves all unsuccessful faxes (which expired from the queue) in case…
Faxing from Informix running under SCO 4.3v2.3 -Reply
Try VSI*FAX from V-Systems, Inc. 32232 Paseo Adelanto Suite 100 San Juan Capistrano, CA 92675 (714) 489-8778 We send 200 - 300 court appearance notifications per day to officers. These are generated with …
Faxing from Informix running under SCO 4.3v2.3 -Reply
Try VSI*FAX from V-Systems, Inc. 32232 Paseo Adelanto Suite 100 San Juan Capistrano, CA 92675 (714) 489-8778 We send 200 - 300 court appearance notifications per day to officers. These are generated with …
Faxing from Informix running under SCO 4.3v2.3 -Reply
Try VSI*FAX from V-Systems, Inc. 32232 Paseo Adelanto Suite 100 San Juan Capistrano, CA 92675 (714) 489-8778 We send 200 - 300 court appearance notifications per day to officers. These are generated with …
Re: Online Instance Question
In article <5dqfq0$1dc@cssun.mathcs.emory.edu>, Jonathan Leffler <johnl@informix.com> writes > >I think, but don't know, that loopbacks do not actually send the data >onto the physical network. > Correct - it is handled internally by the IP device driver which recogises the l…
Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
This is a multi-part message in MIME format. --------------C4C26D4394 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit David Williams wrote: > > In article <4rsf8p$kt@sjx-ixn4.ix.netcom.com>, Stuart Cracraft > <cracraft@ix.netcom.com> writes > >The…
Re: 4gl & ipc queues
In article <31E2C723.6128@thisco.com>, Rob Gajdica <rob@thisco.com> wrote: >> has anyone got an easy way of sending/receiving messages from a svr4 ipc >> queue using 4gl? i'm running 6.01.UD1 4gl on a 7.10 server on a pyramid >> nile 100. we do this, but on 5.0, SCO UNIX. work…
Re: Help wanted - accessing a serial port from 4gl
Richard Moon wrote: > > We need to be able to have a 4gl program talk directly to a specific > serial port on an HP9000. We need to be able to send messages to this > port and receive data back from the device attached to it. > > The program will be run by many users concurrently…
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: Oracle replication wasRe: Sybase 11 TPCC on DEC (your comments please)
>Actually, Oracle allows 2 phased commit and asynchronos replication. It >depends upon what you want to do. Having a choice is a good thing. Sometimes >one wants to require enterprise wide consistency (2 phase commit) and other >times asynchronos replication will be most appro…
How to send event at fixed interval time with NewEra
I want to design a program to open a MODALPOPUP Window , When user not input anything at a fixed time interval( such as 5 minute), this Window will automatically close . I try to use send event to event queue to fix this problem, but I can no get desired result. I do not know ho…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Barcodes and Informix
In <ywJBLc5w165w@cssnet.sanford.nc.us> david@cssnet.sanford.nc.us (J. David Schronce) writes: > I'd like to be able to generate BarCodes for my picking tickets and > shipping documents. Has anyone had any succcess creating these from > Informix? > > Hints, and instructions …
Re: Informix I-Net problem
In-Reply-To: <1992Aug14.223601.8529@informix.com> billd@informix.com (William Daul) In article <1992Aug14.223601.8529@informix.com> billd@informix.com (William Daul) writes: > PROBLEM: > ================================================================= [stuff deleted] > RESPONS…
Re: Informix I-Net problem
FROM: The Informix Closet Engineer PROBLEM: ================================================================= >From shemminga@cix.compulink.co.uk (Stuart Hemming) Newsgroups: comp.databases.informix Subject: Informix I-Net problem Date: 12 Aug 92 16:44:00 GMT Can anyone help m…