Oninit&reg; Archive

Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1 We have several application servers and LDAP based authentication. How to prevent a user's connections from any but the application servers' IPs? ------------------------------ Sincerely, Dennis -------------------------…

Defragment sbspace

Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to defragment (repack) a sbspace after plenty LOBs been deleted? ------------------------------ Sincerely, Dennis ------------------------------…

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 ------------------------------…

INT to SERIAL in-place alter

Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------…

Innovator-C download?

https://www.ibm.com/resources/mrs/assets/packageList?source=ifxids&lang=en_US Scott Pickett IBM Informix WW Tech Sales IBM Informix WW Cloud Tech Sales IBM Informix WW Informix Warehouse Accelerator Tech Sales IBM Strategic Partnerships Boston, Massachusetts USA spickett@us.ibm.c…

where can I download informix 12.10FC7

ZhiWei Cui Please contact me via the email address on my signature below. Scott Pickett IBM Expert Labs Informix WW Tech Sales IBM Expert Labs Informix WW Cloud Tech Sales IBM Expert Labs Informix WW Informix Warehouse Accelerator Tech Sales Boston, Massachusetts USA spickett@us.…

I Still Haven't Found What I'm Looking For

Zok, I have it for you. See me on usual channels and I'll get to you. Scott Pickett IBM Expert Labs Informix WW Tech Sales IBM Expert Labs Informix WW Cloud Tech Sales IBM Expert Labs Informix WW Informix Warehouse Accelerator Tech Sales Boston, Massachusetts USA spickett@us.ibm.…

The version of Informix vNext

Art is correct. The version number for Vnext has not been decided yet. Scott Pickett IBM Informix WW Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales ICIAE IBM Expert Labs IBM Informix WW Informix Warehous…

Informix - Connection Manager + TLS A Major Annoyance

Thanks Tom. Let's see what happens ..... Scott Pickett IBM Informix WW Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales ICIAE IBM Expert Labs IBM Informix WW Informix Warehouse Accelerator Sales IBM Expert…

Happy New Year

To All. I wish all of you all of the best in 2022. Have a Happy New Year in 2022. Scott Pickett IBM Informix WW Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales ICIAE IBM Expert Labs IBM Informix WW Inform…

Questions about the CVE-2021-44228 vulnerability

I have notified development about this. Scott Pickett IBM Informix WW Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales ICIAE IBM Expert Labs IBM Informix WW Informix Warehouse Accelerator Sales IBM Expert …

CSDK free site and the Developer Edition Free site

Thanks David. Do you know of anyone specifically that would use any of these? We have been asking around privately ....... Scott Pickett IBM Informix WW Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales ICI…

14.10.xC7 is out now

Marc, What version are you looking for and what platform? Scott Pickett IBM Informix WW Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales ICIAE IBM Expert Labs IBM Informix WW Informix Warehouse Accelerator…

discrepancy in how Informix checks disk space

Thanks JC. Scott Pickett IBM Informix WW Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales ICIAE IBM Expert Labs IBM Informix WW Informix Warehouse Accelerator Sales IBM Expert Labs Boston, Massachusetts US…

Rubrik Anyone

It is not something that is known to Informix development I would venture. Use the Informix Primary Storage Manager, which has an unlimited number of threads to backup dbspaces in parallel. It is free and comes with the product. Works with onbar but not ontape as ontape does not …

14.10 user/connection limits?

Innovator C has limits. The limits are not on connections but on memory (8 GB) , total data size stored (50 GB) and cpus (2 core) allowed. Also, there are features in the product not allowed in this edition. It is allowed for production use. Scott Pickett IBM Informix WW Technica…

dbaccess select, tabular output

It is nice to know that Carlton and I are thought of so highly by our Informix Community. As stated by other herein, this particular feature had first come up, for me, at the German IUG in Munich 3 years ago and elsewhere since. Over the past 15 years, there have been a lot of mi…

Fixing awkward-looking view-related queries

John, None that I am aware of. My apologies for your difficulties. To look something like this I presume (I left the upper case/lower case mix for key syntax, could be either or both): create view "ifxcita".vwcitationbalance (i_citation_id, i_accounting_id, i_transactiontype, c_d…

Number of extents

Amith, What version of informix are you running ? Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelerator Sales Boston, Massachusetts USA spickett@us.ibm.com 617…

Unused Indexes

sysmaster:sysactptnhdr.pn_idx_acc_tm - active partitions sysmaster:sysptnhdr.idx_acc_tm - all partitions Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelerator …

How to know what edition is installed ?

Mike Walker

I think that when there is no suffix on the version, that that is Enterprise Edition: IBM Informix Dynamic Server Version 12.10.FC6XC <-- custom build, but no suffix IBM Informix Dynamic Server Version 14.10.FC3 ------------------------------ Mike Walker ------------------------…

Composite Indexing strategy

Is this Baan or some 3rd party ERP package? Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelerator Sales Boston, Massachusetts USA spickett@us.ibm.com 617-899-7…

Dbspace contents

John, oncheck -pe will give you all extents (disk storage allocations of objects), in other words, the entire contents of a dbspace, for all dbspaces. If you have a lot of objects .... this listing will be huge. You can redirect to a filename oncheck -pe > oncheckpe.out for examp…

Informix Innovator-C Edition - License - Cores Limit

This is free to download and use and may be used for production purposes up to the edition limits for memory, CPUs and disk. License is here: http://www-03.ibm.com/software/sla/sladb.nsf/lilookup/9C8443E1CC898A858525847200532D6A?OpenDocument= " 1.1) Processor Limit The Program al…

Are there hidden gotchas w.r.t. moving sysadmin tables?

Gaurav Kumar

Steps to move sysadmin https://www.ibm.com/support/pages/moving-resetting-sysadmin-database-new-dbspace-ibm-informix-dynamic-server-ids ------------------------------ Gaurav Kumar ------------------------------…

Modernize your Data Warehouse and Analytics platform with Netezza Performance Server

Jess Leitsch

Built on Cloud Pak for Data, the Netezza Performance Server is an all-new cloud-native data analytics and warehousing system designed for deep analysis of complex data volumes scaling into petabytes with minimal administration and tuning delivering smart insights at the speed of …

Decrease Size of Root Dbspace

Via onstat -d output, how many chunks are there in the root space presently? If there is only 1, then you are screwed. Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehous…

Fast Recovery after correct shutdown

Paul Watson

When the engine is down –what is the last line in the online.log ? If it is not IBM Informix Dynamic Server Stopped then the engine was not shutdown properly Cheers Paul…

IDS 12 Bug

I've never seen an AQT that did not start with aqt as the first three letters for the object name or as reported by onstat -g aqt. Of course, I can be wrong. Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales …

UPCOMING WEBCAST AMA: Streaming Analytics Using Asynchronous Post Commit Triggers

Thanks Nagaraju Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelerator Sales Boston, Massachusetts USA spickett@us.ibm.com 617-899-7549 33 Years Informix User T…

Informix v14.10.FC3 & client csdk versions

Art is correct. Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelerator Sales Boston, Massachusetts USA spickett@us.ibm.com 617-899-7549 33 Years Informix User T…

25572 error when hostname is used

Please also post Dbservername configuration value and INFORMIXSERVER environment variable value for the server. Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accel…

Best pratice to move IDS and upgrade?

Source O/S and page size, target O/S and page size ? Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelerator Sales Boston, Massachusetts USA spickett@us.ibm.com …

DBACCESS_COLUMNS environment variable

Docfix has been requested and forwarded to the appropriate person. Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelerator Sales Boston, Massachusetts USA spicke…

IDS 11.70 slowdown due to TABLEAU tool

Chanaka Perera

Hi, In this incident TABLEAU connected directly to IDS 11.70 database via ODBC connection. They have proceeds a SELECT query millions of records and we have notices it will affected to other database users. We have noticed this issue only once, is above scenario will slowdown IDS…

Last day in the family?

Farewell and good luck .... for now. Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelerator Sales Boston, Massachusetts USA spickett@us.ibm.com 617-899-7549 33 …

How do I determine which edition I m running?

Carlton Doe

John Miller used to have a web page on this but I'm pretty sure it disappeared. If you execute a onstat - or an oninit -Version and see: IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line ...... this is Advanced Enterprise Edition IBM Informix Dynamic Server Vers…

index exclusivity

When update statistics didn't have enough buckets for the distributions in its basic design, back 11.5 time frame and earlier, customers tried to compensate for the resulting inconsistent query speed by creating lots of composite indexes on specific tables which worked sometimes …

9700: Routine (plus) ambiguous - more than one routine resolves to given signature.

Guess I was not clear enough in my deck as this code was 1-2 slides previous, depending on the deck version. Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelera…

Time-Limited Editions

Development and Test uses only for 90 days. Software stops working at the end of 90 days. Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelerator Sales Boston, M…

ADO - activex data object

DIRK MOOLMAN

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…

New version Informix 14.10

ARNULFO MARTINEZ RUIZ

We are IBM business partners, some clients have the Informix Advanced Workgroup version that includes the Informix Warehouse Accelerator product. In the new version of Informix 14.10 there is no Informix Advanced Workgroup version. My question is what happens with this licensing?…

listener-thread@soc_be.c:3073: err = -25582:

KARTHIK RAJAN

Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…

Informix and speculative execution

Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…

Rovoke insert permission but still can insert

RAFAEL

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…

In memory DB on top of IDS 12.10

Solid is dead (in my opinion it never worked properly). Solid was an in-memory OLTP expansion over IDS. If you want an in-memory Data Warehouse engine, that you can get with the Informix Warehouse Accelerator (IWA) which is included in the Advanced Workgroup and Advanced Enterpr…

12.10.FC6 Mac port released

John Miller iii

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)…

Top 10 Enterprise Database Systems to Consider in

Cool! Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization w…

Informix 12 Unicode

Hi, you may use function ifx_gl_mb_loc_max() in an application to determine, how "wide" a character can be in the current locale. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management Read about the Informix Warehouse Accelerator: …

RSS not working

CLAYTON DAIGLE

-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…

Data warehouse: RedBrick vs IDS

Kern Do

Thank you Fred! You're so informative! > On Jul 25, 2014, at 10:43 AM, "FREDERICK HO" <hof@us.ibm.com> wrote: > > Hi, > > Prior to IDS 11.7, the answer would be Red Brick, hands down. That's > simply because IDS was not designed for data warehousing, like the fact > that Red Bri…

Informix upgrade

CHANATIP LAONGSIRIWONG

Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…

DBA Demand

Hi, yes, IWA has been and is selling well. Obviously, I can't tell absolut numbers ... "a lot of" is a relative measure that I can answer with "yes". IWA has proven to be a good investment for the Informix product family, and we are continuing to enhance IWA with new features …

when use IfxDataReader.GetIfxDateTime to NULL valu

VINCENT

Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…

Question on IWA Requirement

Kern Doe

Can Informix Warehouse Accelerator be installed on Solaris 10 32-bit? Thanks in advance for any feedback. Let's go Green This email contains 100% recycled electrons.…

Performance Tuning Discussion

Hi, I agree with Art Kagel in that performance tuning is a process done in cycles: tune, watch, tune, watch, ... If queries adhere to a star or snowflake schema, you may want to consider using the Informix Warehouse Accelerator to increase performance considerably, without much…

DB_locale or local naming convention

SANDIP SHINDE

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 …

Informix Warehouse Accelerator : user informix can

Franck

Hello, I installed the last version of Informix Warehouse Accelerator. To run the ondwa commands as user informix, I followed the following steps : http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm .acc.doc%2Fids_acc_611.htm But, I have to restart…

Error -556 on @ reference

eferreyra

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 11.70 bootcamp in Leawood, KS

Cindy Lichtenauer

FYI.... IBM is organizing a 3-day Informix 11.7 technical workshop with hands-on labs followed by a 1-day of Informix Warehouse Accelerator workshop in Leawood, KS starting Aug 21st. This boot camp free for consultants, IBM customers and business partners. By attending you'll b…

IWA: Error loading datamart

Hi, > ...<text>An internal processing error occurred > in the stored procedure. Diagnostic information: > An assertion 'false' failed. Additional info: > timeout while reading from > /tmp/iwapipe.d6f14231-40fa-4bf7-8128-3ae05e5377ce > </text>... This message points to a problem…

IWA to connect to Informix on Solarix x86

Carlton Doe

I trust you understand the Warehouse Accelerator binary is completely = separate from the base Informix 11.7 binary, correct? You don't need to = have the source instance or the binary on the same machine or O/S as the = accelerator binary. You can have your source Informix 11.7…

ontape question

Hi, you can rest assured: yes, it does. It's the archive checkpoint, done specifically to make sure that the archive will be physically consistent. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management Read about the Informix Wareh…

Multiple port configuration in the sqlhosts file

Hi Francesco, it's called "Wildcard adressing for TCP/IP connections". It allows the database server on a machine with more than one network interface cards to accept connections from clients on each network interface card (with the same port number). The wildcard in the sqlhost…

Re: Summary: Error on IWA initialization:Assert SE

Martin

Hi, a late response ... and even to the origin of a long thread of e-mails ... Meanwhile we have established, that the described problem is due to changed behaviour of the function tellg(). This new behaviour of tellg() appears with the GNU Standard C++ Library (libstdc++) of v…

Error on IWA initialization:Assert SEND_QUEUE_SIZE

VICENTE

Trying to create a Demo Informix Warehouse Accelerator (IWA) environment. Installation was fine but when trying to execute the ./ondwa start command, Error occurs when starting DWA_CM_node0 and DWA_CM_node1 on QueueHub initialization with error: An assertion 'str.tellg() > 0'…

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…

Fast Informix Data Warehouses with Pentaho Open Source Business Intelligence - Webcast 4/10/2012

Informix Warehouse Accelerator and Pentaho Open Source Business Intelligence - We build FAST databases! Webcast: April 10th at 2:00pm EST Register for the Webcast here In February we hosted a Webcast to demo the Informix Warehouse Accelerator that demonstrated our current bench…

Informix Warehouse Accelerator and Pentaho Open Source Business Intelligence Webcast April 10

Informix Warehouse Accelerator and Pentaho Open Source Business Intelligence Webcast: April 10th at 2:00pm EST Register for the Webcast here! http://www.advancedatatools.com/Informix/IWAWebcasts.html In February we hosted a Webcast to demo the Informix Warehouse Accelerator that…

Informix Warehouse Accelerator and Pentaho Open Source Business Intelligence Webcast - April 10

Folks, Our next Informix Data Warehouse Webcast is: Informix Warehouse Accelerator and Pentaho Open Source Business Intelligence Next Webcast: April 10th at 2:00pm EST Pentaho is the open source business intelligence leader. Thousands of organizations globally depend on Penta…

Informix Warehouse Accelerator Billion rows benchmark demo Webcast on Tomorrow at at 2:00pm EST

Folks, Please join us for our Webcast to show benchmarks with the Informix Warehouse Accelerator tomorrow, February 28th at at 2:00pm EST. I have been using it for over a year and I am continually shocked at how fast it is. In one set of benchmarks it ran 9 hours of queries in…

Informix Warehouse Accelerator billion record demo Webcast on February 28th at at 2:00pm EST

Folks, We decided our old number of 400 million records in the fact table was not big enough so we add a few more transactions to get over a billion records in the fact table for this demo webcast! We are hosting a Webcast to demo the Informix Warehouse Accelerator on February …

enterprise replication time to replicate data

KARL OLIVER

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 …

Informix Warehouse Accelerator Demo Webcast on February 28th at at 2:00pm EST

Folks, We are hosting a Webcast to demo the Informix Warehouse Accelerator on February 28th at at 2:00pm EST. I have been using it for over a year and I am continually shocked at how fast it is. In one set of benchmarks it ran 9 hours of queries in 14 minutes. Please join Mik…

Memory resident database

Actually, it would be the other way around. You would reformat the database for OLTP and let the Warehouse Accelerator handle the OLAP queries in memory. The Warehouse Accelerator can run on the same machine as the server IFF the server is running on Intel Linux (IWA only runs …

RE: Note to IBM... Wuz Re: Informix Warehouse Accelerator Prerequisites

Michael Segel

Awww Fernado wants to play smurt IT Specialist... Junior, I have work to do and don't have time to play or lecture you. I think if you take the time to look up all that you can on Morris' worm you will understand the problems with .rhosts and hosts.equiv. Somehow I doubt you'd g…

Re: Note to IBM... Wuz Re: Informix Warehouse Accelerator Prerequisites

On Mon, Aug 22, 2011 at 7:54 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > Sigh. > > Ok junior, lets get a few things straight. > I love when you call me junior. Not only reminds me that I'm still relatively young and away from the ages when some of us start to get mess…

RE: Note to IBM... Wuz Re: Informix Warehouse Accelerator Prerequisites

Sigh. Ok junior, lets get a few things straight. First, ever since Morris' worm, using .rhosts and /etc/hosts.equiv has been a very bad idea. Back in '88 one of my first tasks post Morris was to write a script that walked all of the user's home directories and report and log wh…

Re: Note to IBM... Wuz Re: Informix Warehouse Accelerator Prerequisites

Ok Ian. I can take some time, since you insist. Writing wrong things to me is irrelevant, but to the community makes a difference. On Mon, Aug 22, 2011 at 1:18 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > > > So it took 20 years for this security hole to get fixed? Kind…

RE: Informix Warehouse Accelerator Prerequisites

And it would be easier to switch to SSH and avoid any issues period. Note: I never worried about 'sniffing' that was your own Fernando. My comments and recommendations still stand. HTH -G > To: red_valsen@yahoo.com > Subject: Re: Informix Warehouse Accelerator Prerequisites >…

Note to IBM... Wuz Re: Informix Warehouse Accelerator Prerequisites

So it took 20 years for this security hole to get fixed? Kinda shows how certain product managers treat security. Oooh Snap! Sorry Jerry, I guess closing security holes just aren't high on the customer's wish list so that they take a back seat to a failed product. Ok, sorry, tha…

Re: Informix Warehouse Accelerator Prerequisites

On Mon, Aug 22, 2011 at 4:08 AM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > IBM/Informix has in the past talked about using .rhosts and the hosts.equiv > . Has this changed? > Why are .rhosts and hosts.equiv bad? You're too young to remember Morris > and his worm... > You…

Re: Informix Warehouse Accelerator Prerequisites

IBM/Informix has in the past talked about using .rhosts and the hosts.equiv . Has this changed? Why are .rhosts and hosts.equiv bad? You're too young to remember Morris and his worm... With respect to external machines, those are either machines outside of your network, or those…

Re: Informix Warehouse Accelerator Prerequisites

As expectable, this is now completely off-topic. But just a few remarks: - Te requisites mention "telnet", the client. - As someone else already pointed out, this is used by a script to talk to one "listener" inside IWA - Whn I mentioned root for packet sniffing, my idea was tha…

RE: Informix Warehouse Accelerator Prerequisites

Fernando, If you have questions about security, talk to Errol Back-Cunningham. Last I heard he was an IT Specialist out of Philly. (If you knew his CV and history, you'll understand why... ;-) With respect to IWA... 1) I think if you replace 'telnet' with 'ssh', you're going t…

Informix Warehouse Accelerator Prerequisites

red_valsen

IBM lists on its website (http://publib.boulder.ibm.com/infocenter/ idshelp/v117/index.jsp?topic=%2Fcom.ibm.acc.doc%2Fids_acc_prereqs.htm) the presence of the woefully insecure Unix utility telnet as a prerequisite for use of the Informix Warehouse Accelerator. It's been nearly …

Over 1,000 days of 24x7 database uptime!

Christian Knappke

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…

Informix error -465 No more memory for locator buf

Martin

Hi, I think the solution to avoid that filename extension is to add an exclamation mark to the end of the given file name. In your example it would look like this: SELECT LOTOFILE(byteblob_blob, '/tmp/test.doc!', 'server') ... Regards, Martin -- Martin Fuerderer IBM Informix …

Setting up HDR- First Time -11.70 Innovator-C

SUNIL PAWAR

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

SUSHANT KODE

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.…

Informix Warehouse Accelerator : Problem with a se

Martin

Hi, SDS connecting to Informix Warehous Accelerator is not yet supported in 11.70.xC2. We plan to support it in the next version (11.70.xC3). Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management Read about the Informix Warehouse A…

Informix Warehouse Accelerator : Memory usage, nec

Franck

Hello, I have some questions to understand well the memory management with the IWA : 1/ How to compute the max available shared memory usage for IWA ? I found this formula with my tests : - MAX Available shared memory = SHMMAX * number of worker nodes If the result is greater…

Informix Warehouse ACcelerator : Problem with the

Franck THOMAS

Hello, I'm testing the new product Informix Warehouse Accelerator. I created a data mart (estimated size :1 Gb) When I want to load this data mart, I have the following error : The mart DM1 can not be stored because the memory of accelerator CORSICA is not sufficient for a mart…

Information Week Webcast on Informix Warehouse Accelerator

Folks, I have been testing the Informix Warehouse Accelerator and am very excited to be participating in this webcast. I had 9 hours of queries run in 15 minutes with the Informix Warehouse Accelerator. On March 29, 2011, IBM announced the availability of the Informix Ultimate …

Tool to estimate the size of an index

JOSé LUIS CABRERA SACCO

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

SHAHZAD SALAM KASI

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…

Informix Dynamic Server Software Downloads

Plugge, Joe R.

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…

OPTCOMPIND and perl

Nog

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…

Informix Dynamic Server Scheduler question

MARKO BATELIÄ

Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …

IDS 9.40 End of Support Imminent

I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…

use stored proc that return multiple columns in a query

brenddie

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

jayasakthi.t@gmail.com

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

Liliana

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

BINDU SIVAJI

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.…

What is IPA abbreviation ?

andrei.onica@gmail.com

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

Tool

Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…

Re: admin tools like PC client

Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…

Error when initializing

06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…

problems with Informix dynamic server 9.4 @ WIndows 2003

Kai Zhu

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…

License Extension

dhaya.snidhi@gmail.com

Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…

Re: Security Vulnerabilities Addressed in Informix Dynamic Server

me

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

Paul Watson

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

mchivaviro@okzim.co.zw

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?

mzahidkilic@gmail.com

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

Curtis Crowson

I am on version IBM Informix Dynamic Server Version 10.00.FC4.…

Re: Informix Dynamic Server 9.30 - Shared Memory

Jonathan Leffler

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

Barry Leb

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

Ronald Schwingel

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

ch

Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…

Re: flagship sunk

Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…

Re: 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

Reddy

Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…

Re: IDS 10 Express Edition

hwang fu via DBMonster.com

Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…

setup Informix Dynamic Server Version 9.40.UC1E1 to linux error

I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…

Informix Dynamic Server information Centre