Oninit® Archive
Results for “onstat -g rea”
12.10.FC15W1AWE Blocked in LONGTX
The way automatic DYNAMIC_LOGS works is: a flag is being set when it looks like the system might be running out of usable log space, then the so called periodic thread will submit a task to the db scheduler to get a log added. All this, as you might guess, doesn't work instanta…
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 ------------------------------…
Community call 15 March 11:00 ET discussion thread
This is a discussion thread for the Community Call scheduled on March 15 at 11:00 AM Eastern Time. Please use this thread to share your thoughts, ask questions, and provide feedback on the topics discussed during the call. Some of the topics we will cover during the call include:…
How many aio/KAIO
As for AIO VPs, you will likely need between 2 and 6 AIO VPs with KAIO enabled and DIRECT_IO set to 4 (temp dbspaces processed with KAIO) rather than 0 or 1 if your temp dbspaces are not on RAW disk. If your temp dbspaces are cooked and DIRECT_IO is set to 1, you may need more. A…
Informix NUMA shared memory access
Are there anyone running Informix on VMWare, and also on HP SuperDome Flex? Or any NUMA architecture at all? I'm interested in shared memory access patterns across the NUMA nodes. We are running an instance with approximately 400GB of shared memory on an HP SuperDome Flex, Intel …
RE: LIKE and Regular Expressions AKA regex in SQL
If the scheduler is not running you will have to install the REGEX blade manually using the API function for installing datablades. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer:…
RE: LIKE and Regular Expressions AKA regex in SQL
Art cautioned: > Calling the REGEX_MATCH() function will cause the engine to auto-install the regex datablade that supplies the function. I wonder who will notice that? I added it to my FragmentList.pm Perl module (not yet on iiug, I think) but afterward got my hands on the lates…
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…
Using complete CPU core instead thread
Hi, I'm not sure I completely understood the original question. Anyway, here's some (not too much in-depth) explanation that may be helpful: Informix has a homegrown implementation of multi threading. (This is mainly because at the time the Posix thread implementation first wa…
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.…
DS_NONPDQ_QUERY_MEM not changing
It's working for me in 12.10.FC8W2: $ onstat -g mgm IBM Informix Dynamic Server Version 12.10.FC8W2 -- On-Line -- Up 00:01:23 -- 165016 Kbytes Memory Grant Manager (MGM) -------------------------- MAX_PDQPRIORITY: 100 DS_MAX_QUERIES: 2 DS_MAX_SCANS: 1048576 DS_NONPDQ_QUERY_MEM…
RE: Threat : swth:sbt subclass lpgsrc ol 796 UTF-8
If memory servers me correctly this has to do with = looking at log pages for replication and nothing to do with Memo= ry pages. lpsrc --> Log Page Source. John Miller =0A=0A =0A-------- Original Mes= sage -------- =0ASubject: Threat : swth:sbt_subclass_lpgsrc_ol_796 [401=…
Threat : swth:sbt_subclass_lpgsrc_ol_796
Original post: Platform : AIX 7 Informix version: 11.70.FC7W3XC Config : 1 primary, 1 secondary and 4 RSS Note : We do turn on the large page on AIX level I run onstat -g rea -r 1 and occasionally see the threat name swth:sbt_subclass_lpgsrc_ol_796 Questions: 1) What is this …
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…
IO performance issues
onstat -g mgm IBM Informix Dynamic Server Version 12.10.FC6 -- On-Line -- Up 11 days 18:00:30 -- 10595476 Kbytes Memory Grant Manager (MGM) -------------------------- MAX_PDQPRIORITY: 100 DS_MAX_QUERIES: 6144 DS_MAX_SCANS: 1048576 DS_NONPDQ_QUERY_MEM: 256 KB DS_TOTAL_MEMORY: 6…
Re: RE: onstat -g glo: cpu efficiency
My recommendation would be to disable the four threads per core and reduce that to 2 threads per core (or turn them off entirely). You will get better throughput from the CPU VPs that way and so fewer spins waits. You already have many more NET VPs configured than you need. IBM …
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…
IDS Growth vs Enterprise
Larry: The things to look at would be: - onstat -g rea -r 1 Are the same sessions in the ready queue for more than a second and you are maxed out at 16 CPU VPS on 16 physical cores (not hyper-threads)? - onstat -g rea typically shows more than a couple of sessions waiting f…
Re: Database slow - drop and recreate indexes
From what I'm reading you've gone down the route of rebuilding indices and other actions without really knowing what the problem is. Of course there could be something I don't know here. I would hold off any other actions until you know what's wrong. Do you have a large ready qu…
Mutex logs on logical log flip
I did take a look at the PMR... The number of CPU VPs was a bit of a shock... I've seen your other email.... I have some reservations regarding the fact that T5 has a lot of threads but not as much "internal pieces" so satisfy a real database process in each of those "threads". B…
Socket listener stuck behind non-yielding thread
I'm re-building all 1,900 foreign keys on a system, sometimes a many as 5 such jobs are running concurrently. Occasionally we are getting -27001 failures. I trapped one this morning: dbschema -d hangs and eventually fails -27001 Read error occurred during connection attempt. L…
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)…
Enable or Apply Auto Update Statistics
Hi All, Here is email communication between Ben and myself. I hope this will help someone who really want to play with AUS feature. -------------------------------------------------------------------------------- ---------------------------------------------------------- Hi Ben…
Panic analysis
Folks, IDS 12.10 FC4, Linux 6. The following log is the only info we have about the crash ( no other info dumped ) You can see it was struggling to add lot memories segments before Panic .... The Panic was a also VERY curious one with some unexpected process terminated ... Wha…
memory thread ... VIP status ?
11.70.FC7W3. Yesterday I was profiling our clients very busy instance where the ready queue was getting very long at times. What I did notice was that the memory thread was consistently getting back on top of the ready queue no matter what while it was long. It would vanish mome…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Fatal error in ADM VP at mt.c:14100
Hi, We have faced issue on almost of all instances after giving following error . 00:47:24 Fatal error in ADM VP at mt.c:14100 00:47:24 Unexpected virtual processor termination, pid = 5482, exit = 0x9 Kindly guide us what cause this issue ? We are using IDS 11.50FC8W3…
Update statistics issue
If you would like you large tables running update statistics = low to run very fast then you need to read the link below. I= n general this makes each index which update data statistic low is run o= n take about 1 minute (unless there is great data skew). http= ://www.ibmn…
Licensing : VPU needed ?
The calculation of the VPU depends on the processor, the IBM computer can be found here: https://www-112.ibm.com/software/howtobuy/passportadvantage/valueunitcalculator/ vucalc.wss To understand the sub-capacity licensing, you can look at these two sites: http://www-01.ibm.com/so…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
onstat -g ath
We have a flag which indicates that the thead is in a CPUVP private rea= dy queue. The '*' simply means that the flag is not set - indicating eith= er a hard bind to a CPUVP or that the thread is bound to the CPUVP class. T= here are several things which might cause the thread to…
onstat -g rea output question
Hello Folks, IDS 11.70.FX7W2X9 OS AIX 6 Wondering what the significance of an * after the value under the vp-class column is. IE..."18cpu*". Thanx, Dan…
btscanner running v/s ready
Yash: onstat -g rea and -g act are VERY dynamic. If sessions are staying in either queue for more than a couple of seconds at a time there is usually a problem (OK except during the processing of very complex queries). When I want to monitor how well a server is moving data out …
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.…
redundant connection manager configuration using H
"POLICY=LATENCY" is good for ER replset and GRID To use the latency and failure policies, you must: create a table through the grid, and the table must have replication enabled enabled quality of data (qod) monitoring with MACH11 cluster, connection manager calculates the serv…
Undocumented checkpoint trigger
It's to keep the secondary buffer pool from getting too dirty when the index is being transferred to the secondary. Since the index is built on the primary and then transferer to the secondary, then the primary has already encountered the cost of maintai= ning the buffer pool wh…
Informix on Linux on VMWare
Keith Simmons wrote: > Hi > > It looks like I am going to have to migrate an IDS instance from Solaris > to Linux. > Current machine is a 16Gb dual chip SPARC T5120 with twin path, fibre > attached disk (Raid 1) running IDS 11.5 on Solaris 5.10. > Target machine is likely to be s…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Scheduler Status
original post: IDS 11.7 I know how to stop and start the scheduler: execute function task ("scheduler start"); execute function task ("scheduler stop"); ..... but how do you check the status, to see if it is running or not ? Response: You can run onstat -g dbc If you see …
Re: IDS 11.7 Tuning help
I'm afraid I'm missing something... Can you better define the slowness? Do the sub-second queries take longer now? Or do you believe it's the connection establishment that takes longer? Make sure you follow John's suggestions... A few more questions: - Are you sure ther is no s…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Efficiency of the Informix Virtual Processors
Dear All, IDS 11.50.FC8W2 on Hp-UX 11.23 (12 core - 55 GB mem to informix) No other instance running on this machine. I was reading a post by john on http://www.jfmiii.com/informix/?p=194 It say that if the efficiency drops below 80% (onstat -g glo output) then there seems to …
Newbie question: fresh default Mac OSX install, co
On Mon, May 7, 2012 at 1:34 PM, Madison Pruet <mpruet@us.ibm.com> wrote: > Sounds to me like some of the shared memory segments got hung. > Here's my session: bash-3.2$ onmode -ky bash-3.2$ ps -ef | grep oninit 502 36861 35084 0 0:00.00 ttys000 0:00.00 grep oninit bash-3.2$ wh…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Informix job scheduler issues
Fernando, John, Thanks for the responses. I found that the task was not actually executing when I ran it with the name of the function. It never responded after that, and I had to kill the session. Also, I was able to change the database (it's a test database) to a logged datab…
ph_task scheduled tasks
Without the database scheduler on, no task from the ph_task table will execute. To enable the scheduler do the following: 1. If the following file exists $INFORMIXDIR/etc/sysadmin/stop you will need to remove it. 2. You can then shutdown the database server and restart it and …
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…
Help! Broken server destroys customer demo...
Here's some more information, the output of an oninit -v command: Checking group membership to determine server run mode...succeeded Reading configuration file 'C:\\\\PROGRA~1\\\\IBM\\\\Informix\\\\11.70/etc/ONCONFIG.ol_matdemo'...succeeded Checking config parameters...succeeded…
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…
Re: AIO and Buffer Waits
Most bufwaits are caused by contention for the LRU queues, so increase the LRU queues for your buffer caches to maximum first. Use the BTR calculation and observing activity in onstat -P over time to determine if you may also need more buffers. Art Art S. Kagel Advanced DataTo…
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.…
ER RQM error in IDS11.50 FC8
Madison or all ER experts, We have three sites by ER replicated with UpdateAnyWhere. This is a brand new installation and ready to be operational soon. We are doing some testing and saw the following types of RQM error in online log( see below logs) frequently when you run cdr …
Single threaded vs. Multi threaded
Wow, it's been a while since I worked on Informix 5 :-) In Informix, Version 5, UNIX controlled everything. For each user that connected, a process was created and UNIX controlled process switching. This is a single-threaded architecture model. Due to the size of servers back wh…
Fatal error in ADM VP at mt.c
I've the following messages in online.log of an 9.40.FC9 informix dataserver : 17:52:55 Fatal error in ADM VP at mt.c:12703 17:52:55 Unexpected virtual processor termination, pid = 1466506, exit = 0x90009 17:52:55 invoke_alarm(): /bin/sh -c '/bases/informix/pcampcam/admin/ontap…
Scheduler Error
reading through another thread, I found the syntax to restart the scheduler: "execute function task("scheduler start")" This seems to have restarted the scheduler successfully.…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
optimum usage of resources
> sorry actually I wanted to ask "How do i make use of more Processor > Resources" Increase the workload? Informix will use your CPU resources if it needs to. You could add a million CPUVPs and get CPU utilization up to 100% because more work is being done to coordinate these m…
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…
onstat -g rea
exist a query over sysmaster with similar output of 'onstat -g rea' or 'onstat -g act'?. Thanks…
why so many informix threads on idle systems ?
Trying again... |------------------------+---------------------+-----------------------= -| |Thread |Purpose |When activated = | |------------------------+---------------------+-----------------------= -| |CDRD_### |ER apply thread |When a replicated = | | | |transaction is rece…
Re: Sysadmin Database Errors
Don, Stop the scheduler first, then you should have exclusive access: Execute function task ("scheduler shutdown"); Jeff -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DONALD KORTHAUER Sent: Monday, February 15, 2010 2:58 PM T…
Initialization of Java virtual processor failed
when trying to install a java udr i'm getting the following nessage: 9444: Initialization of Java virtual processor failed: (cannot create gc file) Can anyone help? Here is the statment: execute procedure install_jar( "file:$INFORMIXDIR/extend/krakatoa/examples/Env.jar", "env_…
Random Server Slowdown "Redone"
Hi Javier , Here my opinion and hints... 1) I agree with Art, where have to lot Lockreqs, but I don't consider this impossible since you have 8 machines running your applications... 2) Active an OS monitoring tool, like sar to collect information for each 10 or 15 minutes... (…
Re: HDR Replication Requirements
The HDR secondary is always in recovery mode. Onstat, however, will no= t indicate that it is in recovery mode once the secondary is actively receiving log buffers from the primary. At that point, it will indicat= e that it is a secondary node. Yes - you can perform dirty read op…
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…
Seeing one oninit working hard while others are no
I think we are running into a condition where only one virtual processor is trying to do a majority of the work on a remote server via synonyms. When you look at all the oninit modules running on the remote server, it looks like only one is really taxed: ps -ef |grep oninit hd…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Odd Performance
IDS 10.00.UC8 Solaris 10 I am playing with our new Solaris server - I just increased the VPCLASS parameter to VPCLASS cpu,num=32,aff=64-95,noage from cpu,num=5,aff=13-21,noage. Our new server has 132 virtual processors available: uname -X NumCPU = 128 psrinfo -pv The physical…
Question about the status of the thread
On Jun 30, 2:58 pm, Peternt <roger_vi...@yahoo.es> wrote: > Environment: > > Informix 7.31 64 bits > HP-UX 11i > > Hi, > I see the output of onstat -g ses and I have one question. > Please, anybody knows which is the diference between the status > "sleeping(Forever)" and "sleepin…
How to Turn Off Automated Update Statistics in IDS 11.50
red_valsen@yahoo.com schrieb: > Is there a way, or are there ways (GUI + command line/SQL API) to turn > off AUS? Hi, as I am testing IDS11.50.UC4 in the virtual appliance, where OAT is preistalled, I did what Art just posted and also was able switch it off and on using the OAT…
Cannot drop database in IDS 11.50.FC4 (again)
The thread of my original posting with a legitimate question was subsequently fouled by profanity-laden replies and removed from the newsgroup. So I am again posting my first and the only relevant, useful reply (thank you, Richard) in an attempt to find a solution to this proble…
Long Spins
The purpose of a spin lock is to lock the object amongst multiple processes. The mutex is to lock threads from each other. If you have configured more cpuvps than physical cpus, then you can encounter lock inversion which can only be resolved by spinning until t= he process hold…
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…
Mutex documentaion
Neil Truby wrote: > I've a "slow performance" issue at a customer site. PMR 55561,001,866 > refers. > > When we have the problem - symptom being high server cpu, persistently > long ready queue etc - we notice slcommon_ct mutexes listed when we type > in onstat -g lmx. > > Does …
Re: MSC virtual-processor class too loaded aft....
Hi, first of all, thank you very much John and Jacques for your answers. The IDS engine allocated another vp msc (I supose due to the high load of the first one). I have tried without success (at the moment) to catch operations that msc vp is doing with the following command: …
MSC virtual-processor class too loaded after migra
Hi, After migration our DWH from IDS 10FC9 to IDS 11.5FC3 (Under SLES 10 SP2) I found that msc vp class (Miscelaneous System Call) are too loaded, as you can see in the following onstats: Can anybody tell me the reason, or can point me to the correct documentation to understand…
Question for Connection manager and SDS
See below ------------------------------------- Madison Pruet, STSM IDS Replication Architect = "jak aka" = <jakkritakeng@yah = oo.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Question for Connection manager = and 02/04/2009 12:22 SDS [14718…
Lies, Damn Lies and Statistics...
On 27 Jan, 18:35, lfin...@ca.ibm.com wrote: > On Jan 27, 9:37 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > > > > > > > Not to bust Liam's bubble, > > > But what happens when you have two different threads from the same > > parent trying to run at the same time on differe…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
Re: IDS 11.5 licence question: virtual versus physical processors ?
Martin Thole wrote: > We are planning to migrate our database server to a VMware server. > The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 > cores), > but the (virtual) Linux-OS will only use 2 (virtual) cpu cores. > > How many processor licences are neces…
Re: IDS 11.5 licence question: virtual versus physical processors ?
"Martin Thole" <mth@o-b-s.de> wrote in message news:48e3667f$0$6617$9b4e6d93@newsspool3.arcor-online.net... > We are planning to migrate our database server to a VMware server. > The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 > cores), > but the (virtual)…
IDS 11.5 licence question: virtual versus physical processors ?
We are planning to migrate our database server to a VMware server. The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 cores), but the (virtual) Linux-OS will only use 2 (virtual) cpu cores. How many processor licences are necessary ? Which database editons (…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Hardware advice please
Hi all, I am looking for advice on what servers to buy to replace our existing informix db servers. We have to replace them, because they are dinosaurs and could pack up at any moment. Unfortunately I don't really have any idea what would be good to get as I've never been involve…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
View thread info?
Hi Experts, We use an informix database as database layer for an ERP application. We encounter high CPU usage of the informix server while the ERP application is hardly used (low number of active users). The high CPU load always starts at the same timepoint in the morning and en…
onstat -g rea almot 100 queue there !!!
Dear All... I've a IDS 7.31 in a RHEL 3 server , with 4 dual core cpu there , I set cpuvps to 8 and NETTYPE ipcshm,1,20,CPU soctcp,8,30,NET , and onstat -g ses | wc -l showes 220 ... I have noticed that top showes cpus' idle are about 30%~35% , and onstat -g rea showes about 80…
Analysis of activities during checkpoint.
Hi Vartika, Please check this link. You can add but not drop virtual processors of the AIO, PIO, LIO, TLI, SHM, SOC, and STR classes. http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ad ref.doc/adref308.htm Thanks.. Amitava E - id : amitacha@in.ibm…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: CPU VP Issue
pokeyman76@yahoo.com wrote: > VPCLASS cpu,num=4,noage,aff=0-3 > This will turn on noage and affinity for your 4 cpu vps > > NETTYPE onsoctcp,1,600,NET > FASTPOLL 1 I've seen stuff on FASTPOLL, but have…
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
tgirsch wrote: > I've got a puzzling CPU VP issue that I'm hoping someone else here has > dealt with. I've got a dedicated database server running IDS 10.00.FC8 > on a four-core RHEL Opteron server. We've configured four CPU VPs, one > per core. There are almost always five to…
Informix database virtualization
Hi, I saw one running on XEN Linux. The VM was running in paravirtualization mode.The usual OS-dependent functionality was OK: no age, processor affinity, raw devices, direct I/O. It did not have UDRs and datablades. Performance was about the same as running IDS in the domain0 (…
CPU-VP issue
Straight from the doc: "On a single-processor computer, allocate only one CPU virtual processor. On a multiprocessor computer, do not allocate more CPU and user-defined virtual processors, combined, than there are CPUs on the computer." Mike…
how to balance CPU VP
On Feb 19, 10:21 am, Madison Pruet <mpru...@verizon.net> wrote: > ro...@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 > >…
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…
Update Stats Time
We are currently running IDS 7.3 (I know its time to upgrade) and we are having problems with all the stats and backup completing in time for the server to reboot. I am looking for a way to make the stats complete faster. Some nights they run for 4 hours. I have tuned the DBUPSPA…
IDS 10.0
Hi, While setting up a test environment, a question concerning the correct setting for NUMCPUVPS popped up. We have a Hitachi SAN with fifty-seven 52 GB chunks allocated to this instance. Memory is 8 GB $ uname -X System = SunOS Node = test_1 Release = 5.10 KernelID = Generic_…
CPU Help
First, thanks for your time here. You're right it is confusing. I ran topas and noticed (Online Virtual CPUs: 8, Online Logical CPUs: 16) Does that mean 16 physical cpus? I have 167x4gb dbspaces. Your suggestion then would be: VPCLASS cpu,num=15,aff=1-15,noage VPCLASS aio,num=16…
Physical Processor to Virtual processor mapping.
Hello Everyone, We had recently retired one of the cluster nodes and are running the two Informix instances in the same node. We have also added additional CPUs to this node. Solaris version 9 IDS version 9.40 FC4 mpstat CPU minf mjf xcal intr ithr csw icsw migr smtx srw sys…
Re: NETTYPE NET/CPU
> Read more about NETTYPE and have few more questions: > > 1. What determines the polling cycle of poll thread having class of > CPU VP. You mentioned it polls only periodically. What does it do when > it's not polling ? A poll thread running on a cpu vp will poll at a minimum o…
Re: RSS Feeds for Product Lifecycles
On Aug 19, 5:18 pm, nate...@gmail.com wrote: > On a somewhat similar note, do you or anyone know when a particular > release is going to come out? Is there a schedule? The last release > for 10 was ~January, and I'm wondering when xc7 is going to come out. > > -Nate Whoops, disr…
Tuning IDS for Multicore CPUs
the_omegamon@yahoo.com wrote: > Greetings All, > > I am hoping someone can provide some guidance concerning the tuning > of > IDS for multicore CPU architectures. Currently, I have a number Sun > Ultra > Sparc III machines that will be replaced with multicore Ultra Sparc IV …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Mapping cpuvp's to IBM virtual processors ....
On Thu, 2007-02-22 at 17:27 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > For soctcp use 1 or 2 NET VPs (a net VP should handle over 200 connections > efficiently but I like to keep that below ~150 myself). I added 2. > > #LRUs controls contention between users. In order to re…
Re: Mapping cpuvp's to IBM virtual processors on p
Your assumption is partially correct. You don't NEED all 6 CPU's allocated to CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions to CPU VPs as needed so it's possible that one or a few logical CPUS will be harder hit than the others. That said there are tuna…
Mapping cpuvp's to IBM virtual processors on pSeri
We're currently running a read-only instance of IDS 10.0FC6 on AIX 5.3 TL-05. The logical partition (LPAR) hosting IDS has 2.4 physical CPU's, divided into 6 logical CPU's. Running nmon's cpu monitor shows CPU 0 at about 50% used, CPU1 used occasionally, and CPU 2-5 are idle. I'm…
PDQPRIORITY
Have the scheduler run a script that sets PDQPRIORITY then runs the actual task. Art S. Kagel ----- Original Message ----- From: Tony Demeis <ids@iiug.org> At: 2/20 8:28:24 I would like to give more resources to a query that is run as a SAS batch job, from a scheduled process. …
VP error
IDS 9.4 error in log file. Database restarted and no errors reported. Any ideas on the seriousness of this error? 23:31:18 Fatal error in ADM VP at mt.c:12243 23:31:18 Unexpected virtual processor termination, pid = 499808, exit = 0x90009 23:31:19 invoke_alarm(): /bin/sh -c '/ho…
Thread Migration Statistics
Hi, onstat -g sch gives two informations: VP Scheduler Stats and Thread Migration Statistics. I'm looking for any information about Thread Migration Statistics. Does anyone know what is it about? What does it mean: 'steal-at steal-sc idlvp-at idlvp-sc inl-polls Q-ln'? I couldn't…
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…
Sporadic performance issue
IDS 10.0UC4W3 on RedHat 4 AS The customer's database server, which has been running happily for months, has started, sporadically, to experience very high loads as measured by top on Saturdays (the busiest time of the week). At these times the Informix ready queue is sky-high -…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: VP memory cache (was IFX_FOLDVIEW)
Guy . wrote: > > What is this "Virtual Processor Memory Cache"?? > > This feature is fallout from Informix revisting the world of benchmarks, as is the other xC5 feature, Fastpoll. > Well IDS 10.00.xC5 is out now. And the release notes do not mention (even though this was menti…
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
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?…
Multiple Informix Instances with 9.4 UC4 version
I think you can manage. Just make sure the 2 CPU intensive databases are affinitized to different CPU's. Also, if you can try staggering the busy periods of the databases. You can even reassign CPUs based on current load. Start out 4 on each busy with only 3 affinitized let 1 flo…
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/…
HP-UX KAIOON
Alex wrote: > I try to run Informix with async. kernel io on a HP Itanium 4 Processor ... > onconfig entry: > VPCLASS kio,num=2,noage > > > BUT, after initializing with oninit there is obviously no usage of the > kernel async driver. > > > The command output of "onmode -p…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: cannot start with 4 AIO virtual processor
On Windows platforms IDS is KAIO only, hence in most cases there is no need for more than 1 AIO VP. In IDS versions prior to 9.30.TC6 this limit was enforced and an error was generated when a higher value was used. With KAIO systems the AIO VP is still used for some tasks such …
Re: cannot start with 4 AIO virtual processor
informix can only be run with 1 aio vp under windows. Any other value results in the server being started with 1. Unless 9.40 and 10.x are different (haven't checked)? Regards Stefan ********************************************************************** This email and any fil…
Re: cannot start with 4 AIO virtual processor
BTW, i forgot to tell... the ontape failed and, although, it can be a tape's problem we can cover all posible aspects... we have 4 cpu and 3 of them are assigned to informix and 4gb in ram with 131072 buffers...…
Re: cannot start with 4 AIO virtual processor
"Jaime Casanova" <systemguards@gmail.com> wrote in message news:1137432864.044113.214560@g43g2000cwa.googlegroups.com... > Hi, > > OS: NT4 > IDS 9.21 > > Last saturday i was trying to make a level 0 backup so i execute: > ontape -s -L 0 > > And it gives me this message: > > Warni…
cannot start with 4 AIO virtual processor
Hi, OS: NT4 IDS 9.21 Last saturday i was trying to make a level 0 backup so i execute: ontape -s -L 0 And it gives me this message: Warning: Dynamic Sever 2000 cannot start with 4 AIO virtual processor, limit exceeded. Started with 1 AIO virtual processor. I didn't configure…
RE: MULTIPROCESSOR settings on a multiple CPU server with
>MULTIPROCESSOR Specifies that you are running on a multiprocessor computer I was getting tripped up on: Running on a Multiprocessor Computer If you are running multiple CPU virtual processors on a multiprocessor computer, set the MULTIPROCESSOR parameter in the ONCONFIG file t…
FW: Informix versus Oracle Spatial
This is awesome work. I think it touches on some very salient points, especially regarding virtual processors and threading. It is amazing that Oracle technology could have gone so wrong despite the amount of money they have as a company, and how they could not come up with a b…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Crash of the instance
Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…
Posting from the Informix-list
Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…
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: Measurements: (was: Raw vs. Cooked files)
Martin Fuerderer schrieb: > Hi, > > >>Why is NOAGE set to 0? Surely it should be set to 1? > > > For this work the machine was dedicated solely to IDS > server. No other applcations were running on the machine. > Therefore NOAGE 1 vs. 0 would not have made much of a > difference …
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…
Checkpoint Stall problem?
Whilst searching for information on DS_HASHSIZE, I found the following, I went in search of the results and summary on CDI but couldn't find it. Two questions arise: 1) Which versions does this apply to? and 2) Does anyone know where the results are located? A search on CDI archi…
Checkpoint Stall problem?
Whilst searching for information on DS_HASHSIZE, I found the following, I went in search of the results and summary on CDI but couldn't find it. Two questions arise: 1) Which versions does this apply to? and 2) Does anyone know where the results are located? A search on CDI archi…
Re: very high "mt yield 0" on IDS 9.40
"rvb" <rvbon@gmx.de> wrote in message news:6e9a0040.0503030106.178fac00@posting.google.com... > looking at the wait statistics of my IDS 9.40 I find an ever > increasing value for the "MT yield 0" condition. > > Up to my knowledge this means that threads are doing busy waits for …
Re: very high "mt yield 0" on IDS 9.40
After thinking about this a little longer I changed my mind. Your thread spends a lot of time in the yield 0 state. This can be caused by the following: A thread running a query entirely on the buffer pool (or something similar) has to yield(0) occasionally to give other threads …
Re: very high "mt yield 0" on IDS 9.40
rvb wrote: > looking at the wait statistics of my IDS 9.40 I find an ever > increasing value for the "MT yield 0" condition. > > Up to my knowledge this means that threads are doing busy waits for > other event's Looks like it. (snip) > How can I try to track down the reason f…
very high "mt yield 0" on IDS 9.40
rvb wrote: > looking at the wait statistics of my IDS 9.40 I find an ever > increasing value for the "MT yield 0" condition. > > Up to my knowledge this means that threads are doing busy waits for > other event's Looks like it. (snip) > How can I try to track down the reason f…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Single cpu vp woe
Neil Truby schrieb: > 9.20 UC3 on Red Hat 7. > > This site is running the time series datablade in production on a 2-cpu box. > It's all working fine. > > For reasons we needn't go into they want to move to a single cpu box. > They've set up an identical test server. When we run…
Single cpu vp woe
9.20 UC3 on Red Hat 7. This site is running the time series datablade in production on a 2-cpu box. It's all working fine. For reasons we needn't go into they want to move to a single cpu box. They've set up an identical test server. When we run the same programs with the live…
Monitoring CPU usage
--0__=09BBE539DFC69E448f9e8a93df938690918c09BBE539DFC69E44 Content-type: multipart/alternative; Boundary="1__=09BBE539DFC69E448f9e8a93df938690918c09BBE539DFC69E44" --1__=09BBE539DFC69E448f9e8a93df938690918c09BBE539DFC69E44 Content-type: text/plain; charset=US-ASCII Content-tran…
More CPUVPs than processors
Mark wrote: I've always found that for any CPU faster than about 400MHZ (~600 for x86 CPUS) you can run at least 2 CPU VPs per CPU. Now that CPUS are MUCH faster and multi-pipelined and multi-virtual CPU's, you can likely make that 3 or 4 or 5 times # physical CPUs. I think th…
Could not fork a virtual processor: errno = 12
Hello The past week I had a problem with a memory bank of my SUN450 with solaris 8 The problem is already fixed, but I try to rebuilt a secondary instance with HDR y it is no possible, the steps are the same i had used alltimes: onstape -s -L 0 in the primary server in stanard …
DB-Crash
Hi Everyone, IDS: Version 9.30.UC2X7 SuSe Linux 2.4.21 We received the following error messages in our log file: 12:26:42 Logical Log 11992 Complete. 12:26:44 Logical Log 11992 - Backup Started 12:26:44 Logical Log 11992 - Backup Completed 12:26:45 Fatal error in ADM VP at…
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'?…
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…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Error listener-thread: err = -27001 in online.log
----LNX_Thu_Aug_12_2004_08:59:00_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable >Datum: 2004.08.11 20:34:37 >Sender: THORLEIFUR .... <thorleif@islmark.is> > >Does anyone know the cause of this error in online.log. >This slows d…
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: Unexpected Virtual Processor Termination - HELP!
On Tue, 18 May 2004 08:13:07 -0400, Joel wrote: Bounce both engines. Remote synonyms are usually more trouble than they are worth. Could be better to use ER to replicate the needed data on the other server in a separate local database and access it from there. Art S. Kagel >…
Unexpected Virtual Processor Termination - HELP!
We have two SCO-Unix servers, one runs our order entry and acct software, the other runs the warehouse/inventory control software. Each server has an Informix DB, IDS version 7.30 UC2. The inventory control DB uses synonyms to provide access to data in the order entry DB, and vi…
Setting up JVM on 9.30HC5, HP-UX 11i
Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html ) and compiled the examples (in extend/krak…
Setting up JVM on IDS 9.30HC5, HP-UX 11i
Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html) and compiled the examples (in extend/kraka…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
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…
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 Performance
What is your OS? Are you also using cooked chunks? What does top (or equivalent) show on your server during the slow times? First look in Unix to see what the limit is, if any. Then look in Informix to determine any resource contention... onstat -u Anything obvious for users …
Re: Whatcha' wanta have?????
"Madison Pruet" <mpruet@comcast.net> wrote in message news:<yCVUb.239099$xy6.1249571@attbi_s02>... > As a mild diversion from the IDS-DB2 conversion thread, its time for one of > my more favorite exercises. ;-) > > We are nearing the end of the coding cycle for IDS 9.5. We've g…
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…
Re: Slow reposnse
By apparently allowing all your users to gain a PDQPRIORITY of 8 you are limiting the number of concurrent queries to 11. Any that would take the sum of the PDQPRIORITIES above 100 will just sit there at the "gate" and show up in the Ready Queries list. Suggest you: - Set MAXPDQ…
Re: Re: Slow reposnse
Hi Neil, ----- DS_MAX_QUERIES: 10 <<- max DS queries that can run simultaneously is 10 . Queries: Active Ready Maximum 10 11 10 <<- 10 running, 11 are ready (ie waiting). you are most likely competing for PDQ resources . Load Control: …
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Reduce # of CPU: license cost
IDS 7.3 Customer is looking into possibility to reduce the no of CPU that is running in database server. Reason: cost saving since current charges for Informix license is based on CPU. Question: How to do that without physically removing the CPU ? Can that be done by reducing t…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Unexpected virtual processor termination
Please help me for resolution of an Informix Error : 17:06:14 mt.c, line 10188, thread 9, proc id 8335, Unexpected virtual processor termination, pid = 8336, exit = 0x9 . 17:06:14 Assert Failed: Unexpected virtual processor termination, pid = 8336, exit = 0x9 17:06:14 Who: Sess…
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
Hi, dsolalinde, You must to change the relative to the point in server you updated. The BUFFERS parameter can be bigger than before. I dont know how much BUFFERS you have but you can increment more memory to this parameter. Did it based in the LRU size, and its near to BUFFERS /…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
CPUVP overloaded but physical CPU only 50% used
We need to look at other things besides cpu utilization to address performance issues. Have you checked to see if the ready queues have anything on them? If the threads are waiting on some non-cpu resource, then having excess cpu power is not going to help. If the contention reso…
Re: Onbar Backup?
Venkatesh, Well, the backup speed is dependant on the type of tape drive you have. For a DLT7000 you should get about 40-50 GB/hour. Backing-up to a disk storage unit is the fastest speed you will ever get, so you can benchmark against this. The Informix "arc_very_old_page" bug…
Onbar Backup?
Hi, I am running Level-1 backup on IDS 9.4.UC1 ,SunOS 8. My question is even though multiplexing is on and set to 8 in the onconfig as well as on the Netbackup side. (Veritas Storage Manager ), the Level-0 backups take about 12 Hours to complete for backing up 90 dbspaces. Each…
Onbar Backup?
Hi, I am running Level-1 backup on IDS 9.4.UC1 ,SunOS 8. My question is even though multiplexing is on and set to 8 in the onconfig as well as on the Netbackup side. (Veritas Storage Manager ), the Level-0 backups take about 12 Hours to complete for backing up 90 dbspaces. Each…
A Sleeping Thread - Or is it?
Kevin, Yes, it's probably undocumented. Its main purpose is to enable the collection of thread run statistics data, output using "onstat -g wst". The changed "onstat -g ath" output is only a side effect. This is what it does: Every time a thread changes scheduler status (ready,…
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…
cpu time
I have always felt that IDS doesn't attempt to load balance work assigned to CPUVPS (or other VPS for that matter). The observation you are seeing (some CPUVPS "busier" than others) has been true since early v7. We don't do scheduling, pre-emption, or time-slicing. Threads will s…
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). …
Shared mem connections and semaphores
HeadingDescriptionFormatvpThe virtual processor ID.DecpidThe system process ID for the process running this virtual processor.DecclassThe class of virtual processor.StrsemopsThe number of times this virtual procesor went idle and performed a semaphore operation to wait for work.D…
balancing virtual processors
How do I get the kio's to be more balanced? I'm on a Proliant 7000 4-cpu box using NT4.0. C:\\\\WINNT\\\\system32>onstat -g iov Informix Dynamic Server Version 7.31.TC2 -- On-Line -- Up 08:00:59 -- 1643008 Kbytes AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy …
Informix Lockup (Wierd)
----- Original Message ----- From: "Phillips, Rob" <RPhillips@ce-a.com> To: <ids@iiug.org> Sent: Thursday, January 30, 2003 8:14 PM Subject: Informix Lockup (Wierd) [184] > Occasionally I am experiencing Informix locking up. It won't accept any db > connections, or process any S…
RE: # of instances per machine
I like having 2. One XPS setup, one IDS setup for the OLTP needs. I wish there was conncetivity between them. cheers j. > -----Original Message----- > From: Art S. Kagel [mailto:kagel@erols.com] > Sent: Wednesday, February 07, 2001 2:42 AM > To: informix-list@iiug.org > Subje…
What's happening inside the oninit process ?
Something I look at to find out who is hogging all the servers resources is the ready queue. When a system gets bottlenecked on CPU you will start having threads show up on the ready queue. I figure the more times a single thread shows up on the ready queue, it's likely this th…
what is busy waits?
Waiting for a resource that is busy. These are short waits if this type of spin expires the thread is suspended. Art S. Kagel sudhakar wrote: > > hello, > in the onstat -g sch output illustrating VP scheduler statistics. What are > busy waits? > can anyone explain in detail? >…
RE: # of instances per machine
It depends. What version are you running? If version 5 then perhaps that might be a good rule. I would not consider running 7.x+ on less than 4 CPUs. It also depends on whether these instances will all be active at the same time, if they can swap out...... However. I am hig…
# of instances per machine
If the question is 'should' you configure, the answer is ONE! Certainly for a production server. If you have man CPUs then you can likely get away with 2-4 with enough memory. Art S. Kagel Christian Eriksson wrote: > > Hi! > > I wonder if there's any recommendations about how…
FW: what does lngspins mean?
Longspins are spin locks that virtual processors have spun more than 10,000 times in order to acquire. To reduce longspins, reduce the number of virtual processors, reduce the load on the computer, or, on some platforms, use the no-age or processor affinity features. Dirk Reach …
RE: PDQ_PRIORITY parameter!
In order to utilize PDQ, you either need to set PDQPRIORITY in either your SQL (or 4GL) or your environment. In SQL: set PDQPRIORITY <some_value> In environment (UNIX presumed): export PDQPRIORITY=<some_value> John Carlson Informix Database Administrator EDS - WHSmith USA 32…
PDQ_PRIORITY parameter!
Note that PDQPRIORITY values of 0, 1 & 2 are special values. 0: No parallelism 1: Minimal parallelism (same as LOW) 2: Lowest setting that give full parallel features. See the Performance Tuning Guide and the Administrators Guide for details. Art S. Kagel Murat YILDIZ wrote: …
Re: KAIO ands "onstat -g iov" output
In article <932h3l$os4$1@nnrp1.deja.com>, William Rice <ricew@operamail.com> writes >I can't imagine a couple of extra AIOVP's having anything like a >significant impact on performance. > >Will >1 AIO VP's a) Use more memory - seperate process b) Use more thread schedu…
Informix Issues
David, First of all my congratulations on seeking information on what to monitor. Most folks simply use the number of user complaints as their only monitoring tool. If the users start complaining more than normally then somthing must be wrong. ;-) First of all, just as with t…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
RE: Assert Failed: Unexpected virtual processor termination, pid
nope. but oncheck was being run. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: 30 November 2000 18:12 To: yfwoi@tpl.com.sg; informix-list@iiug.org Subject: Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0…
Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0x100
Did someone kill an oninit process? From: Woi Yew Fong <yfwoi@tpl.com.sg> > >Can somebody tell me what could have happened to IUS the based to the >following extaraction from online.log? > >============= extraction from online.log ================ > >16:13:14 Assert Failed: U…
Assert Failed: Unexpected virtual processor termination, pid = 74
Can somebody tell me what could have happened to IUS the based to the following extaraction from online.log? ============= extraction from online.log ================ 16:13:14 Assert Failed: Universal Server must abort 16:13:14 INFORMIX-Universal Server Version 9.14.UC1 16:…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Mutex spins, polling. and performance - Help Please?
A lot on the number of cpuvps depends on the number of threads in the ready queue. If the ready queue has several threads on it, then you might consider adding another cpuvp. (onstat -g rea). Where are your client programs running? If the clients are running on the same physi…
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…
Exclusive lock on table
Here is a situation on our production server, Hope you guys may be able to throw some light. We need to alter a table,add some columns. So i tried to monitor users threads accessing this table, using who-access.sh script in IIUG site. It doesn't show any userthreads. So i tr…
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 IDS7.31 crawling
chivaviro1379@my-deja.com wrote: > I have just upgraded my server from HP900k260 HP-UX10.2 32 bit 1,5GIG > ram with informix IDS 7.30 and runner 7.2 UD6 TO HP 900 L100 HP-UX > 11.0 2GIG ram with Informix IDS 7.31 UC5-1. with runner 7.2 UD8. The > problem is that I could not use…
Re: Oninit & Instance
Found in "onstat -g glo" Individual Virtual Processors Section -- Class CPU. Neil, Stephen & Edward, thanks for your help. Nick Kataria <kataria.nick@emeryworld.com> wrote in message news:8jdblp$c3e$1@news.cnf.com... > Hi All, > > If I have a process ID of an oninit process (fr…
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…
Shadow passwords and IDS
I believe it is scheduled to be fixed in the 9.21 release due out in a few weeks and a 7.31 interrum release also due soon. The result of this 'bug' is that you can connect from a trusted host without a password if you have valid login on the server but you cannot connect, even …
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…
NUMAIOVPS on 8.2x or 8.3
>Subject: NUMAIOVPS on 8.2x or 8.3 >From: bsfoster.no.spam@mindspring.com (Dickey) >Date: 19.04.00 02:58 W. Europe Daylight Time >Message-id: <38fcfeb5.121783189@news.mindspring.com> > >All, (especially Art) > > > I know that this parameter should be set to (2 * number of >disks…
Re: Informix SE 7 slower than 5 ?
Looks to me that in terms of user and system time SE7 was close to 250 times faster than SE5 but these times are likely for the front-end (dbaccess??) and do not include the actual timings for the sqlexec processes. This is one of the difficulties with timing client/server appl…
Re: NETTYPE question
tienp@wholefoods.com writes: > I have a question regarding the NETTYPE parameter. Which one of the > following is more efficient? IDS 7.x? Probably the first > And does each configure communication > parameters for 256 users? No, the config is for 256 connections (read more…
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…
CPUvps
Madison Pruet wrote: > > I think that Mark Stock has already raised the question of 'more CPUVPs than > physical CPUs'. I'm going to attempt to address CPUVP scheduling. > > We don't attempt to equalize the load of the CPUvps because unlike disk IO there > is nothing to be gaine…
Fragmented table and PDQ
In article <89lig9$1jm$1@news.xmission.com>, dins dins <dins_d@yahoo.com> wrote: > > Hello! > > IDS 7.31.UC4-1, on HP-UX.10.20 > > I'm trying to use PDQ on fragmented table query. > With set PDQ SELECT statement works about two > times longer, than without PDQ. > > Environment …
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
when informix-server down ?
Andreas Lommel wrote: > > Hi,- I think it`s better when I bring the informix db-server from time > to time down and start the server new. My question: Can I see when > it`s the right time (memory, ..) PLATFORM and VERSION info? There should be no need to bounce the engine perio…
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: Assert Failed: Unexpected virtual processor termination
> Hi gurus, > > IUS Version 9.14.UC6 > O/S = HP-UX 10.2 > > Way back in August before I stumbled across this list > IUS crashed and the online.log showed: > > "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" > closely followed by: > "Assert Failed: Unexpected virtu…
Assert Failed: Unexpected virtual processor termination
Hi gurus, IUS Version 9.14.UC6 O/S = HP-UX 10.2 Way back in August before I stumbled across this list IUS crashed and the online.log showed: "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" closely followed by: "Assert Failed: Unexpected virtual processor termin…
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…
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: Serious performance issues
Hi Bill My $0.02... I notice in your "onstat -g ioq" output, all your kaio queues are showing pretty high (up to 85 in once case!) maxlen's. According to my Informix instructor, a maxlen > 25 indicates that disk requests are not being serviced fast enough. The first step in rem…
Re: Serious performance issues
Bill, How many tli poll threads are you running? If a tli poll thread runs on a cpuvp it will generate semops and busy waits like you see on vp 7. Look at the NETTYPE parameter. BTW. I know you are a Sequent/Informix user from previous posts. What revs are you running and ho…
RE: Performance problems
There are a very large number of sequential scans (onstat -p)!! Have you run update statistics medium as described in the release notes? Can you really run the application on 2000 buffers? There is a HUGE number of buffer waits - the obvious answer to the question is no! You w…
Re: Performance problems
Willaert Doris wrote: > > System : IBM RS6000 model suz580 AIX v 4.2.1 (Single processor) (73.3 > Specint92 134.6 Specfp92) > Informix : Version 7.3 UD6 > > We upgraded 2 weeks ago from Online Version 5.05 to version 7.3. With > version 5.05 the performance was ok, but since the …
Re: Performance problems
In article <7j5kpc$kan$1@news.xmission.com>, Willaert Doris <doris.willaert@suzuki.be> wrote: > > System : IBM RS6000 model suz580 AIX v 4.2.1 (Single processor) (73.3 > Specint92 134.6 Specfp92) > Informix : Version 7.3 UD6 > > We upgraded 2 weeks ago from Online Version 5.05 …
Performance problems
System : IBM RS6000 model suz580 AIX v 4.2.1 (Single processor) (73.3 Specint92 134.6 Specfp92) Informix : Version 7.3 UD6 We upgraded 2 weeks ago from Online Version 5.05 to version 7.3. With version 5.05 the performance was ok, but since the upgrade we have big performance pro…
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…
Memory Usage on Informix 7.24
LEE Hsin wrote: > > Hi, everybody=20 > > I have a question and hope you could give me suggestions. Now, we are = > developing an application on NEC UP machine (UNIX) with Informix 7.24. = > After starting up Informix, we use onstat utility to see how many memories = > used by Inf…
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…
Informix 7.3 on NT Slow when replication across WAN
Hi, I have recently setup a Informix Replication server from Informix 7.3 running on Solaris 2.6 to a new Single PII 450 processor box running NT SP3 (256 MB Mem). When replication starts the processor sits at 100% for up to 20 mins Even though There were only 3 entries in the t…
Re: Checkpoints - a mystery
Sean Kelsey wrote: > > Sorry if I have already posted this once already...we are having problems > with our news server... > > HP-UX 10.20 running IDS 7.24.UC5 > > We have been having isolated problems with checkpoints - see below. During > the lengthy checkpoints, obviously no u…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Sysmaster Question(s)
Hello all, I am working on gathering information that is found in the onstat commands but I would prefer to do it with the SMI tables so I can store it in a table and do some trending. I am currently on 7.30.UC3 on HPUX-10.20 and there are a couple of things that are really stu…
RE: onbar backup problem
manaloe@my-dejanews.com wrote: > > Hi, there ... > > Does the onbar command uses the tempdbs dbspace during the actual backup > process? I asked this because we had the following error message during our > scheduled onbar -b -w backup schedule using Legato Networker 5.1 for UNIX…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
RE: Processor Affinity
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…
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…
onstat -g sch , Busy Waits ?
darren_m_rogers@my-dejanews.com wrote: > Hi, > > Could anyone explain what may cause a large number of 'busy waits' ? > > Informix Dynamic Server Version 7.30.UC5 (HPUX-11.00) > > VP Scheduler Statistics: > vp pid class semops busy waits spins/wait > 1 1…
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 …
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: about virtual processors
> > Hmmmm....meaty stuff as usual, thanks for taking the time to > explain....so is the "timeslice" kernel tunable available generally and > if so could you point me in the right direction to read up on it and/or > use it?? > > Thanks > > Greg > You might try 'The Magic Garden' …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: about virtual processors
Art S. Kagel wrote: .> .> Greg wrote: snip...... .> .> Hi Greg. It is not Solaris so much as having FAST CPUs. I have seen .> that on a system with only 2CPUs of speeds up to 150MHZ that there is .> no significant gain from more CPU VPs then nCPU-1. On our DGs which .> use 32 …
Re: about virtual processors
Greg wrote: > > Art - > > I can't tell you how giggly I am that you seem to be coming around to my > long held assertion that the "conventional wisom" of: NUMCPUVPS = > realCPUs-1 (or so) ain't necessarily so.....could it be your switch to > Sun/Solaris that's changing your mind…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Re: about virtual processors
Art - I can't tell you how giggly I am that you seem to be coming around to my long held assertion that the "conventional wisom" of: NUMCPUVPS = realCPUs-1 (or so) ain't necessarily so.....could it be your switch to Sun/Solaris that's changing your mind?? Most of my (admittedly…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: about virtual processors
For a 2CPU system most of us recommend using only a single CPU VP. Based on this, set: MULTIPROCESSOR 1 NUMCPUVPS 1 SINGLE_CPU_VP 1 NOAGE 1 AFF_SPROC 0 AFF_NPROCS 0 This is because IDS does not take advantage of only two CPUs well due to the overhead of managing the addit…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
about virtual processors
hi all: Could someone explain a little bit about virtual processors and their configurations? I am running workgroup dynamic server on sun solairs 2.6 with 2 sparce 300 mhz cpu and 256 meg of rams. how many vp should i assign to io and cpu, what's the relationship, an…
Re: Dynamically adding shared memory segs
Bill Weaver wrote: > > Today for some reason we've added 5 shared memory segments dynamically. It almost never happens > that we even have 1 added since I've worked to size our initial segment to avoid this. How can > I tell what is causing us to add so many all of a sudden? > …
Re: Dynamically adding shared memory segs
Bill Weaver wrote: > > Today for some reason we've added 5 shared memory segments dynamically. It almost never happens > that we even have 1 added since I've worked to size our initial segment to avoid this. How can > I tell what is causing us to add so many all of a sudden? > …
Re: Dynamically adding shared memory segs
Running oncheck or building indexes with PDQ can add memory segments. Is your SHMADD value very small so many segments may be added if memory is needed? Do yo have more sessions than usual? I someone running a select with PDQ and causing your ready queue to grow? Steve Berg s…
Dynamically adding shared memory segs
Today for some reason we've added 5 shared memory segments dynamically. It almost never happens that we even have 1 added since I've worked to size our initial segment to avoid this. How can I tell what is causing us to add so many all of a sudden? Also our ready queue seems t…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: Virtual Processors
I had the same problem. It happens with big queries and you cant stop it really. The VP usually uses what it needs. The best option is to turn NOAGE off, so that the processes age and allow the OS some use of the CPU. Rgds, Jason On Mon, 08 Jun 1998 11:46:55 GMT, darren@syste…
RE: Virtual Processors
Darren, You might check your NOAGE and AFF_SPROC / AFF_NPROCS settings, and then see what your release notes say about those parameters. If this is just occurring when you run specific programs, what is the PDQ_PRIORITY that you are using when you run them? HTH. Paul Mosser O…
Re: Virtual Processors
You need to send us some more info. Is this a SMP box? How many CPU's? What applications are causing the problem? CPU bound Informix engine is not necessarily a bad thing, but if the entire system is slowing down then you need to tune a few things. What to tune depends on wha…
Re: Virtual Processors
darren@systeam.co.uk wrote: : I have a problem with a customer's site with a CPU virtual processor which : seems to be running out of control. It occours when I run one or two : programs, the CPU VP is taking about 90% of the system CPU time, and therefore : bring the system to a…
Virtual Processors
I have a problem with a customer's site with a CPU virtual processor which seems to be running out of control. It occours when I run one or two programs, the CPU VP is taking about 90% of the system CPU time, and therefore bring the system to a general go slow. The Informix engi…
Re: AIO virtual processor
Also sprach <dwillem@ibm.net> : :In the event viewer of Windows NT (4,0), everytime the server is started, we :see the next warning : :INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, :limit exceeded. Started with 1 AIO virtual processor. : :What to do …
AIO virtual processor
Hi, We're running Informix 7.23TC1 on a Digital Alpha 4100 with 3 processors. In the event viewer of Windows NT (4,0), everytime the server is started, we see the next warning : INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, limit exceeded. Started …
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] > …
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…
Re: NUMCPUVPS settings for a four-processor server
In article <6ck1q1$p40@drn.newsguy.com>, Neil Truby <?@?.?> writes >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 u…
Re: NUMCPUVPS settings for a four-processor server
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 all CPU's to 100% busy. Whe…
Re: Is Informix Reliable?
>> >I am currently evaluating Informix -vs- Oracle, and would appreciate = your >> >input. >> > >> >I have read on a few threads that people have had to unload and = re-install >> >the database to fix corrupted system tables, indexes, etc.. How often = does >> >this happen? As I…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: chekcpoints, BUFFER settings, and optimization
David Kosenko wrote: > > "Art S. Kagel" <kagel@bloomberg.com> wrote: > +Dave I have to disagree. I agree that additional cleaners are of > +limited use during normal LRU writes but they are needed for fastest > +checkpointing. Since at checkpoint time each chunk is assigned to…
Re: chekcpoints, BUFFER settings, and optimization
"Art S. Kagel" <kagel@bloomberg.com> wrote: +Dave I have to disagree. I agree that additional cleaners are of +limited use during normal LRU writes but they are needed for fastest +checkpointing. Since at checkpoint time each chunk is assigned to +another cleaner thread until …
Re: chekcpoints, BUFFER settings, and optimization
In article <348F1333.4F79@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >David Williams wrote: >> >> In article <66madi$osk@cssun.mathcs.emory.edu>, Serafim Fonseca >> <inf@dpx20.growela.pt> writes > >> >} In article <881611278.1353908229@dejanews.com>, >> >} jneuge…
Re: chekcpoints, BUFFER settings, and optimization
David Williams wrote: > > In article <66madi$osk@cssun.mathcs.emory.edu>, Serafim Fonseca > <inf@dpx20.growela.pt> writes > >} In article <881611278.1353908229@dejanews.com>, > >} jneugebauer@ameritrade.com writes > >[...] > >David Williams writes > >[...] > >} ># Shared Memor…
Re: Questions on INFORMIX 7.13 and CPU VPs
In article <638pt8$2h7@cssun.mathcs.emory.edu>, sujata_soman_at_omm- la2-infotech-001@internet.omm.com writes > > Hi everybody, > Some more questions for everybody. Feel free to answer > . I have a lot of questions on CPU VPs and performance. Here goes: > > some b…
Re: gfd virtual processor class...
June - sounds reasonable, thanks. I'll have to count tomorrow & see if they jive. Greg (from my alter ego at home...) June Tong wrote: > > : I was looking through the output of "onstat -g ioq", and it occurs to me > : I don't have a clue what VP type "gfd" is (see snippet belo…
Re: Cannot fork a virtual processor
Mark D. Stock wrote: > > Enigma wrote: > > > > Hi, > > My informix ODS went down when I tried to put it to online. I'm > > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > > online.log is > > Cannot fork a virtual processor errno=12. > > This hap…
Re: Cannot fork a virtual processor
Enigma wrote: > > Hi, > My informix ODS went down when I tried to put it to online. I'm > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > online.log is > Cannot fork a virtual processor errno=12. > This happens only intermittently. It seems to…
Re: gfd virtual processor class...
: I was looking through the output of "onstat -g ioq", and it occurs to me : I don't have a clue what VP type "gfd" is (see snippet below). Can : anybody clue me in?? It's not a VP type. It's an I/O queue. I think it's Global File Descriptor (or something like that). Basica…
Cannot fork a virtual processor
Hi, My informix ODS went down when I tried to put it to online. I'm running a informix 7.14 on a IBM AIX 4.2 machine. The error in the online.log is Cannot fork a virtual processor errno=12. This happens only intermittently. It seems to indicate there is insuffici…
Re: Cannot fork a virtual processor
Enigma wrote: > > Hi, > My informix ODS went down when I tried to put it to online. I'm > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > online.log is > Cannot fork a virtual processor errno=12. > This happens only intermittently. It seems to…
gfd virtual processor class...
I was looking through the output of "onstat -g ioq", and it occurs to me I don't have a clue what VP type "gfd" is (see snippet below). Can anybody clue me in?? plsaphp1:informix 1> onstat -g ioq INFORMIX-OnLine Version 7.21.UD3 -- On-Line -- Up 26 days 06:59:37 -- 175552 K…
Re: HELP: Informix Online on HP-K460 is NOT-SCALABLE?
James Francis asks: > We have an HP-K460 server running HP-UX 10.20 attached to an EMC high-speed > disk array. > Our database is around 100GB. > > When we run our application with one user everything performs lightning > fast. > As more users degrade, the performance continues t…
Re: HELP: Informix Online on HP-K460 is NOT-SCALABLE?
In article <1kV2rKSxbLgw-pn2-mddnpqg3z1hk@rick200>, rick.martino@ibm.net writes >On Sat, 4 Oct 1997 17:48:18, "James Francis" <jfrancis@dxi.com> wrote: > >> Hello, >> >> Here is the problem... >> >> We have an HP-K460 server running HP-UX 10.20 attached to an EMC high-speed >> di…
Re: HELP: Informix Online on HP-K460 is NOT-SCALABLE?
Thanks, for the replies. I'll post the Informix case number tomorrow. I had the buffers set as high as 138000. The machine has 1GB of memory. I lowered them according to the recommendations in the "Informix Online Dynamic Server Handbook". My cache hit rate is right around 9…
Re: HELP: Informix Online on HP-K460 is NOT-SCALABLE?
On Sat, 4 Oct 1997 17:48:18, "James Francis" <jfrancis@dxi.com> wrote: > Hello, > > Here is the problem... > > We have an HP-K460 server running HP-UX 10.20 attached to an EMC high-speed > disk array. > Our database is around 100GB. > > When we run our application with one user …
HELP: Informix Online on HP-K460 is NOT-SCALABLE?
Hello, Here is the problem... We have an HP-K460 server running HP-UX 10.20 attached to an EMC high-speed disk array. Our database is around 100GB. When we run our application with one user everything performs lightning fast. As more users degrade, the performance continues to…
Re: Informix crashing UNIX on HP
On Thu, 02 Oct 1997 16:19:24 +0200, "Mark D. Stock" <mdstock@informix.com> wrote: >Silvester_Valiente@tnt.com.au wrote: >> >> Has anyone had an experience where Informix 7.23 UC4 caused Unix to >> Panic and shutdown. >> >> We are experiencing the problem when the virtual portion…
Re: Ready Queue
Are you using PDQ? Send your onconfig file as well as the output of t he onstat that concerns you. -Bill } } This is a multi-part message in MIME format. } --------------A4489FA28C25AB102697661A } Content-Type: text/plain; charset=us-ascii } Content-Transfer-Encoding: 7bit } } I…
Re: Ready Queue
John, What are your PDQ settings? If they are set too high one session could be consuming all system resources. jim ______________________________ Reply Separator _________________________________ Subject: Ready Queue Author: "John M. Shoemaker" <John_S…
Ready Queue
This is a multi-part message in MIME format. --------------A4489FA28C25AB102697661A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am having a problem, and so far tech support has not found the answer, so perhaps YOU have it :) With only a handful …
Performance & PDQ et al...
We have several update process that are currently very slow, (~ 12 hr each) And have enabled PDQ but no table fragmentation yet. Here is our onstat -g mgm output. Interesting that I note, there is not many contention with the PDQ, and very little I/O loading and have free CPU re…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: onstat -u, B-flag
Alexander Selg (alexander.selg@siemens.at) wrote: : The command "onstat -u" gives some information about the userthreads. In : the 2.column you can see the flags to each thread. The 1.position : indicates the resource a thread is waiting for. : My question is: if there is a "B" o…
RE: scheduling Informix stored procedures on NT
Vinitha Dont know anything about NT. There was a post here on your thread which = said that the NT at functions differently than the Unix at. This is how = I would go about doing it in Unix, so please extrapolate the information = for NT if at all possible. echo "dbaccess $DBNA…
HPUX 10.20-7.22 Restore problems
We have an HPK250, single processor, 160 meg mem, Informix 7.22. When I try to restore from a level 0 archive tape, the machine hangs completely. We have to use "the big switch" to reboot. Tried several configs - up to 64000 initial virtual, cutting down the off recovery threads…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Performance advice
You had a lot of questions here :-) I will leave the tuning options to David, but have some comments: "L.Shaw" <lyndons@enterprise.net> wrote: :We have Informix 7.13 online engine which up until now has been running :perfectly on a single processor sun server. What model? Old …
Re: Informix and Oracle in the same shop
In article <5n4f08$cq9@agate.berkeley.edu>, pbrown@triplerock.CS.Berkeley.EDU writes: > Pablo Sanchez wrote: > : The Informix Online engine is not multithreaded. It's some > : bastardization of threading. It's a nice concept but it still incurs > : overhead. > > From the top;…
Re: Informix and Oracle in the same shop
In article <5n4e5a$qk5@cssun.mathcs.emory.edu>, rambabu@sprynet.com writes: > I have been following this thread for quite sometime and I believe > nothing runs "concurrently", not even the unix processes(it just > schedules them). IRIX is multithreaded therefore a parallel proce…
Re: Informix and Oracle in the same shop
Pablo Sanchez wrote: : The Informix Online engine is not multithreaded. It's some : bastardization of threading. It's a nice concept but it still incurs : overhead. From the top; a. This whole discussion confuses 'threads' as an OS feature, with the idea of 'threads' as…
Re: Informix and Oracle in the same shop
David Williams wrote: > > In article <5n1dv1$2ar@mew.corp.sgi.com>, Pablo Sanchez > <news_reader@mew.corp.sgi.com> writes > > > >In article <33935782.7D9610FC@devnull.org>, Tim Schaefer <devnull@devnull.org> > >writes: > >> Pablo Sanchez wrote: > >> > > >> > No vendor, that I kno…
Re: Informix and Oracle in the same shop
In article <5n1dv1$2ar@mew.corp.sgi.com>, Pablo Sanchez <news_reader@mew.corp.sgi.com> writes > >In article <33935782.7D9610FC@devnull.org>, Tim Schaefer <devnull@devnull.org> >writes: >> Pablo Sanchez wrote: >> > >> > No vendor, that I know of, is truly multi-threaded... at leas…
Re: Informix 5 Performance Issues
Remember - YMMV, etc: On 16 Apr 97 at 17:04, Phantom173 wrote: > We have been told by a consultant that a move to Informix 7 would > benefit us because (a) Informix 7 would reduce the number of connects > (and therefore processes) associated with the elephants, and (b) it > wou…
Re: onstat options
Mark H. Preston (markp@mamasita.rose.hp.com) wrote: : Hi, : What are the best indicators of response time, trans/sec, and general : load for monitoring an informix database... using the onstat program? : Any help would be appreciated. Thanks : Mark~ Hi Mark ... Here is a sa…
RE: Online performance and Multiprocessors.
Hi Richard! Performance & Tuning involve many things, not only memory and = processors, and I personally think that this is a serious subject, nobody in this = list will tell you what is the source of your problem (Unless monitoring your = system), and believe me the source can …
Re: Performance / Internal Q's -- Online 7.2
Hello, jimlenahan@aol.com wrote: > > Greetings: > > A few questions on performance and internals on this beast: > I never have had a possibility to run such a big system, sorry. But: > I have a 4way HP Kclass machine as server connected to a pair of HP > G class mac…
Re: Is this stack trace normal?
In article <19961220074500.CAA02432@ladder01.news.aol.com>, SaTriGuy <satriguy@aol.com> writes >While semaphores are often used to lock memory, that is not their only >use. They are also used as a binary lock. What your are seeing is normal >for a shared memory connection when t…
Re: Is this stack trace normal?
While semaphores are often used to lock memory, that is not their only use. They are also used as a binary lock. What your are seeing is normal for a shared memory connection when the query has been passed to the engine. Let me explain. Each shared memory client is assigned a …
Concurrency between processes
I'm perhaps wrong so i'm ready to get any corrections. Our problem is the high concurrency between processes and the application has a big amount of update (several updates or insert per second). First we didn't use the mechanism of 'CURSOR FOR UPDATE' when updating or deleting…
Re: New Era, VB, Delphi, PB
David Williams wrote: > > In article <32AC1AF7.671C@west.co.za>, "Mark D. Stock" > <marks@west.co.za> writes > > > >Oh now here I agree. This is one of my pet topics when giving Informix > >training. The development of both RDBMS's and OS's, in my view, is going > >to cross pa…
Re: New Era, VB, Delphi, PB
In article <32AC1AF7.671C@west.co.za>, "Mark D. Stock" <marks@west.co.za> writes > >Oh now here I agree. This is one of my pet topics when giving Informix >training. The development of both RDBMS's and OS's, in my view, is going >to cross paths somewhere in the not-to-distant fut…
Re: MULTIPROCESSOR OPTION 7.13
In article <01bbcb91$cc1befe0$654750c6@irwin.interaccess.com>, irwin@objectsoft.com says... > > > >Allen Jantzen <allenj@ndr.com> wrote in article ><327fa20d.27552573@news.netline.net>... >> The Informix DSA Administrators Guide, version 7.1, page 10-18 says >> >> "On some two-pr…
Re: MULTIPROCESSOR OPTION 7.13
Just my 2 cents worth: I have a HP T500, T520, and 2 K200's which all have two processors. I found that running with the MULTIPROCESSOR set to two was the way to go. My performance while running config'd as one cpu was good, but sometimes I'd see the one cpu at 100% while the o…
MULTIPROCESSOR OPTION 7.13
The Informix DSA Administrators Guide, version 7.1, page 10-18 says "On some two-processor computers, you should only run one CPU virtual processor because the overhead of synchronizing the two virtual processors offsets the benefit of distributing the processing" Of course, us…
Re: Ready-to-run Queue
In article <557ngf$6en@cssun.mathcs.emory.edu>, mailgw!hpx400!Trevisol_R oberto/bbb_cak@gtw1.netway.com.br writes >Hi, > >I came up with a question last time I was taking a shower... > >In which system table (sysmaster database) can I find out the Online >threads ready to run. It…
Ready-to-run Queue
Hi, I came up with a question last time I was taking a shower... In which system table (sysmaster database) can I find out the Online threads ready to run. It's the same information I get with "onstat -g rea". I guess I found some clues in systhreads view (th_state column) and …
Re: Informix ESQL/C seems to block
On Solaris (2.4 and above) the DCE library needs to be installed for multithreaded esql/c applications to work. All the 7.20 (and above) ports should contain the threaded libraries. I think on the HP and IBM platforms, the esql/c thread libraries rely on native calls rather than …
Re: Informix ESQL/C seems to block
>From: Ken Crismon <kcrismon@earthlink.net> >Date: Thu, 17 Oct 1996 18:56:49 +0000 >X-Informix-List-Id: <news.29434> > >A not so brief discussion of our product. > >We are developing a server application that runs on various UNIX platforms >and Windows NT. It services several co…
Re: Index clustering and performance
In article <3259EA83.66D30FD7@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes >Land, Todd wrote: >> >> I remember a thread from long ago . . . can you refresh my memory? >> >> My database performance is declining, and my DBA wants to dump and reload >> the…
Re: Index clustering and performance
Land, Todd wrote: > > I remember a thread from long ago . . . can you refresh my memory? > > My database performance is declining, and my DBA wants to dump and reload > the database, hoping that will help. > > Isn't there something I can do to my indices (re-cluster?) to regain >…
Re: Query Retrieval
Srirama Sundararajan Rajagopalan <rajagopa@nps.med.ge.com> wrote: :Hi Folks: :I am working on improving the query performance in informix 7.1. :I already have unique indexing on this table and besides optimizing :the query, virtual processor technique, is there any other techni…
Query Retrieval
Hi Folks: I am working on improving the query performance in informix 7.1. I already have unique indexing on this table and besides optimizing the query, virtual processor technique, is there any other technique that can be employed to improve the query retrival time in informix…
Re: Overall unstableness of Informix
In article <322E1112.3F8C@transre.com>, "Juan R. Guzman" <jguzman@transre.com> writes >Michael Silver wrote: >> >> We have had an Informix (7.12.UC2) database running on an HP for over a >> year. We have been utterly disappointed with it. It crashes about >> once-a-week. We ru…
Re: Good Informix bug found
In article <3219FC57.5AC4@cyberramp.net>, Greg <greg@cyberramp.net> writes >Hey - at least you're getting a result. I get a locked up instance I have to >kill -9 >to get it's attention. I'm joining two tables, one join col is a char(6) to >smallint. > Yeah, I know it's hoke…
Re: Logical problem.
In <4tb3ba$bjt@cssun.mathc> Jack postulates whilst scratching thoughtfully: >I have a scheduler which waits for files and a datetime to occur before >running a process. So at a given datetime the process is 'queued' but >cannot run until it's source files/tables are ready. So …
Re: Oninits Running Amok...
In article <4rtnsa$e2@server2.codetel.net.do>, Tom Hay <nomad@codetel.net.do> writes >Yes, I've seen it too, on Version 7.10D1 on a uniprocessor HP-UX, and >I don't like it either. The machine virtually stops for around 30 >seconds. Can't offer any explanation, though ... sorry !…
Re: 2 CPU VP's
In article <31E262D8.20DC@transre.com>, "Juan R. Guzman" <jguzman@transre.com> writes >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 els…
Re: Oninits Running Amok...
OK - got some more info...it looks like the only time the CPUVP's run amok is when our Powerbuilder client connects across a slow (dialup) IP link and is downloading client code changes from a table (Select...) that contains updated app code in BLOB's. This would explain the lac…
Re: Oninits Running Amok...
In article <31D9457E.5C90@eds.com>, Greg Moye <msmcl301.gmoye01@eds.com> writes >We have 7.13.UC2 running on Solaris 2.4 w/ 2 Sparc CPU's. I occasionally >see both CPU VP's chewing CPU like crazy, yet there's few if any Buffer >Reads or any other evidence of productive work goin…
lastest compare against oracle
can anyone provide some new information on the rdbms wars between informix and oracle. I know oracle blasts informix for the poor performance, transaction logging, record locking mechanisms and informix touts the performance gains on the methodology for using threads instead of p…
HP K200 and Online 7
We are experiencing SEVERE performance problems trying to upgrade from Online 5 to Online 7. Online 7 runs about 400 percent slower than Online 5 up until +- 400 processes. (Confirmed by Informix S.A). Online 7 performance never degraded even when the load went above 400 process…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: LRU writes
brian, we should keep this either as private e-mail or just to the list, as i get two messages for everything that gets send out! not a big deal, but kind of a pain. the advantage of the list is that other people can see it and throw in ideas. it can be difficult to diagnos…
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 …
Re: unexpected virtual processor termination
This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---1503566844-140477562-830393090=:47444 Content-Type: TEXT/PLAI…
Re: unexpected virtual processor termination
Sounds like someone issued a Kill -9, while it was holding locks? Anyway I suggest you turn on your montoring program/script (if you do not have one, I got one to watch engine and another one to watch user's) and see what processes are actually occuring at that time. If you want …
unexpected virtual processor termination
We use Online 7.11 on IBM RS6000 AIX 4.xx (32 MB RAM) for development tasks. Often, while 4GL program is being compiled, Online shuts down. In online.log file one writes: "unexpected virtual processor termination, attempting to bring system down". This virtual processor is msc. …
<No Subject Supplied>
>On occassion we can see that the 'oninit' process associated with the CPU >virtual processor of Informix is taking 100% of the CPU. Is there a good >way now to track this down to which Informix sessions are actually using >this CPU time? >Is there a better, more direct way to …
Re: processes sspawned by 7.1
>I noticed there are a lot of processes names oninit -s >spawned by the database engine on start-up. Can someone >enlighten me as to why this is. I'm sorry I'm not familiar >with the new engine and am just groping along. You get an oninit process for every Virtual Processor (V…
Re: processes sspawned by 7.1
Carol Stimmel (stimmel@fsl.noaa.gov) wrote: : Hi, : I noticed there are a lot of processes names oninit -s : spawned by the database engine on start-up. Can someone : enlighten me as to why this is. I'm sorry I'm not familiar : with the new engine and am just groping along. …
Re: Informix dual processor scalability
In article <DJ6CHK.5zx@dsbc.icl.co.uk> smb@oasis.icl.co.uk "Stuart Britt" writes: > Using Informix on 1 processor we achieve good performance. If we switch to > 2 processors, then our performance actually degrades. We have been given > some advice on tuning the system for dual…
Re: Informix dual processor scalability
According to my rusty memory, the reason for this is something about the overhead necessary to handle multiple processors only being overwhelmed by the performance increase after three processors. So you should tune as tho' you only have a single processor... :-( HTH. }Does any…
Re: Informix dual processor scalability
Stuart Britt writes: |> Does anyone have any info on the following problem? We are using Informix |> version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP |> machines. |> |> Using Informix on 1 processor we achieve good performance. If we switch to |> 2 processor…
Re: Informix dual processor scalability
: smb@oasis.icl.co.uk (Stuart Britt) writes: : Does anyone have any info on the following problem? We are using Informix : version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP : machines. : : Using Informix on 1 processor we achieve good performance. If we…
Informix dual processor scalability
Does anyone have any info on the following problem? We are using Informix version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP machines. Using Informix on 1 processor we achieve good performance. If we switch to 2 processors, then our performance actually degra…
Looking for a good job Scheduler / Batch Processer
I am looking for a Unix software package to help us schedule jobs to run automatically in a timely efficient manner. Desired features: * Useable from a variety of IS applications sitting on top of Unix: Red Brick Data Warehousing Oracle Universe future??…
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: Temp Table Space Gobbled Up
> > No. Temp tables don't show up in a tbcheck -pe output. > > > June > > That's what I observed. I ultimately had to do a restart to recover > all of the space in rootdbs. .... .... > > So is there any improvement in 7.1 that enables me to track down owners > of temp table spa…
Re: report writer(generator)
Matt Reprogle (mcreprog@mail.delcoelect.com) wrote: : In article <3lg56c$g5s@newsbf02.news.aol.com>, billkuruc@aol.com (BILLKURUC) writes: : > try IQ for WIndows...simple to use.... : > requires a network solution at this time : > character based version scheduled for near futur…
Re: Trouble with 'onmonitor' on OnLine 6.0/SCO ODT 3.0
> Running 'onmonitor' crashes the engine with the following message left > in the log file: > > 00:09:48 mtshpool.c, line 1928, thread 9, proc id 919, Condition Failed > ((char > *)poolh == ptr || (blk->*l_magic == poolh->po_id && > *L_TRAILER(blk)->bt_magic == > poolh->po_id))…
Re: Informix vrs Oracle 7.0.x or 7.1.x
In article <adamg.773156940@infmx>, Adam Green <adamg@informix.com> wrote: > >Also, Version 7 PDQ will be on a range of platforms by year end. >Also note that our PDQ facility is built into the architecture of the >server, it's not a tacked on, extra cost, option. I agree with…