Oninit® Archive
Results for “onstat -g rqm”
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
Hello, I need to clarify how to use cdr sync cdr sync sends always ALL rows and apply them on target using conflict resolution Alway - to speed up we can truncate target table, in order to not update existing rows by sync process can we use normal transaction activities during th…
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,…
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…
log usage difference insert vs update
Original post: I created a table as: create table t1(c char(5120)); loaded a file of about 5 thousand lines (on average string of 25 bytes). It consumed around 5MB log space. But if i update these records update t1 set c=c||c where 1=1; then log space consumption is around 1.15 …
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
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…
CSDK version
Mukesh: icsdk_4_10_FC9_WIN_64 and icsdk_4_10_TC9_WIN_32 are the latest CSDK releases. Best regards, Martin M. Graney Queues Enforth Development, Inc. This electronic message contains information which may be privileged, confidential, or otherwise protected from disclosure. The…
Connect informix using Active Directory account
J - Are you getting any incorrect username or password entries in the IDS message log or is it not getting that far? I had SAMBA set up in my support and development environment for our LINUX and UNIX systems and had the domain pass-through authentication working to my Windows …
HDR Cannot connect
Dear Benji: I usually test my connection between the HDR pair beforehand by initiating a DBACCESS session from one server to the other and visa versa. This will let you know if one instance can see the other, can connect to it, and if you are authenticating. Good luck. Best re…
CDR DS CDRD_xx thread is aborting
Your stable storage SBLOB for the receive queue was probably unlogged so when the fail-over occurred the transactions were not complete. While it might look scary, it is probably not a real issue. Items are placed in the receive queue only when the receive memory buffers become …
More Smart Large Object Problems
Dear David: I will look at your previous emails to get a better idea of what you're doing, but I can say my company does the same thing (public safety), and we do not experience the issues you are describing when storing images in sbspaces. Best regards, Martin M. Graney Queues…
CDC vs ER
Hi, our customer wants replicate data to oracle and informix server. For oracle wants use CDC and for informix too. Do you have somebody experience with replication over CDC ? 1.informix to oracle and other database system 2.informix to informix. I'm interested also to compare p…
CDR_QDATA_SBSPACE
Do you have ER queued data in send queue ? what are outputs of , cdr list server onstat -g rqm brief ? Thanks Frank On Mon, Mar 14, 2016 at 7:01 PM, jorge valenzuela <jorgervt@gmail.com> wrote: > Hi, > > I have a dbspace specified in the CDR_QDATA_SBSPACE. > Acoording with …
Mutex logs on logical log flip
Hi Neil, what I used to do in the past when on SOL11, before T5 bacame available: - compare sum of total of the cpuvps to the sum of total of non-cpuvps This shows tli using 6.7% of sum of total and has to be considered when it comes to parallel execution. You should investigat…
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)…
Migration from 11.50 to 11.70
It depends on how much data there is. I'm an advocate of clean installs. DBEXPORT UNINSTALL old version INSTALL new version Configure new version DBIMPORT Best regards, Martin This electronic message contains information which may be privileged, confidential, or otherwise pro…
CDC Informix
Dave I have CDC running against a ER target to capture changes and pass on to $QL$erver. I cannot really comment on performance as there is nothing else accessing this database, it is only there so that CDC is running across a LAN rather than WAN (ER handles WANs sooo much bette…
CDR question on big transaction
HI, But I execute 'onstat -g rqm recvq' in the target size, I see the first transaction doesn't change for more than 1 hours.…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
ER queue data
Folks, IDS11.70 FC7, RedHat Linux 5 These days, we are really struggling with Informix ER replication, it just queues data there ( see below, a three site replication Anywhere). The problem started after we upgraded from IDS11.50 FC8 . We were happy with IDS11.50 FC8 and had n…
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.…
ER network replication state
Hi Madison, that the problem is on the target would explain that we have the same problem on the 2 source servers. But why we cannot see anything on the receive queue? There was no spooling. Or 'full receive queueu' means only the memory queue has to be full to get this blocking …
Enterprise Replication recovery slow on Solaris
What is the output on the target of onstat -g ath onstat -g rcv full If there was a large backlog on the source node, then most of the transactional backlog would be in stable storage so there could be an i= ssue with reading the replicated transactions from disk. What is the on…
Re: ER issue
Yes - basic checks look good - although onstat -g nif shows run/blocked on server 1 [informix@psdb01spr logs]$ onstat -g nif IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line -- Up 9 days 08:37:50 -- 20724404 Kbytes NIF anchor Block: 0x7d2f0ad8 nifGState …
ER issue
I have two IDS 11.7FC7 servers replicating data. I have ER replication between the two, all data changes are made on server 1, recently it appears that data has stopped moving to server 2. The sendq on server 1 continues to grow, while the recvq on server 2 appears to be stuck…
Re: Informix on Linux on VMWare
>From (bad) experience; get as much memory as possible dedicated to the VM and use it for read-ahead buffering. The low I/O bandwidth will really hurt you if there's any decent amount of buffer churn / updates. Try to persuade your VM admin to get you a virtual disk on an under…
Re: Informix on Linux on VMWare
Keith: Points: - All Linux distros are about the same to my mind. I've used RH, Ubuntu (Debian based), and SUSE and all work just fine with Informix. - Any Intel processor you select and any number of cores will outperform the T-class Niagra CPU cores in the Sun T5…
Informix on Linux on VMWare
Hi It looks like I am going to have to migrate an IDS instance from Solaris to Linux. Current machine is a 16Gb dual chip SPARC T5120 with twin path, fibre attached disk (Raid 1) running IDS 11.5 on Solaris 5.10. Target machine is likely to be similar memory on a generic Intel p…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
ER queue question
Solved: The queues of the affected replicates could be cleared by "cdr stop replicate replicatename" and " cdr start replicate replicatename" while there was no activity on the corresponding tables. THX. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-boun…
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,…
IWA: Error loading datamart
This is the error returnet: loadMart IWA1 rips_ac_consulta NONE -------------------------------------------------------------------------------- Warning: AQT10205I DETAILS IN MESSAGE OUTPUT PARAMETER 4 / SQLSTATE: 01H08 -----------------------------------------------------------…
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…
Help in defining 3rd ER server
Original Question: 11.50.FC8 AIX I have an existing ER configuration between two servers, A & B. I am trying to add a third server into this configuration so the relationship would be as follows: Update anywhere between A & B Trying to define: A replicates to C B replicates to …
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
HDR question once again
Your only solutions would be to make your primary an ER root server and add another ER node (or a second primary-HDR pair replicated by ER from the current one), or you could use a third party replication product to create a secondary. Hit Software's DbMoto works with Informix, …
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…
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…
Problem with enterprise replication
Andrew Is this on the source or the target ? 1. Is the 'other' IDS instance still running correctly ? 2. Is there an open transaction spanning you entire logical logs ? 3. onstat -g ddr onstat -rqm BRIEF onstat -g dss IDS Version(s), O/S(s), ER Setup ??? Keith On 2 August 2…
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…
log usage with ER and blobs
Karl, We won't log the blobspace blob data when writing it, and also for a blob space blob, we extract the blob when transmitting the replicated transaction to the target server. However, on the target, we may have to spool the blob because we can't apply the replicated transac…
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 …
Replication problem
Hi, onstat -g rqm brief -r 1 | grep "grp_24_kzn (24)" to monitor the growing of the queue On server grp_24_kzn: cdr list repl to monitor that all replicates are ACTIVE on THAT server HTH, Reinhard. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@…
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…
Replication - cdr list serv
cdr list serv shows the servers involved in potential replication. onstat -g rqm brief shows the transaction which need to be transmitted from that none. The two commands are orthogonal with each other. On the surface, I would say that this indicates that there is nothing queued …
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
ER Question
Hmmm - it looks like there is nothing in the receive queue - I'm checking with my network people to see if there is data passing between two of the servers. Are there other configurations I should check? I can do a cdr disconnect... but then the cdr connect fails. Funny tho, the…
Looking for a recommendation for a 3rd party data
Hi, Take a look at IBM Infosphere Change Data Capture, aka CDC. CDC provides heterogeneous replication among the major RDBMS products. It's very good, and it understands things like date format differences so you don't have to do anything. Cheers, Dick Snoke IBM ChannelWorks d…
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 problem
Have you tried running "cdr stop" and the "cdr remove" before dropping the syscdr database? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KARL OLIVER Sent: Tuesday, 21 September 2010 3:25 p.m. To: ids@iiug.org Subject: enterpris…
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
On the surface this looks like you have some partially spooled transactions. First of all , what is thread 205? Can you get an onstat -g stk 205 and/or onstat -g ath | grep 205. From: "Jarrod Teale" <Jarrod.Teale@fonterra.com> To: ids@iiug.org Date: 08/23/2010 12:11 AM Subjec…
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…
why so many informix threads on idle systems ?
Trying again... |------------------------+---------------------+-----------------------= -| |Thread |Purpose |When activated = | |------------------------+---------------------+-----------------------= -| |CDRD_### |ER apply thread |When a replicated = | | | |transaction is rece…
RE: Replication queue filling up [18787]
There is a known CDR Defect (IC65273) in that version of IDS (we had a similar issue). The problem exists since a fix in 11.50.FC2. It will be fixed in the next correction 11.50.FC6W1 probably. The problem is that the send queue will not be emptied. Workaround: Avoiding of Spool…
RE: CDR connect error
Yes, Art, that's absolutely possible. Had have similar problems with HPL while transfering data through named pipes to the server grp_db5. Although, the serverhosts are all in the local network with 1000 Mbps (dmesg: link up 1000Mbps Full-Duplex). Must ask our network specialist…
Re: CDR connect error
Errno 6 is: No such device or address It looks like your communications between the primary and secondary servers is not reliable. The primary keeps losing touch with the secondary. I have a client with the same problem. Their telecom supplier is installing faster cleaner lin…
CDR connect error
Hi while trying to set up a new replicate and working on a very long queue (up to 80.000.000 length whatever) there appear connection errors in the message log: 17:26:57 CDR: Re-connected to server, id 5, name <grp_sun1> 17:27:19 CDR NIF receive failed asfcode: -25582 oserr 6…
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…
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…
RE: Writing into Files from Stored Procedures
Art, So which databases allow one to write a stored procedure in Java? C? or ESQL/C? The point is that if you write something in C or ESQL/C your solution will be less portable to Oracle, than if you had written the stored procedure in Java. Interestingly enough, Informix once …
Re: Writing into Files from Stored Procedures
I know this isn't a developer's forum, strictly speaking, but you've hit one of my small retinue of pet peeves. They include touting the benefits of RAID5, placing parenthesis around the operand to 'sizeof' in C when that operand is a variable, and statements like this one of yo…
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 …
Informix page cleaners (w/ a SAN)
There are other competing recommendations also. You should have at least as many CLEANERS and LRUS (or the total of all lru parameters in all of the BUFFERPOOL settings). Another is one per physical disk (with SANS and other large arrays that one has gotten mostly deprecated.) Th…
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.…
ER problem / bug? in 11.50.UC3
Madison Pruet wrote: > Jarrod Teale wrote: >> Madison, >> It's a test system - we will rebuild. Thanks >> Jarrod > > OK - I've opened a bug for this problem - 172306. There's no need to > open a case for this. I've tested a patch and we'll be including in the > build after tomor…
ER Error Enterprise Replication
On Jan 30, 1:35 pm, TBP <TheBigPota...@Nothere.Co.Uk> wrote: > On Jan 30, 6:04 pm, bozon <cur...@crowson1.com> wrote: > > > > > On Jan 30, 11:07 am, Madison Pruet <mpru...@verizon.net> wrote: > > > > bozon wrote: > > > > Enterprise Replication is giving the following message when…
Basic trouble on ER - primary/target based
2008/12/19 ALEXANDRE MARINI <amarini@fazenda.ms.gov.br>: > Hello! > I have made a primary/target ER on IDS 11.50.FC2, for testing purposes. > My groups are named g_primary and g_target. I started the 2 servers just fine. > Then I created 2 replicates, based on a "select * from" s…
slow connections
> My idea : > > - OS level such as kernel parameter, error log from system > , i/o busy > - Network level such as network card errors , network log > > For IDS : > - Check point duration and check point interval (system will be blocked while doing checkpoint) > - try to change > …
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
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.…
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…
Replication question
Laurie Gustin wrote: > Hmmm - the replay position hasnt been overwritten. I have attached onstat -l and onstat -g ddr outputs. > > I added a bunch of logs last night to make sure we didnt block again until I could do more research this morning (and think more clearly..) > as you…
HDR recommendations
mohitanchlia@gmail.com wrote: > On Aug 23, 8:45 pm, Madison Pruet <mpru...@verizon.net> wrote: >> mohitanch...@gmail.com wrote: >>> Could somebody tell me their experiences about HDR. I am reading about >>> HDR to see where we can improve. We ran our tests and the performance >>>…
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…
Enterprise Replication question
Jarrod Teale wrote: > 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. Please post the command you used to…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
cdr flush interval
vomaringo@yahoo.com wrote: > hi, > onstat -g rqm sendq show a 30 sec ? flush interval. the replicates are > define with immediate flag. > is there a parameter to accept lower flush interval without loosing > data? > thanks. > The RQM SENDQ flush interval is how often we update th…
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…
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…
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: how to copy large data fast
Hate to tell you this, but MySQL has the feature to turn logging on/off per table. Very nice feature. You flip it into MyISAM to load/unload, then flip it back to InnoDB--or whatever other format it was as a logged table. Very easy, and great for lazy people like me. I hate …
Re: how to copy large data fast
If the new database is not being used by anyone, you could certainly turn logging off on the receiver database, run the load, then turn logging back on. Same for the database with the data, if no one is in it, turn the logging off, run the unload, then turn the logging back on. …
Re: Crazy HPL Error....
Neil Truby wrote: > "Tam O'Shanter" <tam@oshanter.com> wrote in message > news:PQCfh.426276$tl2.81137@fe10.news.easynews.com... > >>Greetings, >> >>Muddled my way through unloading a large IFX 10UC4 database and am trying >>to work through the load process. >> >>HPL is really ama…
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…
Sporadic performance issue
IDS 10.0UC4W3 on RedHat 4 AS The customer's database server, which has been running happily for months, has started, sporadically, to experience very high loads as measured by top on Saturdays (the busiest time of the week). At these times the Informix ready queue is sky-high -…
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@…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
CDRGfan and Database crash
Hi All, MASTER: TARGET: IDS 10.0.UC3 IDS 9.40.TC6 ELAS3 (Kernel 2.4.21-4.ELsmp) Win 2K3 DELL PE 6600, PERC4/DC We had a DB crash. Oops !!!! Logged the issue with IBM thorough our ap…
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/…
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: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
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…
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:…
Performance Issues
Beginning to get stuck. :-( Is the underlying Unix Server performing OK? N= o contention/bottlenecks on disk, memory or CPU? I assume nothing specific= changed (application wise) about three weeks ago that could have caused th= ese problems? Have you monitored onstat -u to see if…
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: Single cpu vp woe
Neil Truby schrieb: > 9.20 UC3 on Red Hat 7. > > This site is running the time series datablade in production on a 2-cpu box. > It's all working fine. > > For reasons we needn't go into they want to move to a single cpu box. > They've set up an identical test server. When we run…
Single cpu vp woe
IDS uses preemptive scheduling, the OS uses preemptive with timeslice. Sometimes it's best to let the CPUVPS 'duke it out' by over configuring a bit so you get a bit of timeslice scheduling. ;-) My guess is that there are other things causing the hit. For instance, if a thread…
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: Running Informix on 2 different Servers in parrallel
wcottishpoet wrote: > Neil, > > other than the holiday, how about all the following which are available > in 9.40 .... > > > Improved Performance 8-15%better in internal benchmarks;Fuzzy > Checkpoints;Shared Statement Cache;New Buffer Management System;B-Tree > Scanner;Improved R…
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: 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…
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'?…
Re: HDR question
I normally take it granted whatever comes from Madison especially for ER/HDR. Also, not sure if this may help any thing to you. 1. onstat -g ddr 2. onstat -g rqm FULL Hari…
Re: Enterprise Replication no start or stop
That means that some thread has a lock on the control table. You need to examine onstat -K to see who has locks on what and then determine why any thread has the control table open. If the cdr threads are not running, then I would not expect to see any thread which would be ope…
Enterprise Replication no start or stop
Are the times of the two servers within 5 mintues of one another? As far as I can tell almost every ER problem is caused by this! "Darek" <darek_usunto@supra.com.pl> wrote in message news:chuk81$bah$1@nemesis.news.tpi.pl... > Hello everybody, > > I have a problem with enterpric…
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…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
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
In 7.31 and 9.21, the space allocated in the send queue is not reclaimed because the data is stored as a partition blob. With 9.3, we have moved the disk queue to a smart blob, which enables us to reclaim the space. I would not attempt to use fragmentation to reclaim the space.…
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.…
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…
Incremental Archive performance issue......
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_01C41DAB.E6121798 Content-Type: text/plain; charset="iso-8859-1" Hi, Our QAS system is a Sun E450 box with a sun s…
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…
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: 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…
RES: CDR problems
I'm using ER and all replicates are good (according to the commands outputs). I think the performance problems are in the update statistics. -----Mensagem original----- De: Simmons, Keith [mailto:keith.simmons@office2office.biz] Enviada em: segunda-feira, 19 de janeiro de 2004 1…
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?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: ER problem HPUX - Linux
I would run the following commands to determine few things as below: 1. onstat -g ddr NB: Make sure all IDs in the output MUST be same, if replication is up and running and nothing is in the que. 2. onstat -g rqm BRIEF 3. onstat -g rqm FULL Hari Richard Kofler <richard.kofle…
strange error: CDR RQM rqmPurgeSpool() failed for KEY...
will do btw is 9.40-UC2E1 the most current release? regards hoyte "Madison Pruet" <mpruet@comcast.net> wrote in message news:51Amb.13115$275.27298@attbi_s53... > I thought that we had gotten rid of all of these. > > Basically we were trying to remove a control message and it app…
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: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Re: 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…
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…
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…
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…
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…
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…
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…
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: oncockpit showing incorrect onconfig values
> Over the weekend I made some changes to my onconfig, BUFFERS > from 75000 to > 80000, CLEANERS and LRUS from 25 to 67. I then bounced the engine. > Onstat -R reports the correct figures as you would expect from above. > However, if I monitor the instance using oncockpit (shar…
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?…
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…
Re: Slowness
"Art S. Kagel" wrote: > > Tavis Elliott wrote: > > > > * snip * > > > > > > ********** OUTPUT FROM onstat-p ********** > > > > > > > > Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 8 days 14:55:04 > > > > -- 491520 Kbytes > > > > > > > > Profile > > > > dskreads …
Re: onstat: Shared memory: permission denied???
dmoeller@geocities.com wrote: > > Marc, > > You might try adding that 'other' user to the informix group. > > Here's what 'ipcs' outputs on my system: > IPC status from <running system> as of Tue Jun 6 10:38:3 > Message Queue facility not in system. > T ID KEY …
Re: onstat: Shared memory: permission denied???
Nononononononononononononononononononononononononononononononononono!! From: dmoeller@geocities.com > >You might try adding that 'other' user to the informix group. Nooooooooooooooooooooooooooooooo!!! Major security violation. >Here's what 'ipcs' outputs on my system: >IPC sta…
onstat: Shared memory: permission denied???
Marc, You might try adding that 'other' user to the informix group. Here's what 'ipcs' outputs on my system: IPC status from <running system> as of Tue Jun 6 10:38:3 Message Queue facility not in system. T ID KEY MODE OWNER GROUP Shared Memory: m …
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…
Re: What is bufwaits (onstat -p)
"Art S. Kagel" wrote: > > The bufwaits indicates when a thread has to wait to read a page into a > buffer from disk usually this is caused by the LRU Queue to which the thread > has hashed to acquire a buffer being locked by another thread trying to do > the same thing or needing…
Replication: Flushing Receive Queue
In our replication environment (Primary-Target), the recieve queue on the target is FULL. How do you empty it? TIA Environment: Solaris 6 IDS 7.30.UC9 -- Steve Romankiw Chubb / Executive Risk 82 Hopmeadow Street Simsbury, CT 06070…
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…
Making a system call through a SP on NT from a SCO machine
Help needed! The following set-up applies : Informix version: 7.30 UC2 Question 1 On SCO machine (v 5.0.5): On Insert/Update/Delete of data in table "X" a custom written replication queue is built - Files for the different destinations are created. A transaction is started ap…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
CPUvps
Madison Pruet wrote: > > I think that Mark Stock has already raised the question of 'more CPUVPs than > physical CPUs'. I'm going to attempt to address CPUVP scheduling. > > We don't attempt to equalize the load of the CPUvps because unlike disk IO there > is nothing to be gaine…
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…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Database logging and OnBar
You must use the ondblog utility to queue/register your request, then use onbar -b -F (or a normal backup without -F), which will then actually switch your logging mode. Gabor Jon Wollman <jwollman@modacad.com> wrote in message news:38337395.D00EC9E2@modacad.com... > try backin…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
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…
Re: Single CPU Performance Problems?
Could you please supply some info about the disk config of this machine. The internal drive on the Ultra5 is not the 'most performant' in the world! Where is the data coming from that you are trying to load into the database? For an 'opinion' on general Sun performance issues, tr…
Re: Single CPU Performance Problems?
Addition to all the good people's comments, you should look into Sun Box more closely.. What I have noticed in your onconfig file; most of them you still kept it as default... Is this parameter same on both NT and Sun box..? - If it is so you should tune Kernel of…
Re: Single CPU Performance Problems?
Is the java program running on the database server or on a separate client? 3.5 rows/sec or 10 rows/sec sounds pretty abysmal. I'm guessing the problem is in the client to database communication speed, not within the database itself. To give you some idea of reasonable insert s…
Single CPU Performance Problems?
Hi, I need some help tuning a single processor Sun Microsystems Ultra 5 system with 256 meg of memory running IDS 7.3 and Solaris 7. We have an application written in Java that frequently loads large amounts of data into the database. We can not seem to get reliably good perf…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
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…
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…
ONSTAT
First of all, there is a significant difference between onstat -g que pre-7.31 versions and 7.31. Also, I really think that the onstat -g rqm is a bit more useful than onstat -g que. In 7.2x and 7.30, there is a bit of redundancy between the two onstats. I'd go with onstat -g r…
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…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: 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 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
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…
You like BRILLIANTS? Then you will be interested!!!
JUST CLICK FOR YOUR BRILLIANT!!! http://absolutelyagency.lt/brilliantnet/ begin 600 A19715.jpg M_]C_X `02D9)1@`!`0$`E@"6``#_VP!#``\\*"PT+"0\\-# T1$ \\1%B48%A04 M%BT@(ALE-2\\X-S0O-#,[0E5(.S]0/S,T2F1+4%=:7V!?.4=H;V=<;E5=7UO_ MVP!#`1 1$183%BL8&"M;/30]6UM;6UM;6UM;6UM;6UM;6UM;6UM;6UM;…
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: +…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
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…
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…
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…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: 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…
INFORMIX DEVELOPER/DBA AVAILABLE IMMEDIATELY
TO : ALL EMPLOYERS FROM : TECHNA INTERNATIONAL CORPORATION 17777 MAIN STREET, SUITE 60/G2, IRVINE, CA 92714 (VOICE) : (714)852-9394, (FAX) : (714)852-9420 ENCLOSING RESUME OF ONE OF OUR CONSULTANTS WHO IS AVAILABLE FOR CONTRACT POSITION. HE IS AVAILABLE IMMEDIATE…
INFORMIX DEVELOPER/DBA AVAILABLE IMMEDIATELY
TO : ALL EMPLOYERS FROM : TECHNA INTERNATIONAL CORPORATION 17777 MAIN STREET, SUITE 60/G2, IRVINE, CA 92714 (VOICE) : (714)852-9394, (FAX) : (714)852-9420 ENCLOSING RESUME OF ONE OF OUR CONSULTANTS WHO IS AVAILABLE FOR CONTRACT POSITION. HE IS AVAILABLE IMMEDIATE…
Re: Looking for a good job Scheduler / Batch Processer
Please consider PLATINUM AutoSys for your UNIX job scheduling requirements. A large problem for companies using Unix is the management of distributed processing that is required within their environments. Many organizations begin using cron and shell scripts only to discover th…
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 …
Summary: Which development tool?
This mail is the summary from every mail that you sent us. Thanks everybody for your contributions and any further comments are welcome. PRODUCT: ART*Enterprise. CHARACTERISTICS ART*Enterprise is a client server development tool. It has a front end interfase builder which use…
Informix problem
Informix Users, Below are the code sections where the records are inserted into the table and then the code where the data is retrieved. Once again the process that occurs is: o receive tx from process a place record in master table place re…
Re: Suggested Changes to 4gl
In <1992Dec14.215058.24334@netcom.com> pmahler@netcom.com (Paul Mahler) writes: >Hello the net, >So far the only responses I have received have been suggestions >for changes to the input array statement. Is everyone really >this satisfied with 4gl? Is there nothing else we can…
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…
Re: ESCAPE key (was Re: How can I assign the interrupt action...)
In article <9153@emory.mathcs.emory.edu>, carsinfo!carsmax!bryan@uceng.uc.edu (Bryan Klopfenstein) writes: |> However, I'm also confused. Isql uses the ESCAPE key to start a query, |> the ubiquitous vi uses the ESCAPE key and escape sequences (such as |> arrow keys) quite well. M…