f



KAIO error or warning

IDS 11.5FC6 on RHEL 5.2.

We're getting a warning, or maybe error, each time we start one of the many 
instances on this server.

requested number of KAIO events (16384) exceeds limit (8448). using 8448.

Although the "limit" number varies; sometimes as low as 128.

Any ideas what this is or if it's a worry?

IBM Service Request Number 81212 019 866 refers.

thanks 

0
Neil
1/21/2010 12:52:16 AM
comp.databases.informix 16083 articles. 0 followers. Post Follow

4 Replies
1247 Views

Similar Articles

[PageSpeed] 33

Neil,
I would not worry too much but you should check the following two kerne=
l
parameters:

 "/proc/sys/fs/aio-max-nr"
 "/proc/sys/fs/aio-nr"


Ids would like to use  half of remaining system wide AIO requests... an=
d
not getting it
Do you have other IDS instances running on the same machine or differen=
t SW
using also the AIO interface ?


Kind regards

Sandor

-----------------------------------------------------------------------=
--------------------------------------------------------------------

IBM Deutschland Research & Development GmbH / Vorsitzender des
Aufsichtsrats: Martin Jetter
Gesch=E4ftsf=FChrung: Dirk Wittkopp
Sitz der Gesellschaft: B=F6blingen / Registergericht: Amtsgericht Stutt=
gart,
HRB 243294


                                                                       =
    
             "Neil Truby"                                              =
    
             <neil.truby@arden                                         =
    
             ta.com>                                                   =
 To 
             Sent by:                  informix-list@iiug.org          =
    
             informix-list-bou                                         =
 cc 
             nces@iiug.org                                             =
    
                                                                   Subj=
ect 
                                       KAIO error or warning           =
    
             01/21/2010 01:52                                          =
    
             AM                                                        =
    
                                                                       =
    
                                                                       =
    
                                                                       =
    
                                                                       =
    




IDS 11.5FC6 on RHEL 5.2.

We're getting a warning, or maybe error, each time we start one of the =
many

instances on this server.

requested number of KAIO events (16384) exceeds limit (8448). using 844=
8.

Although the "limit" number varies; sometimes as low as 128.

Any ideas what this is or if it's a worry?

IBM Service Request Number 81212 019 866 refers.

thanks

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
=


0
Sandor
1/21/2010 8:42:48 AM
http://www.ibm.com/developerworks/data/library/techarticle/dm-0503szabo/

When you start the first instance on the server it takes half of what
is setup on the os.
Each instance after that will also try and take half of the max the OS
has defined.

For each instance set KAIOON to the number of KAIO queues for each,
rather than letting Informix take half.

Thanks
Roy


On Jan 20, 7:52=A0pm, "Neil Truby" <neil.tr...@ardenta.com> wrote:
> IDS 11.5FC6 on RHEL 5.2.
>
> We're getting a warning, or maybe error, each time we start one of the ma=
ny
> instances on this server.
>
> requested number of KAIO events (16384) exceeds limit (8448). using 8448.
>
> Although the "limit" number varies; sometimes as low as 128.
>
> Any ideas what this is or if it's a worry?
>
> IBM Service Request Number 81212 019 866 refers.
>
> thanks

0
Roy
1/21/2010 1:38:07 PM
"Sandor Szabo" <sandor.szabo@de.ibm.com> wrote in message 
news:mailman.480.1264063411.6236.informix-list@iiug.org...
Neil,
I would not worry too much but you should check the following two kernel
parameters:

 "/proc/sys/fs/aio-max-nr"
 "/proc/sys/fs/aio-nr"

>> Ids would like to use  half of remaining system wide AIO requests... and
not getting it
Do you have other IDS instances running on the same machine or different SW
>using also the AIO interface ?


If I look at what it was:
cat /proc/sys/fs/aio-max-nr
65536

Then increase it twenty-fold:
echo 1280000 > /proc/sys/fs/aio-max-nr

First instance
OK
Second instance
10:46:27  IBM Informix Dynamic Server Version 11.50.FC6     Software Serial 
Number AAA#B000000
10:46:28  requested number of KAIO events (320000) exceeds limit (160000). 
using 160000.
10:46:29  IBM Informix Dynamic Server Initialized -- Shared Memory 
Initialized.
Third instance
10:47:57  requested number of KAIO events (320000) exceeds limit (40000). 
using 40000.
10:47:58  Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
Fourth instance
10:49:36  Physical Recovery Started at Page (2:2775).
10:49:36  requested number of KAIO events (320000) exceeds limit (10000). 
using 10000.
10:49:37  Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.

etc.

I can't see a pattern to this that will tell me what would be a suitable 
setting. 

0
Neil
1/21/2010 5:10:00 PM
--0015174c3860759ce0047db052c7
Content-Type: text/plain; charset=ISO-8859-1

You can control how much KAIO resource each instance requests with the
KAIOON environment variable.  If you set:

export KAIOON=20000

then that instance will only request 20000 concurrent IO blocks from the
OS.  With the default, 65535, the first server would have requested 32767,
so if you want each server to get that many KAIO blocks, set KAIOON to 32767
and set aio_max_ar to 32767 * 2 * <# instances> or greater.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)

See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference.  Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Thu, Jan 21, 2010 at 12:10 PM, Neil Truby <neil.truby@ardenta.com> wrote:

>
> "Sandor Szabo" <sandor.szabo@de.ibm.com> wrote in message
> news:mailman.480.1264063411.6236.informix-list@iiug.org...
> Neil,
> I would not worry too much but you should check the following two kernel
> parameters:
>
>  "/proc/sys/fs/aio-max-nr"
>  "/proc/sys/fs/aio-nr"
>
> >> Ids would like to use  half of remaining system wide AIO requests... and
> not getting it
> Do you have other IDS instances running on the same machine or different SW
> >using also the AIO interface ?
>
>
> If I look at what it was:
> cat /proc/sys/fs/aio-max-nr
> 65536
>
> Then increase it twenty-fold:
> echo 1280000 > /proc/sys/fs/aio-max-nr
>
> First instance
> OK
> Second instance
> 10:46:27  IBM Informix Dynamic Server Version 11.50.FC6     Software Serial
> Number AAA#B000000
> 10:46:28  requested number of KAIO events (320000) exceeds limit (160000).
> using 160000.
> 10:46:29  IBM Informix Dynamic Server Initialized -- Shared Memory
> Initialized.
> Third instance
> 10:47:57  requested number of KAIO events (320000) exceeds limit (40000).
> using 40000.
> 10:47:58  Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
> Fourth instance
> 10:49:36  Physical Recovery Started at Page (2:2775).
> 10:49:36  requested number of KAIO events (320000) exceeds limit (10000).
> using 10000.
> 10:49:37  Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
>
> etc.
>
> I can't see a pattern to this that will tell me what would be a suitable
> setting.
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>

--0015174c3860759ce0047db052c7
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

You can control how much KAIO resource each instance requests with the KAIO=
ON environment variable.=A0 If you set: <br><br>export KAIOON=3D20000<br><b=
r>then that instance will only request 20000 concurrent IO blocks from the =
OS.=A0 With the default, 65535, the first server would have requested 32767=
, so if you want each server to get that many KAIO blocks, set KAIOON to 32=
767 and set aio_max_ar to 32767 * 2 * &lt;# instances&gt; or greater.<br>

<br>Art<br><br clear=3D"all">Art S. Kagel<br>Advanced DataTools (<a href=3D=
"http://www.advancedatatools.com">www.advancedatatools.com</a>)<br>IIUG Boa=
rd of Directors (<a href=3D"mailto:art@iiug.org">art@iiug.org</a>)<br><br>S=
ee you at the 2010 IIUG Informix Conference<br>

April 25-28, 2010<br>Overland Park (Kansas City), KS<br><a href=3D"http://w=
ww.iiug.org/conf">www.iiug.org/conf</a><br><br>Disclaimer: Please keep in m=
ind that my own opinions are my own opinions and do not reflect on my emplo=
yer, Advanced DataTools, the IIUG, nor any other organization with which I =
am associated either explicitly, implicitly, or by inference. =A0Neither do=
 those opinions reflect those of other individuals affiliated with any enti=
ty with which I am affiliated nor those of the entities themselves.<br>

<br>
<br><br><div class=3D"gmail_quote">On Thu, Jan 21, 2010 at 12:10 PM, Neil T=
ruby <span dir=3D"ltr">&lt;<a href=3D"mailto:neil.truby@ardenta.com">neil.t=
ruby@ardenta.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote"=
 style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.=
8ex; padding-left: 1ex;">

<br>
&quot;Sandor Szabo&quot; &lt;<a href=3D"mailto:sandor.szabo@de.ibm.com">san=
dor.szabo@de.ibm.com</a>&gt; wrote in message<br>
news:mailman.480.1264063411.6236.informix-list@iiug.org...<br>
Neil,<br>
I would not worry too much but you should check the following two kernel<br=
>
parameters:<br>
<br>
=A0&quot;/proc/sys/fs/aio-max-nr&quot;<br>
=A0&quot;/proc/sys/fs/aio-nr&quot;<br>
<br>
&gt;&gt; Ids would like to use =A0half of remaining system wide AIO request=
s... and<br>
not getting it<br>
Do you have other IDS instances running on the same machine or different SW=
<br>
&gt;using also the AIO interface ?<br>
<br>
<br>
If I look at what it was:<br>
cat /proc/sys/fs/aio-max-nr<br>
65536<br>
<br>
Then increase it twenty-fold:<br>
echo 1280000 &gt; /proc/sys/fs/aio-max-nr<br>
<br>
First instance<br>
OK<br>
Second instance<br>
10:46:27 =A0IBM Informix Dynamic Server Version 11.50.FC6 =A0 =A0 Software =
Serial<br>
Number AAA#B000000<br>
10:46:28 =A0requested number of KAIO events (320000) exceeds limit (160000)=
..<br>
using 160000.<br>
10:46:29 =A0IBM Informix Dynamic Server Initialized -- Shared Memory<br>
Initialized.<br>
Third instance<br>
10:47:57 =A0requested number of KAIO events (320000) exceeds limit (40000).=
<br>
using 40000.<br>
10:47:58 =A0Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.=
<br>
Fourth instance<br>
10:49:36 =A0Physical Recovery Started at Page (2:2775).<br>
10:49:36 =A0requested number of KAIO events (320000) exceeds limit (10000).=
<br>
using 10000.<br>
10:49:37 =A0Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.=
<br>
<br>
etc.<br>
<br>
I can&#39;t see a pattern to this that will tell me what would be a suitabl=
e<br>
setting.<br>
<div><div></div><div class=3D"h5"><br>
_______________________________________________<br>
Informix-list mailing list<br>
<a href=3D"mailto:Informix-list@iiug.org">Informix-list@iiug.org</a><br>
<a href=3D"http://www.iiug.org/mailman/listinfo/informix-list" target=3D"_b=
lank">http://www.iiug.org/mailman/listinfo/informix-list</a><br>
</div></div></blockquote></div><br>

--0015174c3860759ce0047db052c7--
0
Art
1/21/2010 5:48:55 PM
Reply:

Similar Artilces:

How to copy a sun-database in one informix database to another informix database?
Hi, Sorry I am not an informix dba, and I was faced to copy a sub-database(sorry I don't know the clear name of such concept, as informix is like sql-server, which used multiple database) from one informix database system to another informix database. I know in oracle, we can use transportable tablespace, copy the datafile and transport the metadata, and do something else. How can I do it in informix then? Is there document which talk about the detail step? Thanks It would really help if you knew the versions of the Informix databases. Assuming Informix IDS 7.x or IDS...

Informix KAIO Error
Hi people !! I have a problem with Informix 7.31 with HP-UX 11i, during the KAIO initialization. Following the online.log Tue Jul 4 08:57:38 2006 08:57:38 Event alarms enabled. ALARMPROG = '/sgbd/informix/etc/log_full.sh' 08:57:44 DR: DRAUTO is 0 (Off) 08:57:44 Informix Dynamic Server Version 7.31.UC7 Software Serial Number AAC#J955102 08:57:44 Can't open /dev/async. KAIO disabled 08:57:44 Assert Failed: kaiothread() ERROR 08:57:44 Informix Dynamic Server Version 7.31.UC7 08:57:44 Who: Session(0, @, 0, 0) Thread(54, kaio, 0, 8) File: kaio.c Line: 2141 08:57:44 stack trace for pid 3757 written to /sgbd/informix/af.41e57b7 08:57:46 See Also: /sgbd/informix/af.41e57b7 08:57:46 kaio.c, line 2141, thread 54, proc id 3757, kaiothread() ERROR. 08:57:46 PANIC: Attempting to bring system down Anybody can help me, please !!! Tks, Eduardo cboccio@yahoo.com.br wrote: > Hi people !! > > I have a problem with Informix 7.31 with HP-UX 11i, during the KAIO > initialization. > Following the online.log > > Tue Jul 4 08:57:38 2006 > > 08:57:38 Event alarms enabled. ALARMPROG = > '/sgbd/informix/etc/log_full.sh' > 08:57:44 DR: DRAUTO is 0 (Off) > 08:57:44 Informix Dynamic Server Version 7.31.UC7 Software Serial > Number AAC#J955102 > 08:57:44 Can't open /dev/async. KAIO disabled > 08:57:44 Assert Failed: kaio...

Error executing remote system command on an AIX Informix database from an NT Informix Server
Dear All, I realise there are many queries and answers already posted on a similar topic, but none seem to be able to get this working. I have two informix servers, one on Windows NT and one on AIX 4.3. Informix NT (7.31) Informix AIX (7.xx) I have a stored procedure on the unix box with a system command SYSTEM '/usr/bin/ksh /usr/bin/env > /tmp/mylog' I have set up the trust, so that I can connect to the AIX instance as informix from the NT server. I connect from the NT server to the AIX instance as informix and execute the procedure. I get the followin...

RE: Informix KAIO Error
Call support?=20 -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of cboccio@yahoo.com.br Sent: Wednesday, July 05, 2006 5:55 PM To: informix-list@iiug.org Subject: Re: Informix KAIO Error TBP, I done the steps that you sent me (set KAIOON=3D1 and install asyncdsk), but the error still the same What can I do to solve this problem ? Tks, Regards, Eduardo TBP escreveu: > cboccio@yahoo.com.br wrote: > > Hi people !! > > > > I have a problem with Informix 7.31 with HP-UX 11i, during the KAIO=20 > > initialization. > > Following the online.log > > > > Tue Jul 4 08:57:38 2006 > > > > 08:57:38 Event alarms enabled. ALARMPROG =3D=20 > > '/sgbd/informix/etc/log_full.sh' > > 08:57:44 DR: DRAUTO is 0 (Off) > > 08:57:44 Informix Dynamic Server Version 7.31.UC7 Software Serial > > Number AAC#J955102 > > 08:57:44 Can't open /dev/async. KAIO disabled > > 08:57:44 Assert Failed: kaiothread() ERROR > > 08:57:44 Informix Dynamic Server Version 7.31.UC7 > > 08:57:44 Who: Session(0, @, 0, 0) > > Thread(54, kaio, 0, 8) > > File: kaio.c Line: 2141 > > 08:57:44 stack trace for pid 3757 written to=20 > > /sgbd/informix/af.41e57b7 > > > > 08:57:46 See Also: /sgbd/informix/af.41e5...

ERROR [HY000] [Informix][Informix ODBC Driver]General error
I have this tables: create table 'informix'.corporatemenuelements ( menuid NVARCHAR(128) not null, caption NVARCHAR(255), type NCHAR(1), address NCHAR(2048) ) extent size 32 next size 32 lock mode row; alter table 'informix'.corporatemenuelements add constraint primary key (menuid) constraint pk_corporatemen269; from .net with odbc data provider i try: String sql =3D "INSERT INTO CorporateMenuElements (MenuId, Caption, Type, Address) VALUES (?, ?, ?, ?)"; DbCommand cmd =3D DB.GetSqlStringCommand(sql); DB.AddInParameter(cmd, "MenuId", DbType.String, menuId); DB.AddInParameter(cmd, "Caption", DbType.String, caption); DB.AddInParameter(cmd, "Type", DbType.String, type); DB.AddInParameter(cmd, "Address", DbType.String, address); Int32 mustBeOne =3D DB.ExecuteNonQuery(cmd); I get: System.Data.Odbc.OdbcException was unhandled Message=3D"ERROR [HY000] [Informix][Informix ODBC Driver]General error." Source=3D"iclit09b.dll" ErrorCode=3D-2146232009 StackTrace: en System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) en System.Data.Odbc.OdbcConnection.Open_EnlistTransaction (Transaction transaction) en System.Data.Odbc.OdbcConnectionOpen.EnlistTransaction (Transaction transaction) en Sys...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html ...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html Scott: #DataBase...

Error out instead of warn, i.e. warning('error', id)
In previous versions of Matlab (at least in R2007a), one could set the status of a warning message to be 'error'. This would cause any function encountering that particular warning to error out instead of just issuing a warning. The behavior was undocumented, and apparently has been removed from more recent versions of Matlab. I only recently discovered the error status possibility, but I found this little technique to be very helpful, both to permanently change certain warnings to errors (such as the inexact match error, 'MATLAB:dispatcher:InexactMatch', which used to d...

.NET TransactionScope -> ERROR [HY000] [Informix][Informix ODBC Driver]General error
Hi using Microsoft Enterprise Library Data access App Block i have this code using (TransactionScope scope =3D new TransactionScope(TransactionScopeOption.Required)) { Database db1 =3D new GenericDatabase( ConnStringBuilder.ConnString, OdbcFactory.Instance); String sql1 =3D "insert into test_text values (51, 'holas1')"; db1.ExecuteNonQuery(CommandType.Text, sql1); scope.Complete(); } The ExecuteNonQuery causes this exception: No se control=F3 System.Data.Odbc.OdbcException Message=3D"ERROR [HY000] [Informix][Informix ODBC Driver]General error." Source=3D"iclit09b.dll" ErrorCode=3D-2146232009 StackTrace: en System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) en System.Data.Odbc.OdbcConnection.Open_EnlistTransaction(Transaction transaction) en System.Data.Odbc.OdbcConnectionOpen.EnlistTransaction(Transaction transaction) en System.Data.Odbc.OdbcConnection.EnlistTransaction(Transaction transaction) en System.Data.Odbc.OdbcConnection.Open() en Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection() en Microsoft.Practices.EnterpriseLibrary.Data.TransactionScopeConnections.GetCo= nnection(Database db) en Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnect...

error in error code database
Hi, &nbsp; I have this error (screenshot provided), which problem is its asking for a password. I think this vi is ni developed. So,&nbsp;I have tried to reinstall labview but still this cannot work. Thanks, for any help. &nbsp; Best regards, Edwin &nbsp; error_code_database_password.zip: http://forums.ni.com/attachments/ni/170/130546/1/error_code_database_password.zip Hi Edwin, The error is most likely caused by opening an LLB in a newer version of LabVIEW than the version it was developed on. It is commonly seen with the "Error Code Database.vi" when upgrading f...

WARNING! WARNING! WARNING!
OK, I posted earlier about uninstalling the NWN2 beta patch because of game/system weirdness. This morning I started my machine and was greeted by a McAfee Personal Firewall tray error message of some kind, and had no internet access. After checking another machine on my network and determining my service wasn't down I decided the simplest thing to do was exercise XP's Restore Point capability. Since Wednesday I'd not only installed the NWN2 beta patch, but also the latest ATI Catalyst Suite and some sort of Java Runtime update I'd been bothered about, so my system ch...

get syntax error when loading data to a informix database
Hi I have ids 9.4 oon windows and csdk. l successfully connected to the database using Visula Basic 6. When l build a string for example SQL1 = "select * from hse2 where field1 matches " & "'a*' and execute using : DbaseConn.Execute (SQL1) it works fine. When l try to load data to a table : SQL1 = "load from " & " 'd:\x.unl' " & " insert into hse2" or SQL1 = "load from 'd:\x.unl' insert into hse2 I get a syntax error -201. Anyone know why. Thanks in advance Umesh "Umesh" <...

Database Warnings & Errors in Virtuoso when opening layout
Hi, A colleague of mine has some weird experience when running Virtuoso. We are using version: icfb.exe version 5.1.0 08/19/2008 01:12 (cicln04) $ 1) After flattening one of the sub-blocks, it hung and suddenly just crashed. The layout cannot be opened at all. 'panic.log' is created but it is empty. My colleague can't remember whether she had a layout of the sub-block she was flattening open in a different window. ----------------------------------------------------------------------------------------------------------------------------------- *WARNING* couldn't build VM t...

Re: get syntax error when loading data to a informix database
Umesh wrote: > Hi > I have ids 9.4 oon windows and csdk. l successfully connected > to the database using Visula Basic 6. > When l build a string for example > SQL1 = "select * from hse2 where field1 matches " & "'a*' > and execute using : DbaseConn.Execute (SQL1) it works fine. > > When l try to load data to a table : > SQL1 = "load from " & " 'd:\x.unl' " & " insert into hse2" > or > SQL1 = "load from 'd:\x.unl' insert into hse2 > > I get a synta...

[OdbcException: ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Transaction not available.]
I 've connected to informix database. i want to begin an odbc transaction in my C# code. then the error occured. ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Transaction not available. pls help me, How can i solve this problem? is it needed to especial setting in the informix db? thanks alot, for the problem, i set the informix : no log--> log and the problem 's solved. Mahta On 31 Dec 2006 23:05:58 -0800, Mahta <mahbahj@gmail.com> wrote: > I 've connected to informix database. i want to begin an odbc > transaction in my C# code. then the error occured. > > ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Transaction not > available. > > pls help me, How can i solve this problem? > is it needed to especial setting in the informix db? Informix databases can be created with support for transactions - not recommended, but possible. It appears that your database is one such - so any operations that use transactions are going to fail like that. Fix - don't use transactions in C#, or add transactions to the database. For the latter, read the manuals (ontape, onbar). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ ...

Re: get syntax error when loading data to a informix database #2
Umesh said: > Hi > I have ids 9.4 oon windows and csdk. l successfully connected > to the database using Visula Basic 6. > When l build a string for example > SQL1 = "select * from hse2 where field1 matches " & "'a*' > and execute using : DbaseConn.Execute (SQL1) it works fine. > > When l try to load data to a table : > SQL1 = "load from " & " 'd:\x.unl' " & " insert into hse2" > or > SQL1 = "load from 'd:\x.unl' insert into hse2 > > I get a syntax error -201. Anyone know why. Because the LOAD statement is specific to DBACCESS, not SQL. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list ...

Re: get syntax error when loading data to a informix database #3
The second form should work. What are you using as a field delimiter? Informix defaults to a pipe "|". If you are using some other character you will need to include the delimiter phrase ... LOAD FROM "pathname" [DELIMITER "char"] INSERT INTO table-name commbtp@lineone.n et (Umes...

Error in error code database.vi
Hi.... I am working on a programm which was developed in Version 6.1. I am currently working with Version 7.1 and I get the errors in the following VI; -General Error Handler -Error Code Database General Error Handler CORE I've been trying to solve my problem with the following posts; http://digital.ni.com/public.nsf/websearch/A87185BF42937DE986256CB0006CA387= ?OpenDocument http://groups.google.de/group/comp.lang.labview/browse_thread/thread/fb2c52= fd4f089517/75d7b00ac66509fb?q=3Derror+code+database&rnum=3D1#75d7b00ac66509= fb It did work the first time after Reinstalling Version ...

informix databases (dbaaccess)(Informix-SE)
How to get the informix databases. i tried to get from net but i didnot get . the ibm site is asking for password. how can we get it . i am asking this because we can de database acess from unix shell scrpting using informix databses. do any one know how to install and download the dbaaccess or informix SE. uday <kariudaykiran@yahoo.co.in> wrote: > How to get the informix databases. i tried to get from net but i didnot > get . the ibm site is asking for password. Type your password. > how can we get it . i am asking this because we can de database acess > from unix shell ...

commenting errors flagged as warnings instead of errors
I'm using Visual C++ on Windows Vista. Being "only human", I sometimes use ***************************************/ to underline a section of code instead of the correct /************************************/ I'm surprised by the fact that my mistake generates a warning rather than an error. How does the compiler understand *************************/ ? Thanks On Apr 8, 10:26=A0pm, Comp1...@yahoo.co.uk wrote: > I'm using Visual C++ on Windows Vista. > Being "only human", I sometimes use > ***************************************/ =A0 to ...

Testing Error Handling for Unusual Database Errors
Have you ever had a piece of database code in which you wanted to test every probable and improbable error condition that might occur? For example, suppose you had this code and wanted to make sure that the error handling did the right thing when an InstantiationException occurred: ---------------------------------------------------------------------------------------------------------------- /* Load the JDBC driver. */ try { Class.forName(this.jdbcDriverName).newInstance(); } catch (ClassNotFoundException cnf_excp) { String msg = &quo...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Web resources about - KAIO error or warning - comp.databases.informix

Storm Warning (2007 film) - Wikipedia, the free encyclopedia
Rob and Pia, a couple who are out for a day of sailing become lost in a heavy storm and end up on a desolate island. They come across a barn ...

WARNING: Malware Targets Brazil’s Facebook Users
Microsoft discovered malware aimed at obtaining Facebook users’ login information and taking over their accounts, and the new malware strain, ...

Malaysia says it's in the dark on DFAT's Kuala Lumpur travel warning
... that terrorists may be planning attacks in the Malaysian capital Kuala Lumpur but never told Malaysian police what prompted the warning. "I ...

Think carefully, Malcolm: John Howard's warning to Turnbull on double dissolution election
Former prime minister John Howard has warned Malcolm Turnbull about the dangers of unusually long election campaigns.

Terror attack warning for Indonesia
... be in the “advanced stages of preparing attacks” in Indonesia and travellers are urged to take precautions, just days after a similar warning ...

Think carefully, Malcolm: John Howard's warning to Turnbull on double dissolution election
Former prime minister John Howard has warned Malcolm Turnbull about the dangers of unusually long election campaigns.

Think carefully, Malcolm: John Howard's warning to Turnbull on double dissolution election
[ The Age - Text-only index ] Think carefully, Malcolm: John Howard's warning to Turnbull on double dissolution election Date: February 27 2016 ...

Think carefully, Malcolm: John Howard's warning to Turnbull on double dissolution election
Former prime minister John Howard has warned Malcolm Turnbull about the dangers of unusually long election campaigns.

Chicago Weather: Blizzard Warning issued for Kankakee County, northwest Indiana
WLS-TV Chicago Weather: Blizzard Warning issued for Kankakee County, northwest Indiana WLS-TV A winter storm will bring heavy, wet snow and ...

Updates: Tornado warnings in Alabama; new watch issued
AL.com Updates: Tornado warnings in Alabama; new watch issued AL.com 7 p.m.: The National Weather Service in Mobile has gotten a report of ...

Resources last updated: 2/28/2016 2:07:33 AM