Oninit® Archive
Results for “SYSSBSPACENAME”
myimport Problem
Thanks to a boost from Art, this problem is resolved. I admit i should have realized it myself. The answer is turn off logging in the sbspace: 'onspaces -ch <sbspace> -Df "LOGGING=OFF"' . Then, after successful import, turn it back on. The syntax issues that seem caused by som…
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 …
SBSPACE Chunk error
Hello All, We are working on IDS 14.10 and yesterday we created SBSPACES everything was fine, but we are getting multiple alerts for SBSPACE chunks down.But in real chunks are ONLINE. After SBSPACE Full backup didn't run . I'm sharing the screenshot for related to my Queries. Onc…
SBSPACE
Hello All, Need one suggestion, we are having Informix cluster environment with Primary, Secondary and RSS nodes on IDS14.10 . We have to create a new SBSPACE, as I know we need to make change in ONCONFIG file by adding SBSPACE parameter for new SBSPACE name. So can we do it by u…
Informix CDC API - Is there a way to pull the change record using .NET?
Thanks for the response, Andreas. You are correct regarding the Java SDK, which supports the IfxSmartBlob object with a session_id. However, the .NET SDK doesn't provide this object. Additionally, the code snippet in the documentation here: https://www.ibm.com/docs/en/informix-se…
Extending chunk capacity
Hi Jose, from your description I'm assuming we're talking raw chunks here, as opposed to file system files? One difference this would make: the extension operation would be much faster as it wouldn't have to "inflate" a file. So the chunk wouldn't be blocked for so long for othe…
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 ------------------------------…
Simple Large Object Replication
HI, I have a customer who wants to implement Informix Repication (not yet decided which kiind of). He is using lots of Simple Large Objects (Text). Taking into account the fact that TEXT data type are not replicated, he wants to know what is the best approach, storing them into d…
Is there a way to check the sbspace usage by table?
Hello All, I want to know the usage of sbspace by table. In the case of BLOBspace, it is possible to check the usage for each table with the oncheck -pe command. ---- checking utilization for table using BLOBspace $ dbschema -d testdb -t mycatalog ... create table "informix".myca…
Smart Blob Metadata Queries?
Can anyone let me know how to determine the metadata defaults for an SBSpace in code? I know that I can get that from "onstat -g smb" but I want to be able to query the info using SQL or UDR API functions. Anyone? ------------------------------ Art Kagel -------------------------…
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…
Spaces and Spindles: Thought Experiment
IDS 12.10.FC12 Solaris 10 1/13 Consider a new Informix instance with db/sbspaces (all 1 chunk) as follows: 1) dbspace for the database catalog and data tables; 2) dbspace for indexes (16K pages); 3) sbspace for sblobs (photos-- relatively infrequently accessed); 4) root dbspace …
enumerate contents of sbspace?
IDS 12.10FC12 Solaris 10 1/13 How might it be possible to exhaustively enumerate all objects within a given sbspace? That is, for each object in the specified sbspace, list the database, table, and column which is associated with that object? Thank you. DG…
prevent automatic generation of sbspace
How can I prevent automatic generation of SBSPACE and automatic registration of BTS-Modul ? IDS 12.10.FC12 My Instance has no SBSPACE and no datablade is registered in any database. If a 'normal' user with connect right runs (can be accidental) a SQL-Statement like 'SELECT xxx FR…
dbexport/dbimport question
We want to back up a complete database. The catalog and all the tables and stored procedures. We want to be able to restore it on another machine (same configuration). We want it to function as quickly and as consistently as invisible-to-the-user as ontape. In the past, we used …
Moving SLOB columns to another sbspace
Hello everybody! We want to move several SLOB columns(CLOB-BLOB) from different tables whom reside in a same sbspace to a new sbspace for each table for backup purpose (to launch parallel backups and reduce the time takes the backup), for this goal, we want to know the approxima…
How to copy table w/ CLOBs to another IFMX server?
IDS 12.10.FC12 Solaris 10 1/13 We have a database with a table that contains CLOBs. How can I copy it to another Informix Server? "SELECT * FROM <database>@<instance>:<table> INTO <new_table>" fails with an error message that CLOBs are not supported for distributed queries. d…
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…
Could not do a physical-order read to fetch next r
I have increased the buffers and set the SHMTOTAL to the nearby by max value. When i rum the oncheck -ce we got an error for sbspace ERROR: Could not obtain lock for Partnum I have ran the onspaces -cl sbspace but the error occurs again.…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Informix and thin provisioning
Luis, Can you get downtime to run oncheck -cS on just the affected sbspace? [1]https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ib m.adref.doc/ids_adr_0381.htm Luis/Andreas, The documentation above seems wrong, surely it should read as follows " The -cs opt…
Smart Large Objects issue
Dear Guru's Our IDS version : 12.10FC8 Environment: Windows 2012 R2 Middle layer: JBOSS AS6.1, JAVA 1.7 Application : web-based application We are facing an issue in our production server which make application hang. Temporary restarting the application server to work. Appli…
Could not position within a table
Two different and likely unrelated problems. For the first problem: onmode -I 154 might give you more clues (see https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.adref.doc/ids_ adr_0666.htm ) -> "Lock Timeout Expired" (error # 154) is your problem, i.e. some (ap…
Issue in production server.
Hi Floks, Yesterday night I have done a activity that, Moving Live production server to New server. All the config parameters are set properly as like existing one and installed same version of informix IDS 12.10 FC8. Using DBEXPORT and DBIMPORT we have moved the data. Now the …
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…
-12014 Smart Large Objects: Cannot find entry in
-12014 Smart Large Objects: Can not find entry in lofd table. This error occurs in informix 12.10FC8 when activating ER Keys The solution is to apply the deletion of statistics as follows Update statistics low drop distributions only; Caution should be exercised in productive…
Convert BYTE column to BLOB
Informix 12.10 Solaris 10 We have an old table with some photos that are stored as simple large objects (in a column type BYTE), and stored in the table. We would like to convert that column to hold smart large objects (column data type BLOB), and be stored in the default sbspac…
More Smart Large Object Problems
Informix 12.10 Solaris 10 Until recently, I have not been too involved with sblobs. Now that I have to deal with them, I am finding continual problems-- both theoretical and administrative/management (as in "lack of")-- with these things. Basic violations of fundamental Relation…
Smart Large Objects Mystery?
Informix 12.10 Solaris 10 I have been dealing with these things a lot, recently, and there is a lot about them I don't understand. However, I would ask about one thing in this post. Situation: I had an sbspace that was nearly full. With some guidance from this forum and Inform…
Usable space available in an sbspace?
Informix 12.10 Solaris 10 I'm finding it challenging to be working with sblobs and sbspaces. Even the terminology is a bit confusing to me. For example, A BYTE type is a blob, but a BLOB type is not a blob but a smart blob. Or maybe I have that wrong. But, that's a rabbit trail.…
Replace sbspace with larger?
Informix 12.10 Solaris 10 I have an sbspace consisting of one chunk (symbolic link). I would like to replace that drive and make a much larger sbspace (still only one chunk). Will the following work for replacing the sbspace (a "last checkpoint" restore is acceptable): 1) Do a …
sbspace size insufficient after dbexport/dbimport
The page size of the sbspace in both instances is identical. DG…
LOGBUFF size
Hi, We set , LOGBUFF 256 Occasionally, I still see this sometimes, 58087a28 Y--P--- 4082303 saapmgr - 551cf760 0 1 0 0 580882e8 G-BPX-- 3671545 saapmgr - 526d0898 0 2 29 48411 58088ba8 Y--P--- 2478091 saapmgr - 55a96230 0 1 116 14986 So, a session is waiting for the log buff…
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)…
new features about dynamic parameter added in 12.1
There may be a better approach, but if not you can do something like: 11.7: onmode -wf dummy=1 Configuration Parameter to be changed is not valid or not supported with this option. The following documented configuration parameters and environment variables can be modified on t…
onstat -d
Now, I am no one to dispute Jacques however, I ran into an issue lately where the metadata portion was full and I was still able to insert blobs. It is documented that a rather large portion (sorry, don't remember the percentage) of the actual data portion of each smart blob is a…
oncheck & BTS index
Thanks Mark! That sort of explains what we are seeing -- except that the second running of the oncheck, within minutes of the first, still grabbed a bunch of logical logs even though it should have been a no-op. However, there was no dbspace usage changes, so that seems correct. …
Moving BIG smart large objects
Hello, I need recommendation how to move BIG tables with CLOB/BLOB between to physical servers in effective way. We have system where data layout (schemas) will be changed (reason is - to optimize it in respect of current requirements) This source system (current production) ru…
DBexport -9810 error
Hi All, I've never experienced issues with dbexport before, but this is a doozie! Informix 11.50.FC9 SunOS Solaris 10 The dbexport is kicking back a "-9810 - Smart-large-object error." but with no secondary error message. I believe this error has to do with possible corruption …
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
VERY slow BTS index build
Hi Michael, I believe SBSPACETEMP is a list of sbspaces. I am know that BTS will accept a list of sbspaces, but it only uses one of the spaces listed, as documented in BTS: A temporary sbspace that is specified by the SBSPACETEMP configuration parameter. The temporary sbspace w…
Unable to drop sbspace
Hi there, I've informix dataserver Version 9.40.FC9 on AIX server. When trying to remove a sbspace I got the following messages : #onspaces -d siglob1dbs1 WARNING: Dropping a sbspace. Do you really want to continue? (y/n)y The sbspace contains smart large objects. To drop this s…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
question on SBSPACENAME and SYSSBSPACENAME
I recently added our first subspace and wondering about SBSPACENAME and SYSSBSPACENAME in the onconf file. My assumption is I set the SBSPACENAME to the smart-blob dbspace name (in my case: sdbs0) so the system has a default and the developers don't have to specify which sbspace…
Who is using a smartblobspace
Thanks Art and Alexandre. Tried both suggestions with the following results: - the select does show a correct result if you have used a PUT IN, if not the data ends up in the default SBSPACE (which is the problem in my case) and there is nothing in syscolattribs. - the oncheck…
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.…
Bitmap is wrong for partp in sbspace
Hello, we have a problem with inserting/updating SBLOBs in one of four sbspace. There are many AFs in online log (all AFs describes the same issue): ========================== 15:55:10 IBM Informix Dynamic Server Version 11.70.FC3 Software Serial Number AAA#B000000 15:55:10 As…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
space taken by table - including smart large obj,
I'm looking for a way to determine the amount of space "attributable" to a table, including the space taken by any smart large objects referenced by rows in the table. I realize that smart large objects technically aren't considered part of a single table, since there is can be a…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Unable to start the storage space backup: Smart La
Hello, I'm running IDS 11.50.FC9W1 on Solaris 10, and doing level 0 backup and encountering this error, note that, with "whole system" backup, this error does not so up?? So basically, the only one dbspace that did not get backed up is this smart large object dbspace, (sbdbspace)…
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,…
Re: Creating a table with BLOB in a SBSpace
I used the command to create table in sbspace successfully. for example: CREATE TABLE sys_datastore1 ( trans_ref NVARCHAR(32) NOT NULL, trans_data BLOB, PRIMARY KEY (trans_ref) CONSTRAINT sql1xxx2 ) put trans_data in (sbsp1) But you should create sbspace sbsp1 first.…
PHP and sqlca array
On Thu, Jul 19, 2012 at 6:07 AM, JOHN CALLICOTTE <john.callicotte@ottawa.edu > wrote: > I tried that, but no luck. I actually went over to do this in ESQL/C, but I > can't get the compiler to recognize the loc_t data type. The structure for loc_t is declared in locator.h in $IN…
Smart Blob errors
I'm using the Spatial Datablade with Informix 11.50FC9 and am encountering smart large object errors in one of my tables. I understand the meaning of the error below - that there is a row in the table that refers to a smart large object that is no longer there. (Although I don't …
ER and sbspace Logging Mode
Continuing my tale !! (IDS 9.4 on AIX 5.3) I have successfully restored an ontape archive from a proposed HDR primary to a proposed HDR secondary, run the relevant onmode -d primary|secondary commands and seen outstanding logged transactions transfer and apply. At the point of Pr…
Basic Text Search
Hi, Environment. Basic Text Search Blade Linux, IDS 11.70.FC4, BTS 3.00 Questions. 1. Any idea how much temporary sbspace is required to built a BTS index on a varchar(70) column with 5 million rows ? - I have allocated 4GB of temporary sbspace and still not enough. 2. Any …
Smart Blob without Logging
Smart Blobs can be either logged or non-logged. The metadata for the s= mart blob is always logged. The metadata contains information about the sma= rt blob object such as extents and reference counts. When you create the smart blob space, you can specify the default loggi= ng b…
Re: Summary: Error on IWA initialization:Assert SE
Hi, Have you created an sbspace (sbspace1 in the example below) and have the following entry in your $ONCONFIG? If you have to create and add the entry to $ONCONFIG, you do need to restart the server. SBSPACENAME sbspace1 # Default sbspace name http://publib.boulder.ibm.com/in…
Migrating from 7.31 to 11.70 with ER?
I'm looking into performing a migration from 7.31 to 11.70 with ER. I'm not even sure this is possible, although from what I've read it seems to be feasible. I'm now reading through this IBM doc, http://www-01.ibm.com/support/docview.wss?uid=swg21153338 and I'm reading about h…
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 …
Spatial Data
hello reading thru the manual states that the ONCONFIG parameters for SBSPACENAME and SYSSBSPACENAME must be set for the default sbspace. We are running an HDR pair and have the parameters set on the Primary Server - does it also need to be set on the Secondary Instance ? thank…
HDR and clob/blob/byte/text/ etc.
I just want to verify I have this right. If you use a SBSpace or a BLOBSPace - they are not logged, therefore you cannot use HDR on that database. Is that correct? So if you are using the BTS datablade - even if it is on Character or varchar fields, you can use HDR because you …
Informix question
Hi, I have two confused question. 1 When a update SQL will update totally 3 pages in bufferpool? How many mutex IDS will allocate for this thread in the buffer-head entry in the buffer table? 2. What the temporary sbspace will be used for? thanks for your time.…
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…
Extending SBLOBSpace
I think I may have created my (development) Informix database server with too small a SBLOBSpace, so I am trying to extend it. (My current file sbspace.000 is only 1024K in size) Using the command C:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70> onspaces -a sbspace -p C:\\\\IFM…
Error IndexInput read past EOF using index BTS
The server message log shows that it ran out of sbspace, although the error message on the command line is a bit obscure. The message will change in further versions to something like that FSE IO write error. The sbspace %s might be full, check the online.log (where %s is the n…
log usage with ER and blobs
General recommendation is to configure one logging and one non-logging sbspace for CDR queue smart blob space. This way smaller size txns gets spooled to logging sbspace and larger txns gets spooled to non-logging sbspace. CDR_QDATA_SBSPACE accepts multiple sbspace names. Thank…
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.…
freeing sbspace space
I have a table with 3 columns, one is a blob held in a sbspace; the sbspace was filling up so I purged out old records and did a level 0 backup. I was looking at utilization of the spaces and chunks using ServerStudio. The sbspace shows as being allocated even though there were n…
Blob size from SQL
I have a table with a blob column (that is stored in a sbspace). Is there a way to do something like: SELECT * FROM <table> WHERE SIZE(<blob_col>) = 12345; I have tried that and also using "LENGTH()" instead of size. No go. Is there a way to do this using SQL? Thank you. DG…
Physical Log Size
How did you "increase" the size? You can only do that song onparams. You cannot do that just by changing the Onconfig file Art On Jan 25, 2011 12:10 PM, "KENT GRUNDEN" <k.grunden@hoogwegtus.com> wrote: > IDS 11.50.FC4WE Windows Server 2008 64bit > > I keep getting the message wh…
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…
XML/PDF/Images/Pictures/Audio/Video files
Yes to all, see details below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my emp…
Locking & Logging Issue
Thanks, Cesar. As I mentioned, the only "change" has been a spike in searches via the external web app. Mining, possibly. Yes, we are using smart data spaces (sbspaces) to hold the CLOB information. That is where we see the HDR+IS locks placed on the smart large object headers.…
HDR and Spatial Datablade
Hello 2 things - #1) Have not read anything special yet regarding installing this nodule but is there anything special that needs to happen when installing and registering Spatial? I have already come across reading from others that the onconfig paramter of IFX_EXTEND_ROLE need…
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…
Re: Freeing up sbspace
On Jan 25, 4:27 pm, "Laurie Gustin" <lgus...@utah.gov> wrote: > IDS 11.5 FC5 > Linux x86 > > I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space. > It didn't seem to free up any space. Is there something special that needs …
Re: Freeing up sbspace
On 25 Jan, 22:27, "Laurie Gustin" <lgus...@utah.gov> wrote: > IDS 11.5 FC5 > Linux x86 > > I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space. > It didn't seem to free up any space. Is there something special that needs to…
Freeing up sbspace
IDS 11.5 FC5 Linux x86 I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space. It didn't seem to free up any space. Is there something special that needs to be done to free up the space for re-use? I had to add another chunk t…
Freeing up sbspace
IDS 11.5 FC5 Linux x86 I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space. It didn't seem to free up any space. Is there something special that needs to be done to free up the space for re-use? I had to add another chunk…
IDS, BTS datablade and HDR
what is an sbspace? Can you point me to some documentation?…
Compression and Smart Blobs
ids-bounces@iiug.org wrote on 11/18/2009 07:48:10 AM: > From: > > "Clifton Bean" <clifton_bean@hotmail.com>: > > To: > > ids@iiug.org > > Date: > > 11/18/2009 07:49 AM > > Subject: > > Compression and Smart Blobs [18146]. > > Sent by: > > ids-bounces@iiug.org > > IDS 11.50.FC5 A…
Re: HDR Replication Requirements
Ahh I understand now.. are the disk requirements in HDR the same as in ER ?(transaction record dbspace, row data sbspaces). the manual dosn't specifically say they are needed.…
Onbar problem
Hi we have got another onbar problem : In the middle of a sbspace-backup , onbar was cut down by a sanswitch-port malfunction and now it looks like the archive-flag for the sbspace has been permanently set. When i try to start another backup on this instance , bar_act.log says…
XML and Smartblob Storage
IDS 11.5.FC5 AIX 5.3 XML Programmer can run simple functions like genxmlqueryhdr(). Example: On web database as user ifxweb "EXECUTE FUNCTION genxmlqueryhdr('emarriage','select c_grm_lname from emarriage');" runs! Ran into errors when XML output is greater than 32739 bytes. R…
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…
Informix size & sbspace location for BLOB & BLOBS
Does anybody know how to get the size and sbspace location of BLOB/ CLOB data using the embedded C functions of ifx_lo_specget_extsz() & ifx_lo_specget_sbspace() ? for an example, who might have a table such as; create table xxx ( first_col integer, sec_col "informix".…
IDS- How to find sbspace storage utilization
I was trying to find out the storage utilized by dbspace,sbspace and blobspace. I have executed the following query in dbaccess select c.pagesize pagesize,d.name dbspace,c.chksize totalpages,c.nfree freepages, c.fname filename from syschunks c, sysdbspaces d where d.dbsnum = c.d…
Re: Fwd: inserting blobs
Thanks Johnathan yup you're right, they just need to read it out in a select statement ( against another field ). Thanks for the advice. From what I've been reading up tonight I'll make sbspace and use put clause. It sounds like the developers should use an esql/c routine to est…
Fwd: inserting blobs
For a simple large object (types BYTE and TEXT) you deffine the blobspace into which to place the BLOB column in the column's definition line: ... some_text TEXT in my_blobspace, ... For smart blob columns you use a PUT clause after the EXTENT clause: ... some_slob_col CLOB, ..…
Creating a table with BLOB in a SBSpace
Hi everyone! Version of IDS: 11.50 FC5 OS: HP-UX 11.11 I'm trying to create a table with a BYTE datatype in a SBSpace. When i run the DDL statement on DBAccess, i've got the following error: CREATE TABLE TB_ANEXO_GUIA_1 ( ID_ANEXO_GUIA INTEGER NOT NULL, CD_GUIA_PRESTADOR VARCH…
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…
database in blobspaces/sblobspaces------WebKitForm
No. A database, or for that matter a permanent table or index, can only be created in a 'normal' dbspace. Temp tables and their indexes can be created in temp dbspaces, but still not in blobspace or sblobspace. You can only place Simple Large Object columns within a table can be …
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
query on sbspace/blobspace
I have the following requirements: 1) I need to identify all the tables which have columns TEXT/BYTE/CLOB/BLOB 2) I need to find out the columns of type TEXT/BYTE/CLOB/BLOB is using which Blobspace/Sbspace to store data. 3) I should be able to execute an SQL query and get the …
more observations when testing V11.50.UC4
On 2 June, 18:38, Richard Kofler <richard.kof...@chello.at> wrote: > Hello fellows, > > today I gave sysadmin and friends a second look. > I found this techarticle to be VERY helpful:https://www.ibm.com/developerworks/data/library/techarticle/dm-0709si... > > Still I miss some go…
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…
SBSPACE FULL
I have a sbspace with 50GB. I stored 100,000 and recived a message of space full. I created the sbspace with 25 chunks of 2GB each, with the default options. this objects store only 5MB in File System. How can I calculate the space used for each object in my sbspace?. The mess…
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.…
Re: error 12115 and how to delete a smart blob
Davorin Kremenjas ha scritto: > If you have no idea what I'm talking about, THEN DON'T DO THIS, > PLEASE! Talk to IBM Tech Support instead. > And don't mention my advice to them :-) Yes, i have idea... but my sbspace are raw device, and if i do something wrong with the db man…
error 12115 and how to delete a smart blob
hi during dbexport of my db, i have got an error ---- *** Error fetching data row. 9810 - Smart-large-object error. 12115 - Smart Large Objects: The LO header page is a wrong length - probably corrupted. --- Using finderr, i found: ------- An internal error probably occurred …
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…
Using BLOB in Informix 7.31
NRON NRON wrote: > Dear all, > > I would like to tell you that I am using Informix 7.31 (Text based). > > I want to place few image files (PDF and/or JPG format) on a report writing by > Informix. I hear that I need to use BLOB and I never use BLOB before. > > Could you tell me h…
Doubts about replication
Hello, folks!!! I´m in a hurry, testing a primary-target based replication using IDS 9.4. That´s all working fine, except that when my replicated db instance is down (offline), my sbspace fill so fast that I had to adjust it. After I resized it, I made several tests again, and it…
Unable to perform delete (error 12097)
sql that results in this error. DELETE FROM tc_cad_preload WHERE oid="a0dec1974db1f34c0114ba2129870000"; Results in: -12097 12097 Smart Large Objects: open: Bad smart-large-object address. Object might have been deleted. Object might have been deleted. I am running IDS 9.4 a…
-12048 Smart Large Objects: unique ID does not
Hi all, Version : IDS 9.3 FC6 OS : Sun I have a table where one of the column is CLOB type. When i perform a delete on this table, i have the following error: -12048 Smart Large Objects: unique ID does not match. Smart large object probably deleted. According to IBM site, the…
Error -9810 -12048 when deleting/updating/unloadin
-------------------------------------------------------------------------------- Dear all: We're facing a disturbing error when trying to delete, update or unload one row with a blob field. When you try to modify or unload it, IDS returns the following error: 9810: Smart-larg…
RE: in search of Informix metadata
A decent starting point for you would have been http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/030 5parker/0305parker.html Sounds like you are a bit past that. the SQL Reference Manual chapter 1 goes through each of the catalogues and details the conten…
SBSpace
Hi all, i have a problem when creating a table into a fresh SBSpace. i use IDS 9.40 UC5 over AIX. i created an sbspace using : ------------------------------------------------------------ onspaces -c -S sb_1 -p /dev/chk2 -o 0 -s 1024000 ------------------------------------------…
Write Simple large object to a file using JDBC 2.x
Is there any function that lets you write a byte column to a file ..something like lotofile for smart large objects. Alternate way is to get the inputstream from .getByteStream and write to a file, I was just thinking of letting JDBC driver do it for me.…
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…
Blademgr error
Stuart, I don't see the DEFAULTSBS keyword in the onconfig file. I do have the SBSPACENAME and the SYSSBSPACENAME keywords. Both keywords are pointing to a valid smart blob DB space. The DB space has plenty of free space available. Mike > -----Original Message----- > From: ids…
ER warning
Does anyone know the meaning/importance of this ER warning? 10:11:43 DR Warning: Non logged Smart-Large-Object write in replqdbs Is my CDR_QDATA_SBSPACE configured incorrectly? IDS 10.0.UC5 on RHEL3 Thanks, Andrew…
Re: Converting TEXT/BYTE to CLOB/BLOB
On Fri, 2007-01-12 at 08:18 -0700, Laurie Gustin wrote: > We are trying to move some of our data to Smart Large Objects in sbspaces.... > > We are currently looking at unloading each TEXT field to a file using unload from a cron job, one row at a time - we cant seem to get unload…
Converting TEXT/BYTE to CLOB/BLOB
We are trying to move some of our data to Smart Large Objects in sbspaces.... We are currently looking at unloading each TEXT field to a file using unload from a cron job, one row at a time - we cant seem to get unload to work from within a stored procedure. Then using the FILE…
Re: Newbie BLOB question
On Fri, 2006-11-17 at 11:39 -0800, debbie@diversifiedmetals.com wrote: > Thank you, Adam. > I'm no DBA so please bear with me. > > > > If so, how do you populate it? > > > > ? Via SQL? > > I figured, but I'm not clear on the syntax....what do you use to > populate and retrieve? …
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…
systabnames & partnum
in4mixDBA wrote: > Hello... I am new to this group... as well as a new informix DBA... > > I was wondering if there is anyway for me to know is the partnum column > from table systabnames in the sysmaster database is a unique column. > > I checked my database and it is unique. I…
Alter Table in 9.4.FC8
Colin Dawson wrote: > We have an ALTER TABLE statement that will change VARCHAR(30,0) to > VARCHAR(80,0), The table has 99M rows. When running a test it looks like > it is altering every row, will it do this instead of the expected quick > alter because we are changing the length…
Re: Need info on blobspace blobs
Madison, I use a blobspace with a 16K page, the DB (Business Objects) was installed with the BYTE/TEXT columns in the tablespace along with the other columns in the table, I moved it to a blobspace to stop the (horrendous) levels of logging. Regards Colin There are 10 types o…
Re: Need info on blobspace blobs
Ben Thompson wrote: > Madison Pruet wrote: > >> I need an idea of the number of customers who are using blobspace >> blobs as opposed to smart blobs. That is - how many customers are >> using BYTE/TEXT as opposed to BLOB/CLOB >> >> Also I need some idea of the impact of not havi…
Performance issue after 732 to 94fc6 upgrade
Doug- We discovered when we made a similar transition that temporary tables built and indexed in a program will not use their indexes unless update statistics is run against them. The 9.x engine apparently has a difference in the optimizer which caused this. --EEM > -----Origi…
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 …
DataBlade Manager
ah - thanks - i am seeing that now - we created an sbspace after getting this error : blademgr: ERROR: DataBlade spatial.8.20.FC2 could not be registered in database test_data. select SE_TestSbspace("SBSPACENAME") from informix.systables where tabname='systables'; You must def…
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/…
Re: Fw: 617 error
Hi Darren, it is not possible to insert char data into text or byte fields using "insert into ... values(...)". As you already figured out you can load data from a file "load from ... insert into ..." . You can also write a program (ESQL/C, Visual Basic, what ever) to do this. Y…
RE: What???
1. Does anyone here use Timeseries and real time loader apart from that clown? 2. Where are the manuals? 3. Why does IDS need to be bounced when using Real Time Loader when the table schema changes or the table storage gets moved (sbspace/dbspace??). 4. I understand Timeseries…
Can't INSERT blob into specific blob space using JDBC
Hello again to all, Thx for everyone's responses. Just wanted to note that I tried the blob examples that come with version 3.0.JC3 of the JDBC driver and they too fail with the same error when I try to do the insert. I modified the example to include the PUT for the blob column…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Fw: change in pagesize calculation by oncheck - an
On 2/13/06, Manoj Ghogale <mghogale@in.ibm.com> wrote: > This is a changed o/p issue I am facing in oncheck -pS, oncheck > -cS & oncheck -pe commands for blob spaces. > I am adding a smart large object sblobsp and inserting 1 file st-louis.jpg > which is of size 103670 bytes. > >…
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!…
Column level encryption - IDS 10
Because we are using block encryption algorthms with chaining. That means you can not store an encrypted number in only 4 bytes. <hariog@yahoo.com> wrote in message news:1134601844.476897.14850@f14g2000cwb.googlegroups.com... > Hi Folks, > > AFAIK column level encryption is ava…
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:…
Error!!!!!! 9810: Smart-large-object error.
Thanks to Amit Dandekar for load/unload. Now i'm getting the error message "9810: Smart-large-object error.". with no detail. Can someone elaborate, please? My SQL code is (nothing clever); UNLOAD TO "path/filename" SELECT * FROM "tablename" The error description I found is (v…
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…
How can I get different Match Patterns in data stored in BLOB (Text) Variable in INFORMIX Database ?
On Tue, 26 Oct 2004 08:07:03 -0400, Durgesh Sharma wrote: > Hi All, > > How can I get different Match Patterns in data stored in BLOB(Text)Variable > in INFORMIX Database ? > > For Example : > Suppose in my Database named "Employee" in INFORMIX ,there is a BLOB Text > Field name…
Re: Slow writing data into BLOB through JDBC
Hi ! The tests that I have done show the same result as you get. I thought it was a problem using JDBC so I did the same thing with a 4GL program and got the same result. It seems that storing large blobs takes a long time. I also looked at other databases and found similar prob…
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'?…
Delete table from nonexistent sbspace
I don't now how it is happen. Informix version is 9.30.UC2W8 I can't drop database "syscdr". It has only one table "control_send_stxn" on nonexistent sbspace. When I try drop database, I have message: 214: Cannot remove file for table. 110: ISAM error: end or beginning of the f…
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: How to find usage for sbspace
Hi. Try. http://www-106.ibm.com/developerworks/db2/zones/informix/library/techarticle/db_sblob.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: R�Eiger M�hl <ruediger.maehl@web.de> >Reply-To: R�Eiger M�hl <ruediger.maehl@web.de> >To: informix-list@iiug.org …
How to find usage for sbspace
Hi folks, I know how to find the size and free size of a dbspace, but how do I get these numbers for sbspaces? (We just got a new server, which uses sbspaces) IDS 9.40, Windows 2000 and Linux (SuSE SLES7). Any help is really appreciated, 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…
Re: Whatcha' wanta have?????
Back in February Madison asked for input as to what we want to see in the IDS 9.6 release. Although this is almost certainly too late for IDS 9.6 consideration, I don't know of a better forum to request modifications. I've recently stumbled on something which I'd like to see cha…
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…
Where to put logs in a RAUD 1+0 system
I'm about to configure a brand new, fast RAID 1+0-based system which will use logged sbspaces. Conventional (JABOD-based) wisdom tells me to put the logs on a separate device to the busy storage spaces. But, on a 5-disk array, does this idea justify holding back one disk for the …
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,…
problem of sbspace
Hi all, I am using IDS 9.21. Recently, one of my metadata area of sbspace chunk run out of space, and I have to add additional chunk on this sbspace. However, the user data area of the original sbspace chunk is only about half full, and the database nolonger write any data to th…
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…
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.…
performance of inserting large objects
Hi, I have a performance problem when inserting large objects to IDS. An insert of 1 MB simple or smart large object takes about 5 seconds while selecting the same amount of data takes 0.1 second. When I use the function FILETOBLOB with "client" parameter, insert takes 5 seconds…
Clarification on SBSPACES
Hi We have informix Database 9.2 running on Solaris, ad our database is registered with datablades, which we are not using at all. As i am going to set up a new server , i have exported the database and changed the .sql file removed all the scrap except what needs for our Data…
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…
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…
HDR questions
We're running IDS versions 9.21.UC5 and 9.30.UC3, both on Sun Solaris = 2.8 We currently use "smart-blob" dbspaces (sbspace) for xml data storage. = Does HDR support sbspaces? Terrence Mullins Sr Database Administrator WagerWorks.com…
Re: Smart Large Objects: Sbspace is full
I suggest adding new chunks to img_db01, img_db02 dbspaces and no new dbspaces. I don't know how you have been able to add a new table with the same name. You should be used ALTER TABLE. Regards, Guillermo. ----- Original Message ----- From: "Mark" <kbl@net-yan.com> To: <inform…
Smart Large Objects: Sbspace is full
At first, I created following table to store PDF data in column img_doc. create table img ( img_key varchar(40), img_no integer, img_doc "informix".blob, ) PUT img_doc in ( img_db01, img_db02 ); Sometimes later, SBspace img_db01 and img_db02 were ful…
Need to talk to someone about SMART BLOB SPACES & map data.
Need to talk to someone experienced with SBSPACES and determining what to set the metadata parameters to. Have a client who is loading a bunch of map layer data into an Informix database to use with ESRI's SDE toolset. The actual data in the smart blob space seems small but the…
Need to talk to someone about SMART BLOB SPACES & map data.
Need to talk to someone experienced with SBSPACES and determining what to set the metadata parameters to. Have a client who is loading a bunch of map layer data into an Informix database to use with ESRI's SDE toolset. The actual data in the smart blob space seems small but the…
IDS 9.3 Enterprise Replication
If you want to use CDR in 9.30/9.40 you have to set SBSPACENAME and SYSSBSPACENAME in your ONCONFIG to an existing SBSPACE with LOGGING=ON. On Thu, 20 Feb 2003 08:43:30 -0500 (EST) "Jozef Horyl" <jho@nr.dflex.sk> wrote: > Hi, > I have problems to define server for Enterprise Re…
ESQL error messages for BLOBs
I am running IDS.2000 under Linux and am trying to access BLOBs via ESQL. However, when I try to call ifx_lo_create, the function returns an error with the error code -9810. However, I looked this up in the error codes, and the docs said "For more information, check the accomp…
sbspaces
I need some help with sbspaces and the information that is presented from onstat -d and the data in syschunks. When I issue a onstat -d, it appears I have lots of free space in my sbspace's. However, when I query the syschunks table looking at the nfree column, it appears I hav…
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…
9.20v 's sbspce diffrent from 9.14v's sbspace?
HI? I have a question. is IIF2000 9.20 sbspce different from Universal Server 9.14 sbspace?…
Replication blobs questions .
Hi all. We are migrating to IIF.2000 with WebDatablade. The WebDatablade store the pages in Sblobspaces. We want a High Available System, to do this we use HDR but we read at manuals and * Adminintrator's Guide for Informix Dynamic Server.2000 ver 9.2 ----Important: The databas…
DBI/DBD test fail
Jonathan, I'm hoping you can help with this DBI::DBD installation problem. I'm really new with this module so be nice! When I run the make test - I'm getting the following errors.... btw - I'm on Solaris 7, Perl 5.004 DBD 1.0 DBI 1.14 t/t90ius............Null pointer for lv…
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…
Smart Large Objects error -12097
Hello, I have a serious problem with an Informix database that I am using to store Word documents for worldwide distribution. I am using Smart Large Objects to store the documents and when I try and retrieve them (thousands of them that appear to have had no problem last week) …
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…
extract BLOBS
there is a smart large object function 'lotofile' which does this. lotofile ( blob-column,pathname, file_destination) pathname = directory path and name of the file. file destination = 'client' to identify the client computer as the location of the file. file destination = 'serv…
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…
Smart Blobs Errors - locking issue
We're using 9.14UC7 and we're consistently getting 9810 (Smart blob error) and 113 (file is locked) errors when we have multiple users creating tables with smart large objects at the same time. Specifically we are running scripts that create a table with the default smart blob s…
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…
Long Type
Irineu Rocha wrote: > Does anybody know how to build a select with a clause where on a attribute > defined as long? LONG isn't an Informix data type; it is used in Oracle, where it approximates to an Informix byte/text blob. If you're processing a text blob, you can write a se…
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…
web datablade
It's been my experience that if one tries to use the syntax "database@instance:table" with smart large objects, you get the not implemented yet message. If all your images are in the same DB where you registered the web blade with then just select from "table" (leave off the "da…
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…
can't drop chunk from sbspace
hi all! i'm using solaris 2.5.1 with IUS 9.14.UC3 I don't know why I can't drop a chunk from a sbspace. with onstat -d , i choose to drop the chunk from clientsbsp3 > onstat -d INFORMIX-Universal Server Version 9.14.UC3 -- On-Line -- Up 7 days 11:19:15 -- 92872 Kbytes Dbspace…
worked example of creating smart large object with INFORMIX-CLI 2.8
Need $subj. Eugene.…
Trouble with smart large object
Hello. I have a problem with creating smart large object using CLI. When I get the size of smart large object, allocate the buffer to hold the structure and create a default smart large object specification structure using ifx_lo_def_create_spec(?), I try to initialise the smart…
9.14 SmartBlobs/No free disk space error
I have defined a temporary smart blob space of significant size, and normally my queries that create smart large objects have no problem. But periodically I start getting an error 9810 Smart Blobs Error accompanied by a "No free disk space" error. When I do an "onstat -d" I see …
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…
don't understand sbspace
hi all I'm using 9.14UC3 on solaris 2.5.1 when I monitor my sbspace by two differents ways . I got two differents results. by using onstat -d, here is my display: > onstat -d INFORMIX-Universal Server Version 9.14.UC3 -- On-Line -- Up 1 days 01:11:56 -- 91960 Kbytes Dbspac…
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…
IUS9.13: SBSPACE full
Hi, I'm storing some images on a SBSPACE. And as it became full (or almost), I don't know how can I free the pages in order to re-use the sbspace. I have droped the tables and database that uses it but it seems that it doesn't free the pages. Also, I've changed to the next logic…
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?…
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: 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: +…
help : about sbspace
I want to know how to use insert clause about sbspace. Many case, must use environment variable SBSPACE_NAME in onconfig file. Also can use 'create clause', some columns have CLOB type to be indicated to use what sbspace like follows. create table abc (col1 int primary key, co…
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…
help : How to insert into sbspace.
If want to use CLOB or BLOB in informix, must create and use sbspace. I didn't setting the default sbspace variable SBSPACENAME in onconfig file, and I had to set it explicitly at table create time. like, CREATE TABLE mytable ( col1 INT PRIMARY KEY, col2 CLOB …
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.…
Informix Universal Server BLOB to BYTE, vice versa ?
Currently Delphi 3 support only Simple Large-Object only. And WebBlade only support Smart Large-Object only. So, we want to implement server routine that convert BLOB to BYTE, vice versa. How can do that?…
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…
Re: DBTEMP variable and sorted rows
> There are about 150 MB of free disk space. We're only sorting about > 10,000 rows. > Could it be some file system limitation? Are the files really created in $DBTEMP or is a (root-)dbspace used instead ? (you could check the free space in sbspaces using an "onstat -d" frequent…
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…
IUS 9.0 problem with lost smartBlobspace
Hi Is there a way to drop a table, wich has an lld_lob row that points to an lost sbspace. (diskcrash) When I try to drop the table, always an error about an lost objectreference occurs. Greetings -- Philipp Gruenig Tecno Software Molerweg 42 2540 Grenchen Switzerland…
Re: Error -130
Klaus Voss wrote: > > David Williams wrote: > > > In article <33AE579D.D38FEC73@pixelpark.com>, Klaus Voss > > <voss@pixelpark.com> writes > > >The creation of a database in a Sbspace fails with ISAM ERROR > > -130: no > > >such dbspace, > > >although the Sbspace exists accordin…
Re: Error -130
<HTML> David Williams wrote: <BLOCKQUOTE TYPE=CITE>In article <33AE579D.D38FEC73@pixelpark.com>, Klaus Voss <BR><voss@pixelpark.com> writes <BR>>The creation of a database in a Sbspace fails with ISAM ERROR -130: no <BR>>such dbspace, <BR>>although the Sbspace e…
Re: Error -130
In article <33AE579D.D38FEC73@pixelpark.com>, Klaus Voss <voss@pixelpark.com> writes >The creation of a database in a Sbspace fails with ISAM ERROR -130: no >such dbspace, >although the Sbspace exists according to onstat -d . The >oncheck-utility doesn't report any >error too.…
Error -130
The creation of a database in a Sbspace fails with ISAM ERROR -130: no such dbspace, although the Sbspace exists according to onstat -d . The oncheck-utility doesn't report any error too. (Informix version is IUS 9.10.UC1 for Solaris) Thanks. Klaus…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: 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?…
HDR and Blobs
HDR is a replication based on the transaction records in the logical logs. The transaction records are copied to the secondary server, which makes "roll forward" operations. When blobs (of data type BYTE or TEXT) are stored in blobspaces, the blobs are not in the transaction rec…