Oninit® Archive
Results for “onstat -g cac”
Ifx 14.10 - DNS outage strategy ?
As far as I know the HOST part of NS_CACHE serves both name-to-ip and ip-tp-name resolution purposes, so temporarily setting host=<really_high_value> probably should get you over such DNS maintenance window, provided that no client connects that hadn't connected yet before, i.e. …
Informix v15 Developer Edition
Please try again to download the installers. For me they are available now. But it was necessary to clear the cache before it was working (why? no idea) ------------------------------ Hedwig Fuchs ------------------------------…
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 ------------------------------…
%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 …
Index page size recommendations
Hi Jacob, many dependencies: - index size - cache read rate - cpu speed ... Best Regards Henri ------------------------------ Henri Cujass leolo IT, CTO Germany ------------------------------…
Spot the difference
JC: Now you've opened a can of worms. Suggested improvements to the SMI tables: This one is not related to onstat being better, but there needs to be more complete reporting of readahead. Not all types of pages are included in either the pages read or pages used by readahead whic…
Informix DNS Warning
In case of network not changing frequently and only a known set of applications, from known set of hosts, connecting to Informix, you might want to be more independent from DNS (and maybe temporary glitches) by taking advantage of DNS caching which can be done on OS as well as on…
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…
memory monitor
Original post: HI, I use informix version 12.10, How to monitor below memory through SMI? dictionary cache; table statistics cache; ...... thanks for your time. Lu chuan Response: Well first off, when you say "table statistics cache" I'm assuming you mean the cache the s…
Set tables in memory
That feature was depreciated around version 11. Informix handles all the buffer cache management. If you are having issue with a table not staying the cache you probably need to increase your buffer cache.…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
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.…
error initializing 11.70.FC9
IDS 11.70.FC9 HP-UX 11.31 PA-RISC I did a standard installation (as root) of 11.70.FC9 in a separate directory on our test server. In the past, I have always set up a quick test instance anytime I install a new version, load the stores7 database, and run a few SQL statements to …
Can I bring informix up/down from another computer
AIX file cache tuning is what your after. The defaults favor the file system side so they probably need to be tuned downwards. https://www.stix.id.au/wiki/Tuning_the_AIX_file_caches…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
IO performance issues
Hi, some thoughts: 1) check where the sequential scans come from. 68000 within one day is a lot .. It might be empty or almost empty tables, when the optimizer decides to read the 0-3 records instead of searching in an index, but in case you are reading through a huge number of r…
SQL statement equivalent TO onstat -g ssc
Patrick: I don't think that the statement cache is exposed in sysmaster. The only reference to it in sysmaster that I know of is the efficiency profile record in syssqlcacheprof: select * from syssqlcahceprof where name = 'Statement Cache'; But that's just over all hits, misses…
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)…
Performance issue
hi, the reasons can be multiple: - the way the application works: it can simply be coded in an very inefficient way, causing conflicts and unuseful repetitions that can be very costly - locks: check if you have relational constraints that will put locks on related tables, also c…
COMMIT WORK, LRU's and Checkpoints.
I wonder if someone could explain what happens when a commit work occurs in terms of the buffer cache? The SQL Manual for COMMIT WORK has the following sentence: "The database server takes the required steps to make sure that all modifications that the transaction makes are comp…
-272 when using role and synonym
I'm sorry, but I think there's something strange in the scenario. Please see my comments below and clarify my doubts. On Wed, Feb 11, 2015 at 6:23 PM, MARK COLLINS <markc@myfastmail.com> wrote: > IDS 11.50.FC6, HP-UX 11.31 PA-RISC > > We have two databases, with a table in one …
where can i find Arts article on san disk write c
Hello I understand Art has written a good article on san disk where can I find it please. Also what are people opinions about have disk write cache enabled on windows servers ?…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
question about sequences
If you define cache size for sequence to 1, you can use following query to get the current value. For larger cache size this query will not give you right value. select tabname sequence_name, c.cur_serial8 currval from syssequences a, systables b, sysmaster:sysptnhdr c where a.t…
Java Cache ?
Hey Gurus, I vaguely remember a John Miller presentation where he discusses new cache variables in 11.70. Isn't there a new value for java cache? I looked through the information center and I didn't find what I was looking for, can someone help here? Specifically I want to know …
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Buffer Size and Use
Thank you for explanations. Could I summarize it like this? RESIDENT speaks to the O/S memory management, and does not affect Informix's management of the buffer cache. That is, the two are orthogonal processes. DG…
Checkpoint causes Db to "freeze"
Jack Is this an issue that has just started occuring or have you always had longish checkpoints. How are your disks connected, what sort of cache do they have ? A few weeks ago my checkpoints went from 0-1 seconds to 30-50 with no change in work-load. Investigation showed the ca…
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.…
Execution Plan
What host language are you using that uses $<num> as a host var that is not replaced until OPEN time? - "Java" Why not just run the thing with SET EXPLAIN enabled or the EXPLAIN optimizer directive in it (with or without the AVOID_EXECUTE option) and look at the actual query pl…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
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,…
btr
How can the BTR be 334 while the %cached for reads is 91% to 95% ? (This is ids11.70.TC3IE )…
Re: Someone have a technique to alter tables with
Fernando, In the message sent by both PMR : Date: 06/06/2011 Time: 11:43:34 Sql : -710 Table (informix.x_xxxxxx) has been dropped, altered or renamed. Isam : 0 Unknown error message 0. Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain …
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Speed discrepancy between prod and a lab
completely identical. Same # of disks, same speed, same raid enclosure, same raid level, same card and cache size.…
How to get the sequence value in ESQL/C program?
Hi, The IDS version is 11.50FC8W4. Below are the defination. I create it in the user database, not sysmaster. create sequence seq1 start with 1 cache 20; I will try John Miller's suggestion. thanks…
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…
sqltrace x prepare statements (4GL)
Hi, IFX 11.50 FC8 AIX 6.1 + 4GL 7.32 (with CSDK 3.50 FC8) I have a 4GL program, executing a simple foreach over a table with 1.5mi records code 1) If this foreach running as dummy, without any code inside , take 1 minute to run: declare xyz cursor select ...from xyz foreach x…
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.…
IDS 11.7 ,Inplace Upgrade Failed
I'm trying to upgrade IDS11.5 to IDS11.7 to benefit the features of IDS 11.7. From Informix migration guide,I know that I've to rename sysadmin database before doing the migration, but How to do it? Before doing the migration,I've do the Level 0 archive the storage of informix…
Re: persistance for sequence's current values
Hello, It use to work one year ago but I don't remember on which IDS version ... now, on 11.5FC2 it is not. What returns is the cache 'ceiling' eg Assuming the cache is 20, then if .currval between 1 and 20 => it returns 20; if .currval between 21 and 40 => it returns 40; Regar…
Help - % Cached
Good morning list, I have the next problems, in my IDS instance, when execute onstat -p, my IDS display the next screen, but this situation is only sometimes, the normal is Read %cached over 90%, and Write % Cached same too, please helpme. Thanks for your time. IBM Informix Dyn…
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…
Art's Fear the Panther....
You probably noticed that Art Kagel posted a new entry in his blog: http://informix-myview.blogspot.com/2010/10/fear-panther.html At the end he mentions that IIUG is preparing the vNext survey (!). The world never stops! He wrote: "The IIUG will soon be posting its new Featur…
Error starting IDS v10
I've already commented the inf-ekpmatrade mol_dev : /usr/informix/etc> cat sqlhosts mtx2informix_prod onsoctcp mtx2informix inf-prod prod_shm onipcshm mtx2informix inf-prod #eis_prod onsoctcp mtx2informix inf-eis stat_prod onsoctcp mtx2informix inf-stat dss_prod onsoctcp mtx2inf…
ONSTAT -G DIC
Try DD_HASHSIZE 1013 DD_HASHMAX 10 You should also take a serious look at the data distribution cache (onstat -g dsc) to see if that doesn't need to be increased as well. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Di…
How to verify SQL statements execution date/time
I don't think that the information exists in the database itself. Perhaps if you have SQLTRACE set and have the contents of the trace cache being saved to a table or file you could get that information that way. Another option is Exact Solutions' iWatch product which captures SQ…
How to retrieve/check previously executed SQL ?
Ummmm... Upgrade to version 11.5 and turn on the SQL statement cache? I don't think it was available back under 9.4 Jarrod -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA Sent: Wednesday, 22 September 2010 4:23 p.m. To:…
Config
I am doing an intial tune for a new instance of 11.5 64bit. All of our previous instances have been 32bit so I am unsure about my current shared memory config... do I have too many buffers? I am also wondering whether I can safely add 1 or more CPU VP's. The stats seem pretty go…
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…
Help on VP cache tunning
Hello, my friends! This is on IDS 11.50.FC6W1 on a linux_64 machine. I´m doing some vp cache optimizations, and some doubt is still un-answered: My onstat -g glo (cpu classes only) shows: class vps usercpu syscpu total cpu 7 854.44 59.08 913.52 vp pid class usercpu syscpu total …
frozen sessions
Thanks Jacques. This is the first time we've seen something like this, and it was only affecting sessions that used this procedure. The rest of the sessions (again procedure driven) were working without a problem. I ended up restarting the engine to correct the problem. -----Ori…
To IBM - DeveloperWorks - Articles
Hi, This message is to IBM . In the DeveloperWorks have a lot of nice Informix Articles , but most of them very very olds (2001-2006) what they treat only old IDS versions without consider news resources and updates.... Is time to review and update all this articles , isn't ??…
Re: How to Change sysdistrib tables extent size?
Is what possible? In 9.xx you cannot change the initial extent size of the TABLESPACE TABLESPACE nor of the system catalog tables. You can, as informix, change the NEXT SIZE for the catalog tables before you start to create tables in the database to minimize the fragmentation of …
Statement Cache & Web Logic
Hello A developer is asking about Web Logic and their documentation and how that relates to informix and the database statement caching. here is what we have set: # Turn the sql caching on onmode -W STMT_CACHE_NOLIMIT 1 onmode -W STMT_CACHE_HITS 15 onmode -e on we have not had …
Re: Resident Memory larger then expected
The RESIDENT segment is more than just the buffer cache. For example, the lock table and the data dictionary, data distribution, stored procedure, statement and other static caches are all stored in the resident segment. Also if you have set RESIDENT to a value other than zero o…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Seeing one oninit working hard while others are no
Where is the capture parameter? I really only see the EXPLAIN_STAT enable. Is that it? If I turn it off, will that possibly improve anything? # SQL Statement Cache Configuration Parameters ################################################################### # STMT_CACHE - Control…
onstat -g his ( Log Space for Select)
On 28 Aug, 15:22, "zaiets.ko...@gmail.com" <zaiets.ko...@gmail.com> wrote: > Hi! > IDS 11.50FC5 > In onstat -g his output for SELECT Stmt Type Log Space not 0. > Statement text: > SELECT COUNT(*) FROM work_alloc > > SELECT using table [ work_alloc ] > > Iterator/Explain >…
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…
Alter statistics to trick the optimizer?
IDS 10.00.fc8 OS AIX 5.x Situation: Statistics updated low every night. Table is empty at time statistics are run every night. I have no control over SQL or schedule of the application tasks. Mass load occurs on table at time of end users choice. Automated task begins on interv…
ISAM reads of system catalog tables
On 5 June, 21:22, Peternt <roger_vi...@yahoo.es> wrote: > On 5 jun, 14:08, TheBigPota...@Nothere.Co.Uk wrote: > > > > > On Jun 5, 4:46 pm, Art Kagel <art.ka...@gmail.com> wrote: > > > > System catalog tables should not be read frequently at all, either from disk > > > or from the…
Cache some specific tables of any database
Sorry about no specs. Our version is 11.50.FC4 running on a Linux_64 machine. Thanks in advance for your helps, mr. Kagel !!! Alexandre Marini Analista de Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW Art Ka…
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 …
How to disable cache/buffer when running the same
Hi, This is quite difficult to do. True, ids does cache your data, and you can reduce the amount of information that can be cached by playing with your BUFFERPOOL configuration and read ahead configuration. However, I wouldn't recommend it. This can affect how much data is cac…
Monitoring SQL Statement Cache
I need to define a set of monitors to monitor key DB metrics. I can see that using the SMI tables, I can get a lot of what I want. However, I can't seem to find any way of monitoring the efficiency of the SQL Statement Cache. Something like a cache hit ratio (in %) would be use…
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…
Re: SQL STATEMENT CACHE Informix
On 13 Mar, 16:22, chav...@gmail.com wrote: > Hello, > Recently we enabled SQL STATEMENT CACHE in Informix 10.FC8, I > have been monitoring the chache since then, one thing I observed is > the statements are being removed from the cache well before (50-70MB) > the configur…
SQL STATEMENT CACHE Informix
Hello, Recently we enabled SQL STATEMENT CACHE in Informix 10.FC8, I have been monitoring the chache since then, one thing I observed is the statements are being removed from the cache well before (50-70MB) the configured max 100MB cache size limit, because the server can…
intersystems cache
is it a ponzi scheme? does it have anything to do with karl reti and elkie holland?…
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…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Speed issues 9.4
Besides seq scans: > > 228057060 779495368 2164074103 89.61 12488020 47951408 124371428 > > 91.10 % read cache is pretty low... this can be caused by sec scans too. Superboer.…
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.…
Caching Data to Buffers
Hello, IDS 11.10.FC2W1 Yet again some simple but imp Qs 1)Could any one pls explain me IN SHORT what Update statistics actually does. i am reading/studying and running upate statiscs for some time now but even today it is not very clear to me :( 2)Also pls let me know if it i…
pinning tables in cache?
Hello, In IDS 10, is there a way to pin (or at least pre-load) an object in the buffer cache? Thanks, Don…
IDS11 startup problems
Where are your chunks located (onstat -d)? Where is $INFORMIXDIR point= ing to? ------------------------------------- Madison Pruet, STSM IDS Replication Architect = "DENIS DIDEROT" = <nyakizu2000@yaho = o.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Sub…
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…
Re: bcheck and retrurned value in index b-tree
Jonathan Leffler wrote: > Rahan wrote: > >>Under Solaris 10 and 9, we are using a product which use an IBM C-ISAM >>database to store a lot of data. >> >>We had some problem with a database, some crash due to a database >>corruption and impossibility to our software to replay a r…
Virtual segment usage - now I'm confused.....
On Nov 1, 11:11 am, Fernando Nunes <s...@domus.online.pt> wrote: > i...@perrior.net wrote: > > On 1 Nov, 13:32, "Art S. Kagel" <art.ka...@gmail.com> wrote: > >> On Nov 1, 8:50 am, i...@perrior.net wrote: > > >>> OK we managed to catch the process that blew up our Virtual portion.…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 16, 4:10 am, Colin Dawson <cjd_1...@hotmail.com> wrote: > For what it's worth, these are my settings > > # Dictionary Cache Size > DD_HASHSIZE 499 # Number of dictionary hash buckets > DD_HASHMAX 68 # Maximum number of dictionary entries p…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 16, 4:10 am, Colin Dawson <cjd_1...@hotmail.com> wrote: > For what it's worth, these are my settings > > # Dictionary Cache Size > DD_HASHSIZE 499 # Number of dictionary hash buckets > DD_HASHMAX 68 # Maximum number of dictionary entries p…
Re: Calculate optimal value for DS_POOLSIZE
For what it's worth, these are my settings # Dictionary Cache Size DD_HASHSIZE 499 # Number of dictionary hash buckets DD_HASHMAX 68 # Maximum number of dictionary entries per hash bucket # Distribution Cache Size DS_HASHSIZE 503 …
STMT_CACHE
mohitanchlia@gmail.com wrote: > Version: 10 FC 4 > > I was reading about STMT_CACHE to see if this could be used to > increase the performance of repeated queries. But I see lot of people > have filed bugs about it. It appears engine crashes if you try to use > it. So my question…
4gl/esql syntax
thanks guys, what worked for directives in both 4gl/esql was: putting query into a string, preparing it, and declaring a cursor with {+ <directives>} syntax any idea, how to set CACHE ON just inside a program?…
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 …
Using STMT_CACHE
Hi These are the advantages of using SQL Statement Cache feature. 1)Reduced memory consumption because query data structures are shared among different users. 2)Faster query processing time because for statements present in the cache, the database server can skip parsing and opti…
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: Cache connect to Oracle
Clearly the problem is with your sqlhosts file. ----- Original Message ----- From: "Obnoxio The Clown" <obnoxio@serendipita.com> To: "gaurav" <gsmart15@gmail.com> Cc: <informix-list@iiug.org> Sent: Wednesday, May 30, 2007 9:53 AM Subject: Re: Cache connect to Oracle > > gaurav …
Cache connect to Oracle
Hi friends i am facing a severe problem in cache connect to Oracle.i tried much but i got an error that DSN not found or default dsn not specified Please help anybody. i have a doubt that is'nt there any mismatch between the versions of timesten and oracle 10g i am using Oracl…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
RE: UDR Cache
Hi , > > Number of lists : 1021 > > PC_POOLSIZE : 2048 ... > > Total number of udr entries: 352. > Number of entries in use : 137 > >This problem is not related whit bad configuration "PC_HASHSIZE" and >"PC_POOLSIZE" ? >I heard tha…
UDR Cache
I try: onstat -g prc OUTPUT: UDR Cache: Number of lists : 1021 PC_POOLSIZE : 2048 UDR Cache Entries: list# id ref_cnt dropped? heap_ptr udr name -------------------------------------------------------------- 444 48180 0…
Question about Linux VM tuning for IDS
-->>So the bottom line, its a *feature* that really has minimal value. do not understimate this!!!!!!!!!!!! linux may kick out pages etc due to filesystem cache!!!!!!!!! Superboer.…
SELECT statement in FROM Clause
OK, I didn't want to get into my whole philosophy of how one properly switches from one programming language to another. I'll try a brief one here, but I continue hold that SQL is not a 'programmer's language' it is a 'user's language'. Perhaps that's better, as you are correct i…
Re: DD_HASHSIZE , DD_HASHMAX
Well it's been a while since I used v7, but it looks like a couple of columns are missing. However given the header for an onstat -g dic list# size refcnt dirty? heapptr table name I'm going to presume the first colum in your example is actually the refcnt. In tha…
Re: DD_HASHSIZE , DD_HASHMAX
Mark, the table xxacct is cached moer than once in this extract. Thanks 426 yes 95e02820 xxx@xxxshm:xxxx.xxacct 147 yes 9f220680 xxx@xxxshm:xxxx.xxacct 12 yes b0df9820 xxx@xxxshm:xxxx.xxcattr 1 yes ce4e2020 xxx@xxxshm:xxxx.xxpecl 9 y…
Re: DD_HASHSIZE , DD_HASHMAX
Could you shoot a small portion of the onstat -g dic output where you are seeing duplicates? Thanks much ----- Original Message ---- From: "tichman@excite.com" <tichman@excite.com> To: informix-list@iiug.org Sent: Tuesday, January 16, 2007 10:02:21 AM Subject: Re: DD_HASHSIZE ,…
Re: DD_HASHSIZE , DD_HASHMAX
A few questions. #1 How many Databases do you have in the instance. #2 Do you perform any remote queries to other instances from the instance. #3 How long has the instance been up. Multiple copies of the same table usually indicates that you have multiple versions of the tabl…
Pls help to tune my informix engine .. thanks
percentage read cached 94% could do better, can you afford to give more nemory to inormix? seq scans seems high, badly written queries, poor indexes, poor statistics for the optimiser? if you have lots of seq scans this may explain the read cache…
sysXXXX XX tables
I never fully researched it, but I tried to increase the next extent size of certain system catalog tables right after creating the database. For some reason, many of the system catalog tables do not honor this resizing. As I say, I haven't fully followed up on it so I can't say …
Re: DD_HASHSIZE/MAX on a Baan installation with more than 100, 000 tables.
Hi Rob, there is very little overhead for DD entries over all , let me see if I can dig up my rough sizing calculations. The base overhead for the Data Dictionary Cache is as follows: X1 = 24 + (40 * DD_HASHSIZE) Below is the minimum cost of every Data Dictionary entry: Y1 =…
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…
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…
Statement Cache
IDS 9.40.FC8 Solaris 9 When I do onstat -g ssc I get lines as follows lru hash ref_cnt hits flag heap_ptr database user -------------------------------------------------------------------------------- 37 152 11 6549 DF 3c3d7e438......... 38 254 571 730…
Cached reads going to 0.00%
I've noticed this a couple of times in onstat, for no apparent reason cached reads go from 95% or so to 0.00% and then slowly build back up to 95% over the next 24hours or so. There's a cronjob that runs at 8, noon, 5 and midnight that records a few interesting statistics on the …
Easy INFORMIX questions
Stored procs can have a precompiled "plan", it gets precompiled when the "UPDATE STATISTICS FOR PROCEDURE" statement is executed. The update stats command needs to be executed when the stored proc changes, if the indexing on the tables that the procedure uses change or the data t…
Informix instances with large number of tables and databases
bozon wrote: > So are you saying it doesn't run well. > > Obnoxio The Clown wrote: >> bozon said: >>> We are doing a proof of concept. In it we want to create a database for >>> each of our 2000+ customers. In each database we will have about 300 >>> tables and about 800 indexes.…
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Max. BUFFERS, IDS 9.4 32 bits on AIX 5.2 64 Bits
Jean wrote: > Hello, > > - Anyone knows the max. cache size on IDS 9.4 32 bits running on AIX 5.2 64 > Bits ? > > Thanks > Jean > > IIRC there is no hard limit. The cache is limited by the memory available through the OS. On 32bit AIX that's about 3.2GB less the space for code …
Max. BUFFERS, IDS 9.4 32 bits on AIX 5.2 64 Bits
Hello, - Anyone knows the max. cache size on IDS 9.4 32 bits running on AIX 5.2 64 Bits ? Thanks Jean…
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/…
Long checkpoint woe
Use /dev/null for if and then for of. This will tell you if it is a read issue or write issue. If they are the same then it is a real problem with the disks. Some of these storage arrays have the cache turned on for reads but off or tuned low for writes. I have also noticed tha…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: IDS Feature Request List (including potential new requests).
Talk to Art Kagel. He already does this kind of stuff with dynamic names for prepared SQL statements a feature Oracle does not have! http://www.thetechtwo.com/detail-11064865.html "Sure, Pro*C does not support dynamic creation of prepared statement names and cursor names in hos…
chunk failed sanity check
Dear Alejandro, It looks as if the power failure physically damaged the data on the raw device or the raw device is not accessible anymore. First try to make the raw device accessible again , ensure you can read it with lets say 'dd' . When you where succesful reading the devi…
Re: Upgrading from 9.21 to 10 planning
SSC? Is that Shared Statement Cache?…
Re: Upgrading from 9.21 to 10 planning
> I had a lot of problems with statement caching in 9.21 so I finally > turned it off. Is statement caching fixed and more reliable in 10. I > was assert failing on 9.21. Also in 10.00UC3R1. IDS crashes when SSC is enabled and during evaluation of views with nested subqueries. D…
Re: Write cache rate
Doug Conrey wrote: > I have a question about tuning the write cache %. I have an OLTP > database running IDS 9.40 on AIX 5.2. There are 300,000 buffers > configured (about 30% of physical memory -- 4 GB), and the read cache > rate is pretty consistently 98.5 - 99.0%, but the writ…
Re: Write cache rate
On 12/2/05, Christopher Coleman <Christopher.Coleman@mediware.com> wrote: >[...] > As I said, we have usually found that we need to over allocate buffers, beyond the normal > 20-25% of physical memory described in the manuals. This does not hurt us during the > day, so long as t…
RE: Write cache rate
Malcolm confessed: > I have often wondered if there are any detrimental effects (other than > excessive OS paging and/or swapping) of having "too many buffers". The major detrimental effect I have seen from too many buffers is not having enough memory for the rest of the server'…
RE: Write cache rate
I have often wondered if there are any detrimental effects (other than excessive OS paging and/or swapping) of having "too many buffers". I have many machines that need a large number of buffers overnight(batch operations, largre reports etc) and then use a very small number dur…
RE: Write cache rate
Doug Conrey wrote: > I have a question about tuning the write cache %. I have an OLTP > database running IDS 9.40 on AIX 5.2. There are 300,000 buffers > configured (about 30% of physical memory -- 4 GB), and the read cache > rate is pretty consistently 98.5 - 99.0%, but the writ…
RE: Write cache rate
I have many machines running with write caching rates in that region. I have observed that the write caching rate is often low when there is a small proportion of write activity. I use Art Kagel's BR, BTR, and RAU calculations to tune the number of BUFFERS. But I think your RA…
Re: Write cache rate
On 11/30/05, Doug Conrey <doug_conrey@oci.com> wrote: > I have a question about tuning the write cache %. I have an OLTP > database running IDS 9.40 on AIX 5.2. There are 300,000 buffers > configured (about 30% of physical memory -- 4 GB), and the read cache > rate is pretty cons…
Write cache rate
I have a question about tuning the write cache %. I have an OLTP database running IDS 9.40 on AIX 5.2. There are 300,000 buffers configured (about 30% of physical memory -- 4 GB), and the read cache rate is pretty consistently 98.5 - 99.0%, but the write cache rate hovers between…
Re: Really Frustrating -9628 Errors
bug_number 130885 description 9628 TYPE NOT FOUND USING SPL WHEN ROUTINE/EXT TYPE CACHE IS HAMMERED ERROR IS STORED IN SYSPROCPLAN product_code ONLINE component_code CT dono have it checked; Superboer.…
Optimizing a BaaN installation
Query sysmaster:syscfgtab (sysmaster:sysconfig is a view that hides undocumented paramaters)! There are DS_ parameters (?? Data dictionary caching). DD_ parameters (?? Data distribution caching) PC_ parameters (SPL caching) Check the IDS 10 manuals they document this stuff …
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: oninit: Dictionary Cache and SPL Routine Cache error
Jef Have you installed any tools (4GL or ISQL) In the same directory? I have seen a similar error when the Tools were installed after the IDS and not before. Keith -> -----Original Message----- -> From: Jonathan Leffler [mailto:jleffler@earthlink.net] -> Sent: Monday, October …
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: Do extents impact speed?
Well logical logs are written to sequentially and read from sequentially as they are backed up. So you want alternate logical logs on seperate spindles or if the SAN will be caching the writes somewhere then you want enough cache dedicated to the logical logs that the backup thre…
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: 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…
RE: strange behavior in 9.40.FC6
There were 2 defects fixed in the patch. Case #411757 opened with IBM Informix regarding a problem with stored procedure guphrase(pv_assn_num LIST(INTEGER NOT NULL). When executed the procedure is doing a sequential scan of the foassn table as well as scanning the entire index …
Some questions about views
Background: Michelle made this change to the webtodev database yesterday: Alter table to_recipient add ( fr_fee_reduction MONEY(16,2) default 0 not null before source_flag, fr_explanation VARCHAR(255) before source_flag, fr_operator_id VARCHAR(30) before source_flag); After she …
Update statistics
Tilman Mode.... wrote: > There is a way to drop distributions without running 'update statistics > low' > > You may use the SQL command: > > DELETE FROM sysdistrib > WHERE tabid = > (SELECT tabid FROM systables > WHERE tabname = '<the_table_in_question>'); > > Disadvantage of thi…
Negative write caching rate
I have been researching write caching rates in an attempt to explain why a number of the sites that I oversee are seeing low write caching rates. In the process I did discover that their level of OLTP write activity is small which means that the basic system administration funct…
Negative write caching rate
I have been researching write caching rates in an attempt to explain why a number of the sites that I oversee are seeing low write caching rates. In the process I did discover that their level of OLTP write activity is small which means that the basic system administration funct…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
> btree pages in cache
Hi list, I have an excessive # of btree pages in cache (on 7.31.UD8, AIX 5.2). onstat -P shows: ---- 8< ---- Percentages: Data 19.76 Btree 78.54 Other 1.70 ---- 8< ---- I have TBLSPACE_STATS switched on in $ONCONFIG. Does anyone have an idea how i can tie up a session with pag…
Light Scan and Caching
Hi, During a light scan, does the data get cached in virtual portion of the server. Bye.…
RE: Memory resident tables
Gustavo Tobares wrote: > This message is in MIME format. Since your mail reader does not understand PLEASE do not post MIME. It more than triples the bandwidth required to download and store your posting. > > Hi all, > > S.O: Solaris 8 > ENGINE: IDS 7.31.UD8 > > In the last…
Re: FW: Oracle ?
Dirk Moolman wrote: > I just wanted to find a couple of people who come from an Informix > background like me, but also know Oracle. I just completed the Oracle > Fundamentals I course, but still have some questions that the instructor > couldn't answer. > > I think the specia…
Re: Running Informix on 2 different Servers in parrallel
wcottishpoet wrote: > Neil, > > other than the holiday, how about all the following which are available > in 9.40 .... > > > Improved Performance 8-15%better in internal benchmarks;Fuzzy > Checkpoints;Shared Statement Cache;New Buffer Management System;B-Tree > Scanner;Improved R…
Informix and RAID
I think that as long as the RAID 5 controller has a reasonable write-back cache memory ( 256Mb seems to be the standard now) and you are talking about a small to medium size Informix installation, RAID-5 is a OK solution. Without a write-back cache is a bad choice indeed. Just my…
SPL caching on secondary - BUG
Hi, everybody, I've just run into a very unpleasant problem obviously related to SPL caching on HDR secondary. Steps to reproduce: (ANSI database, IDS 9.40uc5, also reproduces 9.21): 1. Primary: create function spl_test() returning INT; return 1; end function; commit; execu…
Re: clarification of parallel query on informix and oracle
David E. Grove wrote: >>Light scans do avoid the >>buffer cache and are used for queries that include a long sequential scan > > of > >>a table and are only used for pages from that table. > > > > I've wondered about that, too. So, if a light scan is to be used, IDS > ignores an…
clarification of parallel query on informix and oracle
Hi Gurus , I use oracle 9i rac on linux redhat ia64 . When i issue a parallel query on oracle , the query bypasses the oracle buffer cache and use process memory instead. So no caching occurs. When a full table scan is issued in parallel , it is also true that , oracle always b…
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'?…
clean sql cache for IDS9.4
hi: In informix server, there is some memory for sql cache. I want to clean cach content when debugging my appliction. I want to know that if there is a command for doning instead of directly restarting server. thanks in advance for helps.…
Re: is it possible to use wait hint with cursor select?
On Thu, 16 Sep 2004 15:24:48 +1000, "Andrew Hamm" <ahamm@mail.com> wrote: >sumGirl wrote: >> Is it possible to use a wait hint in a select done via cursor? Please >> no "dont use cursors" posts, I didnt write the code and I am just >> trying to help a developer. I am not a progr…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: Writing to disk or server cache?
Andris wrote: > Thanks, onmode -B indeed seems to be the solution for long > checkpoints, have to test it on IDS 9.21 yet. > > Anyway, another question remains - how to force IDS to use or not to > use cache memory? What do you mean by cache memory? Informix's shared memory? T…
Writing to disk or server cache?
Hello, all. IDS 9.21 on HP-UX 11, raw devices. Another thoughts about checkpoint time. During checkpoint IDS does not write data to server cache memory, but tries to write directly to disk array. Yet, writing to memory can be done more quickly. Is it possible to make Informix …
RE: database market share 2003
> From: Data Goob [mailto:datagoob@hotmail.com] > > In the real world Informix is already dead. > In the real world, DB2 is still in it's childhood. Some facts about DB2: 1. DB2 doesn't support table fragmentation within a single node (unlike XPS, which is able to fragment tab…
another follow-up
One more thing (so far!) I noticed that while my cached read improved, my cached writes is down about 4-5%. Any thoughts on this guys? We do a lot of datamining and we are constantly loading flat files into our production database, so any kind of write is always a worry for me! …
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Re: The old raw devices chestnut.
"Paul Watson" <paul@oninit.com> wrote in message news:407D3202.E6E8B0A4@oninit.com... > > Absolutely not. Cache access is faster. And it has nothing to do > > with fs or raw I/O. You get EXACTLY the same speed regardless > > of where you got the data from. > [cutting] > > But…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Shared memory and SELECT-Performance
On Mon, 01 Mar 2004 05:07:19 -0500, Markus Bschorer wrote: Increase the size of the buffer cache (BUFFERS onconfig file parameter) so that more data is kept resident. The fact that after a few minutes the data need to be reloaded is a clear indicator that the cache is too small…
RE: Problems running 9.40.UC3 on RedHat 8
Harry, This particular problem usually happens when incorrect 'libpthread.so' is used. Try to run 'ldd $INFORMIXDIR/bin/oninit' for diagnostics. Try to take that library from a working configuration and place it to /lib/libpthread.so.0 (Library location is hard-coded in IDS, d…
Problems running 9.40.UC3 on RedHat 8
I am having trouble creating an instance of Informix on RedHat 8. I have read all the problems people have been having running on RedHat 9 so we decided to try RedHat 8. We have also upgraded the glibc to glibc-2.3.2-4.80.8.i686. This was suppose to fix the problem with the TC…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
DiskRead-Cache always 0.00%
Hi, since a few days without any revelant changes in the informix-configuration, out Disk-Read-Cache is always zero. Example: (onstat -p) Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 803475051 834961363 238511699 0.00 5432438 16547952 67235…
Diskreads-Cache always 0.00%
Hi, Informix 9.4 RedHat 2.4.20 since a few days without any relevant changes in the informix-configuration, my diskread-Chace is always zero. Example: (onstat -p) Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 803475051 834961363 238511699 0.00 …
Table Design Question
Paul Watson <paul@oninit.com> wrote in message news:<40110552.6EB20A52@oninit.com>... > I've got this little 30million row table, the entry point wrt to > the app will be via a char(12) unique field. No real hassles, a little > big of fragmentation and it's all fine but ... > > T…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Threads waiting on buffers (TWOB)
Well, Once again, our company is faced with the "threads waiting on buffers" (TWOB) issue. At a certain point, a ton of threads suddenly start waiting on a specific buffer (they show 'B' in the first flag of onstat -u). Onstat -X shows that they're almost all waiting on the same…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
which tables have lowest cache hits?
Hi, our buffer rate increased (to about 6) and it seems it is because low write cache hit (about 93%). We have now 130 MB of buffers and I do not want to increase it ... yet. What I'd like to know now is, which tables have lowest cache hit? Is it possible to find it? How? Than…
Threads waiting on buffers
So, yes, we do have over 200 tables. Including system catalog tables, there are 306 in this one database. And looking at onstat -g dic (for the first time), I see that 10 of the default 31 hash buckets are full with 10 entries each. Many others are 8 or 9. Art, I think you're sho…
memory sort and disk sort
I check the sysprofile table and find there are 700 times disk sort, I think it is lack of sort memory. I want to turn all the disk sort into the memory sort ,but how can I malloc more sort memory for informix? Now my shmvirtsize is 800000(800M) Another question is: my server…
RE: 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…
cached tables
We have some tables which are static in nature. They are loaded every night and during the day are subjected to massive hits (read). Is there a way in Informix to keep such tables in memory only so that performance in enhanced. We use 9.21.UC4 and IIRC it allows STATIC tables to …
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…
Statement Cache in IDS 9.4
Hi, Apparently SQL statements are not cached by SSC(Shared Statement Cached) if the �like' keyword is used. I can change the query to use the equal sign instead of �like' and the statement would be cached (but of course defeats the purpose). The actual query we use is more e…
Re: Performance & checkpoint
you can double your LRU number to decrease your checkpoint duration. I have been suffered the same problem and I increase my LRU from 128 to 512 and I really help. Also you can increase your CKPTINTVL from 300 to 600. "Wayne T" <ntrieu@yahoo.com> ???????:e6623a40.0305121517.15f3…
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…
Changing of owner of a table
Hari Gupta wrote: > Hi Folks, > > I am sure there have been many posts for this issue in the past but I could > not find answer to my query below. > With Informix 9.21 on Linux 6.2 - How safe is (in terms of integrity of > system catalogue) to update systables > for changing owne…
Re: undocumented parameters
----- Original Message ----- From: Ricardo Manzo <Ricardo.Manzo@cosan.com.br> At: 3/12 16:20 > Hi all , > > Does anybody know the meaning about the parameters below and how does it affect > performance ? Yes... > DD_HASHSIZE Not to forget: DD_HASHMAX The above control the siz…
undocumented parameters
Ricardo; These are paired hidden parameters that tune the sizes of the data dictionary cache (DD_HASHMAX, DD_HASHSIZE); the data distribution cache, (DS_HASHSIZE, DS_POOLSIZE); and the stored procedure cache (PC_HASHSIZE, PC_POOLSIZE). These parameters are documented in the Per…
Time delay on ipcshm connection versus tlitcp
Tracy, Were these two tests run one after the other? Did we shutdown and bring up the instance? Were the tests run more than once giving the same results? I have seen many a test run where the second test through shows great improvment. The reson is obivous once you think about…
Re.systables.
Isn't it better to make sure that all the tables you routinely refer to remain in the dictionary cache, than to get too worried about extent sizes for systables & syscolumns. Or do I misunderstand what the dictionary cache is there for? Best regards, Andy. <.. snip ..> -- And…
Redbrick
----- Original Message ----- To: malcolmw@fast24.co.uk At: 3/26 8:29 Several commercial applications, notably SAP and PeopleSoft, have 10,000-30,000 tables, that's the main reason. Also there are instances, like our development servers here, where you may have over 100 databases…
Re: number of extents
David Williams wrote in message ... >In article <3a77a94b$1@news.iprimus.com.au>, Andrew Hamm ><ahamm@sanderson.net.au> writes >>Informix have written somewhere that no more than 8 is ideal because the >>extent pointers can all fit on one page in the system data for the table. >>…
Infomix monitoring tools
all, Anybody have come across any good and reliable informix monitoring tools, that can monitor like chunk/dbspace i/o, read write caching, dbspace info, table info and so on. Thanks and regards Tham…
Dictionary Cache
We have a second virtual memory segment which we would like to free up. No users are currently using this segment but we do have 11 tables out of 773 using in for Dictionary Caching. Is there a way of either removing these tables from the Dictionary Cache or rehashing them to try…
Informix Issues
David, First of all my congratulations on seeking information on what to monitor. Most folks simply use the number of user complaints as their only monitoring tool. If the users start complaining more than normally then somthing must be wrong. ;-) First of all, just as with t…
sqlcmd
Hello I have Dec/alpha UNIX OSF1 V 4.0 alpha, Informix Dynamic Server 7.31 and CSDK 2.40. I have a problem in compiling sqlcmd-57 utility: I compile the software using the following commands (with output): compile loading cache ./config.cache checking for gawk... (cached) gawk c…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: HewlettPackard XP 256
From: "Aboobacker VADAKKUMURI VALAPPIL" <aboo@syd-co.au.dhl.com> > >RAID10 is not yet supported in XP256. If XP256 would have support RAID10, >it Oh, really? >would not make much difference in Performance becuase most of the data will >be >cached. If you have a 4GB cache in XP2…
Cache Hit
Hi Can anyone please tell me how to force the cache hit to be as high as possible. Reason I'm asking, we clone the database (+-200 GB) and then do a backup of the clone. Problem we are running into is that the backup is taking a bit long - 16 Hrs. We are using the following: I…
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…
extents and system tables
adiosadios wrote: > > Hello! My cursory check of TFM turned up nothing so I am turning to all of > you. > > Our production db has several system tables that are approaching the 30 > extent range. I'd like to bring this down to a reasonable size (if it > useful). DON'T!!!!!! >…
DNS Question
I am an Informix DBA running Informix 7.3 UC7 on an IBM AIX 4.1.3 rs/6000 box. Recently, we had a network problem where one of the two DNS servers in our Unix server's table became unavailable. The Informix application began to slow down and eventually new users were unable to ge…
pooled connections and prepared statements
stormchaser wrote: > Thanks for your informative reply. I am disappointed that user > statement re-use is required, since the database should be smart enough > to do that for me. Do you know if preparing *each time* might result in > better cache performance? In other words, doe…
Fwd: FW: Why is rootdbs busy?
Based on your system load and number of buffers defined you might be suffering from statistics lookups. Try enabling Data Distribution Cache. My database system tables are in a separate DBspace and I reduced the I/O by 50% using the DDC. Mileage may vary, I have 30,000 tables …
Re: Why is rootdbs busy?
Ok, I'll "play" with this a little :o) Presumably the cache is part of the resident portion of memory, does it take any significant amount of memory? Tony. Art S. Kagel wrote in message <39AD63DE.8CD76D40@bloomberg.net>... >I'm going to differ with Madison and recommend that y…
Some IDS 9.2/4GL 7.3 strangeness
Recently updated to engine 9.20 and 4gl 7.30 and had a few suprises: ---------------------------------------------------------------------------------------------------------------------- Had this one today for the bug catalogue if it is not already in there. The insert action…
Re: Updating sysdefaults
Thanks Art. I was pretty sure it was a bad idea. The manual writers should avoid tempting us by mentioning that the system catalog tables can be updated by user informix or anyone with DBA privileges. "Art S. Kagel" <kagel@bloomberg.net> wrote: >Jeff Larsen wrote: >> >> Our s…
Re: Updating sysdefaults
Jeff Larsen wrote: > > Our salesmen are always changing their minds about default > values for new customer records. We have a 24-7 system and > I have to kick everybody out just to be able to execute... > > alter table customer modify rate char(1) default 'V'; > > I know the ma…
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: 2 Instances, 1 machine VS 1 Instance 2 databases
Keith L Morris wrote: > > Greetings, > > The current job I find myself in was setup with 2 INFORMIX instances > each with one database. (On the same machine.) > > We have applicattions that link to both concurrently and do work. > > I would THINK that ONE instance with TWO datab…
Re: 2 Instances, 1 machine VS 1 Instance 2 databases
From: Keith L Morris <keith.l.morris@wcom.com> > >The current job I find myself in was setup with 2 INFORMIX instances >each with one database. (On the same machine.) > >We have applicattions that link to both concurrently and do work. > >I would THINK that ONE instance with TWO…
2 Instances, 1 machine VS 1 Instance 2 databases
Greetings, The current job I find myself in was setup with 2 INFORMIX instances each with one database. (On the same machine.) We have applicattions that link to both concurrently and do work. I would THINK that ONE instance with TWO databases (giving the one instance all the…
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…
Number of LRUs, Cleaners & Buffers
i'd say the pct numbers look good. i dont think there is any reason to use affinity unless you are auditing and can only charge by the cpu. remember to change only one thing at a time, and to have a goal for your tuning. if 2 sec checkpoint time is acceptable to users, then forgo…
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…
cache
_______________________________________________________________ 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…
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…
prepares in 9.2
cstefanick@koz.com wrote: > I recently went from 7.22 to 9.2 (big change, I know). In 9.2 > statement cache is used so that similar query plans are shared. Does > this mean that preparing statements is no longer needed in 9.2? > > Sent via Deja.com http://www.deja.com/ > Befor…
RE: caching dynamic content?
>Can someone please shed some light on this for me? I doubt it:-) >A colleague of mind told me about a product that (allegedly) improves >web site performance 35x-50x by letting one cache dynamic content. Yeah >that's what I said, 'cache dynamic content'? What's the point? you …
stored procedure vs. prepared statement
Kevin Macclay wrote:We're running INFORMIX-OnLine Version 7.12.UC1. 1) Please do not post HTML/MIME to this list/newsgroup, many readers use the mail gateway and do not use HTML or MIME enabled mail readers. 2) I STRONGLY suggest upgrading your server to AT LEAST 7.31 or even as…
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…
Separating database system tables from the rest.
"Carlson@WHSmith" wrote: > > One of the issues I've had to deal with is the fragmentation of the > system tables within my larger databases. I thought that separating > those tables from all of the user tables within a database might be a > great ideas, for example: > > crea…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Re: Initializing Dictionary Cache and Stored Procedure Cache
From: mourad <mouradNOmoSPAM@vt.edu.invalid> > >I'm trying to run Initialize the database server (Ver 7.3) >for the first time using oninit -iyv >but I've got the following messages: > >Initializing Dictionary Cache and Stored Procedure >Cache...Cannot find message file. Check I…
Initializing Dictionary Cache and Stored Procedure Cache
Hi, I'm trying to run Initialize the database server (Ver 7.3) for the first time using oninit -iyv but I've got the following messages: Initializing Dictionary Cache and Stored Procedure Cache...Cannot find message file. Check INFORMIXDIR and DBLANG.FAILED INFORMIXDIR is cor…
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…
Re: Read Cache %age on IDS
From: "Arshad, Shehla" <SArshad@purolator.com> > >What are the general recommendations on improving the read cache %age. Add more buffers. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
Read Cache %age on IDS
What are the general recommendations on improving the read cache %age.…
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…
system catalog cleanup
"Thomas J. Girsch" wrote: > > I'm afraid I already know the answer to this, but is there any way to > defragment (i.e., "clean up the extent interleaving") of the system catalog > tables, short of dropping the database and recreating it? I've got a 100+ > GB database that has sy…
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…
Write cache help
Wayne Trieu wrote: > > Hi all, > Can some one please help me how to increase write cache, right > now my cache is about 73% it seem low. I've tried all source recommend I > see on this group, but did not help. May be I done something wrong. I > hope some one can look at my…
binding to cache
Hi Informix 730UC5 - Sequent Numa-Q I was discussing caching with a consultant that we have in at the moment, she mentioned that in oracle and sybase you can bind the database to cache - but this comes with the overhead of high memory usage. I was wondering if you can do a…
system catalogues and extents
jblatz@worldnet.att.net wrote: > > I know that it's recommended that the number of extents for a table be > kept at 8 or less. However I notice that many of the system catalogue > tables have 12 or more. Is there anything I should/could do about this? First, the recommendation…
Logical log usage and long transactions
Firstly, thanks to all who answered the mail "write cache hits slipping". Read caches are sitting nicely in th 99.4% mark. Write caches are still slipping, but I realise that I wasn't aggressive enough with my LRU settings, so that's something to look forward to at next reboot. …
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
SYSMASTER database and extents
"Hamilton, Jerry" wrote: > > Hi Everyone, > > I'm running IDS 7.31.UC2, HP-UX 10.20 with PeopleSoft Financials. > > I know that too many extents on data tables is not good. Is the same true > with the sysmaster tables? I have the following sysmaster tables with more > than 8 ex…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
read and write cache percentages
We are running 7.2 on hp 9000 with approx 240 users. I noticed the write cache percentage was 67%, the read cache percentage was 97%. Is the 67% ok. Are there any paramenters we should be looking at to increase this write cache percentage or is 67% an acceptable level? Than…
Nightmare NT configuration problem
Hi there, I have a dead-end problem that I don't understand... (involved with system installation so I simply can't work around it I install Informix dynamic server (universal data option) on my Windows NT 4.00 Server machine, set up the environment variables and try to run oni…
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: Write cache low
From: "Shevkar, Mukund" <Mukund.Shevkar@dgs.ca.gov> > >Following is onmonitor performance statistics and onconfig file listing. Missing the ONCONFIG, but the short answer is ADD MORE BUFFERS... :-) And your read cache is also way too low. >Can somebody help me improve write ca…
Write cache low
Hi everybody there Following is onmonitor performance statistics and onconfig file listing. Can somebody help me improve write cache please ? STATUS: Profile Userthreads Spaces Databases Logs Archive ... Display system profile information. -----------------------------On…
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.…
Informix JDBC file caching of BLOBs...
All, The Informix JDBC driver caches Large Objects to files that are retrieved from the database. An environment variable can be set to control the size of objects cached to files (e.g. using lobcache=8192 will cache to file any object larger than 8192 bytes). The problem is, th…
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: PC_POOLSIZE
Nick Miles wrote: > > Does anyone know how much memory is being used by the default Procedure > Cache? I'd like to increase the PC_POOLSIZE, but I'd feel more > comfortable knowing exactly what affects this will have. > > I've done some testing with PC_POOLSIZE, and the procedur…
Re: NOT IN TRANSACTION
> If you are the DBA (ie you can su informix), then from the command prompt, > type: > > ontape -s -<LogLevelSwitch> <yourdatabasename> > > where LogLevelSwitch can be U (for unbuffered logging), B > (for buffered logging) or A (for ANSI style logging). With > U all transactions …
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: Cached reads too low
>Absolutely agree. What impact KAIO has on caching ? None of course. But see my reply to the previous message in the thread. Neil…
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…
For the GURUS - sysprocplan and procedure cache
I am looking for the following information: 1. I have read in past postings that the limit on the number of stored procedure plans held in cache is 50. Is this completely independent of size? Is there anything besides sheer numbers that will bump a stored proc out of cache? (…
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?…
Sizing the dictionary cache. Does anyone bother?
andy lennard wrote: > > Hi, > > I was wondering if anyone bothers to change the size and layout of the > dictionary cache to improve performance. I certainly do. I have engines with 1500 active tables, how else to force the engine to keep all of that data in memory? [SNIP deta…
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.…
Flushing Cache
Does anyone know a way to flush cache in Online 7.2x short of a) writing a huge query, and b) cycling the engine? I am trying doing to query optimization and need to do raw timing of the same query written in different ways. Thanks! Cheers, Bryan Hughes Healtheon bryan@healt…
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 …
Re: How to invalidate informix' db-cache
In article <3649C80E.7F9@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Markus Pfadenhauer wrote: >> >> hi all, >> >> is it possible to invalide the whole internal database cache. >> By now I create some dummy tables and do a relationscan on them but >> this is not t…
Re: How to invalidate informix' db-cache
Markus Pfadenhauer wrote: > > hi all, > > is it possible to invalide the whole internal database cache. > By now I create some dummy tables and do a relationscan on them but > this is not the very best solution. There is no way to do this except to bounce the server. However, …
Re: Getting HTTP_REFERER from Web Datablase?
Hi Tony, I'm using Web Datablade 3.32.UC2, and calling as a CGI. I turned on webdriver tracing, and from the SQL statement that contains WebExplode function call, HTTP_REFERER appears once a blue moon, most other times not. Kinda weird. Ah wait, I think I know what's going on.…
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Best database for web backend on Linux?
On Wed, 21 Oct 1998 13:03:49 +0000, Evan Carew <ecarew@yahoo.com> wrote: >Simply put, The main reason I have selected Sybase over Oracle in the >recent past has to do with cache management. In every case, if >you try to use Oracle stored procedures in the same environment with >…
Re: write cache rate
Sadagopan, Sathish wrote in message <6vtini$k0t$1@news.xmission.com>... > >Hi, >I want to improve the " % Write Cache " rate , which parameters need tuning >apart from >BUFFERS ? >TIA >Sathish Sadagopan LRU_MIN_DIRTY, LRU_MAX_DIRTY and CKPINTVL all affect the frequency and type…
write cache rate
Hi, I want to improve the " % Write Cache " rate , which parameters need tuning apart from BUFFERS ? TIA Sathish Sadagopan…
RE: Stored procedures cache
The easiest solution would be to try to combine these stored procedures. Mike Gabbard Red Man Pipe & Supply Company -----Original Message----- From: Micha Meier [mailto:micha@ecrc.de] Sent: Saturday, October 03, 1998 4:49 AM To: informix-list@iiug.org Subject: Stored procedures…
Stored procedures cache
I have an application which relies heavily on stored procedures. Now I've read in Informix Unleashed that the cache can store only 16 procedures at a time and that it is not configurable to store more of them, however, in Gonzales: Stored Procedure Programming it says that the ca…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Hidden parameters for online
I have Informix Online 7.14.UD1. I obtain from Informix hidden parameters. DD_HASHSIZE n DD_HASHMAX n set table cache ??? Cajt…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
After Alter/Create Table => Get Error -937
I am using 9.12 UC2 on Solaris with the Web DataBlade 3.30.UC6 using nsapi with Netscape Enterprise Server. Anytime I alter or create any table (with SQL editor or dbaccess), I get error -937 "Table (tableName) has been dropped, altered or renamed" when I run my web pages. The …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: onstat -g dic
Art S. Kagel wrote: > Correct, it means that one or more of the system catalog tables has been > modified, through proper channels like an ALTER, UPDATE STATISTICS, > or CREATE/DROP INDEX statement, and the cached values are no monger > valid. The new values are not automatical…
Re: onstat -g dic
F.PALMITJAVILA wrote: > > Ok. > > What does it mean the DIRTI column? > > When she is YES, should I understand that the structure of that table to been > modified? Correct, it means that one or more of the system catalog tables has been modified, through proper channels like an …
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: Column Names Returned from a View
The act of setting the values in the onconfig and bouncing the engine fixed the problem. Whether it was the adjustment to the data dictionary or simply the re-initialization of the engine I can't say for sure. Thanks, Larry Kemmerling AT&T Wireless Services Aviation Comm…
Re: Column Names Returned from a View
Larry Kemmerling wrote: > > This is a follow up to my original posting. Thanks to everyone that > has offered help. > > I created a simple view: > > CREATE VIEW test > ( C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13,C14,C15,C16, > C17,C18,C19,C20,C21,C22,C23,C24,C…
Re: sysmaster extents
davin_harvey@dsti.co.uk wrote: > I have a couple of questions on this then > > I've got nothing set for DD_HASHSIZE or DD_HASHMAX. onstat -g dic > reports 357 dictionary entries, but surely the maximum size is 310? > Also, only 14 of these entries are syste…
Re[2]: sysmaster extents
This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable I have a couple of questions on this then=2E =20 I've got nothing set for DD_HASHSIZE or DD…
Re: Re[2]: fragmented system tables
OK I'm dense. Still it will not help unless he also drops the database and recreates it. However, my main point still stands: This is not necessary, the fragmentation of the system tables in a database has NO EFFECT ON PERFORMANCE! This is not off the top of my head, I have ha…
Re: fragmented system tables
Sven Tolkemit wrote: > > Hi people, > > we discovered, that the system tables (systables,sysindexes, etc.) on > our Online 7.23.UC1 are very fragmented. We think, this leads into > performance problems. Is there a way to defragment the tables? Definitive answer: NO! You cannot…
Re: sysmaster extents
Paul wrote: > > I am running Online 7.23.UC4 on HPUX 10.20. > Is it important for the DBA to be concerned about the number of extents in > the system catalog? > I have plenty of room in root to accomodate the growth. No 1) There is nothing you can do about it anyway and 2) Th…
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 "Scott Kolaya" <skolaya1@nycap.rr.com> : :Values of: : :LRU_MAX_DIRTY 3 :LRU_MIN_DIRTY 2 : :are commonly used for OLTP processing to decrease the length of a :checkpoint. How long are your checkpoints taking? They should be very :short with those values, …
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…
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: Read Cache, NUMCPUVPS
jeff, : Can someone explain what happened here? Are the numbers : "rolling over"? yup. it rolled over. no problems. do an onstat -z to zero out the profiles if you don't want to look at those negative numbers. it would be nice if this was fixed, as there is no reason that…
Re: Read Cache, NUMCPUVPS
In article <6cunjh$ird$1@nnrp1.dejanews.com>, jeff.w.mcclure@ameritech.com writes >Hi, > >I'm relatively new to Informix and have two >questions that I need answers to. > >Sparc 20 running Solaris 2.4 >Informix ODS 7.11.UC1 > >First: >I checked the instance profile last night (on…
Re: Read Cache, NUMCPUVPS
jeff.w.mcclure@ameritech.com wrote: > > Hi, > [cutting] > > Second: > Since this is a development machine, we decided to bounce > the instance. Great! I wanted to check out the effects > of adding a second cpu vp. This is a multiprocessor (2) > machine! I set NUMCPUVPS to 2, M…
Re: Read Cache, NUMCPUVPS
jeff.w.mcclure@ameritech.com wrote: > > Hi, > > I'm relatively new to Informix and have two > questions that I need answers to. > > Sparc 20 running Solaris 2.4 > Informix ODS 7.11.UC1 > > First: > I checked the instance profile last night (onstat -p) > and all looked great. dsk…
Read Cache, NUMCPUVPS
Hi, I'm relatively new to Informix and have two questions that I need answers to. Sparc 20 running Solaris 2.4 Informix ODS 7.11.UC1 First: I checked the instance profile last night (onstat -p) and all looked great. dskreads, pagreads were both very low, Buffreads was very hi…
Re: bufwait tunning
Set your RA_THRESHOLD lower. The ninth and tenth pages are being processed before the next ten pages arrive in the buffer cache.…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
the new bie with the share memory problem
Hi all: Thanks for all those who has responded to my previous question, you guy were a great help. Now I have put all the necessary stuff in /etc/system, rebooted, ran oninit -v, my results are: oninit -v Reading configuration file '/usr/yan/Informix/INFX_ODS_723/online/etc/o…
the new bie with the share memory problem
Hi all: Thanks for all those who has responded to my previous question, you guy were a great help. Now I have put all the necessary stuff in /etc/system, rebooted, ran oninit -v, my results are: oninit -v Reading configuration file '/usr/yan/Informix/INFX_ODS_723/online/etc/o…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: chekcpoints, BUFFER settings, and optimization
David Williams <djw@smooth1.demon.co.uk> wrote: >>INFORMIX-OnLine Version 7.22.UC1 -- On-Line -- Up 49 days 04:48:56 -- >>85264 Kbytes >> >>Profile >>dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached >>10363 10367 1405830 99.26 384…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
Hi CDI peeps, Pablo Sanchez wrote: > In article <3357D8D8.35C5@informix.com>, Dan Crowley <dcrowley@informix.com> writes: > I don't agree with the above justification for 1 gig data cache. On a machine with 4 > gig memory, we only get to use 25% of it? Well, okay the buffer …
Re: What's the problem with stored procedures
Jacob Salomon wrote: > > Kirk Waterhouse wrote: > |I had an Informix employee (a fairly high level consultant type) tell > |me that I should not use stored procedures with Informix. He said > that > |Informix did a very poor job of implementing stored procedures. He > said > |tha…
Re: Major performance problems with Informix Online
Ivica Smolic wrote: > > On Sat, 25 Oct 1997 09:36:44 +0100, David Williams > <djw@smooth1.demon.co.uk> wrote: [snip] > > AFFINITY is binding processes to CPUs. It basically improves the > > use of the Level 1 and Level2 caches on the CPU by always running the > > process on th…
Re: doubt in onstat -g -dic
VASA SRINIVASA wrote: > > I have gone through system administration manual to find out the > detail column descpitions of onstat -g dic, specially 'refcnt'. I > coundn't find any reference to 'refcnt'. Please mail me details of > columns of onstat -g dic . Onstat -g dic reports …
Information About Views
How does Informix handle views. Does it execute the SQL statement everytime someone accesses the view or is the view cached? When you create a SQL statement against a view with a WHERE clause does the view select all the information first then apply your WHERE clause or does it…
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: Update Statistics Question
> I understand the need for running UPDATE STATISTICS for the tables >in a database. The recalculated data from this command is going to be >placed in the systables, syscolumns, sysindexes and sysdistrib system >catalog tables. After updating statistics for user created t…
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…
Reply to SELECT too slow
Hi: 1:you should provide your sql statement in details,which maybe a simple select , a join,or subquery ,etc. In different case they will result in different performance. Also you should provide your table schema,index,and sqexplain. 2.I think three fector will affct your perf…
Re: Caching tables in shared memory
Hi, OnLine 7.3 will likely contain options to indicate that specific tables should be favoured for caching. This can be used to bias caching for highly active tables. Chris -- Chris Jenkins (chrisj@informix.com) Advanced Technology Group >>> All statements and opinions are…
Caching tables in shared memory
Hi Gurus, Here are a few questions regarding caching of frequently accessed table in shared memory. During a recent setup , I found that in my code a few of the tables were accessed very frequently. These are master tables and this particular module need not do any updates on th…
Re: Performance Tuning
Hi, I presume you are talking level-2 CPU<->memory cache here. If so there are no informix parameters to change. This type of hardware change is transparent to us (though hopefully overall system performance will improve). Chris DRI wrote: > I am going to put in a 1 gigabyte c…
Performance Tuning
I am going to put in a 1 gigabyte cache module into our informix server which currently has a 256k cache. My question is can any one tell which settings have to be changed so that informix will utilize the new cache size and any other memory utilization settings that may help.…
Re: dbaccess faster than ESQL/C ?
Are you using the same network facility in ESQL as with dbaccess? WHich di you run first? The reason I ask is because whichever is running second has the benefit of the data being cached (unless you bounce the engine in between runs). The only things I see that can make a differ…
Re: Functions using variable values (shell archive)
Here is the promised source code for whoever is interested. ------- Cut Here ------- #!/bin/sh # This is a shell archive (produced by GNU sharutils 4.2). # To extract the files from this archive, save it to some FILE, remove # everything before the `!/bin/sh' line above, then t…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <5j39eg$2sj@mew.corp.sgi.com>, Pablo Sanchez <pablo@mew.corp.sgi.com> writes > > >In article <0v8awLAcPRVzEwpS@smooth1.demon.co.uk>, David Williams ><djw@smooth1.demon.co.uk> writes: >> >I can do a *moderate* comparison between Informix and Sybase (32 bit >> >port): >>…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <0v8awLAcPRVzEwpS@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> writes: > >I can do a *moderate* comparison between Informix and Sybase (32 bit > >port): > > > >Sybase 11.0.X Informix 7.22 > >------------- ------…
Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server
In article <5ith88$14g@mew.corp.sgi.com>, Pablo Sanchez <pablo@mew.corp.sgi.com> writes >[ 1 - I've snipped, what I believe, were a whole bunch of unrelated > newsgroups from this note. I've left only the comp.database.* > > 2 - If you disagree with what I've written, let'…
Re: Performance problem
Raymond Chow wrote: > > Help please!! I have two different machine. Risc6000 R40 and Risc6000 59H. > R40. IGB RAM, SSA DISKS, faster CPU > 59H, 324MB RAM, slower CPU. > > My day end run, seems that the 59H is faster than R40. Sounds ridiculous. > But it is true. > Any help in her…
Re: Performance problem
Raymond Chow <raychow@pc.jaring.my> escreveu no artigo <01bc3a2c$94c45c80$d3db8ea1@Mimos.Jaring>... <snip> > My day end run, seems that the 59H is faster than R40. Sounds ridiculous. > But it is true. > Any help in here? > Any reference on good Informix performance tuning book? …
Performance problem
Help please!! I have two different machine. Risc6000 R40 and Risc6000 59H. R40. IGB RAM, SSA DISKS, faster CPU 59H, 324MB RAM, slower CPU. My day end run, seems that the 59H is faster than R40. Sounds ridiculous. But it is true. Any help in here? Any reference on good Informix p…
INXUTIL MARCH ISSUE
The March Issue of INXUTIL�Magazine is now available: http://www.mindspring.com/~tschaefe When arriving be sure to reload the opening pages. Your local cache may not be showing you the current version of the page(s). Enjoy! Tim Schaefer tschaefe@mindspring.com www.mindspring…
Re: Informix: Please buy Borland
Let me preface this posting by saying that I am *not* interested in converting anyone from Informix to Sybase. As a matter of fact, I'm planning on taking two Informix classes next week to learn about Informix. My posts regarding Sybase are more for educational purposes rather …
Re: Informix: Please buy Borland
pablo@mew.corp.sgi.com (Pablo Sanchez) wrote: : :In article <33146861.31595912@gate.idg.no>, Nils.Myklebust@idg.no writes: :> :> Sybase may have spread their resources to thin, but their basic error :> was in their server design. : :Would you please elaborate on this basic error…
Re: A performance question
Gregory Trubetskoy wrote: > > I am evaluating Informix on NT (to possibly replace MS SQL Server), and > I notice a significant difference in performance. > > I did a little tweaking, not too much - I set BUFFERS to 6000 (x4096K > page)(the machine has 128 Meg) SHMVIRTSIZE to 16Me…
Re: A performance question
In article <330B7E2B.6916@thetsn.com>, Gregory Trubetskoy <grisha@thetsn.com> writes >I am evaluating Informix on NT (to possibly replace MS SQL Server), and >I notice a significant difference in performance. > >I did a little tweaking, not too much - I set BUFFERS to 6000 (x4096…
Stored Procedure cache size (PC_POOLSIZE)
Hi there. Anybody knows how the PC_POOLSIZE parameter affects the stored procedure cache? System is ODS 7.1 on SCO Unix OSR5. Thanks Bashar Chalabi Card Tech Limited…
Re: Prepared V Inline sql
Peter Jennings wrote: > > The environment is Online V5 under AIX. > > We have been running some simlple tests to compare the > performance of prepared sql to inline coded sql in an > esql-C program. Our intuition and experience of other databases > tells us that prepared (dynamic…
Re: Prepared V Inline sql
Peter Jennings (peter_jennings@uk.ibm.com) wrote: : The environment is Online V5 under AIX. : We have been running some simlple tests to compare the : performance of prepared sql to inline coded sql in an : esql-C program. Our intuition and experience of other databases : tells …
Re: Why or why not to use triggers
There's not really a lot of overhead in the 'firing' of the trigger as the procedure cache should handle keeping quite a few of the stored procedures in memory anyway. However, if you have a lot of them, there might be some overhead because stored procedures are pseudo code and …
Re: sqlca and delphi
Frank Tschirpke wrote: > > Hallo, > > we need the sqlca-struct in delphi (1.02) and informix OnLine (7). How > can we access this struct? > > frank Frank, From the BDE API Help: Native handles allow you to bypass BDE functions to use native SQL database APIs to create and mani…
Re: SPL & Triggers - do's and don'ts
In article <3291472D.5831@sprynet.com>, Jake Salomon <jsalomon@sprynet.com> writes >As far as I recall, the SP cache is still limited to 50 procs. This is >not [yet] a tunable to keep those feature requests coming, folks! > Where did you hear about this limit - I cannot find …
Re: Stored procedures and DR
Billy Wheeler wrote } }> .. one of the developers }> created a stored procedure and it was running fine on both mahcines }> primary and secondary. He later changed it and the change did not occur }> on the secondary. Better yet, he dropped it from the primary and it }> still ra…
caching question
Are there different rules for caching of index pages versus data pages ?? Or is it just LIFO for everything ? TIA, -Lin…
caching log, temp files
Are there any log, temp or other files which informix will not, or is not recommended to, cache in CPU main memory?…
Re: CACHE BUFFERS
Billy Wheeler wrote: > > Kevin, > > There is no reason to have a large number of UNIX kernel buffers if you're > using OnLine. I assume it's V*d*c. The only reason you would want many > buffers is if you were doing lots of file system access. Wellll, not exactly. OK, since it's…
Re: CACHE BUFFERS
Kevin, There is no reason to have a large number of UNIX kernel buffers if you're using OnLine. I assume it's V*d*c. The only reason you would want many buffers is if you were doing lots of file system access. Something else you might want to consider is moving to compiled 4GL.…
Re: CACHE BUFFERS
In article <4q6of3$th@hermes.is.co.za>, "K.J. Gribble" <kgribble@icon.co.za> writes >Hi All > >I there anybody which can help in clearing up the differences between the >Informix 5.0 buffer settings and the SCO Unix buffers settings ??? > >Are they related and effected by each ot…
CACHE BUFFERS
Hi All I there anybody which can help in clearing up the differences between the Informix 5.0 buffer settings and the SCO Unix buffers settings ??? Are they related and effected by each others settings ??? Thanks Kevin Gribble…
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: Stored Procedures in Client/Server Env.
govardha@plains.nodak.edu (Jogendra Govardhanagiri) wrote: > I have couple of questions on using SPs in the client/server environment. > I like to get some info. on this. >1) Is there any limit on the number of clients calling a single > procedure at the same time? There is …
RE: How to reduce extents 5.x OnLine
>Saeid Yazdanmehr writes... >I am wondering if anybody has done the follwoing: >1) Trying to reduce Extents for performance improvement on an Informix >database version 5.0. Simply use tbunload/tbload. This compresses the extents and OnLine handles the compressed ext…
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?…
Informix Perf Question
-> 0% - 30% cache reads and 80% - 95% cache writes. On the other servers the -> cache read and write range from the high 80% to 90+%. Is it possible that -> the applicationbs software is negatively impacting the cache %?? Well, yes, I would imagine that the application could …
Re: Informix and SCO
Gary L. Burnore (gburnore@netcom.com) wrote: : I'v developed an application that runs SE on SCO that's installed at : about 35 locations worldwide (actually USA/Mexico but worldwide sounds : cool). Generally between 100-300mbn data stored in each. The key is to : NOT use IDE d…
Caching Hard Disk Controllers and ONLINE
Does anyone have any comments on using Hard Disk controllers with built-in caching while using Informix ONLINE's raw disk chunks? Thanks! -- Tom Lowe tomlowe@speedway.net or tomlowe@delphi.com…
Database monitoring tools
I am interested in tools to monitor Oracle and Informix databases over time in a distributed UNIX environment. Desired features include: o Predict future resource consumption based on past usage over time, and report problems on an exception basis. For example: Based …
Re: 0% caching
>From: uunet!enuucp.eas.asu.edu!anasaz!qip.naomi (Naomi Walker) >Subject: 0% caching >Date: Thu, 12 Nov 92 16:28:24 MST >X-Informix-List-Id: <list.1607> >Here's one that has me stumped. We are running Online, on an AST 486 >with Interactive Unix. We have been tuning tbconfig t…
0% caching
Heres one that has me stumped. We are running Online, on an AST 486 with Interactive Unix. We have been tuning tbconfig to help some performance problems, and last experiment showed something odd. When we changed BUFFERS from 512 to 2048, % cached (disk writes), flopped to 0%.…
Re: SQL Precompilers (preoptimize!)
Path: emory!swrinde!elroy.jpl.nasa.gov!orchard.la.locus.com!prodnet.la.locus.com!jfr From: jfr@locus.com (Jon Rosen) Newsgroups: comp.databases.informix Message-ID: <1992Mar04.203112.01004902@locus.com> Date: 4 Mar 92 20:31:12 GMT References: <1992Mar4.160455.12513@rock.concert.n…
Cache in C-ISAM
Path: emory!sol.ctr.columbia.edu!zaphod.mps.ohio-state.edu!qt.cs.utexas.edu!cs.utexas.edu!uunet!shearson.com!newshost!fsmadja From: fsmadja@figment.shearson.com (Frank Smadja) Newsgroups: comp.databases.informix Message-ID: <FSMADJA.92Feb10133757@figment.shearson.com> Date: 10 Fe…
Flushing changes
Path: emory!wupost!darwin.sura.net!gatech!udel!rochester!cantaloupe.srv.cs.cmu.edu!crabapple.srv.cs.cmu.edu!andrew.cmu.edu!<UNAUTHENTICATED>+ From: Sean.Levy@cs.cmu.edu Newsgroups: comp.databases.informix Message-ID: <EdYNfaS00hMgQ7TYBn@cs.cmu.edu> Date: 6 Feb 92 20:30:30 GMT Org…
SQL security management (Informix/Oracle)
Path: emory!swrinde!cs.utexas.edu!uunet!ftpbox!mothost!techmpc!daves From: daves@techmpc.csg.gss.mot.com (Dave Schmitt) Newsgroups: comp.databases Keywords: sql, informix, oracle, security Message-ID: <1991Sep6.020024.18002@techmpc.csg.gss.mot.com> Date: 6 Sep 91 02:00:24 GMT Org…