Oninit® Archive
Results for “AFF_SPROC”
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 ------------------------------…
flags (onstat -g ses)
Hello - Yes , the flags showed no waiting for Lock or for another ressource - PDQ is set to 10% - 20 vp CPU with eff around 50% - mpstat shows no cpu with 100%, but i will run it again at different times onstat -g glo Individual virtual processors: vp pid class usercpu syscpu tot…
Informix and Hyper-threading
Hi Paul, It would be interesting to know how you are measuring whether it is a good thing. Do you go by the efficiency metric reported by 'onstat -g glo' or other metrics? Do you use processor affinity at all and, if so, how do you configure it? I guess two Informix CPU VPs being…
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…
Mutex logs on logical log flip
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } That would be my analysis... Sent from Yahoo Mail for iPad On Monday, February 29, 2016, 6:46 PM, NEIL TRUBY <ne…
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)…
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…
11.5FC7WE x PROCS AFFINITY
Hi, everyone. I'm performed a Informix 11.5FC7WE install on Red Hat 6 Linux . The machine I'm using have 4 procs and I want to use 3 of then in Informix (VPCLASS cpu).Since the first time I tried to put my server up (online) I could see in online.log the message Affinitied VP "1"…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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.…
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
I agree too , more information about the "cautions" of this efficiency versus OS (and hardware processor) will help a lot... I'm have "trouble" with this too , running ifx 11.50 FC9X6 / AIX 6.1 Running over P7 with smt4 active (I'm not able to change this...) Before I have the …
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 …
drop CPU VPs....
Hi Martin, Few minutes after post this email here, I discovery exactly what you said, I just check which is the last CPU VP with "onstat -g glo" , use the "onstat -g cpu" to found all sessions what running more over it and killed only this session with more cpu utilization.. then…
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…
onstat -g glo: cpu efficiency
I am a bit concerned over what onstat -g glo is reporting regarding eff for the three cpuvp's , they are avg in the mid 60's. Other instances in our client's landscape have all three much closer to 100% (however those instances are no where near as heavily loaded as this one). C…
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.…
VPCLASS parameter
See the Administrator's Reference for a full description of all documented ONCONFIG variables. That said, VPCLASS has been around since 9.40 and replaces several other parameters which may finally have been deprecated in 11.50 IB. It replaces NUMCPUVPS, NOAGE, AFF_NPROCS, AFF_SPR…
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…
Multiprocessor setting
John's talking about OS scheduling. With your applications and a web server all sharing the same set of processors, I'm not surprised that the VP efficiency is around 35%. If most application and web server tasks entail accessing the database then any action requires at least two…
IDS 9.4 Recursive Exception error
Hi, all informix IDS9.40 FC7XO occur Recursive Exception error ¡Athen system crashed. there is no AF file. What is Recursive Exception error ? Any ideas about the case and solution ? online.log message : 16:42:52 Recursive Exception - Server exiting 16:42:52 the master daem…
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
Hi everybody! I'm planning a migration from HP PA-RISC model RP3440 (4CPU X 2core) with IDS 11.10 FC2 in HP-UX 11.10 to Dell PowerEdge Server R710 (2 Sockets Xeon 2.93GHz X 4Core with 2 threads per core - HyperThread) using IDS 11.50 FC5 in Linux RHEL 5. My question is: How ca…
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…
VPCLASS Notation, pros?
Hi. I want to know if replacing former NUMCPUVPS, AFF_SPROCS, and so on for VPCLASS in IDS 10 brings any advantage in terms of better performance or avoiding malfunction. Admin guide just says "you should" (p. 6-13) and warns against using both notations at once. Thanks i…
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…
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
More LRUS (suggest 128) more CLEANERS (also 128) and lower LRI_MIN/MAX_DIRTY values (suggest 2/1 instead of 5/2). Another option: Upgrade to IDS 11.50 which finally has non-blocking checkpoints and autonomic checkpoint tuning. Art On Mon, Mar 16, 2009 at 11:26 AM, KURT VAN GOM…
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…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: CPU VP Issue
Floyd Wellershaus wrote: > Not a hundred percent sure, but theres a processor affinity setting that > may be forcing only one cpu. > Also, what threads are sitting ? Maybe the app is single threaded ? > We haven't set processor affinity, although we've toyed with that idea. Not…
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…
how to balance CPU VP
roger@star2000.com.tw wrote: > I set onconfig parameter > NUMCPUVPS 10 > AFF_SPROC 2 > AFF_NPROCS 10 > and run ' onstat -g glo' > vp pid class usercpu syscpu total > 1 2863646 cpu 9598.41 149.49 9747.90 > 2 155844 adm…
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
SAMUEL JAKABOWSKI wrote: > Hi, > > While setting up a test environment, a question concerning the correct setting > for NUMCPUVPS popped up. > So, what's the question? You have 4 cores and you have configured 4 CPU VPs. Looks kosher. Question or should we guess? Do you want to …
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…
NOAGE Depreciated
Thanks Art. So, if someone is not using VPCLASS but using NUMCPUVPS, NUMAIOVPS, AFF_SPROC, and AFF_NPROCS parameters separately, he/she should use use NOAGE then. Isn't it? Can you or someone please help me with my second query please? Appreciated your dedication towards commun…
ids on Windows and cpu usage
IDS version 9.4 tc2 (Windows) Current Onconfig parameters that relate to these settings: MULTIPROCESSOR 1 #NUMCPUVPS 4 SINGLE_CPU_VP 0 #NOAGE 0 #AFF_SPROC 2 #AFF_NPROCS 8 #NUMAIOVPS VPCLASS cpu,num=3 Note sure what a PDQ is. Let me know more detail and I will forward. Cheers,…
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: VPCLASS 'cpu' not enough physical procs for affinity
sdhaya wrote: > The following is the output of psrinfo in our Sun V890 ... > > # psrinfo > 0 on-line since 06/16/2007 15:09:23 > 2 on-line since 06/16/2007 15:09:19 > 16 on-line since 06/16/2007 15:09:23 > 18 on-line since 06/16/2007 15:09:23 > > Ple…
VPCLASS 'cpu' not enough physical procs for affinity
On Jun 22, 11:26 am, Superboer <superbo...@t-online.de> wrote: > you could try: > > AFF_SPROC 0 # Affinity start processor > > Superboer. Will try and let you know... Thanks Dhaya…
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.…
Question on ownership of oninit
I seem to agree with Art's 10 year-old comment (see below) -- basically, if Informix instance is started by root, oninit processes will be owned by root; if started as Informix then they will be owned by Informix. However, at this environment, oninit processes are always owned b…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
IDS on Solaris(spark server)Multiprocessor Setup
On 10/04/07, OMER KHAN <oskhan@i2cinc.com> wrote: > Hello All, > > I want to set up IDS 10.0(FC4)instance on Sun Spark server, which has one 24 > core processor. So i am not sure how should i give the multiprocessor settings > in the onconfig files parameters related to that inst…
KAIO Question
IDS AIO VPs do NOT use OS Asynch IO facilities, they simulate asynch IO for cooked chunks. If you use RAW chunks there should be only a few aio vps configures and onstat -g iov will show one kio thread for each CPU VP. The only way you would not see KIO threads if all of your chu…
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…
Affinity
Andreas Legner wrote: > What do you mean to achieve by AFF_SPROC 17 ? With AFF_NPROCS 7 you'd > need 25 cpus in your machine. > > Did you mean AFF_SPROC 1 rather? > No SUN numbers processors according to which hardware slot their system board is plugged into. In his case CPU #1…
PVU - half a license?
On Feb 1, 7:03 pm, "Neil Truby" <neil.tr...@ardenta.com> wrote: > I don't believe that you can use processor affinity and and NUMCPUVPS to > qualify for sub-capacity licesning. I believe that you have to use an > apporved virtualisation technology to physically isolate the cpus …
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
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: Informix session VS 'oninit' CPU usage
One more thing: you can use onperf to monitor session activity, it could help you a little. "Rupan3rd" <rupan.nospam.3rd@hotmail.com> wrote in message news:n2tYf.49175$nz4.46626@tornado.fastwebnet.it... > Hi Gurus, a question for you. And sorry in advance if it has been already…
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/…
Informix session VS 'oninit' CPU usage
Hi Gurus, a question for you. And sorry in advance if it has been already answered: I cannot find any previous reference to what I am looking for. I use Informix IDS 9.40.UC6 on Sun Solaris 9. Looking at the OS statstics, sometimes it can be observed that 'oninit' process(es) c…
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…
Solaris Dual Core CPU
We do but not on that scale. Our largest server's are only a 4-way and the rest are 2-ways. We run 1.5 to 2 times the number of physical CPU's and have no issues. In fact our development server is a 4-way and we have a total of 14 CPU VP's, they are split among several instances …
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!…
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: MULTIPROCESSOR settings on a multiple CPU server with
On HP, also watch your context switching in Unix, on the cpu's. My previous company used HP, and this was one of our major problems. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Ford, Andrew G Sent: 14 Decembe…
RE: MULTIPROCESSOR settings on a multiple CPU server with
On HP, also watch your context switching in Unix, on the cpu's. My previous company used HP, and this was one of our major problems. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Ford, Andrew G Sent: 14 Decembe…
Re: Upgrading from 9.21 to 10 planning
Migration on same box? Check the migration Guide... http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.mig.doc/mig31.htm It looks like you can go 9.21 -> 10.0 And http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.mig.doc/mig60.htm …
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…
MULTIPROCESSOR settings on a multiple CPU server with
1. http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.admin.doc/admin255.htm MULTIPROCESSOR Specifies that you are running on a multiprocessor computer so I would set it to 1. 2. Not sure so I would benckmark. I would probably go with more Poll threads. Which I…
processor affinity
I am running two instances on a QA server. Can I use processor affinity for both instances if they copy my production instance? Production has 8 processors and 6 virt cpus. RedHat AS3 Linux, IDS 10.00.UC3 Bob Roussey robert.roussey@spiritair.com…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
IDS 10 on REDHAT 4 AS
I can not affinity processors with IDS 10 on REDHAT 4 AS (2.6 kernel) message is "can't affinity VP1 to phys proc 0" The same configuration of IDS 10 on REDHAT 3 AS (2.4 kernel) works fine Is this REDHAT or IDS bug?…
Re: IDS 10 Download?
David Williams wrote: > By the way...I thought NUMCPUVPS,AFF_SPROCS,AFF_NPROCS > and possibly even SINGLE_CPU_VP is depreciated? > > VPCLASS is the new way..sure I saw this in a ONCONFIG file > somewhere (9.40.UC5?) but IDS 10.0 has no mention of > VPCLASS and still has NUMCPUVP…
Re: IDS 10 Download?
David Williams wrote: > By the way...I thought NUMCPUVPS,AFF_SPROCS,AFF_NPROCS > and possibly even SINGLE_CPU_VP is depreciated? > > VPCLASS is the new way..sure I saw this in a ONCONFIG file > somewhere (9.40.UC5?) but IDS 10.0 has no mention of > VPCLASS and still has NUMCPUVP…
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…
IDS 10 Download?
By the way...I thought NUMCPUVPS,AFF_SPROCS,AFF_NPROCS and possibly even SINGLE_CPU_VP is depreciated? VPCLASS is the new way..sure I saw this in a ONCONFIG file somewhere (9.40.UC5?) but IDS 10.0 has no mention of VPCLASS and still has NUMCPUVPS etc!! Perhaps onconfig.std for …
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…
Monitoring CPU usage
Hi, I would change the advice from your book a little and use the "Virtual processor summary" times for class cpu: time cpu-time ------------------------- 00:52:02 108202.91 01:00:22 108251.34 ------------------------- diff: 500 secs 48.43 secs Your cpu vp uses 48.43 cpu …
RE: More CPUVPs than processors
I cannot comment on version 9, but on 7 I've done this for a long time. My current settings are 6 physical cpu's, but 12 virtual cpu's. If you watched my Unix cpu queue, it used to be quite idle, so I over-tuned my virtual cpu's, and the Unix queue went up, and my Informix queue…
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…
Consolidation servers
Diane, It depends some on what else the server is doing, but 5 might be a target -- 1 for the system itself and the other 5 dedicated to Informix. You may also want to tweak the NETTYPE parameter. Other parameters may look like this (these are from a box with 4 CPUs): NETTYPE t…
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'?…
Config for new live system
I suppose I won't be much of a help but I'll try... > ROOTOFFSET 0 # Offset of root dbspace into device We had problems on Solaris 9 with zero offset. We set iz to 100 K and problems dissapeared. I think it has to do something with OS writing some info in fir…
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…
20% CPU utilisation on a 4CPU box
Morning all Informixers... Our hardware is: Windows 2000 Advanced Server (all latest SP's and relevant patches applied) DELL PowerEdge 2650 Servers with 2 x Xeon 2.8ghz multithreaded CPU's (4 virtual) IDS 9.40.TC5 My problem is that whatever we have running on the server, the o…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: ONCONFIG for 9.40 offered for comment
Andrew Hamm wrote: > > AFF_ works well on HP - try 1,3 and make sure the other engines have > NOAGE=0 and AFF_ =0 Ooooo - everyone should read appendix D of 9.40 Admin Reference. Looks like AFF_ parameters are being obsoleted, and a new VCLASS statement is available to pin more …
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: Performance advice
sumGirl wrote: > NETTYPE soctcp,2,150,CPU > NETTYPE ipcshm,2,150,NET CPU processes don't do soctcp very well, and NET processes don't do ipcshm very well. swap this to NETTYPE soctcp,2,150,NET NETTYPE ipcshm,2,150,CPU > RESIDENT 0 …
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: 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…
Re: onunload / onload filesize issues
On Thu, 18 Mar 2004 05:39:42 -0500, Geezer From Freezer wrote: > "Art S. Kagel" wrote: >> >> On Tue, 16 Mar 2004 06:37:34 -0500, Geezer From Freezer wrote: >> >> > I've noticed that onunload will not create a file bigger than the 2Gb >> > file limit. >> > (i.e. its not largefile…
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: Informix, PHP, Apache
Does phpinfo() say --with-informix? Thomas Ronayne wrote: > I've managed to get myself completely confused. Can anyone tell me what > to set and where in httpd.conf and php.ini so PHP can connect to an > Informix data base (an example would be most helpful)? I'm running > Slack…
Informix, PHP, Apache
I've managed to get myself completely confused. Can anyone tell me what to set and where in httpd.conf and php.ini so PHP can connect to an Informix data base (an example would be most helpful)? I'm running Slackware 9.1, Apache 1.3.29, PHP 4.3.4, Informix 7.30.UC5. My onconfig …
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: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
RES: Pentium 4 hyperthreading
Speaking on Affinity Processors, does anyone know if the IDS 9.40 has support for this feature on Linux? AFAIK IDS 7.31 doesn't. I'm using NUMCPUVPS=4 with 2 XEON Processors and it work fantastic. If I configure a single cpu environment my systems loses performances. The Hypert…
RE: Pentium 4 hyperthreading
Ben, With Xeon, I'm using NUMCPUVPS=8 on 4-CPU (real CPU's) Linux box (2 GHz Xeons, 2MB L3 cache). Everything works fantastic. It's not clear to me, whether Linux process scheduling takes into account that some CPU's are 'better' then others. If You set NUMCPUVPS as number of v…
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…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Engine's re-setting
Thanks to everyone, I send the onconfig file's portion about the memory and processores: about the processor: MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps to one N…
Re: VPCLASS 'cpu' not enough physical procs for affinity
"kh teoh" <khteoh2001@yahoo.com> wrote: > I'm running IDS 9.30.UC2 on Redhat 7.1 in HP Netserver LXr8500 PIII > Xeon-700. The server has 4 processors. In my onconfig file I've the > following settings :- > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for > multi-…
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…
VPCLASS 'cpu' not enough physical procs for affinity
khteoh2001@yahoo.com (kh teoh) writes: > I'm running IDS 9.30.UC2 on Redhat 7.1 in HP Netserver LXr8500 PIII > Xeon-700. The server has 4 processors. In my onconfig file I've the > following settings :- > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for > multi-…
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…
CPUVP overloaded but physical CPU only 50% used
Since you can add and remove virtual CPU's with the onmode command, you could try it and see if the physical CPU goes up and the number of ready threads goes down. We have a Sun V880 with 4 900 MHz CPU's and run with the number of virtual CPU's equal to the number of physical CP…
Informix under Linux - real crap !
Hi Guido We have been successfully testing on a 2 physical processor SMP box with Hyper Threading turned on! (so cat /proc/cpuinfo shows 4) This can be verified nicely with top command or with onstat -g glo Individual virtual processors: vp pid class usercpu …
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Data Warehouse Performance Tuning
It's been a while since I've worked in a data Warehouse environment, so I was wondering if someone could help me with some ONCONFIG parameter settings. As much as I can remember, they don't look correct. We are on a dedicated, 64-bit, 4-CPU HP server w/ 1 GB of RAM, of which 834M…
cpu time
----- Original Message ----- From: "EML" <edmund.lajara@nokia.com> To: <ids@iiug.org> Sent: Tuesday, May 20, 2003 13:46 Subject: cpu time [1180] > I've been observing a machine with IDS and application on same HP-UX platform. The machine has 8 cpu, Informix affinity to 2 process…
Re: Bloody ERP schema
Oxow wrote: > Hi! > > We changed Informix version from 7.30 to 7.31.FD2X1 on AIX 4.3.3 and > after > that we have regonised some performance problems. > > DBSERVERNAME sapshm # Name of default database server > DBSERVERALIASES saptcp # List of alternate dbservernames …
Re: Questions re NUMCPUVPS, PDQPRIORTY, AFF_NPROCS and AFF_SPROC
Hi 1) As for my experience if you have only DB on your server and you do not have large WAIT IO define all cpu to informix. If you have a lot of users and you are using NET VP check there cpu usage, maybe you should spare one or two cpu for them. 2) Probably the first SQL use i…
Questions re NUMCPUVPS, PDQPRIORTY, AFF_NPROCS and AFF_SPROC
Hi, Not sure if anyone can shed some light on a couple of questions I have about Dynamic Server and NUMCPUVPS, PDQPRIORTY, AFF_NPROCS and AFF_SPROC ? Firstly our setup: We are running a data replication setup (2 systems each running Dynamic Server 9.21-FC3x-1 on HP-UX 11.0). …
Re: onconfig.ows - MULTIPROCESSOR
Setting it to 0 can improve overall system performance as then when a VP encounters a latched resource it will suspend the current thread and wait for it to be cleared. With MULTIPROCESSOR on the VP will spin for a while before suspending on the assumption that the latch may belo…
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…
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 …
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 …
3 onconfig parameter questions, help
Have you tried another parameter change?: RTFM=ON <mr_potato_head@my-deja.com> wrote in message news:916inu$fss$1@nnrp1.deja.com... > Hi, > I have an E4500 running solaris 7 with 4 cpu's and running informix > 7.31. Can anyone explain to me the results of changing these 3 >…
Re: procesor affinity and data replication
edem wrote: > > Can i set procesor affinity on secondary server in data replication > pair? > When I set AFF_SPROC and AFF_NPROCS, after reboot there is no > information about affinity in logfile (usually on standard server > information is after "On-line" message, but on seconda…
procesor affinity and data replication
Can i set procesor affinity on secondary server in data replication pair? When I set AFF_SPROC and AFF_NPROCS, after reboot there is no information about affinity in logfile (usually on standard server information is after "On-line" message, but on secondary there is of course no…
Re: AFF_SPROC questions ..
In article <90gs85$fot$1@news.xmission.com>, Sinha, Niraj <niraj.sinha@BondBook.com> writes > >Hi Guys, > >I have following parameters : > >NUMCPUVPS 4 >AFF_SPROC 0 >AFF_NPROCS 0 > AFF_NPROCS = the number of processor which you are using processor affinity on. In this case 0 s…
Re: AFF_SPROC questions ..
From: "Sinha, Niraj" <niraj.sinha@BondBook.com> > >I have following parameters : > >NUMCPUVPS 4 >AFF_SPROC 0 >AFF_NPROCS 0 > >Now, does it mean that I am not using Processor affinity as AFF_NPROCS = >0 The above is correct. _____________________________________________________…
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: affinity process problem
My box does the same, stress about it not. Aside from that, , cpu_state is not a command I've ever heard of, what package is it in? brett samir BADAOUI wrote: > > Hi, > please how can I know that I am using affinity process in my server (in the > informix side). > my config var…
RE: affinity process problem
Does your Informix release support the AFF_SPROC and AFF_NPROCS parameters on AIX? From: http://www.informix.com/informix/resource/pubs/ids/0731uc6/ibm0731m.txt ================================= MACHINE SPECIFIC NOTES …
affinity process problem
Hi, please how can I know that I am using affinity process in my server (in the informix side). my config variables AFF_SPROC and AFF_NPROCS are positionned to respectivly 1 and 2. but I get the following message in the log file : VPCLASS 'cpu' not enough physical procs for affin…
You've heard it all before, cont.
I'm posting some other onstat commands that may help. Informix Dynamic Server Version 7.31.FC4 -- On-Line -- Up 3 days 09:44:13 -- 2545024 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 261671478 74154240 9591835411 97.27 55502789 5144…
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: question for affinity (AFF_NPROCS,AFF_SPROCS)
From $INFORMIXDIR/release/en_us/0333/IDS_7.3 on AIX: 7. The Processor Affinity feature (ONCONFIG variables AFF_SPROC, AFF_NPROCS) that allows the pinning of CPU VPs to physical processors in a multi-cpu configuration is NOT supported in this release. On AIX 4.2.1, the b…
question for affinity (AFF_NPROCS,AFF_SPROCS)
hi gurus, I am using informix 7.30 under AIX 4.3.2 and under HP-UX, how can I know if my systems support the use off the configuration variables AFF_NPROCS et AFF_SPROCS ? thinks a lot _________________________________________________________________________ Get Your Private, Fre…
Re: server 2000, cpu affinity problem
From: <tfhkcyt2000@taifuji.com> > >I installed Informix Dynamic Server 2000 in Red Hat 6.2 4 cpu >intel server, after oninit , I inspected /usr/informix/etc/online.log > >found there are error message for cpu affinity >the message is > > 11:14:11 On-Line Mode > …
RE: server 2000, cpu affinity problem
You are telling INFORMIX use 4 CPU's start at processor 1, the second processor. But you told INFORMIX to use only 1 CPU "NUMCPUVPS=1" out of 4 available. So set NUMCPUVPS=3 {4 for DDS} AFF_SPROC=1 {If the OS supports it, else = 0} AFF_NPROCS=3 {If the OS supports it, else = 0} …
server 2000, cpu affinity problem
Small note. Linux is not supports 'processors affinity' (even for latest kernel ), so setting AFF_SPROC and AFF_NPROCS , will not have effect. See IDS2000 release notes for Linux. Good luck. Sergey. <tfhkcyt2000@taifuji.com> ����� � ���������:8tdj5c$alb1@imsp212.netvigator.…
Re: checkpoint problem
tnx.....see below Chuck Renaud wrote: > > Comments below... > > >> Move to 7.31.UC5.. > >No move, always at 7.31, just a restart > > I think he was suggesting an upgrade to UC5, which I concur with. We are actually in the middle of a move to 9.21 but it will not go into product…
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: no tli vp class
Run onstat -g ath, and look for the tli poll (tlitcppoll) thread. If you did not specify anything in the NETTYPE parameter the tli poll thread will be running in the CPU vp. If you want the tli poll thread to run on a TLI vp, specify it in the NETTYPE parameter. Example: NETTYP…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: Several instances of IDS 7.3X
Ty O'Kelly wrote: > > What role (if any) do parameters concerning multi-processor systems play in > multiple residency? If both onconfig files contain the following values (for a > dual processor system) will there be any kind of contention between the two > instances? > > MULTI…
Re: Several instances of IDS 7.3X
What role (if any) do parameters concerning multi-processor systems play in multiple residency? If both onconfig files contain the following values (for a dual processor system) will there be any kind of contention between the two instances? MULTIPROCESSOR 1 # 0 …
Re: Several instances of IDS 7.3X
What role (if any) do parameters concerning multi-processor systems play in multiple residency? If both onconfig files contain the following values (for a dual processor system) will there be any kind of contention between the two instances? MULTIPROCESSOR 1 # 0 …
Re: Performance goes down - help please!
I also just noticed that you have NOAGE set to zero (0) which is a real NO-NO on Solaris which is very aggressive about aging long running processes. Set NOAGE 1. Also suggesting: RESIDENT -1 (or 1) LBU_PRESERVE 1 Art S. Kagel Serge Moisseyev wrote: [SNIP] > RESIDENT …
performance with very active threads
I forgot to include my onconfig file. From a posting i read the other day, I can see there a few things I can do the next time I restart the engine: unset TBLSPACE_STATS and reduce my PHYSFILE size. PHYSDBS rootdbs PHYSFILE 10000 LOGFILES 21 LOGSIZE …
Informix 9.21 VPCLASS question
Hi everyone, We are in the process of migrating to Informix v9.21. In the Informix Administrator's Guide, it mentions that Informix sugguests to use VPCLASS parameter instead of AFF_SPROC, AFFNPROCS, NOAGE, NUMCPUVPS, and NUMAIOVPS parameters. Does anyone have any experience o…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
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: CPU VP's
>Also I want ensure that only 4 physical CPU's are used (for everything >and there are 8 on the box) but I don't want to bind any process to a >certain CPU (I have already set the numcpuvps 4 but I also have 2 >aiovps) . If I use the parameter AFF_NPROCS - this specifies the num…
Re: CPU VP's
From: Bridget Reitsma <b.reitsma@auckland.ac.nz> > >What is the rule of thumb regarding the number of CPU VP's. One per CPU > >and not more than the total of CPU's on the machine? And how does this >tie in with 'a virtual processor is a piece of work for a CPU' Admin >Guide for…
CPU VP's
Hi What is the rule of thumb regarding the number of CPU VP's. One per CPU and not more than the total of CPU's on the machine? And how does this tie in with 'a virtual processor is a piece of work for a CPU' Admin Guide for Informix Dynamic Server pg 9-5. If my understandi…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
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…
Re: AFF_SPROC + AFF_NPROCS
D.Penfold@Libertel.nl wrote: > > Does anyone out there have any warnings/advice re: setting the above > parameters? You really need to supply your platform, engine version, etc. details. Different platforms display different characteristics. You could then get some actual experi…
RE: AFF_SPROC + AFF_NPROCS
Dominic, My particular experiences has seen a significant performance improvement at all the sites I've set the AFF's parameters. I set AFF_SPROC to 1 rather than 0 - just in case there are special requirements for the first CPU and AFF_NPROCS to one less than the total number. I…
Re: AFF_SPROC + AFF_NPROCS
From: D.Penfold@Libertel.nl > >Does anyone out there have any warnings/advice re: setting the above >parameters? I'm administering a system at the moment that has 6 cpus, and Sometimes they don't work. :-) >NUMCPUVPS set to 5, but neither of the AFF parameters are set. onstat -…
RE: AFF_SPROC + AFF_NPROCS
You did not state your platform. These parameters are not supported on all platforms. Their use should reduce UNIX overhead caused by context switching. They should not cause workload to be spread over different CPU VPs. Spreading NETTYPE connections over all CPUs can help to sp…
AFF_SPROC + AFF_NPROCS
Does anyone out there have any warnings/advice re: setting the above parameters? I'm administering a system at the moment that has 6 cpus, and NUMCPUVPS set to 5, but neither of the AFF parameters are set. onstat -g glo shows very uneven cpu vp activity, and top shows very uneven…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
NETTYPE
Pablo Herrero Fernández wrote: > > Hello everybody. > We have a DEC-UX Alpha8200 with 2 CPU and Informix 7.31. I have the next > values in ONCONFIG: > > NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype Make the above: NETTYPE soctcp,2,250,NET # 2 listene…
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…
How to Take advantage of a multi-processor system using informix?
"S. Martins" wrote: > > How to Take advantage of a multi-processor system using informix? > Do I have to make some special configuration in the Informix Database Engine > to achieve the best performance from a dual processor system? If you only have two processors then IDS does …
Bug 104328 ? Bug 121447 ?
In article <81j41o$ch7$1@news.xmission.com>, michael martin <michael_martin@komatsu.co.jp> writes > >Hi list, > >Here I go again. > >My question is: Has anyone encountered Bugs 104328 and/or 121447 >and if so what is the fix ? > Not encountered but I belive they are fixed in 7.…
Processor Affinity on a 2 CPU HP9000
Is processor affinity supported in v7.22 on HP-UX 10.20? It is in v7.24, but wasn't in (I think) v7.13. Running v7.24 on HP-UX 10.20 on an HP9000 with 2 processors, and noticing long ready queues with onstat -g, I got good performance improvements by adding a second cpu vp (in …
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: Long spins or onstst -g spi. Need any information.
Eugene Nechayev <4new@my-deja.com> wrote in message news:80bvko$so0$1@nnrp1.deja.com... > Art and William thanks for your responses > > Now it's more clear, and after Art's explaining line by line > my onstat -g spi output it's more understandable and useful for me > than after r…
Re: Processor Affinity Sun 4500
Juan Ventua wrote: > Hello everybody!!! > > I have to configure two sun machine with following characteristics: > 2 sun 4500 > Solaris 2.6 > 12 cpus per 4500 > 12 gig memory per 4500 > 8 instances (4 instance per 4500) > Informix Universal Server 9.14 > > In your experience. I …
Processor Affinity Sun 4500
Hello everybody!!! I have to configure two sun machine with following characteristics: 2 sun 4500 Solaris 2.6 12 cpus per 4500 12 gig memory per 4500 8 instances (4 instance per 4500) Informix Universal Server 9.14 In your experience. I should configure binding CPU VP's to pro…
Re: Poor performance for a $750,000 box
"Art S. Kagel" wrote: > It > started when I noticed that 90% of the CPU time my IDS engines were using > was being used by CPU VP #1 and that the CPU that I had pinned that VP to > was running at 98% ALL the time. Uhm why not turn off processor affinity? Then see what happens…
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…
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…
Re: Affinity
FYI.. On Solaris, if one want to use O/S Process binding then do following - onstat -g sch will give you the pid of CPU VP - Use "pbind -b" command to assign the pid of CPU VP to specfic CPU which you can collect from "mpstat" command. - Also if you want to see that your CPU …
Affinity
Hi , I am looking more information about the use of affinity. I have a Sun 2.6 with 14 cpus and the definition listed below. Does anybody can help where I can learn more about it ? Thanks in advance, fred > NOAGE 1 # Process aging > AFF_SPROC 0 …
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Re: Online Config Changes
From: "Carlson@WHSmith" <carlson1@bellsouth.net> > >Not necessarily. The variables can be reconfigured within the ONCONFIG >file while the engine is up; they won't take effect until the engine is >bounced. There's quite a bit of stuff that can be set dynamically. For example, o…
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…
V7.31 Processor Affinity
Can someone please give me some definitive info on processor affinity. We are running IDS V7.31 on HP-UX 10.20. Database of 440 tables, mainly OLTP, some DSS-type queries, 4GL applications running on the same machine as the DB server, all raw disk, fragmentation by expression use…
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…
The ready queue Full but Unix not busy
We are experiencing an engine go-slows with all queries take much longer than they should. The ready queue (onstat -g rea) constantly shows 10+ threads, but Unix is only 30% busy (no waiting on IO) ? Can anyone explain the lngspins column ? Geoffrey.poole@ogs.co.uk <mailto:Geoffr…
RE: NET or CPU VP Class : confusing NETTYPE recommendations
Stephen Faehn wrote: > Mario, > My company is running a SUN E4500 in our production environment as the DB > server/CI. > We are running SAP R/3 (3.1H). > The E4500 has 6 Processors and 4 gig memory. > We have 3 E3000 application servers connected to the CI. > > Here is what I ha…
Re: INFORMIX and utilization of system resources on HP-UX 10.20
Vic Goldberg wrote: > > Without doing an exhaustive analysis, I've noticed a number of problems with your onconfig. > > NOAGE 1 # Process aging > AFF_SPROC 2 # Affinity start processor > AFF_NPROCS 2 # Affinity number…
Re: Re[4]: Long checkpoints (LRU_xxx_DIRTY/LRUS)--NETTYPE va
Hi, > Thanks already for your recommendations ! Further details follow : > > PHYSICAL LOG OVERFLOW : > ------------------------ > We never have checkpoints caused by the physical log being 75% full as > our physical log is so big (250M). Physical log overfl…
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 ?
I have 2-processor SUN and 2VP: Virtual processor summary: class vps usercpu syscpu total cpu 2 40.46 1.46 41.92 aio 1 0.03 0.14 0.17 tli 1 0.12 0.31 0.43 lio 1 0.0…
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…
RE: Processor affinity
Yes, its possible to determine which physical CPU's the VP's run on. We are running Sun Solaris as our O/S and it looks like you might be also. Using the pbind command, I can list which physical CPU's process are bound to. Then, using onstat -g sch, get the pid's of the oninit pr…
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…
Processor affinity
Hi, Is it possible to determine which physical CPU's the VP's run on. I have 6cpu vp's running on an 8 processor machine,with CPU vp affinity. The message log reads " Can't affinity VP 1 to phy proc 0 errno 4,Can't affinity VP 3 to phy proc 0 errno 62...." errno 2 is "interrupt…
RE: Processor Affinity
On AIX you can set processor affinity with the bindprocessor command. We run a script at start-up time to accomplish it. -----Original Message----- From: David Meyer [mailto:dmeyer9@email.msn.com] Sent: Wednesday, February 17, 1999 23:51 To: informix-list@iiug.org Subject: Re: P…
Re: Processor Affinity
Mike, I tried to do this on an AIX system and it did not support it. I found out that some versions of Solaris did. My experience is that this is more of a programming capability. Where you can kick off threaded processes and bind them to a processor. Because of this (for so…
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)…
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. Care to elaborate, and answer a long unanswered question: How doe…
NUMCPUVPS > 0, AFFINITY not set
The NUMCPUVPS value indicates the number of CPU VP's that are started up at run time. As you are running 4 CPU machine, 2 CPU VP's is not a problem. AFF_SPROC & AFF_NPROCS only come into effect if processor affinity is supported on your platform. It 'pins' a CPU VP to a physical…
Processor Affinity
Does anyone have any experience and recommendations regarding the use of processor affinity for a multi-cpu Sun E6500 database server supporting a high traffic web site running IDS 7.30UC3. I have heard arguments for and against its use where I am attempting to reduce or elimina…
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…
RE: onstat -g sch , Busy Waits ?
According to "Informix, DBA Survival Guide" by Joe Lumbley, on page 260, Monitoring Virtual Processors, "When a CPU VP does not have a thread to run, the process performs a 'busywait' . This is a loop of instructions designed to wait a short time". So comparing CPU VP Number 3, …
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
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 …
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: Follow-up: CPU poll threads ...
Schaeflein, Paul wrote: > > Would you please describe the difference between NET VPs and CPU VPs? And > why is one better than the other? [Original reply SNIPPED] OK. Basically a NET VP (shown as class tli, soc, ipx, shm, str in the onstat -g glo report) is a Virtual Processor …
Re: Best database for web backend on Linux?
In article <70tntl$ftl$1@news.bctel.net>, "Thor" <thor@echidna.net> writes: >There are 2 main ways that systems use multiple CPUs to speed query >performance. The 2 main methods are spearheaded by Sybase and Oracle. >Sybase forms data affinity to a processor, while oracle defaul…
Re: Best database for web backend on Linux?
There are 2 main ways that systems use multiple CPUs to speed query performance. The 2 main methods are spearheaded by Sybase and Oracle. Sybase forms data affinity to a processor, while oracle defaults to using a queue, such that all processors can perform parts of a query in p…
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…
hp-ux VCPU Bind processors. Does this work ?
Hi, I am running hp-ux 10.20 with Informix 7.24UC6 I have used the bindprocessor comand on RS6000s before to pin VCPUs to processors before with great success ( Thanks Art K ! ) Processor affinity is not supported on hp-ux 10.20. Is this because hp-ux cannot pin processes…
Re: processor affinity
jblatz@worldnet.att.net wrote: > > Our Unix machine has 4 processors. According to the release notes for Online > ver 7.24, my operating system supports Affinity. However, when I set the > affinity parameter in the onconfig file to anything but 0 (I forget the exact > name of t…
processor affinity
Our Unix machine has 4 processors. According to the release notes for Online ver 7.24, my operating system supports Affinity. However, when I set the affinity parameter in the onconfig file to anything but 0 (I forget the exact name of the parameter), I get a message in the onl…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
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: CPU vp total time
Normand Bedard wrote: > > Hi, > We have a SUN SPARC 2000 with 8 CPU's, 7 of them are bind to Informix. > We have Informix 7.23 on Solaris 2.4. After running the command "onstat > -g glo" we get a total cpu time of 161668.46. After 60 seconds, we run > the command again an…
Re: Difference between Workgroup server and Dynamic server
Noel Griffin wrote: > > IDS (formerly DSA) and OWGS are virtually identical. On systems with four > processors or less there is NO performance difference!!! The differences > are as follows: > > 1. OWGS is limited to 4 CPU servers (who cares, tell me how many system you > known…
CPU vp total time
Hi, We have a SUN SPARC 2000 with 8 CPU's, 7 of them are bind to Informix. We have Informix 7.23 on Solaris 2.4. After running the command "onstat -g glo" we get a total cpu time of 161668.46. After 60 seconds, we run the command again and get 161535.23. 161668.46 - 161535.23 =…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: NUMCPUVPs,ONINIT
In article <6nqntp$qad$1@news.xmission.com>, Sadagopan, Sathish <sadagop0458@att.com> writes > >Hi, >Two questions. >1) Values AFF_NPROCS,AFF_SPROC,NUMCPUVPS have been set to take >advantage of 6 cpu's.Now, when two of the cpu's are unavailable due to h/w >failure.What happens to…
NUMCPUVPs,ONINIT
Hi, Two questions. 1) Values AFF_NPROCS,AFF_SPROC,NUMCPUVPS have been set to take advantage of 6 cpu's.Now, when two of the cpu's are unavailable due to h/w failure.What happens to processor affinity ? "glo" option still shows 6cpu vp's running. 2) What are the activities that o…
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: Novice needs tuning help!
In article <3572124d.141336500@news>, David Kosenko <dkosenko@monmouth.com> writes >Also sprach David Williams <djw@smooth1.demon.co.uk> : >: Is this a single cpu machine? How fast is the cpu? >: Also if NUMCPUVPS=1 set SINGLE_CPU_VP to 1. >: >:NOAGE 0 #…
Re: Novice needs tuning help!
Also sprach David Williams <djw@smooth1.demon.co.uk> : : Is this a single cpu machine? How fast is the cpu? : Also if NUMCPUVPS=1 set SINGLE_CPU_VP to 1. : :NOAGE 0 # Process aging : : Try setting this to 1 : :AFF_SPROC 0 # Affinity …
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
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…
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: NUMCPUVPS settings for a four-processor server
Bill Border wrote: + We have found that in the case of systems with very fast CPU's that + there are times that you need to set NUMCPUVPS to more than the number + of physical CPU's. We have a T600 with 10 CPU's where we configure + 15 CPU VP's and we still cannot drive the al…
NUMCPUVPS settings for a four-processor server
I'm migrating two Informix database servers to a Sun Ultra E4002 with 1.5 GBytes of memory and 4CPUs. One server is heavily-used and performance is optimal, the other is lightly used. I am planning to set up the heavily-used server with NUMCPUVPS=3 (one less than the actual num…
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…
Re: KAIO
rt wrote: > > Whats the real story on KAIO and HP 10.20. Most posts list better > performance with KAIO. When post report decreased performance it > usually is fixed by correcting the configuration. Is there a split > camp on KAIO?? The concensus is that KAIO is better than AIO …
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Major performance problems with Informix Online
On Sat, 25 Oct 1997 09:36:44 +0100, David Williams <djw@smooth1.demon.co.uk> wrote: ... cut ... >>>2. NUMCPUVPS looked ok, even low, I've heard use (CPUs - 1) as the rule? >> >> If your computer have something else to do except to run the >>database you should leave som…
Re: Informix hogging CPU
The multithreading architecture of DSA uses the virtual processors scheme in which we have the CPU virtual processors (they are called CPU VPs because they run the cpu intensive threads and they are supossed to make non-blocking system calls). There's allways a low priority probl…
Dual Instances
We have an RS/6000 4-CPU SMP machine running AIX 4.1.4 and Informix version 7.12.UC2. We also have another RS/6000 machine (single processor) running AIX 3.2.5 and Informix version 5.02.UC9. What we'd like to do is to upgrade our version 5.02 to 5.08 and install it as another ins…
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…
Two Instances on Multiple CPU Machine
Hi , I have a quick couple of questions. We have a SUN machine with SUNOS having 4 CPUs. There is already one instance of Informix(7.2x) up-and-running which uses 2 cpus (1 and 2) by setting AFF_SPROC etc and all other parameters. The second instance of Informix has been config…
Re: Informix and NOAGE
Saeed Talebbeik wrote: > > Both NOAGE and processor affinity can boost the performance. > However look into the machine notes of your platform to see if these two > features are really supported. Apparently on HPUX NOAGE is supported. > > I suggest to experiment with NOAGE and se…
Re: What is the best platform for Informix 7.x?
David Williams wrote: > > In article <33bbe71d.24655512@gate.idg.no>, Nils Myklebust > <Nils.Myklebust@idg.no> writes > >Michael Silver <michael.silver@telequestcorp.com> wrote: > > > >:What is the best platform for Informix Online? We currently run on HP-UX > >:10.01, and have …
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…
What is the best platform for Informix 7.x?
What is the best platform for Informix Online? We currently run on HP-UX 10.01, and have a ton problems. HP has problems with shared memory, aging, and processor affinity. Sun has been recommended since Informix development is done on Sun, and then ported over to other platfor…
Re: OnLine DS installation
In article <5lsk1k$p82@cssun.mathcs.emory.edu>, "Walter S. Tyszka" <walt@wst.b30.ingr.com> writes >} When having two instances of OnLine DS running on same machine will I >} have to edit the onconfig parameters that deal w/shared memory(SHMBASE >} etc.)? Yes you will need two …
Re: OnLine DS installation
} When having two instances of OnLine DS running on same machine will I } have to edit the onconfig parameters that deal w/shared memory(SHMBASE } etc.)? } Also when dealing w/processor affinity and multiple instances of OnLine } Should I set AFF_SPROC 0 for on instance and 1 for…
OnLine DS installation
When having two instances of OnLine DS running on same machine will I have to edit the onconfig parameters that deal w/shared memory(SHMBASE etc.)? Also when dealing w/processor affinity and multiple instances of OnLine Should I set AFF_SPROC 0 for on instance and 1 for the other…
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…
SCO Unix and Informix 7 Performance
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 used as OLTP (80%), our onconfig says: MULTIPROCESSOR 1 NUMCPUVPS 1 LOCKS 300000 BUFFERS …
Re: Informix 7.22 pdq questions and ONBAR problems
On 9 Apr 97 at 1:21, markc@osem.co.il wrote: > 1) Performance with PDQ > So far the only solution is I run informix with only 2 out 3 cpus > leaving one for unix work, but this is a great waste as the unix work > only needs about 20% of one cpu and not all of one. Or to only en…
Re: Processor Affinity
Laurence E. White wrote: > > Sean, > > If your HP is strictly a database server, I would try 4 or perhaps even 5 > CPU VPs. > Larry > > P.S. I have not seen the use of Affinity improve performance anyway. In fact, I don't think affinity is supported under HP-UX Ian…
Re: Processor Affinity
Hi there, the only real problem I have had is when there are system calls within SPL triggers etc. The system calls are also affinitied to the processor where they were generated. This can basically leave real spare capacity on the other processors. ESQL/C programs can usuall…
Processor Affinity
Sean, If your HP is strictly a database server, I would try 4 or perhaps even 5 CPU VPs. Larry P.S. I have not seen the use of Affinity improve performance anyway.…
Re: Processor Affinity
We are running 7.21 on HP-UX, and although it does not support processor affinity per the 'documentation', we had an Informix rep give us some code that actually binds a certain process to a specific processor. When we tried this, we had 6 processors and were running 3 CPU VP's.…
Re: Processor Affinity
David Williams wrote: > > In article <5daceu$sun@cssun.mathcs.emory.edu>, Jon C Vemo > <jvemo@cyberspace.com> writes > >At 08:52 AM 2/5/97 -0500, Steve Romankiw wrote: > > >>Below are setting taken from my onconfig: > >># > >># Our Sun server has four processors > > Sounds like…
Re: Processor Affinity
In article <5daceu$sun@cssun.mathcs.emory.edu>, Jon C Vemo <jvemo@cyberspace.com> writes >At 08:52 AM 2/5/97 -0500, Steve Romankiw wrote: >>Our Sun 4000 server supports processor affinity. Because Sun supports >>this option, I have configured our On-Line instance to recognize th…
Re: Processor Affinity
At 08:52 AM 2/5/97 -0500, Steve Romankiw wrote: >Our Sun 4000 server supports processor affinity. Because Sun supports >this option, I have configured our On-Line instance to recognize this >option. Our present user count is low, roughly 50 concurrent users. >Beginning next wee…
Processor Affinity
Our Sun 4000 server supports processor affinity. Because Sun supports this option, I have configured our On-Line instance to recognize this option. Our present user count is low, roughly 50 concurrent users. Beginning next week, we will be jumping to over 300 concurrent users. …
Re: MULTIPROCESSOR OPTION 7.13
In article <327fa20d.27552573@news.netline.net>, Allen Jantzen <allenj@ndr.com> writes >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 th…
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…
Re: MULTIPROCESSOR OPTION 7.13
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-processor computers, you should only run one CPU virtual > processor because the overhead of synchronizin…
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: 2 CPU VP's
Chao Y. Din wrote: > > 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 Informi…
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…
Re: HP K200 and Online 7
Jose da Fonseca <railit@icon.co.za> writes: > > 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 > <snip> > We are running an HP k200 (dual 100 mhz processors) with > about 560 M…
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: onstat -g questions
On 22 Apr 1996, Rajiv Jauhari wrote: > Has anyone used the "onstat -g sch" and "onstat -g spi" > commands to help tune the performance of Informix 7.1 on an SMP? > If so, can you explain the exact meanings of the various columns? I recently made an adjustment based on the info …
<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 …
Processor Affinity prob on 2cpu SparcServer
hi, i've recently found a bug in the 7.1X online server, and want to know if anyone else has run across this. it has been listed as a bug with support, but i don't know what kind of time frame to expect a fix here. on the sparcserver 20, there are two slots for cpus. you ca…
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…
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?…
Re: Why several oninit processes in ver 6.0?
In article: <3eke1u$65f@eos.ap.org> malhotra@eos.ap.org (Rajesh N. Malhotra) writes: > > > Informix Gurus, > > When we initialize Informix 6.0 using the oninit (or the tbinit) > command, there are seven processes started. Any reason why so many? At > present we are using Online…