Oninit® Archive
Results for “SMX_COMPRESS”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
HDR Issue
It sounds like you're setting up an Informix HDR (High-Availability Data Replication) environment on your personal laptop using Oracle VirtualBox and RHEL 7.9. Since you've checked the Linux side connectivity and everything seems fine (e.g., Telnet, SSH), the issue might be relat…
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 ------------------------------…
Informix 14.10.xc11
The manuals are usually pretty up to date, specifically the "What's New" section where you can see the FC11 items. What's new in Informix ibm.com Specifically: Internal IBM Java packaged with Informix server removed • GSKit upgrade • InformixHQ 2.4.1 enhancements • Partial Index …
IFX 14.10xc8 Updatable RSS and CPU Usage
Hello, In dev env. i've configured a pimary with 2 rss. there is no user activity and i see a high usage of CPU when a do a onstat -z followed by onstat -g smx i've notice a very high number at #scheds onstat -z; onstat -g cpu | grep smx IBM Informix Dynamic Server Version 14.10.…
HDR
Dear Casey, Now I have changed all settings. PRIMARY SQLHOSTS # sqlexec-ssl 9089/tcp on_nebula31 onsoctcp sk-om-ifx-402 soc_nebula31 on_nebula32 onsoctcp sk-om-ifx-402 soc_nebula32 ~ PRIMARY /etc/services soc_nebula31 51001/tcp soc_nebula32 51002/tcp PRIMARY /etc/hosts.equiv # ho…
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…
Replication (RSS) instance it not coming up
Hi All, I an new to the Informix anf getting below error. Please help IDS version : 12.1 OS : SUSE Linux Host Name : Server1 Server1 is hosting 17 informix RSS replication instance. we have create 1 replication instance around 1 month back. it was running fine. On one file day …
RSS Encryption Performance Hit?
Original post: IDS 12.10FC3 Solaris 10 1/13 Is there any significant performance hit to enabling encryption for RSS? Is enabling RSS encryption really as simple as just setting ENCRYPT_SMX (and any desired optional ENCRYPT_* parms) on both ends (we have only a primary and one …
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…
HDR is not working
Dear All, In our environment we have configured HDR. it is successfully configured. Today unexpectedly primary server got physically restarted with unknown reason. But as per HDR setup application should redirect to secondary server, which has not happened, still the secondary s…
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.…
RSS does not apply logs
hello, I have the following situation. I would be very pleased if somebody could put a light into this. Thanks a lot, JUAN Primary: amc1_rss RSS server: amc4_rss RSS DeLAY_APPLY 5M Why does RSS secondary not apply logs up to 116024, having long past the 5 minutes delay config…
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…
Any HDR restrictions on Informix Innovator C?
OK, I only use secondary for failover. BTW, I found that information on this link: (this is for editions 11.50 - 11.70.XC4) http://www.iiug.org/library/ids_11/Compare_Informix_Editions.pdf IBM Informix Innovator-C Edition Market: Small Production Workloads License Information …
cdr autoconf serv failed...
Hallo everyone. I have two servers with Informix 12.10.U8 (Linux) and I want to make an "update anywere" ER between then. Local network, no firewalls, CDR_AUTO_DISCOVER = 1 on both servers. host1: - INFORMIXSERVER=server1 - sqlhosts: g_1 group - - i=1 server1 onsoctcp host1 9088…
HDR- Distance and Latency
A couple of additional points. HDR communication is half duplexed over a single network connection while RSS ( SMX) is using full duplexed mode. Additionslly SMX can run in parallel over multiple network connections resulting is a significant boost to effective bandwidth. Sent fr…
Implementing HDR on Windows 2012 R2 Servers
Hello Friends, Need A Help on Immediate basis. We are implementing HDR(High Availability Data Replication) on Windows 2012 R2 Server. Steps done: 1) Two new Windows 2012 R2 Servers. IDS 12.10FC8 installed and created the instance manually using Server Instance Manager. Serve…
Connection Manager configuration
Mike Walker has already pointed to some information that will help you. There are two functions of the connection manager: 1) direct the application to the appropriate server and 2) monitor the servers and determine if a failover is required. If you want to only connect to the …
HDR Implementaion
Yes I am posting the Secondary server Online log 20:58:15 IBM Informix Dynamic Server Started. 20:58:15 Requested shared memory segment size rounded from 4308KB to 4796KB Mon Jun 12 20:58:17 2017 20:58:17 Requested shared memory segment size rounded from 110629KB to 110632KB 2…
ISSUE regarding IFXCLONE
Hello, After running ifxclone for more than 10 hours and being conscient that nothing was happening (just rootdbs and physical log dbspace were noted in the message log saying that physical restore was done, data dbspace had initied the physical restore but not yet done), (the in…
HDR Solution
Hi, Currently we have used informix IBM Informix Dynamic Server Version 11.50.FC8GE workgroup edition running on hpux. Our production load already full utilize during peak hour. To reduce load on production server, we plan to separated process to another server, means OLTP proce…
CDR DS CDRD_xx thread is aborting
HI, All, IDS11.70 FC8 A little bit complicated system generated the massive errors ( below). System architecture : a GRID is composed of 3 instances A, B and C. A is the grid master and also a HDR primary server of a Secondary read-only server D . A and D are configured with D…
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)…
sh.addShard
Hello, IDS 12.10 FC4 RHEL Linux Used MongoDB shell to create a Shard. Did a bunch of configurations, setup, tests...... Eventually, I am stuck here, mongos> sh.addShard("leslie-dat:9171") { "code" : null, "ok" : 0, "errmsg" : "command failed -- undefined server (37) " } mo…
Wakeup RSS Server
Stuart, What version are you running? We had some problems but now work reliably. Art suggested 'kicking it' by re-running the 'onmode -d' command on the secondary. I still think of this method that it can often work with HDR, but I have never seen it do anything useful with RS…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix/Oracle
Flip: Whoa! I've heard of salespeople streching the truth, but this is a bald faced lie! Or more than one actually. Either the salesman is lying to you or his management lied to him! I'm sure someone from IBM will join this thread, but for now here is the truth as I know it: - …
infxclone
1) SMX_COMPRESS 1 2) Set BAR_MAX_BACKUP greater than 1. = From: "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstore= s.com> = To: ids@iiug.org, = = Date: 06/18/2014 09:37 AM = = Subject: infxclone [33231] = = Sent by: ids-bounces@iiug.org = = Aix 6.1 IDS 12.10.f…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
RE: HDR replication with data encryption
Turn on SMX encryption for RSS encryption. Sent from my iPad > On Nov 29, 2013, at 11:27 AM, "LARRY SORENSEN" <lsorensen25@msn.com> wrote: > > I am running two Sun servers running Solaris 10 and IDS 11.50.FC7. > > We have been performing replication locally, and so we have neve…
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.…
Strange HDR behaviour
There is/was an issue with HDR regarding "SMX thread is exiting " and it does not re-establish connectivity unless the affected HDR server is restarted. (Unless it is fixed in 12.1). If that's the case then you would see the following in the msg log : 15:26:34 DR_ERR set to -1 1…
Replication problem or stand alone server problem
Does the onstat top line still show the primary server is in primary mode? If the logs on the primary are secondary are still compatible you could try putting the primary back into primary mode and run the onmode -d secondary again on the secondary. That sometimes works when th…
Frequent HDR failures: -25572 (oserr = 0 or 4) generally needing restart (11.50FC7 on SLES)
Hi All, I'm more a developer than a DBA, but after our DBA left, I seem to have inherited the job of supporting a number of servers running development databases on a free version of Informix - Innovator-C 11.50.FC7IE The development boxes are running as HDR pairs, and we've ne…
a problem with backup a logical logs
Hello, Yesterday I have a problem with the backup the logical logs and I attached the information that I got from Informix: Can anyone help me to find the problem in order to void this in the future? Any help will be welcome Regards Muthana Here is the information I get from …
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
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,…
Using ifxclone to setup HDR
Original Post: I haven't played around with ifxclone as of yet, but that error on the target would seem to imply that it was having problems connecting back to the source. Can you post what the sqlhosts file on the target machine looked like? (just for note on solaris you can us…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
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
Jack: You are missing a lot. A bit of recent history then. Informix from version 7.10 through 7.31 and 9.10 through version 10.00, supported two overall replication types: 1. HDR or High availability Data Replication - This supported one read/write primary server and one read-…
multi-threaded ifxclone?
I found a session from last years IIUG conference by Hyun-Ju Vega and it says the following in the powerpoint: Source archive data is sent to target using SMX (parallelism is controlled by BAR_MAX_BACKUP ONCONFIG parameter on target) I set BAR_MAX_BACKUP to 4 on my target machi…
CLR vs Long Transactions...
Switch to HDR, that's what it is for! Or RSS of the servers are too far apart. Then you can stop switching logs every 5 minutes. Art On Nov 24, 2011 8:00 PM, "Tristan Ball" <tristanb@pronto.com.au> wrote: > Hi Everyone - hoping someone can explain some behaviour we're seeing he…
RSS with DELAY_APPLY is dog slow!
ok - I think you guys helped find it... > dbaccess sysmaster <<EOF > > SELECT * FROM syscfgtab WHERE cf_name = 'RSS_FLOW_CONTROL'; > EOF No rows found. Which looks like RSS_FLOW_CONTROL was not implemented in xC7. And watching onstat -g ath I notice the following (when testin…
HDR & RSS
Hi Sergio, after your physical restore (onbar -r -p), Informix should automatically start the logical recover, until sync the two instances. (It seems you´re facing some configuration issue between them) Have you enabled SMX connection between them? I suggest you to do so.... he…
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…
Problem with check point
Hello All, My database is running on IDS 11.50.FC8W3 with HDR and RSS , I have a problem when I have tried to add space chunk of 8 GB in dbspace during the chunk addition database respond very slowly and ultimately checkpoint blocked up 70 seconds and following errors found in m…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
Error re-Starting SDS Secondary server
IDS 11.50 FC8X4 Linux I have an SDS secondary server that I started up last week. Today I made a configuration change and stopped/ restarted the server. When it attempted to restart, I got the following "Logical Log File not found." error. 08:36:02 Logical Log File not found. 0…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
RSS Cannot Connect
if RSS (or other secondary) does not receive any message (including heartbeat message) after IFX_SMX_TIME seconds wait, it will think the primary is down or network is broken, then the secondary will print out the error message in online.log and close the SMX connection. a coupl…
Informix RSS Issues - Slow apply of Logical Logs a
Has anyone came across this issue. When I first setup my RSS instance and turn it on "onmode -d RSS {primary}" it takes a long time to apply the logical logs from the primary (2 minutes per logical log) while the primary is generating a logical log every 30 seconds. I also noti…
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…
Re: HDR+Connection Manager in intermittent network scenario
Hi Nate, I guess the manual failover (DRAUTO=0) is the best configuration for HADR and CM environment for handling the conditions described by you in you mail below. (dealing with network issues) Hi Cesar, This look like a little different behavior than in the earlier version …
Re: HDR+Connection Manager in intermittent network scenario
Nate, you will found information about this on the manuals. Check for DRAUTO, FAILOVER_CALLBACK... Just sharing a issues what I got with IFX 11.50 FC7W1GE + CM 3.50 FC7, Linux. On environment with similar configuration, using HDR, I have trouble with CM FOC and DRAUTO configura…
HDR+Connection Manager in intermittent network scenario
I'm trying to acheive high availability without data loss. I have an HDR pair configured with a connection manager on each box for redundancy. Clients are pointed at an sqlhosts group with the connection managers in them, and the connection managers are configured to redirect the…
Re: Mach11 questions
I not sure if this help to clarify any doubt... What the manual says (the last paragraph): http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqls.doc/ids_sqs_2012.htm Isolation Levels for Secondary Data Replication Servers If the UPDATABLE_SECONDARY configurat…
Import restore issue
Hi, I was able to restore the database from inftest1 (prim) to inftest2 (sec) by ontape utility. But I still have problem with the "onmode -d secondary inftest1.newpiper.net" from inftest2 server. Please check out the output from below and advice. Thanks From inftest1 "onmode -…
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…
HDR Error
On 17 Feb, 02:26, John Carlson <jwcarls...@yahoo.com.invalid> wrote: > red_val...@yahoo.com wrote: > > I keep getting an error when I attempt to turn on HDR on my secondary > > server with "onmode -d secondary <primaryserver>." The > > informixserver > > message log reads: > > >…
Suspending HDR temporarily?
On Feb 4, 2:39 am, Art Kagel <art.ka...@gmail.com> wrote: > There is a way but it's a bit back handed: > > - Checkpoint the primary and wait for the secondary to process the > checkpoint. > - Shutdown the secondary (so server A?) > - Change the sqlhosts file on A so t…
IDS 11.50.xC6 is out...
Hello, IDS version 11.50.xC6 is currently available. It has become usual for these fixpacks to bring a lot of new functionality, besides the usual bug fixing. From the release notes: 1.5 What's New in Version 11.50.xC6 of IBM Informix Dynamic Server 1.5.1 External Bac…
IDS, BTS datablade and HDR
I am not sure which version of the server you are using, but if you check the release notes of 11.50.xC3 or later you will find the following: Basic Text Search DataBlade=AE module Supports High-Availability Cluste= rs =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D…
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…
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 …
Enterprise Replication backup question...
In case of Enterprise Replication, I would recommend you take full backup of your secondary (second) instance. It's lot easier to recover from back up than performing the tasks you listed. On the other hand, if were using High Availability Data-Replication then you don't need to…
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…
Informix Replication
One correction - RSS (Remote Stand-alone Secondary) is the correct term= (not RDS). RSS is designed to be used as a disaster recovery solution.= Conceptually it's same as HDR, with some added advantages. Here is info= on "When to use RSS" http://publib.boulder.ibm.com/infocente…
RE: BTS index on HDR Secondary usable?
Sorry to top post. What's to stop you from configuring something to manually update the BTS index on your secondary? I'm shooting from the hip, but I think you could put together something of a kludge that would work. > Date: Thu, 16 Oct 2008 14:39:01 -0400> From: jimtranny@gmai…
Fwd: BTS index on HDR Secondary usable?
Thanks Mike! So there's the proof that I didn't RTFM closely enough ;) BTS + HDR don't mix. ---------- Forwarded message ---------- From: Michael Lowe Date: Thu, Oct 16, 2008 at 2:02 PM Subject: Re: BTS index on HDR Secondary usable? BTS is not supported in any replication e…
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…
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.…
Compressed data in logical logs
On 13/02/2008, Art S. Kagel (Oninit LLC) <art@oninit.com> wrote: > SAMI ZEITOUN wrote: > > Thanks for the reply. > > Actually, I need this for replication purpose. > > Are you saying that the data buffer in the logical logs is allways in a > > compressed mode?? > > There is no wa…
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…
Basic Text Search and ER
The following is taken out of the IDS 11 Manual - when it says Replication is not supported, what does that really mean? If I have replication in place, can I not use the basic Text Search Datablade? How is this database different from the Excalibur datablade for IDS 10? *** The…
HDR Secondary mode Log transfer handling
Hi, 1) yes. 2) yes. This is the purpose of Informix HDR (High availability Data Replication). As long as the network connection is working, the IDS Primary and Secondary servers will stay connected and exchange information continuously. Any changes on the Primary server will be…
Re: HDR recommendations
On Aug 25, 3:41 pm, Madison Pruet <mpru...@verizon.net> wrote: > mohitanch...@gmail.com wrote: > > On Aug 25, 4:12 am, Madison Pruet <mpru...@verizon.net> wrote: > >> mohitanch...@gmail.com wrote: > >>> On Aug 24, 4:15 pm, Madison Pruet <mpru...@verizon.net> wrote: > >>>> mohitan…
HDR recommendations
On Aug 24, 4:15 pm, Madison Pruet <mpru...@verizon.net> wrote: > mohitanch...@gmail.com wrote: > > On Aug 24, 9:59 am, Madison Pruet <mpru...@verizon.net> wrote: > >> mohitanch...@gmail.com wrote: > >>> On Aug 23, 8:45 pm, Madison Pruet <mpru...@verizon.net> wrote: > >>>> mohitan…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: Informix beats Oracle
Quick question for you Fernando or anyone else... With the introduction of MACH11, do you still need a secondary product for HA such as HP Serviceguard, or Red Hat Cluster Manager or other HA product on the machine at the OS level if there are no other applications requiring HA?…
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…
Using IDS on VMware
Thanks Carlton. The two images comment relates to two physical servers linked by WAN. The main thrust of my questions is to see if there is a way to simulate a HDR (in the sense of on-line realtime data replication failover environment) using VMware. Actually, the more I think a…
HP-UX PA-RISC/Itanium
My understanding of HDR was that this is not copasetic. I though you needed to have the same architecture for the primary and secondary servers as well as the same version of IDS on both servers? And in order to setup up HDR a restore of the primary onto the secondary is needed; …
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…
db auditing
It would be very helpful if the following was *not* true as our security manager asks me to look into starting auditing/trusted facility on our production servers: In high-availability data replication (HDR), only the primary database server performs secure auditing and produces…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
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.…
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:…
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: HA cluster on SCO Open Server
On Tue, 09 Nov 2004 19:30:42 -0500, Martin Bouzek wrote: After the primary fails, one changes the secondary to stand-alone mode or to primary mode naming the original primary as secondary. Lets take the stand-alone case as it is most commonly used and more complex to recover fr…
HDR and Blobs
Scott, I agree that secondary should not crash with blobspace blob update on primary. If you have a test case, you should open a case with IBM support. I tried couple of simple scenario and could not reproduce it. Having said that, I am not sure how are you going to handle your…
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'?…
Ontape/logical logs
Hi, no, you are not. You can let the running "ontape -r" command apply as many logs as you want (or have), but once it has finished there is no way to start applying logs again. The reason for this is, at the point where you tell the "ontape -r" command that you have no more log…
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: 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: can run HDR and ER simultaneously on the same server IDS 9.20??
If you can migrate the databases to a mainframe, then you could also upgrade the database version to 9.4. Generally, I would want to take the easiest/most familiar solution. There is a significant mind-set difference between a main frame environment and a UNIX environment. "Cri…
RE: IBM website Informix pages / Workgroup edition
comments in-line. "Everett Mills" <eemills@nationalbeef.com> wrote in message news:ce6d1r$j09$1@news.xmission.com... > > Isn't this contradictory? From IBM's site (reference below): > > One area: > > Informix Dynamic Server V9.4 Workgroup Edition features and attributes > includ…
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: HDR with Synchronous replication
Guys- FYI- HDR is now LEGAL in WGE. You just have to buy an additional server license for your secondary ($686 last time I looked). From the IBM website: Informix Dynamic Server V9.4 Workgroup Edition features and attributes include: High availability Point-in-time instance…
Re: HDR with Synchronous replication
Fernando, thanks for your feedback on this case. I was just alerting "rkusenet" about this issue. My advice now is , do not promise heavy load work on Secondary server until you really test it a lot. (We should not promise anything with out testing it, but in real life it is h…
Re: HDR with Synchronous replication
Francisco Roldan wrote: > There is an important thing to consider if you choose > to use HDR . The secondary server must be a "Stand By" Server. > By "Stand By" i mean that, no hard work like dss queries > on the secondary server, because checkpoint between > servers are synchr…
Re: Extremly long checkpoints: How to find the reason and solve the
Francisco Roldan wrote: > HDR Systems are not optimized for having the secondary server for > DSS . Sounds logic because HDR is oriented for High Availability Systems, > => OLTP Systems. In that time the company wanted the primary server > for the Production System, and the Se…
RE: Extremly long checkpoints: How to find the reason and solve the
You'll sometimes see user threads in log-buffer-wait (onstat -u flags column has a B) and onstat -l shows, uhmmm, i don't recall exactly what it says - something about waiting in the header, but it boils down to not being able to switch to the next log buffer (of the three (tripl…
Re: Extremly long checkpoints: How to find the reason and solve the problem (7.31 FD3)
Francisco Roldan wrote: > Are you Replicating to other server ? > Some time ago I got very long checkpoints in an > Informix Server with High Availability Data Replication (HDR) > on the primary server. > > I found out that the reason was an extremely complex query > executed in …
Re: Channelling Madison Pruett
Madison, Is that Client Reroute must work with Stinger HADR? If we use db2 suspend + Shark or EMC split, can we use Client Reroute to reroute the client to the secondary server? Thanks, "mpruet" <mpruet@comcast.net> wrote in message news:40676184.0404271949.3ecdffa2@posting.goog…
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.…
Channelling Madison Pruett
"Rob Vorbroker" <rvorbroker@yahoo.com> wrote in message news:c6m9hu$t7c$1@terabinaries.xmission.com... > > For those of us venturing out into the DB2 UDB world > can you give us a summary of tools similar to HDR and > ER (which we love so much). > > Trying to support 24x7x365 int…
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…
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: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
RE: ER to replace HDR in HA environment
We went the other direction. ER is great for replicating information to remote servers, but if you read the documentation, it is not recommended for HA. Additionally, you can achieve ER and HDR if you are on 9.4x (or so I have been told by the trolls at IBM) -----Original Messa…
Re: ER to replace HDR in HA environment
Paul, Any idea who has set your clients expectations that ER is the answer to all their woes? I have a couple of cncerns / comments with what the expect to achieve moving to ER! I am concerned that it will take a load of work, without addressing all the issues the client has. …
Re: ER to replace HDR in HA environment
How many tables are you going to replicate? Schema changes will affect you production enviroment, ER is based on the schema for each table. Also you will have a lot of administration for an update anywhere env. rather than HDR. a big number of logical logs if it is a high txn vol…
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: Checkpoint Duration - HDR - Sync/Async
Hi, Francisco, During 'normal' idle secondary operation, the real discrepancy between primary and secondary is very small - just few seconds in the case of unbuffered logging. Note, that secondary doesn't apply changes immediately: it keeps log records in the 'log receive' buff…
RE: Can I refuse all connections except replication?
Why don't use the Master-Secondary Configuration instead of Update Anywhere? The Secondary server would be in "Read Only" mode unless the Primary is working. And if you set the DRAUTO parameter to 1, the Secondary server switchover if the primary fails. And keep your DNS chang…
RE: Enterprise Replication - Primary Key
Great explanation Andrew! Thank you very much. I got 157 tables, some of them (10, the most important ones) do have indexes (not defined as unique), So I could verify these ones to see if i can promote the indexes to unique and then I will verify if there are null values, if I d…
Enterprise Replication - Primary Key
Francisco Roldan wrote: > [SNIP] but i am not in charge of the software application that > runs on my server, I am just the DBA, so the application > administrator refuse to define primary keys and the effect of the > primary keys on the software-application could be very bad ( W…
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…
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: Question
> Arnel CUETO ha scritto nel messaggio > <9583jm$pfq$1@news.xmission.com>... > > > > > >--------------C064AA6EE2CF3D83DF1E7337 > >Content-Type: text/plain; charset=us-ascii > >Content-Transfer-Encoding: 7bit > > > >Hello all, > > > > We have set-up, and are currently testing, …
Question
Arnel CUETO ha scritto nel messaggio <9583jm$pfq$1@news.xmission.com>... > > >--------------C064AA6EE2CF3D83DF1E7337 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >Hello all, > > We have set-up, and are currently testing, our Informix >High-Ava…
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: Using Replication
We've got two production pairs, one is at version 7.24.UC6, the other is at 7.24.UC8. DBMS size of the first pair is a little over 12Gb, and we are going to be upgrading them to Foundation.2000. The second pair has a size of about 4Gb, and we are moving them to 7.31.UC6A (we al…
RE: Using Replication
Thank for your information. Yes, I do mean HDR. We are currently on Informix 7.31 UC 2. What Informix version are you running? Could tell me how large are the database servers that you are replicating? Did you use Ontape to sync the data for first time? (i.e level 0 backup and …
RE: Using Replication
If you mean High-availability Data Replication (HDR), then, yes, we are using it. Primary and secondary servers are located several hundred miles apart, communicating over a very busy T1. DRINTERVAL is set to 30, but almost everything is replicated within a few seconds. We use…
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?…
Reliability of Informix
This would be HDR (High Availability Replication) included as a server feature for about 4 years as a hot-spare backup facility. The secondary/backup instance can be operated in read-only mode, and when the primary goes down, the secondary becomes primary. It's pretty easy to s…
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…
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…
New case
Other question is how much data your going to push through the link. Look at that very carefully. cheers j. Andris <andris.shirons@dati.lv> wrote in message news:8gg4u1$6qe$1@news.xmission.com... > > Dear Madam or Sir, > > our maintenace contract is 5906. > > Our customer, Stat…
Duplicating/Replicating Data? *Urgent please help*
HDR (High Availability Data Replication) is included as part of the engine. With it the logs from the source system are sent directly to the target system. The target system is always in recovery mode as it is applying the logs from the source instance. I understand the issue wi…
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: Cluster with informix.
I agree -- I don't think a cluster is really worth it. We have a very critical app. running on a small HP K460 box (2 Gb memory, 70 Gb disk, 4 CPU), connected via HDR to a similarly-configured K400 box. The two boxes are several hundred miles apart, and yet replication to the s…
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…
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…
Re: Replication and HDR
In article <38552dce_3@news.delphiauto.net>, "Michael K Anderson" <michael.anderson@eds.com> wrote: > On Tue, 30 Nov 1999, Greg wrote: > > <gresmi@yahoo.com> wrote in message news:821u53$dir$1@nnrp1.deja.com... > > We are looking at implementing replication between 2 of our ser…
DR Problems with 7.30 on Alpha Server
> We are running Informix 7.30 7.30.FC? . It's important. > > 21:04:00 Logical Log 136 Complete. > 21:08:06 DR: ping timeout > 21:08:06 DR: Receive error > 21:08:08 DR: Turned off on primary server > 21:08:14 DR: Cannot connect to secondary server Looks loke primary lost …
RE: Replication and HDR
OK, here's my .02... I am currently responsible for four HDR-pairs of servers -- three production pairs and one development pair. All servers are HP boxes, but I'm sure that most of this will apply to AIX, too. For each production server-pair, one server is in Sacramento, CA, …
Replication and HDR
We are looking at implementing replication between 2 of our servers, a primary in Ft. Lauderdale and the secondary in L.A., possibly using Informix's High Availability Data Replication (HDR) tool. Our questions are these: 1. The Informix manuals state that the hardware and OS mu…
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…
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…
RE: Automating Informix Database Environment Restore
Well, I was just able to go into dbaccess on a development secondary server, and it allowed me to "create temp table test001 ... with no log". Two things that may be necessary: (1) make sure you have some temp dbspaces set up and defined in DBSPACETEMP in your ONCONFIG file (NOT…
RE: Automating Informix Database Environment Restore
Yes, we can make the servers identical in every aspect. However, the inquiry-only user's application that runs, which is setup to only perform inquiries and reporting, creates temporary tables on the fly. From what I have read about HDR, the secondary server's data is read-only…
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: Problem with dbexport
Hi Ravi ! I have similar problem with HDR replication pair - when you're running dbexport on the secondary server, and users inserts/updates tables. --------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Senio…
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…
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…
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…
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…
Re: Informix v7.24 on HP-UX 10.20
Hi Dave, 7.30.UC6-1 is available on HP-UX 10.20, David... P.S.: here is a the list of bugs corrected since 7.30.UC5 (maybe not critical bugs but the list is quite impressive). We solved several problems by migrating from UC2 to UC6 (I asked for UC5 but informix sent UC6. W…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
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…
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…
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: replication
Dear Maria, I have not heard of CDR and have not used ER. But have used HDR. This provides a hot backup type facility. Where the secondary machine is updated based on logical log buffers from the primary machine. Only the primary can be updated, but the secondary machine remai…
Re: replication
I have used HDR extensively. There are very good reasons why Informix threw it away and created CDR/ER. If there is some "hard" reason for using HDR, then by all means knock yourself out (literally :-). Even in an ideal environment with everything configured by-the-book, HDR i…
Re: replication
Maria L. Wilson wrote (in two similar posts): > I am interested in the functional differences in CDR (Continuous Data > Replication) and ER (Enterprise Replication). > > Our site (Informix 7.23,Solaris 2.5.1 on Sparc Enterprise 3000's) is > looking at a primary we…
Re: replication
}>Date: Mon, 11 Aug 1997 14:46:55 -0400 }>From: "Maria L. Wilson" <m.l.wilson@larc.nasa.gov> }>Organization: CSC }>To: informix-list@rmy.emory.edu }>CC: wilson@cscsun3.larc.nasa.gov }>Subject: replication }>Sender: informix-list-owner@rmy.emory.edu }>Reply-To: "Maria L. Wilson" <…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Data Replication
Hi, It looks like I made the assumption that you are using 'auto' switchover. If you are using Manual you need to turn the secondary to standard manually. Sometimes, for unknown reasons, it fails. You restore the secondary and repeat the above steps it works fine. ( I could not…
Re: Data Replication
Hi, The very first thing is it is not DHR. It should be HDR (High-availability Data Replication). (assuming it is a typo). We are using HDR still in development and test environment. H/W -- HP K400s with HP-UX 10.10 Informix --- OL 7.20 1. When primary goes down (or you bri…
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: 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?…
Re: INFORMIX ON-LINE REPLICATION
yoramk@segovia.fcmc.com (Yoram Kochol (Technology Grp)) writes: > Does someone knows anything about the REPLICATION ability of the >ON-LINE engine ? and in detail regarding Ver. 6 / 7 / 7.1 or >even 8. In a nutshell, there are two types of replication for Informix-Online 7.1: …