Oninit® Archive
Results for “DS_POOLSIZE”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
Limit User Connections
Hi, We are running Informix 12.10.FC9W1X1 on Solaris. Is there a way to limit the number of DB connections based on User ID? Each user connects to the DB using their own user ID so we are not using connection pools. We want to limit on the Informix side and set a max number of c…
contention on dstpool
Hi, I run 'onstat -g spi | sort -nr -k 2 |head -20 , and the output show high contention on dstpool,currently the ds_hashsize is 31, ds_poolsize is 127, How to tune those two parameter, Do anyone has any guideline ? thanks.…
locks persists while client app is down
We are running IDS 12.1 FC6 on Solaris. Last day a unix box residing java applications gone irresponsive due to high load on it. We restarted the machine but there were locks even the applications were down (these applications maintain jdbc connection pool with IDS database). We …
Connection Manager for HDR in Windows server
So now got clarity. We have to create the SQLHOSTS file in application server. In my scenario the SLA is sla_1. How/where to add the SQLHOSTS entries for application host (JBOSS Server)? Is there any Client bundle/Software to install on application server (JBOSS) to communicate…
User Name from Connection Pool
Hi, We are running 11.70.FC7W2 on Solaris. We have a Java application that uses a connection pool for Informix DB connections. However, we have many triggers that log user activity on certain tables. We would like to log the user that made the change, however from the DB side we…
too many statements in memory
Yes, it is a very common java issue with connection pools. Just look for ifx_autofree and set it to 1, in your connection property or inside your jdbc string. Em 13/04/2016 12:19 PM, JACOBO BALBUENA <jacobo.bc@gmail.com> escreveu: As always, thanks in advance. I have a plague h…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
Help on jboss memory usage for persistant sessions
Hi, the problem is probably in the application, not in the database. When using a JDBC connection, each object should be closed after usage. ResultSet, PreparedStatement, Connection etc. When using a connection pool, the connection.close() method will return the connection to th…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
session/connection last used time
IDS 11.50 FC7 on redhat 4 I'm investigating an issue we have with a db connection pool adding more connections and consuming shared memory resources. I think there is a problem with existing connections not being used/closed but new ones being added instead. I know from the syss…
Database with unbuffered logging + JDBC connection
Unless you really needit and do manage you EJB to XA distributed transaction, configure your jdbc-connection-pool (on glassfish) with option non-transactional-connections="true" . El mié, 10-10-2012 a las 12:05 -0400, Laird Nelson escribió: > Hello; trying to track down a puzz…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
Isolation level on a connection pool data source
I need to set the isolation level on a Glassfish connection pool that is hooked up to Informix 11.7. We are (apparently) running a non-ANSI database that does not have a default isolation level of LAST COMMITTED (5), so in our case we need to set it deliberately. From consulting…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
Problem with identifying root cause of continual m
Ok. I think it probably some application problem. Could you check out if your Informix server is using OPTOFC=1 value? It should. I also suggest you to search for the JDBC connection string (or properties), for IFX_AUTOFREE parameter. It also must be turned on. Maybe that´s the c…
Error with XA transactions
Hi All, Hope someone familiar with XA transaction setup via WebSphere can provide me some answers. We recently switched from Connection Pooling to XA transactions via WebSphere, connecting to some Informix 9.40 databases. We started receiving SQL Exception error messages "The da…
Which .Net provider, and where?
Thanks, Are you aware of a connection or connection pooling issue in the Informix provider? I am getting sporadic (and unpredictable) 'cannot create user thread' errors from the .Net provider which seem (from the call stack) to be concerned with opening a new connection. The cli…
Physical Log Size
How did you "increase" the size? You can only do that song onparams. You cannot do that just by changing the Onconfig file Art On Jan 25, 2011 12:10 PM, "KENT GRUNDEN" <k.grunden@hoogwegtus.com> wrote: > IDS 11.50.FC4WE Windows Server 2008 64bit > > I keep getting the message wh…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
AF During Archive - Looks Familiar
hi Mike, I was excercising a workaround for similar issue few weeks ago, reading now Art's post I'm quite sure the 'bad page' issue was a result of engine crash - it was not on production but on Development machine. Our developers like to test new things like new JDBS/JBOSSes and…
new onconfig parameters added onconfig file 11.5
most of these aren't new at all. Some have been around since 7.10. Some were undocumented until around 9.30 or so. Others were new in 9.40 or 10.00. There are a few really new ones, but, the server upgrade does not, to my knowledge, update the ONCONFIG file at all. Art Art S. K…
Database and ColdFusion connections
Hello all, We use ColdFusion (CF) as the web front end and informix version 10.fc9 on aix 5.3. It looks like CF manages the pooled connections and threads hitting the database just fine when the results are returned according to the time out setting. However, the problem is whe…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
odbc connection pooling settings (in windows client)
Hello, in the odbc control panel in windows, i go to the connection pooling tab (not sure in english how it shows to you), i double click on IBM INFORMIX ODBC DRIVER and there there is a window with an entry for the amount of seconds for keep a connection in the pool. There is a…
Re: Connection Pool JDBC 3.5
The result of my own investigations: You definititly have to use jndi in order to profit from informix connection pooling. Greetings Markus "Markus Bschorer" <mb@worxbox.com> schrieb im Newsbeitrag news:4af7cfc0$0$6733$9b4e6d93@newsspool2.arcor-online.net... > Hi all, > > IDS 1…
Connection Pool JDBC 3.5
Hi all, IDS 11.5, JDBC 3.50 I tried to use connection pooling, without any JNDI-Registrations. IfxConnectionPoolDataSource cpds = new IfxConnectionPoolDataSource(); cpds.setIfxIFXHOST(m_hostname); cpds.setPortNumber(m_port); cpds.setServerName(m_dbservername); cpds.setUser(m_u…
Weblogic V.10 (on Solaris 10) and IDS11.50 (on lin
Hi , Can I connect weblogic 10 (Solaris 10) to IDS 11.50 (on linux) ? I got a problem when try to activate weblogic : " weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: com.informix.asf.IfxASFException: Invalid ASF API input par…
physical log might be too small
Hello, We are getting following error while checking checkpoints "Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoint processing. The server might block transactions during checkpoints. I…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
RE: Connection Pooling with the .NET Provider on IIS
Sigh. Souka ... Again, I have to say this... you need to think about what you are saying. With respect to MC, you're jumping in to how a web app authenticates and how it tracks a user via its session information. (Note: Depending on how complex you want to get, you can track a …
Re: Connection Pooling with the .NET Provider on IIS
Ian Michael Gumby wrote: > With respect to Fernando's earlier post, you have to think about the > security risks if you can change your connection details within the > pool. Not a good idea. > I'd like a more elaborate response if you can. As I said, it's doable by other RDBMS.…
Connection Pooling with the .NET Provider on IIS
I have developed an Intranet IIS web application that is configured to use Windows Authentication against our Active Directory. The sites run with identity impersonation so all connections against the database SHOULD use the the credentials of the original user who requested the …
Connection Pooling with the .NET Provider on IIS
I have developed an Intranet IIS web application that is configured to use Windows Authentication against our Active Directory. The sites run with identity impersonation so all connections against the database SHOULD use the the credentials of the original user who requested the …
Informix Connection Strings
Answer was surprisingly simple. I just left the user name and password out of the connection string and all is fine. I have observed some very strange issues, which I think relate to a bug in the connection pooling code. I'll post that as a new thread.…
ISAM reads of system catalog tables
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. It looks like your data dictionary cache is mis-sized. > Look at the DD_ parameters in the ONCONFIG file. They must prov…
Problems with Connection pool and Informix 11.5
Hi, We have IDS 9.40 and a web aplicattion with apache 2.0.53 and tomcat 5.5.26. We use a jdbc of informix 9.40 and a pool created with this iformix jdbc. When we close a connection, this is closed on the server. We are going to migrate to IDS 11.5 and we have substituted the jd…
9905 error with varchar in a multiset
sounds like an occasion of an oldie: 130885 9628 TYPE NOT FOUND USING SPL WHEN ROUTINE/EXT TYPE CACHE IS HAMMERED ERROR IS STORED IN SYSPROCPLAN up the values for PC_POOLSIZE, DS_POOLSIZE, DD_HASHSIZE,DD_HASHMAX, PC_HASHSIZE,DS_HASHSIZE etc. Superboer. On…
Connection Pool
Hello everybody! I have been looking for this issue for some hours and I wasn't able to find anything. How can I use the connection pool for IDS 9.4? I'm developing in C# of Visual Studio .NET. Until now I have been using Oracle. And to use the connection pool, I only had to u…
Informix .Net Provider Connection Pool Issue
I was wondering if any of you can help me out here. I'm developing an application in Visual Studio 2005 using the .Net Framework 2.0 connecting to an Informix 9.40C2. I'm using version 3.50.TC1DE of the Client SDK drivers and I'm having an issue with the database connection pool…
Re: setting up the connection pool in netbeans for informix database
hmm not really assume that User" value="bpadmin" Password" value="pass" is correct, can you try this using dbaccess ->> connection--> user bpadmin -->passwd pass also did you check if your informix jdbc driver is in your path... you could goto the examples and see/test if you…
setting up the connection pool in netbeans for informix database
Hello! I have trouble with setting up the connection pool for informix database in netbeans ide 6.0.1 I've found netbeans tutorial which explains how to set up the connection pool for mysql database. I followed the steps from tutorial,but it doesn't work for informix database. …
ODBC Connection Pooling and Temp Tables
Hi, i need to filla .NET Data Set with 3 related tables, the bottom line is for the best explain i need frst to do a select XXX into temp... And the fill the tables with joins to the TEMP table. Im using ADO.NET Odbc Data Provider and IBM INFORMIX ODBC DRIVER (3.00 TC3) I woul…
Recover Informix JDBC connections in Tomcat after loss of Network Connectivity
Hi everyone. My application makes use of Informix, Oracle, SQL Server and My SQL. Of all these databases, whenever my web server loses connectivity with a database server, only the Informix connections do not recover. For all the other databases, restoring connectivity between…
RE: Informix hang
Does this application run under tomcat, where are the informix jdbc files situated, what OS etc. Do you ensure that when the trasaction is complete, all connections are closed? if you run onstat -g ses, is there more connections than are actually running ie: previous sessions ar…
Informix hang
Hi, We are running a Java application under load which uses Informix JDBC driver The Informix server is located on another server First we tried static connection pool, everything seems to work fine however for some reason we can not use static connection pool So, we enable dyn…
connection issues
Mark wrote: > Hi all, > > we are having issues with connections not being released timeously from the > database. > Sounds like the clients are Windows apps. Windows is notorious for not releasing TCP connections. One thing, as you have already tried, it to disable connection po…
"Dynamically added new Virtual segment "question
> What do I do? (and don't start me on onmode -F on HP-UX!!!!!!!!!!) > First off is onstat -g seg to find the address of the new segment, no > problem. > But once I've done that, what's the next move? > I'm guessing onstat -g mem and find out what processes have a pool > starting…
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
Actually I believe the confusion is betwen the DS cache values with the DD cache variables. DD_HASHSIZE and DD_HASHMAX mean something else. DD_HASHSIZE is the number of buckets or lists, and DD_HASHMAX is the number of entries (soft limit) per buck or list. DS_POOLSIZE indica…
Re: Calculate optimal value for DS_POOLSIZE
>mohitanchlia@gmail.com >Version: IDS 10 >I am trying to determine the optimal value for DS_POOLSIZE and >DS_HASHSIZE. I looked at the onstat -g dsc. I have following question: > >1. How do I determine the correct size of DS_POOLSIZE. Should I look >at our update stats and see nu…
Calculate optimal value for DS_POOLSIZE
Version: IDS 10 I am trying to determine the optimal value for DS_POOLSIZE and DS_HASHSIZE. I looked at the onstat -g dsc. I have following question: 1. How do I determine the correct size of DS_POOLSIZE. Should I look at our update stats and see number of unique columns that w…
Re: General IDS 11 question
----- Original Message ----- From: "John Carlson" <jwcarlson1@yahoo.com.invalid> Newsgroups: comp.databases.informix To: <informix-list@iiug.org> Sent: Wednesday, July 25, 2007 10:13 PM Subject: General IDS 11 question > Of those of you who are using IDS 11 in a production envir…
Re: How to clean connection pool with Informix .NET provider (Client SDK)?
Hello Sheshnarayan, the problem is that i am using connection pooling and when a problem occurs i want to clean the connections that are already in the pool. So is there a way to clear the connections that are already in the pool ? Sheshnarayan Agrawal : > Did …
How to clean connection pool with Informix .NET provider (Client SDK)?
Hello , does somebody know how to force to clean the connection pool with Informix .NET provider (client sdk) ? Thank you…
Serial Column Informix 10.x
Hi Frank, Thanks for replying.Your suggestion works only when i get a connection using DriverManager.getConnection. When i try to get a connection from a datasource (Weblogic 8.1 connection pool) i get ClassCastException . I need to use Connection pool only. Can someone tell m…
Database without transactions in WAS
Hi: In websphere I need to use a connection pooling with a database that have no transactions. I configured a datasource but I do not found any place to tell that ti Websphere. The application is a web application and works fine if I use a jdbc connection made by hand. Can an…
Problem connecting asp .net to informix
DataBase=...;Server=...;User ID=...;Password=...;CLIENT_LOCALE=...;DB_LOCALE=...;Pooling=true; Please note that DB_LOCALE should be set to the locale with which the database was created. The default DB_LOCALE for unix is en_us.819. Pooling is optional, and default value is true…
set role and connection pool datasource
Hello friends, We are going to use a connection pool DataSource on the Websphere application server. DataSource uses standard JDBC properties to connect to the DB. In our IDS we use DB roles. I would like to know if there is a way to use DB roles with this connection pool D…
Re: Really Frustrating -9628 Errors
Sounds like a bug i've seen before but 'should' have been fixed??? ... update stats will work but it only for xx hours and someother may fail. phone TS and have them look in their bugdb. wa afaicr is cranking up spl cache params PC_POOLSIZE, DS_POOLSIZE, DD_HASHSIZE,DD_HASHMAX…
Optimizing a BaaN installation
> Query sysmaster:syscfgtab (sysmaster:sysconfig is a view that hides undocumented paramaters)! 64 DD_HASHSIZE 1 31 31 65 DD_HASHMAX 1 10 10 95 DS_HASHSIZE 1 31 31 96 DS_POOLSIZE 1 127 127 111 DS_MAX_QUERIES 0 1 1 -1 112 DS_TOTAL_MEMORY 0 2048 2048 -1 113 DS_MAX_SCANS 0 1048…
Connection Pooling
We are using the odbc driver "INFORMIX 3.31 32 bit" The version is 3.31.000 2.40.TC1 When I look at it the set up for it in ODBC drivers, it says <not pooled> under the connection pooling heading. Yet, when I close a connection in a program, my temp tables do not drop. That is,…
Re: FW: Latch Waits
I was talking about DS_HASHSIZE and DS_POOLSIZE which configure the distribution cache, not about DD_HASHSIZE and DD_HASHMAX which configure the dictionary cache and which use a mutex with a different name. Michael Colin Dawson wrote: > I have DD_HASHSIZE=997 and DD_HASHMAX=27,…
RE: FW: Latch Waits
I was talking about DS_HASHSIZE and DS_POOLSIZE which configure the distribution cache, not about DD_HASHSIZE and DD_HASHMAX which configure the dictionary cache and which use a mutex with a different name. Michael Colin Dawson wrote: > I have DD_HASHSIZE=997 and DD_HASHMAX=27,…
Re: Sudden & massive SHMADD activity; engine went BANG!
Well we have got some relatively new apps connecting via JDBC, and we have run into an issue before whereby the connection pools aren't freed unless they explicitly close the connections.... Sounds plausible. I'd appreciate a copy of the script if you're ok with that, thanks RK.…
Re: Sudden & massive SHMADD activity; engine went BANG!
Well we have got some relatively new apps connecting via JDBC, and we have run into an issue before whereby the connection pools aren't freed unless they explicitly close the connections.... Sounds plausible. I'd appreciate a copy of the script if you're ok with that, thanks RK.…
Connection Pooling for 4GL/dbaccess
Hello all, Our application relies heavily on many short lived 4GL and dbaccess sessions. In the process of some performance tuning, I am noticing that executing a simple query through dbaccess on clients (remote from the DB server using tlitcp), can take anywhere between 100 an…
Connection Pool Error in Linux - Work in Windows
--=======2B2546CE======= Content-Type: text/plain; x-avg-checked=avg-ok-24C6DE2; charset=us-ascii; format=flowed Content-Transfer-Encoding: 8bit Hi We are trying to configure a Connection Pool with Tomcat 5.0. We developed an application that runs in Windows environment but whe…
Session memory usage
Hi, does someone know how much memory a user session takes on a Informix database server? How many concurrent user sessions can a normal server (4 GB primary memory) handle, before connection pooling is needed? /Fredrik…
how release threads?
dear all we have an java application running on websphere 5 and using jdbc connection pooling accessing data in IDS 9.40.FC3 on AIX 5.2, pdqpriority=1 there is 20 connections-user session used by appserver and reused within connection pooling by many users however, the number …
Re: JDBC x IDS 7.31.UD6
There have been a number of fixes in the JDBC driver for WebSphere and connection pooling related issues. Please use 2.21.JC5XF. Thanks, Venkatesh. Fernando Nunes <spam@domus.online.pt> wrote in message news:<2k44r6F17otb3U1@uni-berlin.de>... > Ferronato wrote: > > > > > PLEASE…
JDBC x IDS 7.31.UD6
Ferronato wrote: > > PLEASE: > Have somebody knew about other (or right) versions of JDBC or some fix > pack to update it ?? Why do you think there is a problem with JDBC driver? What error do you get? Are you using a pool of connections? Other AS have options to test the conne…
JDBC driver ( Informix & WebSphere )
Hi all Have somebody used WebSphere to connect Informix (as pool connection) ? I'd like to know where I can find (and get) the JDBC driver to this connection. Thanks in advance. R.Ferronato…
Problem with .net provider for Informix
Hi every one, can someone try to help us with this issue? we are trying to use the new .net provider for Informix. We are having big problems to get it to work. We are able to send one or two calls but then we get all kind of error messages and it often ends with that Informix o…
.NET Managed Provider
Does anyone know when the .NET managed provider for Informix will be released? We're working with a beta right now, but running into a few bugs. ODBC refuses to connection pool, among other problems, so the managed provider is our only hope. Have an open case with tech support (…
IP, sqlhosts, and setting up new server for Disaster Recovery
We are creating a 2nd almost identical HP-UX database server for disaster recovery. For purposes of a smooth transition, can folks review our plan and find the holes or issues? Assume that the onconfig, dbserver name, alias, nettypes, etc are identical on both machines. 1. hp_p…
Java and JDBC vs 4gl
Sorry. Then I have no further ideas at the moment. Gorazd "Ph. Chantry" <sorry.nomail@mail.fr> wrote in message news:bpkro7$g13$1@s1.read.news.oleane.net... > > Using standalone Java client will always be slower. What you can do is use > application server like JBoss (or IBM We…
Java Connection/Pooling Question
Hello Everyone, I received an inquiry from one of our developers about a pooling situation he is trying to code for. Not being a java or JDBC guru, I thought it best to present it to the experts: ...... Is there a way, in the Informix JDBC 2.21 driver, to close a pooled c…
Threads waiting on buffers
----- Original Message ----- To: dwright@sherwoodfoods.com At: 11/ 4 14:07 With that many tables also look into increasing the Data Distribution Cache (parameters DS_HASHSIZE & DS_POOLSIZE). Check out chapter 4 in the Performance Guide for details of all of these parameters, it …
Re: WebLogic Connection Pool
OK, my user has confessed. Weblogic was not the culprit but something it required was the problem. In his own words, >The wrong jdbc driver was installed on MAPSDEV. Null values >were not interpreted correctly with the old driver. Upgrading >to the ifxjdbc211 driver allow the…
WebLogic Connection Pool
IDS 7.23UC11 (Archaic, I know) UP-UX B.11.0 Greetings, family. I had to start writing again because a stable system thgat has not had trouble in years crashed a few times today. The swan-song message was: 13:06:53 Assert Failed: Internal Error - Bus Error 13:06:53 Who: Ses…
client port number
rkusenet wrote: > Is there a way Informix can return the port number of the client it uses to talk > to for a connection. We need this to identify some connections amongst hundreds > of connection from iplanet server which uses the same user name. Since client > port number is al…
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…
Re: Performance & checkpoint
You've almost answered your own question. You're experiencing data growth and performance degradation on a system that, no matter how it is configured, was hitherto accurate. So, what's changed in your application, and/or in your businesss? Ref the configuration, please tell us …
JDBC connection problem
When using JDBC to connect to Informix in a Java application, in JDBC Driver documentaiton, there is a Class "IfxConnectionPoolDataSource", it has a method: void setMaxIdleTime(int ageLimit) set maxIdleTime I am wondering the ageLimit's unit is seconds or milliseconds? Basical…
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…
[ids]Cumulative query time
Hi all, I need to identify long running queries against IDS7.31.UD4 (Solaris 8). These queries are coming from BroadVision, so an Informix session doesn't correspond 1:1 with user sessions (connection pooling). I had intended to use sysmaster:syssqexplain.sqx_cumtime as a metri…
Oledb, connection pooling, and watching connections
Hi all, I have a suspicion that the Informix OLE DB provider (from SDK 2.5) may not support connection pooling, but thought I should ask here before making assumptions. Any one know for sure, or have a documentation reference (the OLE DB programmers guide only mentions pooling …
Re: Parallel Transactions
news You may want to open a pool of connections instead of 1 connection. That way you can assign a new thread to a client as it comes in and attach the client to a free connection in your pool. HTH Sujit "news.uswest.net" <jsnodgrass1@uswest.net> on 12/16/2000 01:07:00 PM Ple…
FAQ Update
David kill the 19 June posting on RAID5 it is completely redundant to the rest of the discussion. In 8.13 PC_HASHSIZE the note is incorrect. PC_HASHSIZE is related to PC_POOLSIZE, the former is the number of hash buckets and the latter is the number of entries permitted in each…
pooled connections and prepared statements
I am building an application which will use pooled jdbc connections (either our own pooling or vendor pooling). A question arises about prepared statements in this regard - especially with Informix. One wants to use prepared statements to avoid the overhead of repeatedly running …
data distribution cache
All: System info: - Informix 2000 9.21.FC1 - Baan IVc3 - HPUX 11.00 - DB 280 GB . 30,000 tables "12 Baan companies" I'm currently running DD_HASHSIZE 511 DD_HASHMAX 50 Considering DS_HASHSIZE 511 DS_P…
MTS/COM+ with Informix.
I have seen a number of questions about using Informix with MTS/COM+ but I have not seen any answers. Is it possible? Do the available OLE DB Providers/ODBC Providers support transactions? Can I pool the connections? etc. Kevin Burton Kevin.Burton@avstarnews.com…
Onbar problems
Does anyone have any idea why am I getting these errors while doing backups with onbar? We have a Sun Ultra 3500 with DLT7000 tape backup. Auto Management is turned on, so we don't label the tape manually. When I do a Unix system backup with the ufsdump command, all works fine. I…
looking for a good JDBC connection pool class
Where can I find a class that provides a JDBC connection pool that works with Informix IDS 9.x? I need a connection pool and, unfortunately, don't have time to write one. Would prefer an open source or free one but am open to any solutions... -darrel -- ======================…
Setting up a JDBC Connection pool - problems
I am setting up a JDBC Connection Pool to an Informix IDS 9.12 under Linux using the JdbcConnectionPool from Promatter (http://protomatter.sourceforge.net/1.1.1/index.html) I have set up the JdbcConnectionPool to pool connections to an Informix IDS 9.12 database under Linux and …
Re: Updating statistics
What do you mean not Y2K compliant? Are you talking about a DBCENTURY bug/problem or is this something new? Please give me specifics. Thank you, Tracy >>> <Dick.Brieck@chase.com> 12/15/99 2:20:51 PM >>> djw@smooth1.demon.co.uk wrote: "Move to 7.31.UC4 now! 7.30.UC6 is not Y2K …
Re: Updating statistics
djw@smooth1.demon.co.uk wrote: "Move to 7.31.UC4 now! 7.30.UC6 is not Y2K compliant and has bugs." I was surprised to hear this on December 13th! I thought we were compliant at 7.30.UC6. Would you please let me know what the bugs you referred to are? I am very interested. T…
Re: Updating statistics
Art, Thanks for your thoughts. In your answer to my first question you alluded to a bad index page flag problem. "...in 7.31 distributions MAY aggrevate the problem with the bad index page flags if you have an earlier version prior to the fix to that bug (fixed in 7.31UC4 or 5…
Re: Updating statistics
In article <38555EBD.496B23B1@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Dick.Brieck@chase.com wrote: >> >> Greetings. I have a few questions regarding using distributions with IDS. >> We're currently using >> IDS 7.30.UC6 on Solaris 2.6. I've used Informix's pr…
Re: Updating statistics
Art, Sorry if I am being a little dense about this but I have a question about one of the suggestions you made to Mr. Brieck. In answer to question 3 you said: | |> 3) Are there any other resources to consider before using distributions on a |> large scale? | |Yes the data…
Updating statistics
Dick.Brieck@chase.com wrote: > > Greetings. I have a few questions regarding using distributions with IDS. > We're currently using > IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for > updating statistics on a > limited basis on our databases. I've bee…
Connection pool pb using jdbc
Hello, I'm using a connection pool, but I get some strange errors : All is working fine except that sometimes I get : System or internal error java.io.IOException: Broken pipe But all the connection are checked (isClosed) by the pool before sending back. I'm using th…
Re: Single CPU Performance Problems?
Art, Thank you - you have been very helpful! I am trying to find the best performance with this hardware platform before I start to add SCSI hard drives/more hard drives, etc. By the way - we have turned off logging for now. "Art S. Kagel" wrote: > I see the following: > > Y…
Re: informix parameters in onconfig file
edem wrote: > > Can anyone advise me what can i make better in onconfig file > Informix 7.30FC7 ( will be 7.31FC2 soon ) on HP-UX 11 ( machine V2500 6 > processors) > i am using kaio ( kaioon=1 ) > Any advise will be very helpful > Thanks! > > And this is my onconfig file : It …
Very slow ODBC connections?
> Nowhere in your description have you said what options you selected > when you configured the ODBC data source -- in other words you are > probably seeing default performance. Um, yeah. For all it's worth, I'm using the olsoctcp protocol, cursor behavior = close, scrollable c…
DS_POOLSIZE,DSHASHSIZE , DDHASHSIZE & DD_HASHMAX
Hi All , I am currently trying to set these parmaters and having difficultly get a rule of thumb to set these paramters. They are set to default values as we have not modified the onconfig files. The following is output from the :- onstat -g dic command. INFORMIX-OnLine …
Re: DS_HASHPOOL and DS_HASHSIZE
kbg wrote: > > How do you configure DS_HASHPOOL and DS_HASHSIZE? > does these parameters exist on an IDS 9.14? That should be DS_HASHSIZE and DS_POOLSIZE (there was a typo in my article in TechNotes). DS_HASHSIZE is the number of hash list and must be a prime number. It default…
DD_HASHSIZE,DD_HASHMAX, DS_HASHSIZE, DS_POOLSIZE
Hello list, Has anyone encountered either an absolute or practical upper limit to these parms? (excluding total memory requirements). I only recently got my databases updated with distribution statistics and much to my surprise encounter worst performance after the update. …
Re: Connection pooling
I have the same problem. We have several CORBA objects which make database connections to Informix and the connections are supposed to last until the objects deactivate. All clients need to access data through these objects and the Virtual portion of shared memory grows. I am st…
Multi-threaded client ?
Eunsook Jin wrote: > > Is it possible to make a informix client that is multi-threaded process > ? > In other words, one unix process can act as multiple clients for > Informix server with > many threads ? Yes absolutely. ESQL/C 7.24+ and SDK 2.02+ (which contains ESQL/C 9.??) …
CONNECTION OBJECT
I am using RMI to connect my client-app to an Informix Online Dynamic Server 7.2 I have a single connection object which is used (synchronized) by all the clients. I suspect there must be a limitation in requests to the same connection. Each remote method reuses the object fo…
Re: JDBC
Ben wrote: >Has anyone gotten JDBC to work with servlets for informix? I have >gotten it to work directly from the UNIX prompt, but whenever I try to >connect more than once to a shared memory connection server, I get >errors about shared memory. When I try to connect to tli, …
Re: Multi Thread App
In article <68tpjb$q9j@cssun.mathcs.emory.edu>, "Art S. Kagel" <kagel@ns1.bloomberg.com> writes >On Tue, 6 Jan 1998, Alexander Jaremenko wrote: > >You use the CONNECT TO ... AS <connection name> statement repeatedly with >different connection names (which can be managed in host v…
Re: Multi Thread App
On Tue, 6 Jan 1998, Alexander Jaremenko wrote: } Hello Mr Kagel, } Thank You for response. } } > ODS/ESQL-C versions 7.21 and later support threaded applications. } > Versions prior to 7.13 supported only one connection per process and } > 7.13->7.20 supported multiple sessions …
Shared Virtual Memory Usage Question
We have a nice, simple two tier application, with a Powerbuilder based client connecting to a V7.13 engine. New connections start out using very little memory (virtual pool I think) as reported by "onstat -g ses". Then over time it increases, some getting as high at 20+ megab…