Oninit® Archive
Results for “onstat -g dsk”
B-tree height
Jonathan is correct. Maybe, someday, you won't have to drop and recreate your indexes to compact them any more. You'll should be able to reorg them (and compress the keys like we compress data) as well. Stay tuned!!!!…
Encryption/compression of backups
Technically speaking onbar does not compress or encrypt data, but the storage manager does. yes ism will compress data, I forget what type of compression. You can use the feature backup filters to do compress/encryption with ontape also, but you must supply your own filters. J…
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 ------------------------------…
Phantom rsccompdict table
P.S. I think it is possible that there could have been some attempt to experiment with compression, in the past. Is there any way to know whether any tables in a database are currently using compression? ------------------------------ David Grove ------------------------------…
How many aio/KAIO
Interesting discussion. I don't agree with a lot of things said here, mostly about hyperthreading and "overloading" cores with Informix CPUVPs, but, whatever works for some (test) environments has a right to be presented, I guess. Some AIX / POWER comments. On POWER you are very …
ontape does not finish the backup: tape full
Hi, I would consider changing BACKUP_FILTER (and RESTORE_FILTER) to a shell script which calls the compression program but appends stderr from that to a fixed file so you can see any error messages from the compression program. All, Where does the stderr of the BACKUP_FILTER/REST…
Index page size recommendations
Hello Henri, I wish that 'compressed' was a valid option for us. Unfortunately, we're using Workgroup Edition, and I believe compression is only available in Enterprise Edition. Even if it were available to us, I would not be allowed to use it, as it would interfere with the de…
Slow running backup
If the problem is slow network or target file system, consider compressing with multiple threads, for example: BACKUP_FILTER 'pigz -b 4096 -p 8' RESTORE_FILTER gunzip See: https://zlib.net/pigz ------------------------------ Doug Lawry Oninit Consulting -------------------------…
HQ blues
This is clearly a Informix HQ bug. Stack trace denotes it's something related to table compression evaluation. Please, contact support. Vicente ------------------------------ Vicente Salvador Cubedo ------------------------------…
Are there many customers using Informix version 14.10?
SangGyu Jeong: Version 14.10.xC3 which was released last week contains, as far as I know, all known critical bug fixes and is the first stable release of v14.10. I do recommend to my clients that they upgrade to v14.10 sometime this year. At this point I do not have any active pr…
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…
ER extent sizes
other than manually creating the tables on the "secondary" server with the correct sizing you can try exploring storage optimization methods : https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/i ds_admin_1421.htm Mark…
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…
Compressing a Busy Table
IDS 11.70.FC8 Linux GNU x86 I am wanting to bring compression into our environment and am wondering about when I am actually compressing or repacking, what kind of interference I can expect on my data being used at the time. I have played with this feature before but I know I wi…
index compression on Version 12.10
If i want to compress the detached index, Do the create index command lock the whole user table ? it will affect the business. thanks.…
informix on linux or solaris?
One advantage for Solaris/SPARC is that the make of the OS also making the hardware and storage! The question is whether this provides enough benefit to be worth it. To summarize the below it would be good if IBM used at least 1 SPARC box with Silcon Secured Memory for addition…
Deleting .rsccompdict from dbspace
Hello Everybody Because of reorg some Tables, we are doing some Tests with compression, and after filling a compressed 100G table I was not able to drop the dbspace which holds only the Table right after droping the compressed table. "oncheck -pe" lists some remaining .rsccompd…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
dbimport compressed tables
Dear all, I tried to edit .sql file before dbimport by adding create table yyy ( .... ) fragment by expression ... in datadbs extent size 256 next size 256 lock mode row compressed; following the IBM url https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sql…
Compress Repack Duration
This one is hard to make any statement, from the superficial problem=20 description, but I'd tend to agree that your duration is by far too long. One thing I noticed is: with your very many buffers (23mio) your=20 lru=5Fmin=5Fdirty/lru=5Fmax=5Fdirty values (40/50) would result i…
Blobs vs Smart blobs
I tend recommend smartblobs for reasons Fernando mentioned however if you are don't need replication and you have a smaller system (< few hundred GB blobs) I have found blobspace page optimized for the blob size tend to read perform better Cheers Paul Paul Watson Oninit www.oni…
IDS 12.10.FC- Installation
Different pages sizes do not necessarily use more hard disk space, and in fact can save space. Having different page sizes can allow you to store records more efficiently. When a record is stored on a page, there will usually be empty space left on that page. Using different pag…
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)…
question about enable compression
but I found if i don't execute 'enable compression', the 'shrink' could interupt the application. after I execute 'enable compression', the shrink become the online operation.…
ER replicate compressed tables
Folks, IDS12.10 FC4 If a table is replicated, How would it impact ER performance ( positively or negatively or ..) if we compress the table? Another question, If the table is compressed at one site only, ER will send the compressed data in the format in logical log and do un-c…
SCHAPI table estimate_compression
The reason for this task is to show good candidates for compression of indexes/tables. (11.7+ can compress tables and indexes, prior only tables.) IDS can be setup for "automatic compression" of tables/indexes in 11.7+, but this task is still just an "estimate." I recently did a …
index compression
IDS12.10 FC4. I am going to try to compress some big indexes with long keys , e.g., VARCHAR(250), with considerable length of duplicate sub-strings among millions of index keys. Want to get some existing experiences if possible. --- after an index got compressed, its performan…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix/Oracle
I suppose that by 3rd party it's assumed the Golden Gate product which has been bought by Oracle (mainly due to the fact that their native table base replication never won against this product). DG and RAC are extra cost on top of the "enterprise" product, but that discussion alw…
Index creation on compressed table
Hi All, Informix 12.10.FC2 on HP-UX B.11.31 If I have to create a index on a column of a compressed table (Informix Compression) then will it take more time as compared to creating an index on the same column of the same table when it is not compressed? Regards Vikas…
infxclone
Thanks ... Couple of follow up questions ... Should these be set on both the target and primary servers ... and then is there a general guideline for the BAR parameter ... On this particular server we generally have that set to 4 as that is what our storage manager is allowing …
Dbimport & The Grid
Try the following... execute procedure ifx_grid_connect('grid1'); create procedure xqt_cmd(cmd lvarchar) system cmd; end procedure; execute procedure ifx_grid_execute('grid1', "dbaccessdemo7"); I haven't tried this, but am pretty sure that it would work. With dbimport, you ca…
compression and ER
Folks, When a table is compressed and ER replicated, assume the data compression ratio is 80% on the table, do you think the ER data volume in network for that datable could be reduced by 80%? or compression will not change ER traffic volume ? Thanks, Frank --001a11c2f4e6312cd…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Cognos software
Thanks a lot, Art. I´ll forward this to my managers, and they can obtain more info about it with our local IBM partner (MC Software). Best regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical…
when use IfxDataReader.GetIfxDateTime to NULL valu
Art, Thanks. I use IfxDataReader.IsDBNull to detect the value of the specified field is NULL or not before getting the value. Your suggestion is workable. I have one thing to share with : when use the trim function to compress the string field, the string is empty.…
Storage Optimization
Aix 7.1 IDS 12.10.fc1 I have been tasked with doing some testing with compression to determine the benefits we would receive on our data. I have a test system where we have moved one of our production databases and I am working to compress some of are larger tables. In doing so …
Page Size
Hi, everybody. I talked about this subject before, but I'm not sure what is the best solution for my environment. I have a lot of table that have the row size bigger than page size. I've been thinking about change the dbspace size, use a clob or blob to store those data. I have a…
11.50 : Disk almost full --> What to do?
yes i understand what to do for the primary and hdr, i must see with the systems team if they can add this space on both prim and hdr. but i m really interested with the compression, and yes i have the 11.50 ultimate édition, so in fact, the answer is yes, i can compress :) ?…
Re: Best practices for IDS on virtual machine?
Hi Art , Hmm... I would like to disagree with you... but before that I will do the write test. What I remember from tests did on the past (studying about this behave) I conclude the write I/O throughput bounds will be "defined" from the Linux kernel dirty buffers flush/sync para…
Re: Best practices for IDS on virtual machine?
Cesar, your timings for read-reread using the OS cache are credible and I will say something about that at the end. However, note that whether you use RAW or COOKED without DIRECT_IO or COOKED with DIRECT_IO your data is safe! When you disable DIRECT_IO and are using COOKED chu…
Re: Best practices for IDS on virtual machine?
Hi Richard , check this practical test about the effect of the cooked file cache (performance focus) : | tablename = my_table | size allocated = 3168 MB | size used = 2974 MB | rows = 33.120.000 I reconfigure my test instance with only 40MB of 4k pages …
Which tables are compressed tables ?
I need to uncompress all compressed tables in a database. How can i list which tables are compressed ? Regards Jimmy Jonsson / Plexor AB…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Is compression feature available on 11.50 at no co
Um, NO, the Storage Optimization feature, or table data compression, is NOT free with the Ultimate Edition (used to be called Enterprise Edition) it is an extra cost add-on. It IS included with the Ultimate Warehouse Edition which also includes the Informix Warehouse Accelerator …
11.70.FC6 linux load from seems afwully slow.
Hi Superboer, My 2c worth. Loading through the buffer cache is very in-efficient. With one record per page, the engine must do this for each row: 1. read the page into the buffer cache 2. write the page before image to the physical log 3. write the page back to disk Other tool…
Index reduction
Jim, I would say your assumption is correct regaring missing rows.. other than to say if it did contain missing rows it would be known as a corrupted index. that said, Informix does not compress index pages in the sense it compresses data pages, it instead merges together near …
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,…
Informix Performance Tuning Technical Training Day - Next Thursday, November 8th 2012
The Washington Area Informix User Group will be hosting a one day Informix Performance Tuning Technical Training Day. Last chance to register. We have limited space and there are only a few spaces left. Please register at the link below. Date and Time: Thursday, Nove…
Informix Performance Tuning Technical Training Day - Thursday, November 8th 2012
The Washington Area Informix User Group will be hosting a one day Informix Performance Tuning Technical Training Day. We have limited space and there are still few spaces available. Please register at the link below. Date and Time: Thursday, November 8th, 2012, 9:00am …
execute function estimate compression
Hi I have run compressions on many tables in my database, always running them from the sysadmin database using dbaccess. However, I have a table which is owned by a different user (sapr3), and I cannot get the following to work . EXECUTE FUNCTION task("table estimate_compressio…
Informix Performance Tuning Technical Training Day - Thursday, November 8th 2012
The Washington Area Informix User Group will be hosting a one day Informix Performance Tuning Technical Training Day. Date and Time: Thursday, November 8th, 2012, 9:00am to 4:00pm Location: Advanced DataTools Corporation, 4216 Evergreen Lane, Suite 136 Annandale, V…
Informix Performance Tuning Technical Training Day - Thursday, November 8th 2012
The Washington Area Informix User Group will be hosting a one day Informix Performance Tuning Technical Training Day. Date and Time: Thursday, November 8th, 2012, 9:00am to 4:00pm Location: Advanced DataTools Corporation, 4216 Evergreen Lane, Suite 136 Annandale, VA …
CDR_NIFCOMPRESS setting for ER
It is similar to what happens with other compression programs. Try this: unload the data you plan to replicate into a directory. At least 100MB but I like a GB so there is a nice long runtime. Run gzip on the file at each of its compression rates(1-9) to different files. Using ti…
Informix Performance Tuning Technical Training Day - Thursday, November 8th 2012
The Washington Area Informix User Group will be hosting a one day Informix Performance Tuning Technical Training Day. Date and Time: Thursday, November 8th, 2012, 9:00am to 4:00pm Location: Advanced DataTools Corporation, 4216 Evergreen Lane, Suite 136 Annandale, VA 22…
Compression
IDS 11.70.fc3 Aix 6.1 I have a table that is currently 2.3B rows. The table is fragmented over 39 partitions in 13 dbspaces. I want to compress the table in order to get an idea of the savings we would get from doing this. When I tried running the compress function I got an erro…
rowid
ROWID should ONLY be used within the context of a single transaction. Even then, if the table's contents are volatile, ie unlike your question has lots of deletes and inserts, there is a danger. You should ABSOLUTELY never store the rowid from one table in another as a kind of fo…
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 …
FAILED: table estimate_compression
Good afternoon, I'm trying to run 'table estimate_compression' for some tables, but i'm getting this error: (expression) est curr change partnum table ----- ----- ------ ---------- ----------------------------------- FAILED: table estimate_compression baandb:informix.twhinh22…
ontape level zero format
I am wanting to do custom data compression on the file.…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Archecker + STDIO
Hi there! Does anybody know if there is a way to perform a table level restore using archecker + ontape with a backup file compressed (I'd like to use STDIO + a pipe for that...) Thanks in advance, Alberto Pessonio.…
Performance if storing files in DB
Hi, you could try to modify the column type to blob (should be possible using alter table) and then modify the storage using alter table put column into sdbspace. Maybe this helps (would have some load on the server, but is in-place). Marcus -----Original Message----- From: Al…
Informix User Group Meeting, Training and FREE Hands-on-Lab - March 10-11
Washington Area Informix User Group events! -------------------------------------------- This is less then two weeks away. Folks, the Lab is full, but if you register we can put you on a wait-list. We have lots of room for the user group meeting. Please be sure and register if y…
Informix User Group Meeting, Training and FREE Hands-on-Lab - March 10-11
Washington Area Informix User Group events! -------------------------------------------- Folks, we have only 3 spaces left in the FREE Hands on Lab! Please be sure and register if you are planning to attend. We are pleased to announce that Carlton Doe, IBM Informix Technical Spe…
Compression Dictionary
Good Afternoon, AIX 5.3 IDS 11.50.FC5 I am playing with compression and have some questions based on the following scenario. I have a fragmented table and have already compressed all of the data fragments > 2000 rows. Some dbspaces contain multiple fragments. 1. When I select …
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Compression performance
It would be nice to have the command you are running to compress/repack/shrink this table. The table should remain online the entire time for all your applications and users. I am going to assume that you ran the following command: execute function sysadmin:task("table compress…
Re: RSAM
How come INFORMIX-JDBC has examples of RSAM calls like for rs.next()?, and "...IDS is divided into two parts: a storage manager called RSAM, and a query optimization/execution engine implemented on top of RSAM, and has a well-defined, published API...Implementing Index Stride a…
Data Compression
Hi, When I compress a fragment or table (without repack/shrink), Will all the rows be contiguous in the beginning of each extents that it belongs? Will the compress command move all the records from the same extents to the beginning? Thanks, Celso Cabral Coimbra Administrador …
Compression
Hey all, do you have to pay an additional cost to use the data compression in 11.5.FC4? And does anyone have an opionion on how well XML data compresses? Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors A computer lets y…
IDS 11 Compression question
You wrote: We do large scale loads and unloads of tables - i.e. unload Table A on Instance A and load all the data into Table B on Instance B. When peforming an unload from a compressed table the data is in compressed format right? So a subsequent load using that data would need…
Compression and Smart Blobs
IDS 11.50.FC5 AIX 5.3 (4K Page Size) Smart blobs here default to 4k dbspaces (not allowed to specify a size when creating the smart blob space). From Admin Guide, page 10-48: Dynamic Server can compress any combination of data types, because it treats all data to be compressed…
Index Or-ing & And-ing
Version information would be VERY helpful and it's always a good idea to post such info along with your platform details. The current releases of Informix do not use more than one index for any single table in a query. There is not and'ing and or'ing of index search results. Ans…
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 UK Roadshow
We are delighted to invite you to attend the 2009 IDS Roadshow which will be held on 22 – 23 October at IBM Hursley, near Winchester. We've planned an exciting program for all involved in Informix Dynamic Server offering you numerous opportunities to gain fresh, innovative ideas …
Compression/Uncompression Testing
I am testing the compression and uncompression working on building a cost justification of the feature ... Doing this on an Aix v6 P6 ... v11.50.FC5 of the engine ... I have compressed ... repacked .. and shrinked the tables and got very good results ... My question has to do wit…
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…
Catering for slow(er) drive access
Yup.... slower. It *is* a massively shared SAN fabric (attached hosts in the hundreds).... so far we have Sun & EMC working on why the drive performance isn't matching up to the current hardware; apparently I am the first person to notice a problem in this hardware environment (…
Compression
Hi, IDS 11.50.FC4 on solaris 10 I read: New Format for Backup Filters Backups have a new format for version 11.50.xC2 if they are performed with the ontape command using a filter specified by the BACKUP_FILTER configuration parameter. The new backup format is not backwards comp…
Data Compression
Hi, When I compress the data in a table, After Compression, the result mentions that 67% Compression has been achieved, but the size of the table remains the same as before compression? Is there an issue with data compression that it says compression has been done, but have'nt? …
Re: Informix RESIDENT and Solaris 8 and 10 swap usage
On Jun 29, 10:17 am, Koya <chav...@gmail.com> wrote: > On Jun 29, 8:42 am, Eric Rowell <erow...@gmail.com> wrote: > > > > > > > Koya , > > Wish I still had access to my old Solaris systems (past live), this is > > what I remember. > > > There was a change to the mapping a…
Table compression estimate
I am currently on Aix 6.1, IDS 11.50.fc4. I'm running the task 'table estimate_compression' from the sysadmin database. Sometimes it works, and other times I get an error. I'm including the output from a table that worked and one that didn't. I also have included the online log. …
Data Compression
Hi, When we compress any table, where we can find the Compression Dictionary ? Can it be viewed in any data dictionary ? As we need to make sure that Compression Dictionary is available, in case of any failure.…
Compression problems
I am trying to evaluate the compression in my database (using OAT) . I receive the message that the table mon__compression_estimates is not in the database. How I create this table? Anyone can help me? Informix 11.50 FC4 OAT 2.24 database: query failed - Query: SELECT first 1 …
Washington Area Informix User Group News
Folks, We are working on updating our membership database, please take a minute and update you membership under registration on our web site: http://www.iiug.org/waiug -------------------------------------------------------------------- Washington Area Informix User Group meeti…
Re: 11.50.xC4 Compression with workgroup edition?
> Oracle has a paid and a free version. Of course they're completely > different and as you can imagine the free is much more limited. Well - things play out a little differently in Oracle Firstly - Oracle has always had free index compression in it's Enterprise Edition. So for…
Re: 11.50.xC4 Compression with workgroup edition?
On Thu, May 21, 2009 at 1:02 AM, Fernando Nunes <domusonline@gmail.com>wrote: > > Finally a small note. The compression functionality introduced two other > "small" features that may be very useful. Repack and shrink. But that's a > bit > off topic. > > Regards. > Although this…
11.50.xC4 Compression with workgroup edition?
"Ron MacNeil" <macneil.ron@gmail.com> wrote in message news:mailman.688.1242824883.1831.informix-list@iiug.org... >> I can't seem to get any information on whether the new 11.50.xC4 >> compression feature can be used with the Workgroup edition. In OAT I see >> the ominous warnin…
IDS compression estimator
Has anyone gotten this to work properly? I downloaded it and installed it .. when I attempt to connect to the database I get a "file allocation error, iclit09 not found." Tried this on a couple of different PC's. Using SDK 3.5 and 2.7, database server P5 running AIX 6.1. IDS 11.5…
Re: Compression overview...
Compression at last, all those char(30000), char(8000) tables with only 30 characters in should be a bit quicker now. Shame that database already got migrated to SQLServer. :( So are IBM going to post a performance benchmark now? It looks like there was some work done in this ar…
Re: Compression overview...
I've already reported it. Apparently the link is wrong in several ways. First it points to a local directory. Even if you copy/paste it to a browser the IBM website reports and error. I'm not sure if the URL is wrong or simply not there yet... If I have any more info/feedback I'l…
Compression overview...
There's a new white paper about the upcoming compression feature. Guy Bowerman has the link: http://www.ibm.com/developerworks/blogs/page/gbowerman?entry=new_informix_white_papers Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... bu…
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 …
Re: Fastest Informix DBA Contest at the IIUG Conference
David, Sorry you are not going to be there to try it out. > Which of the following are allow? > > SQL Layer > 1. rewriting the SQL Allowed and encouraged as long as the results are the same. > > Server Layer > 1. changing server parameters Allowed and encouraged . > 2 chan…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Re: {Spam?} RE: {Spam?} RE: Creating index with upper function
Ian Michael Gumby wrote: > > > > Date: Sun, 1 Feb 2009 17:27:12 +0000 > > From: obnoxio@serendipita.com > > CC: informix-list@iiug.org > > Subject: Re: {Spam?} RE: Creating index with upper function > > > > Ian Michael Gumby wrote: > > > > > > > > > > Date: Sun, 1 Feb 20…
RE: {Spam?} RE: Creating index with upper function
Ian Michael Gumby wrote: > > > > Date: Sun, 1 Feb 2009 17:27:12 +0000 > > From: obnoxio@serendipita.com > > CC: informix-list@iiug.org > > Subject: Re: {Spam?} RE: Creating index with upper function > > > > Ian Michael Gumby wrote: > > > > > > > > > > Date: Sun, 1 Feb 20…
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.…
dbimport : symbolic links to xxx.unl files
Hi Art, sorry, but this time I have some doubts. Yesterday evening I upgraded from 9.21 to 9.40 and did not yet give the "onmode -BC 1" command. admi:/var/adm >onstat -d IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 13:35:04 -- 315392 Kbytes . . . . . .. . . …
Command for a compressed ontape to filesystem
Hello, I am using IDS11.10 on Solaris 10. Please let me know the command for a compressed ontape to filesystem . Thanking you in advance. Regards, vikas…
Compressed data in logical logs
Hi, I have an issue when I try to look at the data in the logical logs using "onlog -l". I created a simple table: create table t1 (a char(10), b char(10), c char(10)); insert into t1 values ('aaaaaaaaaa','bbbbbbbbbb','cccccccccc'); and I updated column c: update t1 set c='ggg…
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…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Compressing onunloads
Has anyone a technique for compressing onunload output as it's created ... and uncompressing it directly to onload? Similat to the ontape -s -t STDIO facility. thx -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limite…
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…
onbar or ISM thinks disk is full
You may actually be running out of temp dbspace to hold pre-images of pages modified during the archive. Check this during the archive with onstat -d or just add more temp dbspaces to DBSPACETEMP. Art S. Kagel ----- Original Message ----- From: Nestor Gomez Munoz <ids@iiug.org> …
Problem : archecker with compressed archive
Hello Forum, I am experimenting with compressed Level-0 archives which are generated like this : ontape -s -L 0 -t STDIO | gzip -qc > ontape-L0.gz so far so good - to verify the archive or to restore something from it, I don't want to inflate the compressed archive but the comma…
Re: Out of Box Experience for Cheetah.
Martin Fuerderer wrote: > Looking at this (and similar issues) from a different angle ...: > > As a professional at work (in my profession that is) I want control. > And many options, parameters, etc. provide a lot of control (assuming > they work :). That is control for the pro…
Re: Out of Box Experience for Cheetah.
Martin Fuerderer wrote: > Looking at this (and similar issues) from a different angle ...: > > As a professional at work (in my profession that is) I want control. > And many options, parameters, etc. provide a lot of control (assuming > they work :). That is control for the pro…
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: How can I get throughput of informix such as how many query/update operations per second?
HI Zachi, Thans for your reply. I knwo it depends on many factors, however, I want to know how to estimate the expierenced value range of the throughput for an existing system > your server hardware: > CPU performance > number …
How can I get throughput of informix such as how many query/update operations per second?
eagle_jyjh@citiz.net wrote: > Given an database, how can I get the throughput of informix ? > such as how many query/update opertions per seconds informx can > support? > Because my application may submit serveral thousands of database > operations per seconds, > I want to calcul…
question about compression with IConnect
Is anyone aware of any way of compressing the data using IConnect or any middleware? In our current environment, we have quite a few clients connected to our 9.4 IDS via WAN. The windows GUI client application is written in MFC which uses a DLL that connects to the server using …
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Ontape security when shipping tapes
bozon wrote: > > Jonathan Leffler wrote: > > You can use that to avoid the >> intermediate copy to disk which they suggested. Note that when backing >> up, it is imperative to compress before you encrypt. Encrypted data is >> random looking and hence incompressible; > > Do you …
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…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Old Informix media
pan wrote: > Great info. Any significant compatibility issues between 7.22 and 31? You should be able to upgrade and not worry about it. Since you're moving to another machine aswell perhaps the most worry free thing to do would be to dbexport all your databases (depending how …
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.…
Free space...Clustered Data
Urich Ann wrote: > Do many companies use clustering indexes...via table data ordered by a > key (clustered)? > > Is there a performance boost in Informix when the data is clustered -- > and then retrieved via cluster sequence? The performance benefit is marginal - and debatable.…
Re: ER problem---CDRACK cause rootserver crash
Thank you Madison, At the first step I would try to turn off compression ...it's necessary to turn off compression on sco00 or both sco00 and sco01 ?…
Urgent - IDS 9.4 Taking too much resourcess
Hello, sounds like bad access paths (bad SQL optimization). I assume you have checked all IDS parameters to be OK (BUFFERS, OPTCOMPIND)? You can start with update statistics high on the index fields of your most important tables. Furthermore try to identify the sessions/stateme…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Re: Onbar backup problems
Hi, it occured to me also, that this could be a problem. So actually the error then has the meaning that you are somehow running out of some resource. I don't know about Windows, so I've no idea what this resource would be or why this then gets mapped to 154. With BAR_MAX_BACK…
Re: Onbar backup problems
Hi, it occured to me also, that this could be a problem. So actually the error then has the meaning that you are somehow running out of some resource. I don't know about Windows, so I've no idea what this resource would be or why this then gets mapped to 154. With BAR_MAX_BACK…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
compressed indexes
Does anybody know how to lower the number of levels in a btree index ? We have some that have 4 and 5 levels, and I read that is a performance hit. Thanks, Floyd…
compressed indexes
Does anybody know how to lower the number of levels in a btree index ? We have some that have 4 and 5 levels, and I read that is a performance hit. Thanks, ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Work…
compressing indexes
Does anybody know how to lower the number of levels in a btree index ? We have some that have 4 and 5 levels, and I read that is a performance hit. Thanks, ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Work…
HPL and compressed files
Hello all, I am trying to load some very large files (which are compressed) using High Performance Loader. I finally got a load working using HPL and uncompressing through a pipe. It loads the first 3 tables then dies with the error below. I can't uncompress the file(s) before l…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
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: Informix in the SAN environment
Traveller2003 wrote: > > Hi All , > > My question is:- > > Do all the practices mentioned over the years on this new group for > disk layout's hold true still for performance on SAN's? yes _all_ of them! The only difference to keep in mind: On a SAN a volume group or RAID group…
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…
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,…
Why are rollbacks MUCH slower than committed changes?
----LNX_Mon_Mar_08_2004_12:10:03_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello everybody, = can anybody tell me why rollbacks on large transactions (table reorgs/loa= ds) need MUCH more time than they needed until the r…
LVARCHAR + binary data
Hey guys, I have a question related to inserting binary data into LVARCHAR fields. This is what we do: 1) We use Zlib and compress a bunch of data (level 9 compression is been used) 2) The through ESQL/C we pass these data into an SPL through an LVARCHAR field. 3) Then through P…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Re: 9.40 buggy!
Madison Pruet wrote: > > "Neil Truby" <neil.truby@ardenta.com> wrote in message news:<bpisoe$1olu8d$1@ID-162943.news.uni-berlin.de>... > > Can anyone (apart from Jonathan Lefler!) please explain to me why the > > removal of the 2GByte chunk limit is so great? > > I agree that the…
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: High lngspins - IDS 9.30 UC2
On Tue, 21 Oct 2003 20:07:23 -0400, Andrew Hamm wrote: > Art S. Kagel wrote: >> >> Thanks, Andrew. I have not noticed these problems in my own testing but this >> is Clarion City so... Definitely something to investigate going forward. > > In a Clariion world, I doubt you'll s…
Re: Company thought DB2 will be better than Oracle.
Hi Daniel, Code Bases: The code base across Intel, UNIX, Linux (including with the partitioning option) is absolutely the same. There are some differences between the Intel/UNIX/Linux code base and the AS/400 and DB2/390 code bases ... but mostly in areas that a customer would …
Re: Log compression for replication ??
Jack, I'm more concerned with the reasons for the buildup in the TCP send queue than with trying to implement network compression for this. I'd like to see this worked a bit so that we can find out where the bottleneck actually is. The HDR receive thread on the secondary shoul…
Re: Log compression for replication ??
Apart from one site where there was a hardware firewall problem, we've got other sites successfully running HDR over WAN (500 miles between servers), Ok there is a 2MB link. Alexey Sonkin wrote: > > Paul, > > For VPN and WAN - HDR is not a good solution anyway > because of the s…
Re: Log compression for replication ??
Although I agree with others that this is probably not the problem, you could achieve your log compression using socat on each end and make the transport ssh -C or something similar. You'll need to create a new ip address in each host, and point informix on each end to the new lo…
RE: Log compression for replication ??
Paul, For VPN and WAN - HDR is not a good solution anyway because of the synchronous nature of HDR checkpoints. I didn't see any hint to the WAN environment in original message. As for the HDR over LAN, we use it under very high database load and do not see any network problem…
Re: Log compression for replication ??
On Fri, 2003-08-15 at 02:28, Jack A wrote: > As I mentioned a few days ago, replication traffic has spiked up on our > network. It was because of periodic purges that were running. This is > becoming a big issue in my company that we are eating up bandwidth because > online users…
RE: Log compression for replication ??
Jack, It's really hard to believe that HDR can cause a bad network problem. AFAIK the amount of data transferred should be close to the amount of data accumulated in logical logs. How often do Your logical logs switch of what is the size of the logical log on Your system? If Y…
Log compression for replication ??
As I mentioned a few days ago, replication traffic has spiked up on our network. It was because of periodic purges that were running. This is becoming a big issue in my company that we are eating up bandwidth because online users get bloced. Is there any way to have Informix comp…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Index key compression in informix?
Thanks for all the great info I see passing thru this mail list. You guys are great! We have an indexed field where the last 20 characters are always blank Does the index store all these blanks? Can someone tell me if informix will truncate the trailing part of a key that is alw…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
dbexport
David Kulkarni wrote: > On Informix 5.10UC5 running on HPUX10.20 is there a way to overcome the 2 gig limitations and > dbexport a table that is over 3.0 gigs??? you could try dumping the database to a compressed pipe. i have not tried it with dbexport, but i have used i with …
ontape
billybob wrote: > > I need to know if ontape does any compression of data when it writes it > to tape. Is there any way to control compression of data written to > tape? We are using DLT tape drives on Sun Solaris machines. Ontape does not compress. If your tape drives are ca…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Re: How Much space do I really have?
From: "Loven, Isaac" <Isaac.Loven@team.telstra.com> > >An ontape -s to disk takes up 500Megbytes. >If this is so, why does onstat show we have used 49.8% of the disk >????????? Because you have your physical and logical logs in the rootdbspace!!!!!!!!!! >We have a 2 Gig Disk a…
How Much space do I really have?
An ontape -s to disk takes up 500Megbytes. If this is so, why does onstat show we have used 49.8% of the disk ????????? We have a 2 Gig Disk and Informix allocates all of 2 GIG : ROOTNAME rootdbs # Root dbspace name ROOTPATH /users/informix/release/links/…
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…
Re: Strings vs. Numeric in Comparisons
--- "Steve Romankiw" <sromankiw@execrisk.com> > wrote: >As a rule of thumb, I generally define store numeric data as CHAR unless >this value is going to be used within calculations. > >When it comes to performing SELECTs, does the optimizer prefer one over the >other? In others…
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…
Re: Maximum Number Of Extents
Mister Creosote wrote: > > Could someone out there let me know the maximum number of extents > allowable for a non-system table. Our production database is growing > rather more rapidly than expected and we have a number of tables with > in excess of 50 extents. I would very much…
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…
Re: A question for great Informix minds.....
While I appreciate everyone's input on optimal hardware configurations, I can't really change the hardware that will be used. It's already out of the box and running in the computer room. I would be interested in everyone's opinion on the best way to lay out dbspaces given this…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Re: NAS, SAN, ...
Informix position: Tuesday January 25, 11:58 am Eastern Time Company Press Release Network Appliance Delivers First Network-attached Storage Solution for Informix Database Environments NetApp extends solutions to deliver simple, always available appliance architecture to Informi…
Re: DLT IV TAPE
---- you wrote: > Hi > > We have installed DLTIV(35-70GB) Tape with our Sun E450. Could anyone > tell what should be specified in ONCONFIG FILE for the following > parameters to get 70gb compressed data backup. > > TAPEDEV, TAPEBLK, and TAPESIZE Isn't the compression done by th…
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…
Setting up Rootdbs on a raw disk
In article <850qbs$lje$1@news.xmission.com>, Anne Shelp <shean@mcdss.co.gov> writes > >Hi all, > >I got the part about setting up databases on raw files. I understand that using >links is the way to go. What I am >having problems with is actually getting it to work. I created a l…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Re: KAIO with Solaris 2.6
For other people reading this newsgroup the problem has been found. Im using devices created using Solaris's DiskSuite and used as pathname /dev/md/dsk/ etc... This way you use the BLOCK device which are exploited using COOKED mode. For KAIO to work, you must use real raw…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Re: [Q] Dbexport and file space?
> dbexport dbname -t >(compress - > dbname.exp.Z) -b 1024 -s 2000000000 > I see where you are going here, but isn't this a two step process where you will need the 'large' amount of space for a (short) time before the compressions takes place?…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Online index usage in one table query
"Pentti Tietäväinen" wrote: > > This was my first trip to news-groups and I like to thank all the people who > want to discuss and share information (mostly uncommercial basis). I hope I > learn something from online indexing strategy too. Perhaps more than get an > answer to a p…
Re: To RAID or not to RAID? -that is the question...
we were lazy to optimize with the Raid setup and simply used the same config (aha2940 for external devices and cd-rom, a mylex with three channels and six seagate cheetah 18 GB hd) with Raid 5 on the mylex. The disc accesses are extremely fast. No need to do more tuning on our s…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Re: change logging
Benno - Change TAPEDEV and LTAPEDEV temporarily to /dev/null in your $ONCONFIG file. - Execute the following command from your Unix prompt: ontape -s -L 0 -U your_db_name. - Change TAPEDEV and LTAPEDEV back to what they were. The reason onmonitor and ontape are (apparently) ta…
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…
about compression
hi all: I have a field in a table which needs to be 300 long. However, only 5% of all records (half a million of them) has this field filled with actual text. My question is, does informix automatically compress the empty space or do I have to do something to make it compress …
Re: modifying field types Smallint to integers
judah wrote: > > Art S. Kagel wrote: > > > judah wrote: > > > > > > Hi all, > > > > > > I have to modify a field that is currently a small integer to integer > > > (or anything bigger). Everytime I use a query or dbaccess I get a -201 > > > error > > > > > > #finderr -201 A sy…
Re: Informix and HP AutoRaid
Carlson@WHSmith (carlson1@bellsouth.net) wrote: : I guess that's a problem with AutoRaid . . . my data might be under : RAID5 or RAID 1 or RAID 0. : I'm still curious if any one out there is actually using it. It sounds like you need to carefully read over the HP documentation t…
RE: need help with raw devices..
Hazem; Use onstat -d to look at the space you have allocated on your existing chunk. On solaris 2.6 these are expressed as 2K pages. Your UNIX admin should be able to tell you exactly how large each chunk is. If not, try the devinfo command. Here is a sample from my system (Sun …
RE: PDQ
Watson, Paul wrote: [SNIP] > > -----Original Message----- > > From: wisse [mailto:wisse@kabelfoon.nl] > > Sent: 23 March 1999 23:10 > > To: informix-list@iiug.org > > Subject: Re: PDQ > > > > > > Art, > > > > I have PSORT_DBTEMP set to /tmp and that is implemented on > > physical…
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…
Compression of Blobs
Are there any techniques out there to compress the information stored in blobs in order to reduce the amount of storage space used?? Thanks - Geoff…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Access97 Compression??????????????
Could someone please give me some information about a way to compress a huge Access database so that it would still be able to be accessed by visual basic 5.0. I am with a growing software company and we are very close to our newest release of our program. Our problem is that we …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: Infromix & Data Warehousing Solutions
Dough Metacube Query Optimizer is a tool that as you may Know, is targeted to analyze a specific Multidimensional Model, it actually creates a Matrix for every combination from the Model and based on some methodology will determine what will be the TOP N (You tell it how many) A…
Re: Infromix & Data Warehousing Solutions
Doug Johnson wrote: > > Tim, > > Thanks for the info but we're not on the same page. I'm not talking about > the Informix query optimizer (access plan shown by 'explain plan'). There's > tons of info on www.informix.com on that optimizer. I'm talking about the > new MetaCube Ware…
Re: Infromix & Data Warehousing Solutions
Tim, Thanks for the info but we're not on the same page. I'm not talking about the Informix query optimizer (access plan shown by 'explain plan'). There's tons of info on www.informix.com on that optimizer. I'm talking about the new MetaCube Warehouse Optimizer. My understanding…
Re: Infromix & Data Warehousing Solutions
Doug, Like I had mentioned we were in the early stages of using the product. I haven't spent as much time with it enough to know the answers to your questions. I've played around with some of the more general features, but depend on working with a full-time analyst to manage Me…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
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…
BMC DataTools "Data Optimizer": Re: Compression Tools
Well, before DataTools was bought by BMC, they were marketing a product called Data Optimizer which compressed raw Unix disk. Great for databases. I was waiting for product enhancements, but now I can't find any indication that the product even exists anymore... ...Terry. Dav…
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…
Compression Tools
Does anyone know of compression tools for Informix tables? Thanks, D.Cole…
Re: IDS 7.3 Release
>:Has ANYONE got any info on this version, release due imminently? >:compliant tool to run them, also forcing a particular index to a query, >quick >:retrieve of first 5 rows of a large query, case-insensitive searching, but >why > >Optimizer hints is in there, which is pretty co…
Re: IDS 7.3 Release
malc_p@hotmail.com offerred: :Has ANYONE got any info on this version, release due imminently? :compliant tool to run them, also forcing a particular index to a query, quick :retrieve of first 5 rows of a large query, case-insensitive searching, but why Optimizer hints is in the…
Re: Compression with ontape
Gabriela, Hi. I've always used compressed tape devices for Informix archiving, and I've not had any problems. If you have fewer metres of tape used up, I think you probably decrease the risk of getting a dropout on the tape, so you make the backup more secure, not less. It's al…
Re: Compression with ontape
Gabriela Bellani wrote: > > Hi, > We are experiencing with a new tape device (EXABYTE 8500 8mmm Helical > Scan ) for doing ontape. The default mode of operation of the device is > with compression ON. We did a Level 0 archive (18GB to back up) with > ontape in an hour and a h…
Compression with ontape
Hi, We are experiencing with a new tape device (EXABYTE 8500 8mmm Helical Scan ) for doing ontape. The default mode of operation of the device is with compression ON. We did a Level 0 archive (18GB to back up) with ontape in an hour and a half, and the corresponding restore t…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Re[2]: Is Informix Reliable?
Craig.Lanford@alltel.com wrote: > >What are some examples of the optimizer taking bad paths? Just curious >because we upgraded to 7.23 and I want to know what to look out for. >Craig Laford >Mailto:craig.lanford@alltel.com >}We have found the SE product to be unreliable!!!! S…
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…
Re: logging into and changing current dbspaces
Hi, You don't really have the most optimized setup with everything in the rootdbs. However it is the easiest setup I can think of to add space for several databases all at once! All you need to do is create some raw or cooked space, add one or more chunks of storage to the root…
ISDN: BSP - Can I use STAC or MS compression with 95 or NT?
Dear All, I'm new to the ISDN world, and am looking to get my BSP using some kinda data compression. I don't think the BSP supports compression natively, but understand that either NT or 95 with DUN v1.2b will do the compression in software. Is this correct? I am connecting t…
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…
RLL, PLL, and TPC-C: A Useless Thread
Pablo Sanchez (pablo@sgi.com) wrote: > David> if page was faster Informix would use > David> page level locking in TPC tests!! > > Right, sorta. I don't have the FDR for Informix on which > tables were and were not using page level locks. What the > bench points to is that…
Re: Sybase isql converter
Such a converter exist to convert Sybase Transac-SQL to Informix SPL. Ask your local informix representative that will provide you the tools required. I have worked on these tools and successfully converted up to 30+ACU- of our Sybase SQL procedures without need to rewrite them, …
Re: Table performance problem
Bill Weaver wrote: > > I have a performance problem with a certain table once that table exceeds > 1,000,000 rows and only when it exceeds 1,000,000 rows. I've set explain on > and the optimizer is using the proper index. We run update statistics > nightly. The table has only …
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…
Re: Unique or non-unique indices
Kevin Perry wrote: > > MIS Dept <whsmis1@bellsouth.net> wrote: > : Here's an indexing question: > > : I am in the process of adding a few indices to a given table; the table > : itself consists of over 3 million rows. I've had a tendency to just > : 'create index' without though…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Online: Bizarre disk interactions
Chris Jenkins wrote: > > Cosmo Lee wrote: > > > > I'm troubleshooting for a client whose person that configured Online is > > long gone. I noticed that they configured their chunks to point to > > Block-"/dev/dsk/*" devices rather than Character-"/dev/rdsk/*" devices. > > > > An…
Re: Online: Bizarre disk interactions
Hi again Cosmo, I posted a reply to your earlier post but am mailing this as well for expediency. Cosmo Lee wrote: > > I'm troubleshooting for a client whose person that configured Online is > long gone. I noticed that they configured their chunks to point to > Block-"/dev/dsk…
Re: compression
Chuck Ott wrote: > > Is there anyway to use some sort of compression on a database (other than > varchar datatypes). For example, if I have null values in char fields, it > appears that the fields are still the defined length of the char datatype. No. Now it may change, but the…
compression
Is there anyway to use some sort of compression on a database (other than varchar datatypes). For example, if I have null values in char fields, it appears that the fields are still the defined length of the char datatype.…
Re: Machine Configuration
Enio Roncarati wrote: > > Hi everybody. > > We have a version 7.20 of Informix OnLine Dynamic Server on a DEC 2100 with > 3 CPUs, 1 GB of RAM and 60 GB of Storage Array. > > Everything is OK, but we want to find the best configuration for the disk > array. We have 2 disks array o…
Re: compress
Thuc Nguyen wrote: > > Hi Everyone, > > I am with Online 5.03 on HP/OS 9.02. We have 2.3 gig of data base. Since > the 90M tape limits 2 gig per, it will ask for the second tape to mount > when archiving. The DDL2 tape drive of the HP/OS can hold up to 8 gig > compressed. > > My…
Re: compress
At 03:40 AM 2/6/97 GMT, you wrote: >The key words in this question is "up to 8 gig". With compression of any >kind, you are dealing with imprecise quantities. No one will be willing >to state that "it will hold 8 gig compress", rather they will state "up >to". This leaves open…
Re: compress
The key words in this question is "up to 8 gig". With compression of any kind, you are dealing with imprecise quantities. No one will be willing to state that "it will hold 8 gig compress", rather they will state "up to". This leaves open the probability that the stated "8 gig…
compress
Hi Everyone, I am with Online 5.03 on HP/OS 9.02. We have 2.3 gig of data base. Since the 90M tape limits 2 gig per, it will ask for the second tape to mount when archiving. The DDL2 tape drive of the HP/OS can hold up to 8 gig compressed. My question: Can the database be com…
database compressed
Hi Everyone, I am with Online 5.03 on HP/OS 9.02. We have 2.3 gig of data base. Since the 90M tape limits 2 gig per, it will ask for the second tape to mount when archiving. The DDL2 tape drive of the HP/OS can hold up to 8 gig compressed. My question: Can the database be com…
Re: Compression-enabled tape archiving
You are right in noting about the compression form archiving under Informix. What I've performed in various Unix installation is as follows: 1. Create a process to listen at one end of a pipe queue. This process will compress the data (using compress or pack utility) coming out o…
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: FREE ESSAYS!!!!! LOTS AVAILABLE!!
house@direct.ca (HOUSE) wrote: This has nothing to do with COMPRESSION ! By the way ,, Essay-Exchange http://www.sn.no/~johanf/ is much better. Use that instead !…
Re: tbtape -s archives
Dana, We are still writing to just one tape per archive. We used a compressed device driver that DG provides for its tape devices that allows the tape to handle up to 6GB in compressed mode. Alicia -- ********************************************************************** Alic…
Re: Time series database misinformation from Achmal B Chaudhrii
Colin James III (cjames3@ix.netcom.com) belched: : Illustra is an Informix "company", but Achmal is way off the mark with : the DataBlade stuff and time series. No he wasn't. : DataBlade modules are meant to be simpler defined-functions functions : for data types concocted by…
US-FL. West Palm Beach Oracle DBA Position
Position Available. Closes 05-03-96 Palm Beach County, Florida Database Administrator Sal. range $33,739 - $51,176/yr BS Computer Sci., Electronic Engr., Statistics/closely related and 2 yrs. adm & tech work related to the creation and maint. of relational database storage st…
PRESS: INFORMIX, HP and EMC DELIVER LEGACY WAREHOUSE MIGRATION
INFORMIX, HP AND EMC DELIVER A COMPREHENSIVE LEGACY WAREHOUSE MIGRATION PROGRAM Joint Solution Offers Safe, Cost-Effective Alternative to Legacy Warehouses MENLO PARK, Calif., (December 20, 1995) -- Informix Software, Inc. (NASDAQ:IFMX), Hewlett-Packard Company and EMC Corpora…
Re: npused < 0 - alive and well in 7.11.UC1 (fwd)
Tom I could not send this directly to you, so I am posting my response on the List, THANKS for you RESPONSE, YET: We did the tbunload/tbload, the only thing it did was unfrag that tables. I have a program that runs from cron to correct this problem of neg npused, yet for some r…
Compressing log files 'on the fly'
I have seen compress reduce log files 7:1, making a 400MB log file only 60MB in size. (We only use compress when our system is running out of disk space). Because compress requires enough space to hold both the original and compressed file during part of it's cycle, we are gett…
RE: archive compression question
Carlton - I've been using 8mm drives for years. I've used them with and without the on-board h/w compression. I've found that using the H/W compression, not only increases the capacity per tape, but also increases overall through-put/transfer rate. Using an 8mm, with compression…
Re: Does it make sense to have 2 unique keys in one table?
I'm sorry to send you such a mail, nut I d like to get from somewhere informations and sources about compression ... Espaecially Huffman compression .. Thank you steven f95sbo@student.tdb.uu.se…
Call for Paper for practitioner-oriented handbook
**************1996 Handbook of Data Management*************** Call for Papers****************************** Data management is the process of understanding the current and future data needs of an enterprise and making data optimally available to support business operations. It…
Re: CHAR() v. VARCHAR()
In article n6c@cssun.mathcs.emory.edu, mstrothr@informix.com (Michael Strother) writes: >} Our DBA claims that VARCHAR() is much less efficient than CHAR(). Yet, >} he claims that both are fixed length columns with null terminated string >} data. He claims that Informix pads t…
Re: Distributed Join
In article <3ruiln$1gf@ixnews5.ix.netcom.com> fcasas@ix.netcom.com (Francisco Casas) writes: > >Hi Michael, > >First let me apologize for the �Ingres who?� message. But when you >throw down the gauntlet of �why can�t Sybase do this?� it RUBBED me the >wrong way! I hope you are…
Re: Distributed Join
Hi Michael, First let me apologize for the �Ingres who?� message. But when you throw down the gauntlet of �why can�t Sybase do this?� it RUBBED me the wrong way! I hope you are not an ex-Ingres employee or an existing Ingres customer. If you are, my condulences. Both Oracle …
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…
Re: Distributed Join
In article <MAL.95Jun13082128@yavanna> mal@winternet.com "Michael Leo" writes: > This is NOT a trivial product to use. Why don't you explain the > "architecture" of this product. Explain > > 1. Steps needed to set it up > 2. Storage required on the OmniSQL Gateway hos…
Re: Distributed Join
In article <3rjfvi$ebg@ixnews3.ix.netcom.com> fcasas@ix.netcom.com (Francisco Casas) writes: > >Ingres who? Why limit yourself to Ingres when most large companies run >their business on at least 5 different databases. Those databases >generally include DB2, Oracle, Sybase, som…
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?…
compressing tables
I have several very large tables that I would like to shrink (delete the rows that have already been "marked" for deletion"). First of all, is there a way to tell how many of these blank rows exist in a table. Also, are there any tools to shrink tables, rather than modifying it, …
Re: Exb8505C and TBTAPE Params
In <3gm6q5$cfl@explorer.csc.com> wlyle@PROBLEM_WITH_INEWS_DOMAIN_FILE (Wayne Lyle) writes: > Can anyone tell me the correct settings for tbtape using an >EXAbyte 8505C 8mm tape drive. The currect settings are: > TAPEDEV /dev/rst24 > TAPEBLK 126 > TAPESIZE 5000000 > From wha…
Compression and archiving
Hi, Being new to Informix database (I was recently employed by AT&T to work on one), I was wandering if anyone knows whether Informix itself allows the user to switch compression on or off when archiving. I am currently using tape driver EXB-8505 which has the capability to do …
Library to handle tiff format images?
Does anyone know/have of any library of c functions to read, compress, rotate, decompress tiff format images Thanx. email - roberto@tfs.com -- motd => :-)…
VLDB'94 -- 20th International Conference on Very Large Data Bases
VLDB'94 CALL FOR PARTICIPATION 20th INTERNATIONAL CONFERENCE ON VERY LARGE DATA BASES September 12-15, 1994 …
Re: HP compression tape drives
In article <2ok8nu$3ef@emory.mathcs.emory.edu>, bryan@carsinfo.com (Bryan Klopfenstein) says: > >We have several customers running HP 9000/8xx series machines that are >using HP DAT drives with compression for archives. In a recent case in >with Informix Tech Support, the enginee…
HP compression tape drives
We have several customers running HP 9000/8xx series machines that are using HP DAT drives with compression for archives. In a recent case in with Informix Tech Support, the engineer mentioned in passing that this compression is not supported by Informix because it can interfere …
Re: informix Turbo problems
aim1user@shakti.ncst.ernet.in (CITIL ) writes: |> We are using informix Turbu version 1.1 with modificaton from Plexus |> for image support We are facing a lot of problems with the configuration |> that we have We would like to have any information about the following |> configur…
WORDWRAP [COMPRESS]
I've finally got a good opportunity to use the (relatively) new WORDWRAP feature, but as I try it out, I can't seem to get it to do what I want. I want to be able to print this field as multiple lines on a report, so it seems to me that I want WORDWRAP without COMPRESS: "If you …
Introduction of the Server's 5.0 manual set called "New Features."
I have had a couple of people ask about the differences between 4.1 and 5.0. The following describes major new features. --Bill Text from the introduction of the Server's 5.0 manual set called "New Features." ====================================================================…
table compression
answer to Robert Sparks: To compress the table and release the unneeded table space try the following. Alter index indexname to cluster; Alter index indexname to not cluster; The second ALTER statement will remove the CLUSTER flag from the index. See Ya, Bria…