Oninit® Archive
Results for “onstat -g tpf”
IFX 14.10 FC14 License File
it seems FC13 license can work with FC14 package: onstat -V IBM Informix Dynamic Server Version 14.10.FC14 ------------------------------ ke chen ------------------------------…
How to restrict access for a user to Informix by IP?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1 We have several application servers and LDAP based authentication. How to prevent a user's connections from any but the application servers' IPs? ------------------------------ Sincerely, Dennis -------------------------…
Defragment sbspace
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to defragment (repack) a sbspace after plenty LOBs been deleted? ------------------------------ Sincerely, Dennis ------------------------------…
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 ------------------------------…
INT to SERIAL in-place alter
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------…
New ideas
Hi, Please vote up my new ideas. https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-568 Show reads/writes per session broken down by bufferpool. Note I am not saying by pagesize as I also want more than one bufferpool per pagesize to allow seperation and different page aging. htt…
ifxbkpcloud.jar stucked
Which OS Platform? Try lsof on the backup process, does it use tcp sockets to communicate with the remote aws service? if so then configure keepalive to detect dead connections if possible. Also if it is using TCP/IP why does the socket not get closed on network failure? Try runn…
How to know what edition is installed ?
I think that when there is no suffix on the version, that that is Enterprise Edition: IBM Informix Dynamic Server Version 12.10.FC6XC <-- custom build, but no suffix IBM Informix Dynamic Server Version 14.10.FC3 ------------------------------ Mike Walker ------------------------…
onstat statement
Hi AMit Killing the session may take some(and sometimes a lot) of time because what it does is rollback the transaction. If the transaction is "intensive", i.e lots of SQL statements, it can really take long. You can check what this session does with onstat -g tpf and look at the…
Are there hidden gotchas w.r.t. moving sysadmin tables?
Steps to move sysadmin https://www.ibm.com/support/pages/moving-resetting-sysadmin-database-new-dbspace-ibm-informix-dynamic-server-ids ------------------------------ Gaurav Kumar ------------------------------…
Fast Recovery after correct shutdown
When the engine is down –what is the last line in the online.log ? If it is not IBM Informix Dynamic Server Stopped then the engine was not shutdown properly Cheers Paul…
How do I determine which edition I m running?
John Miller used to have a web page on this but I'm pretty sure it disappeared. If you execute a onstat - or an oninit -Version and see: IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line ...... this is Advanced Enterprise Edition IBM Informix Dynamic Server Vers…
New RFE for your review.
Hi Art, This subject is topical for me now as I spent some time at the weekend looking at this and could not make sense of it. Your post is somewhat cathartic for me. I currently use three ways of looking at read-ahead: 1. System profile, either 'onstat -p' or sysprofile SMI view…
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…
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.…
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…
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)…
lock ovflow
How about look at onstat -g tpf and see the thread which has requested a high number of locks. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 06/18/2015 08:26:52 AM: > From: "MARK SCRANTON…
memory thread ... VIP status ?
What thread name specifically? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Optimising index builds
> On 19 January 2014 at 11:10 NEIL TRUBY <neil.truby@ardenta.com> wrote: > > >> Is DS_TOTAL_MEMORY set high enough to permit significant in-memory sorting? > > I changed DS_TOTAL_MEMORY to 300GB and reduced BUFFERPOOL to 160GB. Now > nothing gets written out to the DBTEMP_SORT fi…
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.…
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,…
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 …
migration checklist 7.31 to 11.7
Art: Thanks for the notes... I'm getting a bit more confident that the small scale, SQL stuff for site specific jobs won't be that big of an issue (as long as the OS and environment doesn't change that much without the developers telling us). FYI I found a migration presentatio…
onstat -g ath
if ! kaio && ! auto aiovp then check to see if you have enough aiovps configured. onstat -g iov , the last few should not be relatively busy (< 1.0 i/o per sec.) usual suspects : check for hot spots on disk (onstat -g iof; onstat -D). check for seq scans (onstat -g tpf | awk '…
IDS and P Series
You are absolutelyu right Paul. The Sun T-class or Niagra processors are brain-dead. They were specifically designed to run web servers and other Java or C++ style multi-threaded applications that run many many very short run threads that spend most of their time waiting for othe…
IDS 10 performance degrades with dual NICs
Since your version 10 you won't be able to add an additional msc vp, but here is an article that may help. Troubleshooting Slow Network Connection Attempts to IDS Users connecting over the network who normally experience split second connection times may suddenly see their conn…
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…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
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…
btscanner endless
Hi all, Does anyone knows why suddenly a btscanner becomes endless? I review which index is cleaning and it only has 783 records and it only has integer field. I added my btscanner reports below (as an observation, see big and negative numbers). I have done a drop a recreate o…
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…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Re: Question re. sysptprof
Not related with sysptprof but to your intended idea of checking index usage. Starting on version 10 you can monitor your index activity with "onstat -C part" It shows the statistics used by BTScanner to decide when an index must be cleaned. Everytime the index is accessed the …
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…
what system table contains the sorting file size?!
The sys*rst* tables contain thread specific profile, tracking, and management data. Art S. Kagel On Wed, Jul 23, 2008 at 6:46 AM, MARS CHEN <mars@jsun.com> wrote: > Dear All... > > I test an esql/c application which select * from a-big-table > order by non-index fileds in endl…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: long checkpoint duration
Thanks Mark. I find very little information in the manual about what rangesize does or is. The actual rangsize=num usage is not even documented. I would love to do trace checkpoint but I can't bounce my instance. ----- Original Message ----- Subject: Re: long checkpoint duratio…
Re: long checkpoint duration
Well, it is by no means a smoking gun, but eh number of leaf scans you are doing could result in some performance degradation. I would definitely sugest enabling range scanning, since it is more efficient. Quickest way to do this would be onmode -C rangesize 100 onmode -C stop …
Re: long checkpoint duration
onstat -C Btree Cleaner Info BT scanner profile Information ============================== Active Threads 1 Global Commands 0 Number of partition scans 5462 Main Block 0x07000002a1…
Informix thread working with a index
Thank you everybody for your answers. I will track your questions in this response. I'm using INFORMIX 9.40.FC9 on Solaris 8 with 4 cpus. Yes, my BT SCANNER is staying active. I realized that it's establishing HIGH PRIORITY. What does it make that switch priority? Is it BTSCA…
RE: Monitor sessions
I think it's great that you're putting together a script to do this sort of thing. I think Paul is absolutely right, you need some commentary so that it doesn't take more than 10 seconds to understand. I would also highly recommend NOT using onstat for this sort of thing. The …
Re: Monitor sessions
>> onstat -g tpf | tr -s " " | sort -nr -k 16 | head > onstat.tpf.out >> for i in `cat onstat.tpf.out|cut -d " " -f1` >> do >> if [ $i -gt 0 ] >> then >> echo "------ LOGICAL LOG $i START" >> user_add=`onstat -g ath|grep $i|tr -s " "|cut -d " " -f4` >> if [ `…
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…
Monitor sessions
On Jan 16, 10:10 am, mohitanch...@gmail.com wrote: > On Jan 16, 5:29 am, scottishpoet <drybur...@yahoo.com> wrote: > > > > > > > On Jan 16, 12:43 am, mohitanch...@gmail.com wrote: > > > > Version: IDS 10 > > > > I am trying to write a script that will find out those threads or > …
Re: Process taking most of Logcal Log
On Sep 6, 2:31 am, "TBP (The Big Potato)" <T...@NotHere.Co.Uk> wrote: > Claus Samuelsen wrote: > > mohitanch...@gmail.com wrote: > > >> Version: IDS 10 > > >> Is there a way to tell which process on the box is filling up the > >> logs. I was thinking if there is a way to tell whi…
Process taking most of Logcal Log
Claus Samuelsen wrote: > mohitanchlia@gmail.com wrote: > >> Version: IDS 10 >> >> Is there a way to tell which process on the box is filling up the >> logs. I was thinking if there is a way to tell which process / thread >> is writing the logical logs or filling up the logical lo…
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: 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…
migrate informix db on mssql server 2005
hi, i should migrate one informix db on a mssql server 2005, any ideas how this goes short and efficient? second problem, also stored procedures must migrate von informix db to mssql server 2005, is there a way? one more question, where does informix store the stored procedur…
Re: listener-thread: err = -408
How does CSM cause error -408? -- r0b ------------------------------------------------------------------------ r0b's Profile: http://unixadmintalk.com/1202 View this thread: http://unixadmintalk.com/showthread.php?t=194103…
Informix OnBar Restore
Hello all, after an Infomix level 0 restore with onbar �r �p the db is at Fast Recovery state ... do I have to restore the logical logs before I bring it online? My aim is to just check that the level 0 backup is recoverable not to bring the db at its latest condition. Or in …
Re: ontape encryption?
Hello, On Jan 4, 4:42 am, chud <chrishud...@gmail.com> wrote: > Hello, I am a Linux admin with some past database experience, however I > am new to Informix. We are running Informix IDS 9.4.0 on RedHat ES 3 > and 4, and we do backups via ontape to a tape device. I have been > …
ontape encryption?
Hello, I am a Linux admin with some past database experience, however I am new to Informix. We are running Informix IDS 9.4.0 on RedHat ES 3 and 4, and we do backups via ontape to a tape device. I have been asked to look into how to encrypt the data on the tapes. I noticed the…
problem while accessing informix on local machine.
Hi, I had recently installed an informix server on a local machine and used the aquafold studio to access data in it - my OS is Win XP Pro SP2. While this seemd to work for 2-3 days , since yesterday i get an error message which inside the 'informix.log' file of the db states : …
Re: For those working on the SUN platform
Can you forward that document to me? Regards, Mukil -- Mukilan ------------------------------------------------------------------------ Mukilan's Profile: http://unixadmintalk.com/591 View this thread: http://unixadmintalk.com/showthread.php?t=200395…
Unix 4GL Programmer w. EDI exp
I'm currently in need of a UNIX 4GL programmer with EDI experience. The successful candidate should be able to read and understand EDI mapping guidelines from retail trading partners and develop 4GL programs to fulfill guideline requirements. Job requirements include communicati…
Re: Importing data from Informix to MSSQL2k5 fails
You may be getting trucation errors. In your Data Flow task for your source task you may need to redirect errors into a flat file for truncation errors or ignore truncation. Ignore only if the source table varchar value is smaller than the one you have in your destination. You c…
Re: Importing data from Informix to MSSQL2k5 fails
We still haven�t come to a proper solution. Please, if anyone has a suggestion oder experienced a similar problem, answer me. I greatly appreciate any help provided. -- Benedikt Ries ------------------------------------------------------------------------ Benedikt Ries's Profile…
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…
ISM_startup -init - MEMORY FAULT
Hi, Wondering if any one can help me with this strange one. Rebuilt ISM as standard. Initiallyising the database with ism_startup -init and get the following : " [root@gra-ds2-4 logs]# ism_startup -init start_ism: is starting the ISM daemons. Memory fault Memory fault ${0##*…
Informix Java User Defined Functions
I have been trying to use Informix Java user defined routines, but could not get the examples to work. I went through the informix docs and searched the internet for solutions, but with no success. Is there anyone who can solve this? I have downloaded Informix version 10 evaluat…
Re: oncheck -cc hangs
Floyd Wellershaus wrote: > Any idea why we can't get an oncheck -cc on our big database ? > We have 5 instances on this box, one of them is a terabyte, with about 80,000 tables. > Oncheck -cc runs perfectly on all of them except the big one. It seems to just hang there. After 2 d…
query using cpu
Floyd Wellershaus wrote: > Any idea why a query that does a join of a table on itself, doing a count and a group by, would cause the cpu usage to go drastically up, almost instantly ? Not pdq, just a query, on a non fragged table. > > It is doing multiple sequential scans of the…
Ontape security when shipping tapes
We have a need to ship a level-0 ontape backup that will contain sensitive data. How secure is the data when backed up using ontape? Could a potential threat use a UNIX utility such as dd to read the tape? Thanks, Kevin -- kxk0912 ----------------------------------------------…
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…
Re: 668 System command cannot be executed - 1: Not owner
Reece Wrote: > If the Informix engine is either: > 10.00.xC4 or later > 9.40.xC8 or later > > Then the problem may be APAR IC49554 and a work around would be to > explicitly specify CLIENT_LOCALE and DB_LOCALE in the URL used to > connect to the database. > > As suggested by Jona…
Re: 668 System command cannot be executed - 1: Not owner
kjuliff (AT) gmail (DOT) com Wrote: > Dous it "login" to the host? > > > gavinrifkind wrote: when creating a JDBC connection to a database it passes in the user login and password, in order to authenticate the user. -- gavinrifkind -----------------------------------------------…
Re: looking for 4GL programmer
I work for an enterprise corporation. 4GL is one of our main languages. We can write a complete program, debug, test, compile, and deliver you the source code. Let me know. -- jmcolyer ------------------------------------------------------------------------ jmcolyer's Profile:…
668 System command cannot be executed - 1: Not owner
I am connecting over a network using a JDBC driver which uses tcp-ip to connect to the server. I am not sure what you mean by "the relationship" between the client and the host -- gavinrifkind ------------------------------------------------------------------------ gavinrifkind'…
Last Day Function
Hi, I�m have a problem, I would like know how return a last day of the month in db Informix . Thank you. leandro@logus-consultoria.com.br. -- leandro_logus ------------------------------------------------------------------------ leandro_logus's Profile: http://www.dbtalk.net/m5…
Re: i4gl install failed
I have a similiar problem. When I run the I4gL, it also shows the same error message. I have consulted the IBM technical engineer and he is very kind to suggest the following solution: If you have run into the defect 176051 after upgrading to AIX 5.3 TL 4, please apply the fix …
Re: i4gl install failed
Hi Vincent. Have you set LD_LIBRARY_PATH or LIBPATH Just my $0.02 -- Tsutomu Ogiwara from Tokyo Japan. >From: vincent yeung <vincent.yeung.29j5m0@no-mx.forums.yourdomain.com.au> >To: informix-list@iiug.org >Subject: Re: i4gl install failed >Date: Fri, 16 Jun 2006 23:44:42 -05…
Re: i4gl install failed
I have installed the i4gl 7.32 FC3 on the machine AIX 5.3 I have no problem during the installation and receved the completion message. WHen I run i4gl, it shows the error message: exec( ): 0509-036 cannot load program i4gl because of the following errors: Actually, I have no…
RE: Checking indexes after large deletes
Yes I was interested in this too. I think a blue person came on here and said, "If you put this line in your onconfig, all your problems with the b-tree scanner will be forgotten". So I did and I forgot all about my b-tree scanner. But I still don't know what the heck it's doi…
Checking indexes after large deletes
Adam Tauno Williams wrote: >> I can't seem to get "onstat -g btc" to return anything in 9.21 FC4 or >> 10.0 FC4. > > It doesn't do anything on my "10.00.UC4" box. > > There is "btree cleaner info", with "onstat -C". Is that the same > thing? > Yes ... onstat -C Use the -C opti…
Re: online replication in IDS workgroup edition
Hi there, The URL you provided is too technical for me, It would be appreciated if someone could explain it to me. Regards, Faisal Qadri -- faisal_qadri ------------------------------------------------------------------------ faisal_qadri's Profile: http://www.dbtalk.net/m386…
online replication in IDS workgroup edition
Hi there, I have query for replication in IDS workgroup edition, I would like to know what is the procedure for implementing online replication in IDS workgroup edition, we can only do online replication if we have HDR lincence in this edition or we have other option available a…
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 …
Re: Latch Waits
Interesting I'm running 7.31.FD7 - on Solaris 8 and constantly getting the global Cach lock as well. Here's truncated results from onstat -g prc and onstat -g dsc run when almost all users had 'S' in the first column with onstat -u onstat -g prc Informix Dynamic Server Version …
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: Errors in stored procedure don't raise
How are you returning from sp_Test2() ? J. -----Original Message----- From: agustincb <agustincb.26v990@no-mx.forums.yourdomain.com.au> To: informix-list@iiug.org Date: Wed, 26 Apr 2006 05:53:48 -0400 Subject: Errors in stored procedure don't raise Hi, i'm using the IBM Inform…
Re: Errors in stored procedure don't raise
How are you returning from sp_Test2() ? J. -----Original Message----- From: agustincb <agustincb.26v990@no-mx.forums.yourdomain.com.au> To: informix-list@iiug.org Date: Wed, 26 Apr 2006 05:53:48 -0400 Subject: Errors in stored procedure don't raise Hi, i'm using the IBM Inform…
Errors in stored procedure don't raise
Hi, i'm using the IBM Informix ODBC driver v. 2.90 to connect to a informix server. I have this two test procedures; the only difference is that the second returns a value: CREATE PROCEDURE sp_Test1() DEFINE X INTEGER; LET X = 0/0; END PROCEDURE CREATE PROCEDURE sp_Test2() RETU…
Problem connecting asp .net to informix
I'm trying to connect to Ifx using the .net provider. Here is my connection string: database=....;server=....;user id=.....;pwd=..... With VB .NET it works perfect, but not with ASP .NET, I get an unspecified error (23101) Any tips? -- agustincb ------------------------------…
RE: Divide by zero error doesn't raise
I'm connecting through Microsoft ActiveX Data Objects 2.6 Library with a Visual Basic program. I tried it with old RDO 2.0 and it happenned the same thing. In DBACCESS it behaves correctly, it fails. -- agustincb ----------------------------------------------------------------…
Divide by zero error doesn't raise
I am connecting to informix via ODBC 2.90, the database is version 9.40. I execute this query, for example: SELECT ap_maximo/ap_minimo FROM jam_agrupapesos The table has 8 records, in one of then ap_Minimo = 0; the query just doesn't return any record, but it doesn't fail. Th…
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/…
DTS from informix to MS SQL 2000
am trying to import data from an Informix database every midnight. Each import will take in ~2million records from a table and i have like 3 DTS package to import data from 3 different tables every night. As the Informix database server is a in-production server, I want prevent …
Re: DBStudio for Informix NEW Version out - Free Download
Mayan Palace/Mayan Resorts/Grand Mayan or Great Vacation Club (GVC) potential customer, beware! Before you decide to purchase any of the Mayan Resorts/Mayan Palace/Grand Mayan or Great Vacation Club (GVC) packages, please make sure to read the extremely valuable information on t…
the error in the online.log
this morning ,I exam online.log find flowing error: 03:55:51 Checkpoint loguniq 280608, logpos 0x32018, timestamp: 1692764495 03:55:51 Maximum server connections 527 04:02:25 listener-thread: err = -25587: oserr = 0: errstr = : Network receive failed.. 04:12:06 listener-thr…
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 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 from cron leaves engine in permanent fast recovery
gerry.cassidy@dsl.pipex.com wrote: > We have a requirement to automatically bounce our 9.40.FC6 instance on > AIX 5.2. > > The idea is to use cron (informix) to run a script that sets the > correct environment, etc. and then issues a 'onmode -yuk', sleeps for > 30 seconds then is…
Oninit from cron leaves engine in permanent fast recovery
Hi We have a requirement to automatically bounce our 9.40.FC6 instance on AIX 5.2. The idea is to use cron (informix) to run a script that sets the correct environment, etc. and then issues a 'onmode -yuk', sleeps for 30 seconds then issues a 'oninit -v'. This script ... and a…
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…
rule of thumb or words of wisdon for btree cleaners?
Does anyone have a rule of thumb or words of wisdom regarding additonal btree cleaners? Looking at the output below it seems I could benefit from adding an additional cleaner or more. Stats reset at 8:30 AM or 6 hrs ago. HPUX 11 $ onstat -C IBM Informix Dynamic Server Version 9…
Re: rule of thumb or words of wisdom for btree cleaners?
Perhaps I should call this "words of desperation". Sorry for being negative. But the most striking thing your numbers show is how much i/o the btree cleaner wastes. NormaJean wrote: > All, > Does anyone have a rule of thumb or words of wisdom regarding additonal > btree cleaners…
Re: rule of thumb or words of wisdom for btree cleaners?
Perhaps I should call this "words of desperation". Sorry for being negative. But the most striking thing your numbers show is how much i/o the btree cleaner wastes. NormaJean wrote: > All, > Does anyone have a rule of thumb or words of wisdom regarding additonal > btree cleaners…
Re: rule of thumb or words of wisdom for btree cleaners?
http://www.informix.co.uk/btscanner.htm "NormaJean" <normajean.sebastian@tellabs.com> wrote in message news:S8%Vd.6$Jo6.2119@news.uswest.net... > All, > Does anyone have a rule of thumb or words of wisdom regarding additonal > btree cleaners? > Looking at the output below it see…
Re: rule of thumb or words of wisdom for btree cleaners?
http://www.informix.co.uk/btscanner.htm "NormaJean" <normajean.sebastian@tellabs.com> wrote in message news:S8%Vd.6$Jo6.2119@news.uswest.net... > All, > Does anyone have a rule of thumb or words of wisdom regarding additonal > btree cleaners? > Looking at the output below it see…
rule of thumb or words of wisdom for btree cleaners?
All, Does anyone have a rule of thumb or words of wisdom regarding additonal btree cleaners? Looking at the output below it seems I could benefit from adding an additional cleaner Stats reset at 8:30 AM HPUX 11 $ onstat -C IBM Informix Dynamic Server Version 9.40.FC2W4 -- On-…
rule of thumb or words of wisdom for btree cleaners?
All, Does anyone have a rule of thumb or words of wisdom regarding additonal btree cleaners? Looking at the output below it seems I could benefit from adding an additional cleaner Stats reset at 8:30 AM HPUX 11 $ onstat -C IBM Informix Dynamic Server Version 9.40.FC2W4 -- On-…
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…
Running 4GL on table that changes a lot
The question is not really clear; what is the problem; is it slow due to seq scans?? try to get a explain and analyze it or when the program runs or do a onstat -g tpf <threadid> and check for seqscans; or look in sysmaster:sysptprof for these tables assuming it's seq scans: Ha…
DRINTERVAL
It would be interested to know which threads are running that are consuming so much cpu (onstat -g act) and what are they doing (onstat -g stk <tid>). You could try some profiling of the oninit as well to gather more info. On the other hand maybe this cpu usage is not a bad sig…
Re: SQL Tracing tools?
IDS v 9.4 (and maybe earlier) supports 'dynamic explain' to capture sql statements for a specific session: onmode -Y <session id> 0|1 A file is then created with the following name: sqexplain.out.<session id> For example, if you wanted to capture the sql statements for se…
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…
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: Virtual Processors and CPU-Load
Markus, With 2 Xeon (multithreading) CPU's it really makes sense to allocate 4 CPU VP's (not 2 as You did) to use CPU power more efficiently. The other thing to investigate is the 'BUFREADS by partition' statistics. Please, pay very close attention to those tables and indexes t…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: 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…
Slow reposnse
"Fernando Nunes" <spam@domus.online.pt> wrote in message news:bve3cb$qvajr$1@ID-161111.news.uni-berlin.de... > Did you start the engine with PDQPRIORITY on? > Apparently even simple queries have several threads... > > Are you issuing grant/revoke statements in big batches? Indee…
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…
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?…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Re: FW: PDQ
Dirk Moolman wrote: > > I have 5 CPU VPs, so this shouldn't be the problem. I've been meaning to > read a bit more about PDQ - I've just been a bit busy. > > I touched a little on PDQ in 7.30 I'm now working with 9.21FC1 and have > to just touch up on PDQ again. I did set th…
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…
questions onstat -g
Is this a trick question? Type onstat -g at the prompt and you will be presented with the options and descriptions of each. Of course there are so many options, pipe it to a page break, i.e. | pg or | more. Is that the answer you are a looking for? Or how about this? (I don't k…
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: shared memory question
Correct for NETTYPE ipcshm..... Take the number of listener/poller threads configured, this is the number of class M shared memory segments created. Now multiply the number of connections per thread, by about 10700 (exact value depends on the system) to estimate the size of each…
Re: Multiple users logging on with same ID
From: Sears Associate <pstuehl@sears.com> > >I have a question regarding multiple users logging into informix via >inet with the same user id. What type of problems can this cause. My >concern is what happens when page level locking is implemented and one >user is updating dat…
Re: IDS 9.20 panic, another one
Have you spoken to tech support? From: Sebastien THOMAS <Sebastien.THOMAS@none.net> > >19:50:50 Checkpoint Completed: duration was 0 seconds. >19:50:50 Checkpoint loguniq 1210, logpos 0x1e4018 > >19:54:25 Assert Failed: Incorrect BLOB stamps. >19:54:25 Informix Dynamic Serv…
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 …
Re: Gil Figueroa, Keynote Speaker
From: "Matti Lamprhey" <matti@polka.bikini> > >"Impy" <wlinden@stritch.edu> wrote... > > Matti, > > I think OTC just receives email via Informix listserv. Under those > > circumstances, I don't think he would be able to keep his replies in the > > group (threaded). > > How did I …
Re: Gil Figueroa, Keynote Speaker
From: "Matti Lamprhey" <matti@polka.bikini> > >"Carlos Benjamin" <benj@firstlinux.net> wrote... > > >"Obnoxio The Clown" <obnoxio@hotmail.com> wrote... > > >> From: "Matti Lamprhey" <matti@polka.bikini> > > >> > > > >> >Obnoxio, why is that the majority of your responses are inco…
Re: Gil Figueroa, Keynote Speaker
I fear you have confused me. From: "Matti Lamprhey" <matti@polka.bikini> > >"Obnoxio The Clown" <obnoxio@hotmail.com> wrote... > > From: "Matti Lamprhey" <matti@polka.bikini> > > > > > >Obnoxio, why is that the majority of your responses are incorrectly > > >threaded? Could it …
Re: Gil Figueroa, Keynote Speaker
From: "Matti Lamprhey" <matti@polka.bikini> > >"Obnoxio The Clown" <obnoxio@hotmail.com> wrote... > > From: William Rice <william.rice@sabre.com> > > > > > >Seeing you can compile your own function calls into the uv executable I > > >think > > >GCI's could be considered an equiva…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: Error 27001!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
From: Simbarashe.Pangeti@icl.com > >please help me out to sort out this error >just do a finderr 27001 and you will get the details!!! Just read what the finderr says, and you might find some clues!!! -27001 Read error occurred during connection attempt. This error can occur …
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…
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…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
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…
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…
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…
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.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
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.…
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…
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…
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…
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…
Re: onstat -g options
> Where will I get complete details of each field of all the outputs from > onstat -g options. For example onstat -g tpf <thred id > gives many values > and I could not find the details in any of the informix manuals or books. I don't believe there's one comprehensive place to g…
onstat -g options
__________________________________________________________________________ This message is intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the s…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
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: Problem with "Changing data structure forced command termination"
On Thu, 9 Jul 1998, Art S. Kagel wrote: > PabloF@my-dejanews.com wrote: > > > > Hi All, > > Anyone out there knows why i can read sometimes the message > > "Changing data structure forced command termination." > > when i execute "onstat -g ses" ? > > I think there's a problem w…
Re: Problem with "Changing data structure forced command termination"
PabloF@my-dejanews.com wrote: > > Hi All, > Anyone out there knows why i can read sometimes the message > "Changing data structure forced command termination." > when i execute "onstat -g ses" ? > I think there's a problem with a ODBC connection. OK definitive answer. Remember…
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…
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: Online 5 to 722 Performance
David Williams wrote: > In article <355807F3.54B5@mcmail.com>, Paul Watson <watson@mcmail.com> > writes > >Art S. Kagel wrote: > >> > >> Paul Watson wrote: > >> > > >> > This weekend upgrade a server from Online 5.x to 7.22.UC5. Everything went > >> > except the 722 runs 75-100…
Re: Online 5 to 722 Performance
In article <355807F3.54B5@mcmail.com>, Paul Watson <watson@mcmail.com> writes >Art S. Kagel wrote: >> >> Paul Watson wrote: >> > >> > This weekend upgrade a server from Online 5.x to 7.22.UC5. Everything went >> > except the 722 runs 75-100% slower than 5. All the index's have …
Re: Online 5 to 722 Performance
Art S. Kagel wrote: > > Paul Watson wrote: > > > > This weekend upgrade a server from Online 5.x to 7.22.UC5. Everything went > > except the 722 runs 75-100% slower than 5. All the index's have been > > rebuilt and updates statistics have been run as per the release notes. > > …
Re: Online 5 to 722 Performance
Paul Watson wrote: > > This weekend upgrade a server from Online 5.x to 7.22.UC5. Everything went > except the 722 runs 75-100% slower than 5. All the index's have been > rebuilt and updates statistics have been run as per the release notes. > > I think I might be seeing the re…
Online 5 to 722 Performance
This weekend upgrade a server from Online 5.x to 7.22.UC5. Everything went except the 722 runs 75-100% slower than 5. All the index's have been rebuilt and updates statistics have been run as per the release notes. I think I might be seeing the recent 7.23 and 7.24 Tech alert …
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
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, > > 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…
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…
onstat -g tpf - 100's of millions of lock requests.
Howdy Anybody struck a problem with threads in selects spinning on the CPU and = generating hundreds of millions of lock requests when viewed from onstat = -g tpf? Anyone know just what is these lockrequests? IE, in what situation they = are created. Syslocks shows zero locks o…
Re: Understanding high CPU utilization
In article <340E2741.58C8@umich.edu>, Brian Braun <bbraun@umich.edu> writes > >Hello informix pros, > >I'm a unix systems administrator looking at a performance problem on a >machine whose only function in life is to run a version 7.2 informix >database. CPU utilization on the b…
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…
Understanding high CPU utilization
Hello informix pros, I'm a unix systems administrator looking at a performance problem on a machine whose only function in life is to run a version 7.2 informix database. CPU utilization on the box is almost always 100% with user time being around 90%, all of it is from oninit.…
Re: Informix and NOAGE
Jim Jordan wrote: > > In article <33CC2D68.307@bellsouth.net>, > MIS Dept <whsmis1@bellsouth.net> wrote: > >Saeed Talebbeik wrote: > > >> Both NOAGE and processor affinity can boost the performance. > >> However look into the machine notes of your platform to see if > the…
Re: Informix and NOAGE
In article <33CC2D68.307@bellsouth.net>, MIS Dept <whsmis1@bellsouth.net> wrote: >Saeed Talebbeik wrote: >> Both NOAGE and processor affinity can boost the performance. >> However look into the machine notes of your platform to see if these two >> features are really supported.…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Informix and Oracle in the same shop
I have been following this thread for quite sometime and I believe nothing runs "concurrently", not even the unix processes(it just schedules them). What Informix I believe it does is, shifting the 'would've been individual processes (threads)' to its control and scheduling them …
Re: Informix and Oracle in the same shop
>From: news_reader@mew.corp.sgi.com (Pablo Sanchez) >Date: 4 Jun 1997 14:14:35 GMT >X-Informix-List-Id: <news.38728> > >David Williams <djw@smooth1.demon.co.uk> writes: >> >o Informix isn't threaded because you have all 'em VP's running out >> > there. They aren't in the same e…
Re: Informix and Oracle in the same shop
In article <OjmGEAATwJlzEwOO@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> writes: > >o Informix isn't threaded because you have all 'em VP's running out > > there. They aren't in the same execution space. They have their > > own and thus there is *some* cont…
Re: Closing OnLine session (2)
At 08:35 AM 5/14/97 -0700, you wrote: >>The Plan : >>My menu programs and database (which are the dormant processes that >>I have targeted) will be under SE, while the >>'action' programs which are activated (RUN 'fglgo ...') from >>the menu program will run under OL. > >Maybe yo…
Re: Using dbexport
This is how we implemented it which works for version 5, or 6, or 7: 1. We are a UNIX shop and put a message in everyone's login profile that at a specific time each week, the database will be brought down. (Of course, this works well if all the databases are in the same instan…
Re: Overall unstableness of Informix
In article <322E1112.3F8C@transre.com>, "Juan R. Guzman" <jguzman@transre.com> writes >Michael Silver wrote: >> >> We have had an Informix (7.12.UC2) database running on an HP for over a >> year. We have been utterly disappointed with it. It crashes about >> once-a-week. We ru…
Re: multithread in INFORMIX, how?
I have heard repeatedly that on machines with two CPU's The performance actually degrades if you have 2 or more cpu VP's. So you are o.k with one CPU vp running and setting MULTIPROCESSOR parameter to false. Informix engine starting from version 6.x is a multi-threaded engine. I…
Re: Oninits Running Amok...
In article <4rtnsa$e2@server2.codetel.net.do>, Tom Hay <nomad@codetel.net.do> writes >Yes, I've seen it too, on Version 7.10D1 on a uniprocessor HP-UX, and >I don't like it either. The machine virtually stops for around 30 >seconds. Can't offer any explanation, though ... sorry !…
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…
Informix 7.1 Online Performance Questions??
Hi, I'm trying to develop a performance profile / model for an application that has been developed using the Informix Online Dynamic Server v7.1. The Server is being called by programs written in "C", which use the ESQL interface. My question is the following: I am observing …
Re: RDBMS Comparison 1.2
chuckg@Starbase.NeoSoft.COM (Chuck G.) wrote: > >Comparing Database Engines >========================== > >This document is intended to stimulate input regarding the strengths, >weaknesses, and gotchas for advanced relational database engines. >Feedback will be used to develop a …
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?…
Re: Timed input, and input array on a certain line in 4gl.
In article <3949@wet.UUCP> dror@wet.UUCP (dror matalon) writes: > Does anybody know how to do you do the following in 4gl? > > 1. Do an input/input array statement and if the user hasen't typed anything > within a certain length of time return control to the program. This > would…