Oninit® Archive
Results for “LRU_MAX_DIRTY”
Large memory segment vs smaller ones
Mike, BUFFERPOOL default,buffers=3500000,lrus=500,lru_min_dirty=0.20,lru_max_dirty=0.50 BUFFERPOOL size=4K,buffers=45000000,lrus=500,lru_min_dirty=0.06,lru_max_dirty=0.14 BUFFERPOOL size=16K,buffers=625000,lrus=500,lru_min_dirty=2.00,lru_max_dirty=5.00 All dbspaces…
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 ------------------------------…
Informix vNext slides from IIUG/Scott/Karen/Shripad
Hi, Interesting IIUG talk from Scott/Karen/Shripad abhout vNext New Features https://www.iiug.org/wp-content/uploads/2023/04/Informix-VNext-New-Features.pdf "Performance better or equal than prior release: 14.10.xC1 Investigating new compiler impacts, better scaling on Linux, imp…
restore through STDIO
HI, ifxclone can change the onconfig on the target instance E.g. it will turn off DIRECT_IO and can also change bufferpool entries! Regards, David. ------------------------------ David Williams ------------------------------…
%Cached using onstat -p vs %Cached using onstat -g buf
Andreas: The write cache percent has little effect on server performance. It is a holdover from Informix v4 & v5 where writes went almost immediately to disk. You are correct that it does not represent, as it would for a filesystem cache, the percent of writes that targeted data …
Buffer wait occurs when performing INSERT in multiple sessions
Hi Mike, Thanks for your response. Setting the IFMX_AIXKAIO_NUM_REQ environment variable requires restarting the instance, so we will consider it later. The result of onstat -F is shown below. Foreground writes 0 LRU writes 305769353 Chunk writes 9225920 The settings in onconfig …
Blocking Checkpoint?
Ifmx 12.10.FC14 Solaris 10 1/13 What does it mean when a checkpoint shows "# Waits" = 1, but "Block Time", "Ckpt Time", "Wait Time", "Long Time" are all zero? Critical Sections Physical Log Logical Log Clock …
archecker utility on ontape level 1 archive
Good suggestion to test restore to pristine or zero'd out drives/files. Don't forget that prior to SE v5.08 archives would miss pages on a very busy system! It wasn't found until someone (OK me) needed to restore to clean disks and not over a partially corrupted system where the …
Number of extents
Amit: There is no problem or issue with having dbspaces with different pages sizes, no. There are advantages, including: Each page size gets its own buffer pool which can improve performance for busy tables and isolate them from affecting other tables. Indexes perform better on w…
Simple Large Object Replication
HI, I have a customer who wants to implement Informix Repication (not yet decided which kiind of). He is using lots of Simple Large Objects (Text). Taking into account the fact that TEXT data type are not replicated, he wants to know what is the best approach, storing them into d…
Index page size recommendations
IDS 14.10.FC5 RHEL 8.2 Migrating from an older release of Informix on a different OS, so everything will be different in the new environment. New Informix, new OS, new hardware. So, this is a great time to consider changing some of the things that have remained in place for so …
ontape error
idsdb00105650 ( IT32529 ) : With extended Checkpoint/Log reserved pages and encryption at rest with rootdbs encrypted, server may fail to come online…
Block during checkpoint
Hi Mr Art I'm refer back to my old 2020. I wanted to share my onstat result. We are running Financial application OLTP whereby apps and db in seperate VM. With 64GB of RAM and 32 CPU been allocated to the VM , necessary config has been tune. Unfortunaly recently we hit system han…
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…
Physical Log size
IDS 12.10.FC9W1 AIX 7 I am trying to calculate if our Physical Log size is big enough. My reason: Checkpoint Completed: duration was 171 seconds. Sometimes we get hit by large checkpoints. From the manual: ---------------- To ensure that you have an abundance of space, set the …
Checkpoint statistics
Hello all, I am posting the checkpoint statistics output below onstat -g ckp IBM Informix Dynamic Server Version 12.10.FC6 -- On-Line -- Up 2 days 07:38:02 -- 5318400 Kbytes AUTO_CKPTS=On RTO_SERVER_RESTART=60 seconds Estimated recovery time 23 seconds Critical Sections Phys…
ONCHECK & checkpoints
IDS 12 AIX 7 Can this command cause large checkpoints ? oncheck -cDI eppix:"informix".my_table my_table = 455 million rows…
Transactions blocked in output of online log
This means that 1 transaction has been blocked by the checkpoint (which is acceptable). Important data is how long the transaction has been blocked: if you see more than a few seconds, you probably have performance issues with your checkpoints and must address them. Once is accep…
Page Limit
Dirk: If the table just needs to be reorganized to gather up previously freed up space, I would use the DEFRAGMENT API function (optional) along with the REPACK SHRINK API function to reduce the number of extents and the number of pages to the minimum number that will hold the d…
25582 error on high volume of short live trans
Hi IIUG, Trying to find why my DB blows up to high CPU. it has 62 physical cores (x4 smt) on AIX machine P8 running 11.70 IDS. We are getting -25582 error after putting significant load of transactions. The volume of transactions is big but short live. Here's the config below:…
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…
Informix Page Lock
All locks are just entries in an in-memory lock table ("onstat -k"). On the plus side for page locks, given this lock table gets checked frequently, the fewer entries in this table the better for your engine speed and less memory will be needed. If you will be updating multiple r…
BUFFERPOOL Configuration
Hi, I saw an excellent video post from AdvancedDataTools https://www.youtube.com/watch?v=Wgw1bAWl_Hg regarding sample BUFFERPOOL configurations 1.3 GB Memory for Buffer - Linux OLTP System - BUFFERPOOL size=2k,buffers=1500000,lrus=32,lru_min_dirty=10,lru_max_dirty=20 2. 12 GB …
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…
Waits on the physical log buffer in v12.10
BTree scanner is a good candidate and would explain the seemingly random nature of the problem since we haven't been looking at that explicitly. The difference between 12.10.FC10X1 and 12.10.FC10 is a patch that means the scanner is cleaning non-default page sizes properly, which…
BUFFERPOOL
Hello friends, Please look into my environment. My buffers are full it looks like. My onconfig parameter for BUFFERPOOL is BUFFERPOOL default,memory=auto BUFFERPOOL size=4K,memory=512000 BUFFERPOOL size=8K,memory=auto and the output for "onstat -P": IBM Informix Dynamic Serve…
Checkpoints statistics
Hello Users, We are using IDS 12.10 FC8 DB server, Application is developed in Java and app server is JBOSS Our application is taking long time to save the data into database trhough application. Find the online log details below: 09:23:22 Checkpoint Completed: duration was 0 …
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.…
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…
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…
Question on PHYSFILE size and buffers ...
My current buffers are totaled for 53000 while according to the guideline found inside the onconfig file, my PHYSFILE is sized good for roughly up to 272000 total buffers? (299000/1.1), am I reading this correctly?Thanks in advance for any inputs.Kern -- #########################…
overzealous checkpoints
This is on IDS 12.10.TC2 on Windows Server 2008 R2. This server does checkpoints every 3 to 15 SECONDS. For example: 13:24:20 Maximum server connections 185 13:24:20 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 0, Llog used 2 13:24:23 Checkpoin…
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…
IDS not writing to online.log
yes, I can't see logical logs and checkpoints in online.log. What should I look for in onstat -g ath and stk ?…
use of dbspaces?
Gurus: If the entire database is cached in the bufferpool, does it matter how the database tables and indices might be physically deployed in dbspaces? I typically observe read cache hit rate to be 99.99% and write rate to be 98%. The database layout hasn't been modified for o…
Odd Bufferpool Behaviou
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 mem, I see some …
LRUS_MIN MAX DOES NOT WORK
Original post: Hi, I have Informix 11.70 C5, in order to avoid long checkpoints, I change LRU MIN AND MAX DIRTY BUT IT SEEMS NOT WORKING MY DRITY PAGES CONTINUE TO GROW AND NO FLUSHING IS HAPPENING. LRU_MIN_DIRTY : 20.00 and LRU_MAX_DIRTY to 10.00 Onstat -R it show : that it sh…
Long checkpoint problem
Hi, we have from time to time long checkpoints in informix 11.70 C5, we have lowered the Min_drity and max_dirty to 2 and 1% but the same problem. we have 400000 bufferpool and Lrus=20 and cleaners=8, what should I do plz, we suspect a IO disk problem, we have one disk including…
Database hanging
Hi, we have an 11.70 C5 Informix database of 90 GB and since 3 weeks we have encoutered some probelems, too simply the database is hanging , when we launch from the server dbaccess mydbname its hanging and the database want to let us access and same thing for the clients. the se…
IFX_XFER_SHMBASE
ok, in this case you could temporarily start up the instance with a minimum amount of memory configured (very small bufferpool and SHMVIRTSIZE) - just for the purpose of collecting the process explorer outputs. In this case it's much more likely that onstat and other on... tools…
IDS 12.10.FC- Installation
Different pages sizes do not necessarily use more hard disk space, and in fact can save space. Having different page sizes can allow you to store records more efficiently. When a record is stored on a page, there will usually be empty space left on that page. Using different pag…
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)…
Long checkpoint
Hi iiug team, May i ask your help on how can i trap or any utilities available to trap what is causing the long checkpoint in my production db. It is running IDS 11.7FCx in AIX 7. This doesn't happened before just started last month and it's not consistently showing. Here are t…
Informix Memory Large Pages Sizes
Hi, We are running Informix 11.70.FC7 on Solaris 11. It seems like all Informix shared memory is using 4 MB page sizes. Solaris supports up to 2 GB page sizes. How to I configure Informix to use larger page sizes when allocating memory. This is different from the BUFFERPOOL page…
Checkpoint blocked by a previous checkpoint
Hi folks. I have a situation that I suspect but can't get IBM to confirm or deny. Thus, I'm requesting a peer review that my logic is correct and a likely explanation of a blocked checkpoint. Solaris 10 IDS 11.50.FC3X5 This is what I think happened: My client's production box…
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…
Slowest restore Ever via onbar need help
I'm also not sure if the "checkpoint req" message is causing the blocking...can i execute 'onmode -c' to force checkpoint?…
query runs longer on informix 11.50 than on 9.40
Hi, and thanks for ur answer. As this 11.50 instance is migrated from an earlier 9.40 instance. I just modifyed the BUFFERPOOL parameter in my 11.5 instance from BUFFERPOOL size=4K,buffers=50000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000 to BUFFERPOOL size=4K,buffer…
new bufferpool
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=20000,lrus=8,lr…
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…
class B segments
I have a question on the below âonstat âg segâ output. What does the class B represent? I never saw the B class until I went to TC2. IBM Informix Dynamic Server Version 12.10.TC2IE -- On-Line -- Up 01:46:25 -- 740672 Kbytes Segment Summary: id key addr size ovhd class blk…
Optimising index builds
>> Is DS_TOTAL_MEMORY set high enough to permit significant in-memory sorting? I changed DS_TOTAL_MEMORY to 300GB and reduced BUFFERPOOL to 160GB. Now nothing gets written out to the DBTEMP_SORT file system and all is sorted in memory. It still takes an hour! I guess then I am…
Performance Impact after storage migration
Hello All, IDS 11.50.FC8W2 on HP-UX B.11.31 U ia64 Recently we have upgraded our storage and the hp boxes and since then we see intermittent performance issues. onstat -g ckp AUTO_CKPTS=On RTO_SERVER_RESTART=180 seconds Estimated recovery time 1304 seconds We observed that th…
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 …
checkpoint was stalled
OS : redhat ids : 9.40uc1 We run this system for 10 years without any problem. But It got worse recently. It had occured several time and show messages like this : $ onstat - Informix Dynamic Server Version 9.40.UC1 -- On-Line (CKPT REQ) Blocked:CKPT All the clients can no…
trace to index name
HI, I tried to use partnum of ouput of "onstat -C clean" ( see below) to get the index name from sysptprof. But it seem NOT very right. select * from sysptprof where hex(partnum)='0x00e00081' Any other sysXXXX table has a relation to Partnum of output of "onstat -C clean" ? or…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Page size
Hi, first ,use onspaces with option k to create a dbspace with your desired page size second,in the onconfig define a bufferpool for the desired page size regards…
Question on Checkpoint Tuning How To for IBM Infor
Hello Informix gurus, I got 2 questions relating to checkpoint. 1. I've heard long checkpoint is acceptable in a data warehouse environment, but as far as I'm concerned, it's not so ok, it's been affecting the performance. In this environment, we have load jobs going on, then rep…
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 am installing Informix 11.70 for a DW. On my Windows Server 2008 (64bit) I have 64GB memory and I am trying to take advantage of it. I have set the following bufferpool sizes and restarted the engine, but my parameters are not respected and the actual values are much lowe…
Is bouncing Informix necessary after changing BUFF
For example, from: BUFFERPOOL size=2K,buffers=5000,lrus=8,lru_min_dirty=50,lru_max_dirty=60 to: BUFFERPOOL size=2K,buffers=10000,lrus=8,lru_min_dirty=50,lru_max_dirty=60 Do we need to bounce Informix to bring the new modification into effect? Thank you in advance. Kern --…
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 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…
LRU Queues - more or less
These are two theoretical questions (based on a current situation) 1) Is it better to use fewer larger LRU queues or many small queues if there are a small number of dirty buffers? 2) Is it better to use fewer cleaners and keep them active or is there a way to balance cleaner l…
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…
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…
Increasing shared memory
Hi All, We have Informix 11.10.FC2 on SUSE Linux 10,RAM 24GB with shared memory of 19190788 Kbytes. The bufferpool is as follows: BUFFERPOOL default,buffers=102400,lrus=32,lru_min_dirty=1.000000,lru_max_dirty=2.000000 BUFFERPOOL size=2K,buffers=204800,lrus=32,lru_min_dirty=1.000…
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…
Informix Status Explanations
if i have a lot of yield bufwaits, would that mean i need to increase bufferpool size?…
Archive backup terminated prematurely
Thanks, Mark. One of the ontape backup failures occurred on Wed Dec 28 22:19:15 PST 2011. I don't think I see anything odd in the logs around the time of failure that wasn't there for a previous successful backup: onconfig.prod ============= MSGPATH /bml/logs/informix/prod.log #…
Problems with long checkpoints
Hello, We're stuck without a dba after some massive layoffs. I know a little, but I'm no dba. IDS 11.50.FC6 on RHEL 5.3 We have a development instance that is suddenly going into long checkpoints (43 minutes, 61 minutes, 90 minutes!). We've rebooted the server and restarted …
Re: Mutex wait
Hi, We have tried to set NUMFDSERVERS to 1 on 11.50 but it did not help. Now, we trying to upgrade to 11.70. ________________________________ From: VIKAS HIVARKAR <vikas.hivarkar@gmail.com> To: ids@iiug.org Sent: Wednesday, September 21, 2011 4:20 PM Subject: Re: Mutex wait [24…
Mutex wait
Hello All, One important observation: When Guardium (monitoring tool from IBM) is stoped I do not see this bad mutex behaviour! @Madison Pruet: Yes, nsf.lock waits are a problem, however in my case If I see 200 mutex waits (onstat -g ath |grep mutex / onstat -g lmx)then only 3-…
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
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.…
Performance Issues
Hello All, IDS 11.50.FC8W2 on HP-UX 11.23, 8 cores Facing performance issue and hence drilling through the following NETTYPE ipcshm,10,30,CPU NETTYPE soctcp,12,150,NET VPCLASS cpu,num=10,noage "onstat -g sch" shows all the cpuvps spinning equally & 4-5 busy waits for all cpuv…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
increasing memory IDS11.50.FC3
Hello, you should check how is your engine running with 8Gb, first. Eg: 1) check how many memory segments are you normally using? That should give you a great tip on how you could resize your SHM parameters (as least shm segments, better for you). 2) are you bufferpool enough for…
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.…
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…
DROPPING BUFFERPOOL
HI FOLKS! I AM WONDERING IF I CAN DROP A BUFFERPOOL REMOVING ONLY THE BUFFERPOOL ENTRY FROM THE ONCONFIG FILE AND RESTARTING THE ENGINE? I CREATED A DBSPACE WITH A PAGE SIZE OF 4K, BUT ACTUALLY I WAS NEEDING ONE OF 8K .. BUT THE ENTRY OF 4K STILL IN ONCONFIG. I WILL THANK YOU …
Explanation of performance improvement
Paul Ridding Wrote: ============================================================================= ...snip... So, finally to my question... Could the moving and fragmenting of this large table (about 1/3 of the overall database size) account for such a massive response time improv…
Buffers not flushed
Is a high number on the buffers not flushed something to be concerned about? Fuzzy Checkpoint Completed: duration was 0 seconds, 36941 buffers not flushed.…
Memory Management
shorti wrote: > Hello, I have another question. Again, new to Informix and just doing > research for a Linux implementation. Is there a setting that can > control the total database memory allowed for Informix to use for all > databases and instances (not sure if instance is th…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
optimum usage of resources
2 Parameters in Onconfig SHMVIRTSIZE BUFFERPOOL If your online log is not saying "Adding shared memory dynamically" then do not increase SHMVIRTSIZE You can increase BUFFERPOOL to allocate more memory. Thanks Amitava "VINEET AGARWAL" <vineet.agarwal@samsonite.co.in> Sent by:…
Performance issue with ZFS
We have set as per your recommendation but still we are facing checkpoint took time . Can you help me further?…
how to force aborting long transaction
As I rememebered , there used to be a tbzero or else can make a checkpoint flag , is there a tool like that in iiug ? or it is for ibm internal only ~~…
Page size for DBSPACETEMP?
Is there any performance reason to have the Temp Dbspaces anything other than the default page size? Informix 11.10 and 11.50 Linux Redhat 4 and 5 Our current system has standard dbspaces and bufferpools of 2, 4 and 8. Our Temp Dbspaces are 4K. I am wondering why they were ev…
IDS 10 -> 11.5
Wyza, Jonathon wrote: > Is there a good set of pages somewhere that let you know about the new stuff > that 11.5 gives you over 10? We recently upgraded to 11.5 and I really want to > know about all the stuff it offers that 10 didn't. So, what you're saying is you never read the…
non-blocking checkpiont, physical log & fast recov
Dear collegues, I have one question related with non-blocking checkpiont. As far as I know when a checkpoint occurs, IDS blocks all transactions while flushing all dirty pages in the bufferpool to disk. When it finishes writes a checkpoint record to the current logical log and …
PROBLEM WITH HPL ON INFORMIX 11.5.FC5 - SOLARIS
Dears, I am trying to import data using HPL on INFORMIX 11.50.FC5 in Solaris (SunOS 000sv432 5.10 Generic_142900-01 sun4v sparc SUNW,SPARC-Enterprise-T5120 Solaris). When I starts the onpload, this message appears: 15:54:53 Requested shared memory segment size rounded from 923…
AIX 5.3 IDS 11.50 FC5 - Performance Advisory
CKPTINTVL specifies the frequency, expressed in seconds, at which the database server checks to determine whether a checkpoint is needed. When a full checkpoint occurs, all pages in the shared-memory buffer pool are written to disk. When a fuzzy checkpoint occurs, nonfuzzy pages …
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…
Re: performance improvements for dbimport?
Thanks for all your valuable input. I changed some parameters now: 21:09:27 Onconfig parameter BUFFERPOOL modified from size=2K,buffers=262144,lrus=8,lru_min_dirty=5.0,lru_max_dirty=10.0 to size=2K,buffers=524288,lrus=8,lru_min_dirty=10.0,lru_max_dirty=50.0. 21:09:27 Onconfig p…
Informix IDS for Linux on Solid State Disks
I did some simple tests on IBM 50 GB SATA SSDs (model 43W7698) with IDS 11.50 on RedHat 4 for the Information on Demand conference last Fall. My tests compared 3 SSDs to 21 spindle drives. Even so the SSDs far outperformed (txn/time) the spindles in an OLTP workload. Things only …
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…
Re: Informix FAQ
Art Kagel <art.kagel@gmail.com> wrote: > The idea is to find the stats that can be interpreted as indicating that a > portion of the cache was replaced. what about "onstat -B" + "oncheck -pe" and creating bufferpool characteristics for each object (table, index)? if you collect …
IDS BUFFER POLL CONFIG *NM*
Good afternoon My Name is Helder Jesus. I was wondering if there was a formula to configure BUFFERPOOL and SHMVIRTSIZE correctly regarding the machine specifications of memory and cpu capabilities Thanks in advance seeing that this is my first post!…
Checkpoint Issues in 10.00.FC8
You wrote: >We have an issue with periodic long checkpoint on a server running 10.00.FC8 (AIX 5.3.0.0). >We see that the buffers are drained, nothing is in a critical state, and the >number of dirty buffers will go to zero, but the checkpoint remains blocked for >several more se…
Resident Memory larger then expected
Hi all, in onconfig I set BUFFERPOOL size=2K,buffers=20000,lrus=8,lru_min_dirty=20.000000,lru_max_dirty=30.000000 . In the message log I see: Memory sizes:resident:570368 KB In earlier versions of IDS the formular was BUFFERS x 2 = Size in KB. I had expected memory size resid…
btscanner endless
Hi all, Does anyone knows why suddenly a btscanner becomes endless? I review which index is cleaning and it only has 783 records and it only has integer field. I added my btscanner reports below (as an observation, see big and negative numbers). I have done a drop a recreate o…
ontape -s -L 0 too slowly(online.log)
continue:Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 3 days 15:46:06 -- 1080928 Kbytes Message Log File: /home/informix/online.log 21:24:31 Checkpoint loguniq 95638, logpos 0xc6e018 21:29:39 Checkpoint Completed: duration was 7 seconds. 21:29:39 Checkpoint loguniq…
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…
11.5 - Dbimport performance
My dbimport was taking 8+ hours for a database under 50Gb in size. What I did to cut down the import time was 2 things: #1: use buffered logging with the option "-l buffered" #2: Significantly increase buffers in my BUFFERPOOL in my ONCONFIG file. Here is my current BUFFERPOO…
Automatic Checkpoints
Aix 6 IDS v11.50.FC5 Has anyone run into a situation where with the automatic checkpoints turned on ... the engine gets into a situation where it's constantly check pointing and nothing else can get done? I have had this happen several times ... haven't been able to cause it my…
Buffer Turnover Rate for IDS11.x
All: I was wondering if there is a way to calculate the BTR on an instance that has both 2k and 16k page sized dbspaces, with buffers defined with 2 of the new BUFFERPOOL configuration parameter. Yeah, I know, I'll standardize 16k pages soon enough... but in the meanwhile, since …
Blocked checkpoint ...
IDS 11.50.fc4 Aix 6 I had a situation today where an underlying symbolic link was missing ... Engine came up .. put the warning in the online.log ... Eventually the system became Hung ... waiting on a checkpoint ... ONSPACEDOWN was set to 2 in the onconfig ... Here is the questi…
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…
Memory Alocation ids 11.5 with Linux Red Hat
Hi everyone, I'm doing some performance tests to validate migration from ids 9.40 to ids 11.5 version on Red Hat 4. The first surprise: I can't initialize 11.5 instance with more than 512000 buffers on bufferpool . When I tried, I got the message: 16:59:01 IBM Informix Dynamic…
It is to laugh
While we're all high-fiving at how well IDS did in the VendorRate assessment, has anyone looked at the last two vendors on page 4? :o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com -- This message has been scanned for viruses and dangerous content by OpenProtect…
rowsize versus pagesize
We get a lot of hits on some of tables mostly select,insert and updates. A very few deletions. One of them is around 5K in size. Where dbspaces are 2K in size. We 've tuned the databases in DB2 by assinging different bufferpools to different tablespaces (like separate bufferpool …
nonblocking checkpoints
how do nonblocking checkpoint use the physical log? when do they fire? how does fast recovery work concerning nonblocing checkpoint?…
Formula for figuring out how many BTSCANNERS I nee
Was looking at my btscanners - IDS 11.5FC3 on Redhat linux. I see that it took 1379 seconds in cleaning and looks to be building a hot list is taking a while - As it is building now and the last one was built at 12:24 and it is 40 min later and still running. QUESTIONS: 1)Is th…
Checkpoint duration
Hi I have a checkpoint issue. Most time the checkpoints last between 0 and 3 seconds. Some times I have sequences of 3 or 4 checkpoint when they last much longer, for example 27 seconds. Thats nearly half a minute and is recognized by the users. >From online.log: 1924 08:55…
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 …
Informix page cleaners (w/ a SAN)
James, are you experiencing any issues, long checkpoints maybe? You have 90ish chunks and 128 CLEANERS. During checkpoint each cleaner gets assigned to one chunk (in the order of chunk creation) so you're on the safe side there, the extra cleaners should just idle. Regards Dav…
Checkpoint Duration
I have an IDS, 7.31.FD3 as a database server for Java GUI client application. There were many times that the database checkpoint duration was very long while concurrent users were not as many as usual (there were some working days that the users work load was low). As checked in …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
IDS 7.31 Solaris8 - Long Checkpoints
Hello, I changed LRUS and CLEANERS to 128, LRU_MAX_DIRTY to 2 and LRU_MIN_DIRTY to 1 on a Solaris8 testserver with 2 processors and 2GB RAM. The chackpoints are shorter but the IDS server is much slower then before: a load of about 85000 records takes 25 minutes now, 7 minutes be…
Tablespace size
Neil Truby wrote: > Does the 16g page tabelspace maxiumum still apply in IDS 11 please? Yes. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is beli…
BUFFERPOOL question
Hi all, I have a basic question but it make me confuse. What's the different between BUFFERPOOL below ? BUFFERPOOL size=2K,buffers=1000000,lrus=64,lru_min_dirty=1,lru_max_dirty=2 and BUFFERPOOL size=2K,buffers=1000000,lrus=64,lru_min_dirty=51,lru_max_dirty=52 Best Regards, Jak…
Buffer Pool
Hi, We are running informix 9.4 FC5xs with SAP. Our SAP admin recently advised that the INFORMIX buffers were set to low. Based on some SAP recommendation, we increased the buffers parameter from 301049 to 501049 (about 600Mb to a little les than 1Gb. 2 days later I found the fo…
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/.…
Re: Checkpoint durations
On Nov 28, 7:45 pm, "Neil Truby" <neil.tr...@ardenta.com> wrote: > IDS 10.0FC8W2 on HP-UX 11.31 > > I'm tuning IDS on quite a large system (18 cpus, 65g memory, Tier One SAN). > > I have BUFFERS set to 10,000,000 (ie 20g), and lru_max_dirty to 0.5%.(ie > 50,000 pages or 100m). l…
Checkpoint durations
Neil Truby wrote: > IDS 10.0FC8W2 on HP-UX 11.31 > > I'm tuning IDS on quite a large system (18 cpus, 65g memory, Tier One SAN). > > I have BUFFERS set to 10,000,000 (ie 20g), and lru_max_dirty to 0.5%.(ie > 50,000 pages or 100m). lru_min_dirty is effectively zero. > > At times …
In place alter issue
I am cleaning up my in place alters for my migration to 11.5. I have everything working. I can find them. I can fake update them. I only have one problem when I fake update them I get the following after running oncheck -pT db:table Home Data Page Version Summary …
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…
Re: Fuzzy checkpoints, then Regular Checkpoints??
On Oct 27, 3:21 pm, "Mark Scranton (Xtivia Inc.)" <mark.scran...@gmail.com> wrote: > On Oct 25, 2:09 pm, nate...@gmail.com wrote: > > > > >Informix10.FC7: > > > 09:27:19 Maximum server connections 0 > > 09:32:22 FuzzyCheckpointCompleted: durationwas 0 seconds, 29 > > buffers n…
Re: Best Use of Free Memory
On Tue, Oct 28, 2008 at 7:14 PM, david@smooth1.co.uk <david@smooth1.co.uk>wrote: <SNIP> > > > > As the number of buffers go up the lru chains get longer and so the > time to find a buffer can increase (if the buffer is further down an > LRU queue > at the time). > David, If the…
Re: Fuzzy checkpoints, then Regular Checkpoints??
Hi Nate, There are some things that require a "regular" checkpoint, and when those conditions are met, a "regular" checkpoint will still be issued. You should expect most of your checkpoints to be fuzzy though. -Mark Jamison ________________________________ From: "natebsi@gmai…
Fuzzy checkpoints, then Regular Checkpoints??
Informix 10.FC7: 09:27:19 Maximum server connections 0 09:32:22 Fuzzy Checkpoint Completed: duration was 0 seconds, 29 buffers not fl ushed. 09:32:22 Checkpoint loguniq 51, logpos 0x5b52f8, timestamp: 0x2c783a49 09:32:22 Maximum server connections 0 09:37:25 Fuzzy Checkpo…
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.…
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…
Long checkpoints
Hello there, I've been reading about long checkpoints issue for a while but haven't found solution for our case. We're using IDS 9.40.FC6 on Solaris 9 for OLTP. It is Sun Fire V1280 with 8 UltraSPARC-III+ 1.2 GHz and 16 Gb of RAM on board. The database is not large (compressed …
Res: Solaris - Memory allocation error - Solved
This situation are solved... was a my mistake. I interpreted wrong the machine notes. Where i believed the parameters are automatically configured on the Solaris 10 and the man of rctladm not help to clarify. I just set all semaphores and memory configurations like su…
Install problems IDS on Mac OS X
owardman@gmail.com wrote: > Dear all. > > Mac OS X 10.5.4 (Intel Core 2 Duo) 2 GB RAM > IDS 11.50 FC1 > > Having worked through the steps of the installer (run using an admin. > account) of IDS 11.50 FC1 on OS X the installer reports the > installation process has been successful…
Solaris - Memory allocation error
Hi, I'm preparing a evaluating environment on Sun Solaris 10 SPARC with IDS 11.50 FC1TL (Time Limited). The Version of Solaris is: # isainfo -v 64-bit sparcv9 applications asi_blk_init vis2 vis 32-bit sparc applications asi_blk_init vis2 …
What means "nonblocked checkpoint" ?!
Thanks all.... In my test case , I use "onmode -c" to trigger checkpoint , and I was told this would always force a blocking checkpoint , it is my fault that ignore this behavior ...…
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…
b-tree scanner tuning and expected behavior
GERARDO PADIERNA said: > here the outputs, and thanks for the references. > Regards. > > juanclu1-[PROD]-(db1):~ $ onstat -C > > IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 5 days > 21:33:27 > -- 2015232 Kbytes > > Btree Cleaner Info > BT scanner profile Informa…
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…
onstat -g rea almot 100 queue there !!!
You say : ----------------------------------------------------------------------------- the more LRUS the merrier, but if you did not have enough LRU queues your BR would be sky high. I wouldn't worry until you have many more users running. --------------------------------------…
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.…
stalled checkpoint
Aix 5.3 ids 9.40fc9 All of a sudden I'm getting stalled checkpoints .. any pointers as to what to look at ... I must be missing something ...…
Info Required about Check Points
<If automatic checkpoints are enabled then CHKPTINTVL is ignored completely. That is not correct. Automatic checkpoint only causes your checkpoints to (potentially) occur more frequently then CKPTINTVL in an attempt to ensure that you perform the new 11.x interval checkpoint, an…
Create Index Mysteriously Slow at the End - IDS 11.10.UC2W2 - Red Hat EL5
Andrew Ford wrote: > From: <jprenaut@yahoo.com> > >>If you are always catching the flush_sub threads with this stack, then >>they have submitted an I/O request to the KAIO threads > > > I thought it would be interesting if I disabled KAIO and went with AIOVPs. > > Totally differe…
Info required about ontape restore
Query #1 has been answered, so I'll take a stab at your query #2. Ontape level 0 backs up all data pages as they are when the backup is initiated. These pages include uncommitted data from transactions open at that point in time. The ontape level 0 also includes the Logical Log …
Re: Can Disk mirroring/db snapshots replace the usage of taking database backups?
Hello Neil, the engine has to be prevented from writing to disk when someone is createing a copy > server and its disk structures in memory only flushing it to disk at > checkpoint time". But, to say Informix cannot necessarily recover from an > unblocked disk copy is surely e…
Re: RE: Informix 10.0 FC4 & Solaris 10
Hi everyone, I've seen this phenomenon many times before in various situtations. I know one cause, but that may or may not be happening in this particular case. What I know: As any large piece of work begins on a relatively idle system, the buffer pool pages are mostly clean. A…
Space Allocation for Indexes
On Feb 6, 7:49 pm, mohitanch...@gmail.com wrote: > Version IDS 10: > > I run below query to get free pages in index tblspace for individual > indexes: > > select dbinfo( 'dbspace', sph.partnum ) dbspace, st2.dbsname > database, st2.tabname partition, nptotal, npused, > npd…
any similar software to toad for informix
debadatta said: > Please let me know the softwares available? > thanks a lot for reply :-) http://www.serverstudio.com/ http://www.ibm.com/developerworks/blogs/page/idsteam?tag=oat http://www-306.ibm.com/software/data/informix/tools/isa/ -- Bye now, Obnoxio "There were a myria…
BTSCANNER ALICE mode
if you understand German: http://www.informix-zone.com/informix-german-newsletter check out Ausgabe September 2007. GOOD STUFF See you Superboer. way fast=http://www.clipjes.nl/clip/nederlands/n/normaal_- _oerend_hard.html On 27 jan, 22:05, jpren...@yahoo.com wrote: > On J…
Actual row size of an index
Hello, We are in the process of testing the use of alternate page/bufferpool sizes for our indexes. I am trying to determine what the best size would be. Since the maximum number of rows that can be stored is still 255 in IDS10, I do not want to pick a page size that would cause…
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…
Difference between Physical and Logical Logs?
DANNY NG wrote: > It seems the work done by logical log is more than physical log. What is the > point of having physical log? As logical log already including post and pre > image of database chanages. > The physical log is ONLY used in two situations: 1- The contents are copi…
Fuzzy vs Full Checkpoints v10.00.UC6
I suggest to disable fuzzy checkpoints - set NOFUZZYCKPT environment variable before you start IDS. and do sensitive checkpoint tuning. In my opinion fuzzy checkpoints provide too little performance benefit (any ?) at the price of too many bugs (crash recovery not working). In …
Tuning Checkpoints
ALICE BENNETT wrote: > I need some help getting checkpoints durations lowered. We are running > informix 9.4. I have been working with Informix Tech support and it has gotten > some better but it is not as good as it should be. We have been adjusting > BUFFERS, LRUS, CLEANERS, LR…
informix.com
Jonathan Leffler wrote: > Well, whatever the problem was, it now (2007-11-27 18:34 -08:00) looks > clean to me. The Informix web site now redirects you to > http://www-306.ibm.com/software/data/informix, and that looks to be a > regular Informix home page (no U2, no Wintergate)…
long checkpoints
hi, i have some problem with the long running checkpoints in IDS 7.31.UD8 on HP/UX. every day a batch utility making hig volume of insert and updates. and this batch works about 5-10 minutes(checkpoint times included). during this batch load one or two (long) checkpoints occur. (…
BUFFERPOOL for BLOBSPACES
IDS 10.0FC4 SUN Solaris 10. SAN Raw devices configured as 52GB each. We have created blobspaces that have a page size of 10K and data page sizes of 8K. We have 2 bufferpools one default and one for the 8k. Do we need to create a separate bufferpool for the blobspaces? Thanks, …
Buffer waits
Onstat -R shows clean versus dirty buffers, not used versus unused. Onstat -P on the first line which is partnum zero (0) the 'other' column is the number of unused buffers, usually zero for any server that's been online for a reasonable time. Bufwaits have two sources, one is s…
Re: Performance problem immediately fixed by disabling HDR
"Fernando Nunes" <spam@domus.online.pt> wrote in message news:f9atdb$7ev$2@aioe.org... > Neil Truby wrote: >> IDS 10.0FC5 on AIX 5.3 >> >> We have a highly sporadic performance problem. Sporedically - hasn;t >> happened for a couple of months but has started today - our database…
Performance problem immediately fixed by disabling HDR
Neil Truby wrote: > IDS 10.0FC5 on AIX 5.3 > > We have a highly sporadic performance problem. Sporedically - hasn;t > happened for a couple of months but has started today - our database server > starts exhibiting 2 sec checkpoints (otherwise they are almost always 0s) > and the…
page size of chunk in fragmented table
It depends. Benchmark with the different page sizes and see what floats your boat. Don't forget to also modify the bufferpool settings in your $ONCONFIG to reflect your choices. j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@i…
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: long checkpoints on informix
Darin wrote: > Also, shameless plug for v11. In Version 11, fuzzy checkpoints have > been removed completely, and the checkpoints are what is referred to > as non-blocking checkpoints. IE, there is no blocking during the > flushing of the buffers in version 11. Of course, the…
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…
How to remove checkpoint
How to remove checkpoint 'Quiescent (CKPT REQ)' during database startup after crash cause I've been waiting for more than 100 minutes, but the database still blocked 'checkpoint state'…
Optimizer Question
Hi For better performance some key aspects are 1. Fast checkpoint ( in your case its 600 -> try to reduce it to 480) 2. RA_PAGES and RA_THRESHOLD increase values to RA_PAGES to 32 or above and RA_THRESHOLD to 30 As you have IDS 9.4 you also should check for LRU_MAX_DIRTY , LRU…
Database Sizes
SUE SIMMONDS wrote: > Is there an easy way to find out how much space/pages each database is > actually using ? > > Using ISA I can see how much space/pages are allocated/used in each dbspace > but in most cases there is more than 1 database in each dbspace and I need the > data …
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.…
Checkpoint times
Hi, we encounter enhanced checkpoint times on a production instance. I have tried to modify some parameters which results in less checkpoints, but still long (at least for our system). Actual config is Sun 280R, 4GB Ram, 2 Processors, Solaris 9 (Sparc), IDS 10.00FC6. Checkpoint …
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Difference in checkpoint durations on HDR Primary and Secondary.
Hiya guys! I've just come across something I didn't think was possible: IDS 10.00.FC5 on Linux RedHat. Primary: ... 14:26:53 Checkpoint Completed: duration was 0 seconds. 14:26:53 Checkpoint loguniq 8922, logpos 0x2066018, timestamp: 0x93d695b1 14:26:53 Maximum server co…
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…
Page Size....
Tam O'Shanter said: > Hello Friends, > > Any compelling reason not to use a page size on my database greater than > 2K > (which I understand is the default)? > > I have some tables where records are larger than 2K and wish to avoid page > chaining by going to a 4K page size (or …
Re: LRU_MAX_DIRTY / LRU_MIN_DIRTY Both equal to 1
> Remember that a checkpoint is activated by time , or when the > LRU_MAX_DIRTY is achieved. > The 9.4x version have decimal values for these parameters. > > Regards. Ferronato Ferronato AFAIR, LRU_MAX_DIRTY is set to reduce the amount of data to be written during checkpoin…
Re: LRU_MAX_DIRTY / LRU_MIN_DIRTY Both equal to 1
Hi, I agree with reducing your CKPTINTERVAL ! Try it! Remember that a checkpoint is activated by time , or when the LRU_MAX_DIRTY is achieved. The 9.4x version have decimal values for these parameters. Regards. Ferronato good_ifmx@yahoo.com escreveu: > Hi, > > Anybody is u…
RE: LRU_MAX_DIRTY / LRU_MIN_DIRTY Both equal to 1
How about increasing the LRUs then the 2% should be fine. BTW if you are planning to upgrade to IDS 10 then max/min dirty accept fraction of a percent do you can use 1% and 0.5% Basim Chafik Senior Systems Analyst IBM Certified Advanced Technical Expert (CATE) 1.800.688.4895 bas…
LRU_MAX_DIRTY / LRU_MIN_DIRTY Both equal to 1
Hi, Anybody is using the following settings LRU_MAX_DIRTY=1 LRU_MIN_DIRTY=1 using Informix 7.3 Engine.........7.31.FD5 / HPUX-11 Heavily used OLTP system.. Current settings LRU_MAX_DIRTY=2 and LRU_MAX_DRITY=1 LRU=128 CLEANERS=128 BUFFERS=500000 slightly longer checkpoints.. A…
Re: behaviour of ontape
Aleksander wrote: [...] > And more: > "(The time the backup started could reflect the last checkpoint before > the backup started.)" > > I don't get this one, what does this mean? It means that if your system had a checkpoint at 20:00, but nothing has changed since then when you…
problems to start an IDS 7.2-database under SCO
Georg Walk said: > Any idea welcome Run, don't Walk, for the nearest exit. :o) Seriously, if they don't have backups and they have page corruption, you are "faced with enormous challenges". -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine …
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
RE: Where are my (simple) BLOBS, really?
Did you do a dbschema -d <database> -t <table> -ss I think the ss is important without it you get simple schema without the storage options. It looks like what you did because you didn't get the extent or the locking mode of the table. Southwell Schuyler wrote: > Er, um eratta…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: IDS 10 on RHEL4 Linux: I/O benchmark of RAW DEVICES vs BLOCK DEVICES vs COOKED FILES
Ben, thanx for the feedback. You are right. I did reset statistics and run the test again: all is cached in the buffers (see below). I need to either change the testing tool or reduce buffers. This means that the previously provided figures about test #2 are not very significa…
checkpoint problem
mchivaviro@okzim.co.zw wrote > > I am runnind IDS 7.31 on HPUX 11 and my check points a taking > too long. > What do I need to change. > LRU_MAX_DIRTY 1 # LRU percent dirty begin cleaning > LRU_MIN_DIRTY 0 # LRU percent dirty end cleaning limit …
Reducing checkpoints
Hi,i have a database with 80gigabytes of data with 360users and up to 400 when at peak.I use IDS 7.31 running on HP-UX 11.0 and 8 Gig of memory.The checkpoints get to as high as 58sec at peak periods .Users often run out of connections into informix.How can i reduce these checkpo…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: shared memory segment size
Ok - the resident part of the shared memory comprised the header, bufferpool, Logical log buffer, Physical log buffer and locks. 1 400 000 Kbyte for bufferpool - we have 700 000 buffers and 2k for each buffer 128 Kbyte for 2 phys buffers 192 Kbyte for 3 logbuffs …
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…
Tuning Recommendations for Informix V10
dhaya.snidhi@gmail.com wrote: > There seems to be a Warning with Buffer Pool Size. What change to I > have to do. Also advise on the Checkpoint duration. Assuming Informix is the only (significant) service running on this box and there is only one instance you aren't making muc…
orphaned blob pieces
When running oncheck -cD I get the following: $ oncheck -cD live:doc TBLspace data check for live:doc Cannot allocate 253725256 bytes for 'remainder pieces used bitmap' ERROR: PNBLOB piece 0x120102 found in page but not referenced by datarow Clean up orphaned blob piece ? Sh…
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/…
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!…
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: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: Not using the new parameters in V10.0 upgrade.
minnickbrian@aol.com said: > > I've just inherited a system that has been recently upgraded from V9.21 > to V10.0. When they performed the upgrade, they just used the old > onconfig file and did not use the new BUFFERPOOL or BTSCANNER > parmeters. It seems to be working so far, b…
Not using the new parameters in V10.0 upgrade.
I've just inherited a system that has been recently upgraded from V9.21 to V10.0. When they performed the upgrade, they just used the old onconfig file and did not use the new BUFFERPOOL or BTSCANNER parmeters. It seems to be working so far, but does anyone know if this will caus…
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 disk configuration
At checkpoint time chunks are assigned round robin to page cleaners for cleaning. ONE CHUNK WILL ONE GET ONE PAGE CLEANERS FLUSHING IT'S WRITES AT CHECKPOINT TIME. We had a 60Gb chunk and someone was loading lots of data into it. 5 minute checkpoint interval and checkpoints up…
Re: No future for DB2
Serge Rielau wrote: > DA Morgan wrote: > >> 1. Load the databases on identical hardware and operating systems > > That one doesn't work. Different systems have different sweetspots for > hardware. Make that "same budget". > There is nothing wrong with getting the same ffect with …
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 …
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…
checkpoint
Hi there, I try to run a sql query statement in background, but seems the thread dead or gone without any error. I know the query will return some data, but when I check, there is no data been generated. I check the online log, and find out that there is a checkpoint when I run …
Re: Need help!! Sql to Informix Migration
And what about the checkpoint, LRU_MAX_DIRTY and LRU_MIN_DIRTY…
Re: Need help!! Sql to Informix Migration
And what about the checkpoint, LRU_MAX_DIRTY and LRU_MIN_DIRTY…
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
Thank you, Jonathan. I guess I was not clear on system vs IDS page size. I knew that the page size for IDS on our Sun boxes was 2K. I didn't know what to make of the mention of 4 MB page size. Why, I thought, would I want to make a buffer pool with page size anything other th…
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: RESIDENT and BUFFERPOOL
I don't think so. I would choose a bigger BUFFERPOOL page size for tables with rows larger that 2k, on any platform and with any os page size. But this is of course a new area to Informix database folks. Michael David E. Grove wrote: >>On Solaris the 4MB page size is used for a…
RESIDENT and BUFFERPOOL
> > 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? DG…
RESIDENT and BUFFERPOOL
> > 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? DG…
Re: rule of thumb or words of wisdom for btree cleaners?
Alexey Sonkin wrote: > Just put > > BTSCANNER num=1,priority=low,threshold=50000,rangesize=10000 > > in Your $ONCONFIG - and Your desperation will go away My desperation might turn into sadness, no more that that. In my opinion the new btree scanner has at least two major design…
RE: rule of thumb or words of wisdom for btree cleaners?
Alexey Sonkin wrote: > Just put > > BTSCANNER num=1,priority=low,threshold=50000,rangesize=10000 > > in Your $ONCONFIG - and Your desperation will go away My desperation might turn into sadness, no more that that. In my opinion the new btree scanner has at least two major design…
Re: rule of thumb or words of wisdom for btree cleaners?
Perhaps I should call this "words of desperation". Sorry for being negative. But the most striking thing your numbers show is how much i/o the btree cleaner wastes. NormaJean wrote: > All, > Does anyone have a rule of thumb or words of wisdom regarding additonal > btree cleaners…
Re: rule of thumb or words of wisdom for btree cleaners?
Perhaps I should call this "words of desperation". Sorry for being negative. But the most striking thing your numbers show is how much i/o the btree cleaner wastes. NormaJean wrote: > All, > Does anyone have a rule of thumb or words of wisdom regarding additonal > btree cleaners…
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…
RE: IDS 10 Download?
Isn't informix's general default for size, 8K? So would not the bufferpool default line you showed mean there is an 8k entry? NJ -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of David Williams Sent: Monday, Februar…
RE: IDS 10 Download?
Isn't informix's general default for size, 8K? So would not the bufferpool default line you showed mean there is an 8k entry? NJ -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of David Williams Sent: Monday, Februar…
IDS 10 Download?
Found something I don't like. onconfig BUFFERS parameters are :- #Following parameters are realted to the buffer pool BUFFERPOOL default,buffers=1000,lrus=8,lru_min_dirty=50,lru_max_dirty=60 BUFFERPOOL size=4k,buffers=1000,lrus=8,lru_min_dirty=50,lru_max_dirty=60 BUFF…
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…
Question on Checkpoints
After a checkpoint, how many "buffers not flushed" is considered acceptable? Let's say the typical check point (every 15 minutes) looks like this: 10:30:40 Maximum server connections 296 10:45:40 Fuzzy Checkpoint Completed: duration was 0 seconds, 179 buffers not flushed,…
long checkpoints in 9.40.fc4
We have converted to the following: hpux-11i (64 bit) 4 proc 8 gig ram IDS 9.40.FC4 HP SAN Cooked files This same system ran on a 7.31 database on Solaris (intel)(2 procs) just fine 0-3 second checkpoints. Anybody have any ideas on what I can check/do to fix this. Stephen Scott…
Checkpoint altos
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_01C4D98B.DA5D84E0 Content-Type: text/plain DATOS ===== IDS: Informix 7.31 FD8 Sistema Operativo: HP-UX 11.11 ( 64 bits…
ramdisks
Bob, Each first chunk of non-root dbspace (including temporary) has at least 53 pages filled-in with data (two reserved pages, one bitmap page and at least 50 'tablespace tablespace' pages) Other chunks of non-root dbspace have at least 3 pre-populated pages You need to restor…
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'?…
long checkpoints
Hi all, the performance on one of our Customer's production databases has decreased dramatically in the last couple of weeks. Checkpoints seem to be taking over a minute to complete. Running IDS 9.21 UC6 (which I know is no longer supported but unfortunately as it is out there i…
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…
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…
Re: Informix WGE with IBM DB2 Gold Bundle
Captain Pedantic wrote: > > "Data Goob" <datagoob@hotmail.com> wrote in message > news:cQxEc.114469$Mr2.40053@fe03.usenetserver.com... > > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message > news:cbtnc4$6lt$1@news.xmission.com... > > > > > > > > > Neil Truby said: > …
Re: Informix WGE with IBM DB2 Gold Bundle
Data Goob said: > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message > news:cbtnc4$6lt$1@news.xmission.com... >> >> >> Neil Truby said: >> >> > Have you tried increasing BUFFERS? >> >> Or UPDATE STATISTICS? > > For DB2 it would be: > > Have you increased the BUFFERPO…
Re: Informix WGE with IBM DB2 Gold Bundle
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:cbtnc4$6lt$1@news.xmission.com... > > > Neil Truby said: > > > Have you tried increasing BUFFERS? > > Or UPDATE STATISTICS? > > For DB2 it would be: Have you increased the BUFFERPOOL? Or RUNSTATS? :-) Bonus…
Hanging checkpoint
Recently we had an issue where a checkpoint was hanging and preventing users from logging on and running any type of query on the machine. I had to shutdown the Informix server and start it back up again to get it to a useable state. Does anyone have any ideas on how to prevent s…
RE: thank you IBM
Madison, I have suspicion, that this particular fragment of the UDB documentation came from DB2 for z/OS (mainframe) documentation. DB2 on mainfraims support shared-disk (like Oracle Parallel Server) architecture. With shred-disk approach, it is necessary to synchronize modifie…
RE: thank you IBM
See below... "Alexey Sonkin" <alexeis@grandvirtual.com> wrote in message news:caj34l$lpd$1@news.xmission.com... > > > > > -----Original Message----- > > From: Madison Pruet [mailto:mpruet@comcast.net] > > > > What is described by the 'victim' in the Admin Guide is the same as a…
Long checkpoints
Hi, all. Environment: IDS 9.21, HP UX 11, OLTP application. Informix stores data on raw devices on disk array. Unfortunatley, this array is used by other applications also. Guess, this is reason, why sometimes checkpoint time jumps to 20 seconds, which is not acceptable. Below…
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?…
Extremly long checkpoints: How to find the reason and solve the problem (7.31 FD3)
Hello, we have some serious problems with extremly long checkpoints. Interactive users can�t really work. 09:01:15 Logical Log 28452 Complete 09:01:16 Logical Log 28452 - Backup Started 09:01:36 Logical Log 28452 - Backup Completed 09:30:28 Checkpoint Completed: duration…
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.…
Long checkpoints on AIX/IDS7.31/IBM Shark
List, We have very sporadic, very long checkpoints on our IBM RS/6000 boxes (AIX 4.3.3, IDS 7.31.UD4) connected to an IBM Shark (2105-F20), eg. 66 seconds to write away 2772 KB. Normally checkpoints are 0 - 1 seconds for 10 - 20 MB: $ onstat -c | grep -e BUFFERS -e LRU -e CKPTI…
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,…
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…
Re: Buffers and LRU.
"T.K" <gp@tf.de> wrote in message news:<bvrslu$67h$1@inews.gazeta.pl>... > Hello. > I'm beginner in use Informix. > Where can I find what are the main difference between > buffers and LRU queue. > > Thanks for your help > > T.K Its kind of like asking what is t…
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…
missing checkpoints
Hello Gurus, Does anybody know why a 9.21 ids engine would not do a checkpoint for at least 30 minutes. all previous checkpoint took 0 seconds and all subsequent checkpoints also took 0 seconds. The application process died or rather the application connection to the database d…
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…
All of a sudden long checkpoint started
Can someone give any pointers what to look for and where to look for long checkpoint duration? Actually we have two production servers and past week all of a sudden there is an increase in checkpoint duration on both the servers simultaneously. Not sure what is going on and wha…
All of a sudden long checkpoints started
Can someone give any pointers what to look for and where to look for long checkpoint duration? Actually we have two production servers and past week all of a sudden there is an increase in checkpoint duration on both the servers simultaneously. Not sure what is going on and wha…
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?…
script to predict checkpoint
Hi, I have a script in perl which can accurately predict when the next checkpoint is due (upto 5 seconds off) and issue onmode -B just before the checkpoint is due. This way, when Informix enters critical stage of checkpoint, it will find lot less dirty buffers and block the ser…
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.…
Fuzzy Checkpoint
Does anyone know what the environment variable is and what it should be set to in order to stop fuzzy checkpoints and keep the normal full checkpoint? I heard the variable was NOFUZZYCKPT but am not sure what to set it to. Joel Reece…
Re: [HELP] What my Informix is doing?
$ grep LRU $ONCONFIG LRUS 8 # Number of LRU queues LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit so i think the min LRUS was set to 8. "Madison Pruet" <mpr…
Re: maxlen in onstat -g ioq
Michael Mueller <michael.mueller01@kay-mueller.de> wrote: > R�diger, > > As I already pointed out, this is normal. It only shows that you do a > substantial amount of writes at checkpoint time. What you could do is > check your checkpoint duration times in the message log. If th…
IDS 9.40 Documentation (LRUs).
Hello. I�ve been trying to find some information about changes in the way IDS 9.40 handles LRU Queues. It seems that there is a new algorithm that allows a performance enhancement regarding Low and High Priority Buffers. The 9.40 documentation does not mention anything, but i…
Description of onstat -C
Oxow, "Outstanding Requests" are requests to clean some page that have to be worked on by the btree cleaner. They are issued after some index key got deleted. An "Invalidation Request" is a request to cancel an outstanding request. This is done for example when an index with ou…
Re: UPDATE STATISTICS
Hi, everybody, If any column included into 'update statistics low' list has an index on it then server makes full index scan. This scan: 1. Makes b-tree cleaning of pages, that were not cleaned before last server shutdown (btree cleaner keeps its list in memory, and, when t…
hdr hang
Hello, ids 9.30uc1 on unixware 7.x. hdr seems to be hang when checkpoint increase on my secondary server (>200). I increase drtimeout on primary to the maximum checkpoint value. It doesn't solve the problem. hdr need to be stop an restart frequently. Any possible tuning and moni…
Replication traffic on the network has spiked up !!!
HDR or ER? How are you able to monitor replication traffic? M.P. "Jack A" <hrehal@yahoo.com> wrote in message news:5eef134e5c079abca0ea83d4dc748474@free.teranews.com... > Running Informix Dynamic Server 2000 Version 9.21.UC5 on SunOS 5.8. Last > week we changed the following …
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…
fuzzy checkpoint
I want to use the fully checkpoint instead fuzzy checkpoint when a checkpoint occur, How can I do? thanks -- Posted via http://dbforums.com…
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: long checkpoints
tomL wrote: > Thanks for all the help. But we have lowered our > LRU_MAX_DIRTY/MIN_DIRTY from 30/25 to 4/2 and still receive > checkpoints in the 25-50 second range - way too long. We notice that > checkpoints still seem to occur at the 5 minute CKPTINTVL interval > (rather than …
checkpoints
Hi, i am working with IDS9.30UC2 on solaris 8. I have to optimize checkpoints duration. What is the writing sequence during a checkpoint ? Does Informix write on disks sorted by chunk number or sorted by dbspace and chunk number ? i have to know that because i would like to p…
long checkpoints
hello all, we have recently experienced checkpoints that are lasting 20-30 seconds that were previously 5-8 seconds. I am looking at the CONFIG file to see if something could be improved. We are on HP-UNIX box (11.00)(2 proc box) with Informix 9.21 HC-5. BUFFERS 250000 …
Re: no checkpoint
Franklin Tang wrote: > Dear All, > I just want to know if I set the CKPTINTVL to 36000 which an hour, of > coz I have around 512 LRU to flush my buffer. Then what will be drawback for > my system. As has been pointed out, 36000 seconds is 10 hours. Why do you want to do thi…
Re: no checkpoint
rkusenet wrote: > "Franklin Tang" <franklin@macauslot.com> wrote in message news:badmbv$eqo1@ctmsun0.macau.ctm.net... > >>Dear All, >> I just want to know if I set the CKPTINTVL to 36000 which an hour, of > > > 36000 is ten hours, not 1 hr. > > >>LRUS 512 …
no checkpoint
"Franklin Tang" <franklin@macauslot.com> wrote in message news:badmbv$eqo1@ctmsun0.macau.ctm.net... > Dear All, > I just want to know if I set the CKPTINTVL to 36000 which an hour, of 36000 is ten hours, not 1 hr. > LRUS 512 # Number of LRU queues wh…
Performance & checkpoint
Hi All, My database has grown 3 times and the performance is degrading. During the business hours my checkpoint duration is between 1-8 seconds. About two months ago my checkpoint mostly is between 0-1 seconds. I included my onconfig file for you to review. If you have any sugges…
Re: checkpoint
rkusenet wrote: > "Franklin Tang" <franklin@macauslot.com> wrote : > >>Dear all, >> what is the impact to increase the CKPTINTVL value. Any side-effect??? >>If my system crash, do I lose more data because the buffer doesnt get fushed >>by the checkpoint action??? I know the LR…
Re: checkpoint
rkusenet wrote: > "Franklin Tang" <franklin@macauslot.com> wrote : > >>Dear all, >> what is the impact to increase the CKPTINTVL value. Any side-effect??? >>If my system crash, do I lose more data because the buffer doesnt get fushed >>by the checkpoint action??? I know the LR…
checkpoint
Dear all, what is the impact to increase the CKPTINTVL value. Any side-effect??? If my system crash, do I lose more data because the buffer doesnt get fushed by the checkpoint action??? I know the LRUs will fush when it reachs the LRU_MAX_DIRTY. Anyone can give me more clear …
RE: LRU writes
> -----Original Message----- > From: Stefan Weideneder [SMTP:stefan@weideneder.de] > Sent: Monday, May 05, 2003 1:16 PM > To: informix-list@iiug.org > Subject: RE: LRU writes > > > > Assuming you really do want to cause more LRU writes because of > > excessive checkpoint duration…
RE: LRU writes
> -----Original Message----- > From: Stefan Weideneder [SMTP:stefan@weideneder.de] > Sent: Monday, May 05, 2003 1:16 PM > To: informix-list@iiug.org > Subject: RE: LRU writes > > > > Assuming you really do want to cause more LRU writes because of > > excessive checkpoint duration…
RE: LRU writes
> -----Original Message----- > From: Franklin Tang [SMTP:franklin@macauslot.com] > Sent: Monday, May 05, 2003 8:13 AM > To: informix-list@iiug.org > Subject: LRU writes > > Dear, > I have a problem on the LRU writes , the figure for LRU compares to > Chunk writes has a huge d…
RE: LRU writes
> -----Original Message----- > From: Franklin Tang [SMTP:franklin@macauslot.com] > Sent: Monday, May 05, 2003 8:13 AM > To: informix-list@iiug.org > Subject: LRU writes > > Dear, > I have a problem on the LRU writes , the figure for LRU compares to > Chunk writes has a huge d…
LRU writes
"Franklin Tang" <franklin@macauslot.com> wrote in message news:<b95ki7$8jr2@ctmsun0.macau.ctm.net>... > Dear, > I have a problem on the LRU writes , the figure for LRU compares to > Chunk writes has a huge difference. E.g. > > Fg Writes LRU Writes Chunk Writes > 0 …
Checkpoint duration too long at times
Environment: Informix Dynamic Server 7.31 UD2 R1 HP-UX 11.0 As you can see below 10:44:50 Checkpoint Completed: duration was 0 seconds. 10:59:59 Checkpoint Completed: duration was 0 seconds. 11:15:08 Checkpoint Completed: duration was 0 seconds. 11:30:17 Checkpoint Completed:…
Checkpoint duration too long sometimes--no fixed pattern
Environment: Informix Dynamic Server 7.31 UD2 R1 HP-UX 11.0 As you can see below 10:44:50 Checkpoint Completed: duration was 0 seconds. 10:59:59 Checkpoint Completed: duration was 0 seconds. 11:15:08 Checkpoint Completed: duration was 0 seconds. 11:30:17 Checkpoint Completed:…
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…
FW: FW: LRU's and CLEANERS (IDS 9.21FC1)
-----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of David Williams Sent: Saturday, February 03, 2001 4:39 PM To: informix-list@iiug.org Subject: Re: FW: LRU's and CLEANERS (IDS 9.21FC1) In article <95efd3$2ha$…
FW: LRU's and CLEANERS (IDS 9.21FC1)
Thanks for the input Christian. I just still have to be convinced about this one. I think your suggestion is also in line with what the manual says, however I've heard of a lot of people having 128 LRUS on only a couple of cpus. In a previous post by Art Kagel (Wed 11/29/2…
LRU's and CLEANERS (IDS 9.21FC1)
"Dirk Moolman" <dirkm@reach.co.za> wrote in message news:95dohr$onl$1@news.xmission.com... > > The manual says the following about LRU's and CLEANERS > > To monitor the percentage of dirty pages in LRU queues, use the onstat -R > command. When the number of dirty pages consistent…
Re: Growing dbspace
Next extent size could be the culprit. Run this :- select tabname, fextsize, nextns, nextsiz from yourdatabase:systables a, sysmaster:sysptnhdr b where tabid > 99 and a.partnum = b.partnum order by nextsiz desc will show you the next extent size of the tables. JH app@not.all…
Re: Growing dbspace
On Fri, 19 Jan 2001 app@not.allowed wrote: > Dear Informix experts, > > I have problem with my dbspace that suddenly growing in size . Within one > night it grows by almost 40,000 pages where in normal case should be > between 1000 - 2000 pages daily. > Do you think because of t…
Growing dbspace
Dear Informix experts, I have problem with my dbspace that suddenly growing in size . Within one night it grows by almost 40,000 pages where in normal case should be between 1000 - 2000 pages daily. Do you think because of temporary tables stuck in the process and how do I elimi…
Re: CLEANERS
"William Rice" <ricew@operamail.com> wrote in message news:90isbi$1j4$1@nnrp1.deja.com... > In article <3a2c1dd0@news.iprimus.com.au>, > "Andrew Hamm" <ahamm@sanderson.net.au> wrote: > > hanna_shaw@my-deja.com wrote in message > <90gti5$gso$1@nnrp1.deja.com>... > > >Hi, > > > >…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
RE: What does it mean "Fuzzy Checkpoint"?
From: "Parker, Jack" <JParker@engage.com> > >This is the checkpoint standard that was promulgated by the GOP. It's how >you do checkpoints associated with fuzzy math. Yes, but do we have to live with repeated recounts of flushed buffers? _______________________________________…
What does it mean "Fuzzy Checkpoint"?
DH wrote: > > Hi all, > > I'm moving from IDS 7.30 to IDS2000 and still learning with it. There is > some new term as "Fuzzy Checkpoint" in online.log that I don't see in IDS > 7.30 for example: > > 17:00:14 Fuzzy Checkpoint Completed: duration was 0 seconds, 77 buffers > not f…
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…
Stalled Checkpoint
Hi~ I have installed IDS 7.31.TC6 on Win NT 4.0 SP 5. This is my first time working with Informix on NT. I have used Informix on UNIX in the past. I successfully installed and initialized Informix. I am trying to force a checkpoint using 'onmode -c', but I get the following …
during a checkpoint
I seem to read somewhere that queries are not blocked during a checkpoint. Is this correct ? If not, what operations are not blocked ? Thanks, Thanh Sent via Deja.com http://www.deja.com/ Before you buy.…
fuzzy checkpoint
Actually, fuzzy checkpointing should not directly affect cache percentages and the indirect effect should be slight. Just because 7.xx flushed most of the dirty pages (7.31 actually partially implements fuzzy checkpointing without fanfare) does not mean that the pages are not av…
Checkpoint Blockage
Greetings, I am searching for suggestions on the best approach to find the resource(s) that are preventing a checkpoint from completing. Occasionally, our 7.31.FC7 instance will be blocked indefinitely during a checkpoint request. The most recent incident did have a thread /ses…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: onconfig advise please
> By looking at ovbuff and the BTR (Buffer Turnover Rate) or BTF (Buffer > Turnover Frequency) you can determine whether the problem is not enough > buffers or LRU contention. If LRU contention increase LRUS and CLEANERS if > possible, if they are already maxed out (128 on 7.x/9…
Checkpoints
I have seen recommendations that setting LRU's 128 can, among other changes, help to reduce long checkpoints of 10, 15, 20 or more seconds. For the most part this recommendation seem to be for 7.3x versions of Informix. Is there a problem with using the same setting for 7.24 ver…
RE: Checkpoint
sorry for that...I have asked the mail server administrator to do something for me. Hopefully, this mail that you guys receive is in text format only. Sorry for any inconvenience caused. BTW, thanks for all the input from you guys. Regards, Jason -----Original Message----- Fro…
RE: Checkpoint
From: "Watson, Paul" <Paul.Watson@aggregate.com> > > > Jason , > > > > This is only a text group. PLEASE , PLEASE do not send > > MIME/HTML versions > > across. > > > > 3 reasons why I say this. > > > > 1. Because you duplicate the message > > 2. A number of people have already a…
RE: Checkpoint
Nah. I think I disagree with the last point. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: 29 August 2000 14:17 To: Paul.Watson@aggregate.com; informix-list@iiug.org Subject: RE: Checkpoint From: "Watson, Paul" <Paul.Watson@aggregate.com>…
RE: Checkpoint
> > Jason , > > > This is only a text group. PLEASE , PLEASE do not send > MIME/HTML versions > across. > > 3 reasons why I say this. > > 1. Because you duplicate the message > 2. A number of people have already asked you to stop posting > mail in MIME/HTML > format. > 3. The mos…
Re: Checkpoint
From: JasonYLPang@pg.SLR.com > >Why the checkpoint take longer time to complete? Is it something not right >at onconfig file??? Your ONCONFIG looks fine as far as checkpoints are concerned, I suspect the server was just very busy for some reason. You might want to set RESIDENT …
RE: Checkpoint
This is a multi-part message in MIME format. ------=_NextPart_000_0047_01C011DA.D9F92360 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit CheckpointJason The checkpoint duration is probably a result of the application. The checkpoint must wait u…
Checkpoint
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_01C01166.DFA6EBAE Content-Type: text/plain; charset="iso-8859-1" Hi all, Why the checkpoint take longer time to comple…
Speeding up DBIMPORT
I am planing to do dbexport/drop database/dbimport. Tables are not fragmented and indexes are in separate dbspace. I will: 1. change LRU_MAX_DIRTY=80, LRU_MIN_DIRTY=40,LTAPEDEV=/dev/null 2. create database without logging 3. create tables without indexes and constraints 4. load d…
long checkpoint
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_000_01C007B8.97F708A0 Content-Type: text/plain; charset="iso-8859-1" I have just recently migrated from IDS 7.31.FC4XE to I…
Long interval without Checkpoint
My checkpoint is triggered each 300 seconds so how is possible this interval ? 18:42:00 Checkpoint Completed: duration was 0 seconds. 19:12:00 Checkpoint Completed: duration was 0 seconds. because there weren't any dirty pages ? (IDS 7.30) Thanks, Manel Falcó…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
RE: Long Checkpoints, balancing network traffic across multiple Aliases
Let me answer my own question by saying that I beleive I am experiencing a problem with a session being stuck in a critical section causing a checkpoint to wait. Andrew -----Original Message----- From: Andrew Ford [SMTP:aford@simpletel.com] Sent: Wednesday, August 02, 2000 9:51…
RE: Long Checkpoints, balancing network traffic across multiple Aliases
Another problem that we are having is that every 12 hours or so we see a really long checkpoint. At first it was 25 seconds then 36 seconds, now we have a 41 second checkpoint. It's very strange, every thing seems to be humming along nicely, then BAM - a virtual slap in the fac…
Re: Regarding LRU,
From: Aboobacker V V <aboo@syd-co.au.dhl.com> > >May be a stupid question !!!, Pass. >Why there is a requirement for more than one LRU queue in Informix >Online. >With one LRU queue pair itself, cann't the buffer be managed?? It can, but the issue is do you want your hundreds…
Regarding LRU,
Hi All, May be a stupid question !!!, Why there is a requirement for more than one LRU queue in Informix Online. With one LRU queue pair itself, cann't the buffer be managed?? Regards Aboo…
Checkpoint/LRU question
Hi, Does a checkpoint block the users sessions ? As well when buffers are flushed via MAX LRU ? Does A LRU-flush trigger an ordinary checkpoint or is it different ? and is it written on the online.log ? It seems that not ... I'm not sure ... Thanks in advance, Manel Falcó…
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…
Re: Checkpoint duration
Lower the LRU_MAX_DIRTY and LRU_MIN_DIRTY so that LRU writes will occur more frequently. The only trade-off is that you'll incur more disk i/o, but sessions will not wait. Unlike checkpoints which basically blocks sessions from entering critical section. DOn "Farmer, Byrd G - C…
Checkpoint duration
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_01BFDD2B.77C69B20 Content-Type: text/plain; charset="iso-8859-1" I am having an issue with checkpoints taking an extrem…
Re: Slowness
From: Boscia <rwboscia@worldnet.att.net> > > onstat -F > >Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 13 days >17:07:49 -- 491520 Kbytes > >Fg Writes LRU Writes Chunk Writes >47 5706029 67736088 You *definitely* need to drop LRU_MAX_DIR…
Number of LRUs, Cleaners & Buffers
In article <394A3B61.B8818F70@styria.com>, Thomas Stainer <tstainer@styria.com> writes >I'm running informix 7.30 UC6 on a 4cpu Server (the engine is db- and Which platform, sun, HP, AIX, NCR?? >app-server, 3 cpus are affinated, AFF_NPROCS=3), acutally I have 8 >LRU-Queues an…
Re: Slowness
From: Leonids.Voroncovs@dati.lv [Lots of good stuff snipped] > > LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit > > LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit > >MAX / MIN = 1 / 0 will be good enough. However, on some machi…
Re: Slowness
Leonids.Voroncovs@dati.lv wrote: > > "Art S. Kagel" wrote: > > > If you still have BR problems you can try increasing BUFFERS also > > and then you have to use the undocumented ONCONFIG parameter LRUPRIORITY > > to alter how clients select LRU queues to reduce contention. > > Oop…
Initiating Checkpoints manually
Vinod Bhansali wrote: > Hello friends, > > I want to tune the checkpoint duration by trying different values for the > ckptintvl. CKPTINTVL is not normally used to tune one's checkpoint duration, although in theory, like the physical log size, it can be used. Rather, in the tu…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
RE: What is bufwaits (onstat -p)
>===== Original Message From "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> ===== >"Art S. Kagel" wrote: >> >> The bufwaits indicates when a thread has to wait to read a page into a >> buffer from disk usually this is caused by the LRU Queue to which the thread >> has hashed to …
Re: What is bufwaits (onstat -p)
"Art S. Kagel" wrote: > > The bufwaits indicates when a thread has to wait to read a page into a > buffer from disk usually this is caused by the LRU Queue to which the thread > has hashed to acquire a buffer being locked by another thread trying to do > the same thing or needing…
RE: What is bufwaits (onstat -p)
I have one question. From your message: -- Pages that get both update and read activity or pages that get updated by multiple users are the source of bufwaits. The odds of two users with incompatible access modes hitting the same page at the same time is little affected by the …
Re: What is bufwaits (onstat -p)
Bufwaits have little or nothing to do with LRU contention nor with reading in a page from disk. As Vinod said it does occur when one has to wait on a buffer because another is accessing it. The counter is not incremented because one waits to get access to an LRU. It is increme…
What is bufwaits (onstat -p)
The bufwaits indicates when a thread has to wait to read a page into a buffer from disk usually this is caused by the LRU Queue to which the thread has hashed to acquire a buffer being locked by another thread trying to do the same thing or needing to move a buffer from the 'clea…
LRU queues
_______________________________________________________________ This message and any attachments are 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 not…
Long checkpoints
Hi, I would welcome suggestions on how to lower the checkpoint durations at one of our sites. Relevant ONCONFIG parameters are given below. All chunks are cooked files. At checkpoint time, there are on the average about 500 dirty buffers to flush. Thanks. Alanoly Andrews. ===…
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…
Fuzzy checkpoints.
"Art S. Kagel" wrote: > I'm getting a headache. Roll out the acetaminophen :-) > OK, so there are two separate issues here. One is Physical logging needed > at all, which it appears I brought up and not William. I agree with > Rudy's assessment that physical logging is need…
LRU, Cleaners and num disks
In article <38FCCB86.D88D17A1@auckland.ac.nz>, Bridget Reitsma <b.reitsma@auckland.ac.nz> wrote: > Hi, > > Does some one out in informix land have a magic formula of working out > what the raito of LRU's and cleaners should be? Is is dependant on the > number of disks? I read…
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…
checkpoint spikes
Now that long checkpoints topic is in discussion I would like to get some help too. We are also getting into a similar problem with long checkpoints (over 13 secs sometimes). Long checkpoints in our case only happen once in a while. Our LRU_MAX and LRU_MIN are at 2 and 1. Our che…
Re: Long Checkpoints
Ulrich Eckhardt wrote: > > "Mark D. Stock" wrote: > > I don't subscribe to the idea of matching your physical log size to your > > average work load. What happens when your work load is a bit high? You > > have performance problems. > > > > I always create my physical log too big…
Re: Long Checkpoints
In article <38BE266E.C164B425@transcom.de>, Ulrich Eckhardt <Ulrich.Eckhardt@transcom.de> wrote: > Hi, > > i have a problem with long checkpoint runs on an informix 7.30 UC 10 > running on linux. (Machine is a PIII 500 with 512 MB Memory). > > Sometimes checkpoints takes 15 to …
Long Checkpoints
Hi, i have a problem with long checkpoint runs on an informix 7.30 UC 10 running on linux. (Machine is a PIII 500 with 512 MB Memory). Sometimes checkpoints takes 15 to 25 seconds. During this times i have approximately 2000 to 2300 dirty LRU queues. an onstat -FR (with only 2…
Shared Memory Parameters?
I am working with an existing database that has some onconfig parameters that I am questioning. One of our problems is extents, but another reason we get hammered during the day might be the following shm parameters. OL Engine Vers. 7.31 on HP 9000 Aprx. 400-600 users Database …
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…
When are checkpoints initiated
I know there are a number of things that can cause a checkpoint to be initiated. The one I'm concerned about is when a checkpoint is initiated because your <blank> is 75% full/dirty. Is <blank> buffers, logs (logical or physical), or log buffers. Any help would be appreciated!…
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 …
Re: checkpoints taking as much as 25 secs
From: "Tam McLaughlin" <tamm@scotlegal.com> > >LRUS 8 Try more LRUS, something like 50. >LRU_MAX_DIRTY 20 >LRU_MIN_DIRTY 15 Try dropping these to 2 and 1, respectively. HTH. ______________________________________________________ Get Your Private, Free Email at…
Re: checkpoints taking as much as 25 secs
Hi Tam, try to increase CLEANERS in ONCONFIG (6 -> 10), and decrease LRU_MAX_DIRTY and LRU_MIN_DIRTY, and also the range of them. Example: LRU_MAX_DIRTY 10 LRU_MIN_DIRTY 8 But I think if you have the most checkpoints under 10 seconds it is OK. R…
Re: Anyone using ISPY?
From: "Neil Truby" <ntruby@netcomuk.co.uk> > >You don't miss a trick, do you Randy?! Personally, I think he's a spambot. He's too damn stupid and thick skinned to be human. >I think in future i'll scan the pages, never posting everything except to >say, in response to a questio…
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…
Long checkpoints
Greetings all..... I watch this group every day and sometimes offer my help. Now it is my turn. I have a system that is generally a lightly loaded system but runs a batch load a couple times a day. During these loads, checkpoints get horrendous averaging 60 seconds to flush abo…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Fg Writes
lower LRU_MAX_DIRTY, LRU_MIN_DIRTY. Make checkpoints more frequent either through CKPTINTVL or resizing the physical log. Increase BUFFERS, CLEANERS, LRUS. Those are the general answers (I can think of right away). LRU_M[IA][NX]_DIRTY - Control when your buffers are cleaned o…
No respons from server process
else and is stop record in file online.log last record 20.15:58 Checkpoint Completed: duration was 0 seconds now 18:43 next day Azat…
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…
Page cleaner configuration
Top Cat wrote: > > I have heard that you should set the CLEANERS configuration variable equal > to the LRUS variable. I have also heard that you should set CLEANERS equal > to the number of chunks in the instance. Which is it? WELLLLLL..... There are several reasons for the d…
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.…
buffwaits & lockwaits
Dhanesh, Please post onstat -p output showing the problem. In general one can control the number of lockwaits by changing table lock modes from page to row and by reducing the duration of locks in applications programs. To reduce bufwaits one can increase the number of buffers…
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.…
Checkpoint duration
Is there a table which can be queried to get the last checkpoint duration?…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problems with Informix on NT - Please Help
You had a disk error on the 6th at 17:07:38 which may or may not have been corrected and your ONCONFIG file has ONDBSPACEDOWN=2 which means pause all operations and wait for the chunk to be repaired and marked back online. Does onstat -d show any chunks and/or dbspaces with a 'D…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Re: Tunning.
From: "Bashar Chalabi" <bashar@ctl.com> > > >>LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit > >>LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit > > > >For OLTP, try decreasing both of these. Try 2 and 1 or 2 and 0. > >Why? > >The …
Re: Tunning.
>>LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit >>LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit > >For OLTP, try decreasing both of these. Try 2 and 1 or 2 and 0. Why? The only reason I can think of is to reduce checkpoint tim…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Re: 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: Raw vs. cooked
A lot of the performance advantage of cooked compared to raw has to do with UNIX filesystem buffering/engine buffering. If the engine's bufferpool space is small compared to the total real memory space, then I would expect that cooked filesystem would significatly outpreform raw…
tuning checkpoint duration
I know this is a common question, but I've tried to implement the common wisdom and I'm still having trouble. I'm running IDS 7.3TC7 on Windows NT 4.0 sp3. I've got 290K buffers, 15 LRUs and 5 cleaners. LRU_MAX_DIRTY is 1, LRU_MIN_DIRTY is 0. Checkpoints are every 15 minutes. …
Problems with oncheck in IDS 7.23
Hello everybody I�m running IDS 7.23 UC6, under AIX 4.2.1 We decided to do a complete oncheck of the database during the night. There is no other process running at the same time. We noticed that the checkpoint interval became extremely high during the oncheck activity, and we …
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: Parameters LRU_MAX_DIRTY & LRU_MIN_DIRTY - UNIX
"John (Jack) O'Hara" wrote: > Our Informix Dynamic Server 7.22 running on Sun Solaris comes to a crawl > when usage reaches high levels. However, I've noticed that "SELECTS" > continue to be quick while UPDATES and INSERTS can take from 20 to 60 > seconds each. I noticed that …
Re: Parameters LRU_MAX_DIRTY & LRU_MIN_DIRTY - UNIX
From: "John (Jack) O'Hara" <johara@writeme.com> > >Our Informix Dynamic Server 7.22 running on Sun Solaris comes to a crawl >when usage reaches high levels. However, I've noticed that "SELECTS" >continue to be quick while UPDATES and INSERTS can take from 20 to 60 >seconds each.…
Parameters LRU_MAX_DIRTY & LRU_MIN_DIRTY - UNIX
Our Informix Dynamic Server 7.22 running on Sun Solaris comes to a crawl when usage reaches high levels. However, I've noticed that "SELECTS" continue to be quick while UPDATES and INSERTS can take from 20 to 60 seconds each. I noticed that our DBA has the LRU_MAX_DIRTY paramet…
Checkpoints - a mystery
Sorry if I have already posted this once already...we are having problems with our news server... HP-UX 10.20 running IDS 7.24.UC5 We have been having isolated problems with checkpoints - see below. During the lengthy checkpoints, obviously no users can perform any update routi…
Re: Need Help about Page Cleaner Time Out
As you are doing a load, there are too much work to be done by the cleaners, they try to clean the dirty pages but the load generates more work and so the cleaners couldn't clean a LRU at the specified time (2 min). To avoid it you could issue checkpoints more often when you are…
Need Help about Page Cleaner Time Out
Hi All- I am running Informix 5.10 on Solaris 2.6. I created new instance and while loading data with either dbimport or tbload my informix log shows that 15:31:04 On-Line Mode 15:54:26 ERROR: page cleaner # 2 has timed out 15:56:19 ERROR: page cleaner # 3 has timed out 15:5…
checkpoint duration too long
plogdbs: 79.8M llogdbs:600M datadbs:1000M my ONCONFIG file: PHYBUFF 128 LOGBUFF 64 CPKINTERVAL 300 onstat -m ...checkpoint duration was 8 [7-10] seconds How can I reduce the checkpoint duration?Thanks!…
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: Checkpoint take so long
Taking on board what Kevyn has already said, it looks like there was some sort of data load happening during the long checkpoints. I also noticed that your logs aren't being archived. Whats the story ?? What are your current settings for LRU_MAX/MIN_DIRTY & CHKPTINTVL and how bi…
Re: onstat -F output
This reinforces the idea from yesterday, that you do not have enough pages updated between checkpoints to force LRU writes, given your current settings. Note that during the measured period, you have only 66,897 page writes. Owing to the imprecise amount of time ('almost an hou…
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: onstat -F output
> Hi all, > I have Informix 7.30.UC2 running on SCO 5.04 and have noticed this on > my onstat -F output > > Fg Writes LRU Writes Chunk Writes > 0 0 18463 > > address flusher state data > 874484c4 0 I 0 = 0X0 > 87448974 1 …
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
> 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 There's a blurb about i…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
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?…
checkpoint time > 15 sec.
michael wallace wrote: > > I am currently running informix 7.3 on an IBM S70 with 2GB men and 4 > CPU's, and 10 mirrored ssa 4.5 GB disks. > CHKPTINVL 300 > LRU 8 > LRU_MIN_DIRTY 2 > LRU_MAX_DIRTY 3 > PAGE_CLEANERS 4 > > any suggestions on improving checkpoint time…
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 …
Decreasing Checkpoint Lengths.
What parameters have the greatest effect on checkpoint lengths? Currenly I have my checkpoint interval at 30 seconds, and a peak times checkpoints are still taking over 10 seconds. We're running multiple configurations on Workgroup Server. Some on WIN NT, Some on SCO, and some…
Checkpoints not in online.log
We're using IUS 9.14.UC2 on SunOS box. I can use onmonitor to force a checkpoint. It comes back and tells me that the checkpoint completed. However, when I look in the online.log file, it doesn't show up. It looks like the system hasn't done any checkpoints for hours. Our CKPTIN…
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…
Page cleaners & LRU contention...
Hi guys and gals, ( On HP-UX 10.20 K-Series 6 CPU ODS 7.24UD6) I recently upped the number of page cleaners on a real time system with 16 chunks from 8 to 16. ( it seemed like a good idea ) It had 8 LRU queues LRUMAX/MIN at 8 and 4 and 30,000 BUFERS . i.e a ma…
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 >…
Re: Reducing Checkpoints duration
Make the Chkptintvl much higher, like 600. This will force the engine to do the cleanups separate from during the checkpoints. Please respond to cam@codetel.net.do To: "International Informix Users Group (E-mail)" <informix-list @ iiug.org> cc: (bcc: Kate Tomchik/IS…
Reducing Checkpoints duration
Hello all! I'm using INFORMIX Dyamic Server Workgroup Edition 7.20.UC2 on SCO OpenServer and I'm getting checkpoints that lasts until 20 seconds . I reduced LRU_MAX_DIRTY and LRU_MIN_DIRTY to 10 and 5 respectively and the CHKPTINTVL to 60. I'm still getting checkpoints around 1…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: Checkpoint takes long
Kai Shen <shen@acer.de> wrote in article <36075023.82CCB1AD@acer.de>... > Hi, > > on our SCO 5.0.4 machine we are running ODS 7.20 UC3. During the day > when appr. 60-80 persons are using the machine, we permanently > experience checkpoints that take 10 seconds or longer. I tried…
Re: Checkpoint takes long
Kai Shen wrote: > on our SCO 5.0.4 machine we are running ODS 7.20 UC3. During the day > when appr. 60-80 persons are using the machine, we permanently > experience checkpoints that take 10 seconds or longer. I tried > changing the time between checkpoints from 1 minute to 10 min…
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…
Checkpoint takes long
Hi, on our SCO 5.0.4 machine we are running ODS 7.20 UC3. During the day when appr. 60-80 persons are using the machine, we permanently experience checkpoints that take 10 seconds or longer. I tried changing the time between checkpoints from 1 minute to 10 minutes and back to th…
Re: Tunning question
You can start by decreasing the LRU MIN/MAX to arround 3-6. This will increase the number of writes that occure between checkpoints, but will make the bufferpool "cleaner" when the checkpoint actually occurs. Madison Pruet…
Re: Page cleaners
jasonharris@my-dejanews.com wrote: > > All, > > I have one question about page cleaners. As they run on CPU VP threads what is > the value in having more page cleaners that CPU VP threads? You need to look at a number of concepts to answer that. None of which I'm going to detail…
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: Reducing checkpoint intervals...
Hi all, If I'm wrong please correct me. Informix docs say that, i) Page cleaning (by CLEANERS) begins when LRU_MAX_DIRTY percent of the buffers managed by a queue are modified. ii) Page claning is no longer required when LRU_MIN_DIRTY percent of the buffers in an LRU queue are …
Database Recovery?
In reading about Online Dynamic Server, it states that the database will rollforward to the last checkpoint when the server is brought to online from offline if the server crashes. If I do a restore from the day before will it read the logs and bring it up to the last checkpoint…
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: Magic? Or good design?
On Tue, 18 Aug 1998, Neil Truby wrote: > Let's assume I'm backing up a large database server with a level 0 > archive, which will take 2 hours. I kick off the archive at 0400. The > pages that make up the instance are therefore being copied to the > archive tape at anything fro…
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: Informix System Hangs
> >We are running Informix version 7.24.UC5-1 on Solaris 2.6 on a Sun E5000. We > >are having multiple daily "pauses" of the database, where it seams a single > >oninit starts sucking up all the CPU time, and nothing else moves. After > >about a 2 minute period, the system retu…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Re: latch/lock , buffer - questions.
Sadagopan, Sathish wrote: > > Hi All, > 1) When a thread needs a buffer to read in data , does it acquire any > latches/locks.How is the allocation done ? This is all explained in the Administrator's Guide. Basically the thread hashes into the LRU queues selecting a queue at …
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: Couldn't drop dbspace
Hi Ivan, verify in the output of "oncheck -pe" the chunk entries of the mentioned dbspace. If the dbspace is really empty only reserved, chunk free list and TBLSPACE TBLSPACE pages should reside in the dbspace. If this is true the only way you have is to reorganize your complete…
Couldn't drop dbspace
Hi Gurus! I've got a very strange problem: I'm using OnLine 7.10UC1 in SCO3.2.v4.2. When I'm trying to drop a non-root dbspace, Informix says that this dbspace is not empty. Onstat -d says that this dbspace really has non-empty pages (a lot of pages!!!). BUT I'm sure, that there…
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…
checkpoint duration
I have a serious problem with checkpoint duration which cause my posting process to almost double in duration because of the amount of time wasted on checkpoints. Here is a a sample of the duration take directly from the online log file. 05:32:00 Checkpoint Completed: duration…
(Chkpt Required)
My Online 7.13 occasionally locks up with a (Chkpt Required) message on the onstat - header line. The logs are not full, but the db just sits and waits. I think this can be cleared with a full backup (ontape -s -L 0). Can someone explain this behavior. And - checkpoint interv…
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: Onstat -R
Hi Roger, The onstat -R commadn give you the listing of the LRU queue's and there status. Eachr LRU queue consists out of two parts. A free and a modified list. The letters f and m indicate wheter it is a f(ree) or m(odified) queue. The LRU length is the numer of pages that are …
Re: Onstat -R
rbruenin wrote: > > Can someone explain the onstat -R headings.. Is the percentage free or > used. Been digging thru the texts.. examples but little explanation? Sure. > INFORMIX-OnLine Version 7.24.FC4 -- On-Line -- Up 4 days 17:40:47 -- > 36320 Kbytes > > 8 buffer LRU queu…
Re: Onstat -R
rbruenin <rbruenin@concentric.net> offerred: +Can someone explain the onstat -R headings.. Is the percentage free or +used. Been digging thru the texts.. examples but little explanation? + +INFORMIX-OnLine Version 7.24.FC4 -- On-Line -- Up 4 days 17:40:47 -- +36320 Kbytes + +8…
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: +…
checkpoint interval
Dear All, I'm running INF 7.23UC1 with total database is 76 GB. We are happy with our configuration, but since Last Monday, our online perfomance going down and also interval of checkpoin sometime took so long, about 50-170 second. We have checked no big transaction, no long tra…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Re: LRU Parameters
Also sprach "Art S. Kagel" <kagel@bloomberg.com> : :By the way: Joao's CLEANERS value is much too low. With 32 LRUs one :should have 32 CLEANERS unless one has > 32 chunks then add more than :32 cleaners. You should have: #Chunks <= #CLEANERS >= #LRUs to :minimize checkpoint …
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: PAGE CLEANERS
Also, At the log file I don�t get any error message, only the regulat checkpoint ones.…
waiting for checkpoint
<HTML> Sometimes informix is waiting for a checkpoint, thus also the users of the application. <BR>What is the reason for this ?? <BR>I asume it is something in the application but how to indentify this and can I set a trigger <BR>that performs the checkpoint when this even…
Re: Page cleaner error
If you are getting page cleaner time-outs, you're most likely running version 5.x of On-Line. In that version page cleaners have a timeout value of 120 seconds. Meaning the page cleaner has 120 seconds to get it's work done (ie. clean from LRU_MAX_DIRTY to LRU_MIN_DIRTY, checkp…
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: Page cleaner error
In article <6ddo4a$plm$1@nnrp1.dejanews.com>, williema@okzim.gaia.co.zw writes >I keep getting the following error in my online log - > ERROR: page cleaner #0 has timed out. >What causes this error and what does it affect ?. > >-----== Posted via Deja News, The Leader in Interne…
Re: KAIO vps, and bufwaits
David Williams wrote: > In article <6bq06q$8tp$1@news.xmission.com>, Art S. Kagel > <kagel@ns1.bloomberg.com> writes > >On Mon, 9 Feb 1998, Tony Tyrwhitt-Drake wrote: > >When a thread needs a buffer to update and the page is not already in > >the buffer pool the thread uses a …
Re: KAIO vps, and bufwaits
In article <6bq06q$8tp$1@news.xmission.com>, Art S. Kagel <kagel@ns1.bloomberg.com> writes > >On Mon, 9 Feb 1998, Tony Tyrwhitt-Drake wrote: > >> Art, >> >> I was intrigued by your mention of a bug in the LRU queue selection. But >> mostly by the number of queues you mentioned. P…
Re: KAIO vps, and bufwaits
Even LRUS need love... How many CLEANERS and LRUS per CPU VP are you running? I've been using the "rule" of CLEANERS = LRUS = CPU VPs. What you're saying about the hashing makes good sense, I'm just trying to find a starting point for our machines (one has high BUFWAITs > 18%)…
Re: Re[2]: KAIO vps, and bufwaits
Any special reason your suggest prime? Art S. Kagel wrote in message <6bq77p$k3r$1@news.xmission.com>... > >On Tue, 10 Feb 1998 davin_harvey@dsti.co.uk wrote: > >> Art >> >> Just a small question. Is there any reason for keeping the number of >> LRU queues to a p…
Re: Re[2]: KAIO vps, and bufwaits
On Tue, 10 Feb 1998 davin_harvey@dsti.co.uk wrote: > Art > > Just a small question. Is there any reason for keeping the number of > LRU queues to a power of two? Everybody seems to use 8,16,32, etc. > Just habit, or what? Naw, just dumb programmer habits. …
Re: KAIO vps, and bufwaits
On Mon, 9 Feb 1998, Tony Tyrwhitt-Drake wrote: > Art, > > I was intrigued by your mention of a bug in the LRU queue selection. But > mostly by the number of queues you mentioned. Personally, I have never set > LRUS to a number anything like as big as 32, let alone 128, prefering…
Re: Extended checkpoint times (Blocked Checkpoint)
Hi-All, Since I got a few E-mail asking which patch we applied I thought I will post to the answer to C.D.I instead. The patch we applied is "PHKL_10634". -- Have a nice day Felix K. Mathews mailto:fmathews@systems.dhl.com…
Re: Extended checkpoint times (Blocked Checkpoint)
Felix Mathews IBS CONTRACTOR wrote: > Eric_Melillo@agsea.com wrote: > > > We've had Blocked checkpoints on 7.13 -- but it has always been a known bug > > -- we get two "C"urrent logical logs, a big no-no. It is a dial-in > > offense. We're moving to 7.23 as quickly as possible…
Re: Another checkpoint situation
At checkpoint time one page cleaner is assigned to queue up the addresses of modified buffers to the global file descriptors for its assigned chunk. (This assumes that you are not using Kernel IO) It appears that all of your work between the check- point was for one chunk and th…
Slow checkpoints
Hi, I run a query on Informix On-Line 7.23UC2 and I go from 1 sec. checkpoints to 30 sec. checkpoints. Any explanations? The table is partitioned and it is very large (46 million rows) Any explanations? Can I avoid this situation? select count(*) total,count(*)*.75 percent from…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
Re: Extended checkpoint times
I had a problem in November of checkpoints blowing out to 10 minutes or so = during the evening like your manifestation. I was advised from tech support that checkpoints can blow out two ways. 1. When checkpoint is requested, Online freezes all sessions for users not = in a cri…
Re: Extended checkpoint times
check your lru parameters, I have mine set at 2 and 1. anonymous wrote in message <34C53870.964739C4@somwhere.com>... >Hi, > >We are trying to investigate a series of overly long checkpoints on one >of our informix databases, here is >a snippet of the online.log file detailing th…
Extended checkpoint times
Hi, We are trying to investigate a series of overly long checkpoints on one of our informix databases, here is a snippet of the online.log file detailing the events: 21:16:55 Checkpoint Completed: duration was 76 seconds. 21:22:04 Checkpoint Completed: duration was 6 second…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Logical Logs -Explain
In article <3485C2BE.73FA@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >Almost, Mark. It would be more accurate to say that a foreground write >happens when an application thread needs a buffer to write into and >cannot get access to one after a specified number o…
Re: Logical Logs -Explain
Mark Collins wrote: > > > Regarding Flushing of logs/buffers to disk > > 1)What is a FOREGROUND WRITE? > A foreground write is a very bad thing for performance. Basically, there are three ways > for modified pages to be written back to disk from the buffer cache: > 1.…
Re: Freeing Logical Log with Status U
What's LOGFILES set to in your onconfig file? Try forcing a checkpoint? Jon.…
Re: Q about LatchWaits, BufWaits and LRU-Writes
Dirk Scheer wrote: [SNIP] > from 512 MB to 1 GB of memory and I've increased the BUFFERS from 40000 to > 200000. Now the performance is ok. But I wonder why the values of LatchWaits > and BufWaits are constantly growing and if this have still negative affects on > performance. S…
Checkpoint blocked ?
Hi, I had the same problem with ODS 7.14.UD6.on AIX 4.2.1. It has happened = twice this week. Everybody just hang and i could not even do a onmode -y properly. There= was a message saying no respond from the server. And when i did an oninit, the system= just hang on Logical Re…
Checkpoint blocked ?
On AIX 4.2 with OWS 7.20.UC2, I had a deadlock situation twice in a short time : nobody could work, and an onstat gave the message : checkpoint required, blocked. I had to stop Informix (onmode -k) and restart (oninit). I guess that some user threads where blocking the checkpoin…
Re: es posible subir tablas a ram
Hola userios, (I'll not burden you with more bad Spanish) >if informix permit to locate a table in ram in transparent way for the >application. This is not explicitly possible in versions <= 7.2x, though frequently used tables should remain in the buffers via the LRU queueing…
Re: Performance problems on AIX 3.2 (RS6000)
In article <340C3A7E.7B24@bellsouth.net>, Daniel Gurian <dgurian@bellsouth.net> writes > >Has anyone seen this problem; I am looking for a solution >to this problem: Check points are taking 20 to 30 seconds >to complete. This is causing all processes to wait until the >check poi…
Re: onstat -u, B-flag
Alexander Selg wrote: > > Hello All ! > > The command "onstat -u" gives some information about the userthreads. In > the 2.column you can see the flags to each thread. The 1.position > indicates the resource a thread is waiting for. > My question is: if there is a "B" on the 1.po…
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: Informix halts for no obvious reason ?!
Milen Metodiev wrote: > > Hi, folks. > > This is the umpteenth time this happens, so I wonder > if anyone can help. Even a few hints will be more than > welcome. > > When the system is busy enough ( 20-30 users of Informix ) > and people start issuing "heavy" queries, Informix fa…
Re: When does bufwaits get incremented ?
tony edwards wrote: > > Hey, > I've been trying to track down some information about when bufwaits is > incremented. I found the following in the ODS Admin guide... If after a limited number of attempts to find an unlocked queue, no free buffer has been found the thread …
Re: When does bufwaits get incremented ?
tony edwards wrote: > > Hey, > I've been trying to track down some information about when bufwaits is > incremented. I found the following in the ODS Admin guide... If after a limited number of attempts to find an unlocked queue, no free buffer has been found the thread …
Re: Mirroring
Jay Aymond wrote: > Is there some rule for defining how many LRU queues to have for a > certain number of buffers? Well, this came up in the optimization tutorial. One thing that we're going to try, as advised, is ramping up the queues to 128 for "large buffer" installs (or al…
Re: Mirroring
Jay Aymond wrote: > > "Art S. Kagel" <kagel@bloomberg.com> wrote: > > >Jay Aymond wrote: > >to wait for page flushes during checkpoints. I run my busiest servers > >with > >LRU_MAX_DIRTY=3 and LRU_MIN_DIRTY=0 90% LRU Writes, these puppies fly! > > > >Art S. Kagel > > Thanks for …
Checkpoint problem.
Hello, guys! Our Informix server has stoped three times for a month. tbstat shows that all user processes (except two) are waiting for process "ckpt" which seems to be a checkpoint process. I noticed that in the Informix log file there were missing checkpoints for about 30 minut…
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…
Checkpoints in online 7.13
Hello , Does anybody know where in sysmaster database I can find informations about checkpoints, particularly in which log file the last checkpoint is ? Thanks, Jean-Francois.…
Re: Too-frequent checkpoints; which parameters to check?
Actually, if performance is important this is what you want. The alternative is to have them less often but for longer periods of time. Since users are completely blocked during the checkpoint, they would not have no response for 5 or 10 seconds (for example) which can seem lik…
Re: Too-frequent checkpoints; which parameters to check?
In article <331FF103.7F5C@lava.net>, Bob Cunningham <bob@lava.net> writes >I've got a situation with On-Line 7.22 (SPARC, Solaris 2.5.1) where >we get flurries of checkpoints at short intervals, during >some update periods that look like: > >23:35:07 Checkpoint Completed: durat…
Re: 2 gig per raw space
In article <331F9977.613D@inconnect.com>, Thuc Nguyen <thucn@inconnect.com> writes >Hi everyone, > >I am with Online 5.03 on HP 9.02 > >My "Sr" DBA did not have full confidence in what I told him. > >I have seen the previous postings but did not save them. I need to prove >him th…
Re: Too-frequent checkpoints; which parameters to check?
Bob Cunningham wrote: > > I've got a situation with On-Line 7.22 (SPARC, Solaris 2.5.1) where > we get flurries of checkpoints at short intervals, during > some update periods that look like: > > 23:35:07 Checkpoint Completed: duration was 2 seconds. > 23:35:14 Checkpoint Comp…
Too-frequent checkpoints; which parameters to check?
I've got a situation with On-Line 7.22 (SPARC, Solaris 2.5.1) where we get flurries of checkpoints at short intervals, during some update periods that look like: 23:35:07 Checkpoint Completed: duration was 2 seconds. 23:35:14 Checkpoint Completed: duration was 1 seconds. 23:…
Re: Slow system ?! - using Informix 7.x on Sun Sparc 1000
In article <5ceths$m9u@cssun.mathcs.emory.edu>, Mario Estrada <marioestrada@guate.net> writes >Hi George! > >Your problem is with the CHECKPOINT DURATION, and the factors affecting = >this period of time are: 1) How many dirty pages must be written to disk = >from the buffer cach…
Re: numerous checkpoints
The two most common reasons for checkpoints are 1) the checkpoint interval has been reached and 2) the physical log is over 75% full. If the checkpoints appear to be closer than the checkpoint interval, I would guess that your physical log file is too small. Madison Pruet…
numerous checkpoints
Hi, I don't understand reason why checkpoints occur so frequent. From my point of view, there are not any event that initiate a checkpoint (events described in INFORMIX-Online Dynamic Server Administrator's Guide Version 7.1 12-52). Could someone tell me another event, that is no…
Re: What do you know about the btclean thread
The btclean cleans up the index entries which have been marked for deletion. It is normally asleep untill it is activiated by another thread. There is a queue containing a list of all leaf pages which have items marked for deletion. When the btclean thread is activated, it runs…
Re: Btrieve problems. Please help!!!!
Kevin Shank <kevin@gcs_npd1.dscinet.com> wrote: >I cannot help you with this specific problem, however I was hoping you may be >able to help me since you sound like you know your way around btrieve. Our >customers who are using the software which I developed are reporting an >al…
Re: Reducing Checkpoint Duration
Lin-Chuan Lee wrote: > > To reduce checkpoint duration, what are recommended strategies?? > > I have guide to performance tuning in front of me .. > so the standard 'by-the-book' .. lower LRU_Min/MAX stuff > I know.. Any other advice gained through real > experience would be gr…
Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
Mark D Stock wrote: > > That is, if LRU_MIN_DIRTY and LRU_MAX_DIRTY are both held > > constant, say 5 and 7 respectively, does a higher or lower LRU result > > in a shorter checkpoint duration? > > My feeling is that if you need to lower these parameters this much in order to > r…
Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
This is a multi-part message in MIME format. --------------C4C26D4394 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit David Williams wrote: > > In article <4rsf8p$kt@sjx-ixn4.ix.netcom.com>, Stuart Cracraft > <cracraft@ix.netcom.com> writes > >The…
A few final thoughts / ideas ....
Well, after 4 hours of sleep, the world looks like a better place ;-) OK, before I forget, congrats to Glenn Miller out of Colorado for passing the certification tests. Maybe he can post his experiences about it? (How about some of the questions too? [NOT!]) Second, this is to …
Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
David Williams wrote: snip > LRU's too low means the there is contention among the queues and > Informix runs slower as processes have to wait before the can update > the queues. There is one mutex per queue which controls give thread > can update the queue. Remember que…
Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
>By the way, what is your checkpoint interval? >Are the checkpoints occurring after this intervall or do they occure >earlier, initiated by a 75% dirty Physical-Log-Buffer? The checkpoint interval is set to 300 seconds. The checkpoint always seems to occur at the interval and n…
Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
In article <4rsf8p$kt@sjx-ixn4.ix.netcom.com>, Stuart Cracraft <cracraft@ix.netcom.com> writes >The On-Line manual on page 12-36 says LRUS should be either 4 or the >number of virtual cpus -- this is a very low number. > >Most of the Informix Press tuning books and chapters on tu…
Re: Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
Stuart Cracraft wrote: > > > So far, setting LRU_MIN_DIRTY and LRU_MAX_DIRTY down to > 5 and 7 respectively, with CLEANERS at 29 and LRU > at 5 (LRU formerlyl at 16) has resulted in approximately 1/5th the > checkpoint durations of when CLEANERS was at 29 and LRU was at 16 > and…
Informix 7.1.2.UC1: LRUS in /usr/informix/etc/onconfig
The On-Line manual on page 12-36 says LRUS should be either 4 or the number of virtual cpus -- this is a very low number. Most of the Informix Press tuning books and chapters on tuning, say LRUS should be equal to CLEANERS and shouldn't be too small. This is typically a higher n…
Re: High numbers of buffer waits in OnLine
In article <DtpnBz.3HC@cix.compulink.co.uk>, "\\"Andy Kent\\"" <akent@cix.compulink.co.uk> writes >Client is noticing large numbers of buffer waits sometimes cropping up >while running a *single* heavyweight job under OnLine 5.04. They've got >plenty of data buffers (12,000) and …
High numbers of buffer waits in OnLine
Client is noticing large numbers of buffer waits sometimes cropping up while running a *single* heavyweight job under OnLine 5.04. They've got plenty of data buffers (12,000) and are getting read caching of 98% and write caching usually over 90%. LRU parameters are at the default…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: LRU writes
On Thu, 2 May 1996, Mickey Mestel wrote: > brian, > > > We have never had anything BUT chunk writes, and are trying to make > > better use of our BUFFERS. Should we be trying to increase the number of > > queues, maintaining the number of buffers, until we just start seeing LRU…
Re: LRU writes
At 01:16 PM 5/2/96 GMT, you wrote: >I am trying to understand the logic of LRU writes : online 5.02.UD3 > >When I do a tbstat -F : i see > >Fg Writes LRU Writes Idle Writes Chunk Writes >0 108566 1565 244701 > >The manual says : >LRU writes : …
Re: LRU writes
At 01:16 PM 5/2/96 GMT, Guy Germonpre wrote: }When I do a tbstat -F : i see }Fg Writes LRU Writes Idle Writes Chunk Writes }0 108566 1565 244701 }The manual says : }LRU writes : Foreground writes alert the master daemon that page cleaning is }…
Re: LRU writes
>LRU writes : Foreground writes alert the master daemon that page cleaning is >needed. Once alerted ... > >How come that my Fg Writes is at 0 ? Please don't miss the point ! I know it is fine the have the foreground writes at 0, but what then is the difference between LRU write…
LRU writes
Hi, I am trying to understand the logic of LRU writes : online 5.02.UD3 When I do a tbstat -F : i see Fg Writes LRU Writes Idle Writes Chunk Writes 0 108566 1565 244701 The manual says : LRU writes : Foreground writes alert the master daem…
Re: page cleaner #1 timed out
> From informix-list-owner@rmy.emory.edu Tue Apr 30 03:41:00 1996 > From: Guy Germonpre <germonpre_guy/dis@bekaert.com> > Subject: page cleaner #1 timed out > Date: 30 Apr 1996 07:43:59 GMT guy, > Online 5.03.UD2 on Compaq proliant 4500. From time to time we get the > error > "E…
Re: page cleaner #1 timed out
Hi, This means that your page cleaners were unable to complete their work in the alloted time. To relieve the problem you can adjust your LRU_MAX_DIRTY and LRU_MIN_DIRTY parameters in the onconfig file. These parameters control the threshold of work that the page cleaners do so …
Re: "tbmode -z" doesn't kill - or even wound!
My experience with tbmode is as follows: kill -9 will kill the process without telling the database engine that it is dying. This is BAD, as you frequently get corrupted pages and need to call and have someone from Informix or Plexus dial in and change the DB page by page. kil…
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: 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?…
Checkpoint Required
Hey Online wizards What causes the check point required message on a "tbstat -"? I know one cause is when achive tapes needs to be changed(many thanks to Joe Lumbley's book), but what other things can cause the check point required message? A "tbmode -c" should force a checkpo…
HELP message log
I need some help to understand the meaning of the messages that appear in the file of Message Log. This is a copy of my Message Log. Thanks in advanced. ############################################################################## Sat Apr 22 08:03:30 1995 08:03:30 INFORMIX-…
Re: Keeping clean pages in shared memory
In article <3j51am$shs@infmx.informix.com> raj@informix.com (Raj Gopalakrishna) writes: > > Page Cleaners and Checkpoints definitely influence cache flushing. >By setting a low value for LRU_MIN_DIRTY, you cause excessive page >cleaning activity. This may not be a good idea as i…
Re: Keeping clean pages in shared memory
June Tong (junet@informix.com) wrote: : In article <3j5crk$566@infmx.informix.com> davek@informix.com (David Kosenko) writes: : >Raj Gopalakrishna writes: : >|> Page Cleaners and Checkpoints definitely influence cache flushing. : >|> By setting a low value for LRU_MIN_DIRTY, you…
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) ----------------------…
Re: Keeping clean pages in shared memory
In article <3j7t1r$dbh@infmx.informix.com>, David Kosenko <davek@informix.com> wrote: > >Raj Gopalakrishna writes: >|> I am aware of the fact that flushed pages are not removed from the >|> cache but what I was trying to say that the effectiveness of the >cache is lost >|> for wr…
Re: Keeping clean pages in shared memory
> > > But what if the system *is* disk-bound during page cleaning? I don't > > think Online takes into account other disk activity when deciding > > whether to flush - it's all based on snooze times and LRU thresholds. > > If the application is disk bound, the best solution is to…
Re: Keeping clean pages in shared memory
Andy Kent writes: |> OK, so every Online person knows how the most frequently-used pages are |> encouraged to stay in shared memory by means of LRU queues. |> |> That's fine for dirty pages. A potentially dumb question then: what |> about clean ones? Does OnLine have a mechanism…
Re: Keeping clean pages in shared memory
Raj Gopalakrishna writes: |> I am aware of the fact that flushed pages are not removed from the |> cache but what I was trying to say that the effectiveness of the cache is lost |> for writes (flushes) while it still works for page reads (lookups). This is |> because the number o…
Re: Keeping clean pages in shared memory
In article <3j5crk$566@infmx.informix.com> davek@informix.com (David Kosenko) writes: >Raj Gopalakrishna writes: >|> Page Cleaners and Checkpoints definitely influence cache flushing. >|> By setting a low value for LRU_MIN_DIRTY, you cause excessive page >|> cleaning activity. T…
Re: Keeping clean pages in shared memory
In article <3j5crk$566@infmx.informix.com>, davek@informix.com (David Kosenko) writes: |>Path: informix.com!davek |>From: davek@informix.com (David Kosenko) |>Newsgroups: comp.databases.informix |>Subject: Re: Keeping clean pages in shared memory |>Date: 2 Mar 1995 21:20:52 GMT |…
Re: Keeping clean pages in shared memory
Raj Gopalakrishna writes: |> Page Cleaners and Checkpoints definitely influence cache flushing. |> By setting a low value for LRU_MIN_DIRTY, you cause excessive page |> cleaning activity. This may not be a good idea as it effectively reduces |> the effectiveness and size of the …
Re: Keeping clean pages in shared memory
At 11:13 AM 3/2/95 GMT, Andy Kent wrote: }> > 1) If a buffer is written to, say, every 30 seconds and you flush it }> > once a minute, you'll do five times as many disk writes for it than }> > with a 5-minute checkpoint }> }> That's what we thought but it wasn't the case. We bas…
Re: Keeping clean pages in shared memory
> > 1) If a buffer is written to, say, every 30 seconds and you flush it > > once a minute, you'll do five times as many disk writes for it than > > with a 5-minute checkpoint > > That's what we thought but it wasn't the case. We basically came to the > conclusion that the page …
Re: Keeping clean pages in shared memory
> > 1) If a buffer is written to, say, every 30 seconds and you flush it > once a minute, you'll do five times as many disk writes for it than > with a 5-minute checkpoint That's what we thought but it wasn't the case. We basically came to the conclusion that the page cleaning …
Re: Keeping clean pages in shared memory
> We wanted to know this because we didn't know if page cleaning and > checkpoints had a detrimental effect on write caching. It appears that > it doesn't so we felt we could change the LRU min and max dirty to a low > value and not affect performance. Not quite David, if you f…
Re: Keeping clean pages in shared memory
We had a similar discussion on our project not only about read pages (which as Malcolm points out is moved to the beginning of the queue when read) but what happens when the page cleaner flushes a dirty buffer? Does the buffer end up in the free list or can it still be used to do…
Re: Keeping clean pages in shared memory
Andy, The LRU queue mechanisms apply to both clean and dirty pages. Malcolm Weallans Online Database Consultancy 2 Arkley Court Maidenhead Berks SL6 2YR Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc…
Keeping clean pages in shared memory
OK, so every Online person knows how the most frequently-used pages are encouraged to stay in shared memory by means of LRU queues. That's fine for dirty pages. A potentially dumb question then: what about clean ones? Does OnLine have a mechanism for ensuring that the most-freq…
Re: HP9000+LVM+Online
Article: 13082 of comp.databases.informix >> >> Andy >> >> I got the impression that Mike's system only had one chunk (therefore >> one page cleaner) which was striped underneath using LVM. > >Put one page cleaner on a five-disk system and you've already got your >checkpoint per…
Re: Why several oninit processes in ver 6.0?
> In article, akent@cix.compulink.co.uk ("Andy Kent") wrote: > > > By default, pre-6.00 would always start 2 tbinit processes: one for > > the master daemon, and one for each page cleaner, for which the > > default is 1. > > Do you mean one for tbinit, one for tbundo, and one for…
Checkpoints problems
Hi A friend of mine is running informix online 5.01 ud3 in aix 3.2.5. The workstations are running inet 5.01 and q+e odbc library. At some time (generally during heavy load), users begin to complanit that they can't connect to the database server. But logged users still works…
Re: rootdbs eaten up
Somehow, you are having sqlturbo processes aborting without getting the chance to clean up temp table space. Are you killing them rather than using tbmode -z? The space will remain allocated until the net time you start up OnLine. As far as I know there is no other way to get rid…
On-Line 5.0 Weird Crash
The other evening we had a database crash on us, it said that a dbspace disappeared. Upon further evaluation, we noticed nothing wrong and restarted the engine and everything was fine. The following listings "online.log" and "tbstat -a" are listings for a on-line crash on …
Questions about Informix page buffers
Hi, in reading the Informix documentation, it mentions that page buffers are used to cache data from disk. It mentioned that the page size and number of pages are dependent on the database server and O/S. I am unclear on what the dependencies are other than the available memory a…
Questions about Informix page buffers
Hi, in reading the Informix documentation, it mentions that page buffers are used to cache data from disk. It mentioned that the page size and number of pages are dependent on the database server and O/S. I am unclear on what the dependencies are other than the available memory a…
Checkpoint Recovery
Does Infomix provide me with the ability to specify a particular transaction or checkpoint to be used in rollback or recovery processing. My questions stem s from a user scenario, where the user has requested a series of database processes accidentally. I would like to be able …
Re: Page Cleaners/Idle Writes
Dave, Thanx for the response. I couldn't reach you directly. page cleaners = LRUS is worth trying. I remember seeing your post a couple of weeks ago when we were discussing maximum performance - it was very imformative and it was that reason I was experimenting with Page …
Re: Page Cleaners/Idle Writes
Mike Alder writes: Mike's issue is cc'ed below. Here is the way to tune to get (for most circumstances) best performance. Fiirst, ignore the bit in the manual about tuning page cleaners to disks; tune them == LRUS (8 by default). Set your LRU_MAX_DIRTY to 10-30, and LRU_MIN_D…
Page Cleaners/Idle Writes
(I'll try again -- I/System had a hic-up...) Hi Netters, I have been experimenting with LRU_MIN AND MAX parameters and page cleaning/cleaners to try and enhance performance and get the most out of my page cleaners. I have 3 seperate spindles with 3 page cleaners and a mod…
Page Cleaning/ Idle Writes
Hi Netters, I have been experimenting with LRU_MIN AND MAX parameters and page cleaning/cleaners to try and enhance performance. I started out with the default values of…
Re: Workaround for memory leak problem -- comments?
P.S. The 800 support is suggesting that the leak is not a defect and that the user is expected to clean up memory allocated by the cursor functions. This is fine if they can tell us how to do it. So far it has been many months with no work-around. -----------------------------…
engine performance (fwd)
Ellen suggested I send this out for a grin. Basically we had experienced some problems on one of our many engines and found this in the logfile. I sent this to Ellen to let her know a) what was going on b) it was the only logical explanation for what was occuring. } One day (7…
Re: LRU writes
Graeme Sargent writes: |> Can anyone explain exactly what triggers an LRU write in Informix- |> OnLine, or what the distinction is between LRU writes and Idle writes? |> |> According to the documentation (and the Informix training courses) the |> only thing that triggers an LRU w…
Need Info on tbtape/tbstat
I need to write a program to automatically know what level of archive needs to be done. I am trying to read the ${INFORMIXDIR}/turbo.log to see the messages indicating when the last archive completed. The turbo.log and the tbmonitor status/archive does not really match. Is the…