Oninit® Archive
Results for “STOP_APPLY”
Not enough room in ROOT DBspace
It looks like your physical log is taking up most of your space. I would imagine that this was moved and grown in your other instance. Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of STEVEN AB Sent: Wednesday, January 04, 201…
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 ------------------------------…
What prevents a RSS to roll forward as fast as its primary?
You also need to indicate which Informix version you're using. In addition to the obvious resource differences Art has highlighted, significant changes to the communication and other H/A cluster technologies occurred in v.14. Off the top of my head, I can't remember the exact fix…
Odd restore failure
Andreas: Thanks for expending brain power on this for me. Yea, onstat -g arc shows what's expected, the last onbar level 0 and level 1 archives which were both full server archives. Also, as you note, both my ontape archive and ifxclone runs were full server so that's not it. Her…
restore through STDIO
Hello. Unless you are trying to create an RSS node on your cluster, I don't see any benefits in using zip/unzip. 1-huge cpu consumption in a serialized method. 2-your network link should be already a high speed to accomodate your primary load for HDR replication. 3-if you are dea…
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…
dbexport lock question
Thank you, Art. Yet, I wonder... if STOP_APPLY is set = 1 (which, I would think, means zero writes are happening) then why can't dbexport put an exclusive lock on the database? DG…
How to DROP unlogged table on RSS?
The fault was totally mine. Indeed Mr. Marques nailed it. I had set STOP_APPLY to 1 so that I could do a dbexport. After dbexport crashed because it encountered the raw table, I failed to reset the STOP_APPLY before DROPing the table in the primary. So, naturally, it didn't DRO…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
HDR Solution
Hi, Currently we have used informix IBM Informix Dynamic Server Version 11.50.FC8GE workgroup edition running on hpux. Our production load already full utilize during peak hour. To reduce load on production server, we plan to separated process to another server, means OLTP proce…
sbspace size insufficient after dbexport/dbimport
Thank you, so much, Art. I had hoped to be wrong, but feared I was right. It just makes us use more space. Oh well. But, it does raise the question in my (alleged) mind, why doesn't IBM provide a way to backup/copy/clone/export (any or all) a database? We have struggled for y…
Re: Restore a specific table from a ontape backup
The first table is there for information purpose only. It use original customer table to know how to extract the rows from the data pages. You can then place the data in any target table using the insert/select syntax (including a remote system). Yes archecker will prompt you fo…
Ebexport
Here are the steps to be followed if you want to perform a *dbexport* on a secondary sever. 1/ Make sure that a dbspace of type TEMP is available * before doing a dbexport , you have to have a TEMP dbspace 2/ Make sure the secondary server is RSS or make it RSS if you are in H…
Compress Repack Slow Performance
Dear All, Have an instance of Informix 11.7.FC4 that runs on AIX PowerHA Cluster, IBM POWER machines, with 64 logical cores, 160GB or RAM memory and FC storage. Have a total of 600GB of chunks, containing few big tables within 1 DB (100GB (100mil records), 70GB, 50GB) fragmented…
dbexport on RSS Secondary
Im running IDS 12.10.FC6 on SLES 11 SP 4 with a primary and RSS secondary on separate boxes. At http://www.oninit.com/presentations/v117.pdf I see the following: Enhancements To Dbschema, Dbexport & Dbimport It is now possible to use the dbschema and dbimport utilities on all …
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)…
Re: Improves - what you need?
I love this sort of initiative... Comments in line: On Mon, Oct 27, 2014 at 6:37 PM, Cesar Martins < cesar.inacio.martins@gmail.com> wrote: > Hi ! > > Few weeks ago I received some updates from IBM RFE (Request for > Enhancement) where some requests was rejected ... > > Featur…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Using Informix ODBC with connection manager
Hello. As soon as you implement your CM, it will be a "network gateway" for your production cluster (and maybe redirect your connections to any cluster node, according to your CM defined policy). So, your ODBC connection will be changed from your database, to your CM hostname/p…
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.…
database replication setup help
If you run HDR to "Site1" and your WAN drops, your HDR primary should just continue to run. What it will do is hold the logs until the WAN is back and the secondary asks for them. If the logs turn over while the secondary is down, you have to either replay logs from tape on the s…
Informix SNMP and replication
Hi, I read in the technical documentation Informix 11.50 : "The*onsnmp*utility cannot be run on HDR secondary servers, remote standalone (RS) secondary servers, or shared disk (SD) secondary servers." Do you know why ? Do you know if the replication (HDR or SDS) will be supporte…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Re: HDR Reconstruction (with ER :-))
Hello Keith, Maybe RS Secondary is something that could work for you instead of a HDR secondary. Superboer. Am Donnerstag, 22. November 2012 10:39:21 UTC+1 schrieb Keith Simmons: > Hi all > I am going to raise a case for this query but wanted to get some community > feedback/t…
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,…
SQL/Optimizer Question
Just eyeballing the schema provided I am guessing you will get 16 rows per 2KB data page. assumed row size of 120 bytes. WHERE i_case_relation_cd = 3 is currently evaluated to return 98,108 rows while we do not have the statistics on the table, the cluster value would indicate h…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Informix Clustered Indexes
On Tue, Jan 31, 2012 at 07:53, Tom Lehr <tomcaml@gmail.com> wrote: > Have been doing some reading about clustered indexing and wondering > what experiences other folks have had with them? > We currently do not use them in our high transaction OLTP world and am > a bit wary due t…
Monitoring IDS 11.50.FC6 in Fast Recovery mode
On 05/12/11 19:02, Jonathan Smaby wrote: > Good morning, > > I have a situation where my development database IDS 11.50.FC6 went down last > night. I've restarted the DB engine with oninit. The Informix state is in Fast > Recovery mode after for a very large transaction (insertin…
RSS with DELAY_APPLY is dog slow!
On Nov 10, 2:52 pm, Nick <milesnmi...@gmail.com> wrote: > Hello, > > Does anyone have experience with RSS and the DELAY_APPLY feature? > > I am running tests, with the end goal to find the best HDR or RSS > setup that will minimize the performance impact on my primary db > server…
HDR & RSS
Hi Sergio, after your physical restore (onbar -r -p), Informix should automatically start the logical recover, until sync the two instances. (It seems you´re facing some configuration issue between them) Have you enabled SMX connection between them? I suggest you to do so.... he…
Problem with enterprise replication
Andy Sorry, read the 'important' bit and missed the 'some time very important, but often information only' bit :-)) DDRBLOCK only occurs when the Replay is unable to move (or only moves slowly) and gets caught by the Current. This can be because the target is not responding cor…
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…
951: Incorrect password error after Big Fix.
Just for curiosity, what is a "big fix"? Regards. On Fri, Jul 22, 2011 at 3:02 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > We had the Big Fix reverted back to the original password file on 107 > serve= > rs. That fixed the issue with the userid logins. It also affected t…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Quick Recovery
Thanks for the info. If we enable STOP_APPLY, then how we need to keep RSS active (even behind primary) ? Do we need to apply logs (manually) ? Thanks.…
Error -19816: Cannot perform this operation on a
The error message/code has nothing to do with your HDR replication which permits dropping a table. Either the table in question is defined as a replicated table using Enterprise Replication or there is an active Change Data Capture (CDC) session open that is using the CDC API to …
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…
Export the databases from secondary
Yes, you can do that. You can do dbexport on HDR secondary but sometimes export taken on that way (when HDR is still active) may have different number of rows for some tables in database.sql file, and real .unl file which is in database.exp folder ... To resolve this, you must e…
SDS and SAN Storage
On Aug 12, 8:21 pm, rpa <ruediger.pa...@t-online.de> wrote: > 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 UBUN…
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…
DBEXPORT IN RSS NOT WORKS
Hello, Tatiana. According to the documentation, it could be just right. (Just a guess) how did you set the STOP_APPLY=1 ? Best regards. Em 30/07/2010 11:36, TATIANA FLORES escreveu: > because no > temporary dbspace exists -- Alexandre Marini Tecnologia da Informação - DBA m…
RE: dbexport on RSS client
Hi everybody!!!! I tried to do a dbexport with the following: dbexport basedato -o /path I followed the path Paul sent, but I got the following in the RSS node: ""The operation cannot be performed on this RS secondary server because no temporary dbspace exists. Set the DBSPACE…
Backup from RSS server
You could use the new ontape STDIO backup and restore, simultaneously, to do it. Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug…
dbexport on RSS client
This function was enabled in 11.50.xC6. On the RSS turn on STOP_APPLY , onmode -wf STOP_APPLY=1 and set USELASTCOMMITTED=ALL using onmode -wf. Regards, -Ping ----- Original Message ---- From: "Chin, Paul (TSG-OSDO)" <pchin@hp.com> To: ids@iiug.org Sent: Mon, April 12, 2010 7:…
Suspending HDR temporarily?
informix-list-bounces@iiug.org wrote on 02/05/2010 04:13:03 PM: > From: > > pretzel <davidegrove@gmail.com> > > To: > > informix-list@iiug.org > > Date: > > 02/05/2010 04:16 PM > > Subject: > > Re: Suspending HDR temporarily? > > Sent by: > > informix-list-bounces@iiug.org? > > …
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
IDS 11.50.xC6 is out...
Hello, IDS version 11.50.xC6 is currently available. It has become usual for these fixpacks to bring a lot of new functionality, besides the usual bug fixing. From the release notes: 1.5 What's New in Version 11.50.xC6 of IBM Informix Dynamic Server 1.5.1 External Bac…
RE: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
> From: domusonline@gmail.com > Subject: Re: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this? > Date: Mon, 7 Dec 2009 23:14:12 +0000 > To: informix-list@iiug.org > > Ian Michael Gumby wrote: > > I have to agree that the issue is interesting…
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…
ANYONE KNOW IDS USERS OR CONSULTING FIRMS IN NYC
I am looking for work in the New York City metro area. Can anyone refer me to an end-user or a consulting firm?.. below is my resume: Frank J. Rotolo, frank.pr@msn.com _______________________________________________________________________________ Summary: Over twenty six years…
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…
External backup
Neil Truby wrote: > -----Original Message----- > From: Madison Pruet [mailto:mpruet1@verizon.net] > Sent: 27 July 2009 19:38 > To: Neil Truby > Subject: Re: External backup > > Neil Truby wrote: >> IDS 10.0 for example, any O/S. >> >> I've never understood why we have to an onmod…
Re: 11.50.xC4 Compression with workgroup edition?
An easy way to distinguish between IBM (DB2 and IDS) compression and Oracle compression is to look at e.g. an employee table with, say names and addresses and other junk (like salaries ;-) Block compressions wins, as Mark points out, in fast changing data. Global compression wins…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
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: Smoke and mirrors...
On Oct 12, 2:20 pm, InDeep <ind...@indeep.com> wrote: > Ian Michael Gumby wrote: > > To your point. Yes IDS will perform much better that either Oracle or > > DB2 in a VM environment. > > Let's not make sweeping statements without facts. I have been happy with IDS > so far on VM…
Re: Smoke and mirrors...
Ian Michael Gumby wrote: > To your point. Yes IDS will perform much better that either Oracle or > DB2 in a VM environment. Let's not make sweeping statements without facts. I have been happy with IDS so far on VMware Fusion on my Macbook Pro, but I have not had a history of ex…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Simple logical log question
Hi, well, when using ER I would probably heed the advice and add more logical logs, possibly with bigger size. I would do this using the "onparams" utility, rather than changing the onconfig file. [ ER uses logical log records to replicate data changes to other IDS instances. I…
Managing IDS in IBM HACMP environment
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > ROBERT ROMERO > Sent: Thursday, May 08, 2008 1:59 PM > To: ids@iiug.org > Subject: Re: Managing IDS in IBM HACMP environment [12053] > > Appreciate the comments. > > We are plan…
Re: Optimizer Issues with 10.00.xC8
Another point of confusion that has me summoning the UPDATE STATISTICS gods. As a reminder, my test table ("foo") looks consists of five columns, col1-col5. Col1, Col2, and Col3 are integers, while Col4 and Col5 are character fields. I have a unique index on (Col1, Col3) and a…
High Extent Tables.
Quick question: 1. If I create a clustered index and drop it on a table with high extents, will that reorganize it and reduce the extents or 2. Do I have to unload the data, drop the table, re-create the table, and re-load the data or 3. Should I rename the original table to a…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
looking for logical log data reconstruction utilit
Yes, it helps. Thanks John. Regards, Jim > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > John Miller iii > Sent: Wednesday, December 05, 2007 12:27 PM > To: ids@iiug.org > Subject: RE: looking for logical log data reconstr…
What is ids11 new function RSS for?
Hi, also in the Administrator's Guide there is a section that is partially copied here: Differences Between an RS Secondary Server and HDR An RS secondary server is similar in many ways to an HDR secondary server. Logs are sent to the RS secondary server in much the same…
Restoring Level 1 Backup ONLY - INFORMIX 9.4
ids-bounces@iiug.org wrote on 07/31/2007 10:16:55 AM: > Dear All, > > I am trying to restore level 1 backup ( with ontape -r ) on a machine ( > solaris 8 )on which I have a level 0 backup already restored preveiously ( > while restoring I terminated restore at the point when lev…
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: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
IDS 10.x on HP 11.23
We are toying around with the idea of a poor mans HA solution. This is our idea: Itanium is primary and PA-RISC is secondary only we don't use HDR. Volume groups are visible to both servers. If primary goes down we could bring the instance up on secondary. Will the data be read…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Senior Oracle DBA now Learning Informix by Request
Tambi Dude wrote: > "DA Morgan" <damorgan@psoug.org> wrote in message > news:1166401364.229016@bubbleator.drizzle.com... >> Tambi Dude wrote: >>> "DA Morgan" <damorgan@psoug.org> wrote in message >>> news:1166388023.574809@bubbleator.drizzle.com... >>>> How one defines quality is…
HP-UX PA-RISC/Itanium
HP claims that HP-UX maintains high degree of compatibility between PA-RISC and Itanium based system. Here is the quote from document they published on their website (http://h21007.www2.hp.com/dspp/tech/tech_TechDocumentDetailPage_IDX/1,1701,9928 ,00.html): "One of the design go…
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…
Moving data between instances
No, only logical logs that are currently online can be replayed. However, IDS 10.00UC5 can resynch without using the logical logs (and there is a set of synch/resynch scripts for earlier releases available). I don't remember that you quoted a version you are using. Check out the …
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: AW: Mirror / Raw device / Informix
What happens whihlst you are doing this the machine is rebooted e.g. hardware failure, panic, power failure? When IDS (+possibly ISM) restart what happens? Model-Bosch, Tilman wrote: > There is a third option, you may use the perpetual restore method > where you keep a secondar…
AW: Mirror / Raw device / Informix
Art Kagel wrote: > > There are better solutions however. As hinted by others, > Informix provides > two levels of database replication that can be used to > maintain a secondary > server which is either a hot backup system for failovers only > or which is > indeed a live server …
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.…
Free space...Clustered Data
Urich Ann wrote: > Do many companies use clustering indexes...via table data ordered by a > key (clustered)? > > Is there a performance boost in Informix when the data is clustered -- > and then retrieved via cluster sequence? The performance benefit is marginal - and debatable.…
Re: IDS 10 erratic run times
"Neil Truby" <neil.truby@ardenta.com> wrote in message news:3pliprFb403pU1@individual.net... > IDS 10.0FC3 on Solaris 2.9 > >>> This is a brand new server which we are preparing to migrate a v9 system >>> to. > Over the past few weeks I have run multiple dbimports from more-or-le…
RE: Informix/TSM Point In Time Restore
Yes, been there, got the T-shirt. You can only recover to point in time if you restore ALL dbspaces. If you don't back up all dbspaces you can't restore ALL dbspaces. I even had to backup and restore temp dbspaces despite the fact that they are cleared when you restore. The s…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Re: Update Statistics
The order I run update statistics is 1) MEDIUM DISTRIBUTIONS ONLY, 2) HIGH for first column in an index, 3) LOW for all other columns in an index, 4) UPDATE STATISTICS FOR PROCEDURE <procname> Is this still the recommended order? Regards Colin >From: "Andrew Ford" <andrewfor…
Re: Update Statistics
Yeah. I've got all of that. But is it true that running update statistics high (or medium) without the 'distributions only' clause does the work of low (building statistics) plus some extra stuff (building distributions). I've been putting a lot of work and thought into optimi…
RE: Update Statistics
Update statistics low doesn't build distributions, the way high does. It compiles information about the structure of the indices (depth, leaf nodes, clustered-ness, second-highest and second-lowest values, etc), and places them in systables, sysindexes (or sysindices, in IDS 9.4.…
Re: XPS
"Mark Townsend" <markbtownsend@comcast.net> wrote > Oracle was using three pricing metrics in those days - unlimited user > pricing based on the MHz of the CPUs, named users and concurrent user. > > In 2000 the unlimited user pricing for Oracle Standard Edititon was $15 > per MH…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: serial and sequential scan
superboer7@planet.nl (superboer) wrote in message news:<bb790a36.0502160532.2c2ac371@posting.google.com>... > where is OPTCOMPIND set to???? if 2 then set it to 0 > > or > > export OPTCOMPIND=0 > > start dbaccess with your problem qry. > > Superboer. > > > > "Bill Dare" <dareb@je…
Re: serial and sequential scan
hajek@nspuh.cz wrote: UPDATE STATISTICS MEDIUM FOR TABLE... Is insufficient. Unlike HIGH and LOW, MEDIUM does NOT update the systables, syscolumns, and sysindexes records. It is the information in the latter that IDS uses to determine the cost of using a particular index. I …
Restoring a level-1 backup at a later date?
Sounds OK, but you would have to level the new server in "recovery mode" for the few days having told it you have got a level one archive you want to restore. i understand you don;t have time to test your whole production instance, but you could maybe create a new small instance…
AW: Problem with ER
Hallo Keith, Thanks again. (hope you had a nice holiday). Another question (for all): When I do "cdr stop group groupname" how can I verify the status of a group (information in a table in syscdr? or cdr - command?) Thanks in advance. Heinz -----Urspr�ngliche Nachricht----…
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: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: Views question?
Comments in-line. rkusenet wrote: > "Mark Townsend" <markbtownsend@comcast.net> wrote > >>Hey - I'm the bug, fat buzztard. Anyhow, still no winner. I believe both >>of these do have Alter Table Drop Column. So who could it be ? Lets >>think about this for awhile. Are we all thi…
Q: continous restore at remote instance?
Davorin Kremenjas wrote: > Hello. > I searched old posts for a possible solution to the problem I have but > without success. > The summary is this: is there a possibility to continously restore > transactions commited on one Informix instance to another? > I know about HDR and …
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.…
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: An interesting meeting with IBM
"Andy Kent" <andykent.bristol1095@virgin.net> wrote in message news:ac5fb36.0404080205.28a8b515@posting.google.com... > Data, > > Yes, I've worked with Oracle. > > Not sure why you ask. > I needed to get answers first before proceeding. Most of the time when people say they will…
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…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Re: Anyone seen this behaviour before ?
TBP <TheBIgPotatoe@Nospam.Nothere.Co.Uk> wrote in message news:<brn87n$vi0$1@sp15en20.hursley.ibm.com>... > mad_villan wrote: > > I have a HDR pair which were working fine up until lately. The primary > > runs in a veritas clustered environment - secondary is standalone. > > Conf…
Anyone seen this behaviour before ?
I have a HDR pair which were working fine up until lately. The primary runs in a veritas clustered environment - secondary is standalone. Configuration is fine. However, when i recently failed over to the second node in the cluster the instance came up cleanly BUT there was a con…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
oncheck -me Feature Request
OK, I've collected the comments of the discussion on oncheck -me, and my own correspondence with contact, and these are the results of my investigations: 1- oncheck -me was never intended for general release 2- it was not completed internally and is not completely safe, meaning…
Re: Log compression for replication ??
Jack, I'm more concerned with the reasons for the buildup in the TCP send queue than with trying to implement network compression for this. I'd like to see this worked a bit so that we can find out where the bottleneck actually is. The HDR receive thread on the secondary shoul…
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…
force engine to use indexes
Because your update statistics indicate that the data is highly unordered and will result in multiple hits for the same data page. Because of that, it is mathematically faster to do a sequential scan of the data pages and sort them than it is to hit the same data pages multiple …
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…
Avoiding rebuilding of indexes
<Jinu.Joseph@citicorp.com> > We operate on a database of size 22 GB. For operational efficiency and > speed it was suggested that the indexes be dropped and recreated on a > weekly basis. Now the problem is that this takes 7 hours, and we dont > have that much time. So there are …
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: NUMCPUVPS
mmmmm In addtion to what the others said.... Are you running KAIO? If you are do the following echo "_ncols/D"|adb -k /stand/vmunix /dev/kmem If this going up at all be worried, if it's going up real fast be very worried. It measures the number of collisions ie the number o…
RE: Logical log restore
Almost anything is possible. See below for comments. The answers may vary depending upon which Informix backup tool (ontape, onarchive, onbar) is being used. -----Original Message----- From: Kudzi Muchaka [mailto:KMuchaka@HAFresno.org] Sent: Wednesday, August 16, 2000 10:44 To:…
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…
IDS 9.20 in a Clustered Environment
Hi All, Has anybody implemented or used IDS 9.20 in a clustered environment? I would particularly like information regarding its uses as a High-Availability and Scalability Solution. Any information will be greatly appreciated. Thanks, DOn…
ODBC connectivity with EDS
Hello Admins, I having a problem connecting to my EDS environement running in a clustered environment. I have SDK (2.40 TC1) in my windows NT workstations and when I do Ilogin demo and try to connect to the EDs database I get -952 error. I have a IDS 7.31 enviroment in the sa…
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:
From: SAMPATH <sampath@gulfins.com.kw> > Its not RAID. Its a cluster software as series of disks will be >in a box accessed by differenct Unix servers. Thanks. I believe the technical term is "disk farm" :-) OK, as long as it's not RAID 5, you're over hurdle no 1. Now for hur…
Re:
From: SAMPATH <sampath@gulfins.com.kw> > > We're having IDS 7.3 running on Alpha 4100. All DBspaces are raw >partitions and mirrored. We are planning to move the disks out of >machine and put them as a disk array with clustering software from >Compaq. 5 disks + 1 emergency disk. …
RE:
Hi, Its not RAID. Its a cluster software as series of disks will be in a box accessed by differenct Unix servers. Thanks. Sam > -----Original Message----- > From: Obnoxio The Clown [SMTP:obnoxio@hotmail.com] > Sent: 01 June, 2000 11:44 � > To: sampath@gulfins.com.kw; informix…
Posting from the Informix-list
Hi, We're having IDS 7.3 running on Alpha 4100. All DBspaces are raw partitions and mirrored. We are planning to move the disks out of machine and put them as a disk array with clustering software from Compaq. 5 disks + 1 emergency disk. Has anyone tried this before? If one of t…
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…
Re: Top Databases Used
Well it depends on all what you will be doing with your database. OLTP "based stuff" Informix, no doubt, fastest in the market at oltp with little or no headaches. Warehousing data of 1 terabyte or more, Teradata, period. Easy to manage, DBA's dream. "Stuff's not running fast…
Re: informix, linux and beowulf
Informix does NOT use that kind of clustering as is present in Beowulf. The Informix clustered product, XPS or IDS 8.xx, uses multiple co-servers in two distinct ways. 1) It can spread a database, indeed even a single table, across multiple coservers on the same or on different…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Borland Delphi and Informix
Hello everybody, we have huge performance problems on our 2-node Sun-Cluster with Informix: Environment: Sun E4500, 6 CPU's, 1GB Memory (primary host for database) Sun E3500, 4 CPU's, 1GB Memory (secondary host for takeover) 4 A5000-Diskarrays with 14 9,2GB disks each connec…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Re: Replication and HDR
In article <38552dce_3@news.delphiauto.net>, "Michael K Anderson" <michael.anderson@eds.com> wrote: > On Tue, 30 Nov 1999, Greg wrote: > > <gresmi@yahoo.com> wrote in message news:821u53$dir$1@nnrp1.deja.com... > > We are looking at implementing replication between 2 of our ser…
RE: Replication and HDR
OK, here's my .02... I am currently responsible for four HDR-pairs of servers -- three production pairs and one development pair. All servers are HP boxes, but I'm sure that most of this will apply to AIX, too. For each production server-pair, one server is in Sacramento, CA, …
Replication and HDR
We are looking at implementing replication between 2 of our servers, a primary in Ft. Lauderdale and the secondary in L.A., possibly using Informix's High Availability Data Replication (HDR) tool. Our questions are these: 1. The Informix manuals state that the hardware and OS mu…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
IDS on NT feasability
This is an OLTP or DSS system? For a 50GB system, personally, I'd opt for some kind of UNIX. NT just chugs its heart out and as was mentioned, is more expensive the bigger it gets. Of course, you could pilot the system on both NT and a UNIX of some kind. IBM has good NT, in …
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
A question about Indexing.
Vijith Gunawardhana wrote: > > Hi > > In my work environment we are using Informix Dynamic Server AD and XP > Options 8.2. > Seems that nobody else has taken a crack at this, so I'll have a go (and try to leave my prejudices at the door :-)). > > Here they don't use indexes at …
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
RE: -710 Error in Multithreaded Informix 7.24 UCX5 on HP-UX 10.20
We also had this problem and figured out that when we did a HPL it changed the constraints and indexes, loaded the data and then changed the constraints and indexes back to what they were defined originally. -----Original Message----- From: Art S. Kagel [SMTP:kagel@bloomberg.n…
-710 Error in Multithreaded Informix 7.24 UCX5 on HP-UX 10.20
Jim Maus wrote: > > My multi-threaded Informix esql process received a -710 (table-name has been > dropped, altered, or renamed) error. The process was using a prepared > statement to fetch using a cursor. The source table was not dropped, > altered, or renamed. I cant reproduce…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
HELP: HDR Restart Fails after upgrade
Platfrom: IBM RS/6000 J30 & J40 Informix: IDS 7.24.UC1-1 Earlier this morning I upgraded both boxes to the above version from 7.23UC1 We had HDR running with no problems. Now when I attempt to restart the severrs I get this message on the primary DR: Primary server connect…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Informix database reorganization
You may want to check out the alter fragment statement. Art Kagel have posted several times on this theme so you should look for that at http://www.dejanews.com What I write here is based on what Art has posted and he may correct errors in this: It sounds like you have all your …
Informix database reorganization
We're looking for a way to dump and reload our Informix database (right now 7.22UC3) that will cause the minimal amount of downtime to our users. Our machines are RS/6000 F50s, AIX4.2.1, and we use SSA disk drives. Our database server is a three-way box with 2GB of RAM. We have 6…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: How to reduce SE .dat & .idx file sizes?
We're also running SE-Databases and there is only one way to downsize the dat and idx file sizes: unload, drop, load or an dbexport/dbimport. My solution for this problem is to do a weekly dbexport/dbimport in cron. If greater/more lecks in your dat / idx files, this will slow d…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Informix Directions
Has anyone out there been working with Informix since the late '80s? Remember how they simply dumped VMS support back then? Seth "Tim Schaefer" <tschaefe@mindspring.com> writes: >Yeah, um, but I heard that the SCO porting of Informix is over. There = >will be >no more SC…
Re: Informix Directions
Yeah, um, but I heard that the SCO porting of Informix is over. There = will be no more SCO ports, and Informix is dumping the small end. What does this do to the market, and in particular, my career path? It = goes in the dumper to stay with Informix. Apparently this is prob…
Informix ON-Bar/ADSM Info
I am forwarding a note to this list from an Informix/ADSM user. His experiences with ON-Bar may be helpful to others. From: David Hendrix <dmhendri@FEDEX.COM> Organization: Federal Express Corporation Subject: Informix ON-Bar/ADSM Info To: ADSM-L@VM.MARIST.EDU For those w…
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…
Re: De-fragmenting tables. Some questions
An even easier way is to use the "ALTER FRAGMENT ... INIT ... " to rebuild the taregt table wherever you want. For a big table I'd do it at odd hours with logging off so you don't get bit by a long transaction. Greg Thomas J. Girsch wrote: > > Expanding on Art's expansion on …
Re: De-fragmenting tables. Some questions
Expanding on Art's expansion on David's suggestion: A quick-and-dirty way I used to use to defragment tables was to do an ALTER TABLE NEXT SIZE to set the next extent size sufficiently high, and then do ALTER INDEX <pick-an-index> TO CLUSTER. Be warned, though, that this method…
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: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Chris Curvey wrote: > > > If you have row level locking, the first select stmt will lock one row. > > As the primary key is 4 bytes you can potentially put 4-500 keys on any > > page (if you have 2K pages). In a page lock system (like Sybase and > > MSSQL) the probability of a us…
Re: Question on Update Statistics
[This followup was posted to comp.databases.informix and a copy was sent to the cited author.] In article <19971107041400.XAA11881@ladder01.news.aol.com>, kponn@aol.com says... > Hi > > If I want to run update statistics on busy tables, can I do the following: > > 1. select tabn…
Re: [Q] How do I force usage of index
Daniel Williams <#danny@uk.ibm.com> wrote in article <341014AA.41C6@uk.ibm.com>... > > Is there any way I can force usage of the indexes to see if it makes any > > difference (presuming that the the query optimizer has decided not to > > use them for some reason) ? > > Have you r…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: script or spl for update statistics
In article <5ujprh$mcu@cssun.mathcs.emory.edu>, zeljan@laus.hr says... > Hi, > > in Informix Guide To SQL Syntax there is recommendation for updating > statistics: > 1) run update statistics with distributions only > 2) run update statistics high for columns with indexes > 3) run…
Re: Informix and Clustering
Nils Myklebust wrote: > > Informix and NCR have some special cooperative solutions to this used > successfully by several customers. There was even a setion on this at > the reasent user conference that your local Informix office may be > able to get information on for you. SUN, …
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Help: Reducing Extents -Reply
Just a comment about Gregs posting. I have also used fragment to rewrite a non-fragmented table in place. I have found afterwards a high likelihood of receiving 243/172 errors on such tables. This seems to be reduced if they are [de]fragmented into a different dbspace that they…
Re: Help: Reducing Extents
Chad, after increasing the NEXTSIZE in systables (don't worry too much about the first extent, it'll tend to be coalesced pretty well unless you have a lot of fragmented tables in the same dbspace). two methods not mentioned are: 1. use onunload/onload - it's waaaay faster tha…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <862264236.20961@dejanews.com>, Brenda Muller <muller.brenda@primestar.tci.com> writes: > > >plans like clustered SMP systems with fiber between the boxes, > > >or some NUMA-like MPP systems with "memory" connectivity > > >between boxes (I still don't see how that woul…
Foreign keys and indexes
We use a mixture of foreign keys and application managed referential integrity, depending on our application. I prefer application managed RI on our larger databases because it is more efficient. We have some very large tables with highly duplicate values on the child columns t…
Re: ***Bitmapped Indexing API Beta - Now Available***
Patrick Gainer <gainer@64k.com> wrote: >Deon du Plessis wrote: >> 3) THE ROUTINES OVERCOME THE PROBLEMS ASSOCIATED WITH HIGH CARDINALITY >> >> DATA. This is basically acheived by breaking the data into sections. >> If there is no data in a particular section, a BM for that secti…
Re: cluster index
I agree with Billy et al regarding the process for updating. I thought I might add that we use clustered indexes as a means of database maintenance. Every so often we will suspend use of the database, run appropriate clustered index creates, and then remove the indexes on compl…
Re: Indexes and Stored Commands/Procedures
On 12 Sep 1996 01:49:06 GMT, sammers@pop03.ca.us.ibm.net (crunch) wrote: > >General question on indexes. > > IMHO tables (with indexes) that have high volumes of insert and >delete operations need to be re-index periodically, else 'bad' things >will happen. Please comment. Hi, W…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Informix, Sybase, Oracle or MS SQL server
> : Sybase: > : Liked dealing with them but it seems that they have some serious > : problems--no row-level locking, no two-phase commit. I like their > There's another thread in here kicking around row level vs page level locking. > It pops up periodically. I have not found …
PRESS: EDS' dbINTELLECT TECHNOLOGIES & INFORMIX FORM STRATEGIC
EDS' dbINTELLECT TECHNOLOGIES AND INFORMIX SOFTWARE FORM STRATEGIC=20 RELATIONSHIP MENLO PARK, Calif. (April 8, 1996) -- Informix Software, Inc.,=20 (NASDAQ: IFMX) the leading provider of parallel processing database=20 technology, today announced that EDS dbINTELLECT(SM) (dbI)…
Re: Large table extents
Cheryl Kendricks wrote: > > Yes to question 1. Yet, if you have an index and set up query correctly > to use index it will use it. But once a table becomes highly fragmentted > either due to delete or insertions it is a good idea to unload and reload > the table. Or if you have …
Re: Large table extents
On Wed, 13 Mar 1996, Cheryl Kendricks wrote: } Yes to question 1. Yet, if you have an index and set up query correctly } to use index it will use it. But once a table becomes highly fragmentted } either due to delete or insertions it is a good idea to unload and reload } the ta…
Re: Large table extents
Yes to question 1. Yet, if you have an index and set up query correctly to use index it will use it. But once a table becomes highly fragmentted either due to delete or insertions it is a good idea to unload and reload the table. Or if you have enough space within the dbspace ju…
Re: Clustered indexes - again
} >So given these responses I am confused. Does leaving an index } >clustered effect future inserts/updates etc? } } >Robert Clark } } } > } >-------------------------------------------------------------- } >e-mail: robert@clark.netkonect.co.uk } >snail: 12 Balvernie Grove, Wan…
Re: Clustered indexes - again
On Wed, 13 Mar 1996, tolly brumbelow wrote: } robert@clark.netkonect.co.uk (Robert Clark) wrote: } } >OK, } } >I have now had a few responses to my original Q about clustered } >indexes - thanks to all of you. } } >Dan Madvig (d-madvig@bethel.edu) said: } >> If you leave it chus…
Re: Clustered indexes - again
robert@clark.netkonect.co.uk (Robert Clark) wrote: >OK, >I have now had a few responses to my original Q about clustered >indexes - thanks to all of you. >Dan Madvig (d-madvig@bethel.edu) said: >> If you leave it chustered, then every time the index changes >> the engine has t…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
performance is the least reason to choose oracle over sypbase, ingres, informix. even if sybase and oracle were the same, oracle is superior in so many ways that it defies description. consider the mass of client tools, media tools, internet tools, and the presence of "row level…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Sorry...I can't resist... To paraphrase a certain executive: "We're faster, cheaper, better. Cool. Think about it. Then buy SYBASE." >For an apples to apples comparison consider the following: > > DBMS Platform CPUs TPC-Cs Cost/Transaction > ----…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
For an apples to apples comparison consider the following: DBMS Platform CPUs TPC-Cs Cost/Transaction ------- ----------- ------- ----------- ---------------- Sybase HP T500 12 5,600+ $390 Oracle HP T500 12 5,369 $535 …
** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
REDWOOD SHORES, Calif., Oct. 27 /PRNewswire/ via First! -- Today, Oracle Corp. announced a record-breaking TPC-C open systems benchmark, 9414 tpmC, surpassing the existing performance record, also held by the Oracle7 database. Oracle7's new record is more than two times faster …
Re: Care and feeding of OnLine
Okay, I was hoping that by being vague, I would get a wider range of responses. I see now, though, that I was too vague. I'll try again to get the ball rolling. What my client-oriented customer is looking for is some simple steps they can perform to keep their OnLine da…
Re: VLDB - for real?
What is a VLDB? Used to be 10GB, now it's 100GB, soon it will be 1TB. And the Intel 8086 used to be an adequate processor for most end-user computing. It's all relative. There's probably a corallary to Moore's Law in regard to database size. About the same time that Informix ann…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: Clustered Indices
In article jql@ixnews3.ix.netcom.com, tcummins@ix.netcom.com (Tim Cummins) writes: >In <3p6toh$ojl@cssun.mathcs.emory.edu> phr@fmsc.com.au (Peter Harris) >writes: >> >>I have RTFM but I am still a tad mystified, when do you use clustered >>indices and when do you avoid them? what…
Re: adjacent row delete bug
} From: kwa@mtatm.mt.att.com (K.ANDERSON(MT5756)XXXX) } [...] } We are now seeing the problem with NON-adjacent rows. I am assuming we } are banging up against another bug. } } Does anyone know a another like bug ?? } Maybe it's not a bug. Are you using the default page lock mo…
Data deletion in Informix
In Message-Id: <3d3v5v$lkc@raffles.technet.sg> sgs@technet.sg (Alan Chen) writes: > If I have done a mass deletion on tables, when I do a tbstat -d , I don't see > the space being free up. Is it the space was free logically but not > physically ?? The space is still allocated f…
Re: Info Req: Informix online replication services
> > Informix On Line Replication Services > > I am considering using Informix On Line Replication Services in an application > where we would have a number of geographically seperated offices that will > feed transactions into 12 regional servers. Each regional server is expected…
Re: What affects performance?
In article <CqsC5J.H96@rosebud.strinc.com> amw@rosebud.strinc.com (Allen M. White) writes: >In article <2sk35o$80v@goshen.connected.com>, >Kurt Schmidt <slores@goshen.connected.com> wrote: >>In article <Cqq0no.9x9@boi.hp.com>, Jack Parker <jparker@boi.hp.com> wrote: >>> >>>But mo…
Re: What affects performance?
In article <2sk35o$80v@goshen.connected.com>, Kurt Schmidt <slores@goshen.connected.com> wrote: >In article <Cqq0no.9x9@boi.hp.com>, Jack Parker <jparker@boi.hp.com> wrote: >> >>But more seriously, Paul and the other posters made some very valid points. >>What the original reques…
Re: What does sysindexes.clust contain?
graeme@pyra.co.uk (Graeme Sargent) writes: : Who can tell me what the numbers in the sysindexes.clust column mean? : : I realise that low numbers mean clustered and high numbers mean : unclustered, but what does (eg) 4000 mean? 4000 whats? Is 4000 : acceptably low or unacceptab…
What does sysindexes.clust contain?
Who can tell me what the numbers in the sysindexes.clust column mean? I realise that low numbers mean clustered and high numbers mean unclustered, but what does (eg) 4000 mean? 4000 whats? Is 4000 acceptably low or unacceptably high? If one wishes to write a utility which tro…
IBM Publishes First TPC-C Benchmark on Open Systems
Subject: IBM Publishes First TPC-C Benchmark on Open Systems On Tuesday, February 2, 1993, IBM released the FIRST TPC-C benchmark results executed on open (non-proprietary) systems. The next day, February 3, 1993, HP released the second set of TPC-C benchmark results on open sy…