Oninit® Archive
Results for “SBSPACENAME”
myimport Problem
Thanks to a boost from Art, this problem is resolved. I admit i should have realized it myself. The answer is turn off logging in the sbspace: 'onspaces -ch <sbspace> -Df "LOGGING=OFF"' . Then, after successful import, turn it back on. The syntax issues that seem caused by som…
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
SBSPACE Chunk error
Hello All, We are working on IDS 14.10 and yesterday we created SBSPACES everything was fine, but we are getting multiple alerts for SBSPACE chunks down.But in real chunks are ONLINE. After SBSPACE Full backup didn't run . I'm sharing the screenshot for related to my Queries. Onc…
SBSPACE
The SBSPACENAME parameter can be changed dynamically with "onmode -wf SBSPACENAME=<name>" and no restart is required. Use SBSPACENAME to specify the default sbspace - you can have multiple sbspaces. ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com -…
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…
Is there a way to check the sbspace usage by table?
Hello, I think there is a way how to find tables/columns with specific reference of given slob (if this sblob is really db table sblob and no the other one (like ER spooled txn object for example). The following script generates sql script containing list of sql select commands w…
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…
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.…
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…
dbaccessdemo and the blob columns in catalog table
The stores_demo database uses a BYTE column in the catalog table. If you want the BLOB/CLOB version, you need to create the superstores_demo database. For the superstores_demo to work properly, you probably need to setup a default sbspace (SBSPACENAME parameter). https://www.ib…
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…
Building and deploying java UDRs
Hi there! Let me try to help you on that issue: 1 - You must have a SBSpace set on SBSPACENAME and SYSSBSPACENAME configuration parameter (requires bounce) 2 - You must have a JVP VP CLASS - "onmode p +1 jvp" to enable it online or set it on instance's configuration file and …
Convert BYTE column to BLOB
Informix 12.10 Solaris 10 We have an old table with some photos that are stored as simple large objects (in a column type BYTE), and stored in the table. We would like to convert that column to hold smart large objects (column data type BLOB), and be stored in the default sbspac…
More Smart Large Object Problems
Informix 12.10 Solaris 10 Until recently, I have not been too involved with sblobs. Now that I have to deal with them, I am finding continual problems-- both theoretical and administrative/management (as in "lack of")-- with these things. Basic violations of fundamental Relation…
Smart Large Objects Mystery?
Informix 12.10 Solaris 10 I have been dealing with these things a lot, recently, and there is a lot about them I don't understand. However, I would ask about one thing in this post. Situation: I had an sbspace that was nearly full. With some guidance from this forum and Inform…
Usable space available in an sbspace?
Informix 12.10 Solaris 10 I'm finding it challenging to be working with sblobs and sbspaces. Even the terminology is a bit confusing to me. For example, A BYTE type is a blob, but a BLOB type is not a blob but a smart blob. Or maybe I have that wrong. But, that's a rabbit trail.…
Replace sbspace with larger?
Informix 12.10 Solaris 10 I have an sbspace consisting of one chunk (symbolic link). I would like to replace that drive and make a much larger sbspace (still only one chunk). Will the following work for replacing the sbspace (a "last checkpoint" restore is acceptable): 1) Do a …
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…
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…
onstat -d
Now, I am no one to dispute Jacques however, I ran into an issue lately where the metadata portion was full and I was still able to insert blobs. It is documented that a rather large portion (sorry, don't remember the percentage) of the actual data portion of each smart blob is a…
oncheck & BTS index
Thanks Mark! That sort of explains what we are seeing -- except that the second running of the oncheck, within minutes of the first, still grabbed a bunch of logical logs even though it should have been a no-op. However, there was no dbspace usage changes, so that seems correct. …
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…
Converting existing second dbspace as chunk
Hi, I have a box that has two sbspaces created (main_sbspace and subsys_sbspace). The main_sbspace is configured as SBSPACENAME in onconfig file. Because of space and other constraints, I cannot allocate more disk space. Can I convert/re-purpose the existing subsys_space as add…
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
as metioned above, maybe you need set TEMPTAB_NOLOG in you onconfig file…
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
Hi Michael, I believe SBSPACETEMP is a list of sbspaces. I am know that BTS will accept a list of sbspaces, but it only uses one of the spaces listed, as documented in BTS: A temporary sbspace that is specified by the SBSPACETEMP configuration parameter. The temporary sbspace w…
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…
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.…
question on SBSPACENAME and SYSSBSPACENAME
I recently added our first subspace and wondering about SBSPACENAME and SYSSBSPACENAME in the onconf file. My assumption is I set the SBSPACENAME to the smart-blob dbspace name (in my case: sdbs0) so the system has a default and the developers don't have to specify which sbspace…
Who is using a smartblobspace
Thanks Art! I did two small adjustments: --and sc.coltype = 40, removed this, did not get any results when it was used, version 11.70.FC7 and st.tabtype = "T", added to get only tables Now it works fine for me Ulf select cf_effective::varchar(128) from sysmaster:sysconfig wh…
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
True, but I have noticed that you need register previously the temporary dbspace in onconfig file, I thought there was some way to make the settings "on the fly", by session. Roger…
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…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
space taken by table - including smart large obj,
I'm looking for a way to determine the amount of space "attributable" to a table, including the space taken by any smart large objects referenced by rows in the table. I realize that smart large objects technically aren't considered part of a single table, since there is can be a…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
installing BTS datablade running on a database
Thanks for that explanation Mark. all clear now We will use SBSPACENAME…
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 …
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…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
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
Yes. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization w…
HDR and clob/blob/byte/text/ etc.
I just want to verify I have this right. If you use a SBSpace or a BLOBSPace - they are not logged, therefore you cannot use HDR on that database. Is that correct? So if you are using the BTS datablade - even if it is on Character or varchar fields, you can use HDR because you …
Informix question
Hi, I have two confused question. 1 When a update SQL will update totally 3 pages in bufferpool? How many mutex IDS will allocate for this thread in the buffer-head entry in the buffer table? 2. What the temporary sbspace will be used for? thanks for your time.…
Re: How to INSERT/UPDATE data type "text" in Informix IDS11.7
for these: create table "informix".emp (emp_name text); create table "informix".emp1 (emp_name1 BYTE IN blob1); check the manual you can use java and use a binary stream or use locator stuff ex in $INFORMIXDIR/demo/esqlc/blobload.ec for: create table "informix".emp1 (e…
How to Insert/Update data type "TEXT" in IDS 11.7
Oat is preparing the INSERT statement, finding that there is a TEXT type column and using one of the proper methods to insert data to a TEXT BLOB, dbaccess and PHP are not doing that so they get errors. You can write your own ESQL/C program to do this. There is a demo program in …
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…
Physical Log Size
How did you "increase" the size? You can only do that song onparams. You cannot do that just by changing the Onconfig file Art On Jan 25, 2011 12:10 PM, "KENT GRUNDEN" <k.grunden@hoogwegtus.com> wrote: > IDS 11.50.FC4WE Windows Server 2008 64bit > > I keep getting the message wh…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
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.…
HDR and Spatial Datablade
Hello 2 things - #1) Have not read anything special yet regarding installing this nodule but is there anything special that needs to happen when installing and registering Spatial? I have already come across reading from others that the onconfig paramter of IFX_EXTEND_ROLE need…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Re: 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…
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
Resolution: We left the SBSPACETEMP alone, created a space for the SBSPACENAME and added the following line to our $ONCONFIG file: VPCLASS idsxmlvp,num=1. After bouncing the engine and changing his query to use function genxmlqueryclob, all is well. Thank you for your assista…
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…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
oninit fails reporting problem with DBSPACETEMP
But in my ONCONFIG file, i have mentioned the tape device as STDIO…
SBSPACE FULL
Is the SBSpace the Deafult SBSpace ? Does the SBSpace store data from more than 1 table? What data type is being stored, BLOB, CLOB, Spatial ?? At a minimum, each SmartBlob will use 1 page ( 2 or 4 K ) depending on page size. So 100,000 x 2 or x 4 is 200,000 or 400,000 KB at a…
RE: garbage after unsintall BTS 1.10
Hi César I am the principle developer or Basic Text Search DataBlade and I just had a look at this issue and I hope I can offer some suggestions to help with this process. Regarding bts objects left behind after bts.1.10 is unregistered.: I am concerned that you are seeing …
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…
Unexpected error registering BTS 2.00 datablade
In BTS v1.xx, BTS only supported indexes built in an external space (ie in a directory on the file system outside the database). This was an issue for customers that wanted to use the index in an HDR environement (among other things). In IDS 11.50xC3, we included a significant f…
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 …
very simple onspaces question?
-p is for Path. So you still use -p. The mirror will have a different path. onspaces Usage: onspaces { -a <spacename> -p <path> -o <offset> -s <size> [-m <path> <offset>] { { [-Mo <mdoffset>] [-Ms <mdsize>] } | -U } } | { -c { -d <DBspace> [-k <pagesize>] [-t] -p <path> -o <…
How can I use new sblob space
It turns out that 10.00.FC6 will not allow me to use a sblob space unless that sblob is defined in SBSPACENAME. And then ONLY the sblob space defined in SPSPACENAME. We have an open ticket with IBM; apparently this is a known issue. IBM is checking to see if this problem was f…
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…
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: 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: Informix Java User Defined Functions
Another source of informaion might be: http://www-128.ibm.com/developerworks/edu/dm-dw-dm-0610perrin-i.html > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Guy Bowerman > Sent: Thursday, August 17, 2006 …
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?…
Informix Java User Defined Functions
1. Make sure you have a c:\\tmp directory. 2. Try changing "file:$INFORMIXDIR/extend/krakatoa/examples/Env.jar" to "file:c:/progra~1/IBM/Informix/extend/krakatoa/examples/Env.jar" 3. Make sure you have an SBSPACE configured and online and pointed to by the SBSPACENAME onconfig pa…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: 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…
Performance issue after 732 to 94fc6 upgrade
Hello, Not easy without knowning the structure of you tables or the number of rows. First thing I would look into is the sequential scans. But as the cost is very low, I assume the tables have only a couple of rows, so this should not make any difference. If you say the snippet …
RE: DataBlade Manager
You also need another SB space: SYSSBSPACENAME - This is the default SB space used by the Informix server. Add the above parameter to your onconfig file with a name for your SB space, add the space with onspaces, do a level-0 backup and register the datablade. Let us know if t…
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
I tried an example with 3.00.JC3 and it works fine without having a default SBSPACENAME in the onconfig file. VG.…
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: Help! blobs in IDS10.0 fail
I appreciate the suggestion. The issue was resolved. It had to do with the need to have a smartblob space, and possibly a SBSpaceName in the onconfig file. Thanks!…
Re: Validating the 'SBSPACENAME' sblobspace
Thank you for your responses. I have implemented the lookup in sysconfig table (using the cf_effective column) with a lookup in sysdbspaces. Thanks for the help! Regards Thor Kristensen…
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 …
Validating the 'SBSPACENAME' sblobspace
Hello, Question: My application is a simple application that connects to the Informix instance, validates that some preconditions are fulfilled and starts creating a database (including dbspaces and such) and enables datablades for the database. Now one of the datablades needs t…
Validating the 'SBSPACENAME' sblobspace
Hello, Question: My application is a simple application that connects to the Informix instance, validates that some preconditions are fulfilled and starts creating a database (including dbspaces and such) and enables datablades for the database. Now one of the datablades needs t…
Column level encryption - IDS 10
Because we are using block encryption algorthms with chaining. That means you can not store an encrypted number in only 4 bytes. <hariog@yahoo.com> wrote in message news:1134601844.476897.14850@f14g2000cwb.googlegroups.com... > Hi Folks, > > AFAIK column level encryption is ava…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
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…
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: ER and inplace upgrade 7.31 to 9.40
=20 =20Andrew=20Hamm=20wrote >=20Hi=20folks >=20 >=20I=20need=20to=20upgrade=207.31=20to=209.40=20on=20servers=20which=20pa= rtake=20in=20 >=20Enterprise=20Replication.=20We=20did=20a=20test=20server,=20and=20it=20= barfed=20 >=20because=20of=20a=20few=20things: >=20 >=201)=20n…
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: 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 …
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…
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…
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…
IDS 9.3 Enterprise Replication
If you want to use CDR in 9.30/9.40 you have to set SBSPACENAME and SYSSBSPACENAME in your ONCONFIG to an existing SBSPACE with LOGGING=ON. On Thu, 20 Feb 2003 08:43:30 -0500 (EST) "Jozef Horyl" <jho@nr.dflex.sk> wrote: > Hi, > I have problems to define server for Enterprise Re…
ESQL error messages for BLOBs
I am running IDS.2000 under Linux and am trying to access BLOBs via ESQL. However, when I try to call ifx_lo_create, the function returns an error with the error code -9810. However, I looked this up in the error codes, and the docs said "For more information, check the accomp…
sbspaces
I need some help with sbspaces and the information that is presented from onstat -d and the data in syschunks. When I issue a onstat -d, it appears I have lots of free space in my sbspace's. However, when I query the syschunks table looking at the nfree column, it appears I hav…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
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…
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…
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…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
extract BLOBS
there is a smart large object function 'lotofile' which does this. lotofile ( blob-column,pathname, file_destination) pathname = directory path and name of the file. file destination = 'client' to identify the client computer as the location of the file. file destination = 'serv…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
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…
Smart Blobs Errors - locking issue
We're using 9.14UC7 and we're consistently getting 9810 (Smart blob error) and 113 (file is locked) errors when we have multiple users creating tables with smart large objects at the same time. Specifically we are running scripts that create a table with the default smart blob s…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Long Type
Irineu Rocha wrote: > Does anybody know how to build a select with a clause where on a attribute > defined as long? LONG isn't an Informix data type; it is used in Oracle, where it approximates to an Informix byte/text blob. If you're processing a text blob, you can write a se…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
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…
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…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
can't drop chunk from sbspace
hi all! i'm using solaris 2.5.1 with IUS 9.14.UC3 I don't know why I can't drop a chunk from a sbspace. with onstat -d , i choose to drop the chunk from clientsbsp3 > onstat -d INFORMIX-Universal Server Version 9.14.UC3 -- On-Line -- Up 7 days 11:19:15 -- 92872 Kbytes Dbspace…
worked example of creating smart large object with INFORMIX-CLI 2.8
Need $subj. Eugene.…
Trouble with smart large object
Hello. I have a problem with creating smart large object using CLI. When I get the size of smart large object, allocate the buffer to hold the structure and create a default smart large object specification structure using ifx_lo_def_create_spec(?), I try to initialise the smart…
9.14 SmartBlobs/No free disk space error
I have defined a temporary smart blob space of significant size, and normally my queries that create smart large objects have no problem. But periodically I start getting an error 9810 Smart Blobs Error accompanied by a "No free disk space" error. When I do an "onstat -d" I see …
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
don't understand sbspace
hi all I'm using 9.14UC3 on solaris 2.5.1 when I monitor my sbspace by two differents ways . I got two differents results. by using onstat -d, here is my display: > onstat -d INFORMIX-Universal Server Version 9.14.UC3 -- On-Line -- Up 1 days 01:11:56 -- 91960 Kbytes Dbspac…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
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: 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…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
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…
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…
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: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
help : about sbspace
I want to know how to use insert clause about sbspace. Many case, must use environment variable SBSPACE_NAME in onconfig file. Also can use 'create clause', some columns have CLOB type to be indicated to use what sbspace like follows. create table abc (col1 int primary key, co…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
help : How to insert into sbspace.
If want to use CLOB or BLOB in informix, must create and use sbspace. I didn't setting the default sbspace variable SBSPACENAME in onconfig file, and I had to set it explicitly at table create time. like, CREATE TABLE mytable ( col1 INT PRIMARY KEY, col2 CLOB …
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
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…
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?…
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: 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…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
IUS 9.0 problem with lost smartBlobspace
Hi Is there a way to drop a table, wich has an lld_lob row that points to an lost sbspace. (diskcrash) When I try to drop the table, always an error about an lost objectreference occurs. Greetings -- Philipp Gruenig Tecno Software Molerweg 42 2540 Grenchen Switzerland…
Re: Error -130
Klaus Voss wrote: > > David Williams wrote: > > > In article <33AE579D.D38FEC73@pixelpark.com>, Klaus Voss > > <voss@pixelpark.com> writes > > >The creation of a database in a Sbspace fails with ISAM ERROR > > -130: no > > >such dbspace, > > >although the Sbspace exists accordin…
Re: Error -130
<HTML> David Williams wrote: <BLOCKQUOTE TYPE=CITE>In article <33AE579D.D38FEC73@pixelpark.com>, Klaus Voss <BR><voss@pixelpark.com> writes <BR>>The creation of a database in a Sbspace fails with ISAM ERROR -130: no <BR>>such dbspace, <BR>>although the Sbspace e…
Re: Error -130
In article <33AE579D.D38FEC73@pixelpark.com>, Klaus Voss <voss@pixelpark.com> writes >The creation of a database in a Sbspace fails with ISAM ERROR -130: no >such dbspace, >although the Sbspace exists according to onstat -d . The >oncheck-utility doesn't report any >error too.…
Error -130
The creation of a database in a Sbspace fails with ISAM ERROR -130: no such dbspace, although the Sbspace exists according to onstat -d . The oncheck-utility doesn't report any error too. (Informix version is IUS 9.10.UC1 for Solaris) Thanks. Klaus…
Re: Resizing Logical Logs
Also, there is a MAXLOGS parameter in the onconfig file that should be increased. Madison Pruet…
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…
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…
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…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
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…
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…