Oninit® Archive
Results for “SDS_ALTERNATE”
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 …
DRDA redirection to HDR primary
Hi Doug, I vaguely remember having dealt with this, my notes having things like alternateserverlist and enableAlternateServerListFirstConnect and a pointer to https://www.ibm.com/docs/en/db2/11.5.x?topic=njcshads-non-java-client-support-high-availability-connections-informix-serv…
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 ------------------------------…
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…
configure sds with raw device
Hello all, I am looking for advice on how to configure Informix SDS. We are using Informix 12.10.FC10 Workgroup and are running on AIX 7.1. No Informix secondary server or cluster software is configured. And DBSPACE consists of raw device, not cook device (file system). I woul…
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…
Upgrade 11.70 to 12.10
Hi. We are running 11.70.FC8W1 on Linux in a Primary / SDS config. Everything works well. Now I'm planning to upgrade to the newest 12.10.FC10. I've been testing the upgrade process (on a restored instance without SDS) and we have run our application and everything seems to be O…
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…
Free Webcast - Informix Auditing 7/27/17 @ 2PM EDT
Be sure to register the next free webcast "Informix Auditing", presented by Mike Walker on Thursday, 7/27/17 at 2 PM EDT. This webcast will show how to set up Informix Auditing (a free-to-use feature included with Informix), and what it can do. Register at: http://advancedatato…
Automatic Failure in HDR Setup
Hello All, We had implemented High Availability data Replication (HDR) with onconfig parameter DRAUTO : 0. (i.e No automatic failover) Now, we need to implement for Automatic failover. If we set the DRAUTO parameter to 3 in onconfig file, we need to configure "Connection Manage…
Informix Best Practices for DBAs - New Webcast Ser
Folks, Happy New Year! We are pleased to share our Webcast series for Informix DBAs - Informix Best Practices. We will discuss configuration, disk layout, backups, performance tuning, and high availability disaster recovery implementation. Our Informix Best Practices are based …
Shared Disk Secondary
Is it possible to avoid a SDS-Server shuts down when the Primary is stopped and restarted? TIA Reinhard.…
sds transactions
I don't understand sds secondary isolation in transactions I'm making some test and I'm a bit confused, perhaps something is not well set: --Primary create table kk(k char(1)); begin work; insert into kk values (2); --Secondary select * from kk --> 2 --- --dirty read?; I keep …
updatable SDS
IBM Informix Dynamic Server Version 12.10.FC6X5 -- Updatable (SDS) -- Up 03:46:16 -- 1950676 Kbytes I'm testing things before releasing the first SDS server, and I'm finding thing I didn't expect: I create a lock in Primary: begin work; delete from kk where 1 =1; Updatable SDS…
Primary + SDS cluster failvoer through cm
Is there a way to tell the connection manager to try to start a node that is down? I dont mean the "turn the sds to new primary y old primary is down" that already does it, I mean a "try to start the primary that failed as an sds node of the new primary you just started". I don…
SDS Replication and VMware VMFS
Hello, Ihac who wants to implement SDS replication using two Vmware Linux virtual machines. Does VMFS support SDS replication? Thanks a lot for your answers. JOHN.…
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)…
Block vs. RAW
Thanks Art. Unfortunately, I can't use a filesystem (except maybe gvfs) because this will be an SDS instance. EXTx filesystems are not safe to be mounted by two servers at the same time (or so I'm being told). I think I will try to config this using RAW and see if I see any dif…
Setting up SDS cluster
HP-UX B.11.31 IDS 11.70.FC8W1 Setnet 4.10.TC5 Hi All When I start the connection manager and try to connect from a Ilogin I get a -908 error. I have checked the port setting on both client and server match but still get this error. Any advice will be appreciated. thnx…
Informix High Availability
Hello all, I am doing Informix HA Implementation research between "Physical Host + Informix + HDR/SDS" vs "VMWare + Informix + vMotion" Whats your bet and why ? Thanks --001a11c3d08c374d8b051fa1c667…
Shared file system
Does it still applies when I set up an updateable SDS server ?…
Unable to bind to the port
Hi, Informix 11.7.FC8 HP-UX 11.31 I am setting up an SDS server. The primary starts successfully but when I run the oninit command on a SDS server I get the following error: "Assert Warning: Unable to bind to the port (9999) on the host (999.99.9.99) for the server (primary)."…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
SDS Shutdown
Hi, We are running Informix 11.70.FC7. I am doing some testing with SDS. I noticed that if I shutdown the primary, the SDS stays up. Though when I bring up the Primary again, it automatically shuts down the SDS. This happens even if I just quickly bounce the primary. Why does th…
Upgrading IDS version on PRI need rebuilt HDR/RSS?
Khan: The primary answer is that if you upgrade one server in a MACH11 cluster (HDR, RSS, SDS) then you have to upgrade them all and yes, for HDR and RSS secondaries it does mean recreating them from an archive taken of the primary. Art Art S. Kagel, Principal Consultant ASK D…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Nasty, unexpected cluster problem
We have a MACH11 cluster defined. It has an SDS Primary, an SDS secondary, and 2 RSSs. The SLA is defined thus: CLUSTER gcgob1_db LOCAL SLA Connections Service/Protocol Rule ob1_oltp_1 234463 ob1_oltp/onsoctcp DBSERVERS=primary ob1_obbo_1 0 ob1_obbo/onsoctcp DBSERVERS=SDS,primar…
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.…
Isolation modes in mach11 cluster
All, We are in the process of converting from a single database server to a cluster, and we are having some confusion about transactions and isolation levels. Our cluster consists of a primary and secondary HDR that are in the same location (1gbps) and an RSS that is across a WA…
.rhosts and PAM authentication
I have a mach11 cluster that is configured for PAM authentication using a custom PAM module. Now, I'm trying to get transparent remote logins to work from another host, but the auth isn't working. If I remove the PAM auth, the remote connections work. Is there a way to get .rhos…
Logical Log File not found ..
Akshay: I would avoid using IP ghosting to provide HA failover and just use Informix MACH11 features. Setting up an HDR secondary server on the backup machine will only cost you the additional disks (as long as the secondary is only standby and not actively queries there is no a…
redundant connection manager configuration using H
"POLICY=LATENCY" is good for ER replset and GRID To use the latency and failure policies, you must: create a table through the grid, and the table must have replication enabled enabled quality of data (qod) monitoring with MACH11 cluster, connection manager calculates the serv…
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,…
Innovator-C is now available!
The README file indicates the following about Replication! Changes to Replication in Informix 11.70.xC5 Innovator-C edition For 11.70.xC5, Informix Innovator-C edition no longer supports Enterprise Replication (ER) or High-availability data replication (HDR). If you were using r…
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 …
new OS Migration with SDS
Hello, we have to change our OS from Solaris to Linux RedHat. Which is the best way to do it, prefered with a limited downtime. We have two Solaris Systems with a Shared Disk. Is it possible to use a third RedHar Node, so we can make this system later to the primary DB Server? t…
Connection Manager
I have setup an RSS server but I am having problems getting it working properly with Connection Manager. Here is what I am running. IDS 11.70.FC4GE CSDK 3.70.FC4DE ServerA - Primary server ServerB - SDS ServerC - RSS The connection Manager config file is - NAME conn_man LOG 2…
CLR vs Long Transactions...
Immediately backing up your log doesn't automatically make it available for re-use. A long transaction is a function of how many logical logs a transaction spans (stays open) with respect to the amount of logical logs you have defined. In your situation every time you do a log sw…
execute dbimport in SDS node
Hi, In V11.7, if I run the dbimport in the SDS node? dbimport will create a non-logged database default,could I use the default method to run it? or I need to specify the buffered or unbuffed option. thanks for your time.…
transaction survial in 11.7
Hi, If I use transaction survial feture, when the primary failed, where the flying-in transaction in the SDS being stored? thanks for your time.…
SDS - AIX
Hi, We will set up a new machine and would like to keep things already prepared to activate an SDS in the future. AIX 6.1 , Storage IBM DS4700. Using VG / LV raw devices. As far I remember , on Linux, we need to configure the VG (or LV... not sure) to active shared access. (t…
DBSPACETEMP IN SDS CLUSTER
I have a Cluster SDS, secondary server is setup as UPDATABLE_SECONDARY 1 my application is connected through CM, When an user is connected to Secondary Server i recived. -229 Could not open or create a temporary file. -131 ISAM error: no free disk space. I checked "onstat -d" a…
DR Default Isolation Level in SDS Secondary
Hi I have a question because DR is default in SDS Secondary Server, how i can setup LC like a Default Isolation mode in SDS Secondary Server?.…
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…
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
Are you sure that the logs are on a shared device? The way that SDS starts up is to perform a checkpoint on the primary and then use the LSN of the checkpoint as the starting point for the SDS node. So unless you are wrapping the logs in less than say a second, then I'm a bit co…
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.…
Informix Warehouse Accelerator : Problem with a se
Hello, I have another problem with Informix Warehouse Accelerator. When I try to add an accelerator on a secondary server (SDS), I have the following java exception 'Add Accelerator ...' has encountered a problem - User Defined Routine (accel_setup_dwa) VP context switch failed.…
Performance if storing files in DB
We are using Mach11 cluster(HDR+RSS). But we think we can create a logged smart blob space with the -Df "LOGGING=ON" option to replicate the blob data. But we are not sure how much performance gain we can get or we start thinking to move these files out from database into OS file…
SDS com OCFS ou sem
Friends I want to ride without using an SDS rawdevices putting a chunk of shared lun mounted on two different machines with the Oracle RAC using OCFS when the use SUSE in INFORMIX have to use OCFS or can simply assemble the two machines pointing to the same LUN without rawdevice…
Mach11 proxyWritePostPBlobCmdSync failed
IDS 11.50 FC8 Linux I get this error in my online log of the SDS secondary: ERROR: Mach11 proxyWritePostPBlobCmdSync failed has anyone seen this error? how do you fix it? Thanks Laurie…
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: Amazon EC2....
Hi Gumby, I don't have intention to use the "cloud resources" in EC2 . I choose try use it, because is the unique place, with "low cost" what I found to run Informix Innovator-C , where the instance can run 24x7 . Just run a single and small instance. --- Em ter, 16/11/10, I…
RE: Amazon EC2....
Amazon's EC2 is cost effective if you're doing a POC and are not ready to pull the trigger on building your own infrastructure. Using your example... you want to build your own site based on Drupal and IDS I-C. For a starter site... you can put Drupal and IDS on the same box. D…
Panther (11.70) is available
No distributed dbslices like XPS, no. Details on the Grid feature will be forthcoming today, but basically more different and more flexible configuration of grids of ER and MACH11 servers to allow for massive scalability. Art Art S. Kagel Advanced DataTools (www.advancedatatool…
Mach11 questions
Does anyone have a good source of in-depth information on Mach11? I googled, perused info center and watched some audio conferences but have not found the info I am looking for so was hoping there was a better place to look. Here are a few things I am looking for : -How UPDATE…
Re: High Availability Solution?
On Aug 23, 6:30 pm, shorti <lbrya...@juno.com> wrote: > Hello, > > I am new to Informix and wanted to get more information about their HA > solutions. This will be a a Linux platform. I come from DB2 so I am > familiar with their solutions (HADR, PureScale). I have found some …
High Availability Solution?
Hello, I am new to Informix and wanted to get more information about their HA solutions. This will be a a Linux platform. I come from DB2 so I am familiar with their solutions (HADR, PureScale). I have found some information about the following for Informix but I was a little…
SDS and SAN Storage
Hi all what is possible and what is the best way to create chunks on a SAN- Storage (NetApp) for SDS. We are planning for IDS 11.50 database installations with SDS feature. OS will be LINUX (SLES or UBUNTU). As Storage we have a NetApp SAN. In case of cooked files (DIRECT_…
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…
Inserting to SDS secondary
IDS 11.50 FC6 X3 Linux I am wondering if anyone is successfully using an SDS server and regularly inserting data from that server? I have an updateable SDS server that I am trying insert records to... the records insert successfully, but the application tries to get the generate…
Inserting to SDS secondary
IDS 11.50 FC6 X3 Linux I am wondering if anyone is successfully using an SDS server and regularly inserting data from that server? I have an updateable SDS server that I am trying insert records to... the records insert successfully, but the application tries to get the generat…
Another SDS question
I have 2 servers in an SDS cluster. ids_1 is the primary ids_2 is the secondary If the whole cluster is lost, and only the server with ids_2 comes back, how can I restart the ids_2 instance? If I start it with SDS_ENABLE =1 it will crash because it cannot connect to its prima…
SDS best practice query
We're working with a customer to set up SDS. It's going well. Because it's little-used there's not a lot of user experience about, apart from the IBM documentation and some useful blogs. Can anyone advice about the placement of the SDS_TEMPDBS and SDS_PAGING files in an envrio…
SDS secondary and LOCK TABLE
Hello all. I recently had an issue with a programmer on our site, regarding concurrency control and an SDS environment. The problem is, that he had a little table that was used to control an order sequence number. No serial column or sequence were used. It is a normal table and …
CRCOLS and VERCOLS and REPLCHECK
IDS 115FC6X3 I am setting up a system that will use both SDS servers and ER. I understand that CRCOLS and REPLCHECK columns are used for ER and VERCOLS are mainly for SDS servers... but it doesnt appear that you can add all 3 (or even 2) sets of these columns to a single tabl…
Re: Skype PostgreSQL in Informix world....
This could be done simply plug-in replacing PostgreSQL with IDS. There are lots of features that IDS can add to the mix to make the implementation easier and more robust though. All of the MACH11 secondary server features for example. The Connection Manager to help with failov…
Gary Speaks!
On 2 Feb., 18:57, darko <darko.krs...@gmail.com> wrote: > On Feb 2, 3:12 pm, eherber <e...@herber-consulting.de> wrote: > > > > > On 2 Feb., 14:53, Superboer <superbo...@t-online.de> wrote: > > > > Hello Eric, > > > > you could start a poll > > > > "Does IBM Management needs a k…
SDS & update statistics performance
Hi My situation: 1. I use MACH11 with IDS 11.50FC5W2 on Sun Solaris On Secondary server UPDATABLE_SECONDARY 0. 2. On SDS server assert and server stop: 15:56:34 Rollforward of log record failed. iserrno = 126 15:56:34 Log Record: log = 4807652, pos = 0x105558, type = OLDR…
MACH 11 questions
Zev Berezin wrote: > Hi, > > Greatly appreciated if someone can be of assistance in a couple of questions I > was recently asked on MACH 11 running IDS 11.50. > > 1) is it possible to have an SDS node against an HDR or RSS node? The reason No. SDS can currently only run against …
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…
SDS Mach 11
When you are using SDS with Mach 11, how does Informix balance the load across multiple pieces of hardware that are all using SDS to share a disk? I assume through connection manager, but I would like to understand the logic of how it determines how to send a transaction. Also, …
HDR crashed after upgradation
HI Art did u mean that that crash happend becz i didnt shutdown the primary database properly. I thought that the crash happend becz of the way i upgraded the databases. To upgrade the database i have performed the following steps. 1) Shutdown the HDR and SDS instances 2) Shutdo…
SDS question
Hi all, currently if the primary server is re-started, all SDS servers are automatically brought offline and need to be re-started. Does anyone know of a way to keep secondary servers online in case primary goes down. (IDS 11.50 FC4, SunOS 5.10) Thank you, Ljiljana Zivanovic …
SDS pre-requisite
Hi, Can we setup SDS without using special file-system like IBM's GPFS? If no then what are the options to choose for Sun Solaris. regards, Kamran…
Read-Only (SDS) (CKPT REQ)
Hi! After run checkpoint - SDS server is blocked. IBM Informix Dynamic Server Version 11.50.FC5 -- Read-Only (SDS) (CKPT REQ) -- Up 00:00:41 -- 2748416 Kbytes Blocked:CKPT online.log: 17:45:14 Maximum server connections 0 17:45:14 Finished processing open transactions on …
Re: SDS performance
Alexander wrote: > Hello everybody, > > Our is planning to upgrade IDS from 9.4 to 11.50 along with hardware > upgrade which includes FC attached disk array that will be shared by > two servers. It looks like we can try to use what is called Sared-Disk- > Secondary server. > > I'…
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…
SDS performance
Hello everybody, Our is planning to upgrade IDS from 9.4 to 11.50 along with hardware upgrade which includes FC attached disk array that will be shared by two servers. It looks like we can try to use what is called Sared-Disk- Secondary server. I've searched this group for SDS …
program failing in secondary server
Hi. In a SDS environment there is a difference between inserts and puts. In the primary instance the program works correctly but in the secondary it fails with and trying to insert null value in a column that don't accept nulls.…
SQLTRACE on HDR Secondary
Is there a trick to get SQLTRACE to work on the HDR Secondary. We use our secondary for some read only applications and would like to be able to analyze the queries with SQLTRACE. This is for HDR, but also wonder if SQLTRACE works for RSS and SDS Read Only Secondaries? IDS 11.…
Informix Roundup: 30 May
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.728.1243757718.1831.informix-list@iiug.org... > http://obotheclown.blogspot.com/2009/05/informix-roundup-30-may-2009.html > > The SQSL edition. :o) Quite dull. But, your 27th May Round-Up highlighted th…
Removing SDS Node servername has timed out - rem
Hi all, informix 11.5FC4 on HP-UX 11.23 I have one primary and two SD secondary instances in my cluster. In my cluster my one of the secondary instance goes down and In the online.log , IDS report the following error: 10:51:31 ERROR: Removing SDS Node prodsds2_tcp has timed ou…
Re: Connection Manager - restrict connections
Tom wrote: I think to do what you are trying to do that you will need to use the password file. The second column has an alias to use in place of the HA_ALIAS. > On May 14, 11:47 am, Tom <tlow...@munis.com> wrote: >> On May 14, 4:57 am, theBP <th...@Usenet-News.Net> wrote: >> …
Connection Manager - restrict connections
On May 14, 11:47 am, Tom <tlow...@munis.com> wrote: > On May 14, 4:57 am, theBP <th...@Usenet-News.Net> wrote: > > > > > > > Tom wrote: > > > On May 13, 8:44 am, theBP <th...@Usenet-News.Net> wrote: > > >> Tom wrote: > > >>> On May 12, 3:05 pm, Tom <tlow...@munis.com> wrote: > > …
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 …
CDR servers on SDS primaries will not connect
IBM Informix Dynamic Server Version 11.50.FC3X8 We have historically combined our test and development environments. But I have been tasked with separating them. To that end we have created test and dev SDS servers. Howerver, one of the projects requires that the test and dev da…
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…
Connection Manager Behaviour - Feedback Request
Madison Pruet wrote: > I don't understand. See below > <snip> >> Two MACH11 clusters >> Each Cluster has >> 1 Primary >> 1 HDR Secondary >> 2 RSS Secondaries >> 2 SDS Secondaries >> Each Cluster has >> 2 Connection Managers >> …
IDS with IBM HACMP
Hi , Does anybody know where can I find reference document for implementing Informix (10.00 or later) with IBM cluster , HACMP. Id like to know about this concept. Does it work or not ? What is the pro/con comparing with Informix HA such as HDR, SDS,RSS. Thank you in advance, J…
Converting SDS to primary or standard
After a system change and reboot, we lost all disk access to SAN storage on our primary server. Is there a way to change teh configuration of an SDS server to become the primary server in the cluster when the primary server is down? The limited SDS documentation only gives comman…
Truncate does not work on "Updatable (SDS)" for TE
Question, is the truncate command allowed on an "Updateable (SDS)" server for a TEMP table? When I run it the command executes but does not truncate the TEMP table. I could not find any documentation that says it cannot be ran on the "Updatable (SDS)" server. There are no error…
Shared Disk Secondary
Hello, I have a query in regards to SDS (Mach11) feature. Is it compatible with HP Service Guard? We have an EVA connected to an HP itanium server through san and OS HP UX 11.23. So what are the prerequisite that is needed for implementing SDS? Regards Poonam…
Problem with SDS server disconnecting - Informix 1
SDS_TIMEOUT is set to 500 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Madison Pruet Sent: Sunday, February 15, 2009 12:18 PM To: ids@iiug.org Subject: Re: Problem with SDS server disconnecting - In.... [14886] What is SDS_TIM…
Question for Connection manager and SDS
I have 2 question for IDS11.50 SDS 1. What is the machanism of Connect Manger to select the dabase server ? Round robin , random ? For example : SLA CMport=(dbport1+dbport2+dbport3) Can we set up the additional rule for CM such as use dbport1 40%, dbport2 30%, dbport3 30% ? 2…
Re: IDS 11.5 and SDS
On Jan 28, 3:11 pm, Madison Pruet <mpru...@verizon.net> wrote: > Madison Pruet wrote: > > Tom wrote: > >> Greetings All, > > >> Has anyone configured IDS 11.5 with SDS on any AIX platforms? I am > >> configuring two new servers and plan on using IDS 11.5 features for HA > >> and …
Re: IDS 11.5 and SDS
Tom wrote: > Greetings All, > > Has anyone configured IDS 11.5 with SDS on any AIX platforms? I am > configuring two new servers and plan on using IDS 11.5 features for HA > and it looks like a Shared Disk Secondary would fit the bill. However, > a call to IBM Informix as well as…
Re: IDS 11.5 and SDS
On Jan 28, 12:01 pm, TBP <th...@Usenet-News.Net> wrote: > TBP wrote: > > Tom wrote: > >> On Jan 28, 10:14 am, TBP <th...@Usenet-News.Net> wrote: > >>> Tom wrote: > >>>> Greetings All, > >>>> Has anyone configured IDS 11.5 with SDS on any AIX platforms? I am > >>>> configuring two…
Re: IDS 11.5 and SDS
On Wednesday 28 January 2009 16:47:17 you wrote: > On Jan 28, 10:14 am, TBP <th...@Usenet-News.Net> wrote: > > Tom wrote: > > > Greetings All, > > > > > > Has anyone configured IDS 11.5 with SDS on any AIX platforms? I am > > > configuring two new servers and plan on using IDS 11…
IDS 11.5 and SDS
Greetings All, Has anyone configured IDS 11.5 with SDS on any AIX platforms? I am configuring two new servers and plan on using IDS 11.5 features for HA and it looks like a Shared Disk Secondary would fit the bill. However, a call to IBM Informix as well as IBM AIX Software grou…
IDS 11.10.FC2, SDS, AIX and DS4800 SAN
Hi There, I'm taking a look at SDS to offload reporting from an OLTP server to another IDS server. Details on environment, hardware, etc are: * IDS 11.10.FC2 for both * AIX 5.3 TL8 SP1 for both * SAN DS4800 for both * OLTP host: p570 Power 5 * Reporting host: p650 Power 4. At th…
cookbook: Linux + SDS + iSCSI
Cool Stuffs: Linux/Desktop + SDS/MACH11 + iSCSI This is a little cookbook/step-by-step what I was tested successfully here and want to share with everybody. Is more focused how configure the linux ... the IDS part is to easy to do a cookbook :) but! if you need information how c…
Informix Roundup: 14 Nov 08
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.326.1226705564.874.informix-list@iiug.org... In your excellent Informix digest at http://obotheclown.blogspot.com you wrote: >> Craig S. Mullins talks out of his arse. Informix-Zone sets him straight >>…
Fwd: Re: Raw Disk still preferred for 11.5? - File system type for SDS
The sysadmin corrected me - OCFS2 - I dont know if that makes much difference or not.. laurie Laurie Gustin" <lgustin@utah.gov> 10/08/08 11:03 AM >>> Thanks so much for all the feedback, I have learned a great deal. I think we will go with a cooked system. I think it will b…
Re: Raw Disk still preferred for 11.5? - File system type for SDS
Laurie Gustin wrote: > Thanks so much for all the feedback, I have learned a great deal. I > think we will go with a cooked system. I think it will be better > administratively, since they wont give me root access to the new > servers and it will be a chance to try something ne…
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…
Raw Disk still preferred for 11.5?
I am setting up a new set of servers that will utilize the SDS capabiltiy of IDS 11.5 and just want to make sure that raw disk space is still the best way to go. I plan to have at least 3 SDS servers. SLES 10.2 4 processors per server 32 GB ram per server Thanks in advance …
HA : What is the best ?
On Mon, Sep 15, 2008 at 3:20 AM, Obnoxio The Clown <obnoxio@serendipita.com> wrote: > Henri MOUKOURI wrote: >> 2/ When adding an external RAID device >> >> a) SSD > I assume you mean SDS? SSD could be Solid-State Disk -- or it could be a typo for SDS as you said. -- Jonathan Le…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
How I can to change status from SDS secondary to Primary.
Hello All. I have my testing environment. I have server1 is primary server and server2 is SDS secondary server and one Connection Manager Arbitrator. When I shutdown my primary server, Connection Manager switches my application to the SDS secondary server. After that my server2 b…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Re: SDS and RAW, It's possible?
On Thu, Jun 12, 2008 at 3:10 AM, Isidre Pons Roca <ipons@base.altanet.org> wrote: > We are planning to move from IDS 9.40.UC4 in Solaris 9 to IDS 11.5.FCx in > Solaris 10. > > Now We are using raw devices in SAN and HDR. > > New functionalities in IDS 11.5 are the use of Shared D…
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.…
Informix Continuous Availalbility Feature Demo
This marketing video of IDS HDR, SDS, RSS and Updatable Secondary Nodes came in on my Google alerts this morning. http://www.cocktail-server.com/informix-caf/ Andrew…
Managing IDS in IBM HACMP environment
Appreciate the comments. We are planning to use HDR but this will be to our Disaster Recovery Site. The use of HACMP at the Primary site is mainly to have high availability in case of any hardware failure and for system maintenance.The cluster is already setup and shared logical…
HDR Performance
I want to know - How to measure/estimate the Network Bandwidth for a HDR pair over a WAN ? - What will happen to the performance of the Primary server if Network slows down ? - If Primary fails during high trasaction processing will the Secondary be in Sync - Are there too…
Re: question about mach11 capabilities
Nice thing about no down time is that you can spread the reorg across > multiple weekends. :-) You call that nice ? Nice to who ? Certainly not me. :-))) ----- Original Message ----- Subject: Re: question about mach11 capabilities Date: Wed, March 5, 2008 10:55 From: "Art S. Ka…
Re: question about mach11 capabilities
Floyd Wellershaus wrote: > Thanks Art, > I figured it had to be ER, but wasn't sure how it would work. So basically > I would have to reorg each ER server ( or er group ) separately and let it > catch back up. > > Lots of work on a weekend type reorg, but at least no downtime. :-…
Re: question about mach11 capabilities
Thanks Art, I figured it had to be ER, but wasn't sure how it would work. So basically I would have to reorg each ER server ( or er group ) separately and let it catch back up. Lots of work on a weekend type reorg, but at least no downtime. :-)) Thanks. ----- Original Message …
Re: question about mach11 capabilities
Floyd Wellershaus wrote: > Hi, > I was just reading the white paper on ids11 availability and have a > question. > The solutions seem explicitly cover every scenario except one. > If I need to reorg a very large table that the application needs, but > I don't want to take any out…
question about mach11 capabilities
Hi, I was just reading the white paper on ids11 availability and have a question. The solutions seem explicitly cover every scenario except one. If I need to reorg a very large table that the application needs, but I don't want to take any outages. Can anyone tell me ( high leve…
Re: current informix white papers ?
>>As for the original post, this reminds me another flame a while ago... If someone is interested in moving to Oracle because of HA, someone should really find out what is really motivating them... Pay more and suffer a migration to gain nothing that eases their pain... sounds co…
Re: current informix white papers ?
Fernando Nunes wrote: > DA Morgan wrote: > >> Floyd Wellershaus wrote: >> >>> My company is seriously thinking of going to Oracle and using >>> RAC/DataGuard for their high availability solution. >>> I know Informix can compete with this, as I'm pretty sure Cheetah has >>> the la…
Re: current informix white papers ?
White paper - ftp://ftp.software.ibm.com/software/data/informix/ids11-availability-wp.pdf Redbook - http://www.redbooks.ibm.com/abstracts/SG247488.html?Open HTH -Nilesh. informix-list-bounces@iiug.org wrote on 02/28/2008 10:20:36 AM: > My company is seriously thinking of going…
current informix white papers ?
My company is seriously thinking of going to Oracle and using RAC/DataGuard for their high availability solution. I know Informix can compete with this, as I'm pretty sure Cheetah has the latest and greatest in HA software. I am unable however to find some decent white papers on …
IDS11 SDS
Hi! I have some problems getting SDS up and running. I set up 2 machines with v11.10FC2, both connected to a SAN. dbsroot is located on the SAN and can be seen and read and written from both machines. Configuration of both machines is identical except to the points mentioned i…
Informix to Oracle replication
I realise that this is a high-level question. IDS 10.0. Does anyone know of a product, available NOW, preferably IBM but not necessarily, that could viably insert data from an Informix database into an Oracle data warehouse in more-or-less real time (say a delay of up to 15 minu…
Re: Hands-free Administration
"Chris Youll" <nospam_cyoull@comcast.net> wrote in message news:C62dnV3Z9MkWJjnanZ2dnUVZ_g2dnZ2d@comcast.com... >I have been trying to follow the resurgence of Informix IDS and the new >cheetah product line. In the "Chat with the Labs" presentations and the >IBM Web site a grea…
How to initialize an SDS instance
Hi, is there anybody who installed an SDS instance on IDS 11.xx. Maybe you can tell me where I can RTFM? Is theI have there anything I have to take into consideration when creating my raw devices? TIA Stefan…
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…
SDS
Hello, I have played around with SDS some and it seems to work quite well. I have a question if the following will work though ... server1 - primary server2 - secondary . Both systems get shut down ...and host names are swapped...then brought back up ..desired effect... serve…
Re: RAC in Informix by year end?
Data Cruncher wrote: > Taken from DBTA magazine. > > Did I read this correctly? Does it mean that by year end Informix > will offer RAC. > > ============================================= > HDR, RSS and SDS servers and even ER can be combined in any way to > provide a sophisticate…
IDS 11 sds problem
Hi: I installed IDS sds in SUN OS 5.9, I initialize the primary and SDS server successful. I could execute some query from SDS server, But after I ran some applicaton in the primary server, The sds server disconnect from the primary server. In the online.log , IDS report the fol…
Re: High Availability HDR suggestions
> 1. Is there any other option in which blobs could be replicated using > synchronous HDR with blobs in blobspace ? 1: contact TS and file a feature request, in the mean time store your old fashioned blobs in dbspaces. > 2. I know it's not a good idea, but I thought I'll write.…
High Availability HDR suggestions
Version: IDS 10 I was reading about HDR and it looks like in HDR blobs are not replicated to secondary server if they are of type simple large objects. We don't want to move to smart blobs as it requires large code change and we probably don't have enought time to make that chan…
Re: IIUG Conference Topic Survey closing soon
I only pointed out that these tests were avaialble at Prometric centres as it has come to my attention that some people are unaware of this and understood they could only take these tests at the various conferences. The same "free" testing was available at the IM technical confe…
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
Thanks Madison, replies intertwined below... Madison Pruet wrote: > Tool wrote: >> 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 o…
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…
HDR vs. SRDF
I'm setting up a high availability/DR environment for a 9.40 database on AIX. The service provider wants me to use EMC's SRDF to replicate/clone data at the disk level vs. using HDR. Has anyone successfully used such a technology for this purpose? I prefer to use Informix native …
HP Continuous Access XP and Informix
Anyone using HP's Continuous Access product on their XP as their High Available/Disaster Recovery solution? Good? Bad? Don't care? ____________________________________________________________________________________ Sponsored Link Compare mortgage rates for today. Get up to…
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…
Mirror or Raid1? Replication or DRBD?
disposablegarry@googlemail.com said: > > Obnoxio The Clown wrote: >> I'd personally prefer HDR, but that's just because I don't have the same >> level of history with DRBD. > > I'm just now browsing through the IBM Informix manual on Enterprise > Replication ... is there a shorte…
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: Highly available database ....
Vivek- You probably need to try Enterprise Replication. It is built into all versions of IDS after 7.x. It allows (among other things) many nodes to update each other, so that any update made on one is replicated on the rest. If one node fails, the rest continue running seaml…
Highly available database ....
I am looking for a solution for Informix (7.31 or 9.4) to have high availability. Like in OracleRAC, you could have multiple nodes sharing same set of datafiles/database. If one node goes down, the other(s) continue to up and serve. Preferred environment - HP / Unix Thanks, Vi…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Mirror / Raw device / Informix
High Availability data replication?…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
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: Reliability System for Informix DB
Hi, for real high availability you should consider HDR (High availability Data Replication), which is built in with IDS (except with Express and Workgroup editions). Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-infor…
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…
Sun Cluster Agent for INFX version 10
Informix Sun Cluster agent is tested/certified with 9.X and 10.X ( SC 3.X) Regards, Mahesh Dashora Development Manager (Backup Restore, High Availability and Utilities) Database Development Information Management Division 4100 Bohannon Drive Menlo Park, CA - 94025 email: maheshd@…
HA cluster on SCO Open Server
Hello all, our company needs to setup an high availability cluster on two machines running SCO Open Server and Informix. Does anybody have any experience with such configuration or at least can anybody point me where to find more information about supported HW minimal versions …
cluster
hi all, is this possible to build a cluster with 2 informix (IDS 9.x) DB (load balancing,high availability..)? what must i look at ?…
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'?…
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: 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…
HDR for high availability
How many customers use HDR for high availability purpose. Meaning, they use it for failover when the primary node goes down. If possible, can those customers contact me off-line. Thanks. Ravi…
Question regarding oncheck
This warning means that ONCHECK has acquired a table level lock required for its operation. It does NOT mean that ONCHECK was unable to check something. It is info for you to indicate that exclusive access can not be obtained on table while this check is on. Regards, Mahesh Dash…
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.…
Logical Log Backup Informix 9.4 linux
If you mirror logdbs (on which log is residing) in different disk, you should be fine, If disk with primary logdbs fails server will continue with mirrored space. Regards, Mahesh Dashora Development Manager - Backup Restore, High Availability and Utilities IBM Informix Developme…
Re: Work group edition - Unlimited edition??
"rkusenet" <rkusenet@sympatico.ca> wrote in message news:c5mn32$3c28b$1@ID-75254.news.uni-berlin.de... > > "David Williams" <djw@smooth1.fsnet.co.uk> wrote > > > This information is a bit old though..perhaps things have changed? Can > > someone from IBM confirm? > > Here is the l…
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…
ER to replace HDR in HA environment
We have been told to figure out how to replace our current HDR environment with an ER update-anywhere solution, in order to eliminate "outages" (planned or unplanned) with the DB server. Our environment: -- HP-UX 11.0 on identical HP RP7400 servers (8 cpu at 750 MHz, 16Gb memory…
ER to replace HDR in HA environment
We have been told to figure out how to replace our current HDR environment with an ER update-anywhere solution, in order to eliminate "outages" (planned or unplanned) with the DB server. Our environment: -- HP-UX 11.0 on identical HP RP7400 servers (8 cpu at 750 MHz, 16Gb memory…
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…
Difference between Enterprise Replication and HDR
Hi can any one you, please tell me what is the difference between Enterprise Replication and High Availability replication. I have worked extensively with HDR, but i dont know what is ER. Can I get the information on ER and how it works and what are the requirements and specifia…
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…
onpladm load job with spec file (includes simple but lengthy test case)
On 24 Nov 2003 10:06:50 -0800, christopher.coleman@mediware.com (Christopher) wrote: >Part of the fun of migrating to new releases (besides learning new >bugs and incompatibilities with old apps) is learning the new >utilities. > >For example, I am attempting to learn the onplad…
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: Company thought DB2 will be better than Oracle.
Blair Adamache <badamache@2muchspam.yahoo.com> wrote in message news:<bk7qnv$igs$1@hanover.torolab.ibm.com>... > For more formal approaches, DB2 supports High Availability through the > following packages / methods: > > HACMP on AIX > Microsoft Cluster server on Windows > Sun Clu…
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: failover
Check out Informix's High-availability Data Replication (HDR). You can RTFineM about it in the two "Data Replication" chapters in the Admin Guide. HDR works well, is easy to set up and maintain, and is very reliable. HTH, Paul Mosser -----Original Message----- From: ajhowell@m…
failover
We are on Informix 7.30.UC3 and Solaris 7. We are considering Legato or Veritas for a high-availability/failover solution. Any comments or opinions regarding either of these options (reliability, ease of use, etc) or a different option would be greatly appreciated. Thanks! Sen…
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…
informix replication
Informix has two replication strageties. The first (HDR) provides mirror image replication. Basically the source instance is replicated onto the target instance. This provides High Availability with a rather low latency. Also it is fairly easy to setup. However it does have …
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 on HACMP
Hi, Currently I'm handling IDS 7.3 on R/S 6000 F50 machine. My company want to upgrade the system for the purpose of availability. Therefore they wanted to implement High Availability Clustering Multi Processor (HACMP) meaning that they will put another server that will share th…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
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: High-Availability For Informix
>From: Don Ignacio <dignacio@techie.com> >> >>Here lies the problem, is there any software together with HDR switch the >>applications >>to the secondary server as well as switch the secondary server to standard >>mode once >>the primary server fails. Basically, achieve the shor…
Re: High-Availability For Informix
From: Don Ignacio <dignacio@techie.com> > >Here lies the problem, is there any software together with HDR switch the >applications >to the secondary server as well as switch the secondary server to standard >mode once >the primary server fails. Basically, achieve the shortest do…
Re: High-Availability For Informix
From: Don Ignacio <dignacio@openratings.com> > >Anybody out there can suggest some high-availability solutions using >Informix. >Something like an automatic switch over. Really, about the easiest and most robust way of doing this is to use HDR. ER is a lot of work (even if it is…
Re: High-Availability For Informix
Hi, We are currently using IDS 9.2 on a Sun E45000. In this Informix version they removed the DRAUTO configuration parameter, which basically tells the secondary server what to do in case the primary server fails. This parameter is existing in 7.x. The easiest way to overcome t…
High-Availability For Informix
HI, Anybody out there can suggest some high-availability solutions using Informix. Something like an automatic switch over. Don…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
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…
Ontape returns errno 27
you meant TAPESIZE parameter? yes, it set to 12 GB. as far as i know if backup size exceeds TAPESIZE informix should ask for next volume... kaido > > See if your TAPEDEV param is larger than 2 GB. > > -- > ------------------------------------------------- > With best regards, Y…
Informix and HP MC/ServiceGuard implementation
Has anyone had experience configuring Informix Dynamic Server and HP's MC/ServiceGuard High Availability product? If so, how was that experience? Regards, Jon Small…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
Re: HDR info
From: James Myers <user@internet.com> > >Can anyone point me to some documentation on how to use >High-availability Data Replication with Informix 7.3 on linux? >I've been able to glean from deja that it is possible, but I can't >find anything on Informix's site about it. RTFM. …
HDR info
James Myers wrote: > Can anyone point me to some documentation on how to use > High-availability Data Replication with Informix 7.3 on linux? > I've been able to glean from deja that it is possible, but I can't > find anything on Informix's site about it. > > TIA Hi James, Have…
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…
Database monitoring
onstat -D & onstat -g iof will tell you which dbspaces are being hit hardest. onstat -g ppf (if TBLSTATS is set to 1 in the ONCONFIG file) to track table usage. onstat -d to track available space by chunk from which you can calculate the results by dbspace (see mention of dbs…
CLI.CPI cpio archive
cpio -icvdBum < CLI.CPI HTH. -- ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest'…
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…
Activity Tracking
> I initially turned to using "onlog" but that does not give you "select" > activity. > > Any ideas? Use audit. ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior Syst…
disconnect session
onmode -z ses_id ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284…
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…
NT 4.0 Sp 5
Paul Gostelow <Paul.gostelow@cableinet.co.uk> wrote in message news:7v3od8$dou$1@news1.cableinet.co.uk... > We are trying to install v7.3 of the Workgroup Server on NT 4 with Sp5. Can > anyone tell me why the DB Engine doesn't start? It works fine with Sp3. Informix is complian…
Re: Update Statistics Plan for IDS 7.31
On Wed, 20 Oct 1999 03:42:10 GMT, dwilson@gtemail.net (Douglas Wilson) wrote: >On Tue, 19 Oct 1999 08:42:48 BST, "Obnoxio The Clown" <obnoxio@hotmail.com> >wrote: >>If you have two indexes >> >>index1 on table (a, b, c) >>index2 on table (a, b, d) >If these are the only indexes…
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…
Sylvan Prometrics sertification
Hi All ! Sorry once again. I've asked some weeks ago, but nobody answers ... Another try. If someone has passed this exams, can you _PLEASE_ send me question examples ? ---------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix techn…
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: Choosing a right database
From: tmgn <tmgn@excite.com> > >I strongly disagree with the Statement that Oracle 7 or Oracle 8 are not >24*7 >Databases. It is a well known fact that Most of all the Critical Round the >Clock >Databases (including top Ecommerce sites) in the World use Oracle becos of >it's >Hig…
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.…
New High-Performance ODBC & JDBC Drivers for Informix
OpenLink Software announces commercial availability of the latest release (version 3.2) of its High-Performance ODBC, JDBC, and UDBC Drivers for Informix. These drivers connect to backend Informix servers with or without I-Connect / I-Net. This data access driver suite enables …
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…
How about a bit of help folks?
Currently I have 14 screaming clients wanting Informix folks! There are well over 30 positions available for which Im putting my best efforts forth and try and fill. If you're currently looking at availabilities either contract or full time p-l-e-a-s-e send me email to: Maria91…
Duplication of the database
Andres Stiller wrote: > > Hi, > > I have a problem to duplicate my Informix Database > to a backup server during the night. No chance to do it. > I've got Informix V.4 and WindowsNT Server 4.0. > > Can anybody help and tell me how to do this? Upgrade to IDS 7.31 and use Enterpri…
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…
High availability config question
We are about to design a configuration of three servers and a separate array of disks, as shown in the ASCII-drawing below (best viewed with a Fixed Width font): +-----------------+ | Array of disks | …
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
RE: high availability data replication examples??
Whoa -- the $INFORMIXDIR/demo/cdrapi programs are for ER (Enterprise Replication), also know as CDR (Continuous Data Replication). This relatively new type of replication is completely different from the older HDR (High-availability Data Replication). The best place to find out…
high availability data replication examples??
Hello, I would like to know if there are any examples on any web sites/ftp servers online with examples of configuration needed to setup high availability data replication on an Informix database?? I am looking for sample code and scripts.... My platform is Solaris 2.x Thanks …
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…
Re: ??? ONPLOAD ????
> I don't find in the user manual the onpload command. What's the use of > this command ? What does this line means : time onpload -p myproject -j > job -fl It's part of the High Performance Loader, for which there's a separate manual. Documentation is also available in the Ans…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
ODBC & JDBC Drivers For Informix SE On Linux
All, OpenLink Software is pleased to announce availability of High-Performance ODBC and JDBC Drivers for Informix SE on Linux. These Drivers support the following client environments: Linux, UNIX (all flavors), MacOS, Windows95/98/NT, and Java . These drivers are available on …
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…
IDS Server 3.0 Released
IDS Software is pleased to announce the availability of IDS Server 3.0. IDS Server is a compact and high performance Type-3 JDBC solution, which offers advance features such as Secure JDBC, firewall access, ResultSet Caching not available in other competing JDBC drivers. htt…
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: +…
Re: Monitor tools
Hi Eric, Yes , there are tools available from Informix to monitor the performace. They are basically like HPL ie High performance Loader but here you need to have X-Term or Emulation client then you can achieve your task very easily. Hope this helps. Regards ameya21@hotmail.c…
RE: Update statistic question
Is it true that the more often you run update statistics, the less time it takes to run, because I have a 26GB, 9000 table SAP database, and running update statistics high on the whole database is taking me about 5hrs. I expected it to take much longer than that. Is this about r…
Re: Update statistic question
Susan Elliott (ISG) wrote: > > Thanks to all of those who have been answering my questions over the > last few days !!! Its much appreciated !!! > > I have a question about the Update statistics script that we do > here.... > > #### Beginning of script ##### > set isolation dir…
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…
Webkit & 4gl advice
I have a client that has a large legacy program (>200,000 lines of code) with more than 250 input and output screens all character based. They need to upgrade their product to a graphic user interface. We are looking at the feasibility of using web browser and rewriting i/o scr…
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…
New Informix JDBC & ODBC Drivers Released
OpenLink Software is pleased to announce the commercial availability of its new High-Performance Data Access Driver Suite version 3.0, comprising the following bundled Data Access Drivers: High-Performance Open Database Connectivity (ODBC) Drivers available in Multi Tier (I-Net …
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Alternative ODBC drivers?
In article <348D861B.5C6C@sympatico.ca>, kgoertz@sympatico.ca says... > Are they any third party Informix ODBC drivers available? > > I am writing an application on a very short schedule, and I have found a > memory leak with the Informix ODBC driver using BYTE data (inside Visua…
Re: JDBC and IUS ?
Gert, You can use the JDBC-ODBC bridge, which comes as part of the JDK1.1. It requires ODBC to be installed and configured. It's not the fastest solution, and in the long run is not recommended by Informix, et al, but it is free. Native JDBC drivers are available from Inte…
New Informix JDBC Drivers
OpenLink Software is pleased to announce availability of the latest release of its High-Performance JDBC Drivers for JDK 1.02 & JDK 1.1. These Drivers are available in Type 1 and Type 3 format supporting the following database engines : Informix, Oracle, Sybase, MS SQL Server, …
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…
Informix on Digital
Morning Folks Anyone out there running Informix over Digital that would care to comment on their experiences to us? We are presently evaluating hardware vendors to replace our existing systems and have a kind of nice looking high availability solution presented from Digital for t…
Informix Replication/High Availability
We are in the process of setting up a "high availability" database consisting of 2 Sun Ultra Enterprise 4000 servers and Informix Online 7.2x database. We are considering using either Informix's data replication or Sun's HA option. Does anyone have any thoughts or experience usin…
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…
High-Performance Loader on NT?
Is High-Performance Loader available for NT? In which version? Regards Michael…
Re: Data Replication Implementation
In article <5jn3qp$bet@cssun.mathcs.emory.edu>, datamas@kuwait.net (datamas) wrote: > > Hi Friends, > > I am having two HP machines > > 1. HP K200-Production System, Dual Processor, 196 MB RAM > > 2. HP 827-Disaster Recovery System, Single Processor, 128 MB RAM > > By any chanc…
Re: JDBC Implementation
On 28 Feb 97 at 8:40, Kelly Harrison wrote: > I've noticed that there are freely available JDBC and Perl > interfaces for Oracle. Are there such things for Informix? The highly esteemed Jonathan Leffler is currently refining dbperl for Informix. There are JDBC drivers as well.…
Continous data replication.
Some time ago, I heard about something called Continous Data Replication (CDR), a concept for geographically distributed databases to maintain integrity over a (reasonably) low bandwidth network. In version 7.20, there is something called HDR (High-availability Data Replication),…
Re: Need to create a highly secured database
Hi I don;t know of any 'off the shelf' product that will do what you want on a record-by-record level, but with an application cut for the purpose you can do anything you want - quotes available on request.... Regards John Jenkins BTW - by 'highly secure', do you want it techi…
Re: Ztools - any good ?
ibogorad@lhr-sys.dhl.com wrote: :Hi people , :Has anybody ever used Ztools ? I used them during the beta test periode and found them very nice indeed. :Any good or it is not worth it ? For me the price where too high at the time. I may decide to buy them later when we get more…
RE: New JDBC Drivers
OpenLink Software has made a Beta Release of its High-Performance JDBC Drivers available for download from: http://www.openlinksw.com/opljdbc.htm These Drivers support: Oracle, Informix, Sybase, CA-Ingres, MS SQL Server, Progress, Unify, and postgres95. Enjoy !…
JOB: Database Administrator for SGI
Silicon Graphics a leading supplier of high-performance visual and enterprise computing systems. The company's products range from low-end desktop workstations to servers and high-end Cray supercomputers. SGI opportunities for Sybase Database Administrators...To research, design…
Announce: High-Performance JDBC Drivers
OpenLink Software would like to announce the availability -in wide beta- of its High-Performance JDBC Drivers for the following Database Engines : Oracle, Informix, Sybase, CA-Ingres, MS SQL Server, Progress, Postgres95 and Unify 2K. You can download these Drivers by visiting :…
Re: 32bit ODBC
OpenLink Software's High-Performance 32 Bit ODBC Drivers for Informix are available for download from : www.openlinksw.com Austria Mineraloele <austria@adis.at> wrote in article <31E39BF9.4643@adis.at>... > Is there a 32bit ODBCdriver for informix available - and where? >…
Re: SCO not recommended for high number of users.
Nils Myklebust (Nils.Myklebust@ccmail.telemax.no) wrote: : jparker@hpbs3645.boi.hp.com (Jack Parker) wrote: : Jack, the following isn't written so much to disagrea with you as : to give others in the group some new information. You may have noticed that I'm very reluctantly dra…
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…
Tips on a highly available & scalable dbms needed
We are trying to select a relational database that will have the following properties: - Windows NT compatible: use native NT threads, and not be just a Unix-port to NT. Plus all of the product (tools, APIs, etc.) must function in the NT environment. - Scalable: up to 100 milli…
Any tuneable parameters for informix/unix
David, This is a good machine and should be giving high performance. I think before looking at the OS I would be making sure that the engine is prperly tuned first. Follow the Informix instruction manual for this and make sure that all required environment variables are set up …
Re: Informix data fragmentation or RAID disk
> I find this subject very interesting. I have heard this before and it > raised a few questions re raid/non raid with high-end database systems. > From my point of view i thought perhaps wrongly that all the raid would > do assuming it was used to stripe (raid 0) was increase th…
Announce: Fast ODBC Drivers On WEB
OpenLink Software's High-Performance 32 Bit ODBC Drivers are available for download from URL: http://www.openlink.co.uk These Drivers provide access to : Oracle, Sybase, Ingres, Informix, Progress, Unify, and MS SQL Server Database Engines hosted on: UNIX (all flavours), Windo…
32 Bit ODBC Drivers For Download
OpenLink Software is pleased to announce the availability for online download of its New 32 Bit High-Performance ODBC Drivers for: Informix, Oracle, Sybase, CA-Ingres, Progress, Unify, and MS SQL Server. These Drivers are usable by Windows 95 & NT based 16 Bit or 32 Bit ODBC co…
Re: ANNOUNCE: TechGnosis - Availability of SequeLink 3.0
In article <mcarpentier-2208951403460001@pc2.techgnosis.com>, mcarpentier@techgnosis.com says... >TECHGNOSIS INC. ANNOUNCES THE AVAILABILITY OF SEQUELINK 3.0 > -********* Deleted text ************** >Apple Macintosh ODBC Support > >SequeLink provides full connectivity to ODBC-com…
$$ Dallas - Informix Contract Available - $$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ Contract positions available now for individuals experienced in Informix 4GL Location: Dallas, TX Rate: Negotiable Start Date: Immediate Pay: Negotiable Length: 4 to 6 months Company: High Point Technologies, Liz Powers Fax: (214) 6…
Performance Data for Informix 7.1 ??
Hello, I am wondering if there is presently performance data on Informix 7.1 (specifically the "oninit" server engine) readily available. I realize that such data is highly machine-dependent, and so also would like to ask: Is there already a publically available test-suite that…
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?…
Executive level DBA needed
Applied Data Systems is a St. Louis based search firm specializing in the placement of both PERMANENT and CONTRACT data processing personnel. ADS provides quality solutions and personnel to the computerization needs of business throughout the south and midwestern US. A client of…
Informix Replication in release 6.0
Greetings, We are planning to use Informix replication to provide a high availability set up. The idea is to use the replicated database ar a R/W database when the primary fails. My questions are: Can the switchover be made automatic? How long are the databases unavailable? A…
Re: End user reporting tool for SCO Unix
IQ Report Writer. Available on Unix and Windows. Great to work with. Highly recommended. Brian Ronnenberg (brianant@iaccess.za) wrote: : Does anyone know of a end-user report writer for SCO Unix that works with Online 5 ? : Please Email me if you know of any. -- Neil - @storm@az…
rootdbs corruption with Online 5.01
Does anyone have experience of rootdbs corruption in the following environment when the system is rebooted (/etc/reboot or power fail) ? Platform: HP 9000/715 Operating System: HP-UX 9.01 Informix-Online 5.01.UD3 The rootdbs (170MB) was stored on a raw partition of a 525MB disk…
unload in esql
I am using Informix v. 4.0 and the esql features. I have a database which has about 20 odd tables in it. I wanted to have a script which would load/unload to any (from) table of this database, so thought of writing an esql/c program. ( beacuase I could locate only dbload …