Oninit® Archive
Results for “onstat -g seg”
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
This system is running one 14.10.FC11X8 standard server with two RSS servers. For some time onstat -g seg shows an increasing number of virtual segments - we have an alert for a threshold of 10 or more: IBM Informix Dynamic Server Version 14.10.FC11X8AEE -- On-Line -- Up 5 days 2…
Onbar: Failed to determine archive's encryption mode. Error code 2
That's great! You have found out a lot about using onbar and Veritas...and that will be useful for the future. The command to clean up the memory segments, etc has the cryptic name of...."onclean"! :-) ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems…
Large memory segment vs smaller ones
I believe that the largest memory segment for Informix on AIX is 64 GB. In 11.70, we would normally expect the bufferpools to be created in the resident segment. Based on your first post showing the memory segments, it looks like the "resident" segment has been maxed out, and 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…
unable to select, delete the data and unable to drop the table, response says Long transaction detected
Post your onstat -g seg, onstat -l, and onstat -d reports and we will try to help. Arr ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
Shared Memory
Hello, Today I checked the Informix shared memory by onstat -g seg on Informix 14.10FC6X3 informix [rs-om-ifx-201] on_nebula21 $ onstat -g seg IBM Informix Dynamic Server Version 14.10.FC6X3 -- On-Line -- Up 16:43:49 -- 10327040 Kbytes 2021-09-03 15:36:42 Segment Summary: id …
Shared memory segments are not removed with the onmode -ky command
Hello, It can be this issue? IT29597: shutting down an instance using INFORMIXSERVER different from the one used for startup would leave shared memory segments behind For AIX, it should be fixed in 14.10.FC3X1 12.10.FC13XF 12.10.FC13XH ------------------------------ Milan Rafaj …
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…
High CPU Utilization
Turn on SQLTRACE in low mode. Bear in mind this allocates memory from your virtual segment. Then use 'onstat -g his' to find any long-running or frequently run queries which are consuming a lot of time. HTH, Ben.…
SHARED MEMORY ALLOCATION
Note that DS_NONPDQ_QUERY_MEM is limited to 25% of DS_TOTAL_MEMORY. Neither DS_TOTAL_MEMORY nor DS_NONPDQ_QUERY_MEM are carved permanently out of SHMVIRTSIZE but are allocated from there as needed and released. I can alleviate Benjamin's fears. The total of DS_NONPDQ_QUERY_MEM u…
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…
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…
Full memory even if I set SHMTOTAL
Are you sure this is shared memory that's being allocated beyond SHMTOTAL? Once going over those configured 16 SHMTOTAL, would you also see this=20 reflected in 'onstat -g seg' ? Andreas From: "CHALLENGER212 ABDERRAFI" <abderrafi212@gmail.com> To: ids@iiug.org Date: 22.01.2017 …
ids 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…
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…
onmode -F question...
I'm aware of at least one APAR which affects 11.70.FC8. IC98869 (APAR # is for 12.10, but problem affects 11.70.FC8 as well) ONMODE -F (FREE UNUSED MEMORY SEGMENTS) CAN CRASH SERVER IN RSFREEBLK()…
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
This is ids12.1.tc4 on windows server 2008 R2 sp1 . This problem just started and I donât know why. When I run onstat I get this: MapViewOfFileEx: w32ec=487 at nt_shm.c:754 09:51:19 shmat: [22]: operating system error 09:51:19 Client could not attach server shared memory segme…
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)…
track session of memory segment
Hello, i have informix 11.50FC8GE server in there there are some memory segments so i want to track particulate user session or process for those memory segment. what is the best way to track them. memory segment like follows. IBM Informix Dynamic Server Version 11.50.FC8GE -- …
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
Folks, IDS 12.10 FC4, Linux 6. The following log is the only info we have about the crash ( no other info dumped ) You can see it was struggling to add lot memories segments before Panic .... The Panic was a also VERY curious one with some unexpected process terminated ... Wha…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
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?…
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.…
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…
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…
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,…
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
This concerns IDS 11.70.TC3IE on Windows server 2008. Each time the instance is started it reports that "the total shared memory size for this server to 2097152 KB" regardless of how many buffers, locks, etc are allocated. So, I conclude that the message is hard-coded to write to…
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…
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, …
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…
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
Art, I've been getting that error message "Insufficient free huge pages in /proc/meminfo for shared memory segment. Requested: 204800000 bytes. Available: 0 bytes. The default memory page size will be used." since I first installed and configured. The engine…
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 …
event trigger/alarm
afaik there is no alarm for this event; , you have to make the assumption that if the total shared memory size increases then there was a recent dynamic allocation of memory. You may want to tweak the below script to keep it from exiting since the engine may add several segments…
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…
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
"howie.lfc@googlemail.com" <howie.lfc@gmail.com> wrote in message news:b0a36222-0b2e-4bdf-98f8-8f003e163f0a@s2g2000vbw.googlegroups.com... > 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 …
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.…
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 …
Can not release unused virtual memory segment
IBM Informix Dynamic Server Version 9.40.FC2 Tru64 UNIX version 5.1a I want to release unused virtual memory segment. I used the command onmode -F. It does not work. online.log has following entry. 11:28:22 Attempting to free unused operating system segments. This operation ma…
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.…
Instance Crashed !!
What must be the ratio of Resident Memory & Shared Memory that we can allocate initially ? What is the impact of # of Buffers & its size to the size of Resident Memory. Thanks.…
Re: Introduction to the three designer handbags(Chanel,Coach,Prada)
What is a semaphore segment? Have you used 'ipcrm -s' instead of 'ipcrm -m'? You should only ever have to use the -m option, one for each remaining shared memory segment. No need to action on any semophores. And usually an 'onmode -ky' would be even more efficient, no need to f…
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…
Introduction to the three designer handbags(Chanel,Coach,Prada)
Due to an interrupted ontape restore, I was left with a down informixserver with its shared memory segments still being reported by ipcs. I carefully removed all the segments using ipcrm, being careful not to remove any used by the other two instances on the host, but when I rem…
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…
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 .......…
adding virtual memory segment
Hello All We are seeing a new virtual memory segment being added at just about the same time every morning - around 2:30 AM. We have set OAT and other capture methods to run during the early hours but see nothing super intensive that would seem to point to needing another segment…
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…
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]: …
Re: Alarm for New virtual shared memory segment
Personally I agree. Call IBM and register a feature request. 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 my employer, Advan…
Re: Alarm for New virtual shared memory segment
Personally I agree. Call IBM and register a feature request. 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 my employer, Advan…
Re: Alarm for New virtual shared memory segment
Art, Thank you. I would consider it a significant event because if I see the Server Dynamically adding new virtual memory segments that means I need to tweak SHMVIRTSIZE and add more memory to the initial segment. --David On Wed, Jun 9, 2010 at 3:52 PM, Art Kagel <art.kagel@g…
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…
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…
Re: 2 shared memory segments [18848
Hi Brian, Here are several things to consider in addition to onconfig parameters: 1. There might be a problem with not enough available memory due to memor= y useage by applications that are running on the server. When you say "re= start the server" do you mean just restarting t…
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…
IDS shared memory segment question
Dear All... I've an IDS 11.50.uc6 running in RedHat Enterprise 5.2 , some of my applications do the following to IDS in an endless loop : fork an esql/c application to connect IDS,insert data,and then die , such kind of actions will do hundreds of thousand time in a period , I o…
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??????…
Extra Shared Memory MESSAGE Segments
IDS 11.50.FC5 AIX 5.3 I am trying to figure out why the Message Segment decided to split itself into 19 smaller pieces ... and if there is anything wrong with it being in so many pieces or if I should strive to put them, ala Humpty Dumpty, back together again ... and how? Thank…
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…
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…
Re: shmat: : out of shared memory segments, ch....
You are running a 32bit version of IDS. On AIX 32bit applications cannot allocate more than about 1.8GB of memory. If pages are carefully aligned and properly sized you can push this to about 2.1GB. Your only alternative is to upgrade to a 64bit release of IDS. While you are at …
shmat: [24]: out of shared memory segments, check
Question: We canât get more than 1 gig of initial shared memory at instance startup. Is there a way to increase the SHMVIRTSIZE, which is being limited by the OS AIX 6.1.0.0? IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line -- Up 03:22:38 -- 2275792 Kbytes â --------…
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 …
trying to free virtual memory
Kamram, onmode -F will only free completely unused virtual memory segments. If you run "onstat -g seg" to view the virtual memory segments you can see if any are candidates for being freed. The last section, named Segment Summary, will have lines with a V in the class column. Th…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
IDS 7.31 Solaris8 - Long Checkpoints
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 …
Virtual Memory Segment Filling Up
We are using IDS 10.00.uc7 on AIX and we are noticing that shared virtual memory segments keeps growing, and we end up having to restart the informix to clean up the memory. Is there any way to determine which session id are using up what virtual memory ? What sql statements are…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Memory segments grow, and never be freed!!!!
Hello, friends. I need some ideas to solve our problem. Our machine is allocating several memory segments, since the IDS is started. The problem around is that it goes up and up allocating new segments, and never stops (it seems it´s not automatically freeing some segments not us…
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?
BUFFERS 3600000 (pagesize is 2KB,SO is 7.2GB), but user command 'onstat -g seg' ,then class 'R' is only 4GB..Is it system limited 4GB?? From Administrators Reference V9.40.. BUFFERS limited is 536,870,912(Solaris)....So I don't know why it is.... IBM Informix Dynamic Server Ver…
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…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Update 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!…
"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…
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…
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…
shared memory not initialized
I have just installed Informix 10 on a CentOS 4.5 system. When I run oninit -v to start the dbserver, I get the following, and then it dumps me back to bash: [root@informix informix]# oninit -v Your evaluation license will expire on 2007-10-30 00:00:00 Checking group membershi…
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…
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/Solaris Kernel Parameter (semsys:seminfo_semmni)
> > What do these 2 (semsys:seminfo_semmni, shmsys:shminfo_shmmin) kernel > parameters do or what are they related to?? > seminfo_semmni on solaris is the maxium number of semaphore identifiers for the system. shminfo_shmmin is the minimum size of a shared memory segment, in by…
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…
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: Cleanup corrupted shared memory segment of IDS
The simplest way is to run onmode -ky with the environment set up for the crashed/damaged server. That will bring the server down if it's still online and will usually clean up shared memory even if the server crashed hard and did not clean up on the way down. If that fails, you …
Re: Cleanup corrupted shared memory segment of IDS
Hi All Thanks Very Much, it work Regards, Satyan Software Engineer R&D - IBM Information Management Division 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8792 (T/L: 337-8792) = Manoj = Mohan/Lenexa/IBM = = To 11/01/2006 12:16 Sathyanesh = PM Krishnan/Lenexa/IBM@IBMUS = …
Re: Cleanup corrupted shared memory segment of IDS
add 56 + hex(server number) =3D xx (the number) and do "userid root ipcs | grep 52xx48" this will give you list of all = your shared memory segments... root ipcrm -m for the list of shared memory segments... = Sathyanesh = Krishnan/Lenexa/I = BM@IBMUS = To Sent by: informix-…
Cleanup corrupted shared memory segment of IDS ser
Hi All, I am trying to get information how to cleanup corrupted shared memory segment of IDS servers without rebooting the UNIX host. If anyone knows the documentation then can you please forward it to me. Thanks, Satyan Software Engineer R&D - IBM Information Management Divis…
onmode -ky hangs
Hello Frank The onmode is nothing but a client application. Whenever, you execute an onmode command, it will make a new connection to the database server and each new connection uses some virtual memory. During the load job you added several virtual memory segments and consumed…
onmode -F: is it just HP-UX?
malc_p@btinternet.com wrote: > Re. my previous issue with loads of V segments; We're on HP-UX11i and > IDS9.30, and onmode -F does absolutely *squat* with regards to > releasing any segments. Out of the segments we had, there were plenty > with just 2 or 3 blocks used and if you…
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 …
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
SQL NET wrote: > 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 onstat doesn't calculate it - it reads from shared memory…
Re: oninit PIDs and Shared memory segments
hariog@yahoo.com wrote: > Hi All, > > Many years ago, Madison Pruet you wrote a very useful utility that > shows all processes on the system and then determines which shared > memory segments are owned by which process. This utility certainly > would be very handy, specially when…
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…
oninit PIDs and Shared memory segments
Hi All, Many years ago, Madison Pruet you wrote a very useful utility that shows all processes on the system and then determines which shared memory segments are owned by which process. This utility certainly would be very handy, specially when many instances are running on one …
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: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
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…
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
Hope this helps... http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.perf.doc/perf97.htm Regards, Nilesh…
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…
RE: shared memory segment size
Is your OS 2K page or 4k? jp "Barry Leb" <bjleb@hotmail.co m> To Sent by: informixquestions@googlemail.com, informix-list-bou infor…
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…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Shared Memory challenge on AIX 5.1
One of my sites has 1 Gbyte of RAM. I have configured them to use 512Mbytes of Virtual Shared Memory and about 256 Mbytes of Resident Share Memory. RESIDENT is set to 0. During normal processing everything is OK with those settings. Occasionally the size of the virtual shared m…
Re: 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 …
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?…
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,
max said: > I have a serious informix problem > Server: informix 9.3 on a Sun System SUNW,Netra-T12 8 CPU's > One of our informix server crashes with the following error: > > 14:27:34 shmat: [EMFILE][24]: out of shared memory segments, check system > SHMSEG > > We use a Solaris…
out of shared memory segments, check system SHMSEG on solaris 8 Informix crashed
> 14:27:34 shmat: [EMFILE][24]: out of shared memory segments, check system > SHMSEG > ... > We use a Solaris 8 System with the following /etc/system entries: > ... > set shmsys:shminfo_shmseg=100 > What do we need to change to increase the availability ? You have to i…
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…
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: 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: what is 'VX' shared memory segment type?
Using UDTs, UDFs, ... ? X is pointing to X-tended :-)…
what is 'VX' shared memory segment type?
--0-1490076988-1102057434=:45685 Content-Type: text/plain; charset=us-ascii Hi! IDS 9.30.UC3 on Sun Solaris 8. Does anybody now what is 'VX' shared memory segment type? Informix Dynamic Server Version 9.30.UC3 -- On-Line -- Up 09:13:09 -- 62464 Kbytes Segment Summary: id …
Setting on BUFFERS parameter
Hi, I am running IDS 7.31.UC6A on HP-UX 11i with 6 CPUs and 6 GB memory. Previously we set the BUFFERS to 80,000 only. After some testing, we change it to 600,000 and the performance is improved significantly. So we try to increase the value to test the performance again. We try…
Shared memory segment message on intialisation
7.31 UD8 on SCO Unixware 7.1.1 Our customer has just upgraded from UC6 -> UD8, and is seeing these shared memory segment messages at start-up time. We've not seen them before on UD8 on other OSs (AIX or Linux). has anyone else seen them, know what they mean, know if they are i…
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'?…
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…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
RE: Fatal error in shared memory
"McCabe-Reed, Barbara SIK" wrote: > > I have encountered and resolved this problem by running the command ipcs and > removing the shared memory segments. As long as you are the owner you can > run the remove command, if not, you must ask the root system admin. > > P.S. There ar…
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…
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…
Allocating memory segments without apparent reason
Scenario: IDS 7.3 UC5 AIX 4.3.3 - LEVEL 11 Our system have been working fine for a long time. Last Tuesday, without = =3D any change on the configuration the system stopped. In less than 1 = =3D minute and without an excesive load in the system, Informix = allocated =3D all memo…
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?…
Re: Shared memory segment IDS 9.4
> <!> When did AIX 5.3 come out? <!> I am not from the future :-) , it is a mistake. Should be AIX 5.2.. Wojtek…
Re: Shared memory segment IDS 9.4
"Wojtek Korg�l" <wkorgol@nospam.gazeta.pl> wrote in message news:<c951f9$7qa$1@inews.gazeta.pl>... > 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 porti…
Re: Shared memory segment IDS 9.4
Wojtek, the server will allocate all the buffer's you have asked for. The rest of your buffers which will not fit in the first resident segment will go into the next virtual segment(s). You can look them up with onstat -g mem where you should see a pool named something like "ovr…
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: Error forking ipcshm listener thread
Theres a memory segment "stuck" and you will need to either bounce the box (shutdown) or determine the PID for the the VP with the segment in question and kill that - which could create consistency probs if you get the wrong one. I would bounce the box, but sometime in the past …
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,…
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…
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…
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…
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…
virtual shared memory segment
hello, this is our output from onstat -g seg : Segment Summary: id key addr size ovhd class blkused blkfree 7680 1381386241 80000000 592850944 245712 R* 144714 25 (shared) 1381386241 a3563000 201334784 6760 V 49154 0 46597 13…
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…
Shared memory segments never freed
Hi all, On one of our systems we have the following problem: RS6000 AIX 4.3.2.0 IDS version 7.30.UC6 One of the application programs adds 3 shared memory segments in. When the program is terminated, this shared memory segments are never automaticaly freed (see output of onstat …
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…
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…
Dictionary Cache
We have a second virtual memory segment which we would like to free up. No users are currently using this segment but we do have 11 tables out of 773 using in for Dictionary Caching. Is there a way of either removing these tables from the Dictionary Cache or rehashing them to try…
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…
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…
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…
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…
Multiple virtual memory segments on HP-UX ...
Hi, from a HP person, commenting on memory segments: "Our hardware provides only 2 registers to store the protection code for memory segments. The alternate usage of more than two shared memory segments results in "protection faults" and a reload of the register content. This w…
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: Server down... Segment locked
Some OS can panic after allocating too many shared memory segments, database needs to have the shared memory segments changed. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: ibogorad@yahoo.com [mailto:ibogorad@yahoo.com] Sent: Wedne…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
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: IDS 9.20
> Was it causing more than 4 memory segments? We're talking about an HP here > -- a seriously brain damaged memory architecture. Nah. S'not that. I've had my arse bitten by that one before.…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Informix 7.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…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
initialize-segmentation falt
I use RedHat6.0 and informix ids7.3 when initialization with onmonitor, there is a segmentation fault I think that the problem is caused shared memory... I heard that in linux, I should set the kernet parameters..but I don't know how to do it..…
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…
Errors in log file while creating shared memory
We brought Informix offline and when we tried to bring it online again, we were getting following error repeatedly 13:54:07 Could not create single shared memory segment with resident and non-resident par titions. Proceeding to create 2 shared memory segments instead. 13:54:07 …
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…
Multiple Residency & Shared Memory
Thanks! I believe I have it working now. In article <39339DD0.43D97E2@home.com>, Edward Rosenthal <edrosenthal@home.com> wrote: > your two instances won't share the same memory space,or segments. > after you bring your second instance up you can see which 'keys' > belong to th…
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 I right? Thank …
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…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Re: Shared Memory Segments are not removed
"Arshad, Shehla" wrote: > > I did open up a case with Tech Support and they advised me post this problem > on IIUG. I guess I am stuck!! No! That's got to be the joke of the century! Or does it put us all in high standing with the official support channel? :-) If you've paid fo…
RE: Shared Memory Segments are not removed
The shared memory segments are marked to be deleted, but there are processes still attached to them. We have found the fastest way to remove them is to re-boot the system's. I have only seen this problem on HP-UX system's. Wayne E. Martin Informix Database Administrator Kmart C…
FW: Shared Memory Segments are not removed
We see the same problem on 10.20 and 11.0 HP-UX. We have traced it down to process's still having open file's to these shared memory segments. remove the processes and the segments will be removed by the OS, that is what the "D" is for. In our case we have found it easier to re…
RE: Shared Memory Segments are not removed
I did open up a case with Tech Support and they advised me post this problem on IIUG. I guess I am stuck!! > -----Original Message----- > From: Obnoxio The Clown [SMTP:obnoxio@hotmail.com] > Sent: Wednesday, March 08, 2000 9:37 AM > To: SArshad@purolator.com; informix-list@iiug.…
RE: Shared Memory Segments are not removed
From: "Arshad, Shehla" <SArshad@purolator.com> > >Yes, we have tried ipcrm as root but that does not remove the segments. >Unix >complains that the segment id is invalid. That may be because the instances >have been marked as "to be removed" and the key of those segments looks >l…
RE: Shared Memory Segments are not removed
Yes, we have tried ipcrm as root but that does not remove the segments. Unix complains that the segment id is invalid. That may be because the instances have been marked as "to be removed" and the key of those segments looks like 0x00000000. No, we run onmode -ky once. Do you me…
Re: Shared Memory Segments are not removed
From: "Arshad, Shehla" <SArshad@purolator.com> > >I have seen this problem quite a few times on two of our HP-UX 11 servers >running IDS 7.30.FC7 and was wondering if somebody has also encountered >this. Sometimes, shared memory segments do not get removed at the O/S level >after…
Shared Memory Segments are not removed
I have seen this problem quite a few times on two of our HP-UX 11 servers running IDS 7.30.FC7 and was wondering if somebody has also encountered this. Sometimes, shared memory segments do not get removed at the O/S level after Informix shutdown. ipcs -m shows these segments flag…
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 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…
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 memory creation during oninit process
mcapp <mcappNOmcSPAM@gsite.com.invalid> writes: > I am posting my online.log, onconfig, and sqlhosts files. Hopefully > this will help in determining what's wrong. Thanks again in advance! Didn't see the above tread, but anyway:) Start informix with -v too se where shit happ…
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…
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 …
Re: 2 shared memory segments
From: fitr0912@my-deja.com > >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 …
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 …
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…
Questions about values of memory in onconfig
Diego Morales wrote: > > 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 …
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…
RE: Dynamically allocated new shared memory segment ???!!!
What version of the web datablade are they using? Willow At 08:13 AM 8/19/99 , Thomas Tatum wrote: >Yes, we have seen this with IUS 9.14 and the Webdatablade. Except in our >case it would keep allocating until the server ran out of shared memory. > >In a web datablade page an …
RE: Dynamically allocated new shared memory segment ???!!!
Yes, we have seen this with IUS 9.14 and the Webdatablade. Except in our case it would keep allocating until the server ran out of shared memory. In a web datablade page an MISQL statement tries to select from a table and gets back too many results for the webdatablade to handl…
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…
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.…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
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…
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…
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.…
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…
Posting from the Informix-list
Requested shared memory segment size rounded from 744KB to 752KB Should I try and make the changes for this to not happen? I am on: AIX 4.2.1 IDS 7.30.uc7-1 TIA Chris Burton…
What does this mean?
Requested shared memory segment size rounded from 744KB to 752KB Should I try and make the changes for this to not happen? I am on: AIX 4.2.1 IDS 7.30.uc7-1 TIA Chris Burton…
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…
Recommended value for SHMMAX
Stefanie Vario wrote: > > Can anyone recommend a good value for SHMMAX based on the following: > We're on HPUX 10.2 with Informix 7.30 with 784MB memory. The current > value of SHMMAX on our platform is 67MB. After I bring Informix up, an > ipcs -m shows that there's 3 segments…
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…
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…
large number of shared memory segments
IDS 7.24.UC5, HP9000 running HP-UX 11.0 We had an interesting situation last night where the server un-surprisingly ) appeared to not accept any user requests from either soctcp or shmem connections even though the engine was up and running and was issuing checkpoints. We could…
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…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix error.
Does anyone know what this error is about: shmat: [EINVAL][22]: shared memory base address illegal Thanks, Fred Lee…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Re: Informix 5.05 kernel parameters
Carlos Aviles wrote: > The initialization is failing with the error: > > shmat: [EINVAL][22]: shared memory base address illegal > using 0xC3ABE0, needs 0xC0058000 More often than not, this error means your shared memory kernel parameters are insufficiently configured. Tr…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Segmentation Violation (bad memory pointer)
We are running Online DS 7.22 on SCO Unix 5.04 (release supp c). Has anyone seen the folowing problem before? Thanks, Lutz Wiggershaus 13:45:50 Checkpoint Completed: duration was 0 seconds. 13:50:53 Checkpoint Completed: duration was 0 seconds. 13:55:56 Checkpoint Completed…
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…
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
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: 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 …
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…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: 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: 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…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
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: 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
>: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…
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: 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: 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…
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…
Re: Error in shared memory initialization
mukta mohindra 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 enabled. …
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 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…
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…
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…
Shared memory segments hanging around
Hi Folks. I have a problem I that calls for familiarity with certain quirks. OnLine DSA 7.13.UC5. Main Symptoms: My users used onmonitor to change the number of locks (150000-->200000). Onmonitor gives its usual warnings - are you sure blah blah.. But then all just does nothing…
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: 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 …
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: User Limitation?
In 5.x the number of users was inforced within the software. I'm unaware of any code in 7.1x which is inforcing this. True we removed the number of configured users, but that was because we started dynamically allocating the user table in the virtural shared memory segment, inst…
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: Online Performance Tuning Question ??
I'm curious. When you start the GQL program, does it cause dynamic virtural memory segments to be added? Madison Pruet…
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: Incredible paging on the system
Collalti, Fernando (Fernando.Collalti@orbit.net) wrote: ... > EXTRAC OF online.log (when the problem occurs) with the > BUFFERS set to 2000(before it was 200) > with the new configuration of BUFFERS=5000, CLEANERS=6, LRUS=12) > Wed Nov 6 08:22:44 1996 > 08:22:48 Onconfig pa…
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: Can not create resident segment
tolly brumbelow wrote: >if the online came down for some reason > and did not clean up all the share memory segments (ipcs |grep > informix). > -- > Tolly Brumbelow, Informix DBA > email:tolly.brumbelow@bridge.bellsouth.com If you do see some shared memory segments that informix…
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…
Question about virtual memory segments
Hi, 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? It would seem to me that the app…
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: 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…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
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: ESQL/C dynamic SQL and BLOBS
The parameters to GlobalAlloc are probably GPTR which results in the allocation of a global segment which is fixed in memory. To free this memory all you need to do is cast the global pointer to a handle, example GlobalFree( (HGLOBAL) loc.lc_buffer ); When Informix ported ESQ…
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…