Oninit® Archive
Results for “NUMAIOVPS”
onload utility runtime performance issue
Hi We have a problem with the onload utility runtime. We performing a full database load with onload. (the db is ~800 GB). Currently the onload was executed more then 80 hours. I think there is a performance issue. How can I improve the runtime for the onload utility? Adding more…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Informix future...
ALL - Please vote the below ideas up Hi, If IBM are serious where are the following in Informix? DB2 has them and IBM has owned both code bases for over 20 years, what is the delay? Merge DB2 and Informix? Sure merge them on the Informix code base User level threading so less us…
DIRECT I/O (KAIO) Disabled in RHEL 9
Boycho: Just a note on your comment that "when I see more than 1 AIO VP I feel uncomfortable". Note that the AIO VPs handle all flat file IO that is not under DIRECT_IO. That includes: The message log The console log Audit files af file output SET EXPLAIN output and a handful of …
How many aio/KAIO
AMD has tried to answer the question of CPU selection for databases in this document: https://developer.amd.com/wp-content/resources/56949_1.0.pdf It's interesting that they focus just as much on how many sockets the server has and how many NUMA zones are configured. Ben. -------…
Informix NUMA shared memory access
Are there anyone running Informix on VMWare, and also on HP SuperDome Flex? Or any NUMA architecture at all? I'm interested in shared memory access patterns across the NUMA nodes. We are running an instance with approximately 400GB of shared memory on an HP SuperDome Flex, Intel …
Informix and Hyper-threading
This question does not have a simple answer. However, based on a lot of data from OLTP benchmarks performed on a variety of hardware, one recommendation can be given - use resources (CPU, memory) with maximum degree of affinity to run Informix. In which case enabling HT, SMT, CMT…
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…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
IDS 12.10 on HP-UX- DS Total Memory
Hi, Here our current memory configuration config for IDS 11.10 SHMVIRTSIZE 3000000 # initial virtual shared memory segment size SHMADD 1800000 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total…
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)…
Panic analysis
Folks, IDS 12.10 FC4, Linux 6. The following log is the only info we have about the crash ( no other info dumped ) You can see it was struggling to add lot memories segments before Panic .... The Panic was a also VERY curious one with some unexpected process terminated ... Wha…
Linux Processor x Informix 11.5FC5WE
Affinity is OFF by default, the aff= clause in your VPCLASS entry is turning it on and assigning all VPs to processor core #0. Just remove that entry. As far as how many VPs to use, my testing over the years shows that Informix can take advantage of about 450-500MHZ of processor…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Fatal error in ADM VP at mt.c:14100
Hi, We have faced issue on almost of all instances after giving following error . 00:47:24 Fatal error in ADM VP at mt.c:14100 00:47:24 Unexpected virtual processor termination, pid = 5482, exit = 0x9 Kindly guide us what cause this issue ? We are using IDS 11.50FC8W3…
Poor performance on VMWare
Turn off affinity. It only helps on Numa architecture machines and can hurt performance on most systems. Not your main problem I think, but ... Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in…
shmget ENOSPC Informix 11.70FC7 on Ubuntu 64 bit
Hello Art, thank you very very much for this valuable information/explanation! An 'onmode -F' after 'Low Memory Reconfig'(?) has added new virtual shared memory segments dynamically hardly frees memory resources and no segments are released again. I guess the new default VPCACHE…
Licensing : VPU needed ?
The calculation of the VPU depends on the processor, the IBM computer can be found here: https://www-112.ibm.com/software/howtobuy/passportadvantage/valueunitcalculator/ vucalc.wss To understand the sub-capacity licensing, you can look at these two sites: http://www-01.ibm.com/so…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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.…
a problem with backup a logical logs
Hello, Yesterday I have a problem with the backup the logical logs and I attached the information that I got from Informix: Can anyone help me to find the problem in order to void this in the future? Any help will be welcome Regards Muthana Here is the information I get from …
Informix on Linux on VMWare
Keith Simmons wrote: > Hi > > It looks like I am going to have to migrate an IDS instance from Solaris > to Linux. > Current machine is a 16Gb dual chip SPARC T5120 with twin path, fibre > attached disk (Raid 1) running IDS 11.5 on Solaris 5.10. > Target machine is likely to be s…
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,…
Efficiency of the Informix Virtual Processors
Dear All, IDS 11.50.FC8W2 on Hp-UX 11.23 (12 core - 55 GB mem to informix) No other instance running on this machine. I was reading a post by john on http://www.jfmiii.com/informix/?p=194 It say that if the efficiency drops below 80% (onstat -g glo output) then there seems to …
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
VPCLASS cpu on sun/oracle M4000 machine
Hello, I have an IDS 11.50.FC6 instance on an M4000 oracle server with 4 CPUs with 4 cores * 2 threads each. The OS (Solaris 10) 'sees' a total of 32 CPUs. The thing is, I'm trying to tune the cpu VPCLASS onconfig parameter so that this instance is able to use more CPU power, but…
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.…
Is KAIO in use
Hi, I'm running an informix 94FC09 engine on an AIX box using KAIO. I launched the engine after setting the following OS parameters KAIOOFF=0 and IFMX_AIOKAIO_NUM_REQ=12288, knowing NUMAIOVPS is set to 2, and the OS AIOs configuration is Min number server=10, Max number server =…
Fatal error in ADM VP at mt.c
I've the following messages in online.log of an 9.40.FC9 informix dataserver : 17:52:55 Fatal error in ADM VP at mt.c:12703 17:52:55 Unexpected virtual processor termination, pid = 1466506, exit = 0x90009 17:52:55 invoke_alarm(): /bin/sh -c '/bases/informix/pcampcam/admin/ontap…
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…
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…
optimum usage of resources
One more thing : In the IDS 9.4 documentation I find that NUMAIOVPS (and other parameters) have been replaced with VPCLASS parameter.…
Initialization of Java virtual processor failed
when trying to install a java udr i'm getting the following nessage: 9444: Initialization of Java virtual processor failed: (cannot create gc file) Can anyone help? Here is the statment: execute procedure install_jar( "file:$INFORMIXDIR/extend/krakatoa/examples/Env.jar", "env_…
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…
Tunning CPU VPS and Processor Affinity
Ignore the hyper threads and configure for the 8 physical cores. On a 2.9GHZ Xeon processor, I would not configure more than 3-4 CPU VPs per core on a dedicated IDS server machine. Less if you will be sharing the machine with client applications or other software depending on the…
Seeing one oninit working hard while others are no
I think we are running into a condition where only one virtual processor is trying to do a majority of the work on a remote server via synonyms. When you look at all the oninit modules running on the remote server, it looks like only one is really taxed: ps -ef |grep oninit hd…
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…
Odd Performance
IDS 10.00.UC8 Solaris 10 I am playing with our new Solaris server - I just increased the VPCLASS parameter to VPCLASS cpu,num=32,aff=64-95,noage from cpu,num=5,aff=13-21,noage. Our new server has 132 virtual processors available: uname -X NumCPU = 128 psrinfo -pv The physical…
large number of sessions with Y flag
Actually it looks very good. It shows all threads waiting for users to enter requests, nothing really blocked on any server resource. no contention. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own op…
Long Spins
Hi, The IBM IDS document says: "To reduce longspins, reduce the number of virtual processors, reduce the load on the computer, or, on some platforms, use the no-age or processor affinity features." But wait for other to advice you, I'm sure the IDS guru's will suggest you a so…
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…
IDS 7.31 Solaris8 - Long Checkpoints
To shorten checkpoints in version 7.31 you should 1) increase the checpoint interval to 500sec (you don't want the interval to ever force the checkpoint) 2) lower the lru_max_dirty to 2 3) lower the lru_min_dirty to 1 Try this out. I assume you are using KAIO and that is why …
Re: MSC virtual-processor class too loaded aft....
Hi, first of all, thank you very much John and Jacques for your answers. The IDS engine allocated another vp msc (I supose due to the high load of the first one). I have tried without success (at the moment) to catch operations that msc vp is doing with the following command: …
MSC virtual-processor class too loaded after migra
Hi, After migration our DWH from IDS 10FC9 to IDS 11.5FC3 (Under SLES 10 SP2) I found that msc vp class (Miscelaneous System Call) are too loaded, as you can see in the following onstats: Can anybody tell me the reason, or can point me to the correct documentation to understand…
AIO VP has more load then KAIO
hi all, I have only raw chunks on HP-UX, but AIO VP has load more then KAIO. Why ? Do you have someone any ideas. thaks Petr Pomykacek IBM Informix Dynamic Server Version 11.50.FC3 -- On-Line -- Up 3 days 14:30:41 -- 1694836 Kbytes AIO I/O vps: class/vp s io/s totalops dskre…
Lies, Damn Lies and Statistics...
On Jan 27, 9:37 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Not to bust Liam's bubble, > > But what happens when you have two different threads from the same > parent trying to run at the same time on different CPUs? > > Me thinks that there's more spin and double talk …
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…
Re: IDS 11.5 licence question: virtual versus physical processors ?
Martin Thole wrote: > We are planning to migrate our database server to a VMware server. > The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 > cores), > but the (virtual) Linux-OS will only use 2 (virtual) cpu cores. > > How many processor licences are neces…
Re: IDS 11.5 licence question: virtual versus physical processors ?
"Martin Thole" <mth@o-b-s.de> wrote in message news:48e3667f$0$6617$9b4e6d93@newsspool3.arcor-online.net... > We are planning to migrate our database server to a VMware server. > The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 > cores), > but the (virtual)…
IDS 11.5 licence question: virtual versus physical processors ?
We are planning to migrate our database server to a VMware server. The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 cores), but the (virtual) Linux-OS will only use 2 (virtual) cpu cores. How many processor licences are necessary ? Which database editons (…
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…
Hardware advice please
Hi all, I am looking for advice on what servers to buy to replace our existing informix db servers. We have to replace them, because they are dinosaurs and could pack up at any moment. Unfortunately I don't really have any idea what would be good to get as I've never been involve…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Analysis of activities during checkpoint.
Hi Vartika, Please check this link. You can add but not drop virtual processors of the AIO, PIO, LIO, TLI, SHM, SOC, and STR classes. http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ad ref.doc/adref308.htm Thanks.. Amitava E - id : amitacha@in.ibm…
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.…
oninit process of IDS 11.5
Thank you very much. Almost of vp are aio. I changed it to 2. It's ok now.…
NUMAIOVPS and KAIOON
Greeting all, My understanding is in IDS 10, System Admin guide recommends NUMAIOVPS = 2 * No of Chunks or 6 whichever is greater. Questions: 1. Is it also valid for IDS 9.40.FC4? 2. Is it also valid if KAIOON is enable? Is there any overhead in terms of server performance if …
Re: how much cpu does Informix use
Art S. Kagel (Oninit) wrote: > Floyd Wellershaus wrote: [cutting] >> >> First question: Am I correct that only the cpuvps are directly tied to >> the physical cpus? Or do I need to be counting all of the vps ? > > That depends. If you are using a version before 9.40 (don't rem…
Informix database virtualization
Hi, I saw one running on XEN Linux. The VM was running in paravirtualization mode.The usual OS-dependent functionality was OK: no age, processor affinity, raw devices, direct I/O. It did not have UDRs and datablades. Performance was about the same as running IDS in the domain0 (…
CPU-VP issue
Straight from the doc: "On a single-processor computer, allocate only one CPU virtual processor. On a multiprocessor computer, do not allocate more CPU and user-defined virtual processors, combined, than there are CPUs on the computer." Mike…
Re: informix 9.3 to 9.4 issue
<snip >>>RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) RESIDENT 1 >>>NOAGE 0 # Process aging NOAGE 1 >>>NUMAIOVPS 2 # Number of IO vps Using KAIO?? or AIO?? If using AIO, may need to increase NUMAIOVPs to "number of…
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…
IDS 10.0
Hi, While setting up a test environment, a question concerning the correct setting for NUMCPUVPS popped up. We have a Hitachi SAN with fifty-seven 52 GB chunks allocated to this instance. Memory is 8 GB $ uname -X System = SunOS Node = test_1 Release = 5.10 KernelID = Generic_…
CPU Help
First, thanks for your time here. You're right it is confusing. I ran topas and noticed (Online Virtual CPUs: 8, Online Logical CPUs: 16) Does that mean 16 physical cpus? I have 167x4gb dbspaces. Your suggestion then would be: VPCLASS cpu,num=15,aff=1-15,noage VPCLASS aio,num=16…
Re: long checkpoints
On Nov 21, 10:23 pm, TBP <TheBigPot...@NotHere.Co.Uk> wrote: > Art S. Kagel wrote: > > On Nov 21, 8:46 am, Apostrof <abdullah.ako...@gmail.com> wrote: > > <Previous post SNIPPED> > >> Hi Art, > > > Hi, > > > Your server's healthy overall. Metrics look good: > > > BR = 3.68 > > B…
Physical Processor to Virtual processor mapping.
Hello Everyone, We had recently retired one of the cluster nodes and are running the two Informix instances in the same node. We have also added additional CPUs to this node. Solaris version 9 IDS version 9.40 FC4 mpstat CPU minf mjf xcal intr ithr csw icsw migr smtx srw sys…
NOAGE Depreciated
NOAGE isn't deprecated completely, it's just been subsumed along with NUMCPUVPS, NUMAIOVPS, AFF_SPROC, and AFF_NPROCS parameters into the new VPCLASS. So instead of setting: NUMCPUVPS 10 NOAGE 1 AFF_NPROCS 10 AFF_SPROC 2 You would set: VPCLASS cpu,num=10,aff=2-11,noage Art S.…
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: Slow database creation and loading
On Jun 11, 3:07 am, Superboer <superbo...@t-online.de> wrote: Hi Superboer, Thanks for the reply. > You should be able to speed this up. > > > I have been told that we have 4 GB of memory on this box. > > BUFFERS 75000 # Maximum number of shared buffers > > 4 …
Re: Slow database creation and loading
> Free=13177086K Used=10205524K Full=43.65% > > Is this 10 plus hour time the best we can do or can we speed this up > somehow? If we can speed this up please guide me as I am not a DBA > and we do not have a DBA on staff. You should be able to speed this up. > I have been …
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Mapping cpuvp's to IBM virtual processors ....
On Thu, 2007-02-22 at 17:27 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > For soctcp use 1 or 2 NET VPs (a net VP should handle over 200 connections > efficiently but I like to keep that below ~150 myself). I added 2. > > #LRUs controls contention between users. In order to re…
Re: Mapping cpuvp's to IBM virtual processors on p
Your assumption is partially correct. You don't NEED all 6 CPU's allocated to CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions to CPU VPs as needed so it's possible that one or a few logical CPUS will be harder hit than the others. That said there are tuna…
Mapping cpuvp's to IBM virtual processors on pSeri
We're currently running a read-only instance of IDS 10.0FC6 on AIX 5.3 TL-05. The logical partition (LPAR) hosting IDS has 2.4 physical CPU's, divided into 6 logical CPU's. Running nmon's cpu monitor shows CPU 0 at about 50% used, CPU1 used occasionally, and CPU 2-5 are idle. I'm…
VP error
IDS 9.4 error in log file. Database restarted and no errors reported. Any ideas on the seriousness of this error? 23:31:18 Fatal error in ADM VP at mt.c:12243 23:31:18 Unexpected virtual processor termination, pid = 499808, exit = 0x90009 23:31:19 invoke_alarm(): /bin/sh -c '/ho…
number of flush_sub
Run the following query, select th_id, th_name from sysmaster:systhreads you got result( see below) My question is who( where) does control the initail number of flush_sub threads when you oninit the server? (IDS10 UC5) Thanks, Frank th_id th_name 2 lio vp 0 3 pio vp 0 4…
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…
NUMAIOVPS/VPCLASS
Apologies for asking this question but I've searched through the CDI archive and can't find it. Recently I read something about a config parameter (possibly undocumented) to do with an AIO setting when using cooked files instead of raw chunks. I though I read it on this forum bu…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
RE: IDS 10.0 performance on RedHat
Neil, I think, that both data load (into unindexed table) and index build (which is actually a sequential scan from I/O standpoint) are more hungry for latency, then for parallelizm. Also, it is quite clear, why increasing number of CPU VP's impoves KAIO performance: IDS direct…
RE: IDS 10.0 performance on RedHat
>> My observation is that for parallel load, Informix AIO gives up to 100% better throughput (I don't use term 'performance' here!), then AIO. Just allocate as many AIO VP's, as you need (30+)! Unless I'm mis-understanding you, your results are not similar to mine. With low numb…
RE: HDR problem with Windows
Guy Bowerman wrote: > Some minor comments: > > ROOTPATH D:\\IFMXDATA\\ol_server1\\rootdbs_dat.000 > > You've moved the root dbspace to D:\\IFMXDATA\\ol_server1 on ol_server2 as > well right? Yes, the directory name is the same on both servers. That is to say server2 has a ol…
Re: VP memory cache (was IFX_FOLDVIEW)
Guy . wrote: > > What is this "Virtual Processor Memory Cache"?? > > This feature is fallout from Informix revisting the world of benchmarks, as is the other xC5 feature, Fastpoll. > Well IDS 10.00.xC5 is out now. And the release notes do not mention (even though this was menti…
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/…
Onstat -g sts
Hello all, I have this problem : 01:08:38 Found during mt_shm_free 4 01:08:38 Pool 'sscpool3' (0x7000000e0e22040) 01:08:38 Bad block header 0x7000000f7fd1000 blk-64 07000000f7fd0fc0: 00000000 00000000 00000000 00000000 ........ ........ 07000000f7fd0fd0: 00000000 00000000 0…
HP-UX KAIOON
Alex wrote: > I try to run Informix with async. kernel io on a HP Itanium 4 Processor ... > onconfig entry: > VPCLASS kio,num=2,noage > > > BUT, after initializing with oninit there is obviously no usage of the > kernel async driver. > > > The command output of "onmode -p…
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!…
onstat -g iog
You won't see 2 even though you think you have only 2. You would see 6 aio classes if you didn't add one dynamically. I believe some of the threads are using the AIO class of virtual processors which can be broken down as: aio because NUMAIOVPS =1 (in your onconfig) adm (administ…
Re: cannot start with 4 AIO virtual processor
On Windows platforms IDS is KAIO only, hence in most cases there is no need for more than 1 AIO VP. In IDS versions prior to 9.30.TC6 this limit was enforced and an error was generated when a higher value was used. With KAIO systems the AIO VP is still used for some tasks such …
Re: cannot start with 4 AIO virtual processor
informix can only be run with 1 aio vp under windows. Any other value results in the server being started with 1. Unless 9.40 and 10.x are different (haven't checked)? Regards Stefan ********************************************************************** This email and any fil…
IDS and Sun
No but do you have one going spare I can play on? I would be aware of the limitations of Hyperthreaded Processors and IDS that I vaguely remember someone posting here. Database are about data movement (including into/out of the CPU package). Perhaps ensuring CPU VPS are spread…
Re: cannot start with 4 AIO virtual processor
BTW, i forgot to tell... the ontape failed and, although, it can be a tape's problem we can cover all posible aspects... we have 4 cpu and 3 of them are assigned to informix and 4gb in ram with 131072 buffers...…
Re: cannot start with 4 AIO virtual processor
"Jaime Casanova" <systemguards@gmail.com> wrote in message news:1137432864.044113.214560@g43g2000cwa.googlegroups.com... > Hi, > > OS: NT4 > IDS 9.21 > > Last saturday i was trying to make a level 0 backup so i execute: > ontape -s -L 0 > > And it gives me this message: > > Warni…
cannot start with 4 AIO virtual processor
Hi, OS: NT4 IDS 9.21 Last saturday i was trying to make a level 0 backup so i execute: ontape -s -L 0 And it gives me this message: Warning: Dynamic Sever 2000 cannot start with 4 AIO virtual processor, limit exceeded. Started with 1 AIO virtual processor. I didn't configure…
RE: MULTIPROCESSOR settings on a multiple CPU server with
>MULTIPROCESSOR Specifies that you are running on a multiprocessor computer I was getting tripped up on: Running on a Multiprocessor Computer If you are running multiple CPU virtual processors on a multiprocessor computer, set the MULTIPROCESSOR parameter in the ONCONFIG file t…
Re: informix market share
On 2005-11-30, Mark Townsend <markbtownsend@comcast.net> wrote: > Serge Rielau wrote: >> >> *chuckle*And there always will be because SMP scales better than RAC >> (more CPUs needed) > > Not necessarily - as people move of their older SMPs they can find that > the new CPUs in the…
FW: Informix versus Oracle Spatial
This is awesome work. I think it touches on some very salient points, especially regarding virtual processors and threading. It is amazing that Oracle technology could have gone so wrong despite the amount of money they have as a company, and how they could not come up with a b…
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.…
Re: IDS 10 erratic run times
fromthe online manual Kernel-Asynchronous I/O The database server uses KAIO when the following conditions exist: The computer and operating system support it. A performance gain is realized. The I/O is to raw disk space. Block special devices are still raw devices so we should…
Crash of the instance
Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…
Posting from the Informix-list
Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…
Re: No future for DB2
Noons wrote: > Data Goob wrote: > >>flames. They opted to buy the racing team with their marketing budget, instead >>of promoting any of their products. The racing team really helped get the > > > Oh puh-leaze: the ONLY reason IBM bought Informix > was that it was a cheap way …
Re: No future for DB2
Colin Dawson said: > > They also wanted the technology - it saved them writing it. Same reason > why > they bought Sequent - the NUMA-Q architecture was cheaper to buy than > develop it internally. Really? I heard from an IBMer recently that by the time IBM decided to do anythin…
Re: No future for DB2
They also wanted the technology - it saved them writing it. Same reason why they bought Sequent - the NUMA-Q architecture was cheaper to buy than develop it internally. Regards Colin There are 10 types of people in the world, those that understand binary and those that don't …
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: ONCONFIG - comments
"Juan Pablo" <in4mixperu@hotmail.com> wrote in message news:1120173312.07d6de6c2486de67e3cad47cd40e6341@teranews... > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ====================…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
ONCONFIG comments
Should have qualified my comment on rootoffset. I assumed you are using KAIO and raw disk because your NUMAIOVPS is so small - in this case rootoffset is important. Especially since the first 13 pages of rootdbs are the crucial pages. If, on the other hand, your are using AIO (in…
ONCONFIG comments
"Bono Vox" <in4mixperu@hotmail.com> wrote in message news:1115714331.fe81cde2ee8f8402d2a791d65e041327@teranews... > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks See embedded comments …
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…
More CPUVPs than processors
Mark wrote: I've always found that for any CPU faster than about 400MHZ (~600 for x86 CPUS) you can run at least 2 CPU VPs per CPU. Now that CPUS are MUCH faster and multi-pipelined and multi-virtual CPU's, you can likely make that 3 or 4 or 5 times # physical CPUs. I think th…
Could not fork a virtual processor: errno = 12
Hello The past week I had a problem with a memory bank of my SUN450 with solaris 8 The problem is already fixed, but I try to rebuilt a secondary instance with HDR y it is no possible, the steps are the same i had used alltimes: onstape -s -L 0 in the primary server in stanard …
Re: Informix UC7.41 - slow
TBP wrote: > > Well, I don't think that running onstat -z and then doing 2 exports will > provide statistics which are relevant to your "normal running" - > perhaps do an onstat -z, let it run for a day(??), and then post the output. > > It is good that you re-posted your oncon…
DB-Crash
Hi Everyone, IDS: Version 9.30.UC2X7 SuSe Linux 2.4.21 We received the following error messages in our log file: 12:26:42 Logical Log 11992 Complete. 12:26:44 Logical Log 11992 - Backup Started 12:26:44 Logical Log 11992 - Backup Completed 12:26:45 Fatal error in ADM VP at…
IDS 9.40 UC5/linux update statistics crashes engine on large table
I have an interesting update.. this is the original statement created by dostats which crashes the engine: UPDATE STATISTICS MEDIUM FOR TABLE big_table DISTRIBUTIONS ONLY; I played with the following changes and they all ran for a while without error or engine crashing(there ha…
Re: Performance Issues
[cutting] > > NUMAIOVPS 6 # Number of IO vps > > Then monitor onstat -g iov. If there are more than one AIO VP with an > io/wup column value less than 1.0 you can drop some. If there are NO > AIO VPs with io/wup less than 1.0 you need to add more. Add two a…
CPU Binding
Hello Everyone, I just wanted to clarify how does IDS determine the number of processors a UNIX box have? Our new server(Sun Fire E6900) uses the UltraSPARC IV processor, which is using the Chip Multithreading(CMT) technology. Through CMT, 20 additional virtual processors are sp…
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'?…
FW: RE: Informix IDS query to the Informix -list
Fwd from sputnik� ________________________________________ From: None [mailto:myinformix@rediffmail.com] Sent: Tuesday, September 14, 2004 02:08 To: Jean Georges Perrin Subject: Re: RE: Informix IDS query to the Informix -list � Hi Jean, Thank you for your prompt reply. If you…
How many physical processors we need to support 32K THREADS in IDS.
Hi Team, Informix IDS supports upto 32K threads according to most IDS realease notes. My question is What sort of a machine you are looking at to support this many threads?? This came to my mind when considering max. num of threads(or connections that matter) that each CPU or NE…
Re: Why there is no controlfile in Informix like Oracle ?
Daniel Morgan wrote: > Obnoxio The Clown wrote: > >> Daniel Morgan said: >> >>> Obnoxio The Clown wrote: >>> >>> >>>> Mark Townsend said: >>>> >>>> >>>> >>>>>> On the other hand, Oracle did not have such excellent tools for data >>>>>> management and manipulation as external enti…
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: Informix Tuning Problem
"Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message news:10hn3hctpj28u45@corp.supernews.com... > Andy Leung wrote: > > Based on what you have put above, I would say NUMAIOVPS is very low > indeed (suggest 20-30) .... How can you say that without knowing if he is using k…
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: IDS9.4/AIX5.2 performace degradation
Ups, sorry.. here it is ***ONSTAT -g iov*** IBM Informix Dynamic Server Version 9.40.FC4 -- On-Line -- Up 06:16:20 -- 943248 Kbytes AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors kio 0 i 125.3 21921 21000 921 …
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: ONCONFIG for 9.40 offered for comment
"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:pan.2004.06.16.17.04.12.773451.9956@bloomberg.net... > On Wed, 16 Jun 2004 13:29:21 -0400, Neil Truby wrote: > > From these lines I'd say you would be able to utilize NUMAIOVPS set to 10 or > 12. These values indicate th…
ONCONFIG for 9.40 offered for comment
On Wed, 16 Jun 2004 01:01:12 -0400, Neil Truby wrote: Neil, I'd recommend the following: > 9.40 FC3W2 on HP-UX 11.11 > The server has 6 cpus and 6G of RAM. > 3 other, small, IDS 9.40 instances run on the server, and one small 7.31. > kaio is enabled. > > Just put 9.40 live, and…
Re: OnConfig parameters tuning
"Laverio" <laverioNO@z-1000.net> wrote in message news:cac7sg$e8v$1@newsreader.mailgate.org... > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in…
Re: database market share 2003
Serge Rielau <srielau@ca.eye-be-em.com> wrote in message news:<ca28br$jr3$1@hanover.torolab.ibm.com>... <snip> > I quote from Blair's post, and yours (appended): > > DB2 is the same code base on all versions of Windows (95 through 2000), AIX, > Solaris, HP-UX, NUMA-Q and OS/2. T…
Re: NUMAIOVPS setting
"Art S. Kagel" <kagel@bloomberg.net> schrieb: >NO, io/wup can indeed fall below 1.0 if you are configured correctly, and I >DO indeed mean you shoule monitor io/wup. If you are showing io/wup 1.0 or >above for all aio VPs then you will improve performance (EVEN if all of your …
Re: NUMAIOVPS setting
On Tue, 25 May 2004 08:51:20 -0400, Reinhard Habichtsberg wrote: > Art S. Kagel wrote: >> Once you have a running system, run onstat -g iov, as Madison suggests. If >> there are a few aio VPs with io/wkup less than 1.0 then you are OK. If >> there are many such you can reduce …
Re: database market share 2003
Everything is up for grabs Daniel, that's what newsgroups are all about. If you understand the Informix world, you'll understand my statement, especially in the context of the Informix newsgroup. Informix people have had several servers to choose from over the years, but no one…
Re: NUMAIOVPS setting
On Mon, 24 May 2004 10:47:48 -0400, Bent_Andy wrote: Here's the deal. The rule-of-thumb I gave is just that a rule for determining a starting point. Once you have a running system, run onstat -g iov, as Madison suggests. If there are a few aio VPs with io/wkup less than 1.0 t…
Re: NUMAIOVPS setting
Hi Andy, The best way I've come up with getting an overall feel for how many is needed, is to combine the Informix 'onstat -g glo' information with that of the operating system 'ps -ef'. Here are two scripts you can use as examples... <-------- vpscheck1.sh script --------> #!…
NUMAIOVPS setting
HP-UX 11.11 - 7.31.fd5 - Baan IVc4 (OLTP) I have a question about numaiovps. Our current setting is 52 and we have 68 chunks. Notes from a performance class say if onstat -g ioq shows maxlen > 25 then time to add more aiovps. The system is not slow, I am only looking to impro…
Re: Straw Poll
Wow, thats harsh - especially considering the expense of the numa platform, I came close to trying NUMA a few years ago myself. I am surprized that the UC versions of IDS will not run on it though, has the NUMA OS diverged so far from unix? If I were you I would call my IBM part…
Re: Unexpected Virtual Processor Termination - HELP!
On Tue, 18 May 2004 08:13:07 -0400, Joel wrote: Bounce both engines. Remote synonyms are usually more trouble than they are worth. Could be better to use ER to replicate the needed data on the other server in a separate local database and access it from there. Art S. Kagel >…
Unexpected Virtual Processor Termination - HELP!
We have two SCO-Unix servers, one runs our order entry and acct software, the other runs the warehouse/inventory control software. Each server has an Informix DB, IDS version 7.30 UC2. The inventory control DB uses synonyms to provide access to data in the order entry DB, and vi…
RE: Straw Poll
As you were !! I have just been pointed to UD7 on the PA site and am in the process of downloading 173Mb. I am happy again!! Keith -> -----Original Message----- -> From: Simmons, Keith -> Sent: Tuesday, May 18, 2004 8:55 AM -> To: informix-list@iiug.org -> Subject: Straw Poll …
Straw Poll
All I have a problem in that current maintenance releases of 7.31 (later than UD5) are not being ported to IBM/Sequent NUMA-Q hardware running Dynix. This is beginning to be a problem as I need a bug fix in UD7 and don't really want to go onto a patched version. As the hardware …
Setting up JVM on 9.30HC5, HP-UX 11i
Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html ) and compiled the examples (in extend/krak…
Setting up JVM on IDS 9.30HC5, HP-UX 11i
Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html) and compiled the examples (in extend/kraka…
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.…
RE: Long checkpoints on AIX/IDS7.31/IBM Shark
Thank you TBP, Dave & Alex for you suggestions, I have duly increased my LRUS to 128, and CLEANERS & NUMAIOVPS after looking at onstat -g iov and checking the io/wup column. We've found the culprit which affects all hosts connected to the same Shark (and there are quite a few) …
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: oninit process
Hi Ray. IIRC,If NUMAIOVPS is null, oninit will depend number of chunks. If you use raw device, specify NUMAIOVPS 2 or 3. Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: raywsl@hotmail.com (Ray Walsh) >Reply-To: raywsl@hotmail.com (Ray Walsh) >To: informix-…
oninit process
They are from a variety of things: - CPU VP's - AIO VP's - TLI VP's - LIO VP's - PIO VP's - Misc. VP's You can do on onstat -g glo to see which type of VP is mapped to a Unix pid. "Ray Walsh" <raywsl@hotmail.com> wrote in message news:15aa6f7d.0404090611.ecf9044@posting.google…
Do I need more KIO's
you've got 2 kio 'cos you've got two cpus, I suspect that NUMAIO is one and the rest of the aio tally across to the gfd, I'd expect onstat -g iof to show the path to the various chunks. I think this looks fine. Fire out your ONCONFIG file, onstat -R, onstat -p, onstat -F, onsta…
RE: Virtual Processors and CPU-Load
Markus, With 2 Xeon (multithreading) CPU's it really makes sense to allocate 4 CPU VP's (not 2 as You did) to use CPU power more efficiently. The other thing to investigate is the 'BUFREADS by partition' statistics. Please, pay very close attention to those tables and indexes t…
RE: Virtual Processors and CPU-Load
Dont post MIME Have you run the correct update stats? In Informix monitor users -- onstat -u the ready queue -- onstat -g rea the sqls -- onstat -g ses {session number} You need to determine which sessions or parts of the application are causing the load. With 200 users you…
Virtual Processors and CPU-Load
Hi all, we are a little bit confused concerning the CPU-Load of our Informix-Database-Server. (9.4 UC3, RH9 2.4.20) We use a 2-Xeon (3.0 GHZ)-Dell-Server and both CPU's are mostly at 99.9%! All tables and indexes (DBSpaces, Extents, ...) are optimized to the best of our knowledg…
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: long checkpoint problem
Looking at your stats: Alex V. Spirin wrote: > andykent.bristol@virgin.net (Andy Kent) wrote in message news:<a3525a11.0401290307.42f6e997@posting.google.com>... > >>It's quite plausible that page cleaning would lag behind buffer writes >>during a bulk load. Disk i/o is obvious…
Re: RES: Pentium 4 hyperthreading
Linux has support, IDS does not care whether the CPU is physical or a hyperthreaded virtual CPU. It will use it if you tell it to. Art S. Kagel Julio Cesar wrote: > Speaking on Affinity Processors, does anyone know if the IDS 9.40 has > support for this feature on Linux? > AF…
RE: These crazy emails about IDS to DB2 conversion
Man, I hope IBM is following this thread ... -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Obnoxio The Clown Sent: Thursday, February 05, 2004 6:58 PM To: informix-list@iiug.org Subject: Re: These crazy email…
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…
Re: These crazy emails about IDS to DB2 conversion
Malc P wrote: > Malcolm W more or less hit the nail on the head. If he did, then why are you asking questions about IBM's IDS strategy? :o) > My input to this is, I'm an Informix DBA and I'd rather not have to > learn how to DBA another vendor's offering. This statement may or…
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…
Affinity in IDS 2000 under Windows Server 2000
Please, I need some help about an issue: I have a machine with 2 processors and a IDS 2000 installed on it. But I need to share the processing of Informix over 2 processors. But all the time that I change the MULTIPROCESSOR, NUMCPUVPS, SINGLE_CPU_VP, NOAGE, AFF_SPROC, AFF_NPROC…
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…
Reduce # of CPU: license cost
IDS 7.3 Customer is looking into possibility to reduce the no of CPU that is running in database server. Reason: cost saving since current charges for Informix license is based on CPU. Question: How to do that without physically removing the CPU ? Can that be done by reducing t…
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…
Unexpected virtual processor termination
Please help me for resolution of an Informix Error : 17:06:14 mt.c, line 10188, thread 9, proc id 8335, Unexpected virtual processor termination, pid = 8336, exit = 0x9 . 17:06:14 Assert Failed: Unexpected virtual processor termination, pid = 8336, exit = 0x9 17:06:14 Who: Sess…
Re: Puzzling performance issue?
Andy Kent wrote: >>High values (i.e. over 256) give high CPU usage > > > How so? > > Andy 'cos kaio (or the aio vp) will be hammered when jumping ahead 512k (or 1 Mb on a 4k system) at a time. Perhaps I should have phrased it "higher CPU usage" - everything is relative.…
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?…
Re: Puzzling performance issue?
Eric wrote: > First of all, thanks for the drops! The comp.databases.informix group > has given several noteworthy replies... Normally I tune by the book > (Informix) yet with this system it was seemingly a negative impact. > My second set of attempts were to see if I could alle…
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.…
Engine's re-setting
Hi, dsolalinde, You must to change the relative to the point in server you updated. The BUFFERS parameter can be bigger than before. I dont know how much BUFFERS you have but you can increment more memory to this parameter. Did it based in the LRU size, and its near to BUFFERS /…
RE: 4GL Connectivity
Thanks Guys, Installed CSDK, bit of configuring and all is now fine, I can see the engine from the app server with just 4GL and CSDK installed. Keith -> -----Original Message----- -> From: Mark D. Stock [mailto:mdstock@MydasSolutions.com] -> Sent: Friday, August 29, 2003 2:46 …
Re: 4GL Connectivity
Simmons, Keith wrote: > All > > I am wanting to migrate an application (R4GL 7.20 UD7) from my main database > (Sequent NUMA-Q2000 Dynix/pts 4.4.10, IDS7.31 UD5) server to a subsidiary > application server (Sun E250 Solaris 8). This application server does not > have IDS instal…
4GL Connectivity
All I am wanting to migrate an application (R4GL 7.20 UD7) from my main database (Sequent NUMA-Q2000 Dynix/pts 4.4.10, IDS7.31 UD5) server to a subsidiary application server (Sun E250 Solaris 8). This application server does not have IDS installed nor do I wish to install an en…
Replication traffic on the network has spiked up !!!
HDR or ER? How are you able to monitor replication traffic? M.P. "Jack A" <hrehal@yahoo.com> wrote in message news:5eef134e5c079abca0ea83d4dc748474@free.teranews.com... > Running Informix Dynamic Server 2000 Version 9.21.UC5 on SunOS 5.8. Last > week we changed the following …
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???…
RE: TBLSPACE_STATS
Hi, In the machine notes for ids 9 I find the next text: "16. In this release, partition profiling can be disabled by setting a new configuration parameter, TBLSPACE_STATS, to 0 in the onconfig file. When TBLSPACE_STATS is set to 0, the output of onstat -g ppf will …
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…
Shared mem connections and semaphores
HeadingDescriptionFormatvpThe virtual processor ID.DecpidThe system process ID for the process running this virtual processor.DecclassThe class of virtual processor.StrsemopsThe number of times this virtual procesor went idle and performed a semaphore operation to wait for work.D…
raw disk to cooked files
Due to some reasons our sysadmin is forcing us to use cooked files on one of our training box. Since performance is not critical, I am ok with it. However I find the performance quite disappointing, close to unacceptable. What should I do to tune? I did not do any change in the …
balancing virtual processors
How do I get the kio's to be more balanced? I'm on a Proliant 7000 4-cpu box using NT4.0. C:\\\\WINNT\\\\system32>onstat -g iov Informix Dynamic Server Version 7.31.TC2 -- On-Line -- Up 08:00:59 -- 1643008 Kbytes AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy …
XPS or IDS customers using SANs?
We use IDS on HDS 7700E. Like the others, works great. No problems over last 3 years (not even a failed disk). who is the customer? FSC - Financial Service Corporation how much data are they storing? About 1/2 terabyte overall (2/3 of that is database 1/3 file storage) which pla…
Informix Lockup (Wierd)
----- Original Message ----- From: "Phillips, Rob" <RPhillips@ce-a.com> To: <ids@iiug.org> Sent: Thursday, January 30, 2003 8:14 PM Subject: Informix Lockup (Wierd) [184] > Occasionally I am experiencing Informix locking up. It won't accept any db > connections, or process any S…
RE: # of instances per machine
I like having 2. One XPS setup, one IDS setup for the OLTP needs. I wish there was conncetivity between them. cheers j. > -----Original Message----- > From: Art S. Kagel [mailto:kagel@erols.com] > Sent: Wednesday, February 07, 2001 2:42 AM > To: informix-list@iiug.org > Subje…
RE: NUMAIOVPS
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_01C0905B.54B8BA30 Content-Type: text/plain; charset="iso-8859-1" I check max queue length (onstat -g ioq). If max queu…
RE: NUMAIOVPS
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_01C09050.0C3C53BC Content-Type: text/plain; charset="iso-8859-1" When you notice that the aio vps on the 'bottom' aren'…
NUMAIOVPS
This is a multi-part message in MIME format. ------=_NextPart_000_0039_01C09048.8C7D2270 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am steadily increasing my NUMAIOVPS according to the "onstat -g iov" output (io/wup) Accept for this comma…
RE: # of instances per machine
It depends. What version are you running? If version 5 then perhaps that might be a good rule. I would not consider running 7.x+ on less than 4 CPUs. It also depends on whether these instances will all be active at the same time, if they can swap out...... However. I am hig…
# of instances per machine
If the question is 'should' you configure, the answer is ONE! Certainly for a production server. If you have man CPUs then you can likely get away with 2-4 with enough memory. Art S. Kagel Christian Eriksson wrote: > > Hi! > > I wonder if there's any recommendations about how…
FW: what does lngspins mean?
Longspins are spin locks that virtual processors have spun more than 10,000 times in order to acquire. To reduce longspins, reduce the number of virtual processors, reduce the load on the computer, or, on some platforms, use the no-age or processor affinity features. Dirk Reach …
Re: aio vp confusion again
Chalice Tabernacle Now I am waiting to get a earful from everyone in France. *********** REPLY SEPARATOR *********** On 1/25/2001 at 6:21 PM obnoxio@hotmail.com wrote: >Bugger off, spammer. > >In the year of Our Lord Thu, 25 Jan 2001 13:08:00 -0000, Earle Long ><Earle.Long@s…
Re: aio vp confusion again
Woodall Con wrote: > > On Thu, 25 Jan 2001, Earle A Long wrote: > > > Certain swear words have a different amount of severity dependent on the > STUFF LEFT OUT > > "Andrew Hamm" <ahamm@sanderson.net.au> wrote in message > > STUFF LEFT OUT > > > I don't want to offend anyone, but …
Re: aio vp confusion again
On Thu, 25 Jan 2001, Earle A Long wrote: > Certain swear words have a different amount of severity dependent on the STUFF LEFT OUT > "Andrew Hamm" <ahamm@sanderson.net.au> wrote in message STUFF LEFT OUT > > I don't want to offend anyone, but I'm not going to live in a monestar…
RE: aio vp confusion again
I'm not allowed to say anything as the chap happens to work for one of our customers. :( But I'm reading with interest :) Rekaish. Oh I almost forgot that disclaimer stuff Any views expressed in this message are those of the individual sender, except where the message states…
RE: aio vp confusion again
> Certain swear words have a different amount of severity > dependent on the > Country and Culture they are used in. The particular work > used is considered What work were you referring to? Personally I find all work vulgar and disgusting > extremely vulgar and disgusting in …
RE: aio vp confusion again
At lease you've found out how to get the volume of replies you were after. -----Original Message----- From: Tony Flaherty [mailto:aef@mfs.misys.co.uk] Sent: Tuesday, January 16, 2001 11:44 AM Posted To: informix Conversation: aio vp confusion again Subject: aio vp confusion ag…
RE: aio vp confusion again
Oh should I have added a tic (tongue in cheek) or to be read by those with some intellect or maybe <smile> or :-) or evel lol Yours --- Earle A Long (Senior Informix DBA) SINGLEPOINT LIMITED -----Original Message----- From: jim lowry [mailto:lowryjim@hotmail.com] Sent: 25 Janua…
RE: aio vp confusion again
Mr. Long, For you to single out a given country only shows your own weaknesses. You speak of common courtesy, yet you have the gall to include an entire country in you comments. Should we lump you into the same group as Jack the ripper, or the other morals lacking Ladies and D…
RE: aio vp confusion again
Certain swear words have a different amount of severity dependent on the Country and Culture they are used in. The particular work used is considered extremely vulgar and disgusting in England and as such I took exception to it's use. I'd hate to have to consider leaving a techni…
RE: aio vp confusion again
Certain swear words have a different amount of severity dependent on the Country and Culture they are used in. The particular work used is considered extremely vulgar and disgusting in England and as such I took exception to it's use. I'd hate to have to consider leaving a techni…
RE: aio vp confusion again
> In the year of Our Lord Wed, 24 Jan 2001 15:21:56 -0000, > "Earle A Long" > <earle@btclick.com> spake, saying: > > >If you use foul language in a posting don't count on getting > many replies. Spheriods!!! You get some of the best responses that way :-)) Paul Watson …
Re: aio vp confusion again
In the year of Our Lord Wed, 24 Jan 2001 15:21:56 -0000, "Earle A Long" <earle@btclick.com> spake, saying: >If you use foul language in a posting don't count on getting many replies. Golly, gee whiz. Foul language. I think someone needs a visit to the life shop.…
FW: aio vp confusion again
We got our filter about 2 weeks ago - sad. Attachments are being blocked as well as certain text words, which I can't list here. Maybe it's time become a freedom fighter ...... Dirk Reach Technologies -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:…
RE: aio vp confusion again
I believe it was decided that phrases such as Fire trUCK could be substituted. Cheers David -----Original Message----- From: Andrew Hamm [mailto:ahamm@sanderson.net.au] Sent: Thursday, January 25, 2001 11:35 AM To: informix-list@iiug.org Subject: Re: aio vp confusion again Dav…
RE: aio vp confusion again
Andrew, I think few people will be offended by mild Aussie slang. However, I think this was discussed previously, companies are starting to place e-mail filters on their mail servers which prevent the message from being passed through. So, if you use foul language you may be…
Re: aio vp confusion again
Earle A Long wrote in message ... >If you use foul language in a posting don't count on getting many replies. > Are you serious? Really sounds like you are... I thought it was not uncommon for people to use mild slang to setup a kind of chummy casualness - same way that smileys …
Processor Affinity
On 18th Aug 1998 kagel@bloomberg.net (Art S. Kagel) wrote:- There can be great benefit. Sometimes, on some systems (especially Numa architecture systems), there are performance gains above those achieved by the ONINIT affinity parameters to be had be affining the VPs yourself. I …
Re: KAIO ands "onstat -g iov" output
Earle A Long wrote: > > RTFM .... "Performance Guide, Configuration Parameters and Environment > Variables That Affect CPU Utilization, NUMAIOVPS" :- > If your operating system supports KAIO, the CPU VPs make I/O requests > directly to the file instead of the operating-system buf…
Re: KAIO ands "onstat -g iov" output
In article <932h3l$os4$1@nnrp1.deja.com>, William Rice <ricew@operamail.com> writes >I can't imagine a couple of extra AIOVP's having anything like a >significant impact on performance. > >Will >1 AIO VP's a) Use more memory - seperate process b) Use more thread schedu…
Re: KAIO ands "onstat -g iov" output
Jens Ebert wrote: > > We see the following output for onstat -g iov: > > AIO I/O vps: > class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup > kio 0 i 4.0 225118 223795 1323 0 451246 0.5 > > kio 1 i 2.5 139912 138237 1675 …
Re: KAIO ands "onstat -g iov" output
In the year of Our Lord Thu, 21 Dec 2000 09:58:38 GMT, j.ebert@hhpv.de (Jens Ebert) broke a vow of silence to utter: >We see the following output for onstat -g iov: > >AIO I/O vps: >class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup > kio 0 i 4.0 225118 …
KAIO ands "onstat -g iov" output
Make sure you have NUMAIOVPS set to 1 Yours Earle A Long (Senior Informix DBA) SINGLEPOINT UK LTD "Jens Ebert" <j.ebert@hhpv.de> wrote in message news:3a41d342.8306119@proxy... > We see the following output for onstat -g iov: > > AIO I/O vps: > class/vp s io/s totalops dskre…
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…
RE: Assert Failed: Unexpected virtual processor termination, pid
nope. but oncheck was being run. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: 30 November 2000 18:12 To: yfwoi@tpl.com.sg; informix-list@iiug.org Subject: Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0…
Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0x100
Did someone kill an oninit process? From: Woi Yew Fong <yfwoi@tpl.com.sg> > >Can somebody tell me what could have happened to IUS the based to the >following extaraction from online.log? > >============= extraction from online.log ================ > >16:13:14 Assert Failed: U…
Assert Failed: Unexpected virtual processor termination, pid = 74
Can somebody tell me what could have happened to IUS the based to the following extaraction from online.log? ============= extraction from online.log ================ 16:13:14 Assert Failed: Universal Server must abort 16:13:14 INFORMIX-Universal Server Version 9.14.UC1 16:…
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…
Re: onstat -g iov
From: "Neil Truby" <ntruby@netcomuk.co.uk> > > > Have one AIO with less that 1 io/wup. Keep adding until this happens. > >... or you blow some critical system table parameter related to the number >of processes! Well, you *are* running on HP. :-> >Obnoxio The Clown <obnoxio@hot…
Re: onstat -g iov
From: mgimbert8769@my-deja.com > >I have INFORMIX 7.24.UC7 and I will like to known means of columns >wakeups and io/wup in onstat -g iov command > >AIO I/O vps: >class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup > msc 0 i 0.0 17106 0 0 …
onstat -g iov
The column wakeups is literally the number of times each VP was awakened from an idle sleep when it had not been needed then suddenly was. The next column, io/wkup, is how many I/O requests the VP satisfied, on average, each time it was awakened. One use of this last is that if…
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 …
Re: checkpoint problem
> NUMAIOVPS 2 # Number of IO vps A newbee observation, NUMAIOVPS is too small, compared to the number of CLEANERS of 127. Thanh Sent via Deja.com http://www.deja.com/ Before you buy.…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: Slow Performance on IDS 7.30
Hi Art, I suppose that the Bufwaits Ration you mentioned is a calculated value. I want to check our system. How is it done? Thanks Art S. Kagel <kagel@bloomberg.net> wrote in message news:39A6B13B.DC42449C@bloomberg.net... > First Jason please do not post MIME/HTMP, this is a …
Regading to io/wup
Hi, I have 10000 buffers, 10 LRUs, 10 Cleaners and initially 10 vps AIO (no Kaio, 1 processor, 128 Ram, SuSE Linux, IDS 7.30.UC7, 10 users) I've read in this group that at least, 1 io/wup should be to < 1.0, so I added more AIO vps. Firstly 2, then 2 plus and so on, until 16 ..…
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…
Informix 7.30 slows down
This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C001ED.8DF51520 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Has anyone heard of the following problem. Tech Support have not been able to locate a problem or give a rea…
Re: I/O bottleneck, bufwaits too high
"Hal Maner" <hmaner@msystemsintl.com> wrote in message news:8ma9dc$eve1@www.informix.com... > Just out of curiosity ::) > > How many rows are there in the t_prm table? Around 526,000. > What are the indexes (and key columns) in the t_prm table? No indexes except for the PK col…
Re: Changing from Informix to Oracle
From: rboscia <rbosciaNOrbSPAM@ems.att.com.invalid> > > You told me I should increase my AIO VP's. What is a good # >to start at? >The Informix book shows max (2* number_of_chunks),6) > >and I have no clue what that 6 means.... It's the number between 5 and 7. Just look on yo…
Changing from Informix to Oracle
Art, You told me I should increase my AIO VP's. What is a good # to start at? The Informix book shows max (2* number_of_chunks),6) and I have no clue what that 6 means.... Thanks Robin ----------------------------------------------------------- Got questions? Get answers o…
About AIOs vp ...
Hi, Do the AIOs vp lunch treaths as CPUs vp do ? According to onstat -g ath, #AIOs threaths seem to be equal to #AIOs vp. Regards, Manel Falcó…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: Oninit & Instance
Found in "onstat -g glo" Individual Virtual Processors Section -- Class CPU. Neil, Stephen & Edward, thanks for your help. Nick Kataria <kataria.nick@emeryworld.com> wrote in message news:8jdblp$c3e$1@news.cnf.com... > Hi All, > > If I have a process ID of an oninit process (fr…
Initiating Checkpoints manually
In addition to Rudy's suggestion note that LRUS, CLEANERS, and (if you are not using KAIO) NUMAIOVPS will also affect checkpoint duration far more readily than CKPTINTVL. Also setting the CKPTINTVL too short can adversely affect performance as too large a percentage of time is s…
Re: AIO VP's -how many?
In article <39356F86.88380AF2@home.com>, The Beef Man <paulhoward@home.com> writes >FYI - We had a similar problem with your same configuration. Our kaio >problems were solved with IDS 7.31UC5 > 7.31.UC6 is the latest version. >CKGeier@nwc.edu wrote: > >> We are using AIX 4.3…
Re: AIO VP's -how many?
From: CKGeier@nwc.edu > >We are using AIX 4.3.3, and IDS 7.31UC3, with 2 processors but >MULTIPROCESSOR=0, so we are using one CPU VP. I have 2 AIO VP's >configured. We are not using kaio as it caused Informix crashes when we >implemented a web server to access the Informix datab…
AIO VP's -how many?
We are using AIX 4.3.3, and IDS 7.31UC3, with 2 processors but MULTIPROCESSOR=0, so we are using one CPU VP. I have 2 AIO VP's configured. We are not using kaio as it caused Informix crashes when we implemented a web server to access the Informix database. I have heard differing…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
RE: Page Size on Solaris (Informix 7.31)
My apologies to all where I stated that all current INTEL platforms have 2K page size. Somewhere I read 2K was the norm {not all} for INTEL platforms. -----Original Message----- From: Murray Wood [SMTP:murray@quanta.co.nz] Sent: Friday, May 05, 2000 6:01 AM To: a_blonde@mindless…
NUMAIOVPS on 8.2x or 8.3
All, (especially Art) I know that this parameter should be set to (2 * number of disks or 6, whichever is greater) but; I have ~6000 dbspaces on about 320 DASD devices totalling about 2TB. Now, here's the question, how much memory does Informix allocate for each VP?, and wha…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
Re: checkpoint spikes
You don't need any AIO VP for logging just for writes to cooked files. If you have cooked log space you will be using LIO vps not AIO vps. However, I would definitely recomend moving to raw disks and KAIO before setting up 135 AIO VPS. Also, you need to take into consideratio…
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…
KAIO in AIX
Andre Ngo <andre@fiscal.org.jm> wrote in message news:8augdc$aj7$1@nnrp1.deja.com... > Hi all!!! Hi . > I came to a deadlock tying to figure this one out. > Is there a way to add more KAIO to the engine? Number of kio threads is equal to the number of CPU virtual processors in…
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…
checkpoint spikes
When onstat -g ioq shows a backlog for aio, try incrementing NUMAIOVPS. A a rule of thumb, two aio VPs per frequently accessed disk. Nona…
Database performance
I guess the question would be more about the number of AIO VPs running (or sleeping). My onconfig file does not have the variable NUMAIOVPS set which according to the documentation would default to 6 (since there are about 24 chunks in the database). So if that was going to be th…
Shared Memory Parameters?
I am working with an existing database that has some onconfig parameters that I am questioning. One of our problems is extents, but another reason we get hammered during the day might be the following shm parameters. OL Engine Vers. 7.31 on HP 9000 Aprx. 400-600 users Database …
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…
Re: About RA_PAGES
From: Informatica <navidul@retemail.es> > >I've a DSS style Server, I have this parameters in my ONCONFIG file: > ># Read Ahead Variables > >RA_PAGES 1000 # Number of pages to attempt to read >ahead >RA_THRESHOLD 500 # Number of pages left before …
About RA_PAGES
Hi, I've a DSS style Server, I have this parameters in my ONCONFIG file: # Read Ahead Variables RA_PAGES 1000 # Number of pages to attempt to read ahead RA_THRESHOLD 500 # Number of pages left before next group My AIO's working to much. Outpu…
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…
when informix-server down ?
Andreas Lommel wrote: > > Hi,- I think it`s better when I bring the informix db-server from time > to time down and start the server new. My question: Can I see when > it`s the right time (memory, ..) PLATFORM and VERSION info? There should be no need to bounce the engine perio…
Help - database access from web server
We have a web application (Linux/apache/CGI/perl/4GL) accessing the database on our Sequent NUMA-Q server. Out of the 700 licenses on our Sequent we want to use up to 100 of them from the Web Server. What is the best way to ensure that this limit is never exceeded? Also, if nu…
Re: The stats of "aio" VP on SingleProc machine in KAIO mode
In article <KSN_3.11459$K%.256066@news.tpnet.pl>, Piotr Wróblewski <ptrwrb@kki.net.pl> writes >I am running IDS 7.30.UC2 server on HP-UX10.20. >My statistics for G50 says, that millions of disk writes go through 'aio', but TRUE. >when we compare 'onstat -g iov' with 'onstat -g…
Re: The stats of "aio" VP on SingleProc machine in KAIO mode
>My statistics for G50 says, that millions of disk writes go through 'aio', but >when we compare 'onstat -g iov' with 'onstat -g iof', the sum of disk writes >(-g iof) is nearly equal the count of 'kio' disk writes (-g iov), >and similarly for disk reads. There is bug in Informi…
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: Assert Failed: Unexpected virtual processor termination
> Hi gurus, > > IUS Version 9.14.UC6 > O/S = HP-UX 10.2 > > Way back in August before I stumbled across this list > IUS crashed and the online.log showed: > > "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" > closely followed by: > "Assert Failed: Unexpected virtu…
Assert Failed: Unexpected virtual processor termination
Hi gurus, IUS Version 9.14.UC6 O/S = HP-UX 10.2 Way back in August before I stumbled across this list IUS crashed and the online.log showed: "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" closely followed by: "Assert Failed: Unexpected virtual processor termin…
binding to cache
Hi Informix 730UC5 - Sequent Numa-Q I was discussing caching with a consultant that we have in at the moment, she mentioned that in oracle and sybase you can bind the database to cache - but this comes with the overhead of high memory usage. I was wondering if you can do a…
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
pankaj wrote: > > Hi , > > Not an Informix Expert but your NUMAIOVPS seems somewhat low. Informix > recommends NUMAIOVPS (2 + number of disks used for online). > Then monitor length of aio queues. onstat -g ioq [Original message SNIPPED] Pankaj, If you have Kernel Asynchronou…
Re: slow DSS large dataset query, help
More thoughts below: From: sjsyau@my-deja.com > >NUMAIOVPS 6 # Number of IO vps This is very low, unless you are using KAIO. Also, are these tables fragmented? Are you using PDQ? HTH. ______________________________________________________ Get Your Privat…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Re: Sr. Hardware Systems Engineer Needed
Get that PROM burner warmed up. SC > I didn't know that Informix was implemented at the hardware level. Is > this a new trend? <G> > > John Carlson > Informix DBA > WHSmith USA > > kimral@my-deja.com wrote: > > > > This senior level hardware systems engineer will be a key pa…
7.31 upgrade problems
Thanks for all of the tips. The `onstat -g iof` showed that the vast majority of I/O was occurring on the dbspace that contained all of the tables (~33 IO/sec). The dbspace that came in second was the index dbspace (5 IO/sec). The NUMAIOVPS was also set to 2, so that was not h…
Sr. Hardware Systems Engineer Needed
This senior level hardware systems engineer will be a key participant in system and ASIC simulation for a major new product. This position involves implementing parts of the verification testbench for system testing and writing complete multiprocessing tests for coherency verific…
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…
What mean NUMAIOVPS
Hi Gurus informix, Can you tell me what does mean parameter NUMAIOVPS and in which situation it must be increased ?? best regards PS: our infx administrator has increase this limit from 6 to 7 ???? P. Gineste…
Re: performance turning help
In article <7l2a73$tif$1@nnrp1.deja.com>, Yuri Dovgart <y_dovgart@tci.ukrtel.net> wrote: Hi Yuri, > > NUMAIOVPS 1 # Number of IO vps > > You are using kaio ? If not, increase NUMAIOVPS to at minimum the > number of your active disks. > How do I know if I a…
Re: performance turning help
> My Informix seen to run slow and not taking > full CPU resource. I would ppreciate any help I can get on this problem. See recomendations for NOAGE param. > NOAGE 0 # Process aging Set to 1. It's critical for processes priority. > NUMAIOVPS 1 …
Sun, HP, IBM or Intel?
Todd Boewe wrote: > > Would anyone care to share what has or has not worked in your shop? > Does Informix scale better on a large box like a Sun Enterprise6000 > server, or will it scale just as well spread across multiple Intel boxes > running on Unix? We run IDS 7.xx on 32 CPU…
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: Performance problems
In article <3756CBFE.B27DB9E0@bloomberg.net>, kagel@bloomberg.net wrote: > [ ... snip ... ] > for any busy chunks, with the number of LRUS as a minimum. So if you > increase LRUS to 32 use AIOVPS of 32 otherwise at least 14. Monitor > onstat -g iov at least one or two of th…
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…
Question about IDS scalabiltiy
Carlos Bolden wrote: > > OK....now that's obvious > : - ) > > Here is the problem I am running into: AHH! Now we get to the real question! For everyone's edification, and especially anyone new to the group: It is almost always more productive to post your problem, with as muc…
RE: Number of oninit processes
From: bayati@tmcso.com (Babak Bayati) > >----- Begin Included Message ----- > >no,2 AIO VPs per chunk, > > > From obnoxio@hotmail.com Tue May 4 19:33:02 1999 [MASSIVE SNIP] > > I think it fires off 2 AIO VPs per dbspace or something if NUMAIOVPS is > > blank. Jeez, near enoug…
RE: Number of oninit processes
----- Begin Included Message ----- no,2 AIO VPs per chunk, BABAK > From obnoxio@hotmail.com Tue May 4 19:33:02 1999 > X-Originating-IP: [198.141.197.118] > From: "Obnoxio The Clown" <obnoxio@hotmail.com> > To: doris.willaert@suzuki.be, informix-list@iiug.org > Subject: RE: Num…
Memory Usage on Informix 7.24
LEE Hsin wrote: > > Hi, everybody=20 > > I have a question and hope you could give me suggestions. Now, we are = > developing an application on NEC UP machine (UNIX) with Informix 7.24. = > After starting up Informix, we use onstat utility to see how many memories = > used by Inf…
Re: Capturing SQL
Javier Puente wrote: > > You can access this information by making : > 1.- onstat -u To get the session conection id > 2.- With the sessionid you can trace SQL tasks by doing > onstat -g sql sessioid > EX: > onstat -u |grep myuser > > ---Supposing that sessionid is…
RE: Number of oninit processes
From: Willaert Doris <doris.willaert@suzuki.be> > >Thanks, I saw that NUMAIOVP was left blanc. I think it fires off 2 AIO VPs per dbspace or something if NUMAIOVPS is blank. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.…
RE: Number of oninit processes
Thanks, I saw that NUMAIOVP was left blanc. Doris -----Original Message----- From: Neil Truby [mailto:ntruby@netcomuk.co.uk] Sent: dinsdag 4 mei 1999 10:11 To: informix-list@iiug.org Subject: Re: Number of oninit processes The NUMAIOVPS setting in your $ONCONFIG file? Neil W…
Number of oninit processes
The NUMAIOVPS setting in your $ONCONFIG file? Neil Willaert Doris wrote in message <7gm8ig$5vn$1@news.xmission.com>... > >Online 7.3 UC6 on RS6000 AIX 4.2.1 (390) > >I have 3 instances running on this system. For the first system I have 12 >oninit processes running, for the sec…
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…
Informix on NUMA-Q machines
Does anyone run their OnLine database on a Sequent NUMA-Q machine? If so, can you suggest any online sources of information regarding performance comparisons between a standard SMP machine and a NUMA-Q machine? Or any online info that will explain how the NUMA architecture works…
Re: 48 oninit processes, when informix started
Martin: I check the stop-scripts. Looks the scripts are there. But I usually reboot the machine with : shutdown -r +5 ( for Digital UNIX). I am not sure whether the shutdown execs the scripts. I will check it out. We are using KAIO. Following your suggesting I set the NU…
48 oninit processes, when informix started
xuejinw@shubertorg.com schrieb: > > Hello: > > We are running Informix Dynamic Server Version 7.30.FC4. recently we > noticed that when the system was rebooted, 48 oninit processes were started. > That is a lot. Could not figure out why so many. need your help! > > Thanks…
Informix 7.3 on NT Slow when replication across WAN
Hi, I have recently setup a Informix Replication server from Informix 7.3 running on Solaris 2.6 to a new Single PII 450 processor box running NT SP3 (256 MB Mem). When replication starts the processor sits at 100% for up to 20 mins Even though There were only 3 entries in the t…
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…
HP, KAIO and statistics. What's wrong ?
Eugene Nechayev wrote: > > Hi Informixers > > Ive crossed with a strange problem. > > HP-UX B.10.20 with all recommended Informix patches, > IDS 7.30 UC6 [SNIP] > > The question is what do other kio vp's DO ? > Why do I have only one kio vp that works in the system ? > > Is k…
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…
Re: Processor Affinity
Mike Segel wrote: > Processor Affinity isn't a good idea. > It defeats the purpose of SMP and while some may say its the greatest > thing since sliced bread, its like stored proceedures. Use it when > necessary. > The question is really one of scheduling. > Does SunOS (Solaris)…
Performance Tuning
zandy@skyinet.net wrote: > snip > BUFFERS 1000 You have 512 MBytes of Memory. Why don't give Online more ? snip > RA_PAGES 8 > RA_THRESHOLD 4 Why don't Read 32 Pages instead of 8 ? > NUMAIOVPS 64 OOps - What's that ? > snip > > bufwaits…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Numbers of NUMAIOVPS
I am setting up a small demo database with only cooked filespaces, all on the same disk. Any suggestions of how many NUMAIOVPS I should start with? 2 per cooked space? Thanks david.tamburin@protegrity.com…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Re: IDS & Workgroup Edition
John H. Frantz wrote in message <366D3928.E7586C67@rl.is>... >I'm finding it hard to determine what the essential differences in >functionality are between plain IDS and the Workgroup Edition. I've >gathered the following information from various sources, but I'm not >sure if it'…
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 …
Re: AIX and KAIO
In your config file, try setting KAIOOFF=1 You might also set KAIOON=0 (in addition to setting KAIOOFF). Jay Aymond wrote in message <363fa059.1800529@netnews.worldnet.att.net>... >I would like to benchmark KAIO vs. Informix AIO VP's on AIX. > >How can KAIO be disabled and enabl…
AIX and KAIO
I would like to benchmark KAIO vs. Informix AIO VP's on AIX. How can KAIO be disabled and enabled on AIX 4.2 and Informix 7.24? It seems that setting and unsetting KAIOON does not work. ___________________________________________________________ Jay Aymond EXE Technologies jay…
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: INFORMIX XPS
singhh@vrinet.com wrote: > > Hello all! > > We have a about 5 DEC Alpha's running UNIX 3.2G. We are currently running > INFORMIX 7.12 on the servers. > > We are looking into INFORMIX XPS to create a virtual database on these 5 > servers. Is there anyone who is using INFORMIX XP…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: about virtual processors
> > Hmmmm....meaty stuff as usual, thanks for taking the time to > explain....so is the "timeslice" kernel tunable available generally and > if so could you point me in the right direction to read up on it and/or > use it?? > > Thanks > > Greg > You might try 'The Magic Garden' …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: about virtual processors
Art S. Kagel wrote: .> .> Greg wrote: snip...... .> .> Hi Greg. It is not Solaris so much as having FAST CPUs. I have seen .> that on a system with only 2CPUs of speeds up to 150MHZ that there is .> no significant gain from more CPU VPs then nCPU-1. On our DGs which .> use 32 …
Re: about virtual processors
Greg wrote: > > Art - > > I can't tell you how giggly I am that you seem to be coming around to my > long held assertion that the "conventional wisom" of: NUMCPUVPS = > realCPUs-1 (or so) ain't necessarily so.....could it be your switch to > Sun/Solaris that's changing your mind…
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:…
Re: about virtual processors
Art - I can't tell you how giggly I am that you seem to be coming around to my long held assertion that the "conventional wisom" of: NUMCPUVPS = realCPUs-1 (or so) ain't necessarily so.....could it be your switch to Sun/Solaris that's changing your mind?? Most of my (admittedly…
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: about virtual processors
For a 2CPU system most of us recommend using only a single CPU VP. Based on this, set: MULTIPROCESSOR 1 NUMCPUVPS 1 SINGLE_CPU_VP 1 NOAGE 1 AFF_SPROC 0 AFF_NPROCS 0 This is because IDS does not take advantage of only two CPUs well due to the overhead of managing the addit…
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…
about virtual processors
hi all: Could someone explain a little bit about virtual processors and their configurations? I am running workgroup dynamic server on sun solairs 2.6 with 2 sparce 300 mhz cpu and 256 meg of rams. how many vp should i assign to io and cpu, what's the relationship, an…
Re: AIO vp...
In article <35FD5009.2B91@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Arun Shastry wrote: >> >> SUNIL S. SINGH wrote: >> >> > Hi all !!! >> > >> > I have a little doubt here abt AIO vp. >> > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, …
Re: AIO vp...
Art S. Kagel wrote: > > Stefan Weideneder wrote: > > > > Art S. Kagel wrote: > > > > > > SUNIL S. SINGH wrote: > > > > > > > > Hi all !!! > > > > > > > > I have a little doubt here abt AIO vp. > > > > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, > > >…
Re: I/O Q length
Sadagopan, Sathish wrote: > > Hi, > If the I/O queue length is large for a system using KAIO and all raw devices > which parameters need examination ? > ('-g ioq') - The CPU vp queues (for KAIO) are showing large 'maxlen' values. My suggestion? Disable KAIO and return to AIO VP…
Re: TUNING:aio parameters on AIX
Art S. Kagel <kagel@bloomberg.net> wrote in article <36002794.5F4A@bloomberg.net>... > Dave Thacker wrote: > > > > Platform: IBM Rs/6000 J30 AIX V4.1.5 > > Engine Online DSA 7.23 > > > > From much reading of vmstat, iostat, and xmperf we appear to be I/0 bound > > on our p…
Re: TUNING:aio parameters on AIX
Dave Thacker wrote: > > Platform: IBM Rs/6000 J30 AIX V4.1.5 > Engine Online DSA 7.23 > > From much reading of vmstat, iostat, and xmperf we appear to be I/0 bound > on our production machine. > While investigating the problem I came across a configuration for aio > server…
Re: AIO vp...
Stefan Weideneder wrote: > > Art S. Kagel wrote: > > > > SUNIL S. SINGH wrote: > > > > > > Hi all !!! > > > > > > I have a little doubt here abt AIO vp. > > > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, > > > ie performing I/O through operating syste…
Re: AIO vp...
Art S. Kagel wrote: > > SUNIL S. SINGH wrote: > > > > Hi all !!! > > > > I have a little doubt here abt AIO vp. > > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, > > ie performing I/O through operating system, if chunk is UNIX raw device > > and it rel…
Re: AIO vp...
Arun Shastry wrote: > > SUNIL S. SINGH wrote: > > > Hi all !!! > > > > I have a little doubt here abt AIO vp. > > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, > > ie performing I/O through operating system, if chunk is UNIX raw device > > and it relie…
Re: AIO vp...
SUNIL S. SINGH wrote: > Hi all !!! > > I have a little doubt here abt AIO vp. > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, > ie performing I/O through operating system, if chunk is UNIX raw device > and it relies on AIO vp for performing I/O direct…
Re: AIO vp...
SUNIL S. SINGH wrote: > > Hi all !!! > > I have a little doubt here abt AIO vp. > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, > ie performing I/O through operating system, if chunk is UNIX raw device > and it relies on AIO vp for performing I/O direc…
Re: AIO vp...
SUNIL S. SINGH wrote in message <6titsg$k81$1@news.xmission.com>... > > >Hi all !!! > >I have a little doubt here abt AIO vp. >One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, >ie performing I/O through operating system, if chunk is UNIX raw device >and i…
AIO vp...
Hi all !!! I have a little doubt here abt AIO vp. One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, ie performing I/O through operating system, if chunk is UNIX raw device and it relies on AIO vp for performing I/O directly if chunk is UNIX cooked file. …
Re: Dynamically adding shared memory segs
Bill Weaver wrote: > > Today for some reason we've added 5 shared memory segments dynamically. It almost never happens > that we even have 1 added since I've worked to size our initial segment to avoid this. How can > I tell what is causing us to add so many all of a sudden? > …
Re: Page cleaners
All, I have one question about page cleaners. As they run on CPU VP threads what is the value in having more page cleaners that CPU VP threads? Rgds, Jason In article <35F24445.2AD01F0C@weideneder.de>, Stefan Weideneder <stefan@weideneder.de> wrote: > Hi, > > Normand Bedard…
Re: Page cleaners
Hi, Normand Bedard wrote: > = > I would like to know if: > = > 1) you assign one page cleaner per disk or one page cleaner per chunk? I would assign one page cleaner per disk. But this is only usefull if you assign your chunks to your dbspaces in the right order and if you ba…
RE: Dynamic 4GL / Sequent
Jonathan Leffler wrote in message <6rccrb$s75$1@news.xmission.com>... > >I'm cannot claim to give you unbiassed answers, but... > >We are planning to have a native Sequent port soon. I'm assuming this will >run on NUMA-Q, but I don't know for certain. It will depend in part on …
Re: Dynamic 4GL - on Sequent
Jonathan Leffler wrote in message <6rccrb$s75$1@news.xmission.com>... > >I'm cannot claim to give you unbiassed answers, but... > >We are planning to have a native Sequent port soon. I'm assuming this will >run on NUMA-Q, but I don't know for certain. It will depend in part on …
Re: Attaching VP CPUs to real CPUS on AIX
Graham mitchell wrote: > > Hi > > I am experimenting with the > /usr/sbin/bindprocessor > command on aix 4.1.5 to pin VP CPUs to real CPUs > on an 8 CPU RS6000. > > > What real benfits does this provide ? > Does it ever screw anything up ? > ( I had a down system t…
Re: Dynamic 4GL - on Sequent
On Sun, 16 Aug 1998, David K. Killough wrote: > Two questions: I'm cannot claim to give you unbiassed answers, but... > 1) Has anyone tried to get Dynamic 4GL running on a sequent numa q. 4JS > told me that the unixware trial was my best bet. I don't have the right > system …
Re: Dynamic 4GL -
4js are currently testing beta3 of the web version. informix say they should be ready by the end of this year. Paul Sergeant In article <6r6jqd$8ug$1@birch.prod.itd.earthlink.net>, "David K. Killough" <killougd@ix.netcom.com> wrote: > Two questions: > > 1) Has anyone tried to…
Dynamic 4GL -
Two questions: 1) Has anyone tried to get Dynamic 4GL running on a sequent numa q. 4JS told me that the unixware trial was my best bet. I don't have the right system libraries. 2) Will Informix Web-Enable Dyn 4GL? I saw this claim on the 4JS home page but Informix does not m…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
shm initialization problem solved - was NUMAIOVPS
Answer to my own question - shm init problem solved at last NUMAIOVPS was not set (look at my onconfig file). I changed the parameter to 1 (defeult is 6 or num chunks * 2, whichever is greater) according to the book from Elisabeth Sato- Informix Performance Tuning (p. 66/67): …
shm initialization problem solved - was NUMAIOVPS
Answer to my own question - shm init problem solved at last NUMAIOVPS was not set (look at my onconfig file). I changed the parameter to 1 (defeult is 6 or num chunks * 2, whichever is greater) according to the book from Elisabeth Sato- Informix Performance Tuning (p. 66/67): …
shm initialization problem solved - was NUMAIOVPS
Answer to my own question - shm init problem solved at last NUMAIOVPS was not set (look at my onconfig file). I changed the parameter to 1 (defeult is 6 or num chunks * 2, whichever is greater) according to the book from Elisabeth Sato- Informix Performance Tuning (p. 66/67): …
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: Virtual Processors
I had the same problem. It happens with big queries and you cant stop it really. The VP usually uses what it needs. The best option is to turn NOAGE off, so that the processes age and allow the OS some use of the CPU. Rgds, Jason On Mon, 08 Jun 1998 11:46:55 GMT, darren@syste…
RE: Virtual Processors
Darren, You might check your NOAGE and AFF_SPROC / AFF_NPROCS settings, and then see what your release notes say about those parameters. If this is just occurring when you run specific programs, what is the PDQ_PRIORITY that you are using when you run them? HTH. Paul Mosser O…
Re: Virtual Processors
You need to send us some more info. Is this a SMP box? How many CPU's? What applications are causing the problem? CPU bound Informix engine is not necessarily a bad thing, but if the entire system is slowing down then you need to tune a few things. What to tune depends on wha…
Re: Virtual Processors
darren@systeam.co.uk wrote: : I have a problem with a customer's site with a CPU virtual processor which : seems to be running out of control. It occours when I run one or two : programs, the CPU VP is taking about 90% of the system CPU time, and therefore : bring the system to a…
Virtual Processors
I have a problem with a customer's site with a CPU virtual processor which seems to be running out of control. It occours when I run one or two programs, the CPU VP is taking about 90% of the system CPU time, and therefore bring the system to a general go slow. The Informix engi…
Re: AIO virtual processor
Also sprach <dwillem@ibm.net> : :In the event viewer of Windows NT (4,0), everytime the server is started, we :see the next warning : :INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, :limit exceeded. Started with 1 AIO virtual processor. : :What to do …
AIO virtual processor
Hi, We're running Informix 7.23TC1 on a Digital Alpha 4100 with 3 processors. In the event viewer of Windows NT (4,0), everytime the server is started, we see the next warning : INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, limit exceeded. Started …
Re: nr of processes in ol7.2 on aix?
Klaus Weitzer wrote: > > Can you tell me why there are 11 processes named oninit running on a AIX > risc machine? > Why, how can i reduce them and are they necessary? Each oninit process represents one of your Informix Virtual Processors. There are at least the following: cnt t…
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: oninit sessions
Don Peoples <baileyco8@earthlink.net> wrote in article <3549E114.1AF3@earthlink.net>... > Does anybody know what the aproximate number of oninit sessions should > be under normal operating conditions for Informix 7.2. I am asking > because I have 28 oninit processes running on ou…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: limiting oninits?
neck wrote: > > Is there a way to limit the number of oninit processes that get spawned? > > I'm using 7.20.UC4 for Solaris. They each eat up about 15 megs, and several of them dont get used at all. > > tia Solaris supports the use of Kernel AIO. Consequently, provided you're u…
Re: limiting oninits?
Tia, You need to identify what the processes are being used for. The way to do this is by doing an onstat -g glo. The class you can effect easiest are the AIO processes. The number of AIO processes is controlled by the onconfig NUMAIOVPS. I usually drop…
Re: slow performance
Thuc Nguyen wrote: > > Hi > > I am running ODS 7.23 u4 on HP 10.20 > > So many users complained about slow performance...I looked at "top".... > > IDLE has been around 21% > > %WCPU 36% == (command) oninit > %CPU 35% == (command) oninit > > The partial onconfig info.... [SNIP] > …
Re: raw Vs kernel aio
David Williams wrote: > In article <01bd537d$be79c270$bb3c2ba0@prn100-02-682e>, Bloomberg L.P > <LOGIN_ID@bloomberg.com> writes > >David Williams <djw@smooth1.demon.co.uk> wrote in article > ><NXzCuMAuFDE1Ewdv@smooth1.demon.co.uk>... > >> In article <350CE08F.44902F25@email.mot…
Re: Informix ODS 7.24 on Sequent NUMA-Q
I thought that applications did not need to be programmed to be NUMA-Q aware. All the information that I had been given indicated that it was not necessary. Do you know what kind of changes are required to be NUMA-Q ready? What kind of performance difference is there between a…
Re: Informix ODS 7.24 on Sequent NUMA-Q
Laurent, Many thanks for your helpful comments. We are resuming our test tomorrow and I know we will benefit from your response. My faith in Sequent/Informix has been restored!! > Did this person told you why it wouldn't scale? Yes, because Informix was not NUMA aware, and …
Re: Informix ODS 7.24 on Sequent NUMA-Q
In article <3502d2f5.0@news.snip.net>, David K. Killough <killougd@ix.netcom.com> wrote: >We are having problems testing a 450-user OLTP application. We have been >told that the Informix/NUMA-Q combination will not scale well for our test. David, Whoever told you that doesn't…
Informix ODS 7.24 on Sequent NUMA-Q
We are having problems testing a 450-user OLTP application. We have been told that the Informix/NUMA-Q combination will not scale well for our test. Anyone with INFORMIX/NUMA-Q OLTP installed please respond with comments!!! We have 2 quads (1GB mem, 4 180MHz P6 on each). We w…
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: KAIO on HP UX 10.20
Jason Harris wrote in message <34ea2543.1361877556@10.209.30.200>... >Dear All, > >Running 7.23UC6 on HP 10.20 we so far have found KAIO to be slower >than using AIO VPs. I have seen the same with HPUX 10.10 and 7.2x There is a rumour that the implementation of KAIO on HPUX is n…
Re: onstat -g ioq ??
On Wed, 28 Jan 1998, Jeremy Hawkey wrote: > I 'm sorry to be such a peasent, but does this mean; looking at the > activity on these gfd's I need to add another AIO vp or not. In the > manual it says if maxlen or len is high add another aio, I think it is > referring only to the…
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…
Philly, PA Area Positions for Informix-4GL developers
UNIQUE OPPORTUNITY FOR INFORMIX 4GL PROGRAMMERS TO - make a difference using your skills - move to client/server We are a rapidly growing transportation company seeking 4 seasoned Informix-4GL programmers for full-time permanent employment. We have just purchased Sequent …
Southern NJ Positions (4) for Informix-4GL Programmer/Analyst
UNIQUE OPPORTUNITY FOR INFORMIX 4GL PROGRAMMERS TO - make a difference using your skills - get into client/server and java We are a rapidly growing transportation company seeking 4 seasoned Informix-4GL programmers for full-time permanent employment. We have just purchase…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: chekcpoints, BUFFER settings, and optimization
In article <66madi$osk@cssun.mathcs.emory.edu>, Serafim Fonseca <inf@dpx20.growela.pt> writes >} >} In article <881611278.1353908229@dejanews.com>, >} jneugebauer@ameritrade.com writes >[...] > > >David Williams writes > >[...] >} ># Shared Memory Parameters >} > >} >LOCKS 10000…
Re: chekcpoints, BUFFER settings, and optimization
} } In article <881611278.1353908229@dejanews.com>, } jneugebauer@ameritrade.com writes [...] David Williams writes [...] } ># Shared Memory Parameters } > } >LOCKS 100000 # Maximum number of locks BUFFERS 5000 # Maximum number } } BUFFERS 5000!! } Run onstat -b and look…
Re: Questions on INFORMIX 7.13 and CPU VPs
sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > 1. Is it true that we can configure only one NETTYPE connection on the > CPU VP ? Currently, both my NETTYPE connections ( SOC and SHM ) are > configured on CPU VPs. If my assumption is true, does INFOR…
Re: oninit processes
SaTriGuy wrote: > >By default , the NUMAIOVPS is left blank, which > >according to the Informix guide implies that NUMAIOVPS is 2 for > >single processor CPU. > > The number of aiovps defaults to the min of 2 per chunk or 6, which ever is > larger. > Madison Pruet But accordin…
Re: oninit processes
>By default , the NUMAIOVPS is left blank, which >according to the Informix guide implies that NUMAIOVPS is 2 for >single processor CPU. The number of aiovps defaults to the min of 2 per chunk or 6, which ever is larger. Madison Pruet…
Re: oninit processes
Terence Chang wrote: > I'm just puzzled by the no of oninit processes when on-line starts > up. You will have one oninit process for each VP you start. So, you just add cpuvs + liovp + piovp + admvp + mscvp + netvp + aiovp. > By default, the NUMAIOVPS is left blank, which accor…
oninit processes
System: AIX 4.2 ODS : 7.14 UD1 No of CPU : 1 Chunks : all raw devices. Hi, I'm just puzzled by the no of oninit processes when on-line starts up. It seems these oninit processes are related to the NUMAIOVPS onconfig parameter. By default , the NUMAIOVPS is left blank, w…
Re: gfd virtual processor class...
June - sounds reasonable, thanks. I'll have to count tomorrow & see if they jive. Greg (from my alter ego at home...) June Tong wrote: > > : I was looking through the output of "onstat -g ioq", and it occurs to me > : I don't have a clue what VP type "gfd" is (see snippet belo…
Re: Cannot fork a virtual processor
Mark D. Stock wrote: > > Enigma wrote: > > > > Hi, > > My informix ODS went down when I tried to put it to online. I'm > > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > > online.log is > > Cannot fork a virtual processor errno=12. > > This hap…
Re: Cannot fork a virtual processor
Enigma wrote: > > Hi, > My informix ODS went down when I tried to put it to online. I'm > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > online.log is > Cannot fork a virtual processor errno=12. > This happens only intermittently. It seems to…
Re: gfd virtual processor class...
: I was looking through the output of "onstat -g ioq", and it occurs to me : I don't have a clue what VP type "gfd" is (see snippet below). Can : anybody clue me in?? It's not a VP type. It's an I/O queue. I think it's Global File Descriptor (or something like that). Basica…
Cannot fork a virtual processor
Hi, My informix ODS went down when I tried to put it to online. I'm running a informix 7.14 on a IBM AIX 4.2 machine. The error in the online.log is Cannot fork a virtual processor errno=12. This happens only intermittently. It seems to indicate there is insuffici…
Re: Cannot fork a virtual processor
Enigma wrote: > > Hi, > My informix ODS went down when I tried to put it to online. I'm > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > online.log is > Cannot fork a virtual processor errno=12. > This happens only intermittently. It seems to…
gfd virtual processor class...
I was looking through the output of "onstat -g ioq", and it occurs to me I don't have a clue what VP type "gfd" is (see snippet below). Can anybody clue me in?? plsaphp1:informix 1> onstat -g ioq INFORMIX-OnLine Version 7.21.UD3 -- On-Line -- Up 26 days 06:59:37 -- 175552 K…
Re: Informix crashing UNIX on HP
On Thu, 02 Oct 1997 16:19:24 +0200, "Mark D. Stock" <mdstock@informix.com> wrote: >Silvester_Valiente@tnt.com.au wrote: >> >> Has anyone had an experience where Informix 7.23 UC4 caused Unix to >> Panic and shutdown. >> >> We are experiencing the problem when the virtual portion…
RE: ?? Are table fragments going to work for me ??
Dave Killough wrote: > I am preparing an 140GB database using Dynamic Server 7.2. > > We need the database available 100% of the time. We will use it = 24x7x365. > We need to store the last 25 months; the oldest month needs to be = archived to > tape and deleted from each table …
?? Are table fragments going to work for me ??
I am preparing an 140GB database using Dynamic Server 7.2. We need the database available 100% of the time. We will use it 24x7x365. We need to store the last 25 months; the oldest month needs to be archived to tape and deleted from each table to make room for the next month. I…
Re: Online 7.12 Tunning [more info]
On Tue, 23 Sep 1997, Nigel Gall wrote: } } Hi! } } Just a question on your response: } } At 07:11 PM 9/22/97 EDT, Art Kagel wrote: } > } > [... snip ...] } > } >3) You have but one AIO VP, since the CPU VP does work for other threads } >while waiting for the AIO VP to return man…
Re: Online 7.12 Tunning [more info]
Hi! Just a question on your response: At 07:11 PM 9/22/97 EDT, Art Kagel wrote: > > [... snip ...] > >3) You have but one AIO VP, since the CPU VP does work for other threads >while waiting for the AIO VP to return many IO requests can queue up. >Informix recommends 1.5 AIO VPs…
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…
FW: Re: DIGITAL and INFORMIX
Another company that should be added to this list and has also put out some "pretty outrageous" TPC scores is Sequent with their NUMA technology. Sequent is also a first tier company. Informix in fact has a portion of its development staff actually at Sequent's headquarters. I…
HPUX 10.20-7.22 Restore problems
We have an HPK250, single processor, 160 meg mem, Informix 7.22. When I try to restore from a level 0 archive tape, the machine hangs completely. We have to use "the big switch" to reboot. Tried several configs - up to 64000 initial virtual, cutting down the off recovery threads…
PRESS: Sequent and Informix Post Record TPC-D Single System
Sequent and Informix Post Record TPC-D Single System Performance with NUMA 2000 and OnLine XPS Best Single System Performance with Half the Processors of Previous 300GB Record; First NUMA System and First Large Intel-based Single System to Weigh-In on Decision Support Benchmark…
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: kaio
Ilya, I've have an HP system that has about a 15% speed degredation when using KAIO instead of AIO VP's. I also have an EMC disk farm, with a 1GB cache on board,so that probably is affecting the mix quite a lot. David >Folks, > >I am sure there are people around who's done th…
Re: Performance advice
What is your NUMAIOVPS $ONCONFIG parameter set to - you may want to increase it if you have lots of chunks. (Mine is set to 26 for approx 50 chunks - made a huge difference) Dan…
Re: Informix and Oracle in the same shop
In article <5n5d33$2ma@mew.corp.sgi.com>, newsrdr@mew.corp.sgi.com writes: > > In article <5n50t2$4vb$1@despair.u-net.com>, david@go5.com writes: > > > > Even your company is going down the "shared-nothing" route in order to > > meet future performance and scaleability requiremen…
Re: Informix and Oracle in the same shop
In article <5n50t2$4vb$1@despair.u-net.com>, david@go5.com writes: > > Even your company is going down the "shared-nothing" route in order to > meet future performance and scaleability requirements. Your Cellular > technology is an example of this. > It's going down the "best o…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <862264236.20961@dejanews.com>, Brenda Muller <muller.brenda@primestar.tci.com> writes: > > >plans like clustered SMP systems with fiber between the boxes, > > >or some NUMA-like MPP systems with "memory" connectivity > > >between boxes (I still don't see how that woul…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <LtWjwJALCpYzEwnU@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: > > In article <861943179.18332@dejanews.com>, Brenda Muller > > > >Oracle's product is Oracle Parallel Server (OPS), and Informix's > >product is Informix XPS. I only have direc…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <861943179.18332@dejanews.com>, Brenda Muller <BMReed@aol.com> writes >In article <5j6eju$h25@omni2.voicenet.com>, > gray@voicenet.com (Scott Gray) wrote: >> >> In article <33538a45.29051694@news.jax.mindspring.com>, >> Reid Fleming <RFleming@aol.com> wrote: >> >Dave …
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <5j6eju$h25@omni2.voicenet.com>, gray@voicenet.com (Scott Gray) wrote: > > In article <33538a45.29051694@news.jax.mindspring.com>, > Reid Fleming <RFleming@aol.com> wrote: > >Dave Raddatz <raddatz@austin.ibm.com> wrote: > > > >>Steve Phelan wrote: > >> > >>I think La…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Scott Gray wrote: > > In article <33538a45.29051694@news.jax.mindspring.com>, > Reid Fleming <RFleming@aol.com> wrote: > >Dave Raddatz <raddatz@austin.ibm.com> wrote: > > > >>Steve Phelan wrote: > >> > >>I think Larry's referring to the SP machines (mutltiple RS/6000 > >>node env…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Scott Gray wrote: > > In article <33538a45.29051694@news.jax.mindspring.com>, > Reid Fleming <RFleming@aol.com> wrote: > >Dave Raddatz <raddatz@austin.ibm.com> wrote: > > > >>Steve Phelan wrote: > >> > >>I think Larry's referring to the SP machines (mutltiple RS/6000 > >>node env…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <33538a45.29051694@news.jax.mindspring.com>, Reid Fleming <RFleming@aol.com> wrote: >Dave Raddatz <raddatz@austin.ibm.com> wrote: > >>Steve Phelan wrote: >> >>I think Larry's referring to the SP machines (mutltiple RS/6000 >>node environment) vs. what you describe as S…
Re: Informix 5 Performance Issues
Remember - YMMV, etc: On 16 Apr 97 at 17:04, Phantom173 wrote: > We have been told by a consultant that a move to Informix 7 would > benefit us because (a) Informix 7 would reduce the number of connects > (and therefore processes) associated with the elephants, and (b) it > wou…
Re: SCO Unix and Informix 7 Performance
In article <334E8ADA.6CFD@ccmail.acer.de>, Kai Shen <kai_shen@ccmail.acer.de> writes >Hi all, > >we are currently running SCO OS 5.0.2 and Informix OL 7.11, the machine >is a double Pentium Pro/200 with 512 MB RAM, 4 harddisks with 14 GB >(plus duplexed). The system is mainly use…
Re: 7.22.UC1X2 Performance tuning questions....
Bill, Thanks for your response, We will be installing the new asyncdsk software later today and relinking the kernel tonight, Once this is done we will turn on KAIO and reduce the number of NUMAIOVPS to two. It will be very interesting to see the impact of the KAIO on the system…
Re: OnLine 7.13 performance problems - comments please?
I notice a lots of seqscans. You probably have to ta a look at the application. Your database probably needs some more indexes. Use set explain on. And watch out for SEQUENTIAL SCANS. Then take a look at the where clause and add new indexed as needed. Have you done update stati…
Re: dbaccess setup between different platforms
> From: David Hexem <dhexem@co.riverside.ca.us> > Subject: dbaccess setup between different platforms > Date: Mon, 24 Mar 1997 11:17:19 -0800 > Reply-to: 4080@rmy.emory.edu, Lemon@rmy.emory.edu, Street@rmy.emory.edu, > 7th@rmy.emory.edu…
Re: Informix on NT platform - Impact of 100 to 400+ Users
Nils Myklebust <Nils.Myklebust@idg.no> wrote: > chaminda@jcdcrs4.jobcorps.org wrote: > First I am not an NT hater. We intend to use it as a database server. > However not in the league asked about by the original poster of this > thread. > Hopefully NT can make the Unix communit…
Re: Installing Online 6 on SCO Unix: Network down
In article <331B4E15.2C2A@acer.de>, Kai Shen <shen@acer.de> writes >Hi all, > >we are installing Online 6.0 on SCO OS 5.0.1 When taking Online to >Quiescent or online mode we get the warning "Network down", and online >gets incredibly slow. We think it is a shared memory configur…
Re: AIO vp's
Edward Bidinotto wrote: > > IN running 7.11 uc1 you can dynamically add AIO vp's but cannot > dynamically remove them. > > Can someone tell me the reason behind that and do future releases > allow this functionality? > > Tks > Ed Hi, maybe it's because most of the users add so…
Re: AIO vp's
In article <330DE3E5.5EF4@cobe.com>, Edward Bidinotto <edbid@cobe.com> writes >IN running 7.11 uc1 you can dynamically add AIO vp's but cannot >dynamically remove them. > >Can someone tell me the reason behind that and do future releases >allow this functionality? > >Tks >Ed …
AIO vp's
IN running 7.11 uc1 you can dynamically add AIO vp's but cannot dynamically remove them. Can someone tell me the reason behind that and do future releases allow this functionality? Tks Ed…
Re: Tuning CPUVPS/AIOVPS
In article <32FFA371.749@cobe.com>, Edward Bidinotto <edbid@cobe.com> writes >On 7.11 if you run > >ONSTAT -G SCH > >What does the busy waits column mean? Is 0 a good number for AIO or CPU >VP's? >Does it mean that there are sufficent AIO or CPU vp's and nothing is >waiting or is…
Tuning CPUVPS/AIOVPS
On 7.11 if you run ONSTAT -G SCH What does the busy waits column mean? Is 0 a good number for AIO or CPU VP's? Does it mean that there are sufficent AIO or CPU vp's and nothing is waiting or is it just the opposite saying that all of the VP's are being used up and you need more…
Re: SAme Aps on 2 Servers, different performance, help!
Hi, Looking at the memory of the 2 machines I'm not surprised at the better performance on Server 1. You also have several other configuration differences between the two machines. The NUMAIOVPS is 8 on server 1 and 3 on Server 2. Is this because you have more disks allocated t…
Re: MULTIPROCESSOR OPTION 7.13
In article <01bbcb91$cc1befe0$654750c6@irwin.interaccess.com>, irwin@objectsoft.com says... > > > >Allen Jantzen <allenj@ndr.com> wrote in article ><327fa20d.27552573@news.netline.net>... >> The Informix DSA Administrators Guide, version 7.1, page 10-18 says >> >> "On some two-pr…
Re: MULTIPROCESSOR OPTION 7.13
Just my 2 cents worth: I have a HP T500, T520, and 2 K200's which all have two processors. I found that running with the MULTIPROCESSOR set to two was the way to go. My performance while running config'd as one cpu was good, but sometimes I'd see the one cpu at 100% while the o…
MULTIPROCESSOR OPTION 7.13
The Informix DSA Administrators Guide, version 7.1, page 10-18 says "On some two-processor computers, you should only run one CPU virtual processor because the overhead of synchronizing the two virtual processors offsets the benefit of distributing the processing" Of course, us…
Re: Query Retrieval
Srirama Sundararajan Rajagopalan <rajagopa@nps.med.ge.com> wrote: :Hi Folks: :I am working on improving the query performance in informix 7.1. :I already have unique indexing on this table and besides optimizing :the query, virtual processor technique, is there any other techni…
Query Retrieval
Hi Folks: I am working on improving the query performance in informix 7.1. I already have unique indexing on this table and besides optimizing the query, virtual processor technique, is there any other technique that can be employed to improve the query retrival time in informix…
Re: NUMAIOVPS setting for KAIO
Fred Krefting wrote: > > David Samuels wrote: > > > > ==========Lin-Chuan Lee, 7/29/96========== > > What is recommended setting in general ( assume on platform > > with no KAIO) ?? A Performnace tuning guide I got in class > > states 1x number of disks but I also remeber the in…
Re: NUMAIOVPS setting for KAIO
Chao Y. Din (cdin@csc.com) wrote: : Fred Krefting wrote: : > : > David Samuels wrote: : > > : > > ==========Lin-Chuan Lee, 7/29/96========== : > > What is recommended setting in general ( assume on platform : > > with no KAIO) ?? A Performnace tuning guide I got in class : > > s…
Re: NUMAIOVPS setting for KAIO
Fred Krefting wrote: > > David Samuels wrote: > > > > ==========Lin-Chuan Lee, 7/29/96========== > > What is recommended setting in general ( assume on platform > > with no KAIO) ?? A Performnace tuning guide I got in class > > states 1x number of disks but I also remeber the in…
Re: NUMAIOVPS setting
David Samuels wrote: > > ==========Lin-Chuan Lee, 7/29/96========== > What is recommended setting in general ( assume on platform > with no KAIO) ?? A Performnace tuning guide I got in class > states 1x number of disks but I also remeber the instructor > saying that sometimes it…
Re: NUMAIOVPS setting
==========Lin-Chuan Lee, 7/29/96========== What is recommended setting in general ( assume on platform with no KAIO) ?? A Performnace tuning guide I got in class states 1x number of disks but I also remeber the instructor saying that sometimes it's better to go with 2x. Experts…
Re: NUMAIOVPS setting
> What is recommended setting in general ( assume on platform > with no KAIO) ?? A Performnace tuning guide I got in class > states 1x number of disks but I also remeber the instructor > saying that sometimes it's better to go with 2x. > If you have really fast disk controllers…
NUMAIOVPS setting
What is recommended setting in general ( assume on platform with no KAIO) ?? A Performnace tuning guide I got in class states 1x number of disks but I also remeber the instructor saying that sometimes it's better to go with 2x. Experts ??? Thanks, -Lin…
Re: 2 CPU VP's
Juan R. Guzman wrote: > > I have a Sparc 20 with 2 processors with Solaris 2.4 and Online 7.11UC1. I have > been thinking of incrementing the amount of CPU VP's from one to two. I don't > use the server for anything else other that for the Informix application. Any > feedback…
lastest compare against oracle
can anyone provide some new information on the rdbms wars between informix and oracle. I know oracle blasts informix for the poor performance, transaction logging, record locking mechanisms and informix touts the performance gains on the methodology for using threads instead of p…
HP K200 and Online 7
We are experiencing SEVERE performance problems trying to upgrade from Online 5 to Online 7. Online 7 runs about 400 percent slower than Online 5 up until +- 400 processes. (Confirmed by Informix S.A). Online 7 performance never degraded even when the load went above 400 process…
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: unexpected virtual processor termination
This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---1503566844-140477562-830393090=:47444 Content-Type: TEXT/PLAI…
Re: unexpected virtual processor termination
Sounds like someone issued a Kill -9, while it was holding locks? Anyway I suggest you turn on your montoring program/script (if you do not have one, I got one to watch engine and another one to watch user's) and see what processes are actually occuring at that time. If you want …
unexpected virtual processor termination
We use Online 7.11 on IBM RS6000 AIX 4.xx (32 MB RAM) for development tasks. Often, while 4GL program is being compiled, Online shuts down. In online.log file one writes: "unexpected virtual processor termination, attempting to bring system down". This virtual processor is msc. …
<No Subject Supplied>
>On occassion we can see that the 'oninit' process associated with the CPU >virtual processor of Informix is taking 100% of the CPU. Is there a good >way now to track this down to which Informix sessions are actually using >this CPU time? >Is there a better, more direct way to …
Re: How do I .... ?
In article <4cmnor$ki2@cssun.mathcs.emory.edu> 1689@MN.LAWSON.lawson.com (Anjan Chakraborty) writes: > >I am getting very high chunk writes and almost 0 LRU writes against onstat > -F >and >high duration against onstat -m. >How do I solve this problem ? >I have CKPTINTVAL=300,NUM…
Re: How do I .... ?
Anjan Chakraborty (1689@MN.LAWSON.lawson.com) wrote: : I am getting very high chunk writes and almost 0 LRU writes against onstat : -F : and : high duration against onstat -m. : How do I solve this problem ? : I have CKPTINTVAL=300,NUMAIOVPS=20,CLEANERS=6,LRU_MAX_WRITE=20, : LR…
Re: How do I .... ?
Anjan Chakraborty wrote: > > I am getting very high chunk writes and almost 0 LRU writes against onstat > -F > and > high duration against onstat -m. > How do I solve this problem ? > I have CKPTINTVAL=300,NUMAIOVPS=20,CLEANERS=6,LRU_MAX_WRITE=20, > LRU_MIN_WRITE=10,LRUS=8,BUFFE…
How do I .... ?
I am getting very high chunk writes and almost 0 LRU writes against onstat -F and high duration against onstat -m. How do I solve this problem ? I have CKPTINTVAL=300,NUMAIOVPS=20,CLEANERS=6,LRU_MAX_WRITE=20, LRU_MIN_WRITE=10,LRUS=8,BUFFERS=60000,PHYSFILE=60000, MULTIPROCESSOR=1…
Re: processes sspawned by 7.1
>I noticed there are a lot of processes names oninit -s >spawned by the database engine on start-up. Can someone >enlighten me as to why this is. I'm sorry I'm not familiar >with the new engine and am just groping along. You get an oninit process for every Virtual Processor (V…
Re: processes sspawned by 7.1
Carol Stimmel (stimmel@fsl.noaa.gov) wrote: : Hi, : I noticed there are a lot of processes names oninit -s : spawned by the database engine on start-up. Can someone : enlighten me as to why this is. I'm sorry I'm not familiar : with the new engine and am just groping along. …
Re: KAIO clarification.
Bruce Cota (cota@dpg.rnb.com) wrote: : Hello folks, I could use a little clarification about using KAIO under : SOlaris. We are running On-line 7.11 under Solaris 2.4. An informix : engineer told us that we should set NUMAIOVPS to use more than one : AIOVP and this would have …
KAIO clarification.
Hello folks, I could use a little clarification about using KAIO under SOlaris. We are running On-line 7.11 under Solaris 2.4. An informix engineer told us that we should set NUMAIOVPS to use more than one AIOVP and this would have a major impact on performance. However: - E…
Re: Informix dual processor scalability
In article <DJ6CHK.5zx@dsbc.icl.co.uk> smb@oasis.icl.co.uk "Stuart Britt" writes: > Using Informix on 1 processor we achieve good performance. If we switch to > 2 processors, then our performance actually degrades. We have been given > some advice on tuning the system for dual…
Re: Informix dual processor scalability
According to my rusty memory, the reason for this is something about the overhead necessary to handle multiple processors only being overwhelmed by the performance increase after three processors. So you should tune as tho' you only have a single processor... :-( HTH. }Does any…
Re: Informix dual processor scalability
Stuart Britt writes: |> Does anyone have any info on the following problem? We are using Informix |> version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP |> machines. |> |> Using Informix on 1 processor we achieve good performance. If we switch to |> 2 processor…
Re: Informix dual processor scalability
: smb@oasis.icl.co.uk (Stuart Britt) writes: : Does anyone have any info on the following problem? We are using Informix : version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP : machines. : : Using Informix on 1 processor we achieve good performance. If we…
Informix dual processor scalability
Does anyone have any info on the following problem? We are using Informix version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP machines. Using Informix on 1 processor we achieve good performance. If we switch to 2 processors, then our performance actually degra…
Informix 7.1 Online Performance Questions??
Hi, I'm trying to develop a performance profile / model for an application that has been developed using the Informix Online Dynamic Server v7.1. The Server is being called by programs written in "C", which use the ESQL interface. My question is the following: I am observing …
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?…