Oninit® Archive
Results for “SBSPACETEMP”
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…
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…
oncheck warning,What impact will it have on the future?
Ok, I make sense. Althrough I can't see that parameter in ONCONFIG, but it really exists with default value. ------------------------------ chuan lu ------------------------------…
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…
Large memory segment vs smaller ones
No ONCONFIG changes are required. ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
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 ------------------------------…
restore through STDIO
HI, ifxclone can change the onconfig on the target instance E.g. it will turn off DIRECT_IO and can also change bufferpool entries! Regards, David. ------------------------------ David Williams ------------------------------…
Problems with temporary dbspaces
Hello, Change the DBSPACETEMP entry in onconfig file , separated them with semi colon (;), instead of comma (,). Rebounce ids, and see whether the error disappear. Hope it works -Fauziah-…
ontape does not finish the backup: tape full
TAPESIZE in the onconfig set to zero? Backups to disk running into a tape full and asking for a second tape should not happen. Hal Maner M Systems International, Inc.…
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…
Index page size recommendations
Art, Not sure whether you saw my previous post. The online docs say: You can specify a page size for a standard or temporary dbspace if you want a longer key length than is available for the default page size. You had said that all temporary dbspaces were created using the ser…
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…
Phys Log Size Inconsistency?
Disregard. I confused the ONCONFIG parm with the actual phys log. Forgot to actually run onparams! My total bad. DG…
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…
RSS: Different # CPUs?
Those were my thought exactly. But, was uncertain whether RSS required identical settings in ONCONFIG as the primary. Thank you. DG…
Identifying types of temporary tables
Hi gurus, I want to catch de application that is consuming a lot of space of temporary dbspaces. I know there is no direct way to associate sessionid with use of temporary space. Moreover, there are temporary tables that are created internally by the engine. Do you know when is…
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…
onmode bug discovered (-wf)
Don't believe in a bug here. When starting the server he knows about the onconfig-file from the environment variable ONCONFIG. If you change this variable when the server is running it will not know the new value. Assuming that variable is only read once during the startup of th…
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.…
Who is filling my Temp space ?
It can be difficult to answer this question depending on how the temp space is being used. You can only easily identify sessions that have explicitly created temporary tables, i.e. using CREATE TEMP TABLE or INTO TEMP clause. If your temp space is being used for sorting the resul…
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…
ROOTDBS file
I did not find the AUTOLOCATE parameter in onconfig file as well as onconfig.std file also. Im using IDS 12.10 FC8 version…
Update Statistics
what kind of things could I check in the onconfig file. They are working on getting me IBM technical support help, but that will be a few hours away.…
-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…
Creating a dbspace with a non-default page size
Hi, My environment : IDS 12.10 FC6 with HP-UX 11.31 I'm creating a new instance for a datawarehouse and I want to use the option -k pagesize of the command "onspaces". I want to use the non-default size only for data dbspaces, not for root, logical, physical or temporary dbspac…
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 …
IDS 12.10 - Query Slow
Hi, I means value on onconfig 12.10 same or better than value onconfig IDS 11.10. i don't copy onconfig file and put on IDS 12.10. I already rebuild of your statistics is highly. We don't have performance issue for overall our system, only a few program, especially program runn…
sbspace size insufficient after dbexport/dbimport
The page size of the sbspace in both instances is identical. DG…
Script to see who's (session) using temp space
Hi, I've been working on a script to allow a DBA to see which session(s) are consuming temp space. Basically a workaround for the problem covered in http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=77869 The script is accessible in https://github.com/domuso…
srt* files PSORT_DBTEMP DBSPACETEMP strange
This is a very opaque area of the engine. I wrote a blog post about user-generated temporary tables which touches on this topic a while ago: https://informixdba.wordpress.com/2015/03/29/temporary-dbspaces/ What specifically is causing the srt files to be created. I see you can …
ON-Bar database server is dismissing the logical
Thanks Art and Martin. IDS bounce worked as onconfig was changed for LTAPEDEV earlier. Thanks, ~ Pravin Bankar…
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…
DBSPACETEMP Parameter
Hi, The DBSPACETEMP Parameter in onconfig file create automatically the temporally dbspaces ? Or They must be created with onspaces utility. Thanks in advance.…
Re: Re-Register BTS.3.10 fails
Run oncheck -cs and oncheck -cS. Looks like you had a similar problem in 2014 - http://www.iiug.org/forums/ids/index.cgi/read/34165 What was the solution then? Otherwise open a case with IBM. Regards, David. > On 19 April 2016 at 18:41 MICHAEL HOFFMAN <offdisc@gmail.com> wro…
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…
Insufficient space in temporary dbspaces
Hi, >>>> My IDS log is reporting "Insufficient space in temporary dbspaces" and I think I have enough space. IDS: IBM Informix Dynamic Server Version 12.10.FC5WE Platform: CentOS release 6.6 Spaces: | [informix@lpsalxids ~]$ onstat -d | | IBM Informix Dynamic Server Version 12.…
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…
View with left join.
Hi Marco/Fouad, I would be interested to see the DBSPACETEMP set up. I know the engine has logic that means it will look at all the spaces listed in DBSPACETEMP and if none of them has enough free space to create the temporary table, it will use ROOTDBS instead, regardless of h…
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. …
BTS 'corruption' after ontape restore
[This is a re-post from last week. More testing was done, but still no results. Last attempt before turning over to IBM Support] Hi All, We just installed BTS on a Production server. We backed up the instance using ontape, and restored on a different machine. When we tried to u…
BTS fails after ontape Restore
Hi Mark, Backup is done by 'ontape -s -L 0' Restore was done with 'ontape -r' No extra special parameters. And as I was typing this email, I was collecting the appropriate BTS-related lines from the 4 onconfig's in play (we use a special 'backup' onconfig for ontape). Lo and b…
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…
Root db space fills up
All the temp db spaces are logged. I also examined the queries and there are no temporary tables specifically created in the queries.…
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 …
Error Message in online.log file
Hi André. What setting do you have for ALRM_ALL_EVENTS in the $ONCONFIG file? I have found "alarmprogram.sh" can loop if set to 1. Regards, Doug Lawry…
RSS not working
Fee disk space on the chunk partition ok on the RSS server? Can you post your onconfig?…
Setup HDR
Sounds like the onconfig has the same STACKSIZE but what both servers read in at initialization is different. Bounce both servers and see if it's fixed.…
Physical Log size 2000 is too small
Hi, the onconfig we are using is from a inf version 9.7 wherein no PLOG_OVERFLOW_PATH located in it. I tried adding it to the onconfig and put a location but the inf instance when restarted still always fails. As for the onmode command we are always using onmode -ky maybe it's b…
VERY slow BTS index build
Thanks David! I missed that line! In the onconfig file it describes SBSPACETEMP as: # SBSPACETEMP - The list of sbspaces used to store temporary # tables for smart large objects. If no sbspace # is specified, temporary files are created in # a standard sbspace. And we wonder why…
ERROR doing ontape
Thanks for your response! So, is it possible to create a new dbspace then set it in $ONCONFIG and restart the instance? best regards…
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…
virtual segment question
Did you try to increase the number of locks in the LOCKS parameter in Onconfig? Lloyd…
ontape error message
Increase the value of TAPESIZE parameter in onconfig and try the backup. Lloyd…
Onconfig name
Hi, I am developing a JDBC application, and need to read from within SQL the onconfig environment variable. From with IDS 11.70, I can extract the need information using the query: select trim(env_value) env_value from informix.sysenv where env_name = 'ONCONFIG'; The code nee…
DBSPACETEMP, sorting, temporary tables...
Hello gurus, Temp dbspaces are for sorting and for temporary tables. These dbspaces are actually disk spaces. We don't have a way to sort or to create temporary tables in memory, do we? Memories are getting less and less expensive, wouldn't it be much faster to use memory instead…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Problmes using ontape with an IBM TS2900 changer
The TAPEDEV section in the onconfig is as follow: TAPEDEV /dev/IBMTape0 TAPEBLK 512 TAPESIZE 0 We have played with the TAPEBLK from 512 to 4096 to no avail.…
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…
ER & CPU Sizing Question
HDR, RSS all considered, but the client's model is that this DR server will only be used as a "temporary stop gap" until an emergency replacement server is delivered and restored via backup tapes that are stored off-site daily. Since this DR server will only serve as a temporary …
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.…
How to set up temporary space per session
Hi, I have an application that creates large temporary tables, causing temporary dbspaces are full. This hurts the entire instance. At the moment it is not possible to change the application. One solution would be to increase the size and / or amount of the temporary dbspaces, b…
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…
recover SQLHOSTS file
Do the onconfig files also have that info?…
Auto Update Stats
Hi, I have one more query. I have the below entries in onconfig file for AUS AUTO_STAT_MODE 1 STATCHANGE 10 USTLOW_SAMPLE 0 Now all my tasks(mon_table_profile,Evaluator and Refresh) running fine at scheduled time. Now when I remove the above entries in onconfig file, still al…
Emergency, Error 271
IDS 11.50 FC 9 (ultimate) I have a program that runs in parallel, multiple instances at the same time (20 instances), this program is launching the same queries on the same table, and after a few instances the error code 271 is displayed. I checked the space and dbspace is not s…
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)…
Page size
Where do you set the page size when configuring Informix? I don't see it in the ONCONFIG anywhere.…
Re: manually edit onconfig?
You should never install the new version over the current one. If something goes wrong in the upgrade you'll have much more work to recover. Regards On Mon, Dec 17, 2012 at 6:38 PM, June Nebab LKINY <jnebab@gmail.com> wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. I…
RE: manually edit onconfig?
I would give a try to the new onconfig_diff utility, it seems to help you identify and correct some of them.... Check it out! https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/how_to_use_the_onconfig_comparison_tool_onconfig_diff3?lang=en Regards. Alexand…
Re: manually edit onconfig?
I'm a big fan of copying the current settings into the new ONCONFIG file. It gives you a good chance to see the new parameters, like those you mentioned - all of which were available in 11.70.xC5 BTW, so someone used an older ONCONFIG instead of editing the new one last time. By…
Re: manually edit onconfig?
Figure out what each of the new ones do, whether you want to use them or not, then add them to your old onconfig. Ideally on a test environment. j. On Dec 17, 2012, at 1:38 PM, June Nebab LKINY wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version o…
manually edit onconfig?
Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version on same $INFORMIXDIR and on same server. I noticed new onconfig params (ie: AUTO_READAHEAD, NUMFDSERVERS, etc) that are in the UC6GE onconfig.std that are not in my $ONCONFIG. What is the proper way to dea…
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,…
Error # 40002
Also set AUTO_REPREPARE 1 in your $ONCONFIG file. Regards, Doug Lawry…
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.…
Re: help with informix on windows oncheck -pr erro
ok sounds like silly question but how do i find out what ONCONFIG variable is on windows ? which is likely to be correct set ONCONFIG=oncfg_apecert.0 ::set ONCONFIG=ONCONFIG.apecert…
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 …
Re: Strange behaviour when using a view in 11.....
Art, Thanks for the reply. Yes, I have temp spaces configured. I did not have a normal dbspace in my DBSPACETEMP list, only had temporary dbspaces. I added one, restarted informix, and rootdbs still filled. The client had nothing set for DBSPACETEMP. I even tried added the same…
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…
doubt about parameters (PDQ)
Sorry people, I meant the MAX_PDQPRIORITY 100 onconfig parameter.…
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 …
NOFUZZYCKPT: onconfig parameter or environment variable?
Is NOFUZZYCKPT an onconfig parameter or an environment variable? Is there any definitive documentation? Still running IDS 10 on Linux.…
Testing the 'free' versions - moving from Dev edition to Innovator-C
Art, thanks - I've gone for the separate INFORMIXDIR install (just had to change $INFORMIXDIR, $PATH and some paths in $ONCONFIG) and it's come up just fine.…
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 …
tempdbs used by a ghost
Hi folks! I Couldn't identify a session who is using the temporary DBSpace of my company's system. The SNMP Monitoring Tool is pointing that the free space of 2 of 3 spaces has been used, and I can't find who is using. PS: I can't bounce the engine this week to solve this probl…
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…
ontape -p/r with changed ROOTPATH
Jack Parker Wrote: ================================================================================ Not sure if you noted that you also need to change your $ONCONFIG = ROOTPATH to point to what is on the backup image. j. ==========================================================…
question about Query with joined view
Have you tried "IFX_FOLDVIEW 1" in your environment or $ONCONFIG file? Regards, Doug Lawry…
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…
create bts index long transaction
Another thing to check is the if SBSPACETEMP configuration on the server. If neither the SBSPACETEMP onconfig variable is set nor a corresponding temporary sbspace created, BTS may use large amount of log space while creating the index. In this scenario, the index is built in th…
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…
sqlerr:-243 and isam err:-111 in esql/c
This "may" be a good place for USELASTCOMMITTED set to all in the onconfig.…
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…
Primary Slowness when RSS is active
You need to set LOG_STAGGING_DIR parameter in onconfig of the rss…
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.…
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…
Slow indexing with BTS
Hi Rolf, BTS does not have the fastest index build and I do keep working on that, but I have not seen performance like this. A couple of things to check, a) Do you have SBSPACETEMP set to a temporary sbspace (ie an sbspace created with the -t option). This space should be twice…
Re: RE: new onconfig parameters added onconfig fil
Typically, I make a copy of the onconfig.std, naming it something like cheetah_online. Then I open up both the old and new onconfig, side by side, and copy from old to new. Obviously, the new onconfig has new params that were not addressed in the old onconfig and may have elimina…
Re: RE: new onconfig parameters added onconfig fil
Isn't that what I said? "If you simply just bring up the instance using your old onconfig, I believe that you will get whatever the default is for the new parameters, even though you do not mention them in your old ONCONFIG." -----Original Message----- From: ids-bounces@iiug.or…
new onconfig parameters added onconfig file 11.5
hello folks Can any one tell me at what stage the new onconfig parameters are added to the onconfig file when upgrading from 11.10 to 11.5. I have converted two instances from 11.10 to 11.50 One onconfig file has the new parameters at the end of the file the other doesnt have any…
Re: performance improvements for dbimport?
Thanks for all your valuable input. I changed some parameters now: 21:09:27 Onconfig parameter BUFFERPOOL modified from size=2K,buffers=262144,lrus=8,lru_min_dirty=5.0,lru_max_dirty=10.0 to size=2K,buffers=524288,lrus=8,lru_min_dirty=10.0,lru_max_dirty=50.0. 21:09:27 Onconfig p…
BACKUP_FILTER in onconfig
Hello, when I using BACKUP_FILTER in $ONCONFIG, parameter for "The tape block size, in KB, for backing up logical logs" is NOT LTAPEBLK, but it is TAPEBLK. Everything work fine (LTAPEBKL for logical log) when I turn off BACKUP_FILTER ... This is happening with ontape, with BAC…
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…
garbage text in SHMNOACCESS parameter
On Jan 21, 8:15 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Just a guess. What's the hex value for that string? > grep ^SHMNOACCESS onconfig SHMNOACCESS �����������" ������� grep ^SHMNOACCESS onconfig |cut -c17- �����������" ������� grep ^SHMNOACCESS onconfig…
Data Dbs suddenly went Full
Hi, We've faced an issue where the dbspace kept on reducing and suddenly it reaches dead level. Then we've added space, but after adding space into it, the old space is being shown as well, as it never being used. After monitoring log file, we've found "temporary DBspace tempdbs_…
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".…
DYNAMIC_LOGS in ONCONFIG
Good afternoon, We occasionally have a programmer than needs a large amount of log space to move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS 10.00 on HPUX? Where would the dynamic …
Unsufficient buffer size for error message
Hi Please check your online.log and check also your onconfig file. thanks.…
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…
Could not write to a temporary file
Joshua wrote: > [Informix][Dynamic Server 2000][trgokom] SQL Error(-264): Could not > write to a temporary file. [ISAM error -131 : ISAM error: no free disk > space] > > This error appears when I select from view which has 25 000 000 rows. > What can I do to resolve this problem?…
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 …
Finding the session which uses a particular temporary table
I need to know what session or sql is consuming high temporary space due to other session are affected (-264 Could not write to a temporary file.) I have two temporary dbspaces (tmp1 and tmp2, 1 GB c/u). I get from sysmaster: tabname type nptotal dbspace…
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…
Engine won't use temporary space - rootdbs full
Hey all, I have an 11.50.UC3 engine running on RedHat EL4 It has three temp dbspaces set up and the DBSPACETEMP variable is set to use them. Any sort query only uses space in the rootdbs - completely filling it up. I have tried setting client side environment variables for DBSPAC…
oninit fails reporting problem with DBSPACETEMP
But in my ONCONFIG file, i have mentioned the tape device as STDIO…
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…
Changing TAPEDEV from script
sed -e 's/^TAPEDEV/TAPEDEV NEW-TAPEDEV/g' onconfig > onconfig.other export ONCONFIG=onconfig.other after finishing just set the ONCONFIG to your default and delete onconfig.other Sebastian…
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 …
One temp space fills and 4gl fails
Got a 4gl program that fills up one temp dbspace inserting into a temp table then fails. I have 3 temp dbspaces, but it's not overflowing into the other two, it just fills up the tempdb3 and fails. I thought there would be an automatic overflow into the other two temp spaces, co…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >> mosserp@wellsfargo.com wrote: >> >>>>> RESIDENT 0 # Forced residency flag >>>>> >>>>> >>>> (Yes = 1, No = >>>> >>>> >>>>> >>>>> >>>>> >>>> Don't know HP model numbers, but it this is a PA-RISC machine, you >>>> almost have to …
RE: onconfig recommendations
> mosserp@wellsfargo.com wrote: > >>> RESIDENT 0 # Forced residency flag > >>> > >> (Yes = 1, No = > >> > >>> > >>> > >> Don't know HP model numbers, but it this is a PA-RISC machine, you > >> almost have to set RESIDENT to -1 to prevent poor performance > >>…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >>> RESIDENT 0 # Forced residency flag >>> >> (Yes = 1, No = >> >>> >>> >> Don't know HP model numbers, but it this is a PA-RISC machine, you >> almost have to set RESIDENT to -1 to prevent poor performance >> due to the >> archi…
RE: onconfig recommendations
> > RESIDENT 0 # Forced residency flag > (Yes = 1, No = > > > Don't know HP model numbers, but it this is a PA-RISC machine, you > almost have to set RESIDENT to -1 to prevent poor performance > due to the > architectures restrictions of only four active shar…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
[Fwd: Re: onconfig recommendations]
Kennedy, Randy wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for given > platform. > > Current Server: HP rp5405 …
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
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…
onconfig recommendations
Would like to receive some feedback on our onconfig setup for current platform. This is the 3rd physical server that the database has moved to and just want to ensure we are using the best settings for given platform. Current Server: HP rp5405 4-Way (650 MHz) with 8GB RAM. 1 …
Newbie question-please don't shoot me
I have a newbie question. Please pardon my lack of knowledge with this. I have a Unix server (HP) that houses 2 9.4 Informix database servers (IE: there are 2 separate onconfig files that have unique INFORMIXSERVER parm values). The informix engine stopped (I think because the un…
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…
Informix onconfig file configuration
Hello, We recently moved from a quad proc (hyper threaded to 8), 8GB RAM to a 2 socket dual core, 16GB RAM server. In order to maximize the cores and RAM what entries need to be modified, if any? Thanks, Jared…
-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…
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 ------------------------------------------…
BAR_MAX_BACKUP and BAR_WORKER_MAX
What's the difference between BAR_MAX_BACKUP and BAR_WORKER_MAX. Both seem to be doing parallel/concurrent log backup. Which one should be specified in onconfig ?…
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: Digital UNIX V4.0F + 7.31.FD1 Performance
Thank you, today on evening we make this changes in $ONCONFIG, restart the machine and hope it works! Greetings from Austria…
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…
onconfig problem
when i try to initialize server using oninit following message appears on screen "ONCONFIG can only specify a simple filename whith no path components" plz do replay me how to solve this one…
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…
tempspace estimation for a query
For a report, I have a query that needs a lot of temporary space, due to sortings and joins. Issuing 'onstat -d' every 30 seconds allows me to watch the tempspace as it is continously decreasing, until no more is available. At that point I get some error message, and the tempspac…
syssqexplain table and error 264...
Hello IDS gurus, Everytime I try to run queries against syssqexplain table, I've got error 264 -- I know I have lots of temp dbspaces. I tried setting PSORT_DBTEMP to a big directory, it also failed me. Does anyone have any experience with this? Example: select avg(sqx_estcost),…
RE: Listing all the tables in using a dbspace in Informix
> Make sure $INFORMIXDIR and $ONCONFIG are set and that you have > permissions with your login ID to access them. There is also system > tables that can give you this information. System tables which can list out all the tables in a particular dbspace ?…
Re: onconfig
Hello, apart from editing ONCONFIG directly, some parameters are dynamically changeable: Usage: onparams ... -m <param> <value> ... -m - Modify the value of one of the following configuration parameters: AFFAIL, AFCRASH, AFW…
RE: onconfig
I don't run onbar, but I suspect you're right. LTAPEDEV, etc. would also probably be in this group as well. Either way, restore the old onconfig and you're OK. It may be a good idea to check the permissions on the file before you're done, though... --EEM -----Original Me…
Re: onconfig
I think the onbar config parameters can be changed on the fly as well. ----- Original Message ----- From: "Everett Mills" <eemills@nationalbeef.com> To: <informix-list@iiug.org> Sent: Friday, February 09, 2007 11:45 AM Subject: RE: onconfig > Stan- > TAPEDEV, TAPEBLK and TAPESI…
RE: onconfig
Stan- TAPEDEV, TAPEBLK and TAPESIZE can be modified on the fly through onconfig. Restore your old onconfig and you should be fine. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Stan Sent: Friday, …
onconfig
Hello. What will happen when during work (online state) IDS unfortunately someone modify onconfig. Which paramaters takes effect immediately (without restrart IDS). Thanks in advance Stan…
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…
Informix produces error -1263 after system time is changed
Also I forgot to mention that the onconfig USEOSTIME is set to 1 (gets time from the host)…
Re: Solaris: temporary tables in /tmp VS in a temporary dbspace
Yes, don't use /tmp Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix. Attend IDUG 2007 San Jose, North America May 6-10, 2007 Visit http://www.iiug.org/conf for more information. > -----Original Messa…
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? …
Re: infdump
couldn't we at least ask him for a tiny snippet of his online.log - maybe there's more wisdom in such file than you might imagine. Tip: set MSGPATH (in onconfig) to ... ... and don't forget to restart the engine ;-)…
HELP : All logical logs are FULL
Hi All Thanks for your response. I solved the "All logical logs are FULL" . I did the following : ShutdownServer : onmode -ky Change Onconfig : LTAPEDEV in the onconfig to /DEV/NULL Restart Server : oninit After RECOVERY : onmode -ky Change Onconfig : LTAPEDEV change…
Re: Performance tuning suggestions needed
On 1 Oct 2006 20:10:51 -0700, calyanram@hotmail.com wrote: >this my onconfig file. > ...onconfig file snipped... Please give us a bit more information. Hardware specs (number of CPUs, memory, OS. etc.) would be good . . . JWC…
SHMADD and EXTSHMADD
Hi, What is the difference between SHMADD and EXTSHMADD? We know the meaning of the SHMADD onconfig parameter. Thanks, Khaled Bentebal ConsultiX Email: khaled.bentebal@consult-ix.fr…
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…
DBSPACETEMP
Hello All, Just a quick question for you to ponder. Is it possible to include random dbscpaces in the DBSPACETEMP parameter with the onconfig file to prevent space problems in the temp dbspace when creating indexes etc. on very large tables?…
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…
264: Could not write to a temporary file.
Run ondtat -d and monitor the free space of tempspace if br runninbg out of space Thank You Jeffrey J Wain ----- Original Message ---- From: Quman <yquman@gmail.com> To: ids@iiug.org Sent: Friday, August 4, 2006 3:34:27 PM Subject: 264: Could not write to a temporary file. [722…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: ONCONFIG and AIX
Hi, I would enable KAIO, too. Apart from KAIO the B-Tree Scanner usually benefits from some configuration: >From my experience increasing threshold (default: 500) reduces I/O significantly, enabling range scans (rangesize=500), too. BTSCANNER num=1,prio=low,threshold=50…
RE: ONCONFIG and AIX
> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of tomcaml@yahoo.com > Sent: Thursday, July 27, 2006 12:57 PM > To: informix-list@iiug.org > Subject: ONCONFIG and AIX > > Hello All, > > I am looking for feed…
ONCONFIG and AIX
Hello All, I am looking for feedback, comments, etc. We are currently on IDS 10.FC4 on HP-UX 11 - migrating to IDS 10.FC5 on AIX on an LPAR partition on the i595 I have gotten this message in the log while performing some loads/alter tables/indexes, etc in development phase.…
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…
Parametro TXTIMEOUT
Hola, quisiera saber si alguno de ustedes me puede informar que quiere decir el parametro del onconfig TXTIMEOUT 0x12c, a cuantos segundos se refiere. Gracias de antemano. Salu2...…
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…
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!…
Re: Validating the 'SBSPACENAME' sblobspace
"Is a command-line call significantly different from file system access?" Well for SQL yes. In sysmaster.sysconfig there is a cf_effective column. This is the value in use by the database server NOW, this does not have to match the ONCONFIG value. You can change the onconfig …
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…
Informix database filling up rapidly
Hi Gurus, I am facing a strange problem with informix database growth patterns. We are using Version 9.21.UC7XO for our application database. Normally application tables grow at rate of 1% per day. But recently we hit with 80% growth in database within a week time. Comparing th…
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.…
v 9 stopping
search for a dir called informix (assume you installed it there) in there you should have a subdir called etc in there you should find a file called onconfig.<informixserver> search for MSGPATH which has the name of your logfile Superboer.…
Redirected restore failure
>From the backup and restore manual renaming chunks duing a restore..key considerations... "During a cold restore, ontape performs the following validations to rename chunks: 3. If renaming the primary root or mirror root chunk, it updates the ONCONFIG file parameters ROOTPATH…
hyperthreading and onconfig parameters
We are upgrading our database servers to HP ProLiant DL380 G4 two-way systems. This platform supports enabling or disabling "hyperthreading". (See, for example, http://sysadminforum.com/t36970.html.) With hyperthreading enabled, the OS (Solaris 9, x86) sees 2 logical processors …
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: recording ONCONFIG changes
Tripwire or AIDE would do the trick too. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Jonathan Leffler Sent: Thursday, July 07, 2005 2:16 AM To: informix-list@iiug.org Subject: Re: recording ONCONFIG changes mw…
Re: recording ONCONFIG changes
mweallans@panacea.co.uk wrote: > Scanning the old messages I came across a "suspicion" from Neil Truby > that IDS 9.2 was't recording all changes to ONCONFIG in the message > log. > I've recently spent many days trying to find why a problem had recurred > and eventually I discove…
recording ONCONFIG changes
Scanning the old messages I came across a "suspicion" from Neil Truby that IDS 9.2 was't recording all changes to ONCONFIG in the message log. I've recently spent many days trying to find why a problem had recurred and eventually I discovered that it was because a previous change…
Re: ONCONFIG - comments
Juan Pablo wrote: My comments below: > Hi: > Let me begin by saying thanks to all of the frequent posters to this group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiem…
Re: ONCONFIG - comments
"Juan Pablo" <in4mixperu@hotmail.com> wrote in message news:1120173312.07d6de6c2486de67e3cad47cd40e6341@teranews... > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ====================…
Re: ONCONFIG - comments
Juan Pablo said: > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiempo y su ayuda. Est…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pode…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para…
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…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pod…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG par…
RE: New installation
Yes I agree with Brian, you put something in the onconfig that required 161MB but you have defined the root dbs size 60MB that is not enought to cover all the requests. Check the PHYSFILE, LOGFILES LOGSIZE in the ONCONFIG file. If you need more help give us the full ONCONFIG. b…
Help with ONCONFIG needed
Having a problem with a client connection to an informix database. The server has two databases, db1 and db2. Each database has a separate ONCONFIG file which lists the different db names in them. ONCONFIG_db1 includes db1,but not db2 in the DBSERVERNAME/DBSERVERALIAS …
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…
The onconfig FILLFACTOR
My day for asking questions ... but that is how one gains knowledge :) The lead DBA for the company for which I am now working for as a consultant wants to establish an initial FILLFACTOR of 100 for those indices that represent a serial column. Since none of the tables having a…
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: 7 vs 9
> > sql error -242 (isam -106). > there's not enough disk space to build the index. How do You decide? My manuals tells about "non-exclusive access". How this can be in one session on temporary table? -- ���������� �������� ���� ������������ http://webmail.delfi.lv sending to in…
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: parametros ONCONFIG
Los parametros del ONCONFIG que tienes que setear para inicializar tu instancia como MINIMO son: ROOTPATH Path completo del chunk creado para almacenar el root Dbspace ROOTSIZE Tama�o del chunk en Kbytes (Ejemplo: 2048000 # 2Gb) DBSERVERNAME Nombre l�gico del server.(Eje…
parametros ONCONFIG
Me podrian ayudar con los parametros del ONCONFIG. No las tengo muy clara cada parametro, por lo que la misma me trae problemas para el momento que quiero OPTIMIZAR el servidor de bases de datos. Si alguien me puede ayudar a conocer mejor cada uno de estos parametros .... les agr…
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: DBSPACETEMP Variable [3248]
David Linthwaite wrote: > > Keith > > The following is an extract from the administrators reference manual: > > ".....The list of dbspaces can contain standard dbspaces, temporary > dbspaces, or > both. Use a colon or comma to separate the dbspaces in your list. If > both > stan…
RE: DBSPACETEMP Variable [3248]
Neil Truby wrote: > "David Linthwaite" <dlinthwaite@lintel.co.uk> wrote in message > news:cd6ab3$4r8$1@news.xmission.com... >> >> 3. if my memory serves me right, temporary dbspaces must be raw - >> are you using the character special devices. > > I don't think this is true (in …
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…
onconfig for analisis
Hi, I post the onconfig file for its analisis: Operating System: SuSE 9.0 RAM: 1024 Mb Informix version: 9.40 UC2 All chunks are raw devices. Thanks. #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig…
ONCONFIG for 9.40 offered for comment
9.40 FC3W2 on HP-UX 11.11 The server has 6 cpus and 6G of RAM. 3 other, small, IDS 9.40 instances run on the server, and one small 7.31. kaio is enabled. Just put 9.40 live, and it's running about 5-10% more slowly on some key processes. This reflects what happened in testing. …
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ > 2Gb ram and 4 processors that seems very slow on a large sequential > write (I suppose that the problem resides in the dbspaces on > filesystem...). Any suggestion? The following is my standard…
Re: OnConfig parameters tuning
"Laverio" <laverioNO@z-1000.net> wrote in message news:cac7sg$e8v$1@newsreader.mailgate.org... > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in…
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in the dbspaces on filesystem...). Any suggestion? > > My onconfig it's set as fol…
OnConfig parameters tuning
Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram and 4 processors that seems very slow on a large sequential write (I suppose that the problem resides in the dbspaces on filesystem...). Any suggestion? My onconfig it's set as follow: # System Configura…
Howto for Onconfig
Hi everyone, This is probably a question which has been asked often. But I could not find proper documentation on how to calculate and set correct parameters for Onconfig. I understand this is a complex question. But are there any articles on this ? Maybe they covered the topic …
IDS 9.30 consumes too much temp dbspace
There is a bug in 9.30.UC3 where the temporary dbspace on the secondary server in a HDR pair is not released after use. Can be worked around by bouncing the secondary. I believe this is fixed, certainly in 9.40.UC3. Crystal Reports can also be very inefficient as many if not all…
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,…
SHARED MEMORY LIMIT
Is posible to use with informix of 32 bits more than 2GB of shared memory in a Linux Machine? The base address in onconfig is: SHMBASE 0x41000000 Thanks in advance,…
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…
RE: dropping temporary db space that is on bad disk
Thank you so very much! I have done testing along the lines of your suggestion. My temp spaces are symb links to raw devices. I have created identical tempdbs6 and tempdbs7 and then removed the link for tempdbs6 and relinked it to the same raw device as tempdbs7 and then succes…
dropping temporary db space that is on bad disk
Hello, I am having problems dropping the temporary db space. Any help would be appreciated. platform: SunOS, sun4u sparc SUNW,Ultra-4 informix: Informix Dynamic Server 2000 Version 9.21.UC1 Three days ago I had realized that the disk on which is my tempdbsp1 is bad and sorting…
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…
Re: Very slow archives - the Very Old Page bug perhaps?
> Queries involving temporary tables (specially in your version) and other queries that force the engine to create temporary space (that use IN for example). So basically queries that update something - even if that something is only a temporary resource ... ? > Ouch... 7.31.UC…
Changing database local / dbexport tapesize
Hi, Did you change TAPESIZE on your onconfig file? That could be the restriction! REGARDS…
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.…
Re: onconfig and sqlhosts
Hi Thomas. Administrator's Guide for Informix Dynamic Server, Version 7.3 http://www-3.ibm.com/software/data/informix/pubs/library/ids_73.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Thomas Ronayne <trona@ameritech.net> >Reply-To: Thomas Ronayne <trona…
onconfig and sqlhosts
I've managed to blow away my installed Informix system and cannot for the life of me find the notes I had about onconfig and sqlhosts. It's version 7.30.UC5 running on Slackware 9.0 -- can someone point me at the right document in Answers for the appropriate settings? Thanks.…
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: Onconfig file parameters
Sometimes even the ontape parameters (TAPEDEV, LTAPEDEV, TAPESIZE, etc.) are not dynamic. What you can do is change a parameter in the onconfig file and then dump out the reserve page that holds the onconfig parameters with: oncheck -pP 1 1 Hope this suggestion helps. Brice Av…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
RE: HPL Unloading error [1467]
Here's my onconfig file SHMVIRTSIZE 147456 SHMADD 8192 SHMTOTAL 0…
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…
onconfig file
The system administrator at my current site thought he would be very clever and he linked the onconfig files to different directories using ln -s. We have now discovered that these links are being lost when we use onmonitor and replaced by a local file, but not when we use vi. I…
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…
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…
RE: temporary space - doesn't scale?
I would never be so rude to trolls as to include you in their number. Besides, unless you have an office deep under the ground, we've seen your posts come winging out during the daylight hours when all good little trolls are supposed to be in bed. > -----Original Message----- > …
RE: temporary space - doesn't scale?
Troll. Actually, I'm a registered Republican. cheers j. > -----Original Message----- > From: obnoxio@hotmail.com [mailto:obnoxio@hotmail.com] > Sent: Saturday, December 16, 2000 6:30 PM > To: informix-list@iiug.org > Subject: Re: temporary space - doesn't scale? > > > In the y…
RE: temporary space - doesn't scale?
> The last time somebody listened to a Bush, folks wandered in the desert for > 40 years. Ah, but the reality is that they *didn't* listen to the Bush, and that's *why* they wandered in the desert for 40 years!!! :-) Paul Mosser -----Original Message----- From: Parker, Jack […
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…
RE: temporary space - doesn't scale?
> -----Original Message----- > From: Andrew Hamm [mailto:ahamm@sanderson.net.au] > Sent: Wednesday, December 13, 2000 6:52 PM > To: informix-list@iiug.org > Subject: Re: temporary space - doesn't scale? > > > georhill@my-deja.com wrote in message <918aml$ruc$1@nnrp1.deja.com>... …
Re: temporary space - doesn't scale?
In the year of Our Lord Wed, 13 Dec 2000 16:59:02 -0500, Matthew Cornell <cornell@cs.umass.edu> broke a vow of silence to utter: >Obnoxio The Clown wrote: >> That's right, blame the server. >> >> You haven't really given us enough info to make any kind of assessment here, but >>…
Re: temporary space - doesn't scale?
In article <3A37BFC4.CDCF8D26@cs.umass.edu>, Matthew Cornell <cornell@cs.umass.edu> wrote: > > What is the value of DBSPACETEMP? > Sorry. Here it is: > > DBSPACETEMP tempdbs # Default temp dbspaces > > tempdbs was created using: > > onspaces -c -d tempdbs -t -p ~i…
RE: temporary space - doesn't scale?
If you do not have tempdbs defined, all sort/order by etc goes in you /tmp. take a look if your /tmp is not running out of space. -----Original Message----- From: Matthew Cornell [mailto:cornell@cs.umass.edu] Sent: Wednesday, December 13, 2000 9:29 AM To: informix-list@iiug.org …
Re: temporary space - doesn't scale?
> What is the value of DBSPACETEMP? Sorry. Here it is: DBSPACETEMP tempdbs # Default temp dbspaces tempdbs was created using: onspaces -c -d tempdbs -t -p ~informix/links/chunk2 -o 0 -s 2000000 matt…
RE: temporary space - doesn't scale?
Sounds like rootdbs is too small and you have not put in the 'create temp table .... with no log;' statement in the code. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: Matthew Cornell [mailto:cornell@cs.umass.edu] Sent: Wednesday, …
temporary space - doesn't scale?
Hi Folks, We're running IDS.2000 (9.21.UC3-2) on RedHat Linux 6.2, and our program is running out of temp space (-229: Could not open or create a temporary file.) What bothers me is I've allocated a 2GB dbspace for temporary usage, but I'm running the program on our "tiny" datab…
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…
IDS 7.31.Txx Windows NT Alaramprogram
i have change the path in the onconfig-file and restart the server but the alarmprogram will not be start if a event (logs) a generated! thomas…
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…
Force dropping a dbspace
I have a temporary dbspace I'm trying to blow away, and I can't seem to do it with 'onspaces -d tempdbs' because it claims the space is not empty. I checked the contents of the dbspace with 'oncheck -pe' and all it showed to be in the dbspace was a series of tblspace tblspace's …
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
Re: ONCONFIG History
put it under source code control? SCCS and RCS are free tools and dont take too much resources. HTH Sujit testNews <mtabunda@amellar.com> on 10/04/2000 09:05:30 PM Please respond to testNews <mtabunda@amellar.com> To: informix-list@iiug.org cc: Subject: ONCONFIG History I…
RE: ONCONFIG History
Look at your online message log onstat -c |grep MSG -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Wednesday, October 04, 2000 9:06 PM To: informix-list@iiug.org Subject: ONCONFIG History Is there a way to know/track the changes made to ONCONFIG …
RE: ONCONFIG History
Changes are recorded in the message log at startup. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Thursday, October 05, 2000 12:06 AM To: informix-list@iiug.org Subject: ONCONFIG History…
ONCONFIG History
Is there a way to know/track the changes made to ONCONFIG files?…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
TBLSPACE_STATS
Hi, what is the meaning of TBLSPACE_STATS variable in onconfig file? thank in advance.…
Query Optimization: Wrong execution plan?
Xavi Tarafa Mercader wrote: > Any suggestion about how to improve the query performance? Set OPTCOMPIND parameter ( in onconfig file ) to 0. > Xavi. Leonid.…
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…
Re: Cannot write sorted rows.
I'm also getting this problem. I have increased the temporary DBSpace to 400MB. I'm running on an NT machine but we have seen this on solaris. This does not happen for all queries only on a particularly complicated one when I' trying to do an order by. There is plenty of disk spa…
WSTATS and Performance
Hi, does anybody know the performance degradation by setting WSTATS 1 in the onconfig file? Is this 1%, 5% or 10% ??? TIA Ruediger Papke…
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…
Primary chunk sanity check error
Hi, When we try to startup a restored Online 7.23 instance, we are getting the following error: "Fatal error initializing shared memory." In the log file: 'Primary chunk '/links/dbs04temp_01' sanity check failed -offline. ' We have checked that the raw device mapping etc are c…
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…
DBSPACETMP
Hi Please let me know how the temporary dbspace can be freed. I am working on IDS 2000 on NT & the command given was select first 100 * from billed_calls order by callbilldt The row count for the table mentioned above is 6.2 million . The size of tempdb space is 2GB. …
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…
Re: Memory problems? Please help.
>>What is the connection type? shm or soc ? >> >What are these? See NETTYPE in your onconfig file. HTH Michael…
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…
monitoring temp space
Bridget Reitsma wrote: > > Hi > > I was wondering about how to monitor temp space. I received an error > this morning that the database was out of temp space so I added another > chunk. However before I added the chunk I checked the temp space > through onmonitor it appeared to…
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…
URGENT: Temporary Work Space
I know this has been discussed before, but I have a client who is suffering error -264 when running quite a complex Ace report using multiple selects into temporary tables followed by a large select with many outer joins. My question is this :- How do I find out which area (UNIX/…
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…
Re: Dumb question
Sorry all, I think I found the answer to my own dumb question in the documentation (last place I would have thought to look). "The database server uses the ONCONFIG file during initialization" >Is it safe to edit my onconfig file when the database is live ? > >Or should I stop…
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…
Re: Informix - using HP AutoRAID
David, AutoRaid is not recommended for databases because you just add disks without control where to place your logs, temporary dbspaces, data/index spaces etc (all disks appear as one big disk). Yes , it's very easy to administrate this box, but performance will be a problem. …
Re: Problems with DBSPACETEMP
In article <7sfuli$1u6$1@nnrp1.deja.com>, Stephan Stresing <st@mr- informatik.de> writes >Hi, >we have IDS 7.30.UC8 running here on a Sun Solaris 2.6 box. We've >encountered a problem with DBSPACETEMP: we've set this parameter to >dbs1:dbs2 (and we tried also dbs1,dbs2) in the on…
Problems with DBSPACETEMP
Hi, we have IDS 7.30.UC8 running here on a Sun Solaris 2.6 box. We've encountered a problem with DBSPACETEMP: we've set this parameter to dbs1:dbs2 (and we tried also dbs1,dbs2) in the onconfig file. After starting a big print job IDS claims temporary space to collect the data. B…
Lock Table Overflow - onconfig
We get an error in the Informix log-file. Lock table overflow. What do we have to change in the onconfig-file ? Kind Regards, Franky Thiel franky.thiel@Infohos.be…
Setting up shared memory connection
Did you add the DBSERVERALIASES line in the onconfig file? -- James Edmiston Quest Information Systems, Inc. www.questisinc.com…
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…
Re: ontape in HP-UX
You need verify the sintax of onconfig file for this entries: TAPEDEV /dev/rmt/0m # Tape device path TAPEBLK 512 # Tape block size (Kbytes) TAPESIZE 7800000 # Maximum amount of data to put on tape (Kbytes) (This is my onconfig fil…
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…
oncheck uses /tmp
Does the oncheck uitlity use the /tmp directory? oncheck -pe fails with the error: The temporary file used to sort extents has exhausted the amount of space it may allocate. and /tmp is full. AIX 4.3 IDS 7.31 UC2 Uday…
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.…
Ontape --- out of disk space
I am getting an error from our ontape level 0 backups. The error message reads "ISAM error --- no free disk space". During the backups, there is quite a bit of database activity (inserts, deletes, updates). I believe that this error is caused by ontape having to preserve chang…
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…
Re: Problems with temporary string storage space
There used to be an excellent explanation of this and the various = workrounds in the FAQ, check out www.iiug.org Paul Watson WF Software Ltd Tel +44 1436 674729 Fax +44 1436 678729 www.wfsoftware.co.uk >>> Ignasi Fosch Alonso <ifosch@sefes.es> 06/25/99 05:57pm >>> Este es un m…
Re: Problems with temporary string storage space
Jun Nolasco wrote: > This is -4518 error is a known "feature" of Informix-4GL and New Era. > The best place to learn more about this topic is at the web sites of > both Informix and the International Informix User Group (IIUG). Don't > have the IIUG site address handy though. ht…
Problems with temporary string storage space
Hi, Folks, I'v found a problem with a 4GL program running on an Informix SE with SCO Openserver. This machine is a AMD K6-2 300 MHz with 64 Mb RAM space and sufficient disk space. We have a program which unloads some data to ASCII files for a modem communication, but in this ca…
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.…
Re: Informix 7.3 UC5 on RH Linux 5.2
Additional INFO: Please see attached "sqlhosts" and ONCONFIG files...…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Re: Inittial and next extend size effects on temporary db space
From: brucelock@my-dejanews.com > >Hi >I am new to Informix and struggling with initial and next extent sizes >in Informix 4.0 on SCO unix 3.2. >Before I get the cat calls.... yes its old versions, but there are good >reasons (like lost source code) that keep my client using the …
Inittial and next extend size effects on temporary db space
Hi I am new to Informix and struggling with initial and next extent sizes in Informix 4.0 on SCO unix 3.2. Before I get the cat calls.... yes its old versions, but there are good reasons (like lost source code) that keep my client using the product. The problems I get are that i…
Re: onconfig parameters
> onstat -c shows you the contents of the ONCONFIG file, but then so does vi > $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? Does onstat -c reflect changes made by onmode commands? I should try that and see...that, to me, would be the compelling reason …
Re: onconfig parameters
Thomas onstat -c shows you the contents of the ONCONFIG file, but then so does vi $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? HTH Sujit "Thomas G. Smith" <tsmith@wdn.com> on 04/28/99 12:19:10 PM Please respond to "Thomas G. Smith" <tsmith@wdn.com> …
onconfig parameters
Is there a command to force the engine to show me what all the onconfig parameters (and other perhaps unknown parameters) have been set to?…
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…
Re: Informix 7.24 Temp Tables Not Dropping
jeffm@lysander.co.uk wrote: > > In article <7d74rd$hrt$2@news-1.news.gte.net>, > June Tong <june_t@hotmail.com> wrote: > > jeffm@lysander.co.uk wrote: > > > > > I have a system running IDS 7.24 on HP-UX 10.20. Some software is creating > > > temporary tables using 'SELECT...IN…
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…
Sort memory
I have a query which I need to run in an OLTP environment, but which seems to tear up the disk where my temporary space is located. Is it possible to assign additional memory to this query for sorting so that it doesn't need the disk space? I've played around with the PDQPRIORI…
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…
onconfig tuning
Hi all! I have posted to the web my collection of notes on onconfig parameters. It is not yet complete but pretty far along. http://home.earthlink.net/~mildness/bamph/informix.htm It has helped me over the years to have this list in my PDA. If you think it useful feel free…
BAR and NT :temporary files ?
Hi, I have an informix database of 3.5GB on a windows NT system. When I try to do a backup with the informix BAR I receive an error message "Error insufficientdisk spaces : files C:\\winnt\\ismXX.tmp " I suppose that this is a temporary file. I have only 200MB free on the disk …
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?…
Regarding calling an INFORMIX procedure from a UNIX shell script
I use dbaccess for this purpose. Syntax is "dbaccess <database> <text file with sql commands>. Just be sure your informix environment variables are set properly (INFORMIXSERVER, ONCONFIG).…
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…
Re: IECC Server Discovery Failed 2nd
Hi Dale, sorry for not reading your article correctly: Are both agents running admagent and osagent ? If so, when you run stopsa, do both stop? If not, kill them and run startsa again. Is your onconfig still up to date? The agents seem to take all information from onconfig ra…
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…
Updating databases
What must be done,eg onconfig, to get the fastest result on updating a database alter tables, inserts etc.…
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:…
ONCONFIG on UNIX
What kind of use if the parameter "SYSALARMPROGRAM" for. And which input parameters are used. Thanks for mailing to baumschlager@pfeiffer.co.at…
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…
Backup Problem
When I try to backup my databases I receive this error: "ISM Message: Error: Temporary space is insufficient to perform a backup. Free space in c:\\winnt\\ISM5.tmp" I want to change the temporary file to another drive. Where can I do that? (Maybe a System variable could resolve…
sizes in onconfig
OWS 7.2 on SCO UNIX: Does anybody know why all sizes of dbspaces or logs, etc. are just half as big as they are in the onconfig file. If I check the size of a dbspace, for example, its file size is 2 GByte, but oncheck -pe says it's 1 GByte. Thanks in advance, Pascal…
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: Doubt regarding L.Log size
Sadagopan, Sathish wrote: > > Hi, > LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows > > a figure of 5000 , Page size is 2K. > How can that be ? It looks like someone used onparams to add logfiles with sizes different from that stored in the onconfig.…
Doubt regarding L.Log size
Hi, LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows a figure of 5000 , Page size is 2K. How can that be ? TIA Sathish…
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: Temporary Space Issue
In article <01bd9a08$c42fe150$57011814@willie>, Willie L. Meeks <wmeeks@harrahs.com> writes >Greetings all, > >I have a problem related to temporary dbspace usage. It is a known bug in >7.14 related to temporary spaces not rolling i.e.( When a query attaches to >a temporary spac…
Re: Temporary Space Issue
Willie L. Meeks wrote: > > Greetings all, > > I have a problem related to temporary dbspace usage. It is a known bug in > 7.14 related to temporary spaces not rolling i.e.( When a query attaches to > a temporary space it will not roll to the next temporary space). I know you do…
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…
Temporary Space Issue
Greetings all, I have a problem related to temporary dbspace usage. It is a known bug in 7.14 related to temporary spaces not rolling i.e.( When a query attaches to a temporary space it will not roll to the next temporary space). Example currently I have 11 temporary dbspace d…
Re: Temporary dbspaces
In article <3576713C.79705C38@jonners.cix.co.uk>, Jonathan Myatt <jon@jonners.cix.co.uk> wrote: > > A quick question for the gurus... > > If I have four temporary dbspaces defined, will a large sort which > creates a large temporary table use all four, or can the temp table > n…
Re: Informix backup and temporary space
Helmut Leininger <Helmut.Leininger@bull.net> offerred: +I've had the same problem at a customer site. I found out, that about 200 MB +of free space was needed during the backup (it's freed afterwards). +I do not know, why taking a backup needs so much space and I did not find a +…
Re: Informix backup and temporary space
As far as i can tell, when you do a backup with onbar it pulls the data out of each dbspace into a temporary file, then copies that file to tape. (This seems to be true with a whole-system backup anyway - onbar -b -w -L 0 ) Thus, If you have a dbspace with 2Gig of data in it (li…
Re: Informix backup and temporary space
Hi Ren�, I've had the same problem at a customer site. I found out, that about 200 MB of free space was needed during the backup (it's freed afterwards). I do not know, why taking a backup needs so much space and I did not find a hint in the documentation (I would be interested …
Informix backup and temporary space
Can anyone help me? I have a Informix Online Workgroup Server 7.23 running on a Windows NT Server 4.0. When I try to do an Informix backup of the whole system, I get an error message: ERROR: Temporary space is insufficient to perform a backup. Free space in C:\\WINNT\\ISM34.TMP…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: Bad performance with DBSPACETMP enabled
> You have stumbled on a little known fact. Sorting is faster to > filesystem space than to temp table space. And since you do not care > about the safety of those sort-work files that's OK. > I am sure that you have tested this. Please excuse my ignorance. I find it hard to be…
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…
My weird problems
Thanks to all who replied. The Logical Log problem was with memory parameters in the onconfig file. DBSPACETEMP problem still exists however Regards Lee Robertson…
Re: [Fwd: Correct Answer]
Hi, Below is the excerpt from INFORMIX Dynamic Server Administration: When you create an explicit temporary table using the IN dbspace option of CREATE TEMP TABLE, OnLine stores the temporary table in that dbspace. When you do not use the IN dbspace option of CREATE TEMP TABLE, o…
Onconfig Question
I sent this a few weeks ago and didn't get any responses. I am rephrasing the heading and trying again. We are not currently having any performance problems, but I am interested in hearing some opinions from the experts out here. One of our systems is as follows: Sun SPARCcen…
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?…
OWS on NT: temporary space used by onbar ?
Hi, I have seen that a backup by onbar (launching it by the Command Center) of my database (size about 2 GB, used 500 MB) onto a streamer tape on the NT system needs nearly 250 MB temporary space. Is there a way to say what amount of temporary space is needed? Can it be reduced…
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: onstat -d,onstat -D
I believe 1001 indicates that the dbspace is a blobspace. I know that 2001 indicates that the space is a temporary dbspace. "Tony_Reynolds(Accounting & Purchasing System") wrote in message <67972r$caj@cssun.mathcs.emory.edu>... >Can anyone tell me the difference between a dbspa…
Re: Freeing Logical Log with Status U
What's LOGFILES set to in your onconfig file? Try forcing a checkpoint? Jon.…
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…
Re: 4gl Temporary string storage space error worka
Interesting... any idea why this would work? At 09:28 PM 10/27/97 EDT, you wrote: }Belakimem <belakimem@aol.com> schrieb im Beitrag }<19971026173000.MAA15424@ladder02.news.aol.com>... }> Hi All }> }> Re : 4gl Temporary string storage space error workarounds? }> }> I have the ver…
Re: 4gl Temporary string storage space error workarounds?
Belakimem <belakimem@aol.com> schrieb im Beitrag <19971026173000.MAA15424@ladder02.news.aol.com>... > Hi All > > Re : 4gl Temporary string storage space error workarounds? > > I have the version of 4gl which still gives this problem. > > I am familiar with the workarounds as sugg…
Re: 4gl Temporary string storage space error workarounds?
On 26 Oct 97 at 17:30, Belakimem wrote: > Re : 4gl Temporary string storage space error workarounds? Check out the FAQ. The URL's in my .sig. Any other TLA's you need? :-) -- Ciao, Billy Head up the ass in: Dubai, Merry Middle Eastern Paradise Get the Informix FAQs of life at…
4gl Temporary string storage space error workarounds?
Hi All Re : 4gl Temporary string storage space error workarounds? I have the version of 4gl which still gives this problem. I am familiar with the workarounds as suggested by the finderr function. My problem is that I am outputting to a report (with an order external by) and …
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…
TempSpace is down
Hi, recently onstat -d (Online 7.20UC2) flags our temporary DBspace as "NDT", which means it is "down", oninit says "bad primary chunk", and the manuals are no help. Online is actually not using the space, so how can I bring it up again? Thanks, Patrick -- Patrick Preuss …
Error 179 - any ideas??
I set up a test instance on a server, with a copy of our production database, for testing. I kept BUFFERS very small - 500 I think. The server application failed with 179 errors (no more sort space). This suggests a problem with DBSPACETEMP. It's certainly true that my settin…
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…
Re: Error 567 - Cannot Write Sorted Rows - Help Needed
news wrote: > > Error 567 - Cannot write sorted rows. > Can anybody please enlighten what is this error and how to resolve it. > Thanks. > > Francis . Hi, possibly you do not have enough space for temporary data available. Bye Stefan…
Re: Resizing Logical Logs
Also, there is a MAXLOGS parameter in the onconfig file that should be increased. Madison Pruet…
DR Question
Hi Chaps, I cannot seem to create a temp table on the secondary server. (select * from table into temp table;) According to the informix manuals it is only possible to create temp table on the secondary server. The message I get is 229: Could not open or create a temporary fi…
Re: Replication 7.11
David Williams wrote: > > Try tbstat -c to get the current configuration on the seconary BEFORE > ontape -p and check it matches the primary configuration with only > the root dbspace and temporary dbspaces including (dbspace has a > T against in in onmonitor). > > Some…
Re: root dbspace
Tony_Reynolds(Accounting & Purchasing) wrote: > > I have a test machine running Online 7.1. > On performing a VERY large query I received an error message > saying that there was no free disk space to write sorted rows into > a temporary table. On examining the space available i…
root dbspace
I have a test machine running Online 7.1. On performing a VERY large query I received an error message saying that there was no free disk space to write sorted rows into a temporary table. On examining the space available in the rootdbs 32252 pages remained out of 575000. I sh…
Re: ONCONFIG
Kerry Davids wrote: > > Jacob Salomon <jake@apparel.net> wrote: > > >Patrick, > > >onconfig.std is meant as a template to copy from. If I had my druthers, > >I would have it shipped with 666 permissions so that even user Informix > >could not (or at least is less likly to) inadv…
Re: ONCONFIG
>From: satriguy@aol.com (SaTriGuy) >Date: 21 Jan 1997 06:01:04 GMT >X-Informix-List-Id: <news.32813> > >If I had my way, I'd remove it from the system all together so that it >would not be possible to 'accidentally' use the wrong onconfig. ;) >Madison Pruet I think the 'it' refe…
Removing a DBSpace
I'm having some trouble removing a DBSpace from an old Online 5.0x server. I created a temporary space to test some things, finished the testing, and deleted the database I had created, but it complains that the space isn't empty. Here is the "tbcheck -pe" output: Chunk: 4 …
Re: ONCONFIG
If I had my way, I'd remove it from the system all together so that it would not be possible to 'accidentally' use the wrong onconfig. ;) Madison Pruet…
Re: ONCONFIG
Jacob Salomon <jake@apparel.net> wrote: >Patrick, >onconfig.std is meant as a template to copy from. If I had my druthers, >I would have it shipped with 666 permissions so that even user nformix >could not (or at least is less likly to) inadvertently modify it. >(Actually, in …
RE: ONCONFIG
Hi Patrick! OK. please check with env command to see the ONCONFIG environment variable, this sould containg the file being use at this moment, and please, make a copy before you make any changes, Regards :) ---------------------------------------------------------------- Mario…
RE: ONCONFIG
You have to check your env variables. One of them is ONCONFIG which will be set to either of the files. Munaf g086mnf@bomplant3.appl.ge.com ---------- From: informix-list-owner[SMTP:informix-list-owner@rmy.emory.edu] Sent: Friday, January 17, 1997 4:04 PM To: informix-list S…
Re: ONCONFIG
In <32DF327E.1DBB@mediacity.com.sg>, Patrick Stacey wrote: }I see 2 onconfig files in my etc directory (sol 2.5.1 platform). } }one has .ifmx and the other .std } }which do I edit in order to change the system configuration? }Specifically I want to configure informix for a multip…
Re: ONCONFIG
Patrick, Type the command "onstat -c | more". This option prints a copy of the current configuration to the screen, but more importantly, the second line gives the path and filename of the current configuation in use. Tracy > > I see 2 onconfig files in my etc directory (sol …
Re: ONCONFIG
If you have to ask this you shouldn't attempt to modify the file. This is RTFM, very much so. You'll depend on knowing so much before tuning OnLine in this way that if you have missed this in the manuals, you may also have missed a lot of other info. Sorry for this. I don't mean …
Re: ONCONFIG
Patrick Stacey wrote: > > I see 2 onconfig files in my etc directory (sol 2.5.1 platform). > > one has .ifmx and the other .std Patrick, onconfig.std is meant as a template to copy from. If I had my druthers, I would have it shipped with 666 permissions so that even user nform…
ONCONFIG
I see 2 onconfig files in my etc directory (sol 2.5.1 platform). one has .ifmx and the other .std which do I edit in order to change the system configuration? Specifically I want to configure informix for a multiprocessor machine (4 CPUs actually). many thanks, /pks -- [ Pat…
Temp Table/dbspace problem
I am having a problem with an Informix application. The DBSpace that the application uses gets filled seemingly when large queries are performed. After the error occurs we have examined the DBSpace via TBMonitor and it is full. However when we add the sizes of all the tables re…
Re: Incompetence!
I don't know exactly what the problem you encountered is since you did not describe the error code that you received. However, I'm going to take a guess that you might have run out of space in the dbspace that the temporary table was being created in. Try creating a dbspace for…
Re: Help I'm in crisis
Hi Tony, Check you $ONCONFIG file if the PDQPIORITY > 0, modify it to be 0, that means disable PDQ in $ONCONFIG. Please set PDQPIORITY as user environment variable for large report/ bach job only. Otherwise, every single session takes a lot of memory. Regards Eric Lam Taipei/Tai…
Re: onconfig
Hi Sue, >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this question may >appear to come from a simpleton. Stop right there. Go and fin…
Re: onconfig
> From: Sue Alsbury <salsbury@mdshealth.com> > Date: Friday, October 18, 1996 4:11 PM > > Hi there. I am an Oracle/Sybase dba. I've just been put on a project > which uses Informix Workgroup Server V7.12 on Windows NT. I have no > training or manuals in either Informix or NT, so …
Re: onconfig
In article <3267E47A.54DA@mdshealth.com>, Sue Alsbury <salsbury@mdshealth.com> writes >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this …
onconfig
Hi there. I am an Oracle/Sybase dba. I've just been put on a project which uses Informix Workgroup Server V7.12 on Windows NT. I have no training or manuals in either Informix or NT, so this question may appear to come from a simpleton. I issue a select * from tablename. The tab…
Re: Misunderstood DBSPACETEMP ?
David Williams wrote: > > This is odd - Check Informix Online Dynamic Server > Admin. Guide, Volume 2 Version 7.1 Page 38-18. > > "The DBSPACETEMP configuration paramaters is a list of dbspaces used > to globally manager the storage of temporary tables" > > "If bot…
Re: Misunderstood DBSPACETEMP ?
David Williams <djw@smooth1.demon.co.uk> wrote: > This is odd - Check Informix Online Dynamic Server > Admin. Guide, Volume 2 Version 7.1 Page 38-18. > "The DBSPACETEMP configuration paramaters is a list of dbspaces used > to globally manager the storage of temporary table…
Re: Misunderstood DBSPACETEMP ?
In article <325A9392.1C99C17C@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes >Hi folks, > >has anyone some experience with DBSPACETEMP ? Starting with version >7.0 ( an inofficial version ) until 7.12UC1 I've made a few tests >with temporary tables. Now I…
Temp tables not getting removed
Greetings, I am working on an HP-UX 10.01 system running On-Line 7.13.UC1 the the ESQL/C and ISQL packages installed. Lately, I've noticed a problem with temp tables not getting cleaned up. Initially I had DBSPACETEMP defined as the same dbspace as my root dbspace. After runn…
HELP ! - DBTEMP - ONLINE 7.12
Anyone got ideas on how this variable is used in Online 7. We have a big table (c 4million rows) and when we try to add indexes we are running out of space in rootdbs. It should be possible to set DBTEMP to make the sorting and temporary building take place on a UNIX volume tha…
NewEra: Out Of Temp. String Space Error
I have got the 'Out Of Temporary String Space Error' ( error -4518) and can't find what causing it. I have tried to remove all strings passed through functions, but I got the problem still. Can anybody give me some help or hints how to avoid this error??? Thanks! **************…
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…
NewEra: TSS still present
In NewEra we keep getting the "no more space for temporary string storage" error, although we obeyed the rules mentioned in the informix faq's appendix. Are there any problems known with informix classes causing this error ? --- _ // Tom Beuke …
Temporary dbspace
I have created a temporary dbspace. It is referenced by the onconfig file parameter DBSPACETEMP. It was made larger recently because our reports explicitly create temp table using the "WITH NO LOG" option and the temp tables created by 2 specific reports can get pretty big. It i…
Temporary questions
Dear all, could anybody answer the following questions, please. 1. How can I get info in which dbspace a table was created ? 2. How can I get list of tables created in one dbspace ? 3. Where (dbspace) are explicit temporary tables created ? If I have set the enviroment vari…
Re: HELP- 4GL RDS -4518 ERROR IN A REPORT IF NOT DBA
alogica wrote: > > HELP HELP HELP HELP > Did anyone find the same problem or have any suggestment? > Thanks in advance. > Hope my english is understandable. > > Marco Calmasini. > Logica Srl. > Via Calatafimi 1/B > Venice - Italy There is a section in the Informix FAQ about the…
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?…
-567 error with query
I have a windows app which when executing a particular querry (involving outer joins) returns a -567 SQL error (ISAM -2). If I run this query via dbaccess, while loggedinto the same account as identified by setnet, the query is fine. I believe this has somehting to do with disk…
Re: Error -4518 in version 4.1
In article <3lk53f$dkg@cssun.mathcs.emory.edu>, wayne@jones.mac.alt.na (Wayne Harlech-Jones) wrote: > I have encountered error -4518 _The 4GL program cannot allocate any more > space for temporary string storage_ on several occcasions. There is a good description about temporar…
Process Priority with onilne 4.10
Does Online ver 4.10 have fixed priority support like ver 7.0 does with the NOAGE onconfig param. Thanks Chris…
Re: Temporary String Space errors
}From: dennisp@informix.com (Dennis Pimple) }Subject: Re: Temporary String Space errors }Date: 20 Jan 95 14:51:31 GMT }X-Informix-List-Id: <news.10966> } }mdl@world.std.com (Michael D Lemon) writes: } }>After much ado, it seems the problem is occuring in my report with }>using st…
Re: Temporary String Space errors
Dennis, Is it not the case that the code LET a=b using "mm/dd/yy" PRINT a causes less Temp string space errors than PRINT b using "mm/dd/yy" Perhaps you and johnl could answer that one for us. Malcolm Weallans Online Database Consultancy 2 Arkley Court Maidenhead Berks SL6 2YR…
Re: Temporary String Space errors
mdl@world.std.com (Michael D Lemon) writes: >After much ado, it seems the problem is occuring in my report with >using statements. This is very depressing. Could it be possible >to have too many using statements in a report? I have much larger >reports than this one and they …
Re: Temporary String Space errors
In article <D2M19L.Gx4@world.std.com>, mdl@world.std.com (Michael D Lemon) wrote: > > I will get that tech info. Here's an excerpt from the FAQ. The complete Tech Info can be found in Appendix A (recommended reading): 4.1.1 I keep getting -4518 errors! How can I fix this probl…
Re: Temporary String Space errors
After much ado, it seems the problem is occuring in my report with using statements. This is very depressing. Could it be possible to have too many using statements in a report? I have much larger reports than this one and they run without error. I will get that tech info. -…
RE: Temporary String Space errors
The temp string space error is a real pain to track down, many things can cause the error. The cause starts somewhere but the program continues til it run out of string space and then the program dies. Informix tech support gave me a tech info #3925, that had routines to help t…
Re: Temporary String Space errors
In article <D2CLuH.FLG@world.std.com>, mdl@world.std.com (Michael D Lemon) wrote: > I need a profiler for Informix-4gl. Specifically, I would like to > print a function call tree for a program which is giving me 'out > of temporary string space' errors. My 4gl version is 4.11.U…
Temporary String Space errors
I need a profiler for Informix-4gl. Specifically, I would like to print a function call tree for a program which is giving me 'out of temporary string space' errors. My 4gl version is 4.11.UC4 on the RS/6000 using AIX 3.2.5. According to the manual, this can be caused by certa…
Re: help: I-NET and t_open function problem
No space left on device ussually means you've run out out disk space. It might be being used to create a temporary table or something. -- Mike Aubury…
ERROR -4518 String Storage problem
I would appreciate any help with the following error that is occuring at different places in the program where variables are being returned from a function. The error is no. -4518 The program cannot allocate any more space for temporary string storage. At…
"Could not write to a temporary file" error
Dear fellow informix enthusiast, i am in the quest for more than the manual can give. I would like your wisdom, knowledge and thought upon the different cases that would ...... prompt the 'Could not write to a temporary file' error (free list problems, too many open files, etc.) …
Re: Excellent article on Temp. String Space
In <1992Dec9.231353.2343@panix.com> clay@panix.com (Clay Irving) writes: >I've found this to be an excellent discussion of temporary string space in >Informix-4GL. The author is Loren West of FourGen Software, Inc. >(uunet!4gen!lorenw) > Temporary Strin…
Re: Error -4518: Cannot allocate any more space
Thanks you all who reacted to my request for help on error -4518 (cannot allocate any more space for temporary string storage). I really tried all the solutions and work-arounds you suggested. Some of them worked a little bit: the program dumped somewhat further on. So I guess t…
Out of Temporary String
Hi netters \\-), We have a program that runs on a client's machine many times a day. It's an input screen that logs incomming customer replies. And usually after the user enters 50 records, the program bombs out with the -4518 error which is the "the 4GL program cannot allo…
Re: Temp Tables
Naomi Walker writes: > >I thought you could control where temp tables were created (from 4.1 >Online) using DBTEMP. We sometimes have to create them in Unix file >space. DBTEMP has no effect on temporary *tables* created in OnLine; they will always exist in the root dbspace. T…
Re: Informix System constraints
> > 1) Informix error -4518: The 4GL program connot allocate any more space for > temporary string storage. > > This problem occurs after several passes through the program. I am not > using temporary string storage at the statement in which the error occured, > and I can't loca…
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…