Oninit® Archive
Results for “SEQ_CACHE_SIZE”
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 …
Informix 15 compatibility mode
About 6 months back I tried testing some programs that used the 4.50 csdk against a v15 informix that was not running in compatibility mode, but all the tables had been created as small tables. This was before I had come across the TABLE_SIZE=SMALL onconfig setting. The one thi…
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 ------------------------------…
Empty `onstat -g his`
Art: Can that be a matter of 11.70? Or may be I am missing something? What is a working sequence to turn on tracing on a single session? ------------------------------ Sincerely, Dennis ------------------------------…
HQ blues
Never had it, as I said. What is the sequence to reproduce ?…
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.…
insert in locked table
Reversing the order solved the problem so it looks that the pending transactions get the sequence numbers (of serial column) while waiting the release of lock(s).…
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…
Dbexport and Informix Sequence
Im running IDS 12.10.FC6 on SLES 11 SP 4. Over the weekend, I used dbexport to copy a production database in order to refresh a test/dev database instance. One of our developers had created an Informix sequence (https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.…
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)…
Accessing sequence's currval
Hello everybody, I just want to read a sequence's current value but don't want it to be incremented. Is there a way to access a sequence's currval without first accessing nextval?. Thanks a lot, Juan…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Sequence in a table
Hi, I have a table that is updated by a trigger that runs a sequence, I planning to recreate the table, will be a problem with this table or the sequence if I recreate the table? Thanks in advance.…
question about sequences
All, Informix 10.00.FC10 Sun Solaris All, Can someone tell me how I can determine the current sequence number for a sequence from the system tables or by using a command that does not affect the resulting value? Seemingly using dbschema or the select currval, nextval has an af…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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…
Innovator-C on Windows (code page)
23103 - Code-set conversion function failed due to illegal sequence or invalid value.…
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,…
Sequences & Locks
Hello We hit a table extensively (and with multi threaded) for a next key value to be returned and of course it is running into deadlocks, etc. We are looking to move this to sequences - are there locks involved with sequences in a multi threading scenario? thanks tom…
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 …
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…
sequence problem of IDS 11.5
I've a centOS Linux running 11.50.UC7IE , everyday I run the sql first : alter sequence seq_dealsession restart with 1; and then run a esql/c ap , I use : EXEC SQL select seq_dealsession.nextval into $seqval from systables where tabid = 1 ; EXEC SQL insert into xxxx(seqno,...) v…
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 …
a question of order by , strange behavior
sorry... create sequence seq_dealsession , not create sequence seq_dealsession.nextval , I type it wrong ...…
Enterprise Replication Problem
In which syscdr-table are this "Log Sequence Number"-Informations? Could we manipulate this entry by way of trial? Annotation: We build our test-environment completely new with copies of our productive-environment-databases. There exists no old databases before this db-restores.…
How to get the sequence value in ESQL/C program?
If the sequence is defined in the user db, then you have to identify the db in which the sequence exists. Sequences are not instance-wide. So, if you connect to sysmaster, your query should be select userdb:seq1.nextval from sysdual; or, if you connect to userdb, select seq1.ne…
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.…
How can I insert an actual 0 in serial column?
You can create sequence that always returns zero: create sequence mysequence start 0 maxvalue 0 cycle nocache; insert into foo select mysequence.nextval, tabname from systables; select * from foo; 0 systables 0 syscolumns 0 sysindices 0 systabauth 0 syscolauth 0 sysviews 0 sysus…
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…
a sequence question
Dear All.. I've 2 IDS 11.50.uc6 engine in 2 servers running RedHat Linux , say ifx1 and ifx2 , there is a sequence like following : CREATE SEQUENCE seq_1 INCREMENT BY 1 START WITH 2000000 MAXVALUE 4000000 MINVALUE 2000000 in both engine , ifx1 and ifx2 !! Suppose in ifx1 , "s…
Re: dynamic row sequence
Hi Holger, Thanks for your answer, but isn't this what I looking. Row id isn't sequencial numbers.. don't solve my problem... Cesar --- Em sex, 10/9/10, Holger de Wall <holger@dewall-net.de> escreveu: De: Holger de Wall <holger@dewall-net.de> Assunto: Re: dynamic row sequence …
Re: dynamic row sequence
Hi, "... In Dynamic Server, you can use the rowid column that is associated with a table row as a property of the row. ..." from http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?tab=search&searchWord=rowid select ROWID, name from users where state = 'NY'; -- Hol…
dynamic row sequence
Hi, I need a resource , what is common in any other database... Return the sequence # of the rows returned from select, something like: select func_rownu(), name from users where state = 'NY'; 1 john 2 katty 3 mike 4 nattan and so on... So , what I need is this "virtual seria…
dynamic row sequence
Hi, I need a resource , what is common in any other database... Return the sequence # of the rows returned from select, something like: select func_rownu(), name from users where state = 'NY'; 1 john 2 katty 3 mike 4 nattan and so on... So , what I need is this "virtual seria…
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…
persistance for sequence's current values
Hello World, I was hoping that 'syssequences' table will hold these values (in case I have more sequences) ... but not. Cant find these in any sysmaster tables too. But they have to be written somewhere waiting for IDS to awake... Regards, E.Ionescu…
how to restart sequence number ?!
Dear All... I try to utilize sequence object of IDS 11.50.uc6 in my application , Suppose I create a sequence like the following : CREATE SEQUENCE seq_2 INCREMENT BY 1 START WITH 1 MAXVALUE 3000000 MINVALUE 0 CYCLE ; But if I like the seq_2 to restart from 1 on every monday…
HDR Problem
Hi Art, Yes, i am planning to use the ol_ross1hdr/ol_ross2hdr as the connection string. BTW, is there any sequence on start up of primary and secondary? I also would like to ask about authentication, is there any authentication needed? like 'hosts.equiv, hosts, .rhosts'... Do w…
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…
Strange behavior for INSERT
hello What is the next character following the 'ESC' char ? Maybe the shell (ksh, bash, etc) translates the sequence of characters in another character ....…
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…
DBimport error
I'm trying to import one of my basic version of 7:31 to 11:10 and I am having the following error in import qunado comes in one table. 23103 - Code-set conversion function failed due to illegal sequence or invalid value how can do the import without this error. grateful rafae…
Sequence value sets backwards
We have noticed a unique problem. We have set sequence objects on two tables. We have a 3 node cluster of Cheetah with one primary (prim) and 2 seconday servers (sds1 and sds2). Our primary database (prim) crashed. So sds1 became the primary server. Now when we tried processing a…
IDS11.50.FC3 backup sequencing
Hello all.... We have just upgraded from IDS9.3 to IDS11.50FC3.... All appears fine apart from the backup sequence whic I would like to change.... I have googled the problem but can not fine a definative answer..so hopefully you guys will have the answer. Within the sysutils …
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…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
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.…
Informix function to generate GUID/UUID
I think Create sequence may meet your needs.. CREATE SEQUENCE--+----------+--sequence----------------------> '-owner--.-' >--+--------------------------------------+-------------------->< | .-----------------------------. | | V .-BY-. | (1) | '---+-INCREMENT--+----+--step-+…
RE: FOREACH cursor sequence
The index is only clustered until the next record is inserted into the table. Then there is no guarentee that the data will be stored in a sequential order (the new record will go into the next available page, it will not reorder the table data to keep it sequential as time cont…
RE: FOREACH cursor sequence
If you have CLUSTERED INDEX (index in the ORDER that you need) on the table then you can get rows in sequence without ORDER BY clause ... -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Jarrod Teale Sent: Mond…
FOREACH cursor sequence
I have a table with row 1, row 2, row 3, and etc. If I use foreach cursor to loop through the rows, will the rows been retrieved in sequence, i.e. follow row 1, row 2, row 3, and etc sequence? Or it will been retrieved without follow the original sequence, i.e. may be row 2, row …
RE: Functional Indexes?
On 9 Apr, 20:36, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Serge, > > Its posts like these which make me question your intelligence. > Lets try this again. > > I have a table: > product_id int > type char > sequence int > text varchar(128) > > There…
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…
sequence problem on IDS 9.40
I have problem in a working with sequence on IDS IDS-9.40.HC4-HPUX-32 on HPUX 11 and IDS 9.40.UC2 on linux. I use sequence for generating unique keys for some tables. In some cases nextval for sequences have set to some previous used number. For example 21, 22, 23, 24, 21, 22, ..…
Installation Sequence
Hi all, I installed IDS 10 in HPUX 11i. After installed, 4GL is needed to run the application. Then, I want to install 4GL v7.32 (e.g. runtimes). I found some installation guides and newsgroups mentioned the installation should be in sequence ... and uninstall CSDK. Do I need t…
Re: cdr_serial issue
>From: bozon <curtis@crowson1.com> If you didn't have to worry about synch'ing between servers, you would have a simple sequence number and you can just use that... Why not have a numeric string that represents the server id. (lets say 4 digits.) Then you have a sequence number…
cdr_serial issue
I made a mistake about cdr_serial I assumed that it would work regardless of whether ER was on or not. This doesn't seem to be the case. I need to spread out my serial IDs like CDR_SERIAL does. Is there a way to get the functionality of CDR_SERIAL without actually replicating? …
schema for views
Thanks for telling me to refer "dbschema" help. i want the schema for a single table where i can get the sql for ALL the dependent objects ie VIEWS , synonyms, sequence , procedure etc. i get the sql for synonyms, sequence , procedure using dbschema -d <> -t <> -f all -- for SPL…
sequence skips in ADO
I am trying to replace some of our old document# generators that were written back before IDS had sequences. They just cause unwanted contention. It seems that ADO is double-buffering and hitting the sequence twice, causing all numbers to be either even or odd. That may be ok for…
Re: Make MySQL syntax work in Informix
Hello Schuyler, Looking at the below SQL, I presume that you are trying to get th next value in a sequence of values? If this is the case, then you need to create the hibernate_sequence table as a sequence, or, presuming the table has more columns than just sequence related col…
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…
Insert problem
You cannot use serial unless you change the structure to a linked list by serial number (BTW rowid is a poor choice for a column name as IDS has an internal record address which is called rowid and you will be hiding it - OH and values is a keyword also). The other alternative is…
XBSA client/application
Hello, I would also like to find the source for an XBSA client or application (i.e. links against an XBSA library) so I can better understand the XBSA API, function call sequence , etc. Vasili…
XBSA client/application
Hello, I would also like to find the source for an XBSA client or application (i.e. links against an XBSA library) so I can better understand the XBSA API, function call sequence , etc. Vasili…
RE: EJB3 and informix sequences
Sorry, I have worked a bit with Hibernate + the EJB3, but I did not use the sequences. > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Donaubauer Bernhard > Sent: Thursday, February 22, 2007 18:23 > To: …
EJB3 and informix sequences
Hello! I try to get EJB3 (Hibernate), JBoss and Informix sequences to work. Here is my Entity Bean: package com.tresorband.yucatan.TabLagerBuchungen; //BD Tabellenname: lagerbuchungen import java.io.Serializable; import java.math.BigDecimal; import java.sql.Timestamp; impor…
using a var in spl alter sequence
I have an application that requires a series of unique 12 digit integers. The left most 4 charaters are the year and the right most 8 are a sequence that gets reset to 1 every January 1. I have created a spl routine that uses a sequence and then a sql restart. The problem is t…
Fetching the last sequence value allocated by any database connection
Does anyone know how to get the current value of a sequence without incrementing it? If you have an existing sequence created with CREATE SEQUENCE pk_seq and in a new database connection you try SELECT pk_seq.CURRVAL FROM systables WHERE tabid = 1 you get: "-8315 Seq…
dropping sequence objects and default db space
Hi there - Running IDS 9.4FC5 on Solaris v.9 Two questions: 1) do sequences get stored by default in default db spaces? Can I specify a space other than default db space to store them in? 2) Why aren't sequences dropped when I drop a database? -- I ask because I created a sequ…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Restore sequence ?
Hello, I have a couple of onbar related questions: I searched in the web and could not get any concrete answers. 1. what is the sequence of the restore order for the dbspaces ? Default looks like it is restored in alphabetical order. i.e. rootdbs, Critical database in alphabetic…
Problem with sequences
Hi, we have a weird problem on our development server, which is not reconstructable. Maybe anybody here encountered a similar problem. Any hint could help us (though it is not really critical, but a design decision could be dependent on the solution): We have a simple table, wh…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Q: writing new locale files
havbe you contacted your Informix support provider to log a bug with the exisiting collation sequence?…
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.…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
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…
RE: Sequences
Scottishpoet wrote > according to the SQL syntax Guide "Authorized users of a > sequence can request a new value by including the > sequence.NEXTBAL expression in SQL statement" > > http://publibfp.boulder.ibm.com/epubs/pdf/ct1sqna.under > "create sequence" (2-207) > > so, I tri…
Re: Re: Sequences
Quite cool! J. -----Original Message----- From: Claus Samuelsen <csa@dk.eye-bee-em.com> To: informix-list@iiug.org Date: Tue, 15 Feb 2005 22:59:33 +0100 Subject: Re: Sequences Here's an example which does what you want. You have to use both a trigger and a function: create ta…
Re: Sequences
Here's an example which does what you want. You have to use both a trigger and a function: create table mytab ( tid integer, txt varchar(10) ); create sequence myseq start with 10000 maxvalue 19999 cycle; create function myval() returning integer; return (select…
Sequences
Is it possible to set up sequences to mimic the actions of a serial field ? (IDS 9.4 FC2) I want to be able to insert a new record with out changing the application code but with more control of the limits of the serial field. I have a table - create table tab1 ( tab1_id int8, …
Re: Isolation levels in Informix vs Oracle
Serge Rielau wrote: > Sidenote: SEQUENCE is "dirty read" by definition and it is quite popular > in Oracle :-) > > Cheers > Serge By whose definition? Certainly none I have ever heard. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u'…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
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…
Admin/Develop Tool for Informix
Hi all, I need a tool to develop and administrate an informix database. I only knew about from AGS. Is any other tool /freeware perhaps) with which I can do basic things like wor with tables, sequences, procedures? thanx a lot for help R�diger…
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…
Onbar Restore Sequence Question
Hi There, I have a restore problem with a third party backup software that conects via xbsa to onbar. The problem we are having is that the backup software is not 'asking' for the second tape when the dbspaces to restore are on the second tape. An issue has been raised with the…
Re: How to get NEXTVAL of a sequence without seq_name.nextval?
Jonathan Leffler wrote: > GV wrote:\\ > >> I have a table with clients and a sequid, in this sequid I will put >> the id of the sequence that corresponds to the client: >> >> CREATE TABLE client( >> name CHAR(20), >> sequid INT REFERECES syssequence…
How to get NEXTVAL of a sequence without seq_name.nextval?
Hi, I have a table with clients and a sequid, in this sequid I will put the id of the sequence that corresponds to the client: CREATE TABLE client( name CHAR(20), sequid INT REFERECES syssequences(sequid) ) Every time there is an inser…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
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…
Lock Queue Behaviour
We have an application that will lock a table in exclusive mode and then another 10 transactions will kick off to access that table with wait in shared mode. The 11th transaction is another lock exclusive. Testing shows a straight queue however is there a chance that the order of…
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…
Re: IDS to DB2 conversion
OTC, I don't recall having claimed that sequences are a relational feature. It's the admission that purely relational has limits in the real world. Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab…
Re: IDS to DB2 conversion
And what if you want a db-wide unique ID? I like sequences better than SERIAL/IDENTITY they are a functional superset. Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab…
Re: IDS to DB2 conversion
Sequences, Instead of triggers. Both in IDS 9.4 I don't know about what's going on under the hood, but DB2's and IDS'/XPS' optimizers have very different strengths. A lot they can learn from each other. Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab…
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…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Sequence Number Generator in IDS 9.4
Anyone using or familiar with this new feature in IDS 9.4? We are wondering what it would take to convert from IDS 7.3 to 9.4 and implement this feature. How would serial numbers be converted to sequence numbers? Is there a utility to do this? Thanks for any input!…
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…
Clarification on ONBAR restore sequence..
Hi I would like to clarify regarding the ONBAR restore. I want to perform an alternate client restore.The backups are serial whole system backup using "onbar -b -w -L 0".I have the ixbar file which contains only the recent level-0 entries. Assuming that the RESTARTABLE_RESTOR…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
checkpoints
Hi, i am working with IDS9.30UC2 on solaris 8. I have to optimize checkpoints duration. What is the writing sequence during a checkpoint ? Does Informix write on disks sorted by chunk number or sorted by dbspace and chunk number ? i have to know that because i would like to p…
Re: Sequences
Hi, Sequence Objects support is introduced in IBM IDS 9.40 version. Regards Samar Jack Parker <vze2qjg5@verizon.net> wrote: Take a look at the serial datatype. cheers j. ----- Original Message ----- From: "Manel Falcó" To: Cc: Sent: Tuesday, March 04, 2003 1:32 PM Subject: Sequ…
Re: Sequences
Hi, Sequence Objects support is introduced in IBM IDS 9.40 version. Regards Samar Jack Parker <vze2qjg5@verizon.net> wrote: Take a look at the serial datatype. cheers j. ----- Original Message ----- From: "Manel Falcó" To: Cc: Sent: Tuesday, March 04, 2003 1:32 PM Subject: Sequ…
Re: Sequences
Take a look at the serial datatype. cheers j. ----- Original Message ----- From: "Manel Falcó" <manel@semic.es> To: <ids@iiug.org> Cc: <informix-list@iiug.org> Sent: Tuesday, March 04, 2003 1:32 PM Subject: Sequences > Hi, > Is there any way to generate a GENERIC sequence in th…
sequences
Hello! Is there an analogue for Oracle sequence in Informix ( non transactional )? Thanks. Artem Goncharuk…
UDR: DBINFO('sqlca.sqlerrd1') -- transaction based?
Hello, I am trying to write a UDR that is a sequence number generator: uses a separate table to hold sequence values. Does the DBINFO function in Informix need to be transaction based to be used properly? This seems to make sense to me that you would need to execute this as a …
fonts!!!
"R. Alonzo" wrote: > This is a multi-part message in MIME format. Please don't post MIME. > I am currently doing a report but the report is too big and was > wondering > how to change the font from informix-4gl. In otherwords, I would like > to minimize the font being printed…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: World's No.1 SQL server!! PostgreSQL defeated Oracle, MS SQLserver, DB2, Sybase, Interbase....!!!!
>> In fact I'm currently trying to test Oracle myself for a German client, and >> have >> hit a brick wall. Does Oracle have an AutoIncrement field (i.e an >> automatically increasing counter)? My German is normally OK but all my docs >> are in German and I can't guess what the…
some questions about Informix
> > User1 > > begin work; > > execute function sequence('same_name'); > > User2 > > begin work; > > execute function sequence('same_name'); > > If you use CURSOR STABILITY isolation level, then it is no problems with > multiuser access for 'sequence'. I test and ther…
Informix sequencing
I'm a bit new to Informix and need some help with how informix handles primary keys and sequencing. Oracle uses sequences and manages them using CURR_VAL and NEXT_VAL to manage record sequences. How does Informix handle this? Is it handled only by using a SERIAL or SERIAL8 dat…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: 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…
LC_COLLATE
LC_COLLATE controls locale specific collating sequencing for sorts, etc. The default locale and colating sequence are 'C' which is ASCII natural collating (as opposed to say German collating or phone book collation). Art S. Kagel "howard.jones" wrote: > > Does anybody know wha…
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…
create sequence ...
What is the informix equivalent of Oracle's: CREATE SEQUENCE sequence_name INCREMENT BY 1 START WITH 1 thax alot, stefan…
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…
Incrementing sequence number
OK, you've all come across this scenario I'm sure, so can someone save me having to reinvent this particular wheel, please? You've got this table which stores, among other things, a name and a sequence number within name: Annie 1 Annie 2 Annie …
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…
D4GL Text fields and Wordwrap
> Hey, won't anybody take a stab at this? Are we the only ones having > this problem? I'll have a stab , don't know if it will help. I use 4GL not D4GL. First of all if you print to a file are the hard returns in the right place when you view it ? If not then I'd call support …
Week-Function in SQL ?
Hi, is there a "week-function" in the Informix-SQL ? Something like SELECT start_date, week(start_date) FROM ... => start_date week 2.12.1999 48 ...or has anyboy an idea to do this via a SPL Sequence ? Thanks Markus…
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…
Re: Sequences and Serials
From: troegers13@my-deja.com > >I am working with Informix for the first time. I understand the >basics of the Serial datatype. The problem that I am encountering is >that I need to get the value of the Serial field after the record has >been inserted, to use as a foreign key f…
Sequences and Serials
I am working with Informix for the first time. I understand the basics of the Serial datatype. The problem that I am encountering is that I need to get the value of the Serial field after the record has been inserted, to use as a foreign key for records in other tables. I have…
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…
Informix sequence number generator
Greetings all, i'm new to Informix and would like to know if there's the capability to automaticall generate sequential numbers for an id field in Informix. Any help will be appreciated. Thanks in advance…
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…
Sequencing chunk population in dbspace
I am using IDS 7.23 on Solaris 2.5.1. I have defined a dbspace with three chunks and create a table in that dbspace. I then proceed to load the table using a migration utility. How will the engine decide in which chunk to store the data?…
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…
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?…
ESC-Sequence in Report
Hello to all! Is it possible to ESC-Sequences in reports?. I'm using Informix 4.00.UH2 SE on a HP-UX 10.01 system. What is to do to use a ESC-Sequence in a report? Best regards. Dirk Emmermacher Nieders�chsischer Turner-Bund e.V.…
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.…
DB Sequences
As someone who knows mostly Oracle, I was wondering if there is an equivalent to the Oracle sequence object which I can use in Informix? I don't really want to have to create a new single column table with a serial number in it just to give myself access to a number sequence!! …
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: load a file in sequence
dday@rheem.com wrote: > > We have a need to load a work table with data from a flat file. > The table has no index and because of several record types within > the table, it needs to loaded in the exact order it was written > to the flat file. The dbload works great 99% of the ti…
load a file in sequence
We have a need to load a work table with data from a flat file. The table has no index and because of several record types within the table, it needs to loaded in the exact order it was written to the flat file. The dbload works great 99% of the time. When we get a larger flat fi…
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: 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: SQL Question
For oracle, it is easy. you can say select rownum, a.* from table1 a where xxx remember use tablex.* rather than just * On Sun, 21 Jun 1998, Krishnan Subramanyan wrote: > hello- > > you can try the following. not sure if it will work but it's definitely > worth a shot. > > c…
Re: SQL Question
hello- you can try the following. not sure if it will work but it's definitely worth a shot. create a sequence (say MySeq) and add the sequence to the select statement. for example, select MySeq.nextval, .... from table; the sequence must be reinitialized to 1 before any new …
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: +…
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.…
Problems with null in a report with Informix-4GL
Hello everyone! I am having problems to send a escape sequence that contains a null character (let a = ascii 0, ...etc. ) to a report to use it with an HP printer. I think it changes it to a blank character. Any suggestion will be appreciated. Thanks in advance Evelio Mart�…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
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…
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…
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…
Semaphore Locking Operation IN INFORMIX OnLine 7.1 Stored Procedure
I am involved in the migrations of an Oracle 7.x application to an Informix Online 7.1 Database. One of the requirements is for implementing something that acts like an Oracle sequence. (for those of you who haven�t dealt with these objects they behave something l…
Re: Further on "How to bring a dbspace down" and OnBar
Sorry about the format of the reply - as you can guess something went wrong with the cr/lf settings. To read my posting, look upon it as a sequence of instructions, from 1 to 11. It shouldn't be too hard to read. Dan…
optimizing the sequence of index fields
We're having poor performance when tracing is turned on for an index whose first field has thousands of identical values. It seems as if a multiple-field index will be more efficient if the values of the first field are highly varied - but I never can tell with Informix! Is the…
Re: Sequences in Illustr/Informix
On 6 Jan 97 at 13:29, Trevor A. Phipps wrote: > Does ILLUSTRA/INFORMIX have a sequence structure, (ie) some > structure for automatically assigning unique numbers without > creating a special table and routines to handle updates to that > table. > > In ORACLE it is handled as f…
Re: Sequences in Illustr/Informix
Trevor A. Phipps wrote: > > ------------4B946A68A00 > Content-Transfer-Encoding: 7bit > Content-Type: text/plain; charset=us-ascii > > Does ILLUSTRA/INFORMIX have a sequence structure, (ie) some structure > for automatically assigning unique numbers without creating a special > t…
Sequences in Illustr/Informix
------------4B946A68A00 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Does ILLUSTRA/INFORMIX have a sequence structure, (ie) some structure for automatically assigning unique numbers without creating a special table and routines to handle updates to …
Sequencers in Informix
hello, is there any way to automate unique key generation in Informix? i am used to doing that by creating sequencer objects in Oracle. i did look at SERIAL datatype. It is not exactly what i had in mind please cc me via e-mail. thanks, - ilya…
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…
Illustra sequence generator?
Can someone help, Does there exist a sequence generator within Illustra, to obtain unique ID's. If not, what is the best strategy to create your own sequence generator. Please help, Peter Rongen __________________________________________________________________ Peter Rongen Phi…
dbimport
Hi, all An interesting question regarding the Informix utilities specificly "DBIMPORT". When the import utility is run what is the sequence of how the database is built. a) Does it create the tables, create the indexes, load the data, and then create the constraints. b) Does i…
How to simulate sequence numbers of Oracle
Hi Folks ! I am trying to port a large ORACLE application to some of the other RDBMS systems using ODBC as API. One of the things I need to deal with is handling sequences. Oracle sequence number generator is an excelent facility, unfortunately not supported by other systems (to…
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?…
ISQL
Possibly dumb question. How does one, if one does, specify to an ISQL form the sequence one would like to see the data when performing a query. -- Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; cwoodall@vth1.vth.colostate.edu…
Re: Sequence numbers in Informix?
In article <CCMr99.29B@apertus.com> robertr@ns.apertus.com writes: } } I am a new user to the Informix line of products. As usual, the manuals } are a bit cumbersome. Could someone please tell me if Informix has a } sequence number generation facility. For example, in Oracle, …
Re: Sequence numbers in Informix?
robertr@apertus.com (Robert Randall) writes: >I am a new user to the Informix line of products. As usual, the manuals >are a bit cumbersome. Could someone please tell me if Informix has a >sequence number generation facility. For example, in Oracle, you can >create a sequence…
Sequence numbers in Informix?
I am a new user to the Informix line of products. As usual, the manuals are a bit cumbersome. Could someone please tell me if Informix has a sequence number generation facility. For example, in Oracle, you can create a sequence and perform a select against it that returns the …
Re: Daily SQL quiz - revisited
In article <1993May13.170650.27426@wvus.org>, sford@wvus.org (Scott Ford) writes: |> Say we have a table that contains many rows. For each row, we have a |> column called "sequence", such that we could have the following: |> |> key_col sequence many other columns |> -------…
Re: Daily SQL quiz - revisited
In article <1993May13.170650.27426@wvus.org> sford@wvus.org (Scott Ford) writes: >Say we have a table that contains many rows. For each row, we have a >column called "sequence", such that we could have the following: > > key_col sequence many other columns > ------- --------…
Re: Daily SQL quiz - revisited
In article <1993May13.182749.14450@stsci.edu> davids@stsci.EDU (David Silberberg) writes: >In article <1993May13.170650.27426@wvus.org>, sford@wvus.org (Scott Ford) writes: > >[munch] >what about the following: > >select * from mytable >group by key_col >having sequence = max(seq…
collating sequence
Does anybody know how to tell S.E. to change its collating sequence for the ORDER BY clause? We need a reasonable output for German. We use the S.E. on top of SCO Unix (with NL support), but Informix ignores any "locales" set at the OS level. Thanks in advance, Martin Hitz hitz…
ESC sequence & arrow keys
> We are using Informix SQL and 4GL version 2.10 on UNIX SYSV3. > Our terminals are emulating vt1220. We are having problems with arrow > keys "breaking". > > For example, user in Query Language editor uses an arrow key, cursor > goes up to menu and [A displays. Apparently, ESC…