Oninit® Archive
Results for “DS_HASHSIZE”
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 …
Can we get the same output as onstat -g spa from SQL queries against sysmaster
Henri: Honestly, if you set SQLTRACE to LOW or MEDIUM and have a reasonable number of reasonably sized buffers configured, I have not seen any significant performance hit from turning SQLTRACE on. The single incident I did see was a client who crashed their host be configuring a …
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 ------------------------------…
A lot of extents in temp tables
Leandro: I didn't realize that you were only concerned about the temp tables. There isn't much you can do if you do not have access to the application code. However, unless you do not have sufficient cache configured a temp table with many extents should not be a problem. In the …
Informix recommended setup for storage
Hi everybody, we are planning a new database server (pair, should be HDR) for a huge customer. Our admins started a discussion on how to configure storage. We want to have ~6TB of space and are planning to be running with a set of NVME Raid (Raid 10, 5 disks e.g. 5x3.8TB like Sam…
Informix 14 - ALTER JOIN -
Miguel: Ordinarily I would suggest that VM performance is always unpredictable and moving from one OS version to another has also impacted performance, however, if inner joins are consistently faster and outer joins are consistently slower, that's not caused by the VM or the diff…
DIRECT_IO/KAIO
John: Using DIRECT_IO will indeed use KAIO! Here's the full story: When Informix accesses RAW chunks (so character devices) it uses the OS's KAIO facility by starting a KAIO thread in each CPU VP to handle all IO to/from those RAW chunks. By default, when Informix accesses chunks…
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…
memory monitor
Original post: HI, I use informix version 12.10, How to monitor below memory through SMI? dictionary cache; table statistics cache; ...... thanks for your time. Lu chuan Response: Well first off, when you say "table statistics cache" I'm assuming you mean the cache the s…
Bufferpool configuration
Hi informix community, on a SPARC M10-1 Server we have a informix 12.10FC10 instance. Currently this instace use a buffer pool with around 7GB. Now i have the chance to configure the buffers up to 40GB. I would like to use the following configuration of the buffer pool: BUFFER…
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.…
contention on dstpool
Hi, I run 'onstat -g spi | sort -nr -k 2 |head -20 , and the output show high contention on dstpool,currently the ds_hashsize is 31, ds_poolsize is 127, How to tune those two parameter, Do anyone has any guideline ? thanks.…
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…
Full memory even if I set SHMTOTAL
Are you sure this is shared memory that's being allocated beyond SHMTOTAL? Once going over those configured 16 SHMTOTAL, would you also see this=20 reflected in 'onstat -g seg' ? Andreas From: "CHALLENGER212 ABDERRAFI" <abderrafi212@gmail.com> To: ids@iiug.org Date: 22.01.2017 …
IDS 12.1- Query cost High
Mike, I would love to understand what caused a same query plan to be significant slower in an N+1 version compared to an N version. That's not neither normal or usual. I've seen a corrupted index cause the query to use a different query plan (if run on a secondary server) or ca…
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)…
oninit taking ages
Hi all, before I post a PMR: did anyone see an informix instance take 25mn to start ? 25 minutes was with 12.10FC4 on a linux/red hat VMWare (big server according to the vendors) With 12.10FC5W1, i had to wait 46 mn before deciding to kill oninit. I am using huge pages and RESI…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
RSS/HDT Sec - Different Query Plans???
True... But there were some bugs that when we run updatet statistics on the primary, and when the resulting catalog data was sent to the secondary(ies) the in memory cache of the distributions was not refreshed. This can cause the mentioned effect. Regards. On Tue, Jul 7, 2015 …
Informix Memory Large Pages Sizes
Hi, We are running Informix 11.70.FC7 on Solaris 11. It seems like all Informix shared memory is using 4 MB page sizes. Solaris supports up to 2 GB page sizes. How to I configure Informix to use larger page sizes when allocating memory. This is different from the BUFFERPOOL page…
-272 when using role and synonym
sysdbopen() doesn't get executed on distributed queries. Which actually is not a big deal... If you need to have a role for direct connections to the DB and a different role when running a distributed remote query you can create a sysdbopen() procedure and set the role for direct…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
- Workgroup Edition (WE) does support Enterprise Replication with no restrictions. However, Everett's basic point stands. If you are not now using features that WE does not support, or can do without them without hurting performance or breaking your applications, then WE is a …
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.…
informix 11.70 growth edition features
HI All, There are several things to look at. There is a difference between*Distributed Database* and *Distributed Processing*; this latter is sometimes called Distributed operations. A *distributed database system* consists of a collection of sites, connected together via some…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
anyone using Netapp
We are using Netapp with Solaris 10 and Informix 11.70.FC5 since April. The Netapp Storage is a part of the SAN. Each Informix Server instance has it's own volume which is splitted in a couple of luns. Important attributs: Big Flash Cache (1 TB), Stretched Metrocluster. Metrocl…
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…
Linux: oninit returns "shared memory base address illegal", fails to start
Art, I've been getting that error message "Insufficient free huge pages in /proc/meminfo for shared memory segment. Requested: 204800000 bytes. Available: 0 bytes. The default memory page size will be used." since I first installed and configured. The engine…
Problem with identifying root cause of continual m
Ok. I think it probably some application problem. Could you check out if your Informix server is using OPTOFC=1 value? It should. I also suggest you to search for the JDBC connection string (or properties), for IFX_AUTOFREE parameter. It also must be turned on. Maybe that´s the c…
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 …
11.50.FC8 aio memory pool allocation seems high
after upgrading our client from 11.50.FC5 to 11.50.FC8 (aix) , the engine uses aprx 130 meg more of virtual shared memory. By comparing historical onstats between the two versions the increase is in the aio memory pool (~230 meg) , where on FC5 the usage topped around 90 megs... …
Shared memory connection to HDR Secondary
original post: Folks, IDS11.50 FC8, Redhat Linux It is not allowed to have a shared memory connection to a HDR Secondary( with dbacess..), is it? Thanks, Frank Response: No, as long as you are on that machine you should be able to use the shared memory protocol to connect wi…
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…
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.…
Physical Log Size
How did you "increase" the size? You can only do that song onparams. You cannot do that just by changing the Onconfig file Art On Jan 25, 2011 12:10 PM, "KENT GRUNDEN" <k.grunden@hoogwegtus.com> wrote: > IDS 11.50.FC4WE Windows Server 2008 64bit > > I keep getting the message wh…
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…
ONSTAT -G DIC
Try DD_HASHSIZE 1013 DD_HASHMAX 10 You should also take a serious look at the data distribution cache (onstat -g dsc) to see if that doesn't need to be increased as well. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Di…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
Re: Mach11 questions
On Thu, Sep 9, 2010 at 5:29 PM, shorti <lbryan21@juno.com> wrote: > > And your question: "-How UPDATE commands are routed if coming through an > SDS > > node" made me think you understood that. > > > The updates are transparently sent to the primary node. Only the primary > > no…
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…
new onconfig parameters added onconfig file 11.5
most of these aren't new at all. Some have been around since 7.10. Some were undocumented until around 9.30 or so. Others were new in 9.40 or 10.00. There are a few really new ones, but, the server upgrade does not, to my knowledge, update the ONCONFIG file at all. Art Art S. K…
NET or CPU VP and how many?
IBM recommends to use NET VPs for onsoctcp/ontlitcp and CPU VPs for onipcshm. So does Art. But what about onipcstr on Unix? The recommendation is not platform specific, so the use of NET VPs for network connections is probably true for Unix and Windows. What about onipcnmp on Wi…
Re: performance improvements for dbimport?
On 10.03.10 01:44, FRANK wrote: > Frank , > What is your Virtual memory size configuration? > Frank > SHMVIRTSIZE 262144…
Re: How to Change sysdistrib tables extent size?
Is what possible? In 9.xx you cannot change the initial extent size of the TABLESPACE TABLESPACE nor of the system catalog tables. You can, as informix, change the NEXT SIZE for the catalog tables before you start to create tables in the database to minimize the fragmentation of …
alarmprogram.sh
Good Morning My Informix dbs are all IDS 10FC4 and my alarm program in configure with the following parameter: ALRM_ATTENTION=3 In order to identify an issue the Im having with some particular session that is causing a excess of additional shared memory segments I would like t…
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 BUFFER POLL CONFIG *NM*
Good afternoon My Name is Helder Jesus. I was wondering if there was a formula to configure BUFFERPOOL and SHMVIRTSIZE correctly regarding the machine specifications of memory and cpu capabilities Thanks in advance seeing that this is my first post!…
Re: Resident Memory larger then expected
The RESIDENT segment is more than just the buffer cache. For example, the lock table and the data dictionary, data distribution, stored procedure, statement and other static caches are all stored in the resident segment. Also if you have set RESIDENT to a value other than zero o…
To 16K My Indices ... Or Not to 16K Them, That is
I think the answer to this question is...it depends. We looked at 16K page size (also looked at 4K, 6K, 8K, 12K and 14K) for some of our busiest OLTP indexes with the thought that a larger page size = more index entries per page/btree node = fewer index levels = better performan…
Application slow and data not saved
OK, there are three metrics that give one a quick look at the health of a server and suggest quick fixes. They are all calculated from the data in the onstat -p output which you have fortunately supplied: Bufwaits Ratio (BR): (bufwaits / (bufwrites + pagreads)) * 100.00 = 144.94…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
ISAM reads of system catalog tables
On Jun 5, 4:46 pm, Art Kagel <art.ka...@gmail.com> wrote: > System catalog tables should not be read frequently at all, either from disk > or from the cache. It looks like your data dictionary cache is mis-sized. > Look at the DD_ parameters in the ONCONFIG file. They must prov…
UPDATE STATISTICS Performace Improvement
Read John Miller III's white paper at this link: * http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/miller/ 0203miller.html * Also, you can use my dostats utility, taking the recommendations in John's paper into consideration about setting PDQPRIORITY an…
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…
9905 error with varchar in a multiset
sounds like an occasion of an oldie: 130885 9628 TYPE NOT FOUND USING SPL WHEN ROUTINE/EXT TYPE CACHE IS HAMMERED ERROR IS STORED IN SYSPROCPLAN up the values for PC_POOLSIZE, DS_POOLSIZE, DD_HASHSIZE,DD_HASHMAX, PC_HASHSIZE,DS_HASHSIZE etc. Superboer. On…
Question about sysindexes.clust
Art, Thank you for your analysis we came up with the same thing but backed into this via watching the page reads on the table during the applications run. We happened to find this as a production issue when trying to normalize this table in development so that the large highly r…
Re: Best Use of Free Memory
On 31 Oct, 00:49, "Kevin Cherkauer" <invalid_addr...@nowhere.com> wrote: > David, > > I see the confusion now. The English phrase, "Needs to acquire a buffer," is > too vague. There are really two major cases, but the manual is only > addressing one (the rarer one). The cases are…
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…
Meaning of DS_NONPDQ_QUERY_MEM
Dear All.... http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp I refered to this document of IDS 11.1 , and found the following statements: Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of memory that is a available for a query that is…
IDS 7.31.UD8 Running out of memory
Hi everyone, I'm running IDS 7.31.UD8 on AIX 5.1 ML9 and it seems that whenever I reach somewhere around 2600 informix sessions , IDS runs out of memory and can not start any further sesssions. This causes the ERP application to lock up and many orphaned sessions are left in Inf…
CPU VPs
On Aug 5, 10:10 am, Mohit <mohitanch...@gmail.com> wrote: > To scale for anticipated traffic we increased number of CPU Vps from > 15 to 25. Along with that we changed the affinity also. We were > expecting increase in performance but it actually degraded the > performance. Since…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Re: load distribution to kio vps or hash PN_ID
On Jul 28, 1:36 pm, "Art Kagel" <art.ka...@gmail.com> wrote: > The KIO threads each run in one of the CPU VPs and ONLY service IO requests > from threads running in that specific CPU VP. > > The only way to spread the load better between the CPU VPs is to properly > tune your lis…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: long checkpoint duration
Floyd Wellershaus wrote: > Hi, > The age old question I guess. But our checkpoint durations are > consistently near 20seconds. > > ids10.0 fc5 on ibm p570 running aix 5.3 7 cpus 41g ram. > ckptintvl is 300, I am considering halving that. > We have 128 lru's and 128 cleaners > 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…
Re: long checkpoints
your sar says 90% busy doing 148 r/w sec which is 1906 blocks meaning aprox 1 MB/s a sec for a disk.... having an average of 6 Kb in size... onstat -Rr |grep dirty during checkpoint will tell you how many pages per 5 secs are written. Also it will tell how many pages are reall…
Re: long time to wait until "dbaccess - Database - Select" answers
On 9 Nov, 11:39, "Keith Simmons" <smile...@googlemail.com> wrote: > On 09/11/2007, wjb <w.beh...@uni-bonn.de> wrote: > > > > > On 9 Nov., 09:59, "Keith Simmons" <smile...@googlemail.com> wrote: > > > On 08/11/2007, bozon <cur...@crowson1.com> wrote: > > > > > On Nov 8, 7:49 am, w…
Re: long time to wait until "dbaccess - Database - Select" answers
On Nov 8, 7:49 am, wjb <w.beh...@uni-bonn.de> wrote: > Hello, > > dbaccess - Database - Select > takes about 30 ... 45 seconds to list all 8 databases. > > After selecting a database it takes the same time to > show the info or the missing connect permission. > > The same behavio…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 16, 4:10 am, Colin Dawson <cjd_1...@hotmail.com> wrote: > For what it's worth, these are my settings > > # Dictionary Cache Size > DD_HASHSIZE 499 # Number of dictionary hash buckets > DD_HASHMAX 68 # Maximum number of dictionary entries p…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 16, 4:10 am, Colin Dawson <cjd_1...@hotmail.com> wrote: > For what it's worth, these are my settings > > # Dictionary Cache Size > DD_HASHSIZE 499 # Number of dictionary hash buckets > DD_HASHMAX 68 # Maximum number of dictionary entries p…
Re: Calculate optimal value for DS_POOLSIZE
Art S. Kagel wrote: > On Oct 15, 6:49 pm, Mark Jamison <maj...@yahoo.com> wrote: >> Actually I believe the confusion is betwen the DS cache values with the DD cache variables. >> >> DD_HASHSIZE and DD_HASHMAX mean something else. DD_HASHSIZE is the number of buckets or lists, a…
Re: Calculate optimal value for DS_POOLSIZE
>mohitanchlia@gmail.com >Version: IDS 10 >I am trying to determine the optimal value for DS_POOLSIZE and >DS_HASHSIZE. I looked at the onstat -g dsc. I have following question: > >1. How do I determine the correct size of DS_POOLSIZE. Should I look >at our update stats and see nu…
Calculate optimal value for DS_POOLSIZE
On 15 Oct, 14:49, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Oct 13, 3:58 pm, mohitanch...@gmail.com wrote: > > > Version: IDS 10 > > > I am trying to determine the optimal value for DS_POOLSIZE and > > DS_HASHSIZE. I looked at the onstat -g dsc. I have following question: …
shared memory already exists
I am using IDS 9.40, I get message informix log below, after I shutdown and take offline the database: 14:38:05 IBM Informix Dynamic Server Started. 14:38:05 shmget: [EEXIST][17]: key 52564801: shared memory already exists 14:38:05 mt_shm_init: can't create resident segment Cou…
Re: General IDS 11 question
----- Original Message ----- From: "John Carlson" <jwcarlson1@yahoo.com.invalid> Newsgroups: comp.databases.informix To: <informix-list@iiug.org> Sent: Wednesday, July 25, 2007 10:13 PM Subject: General IDS 11 question > Of those of you who are using IDS 11 in a production envir…
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…
slow performance for one group of tables
laurad@dis-corp.com wrote: > I have a database where six records were corrupt. One of the fields > that was corrupt was a date field so it would not allow an export to > complete. In transaction mode I updated the date field to an > acceptable value and unloaded the table. The…
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: Attempt to connect to database server (mydbSer
On 1/17/07, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote: > That's very odd. I've never had to add a shared memory port to /etc/services. > indeed the manual says: > > Because this is a shared-memory connection, no entries in network > configuration files are requi…
Onspaces freezes!
Marcus, Exactly that's my configuration. Dbaccess can connect, but onspaces freezes for a while and then it throws this error: "Shared memory not initialized for INFORMIXSERVER 'suse_shm' onstat works with both (shm or tcp). When i stop and restart the engine (oninit -v) ever…
Re: How can I get throughput of informix such as how many query/update operations per second?
eagle_jyjh@citiz.net wrote: > HI Zachi, > Thans for your reply. > I knwo it depends on many factors, however, I want to know how to > estimate the expierenced value range of the throughput for an existing > system > > > > > > your server hardware: > > …
Re: Element Size - RAID 10 SAN
Hello Art, big writes are 16 pages. haven't checked out when the pagesize is 32k yet... i would use chunks which are twice 16 pages to avoid split writes. Superboer. Art S. Kagel schreef: > Tam O'Shanter wrote: > > Wondering about the optimal configuration for a Raid 10 arra…
Element Size - RAID 10 SAN
Tam O'Shanter wrote: > Wondering about the optimal configuration for a Raid 10 array, specifically, > element/block/stripe sizes. > > Does this relate to my DB block size the same way it would with Oracle? > > Given the smaller the element size, the more efficient the distributio…
Re: how to configure this?
Jonathan Leffler wrote: > calyanram@hotmail.com wrote: > >> performance of SGSINHS002, There are 2 instances in this box. >> OS HPUX.9.x > > > You're joking? Aren't you? > > HP-UX 10.x is out of service, let alone 9.x. > > Is this PA-RISC or Itanium hardware? 32-bit or 64-bit? …
Re: how to configure this?
calyanram@hotmail.com said: > Old Server Memory Configuration : > 1. 4 GB RAM > 2. 4 CPU M/c > > New Server Memory Configuration : > 1. 16 GB RAM > 2. 2 CPU M/c > > these new instances has a boosted memory configuration for databases. > These configuration will result is total me…
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…
SHMTOTAL
Hi All, I came across this line in the Informix 9.3 Administration Guide: If messages indicate on a regular basis that the database server needs more memory than SHMTOTAL allows, you have not configured the database server correctly. Lowering the value of BUFFERS or DS_TOTAL_MEM…
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…
IFX_FOLDVIEW
Guy Bowerman wrote: > There'll be a description of the IFX_FOLDVIEW parameter in the IDS > 10.00.xC5 release notes. Sneak preview here: > http://www-03.ibm.com/developerworks/blogs/page/gbowerman?entry=new_features_in_ids_10 > > Guy > > tomcaml@yahoo.com wrote: > > hello all, > >…
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/…
EXTSHMADD New shared memory parameter?
Hi family. In configuring a new server, I noticed a parameter I have not noticed before: EXTSHMADD I'm trying to figure out from the "Administrator's Reference" exactly what is the functional difference between SHMADD and EXTSHMADD. The text reads: EXTSHMADD specifies the size…
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!…
Shared Memory challenge on AIX 5.1
One of my sites has 1 Gbyte of RAM. I have configured them to use 512Mbytes of Virtual Shared Memory and about 256 Mbytes of Resident Share Memory. RESIDENT is set to 0. During normal processing everything is OK with those settings. Occasionally the size of the virtual shared m…
Re: composite indexes and filter
bozon wrote: >>Depending on the avail statistics the database server might decide >>that a sequential scan or use of a different index is less costly. > > > Yes, the devil is in the details. If Informix decides that it would > return more records than some X % of the table it wil…
Re: Really Frustrating -9628 Errors
Sounds like a bug i've seen before but 'should' have been fixed??? ... update stats will work but it only for xx hours and someother may fail. phone TS and have them look in their bugdb. wa afaicr is cranking up spl cache params PC_POOLSIZE, DS_POOLSIZE, DD_HASHSIZE,DD_HASHMAX…
Optimizing a BaaN installation
Since this is Baan and the # of tables is as usual incredible you may want to set also DS_HASHSIZE and DS_POOLSIZE in onconfig. see old article from Art: -------- DS_HASHSIZE is the number of hash list and must be a prime number. It defaults to 31 in IDS 7.21->7.31. DS_POOLSIZ…
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: informix and web logic
I would not recommend mucking around with the system catalog.... there is a thing called Distribution cache as well which does not get handled if you load/delete whatever of the sysdistrib. (onstat -g dsc) so i would say DO NOT. Superboer. tomcaml@yahoo.com schreef: > Art, > …
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: Raid 5
Danny Wright wrote > > Someone's trying to sell us on RAID 5 and I haven't reviewed > Art's objections lately. > > They're saying all our concerns are no longer valid. > > > Agree or disagree? > Ask them what performance advantages has RAID 5 got over RAID 10. The answer - NONE…
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…
Re: Checkpoint Stall problem?
Art, to get this straight both of us should make clear what we are talking about. I was referring to bug 170919 (dup of 169447) fixed in 9.40.UC7 and 10.0.UC2. It occurs in all previous versions and behaves as I described it. Can you give us the same information about your che…
Re: Checkpoint Stall problem?
Michael Mueller wrote: > This is quite incorrect and very misleading. There is a problem only for > some huge systems and it is not as dramatic as this article sounds. The > tunig tips are also wrong. As far as I have heard it will be fixed in > 9.40.UC7 and 10.0.UC2. We're talk…
Re: Checkpoint Stall problem?
Colin Dawson wrote: > Whilst searching for information on DS_HASHSIZE, I found the following, I > went in search of the results and summary on CDI but couldn't find it. Two > questions arise: 1) Which versions does this apply to? and 2) Does anyone > know where the results are lo…
Re: Checkpoint Stall problem?
Colin Dawson wrote: > Whilst searching for information on DS_HASHSIZE, I found the following, I > went in search of the results and summary on CDI but couldn't find it. Two > questions arise: 1) Which versions does this apply to? and 2) Does anyone > know where the results are lo…
Re: Checkpoint Stall problem?
This is quite incorrect and very misleading. There is a problem only for some huge systems and it is not as dramatic as this article sounds. The tunig tips are also wrong. As far as I have heard it will be fixed in 9.40.UC7 and 10.0.UC2. There is a problem at checkpoint time for…
Re: Checkpoint Stall problem?
This is quite incorrect and very misleading. There is a problem only for some huge systems and it is not as dramatic as this article sounds. The tunig tips are also wrong. As far as I have heard it will be fixed in 9.40.UC7 and 10.0.UC2. There is a problem at checkpoint time for…
Checkpoint Stall problem?
Whilst searching for information on DS_HASHSIZE, I found the following, I went in search of the results and summary on CDI but couldn't find it. Two questions arise: 1) Which versions does this apply to? and 2) Does anyone know where the results are located? A search on CDI archi…
Checkpoint Stall problem?
Whilst searching for information on DS_HASHSIZE, I found the following, I went in search of the results and summary on CDI but couldn't find it. Two questions arise: 1) Which versions does this apply to? and 2) Does anyone know where the results are located? A search on CDI archi…
Update statistics
Tilman Mode.... wrote: > There is a way to drop distributions without running 'update statistics > low' > > You may use the SQL command: > > DELETE FROM sysdistrib > WHERE tabid = > (SELECT tabid FROM systables > WHERE tabname = '<the_table_in_question>'); > > Disadvantage of thi…
Re: FW: Latch Waits
I was talking about DS_HASHSIZE and DS_POOLSIZE which configure the distribution cache, not about DD_HASHSIZE and DD_HASHMAX which configure the dictionary cache and which use a mutex with a different name. Michael Colin Dawson wrote: > I have DD_HASHSIZE=997 and DD_HASHMAX=27,…
RE: FW: Latch Waits
I was talking about DS_HASHSIZE and DS_POOLSIZE which configure the distribution cache, not about DD_HASHSIZE and DD_HASHMAX which configure the dictionary cache and which use a mutex with a different name. Michael Colin Dawson wrote: > I have DD_HASHSIZE=997 and DD_HASHMAX=27,…
RE: FW: Latch Waits
I have DD_HASHSIZE=997 and DD_HASHMAX=27, these numbers were arrived at by running a script I downloaded from the s/w repository for calculating DD_HASHSIZE and DD_HASHMAX values. I have just rerun it and for a HASHSIZE value of 997 HASHMAX should be a minimum of 40. I'll check t…
Re: Latch Waits
Colin, I assume you are running some 7.3x version? The mutex name you see is truncated and really is "global cache mutex". This is either the mutex protecting the distribution cache (holding update statistics medium and high information) or the one for the stored procedure cache…
Latch Waits
Colin, I assume you are running some 7.3x version? The mutex name you see is truncated and really is "global cache mutex". This is either the mutex protecting the distribution cache (holding update statistics medium and high information) or the one for the stored procedure cache…
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…
question about pdq memory
If you have a certain amount of memory configured in the DS_TOTAL_MEMORY parameter in onconfig, does that mean your engine reserves that memory only for pdq queries where you have pdqpriority set ? In other words, if you are not running any queries with pdqpriority set, is that m…
RE: Memory resident tables
Gustavo Tobares wrote: > This message is in MIME format. Since your mail reader does not understand PLEASE do not post MIME. It more than triples the bandwidth required to download and store your posting. > > Hi all, > > S.O: Solaris 8 > ENGINE: IDS 7.31.UD8 > > In the last…
Informix and RAID
In article <1102689507.780115a3c1139c370adf08eac9c2039f@teranews>, "Fernandez Garcia, Domingo" <domingo.fernandez@gestion.unican.es> wrote: > Up till now we have stored data in different chunks distributed betwen = > different disks to obtain a better performance in read-write…
Cooked files vs Raw disc
Peter, Our experience was that Informix on raw devices was about 10 times faster, not 10% (this was on Solaris servers). Setting up the raw partitions was no more demanding of my time than was doing cooked devices (although our sysad had to do some work to set up the raw devices…
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'?…
finderr code 406
Greetings! I'm running a large report and seem to be getting a 406 error: -406 Memory allocation failed. Something in the current statement required the allocation of memory for data storage, but the memory was not available. Several things can cause this error. For example,…
Virtual Memory Question for IDS 7.31 on Windows
Stefan.Gabriel@nylex.com.au wrote: > Hi all, > > I have a question regarding the virtual memory portion of informix shared > memory. What is the comparison between the size of the resident memory > compared to the size of the virtual memory? i.e, if the resident portion is > 700…
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…
Memory allocation failed during query processing -AIX 5.1
A process failed on AIX 5.1, IDS 7.31 UD6 with this error: -208 Memory allocation failed during query processing. The database server needed to allocate data-space memory in order to process the query, but none was available. This error may reflect a hardware limit, an opera…
Re: Configuring Shared memory for Suse Linux 8.2
malcolm.weallans@btopenworld.com (malcolm) wrote: >Richard, >I can't find the file /etc/sysctl.conf on my system. There is a file >/etc/sysconfig/sysctl but when we tried editing that it didn't do the >job. >My Linux Sysadmin is very inexperienced, and I suspect has never >re-l…
Re: Configuring Shared memory for Suse Linux 8.2
Richard, I can't find the file /etc/sysctl.conf on my system. There is a file /etc/sysconfig/sysctl but when we tried editing that it didn't do the job. My Linux Sysadmin is very inexperienced, and I suspect has never re-linked a kernel. regards Malcolm Dr. Richard Spitz <Ric…
Re: Onbar - a few funnies
Many thanks for the help I received on this issue. It appears that one of my colleagues had inadvertently configured Informix for a very large amount of shared memory and the default settings in Linux meant that we were using 23 shared memory segments of about 32Mbytes. I have …
Configuring Shared memory for Suse Linux 8.2
After a great deal of struggling I have discovered that Suse Linux kernel parameters can be set in the /etc/rc.d/boot.local file. The real secret seems to be that the parameters can only be changed if the current working directory is /proc/sys/kernel My script to set SHMMAX 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: [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.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
RE: update statistics slowing system
Glen, I forgot to mention, that 'update statistics' intensively replaces data/index pages in the common buffer cache, and this can also effect performance of applications working with any database on the same server ------------------------------------------ Alexey Sonkin Senio…
Threads waiting on buffers
----- Original Message ----- To: dwright@sherwoodfoods.com At: 11/ 4 14:07 With that many tables also look into increasing the Data Distribution Cache (parameters DS_HASHSIZE & DS_POOLSIZE). Check out chapter 4 in the Performance Guide for details of all of these parameters, it …
Problem Installation IDS 9.4 on Suse 8.2 Intel
Hello group: I would like to start the server demo_on, on my Suse 8.2 Intel. But when = I start oninit command, it is return a message error: Fatal Initialize = on Share Memory. The file log return a invalid sh_get key. Have I need = to pre-configure kernel to configure the shar…
Problems with Shared Memory
I have problems with Shared Memory. Only 5 or 6 users can login at the same time at database using shared memory INFORMIXSERVER. All run ok changing them to tcp... but they are running a 4gl app and I want them throw INFORMIXSERVER shm. I check the sqlhosts and NETTYPE and I t…
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…
memory increase
Hi all, I'm not an Informix DBA but I want to check if what our DBA told me about configuration on Informix after increasing memory on our AIX 4.3.3 box is true. The version of Informix is 7.31UC4, I think. Is that true that after adding physical memory to the machine, we don't…
Re: Performance & checkpoint
you can double your LRU number to decrease your checkpoint duration. I have been suffered the same problem and I increase my LRU from 128 to 512 and I really help. Also you can increase your CKPTINTVL from 300 to 600. "Wayne T" <ntrieu@yahoo.com> ???????:e6623a40.0305121517.15f3…
Re: Performance & checkpoint
You've almost answered your own question. You're experiencing data growth and performance degradation on a system that, no matter how it is configured, was hitherto accurate. So, what's changed in your application, and/or in your businesss? Ref the configuration, please tell us …
Re: undocumented parameters
----- Original Message ----- From: Ricardo Manzo <Ricardo.Manzo@cosan.com.br> At: 3/12 16:20 > Hi all , > > Does anybody know the meaning about the parameters below and how does it affect > performance ? Yes... > DD_HASHSIZE Not to forget: DD_HASHMAX The above control the siz…
undocumented parameters
Ricardo; These are paired hidden parameters that tune the sizes of the data dictionary cache (DD_HASHMAX, DD_HASHSIZE); the data distribution cache, (DS_HASHSIZE, DS_POOLSIZE); and the stored procedure cache (PC_HASHSIZE, PC_POOLSIZE). These parameters are documented in the Per…
Redbrick
----- Original Message ----- To: malcolmw@fast24.co.uk At: 3/26 8:29 Several commercial applications, notably SAP and PeopleSoft, have 10,000-30,000 tables, that's the main reason. Also there are instances, like our development servers here, where you may have over 100 databases…
Nettype
Tony Woods schrieb: > > Hello all, > > NETTYPE ipcshm,1,200,NET # Configure poll thread(s) for nettype > NETTYPE soctcp,3,384,CPU # Configure poll thread(s) for nettype > > Does the above setting mean that 3 poll threads will handle 384 connections > or each of th…
DISK ARRAY
I use such an array. As Anndrew Hamm said, you'll have to present the 9 or 18GByte logical units you see from EMC as 2 GByte chunks. So, there will be an inherent level of indirection between the way you see the chunks on Informix and their physical position. In my experience,…
SHMBASE Address - From Gigi
Hi I am facing a problem .while trying to install a Informix Database on Dell 2300/500MHz Intel / Sco Openserver Unix platform. with memory of 512MB The message is like this ILLEGAL MEMORY ADDRESS showing in the logfile, when I used SHMBASE=0x0 on the configuration file.…
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…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
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…
Redbrick Memory Management & Statistics
Hi, How can I control the amount of shared memory redbrick uses? I can�t find any parameter in the configuration file. Another question: Is statistics automatically maintained in RedBrick? Is there some SQL command like "update statistics"? Thanks in advance …
RE: Informix "hardware bottlenecks"
One of the issues about RAID5 is that media degradation can occur in "unused" parts of the disk space which is only discovered during another disk failure and rebuild with catastrophic results. If there is a background media scan built into the RAID (as opposed to an offline sca…
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 …
Fwd: FW: Informix on IBM SAN?
Doug: I have been using an IBM-2105/E20 for our production database for about ten months now all configured RAID5. Our array has 3Gig read cache and 192Meg of write cache NVS per cluster. The system is incredibly fast, but you can significantly improve performance by experiment…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Maximum Instance
Is there a limit on number of DB Instance Online? Is there a connection w/ my memory? I cannot make all of my DB Instance to online state. Is there a solution on changing a configuration for an instance?…
FAQ Update
David kill the 19 June posting on RAID5 it is completely redundant to the rest of the discussion. In 8.13 PC_HASHSIZE the note is incorrect. PC_HASHSIZE is related to PC_POOLSIZE, the former is the number of hash buckets and the latter is the number of entries permitted in each…
data distribution cache
All: System info: - Informix 2000 9.21.FC1 - Baan IVc3 - HPUX 11.00 - DB 280 GB . 30,000 tables "12 Baan companies" I'm currently running DD_HASHSIZE 511 DD_HASHMAX 50 Considering DS_HASHSIZE 511 DS_P…
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…
Re: Optimize Buffer and Shared Memory Configuration
From: lkcho@my-deja.com > >Currently we are running Pentium III 800 MHz, 640 MB memory. We are >running SCO OpenServer 5.0.5 and Informix 5.10c. May I know what is >the best configuration, or how to optimumly configure buffer >configuration for Informix and shared memory for SC…
Optimize Buffer and Shared Memory Configuration
Currently we are running Pentium III 800 MHz, 640 MB memory. We are running SCO OpenServer 5.0.5 and Informix 5.10c. May I know what is the best configuration, or how to optimumly configure buffer configuration for Informix and shared memory for SCO OpenServer. What is the for…
Raima Magager Database
Hello, all Is there anyone familiar with Raima embedded database ? Does support replication or hot standby features (I want to have a main instance running on Solaris with persistent storage, and have some in-memory copies running on VxWorks ) ? If I configure it to all the tabl…
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…
informix newbie needs help - out of shared memory segments, check system SHMSEG
how much memory does your platform have in total? how much memory is the sum of all required memory for applications other than the informix instance? subtract the two, and you have an idea of how much total memory you can use for your instance. depending on your unix system, sar…
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…
shmget EEXIST 17 : shared memory already exists
Hello, We use : Informix Dynamic Server Version 7.31.UC2A on a Siemens box : ReliantUNIX-Y 5.45 A1023 RM600 6/3072 R10000 About twice a month, our db server crashes with this error : shmget: [EEXIST][17]: key 52564801: shared memory already exists ----- 03:15:52 Checkpoint Co…
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…
RE: Routine DBA activities for Informix!!!
From: William Rice <ricew@operamail.com> > >Come in late. >Leave early. >Take long lunches. >Be arrogant. >Blame it on the developer. Go BDBAFH! Use obscure terminology to confuse users. Randomly batch delete chunks of data. Randomly drop or create indexes. Randomly bounce the …
RE: Routine DBA activities for Informix!!!
Come in late. Leave early. Take long lunches. Be arrogant. Blame it on the developer. Actually from what I have seen (which isn't that much) the following seem to always apply. 1. Watch space usage. 2. Ensure backup and restore strategy is reliable. 3. Tune database. a. Try to…
RE: fragmenting tables with RAID1
>===== Original Message From "John Stephenson" <JStephen@ctr.pcusa.org> ===== >Has anyone had any experiences, good or bad, using table fragmentation in >combination with RAID1 for their dbspaces? > >I like the idea of being able to intelligently distribute the data by >expressio…
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…
NETTYPE
Hello everybody. We have a DEC-UX Alpha8200 with 2 CPU and Informix 7.31. I have the next values in ONCONFIG: NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype NETTYPE ipcshm,2,200,CPU # Configure poll thread(s) for nettype RESIDENT 1 …
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: Informix on SuSE Linux 6.2
In article <385FA8D4.5F3306F3@bloomberg.net>, kagel@bloomberg.net wrote: > [Earlier discussion SNIPPED] > > No. The ONCONFIG file parameter NETTYPE configures the listeners and > replaces the OL5.xx parameter USERS to configure the number of concurrent > users that can attach …
Re: Updating statistics
What do you mean not Y2K compliant? Are you talking about a DBCENTURY bug/problem or is this something new? Please give me specifics. Thank you, Tracy >>> <Dick.Brieck@chase.com> 12/15/99 2:20:51 PM >>> djw@smooth1.demon.co.uk wrote: "Move to 7.31.UC4 now! 7.30.UC6 is not Y2K …
Re: Updating statistics
djw@smooth1.demon.co.uk wrote: "Move to 7.31.UC4 now! 7.30.UC6 is not Y2K compliant and has bugs." I was surprised to hear this on December 13th! I thought we were compliant at 7.30.UC6. Would you please let me know what the bugs you referred to are? I am very interested. T…
Re: Updating statistics
Art, Thanks for your thoughts. In your answer to my first question you alluded to a bad index page flag problem. "...in 7.31 distributions MAY aggrevate the problem with the bad index page flags if you have an earlier version prior to the fix to that bug (fixed in 7.31UC4 or 5…
Re: System Admin Performance Tuning Exam.
From: "Neil Truby" <ntruby@netcomuk.co.uk> > >Follow my handy hints for performance tuning and you won't go far wrong: I don't think this will help Tracy pass the exam, Neil... :-) > >Disk Layout & Configuration >Don't bother. You'll have EMC or similar, and it's it's all so h…
shared memory problems
Hi I am having some difficulty getting some programs to work on a linux box (they are being ported from an HP9000) The problem I am (currently) having is that one of the processes requires shared memory to be allocated. The program requests two loads of shared memory , the first …
Re: Updating statistics
In article <38555EBD.496B23B1@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Dick.Brieck@chase.com wrote: >> >> Greetings. I have a few questions regarding using distributions with IDS. >> We're currently using >> IDS 7.30.UC6 on Solaris 2.6. I've used Informix's pr…
Re: Updating statistics
Art, Sorry if I am being a little dense about this but I have a question about one of the suggestions you made to Mr. Brieck. In answer to question 3 you said: | |> 3) Are there any other resources to consider before using distributions on a |> large scale? | |Yes the data…
Updating statistics
Dick.Brieck@chase.com wrote: > > Greetings. I have a few questions regarding using distributions with IDS. > We're currently using > IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for > updating statistics on a > limited basis on our databases. I've bee…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Re: Processor Affinity Sun 4500
Juan Ventua wrote: > Hello everybody!!! > > I have to configure two sun machine with following characteristics: > 2 sun 4500 > Solaris 2.6 > 12 cpus per 4500 > 12 gig memory per 4500 > 8 instances (4 instance per 4500) > Informix Universal Server 9.14 > > In your experience. I …
Processor Affinity Sun 4500
Hello everybody!!! I have to configure two sun machine with following characteristics: 2 sun 4500 Solaris 2.6 12 cpus per 4500 12 gig memory per 4500 8 instances (4 instance per 4500) Informix Universal Server 9.14 In your experience. I should configure binding CPU VP's to pro…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Re: informix parameters in onconfig file
edem wrote: > > Can anyone advise me what can i make better in onconfig file > Informix 7.30FC7 ( will be 7.31FC2 soon ) on HP-UX 11 ( machine V2500 6 > processors) > i am using kaio ( kaioon=1 ) > Any advise will be very helpful > Thanks! > > And this is my onconfig file : It …
dictionary cache parameters
Top Cat wrote: > > I read that the parameters (DD_HASHSIZE * DD_HASHMAX) should be greater than > the estimated number of active tables in all databases for performance > gains. Where the heck are these parameters? They are not in the onconfig > file. Environment variables? M…
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: Memory configuration on HP, Informix 7.31
---- you wrote: > I am trying to give Informix all the memory it can have. We are running 7.31.FC2 on HP-UX B.11.00 A 9000/800 with 1 Gb of RAM, there are no other applications running on the box, only Informix. > > I can give Informix about 700 Meg with RESIDENT set to 1 with …
Memory configuration on HP, Informix 7.31
I am trying to give Informix all the memory it can have. We are running 7.31.FC2 on HP-UX B.11.00 A 9000/800 with 1 Gb of RAM, there are no other applications running on the box, only Informix. I can give Informix about 700 Meg with RESIDENT set to 1 with no problems, but when …
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…
Re: read and write cache percentages
Art S. Kagel wrote: > > Everything looks fine except you definitely need many more buffers. > I'd start with 100,000 and work from there. Also with 240 users you > can need more than 16 LRUS which is verified by your enormous bufwaits > ratio of 25%, it should be below 7%. Go f…
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…
read and write cache percentages
Everything looks fine except you definitely need many more buffers. I'd start with 100,000 and work from there. Also with 240 users you can need more than 16 LRUS which is verified by your enormous bufwaits ratio of 25%, it should be below 7%. Go for broke and configure 127 LRU…
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…
SCO: shared memory problem...
Hello, I am having a problem that, hopefully, one of you have had before, or have heard about before. There box is a PII system with 128MB RAM running SCO OpenServer 5.0.5 with the latest patches. The error oninit -v gives: oninit: Fatal error in shared memory creation The er…
Re: DS_HASHPOOL and DS_HASHSIZE
kbg wrote: > > How do you configure DS_HASHPOOL and DS_HASHSIZE? > does these parameters exist on an IDS 9.14? That should be DS_HASHSIZE and DS_POOLSIZE (there was a typo in my article in TechNotes). DS_HASHSIZE is the number of hash list and must be a prime number. It default…
DS_HASHPOOL and DS_HASHSIZE
How do you configure DS_HASHPOOL and DS_HASHSIZE? does these parameters exist on an IDS 9.14? -- __________________________________________________ La meteo par le Web : http://www.meteoconsult.fr Meteo Consult - Bureau d'etudes meteorologiques Domaine de Marsinval F-78540 Ver…
shared memory error SCO install
In article <3771800C.6FF8BF38@saw.net>, Brian Adams <adams@saw.net> writes: > Why are getting this error "Fatal error inshared memory creation" > > You have to set the kernel-parameters documented in $INFORMIXDIR/release/en_us/0333/IDS_7.3. I use this script: #!/bin/sh echo SHM…
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.…
RE: shared memory question
What is the current shared memory total? How much do you want to go to? You have configured a maximum of 250Mb in the OS. If you want more than this, increase shmmax. I presume you have sufficient memory in the box! Murray Wood -----Original Message----- From: Phillip Tien …
RE: NT large memory configuration
I take it the instance comes up fine with fewer buffers etc. 300000 buffers = 1.2Gb on NT plus 131Mb SHMVIRTSIZE plue NT and anything else on it. What memory does the server have? Murray Wood -----Original Message----- From: Jay Walters [SMTP:jwalters@computer.org] Sent: Tues…
shared memory question
Phillip Tien wrote: > > I have a configuration question on the onconfig file. I'm wanting to > change (increase) the number of BUFFERS and SHMVIRTSIZE on the instance > I'm running, but I'm wondering if I should be concerned with the Unix > memory configuration before doing so. …
NT large memory configuration
I'm trying to configure a large amount of memory on Informix 7.3tc8 on Windows NT Server 4.0 sp3. When I go about 300000 buffers and some 131MB of shared memory I get the usual complaints - 13:44:43 shmat: [EINVAL][22]: shared memory base address illegal 13:44:44 usi…
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…
Shared Memory on Linux
How do I configure Redhat Linux to get rid of the Shared Memory Error when I try to start Informix (IDS 7.3)? Thanks. Aris…
DD_HASHSIZE,DD_HASHMAX, DS_HASHSIZE, DS_POOLSIZE
Hello list, Has anyone encountered either an absolute or practical upper limit to these parms? (excluding total memory requirements). I only recently got my databases updated with distribution statistics and much to my surprise encounter worst performance after the update. …
Kernel configuration
"Shevkar, Mukund" schrieb: > > We have added 128 Mb of Ram to our Sun sparc station running ver 2.6. > I want to know that how to best configure Kernel so that online (7.13 UC) > can make efficient use of the added memory . Hi, If you have included the recommended lines from the …
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
7.3x, 8.xx, 9xx Upgrade planning for OLTP product line
Will Roper wrote: > snip..... > Well, I've been called a lot of things, but never a troll, so I don't > think that's it. > OK, I got a little carried away...my apologies, no offense meant. > The million is a max - on the systems that do that, the daytime average > was more like…
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…
Unknown Error / Installation issues Universal Server 9.14
Hi there, There seem to be numerous configuration issues with NT/Universal Server 9.14. Does anyone have a typical machine configuration that seems to work. Our (test) database is setup with - 128MB ram - NT 4.0 - Universal Server 9.14 ===============================…
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?…
Sizing the dictionary cache. Does anyone bother?
andy lennard wrote: > > Hi, > > I was wondering if anyone bothers to change the size and layout of the > dictionary cache to improve performance. I certainly do. I have engines with 1500 active tables, how else to force the engine to keep all of that data in memory? [SNIP deta…
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.…
Re: Informix 5.05 kernel parameters
Carlos Aviles wrote: > The initialization is failing with the error: > > shmat: [EINVAL][22]: shared memory base address illegal > using 0xC3ABE0, needs 0xC0058000 More often than not, this error means your shared memory kernel parameters are insufficiently configured. Tr…
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.…
Re: Best database for web backend on Linux?
This is a multi-part message in MIME format. ------=_NextPart_000_1916_01BDFD9B.6C0CD360 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I pin my common procedures, so they don't get blown out of the cache. = In Oracle I have fairly …
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…
Informix on SCO
Where can I get some information on how to configure Informix Onlie Dynamic server on SCO. I'm stuck on the Root DBspace chunk. when tring to initialize the shared memory.…
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: DS 7.23 performance
Hi Niclas, first, read your Release Notes concerning the SHMBASE settings. You just have about 2000 BUFFERS, that is, 4MB of memory for your cache and about 8MB for the virtual segment. It must be possible to increase your cache. Your complete configuration file looks a bit as …
DS 7.23 performance
We have upgraded from Online 5.06 to Dynamic Server 7.23.FC1 on OSF1 ver 4.0 and have major performance problems. Some applications now are up to 6 times slower. Applications also once in a while receives error -25587 and -25588. I've tried to increase LOCKS and BUFFERS, but th…
Re: LOCKS
Sahrul Hidayat wrote: > > Dear all, > > I have a question about LOCKS. > > If we configure LOCKS, let say 1.000.000, Online allocates about 40 MB of > resident shared memory for LOCKS. So, When locks active i.e 6 users (i.e > result of onstat -k), the allocated of shared memory s…
LOCKS
Dear all, I have a question about LOCKS. If we configure LOCKS, let say 1.000.000, Online allocates about 40 MB of resident shared memory for LOCKS. So, When locks active i.e 6 users (i.e result of onstat -k), the allocated of shared memory still 40 MB, even the limit of locks …
Re: Multiple residency - 7.2.3 and 9.1.4
In article <35D20971.5E4@bloomberg.net>, kagel@bloomberg.net wrote: > harikoduru@my-dejanews.com wrote: > > > > Hi all, Is it possible to have both ODS 723 and IDS/UDO 914 running on the > > same machine, sharing data and resources. I personally feel that it is not > > possib…
Re: Multiple residency - 7.2.3 and 9.1.4
harikoduru@my-dejanews.com wrote: > > Hi all, Is it possible to have both ODS 723 and IDS/UDO 914 running on the > same machine, sharing data and resources. I personally feel that it is not > possible because they are two completely different architectures right now > but I nee…
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 …
Re: Bad ESQL/C Memory Configuration
Jonathan Leffler <jleffler@earthlink.net> offerred: +Christian Kissner wrote: +> +> I have a problem allocating medium-sized memory when using ESQL-C. +> Actually, it happens after connecting to my Database: All the +> Memory I can get is just below 8MB ! +> +> [...] +> +> For I…
Re: Bad ESQL/C Memory Configuration
The only time I've seen memory problems is when doing multithreaded programming, in which case you may have to specify the attributes before creating the thread to increase the stack size beyond 1 MB. This shouldn't limit dynamicly allocated memory, though.. You should be able …
Re: Bad ESQL/C Memory Configuration
Christian Kissner wrote: > > I have a problem allocating medium-sized memory when using ESQL-C. > Actually, it happens after connecting to my Database: All the > Memory I can get is just below 8MB ! > > [...] > > For Information: > I'm running program and server on the same Machi…
Bad ESQL/C Memory Configuration
I have a problem allocating medium-sized memory when using ESQL-C. Actually, it happens after connecting to my Database: All the Memory I can get is just below 8MB ! Though this is a serious problem considering the amount of Data to be processed and the slowness of connections, …
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: onstat -g ses
The configuration file specifies the size of new segments(SHMADD) that'll be allocated in quantums for sessions. A session not necessarily uses up all of it, so you see the two pieces of info. For example, if SHMADD = 8192 (i.e. 8 KB at a time), and your session only used 3K of…
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[2]: sysmaster extents
This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable I have a couple of questions on this then=2E =20 I've got nothing set for DD_HASHSIZE or DD…
Re: Bad performance with DBSPACETMP enabled
Idiot wrote: > > > You have stumbled on a little known fact. Sorting is faster to > > filesystem space than to temp table space. And since you do not care > > about the safety of those sort-work files that's OK. > > > I am sure that you have tested this. Please excuse my ignora…
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…
-12 Out of Core SCO Kernel
Hello Informix Tech World .... We are having trouble configuring additional shared memory for OnLine. Environment: 5.01.UD2 OnLine on SCO 3.2.2 32MB Memory, 8MB of which is used by the kernel. We get a -12 Out of Core message when trying to increase BUFFERS to 7000. When we s…
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…
Re: Error -406 problem
i ve set INFORMIXDIR to "c:\\informix" where the software is installed and INFORMIXSERVER to "LOCAL" and checked it with "set". still no other reponse .. In <35209FF0.346FF3CD@earthlink.net>, Vijayakumar Bhavani <vbhavani@earthlink.net> writes: >Yes, it has nothing to do with me…
Re: Error -406 problem
Yes, it has nothing to do with memory. It is a configuration issue. Make sure that you set the env. variables like INFORMIXDIR, INFORMIXSERVER in the control panel\\system\\environment variables. Reboot the system. If it still doesn't work, set the same using informix utility s…
Re: Detaching Indexes
>To spread the workload on our drives, we have taken the approach of >detaching the index from our tables. Our indexes are on one set of >disks and the data is stored on another set of disks (ie, physically >separate disks). > >If some cases we have seen comparable results when …
Shared Memory Errot
I am currently migrating my informix 7.13 to new hardware I matched the configuration and I get the following error in my logs: shmat: [EMFILE][24] out of shared memory segments, check system SHMSEG mt_sh_init: can't create resident segment. The error caused by Unixware 2.…
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…
Re: 4GL Error 4502 = 1319
christian.winterhager@orbit.de wrote: > > Our customer has Online 4.1 and 4GL 4.12; if more then 10 - 12 Users > connect to the database, then this error 4502 (now 1319) comes. The > machine has SCO-Unix 3.2.4.2, 128MB Memory, and the shared memory of > OnLine is about 40MB. So w…
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…
More memory, or more processors
We are running a heavy-duty aplication under Informix OnLine 7.13 os a Sun Sparc 20 with 2 x 75MHz processors and 160M of physical memory. Budget has been set aside to purchase a hardware upgrade, viz an Ultra 4000. The specification was to have been 4x250Mhz processors and 1G o…
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…
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: Base address SHMBASE on Axil S/420
Look in the release notes. If what your trying to configure is online 5 or 7 then it will be in something like $INFORMIXDIR/release/ONLINE_7.1 or similar. You'll also find a lot of kernel parameters in here that I'd recommend you double check before you begin. Adam. PS. I hope…
Base address SHMBASE on Axil S/420
Hi folks We are in the process of configuring a S/420 to act as a restore environment to test our backups. The base shared memory address is different from a Sun box. Does anyone know what it might be? Much appreciated. rgds Peter Tashkoff <tashkop@zespri.co.nz> Zespri Internati…
Re: Help -- OnLine server refuses connections
With ur current configuration nugread are cached 95% (which is good) and bufwrits are cached only 37% (which is a bad omen). Couple of possibilities ... 1. it looks like a shared memory problem. Check BUFFERS size in onconfig file. Buffers should be fairly large to handle 30 co…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Pablo Sanchez wrote: > In article <3351f3b1.8299223@gate.idg.no>, Nils.Myklebust@idg.no writes: > > ichudov@algebra.com (Igor Chudov @ home) wrote: > > > > :I have been asked to do a comparison of captioned database engines, > > :to choose a database server for a medium size data…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <5ith88$14g@mew.corp.sgi.com>, Pablo Sanchez <pablo@mew.corp.sgi.com> writes >[ 1 - I've snipped, what I believe, were a whole bunch of unrelated > newsgroups from this note. I've left only the comp.database.* > > 2 - If you disagree with what I've written, let'…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
[ 1 - I've snipped, what I believe, were a whole bunch of unrelated newsgroups from this note. I've left only the comp.database.* 2 - If you disagree with what I've written, let's be constructive. ] In article <3351f3b1.8299223@gate.idg.no>, Nils.Myklebust@idg.no writ…
7.1 initialization error
Hi everyone, I have a client that runs 7.1 on a SCO box. When the nettype is set to a shared memory connection (onipcshm) 7.x will not initialize. However, when the nettype is tcpip (ontlitcp) everything works. Do you think this is a Informix configuration problem or a SCO ke…
Re: WWW.INFORMIX.COM - Nils, of course, right?
I just relize from reareading your post that you didn't actually complain about the server itself, but simply the graphics they display on the home page. I first read it as a complaint about their datablade techonology. I was far too fast, and appologize for my then more than un…
oninit: Fatal error in shared memory creation
What causes this error? # oninit oninit: Fatal error in shared memory creation I completed the recommended configuration on the Administration Manual Vol. 1. Are there any Step-by-step books or Video Tapes out for the Unix (Solaris) version of INFORMIX On-Line Workgroup Server…
Shared Virtual Memory Question/Engine Shutdown
Our project site recently received a binary executable from a sister site which updated approximately 5000 stored procedures. The executable brought down the engine due to shared memory limitations. When looking at the data (onconfig, memory on machine, etc. as stated below), t…
Re: sqlrmsoctcp
Bug is with shared memory configuration (onipcshm). TCP is absolutely fine. FYI I append the Informix Defect Report - and the problem is not specific to AIX, we had the same on HP-UX. (You can search defect reports at http://www.informix.com/ - it's a good place to look for probl…
Re: User Limitation?
In 5.x the number of users was inforced within the software. I'm unaware of any code in 7.1x which is inforcing this. True we removed the number of configured users, but that was because we started dynamically allocating the user table in the virtural shared memory segment, inst…
Re: Incredible paging on the system
Collalti, Fernando (Fernando.Collalti@orbit.net) wrote: ... > EXTRAC OF online.log (when the problem occurs) with the > BUFFERS set to 2000(before it was 200) > with the new configuration of BUFFERS=5000, CLEANERS=6, LRUS=12) > Wed Nov 6 08:22:44 1996 > 08:22:48 Onconfig pa…
Re: Shared Memory Not released
>Brian Li <cphdcbl@ted.cs.depaul.edu> wrote in article ><511nel$aft@shrike.depaul.edu>... >> >> Dear Informix experts, >> >> We are currently have Informix Dynamic Online running on our HP T500 >machine >> and recently have shared memory problem which is only known to be solved …
Re: Update Statistics Low, Medium & High
This is a multi-part message in MIME format. --------------5C6612934DBB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Clem Akins wrote: > > >In our system, we discover sometimes some tables in index searching is much > >faster while we update their …
Informix-CLI 5.0/5.01 "eats" memory
Hi all, we have a problem. Our configuration is Windows 3.1, Informix-CLI 5.01, LAN Workplace 5 (TCP/IP), ODBC shipping by Informix-CLI 5.01 and Borland Native Informix Driver. Every insert- or append-statement allocates memory. But this memory is never released, except of term…
Informix-CLI 5.01 "eats" memory
Hi all, we have a problem. Our configuration is Windows 3.1, Informix-CLI 5.01, LAN Workplace 5 (TCP/IP), ODBC shipping by Informix-CLI 5.01 and Borland Native Informix Driver. Every insert- or append-statement allocates memory. But this memory is never released, except of term…
Informix-CLI 5.0/5.01 "eats" memory
Hi all, we have a problem. Our configuration is Windows 3.1, Informix-CLI 5.01, LAN Workplace 5 (TCP/IP), ODBC shipping by Informix-CLI 5.01 and Borland Native Informix Driver. Every insert- or append-statement allocates memory. But this memory is never released, except of term…
Informix-CLI 5.0/5.01 "eats" memory
Hi all, we have a problem. Our configuration is Windows 3.1, Informix-CLI 5.01, LAN Workplace 5 (TCP/IP), ODBC shipping by Informix-CLI 5.01 and Borland Native Informix Driver. Every insert- or append-statement allocates memory. But this memory is never released, except of term…
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: OnLine 7.X performance - R U satisfied?
Are you taking full advantage of you physical memory? How does you caching ratios look (onstat -p)? If not in the 90's play arournd with BUFFERS and SHMVIRTSIZE. Also, is the engine frequently allocating additional shared memory segements? If so, this will impact performan…
How many instances .... ?
What might happen regarding performance degradation suppose if I have a 6 CPU machine with sufficient memory and running 4 Informix7.1 instances configured as follows: instance_one : 1 CPU VP instance_two : 1 CPU VP instance_three : 3 CPU VP instance_four : 5 CPU VP ? …
How many Instances .... ?
What might happen regarding performance degradation suppose if I have a 6 CPU machine with sufficient memory and running 4 Informix7.1 instances configured as follows: instance_one : 1 CPU VP instance_two : 1 CPUVP instance_three : 3 CPU VP instance_four : 5 CPU VP ? E…
Re: Informix 7.1 Online Performance Questions?
Ooops! I forgot to mention an important factor: The RS/AIX workstation I mentioned in the previous message (Compact Server C10) is configured with 128 MB of RAM, 50MB of which is used as a shared memory segment for use by Informix. Thanks again, Scott Miller Siemens Rolm Comm…
Re: A basic Online question
: I am trying to configure and start Informix-Online : I have set up the environment variables.. Allocated Disk space : as Unix files.. Prepared ONCONFIG andchanged it to match the : new server name.. ROOTPATH etc.. : I have also modified the sqlhosts.. : Now the question: …
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: INFORMIX-ONLINE 6 HELP
>I'm trying to follow the instructions in the Admin Guide Vol 1 >to 'Configure a Learning Environment' but keep getting the message >'Shared Memory not initialised for INFORMIXSERVER 'learn_online'. >I'm running SCO Unix on a 32M machine. >Any ideas ? Check to see whether your…
INFORMIX-ONLINE 6 HELP
I'm trying to follow the instructions in the Admin Guide Vol 1 to 'Configure a Learning Environment' but keep getting the message 'Shared Memory not initialised for INFORMIXSERVER 'learn_online'. I'm running SCO Unix on a 32M machine. Any ideas ? -- ----------------------------…
Re: DBMS Selection for 500+GB data and 500+ Users
msigler@informix.com (Mark Sigler) writes: > >Don't be sucked in to oversizing the hardware. Oracle will tell you that >the only way to scale that large is with an MPP system. Funny that I've >done it with Oracle on large SMP systems from Sun and outperformed MPP. >which causes …
PRESS VERSANT TO PROVIDE REPOSITORY FOR INFORMIX-NEWERA DEVELOPMENT TOOL
VERSANT TO PROVIDE REPOSITORY FOR INFORMIX-NEWERA DEVELOPMENT TOOL VERSANT ODBMS Selected to Provide Distributed Object Repository for Team Development Boston, MA (March 21, 1995) -- Versant Object Technology Corporation (Versant), the leading provider of object database manage…
Re: Keeping clean pages in shared memory
In article <3j7t1r$dbh@infmx.informix.com>, David Kosenko <davek@informix.com> wrote: > >Raj Gopalakrishna writes: >|> I am aware of the fact that flushed pages are not removed from the >|> cache but what I was trying to say that the effectiveness of the >cache is lost >|> for wr…
Need Info on INET for Unix
We have a UNIX client-server application with Informix running on the host computeraccessed via esql only, and a series of workstations on an ethernet currently caching data with a cheapo flat file DBMS called c-tree. This has led to a lot of special purpose distribution softwar…
Re: Increasing user limit
Fix the size of the shared memory segments in your kernel so that they can be up to 4 MB -- no larger, no smaller. Until you do that, you won't be able to configure OnLine with more than 1 MB of shared memory, because that is the largest contiguous chunk you can get. It's a com…
Re: Online and Shared memory
ywleung@ouray.denver.colorado.edu (YIU WAH LEUNG) writes: >I went into a theoretical discussion with my workmate on how Informix handles >shared memory that is defined by using tbmonitor/Parameter/Shared memory. >He said that the size of the shared memory that defined in Informi…
Database monitoring tools
I am interested in tools to monitor Oracle and Informix databases over time in a distributed UNIX environment. Desired features include: o Predict future resource consumption based on past usage over time, and report problems on an exception basis. For example: Based …
Re: SQL Precompilers (preoptimize!)
Path: emory!swrinde!elroy.jpl.nasa.gov!orchard.la.locus.com!prodnet.la.locus.com!jfr From: jfr@locus.com (Jon Rosen) Newsgroups: comp.databases.informix Message-ID: <1992Mar04.203112.01004902@locus.com> Date: 4 Mar 92 20:31:12 GMT References: <1992Mar4.160455.12513@rock.concert.n…