Hi All, I am new to informix and I am struggling with a bug for quite a few days. Whenever I send a report to a printer The last line of every page...

Sanjey

12-23-2009 11:19 PM
Liewkn@gmail.com

I have a program that is closed to us. It inserts a new row, every column of the table. I want one to update the value of one column on the inserted...

Gentian Hila

12-23-2009 04:07 AM
SaltTan

getting the following message on the online.log listener-thread: err = -27003: oserr = 0: errstr = : Internal Communications Error: internal...

brenddie

12-22-2009 12:53 PM
Art Kagel

Does anybody have a query that returns tablename and extentsizes? I haven't quite gotten one to work vs. sysmaster -- it will return 2 rows per...

thomasgsmith

12-21-2009 05:56 AM
Art Kagel

When opening a connection, you can specify a lot of parametesr: Server, Database, Host, UID, DBLOCALE ... But can we set the environment variables...

Martin Thole

12-21-2009 03:16 AM
Habichtsberg, Reinhard

Join us on April 25th - 28th, 2010, for the largest gathering of Informix users, developers and all around enthusiasts. This is the best opportunity...

James Edmiston

12-17-2009 08:00 AM
James Edmiston

Are you looking for education, training and tutorials in computer such as: • Computer Repair Course • Laptop Repair Course • Start Your Own Repair...

Projectdrive

12-17-2009 05:14 AM
Projectdrive

Forgot to add: SCSI errors are not seen any more since few days. -Jose.

Jo

12-16-2009 02:36 PM
david@smooth1.co.uk

Free Project Management Software and Tools "Which Free Project Management Software Provider will come in your mind after the listening Online...

Projectdrive

12-16-2009 06:05 AM
Projectdrive

Are you looking for a Free Project Management Software? Then, stop your search at http://www.project-drive.net/ . They provide Web Based Project...

Projectdrive

12-15-2009 05:49 AM
Projectdrive

Hello, I am in a bit of a jam after trying to use the AGS Server Studio to run a table reorg in HPL express mode. The job failed when trying...

Rob

12-14-2009 04:02 PM
Rob

Hi all, in onconfig I set BUFFERPOOL size=2K,buffers=20000,lrus=8,lru_min_dirty=20.000000,lru_max_dirty=30.000000 .. In the message log I...

Habichtsberg, Reinhard

12-12-2009 12:47 PM
Neil Truby

Hi All, Informix-Server: IBM Informix Dynamic Server Version 10.00.FC8 since upgrading from Informix JDBC-Version 2.21 to 3.5, we somtimes get...

Markus Bschorer

12-10-2009 02:37 PM
Markus Bschorer

Sorry, you're right. I shouldn't have included the entire post. But I'm not sure that it was spam per say. I don't know how they got our e-mail...

Ian Michael Gumby

12-10-2009 01:53 PM
Ian Michael Gumby

Thanks Stuart, That was all that I was asking for. Just a simple clarification. Except for one small detail. The IIUG says that they don't share...

Ian Michael Gumby

12-10-2009 11:30 AM
Ian Michael Gumby

Not to knock AGS, but why pay for something when you can get it for free? I mean what are you paying your DBAs or Sysadmins for? Yeah that's the...

red_valsen@yahoo.com

12-10-2009 09:21 AM
Ian Michael Gumby

<david (AT) smooth1 (DOT) co.uk> wrote http://www-01.ibm.com/support/docview.wss?uid=swg1IC61072 IC61072: PREFORMANCE DEGRADATION DUE TO...

Ian Michael Gumby

12-09-2009 08:25 PM
Ian Michael Gumby

Hi all, last Friday and yesterday we had checkpoints with duration of 290 and 135 seconds. All writing applications were blocked. Typically the...

Habichtsberg, Reinhard

12-09-2009 03:19 PM
david@smooth1.co.uk

And what happens if you drop and recreate the index? Does the size of the extents automatically change to reflect the current table size? By this I...

pow

12-08-2009 09:28 AM
Art Kagel

The Yellowfin BI team have produced a new paper on "Business Intelligence on Mobile devices". Anonymous Download Link...

JTP PR

12-08-2009 05:44 AM
JTP PR

Hi all, How could I determine how much time it would take to create this index? Table has row = 128 million records This one Index is on 3 columns...

Jo

12-05-2009 10:38 AM
Jo

I have an IDS 11 instance on an AIX 5.3 platform. IBM Informix Dynamic Server Version 11.10.FC2 chunk/dbs size free pathname 1 ...

steven_nospam at Yahoo! Canada

12-04-2009 04:30 PM
david@smooth1.co.uk

Hi everybody, Im trying to create a simple store procedure but I get an error when I define the variables. Code: CREATE PROCEDURE scope() DEFINE...

Oskr

12-04-2009 05:17 AM
Jonathan Leffler

If the allocations were spread from the first logical log used during the 'transaction' to the log comprising the LTXHWM percentage of the logs,...

Bispo

12-03-2009 10:30 AM
Art Kagel

Hi, how can i implement secure (encripted) odbc connection from windows clients to informix dynamic servers 11.5 ? I read something about client...

eferreyra

11-30-2009 12:32 PM
Ian Michael Gumby

http://www.theregister.co.uk/2009/11/30/ibm_guardium/ :-P -G _________________________________________________________________ Windows 7: I...

Ian Michael Gumby

11-30-2009 09:10 AM
Ian Michael Gumby

Here's an odd one... We have 4 servers, all Solaris Sparc 64bit --- 2 in site A, 2 in site B Site A contains a Standalone Server S1 and RSS...

Lello, Nick

11-26-2009 06:03 PM
Captain Pedantic

This is something I may have missed trying to read all that now doc in a short time. Question: When you set your server to dynamically create logs...

Jacob Salomon

11-25-2009 08:10 AM
david@smooth1.co.uk

Hi! I have this record in log file. 15:29:32 Maximum server connections 132 15:29:32 Checkpoint Statistics - Avg. Txn Block Time 0.000, #...

padddfoot

11-23-2009 08:59 AM
Art Kagel

first of all i would like to thank. Real situation: five servers with its own database, and independent information. All replicating on a parent...

semex

11-23-2009 08:52 AM
Art Kagel

Because of enhanced network security requirments, I have an informixserver for which I've configured a dbserveralias running onsocssl for users of...

red_valsen@yahoo.com

11-20-2009 03:52 PM
Ian Michael Gumby

Redhat Linux 4 running on Sun 4600 Servers, IDS 11.50.FC5 (6) when GA. We are currently using 8-Dual Core, 2.5 GHz AMD Opteron 8218. We are planning...

Roy Mercer

11-18-2009 09:50 AM
Captain Pedantic

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-18-2009 09:35 AM
Mia

Creating infos file ""...FAILED Happened on my sandbox, I'd been ignoring it because IDS started and worked just fine - just that onstat/onmode...

Jack Parker

11-17-2009 12:51 PM
Jack Parker

OAT version 2.26 on Windows XP SP3 IDS 11.50.FC5DE From Oat, Server Administration, MACH, Find Clusters I am getting the following error: Am I...

Roy Mercer

11-17-2009 09:44 AM
Roy Mercer

http://www.cloudera.com/blog/2009/11/11/hadoop-world-rethinking-the-data-warehouse-with-hadoop-and-hive-from-ashish-thusoo/ You may not believe in...

Ian Michael Gumby

11-17-2009 09:34 AM
Ian Michael Gumby

Fernando, Thank you much! Yes, Guy's blog looks related to the 819 versus1252 problem rather than our specific situation. our scenario would be...

Tom Lehr

11-16-2009 10:00 AM
Tom Lehr

When I am trying to start informix server the following massage apears: shared memory not initialized for INFORMIXSERVER Any idea??????

blaberus

11-15-2009 12:13 PM
blaberus

Fastest Informix DBA Contest II We are planning a Webcast at 4:00pm EST on Monday, November 16th to review the results and share with other Informix...

Lester Knutsen

11-14-2009 01:44 PM
Lester Knutsen

One of our customers asks, about encryption: 4. Do you have any idea what is the performance hit by encrypting either specific columns or the full...

Neil Truby

11-13-2009 10:53 AM
Neil Truby

Does anyone have a query that will provide the Number of pages allocated for each partition in the database, along with the tablename/indexname that...

Floyd Wellershaus

11-12-2009 05:52 PM
Fernando Nunes

Folks, I really made a mistake here and I apologize for it. In reviewing the logs to send to folks I discovered two entries I did notrun. Tatian...

Lester Knutsen

11-12-2009 03:30 PM
Lester Knutsen

No. You have to manually add the new larger logs with onparams then move the current log into one of the new ones, back up the old ones, and...

Kennedy, Randy

11-11-2009 06:59 PM
Art Kagel

Hi all, IDS 11.5, JDBC 3.50 I tried to use connection pooling, without any JNDI-Registrations. IfxConnectionPoolDataSource cpds = new...

Markus Bschorer

11-11-2009 03:03 AM
Markus Bschorer

Can dbaccess use an onsocssl connection? Running IDS 11.50.FC4 on hpux11.23

red_valsen@yahoo.com

11-10-2009 02:33 PM
red_valsen@yahoo.com

IDS 10.00.UC5 I have a production Informix engine with a DBSERVERNAME of engine1 running on server1 backing up to TSM and I have a test Informix...

Andrew Ford

11-09-2009 03:21 PM
Martin Fuerderer

Hi we have got another onbar problem : In the middle of a sbspace-backup , onbar was cut down by a sanswitch-port malfunction and now it looks...

oma

11-09-2009 09:36 AM
theBP

Thanks Christian - I was just composing the below ehen I read your response, much appreciated for the work you're putting in! Well... sorry this...

Malc

11-09-2009 09:35 AM
Ian Michael Gumby

Hi all, does anybody know whether an IDS Level-0 Archive, taken from IDS 10 FC 8 under solaris 9 / 64 bit /sparc, can be restored on a IDS 10 FC 8...

Markus Bschorer

11-09-2009 07:37 AM
Ian Michael Gumby

Hello, We are having trouble deploying the Informix JDBCProxy Servlet, and as we are neither accustomed to tomcat/other servlet server, nor is...

X-RZG-CLASS-ID:X-RZG-AUTH;bh=I7RvXb3VBP4ypvJmGhMuhsWpF5E=;b=OgfII2JSV3tHqC6hQEZJDzr0D/LfvgfawYaIyqrc

11-09-2009 04:06 AM
Holger de Wall