Oninit® Archive
Results for “RA_THRESHOLD”
Large memory segment vs smaller ones
Hi Dennis. Yes: " vmo -p -o v_pinshm=1". You must have RESIDENT 2 or more for large pages as they must be pinned. The "rsam" pool is in the dynamic segment. You need RESIDENT 2 or more. It doesn't sound like the problem is with the buffer pool but the "rsam" pool. Your BTR is fin…
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 ------------------------------…
Buffer wait occurs when performing INSERT in multiple sessions
You have to only peripherally related problems. The issue about not enough KAIO resources is an operating system tuning parameter. You can read the maximum value and set it here: $ cat /proc/sys/fs/aio-max-nr 65536 echo 131072 >/proc/sys/fs/aio-max-nr # set new maximum And see …
Index page size recommendations
16 k for indices is a good starting point. After that is depends on the data. If I am using TS then I would tend to have dedicate spaces as well. And yes you need a buffer pool for each page size. Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trade…
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…
Problem with backup
Original post: Hello, every time we release a copy with onbar , the Database server gets blocked one to three minutes. Is this normal ? Our version is 12.10.FC3WE and the command is onbar -b -w Thank Response: The answer is possibly. At the start of every backup, the server…
Connections over SSL
Clients need to have read permission on the files configured in SSL_KEYSTORE_FILE and SSL_KEYSTORE_STH .…
Creation on read only user.
Hello, 1. I have 2 user in my instance i.e. 'USER1' and 'USER2'. 2. 'USER1' and 'USER2' can Execute SELECT, INSERT, UPDATE, and DELETE statements as they gave got 'CONNECT' database level privilege, that comes with default 'PUBLIC' role. 3. I want to create 'USER3' that should…
Informix 11.70: Stored Procedure SQL exceptions
Alexandre, I should also explain that I set up a WHILE loop to read from a select cursor. Thanks, Bob…
EXTERNAL table read
Hi, How can I read one external table as an usual table, is it possible? Can I do select from one external table created by another program? As I only have seen operations over external table after create...??? Thanks for any help, SP…
Not sure if I have a problem with CKPs
Sorry. My reference to Madison's comment is this thread: http://members.iiug.org/forums/ids/index.cgi/read/31286 DG…
Reading logical logs of informix
Is it possible to find what was being written in database at a certain point of time by reading logical-logs?…
Bufferpool configuration
Hi informix community, on a SPARC M10-1 Server we have a informix 12.10FC10 instance. Currently this instace use a buffer pool with around 7GB. Now i have the chance to configure the buffers up to 40GB. I would like to use the following configuration of the buffer pool: BUFFER…
RAU
Hi, our current onconfig value for RA_THRESHOLD and RA_PAGES are 30 and 32 respectively. Do we need to increase/decrease both values? how can we measure the amount of increase/decrease we need to make? or is it a trial and error thing?…
SQL using the index
If I find one index has high buffer read, How to know which SQL use this index?…
Restore secndary from primary fails
Issue was solved. Primary had a backup filter and secondary couldn't read the backup from STDIO…
Could not position with in a table
Hi Mukesh. You probably have uncommitted changes to that table by another session, which results in exclusive row locks. If your application has the default SET ISOLATION TO COMMITTED READ, it will abort when it tries to read those rows. When you start a new session, execute SQ…
BUFFERPOOL Configuration
Oh, one more reason to use multiple page size buffer pools: - To be able to isolate the IOs against some objects from those of other objects so that, for example, index IO activity does not flush data pages from the cache.…
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…
Dbexport very slow
dbexport supposedly unloads the tables by reading sequential. Update statistics should be irrelevant in this case. What about the amount of data produced by that massive inserts?…
Users from a database Import
I'm missing something to this whole thing. If Public has connect, it has read, write update and delete. I want the user to have only read and write to the entire database. Doesn't every user have public so he has read, write, update and delete?…
dbexport
my command doesn't seem to work. Reading the documentation...…
reading committed data on hdr
We are using informix IDS 12.1 with an HDR in near_sync mode. Some applications read data from hdr. We found that uncommitted data is also read n hdr that some times rollaback and information delivered at that instance does not recoincile. One solution might be keep the hdr in fu…
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.…
Cannot read from sysprocplan
Hi, we are seeing an error through an application when it tries to do a select on the database, but if we go on the server and use dbaccess, the select statement works. Anybody know anything about these errors? 12/08-09:22:26.211 [01] <002:0001:> (01) ==> inf_exec_stmt: (-211,-1…
Informix 12.1 Blocking Checkpoints
> On 7 Nov 2017, at 10:48, NATYURAL HORACIO <horacio.natyural@gmail.com> wrote: > > Hi, > > > Based on the current workload, the physical log might be too small > to accommodate the time it takes to flush the buffer pool during > checkpoint processing. The server might block tran…
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…
Secondary stuck in Fast Recovery
Hi, from reading other posts, it seems like I need to restore secondary so I will give that a go now.…
identify what is allocating memory
original post: Hi , How identify what/who is consuming memory in a specific virtual memory segment ? With onstat -g ses , there is no session with high memory allocated. The amount of users sessions is keeping at regular average... No buffers pool was allocated automatically (I…
SQL have most IO read
HI, How to monitor which SQL has the most IO read operation? thanks for your time.…
Re: RE: Dev server restore fails
Hey Martin, believe me when I say I have read and read and read before I ask my questions. I think I have at least 6 different manuals for informix 11.5 and I'm guessing they have to be 10,000 pages. :)…
Buffer pools in 11.50.FC5
IDS 11.50.FC5 Solaris 10 Sparc I need some guidance on BUFFERPOOL. I am receiving the 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 threads. I am not sure how that translat…
Negative pages read in chunk
I have some system monitoring that captures pages read from each chunk. This is simply "select fname, pagesread from syschktab" For the most active chunk in the instance this statement returns a large negative number (-1,181,472,262). However an onstat -D returns a larger positiv…
updatable SDS
I just found the answer: The only isolation modes that are not supported at the Secondary server are REPEATABLE READ and CURSOR STABILITY.…
Odd Bufferpool Behaviou
Original post: AIX 6.1 IDS 11.70.FC8X8 I have a new machine with a lot of extra memory. Given that, I added a bunch of new buffers (4k, 8k, & 16k) and went to town testing away. Long story short, with all those new buffers, I get virtual segments added at startup. In onstat -g …
Data loading quesiton
the customer will run the read only application on HDR, so reinitilize the HDR is not workable , the read data is about 60TB, ifxclone take about 9 hours.…
External table problem
I'm reading from a file and for the rejectfile of course informix should write…
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)…
dbspaces corrupted
Thanks so much. After fixing the read-only problem on the dbspace how does one bring the chunk back on-line?…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Physical Log Size
IDS 11.70.FC8 AIX 1 6 00CC96664C00 I received the following message in the online.log file ..... is it something to be concerned about ? Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoi…
virtual segment question
I read the online.log, it's dynamic lock allocation lead to the problem…
new bufferpool
original post This concerns ids12.10TC3IE . These are the old lines in my onconfig... #BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 #BUFFERPOOL size=4K,buffers=100000,lrus=8,lru_min_dirty=20.00,lru_max_dirty=30.00 #BUFFERPOOL size=16K,buffers=…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Buffer Size and Use
Folks, We recently had a conversation with a well-respected name in the Informix world, recently, concerning our bufferpool configuration. When exported, our database takes up only about 18 GB. We had a buffer pool of 12 GB, figuring that the more memory resident, the better. Al…
can we have to hdr servers ?
In fact i will use it for backuping the production. Is the rss read. Only. Likr hdr ?…
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.…
onstat -g ckp Question
When we are transferring an index from the primary to the secondary we = have a problem. All the work and maintain a clean buffer pool on the primary= is done all the index is being built. However on the secondary there is no= way to keep the buffer pool clean. If we do not keep …
CREATE FUNCTION() containing ORDER BY clause
Excellent point Fernando! It seemed very obvious as I read your response. Thank you for pointing that out.…
Ifxclone issue
Is it logging anything at all on the primary or secondary? is the primary still available for reads and writes or does it hang?…
Auditing HDR server
good evening, can we audit an hdr server ? which is, by definition, on read only mode :) thanks in advance…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Dirty Read with Coldfusion
Hey, all. We're running ColdFusion 9 against an 11.70.FC7 instance, and it insists on using Committed Read. I set up a sysdbopen() to set it to DIRTY READ, but it doesn't seem to honor that, almost as if CF9 is explicitly executing SET ISOLATION TO COMMITTED READ (or, more like…
Indexes on Null values
For oracle, I have read that nulls are not indexed. How does Informix handle null values on a column that has an index? Thanks…
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,…
Bufferpool max size in Windows Server 2008 64bit
Hi, I restarted engine once more and now it looks right. So, probable user error! Are there other memory parameters that would benefit from very large values? Thanks, Lauri d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70>onstat -X IBM Informix Dynamic Server Version 11.70.FC…
buffer pool and dbimport (11.70FC5)
Hi, I'm facing a problem and i don't understand how is it possible ... I'm loading (dbimport) a big table (> 3 Million records) and my buffer pool becomes quickly full (700000 buffers with LRU min = 0.50 and max 1.00). Checkpoint is not trigger until CKPINTVL (180) and you can im…
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…
Disabling LRU flush
Hi, IFX 11.70 FC 5 Innovator-C , Linux 64bits OpenSuse. I'm working with database load. Basically I'm using HPL, unfortunately some tables have huge rowsize0 (1 row size = 2 pages) and lvarchar datatype which force use deluxe mode. Consequently use buffer pool , and then LRU fl…
btr
How can the BTR be 334 while the %cached for reads is 91% to 95% ? (This is ids11.70.TC3IE )…
BTR on each buffer pool?
This concerns IBM Informix Dynamic Server Version 11.70.TC5IE . I have a 16k page size space where I put a temp space and all primary and foreign key indexes. Since I can select nbuffs, bufwaits, bufwrites, pagreads from sysmaster:sysbufpool I can get the BTR on each pool. Should…
Re: help with informix on windows oncheck -pr erro
thanks for link Fernando I will do some reading…
Correct method of sizing resident pool...
Hi all, I have a script that reads an onconfig file and outputs an estimated memory footprint of the instance. However, I am finding it hard to accurately predict the resident section size. According to http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com…
Informix Auditing
Hello, I want to know the difference between following two audit Mnemonic. ACTB Access Table RDRW READ ROW Thanks in advance.…
What are best onconfig parameters for a DSS app
Someone posted this answer in http://stackoverflow.com/questions/10477914/which-of-the-ids-11-70-onconfig-para meters-can-be-changed-to-maximize-performanc and your reply contradicts some of the following: "..But in essence, DS_MAX_QUERIES is the maxumum number of parallel que…
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…
hello
wow give this a look http://www.panews15.net/biz/?read=6647671…
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 …
ZFS and Informix
I'm well aware that the buffer pool has nothing to do with the underlying file system. We're just trying to figure out what scales better. We know that ZFS's ARC scales very well (the algorithms come from IBM !!). I trust though the people that have been out in the trenches worki…
lock problem
check your isolation level as well. are you in repeatable read? thanks…
Informix Status Explanations
hi, can anyone shed light on this for me. what does this mean? status yield bufwait- does it mean i'm lacking buffer pools? what does this indicate? cond wait netnorm - session is not doing anything. running- does it mean the sql is currently running. yield lockwaits - does th…
Informix Locks On Select count(*)
Also, Will setting isolation to dirty read help with this? Thanks…
Drop Index
When you say "attached" I get a bit confused... By default, 11.50 does not create attached indexes. Was it created in a previous version (prior to 9.40 I believe)? Or do you have the variable DEFAULT_ATTACH set in the environment? Depending on the table size, other indexes, main…
Informix process reads a lot of pages
Hello, I have a problem with Informix 7.31.UD8 on Linux. One of the Informix process reads a lot of pages. Can I see what does do this process? Why this process reads pages, when nobody use IDS?…
ONBAR restore error
I'm trying to restore a ONBAR backup It was a full system backup using ONBAR -b -w to disk When I try and restore it using ONBAR -r -w I get the error below in ism_watch what is the error and how can I fix it thanks Up since: Thu Oct 13 12:19:10 2011 Version: Informix_Stora…
4GL Read file
Hi, I want to use the new OPEN FILE, READ FILE, CLOSE FILE in Informix 4GL. Could anyone direct me to detailed documentation on it? I can't find any description on how to detect EOF in the READ statement as the READ statement does not seem to return a flag. Any help will be appr…
reading: Bad file descriptor
I'm trying to restore an onbar backup that is done to disk does the error reading: Bad file descriptor in ism_watch refer to a corrupt onbar file or something else ?…
Increase buffer pool size
Dear All, i found the following line in the message log of an IDS 10.00 on a Linux Box having 3GB memory: WARNING: Buffer pool size is too small for read ahead operation I would like to increase this parameter, as obviously it has the default size of 5000 buffers with a 2k page…
Informix question
Original Post: Hi, I have two confused question. 1 When a update SQL will update totally 3 pages in bufferpool? How many mutex IDS will allocate for this thread in the buffer-head entry in the buffer table? 2. What the temporary sbspace will be used for? thanks for your time.…
Re: Upgrade to 11.70 from 11.50 results in low Read Ahead Utilization
Hi, In 11.70.xC3, the new AUTO_READAHEAD ONCONFIG parameter was introduced. This parameter reflects a new read-ahead algorithm in the database server. Basically, in mode 1 setting, auto read-ahead will turn off read-aheads for a scan if it detects that the pages are already ca…
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…
Upgrade to 11.70 from 11.50 results in low Read Ahead Utilization
I recently upgraded from 11.50.FC3 to 11.70.FC3. As expected, the upgrade was painless and there are no apparent issues as a result of the upgrade. One thing that I do notice is my Read Ahead Utilization (RA-pgsused / (ixda-RA + idx-RA + da-RA)) is in the toilet after the upgra…
Informix ... and marketing.
Informix ... and marketing. Please read this important post! : http://t.co/k0QfC0s #Informix…
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.…
must read.!!
way cool am baffled!!!!!! http://www.informix-zone.com/redbook-draft-version-ibm-informix-flexible-grid Thanks!!! Superboer.…
ER error
If I am reading it right cdr finderr 1 1 A connection does not yet exist for the given server. Is replication actually working ?…
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…
informix dropping idle connections
Thansk for info Art John cant read your post…
PDQ and Growth Edition
On 12 Aug, 20:21, LIGHT SCANS <light_sc...@yahoo.com> wrote: > Hello Neil, > > Try putting your TEMPDBS in ramdrive. That should speed up the > sorting required to create an index. Also, make sure your swapping is > zero. > > Just for grins, I would try everything: Define tabl…
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…
Tremendous number of reads
Hi guys, any ideas how to investigate or determine the casue for the following ? Platform Solaris 9 on sparc, Informix 9.4FC5 New application causes a very high cpu-load, and we see about 2BILLION reads on a specific index in 1 day (more then 4 million in a minute) for 2 other…
data access control
Folks, IDS11.10 UC2 AIX5.3 We granted READ permission on most of our tables to Public. So all valid users have the default read privileges. We are going to have an exception : An newly added user will be prevented from reading some tables that are granted to Public already. W…
An interesting read...
http://radar.oreilly.com/2010/03/joe-stump-talks-location-and-n.html What makes it more interesting is that some of the readers relate the inability of MySQL not being able to scale as something all databases are unable to scale. XPS anyone? Sorry for those who don't think out…
Cannot read systemcatalog
Hi guys, During execution of "update statistics" scripts, which are build based on the performance guide and the recommendations of John Miller we have following issue on Solaris with IDS 9.4UC7. Database is in buffered logging mode. In the scripts , for every 100 statements we…
RE: Long Checkpoints with HDR and 11.5.
Art Kagel wrote: No, Jacques, IDS secondaries do not share buffer pool updates with the primary. Only the logical log buffers are transferred, so only the server's transaction rate would affect the data transfer rate between the servers and that would be about the same regardles…
Is there a gateway issue?
I'm reading on c.d.i UseNet. It seems that there are replies that are referenced that I don't see. Is there an issue with the gateway? JWC…
Network Buffer Pools
IDS 11.50.FC5 AIX 5.3 For HDR replication between two AIX 5.3 servers, is there a suggested value for the following environment parameters: 1. IFX_NETBUF_PVTPOOL_SIZE 2. IFX_NETBUF_SIZE 3. Sqlhosts option b (client buffer size) The primary has 64GB of memory while the second…
Congratulations to Warren Donovan as the Fastest D
Warren, If your out there "Congratulations" I just read you are the fastest DBA. -- Eric B. Rowell --000e0cd70dbe5a2de90477181a6b…
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…
onbar backup exited 151
Thanks Martin, You are right... Secondary Server can't be backup... Upon reading most all informix forums and your confirmation. Regards.…
Create index errors
Sorry - bad bit of reading on my part! Could it be number of extents/extent size for the index?…
Re: SSD --- The reliability of
Question how many times do you read write to a hard drive in a year? Question how many times do you think you will read write to a ssd in a year? Then go and buy a usb stick and read write to it then come back and tell us how long it took you break it. And how many read write op…
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…
physical log might be too small
Hello, We are getting following error while checking checkpoints "Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoint processing. The server might block transactions during checkpoints. I…
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…
Buffer Pool
What are your Readahead parameters (RA_PAGES, RA_THRESHOLD) set to in the ONCONFIG file? Art On Tue, Feb 10, 2009 at 12:25 PM, ANTONIO VARRICCHIO < antonio.varricchio@domtar.com> wrote: > Hi, > > We are running informix 9.4 FC5xs with SAP. Our SAP admin recently advised > that…
RE: How to do Light Scans . . .
Rather than write it all over again. http://www.ibm.com/developerworks/db2/library/techarticle/dm-0205parker/ Although scanning that briefly I see that it does not mention that Light Scans will not work against a table with varchars. j. On Mon, Jan 5, 2009 at 11:10 AM, LIGHT S…
How to do Light Scans . . .
Over-simplified definition: LIGHT SCANS occur when you sequentially scan data without using the BUFFERS. This can be about 1 to 3 times faster than regular scans! It does not like locking, filtering or varchar but it will tolerate some of it. IBM tells me (and I'm paraphrasing…
dirty read isolation in views
Is it possible to create views with dirty read default isolation -or- run views in dirty read isolation? IDS 9.4UC8 Redhat Enterprise Linux 3 AS DISCLAIMER This transmission and the information contained herein and/or in any attachments hereto and/or in any attachments theret…
Fatal error
Dear Friends, When i am try to onlining the informix i got this messages informix@DBSERVER> oninit -v -y Checking group membership to determine server run modesucceeded Reading configuration file '/export/home/informix/IDS0/etc/onconfig.voms'...succeeded Creating /INFORMIXTMP/.…
Change the informix database to read only
Dear All, I want to put one of my informix database to read only mode. Can anybody provide the solution to change the database to read only mode. Thanks, Gulshan…
Re: Best Use of Free Memory
David, I see the confusion now. The English phrase, "Needs to acquire a buffer," is too vague. There are really two major cases, but the manual is only addressing one (the rarer one). The cases are: 1. The required data is already in the buffer pool. In this case the thread nee…
Best Use of Free Memory
BUFFERS is generally a good place place to use extra memory, subject to a couple caveats: 1. If the working set already fits in the current buffer pool, adding still more buffers will not produce any noticeable performance increase. Check "onstat -g buf" output for your %cached.…
v11.50.fc2 excessive kernel reads
I just installed v11.50.fc2 on an Aix 5.3 system. Only changes to the config file was that I changed the sqltrace to be global and not user ... and I added SCANNER num=2,treashold=500000,rangesize=100,alice=6 previous that was not set ... Since the upgrade the kernel reads on …
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…
If there were no onstat...
Noonan! I hate when I screw up a contraction... Think the title was also bumbled... should read If there was no onstat. MM…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Parameter tuning?
Great Mr Kagel! i guess now working with IDS 11.* we get performance advisory in online.log but ur calculations and adivisory are of great help. Pls could you give us the formule for calculating Bufwaits Ratio (BR) Buffer Turnover Rate (BTR) Readahead Utilization (RAU) especi…
Anyone else read CRN ?
CRN - Computer Reseller News , a CMP publication... April 28th issue. IBM insert in the plastic wrap. Its a SWG advert. Interesting notes: 1) Information Management pillar had 5 products listed. The most of any brand ... 2) Note to Jerry K. Does it make sense to sell IDS as …
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…
Informix Helps Clean up London
Please read this case study for details. http://www.informixcity.com/downloads/LB_Camden.pdf…
Informix strong in the UK
Please read the following case study demonstrating Informix is still active in the UK. http://www.informixcity.com/downloads/Exel%20Case%20Study.pdf…
Extent DB
I will read a bit more. The key answer came from Marcus. After reading a lot I thought: Disk->DbSpace->Chunk but now I think Disk->chunk->DbSpace Thanks for helping Freudi…
Migrating data between Informix Platforms without
I've had similar issues with Brio reports. One possible fix is to force the report generation to use PDQ. In this way, the BUFFERS are not flushed and you get to use lightscan buffers. I've been able to up the RA_THRESHOLD/RA_PAGES significantly with no ill effects to OLTP and im…
HDR Secondary mode Log transfer handling
How the Informix handle the locking between the read only access and updates from Primary Database to Backup database?…
Error reading buffer on onunload
Hi i'm running informix 7.31 on a Compaq Proliant 3000. If I perform an onunload of small database, for example 130 Mb, it will finished without errors, but if I perform an onunload bigger than (15 Gb) . It returns the following error : " Error reading buffer ". The tape device…
Re: 9.40FC9 BUFFERS limit
On Jul 25, 4:41 pm, <eshkambx-i...@yahoo.com> wrote: > Hi > > Does anyone know what is real maximum number (not from release notes) of BUFFERS parameter for IDS > 9.40FC9 for Solaris 10? Exact Solaris version is: Solaris 10 11/06 s10s_u3wos_10 SPARC. > > Situation: > > We have ne…
description of onstat -g ntt
Hi Karl, From IBM Performance Guide v9.4, we can find this explanation on the q-exceed field: << output output field Description -------------------------------------------------------------------------------- -------------- onstat -g ntm q-exceeds Number of times the free buff…
Re: Strange behaviour of the buffer pool
On Jul 17, 8:57 am, RoB <pluma...@gmail.com> wrote: > >My post to the news group is taking forever. In any case, I looked > >around a bit and it seems like the easiest way to get your resident > >section to become larger, other then BUFFERS in the $ONCONFIG, is the > >LOCKS para…
Re: Strange behaviour of the buffer pool
On 17 Jul, 12:10, RoB <pluma...@gmail.com> wrote: > Hi all, > > IDS: 9.40.FC3W2 > OS: HP-UX 11.11 > > What am I missing here? An instance is unexplainably allocating 224 MB > of buffer pool in addition to the amount configured. > > The BUFFERS onconfig parameter is set to 6250 (=…
Re: Strange behaviour of the buffer pool
Looking at a larger instance on the same versions I can see the "resident" pool being 354MB while the "res-buff" being the same the BUFFERS setting: onstat -g mem|grep " R " res-buff R c00000001669d040 1280004096 2848 2 2 resident R c000000000491040 …
Strange behaviour of the buffer pool
Hi all, IDS: 9.40.FC3W2 OS: HP-UX 11.11 What am I missing here? An instance is unexplainably allocating 224 MB of buffer pool in addition to the amount configured. The BUFFERS onconfig parameter is set to 6250 (= 12.2MB): onstat -c|egrep "BUFF|SHM" BUFFERS …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: Slow database creation and loading
On Jun 18, 10:50 pm, "Jack Parker" <jack.park...@verizon.net> wrote: > If you are using HPL, that grabs it's own memory. Data does not go through > the normal buffer pool (unless you are using deluxe mode). You might not > want to increase buffers. I need to double check but I…
RE: Some interesting reading
I was trying to find the origins of Informix & Oracle. Someone told me that Roger Sippl & Larry worked for the same company, had different ideas, resigned, and started their own databases. But I don't know if this is true, or just a story. While searching for more inf…
RE: Some interesting reading
You forgot http://en.wikipedia.org/wiki/IIUG -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Dirk Moolman Sent: Thursday, June 07, 2007 16:29 To: informix-list@iiug.org Subject: Some interesting reading http:/…
Some interesting reading
http://www.storyofinformix.com/ http://en.wikipedia.org/wiki/Informix http://en.wikipedia.org/wiki/Larry_Ellison Dirk Moolman Database and Unix Administrator Agility Technologies (HealthCorp) "People demand freedom of speech as a compensation for the freedom of thought whic…
Re: Is IBM actually doing something with IDS?
> Otherwise they would > not have introduced Oracle like features , like > read consistency (read don't block writes > and vice-versa). And since it is Informix I > can bet it will do a better job than Oracle > at read consistency without locking. > Also RAC like shared disk fea…
look like something reputable
anyone in IT knows whats happened re: isoft CSC NHS IT corporate raiders corporate scum (read posts to comp.databases.pick informix people)…
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.…
Must Read!!!
Excellent material is available for test drivers on code providing enormous in depth information of the suggested test programs. Don't miss it! http://www.it-techexperts.com/Tutorials/KometTest.asp…
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…
Must Read!!!
New material has been added for the Silktest and WinRunner feature descriptions focusing on the day to day functionality provided by both the tools used for software testing. http://www.it-techexperts.com/Tools/SWFD.asp…
Connecting to IDS 9.4 from Linux x86_64
[authlive] should read [mydb]…
Re: index build performance
Very cool. Thanks Art. And thanks Clown. ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Home: 703-430-0805 Cell: 703-477-6045 ======================== http://www.one.org/ -…
Re: index build performance
Thanks. Yes the table has 6 fragments. I have 7 cpu's on the box. So I assume, based on your recommendation to set PSORT_NPROCS to 7 and have 7 temp dbspaces and set PSORT_DBTEMP to those. btw, we have nothing else running at the time, so I was planning on using pdqpriority 100 b…
Re: index build performance
Floyd Wellershaus said: > Back on that 1.1 billion row table again. > Thanks to help from sources here, I was able to get the named pipes > working to half the time for a load and unload for the table. > Now I'm concerned with building the indexes. > >>From sources here also, I a…
index build performance
Floyd Wellershaus wrote: > Back on that 1.1 billion row table again. > Thanks to help from sources here, I was able to get the named pipes > working to half the time for a load and unload for the table. > Now I'm concerned with building the indexes. > > From sources here also, I…
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…
A Must Read !!!!!
I have not been able to find a proper tutorial for WinRunner & LoadRunner at a single place. This has been a good effort to share WinRunner knowledge and I am sure that this Blog would grow into an excellent resource over the time. http://test-techtools.blogspot.com…
How do I read a file with Informix 4GL?
What is the best way to read a flat file using Informix 4GL? Thanks…
dirty reada to committed read
Hi, Refer the follwing link. http://www.iiug.org/waiug/archive/iugnew84.html Regards, Premnath Srinivasan "eferreyra" <eferreyra@gmail. com> To Sent by: …
dirty reada to committed read
Hi, i start a program that uses ODBC for connect to an informix (7) IDS, i start the connection with isolation level of dirty read, but in some point checking the SMI tables i see connection have isolation level of committed read. I dont change the level via set isolation level …
an XBSA reference implementation?
Hello, Does there exist an XBSA reference implementation? I would like to read the source. Thank you, Vasili I. Galchin…
an XBSA reference implementation?
Hello, Does there exist an XBSA reference implementation? I would like to read the source. Thank you, Vasili I. Galchin…
error initializing
Hi: when initializing my INFORMIX leaves the following message to me error: $ oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file '/usr/informix/etc/onconfig.nazca'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Creat…
Total length of columns in constraint is too long
Hi, We recently migrated our application from MySQL to IDS. While the migration (post DDL and few other code changes) worked just fine in a dev. environment on windows, while executing DDL scripts on Linux, IDS throws this error. Basically I have a unique constraint on 3 columns…
Re: Pls help to tune my informix engine .. thanks
Henry wrote: > Hi gurus: > > I am using IBM Informix Dynamic Server Version 9.40.FC7 under a 6 CPUs > HP-UX server. > There are 57 dbspaces with a total of 85 chunks. > The informix engine is running very slow recently. > I was not sure whether it is the result of poor tuning or …
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…
Here you can read books free and buy all tickets
Here you can read books free and buy all tickets you can find all tickets here: http://allticket.yourfreewebspace.com/ you can read books free: http://onlinebook.yourfreewebspace.com/ http://bookonline.yourfreewebspace.com/…
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…
Cached reads going to 0.00%
I've noticed this a couple of times in onstat, for no apparent reason cached reads go from 95% or so to 0.00% and then slowly build back up to 95% over the next 24hours or so. There's a cronjob that runs at 8, noon, 5 and midnight that records a few interesting statistics on the …
KAIO READ ERROR
Hi All, Through the working day I can constantly see error messages containing the information: KAIO: error in kaio_READ, kaiocbp = 8ac9e608, errno = 14 11:30:44 fildes = 8 (gfd 6), buf = 8be2e400, nbytes = 61440, offset = 37412864 Sometimes IDS goes down if the system is doin…
Database read only
Hi, I need to put my database in read-only mode to previne access while we migrate the data to the other database. I'm using Informix 7.31.UD6 on HP-UX. I would like to know to proceed in this case? Thanks. Rodrigo…
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 …
Changing database to read-only
Hello, I am trying to find out the procedure for preventing updates on an Informix database by changing it to read-only. Is there a stored procedure to do this? What would anyone recommend? Version 9.21UC4 HPUX 11.11 Thanks in advance, Howard…
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?…
How do it get writes form the lrus in V10
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Bill > Marshall > Sent: Wednesday, May 03, 2006 7:21 AM > To: ids@iiug.org > Subject: How do it get writes form the lrus in V10 [6648] > > > I have a new HP Intel 32 bit chip mach…
Onar failure
My Apologies for poor spell checking. The Title should read OnBar Failure.…
Dirty Read Default
I thought I heard a while back about an environment variable setting to change the default isolation level to DR. Does anyone know about this, or maybe I was just dreaming. The users of our data warehouse have been running selects against tables with the default of Committed Re…
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/…
Re: Stored Procedures Limitation
oopps it should read pre 7.3 ..…
initialization rhead struct failing
Superboer wrote: > dono what your problem exactly is... if it's read ahead, and something > fails > to start.. (the database...) you may want to consider setting > RA_PAGES 0 > RA_THRESHOLD 0 > in your $ONCONFIG file > > since the default is 4 and 2 if i recall correctl…
column level encryption
hello all, i am correct in reading that column level encryption is available in IDS version 10 but not 9.3/9.4? thanks tom…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: Splitting rows without temp tables
"I'm interested in this concept of read-only access not allowing temporary tables. You can even build temporary tables on an HDR secondary, the ultimate read-only database." Just testing.... ;-p…
Check INFORMIXDIR and DBLANG.FAILED
Hill, what could have caused it ? angel:/opt/informixids/msg/en_us/0333}oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informixids/etc/onconfig.angel'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating …
Re: Shocked! Shocked, I tell you!
Don't ask...it's why I'm so annoyed. They read this here.... Hmmmmpffff....…
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.…
Read Block Size on Disk
Hi all, what block size is used when informix is reading from disks ? Is there a difference between the block size on solaris and linux ? thanks gerd ______________________________________________________________ Verschicken Sie romantische, coole und witzige Bilder per SMS! J…
Re: what elkie holland said about me on usenet july 23rd 2001
Never heard of him till I read your post, Thank you for a most entertaining afternoon...…
oninit: Dictionary Cache and SPL Routine Cache error
I am having some trouble initializing shared memory on Solaris 9 with Informix IDS 9.4. --------------- $ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/dbms/informix/etc/onconfig.site'...succeeded Creating /INFORMIXTMP/…
Re: IDS 10 erratic run times
oops should have read Neil's post more carefully!…
Reading DBF from Informix
hello, can anyone tell me if exists any patch or something else for Informix that help me to read/write DBF files from Informix without using ODBC?…
Why Informix is Best
Not horseshit it was on the Slides at the may IBM Infobahn at Bedfont Lakes in the UK. I was at the front where even I could read it...…
ISM ism_catalog question
I was able to retrieve the information I needed using the mminfo command. Thanks to anyone who took the time to read this post.…
Onstat -P output
We need more information as requested by Jay Konigsberg otherwise we're guessing a bit. Leona Ankrah wrote: > Informix Dynamic Server 2000 Version 9.21.UC6 -- On-Line (Prim) -- Up 09:07:09 -- 3063808 Kbytes Do you still have support for version 9.21.UC6? You should conside…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: Re: oninit error .. [5496]
$ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informix/etc/onconfig.padbv2'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating infos file "/opt/informix/etc/.infos.padbv2" ... "/opt/informix/etc/.co …
Reading environment variables
People, Is there a way to read the environment variables from within dbaccess? for example select '$INFORMIXDIR' from systables where tabid =1' Thanks in advance Kenneth…
Informix Logocal Logs
Hi All Is there any tool available to read from the Informix log files ? or can we write a C program to read from the logical logs ?. Thanks Deena --------------------------------- Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football…
Installation problem
I am attempting to upgrade an Informix installation from 7.3x on Sun 5.7 to 9.4 on Sun 5.9. When I run oninit -ivy I get the following: Creating buffer pool 200002 kbytes...succeeded Initializing rhead structure...succeeded init_alarm failed fyi: I installed a new version of IS…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Reading co…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Readin…
Re: script for SQL Capture
michael i get an error reading header on this file after download tom…
How to determine optimum buffer size?
Hello, how do I (or how do you) determine the optimum buffer size (on IDS 9.40, but I think it's a generic question) ? I have a machine with almost 'unlimited' memory (96 GB RAM). Therefore I could define a large number of buffer pages. But I'm not sure if at some point the adm…
What counts sysbufhdr.reusecnt ?
Hi, I found the table sysbufhdr in the sysmaster database apparently containing information about the database buffer pages. One column has the name 'reusecnt' - does anybody know what exactly that column counts? Most entries have reusecnt=0 and I have one system (with a very la…
Re: RESIDENT and BUFFERPOOL
David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? I'm no sure whether you understa…
Re: RESIDENT and BUFFERPOOL
David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? I'm no sure whether you understa…
Re: Expert advice needed on Buffer management
jpierrot@chubb.com wrote: > Hi gang, His per-session buffer pool requirement calculation is completely bogus since most sessions will be sharing the use of the same pages of data and which pages are shared and which are uniquely used by a single session will differ from server t…
Expert advice needed on Buffer management
Hi gang, I received this below from the architecture Dept. trying to simulate Production like performance in QC and development envs. Assuming performance testing would be equal in all those environments if buffers are adjusted to a certain value. Please advise! My question to yo…
Expert advice needed on Buffer management
Hi gang, I received this below from the architecture Dept. trying to simulate Production like performance in QC and development envs. Assuming performance testing would be equal in all those environments if buffers are adjusted to a certain value. Please advise! My question to yo…
Re: Informix Performance Issues
TBP said: > Try something silly at least once :D > > RA_PAGES 1024 > RA_THRESHOLD 64 > > would be cranking it high. > > For a "mix" try > > RA_PAGES 128 > RA_THRESHOLD 16 Hmmm ... I am so going to remember *this* post... :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien…
Re: Informix Performance Issues
TBP said: > Try something silly at least once :D > > RA_PAGES 1024 > RA_THRESHOLD 64 > > would be cranking it high. > > For a "mix" try > > RA_PAGES 128 > RA_THRESHOLD 16 Hmmm ... I am so going to remember *this* post... :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien…
Re: Informix Performance Issues
Obnoxio The Chav wrote: > Anirudh Chitnis via DBMonster.com said: > >>dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached >> >>1525587639 2242129221 16409885204 90.70 13386474 31272626 96935964 86.19 > > > Well, there's your problem right there -- 90.7% read c…
Re: Informix Performance Issues
Obnoxio The Chav wrote: > Anirudh Chitnis via DBMonster.com said: > >>dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached >> >>1525587639 2242129221 16409885204 90.70 13386474 31272626 96935964 86.19 > > > Well, there's your problem right there -- 90.7% read c…
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: Informix locking & transactions
Lock Mode is Row Isolation Level is Committed Read.…
cannot read system catalog
--0-1004379464-1102954650=:32339 Content-Type: text/plain; charset=us-ascii Content-Id: Content-Disposition: inline Hi, Using IDS 9.21 UC4. Solaris 8.0 we have this problem with users trying to connect to the database running. it gives the error 'cannot read system catalog (sys…
clarification of parallel query on informix and oracle
this is some time ago; if i recall correctly: there is an env var called export LIGHT_SCANS=FORCE and there are restrictions on it; check the manual for it; it may also be dependant on your isolation level; if dirty read then light_scans ?? monitor it using onstat -g lsc th…
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'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
problems of Inztallation's
Hi: I have problems with thle installation of IDS. Plataform: HP-UX 11.11 IDS: 7.31 FD8 I cannot initialize !!! If I want to iniciarlize via onmonitor .... the error is: shared memory not initialized for INFORMIXSERVER 'crazy_tcp If i want to inicialize vi command ..... the err…
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: DB Tuning...
On Fri, 30 Jul 2004 06:20:11 -0400, Ben Thompson wrote: > Art S. Kagel wrote: > >> Tuning is pretty good. Here are your metrics: >> >> BR = (24306 / (32278143 + 622031)) * 100.00 = .0700 ! Excellent BTR = >> (((32278143 + 622031) / 100000) / 61.817) = 5.3221 ! On target …
DB Tuning...
On Thu, 29 Jul 2004 13:23:38 -0400, Anthony Presley wrote: > With the light of query tuning, lately, I've decided to submit my server's > config for some review ... to see if someone would be willing to help me > tune it a bit. Tuning is pretty good. Here are your metrics: BR…
Intitialization problem
Hi, I have a problem with IDS 7.31 on SCO 5.0.5 When trying to initialize IDS and it hangs. Here is the oninit -v command: # oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/usr/informix/etc/onconfig'...succeeded Creating …
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…
Problems with locks and committed read
Hi ! well, once again... another question on locks, and isolation level. This time it's rather "critical" for me. I've got 2 processes. One of them => insert data in some tables. The second => try to select row in it. (in fat , it select in it) the two transactions are initi…
Dirty Read dbschema?
Hello All, I have a question regarding dbschema. I have a script that copies data on a nightly basis to a reporting database. I wrote the script to capture the schema each night so that any schema changes are automatically incorporated. Occasionally, I cannot capture the schema …
Informix IDS problem
Hi All, When I try to start the IDS 9.40 on HP PA-RISC machine, I get the following error. If I reinstall the IDS it works properly. If I shut down & restart the database it fails with the below message.. Checking group membership to determine server run modesucceeded Reading …
RE: Clearing Buffer Pool
Informix (unlike MS SQL) keeps all pages in the buffer pool 'forever' - until page becames replaced by another page... ------------------------------------------ Alexey Sonkin > From: Dave Griffen [mailto:dgriffen@nospam.finishline.com] > > I do mean to remove all non essential…
RE: Clearing Buffer Pool
To clear the buffer pool from dirty pages, generate a chackpoint with 'onmode -c' If You mean to remove all pages from it, then it's impossible. ------------------------------------------ Alexey Sonkin > -----Original Message----- > > Does anyone know if there is a way to clea…
Clearing Buffer Pool
Does anyone know if there is a way to clear the buffer pool without bouncing the engine?…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Re: Performance advice
sumGirl wrote: > NETTYPE soctcp,2,150,CPU > NETTYPE ipcshm,2,150,NET CPU processes don't do soctcp very well, and NET processes don't do ipcshm very well. swap this to NETTYPE soctcp,2,150,NET NETTYPE ipcshm,2,150,CPU > RESIDENT 0 …
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Performance is getting worst after turn on the LRUAGE
On Sun, 28 Mar 2004 22:40:01 -0500, miyaki wrote: Other is usually 'unused pages'. Look at the top of the onstat -P report. On the line for address zero (0), is the value under Other very large? Those are unused buffer pages, ie no data pages have been loaded into them. There…
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,…
Help parameters RA_PAGES,RA_THRESHOLD
I have doubts with respect to these parametros, as I should calculate that so that the readings in secueciales in temporary it is mas fast. # Read Ahead Variables #RA_PAGES 4 # Number of pages to attempt to read ahead RA_PAGES 4000 # Number of pages to attempt to read ahead #RA_…
Re: Buffers and LRU.
Madison, the standard interpretation of LRU is Least Recently Used. The standard usage of such a queue is as follows: Each queue has an MRU (Most Recently Used) end and an LRU end. When a buffer is touched (either read or written) it is moved to the MRU end of the queue. When a…
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…
Read only connection
Hi. I have installed IBM Informix Connect 3.82 32 BIT driver for connecting to a Informix Dynamic Server 9 for Linux. I have configured the driver and works fine but I don't know if I can restrict read access. Is there any option for configure the driver in a read only connectio…
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…
Buffers and LRU.
The buffer pool is the page cache of the engine. The LRUs are simply a means of chaining the buffers together. There are two chains per LRU - the free and the dirty. (Actually a free buffer has a page in it, but it is not dirty.) There are multiple LRUs so that if a thread tri…
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…
Threads waiting on buffers (TWOB)
Well, Once again, our company is faced with the "threads waiting on buffers" (TWOB) issue. At a certain point, a ton of threads suddenly start waiting on a specific buffer (they show 'B' in the first flag of onstat -u). Onstat -X shows that they're almost all waiting on the same…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
RE: Large delete
Thank your for your effort, but we don't use any stored procedures, since application is written in some strange tool called Systemator, which doesn't know anything about stored procedures (and many other things as well for that matter). Anyway, we have finished the job this wee…
Re: memory sort and disk sort
On Fri, 24 Oct 2003 02:03:10 -0400, dusong wrote: In a vacuum these ONCONFIG values look OK, but we need to see the onstat output to make a diagnosis. Certainly you have lots of cache and an RA of 16 does not look outrageous (is that the RA_PAGES or RA_THRESHOLD and what's the …
Read sqexplain.out on client machine
Hi, Server IDS 9.30UC2 on linux. Client Apache/PHP/CSDK 2.81 on another linux box. I want to show the query cost and access plan in a web page, How can I retrieve it? I know that in page 10-13 of the IDS Performance Guide it says : <quote> When the current database is on anot…
Question on split reads...
Quoting from page 17-10 of the IBM Informix Dynamic Server Administrator's Guide (IDS 9.4 on Solaris 8) -- "A data page is read from either the primary chunk or the mirrored chunk, depending on which half of the chunk includes the address of the data page.". If the disks containi…
Re: lock table overflow
The customer's server has 1GB of ram. Unfortuately, it also is the web server, so IIS is running on it. I upped the buffers to 400 and the locks to 40000. The service reported: 08:47:27 Onconfig parameter RA_PAGES modified from 4 to 8. 08:47:27 Onconfig parameter RA_THRESHOLD …
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…
Re: Spin locks bringing system to a crawl
On Mon, 21 Jul 2003 10:01:28 -0400, Jay wrote: You're getting some moderate LRU contention (BR ~7% & some LRU mutex spins >15), try increasing LRUS and CLEANERS to 48. RA_THRESHOLD is too high even for JBOD disk farm, try dropping that to 8 or 12 from 30. See if that helps. A…
Commit-read question
I am experiencing a quirk of some sorts. I am running the query below with a wait 30 against a table that has an application stepping thru recordid #'s checking for the next record that has a status of "not processed". Once the application does other modifications to other tables…
Is dirty read enough ?
This is a multi-part message in MIME format. ------=_NextPart_000_007B_01C339B8.442F6BB0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, everyone , Here I encounter a problem, in our system some tables were accessed by many clients at the s…
Re: Is dirty read enough ?
> THIS IS A MESSAGE IN 'MIME' FORMAT. Your mail reader does not support MIME. > Some parts of this will be readable as plain text. > To see the rest, you will need to upgrade your mail reader. --PART.BOUNDARY.2960.4671.p057.1056372883.3930 Content-Type: text/plain Content-Trans…
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…
Re.Dirty reads
Hi Everybody, What would be the impact on database and its integrity if the application has used DIRTY READ during INSERT. Thanks in advance. Sushil... _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://cl…
IDS starting read only
----LNX_Thu_Mar_06_2003_10:17:52_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, = is it possible to start IDS 7.31.xDx (and IDS 9.30.xCx) 'read-only' , e.= g. starting with all checks for chunks / physical and logical logs…
regarding concept of physical logging??
hello, i have a serious confusion regarding tha concept of physical logging, this might sound silly for an expert kindly bear with me and explain.. according to what the book says.. physical logbuffer contains the before images of the data that taken from disk for modification..…
RE: what is light scan and look aside??
All of these 'advanced' questions. Are you retreading from some other vendor? You should consider a course. Light Scan: Normally when you read a table, you go through the buffer pool. That is your row is retrieved from disk, stuck into a buffer, an LRU entry is made to track…
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…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: Number of Light Scan Buffers
Mike Davies wrote: > > I believe the number of Light Scan buffers is dependent upon RA_PAGES and > RA_THRESHOLD but I am not sure of the exact formula. Does anyone know what > this is? Furthermore, are the formulae the same for IDS 7.3 and XPS 8.3? I don't know about XPS, but in…
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 …
Read in ACE
I have SE 7.20.UE2. I have an ACE report project where I have to do a SELECT with 55 compares in the WHERE clause. So I thought maybe I could put the 55 items in an ASCII file, READ them into an ACE report program that would put them in a temporary file. After all, there has go…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Read only
Hi Can anyone tell me whether it is possible to make a Data source for the informix 3.32 32 bit ODBC driver read-only. Thanks Greg…
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…
Dirty Read
I have created a stored procedure in SQL7.0 which retrieves data from a linked server. The linked server is an Informix database - I want to set the query so it reads an uncommitted/locked records. I have set SQL7.0 to read uncommitted record which seems to be working, but how …
read dirty
I am developing an application in VB6.0 using ADO2.1. I want to Set Isolation dirty read, How can I do that through ADO? Thanks Peter pczurak@bigfoot.com…
Re: Load Performance problems
Hi ! QSTAT ? what does it do ? I didn't find it on my onconfig V7.30 and TBLSPACE_STATS 1 What is it for ? tablespace statistics ? where do they go ? so, better to 0 ? Regards, Manel Falcó > >>QSTATS 1 > >Do you really want this on? > >># Read Ahead Variables >>…
ace report & dirty read
How should I run a report with sacego in dirty read mode ? Thanks.…
Re: Performance problems with large SELECTS in 7.3x ?
Stefan Weideneder wrote: > > Hi, > > I tried to select some pages of a table that was a bit larger > than my buffer pool. I estimated that my statement will take > about 5 seconds but it took 12 seconds. > I found out, that the server spent approx. 7 seconds for > "buffer waits".…
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…
Row locked on reads even under dirty read
Hi again, family. This is not so much a call for help as it is a request for discussion. Here's the way the problem was presented to me: The programmer, Charlie, complains to me that his app is getting a slew of error 244/154 (or, if not waiting on locks, 244/144). (Exactly how…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: How do I check LRU contention - onstat -g spi ????
On Tue, 11 Apr 2000 13:30:59 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >bothwellno@spam.duke.edu wrote: > >> Art S. Kagel & Family <kagel@erols.com> wrote: >> : InfoJones wrote: >> : [output SNIPPED] >> >> : To determine whether buffer contention or LRU contention is in…
Re: How do I check LRU contention - onstat -g spi ????
bothwellno@spam.duke.edu wrote: > Art S. Kagel & Family <kagel@erols.com> wrote: > : InfoJones wrote: > : [output SNIPPED] > > : To determine whether buffer contention or LRU contention is involved > : try to calculate your buffer turnover rate: > > : Buffer Turnovers = (dskread…
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…
Re: How do I check LRU contention - onstat -g spi ????
Art S. Kagel & Family <kagel@erols.com> wrote: : InfoJones wrote: : [output SNIPPED] : To determine whether buffer contention or LRU contention is involved : try to calculate your buffer turnover rate: : Buffer Turnovers = (dskreads + bufwrits) / BUFFERS : BTR = (Buffer Turnove…
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: Long checkpoints with no obvious cause
One sore thumb is the RA_THRESHOLD. Try 30 instead of 8. Also, the 1, 2 and 0 for multiprocessor, numcpuvps and single_cpu_vp. Nona…
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…
Read Cache %age on IDS
What are the general recommendations on improving the read cache %age.…
Re: About RA_PAGES
"Dpto. Informatica" wrote: > > mars1972@my-deja.com wrote: > > > > > RA_PAGES 1000 # Number of pages to attempt to read > > > > ahead > > > > RA_THRESHOLD 500 # Number of pages left before next > > group > > > > > > Or the bigger question (to me):…
Re: About RA_PAGES
From: "Dpto. Informatica" <navidul@retemail.es> > >mars1972@my-deja.com wrote: > > > > > RA_PAGES 1000 # Number of pages to attempt to read > > > > ahead > > > > RA_THRESHOLD 500 # Number of pages left before next > > group > > > > > > Or the bigg…
Re: About RA_PAGES
From: Informatica <navidul@retemail.es> > >I've a DSS style Server, I have this parameters in my ONCONFIG file: > ># Read Ahead Variables > >RA_PAGES 1000 # Number of pages to attempt to read >ahead >RA_THRESHOLD 500 # Number of pages left before …
About RA_PAGES
How did you arrive at your settings for RA_PAGES and RA_THRESHOLD??? Thanks in advance, Tim Informatica wrote: > > Hi, > > I've a DSS style Server, I have this parameters in my ONCONFIG file: > > # Read Ahead Variables > > RA_PAGES 1000 # Number of pages to a…
Committed read
I am working on stock trading database where there is a 'quote' table accessed by multiple web users in commited read islation level. onstat -k shows a shared lock for placed. Now I want to alter table and change the page level locking of the table to row level. It returns an err…
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…
RE: checkpoints taking as much as 25 secs
Scott Huppert wrote: > > It's logical that turning the entire buffer pool every 10 minutes is > probably bad, but what is a reasonable time frame? Is there any rule of > thumb? On a busy server that is NOT primarily a DSS/DW server I'd like to see the buffer pool turnover rate …
Buffer Waits Ratio
Andrew Bland <blanda@hep.bradford.gov.uk> wrote in message news:383D2C9D.1D7000C4@hep.bradford.gov.uk... > Hi Everyone, > > I've been trying to get this ratio down below 10% I've been using a > calculation posted on here by Art. > > ratio = bufwaits/pagreads+bufwrits * 10…
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…
ovbuff vs. fgwrites question
Bobby Medus <jeepin@eatmydirt.com> wrote in message news:382C304D.90240C61@texas.net... > This may be a stupid question but you know the old saying..... > > I noticed an increase in 'ovbuff' on the onstat -p. This is a very > small database running on NT and so I increased my b…
RE: Long spins or onstst -g spi. Need any information.
Eugene Nechayev <4new@my-deja.com> wrote in message news:80bvko$so0$1@nnrp1.deja.com... > Art and William thanks for your responses > > Now it's more clear, and after Art's explaining line by line > my onstat -g spi output it's more understandable and useful for me > than after r…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Read ahead utilization
Family Jurkovic <jurkovic@netcom.ca> wrote in message news:37FB7EB9.FD262F96@netcom.ca... > Hi there, > > I am wondering if anybody succeeded to get read-ahead utilization > around 99% ?! Regardless of setting RA parameters I cannot achieve more > that 96-97%. Yes, I got the s…
Kevin read this
--------------- cc:Mail Forwarded --------------- From: Siroui Pink AT NYPBMIS1 Date: 10/06/99 09:13 AM To: informix-list@iiug.org AT INTERNET Subject: Testing from Siroui, Time Inc Service Desk ______________________________ Forward Header _______________________…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Tuning RA for DSS on IDS7.30
Run onstat -p and look at the read-cache and write-cache percentages over a typical load period. Also look at the RA usage values reported and calculate the RA Usage Ratio: RA-pgsused / (ixda-RA + idx_RA + da-RA) * 100 This ratio should be VERY close to 100 (like I get 99.498 …
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…
syschkio view
Hi all, I am trying to understand the syschkio view. What is the relationship between read/pagesread. I read in an article that read means # of read operations and pagesread means # of pages read.Therefore, I identified situations where the number of reads is less than the numbe…
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…
Bufwaits and tuning
Your calculation is backwards that (bufwaits/(dskreads+bufwrits)) which is still 44% (1/2.24) and not too good. Try a value which is not a power of 2. Menlo says they changed the LRU algorithm to get around the problem I reported, which they cannot duplicate and which they clai…
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.…
Read Ahead Parameters
<< I am reposting this message. I don't think it made it through! >> I was recently looking at the same recommended parameters and thought it was rather strange with the numbers I came up with. My environment: BUFFERS=50,000 bp_fact=0.50 # random % large_queries=2 # rando…
Online Config Changes
Marichamy, Udaykumar wrote: > Hello all, > > Can I dynamically change BUFFERS and RA_THRESHOLD without having to bounce > the Informix server? > > I am doing this because the onstat -p output shows that bufwaits is > increasing and ovbuffs has 143. Also, RA-pagesused is much less…
Re: Out of buffer?
On Wed, 26 May 1999, Mark D. Stock wrote: > Xavier wrote: > > > > 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…
Re: Out of buffer?
Xavier wrote: > > 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 time…
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…
Re: Read-ahead parameters
I was recently looking at the same parameters and thought it was rather strange with the numbers I came up with. My environment: BUFFERS=50,000 bp_fact=0.50 # random % large_queries=2 # random queries RA_PAGES = ( BUFFERS*bp_fract ) / ( 2*large_queries ) + 2 = 25,000 / 4 + …
Re: Read-ahead parameters
In "Performance Guide for IDS" book( for IDS V7.30), I found this: RA_PAGES = ( BUFFERS*bp_fract ) / ( 2*large_queries ) + 2 RA_THRESHOLD = ( BUFFERS*bp_fract ) / ( 2*large_queries ) - 2 bp_fract is the portion of data buffers to use for large scans that require read-ahead. If …
Read-ahead parameters
IDS 7.30.uc7 HPUX 10.20 The bugs are supposed to be gone; after eight months I'm ready to reenable read-aheads. Our original values of RA_PAGES / RA_THRESHOLD were 150 / 75. These seemed a bit high based on the postings that I've seen since that time. We're an OLTP shop, wit…
Mirroring parallel read
Can anyone confirm whether my understanding is correct in regard to Informix mirroring and parallel read performance. Informixs' implementation of parallel reads from mirrored DBspaces is thus: Data from the first half of the chunk is read from the primary DBspace and data from…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Re: RESIDENT and PDQ
Chuck Renaud wrote in message <7ddp91$hpf$1@news.xmission.com>... > >As for light scans--those only happen if the table being read is >larger than the buffer pool. So if you max out your buffers, you >won't get light scans unless they're huge tables... So, would this mean that …
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: Why IDS-Linux is so slow?
Obnoxio The Clown wrote: > >now I'm looking for the best platform to run Informix-OnLine on Intel. > >I've tested some versions on my Celeron-333 with 64 Mb RAM and > >single 6.4 Gb Quantum Fireball HDD. I've tried to dbimport database > with > > > >100 tables, 110 Mb unloaded d…
Delete
Hi. I've a question. When execute a delete by where on field not indexes, it sequential scan table' s page. Before to delete records, it casche pages in buffer pool ? Tank you.…
Re: Buffer Waits
> hmm, could you go into a bit detail on the light-scan? I have a DSS system > but I am not sure how to make it use light scan. I read something on the > book about it, but it wasn't very clear on exactly how to utilize it or > how to check it. thanks yan Here's some more inform…
RE: Buffer Waits
You could look at RA_PAGES and RA_THRESHOLD as well, if your system has a lot of sequential reads. HTH Sathish Sadagopan -----Original Message----- From: Bob Davis [mailto:rdavis@rmi.net] Sent: Wednesday, February 10, 1999 3:41 PM To: informix-list@iiug.org Subject: Re: Buffer W…
Performance Tuning
zandy@skyinet.net wrote: > snip > BUFFERS 1000 You have 512 MBytes of Memory. Why don't give Online more ? snip > RA_PAGES 8 > RA_THRESHOLD 4 Why don't Read 32 Pages instead of 8 ? > NUMAIOVPS 64 OOps - What's that ? > snip > > bufwaits…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
Read Ahead pages in 7.xx
__________________________________________________________________________ This message is intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the s…
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: ISAM ?
Guru wrote: > > What is a difference between ISAM reads, disk reads, page reads, buf > reads ? > I can watch it by onstat but I don't know exactly what it is. > Can YOU help me? Sure. dskreads are the number of read requests made to disk, some may be multiple page reads which i…
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?…
Performance degraded after detaching indexes / fragmentation
Possibly you have hit the limits of your little SMP (4 CPU?). Or if you got them, jack NUMCPUVPS up and check the parallel processing parameters in the ONCONFIG. Time for more CPUs. Fragmentation splits up stuff so more parallelization can happen. but it won't happen if you do…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Best database for web backend on Linux?
On Wed, 21 Oct 1998 13:03:49 +0000, Evan Carew <ecarew@yahoo.com> wrote: >Simply put, The main reason I have selected Sybase over Oracle in the >recent past has to do with cache management. In every case, if >you try to use Oracle stored procedures in the same environment with >…
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: Reducing checkpoint intervals...
Hi, in my opinion you must reduce LRU_MAX_DIRTY and LRU_MIN_DIRTY. It's not a good idea to reduce the time interval between the checkpoints because each checkpoint costs a lot of overhead ( thread-synchronisation and checkpoint-waits ). How about: http://www.weideneder.de/info…
Re: Performance problems with large SELECTS in 7.3x ?
Stefan Weideneder wrote: > > Hi, > > I tried to select some pages of a table that was a bit larger > than my buffer pool. I estimated that my statement will take > about 5 seconds but it took 12 seconds. > I found out, that the server spent approx. 7 seconds for > "buffer waits".…
Performance problems with large SELECTS in 7.3x ?
Hi, I tried to select some pages of a table that was a bit larger than my buffer pool. I estimated that my statement will take about 5 seconds but it took 12 seconds. I found out, that the server spent approx. 7 seconds for "buffer waits". Now I added a few buffers to the buffer…
Re: Performance problem after merging db server
Stephan Stresing wrote: > > Hi, > we have a heavy performance problem after 'merging' two db systems > to one. We did this because according to the Informix Performance guide > and the advices of Informix experts. The most obvious thing is that BUFFERS 5000 is *WAY* too low. As…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Re: Onload is too slow
Raghava Ponnapalli wrote: > > Hello, > > We have 1.2 G database that's taking about 2-3 hrs to load using onload > from a flat file. I turn off logging when I onunload. This is 7.13 UC2 on > Solaris 2.4. Here are some of our settings for onload: OK . . . logging is off . . . > …
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: onload performance
Try turning off your indexes during the load. You will need to resync the indexes after the load though. How often are you commiting? Doing so less often should help. How many checkpoints occur during the load? What is the avg checkpoint length? Can you provide an onstat -p afte…
Re: Onload is too slow
I think your problem is about the amount of indexs on your table why don�t you remove some or all of your index and (re)create the indexs after you finish, Juan Enrique Flores jeflores@ref.pemex.com Raghava Ponnapalli <kponn@worldnet.att.net> wrote in article <6p0s3l$3q8@bgtnsc0…
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: onstat -g ses
>Hi, >In the onstat -g ses output , what is the basis for allocation of 'total >memory' ? >There is also the figure 'used memory' , why not just allocate required >memory ? Well, we could do that but then that would 1) fragment memory and 2) create bottlenecks. Memory in shared…
Re: Optimising IDS for RAID-5 ?
Andrew Lawrenson wrote: > > Does anyone have any clues as to how to best tune Informix (v7, currently > 7.23) to run on RAID-5, in terms of LRU's, CLEANERS, LRU_MIN/MAX_DIRTY, Read > Ahead, etc? I my case, this is all under NT 4.0 Tuning these things is very dependent on your g…
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…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
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: RA, bugs, and performance
Arun Shastry wrote: > > Andreas Zeugswetter wrote: [SNIP] > > Hmm, what you say can only be true on a system very low on memory. > > Our values are RA_PAGES 256 and RA_THRESHOLD 96 and we get very [SNIP] > See if you get any different performance, both query and cache, if you set…
Re: RA, bugs, and performance
SaTriGuy wrote: > > >>> most of the pages that were read-ahead. > >>> > >> > >>Wow, that's way too high for even a DSS environment. Rule of thumb I use > >>isto set these to about 32, 16 for a good sized DSS and to about 12,8 for an > >>OLTP envrionment. > > > >Hmm, what you say…
Re: RA, bugs, and performance
Andreas Zeugswetter wrote: > >> RA_PAGES 150 > >> RA_THRESHOLD 75 > >> > >> While these numbers were a bit high, we were able to take advantage of > >> most of the pages that were read-ahead. > >> > > > >Wow, that's way too high for even a DSS environment. R…
Re: RA, bugs, and performance
>>> most of the pages that were read-ahead. >>> >> >>Wow, that's way too high for even a DSS environment. Rule of thumb I use >>isto set these to about 32, 16 for a good sized DSS and to about 12,8 for an >>OLTP envrionment. > >Hmm, what you say can only be true on a system very…
Re: RA, bugs, and performance
>> RA_PAGES 150 >> RA_THRESHOLD 75 >> >> While these numbers were a bit high, we were able to take advantage of >> most of the pages that were read-ahead. >> > >Wow, that's way too high for even a DSS environment. Rule of thumb I use >isto set these to about …
Re: RA, bugs, and performance
Arun Shastry wrote: > > Carlson@WHSmith wrote: > > > Informix DS 7.23.uc4 > > HPUX 10.01 > > HP K200 4-way > > > > Up to this time, I have maintained a RA hit percentage of 90-99%. My RA > > variables were set to : > > > > RA_PAGES 150 > > RA_THRESHOLD 75 > >…
Re: RA, bugs, and performance
Carlson@WHSmith wrote: > Informix DS 7.23.uc4 > HPUX 10.01 > HP K200 4-way > > Up to this time, I have maintained a RA hit percentage of 90-99%. My RA > variables were set to : > > RA_PAGES 150 > RA_THRESHOLD 75 > > While these numbers were a bit high, we we…
RA, bugs, and performance
Informix DS 7.23.uc4 HPUX 10.01 HP K200 4-way Up to this time, I have maintained a RA hit percentage of 90-99%. My RA variables were set to : RA_PAGES 150 RA_THRESHOLD 75 While these numbers were a bit high, we were able to take advantage of most of the pages that were …
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: Read Ahead Pages, etc.
Andrew Lawrenson wrote: > > Is there any optimum upper limit for the values of RA_PAGES and > RA_THRESHOLD? > I've bumped mine up from the defaults of 4/2 to 64/16, and I'm still at > 99.9% pages used. How high should I go? Should I just keep going until the > percentages fall? …
don't read%
Subject: PLEASE DON'T READ THIS MESSAGE From: MONEYMAN.COM Date: Sat, Apr 11, 1998 1:27 AM EDT Message-id: <6gmuvl$4f2653@news.mitm.net> **************************************************************** * This Article was Posted By an unregistered version of: * * …
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: Optimizing..
Know your schema, update statistics, and read sqexplain.out.…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Load vs unload time differ. why?
yes... a write does take longer than a read.…
Re: bufwait tunning
Set your RA_THRESHOLD lower. The ninth and tenth pages are being processed before the next ten pages arrive in the buffer cache.…
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…
Re: bufwait tunning
Mr Cheuk Kong Lo wrote: > I'm getting quite some large bufwaits. Am I right to set a larger > RA_PAGES value to cut it down? Currently I have RA_PAGES set to 10 > and RA_THRESHOLD 8. > No, I don't think that will help. A bufwait occurs when a user is waiting for a buffer to be…
bufwait tunning
I'm getting quite some large bufwaits. Am I right to set a larger RA_PAGES value to cut it down? Currently I have RA_PAGES set to 10 and RA_THRESHOLD 8. Thanks. -- Chris Lo mailto: cklo@hk.super.net System Administrator/Informix DBA mailto: cklo@cklo.hk.super.net The Pru…
Re: Informix vs. Sybase vs. SQL Server vs. Oracle
Andreas Zeugswetter wrote: > Oracle's only advantage is with concurrent read and update, > since it does not need a read lock. > But if you use dirty read isolation, you don't have read locks in > Informix either. Oralce read a row without read lock and get current value withou…
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…
BUFFERS & RA_PAGES
In the performance tuning manual for OnLine 7.x, Informix recommends that you set your buffers to 25/20% of physical memory. My question is, what unit are we meant to be measuring memory in. I have presumed kilobytes, so that for my box with 64 Mb, my buffers are set to 16000. If…
Unix to DOS/Windows Tape
I have a series of tape backups done "tapecopy' in Unix 3.2.2. How can I read them in Windows/DOS machine? The "tar" programs generally available don't read them. I am desperate to recover these text files. Thanks…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: When does bufwaits get incremented ?
> I talked to the instructor at Informix UK > when I went on the Online 7 performance Tuning course. He contacted > the USA but still could not find out EXACTLY what bufwaits meant. > > He did say that if bufwaits was too high then increasing the number of > buffers wou…
Reading a file with 4GL
Does anyone know how to read data from a text file into a 4GL program? I want to read data from a configuration file and initialize some program variables. Thanks in advance, Mike…
computing number of light scan buffers and their size
The P&T manual says: o Size Of Light Scan Buffers - RA_PAGES/(MAXAIOSIZE/PAGESIZE) o Number of Light Scan Buffers - (RA_PAGES+RA_THRESHOLD)/ (MAXAIOSIZE/PAGESIZE) Where MAXAIOSIZE on most 7.2 ports is 60KB and PAGESIZE in (2, 4)KB. Doing the math... (MAXAIOSIZE/PA…
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…
Replication
Hi, I would like to know if the replication is always a database (master) to a database (read only) ? I would like to have one database master and 4 databases (read only). Is it possible ? Could we have one database read/write and use the replicat…
Re: DSA 7.22.UC1/HPUX 10.20
On 22 Feb 1997 22:28:08 -0500, "DavidCoburn/ISG/WVUS/WorldVision"@wvus.org ("David Coburn/ISG/WVUS/WorldVision@WVUS") wrote: > > Let's try this one more time. The original appears to be munged... > > David > > Hi. I have an odd problem here. DSA 7.22.UC1 is demonstrably sl…
Re: SAme Aps on 2 Servers, different performance, help!
In article <5chhg1$kje@netnews.csie.nctu.edu.tw>, ccliu <ccliu@maria2.cs ie.nctu.edu.tw> writes > > >Hi Net, > I have a very confusing situation regarding to performance for >two similar Database. > >Server 1: >HP-UX A.09.04 U 9000/887 >INFORMIX-OnLine Version 7.12.UC1X8 >7…
Re: SAme Aps on 2 Servers, different performance, help!
Hi, Looking at the memory of the 2 machines I'm not surprised at the better performance on Server 1. You also have several other configuration differences between the two machines. The NUMAIOVPS is 8 on server 1 and 3 on Server 2. Is this because you have more disks allocated t…
SAme Aps on 2 Servers, different performance, help!
Hi Net, I have a very confusing situation regarding to performance for two similar Database. Server 1: HP-UX A.09.04 U 9000/887 INFORMIX-OnLine Version 7.12.UC1X8 768 MB memory Server 2: HP-UX B.10.01 U 9000/829 INFORMIX-OnLine Version 7.13.UC1 384 MB memory Both have …
SMI: VP level stats
I'm interested in getting VP level I/O statistics like reads, writes, buffer reads, and buffer writes. These are avilable via onstat with -g iob and -g iov, however I need to get at them via SMI.…
Indexed read on "order by X desc"
Is it possible to do a indexed read when doing order by desc ??? TIA, -Lin…
Re: Locks/Committed Read Problem
Committed Read implies that it can only return committed data. Therefore, if one process has the row locked (always the case if it is updated and still in a transaction), then the other process can not read the row until it is committed or rolled back (the transaction is closed)…
Re: Set transaction isolation level read uncommitted?
On Sun, 14 Jul 1996 03:08:37 -0400, "Chao Y. Din" <cdin@csc.com> wrote: >> >> SET ISOLATION TO DIRTY READ >> > > SET TRANSACTION LEVEL TO READ UNCOMMITTED. > > Usign SET ISOLATION TO DIRTY READ allows you to switch between dirty-reads and non-dirty reads during the SAME…
Re: RA_PAGES and RA_THRESHOLD Defaults
This is a multi-part message in MIME format. --------------A44C74DFA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit mailgw!hpx400!Trevisol_Roberto/bbb_cak@srv3-poa.nutecnet.com.br wrote: > > Recently, I heard from Informix Tech Support that you can n…
Re: RA_PAGES and RA_THRESHOLD Defaults
Recently, I heard from Informix Tech Support that you can not set RA-PAGES higher than 32, because that's the Informix limit for I/O length. Does anyone else have that information? By now I have it as true! Roberto Trevisol rtrevisol@bamerindus.com.br }John - I think they are R…
Re: RA_PAGES and RA_THRESHOLD Defaults
John Morton wrote: > > Does anybody have any idea what the defaults are for RA_PAGES and > RQ_THRESHOLD in 7.1? As far as I know it is switched off by default, with RA_PAGES=0. Have a look in the file $INFORMIXDIR/etc/onconfig.std, which should be your 'standard' configuration f…
Re: RA_PAGES and RA_THRESHOLD Defaults
John - I think they are RA_PAGES=4 and RA_THRESHOLD=2. I have found in our environment, which is heavy read and not so much write that these are very low. I have them set to 64 and 32 respectively, and am contemplating increasing them (I use 99.99...% of those I read ahead). I…
RA_PAGES and RA_THRESHOLD Defaults
Does anybody have any idea what the defaults are for RA_PAGES and RQ_THRESHOLD in 7.1? I'm not getting good read ahead numbers right now, but I don't want to adjust these two parms until I know where I'm starting from. Thanks! Regards, John Morton Toronto, Ontario, Canada mort…
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: Split comp.databases.informix!
Kerry's list looks reasonable to me. I too am skipping much more than I read.…
Barcode reading
The following are some snippets of code that show an example of how we read from barcode readers. The readers that we use are capable of being programmed. You can set a code sequence that is automatically sent at the beginning and the end if required of each barcode. The code we …
Re: Good Buffer Size For Tuning Informix?
Chris Jenkins (chrisj@informix.com) wrote: : The only really important factor in determining the number of buffers is : the read and write cache hit ratios reported by tbstat -p. Keep : increasing the number of buffers until these cache hit rates do not : increase when the system…
Re: Isolation levels
In 6.0 and 7.10 also, I think, Informix isolation levels are dirty read commit read cursor stability repeated read…
Re: HELP : ODBC's physical-order read error message
Sure looks like you are trying to read a locked record…
Re: informix newsgroup
Same as what you did to read/send this/previous messages. Dave.…
test
Don't read this. Apologies for the inconvenience.…
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?…
YOU MUST READ THIS!!! NOW!!!
Allright, I know what you're going to say... This is just pure spam, I should be flame-broiled, thrown on a bun, chewed up, swallowed, digested, and shit out. But just listen to this for a sec. We've all seen it in various forms on local BBS systems, on CI$, AOL, and here on t…
Informix buy Borland?
I read somewhere that Informix was thinking about buying Borland? Has anyone else hurt anything more about this?…
Re: Reading Audit Files?
> Does anybody know of any utilities that would allow me to make sense of > the data contained in an audit file? We don't run transaction logs, but > we're wondering if the audit files might possibly yield useful info about > how data was entered into the table, and when and/or …
Reading Audit Files?
Does anybody know of any utilities that would allow me to make sense of the data contained in an audit file? We don't run transaction logs, but we're wondering if the audit files might possibly yield useful info about how data was entered into the table, and when and/or by whom.…
Reading over locked rows
Hi, i've a program which unload tables to an ascii file and updates a specific column in the rows after they are written to the file. Isolation mode is set to repeatable read to avoid rows to be written to the file which are not committed. Everything was fine but if there are …
re: read ascii in Informix
Here is a program I have been using for a few years that will read an ascii file in Informix. It is 'c' code with a sample of the Informix '4gl' code needed to run it. Have Fun Stuart Litel slitel@netcom.com ------ cut here----- /*From: slitel@netcom.com */ /* fileio.c for u…
Intersolve ODBC Q&E
I'm looking for feedback on Intersolve's ODBC Q&E Ver 2.0 software. I've read the marketing info,but if anyone reading this is actually using it I'd like to know what you think. Regs, Rick rodonnel@ibl.bm…
How to read Flat files from 4gl
I have a requirment to read the flat file from 4GL. Is there any way to do it. Thanks in advance <shanke11@singnet.com.sg>…
Re: Informix Transactions
If you lock the table in exclusive mode and you wish to read from it, use SET ISOLATION TO DIRTY READ; before your select statement.…
Re: Keeping clean pages in shared memory
> If you have a DSS app, the buffer pool does not become dirty, so the > LRU_MAX_DIRTY will not have any impact. ...unless of course you're generating temp tables. Which just about all apps do at some time or another. akent@cix.compulink.co.uk (Andy Kent) ----------------------…
Reading BTrieve-file�p2
To narrow my question down, I only want to be able to read the file from one end to the other, and on my way extrat the information in each record. So to say that I don't need to be able to perform querys on the file, but only read trough it.. If that's impossible, is there a wa…
Re: INFORMIX/ UNIX/ C/ --ATL-
> If you do not want to read it, hit "d" -- that is all. d-- ?? That's how we got c--. -- cwoodall@vth1.vth.colostate.edu…
Read only databases - CD_ROMS
Hope you can help me, I'm trying to find a starting point. I am currently working on a project that will involve databases which will be distributed around the world on CD-ROM. There will be regualr updates (monthly or quaterly) and in each case all preceeding data will be repla…
Re: Reading DBEXPORT tape
I've received the same "invalid arg" errors when trying to read a tbtape archive using dd. I've only had this problem on Solaris. J. Dority…
tbunload for Online 6.0
tbunload and tbload utilities for OnLine 5.0 writes and reads databases and tables only to tape. Is there true, that OnLine 6.0 tbunload and tbload writes and reads to and from files ? Lines: 2 Vadim Ketchashin, St-Petersburg, Russia…
Reading C-ISAM Files
I need to be able to read files written in a C-ISAM file format. If someone could please detail the file format, provide source code to do the job or point me to where I could get the infor- mation I would appreciate it. Please address responses to matthew@aryabhat.umsl.edu. Th…
read this
Hello: We are looking for a client/server database for course management. This database will be installed on a database server which is connected to the campus network. The course database will be used to provide course and lecture information. Students should be able to do quer…
Re: Dirty Read info
In article <1993Nov8.145344.22870@athen.mch.sni.de> gm@athen.mch.sni.de (Guenther Moschen) writes: > >I'm looking for some background of Informix's "Dirty Read" mode. > >Specifically: How is it invoked? Can it be turned on/off for an entire > >session, or on a per…
Re: Dirty Read info
In article <CFz2I7.698@andyne.on.ca> stevenb@bbs.andyne.on.ca writes: > >I'm looking for some background of Informix's "Dirty Read" mode. >Specifically: How is it invoked? Can it be turned on/off for an entire >session, or on a per-query basis? > >Steven > > > It can be turn on …
Re: Reading locked rows
Scott Ford writes: |> user 1 -> begin work; update bozo |> set col2 = 10 |> where col1 = 'a'; |> let's say that the previous value for col2 was 5. note that |> we HAVE NOT yet done a commit work. |> |> user 2 -> set isolation to dirty read; |> select * from bozo; |> …
Re: Reading locked rows
In <1993Sep03.061326.21151@wvus.org> sford@wvus.org (Scott Ford) writes: >Hey folks, >We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We >talk to it using inet-pc 4.10 and powerbuilder running on windows. >Today's question #1 is about reading locked records…
Re: Reading locked rows
> > In <1993Sep03.061326.21151@wvus.org> sford@wvus.org (Scott Ford) writes: > > >Today's question #1 is about reading locked records. Here's the > >scenario: > > buffered logging data base "foo" with table "bozo". > > table bozo has two columns "col1" (primary key) & "c…
Re: Reading locked rows
In <1993Sep03.061326.21151@wvus.org> sford@wvus.org (Scott Ford) writes: >We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We >talk to it using inet-pc 4.10 and powerbuilder running on windows. >Today's question #1 is about reading locked records. Here's the…
Reading locked rows
Hey folks, We're running online & istar 5.0 on a Sequent 2000 with ptx 2.0.4. We talk to it using inet-pc 4.10 and powerbuilder running on windows. Today's question #1 is about reading locked records. Here's the scenario: buffered logging data base "foo" with table "bozo". …
ESQL/C: reading in to a structure
This must be a naive question, but I would appreciate if some one help me with this. How do I read a sql query response to a C lang. structure? For eg. if I have a table t with { x int, y varchar(40), z char(20)} In my prorgam if I execute a query "select * from t " using a c…
Re: Reading tbtape
> > Is there a way to read the tape after a tbtape has > been done to assure what was written? > Depends which tbtape you mean... Since we have been bitten by media failures, we verify all our archive and log tapes on production systems. To read the log tapes, we use tblog.…
Reading tbtape
Hello everyone, Is there a way to read the tape after a tbtape has been done to assure what was written? Thanks! Brian MacWilliams --------------------------------------------------------------------------- Brian MacWilliams IND. TECH. & DB ADMIN BR …
Test - do not read
This is a test. This is only a test. For the next 60 seconds .......... Wayneo burke_w*cdx_miss@msm.cdx.mot.com…
Dirty Read & Upd.Statistics
Hey expert ! I have a question, which you may be able to answer. Could there be any problem if in an online system you have to processes, which executes in parallel, when the 2 processes are: 1 Update statistics ... …
Re: stuffing the read buffer
mukesh@elsouth.wsnc.org (Mukesh Rathor) writes: >>Under DOS, a character can be placed in the front of the keyboard >>buffer using the BIOS interrupt 16h, service 05h. This character ... > > or under Sys V 3.2.x. I wrote a 4GL simulating sperform 2-screens > interface. …
stuffing the read buffer
>Under DOS, a character can be placed in the front of the keyboard >buffer using the BIOS interrupt 16h, service 05h. This character >is the next one read by the Informix application and can be used >in ON KEY code to push carriage returns into the keyboard buffer, >which Inform…
Cannot read system catalogue!!
Path: emory!swrinde!zaphod.mps.ohio-state.edu!think.com!snorkelwacker.mit.edu!tamsun!mtecv2!root From: alfonso@mtecv2.mty.itesm.mx Newsgroups: comp.databases.informix Message-ID: <5153@mtecv2.mty.itesm.mx> Date: 20 Feb 92 18:47:54 GMT Sender: root@mtecv2.mty.itesm.mx Reply-To: al…