Oninit® Archive
Results for “SHMVIRT_ALLOCSEG”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
Gathering EXTREME amounts of time in %sys CPU
<snip - delete a lot of old text> David Williams wrote in message <0mcD2LAtTeo2EwkJ@smooth1.demon.co.uk>... > Several... >>> Have you seen anything like this ? > > Not exactly, the only time I saw a system freeze that hard was an old > 7.1x running against Pyramid which hung …
onstat -g seg reveals several virtual segments many show a pool summary of 17184.H.sd
Hi Stuart, If it has been set to POOOL for that long and this type of behavior has not seen before then the changing of this to HEAP and bouncing the engine was probably coincidental. Looking at some of the onstat snippets posted above then I have a feeling that a session or mayb…
How to configure alarmprogram.sh to trigger only on errors and replication failures?
Hello, The alarmprogram.sh is just a shell script. You need to look into it and tailor it to your needs. This script was meant to help you to have a basic example. You could enrich it the way you want by either adding things or adapting things to alter the way y…
Extending chunk capacity
A couple more notes. If the server creates a chunk from a directory entry in the storage pool, as you know it will create a new cooked file in the directory and use it for the chunk. If its space is a regular dbspace we'll automatically mark that new chunk as extendable, so you s…
Large memory segment vs smaller ones
Using several smaller memory segments instead of one large segment is often better for stability, particularly in preventing memory block header corruption in IBM Informix. Adjusting parameters like SHMVIRTSIZE and SHMADD can help fine-tune memory allocation, but it's important t…
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 ------------------------------…
Question of dostats
Yes. Many dostats rune used two connections egging you cannot do over a shared memory connection. There is an option to use a shared memory connection but then you can only process one database per run. Art ------------------------------ Art S. Kagel, President and Principal Con…
What prevents a RSS to roll forward as fast as its primary?
Art, Here are differences that make sense between the primary and RSS, 236,238c236 < NETTYPE onsoctcp,50,220,NET --- > NETTYPE onsoctcp,40,220,NET 243,245c241 < NUMFDSERVERS 8 --- > NUMFDSERVERS 4 2…
unable to select, delete the data and unable to drop the table, response says Long transaction detected
Suresh: You do not have enough logical logs defined. Any transaction or combination of transactions that span more than the percent of logical log space documented in the LTXHWM parameter in your ONCONFIG file will trigger the oldest of the open transactions to roll back with a L…
Memory issue on Informix primary server
Amit: All of those additional virtual segments are in use. I think that the only thing you can do is merge them all into the initial SHMVIRTSIZE and increase the SHMADD size by 10X or more. Solaris is REALLY slow to allocate shared memory, so the fewer segments the better. Art --…
Shared Memory
Yes, you can set SHMVIRTSIZE parameter to 6375342 KB in ONCONFIG file . Please take into account, whether you are using of mgm facility for DSS queries or not? I mean at first use of "onstat –g mgm" and investigate in output to find out, you are using of DSS Queries or not?. If…
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…
PDQ mixed with OLTP
You need to check the explain plan to see whether you would benefit from parallel processing. I believe that if you set PDQ you can still benefit from from access to the memory grant manager even without a parallel query. You can check this with "onstat -g mgm" while your query i…
-951 trap
Folks, IDS 11.70 AIX 7.4 Is there any way/method etc. to trap for the following authentication error and send out an alert to security admins ? (other than greping the msg log ) 951: Incorrect password or user is not known on the database server. Preferably would like to have…
systemd centos7
Hi All, we configured systemd on CentOs7 to start and stop informix server 12.10.FC10. Im not sure of the type of the service so I tried oneshot, simple and forking. Informix starts in all cases. I see no difference. But we have an issue: If starting informix via systemd, the …
SHARED MEMORY ALLOCATION
Hi, Can I ask your opinion regarding memory allocation in informix 12.10 running on AIX 7? Total Server Memory is 12 Gig I was planning on leaving 4 Gig on the server and 8 Gig to be put in Shared Memory SHMTOTAL = 8192000 BUFFERPOOL (50% of SHMTOTAL) = 4096000 SHMVIRTSIZE (25…
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…
Re: 12.10.FC9 1809 Error
i'm just connecting on shared memory (onipcshm in sqlhosts) regards…
Could not do a physical-order read to fetch next r
I have increased the buffers and set the SHMTOTAL to the nearby by max value. When i rum the oncheck -ce we got an error for sbspace ERROR: Could not obtain lock for Partnum I have ran the onspaces -cl sbspace but the error occurs again.…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Issues With Restore
I tried it well 10 times now, but it is now saying: Warning: Fatal error in shared memory creation…
Error allocating temporary clob file on Innovator
Hello! We're getting Error: 8359: Function (extractvalueclob) Error allocating temporary clob file. trying to use SELECT EXTRACTVALUE(xml,'/doc/number') FROM TABLE_WITH_A_XML_COLUMN. In the online.log we got the message: Warning: The IBM IDS Innovator-C Edition license restrict…
identify what is allocating memory
original post: <some stuff deleted> @Jacques , Thank you for your explanation. Please, can you answer my question below? If I get the sum of the column totalsize of all lines on 'onstat -g mem' (Pool+blkpool), should be close value of the used memory for the segments at 'onst…
sqlhosts file
For the sqlhosts file, if you have two servers (primary and secondary for HDR), will the sqlhosts file have 3 entries? Primary One for shared memory with name of primary and two for tcp(one for each server)? Secondary Same thing(3 entries) except for shared memory, it will have…
create_tcb: cannot allocate memory
The thread control block (TCB) is in virtual memory. What is the output of onstat -g seg??? Also what are the settings for SHMVIRTSIZE, SHMADD, EXTSHMADD and SHMTOTAL Madison Pruet Retired and Loving it On Tuesday, February 7, 2017 12:06 PM, HUGO PADILLA <hugo_padilla@terra.com…
Full memory even if I set SHMTOTAL
Hi, My server got full memory (Windows 2008 R2), even if I set SHMTOTAL to 16 GB, the system go more over this value until it reach the all memory of the machine (52 GB). when I shutdown the database (onmode -kuy), the memory is got free. is there any issu with some parameterss…
ids 11.50 shared memory for Workgroup Edition
Solaris 10 11.50.FC5 For the Workgroup Edition, is the maximum memory allowed shared between instances on the same server; or does each instance on the same server have access to the maximum allowable shared memory? Larry…
IO performance issues
Michael: FWIW, your other post (with onstat -g mgm) doesn't tell us anything useful except that the server's been online for 11 days and 18 hours or 282 hours. Assuming you have not zero'd your stats since startup, I can calculate a rough Buffer Turnover Rate (BTR) across the tw…
Capture event of adding shared memory segment
Hi, IDS 12.10 FC4. I only want noteworthy event ( ALRM_ALL_EVENTS 0) But, It seems "adding a virtual shared memory segment " is not a noteworthy event, 16:42:36 Dynamically allocated new virtual shared memory segment (size 1000KB) 16:42:36 Memory sizes:resident:114076 KB, vir…
IDS 12.10 on HP-UX- DS Total Memory
Unfortunately there are not best practices for tuning an Informix instance since all workloads are different. Tuning can only be done after observing actual production workloads. There are ways you can capture your production workloads on the older system and test them on the new…
backups
Trying to find what created lots of V mem segments, I found that during 2 backups lots of blocks where allocated. Do any kind of backup creates blocks on ony kind of dbspace?. What kind of monitoring should I do to catch V segment creators? 10:25:28 Dynamically allocated new v…
IFX_XFER_SHMBASE
ok, in this case you could temporarily start up the instance with a minimum amount of memory configured (very small bufferpool and SHMVIRTSIZE) - just for the purpose of collecting the process explorer outputs. In this case it's much more likely that onstat and other on... tools…
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)…
ALARMPROGRAM: Event Alarms Filtering?
Hello, IDS 11.70 I need to find out if there is a way to force ALARMPROGRAM not to trigger itself whenever certain types of events happen. For example, I am making dbexport backups of all dbs during night, and I need to temporarily stop ER. This event is with type WARNING and …
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
shared memory issue
Hi I am frequently getting below error, I know I am using workgroup Edition hence there is a limit, Using shared memory... however transaction are so less hence dont expect this error very frequently Warning: The IBM IDS Growth Edition license restriction limits the total share…
Panic analysis
Its the OOM=20 Linux has an Out Of Memory tool. Signal 9 is the clue. Informix never issues a signal 8, or kill -9, in its c= ode. Basically you Os OOM manager felt too much memory consumed and it killed the= culprit=20 Sent from my iPhone > On Jun 19, 2015, at 10:31 AM, FRA…
RFE request for session details during virtual shm
Thanks a lot, Jacques. From the manual page, SHMVIRT_ALLOCSEG it says that: alarm_level: Optional. An integer value from 1 to 5 that specifies the level of the event alarm to raise: 1 = Not noteworthy, 2 = Information, 3 = Attention (Default), 4 = Emergency, 5 = Fatal. The event…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Second instance IDS issue
Yann SERVERNAME/ALIAS - sqlhosts - /etc/services must all be OK if both instances will start manually, disregard my comment. When you run /etc/init.d/infomrix start manually are yo running as root or informix or/and is there an su - informix in the script ? Reversing out all my …
VERY slow BTS index build
Retry with Kate & Art's suggestions. Seems to be similar results. BUT also discovered something else that might shed light: Informix 11.5.FC6 running on a Sun Solaris 10 system. PDQ set to 100. PSORT_NPROCS = 8. changes to onconfig: MULTI_INDEX_SCAN 0 VP_MEMORY_CACHE_KB 819200 …
DE Edition
Yes. It=92s hardcoded into the code along with the limitations on CPU = VPS, SHMTOTAL and so on. Carlton ------------------------------------------------- Carlton Doe Flower Mound, TX No trees were killed in the transmission of this email, however a large = number of electrons…
virtual segment question
Does onmode -F release the extra segments? Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organiza…
shmget ENOSPC Informix 11.70FC7 on Ubuntu 64 bit
Hi, "shmget: [ENOSPC][28]: key 52564864: The server could not allocate shared memory because an operating system limit was reached" So, what can we infer from this? 1. The number of shared memory segments allocated to your instance has reached: 0x52564864 - 0x52564801 = 0x63,…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
class B segments
B is a dynamic buffer segment. V12 can expand the buffer pools on the fly if needed. Art Art S. Kagel Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG or any other organization with which I sm associated either explicitely…
Optimising index builds
>> How are the tables fragmented? How much memory can PDQ 100% allocate? 1. Round-robin 2. I assume it is constrained by SHMVIRTSIZE, which is 24000000? Thx Neil…
Logical logs - push or pull?
Hi Bill, Since a "LOG FULL" is an internal engine event (among the many other events) and that the engine executes the alarm program of your choice (the name of the alarm program should be defined in the ALARMPROGRAM onconfig parameter, I prefer to keep this solution. Plus the …
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.…
out of shared memory?
John How much memory is currently allocated to the engine (onstat -g seg) and what is the total memory use on the machine (ipcs -ma ). Keith On 3 Sep 2013 22:33, "John Adamski" <adamski@graceland.edu> wrote: > HPUX 11.31 HP BL870c integer server 24GB memeory > Informix 11.70.FC…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
Temporary tables called th_overflow_ffffff
Ok, that means: a) I could review the queries and create indexes for reduce the amount of hash joins. b) I could increase the size the shared memory (SHMVIRTSIZE) so that the majority of hash joins are running in memory. Please tell me if this statements are correct Thanks in a…
Estimate size of virtual portion of shared memory
Hi, I´m trying to estimate the size of the initial virtual segment of shared memory to give an accurate value to SHMVIRTSIZE in my ONCONFIG file. I´ve found the formula in IDS 11.50 Performance Guide, but in the first step it is said: "Estimate a value for the thread pool after…
Re: Issue about logical restore
> This looks to be a defect. It appears to have something to do with recovery and running out of memory, > which your server appears to be having memory issues based on the MSGPATH output you've included > (the "out of virtual shared memory messages" prior to the rest of the fail…
Re: Issue about logical restore
> This looks to be a defect. It appears to have something to do with recovery and running out of memory, > which your server appears to be having memory issues based on the MSGPATH output you've included > (the "out of virtual shared memory messages" prior to the rest of the fail…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
Issue about logical restore
Original post: Hi, I need help on an issue which occur during logical restore on Informix Dynamic Server Version 9.30.UC2 can someone help me? When I run a logical restore, I get an the error message such as the one reported at the end of email. How can I limit the number of vi…
problem with IDS 11.70FC4 and RedHat 5.6
Hi, What is the output of onstat -g seg ? Its good to tune VP_MEMORY_CACHE_KB 10240 also. rgds schillache…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Initializing shared memory
Here is what I get if I don't set the FULL_DISK_INIT to 1: Fri Jan 18 07:24:06 2013 07:24:06 Event alarms enabled. ALARMPROG = '/opt/informix/etc/no_log.sh' 07:24:06 Booting Language <c> from module <> 07:24:06 Loading Module <CNULL> 07:24:06 Booting Language <builtin> from mod…
Resident memory size vs. Virtual memory size
Hi, Check for this bug , APAR= IC77372 : ABNORMAL ALLOCATION OF VIRTUAL MEMORY SEGMENTS WHEN CREATE INDEX ON FRAGMENTED TABLES. rgds schillache…
Informix 11.70.FC4 (Innovator-C edition) crash on Linux
On Tuesday, December 18, 2012 3:43:34 AM UTC-6, checc...@libero.it wrote: <stuff cut> > > The architecture is composed by 2 nodes only: one (primary) replicate some tables on a secondary-server // the replication is mono-directional. Can the message below be related to the panic?…
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,…
Interpreting event alarm messages
we are on 11.7.FC5 on AIX 6.1 seeing many instances of dynamic lock allocation - however, that is the only thing that gets written to the online log and the ph_alert table: "dynamically allocated 1000000 locks" however, the manual states that " if a thread attempts to acquire a …
Increased Swap usage by IDS
Don't use top to see memory utilization by Informix, look at onstat - or the Total line of onstat -g seg. Your Informix engine has only allocated about 569 MB. Each of those oninit processes in top are attaching to the same shared memory segments and that is why top gives the im…
shared memory questions
I changed shmtotal as you suggested. 16:34:06 Onconfig parameter SHMTOTAL modified from 0 to 2097152. The license message went away the next time I started the IDS. Thanks, Jacques. -----Original Message----- From: JACQUES RENAUT Sent: Tuesday, October 09, 2012 3:58 PM To: ids@i…
shared memory
This concerns IDS 11.70.TC5IE on Windows Server 2008 . This article http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm .perf.doc%2Fids_prf_750.htm defines buffer_value = (BUFFERS * pagesize) + (BUFFERS * 254) + 250000and goes on to say: âIf you hav…
Monitoring IDS Load
For load/strees testing - versus normal performance monitoring - I would concentrate on the stats displayed by onstat -D, onstat -p (including calculating the basic metrics - BR, BTR, and RAU), onstat -g iov, onstat -g iof, onstat -g ppf, onstat -g seg as well as operating perfor…
alarmprogram.sh when LTAPEDEV /dev/null
2 dr-xr-xr-x 92 bin bin 8192 Apr 6 2011 /opt 61926 drwxr-xr-x 38 informix informix 8192 Sep 13 2011 /opt/informix 61927 drwxrwxr-x 4 informix informix 8192 Aug 13 09:34 /opt/informix/etc 83027 -rwxr-xr-x 1 informix informix 19932 Aug 4 2010 /opt/informix/etc/alarmprogram.sh head…
RESIDENT onconfig Parameter and Multiple Instances
I've been doing some research as well, and discovered these parameters can be changed in /etc/security/limits.conf file... I've changed the memlock, rss, and as services values to unlimited, but am still having the same issue...out of curiosity, what is the overhead of Informix, …
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
alrmprogram
On Tuesday, June 26, 2012 9:28:44 AM UTC-5, tom...@gmail.com wrote: > hello > > we recently upgraded from version 11.7.FC4 to 11.7.FC5 on AIX 6.1. > The scripts we use for the backups and alarms are the same (except for the new paths, of course) and we have ADMIN and PAGER set to…
Moving IDS to a new host
If you have RESIDENT set to a non-zero value in the ONCONFIG file, try setting it to zero. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do …
IDS crashed when you run ontape backup
From the best I can recall this sounds like an old defect with ontape; when you try to take an archive and the total size of your allocated shared memory (onstat -g seg) is greater than 2 gig (or slightly greater )this error will occur . (ontape is separate binary from the engine…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
Memory down and shared memory not initialized
I compiled utils2_ak. When executing printFreeB I got a message the library libifsql.so could not be found. So I put the lines below in /etc/ld.so.conf and exectued ldconfig. /opt/informix/lib /opt/informix/lib/c++ /opt/informix/lib/cli /opt/informix/lib/csm /opt/informix/lib/dm…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
Linux: oninit returns "shared memory base address illegal", fails to start
You need to set the number of huge memory pages available for Informix to use. Your OS is currently configured to allow none (see the message log output from during the boot). To do that, say you want to allow for 12GB of huge page memory (pages are 2MB each), you can run: ech…
Problem with identifying root cause of continual m
Ok. I think it probably some application problem. Could you check out if your Informix server is using OPTOFC=1 value? It should. I also suggest you to search for the JDBC connection string (or properties), for IFX_AUTOFREE parameter. It also must be turned on. Maybe that´s the c…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
11.5 UC7E crashes
Hello again, today I changed the shared memory parameters and everything looks fine ... so far. The problem with random crashes: you´ll never can be sure you fix them. I increased the kernel-parameters for Debian and then could take much larger values for SHMVIRTSIZE (512 MB) a…
event trigger/alarm
Hi, Folks, IDS11.50 FC8, Redhat Linux. I am going to narrow down which job peoridically caused IDS to add new memory segments. Basically, the plan is, whenever IDS is adding a new memory segment( as in the attached online log messge) , the event will trigger my script to take …
IDS Monitoring tolls
I'm administering a large number of IBM-DB instance under HP-UX, with version IDS 11.50, XPS, some DB2 databases. Today, I use HP-Open View (OVO) to monitoring. with this tool, I generate logs and alarm events via e-mail. My organization ask me if exist another monitoring tools…
11.50.FC8 aio memory pool allocation seems high
after upgrading our client from 11.50.FC5 to 11.50.FC8 (aix) , the engine uses aprx 130 meg more of virtual shared memory. By comparing historical onstats between the two versions the increase is in the aio memory pool (~230 meg) , where on FC5 the usage topped around 90 megs... …
Shared memory connection to HDR Secondary
Folks, IDS11.50 FC8, Redhat Linux It is not allowed to have a shared memory connection to a HDR Secondary( with dbacess..), is it? Thanks, Frank --001517588cfa01cb4304b178d099…
How to monitor the memory usage of OLTP and OLAP
Hi, I set SHMVIRTSIZE TO 2048000 ,DS_TOTAL_MEMORY to 1024000. My application has both OLTP and OLAP feature. I want to optimize the memory usage? How to monitor the real memory usage for OLTP portion and OLAP portion in the production enviroment? thanks for your time.…
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
The memory you specify in SHMTOTAL and SHMVIRTSIZE is specified in KBytes. The memory shown in onstat -g seg in in bytes Informix ideally will not stop when you reach SHMTOTAL, but it's hard to handle low memory conditions (sometimes to rollback you need more memory for example)…
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
Are you saying I should have SHMTOTAL 6442450944 ? Will the IDS stop if memory exceeds that number? From: Fernando Nunes Sent: Wednesday, September 21, 2011 5:12 AM To: Bill Hamilton Cc: informix-list@iiug.org Subject: Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE It …
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
It should not even start... You're saying that the memory limit is inferior to the initial memory allocation! It would be interesting to see the online.log of the instance... Regards On Tue, Sep 20, 2011 at 6:06 PM, Bill Hamilton <garage_dba@hotmail.com>wrote: > Many Thanks.…
Re: Need Stability on I5 1st edition on IDS 11.70.TC1IE
Many Thanks. We will see if that helps. I now have this in the config ... RESIDENT -1 SHMBASE 0xc000000L SHMVIRTSIZE 130624 SHMADD 26124 EXTSHMADD 26124 SHMTOTAL 6144 SHMVIRT_ALLOCSEG 0,3 Will the IDS stop if memory exceeds 6144kb ? From: Alexandre Marini Sent: Tuesday, Septem…
Can Informix 9.40 UC7 use more than 2 GB of memory
You can, however on AIX you have to pay attention to boundary aligments which require segments (and all added segments, i.e. shmadd) be aligned on 262 meg boundary alignments. This is easily overlooked as you may wind up with memory allocation errors and find out you wasted acces…
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…
increasing memory IDS11.50.FC3
hello all, We are increasing the RAM from 8Gb to 32Gb on the HP-UX 11.11 server.Just a quick question...should we be tuning informix to reflect the increase in memory? current settings are.... SHMVIRTSIZE 2784000 #SHMADD 128000 SHMADD 256000 EXTSHMADD 8192 SHMTOTAL 10000000 Th…
Re: ids 11.70.TC1IE limits
Thanks, Art. Some Indian gentleman answered and wanted a customer# before he would help me. My boss cannot find it. That was like 1994 that we had such a number. Why would you need a customer# if this product is free? I will install into a new directory and change onconfig to po…
Re: ids 11.70.TC1IE limits
Does not work for me. I guess I will install into a new folder, disable old service, change onconfig to point to the old rootdbs and go from there. -----Original Message----- From: Jack Parker Sent: Sunday, July 17, 2011 8:57 AM To: Art Kagel Cc: Bill Hamilton ; iiug Subject: Re…
What is virtual about Informix "virtual segment of shared memory"?
In the IDS memory architecture, why is the "virtual" portion of shared memory called "virtual?" It seems to reside in that portion of physical memory that the O/S designates to share between multiple processes, but never seems to have anything to do with swapping/paging to disk.…
Re: ids 11.70.TC1IE limits
IBM Support: 1-800-426-7378 or 1-888-876-9797 Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTool…
Re: ids 11.70.TC1IE limits
Just call where? I have been on their crappy website for an hour and cannot find out whom to call. The chat would be ok, but appears broken. From: Art Kagel Sent: Sunday, July 17, 2011 8:55 AM To: Bill Hamilton Cc: iiug Subject: Re: ids 11.70.TC1IE limits I don't know. I've on…
Re: ids 11.70.TC1IE limits
An uninstall is not required. It should just upgrade. I haven't worked the 32 bit version, but have played around with the 64bit over the past several weeks. j. On Jul 17, 2011, at 9:55 AM, Art Kagel wrote: > I don't know. I've only installed Informix on Windows myself once…
Re: ids 11.70.TC1IE limits
I don't know. I've only installed Informix on Windows myself once on my laptop. However, installation support is provided by IBM even for Innovator Edition without paid support, so call in. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-m…
Re: ids 11.70.TC1IE limits
Thanks a lot , Art. I downloaded 11.70.TC3IE as you suggested but it failed to install, saying that I cancelled it, but I did not. I think it expects me to uninstall TC1 first, but it does not say that. Do you think that an uninstall is required? Install Log Detail: Refresh Win…
Re: ids 11.70.TC1IE limits
If you have paid for support on your IE server, call IBM and see if this is a known issue. If not, you might try installing 11.70.TC3IE or even 11.70.FC3 (64bit) for windows. 11.70.xC3 fixes some problems in .xC1 & .xC2. Art Art S. Kagel Advanced DataTools (www.advancedatatoo…
ids 11.70.TC1IE limits
This question involves IBM Informix Dynamic Server Version 11.70.TC1IE running on Windows Server 2008 Enterprise, service pack 2. This server uses a new Intel I5 processor with 4gb of ram. It seems that IDS freezes several times a day and no programs can get a connection. Even d…
IDs tries to allocate virtual memro segments
Hi, We are using IDS V11.50.FC8 on HP and we have a strange behavior. The engine tries to allocate virtual segments non stop. The engine has been running since the end of April without any problems. The engine allocated a bunch of virtual memory segments until it reached the …
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.…
Enterprise Replication event alarm code question
IDS 11.50.UC5 RHEL 5 We have the alarm program picking up event 71 for ER node disconnected and alerting through to our support system to go find out where the node went (network fault etc). The question is what is the event code to say "connected again"? I can't find it in the …
onbar restore issues
I am getting followig errors in onbar when trying to restore on another server. Please guide me and point out if i am doing some mistakes. onbar -m Onbar activity log file: /export/home/informix/informix11-50FC7/tmp/bar_act.log 2011-05-12 21:39:08 25765 25763 Successfully conne…
Is KAIO in use
Hi, I'm running informix engine Version 9.40.FC9 on an AIX box and this what is said in the ids_machine_notes_9.40.txt : 3. Kernel Asynchronous I/O (KAIO) KAIO is enabled by default on this platform. The AIO driver must be configured into the AIX system for KAIO to work. Inst…
Informix Shared Memory Problem
Il 15/02/2011 12:24, Art Kagel ha scritto: > Is it possible that the problem is that you have too many shared memory > segments? There is a kernel parameter to set the maximum number of shared > segments per process. You can adjust that. If that's the problem, another > solution …
RE: operating system limit was reached
Hi Art, yes, you are right. All ids instances run under the "default"-project in Solaris 10. The limit of number of shared mem segs ist 128 (default). We will create new projects with bigger values. Thanks to all. Reinhard. From: Art Kagel [mailto:art.kagel@gmail.com]…
Re: operating system limit was reached
It's either the number of shared memory segments per process or the maximum shared memory per process. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mi…
operating system limit was reached
Hi all, IDS 11.50.FC7W3 I found this in the message log (sorry, it's a bit long): 17:36:56 IBM Informix Dynamic Server Started. 17:36:56 Requested shared memory segment size rounded from 116736KB to 131072KB 17:36:56 Shared memory segment will use large pages with intimate …
Freeing memory when onmode -F doesnt
THanks for the information folks. I did hear that it was bad to have several segs on HP-UX hence the questiom On one production instance we have 11 V seg. On this instance I will need to increase SHMVIRTSIZE when I get the chance.…
Physical Log Size
How did you "increase" the size? You can only do that song onparams. You cannot do that just by changing the Onconfig file Art On Jan 25, 2011 12:10 PM, "KENT GRUNDEN" <k.grunden@hoogwegtus.com> wrote: > IDS 11.50.FC4WE Windows Server 2008 64bit > > I keep getting the message wh…
Instance Crashed !!
Hi, We are using IDS FC6 on Sun Solaris. We've allocated 8GB of Memory (SHMTOTAL) to one of our instance. When its memory approached 5.2 GB, it remained stable for around 1.5 hrs. Afterwards, the instance stopped response (even we could not access it using dbaccess). The checkpoi…
PSORT_DBTEMP
Hello, IDS 11.50.FC5 AIX 5.3 I am having trouble using PSORT_DBTEMP this morning. I am attempting to build an index on a large table (450,xxx,xxx rows - 924 rowsize). I have PSORT_NPROCS set to 8 and PSORT_DBTEMP set to a colon delimited set of 8 unix directories export PSORT_…
Shared memory segments
Don't have an answer for you off hand, but I did fix your subject line so it doesn't look like spam. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of qingchuntrade Sent: Monday, December 27, 2010 7:54 PM…
Re: IDS GE license restriction limits warning messages...
Can you post the output of "onstat -g env"? Regards. On Thu, Dec 16, 2010 at 8:58 PM, June Nebab LKINY <jnebab@idealcut.com>wrote: > Good catch Art, fixed that but as you have stated it had nothing to do > with it. > > > > ----- Original Message ----- > From: "Art Kagel" <art.…
Re: IDS GE license restriction limits warning messages...
June: This one setting, at least, is not correct: SHMNOACCESS cpu,num=1,noage This looks like your SHMNOACCESS and VPCLASS settings got combined somehow. Don't think this has anything to do with the warning you are seeing, but.... Art Art S. Kagel Advanced DataTools (www…
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…
rootdbs size
The problem, as someone already mentioned, is that you cannot position the physical log in a different dbspace during server initialization since only the rootdbs will exist at that time. Change PHYSFILE to something rather small (less than 300MB) and remove the no longer support…
Need Help- IDS 11.5 Stored procedures.
Hi, After migration from IDS 10. to IDS 11.5, It observed that the stored procedure with recursive/nested stored procedure calls working fine on IDS 10, is not releasing the memory on new Informix Engine IDS 11.5. Could you please help to resolve the issue. I am monitoring the o…
CDR Grouper FanOut thread is aborting
Folks, Build Version: 11.10.UC2 Build OS: AIX 5.3 The ER does not work properly due to a "out of virtual shared memory " problem in one site. Is there any EASY DRUG to treat "CDR Grouper FanOut thread is aborting." ? (instead of recreating whole the ER) Thanks, Frank .......…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
Memory Management
On Sep 1, 3:26 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > shorti wrote: > > Hello, I have another question. Again, new to Informix and just doing > > research for a Linux implementation. Is there a setting that can > > control the total database memory allowed for…
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…
Shared memory problem
IDS 9.40 UC4 on Linux (yes, I know ...) 1. Initialising the instance with a shared memory connection it just hangs at: 01:09:26 Maximum server connections 0 01:09:26 Dataskip is now OFF for all dbspaces 01:09:26 On-Line Mode 01:09:26 Building 'sysmaster' database ... Never…
optimum usage of resources
The onstat -g seg shows IBM Informix Dynamic Server Version 9.40.TC9 -- On-Line -- Up 07:08:41 -- 1319232 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 1381386241 1381386241 c000000 302317568 226624 R 73772 36 1381386242 1381386242 1e050000 1048576000 326…
Re: Dynamically allocated new virtual shared memory segment repeatdly
The engine will not free a virtual segment once it has been created under the assumption that if the space was needed once, it will be needed again. Some of the reasons for the multiple segments can be: - SHMADD is too small - Multiple sessions needed space simultaneously …
Fwd: Dynamically allocated new virtual shared memory segment repeatdly
Dear ART, Thank you for your answer. My Informix version is 10.00 UC6 (i know 9/2010 end of support...) On Linux Box (RHL). I would like to know, besides complex queries and sort, which other actions could generate the increase on these segments? Views? Is there any tool, besi…
Re: Dynamically allocated new virtual shared memory segment repeatdly
You can release shared memory segments (except for the RESIDENT segment, Message segments, and the first virtual segment) by running "onmode -F". You don't state what version you are running, so I'll warn you that on some IDS 7.3x/9.30 and earlier releases running onmode -F can s…
Dynamically allocated new virtual shared memory segment repeatdly
Since a long time we have some troubles with Shared Memory segments assigned by the engine. When we run an onstat - g seg, this one shows that is always assigning new segments and it seems that they never release them, because sometimes appears the following error: [ENOMEM][12]: …
Post-Upgrade HPL issue
I want to add that there was a single config change made to the onconfig on the affected instance - we doubled shmvirtsize, going from 1 gig to 2 gig. The issue seems resource related for sure. I just started another set of jobs, only running two at a time and they ran fine. When…
Alarm for New virtual shared memory segment
Hello, I was wondering if there is any way for Informix to alert us if it "Dynamically allocated new virtual shared memory segment". I tried getting the ALARMPROGRAM to alert, though it seems that this action does not trigger the ALARMPROGRAM. Any ideas? 16:17:26 Requested s…
951: Incorrect password or user informix is not kn
Hi, I forgot to mention that, on this instance i can connect with an unix user other than 'informix'. Doesn't this alleviates the assumption of 'a lack of shared memory or a problem with shared memory' ? Regards…
Create Another Instance On The Same Server
Ignore previous post I changed shmvirtsize and got the instace initialized. Thanks for the help.…
Ontape restore : Fast recovery hangs
Hi, I've launched an 'ontape -r -rename -f <file>' to restore an instance version 940 from a tape. But since 2 hours the instance is in Fast Recovery mode as 'onstat -' shows below : informix@pcoi01:pcoipcoi_tcp:/bases/informix/pcoipcoi/var/bdump> onstat - IBM Informix Dynamic…
Re: performance improvements for dbimport?
Thanks for all your valuable input. I changed some parameters now: 21:09:27 Onconfig parameter BUFFERPOOL modified from size=2K,buffers=262144,lrus=8,lru_min_dirty=5.0,lru_max_dirty=10.0 to size=2K,buffers=524288,lrus=8,lru_min_dirty=10.0,lru_max_dirty=50.0. 21:09:27 Onconfig p…
Re: performance improvements for dbimport?
Your SHMVIRTSIZE (262144 ) is small. You can increase it quite bit. It will improve. You have 8 GB memory, some times, depends on your data usage pattern , balancing the Buffer size and the SHMVIRTSIZE can give you a lot better performance. Frank On Wed, Mar 10, 2010 …
Handling Memory Limits
Occasionally we run into a situation on development hosts in which the informixserver is running several memory-intensive processes and attempts to procure more memory than the O/S permits. Since we don't set SHMTOTAL (and RESIDENT=0), the informixserver at first fills its tmp d…
shared memory parameters
Having trouble with share memory parameters. I am trying to locate each piece of the memory size number reported by "onstat -". So far I have been able to correlate changes in onconfig with changes in that onstat number. However, I haven't been able to get it all and can't seem t…
Performance degradation over a period
Hi, what do you mean by some period: seconds, minutes, hours, days, months ? Many indexes on the tables ? New tables/indexes, when the application starts ? Regards, Andreas > ------------------------------------------- SPAR Österreichische Warenhandels-AG Hauptzentrale A - 5…
2 shared memory segments
Informix 10.00.HC5 HP-UX 11i v2 Recently, I've started getting message like the following when I restart the server Could not create single shared memory segment with resident and non-resident partitions. Proceeding to create 2 shared memory segments instead. Sometimes, the se…
garbage text in SHMNOACCESS parameter
Just a guess. What's the hex value for that string? > From: brenddie@gmail.com > Subject: garbage text in SHMNOACCESS parameter > Date: Wed, 20 Jan 2010 19:46:16 -0800 > To: informix-list@iiug.org > > While doing some changes to the onconfig file I noticed that the > SHMNOACCESS…
alarmprogram.sh
Good Morning My Informix dbs are all IDS 10FC4 and my alarm program in configure with the following parameter: ALRM_ATTENTION=3 In order to identify an issue the Im having with some particular session that is causing a excess of additional shared memory segments I would like t…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
Re: Resident Memory larger then expected
"Art Kagel" <art.kagel@gmail.com> wrote in message news:mailman.377.1260535600.6236.informix-list@iiug.org... >> I haven't yet overrun SHMTOTAL on an 11.50 instance since I always set >> SHMTOTAL to zero (unlimited) now, but in the past, if the engine wanted >> more virtual memor…
shared memory not initialized for INFORMIXSERVER
When I try to start Informix Dynamix Server the following massage appears: shared memory not initialized for INFORMIXSERVER Any idea???…
shered memory not initialized for INFORMIXSERVER
When I am trying to start informix server the following massage apears: shared memory not initialized for INFORMIXSERVER Any idea??????…
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…
shared memory not initializing
Hi All, Can anybody help me. My shared memory not initializing and IDS was working fine before restore and restored was failed in the middle. I have executed oncheck -pr and getting below error. ONCONFIG config file error on element PHYSFILE. Value in reserved page: 30000 Val…
shared memory not initialized for INFORMIXSERVER
________________________________ From: Tang, Wally, CTR, DMA-Riv/IT Sent: Friday, September 18, 2009 9:28 AM To: 'ids@iiug.org' Subject: shared memory not initialized for INFORMIXSERVER Hi, On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we executed dbaccess dbn…
IDS 7.13 Monitoring tool
Is there any event ALARM program comes with informix 7.13 for monitoring Database server. What are the software/application that I can use to monitor our Database server health which is running on HP-UX 10.01. Please help me.…
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…
Informix virtual shared memory
We are running Informix 9.40.FC4 on HPUX-11i. For the past few weeks, we are experiencing this problem. The informix server keeps continuosuly allocating memory and never releases it back and allocates many virtual shared memory segments and finally runs out of shared memory and …
IDS instance memory
Hi, We are running 4 IDS (11.5 FC4) instances on a sun sparc machine with 8 GB physical memory. We can see the shared memory through "onstat -" command which is around 1 G. This machine is purely acting as databases server and no other application is runnig on it (like web applic…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
virtual share memory too big ?
Environment: Informix 7.31 S.O. HP-UX 11i I have an instance with an average workload of 1000 user sessions and 1200 threads. This instance have only one database with 2000 tables approximately. I have set the onconfig parameter SHMVIRTSIZE at 640 MB and SHMADD at 100 MB Due to …
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…
Update Stats for procedure uses too much Virt memory.
Get my dostats utility. It will recompile each routine individually which tends to take up much less memory that doing them all in a single statement as you have below. Dostats is contained in the package utils2_ak which you can download from the IIUG Software Repository. Art …
IDS 7.31 Solaris8 - Long Checkpoints
Hello, Here's the output op onstat -g seg: Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 10:22:10 -- 412752 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 94000 1394493441 a000000 268435456 24820 R* 31026 1742 94001 1394493442 1a000000 15360000…
-25588 error after CPU & fiber channel failure
John, See if the app can connect if it uses the network connection (carsitcp) instead of the shared memory connection. Mike…
btree invalidation
I have the following line in the output of onstat -g mem btree inval V c000000054330028 1745338368 149991704 1704431 213054 I'm care about that because the last week the number of memory segments (onstat -g seg) has increased and onmode -F has no efect. I've noticed that …
Best Use of Free Memory
In general, I'm just wondering about how to use additional free memory for Informix. We have a lot of boxes that might have 4,6, even 8+ GB's of memory that is never used. The only places I know to use it are SHMVIRTSIZE and BUFFERS. I was under the impression that SHMVIRTSIZE o…
Looking for comprehensive list of all IDS event class id and message parameters with associated severity
Does anybody know where I can obtain a comprehensive list of all of the IDS version 11.10 event class id and message parameters WITH the associated severity in regard to the alarm program? I have the separate lists, just need to know that what each individual CLASS ID has for a…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Audit Logs
If you have your own ALARM script, try trapping *all* alarms, including the 'message' ('info'?) type and just dumping the text to a file in /tmp. There *might* be a 'message' type that shows switching audit logs. -- Bob -------------- Original message -------------- From: "Fern…
Res: Solaris - Memory allocation error - Solved
This situation are solved... was a my mistake. I interpreted wrong the machine notes. Where i believed the parameters are automatically configured on the Solaris 10 and the man of rctladm not help to clarify. I just set all semaphores and memory configurations like su…
Solaris - Memory allocation error
Hi, I'm preparing a evaluating environment on Sun Solaris 10 SPARC with IDS 11.50 FC1TL (Time Limited). The Version of Solaris is: # isainfo -v 64-bit sparcv9 applications asi_blk_init vis2 vis 32-bit sparc applications asi_blk_init vis2 …
Informix allocating shared segments
It does sound like it could be a server memory leak. What you would want to do is to start monitoring onstat -g mem and onstat -g seg output. In the onstat -g mem output you would want to do comparisons on pool sizes and look for any pool or pools that might be continually growin…
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…
virtual portion memory size
I believe that parameter can be tweaked in '/etc/system' and is called 'shmmax' >From /usr/include/sys/shm.h: /* * Shared Memory information structure */ struct shminfo { int shmmax, /* max shared memory segment size */ shmmin, /* min shared memory segment size */ shmmni, /*…
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.…
The max size of BUFFERS in IDS9.40FC7 at Solaris?
That is means the maxsize of share memory segment is limited to 4GB... OK,Thanks all!…
Running out of virtual mem segments
Wonder if all those segments are really beging used. Might try this as a script and run it as user informix if informix owns the segments. ------------ #!/bin/ksh TMP=${0}.tmp ipcs -mob | grep "0 200" | grep -v "root" | grep -v "informix" > ${TMP} count=0 while read ipcs_val…
informix server is down
Make your SHMVIRTSIZE value much larger. THAMMANA VEERA VENKATA PHANI KUMAR <tvvphanikumar1@rediffmail.com> wrote: online.log:- 08:19:31 Maximum server connections 28 08:21:48 Dynamically allocated new virtual shared memory segment (size 8192KB) 08:21:51 Dynamically allocated n…
Do SHMVIRT_ALLOCSEG really prevent run out of mem
In ids11 ,if I set SHMVIRT_ALLOCSEG to SHMVIRT_ALLOCSEG ".8, 4",do it really prevent ids run out of memory? In previous version on HP platform, If ids run out of memory, ids will stopped.…
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…
convert IDS10UC5 to IDS11 UC1
HI, folks, we are doing conversion (migrate/upgrade..) from IDS10UC5 to IDS11 UC1. After we prepared, and oninit, it shows below. There should be not memory limit. AIX 5.3, 8G memory. Any idea? Thanks, Frank \\\\19:48:07 IBM Informix Dynamic Server Started. Fri Nov 30 19:48…
Update from Digital 7.31.FD1to ....
Baan IV run not on the same machine and connect to the informix server with an 1GB crossoverethernetcable. so we use not Shared Memory to access the database!…
Dynamic Virtual segment allocation - finding the cause?
IDS9.30HC5, HP-UX11i One of our hundreds of users has run something that's caused extra virtual segment allocation. Background: The system runs for months on a single Virtual segment of 600Mb, quite happily day and night with up to 300 connections, all running any one of the hund…
"Dynamically added new Virtual segment "question
> What do I do? (and don't start me on onmode -F on HP-UX!!!!!!!!!!) > First off is onstat -g seg to find the address of the new segment, no > problem. > But once I've done that, what's the next move? > I'm guessing onstat -g mem and find out what processes have a pool > starting…
how to know virtaul portion's empty space?
Hi, I want to know how much the SHMVIRTSIZE's size is reasonable, Is any way that I can monitor the virtual portion's used & free space ?…
shared memory limitations
Hi folks does someone know what are the maximum shared memory size that can be used both in IDS9 and IDS10 Thanks…
BAR_MAX_BACKUP - not spawning parallel threads
Version : 10 We are running onbar -b -l with BAR_MAX_BACKUP = 4 and BAR_NB_XPORT_COUNT = 10. But when I check the number of onbar process I just see one onbar_d process. I was expecting atleast 4 processes. Why is it just spawning one process. Is it because our SHMTOTAL is 0.…
shared memory already exists
I am using IDS 9.40, I get message informix log below, after I shutdown and take offline the database: 14:38:05 IBM Informix Dynamic Server Started. 14:38:05 shmget: [EEXIST][17]: key 52564801: shared memory already exists 14:38:05 mt_shm_init: can't create resident segment Cou…
Re: shared memory not initialized
Tom I may have missed this in the variety of posts ! but do i understand this is a new installation and has never run? If so have you actually initialised the engine (oninit -i) at any time? Keith On 13/08/07, Ogiwara Tsutomu <tsutomu_ogiwara@hotmail.com> wrote: > Hi Tom. > > …
Re: shared memory not initialized
Thanks Andreas, The system is resolving the host name fine. uname -n reports informix. when i ping informix, i get a reply from the correct IP, 192.168.26.66 Still no luck Tom On Aug 9, 4:55 am, Andreas Breitfeld <abrei...@de.ibm.com> wrote: > Maybe my hint regarding the 'set…
RE: shared memory not initialized
You didn't need to run oninit -v the second time, the first time (oninit -ivy) was enough. The second time around it tries to pop memory back in the same place as the last one. Check if the first one is still running: onstat - It probably is. If not, then you may have corrup…
RE: shared memory not initialized
The holy trinity is ONCONFIG, sqlhosts and /etc/services. Your entries look ok at this point - sounds like your rootdbs either does not exist or has wrong ownership/permissions (previous note). You also need environment variables: INFORMIXSERVER=informixserver (in your case) ON…
Re: [24]: out of shared memory segments, check sys
informix-list-bounces@iiug.org wrote on 08/08/2007 11:24:48 AM: ... > > When I defined export EXTSHM=ON in ".profile" of ROOT and INFORMIX > users and tried to restart the IDS, I faced following errors > therefore i had no other choice than to revert this change. > Sun Aug 5 01:…
shared memory not initialized
Please try disable randomization of the virtual address space. On CentOS and RedHat 5 this can be done for a new shell: setarch i686 -R sh or setarch i686 -R -L sh from which IDS can be started. On some CentOS and RHEL5 systems users reported shared libraries are loaded near…
oninit -i failure
Found the problem I had $ONCONFIG=/opt/informix/etc/onconfig. Should have been $ONCONFIG=onconfig On Aug 8, 2:03 am, tom.pri...@gmail.com wrote: > I'm trying to startup informix for the first time on a CentOS 4.5 > server. When I run oninit -i , I get the following error: > > …
Erroneous event alarm 7 "Initialization failure"
Just a gripe, really - a little while back our alerting system raised the above alarm (via ALARMPROGRAM) and initiated a callout, and all we found was "WARNING! Physical Log size 15000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physic…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
extra virtual mem segments
We are getting several extra virtual memory segments. Every source I read says to increase SHMVIRTSIZE so that you do not get extra segments. Can someone tell me why its bad to have the extra segments?…
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…
RE: error on initilization
Execute:User root:# ipcs -ma send tha exitThe freedom of Linux ... The power of InformixDate: Tue, 15 May 2007 16:30:29 -0400From: yunyaoqu@gmail.comTo: heathn@infobase.co.zwSubject: Re: FW: error on initilizationCC: informix-list@iiug.orgYou already have a instance running or th…
FW: error on initilization
_____ Hi this is after a restore ? Can anyone help ? Thanks Heath Zimbabwe Tue May 15 09:29:23 2007 09:29:23 Event alarms enabled. ALARMPROG = '/u/informix/etc/log_full.sh' 09:29:23 Booting Language <c> from module <> 09:29:23 Loading Module <CNULL> 09:2…
onmode -r on AIX?
Hi All, IDS 9.40.UC4 on AIX 5.1. I have reports of the same behaviour with IDS 10 but I havn't tested that myself. I cannot get a cold restore + logical logs working on AIX. It works on Solaris. It is when I choose to restore the logical logs that it fails. Works if I don't re…
Question on SHMVIRTSIZE
Are there any parameters that can be monitored to help determine whether or not increasing SHMVIRTSIZE will provide any benefit, or whether or not it is necessary? The only one I am aware of is if the engine dynamically allocates more memory, then this parameter should be increas…
how to fix the error "hpkaioaddseg: ASYNC_ADDSEG.
OK, it happen as Andreas Kutsche says. - enough memory/swapspace/shared memory available, enough segments available the IDS allocates a lots of segments,so the error act.…
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…
Informix Installation Crashed
When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting following error continuously ... can any body help where should I do??? In fact the "Setup" hangs, when "Launching sysmaster database ...", and then it crashes. Early response will be highly appreciated. …
Informix Installation Crashed
When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting following error continuously ... can any body help where should I do??? In fact the "Setup" hangs, when "Launching sysmaster database ...", and then it crashes. Early response will be highly appreciated. …
Re: Mapping cpuvp's to IBM virtual processors on p
On Thu, 2007-02-22 at 16:35 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > 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 …
RE: 10.0 xC6
David, 'onstat -g afr' should be used with a specific memory pool from 'onstat -g mem' that has a big memory allocation. As I mentioned, 'onstat -g mem' doesn't show anything at all for this case: memory is leaking to nowhere. ------------------------------------------ Alexey…
SHMTOTAL
IDS 10.0FC5 on RHEL AS 4 We have a system where, as ever, we have set SHMTOTAL to zero. Having run fine for months, the system has sporadically started taking, in a very short space of time, multiple shared memory segments. eg Saturday at 0800, fine with one V segment, by 1000…
shared memory already exists
HI, guys, AIX5.3 , IDS UC5 If we see the following problem, the only way is to turn off/on the power? informix@otto $ oninit oninit: Fatal error in shared memory creation informix@otto $ informix@otto $ onstat -m *** WARNING: IBM Informix Dynamic Server is no longer running. …
shared memory
In our IDS 7.31 server, onstat -g seg displays seven 'V's (Memory Segments). SHMVIRTSIZE 100000 SHMADD 100000 SHMTOTAL 0 At present 6th "V" is in use and one is free. Each memory segment is quickly getting exhausted. Why its getting utilised very quickly im running update stat…
Re: ISQL install problem
Hi Clive, I do have an unlimited shared memory connection, but am not sure of any others - is there a way that I can check this? Thanks Andy…
shared memory and tempdb spaces
I'm pretty new to Informix and AIX and have a bit of a problem. The Informix log is showing the error "out of shared memory segments". From the other posts I've figured that we've hit the 2GB SHM limit and are probably going to move to the 64bit platform, but in the meantime I'…
Re: onmode -F: is it just HP-UX?
> > >>onstat -g aft may give you a clue (by the address) as to what is being used in the virtual segments which cannot be released. > doh! onstat -g afr > > I'll do that, thanks. I'll also set SHMADD to 64Mb (up from 8) in > future. >…
onmode -ky hangs
We had a bulk LOAD -INSERT and caused the IDS hangs. see below log info. It remains hanging after I issued "onmode -ky". What should we do? Thanks, Frank ====== 12:29:38 dynamically allocated 100000 locks 12:29:47 dynamically allocated 100000 locks 12:30:01 Checkpoint Complet…
onmode -F: is it just HP-UX?
TBP (The Big Potato) wrote: > onmode -F is not a "garbage" collector (i.e. it will not trawl through all the V segments and try and move used bits into a lower > addressed segment). > > If there is ANY memory in the extra V segments which is used it will not release the V segmen…
Re: Resident Segments marked as virtual
Art S. Kagel wrote: > > Per the Administrator's Reference (paraphrase) since the largest single > shared memory segment is 4GB if you request > 4GB of BUFFERS the remainder > is allocated in VIRTUAL segments. If you want those segments to also be > marked as memory resident you …
SHMADD and EXTSHMADD
Hi, What is the difference between SHMADD and EXTSHMADD? We know the meaning of the SHMADD onconfig parameter. Thanks, Khaled Bentebal ConsultiX Email: khaled.bentebal@consult-ix.fr…
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
"TBP" <TheBigPotato@NotHere.Co.Uk> wrote in message news:scwRg.32880$Mh2.490@newsfe6-win.ntli.net... >> What is SHMBASE set to? [root~] onstat -c | grep SHMBASE SHMBASE 0x44000000L # Shared memory base address >> What does onstat -g seg report when you hit the "lim…
Resident Segments marked as virtual
Bispo wrote: > Hello everybody. > > I have IDS 7.31 FD6 running on AIX 5.3. For memory configuration I have > the following parameters in the onconfig file: > > BUFFERS 2100000 (aprox. 8.4 GB) > SHMVIRTSIZE 767000 > SHMTOTAL 0 > > Now see the onstat -g seg output: > > Informix Dy…
Shared Memory
HI,I hava a problem. /home/informix/etc>onstat - Informix Dynamic Server Version 9.30.UC4 -- On-Line -- Up 103 days 05:37:36 -- 269068 Kbytes How does it is calculate for "269068 Kbytes" ? tks…
Re: oninit PIDs and Shared memory segments
onstat -g glo will map the VP's (oninit's) to the os pids. or you can query from sysmaster select vpid,pid from sysvplst; onstat -g seg will map the shared memory segments. The shmkey will have to be converted to hex to match what shows in ipcs or you can query from sysmaster se…
RE: Contiguous shared memory segment allocation failed at 0xd0000000
SHMBASE is different in your config from standard - why? How much shared memory is allocated to this instance (onstat -g seg) ? How many locks do you need for this process (16:10:23 dynamically allocated 100000 locks) ? OR you could lock the table. You need to configure LOCK…
Contiguous shared memory segment allocation failed at 0xd0000000
I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested shared memory segment size rounded from 8604KB to 8608KB 16:10:23 Contiguous shared memory segment allocation failed at 0xd0000000.…
Contiguous shared memory segment allocation failed
I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested shared memory segment size rounded from 8604KB to 8608KB 16:10:23 Contiguous shared memory segment allocation failed at 0xd0000000. Al…
shared memory not initialized for INFORMIXSERVER
Greetings all- I'm looking for a nudge in the right direction for an issue I'm having. I'm running IDS 7.31.UD3 on W2k Server SP4. localhost name is cognos INFORMIXSERVER=data_archive I am working at the console of just the server. (not connecting via network) I am getting an …
Re: SHMTOTAL
danielyeap@gmail.com wrote: > Hi All, > I came across this line in the Informix 9.3 Administration Guide: > > If messages indicate on a regular basis that the database server needs > more > memory than SHMTOTAL allows, you have not configured the database > server correctly. Lowe…
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…
RE: SHMTOTAL
SHMTOTAL is the upper limit of the total memory size for IDS. If you set SHMTOTAL to 100 MB then resident size (BUFFERS) + virtual size (DS_TOTAL_MEMORY, etc) + message size can not exceed 100 MB. The Admin Guide is trying to tell you to reduce BUFFERS if you want to allow the …
SHMTOTAL
Hi All, I came across this line in the Informix 9.3 Administration Guide: If messages indicate on a regular basis that the database server needs more memory than SHMTOTAL allows, you have not configured the database server correctly. Lowering the value of BUFFERS or DS_TOTAL_MEM…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
onstat shared memory error
I am running INFORMIX IDS9.40 on Slackware 10.1 and everything works fine except that informix cannot run onstat due to the shared memory: permission denied error. The database chunks reside on a smart array disk system, so I did a raw /dev/raw/raw1 /dev/cciss/c0d0p3 so I woul…
Update statistics and shared memory
We are not exactly sure what our problem is, but any help would be greatly appreciated. We are running IDS 7.31.UD3-1 on AIX 4.3.3. We have been experiencing a problem for a number of years, but it had not been one that has caused us any major problems untill recently. Here is t…
Informix KAIO Error
Hi people !! I have a problem with Informix 7.31 with HP-UX 11i, during the KAIO initialization. Following the online.log Tue Jul 4 08:57:38 2006 08:57:38 Event alarms enabled. ALARMPROG = '/sgbd/informix/etc/log_full.sh' 08:57:44 DR: DRAUTO is 0 (Off) 08:57:44 Informix D…
Lock Table Overflow
Get my package utils3_ak from the IIUG Software Repository and compile and install the eventalarm.c in ALARMPROGRAM instead of log_full.sh. It will handle multiply occurring events like the lock table overflow event by ignoring all by the first to arrive in a given configurable p…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: shared memory segment size
Ok - the resident part of the shared memory comprised the header, bufferpool, Logical log buffer, Physical log buffer and locks. 1 400 000 Kbyte for bufferpool - we have 700 000 buffers and 2k for each buffer 128 Kbyte for 2 phys buffers 192 Kbyte for 3 logbuffs …
Re: shared memory segment size
The resident portion of shared memory depends on # of BUFFERS + # of LOCKS + LOGBUFF + PHYSBUFF + some SHM headers for more details - http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.admin.doc/admin276.htm Regards, Nilesh Friday, May 05, 2006 10:31…
shared memory segment size
Why has my shared memory segment this size? This is the output from onstat -g seg Segment Summary: id key addr size ovhd class blkused blkfree 36 1384138753 a000000 1613758464 266640 R 393773 211 37 1384138754 6a…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
EXTSHMADD New shared memory parameter?
Hi family. In configuring a new server, I noticed a parameter I have not noticed before: EXTSHMADD I'm trying to figure out from the "Administrator's Reference" exactly what is the functional difference between SHMADD and EXTSHMADD. The text reads: EXTSHMADD specifies the size…
IDS 10.UC4 memory allocation
I am planning to consolidate two informix instances on a single machine using informix 10.uc4 32bit version. This machine will be installed with 4 Gigs of Ram. On reading the 10.uc4 release notes it states that Maximum Capacity per Computer System is of 2 gigs (SHMVIRTSIZE) for t…
AW: BUFFERS on Solaris-Box
> The size of the resident portion seems to be 1220 MB. I would be glad if you > could explain this behaviour. this includes the memory it takes to store LOCKS configured etc. > system the SHMVIRTSIZE is 491520 and SHMADD is 98304 i would up it so you have one or 2 segs for SH…
BUFFERS on Solaris-Box
Hi, new job, new environment. I found two Solaris Database Server with IDS 9.40.FC4W2 here. The one has 32 GB RAM the other 12 GB RAM. Server db1 (32 GB) Uname -a: SunOS db1 5.9 Generic_117171-12 sun4u sparc SUNW,Netra-T12 Server db2 (12 GB) Uname -a: SunOS db2 5.8 Generic_1085…
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…
W2K Advanced Server /3GB (ontape not start)
Hi, everybody. We are running Informix 7.31.TD1X3 and SAP R/3 on it. We have upgraded to Win 2k Advanced Server in order to bypass the memory limit of 2GB. We have made the changes to the boot.ini according to the release notes to enable up to 3GB of memory. This works fine, but …
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Shared Memory challenge on AIX 5.1
It will use swap as necessary, it's no big deal as your users didn't (and shouldn't) notice anything. As an aside, why is your SHMADD so small? You must have had a fair few additional segments allocated to be using 1.2Gb. Regards Colin There are 10 types of people in the worl…
Re: Optimizing a BaaN installation
The query should not be causing problems. What does onstat -g seg give? Although you have resident set to 0 on the ONCONFIG there is an onmode command that can change this on the fly! Raise a bug report on the query. Also check $INFORMIXDIR/etc/sysmaster.sql. You will find th…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: IDS 7.30 do not start - NT
Your server only has 512M of memory. Check you onconfig parms and reduce the number of buffers, SHMVIRTSIZE, locks etc to reduce the amount of share memory requested, then start your server. Good luck, Brian >Hello, > >i have a problem with the informix database. It is on WIN …
Shared Memory not Initialized for INFORMIXSERVER on Informix IDS 7.31
For more informatio in my Log file appears: 09:23:21 (3) failure, system out of semaphores 09:23:21 Dynamically allocated new message shared memory segment (size 352KB) 09:23:21 Requested shared memory segment size rounded from 344KB to 352KB 09:23:21 Requested shared memory seg…
unable to attach to shared memory
Hi All, Tech Specs: IDS 7.31.FD7 O/S - Solaris 5.8 Generic_117350-26 sun4u sparc SUNW,Sun-Fire oncheck and onmonitor are giving errors: shmat: [22]: operating system error Unable to attach to shared memory. onstat -g seg gives Informix Dynamic Server Version 7.31.FD7 …
SHMBASE 0x44000000
Hi All, Redhat EL-AS3.0 Informix IDS 10.00.UC3 Physical Memory 8 GB OLTP One of our production server has got 3 instances (Live, Test and Test2). I know its not a good option to have test/dev instances on production server. You are right, eventually production server will have …
Little Help ASAP
I'm getting the following errors in the log when attempting to restart the engine after the server crashed. It appears it gets to a point in the recovery and wants to restart itself. HPUX 11.i v1 9.40 FC2 16:23:38 Dynamically allocated new virtual shared memory segment (size …
Shared Memory Permission Denied
Hi, when i execute onstat with informix user send this message: onstat: = Shared memory: permission denied. or when i go into onmonitor and sel. an option send the message: Unable to attach to shared memory. Permission denied Informix IDS 7.31.UD3 Unix, Solaris 5.6 thanks in a…
Max Locks Forever
Well, well I'm getting different results under IDS 10.00.TC3 under windows. with 2000 locks onstat -g seg gives:- Segment Summary: id key addr size ovhd class blkused blkfree 1381386241 1381386241 c000000 5308416 215512 R 1278 18 138138…
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…
Latch waits
I'm seeing quite a highish level of latch waits (lchwaits) - whats the best way to reduce this? Increase the shared memory?…
MAX Buffers
Greetings All, I'm currently in the process of migrating to a new box. Physical mem is 16 gig on the server. I'm able to bring the instance online using "BUFFERS 4096000" with "SHMVIRTSIZE 2048000". However, I would like to add another 250000 (4346000) buffers but I'm running…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Re: out of shared memory segments, check system SHMSEG on solaris 8 Informix crashed
On Thursday 02 June 2005 12:01, you wrote: > >From: david@smooth1.co.uk > >Reply-To: david@smooth1.co.uk > >To: informix-list@iiug.org > >Subject: Re: out of shared memory segments, check system SHMSEG on solaris > >8 Informix crashed > >Date: 1 Jun 2005 13:40:02 -0700 > > > >Cha…
Re: out of shared memory segments, check system SHMSEG on solaris 8 Informix
>From: david@smooth1.co.uk >Reply-To: david@smooth1.co.uk >To: informix-list@iiug.org >Subject: Re: out of shared memory segments, check system SHMSEG on solaris >8 Informix crashed >Date: 1 Jun 2005 13:40:02 -0700 > >Change SHMVIRTSIZE to 4Gb and SHMADD to 1Gb and restart IDS. >…
out of shared memory segments, check system SHMSEG on solaris 8 Informix crashed
Change SHMVIRTSIZE to 4Gb and SHMADD to 1Gb and restart IDS. When IDS has started use onmode to manually add You should move to IDS 10.0 64-bit version where you can have shared memory segments more than 4GB.…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
RE: Solaris memory management
My main concern is not Informix, but the limitation in the operating system. I had an AIX system, where I specified lots of memory in Informix, but AIX still had to break it up - could not handle such a large contigous chunk. I was not able to only have one virtual segment on …
RE: Solaris memory management
My main concern is not Informix, but the limitation in the operating system. I had an AIX system, where I specified lots of memory in Informix, but AIX still had to break it up - could not handle such a large contigous chunk. I was not able to only have one virtual segment on …
RE: Solaris memory management
-----Original Message----- From: Martin Fuerderer [mailto:MARTINFU@de.ibm.com] Sent: 11 April 2005 06:57 PM [dirk] owner-informix-list@iiug.org wrote on 11.04.2005 13:35:51: > I am trying to find out what the limit is on contiguous memory in > Solaris. Can I grab one segment of…
RE: Solaris memory management
-----Original Message----- From: Martin Fuerderer [mailto:MARTINFU@de.ibm.com] Sent: 11 April 2005 06:57 PM [dirk] owner-informix-list@iiug.org wrote on 11.04.2005 13:35:51: > I am trying to find out what the limit is on contiguous memory in > Solaris. Can I grab one segment of…
Re: Solaris memory management
Hi, On UNIX systems INFORMIX reserves memory in blocks( this is 8k each one). Your 20Gg of Memory are 20 Gb / 8Kb of contigous blocks. If you see in your onstat -g seg one virtual value, there are one contiguos Virtual segment. Otherwise, remember that INFORMIX manage a RESIDENT…
Re: Solaris memory management
Hi, in general this is configurable in the kernel. Maximum possible configuration may also depend on Solaris version, but I don't know. The kernel parameter may be something like shminfo_shmseg but I'm not 100% sure. Regards, Martin -- Martin Fuerderer IBM Informix Developmen…
Re: Solaris memory management
Hi, in general this is configurable in the kernel. Maximum possible configuration may also depend on Solaris version, but I don't know. The kernel parameter may be something like shminfo_shmseg but I'm not 100% sure. Regards, Martin -- Martin Fuerderer IBM Informix Developmen…
Solaris memory management
I am trying to find out what the limit is on contiguous memory in Solaris. Can I grab one segment of 20G, or will Solaris break the segment down into smaller pieces ? For example, if I run onstat -g seg, can I have one segment of 20G, or is this not possible ? I am using Solar…
Solaris memory management
I am trying to find out what the limit is on contiguous memory in Solaris. Can I grab one segment of 20G, or will Solaris break the segment down into smaller pieces ? For example, if I run onstat -g seg, can I have one segment of 20G, or is this not possible ? I am using Solar…
Re: 9.4 upgrade SHMVIRTSIZE problem
Andrew wrote: > Upgrade from 9.21 to 9.40 > Windows NT Advanced server SP3 > 4 Gig ram > > Had had SHMVIRTSIZE set to 655360 > > Did the upgrade and Informix failed on setting up the Shared memory. > Worked OK if it was reduced - to 327680, and stepped up OK to 557056, but > afte…
9.4 upgrade SHMVIRTSIZE problem
Upgrade from 9.21 to 9.40 Windows NT Advanced server SP3 4 Gig ram Had had SHMVIRTSIZE set to 655360 Did the upgrade and Informix failed on setting up the Shared memory. Worked OK if it was reduced - to 327680, and stepped up OK to 557056, but after that it just falls over when…
9.4 upgrade SHMVIRTSIZE problem
Upgrade from 9.21 to 9.40 Windows NT Advanced server SP3 4 Gig ram Had had SHMVIRTSIZE set to 655360 Did the upgrade and Informix failed on setting up the Shared memory. Worked OK if it was reduced - to 327680, and stepped up OK to 557056, but after that it just falls over when…
RE: Sudden & massive SHMADD activity; engine went BANG!
Sorry, got my threads mixed up here - just ignore my previous reply !! The cron job question was aimed at the missing primary key thread :-o -----Original Message----- From: Dirk Moolman Sent: 07 March 2005 11:44 AM To: 'Malcolm Perrior'; John Carlson; informix-list@iiug.org S…
RE: Sudden & massive SHMADD activity; engine went BANG!
Sorry, got my threads mixed up here - just ignore my previous reply !! The cron job question was aimed at the missing primary key thread :-o -----Original Message----- From: Dirk Moolman Sent: 07 March 2005 11:44 AM To: 'Malcolm Perrior'; John Carlson; informix-list@iiug.org S…
RE: Sudden & massive SHMADD activity; engine went BANG!
A cron job perhaps ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Malcolm Perrior Sent: 05 March 2005 03:41 PM To: John Carlson; informix-list@iiug.org Subject: Re: Sudden & massive SHMADD activity; engine went …
RE: Sudden & massive SHMADD activity; engine went BANG!
A cron job perhaps ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Malcolm Perrior Sent: 05 March 2005 03:41 PM To: John Carlson; informix-list@iiug.org Subject: Re: Sudden & massive SHMADD activity; engine went …
Re: Sudden & massive SHMADD activity; engine went BANG!
Well we have got some relatively new apps connecting via JDBC, and we have run into an issue before whereby the connection pools aren't freed unless they explicitly close the connections.... Sounds plausible. I'd appreciate a copy of the script if you're ok with that, thanks RK.…
Re: Sudden & massive SHMADD activity; engine went BANG!
Did the application software change recently. We had exactly the same problem on Mar 10 2004 when it added 8 SHMADD in 15 min and engine died. It was finally traced to sloppy coding in JDBC where they kept recycling the result set, leading to memory leaks in Informix session. To…
Re: Sudden & massive SHMADD activity; engine went BANG!
Did the application software change recently. We had exactly the same problem on Mar 10 2004 when it added 8 SHMADD in 15 min and engine died. It was finally traced to sloppy coding in JDBC where they kept recycling the result set, leading to memory leaks in Informix session. To…
Re: Sudden & massive SHMADD activity; engine went BANG!
--- John Carlson <jwcarlson1@yahoo.com.invalid> wrote: > > No one creating large indexes? > Not while I'm DBA, they don't ;-) All users are CONNECT-only except in a couple of very rare RESOURCE cases that I police very closely... > JWC > sending to informix-list…
Re: Sudden & massive SHMADD activity; engine went BANG!
--- John Carlson <jwcarlson1@yahoo.com.invalid> wrote: > > No one creating large indexes? > Not while I'm DBA, they don't ;-) All users are CONNECT-only except in a couple of very rare RESOURCE cases that I police very closely... > JWC > sending to informix-list…
Re: Sudden & massive SHMADD activity; engine went BANG!
On 4 Mar 2005 04:38:06 -0800, malc_p@btinternet.com wrote: >IDS9.30HC5; HP-UX11i; largely OLTP; 4ge applications on server; about >150 users. >Just now our engine suddenly allocated 48 SHMADD segments in under 5 >minutes and af'd itself into oblivion. >We normally blithely run w…
Re: Sudden & massive SHMADD activity; engine went BANG!
On 4 Mar 2005 04:38:06 -0800, malc_p@btinternet.com wrote: >IDS9.30HC5; HP-UX11i; largely OLTP; 4ge applications on server; about >150 users. >Just now our engine suddenly allocated 48 SHMADD segments in under 5 >minutes and af'd itself into oblivion. >We normally blithely run w…
RE: Sudden & massive SHMADD activity; engine went BANG!
Installed any new software recently (including ODBC connections) ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of malc_p@btinternet.com Sent: 04 March 2005 02:38 PM To: informix-list@iiug.org Subject: Sudden & mas…
RE: Sudden & massive SHMADD activity; engine went BANG!
Installed any new software recently (including ODBC connections) ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of malc_p@btinternet.com Sent: 04 March 2005 02:38 PM To: informix-list@iiug.org Subject: Sudden & mas…
Sudden & massive SHMADD activity; engine went BANG!
IDS9.30HC5; HP-UX11i; largely OLTP; 4ge applications on server; about 150 users. Just now our engine suddenly allocated 48 SHMADD segments in under 5 minutes and af'd itself into oblivion. We normally blithely run with just the initial SHMVIRTSIZE virtual segment and haven't adde…
Sudden & massive SHMADD activity; engine went BANG!
IDS9.30HC5; HP-UX11i; largely OLTP; 4ge applications on server; about 150 users. Just now our engine suddenly allocated 48 SHMADD segments in under 5 minutes and af'd itself into oblivion. We normally blithely run with just the initial SHMVIRTSIZE virtual segment and haven't adde…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
IDS 10 Download?
So many questions... I have played with multiple buffer pools and different page sizes... creating a dbspace with an 8k page size..oh wow! Make size is only 16K though...oracle (where I guess this idea came from) allows 64K! onstat -h (buffer hash chain info) gives two outputs …
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: On Informix Virtual Segments - SHMADD/SHMVIRTSIZE
Hi, hmm, I guess you now have to also look at the output of system command "ipcs -m", execute that as user root. This will tell you, how many SHM segments there are on the OS level. And this is the relevant info for the OS limits. [ If IDS requests from the OS an SHM segment th…
Re: On Informix Virtual Segments - SHMADD/SHMVIRTSIZE
I am not doing shared memory connections. Below is the output for onstat -g seg Informix Dynamic Server Version 7.31.UD7 -- On-Line -- Up 14 days 14:09:36 -- 1944016 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 19136525 …
Re: On Informix Virtual Segments - SHMADD/SHMVIRTSIZE
Are you using the shared memory interface to connect to the engine? If so then the message buffers count against the limit of 10. So if you ran into trouble after 2 segments were added, then I suspect that you might be running with 6 message buffer segments. That would be 6 me…
On Informix Virtual Segments - SHMADD/SHMVIRTSIZE
Can anyone help shedding some light on the following issue. Informix IBM tech is saying one thing while IBM AIX tech contradicts its counterpart. I have one IDS instance on AIX 5.2 and the Informix ver is 7.31.UD7 , 32bit SHMVIRTSISE set to 1100000 SHMADD set to 100000 BUFFE…
"Onmode -F " hangs engine
Konstantin, Per default for SAP systems the onconfig parameter SHMTOTAL is actually set to value 0. If you set SHMTOTAL to other value in similiar situation without any other configuration changes you will run into same problem but earlier than before. If the database system re…
Re: shared memory weirdness
Ian Spare wrote: >We're running a very old version of HPUX and Informix, the system will >shortly be retired so we're limping along for a short time. > >We're running out of shared memory though and it's killing the database, >to an extent it's something we're going to have live…
shared memory weirdness
We're running a very old version of HPUX and Informix, the system will shortly be retired so we're limping along for a short time. We're running out of shared memory though and it's killing the database, to an extent it's something we're going to have live with but something puz…
Re: Q: SHMTOTAL
Thanks Art. We decided to migrate to 64bit so I won't play around with 32bit Informix anymore. "Art S. Kagel" <kagel@bloomberg.net> wrote in message news:pan.2004.10.05.09.10.38.374298.1355@bloomberg.net... > On Tue, 28 Sep 2004 02:58:13 -0400, Davorin Kremenjas wrote: > > 32bit…
Re: Q: SHMTOTAL
On Tue, 28 Sep 2004 02:58:13 -0400, Davorin Kremenjas wrote: 32bit processes on Solaris can only access/attach about 3.6 GB of shared memory segments with no segment larger than 2 GB (or the OS configured maximum segment size which may be smaller). I have a test prog if you wan…
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'?…
Q: SHMTOTAL
IDS 9.40 UC3 (32-bit) on Solaris 9 (64-bit) on Sun Fire V480 with 4 processors and 12 GB of RAM. Hello everyone. I'm testing a new Informix configuration just to see if I can use as much of a system resources as I have. But, there seems to be a problem with the total amount of …
Config for new live system
I suppose I won't be much of a help but I'll try... > ROOTOFFSET 0 # Offset of root dbspace into device We had problems on Solaris 9 with zero offset. We set iz to 100 K and problems dissapeared. I think it has to do something with OS writing some info in fir…
Virtual Memory Question for IDS 7.31 on Windows
On Tue, 14 Sep 2004 18:17:30 -0400, Stefan.Gabriel wrote: > Hi all, > > I have a question regarding the virtual memory portion of informix shared > memory. What is the comparison between the size of the resident memory > compared to the size of the virtual memory? i.e, if the re…
Re: Questionable IDS 9.21 performance on HP-UX v11.11
"Madison Pruet" <mpruet@comcast.net> wrote in message news:<2JHXc.70108$Fg5.17160@attbi_s53>... > What does onstat -g seg look like? It was the last piece of info I posted .... only 3 segs. Jason > "Jason" <jasondinsdale@bigpond.com> wrote in message > news:494e6103.0408262219…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
virtual memory segments added
onstat -g mem displays the pool names (first column) onstat -g afr <poolname> displays the allocated fragments by address. If you run onstat -g seg, you get the logical address of the shared memory segments. Somthing like... for f in `onstat -g mem | cut -d ' ' -f 1 ` do o…
avoiding disk sorts or usage of temp spaces
ANDREAS KUTSCHE said: > Hello, > > our database server has a lot of memory. I would like to use some of that > memory to avoid disk sorts. Is there a possibility to tell the database > server to do bigger sorts in memory (environment variables, onconfig > parameters)? > > Further…
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…
Fatal error in shared memory
Trying to set-up Informix 7.31 UC4 on Solaris 2.6 everytime I try and start informix I get oninit: Fatal error in shared memory initialization I have set SHMBASE to 0x1000000 and also tried 0x1000000 as suggested in the documentation - both fail. The system has 512Mb of RAM and…
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…
cannot initialize root dbspace
$ 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 server run modesucceeded Reading configuration file '/informix/etc/on…
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: Reg Informix Alarm events.....
On Wed, 23 Jun 2004 10:09:56 -0400, Rajasekaran, Rajesh wrote: Check out my package utils3_ak contains my alarm program executable source eventalarm.c It is configured to handle most critical events out of the box and adding handling of lower priority events is trivial (support…
Reg Informix Alarm events.....
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_01C4592A.D26B7E18 Content-Type: text/plain; charset="iso-8859-1" Hello all, I have a requirement to track some of th…
RE: Memory allocation failed during query processing -AIX 5.1
have you turned on PDQ?, is the DS_TOTAL_MEMORY set greater than SHMTOTAL in the onconfig?. also, may need to check SHMADD onconfig parameter. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of CKGeier@nwc.edu Sent: Tu…
RE: Memory allocation failed during query processing -AIX 5.1
Are there any other instances on this server? (and all their onstat -g seg). What does onstat -g seg say? MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of CKGeier@nwc.edu > Sent: Wednesday, 23 June 2004 …
onload consuming shared memory
Hi all, we're just about to start a full database restore to recover from a failed onload session. I just want to try and determine what might have gone wrong to see if how we can do it better next time. We want to onload a table with blob data of about 300000 rows and 11GB of …
shared memory not initiaized for INFORMIXSERVER
I'm removing the indexes and recreating them in my informix database and all the onstat commands were working fine. Now all of a sudden I am seeing this error when performing any onstat commands: shared memory no initialized for INFORMIXSERVER 'informixservername' Why is this?…
Shared memory segment IDS 9.4
Hi, I defined 1200000 BUFFERS in $ONCONFIG file for IDS 9.4/AIX 5.3. I used a formula from Performance Guide and counted that the buffers should take in resdident portion of shared memory about 1200000 * 4 kB + 1200000 * 254 ~ 5 GB. I started IDS and found ( onstat -g seg ) t…
RE: problem during the compilation for ids 7.31UD1 running on lin
Double the size of your SHMVIRTSIZE and triple the size of your SHMADD. -----Original Message----- From: James Lim [mailto:jamescwlim@time.net.my] Sent: Wednesday, April 28, 2004 7:17 PM To: ids@iiug.org Subject: problem during the compilation for ids 7.31UD1 running on linux [2…
RE: problem during the compilation for ids 7.31UD1 running on lin
Jim, 1. It definitely makes sense to have SHMADD close to SHMVIRTSIZE to avoid having too many shared memory segments 2. You definitely face some server-side bug (7.31ud1 was not a very stable version, it makes sense to upgrade). It looks like something is causing severe server…
problem during the compilation for ids 7.31UD1 running on linux
Happy Day, I have a problem during the compilation for my object code. during the compilation it was running half-way then it stop in my online.log file it showing the error as below: 07:48:15 Dynamically allocated new virtual shared memory segment (size 8192KB) 07:48:15 Dynam…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Excess V-segment allocation - who's responsible?
HP-UX 11i (aka 11.11), IDS 9.30HC5 Our system runs well and within its initial Virtual shared memory allocation of 400Mb most of the time, but every now and then it goes mad and allocates load of SHMADD-sized Vsegs sized at 8Mb (where loads >=8), which as we all know, is not good…
Shared memory and SELECT-Performance
Hi all, IDS 9.4 UC3 / RH 9 I have a performance-question: The quality of our application depends strongly on the execution-time of one single SQL-Select-Statement. Of course, the parameters in it's Where-Clause are different from time to time and from user to user, but we can u…
SHARED MEMORY LIMIT
Is posible to use with informix of 32 bits more than 2GB of shared memory in a Linux Machine? The base address in onconfig is: SHMBASE 0x41000000 Thanks in advance,…
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.32/64 bits
You can migrate from a 64-bit 9.30FC*/9.40FC* to a 32-bit 9.30UC*/9.40UC* database without exporting/importing and is quite easy to do. There is a shell script in $INFORMIXDIR/etc/update.sh that will convert the relevant tables. Please read the release notes. The information is i…
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…
Shared memory problem
Platform : Win2000 / IDS 9.30.TC3 I get the following error when increasing the buffers. shmat [ENOMEM] [12]: out of available data space, check system MAXMEM shmdt: errno 22 mt_shm_init : can't create virtual segment. The server has 2 Gig of physical memory of which approx. 9…
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…
Shared memory problem???
Environment: RH Linux 7.1 Kernel 2.4.10-ac11 Informix IDS 9.21.UC4 Dual x86 Processor 1.5 GB Memory 8 temp dbspaces, 256MB each 100 full time users during the day My Informix shared memory parameters are as follows: LOCKS 2000 # Maximum number of locks BUFFERS 180000 # Maximum …
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?…
Sick server session
IDS 9.21 on Red Hat My client's database session is really not too well. The database server will not accept memory-type operations, such as onmode -k or onstat -F. There are also no oninit proceses running. An onstat -g seg shows single segments, but an ipcs -m shows multiple…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: Shared memory. Error.
Hi. Make sure your permission of onstat and oninit like this. % ls -l $INFORMIXDIR/bin/onstat -rwxr-sr-x 1 informix informix % ls -l $INFORMIXDIR/bin/oninit -rwsr-sr-- 1 root informix I think oninit has wrong permisson. Regards. -- Tsutomu Ogiwara from Tokyo Japan. I…
RE: Shared memory. Error.
It looks like You are on Linux You can try to verify whether 'raw10' points to the correct block device: 'raw -q dev/raw/raw10' ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: inf [mailto:inf@terr.es]…
Re: Shared memory. Error.
Hi, Paul As you can see, the file /dev/raw/raw10 has the correct permissions: 0 crw-rw---- 1 informix informix 162, 10 ago 31 2002 raw10 but the error appears... Any suggestion ? "inf" <inf@terr.es> escribi� en el mensaje news:bor348$fgf$1@nsnmpen2-gest.nuria.telefonica…
Re: max number of connections
On Tue, 11 Nov 2003 12:42:00 -0500, Micha wrote: <SNIP>> We use both ontlitcp for remote connections and onipcshm for local > connections. NETTYPE is not defined in onconfig. How can nettype limit the > number of shared memory connections? AFAICT, the remote connections actually…
RE: Shared memory. Error.
You only can tell, that a link to a file has correct permissions, not a file itself Please, make 'ls -l /dev/raw/raw10' ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: inf [mailto:inf@terr.es] > Sent: …
Shared memory. Error.
Hi, - When starting informix the following error appears: 12:52:14 Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized. 12:52:14 Physical Recovery Started. 12:52:14 The chunk '/home/informix/dbs/tempdbs' must have owner-ID "informix" a nd group-ID "root". 1…
memory sort and disk sort
I check the sysprofile table and find there are 700 times disk sort, I think it is lack of sort memory. I want to turn all the disk sort into the memory sort ,but how can I malloc more sort memory for informix? Now my shmvirtsize is 800000(800M) Another question is: my server…
Re: Recommended BUFFERS Wont Work for import
Look at the settings for SHMVIRSIZE, SHMADD and SHMTOTAL. At the time of the failure a sort was in progress. Don't know how much data you are loading, so I am assuming that you have not got these settings correct. Shat values do you have? As a yardstick for the import you might …
HDR Replication and event alarm log backup
Hi Folks, I got replication up and running finally. The process was as described in the manuals and everything looks good for now. The on bar alarm program ( /etc/log_full.sh ) which backs up the log files when they fill up is failing though. The message is: 07:46:47…
Re: SHMVIRTSIZE on 64 bits OS
Sorry I missed the 64bit part or was just asleep. Just tried my test program compiled in 64bit mode on Solaris 8 and it allowed me to allocate and attach about 12.7GB of shared memory which is appoximately the amount of free real memory on the machine (out of 24GB), there was 22G…
Re: Problems with Shared Memory
U r limited to 50 connections in all ... if you are using SHM connections ... are the users spawning more than one connection to the engine when they run the program ... I would suggest increasing the number of connections to say 100 to see if it works or not ... onstat -g ses a…
RE: Problems with Shared Memory
Yes, -25588. $ finderr -25588 -25588 The appl process cannot connect to the database server server-name. But it's not true because some users are connected to. No ISAM-Error associated. TIA. -----Mensaje original----- De: owner-informix-list@iiug.org [mailto:owner-informix-li…
RE: Problems with Shared Memory
4 -----Mensaje original----- De: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]En nombre de Obnoxio The Clown Enviado el: viernes 12 de septiembre de 2003 14:46 Para: informix-list@iiug.org Asunto: Re: Problems with Shared Memory Diego Morales wrote: > > >…
Problems with Shared Memory
I have problems with Shared Memory. Only 5 or 6 users can login at the same time at database using shared memory INFORMIXSERVER. All run ok changing them to tcp... but they are running a 4gl app and I want them throw INFORMIXSERVER shm. I check the sqlhosts and NETTYPE and I t…
Excessive and sudden Virtual Segment allocation
Our development server instance runs perfectly happily day in, day out with plenty of Virtual memory as follows (IDS7.31, HP-UX 10.20) dev:dba:/users/dba>onstat -g seg Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 21 days 17:02:11 -- 248456 Kbytes Segment Summary: i…
dbimport Problems: 567 and 116 Errors
Yes, shown below 18:44:33 Dynamically allocated new virtual shared memory segment (size 8192KB) 18:45:37 Dynamically allocated new virtual shared memory segment (size 8192KB) 18:45:39 Dynamically allocated new virtual shared memory segment (size 8192KB) 18:45:41 Dynamically allo…
not initializing shared memory
mt_shm_remove: WARNING: may not have removed all/correct segments what do you do about that?…
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…
Shared memory: permission denied.
Hi all, Informix Dynamic Server Version 9.40.FC1 I receice the error Shared memory: permission denied when I run onstat - and this is the output of ipcs Message Queues: T ID KEY MODE OWNER GROUP q 0 0x4190051c --rw------- root system Sh…
Re: Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1
Thanks for all of your help. I lowered the amount of initialy reqquested shared memory and things seem to be working fine. Thanks, John M…
Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1
John M schrieb: >>What are your settings for NETTYPE, BUFFERS and SHMVIRTSIZE ? > > > Here are the settings you requested. > Through the IDS docs that I am using it says to make BUFFERS = 25000, > I tried that but the problem still persists. > > NETTYPE ipcshm,1,13,NET > B…
virtual shared memory segment
John Carlson wrote: > On 19 Jun 2003 08:27:04 -0700, schmotom@yahoo.com (tomL) wrote: > > Are you HP? If so, this is probably a major drain on your system. HP > memory management doesn't like that many shared memory segments. > > > May not be high depending on what is happening…
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…
Ontape "Not Enough Memory" - more ...
We've got SHMTOTAL set to 0 by the way. Andy…
Fw: alarmprogram.sh
Thanks Markand Brice, we'll work on it.. Regards ----- Original Message ----- From: "Mark D. Stock" <mdstock@MydasSolutions.com> To: "Sadi G�rsoy" <sadi@login.com.tr> Cc: "IIUG" <informix-list@iiug.org> Sent: Thursday, June 05, 2003 1:06 PM Subject: Re: alarmprogram.sh Sadi G�r…
Re: alarmprogram.sh
Sadi G�rsoy wrote: > Hi all, > Our platform is: > IDS 9.40 FC1 > AIX 5.2 > > We want to modify alarmprogram.sh. We want the program to work like > ontape -c. That is, when one logical log becomes full, we want it to be > archived, not wait until all logs are full. The default al…
Re: Err 243
> Dear, > I found an err code 243 in my online.log, CPU loading at that time was > around 90%+. does anyone know what the problem is??? and solution??? > here is my config. > > LOCKS 200000 > #BUFFERS 1536000 > BUFFERS 1126400 > NUMAIOVPS 2 > …
Err 243
Dear, I found an err code 243 in my online.log, CPU loading at that time was around 90%+. does anyone know what the problem is??? and solution??? here is my config. LOCKS 200000 #BUFFERS 1536000 BUFFERS 1126400 NUMAIOVPS 2 PHYSBUFF 32 …
mt_shm_init: can't create resident segment
----LNX_Wed_Apr_16_2003_08:39:34_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable >Datum: 2003.04.15 21:51:00 >Sender: Zablatzky, .... <wzablatz@ubspw.com> > >First try issuing onmode -ky. Even if the server is down, this sometim…
Re. Shared Memory Parameters
Hi Everyone, Which file needs to be changed on AIX 5.1(9.3 UC3) for memory parameters, is it "/etc/system" but it does not exist on unix box. SHMTOTAL is set to 0 in ONCONFIG, but the total memeory does not exceed 2GB although we have 4GB of ram, could not find any info. Any id…
Re: LINUX Kernel (kswapd) and INFORMIX
ART KAGEL, .... wrote: > Run onstat -g seg to see if the engine has grabbed additional VIRTUAL segments > for sorting purposes. If you are running with a high PDQPRIORITY value PDQ will > require additional memory depending on the DS_TOTAL_MEMORY and SHMTOTAL. If > SHMTOTAL is ze…
Fatal error asfcode = '25507'
Hi! I have a problem to initialize my informix 9.30 on linux(red hat 7.3 on intel) it is a freshly installed 9.30.UC2E3 with a demo licens. This message is all that i get when i start the ids: oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '25507'.…
EMERGENCY: Logs attached
EMERGENCY: I have a down system. I am trying to to a cold restore using command "ontape -r". The command keeps failing after prompting to back up the logs. The only error message which appears on the screen is : "oninit: Fatal error in shared memory creation". Additional error me…
linux kernel 2.4 + informix
HI ? I must setting Linux and IIF200 on DELL PowerEdge 6400 server . that server has 6Gbyes main memory, 120Gbyes hard disk. first i have install Redhat 6.2 official. and i have upgraded kernel 2.4 from kernel 2.2.16 . ( because for awaring 6Gbyes main memory at Linux) l…
Re: How to find onstat -g seg details
Murat YILDIZ wrote: > > How can I find details of a virtual segment?I want to learn which pools > of VM and if session pool then which sessions are allocating an added > segment. Any session can be the one to "add" the segment, so you will probably not be able to identify the ex…
How to find onstat -g seg details
How can I find details of a virtual segment?I want to learn which pools of VM and if session pool then which sessions are allocating an added segment.Sometimes very small part of the segment is used therefore onmode -F doesn't free that segment.Thanx... Sent via Deja.com http://…
RE: Problem with memory allocation
It looks like you're running into KAIO problem (bug). Tell us about your environment. Vivek Chaudhary -----Original Message----- From: Aboobacker V V [mailto:aboo@syd-co.au.dhl.com] Sent: Wednesday, January 03, 2001 6:10 PM Cc: informix-…
RE: Problem with memory allocation
See comments below . . . . -----Original Message----- From: Aboobacker V V [mailto:aboo@syd-co.au.dhl.com] Sent: Wednesday, January 03, 2001 6:10 PM Cc: informix-list@iiug.org Subject: Problem with memory allocatation Hi All, Can anybody please help me with the memory segments…
Shared Memory
Hi all, I need help on how to identify what process and users trying to allocate more shared memory segments (onstat -g seg) ? and how to releases this memory segment (virtual portion) ? TQ…
ALARMPROGRAM and Linux IDS 7.30.U
OK, I'll try to make this simpler. I named my alarm program "t.sh" Here is the source pwd > /tmp/t.err exit 0 Two simple lines of code to redirect the output of "pwd" to a file in /tmp. Each and every time an event pops, regardless of the severity, I should get a file c…
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…
Automated Backups using ALARMPROGRAM
Right after the instance does a timestamp in the online log you should see the statement: 06:10:04 Event alarms enabled. ALARMPROG = /home/informix/7.24/etc/log_full.s h' with your correct information. If you don't see that, after you verify in the $ONCONFIG file that it is set…
SHMAT error
Oncheck allocates a shared memory segment for sorting memory. If your kernel's shared memory parameters are too small you can get that error. Art S. Kagel "Sinha, Niraj" wrote: > > Folks, > I get following error while running oncheck comand. > I knwo that it is UNIXsystem erro…
RE: Is ANYONE using 64 Bit Informix ????????
From: Thanh <tqma@my-deja.com> > >In article <904bi8$fca$1@news.xmission.com>, > <murray@quanta.co.nz> wrote: > > > > We did one on an RS6000 running AIX. > > This is a 1 way upgrade. You cannot revert to 32 bit (must do an >export > > import and rebuild the instance. > > Anyt…
How to use more than 2GB share memory in Informix?
Unless you are specifically trying to limit Informix consumption of shared memory (i.e. to keep Informix from crowding out another application), set SHMTOTAL to 0 and forget it too. It's the default, and basically means unlimited. It's what most people use, especially if the ma…
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…
Performance Problem
I have an IBM rs6000 (4x166 processors) and 1.5 G Ram running Informix 7.24. The problem is that unless I cripple Informix using the SHMTOTAL directive in the onconfig (set to 700M) the system goes so slow that no one can use it, which also results in AIX reporting fork failure…
shared memory question
Hi all, I have a question a bout shared memory allocation. I know that we can specify the size of the virtual memory segment and the additional size allocated(SHMVIRSIZE in onconfig) BUT, how can we control the other segments classes (Resident sgments and Message queue segments) …
RE: ontape -r quitting with code -1 errno 22
Hi, log files say's nothing (really nothing). Error 22 is in error.h = Invalid Argument. I check the kernel shm config. "Watson, Paul" <Paul.Watson@aggregate.com> > > What are your log files saying? Do you have truss under Digital Unix, > if so then truss and find out what sys…
Re: UnixWare 7.1.1 and IDS 7.30UC10
In article <39E31159.13774915@evg.de>, Roland Wintgen <rw@evg.de> wrote: > Hi all, > > we're moving towards a SCO UnixWare 7.1.1 machine running IDS 7.30UC10. > When trying to initialize IDS it gives the error: > > "shmat: [ENOMEM][12]: out of available data space, check system…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
RE: Slow performance after shmem dynamically allocated
How many segments does 'onstat -g seg' show? If there are more than four, then you could be having some performance issues. It's all in the way that HP handles memory; it can't have more than three memory segments active in the OS at one time. Here's a snip of my current produ…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
RE: SHMVIRTSIZE --- How much bang for the buck?
> > > The main segment is 400 meg and the other 7 are 200 meg each. > > (1.8 Gig > > total) > > > > The /etc/system (solaris) allows 2 Gig shared memory segments. > > > > I'm thinking that since we use the memory ANYWAY we should > > consolidate, > > and the Informix manuals agr…
RE: SHMVIRTSIZE --- How much bang for the buck?
> -----Original Message----- > From: Keith L Morris [mailto:keith.l.morris@wcom.com] > Sent: Monday, September 25, 2000 12:51 PM > To: informix-list@iiug.org > Subject: SHMVIRTSIZE --- How much bang for the buck? > > > Greetings, > > On a current production system I have found an…
SHMVIRTSIZE --- How much bang for the buck?
Greetings, On a current production system I have found an instance that has 8 VIRTUAL segments. (onstat -g seg) The main segment is 400 meg and the other 7 are 200 meg each. (1.8 Gig total) The /etc/system (solaris) allows 2 Gig shared memory segments. I'm thinking that sin…
Re: Informix initializing in Linux.
From: "Marcos Alves" <marcosaoalves@ig.com.br> > >I'm try to install Informix IDS 7.3 in Linux Red Hat 6.2. The installation >was all OK. But, when I try initializing the database with oninit command, >I receive the message below: > >Event alarms enabled. ALARMPROG = '/usr/inform…
Re: onmode -F
We had a similar situation with IDS 7.30.UC7XB several months ago. Occasionally, when we'd run "onmode -F", our engine would go out to lunch and force us to shutdown/restart. After upgrading to IDS 7.30.UC7XL the problem went away. If you continue seeing the problem I'd contact…
Re: onmode -F
I've never seen aproblem using onmode -F. Note that if you run onstat -g seg you can identify which and if any segments will actually be freed by onmode -F. These will be 95% or more unused meaning only overhead pages have been allocated. If a segment is not unused onmode -F w…
Re: onmode -F
Of course, it's a question of onmode -F....not onstat -F J. M�ki <jukka.maki@tieto.com> wrote in message news:4aQo5.264$_03.12419@read2.inet.fi... > Has anybody been facing a problem when running onstat -F > We had problems with logical logs, they didn't got backed up. > We are …
onmode -F
Has anybody been facing a problem when running onstat -F We had problems with logical logs, they didn't got backed up. We are using onbar. After rebooting Informix everything has been always ok !. Now I tried onstat -F, because I think it's a kind of memory fragmentation problem.…
Re: Dynamic Server 2000 crash
"smooth1" <smooth1@iclway.co.uk> wrote in message news:399c6620_3@news1.vip.uk.com... > > Check kernel parameters > I am not sure you can have more than 10 shared memory segments > under Linux. Increase SHMVIRtSIZE in your ONCONFIG file. > > Also check the kernel parameters for s…
Dynamic Server 2000 crash
Add more swap space. You are running out of memory. What are the BUFFERS,SHMVIRTSIZE,SHMADD entries in $INFORMIXDIR/etc/$ONCONFIG set to? What does onstat -g seg give? Richard Puchalsky wrote in message ... > >"Peter Eckhardt" <Peter.Eckhardt@transcom.de> wrote: >> play with t…
RE: IDS 9.20
Yes it does . . . . Set the way back machine, Sherman. A long time ago, a certain DBA learned of a great resource to aid his learning . . . c.d.i. This DBA happened to come across an article concerning the number of memory segments on an HP box. The DBA noticed that we would h…
Re: IDS 9.20
From: "STRONGN" <Neil.Strong@Syntegra.Bt.Co.Uk> > >When you say 4 memory segments, do you mean extents to the original shared >memory segment ( SHMVIRTSIZE / SHMADD ) 1 SHMVIRTSIZE + 2 SHMADD + 1 RESIDENT >I ask because we have similar performance problems and noticed several (…
Re: IDS 9.20
When you say 4 memory segments, do you mean extents to the original shared memory segment ( SHMVIRTSIZE / SHMADD ) I ask because we have similar performance problems and noticed several ( 10 ish ) extents being allocated shortly after database startup. Obviously, we have not siz…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Re: shared memory problem
To all, I changed SHMVIRTSIZE and SHMADD, but it was Unix that was limiting the shared memory to 1GB. That limit was removed and I'm now waiting till we hit the 1GB again. Thanks to all. Daniel Willems Mark D. Stock <mdstock@mydas.freeserve.co.uk> wrote in message news:8lq5e2…
Error 139 in logical log backup (resubmitted with additional info)
ram wrote: Neil, you misunderstand Pierre's problem. He, like many, did not know what to do with the ALARMPROGRAM parameter in the ONCONFIG file and left the sample value of $INFORMIXDIR/bin/logs_full.sh which is an example alarm event handler script that only handles the log f…
Informix 7.31 and Windows2000
Somebody has installed it on Windows 2000 ? The Instance Manager can't initialize shared memory.. Thanks in advance. -=SIMO=-…
SCO IPC
OK - I've RTFMed, but still in need of help. I am running SCO Unix 5.0.{245}, with Informix IDS.2000 Dynamic Server. Trying to initialize shared memory does not appear to work. The system utility "ipcs" does not report any shared memory being allocated, and the oninit -i seems…
Re: SHMTOTAL
Hi, The SHMTOTAL sets the limit on the amount of virtual memory IDS will get from the OS. The value of SHMTOTAL should be SHMTOTAL >= (size of resident) + (initial virtual segment size) Increase your SHMTOTAL or decrease the sizes of your resident and/or virtual shared memory…
SHMTOTAL
Hi, I want to delimiter SHMTOTAL because I don't have much memory. hence, I only want one Virtual segment. now, this messages appears on online.log 19:13:12 size of resident + virtual segments 23437312 + 33308672 > 51200000 total allowed by configuration parameter SHMT…
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?…
Re: IDS Alert -> Mobile Phone Text Message
Mr Creosote Most mobile phone or pager companies have a website from which you can "email" pages to them. The one we use (Skytel) even has a mail-to-page interface, so if your pager number was 12345678, then you could email your pager at 12345678@skytel.com. We use this feature …
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
RE: informix newbie needs help - out of shared memory segments, c
You won't find SHMSEG in scoadmin, you have to edit your header files and then rebuild the kernel. But before you do that, try changing the SHMBASE, SHMVIRTSIZE, and SHMADD in your onconfig. hth, sunil |-----Original Message----- |From: Eggert.Ehmke@berlin.de [mailto:Eggert.E…
Re: initialization problem
From: "Savio Mario Bartholomeo Pereira" <saviop75@hotmail.com> > >Hello everybody! > >I gotta problem. >I get an error while initializing informix. >oninit: Fatal error in shared memory creation. > >Version; IDS 2000 on SCO 7.1.0 > >I undrestand that the total memory (i:e memory …
Version 7.31.UC5 memory question
Steven L Cooper wrote: > > Howdy, > I am installing my 7.31.UC5 upgrade and have a question about the memory. I > see a message about rounding the memory up, which is find with me, but does > anyone know which onconfig parameter this is using? > > OS: SCO 5.0.4 on 4/way Intel bo…
Fatal error in shared memory creation
When I type oninit, it said: Fatal error in shared memory creation Why ? Thanks…
Re: Problems with shared memory
After running onmode -F what is the size of the virtual segment? Is IDS using the correct ONCONFIG file? You can verify this by running onstat -c. Don Tom wrote: > On my machine I've observed a strange thing. After initialization IDS create > virtual segment (500MB!!) > For …
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…
RE: Shared Memory segment (5 of them)
> > Hi gurus, > > Recently, I noticed 5 extra shared memory segments created in > my Informix > 7.30 UC7. What could have caused this and how to remove/prevent these > segments from created again? AFAIK, more shared memory > segments means less > efficient shared memory usage. Am…
Shared Memory segment (5 of them)
"Lawrence @ Maxis.Net" wrote: > > Hi gurus, > > Recently, I noticed 5 extra shared memory segments created in my Informix > 7.30 UC7. What could have caused this and how to remove/prevent these > segments from created again? AFAIK, more shared memory segments means less > efficie…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: oninit -v
From: "Stefansson" <bs@rhi.hi.is> > >oninit -v >returns an error: >Allocating and attaching to shared memory...FAILED >onint: Fatal error in shared memory creation > >What can be causing this and what could be able to solve this problem ? It could be something holding on to shar…
oninit -v
oninit -v returns an error: Allocating and attaching to shared memory...FAILED onint: Fatal error in shared memory creation What can be causing this and what could be able to solve this problem ? Thanks. B. Stefansson…
Problems with RedHat Linux 6.0 and IDS 7.30
Hi, I'm novice in Linux and after installing the IDS 7.30 on a RedHat 6.0 machine when the IDS try to create the shared memory i got a list with messgaes like this: dupfd: fd 1025 max 1024 finally i got the message: error on shared memory creation. Where I can find information …
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…
Oninit problems with IDS 7.31 on Solaris
After a new install, I try to run "oninit -ivy", it gets quite a ways through, then bombs during the following phase: Initializing Dicitonary Cache and Stored Procedure Cache ... cannot find message file. Check INFORMIXDIR and DBLANG.FAILED My INFORMIXDIR is set correctly, as …
Unable to start engine sometimes...
Howdy, I get this message sometimes and Informix "support" has not been able to give me an answer as to why...just guesses. If I reboot the server, it works 99% of the time. After the engine starts, I see no problems at all! Has anyone ever seen this before? SCO 5.0.4 OWS 7.20…
Serious oninit -i problem?
oninit -i produced the following lines in the online.log on Solaris 2.7 The bit about the unusable chunk doesn't look healthy to me! BTW, rootdbs is a symbolic link to a raw meta device i.e. /dev/md/rdsk/d30 Any ideas? Advice greatly appreciated. 17:19:19 Event alarms enabled.…
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…
Total of all shared memory vs. Total Physical memory
Hi listers, We have 8 instances of INFORMIX (-OnLine Version 7.23.UC4) on a HP-UX 10.20, 4 CPUs, 1.5GB Physical memory box. I am aware (thanks to this list) of the need to monitor with onstat -g seg and adjust SHMVIRTSIZE and SHMADD so as to avoid getting more than 3 shared mem…
RE: Informix 7.31 Event Codes
Event alarm codes are documented in the Administrator's Guide for Informix Dynamic Server (section 29 in IDS 7.3 manual). They are also shown in Appendix D of the Informix Administrator's Reference, September 1999. -----Original Message----- From: jaymond@communitycoffee.com [m…
Re: MEMORY problem after Informix upgrade
Run onstat -g seg and look at the total of the RVM segments. It is in bytes. Does that equal your total of your physical memory on the system. If so then you might have a problem. the R segment should be about 20% of your physical memory. M and V are dependent on what you are run…
Shared Memory Parameters?
I am working with an existing database that has some onconfig parameters that I am questioning. One of our problems is extents, but another reason we get hammered during the day might be the following shm parameters. OL Engine Vers. 7.31 on HP 9000 Aprx. 400-600 users Database …
Re: problem on initialization
Yes, I have the INFORMIXDIR environment variable. The system work very well before system crash. Chris McKay ���g��峹 ... >Do you have the INFORMIXDIR environment variable set when you run oninit ? > >Chris > >"W. J. Hsu" <wjhsu@pti.com.tw> wrote in message >news:88a6oa$h5f@netne…
shared memory problem
Hi David. Plz. supply your $ONCONFIG file. Reviewing your kernel parameters would be good. If your server is still running, output from onstat -g seg may be helpful. David Palmer <dapalmer@imt.net> wrote in message news:s9kh3oucdh55@corp.supernews.com... On 7.2.0, I'm gett…
Re: Informix Database and Performance
[cutting > > I think AIX is limited to 10 SHM segments, so make your shmvirtsize quite > big. True, 10 is all you can have. >Unfortunately AIX doesn't support residency. Sure??? I thought it did - but I'm regularly wrong -- Paul Watson # WF Software …
Re: Shared memmory initialization
From: Manoj Narayanankutty <mnarayan@crosskeys.com> > > I am using Informix dynamic serrver version 7.31 on solaris 2.6. When I >am trying to reinitialize my shared memmory using oninit command, my >system gives an error >indicating fatal error in shared memory initialization. >…
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…
Shared memmory initialization
Hi, I am using Informix dynamic serrver version 7.31 on solaris 2.6. When I am trying to reinitialize my shared memmory using oninit command, my system gives an error indicating fatal error in shared memory initialization. The online.log gives the following message: 21:17:54 E…
Problem with data replication in Informix On-Line
HELP! Informix On-Line 7.23 on SCO UNIX Open Server 5.0.4 Both servers are identically configured. Data Replication starts fine but Secondary server allocates memory as quick as 16MB per hour: 14:31 dynamically allocated new shared memory segment (size 8388608) what makes …
Virtual Memory
We are running Informix 7.3 on HPux 11 On a system with 6Gb available memory, I am trying to increase the SHMVIRTSIZE. It is currently set to 2000000 kb ( 2 Gb ). Initially I tried increasing by 500000 kb this resulted in informix failing to initialise with error "size of resid…
Virtual Memory
We are running Informix 7.3 on HPux 11 On a system with 6Gb available memory, I am trying to increase the SHMVIRTSIZE. It is currently set to 2000000 kb ( 2 Gb ). Initially I tried increasing by 500000 kb this resulted in informix failing to initialise with error "size of resid…
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…
Shared memory ran out
Hi : We have situation where Java user defined rountine (UDR) when being called from a INFORMIX 4GL in a loop, after certain iterations (30000) , INFORMIX Engine CRASHES. When I looked at INFORMIX onstat -g seg, I could see many shared memory being allocated dynamically. Even t…
Receiving "Changing data structure forced command termination." from onstat!
I've seen this occur under HP-UX when shared memory kernel parameters weren't set correctly (see the Release notes directory under INFORMIXDIR for recommendations). I vaguely recall that if "Total Resident memory" allocated to the instance exceeded the shmmax setting at the OS le…
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…
network down error
We have a new installation of 7.24.UC5X7 on an IBM S80 and when we get around 100 users connected new users cannot connect to the database. Onmonitor gives the error "Network Down". When you check shared memory with onstat it says that shared memory is not initialized but when yo…
Out of shared memory with 2 instances
Hi ! Put your SHMVIRTSIZE bigger....app. 950MB ( you have enough memory !). After that, check ipcs -m to be sure that everything is in one segment !. There is no use of using CHATR, because of segments. MAX amount is 2. MAX first segment size is 1 GB. next extent max size is 512 …
RE: accessing shared memory
Hi John, You need to change permissions to shared mode (s) for necessary executables in $INFORMIXDIR/bin directory. thanks Ravi Yarlagadda Informix Certified Professional -----Original Message----- From: John Horton [mailto:john.horton@cognito.co.uk] Sent: Tuesday, December 14…
accessing shared memory
Hi How do I set up a user so that they can access shared memory (ie. they can use the onstat - command) . Currently only root can access shared memory (not even informix can access shared memory or use the onstat - command) I have tried stting up the group so that informix is a …
shared memory problems
Hi I am having some difficulty getting some programs to work on a linux box (they are being ported from an HP9000) The problem I am (currently) having is that one of the processes requires shared memory to be allocated. The program requests two loads of shared memory , the first …
onbar -l
Ron, I'm not sure who you are referring to as the "user". Anyway, this may be what you're after. Informix will generate an "Event Alarm 23" when a logical log fills up, if you have the ALARMPROC set to some shell script in your config. Informix will execute it for every EVENT AL…
2 shared memory segments
When I start up informix I get the following message in the online log. Could not create single shared memory segment with resident and non-resident par titions. Proceeding to create 2 shared memory segments instead. The following are some my onconfig parameters LOCKS …
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…
Shared memory problem
Zeljan Silje wrote: > > Hi, > > I am using IDS Workgroup edition 7.30 on SCO unix 5.0.0. When I try to > startup informix, I get several warnings: > WARNING: Shared memory could not be directly allocated. > > Informix is working OK after startup. > > I set kernel parameters like …
Long checkpoints
The first things to do are change LRU MIN to 1, MAX to 2. Avoid 0 and 1, you'll get too much redundant writing too quickly. Let the page age to at least 1 percent before writing it out. Up CLEANERS to 127, and make sure all of the stuff you're writing out isn't all going to th…
Re: oncheck problem
In article <I+bMACALtmG4Ewq$@smooth1.demon.co.uk>, djw@smooth1.demon.co.uk (David Williams) wrote: > In article <7vbokg$427$1@news.xmission.com>, Paul watson > <watsop@russellcorp.co.uk> writes > > > >[cutting] > > > >>Just set SHMVIRTSIZE to zero (0) which means "UNLIMITED" and…
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…
oncheck problem
Adam Bradley wrote: > > Upon closer inspection of this problem, the Informix message file (MSGPATH) > had > the following entry when 'oncheck' fell over: > > 13:04:49 dynamically allocated new shared memory segment (size 5832704) > > 13:04:49 size of resident + virtual segments…
shared memory
Beim Start mit oninit erscheint folgende Fehlermeldung 21:00:20 shmget: [EEXIST][17]: key 52564801: shared memory already exists 21:00:20 mt_shm_init: can't create resident segment Was fehlt noch bei der Einstellung ? Wer kann mir helfen…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
RE: Backups terminated by client
---- you wrote: > This is exactly the same problem that I am encountering. Maybe someone can > shed some light for us. I am not very experienced in this area Dudes & Dudettes, but are you looking in the right area? From what I've seen, from version 7.24 onwards, these physical…
PA-RISC processors
Apparently there is a problem with HPUX 10.XX operating systems running on PA-RISC processors. The hardware limitation of the processor is that it uses 4 special purpose address registers which are the only way to access shared memory segments. If you have 4 or more shared memo…
Re: Questions about values of memory in onconfig
En Diego Morales va escriure el dia 9 Sep 99, a les 16:07: > > > > > > Hi all again. > > I'm working with a 7.31 UC2 with HP-UX 10.20 > > I'm tunning the memory values of onconfig, exactly SHMVIRTSIZE and > SHMADD. > > We have recently change to this version of Informix and who…
Re: Error -25588 and errno 22 from shmat()
> > Well, I think I found something. I looked at the truss > output for a few different programs, and found that the > programs that fail are trying to attach the IDS > shmem segment below their break address, which is > rightfully invalid. > > Every program tries to attach the …
Questions about values of memory in onconfig
Hi all again. I'm working with a 7.31 UC2 with HP-UX 10.20 I'm tunning the memory values of onconfig, exactly SHMVIRTSIZE and SHMADD. We have recently change to this version of Informix and who installed us this version changed the values of SHMVIRTSIZE and SHMADD (they was se…
Oninit didn't work fine and I don't know why
Hi all ! I have an Informix 7.31 UC2 with a HP-UX 10.20 and we work with Baan Triton 3.10_a1 Yesterday afternoon I changed the SHMVIRTSIZE parameter to 200000 (we had 190000 before). When I tried to initialize Informix with 'oninit'. With 'onstat -' I want to see when I…
RE: Size of shared Memory
Post your reasons for saying it doesnt add up to 20Mb. Look at and post onstat -g seg and you will see why it is. Murray Wood -----Original Message----- From: kumarljv@my-deja.com [SMTP:kumarljv@my-deja.com] Sent: Tuesday, September 07, 1999 4:53 PM To: informix-list@iiug.org …
RE: Fatal error in shared memory creation
Check the release notes for SHMBASE parameter value. Try to start Informix with SHMBASE value 0 -----Original Message----- From: Jerome BARRET [SMTP:jejgphy@hotmail.com] Sent: 06 ������, 1999 06:43 � To: informix-list@iiug.org Subject: Fatal error in shared memory creation…
Fatal error in shared memory creation
When I want to startup for the first time, in the oninit program, this message appears : "Fatal error in shared memory creation". In the part shared memory parameter, the parameter are the default parameters. Thank you for your help…
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…
Pb with initialization. System: SUN Solaris 2.6 Informix 7.31
Hello, I'm installing an Informix Dynamic Servr for the first time. I have a problem with initialization of Informix. When running 'oninit -iy' I have this message: "Cannot find message file. Check INFORMIXDIR and DBLANG" I have checked INFORMIXDIR, it's "/opt/informix" (good) …
Dynamically allocated new shared memory segment ???!!!
Dear ALL : Our system appear the following messages in seconds : 09:11:02 dynamically allocated new shared memory segment (size 8388608) 09:11:30 dynamically allocated new shared memory segment (size 8388608) 09:11:50 dynamically allocated new shared memory segment (size 8…
Shared memory limits in 64-bit environment
Is there any practical shared memory limits in HP/UX 11 (N-serie) with 64-bit Informix ?. -Jukka…
208: Memory allocation failed during query processing.
Sounds like the engine hit SHMTOTAL and could not allocate additional virtual segments. There are other possibilities. Art S. Kagel HENCHOZ Daniel wrote: > > Hello ! > > While our developers try to run an SPL procedure they get the following message > : > > 208: Memory allocat…
Loading into Shared Memory...
Hi, Can i explicitly ask Informix to load a table into Shared-Memory? And then later on sync the copy of table on disk \\ with the one in shared memory? Any suggetions welcome Thanks Anand Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.…
ONCONFIG Parameter SHMADD
I am on a Digital Unix box. The OS Vendor has told the maximum size of SHMVIRTSIZE the OS can be tuned to use is 2 Gig. All of the tuning manuals tell you to keep your Virtual Segments down to one (on HPUX) or two (all others) segments; after that, you will experience performan…
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.…
Problem with delete
In addition to what Art said: You may also want to increase the size of SHMADD when increasing the size of SHMVIRTSIZE. It is sometimes suggested you make SHMADD from 20 - 25 percent the size of SHMVIRTSIZE as to create fewer non-primary Virtual segments when additional memory …
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…
Informix online shmat error !!
> 1)out of available data space, check system MAXMEM > 2)Make more virtual memory available to OnLine > > in other words whats wrong ?! You need to increase your SHMVIRTSIZE and SHMADD params. > > I can see in my online.log many lines like this > dynamically allocated new share…
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…
Re: HP Shared Memory Limits
> What we can't figure out is where the limitation on initial memory coming > from? We are wanting to increase buffers even more and are willing to add > physical memory to the system so that we can force residency on all > segments, but if we can't get past the 1.3 GB startup,…
HP Shared Memory Limits
I'm running Informix 7.30.UC7XB on a dedicated 4-processor HP T520 (OS level HP 10.20) with 1.75 GB physical memory and 5.5 GB swap space. Informix will fail to start with a ENOMEM error if we try to allocate more than approximately 1.3G of memory (R, V, and M combined), althoug…
SCO: shared memory problem...
Hello, I am having a problem that, hopefully, one of you have had before, or have heard about before. There box is a PII system with 128MB RAM running SCO OpenServer 5.0.5 with the latest patches. The error oninit -v gives: oninit: Fatal error in shared memory creation The er…
error while creating online instance
While creating a new online instance using "oninit -ivy", this is the following error message that we get. Creating infos file "/usr/informix/etc/.infos.kil_serv3" ... succeeded Writing to infos file ... succeeded oninit: Fatal error in shared memory creation We have created in…
KAIO on HP/UX 10.20 & Informix 7.30
I am using 7.24.UC4 & HP-UX 10.20 with Y2K patches installed. KAIO is enabled, no problems at all. Performance gain is about 15..20%. Shared memory problem is well-known : try to minimise a number of segment that IDS uses ( increase SHMVIRTSIZE ). Sergey…
Usage of INFORMIXSHMBASE
It replaces, or supplants, the SHMBASE ONCONFIG file parameter's value. It is the preferred attached address for shared memory if you are using a shared memory connection. Art S. Kagel Wu wrote: > > What's the usage of this environment variable -> INFORMIXSHMBASE ? > > thanx…
HELP with "Stored procedure and memory problem"
The problem seems to be the SHMTOTAL ONCONFIG parameter. You have it set to a hard limit and the engine needs to allocate additional segments which would violate this limit. You can set SHMTOTAL to zero and it will permit shared memory to grow indefinitely. BEWARE you are runn…
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.…
shared memory question
Phillip Tien wrote: > > I have a configuration question on the onconfig file. I'm wanting to > change (increase) the number of BUFFERS and SHMVIRTSIZE on the instance > I'm running, but I'm wondering if I should be concerned with the Unix > memory configuration before doing so. …
Re: Memory Used
The values displayed by 'onstat -g ses' for memory used and total memory are just bytes, not Kbytes. You can check that by performing a 'dbaccess sysmaster -', which just opens a connection to the database. onstat -g ses should show about 32000 for the columns total memory and u…
Re: running out of Unix Shared memory segments
You may want to check how many shared memory segments are allocated to Informix and other programs; use the unix command "ipcs". If you normally have many Informix segments you could change the onconfig file parameters for SHMADD and the initial shared memory parameter to increa…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Shared Memory on Linux
How do I configure Redhat Linux to get rid of the Shared Memory Error when I try to start Informix (IDS 7.3)? Thanks. Aris…
how to caculate resident shared memory size?
hi,all could you tell me how to caculate resident shared memory size? thank you.…
RE: HP-UX 10.20 , Informix 7.30 - advice needed
I just changed SHMVIRTSIZE and SHMADD on an HPUX10.20 to match the size of the memory dynamically allocated to informix as shown by the ipcs command. For example if you show eight 8MB segments then set SHMVIRTSIZE to 64MB. It seemed to speed things up a lot. Many shared memory …
Re: SCO & INFORMIX:Network driver cannot bind a name with the port
In article <7hsvs5$3up$1@news.xmission.com>, Sujit.Pal@BankAmerica.com wrote: > Alex > > What are your NETTYPE config variables set to? That determines the number > of user threads that can be allocated. Sujit, it was: NETTYPE ipcshm,3,400,CPU Informix support advi…
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…
Re: Re[2]: An alarm program from the online.log
> Yea, I'm thinking I could rsh to the other machines and check the > logs, or am I nuts? Don't ask me, you might regret it! :-) Why don't you write an event-handling script to e-mail/fax/page you and just install it on every box in the network? That *sort* of approach …
Re[2]: An alarm program from the online.log
Yea, I'm thinking I could rsh to the other machines and check the logs, or am I nuts? Thanks, Kevin ______________________________ Reply Separator ____________________________ _____ Subject: Re: An alarm program from the online.log Author: obnoxio@hotmail.co…
An alarm program from the online.log
Hi group! I am trying to write a script that will periodically check the online log for certain events, through egrep and awk, and eventually mail and page me. I checked the alarm program in /etc and would use it, but I need the program to look at several instances across the net…
Re: onstat -u / onstat -g ses Problem
Informix Netherlands advised to start the database with the environment variable SINGLESEG_OFF=1. Try it! Regards Hans Bosma Database Administrator NCCW(Netherlands Ing Thoralf Bihlo wrote: > > I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server > 7.30 UC6. >…
REQ: Problem with onstat -u / onstat -g ses
I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server 7.30 UC6. My SHMVIRTSIZE is 32k and onstat -g seg shows that I have just one Segment. When I try an onstat -u or onstat -g ses I get the Error: >Changing data structure forced program termination< during the …
IDS 7.30.UC7 on HP-UX 10.20 ignores RESIDENT settings
Hi InforMixers, i detected the following 'feature' with IDS 730.UC7 on HP-UX 10.20 (all recommended patches installed): With KAIO All shm-segment are in fact resident. We have a test-machine with 128MB memory. IDS-SHM (resident + first virtual) is approx. 80MB. IDS is unable to …
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: How can we avoid reclustering some indexes ??
> Sorry for misunderstanding, I don't give 60% as general recommendation. > Recommendation is to start from 20% and tune up keeping eye on free memory > cushion, onstat -g seg, swapping, etc. 60% is where I stopped for > particular system I just tuned (7.24, 512M RAM, Fourth Gen…
ALARMPROGRAM
Hi, my Informix is 7.22 UC1 on HP 10.20 I do not want to use /informix/etc/log_full.sh as an alarmprogram because I have 4 informix server running on the machine. For each I have a shell script that starts ontape -c to a file on disk. (extra file for each server) I want to deacti…
Shared Memory
I have a question about the shared memory segments Informix adds dynamically in version 7.x. I use onmode -F to free the unused shared memory but this seems to only ever free up one segment regardless of how much is unused. Has anybody used this to free more than one segme…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Re: Memory Leak
In article <78a8dj$1h7$1@nnrp1.dejanews.com>, joel_anderson@prosolution.com writes >We just installed our first customer with Informix 7.30 TC5 on an NT server. >With only a few users on the system for a few hours, the memory usage on the >Informix server goes from a few meg to o…
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…
Informix for NT error -406
DBMS wrote: > > Hi there, > > I'm trying to connect to a database through Informix 7.30.tc3-1 for Windows > NT 4. > I'm using a Pentium 233 MMX 64Mb with 128 of virtual memory. > Everytime I try to connect, the error message is displayed after 15 minutes > of use. > The system sa…
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?…
Performance degraded after detaching indexes / fragmentation
Possibly you have hit the limits of your little SMP (4 CPU?). Or if you got them, jack NUMCPUVPS up and check the parallel processing parameters in the ONCONFIG. Time for more CPUs. Fragmentation splits up stuff so more parallelization can happen. but it won't happen if you do…
Informix error.
Does anyone know what this error is about: shmat: [EINVAL][22]: shared memory base address illegal Thanks, Fred Lee…
oninit: Fatal error in shared memory creation
Kevin M. Carroll wrote: > The most recent entries in the online.log file report: > > shmget: [EEXIST][17]: key 52564801: shared memory already exists > mt_shm_init: can't create resident segment > > The first error however was: > > shmat: [EMFILE][24]: out of shared …
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Re: Running out of shared memory
In article <366E7D08.C219D263@uk.ibm.com>, Danny Williams <danny@uk.ibm.com> writes >Hi There! > >I have an Informix instance that ran out of shared memory during a >transaction:- > >AIX 4.2.1 >Informix 7.22.UC1 >SHMVIRTSIZE=64Mb >SHMADD=32Mb > >So I increased SHMVIRTSIZE to 256 …
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Parallel Backups using onbar
I have some questions concerning parallel backups using onbar. We are running a large OLTP application on a SUN 10000 platform usint Informix 7.23. We are using onbar with Veritas Netbackup as the storage manager: When backing up logical logs, does onbar take advantage of para…
Re: Informix engine will not initialize
sda@arentfox.com wrote: > > I am running Online v7.22 on a HP 10.20 box. We lost a drive and I am > recovering the database. The ontape -r runs fine. > > 08:50:24 Event alarms enabled. ALARMPROG = '/dev/null' > 08:50:26 DR: DRAUTO is 0 (Off) > 08:50:26 INFORMIX-OnLine Initial…
Re: Informix engine will not initialize
sda@arentfox.com wrote: > > I am running Online v7.22 on a HP 10.20 box. We lost a drive and I am > recovering the database. The ontape -r runs fine. > > 08:50:24 Event alarms enabled. ALARMPROG = '/dev/null' > 08:50:26 DR: DRAUTO is 0 (Off) > 08:50:26 INFORMIX-OnLine Initial…
Informix engine will not initialize
I am running Online v7.22 on a HP 10.20 box. We lost a drive and I am recovering the database. The ontape -r runs fine. 08:50:24 Event alarms enabled. ALARMPROG = '/dev/null' 08:50:26 DR: DRAUTO is 0 (Off) 08:50:26 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 08…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: alarm handler bug on OWS 7.22?
Here is a part of the ONCONFIG file: # Diagnostics MSGPATH /informix/etc/online.log # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM db_alarm_prog # Alarm program path The event handler db_alarm_prog is …
event-alarm-error ?
I've got some problems with the event alarm feature of OWS 7.22. I have written an event handler and set the onconfig paramter correctly as I can see from online.log. Also, I can see from online.log that my event handler is sometimes (it depends on the event class) called by: /b…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: upgrade from 7.23 to 7.3 on HP
Kate_Tomchik@HomeDepot.COM wrote: > > Has anyone else noticed this? When we upgraded our environment last night > from 7.23.uc1 to 7.3.uc2 on HP 10.20, each oninit process appears to take > about 1.7 megabytes of additional memory. On larger systems, this is > resulting in seve…
Re: Dynamically adding shared memory segs
Martin Berns wrote: > > Mark D. Stock schrieb: > > > > Martin Berns wrote: > > > > > > Bill Weaver schrieb: > > > > > > > > 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…
Re: Dynamically adding shared memory segs
Martin Berns wrote: > Mark D. Stock schrieb: > > > > Martin Berns wrote: > > > > > > Run 'onstat -g ses' and have a look at the 'total memory' column. This may indicate who is using > > > the additional memory. Remember, sessions don't free memory by themselves: So if there is a…
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? > …
Shared Memory ??
--------------F10AFCC198D69640B04B5FAB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! I just installed the Informix OnLine Workgroup Server 7.20 in Sun Sparc 5 with solaris 2.5.1, but when I try to run some utilities (e.g. onspaces, oninit) it…
Re: ****Change from ANSI to unbuffered
insight@shabakah.com wrote: > > Hi, > > We have changed our database from ANSI mode to unbuffered, we got low paging > space. Does ANSI require less memory/paging than unbuffered??? Not directly. The only thing I can think of is that the default ISOLATION LEVEL is different for…
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 …
Assert Failed / Segmentation violation
Hi, Does anyone know exactly what is the meaning of : Assert Failed: Internal Error - Segmentation Violation Who - doesn't really matter in this case as my users would not have done anything unusual wih the server/database throught the applications. OnLine must abort and has t…
Increased memory w/7.24
I have not been able to read the newsgroup in a while, so excuse me if this has been discussed. I have an instance up on a test server. Here are the facts (and difficulties): 272 meg ram HPUX 10.01 Running 7.22.UC1, the instance uses about 60 megs ram (measured using "glance")…
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…
Re: Question: Continous Log
Mario, Continuos logical log backup needs a dedicated terminal. I usr 'automatic backup' of the logical logs instead. The log_full event alarm triggers the log_full.sh script in $INFORMIXDIR/etc. This script then can activate an onbar -l command. Hope this helps. Carl in Atla…
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…
Re: memory allocation failed - error 406
Maria Wilson wrote: > > I am trying to load a large (around a gig) msaccess database into an > informix db on a Solaris 2.5 machine with Informix 9.x engine on it. I > am getting this error (406) after several hours of loading. The sql is > not doing anything other than loading…
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: Unable to create an Index!
Robert Hosler wrote: > > I am running Informix-Online 7.11.UC1 on Digital UNIX 4.0 and I get two > errors whenever I try to create an index. Errors -212 and -116 > > Please send replies to rhosler@ptt-telekom.com or bendarek@sundial.net Error -212 just says that the index could…
Re: onstat -g ses
The configuration file specifies the size of new segments(SHMADD) that'll be allocated in quantums for sessions. A session not necessarily uses up all of it, so you see the two pieces of info. For example, if SHMADD = 8192 (i.e. 8 KB at a time), and your session only used 3K of…
Announcment of new utility package - utils3_ak
I have submitted my event alarm handler program and the simple script to backup logical logs to disk using ontape that were discussed last week. If you did not get that package directly from me and still want to give it a look it is now available in the IIUG Repository under: M…
Re: ontape for logical log backup
z. heavener wrote: > > is there a way to implement the backup of logical logs from a script > using ontape? > If you have such script, and it can be scheduled with cron, I would like > to see it. I have either a script or an executable ("C") either of which can be installed as t…
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: ODS 7.23.UC7
In article <1998061813183900.JAA22199@ladder01.news.aol.com>, olorin5@aol.com (Olorin5) wrote: > > Has anyone had problems with high sys on 7.23.UC7? > The engine is OK for about 15 min. after being bounced but then > sys is in the 70's and usr in the 20's. onstat -g glo repor…
Re: Trapping Informix Crashes ??'s
Glenn Travis wrote: > > You can set AFDEBUG=1, then start the instance. This will cause the [SNIP] > David Parent wrote: > > Wondering what tools DBAs are using to > trap Informix crashes (at any level, OS > or Informix). > > For instance, Informix crashes at…
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: dbservername/dbserveraliases/nettype
"Scott Kolaya" <skolay1@nycap.rr.com> offerred: +>BTW be careful to not use the same port for shared memory and tcp in +>the sqlhosts on the server > +>Art S. Kagel +We've been using the same port for shared memory and tcp for a year now in +production. Yes, shared memory connec…
shared memory
This is a multi-part message in MIME format. --------------F12A58D21005157C74BAD832 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit hello; how do i go about initalizing shared memory for informix 7.2 on a sun? --------------F12A58D21005157C74BAD8…
Re: onunload fails! help.
sjsyau@my-dejanews.com wrote: > > I try to onunload the demo database "stores7". > [SNIP] > 14:39:08 Checkpoint Completed: duration was 0 seconds. > 14:40:13 semget: errno = 28 > > 14:40:13 create_vp: cannot allocate memory > The server is running! > > Any hint? Yup, the hin…
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: +…
Problem with kaio
I am having a problem bringing up my database for the first time. I am on a HPUX 10.20 running Informix version 7.20.UC2. I have verified that the asynkdsk driver is loaded and linked into the kernal. I have created the /dev/async node according to the release notes and I contin…
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…
Re: Informix 7.22 Online under AIX 4.1 ERRORS !!!!!
>> shmat: [EINVAL][22]:shared memory base adress illegal >> using 0xd0000000, needs 0xffffffff >> >From onconfig : >SHMBASE 0x30000000 c Shared memory base address PMFJI, but isn't this the important one? The machine specific release notes detail the correct share…
Re: DB 7.21 (HP-UX 10.20) hangs while backup
if RESIDENT is set to 1 the shared memory used by informix will not be swapped to disk by UNIX if UNIX needs more memory. It's generally not a good idea to set to 1 if you're having problems or you're limited on memory. Scott Kolaya…
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
To ensure only using 1 register, the trick is to ensure that SHMVIRTSIZE is sufficient for all circumstances. In my experience, any execution of SHMADD should be caught and eliminated. Sean Bradley…
Re: slow performance
Thuc Nguyen wrote: > > Hi > > I am running ODS 7.23 u4 on HP 10.20 > > So many users complained about slow performance...I looked at "top".... > > IDLE has been around 21% > > %WCPU 36% == (command) oninit > %CPU 35% == (command) oninit > > The partial onconfig info.... [SNIP] > …
Re: HP shared memory limits
In article <1998032304401000.XAA04553@ladder01.news.aol.com>, SaTriGuy <satriguy@aol.com> writes >>:Okay, David. I might agree with you, but I would want to try it first. >>:Just remember that HP-UX 10.20 does not like to have more than two (2) >>:Informix virtual shared memory …
Re: HP shared memory limits
Well, since I started this let me jump in here... For a single instance of the Informix engine, you want to avoid allocating more than the initial virtual segment (the engine comes up with three segments, Resident and Virtual which are big and very active, and a "message" segmen…
Re: HP shared memory limits
>:Okay, David. I might agree with you, but I would want to try it first. >:Just remember that HP-UX 10.20 does not like to have more than two (2) >:Informix virtual shared memory segments, remember? More than two (2), >:and they get paged out. HP-UX problem, right? > >I believ…
Re: HP shared memory limits
David Weis <dweis@louisville-i-market.com> offerred: :Okay, David. I might agree with you, but I would want to try it first. :Just remember that HP-UX 10.20 does not like to have more than two (2) :Informix virtual shared memory segments, remember? More than two (2), :and they …
online workgroup server 7.22 on NT Server CLI probs
I'm running online workgroup server 7.22 on NT server 4 with service pack 3. I cant however get ilogin to work. I get the 406 error. Do I need to do anthing with shared memory before this will work? How does shared memory work with NT? email to ag@roninsrv.demon.co.uk Thanks, …
Re: Shared Memory Errot
Paul Watson wrote: > It should be under System-Configure-Kernel [sysadmsh] then follow the > instructions > > The alternative is to edit the files directly and relink the kernel by > hand. I don't have any SCO books to hand but files are mtune/stune under > the /etc/conf [?] dir…
Multiple Residency Problem solved - Thanks
Thanks to every one who responded to my problem. The solution seems to be that SHMVIRTSIZE and SHMADD were set slightly too high (18300 and 16384 respectively). I set them back to 16384 and 8192 respectively, based on the default values of 8192 and 8000 in onc…
Re: ONLINE SLOW on HP-9000!
Cecilio <cecilio@redestb.es> writes: As someone else said, post a copy of your ONCONFIG file, and the output from running 'onstat -g seg'. Can you also maybe post the output from something like 'sar -uw 10 20' when your computer feels slow? -- �yvind Gjerstad Systems dept To…
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.…
Solaris 2.5.1 Memory ? w/Informix
Hello, We have a 3000 Ultra which has the following: Informix DSA 7.24, 512 M physical memory, Solaris 2.5.1, 1 CPU. When DSA is up, there is about 70 M of physical memory available listed from vmstat or top. When Informix DSA is brought down, there is 119 M of physical memory …
-123 ISAM error : no shared memory ... TOP URGENT !!!!!
How to solve Shared Memory can't attach error in AIX 3.X ... Error Message was appeared after run dbaccess ... -529 Cannot attach to shared memory -123 ISAM error : no shared memory. Please send me a solution : brianip@magician.com.hk…
can't attach shared memory , TOP URGENT !!!
How to solve Shared Memory can't attach error in AIX 3.X ... Error Message was appeared after run dbaccess ... -529 Cannot attach to shared memory -123 ISAM error : no shared memory.…
Re: SHMVIRTSIZE
>Hi > >I had a strange problem. I am running SAP on informix. I'd increased >SHMVIRTSIZE parameter recently. After that, I'd shutdown and restarted >both SAP and informix. No problem. Things were fine for a week. Last >weekend we had to install a HP-UX patch. We installed a patch…
SHMVIRTSIZE
Hi I had a strange problem. I am running SAP on informix. I'd increased SHMVIRTSIZE parameter recently. After that, I'd shutdown and restarted both SAP and informix. No problem. Things were fine for a week. Last weekend we had to install a HP-UX patch. We installed a patch and r…
Re: Question about ALARMPROGRAM
Sujit Pal wrote: > > Hello All > [cutting] > > So my question is: Has anyone done this sort of thing? Do you think = > (from your knowledge of Unix and event handling) that this is workable? = > If not do you have workarounds short of calling wrappers for each = > instance or wor…
Question about ALARMPROGRAM
Hello All The FM says that the script pointed by ALARMPROGRAM takes 4 arguments, = ie EVENT_SEVERITY, EVENT_CLASS, EVENT_CLASS_MSG and EVENT_FILE (aka See = Also). I have multiple databases residing on the same machine, so I need = the instance name as well to identify an alarm.…
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…
Virtual Shared Memory increases with Online/Optical
We are using ODS 7.20.UC2, Online/Optical with Plexus XDP StorageManager 2.2. on Sun Solaris 2.5. We have written a small process which stores some TIFF-Images as Blobs on Optical Disks. Each time the process is being run the Informix Server takes a portion of the Virtual Shared…
Re: log_full.sh script exits with code 139
I just dealt with this -- In our distribution IUS 9.12UC3 on IRIX 6.4 there is a no_log.sh script in the etc directory, replace the ALARM_PROGRAM entry with the full path to no_log.sh and that should do it. We just made that change, and we have not had a problem in 2 hours! Da…
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: memory
Thuc Nguyen wrote: > > Hi > > I am running Online 7.23 on HP 10.20 > > We want to find out why we allocate alot of memory per user and never > release it. > > Is that memory leak? Actually you are probably not allocating any memory "per user". If your default connection, or the…
Informix wg server 7.20.uc2 on SCO 5.02 halts with 25580
I'm installing informix online workgroup server 7.20.uc2 on SCO 5.02. As recommanded by Informix, I've modified kernel parameters and relinked the kernel. Installation have completed but when I launch oninit, the systems replies : oninit: Fatal error in initializing ASF with 'ASF…
Re: DS_TOTAL_MEMORY configuration
>We are trying to configure our instance of Informix ODS 7.23 to support >pdq. Using the default DSS parameters (DS_TOTAL_MEMORY and DS_MAX_QUERIES >are blank), we get 208 errors when running queries with aggregate >functions and PDQPRIORITY>1. > >Our first guess was to increase …
Re: DS_TOTAL_MEMORY configuration
dmahoney@intraware.com wrote: : We are trying to configure our instance of Informix ODS 7.23 to support : pdq. Using the default DSS parameters (DS_TOTAL_MEMORY and DS_MAX_QUERIES : are blank), we get 208 errors when running queries with aggregate : functions and PDQPRIORITY>1. …
Re: DS_TOTAL_MEMORY configuration
dmahoney@intraware.com wrote: : We are trying to configure our instance of Informix ODS 7.23 to support : pdq. Using the default DSS parameters (DS_TOTAL_MEMORY and DS_MAX_QUERIES : are blank), we get 208 errors when running queries with aggregate : functions and PDQPRIORITY>1. …
DS_TOTAL_MEMORY configuration
We are trying to configure our instance of Informix ODS 7.23 to support pdq. Using the default DSS parameters (DS_TOTAL_MEMORY and DS_MAX_QUERIES are blank), we get 208 errors when running queries with aggregate functions and PDQPRIORITY>1. Our first guess was to increase DS_TOT…
Re: Error in shared memory initialization
At 10:18 AM 10/15/97 -0400, you wrote: >I initialized my online 7.2 on Solaris 2.5.1. Then I tried to add >dbtempspace and logical logs. Now when I do oninit it gives me the error > >oninit: Fatal error in shared memory initialization >The online log says >10:16:26 Event alarms …
ODS hangs on startup
Since I've upgraded to ODS 7.2, I've had this nagging problem when I bring the engine down and then restart it. It hangs on the way to quiescent mode. The log indicates event alarms enabled, then three VP processes start, then nothing. I control-c out of the process, take th…
Shared Memory Initialization
I initialized my Online 7.2 on Solaris 2.5 successfully. Then I tried to add logical logs and temp space and now it does not initialize. Any ideas? oninit: Fatal error in shared memory initialization 10:16:26 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alarm.sh' 10:1…
Error in shared memory initialization
I initialized my online 7.2 on Solaris 2.5.1. Then I tried to add dbtempspace and logical logs. Now when I do oninit it gives me the error oninit: Fatal error in shared memory initialization The online log says 10:16:26 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alar…
Re: HELP: Informix Online on HP-K460 is NOT-SCALABLE?
Thanks for responding... SaTriGuy <satriguy@aol.com> wrote in article <19971004200101.QAA06456@ladder02.news.aol.com>... > >Online on HP-K460 is NOT-SCALABLE? > >From: "James Francis" <jfrancis@dxi.com> > >Date: Sat, Oct 4, 1997 13:48 > > First of all, your buffers are really way…
Re: HELP: Informix Online on HP-K460 is NOT-SCALABLE?
>Online on HP-K460 is NOT-SCALABLE? >From: "James Francis" <jfrancis@dxi.com> >Date: Sat, Oct 4, 1997 13:48 >The relevant parameters from the onconfig file: >MULTIPROCESSOR 1 >NUMCPUVPS 3 >NETTYPE ipcshm,2,300,CPU >NETTYPE soctcp,1,100 ,NET >BUFFERS 7200 >PDQPRIORITY 0 >OPTCOMPI…
Re: Informix crashing UNIX on HP
Silvester_Valiente writes: > I had never heard of this problem before on HP. We have been running > 7.20 - 7.22 > for over a year with as many as 10 x 8 Mb extents at one time (ie > during heavy load). See my previous posting on this. With HP/UX, >3 shared memory segs per proc…
Re: Informix crashing UNIX on HP
Jeff Kalchik wrote: > On Thu, 02 Oct 1997 16:19:24 +0200, "Mark D. Stock" > <mdstock@informix.com> wrote: > >Make sure you don't allocate more than ONE VIRT segment on an HP box. > >This is normally just a performance issue, but could be your problem? > > Wait a minute..... Why …
Re: Informix Online 5.0 and Solaris 2.5
>"Shared memory not initailzed" does (necessarily) imply a problem with >the UNIX server's shared memory; This first line should have read ".... does not (necessarily imply a problem ...." Also, I've checked my release files and your shared memory settings seem fine. Neil Trub…
Problems installing Informix DS on ScoOpen 5
I'm running a ScoOpen 3.2v5.0.2 and I have installed an Informix Online DS 7.22.UC3. The installation went ok, but when I run the command : oninit -iy I receive the error message : oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '- 25580'. $ The lo…
Re: Error 208: Shared memory problem
Mark D. Stock wrote: } Derrick Hardison wrote: } > } > This may be obvious, but make sure that the SHMTOTAL parameter in the } > ONCONFIG file is set to the maximum amount of memory available to } > On-line. } > NOTE: This is the total amount of memory in the system minus any …
OnLine 7.20 problem
We have Informix ODS 7.20 UC2 on machine: HP9000 K260, HP-UX 10.20. The onconfig was copied form onconfig.std to the new and names were changed. The ROOTPATH is a cooked file. I initialized online 7.2 oninit -i and database engine not started. I get the following in the log: 1…
Re: Error 208: Shared memory problem
Derrick Hardison wrote: > > This may be obvious, but make sure that the SHMTOTAL parameter in the > ONCONFIG file is set to the maximum amount of memory available to > On-line. > NOTE: This is the total amount of memory in the system minus any > memory needed by the OS and othe…
Re: Can't change SHMVIRTSIZE
In article <34040108.70F4@romac.com>, Timothy Jones <tojones@romac.com> writes >HP 9000 K420 UX 10.10 w/1.0Gig of RAM >Informix 7.14 UC1 > >Getting Error 156 when I changed from 170000 to 200000 > >Any ideas ? > >TJ What does finderr -156 give, I can't see it listed…
Re: Error 208: Shared memory problem
This may be obvious, but make sure that the SHMTOTAL parameter in the ONCONFIG file is set to the maximum amount of memory available to On-line. NOTE: This is the total amount of memory in the system minus any memory needed by the OS and other processes. If On-line tries to dy…
Re: memory
In article <5v76b7$pg0@cssun.mathcs.emory.edu>, Thuc Nguyen <thucn@email.utcourts.gov> writes >I looked at the log file of Online 7.23 running on HP 10.20 > >What does "dynamically allocated new shared memory segment" mean? >and how can I resolve that problem? > > >14:57:23 Chec…
RE: memory
Thuc, Informix is requiring additional space in memory, it needs the virtual size to be increased. Because your engine experiment performance degradation by having more than 1 virtual segments , you must increase the SHMVIRTSIZE onconfig parameter to match the size of the two se…
memory
I looked at the log file of Online 7.23 running on HP 10.20 What does "dynamically allocated new shared memory segment" mean? and how can I resolve that problem? 14:57:23 Checkpoint Completed: duration was 2 seconds. 14:57:43 dynamically allocated new shared memory segment …
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: Can't change SHMVIRTSIZE
Timothy Jones (tojones@romac.com) wrote: : HP 9000 K420 UX 10.10 w/1.0Gig of RAM : Informix 7.14 UC1 : Getting Error 156 when I changed from 170000 to 200000 Is it possible that your SHMMAX kernel parameter is set somewhere between 170MB and 200MB? OnLine will try to allocate…
Online hangs during oninit after reboot.
Folks, Sorry I should have provided a few more details initially. Here is the squence of events: 03:00 1. We shut down the engine with onmode -ky (probably no users present) 2. The RS6000 box is rebooted. 3. We restart the engine with oninit It during step 3 that the onli…
Can't change SHMVIRTSIZE
HP 9000 K420 UX 10.10 w/1.0Gig of RAM Informix 7.14 UC1 Getting Error 156 when I changed from 170000 to 200000 Any ideas ? TJ…
Re: HELP ... Multi System Disaster
... >We are facing a problem of consististently running out of memory. >ie.: INFORMIX seems to be taking control of 100% of the memory >resources ... I would first look in the config file and see if shmtotal is set to zero. If it is, that means you are allowing Informix to grab…
Re: HELP ... Multi System Disaster
... >We are facing a problem of consististently running out of memory. >ie.: INFORMIX seems to be taking control of 100% of the memory >resources ... I would first look in the config file and see if shmtotal is set to zero. If it is, that means you are allowing Informix to grab…
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: Event Alarms
Felix Koshy Mathews wrote: > > In <33B7F989.2C97@arrowintl.com>, Chad Laity wrote: > >Does anyone out there have an event alarm that warns you via > >email when the logs are a certain %age full?? > > > >I tried to alter the script logevent.sh to accomplish this but > >it did not …
Re: Event Alarms
In <33B7F989.2C97@arrowintl.com>, Chad Laity wrote: >Does anyone out there have an event alarm that warns you via >email when the logs are a certain %age full?? > >I tried to alter the script logevent.sh to accomplish this but >it did not work. > Chad, You have to add the follo…
Event Alarms
Does anyone out there have an event alarm that warns you via email when the logs are a certain %age full?? I tried to alter the script logevent.sh to accomplish this but it did not work. Thanks, Chad Laity mailto:chad_laity@arrowintl.com…
Re: onmode -F
Zeljan Silje wrote: > > Hi, > > in "Performance Guide Version 7.2" I found recommandation to run onmode > -F using cron facility. > Does anyone has experience with this, and how often should I execute > onmode -F using cron? > I am using Informix OnLine7.22 on AIX4.2. > > Thanks …
Re: Shared Memory allocation error
<SNIP> > I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. > When I run a query on a view that joins many tables online begins > allocating additional shared memory until it hits an illegal address. <SNIP> > SHMVIRTSIZE 8000 # initial virtual…
Shared Memory allocation error
All: I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. When I run a query on a view that joins many tables online begins allocating additional shared memory until it hits an illegal address. At this time the query hangs but the engine stays up. If anyone c…
Shared memory
My director told me that Digital dialed into our Unix box (AT&T running Informix 5.05) and saw that every sqlturbo is getting 5000 pages of memory. Does anyone know if this set in the tbconfig file? I can't find any information about this. If I can reduce this, it may benefit …
Re: Shared Virtual Memory Question/Engine Shutdown
In article <5d9913$cq5@cssun.mathcs.emory.edu>, Mario Estrada <marioestrada@guate.net> writes >Hi Carol! > >Error 22, is a Unix error indicating hat an invalid argument has been passed, >in DSA terms, it means that the shared memory requested by oninit >cannot be allocated. > >1)…
Shared Virtual Memory Question/Engine Shutdown
Our project site recently received a binary executable from a sister site which updated approximately 5000 stored procedures. The executable brought down the engine due to shared memory limitations. When looking at the data (onconfig, memory on machine, etc. as stated below), t…
Re: shmdt: errno = 22
Double check the shared memory parameters Informix suggests for 7.12 for your kernel. Good Luck, Arun…
Re: Do alarms work in 7.20 ?
ctreptow@aol.com wrote: > > Hi. I am trying to write an alarm program for Informix, but it doesn't > appear to work. We are on HP-UX 10.01 running Informix Online version > 7.20. I have written the following script, but it doesn't ever appear to > get called by Informix. Acco…
Calculate the size of the resident portion of ONLINE
The formula on page 2-22 (INFORMIX-Online Dynamic Server Performance Guide V7.2) is not correct. f.e.: BUFFERS=4000, LOCKS=10000, PHYSBUF=64, LOGBUFF=64 With the formula the resident size shoud be 13986880 Bytes, onstat -g seg says: 16539648 Bytes --> difference over 2 MBytes ! …
Re: HELP I'm in crisis
You need to avoid dynamic shared memory segments on HP at all costs. If your SHMVERTSIZE is 60000, I would suspect that would be enough. However, if your application is leaving a lot of open statements (i.e. not issueing a FREE on a prepared statement or CURSOR) then each user t…
Re: ONINIT ERROR - shared memory
Peter Strempel wrote: > > I get the following error when running oninit or onmonitor to initialise > our database for the first time: > > WARNING: semsys: can't load module, too much memory requested. > > We are running ONLINE DS ver 7.20.UC3 on Solaris 2.5.1. The hardware is > …
Re: malloc()/brk() failing with lots of mem. and swap space ?
Atiqullah Hashmi wrote: > > We are running Sol2.4 on a Sun 670. The applic. uses informix. > At one point during execution, the applic. is failing in malloc(). > Although there is not sign of mem. shortage. Below are the relevant > outputs of unix tools to determine mem/swap spac…
Re: out of virtual shared memory
In article <53bidq$gqf@cssun.mathcs.emory.edu>, mailgw!hpx400!Trevisol_R oberto/bbb_cak@srv3-poa.nutecnet.com.br writes >>In article <530p0d$o12@cssun.mathcs.emory.edu>, >>Ralph.Halter@pac.panmail.com writes >>>Hi all! >>> > >>>When I saw this message today I checked with onstat …
Re: out of virtual shared memory
>In article <530p0d$o12@cssun.mathcs.emory.edu>, >Ralph.Halter@pac.panmail.com writes >>Hi all! >> >>We're running OnLine 7.10.UD1 on AIX 4.1.2 on an RS6000-J30 with 256MB memory >>and 480MB paging space. There are 15 uniface developers/users filling about >>50MB of logical logs …
Shared memory
I guess i missed some previous discussion about shared memory problems. I'll appreciatesome info about the followinfg error message: "Cannot attach shared memmory" from the Rapid Developement System, Informix 4GL V4.10 under AIX. Ramiro Rela.…
Re: initializing shared memory
} From: Gene Terry Sanford <tsanford@csti-md.com> } Subject: initializing shared memory } } We are runnning informix 4.1 on SCO OpenSever 5.02. } When we run tbinit to initialize shared memory we get } the following error: } } tbinit: shmat[EINVAL][22]: shared memory base addres…
initializing shared memory
We are runnning informix 4.1 on SCO OpenSever 5.02. When we run tbinit to initialize shared memory we get the following error: tbinit: shmat[EINVAL][22]: shared memory base address illegal using 0x80480000, needs 0x80000000 tbinit: fatal error in shared memory creation. Our…
Re: Shared Memory Not released
>Brian Li <cphdcbl@ted.cs.depaul.edu> wrote in article ><511nel$aft@shrike.depaul.edu>... >> >> Dear Informix experts, >> >> We are currently have Informix Dynamic Online running on our HP T500 >machine >> and recently have shared memory problem which is only known to be solved …
>1 Virtual Shared Memory Segment slow down
I've been told by Informix that having >1 virtual shared memory segment slows down your Informix Online Database server. Informix normally has 3 share memory segments 1 Fixed size 'Resident' shared memory segment for disk cache etc. 1 Fixed size 'Message' shared…
Re: Performance Decreasing
In article <50q3hh$7ka@nntp1.best.com>, Lin-Chuan Lee <lclee@nntp.best.com> writes >Bill Ennis (ennis@ssax.com) wrote: >: Are you adding dynamic memory segments as the system is up? >: Run onstat -g seg. If you have many segments of type V when your >: system is slow this could b…
Re: Performance Decreasing
Bill Ennis (ennis@ssax.com) wrote: : Are you adding dynamic memory segments as the system is up? : Run onstat -g seg. If you have many segments of type V when your : system is slow this could be a signifcant part of the problem. : -Bill Is there a known bug that causes engine t…
RE: event-alarms
---------- From: Stuber[SMTP:sstuber@intrlnk.com] Sent: Thursday, August 15, 1996 3:22 PM To: informix-list@rmy.emory.edu Subject: event-alarms The Administrator's Guide (7.1) states "When any of the events in a = predefined set occur, OnLine invokes=20 this executable" wher…
Re: event-alarms
Hi, There was an articule in our last user group newsletter on Alarms which has an example of how to use Alarms. You can view it at our user group web site www.access.digex.net/~waiug Regards - Lester > The Administrator's Guide (7.1) states "When any of the events in a prede…
event-alarms -Reply
I don't have the answer to your question but basically everything which writes an alarm to the log will call alarmprog. It is a handy utility except that at present it doesn't work to well. If alarmprog gets passed a string longer than a predefined length (512 bytes?) then it wi…
event-alarms
The Administrator's Guide (7.1) states "When any of the events in a predefined set occur, OnLine invokes this executable" where "this executable" refers to ALARMPROGRAM. Is the "predefined set" referring to figure 33-2? In other words any event of a sort listed in that table wi…
SHARED MEMORY
Hi All When doing kernel performance tuning for a Informix 5.0 system with 512MB memory and 50GB disk, should the the shared memory be included into the kernel parameter tuning or excluded. Watching the memory use with 'cpqmon' it appears that these calculations should be done …
SHARED MEMORY
Hi All When doing kernel performance tuning for a Informix 5.0 system with 512MB memory and 50GB disk, should the the shared memory be included into the kernel parameter tuning or excluded. Watching the memory use with 'cpqmon' it appears that these calculations should be done …
Re: SHARED MEMORY
At 12:36 PM 6/19/96 -0700, Paul Middleton wrote: >When doing kernel performance tuning for a Informix 5.0 system with 512MB >memory and 50GB disk, should the the shared memory be included into the >kernel parameter tuning or excluded. > >Watching the memory use with 'cpqmon' it a…
HP USERS with Dynamic Server, ALERT!!
This is for all the HP users of Informix version 6 or greater. If you don't already know (like I didn't) the number of virtual shared memory segments your config access must be 2 (TWO!) or less or it will *GREATLY* affect the performance of the server. This problem is fairly sp…
segmentation violation on O.L.7.12
On aix 4.1.4 an online 7.12.uc1, online crash after the following statement: revoke all on fakturen from public; The table fakturen has 532020 rows. The log file indicates: Assert Failed: Internal Error - Segmentation Violation Who:Session(271, informix@dpescam1, 12472, 107402…
Help! OnAutomatic backup using Informix...
Hello I work with Informix 7.10.UC1 on Solaris 2.4 I have a program that forks and execs ontape, communicates on a pipe to feed "return" to it and continues doing some other work. It needs to be informed when and with what status ontape completed. I tried using the event-al…
Help! OnAutomatic backup using Informix...
Hello I work with Informix 7.10.UC1 on Solaris 2.4 I have a program that forks and execs ontape, communicates on a pipe to feed "return" to it and continues doing some other work. It needs to be informed when and with what status ontape completed. I tried using the event-al…
Re: Question about virtual memory segments
Item Subject: Texto da Mensagem }>We're running Online version 7.11 on HP/UX 9.X and have run into a }problem }>where the engine keeps crashing since it keeps allocation virtual memory }>segments until all memory is used up. Is this the correct behavior or }>have we run into a bu…
Re: Question about virtual memory segments
>We're running Online version 7.11 on HP/UX 9.X and have run into a problem >where the engine keeps crashing since it keeps allocation virtual memory >segments until all memory is used up. Is this the correct behavior or >have we run into a bug? Hello Bill -- There is a paramet…
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:Timeout in 4GL Programms
tvarnas@compulink.gr (Apostolos Varnas) schrieb : tv>I want to implement a timeout of a 4GL application from inside the tv>application.I tried to use alarm() but I found out that alarm() is used tv>internally from Informix and thus resetted after each keyboard stroke. tv>This po…
Re: OnLine 7.X performance - R U satisfied?
ray, > Are you taking full advantage of you physical memory? How does you > caching ratios look (onstat -p)? If not in the 90's play arournd with caching ratios are good, high 90's. > BUFFERS and SHMVIRTSIZE. Also, is the engine frequently allocating > additional shared…
Re: OnLine 7.X performance - R U satisfied?
Are you taking full advantage of you physical memory? How does you caching ratios look (onstat -p)? If not in the 90's play arournd with BUFFERS and SHMVIRTSIZE. Also, is the engine frequently allocating additional shared memory segements? If so, this will impact performan…
Re: Loading tables in Shared Memory
peeyush wrote: > > Hi, > > I need to know how to load some of the frequently used tables (like master > reference tables which are accessed very frequently) into SHARED MEMORY. By > loading them into shared memory, they permanently reside there until they > are unloaded, and the …
Re: Loading tables in Shared Memory
peeyush (peeyush@toj.com) wrote: : Hi, : I need to know how to load some of the frequently used tables (like master : reference tables which are accessed very frequently) into SHARED MEMORY. By : loading them into shared memory, they permanently reside there until they : are unl…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
Shared Memory Setup.
>The type of info I'm looking for is: >- How to interpret Informix shared memory error messages. Usually either a) the server fails to start or 4GL program used shared memory connection fails to connect SHMBASE environment variable is set incor…
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…
Re: 6.0 Shared Memory Usage
From: jvemo@cyberspace.com (Jon C. Vemo) > There are (I believe there also in ver. 6) $ONCONFIG parameters to control > the amount memory that OnLine can consume. If these are not set (in > particular SHMTOTAL), then SHM will grow until there's no more room to grow >…
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?…
7.1 - Unable to free unused shared memory
If anyone has struck and/or resolved the following problem then any advice that could be offered would be appreciated. Environment: Sparc1000 running 7.1 DSA. 512 Meg Ram. Not a dedicated Informix Server. Problem1: When physical ram (as opposed to swap) gets down to near zer…
Re: OnLine shared memory question
>From: res@din.lois.perm.su (Igor G. Popov) >Subject: OnLine shared memory question >Date: Fri, 28 Oct 94 16:55:07 +0600 >X-Informix-List-Id: <news.9512> >When I attempt to increase BUFFERS value in tbconfig, >initializing fail and print message: >tbinit: shmat[EINV…
Re: Online and Shared memory
ywleung@ouray.denver.colorado.edu (YIU WAH LEUNG) writes: >I went into a theoretical discussion with my workmate on how Informix handles >shared memory that is defined by using tbmonitor/Parameter/Shared memory. >He said that the size of the shared memory that defined in Informi…