Re: raw devices in linux (O_DIRECT)
On Thursday 03 March 2005 18:45, you wrote:
> I just installed IDS 10 on linux and this is what I have found:
> - It required glibc 2.3.3 and I was using and old redhat 8, so I upgraded
> linux to Fedora Core 3. Dependency fixed
> - Required libstdc++.so.5, FC3 includes libstdc++.6[.0.3] so make a
> symbolic link (yes I should downgrade but like with curses4 works fine)
Fedora Core 3 delivers compat-libstdc++-8-126.96.36.199.i386.rpm which include the
right link to libstdc++.so.5. If you install the package you can resolve the
dependency ...Re: raw devices in linux (O_DIRECT) #3
Without the library libaio I got
08:32:46 libaio.so.1: cannot open shared object file: No such file or
08:32:46 Please install libaio package. See machine notes.
08:32:46 Warning: Kernel Asynchronous I/O is disabled.
After installing the library and leaving raw devices disabled in kernel
(default), IDS 10 uses KAIO.
[root@tina 0333]# cat /proc/sys/fs/aio-nr
[root@tina ~]# onstat -g iov
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 01:21:20 --
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy...Re: raw devices in linux (O_DIRECT) #6
Martin Fuerderer escribi�:
> in your Machine Specific Notes you should see something like this:
> 3. Kernel Asynchronous I/O (KAIO)
> Asynchronous I/O is supported by the official Linux kernel since
> 2.6.x. IBM Informix Dynamic Server supports Kernel Asynchronous I/O
> on character devices (a.k.a. raw devices) and block devices. It is
> by default, and can...Re: raw devices in linux (O_DIRECT) #4
Andreas Breitfeld escribi�:
> On Thursday 03 March 2005 18:45, you wrote:
>>I just installed IDS 10 on linux and this is what I have found:
>>- Required libstdc++.so.5, FC3 includes libstdc++.6[.0.3] so make a
>>symbolic link (yes I should downgrade but like with curses4 works fine)
> Fedora Core 3 delivers compat-libstdc++-8-188.8.131.52.i386.rpm which include the
> right link to libstdc++.so.5. If you install the package you can resolve the
> dependency clean.
> Andre...Re: raw devices in linux (O_DIRECT) #5
in your Machine Specific Notes you should see something like this:
3. Kernel Asynchronous I/O (KAIO)
Asynchronous I/O is supported by the official Linux kernel since
2.6.x. IBM Informix Dynamic Server supports Kernel Asynchronous I/O
on character devices (a.k.a. raw devices) and block devices. It is
by default, and can be disabled by setting the environment variable
KAIOOFF=1 in the environment of the process that brings up the server.
Note that the li...Re: Relocate Informix database from Raw slices to filesystem #2
Why pay someone ??? It's a trivial task
On 10/17/05, Neil Truby <firstname.lastname@example.org> wrote:
> <email@example.com> wrote in message
> > Thats sounds promising.
> > So effectively add a mirrored chunk to each dbspace using onspaces and
> > then drop the original chunk.
> > Can you do this for the rootdbs dbspace too...?
> > Matt
> If it's a production system you might be better off paying someone who
&...RE: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux #2
Christian Knappke wrote
> "Colin Bull" <firstname.lastname@example.org> wrote:
> > Here is one I prepared earlier ---
> > onbar/ontape whatever ..
> > FORCEOL=n
> > until onstat - | grep "On-Line" > /dev/null
> > do
> > echo "Off line" # ; sleep 20
> > onstat - | grep "[BQ][lu][oi][ce][ks]" > /dev/null && ( echo
> > "\nServ blokd"
> > if [ x$FORCEOL = "xn" ] ; then
> > echo "On...Re: Re: Informix and Linux opinions/who is running production #2
I know one. I've posted the name privately, as the last time I made the
error of sharing information about a client on this list, a consultant (?)
from this list cold called them.
Tired of 56k? Get a FREE BT Broadband connection
sending to informix-list
sending to informix-list
Maelwys Filidh wrote:
> I know one. I've posted the name privately, as the last time I made
> the error of sharing information about a client on thi...RE: [Maybe spam] Re: Relation of OS user to Informix database #2
You can only revoke a privilege that exists explicitly and you are the
GRANTOR, if a user's rights are part of "public" then you cannot prevent the
access unless you revoke connection privileges from public
There are 10 types of people in the world, those that understand binary and
those that don't
>From: "Gosney Simon" <GosneyS@axxia.com>
>To: "Jonathan Leffler" <email@example.com>, <firstname.lastname@example.org>
>Subject: RE: [Maybe spam] Re: Relation of OS user to Informix databas...raw devices in linux (O_DIRECT)
I just installed IDS 10 on linux and this is what I have found:
- It required glibc 2.3.3 and I was using and old redhat 8, so I upgraded
linux to Fedora Core 3. Dependency fixed
- Required libstdc++.so.5, FC3 includes libstdc++.6[.0.3] so make a
symbolic link (yes I should downgrade but like with curses4 works fine)
- I can't use raw devices with FC3! it's depretacted, the new way is
using the O_DIRECT flag when opening the chunks, of course in a
close-source program like IDS the only hope is to open a feature request.
+ RHEL 4 has this deprecated op...Re: hi Cant load informix online 5.2 on linux -8 ( rpm file) #2
As Tsutomu said it's a bug in the RPM package of Red Hat 8, I know two
1. - When you get the error message type 'OVERRIDE', (all caps and without
install without any relocation
----- Original Message -----
From: "RATHER" <email@example.com>
Sent: Friday, December 26, 2003 11:57 PM
Subject: hi Cant load informix online 5.2 on linux -8 ( rpm file)
> Hello friends
> RE...RE: Informix database creation #2
The existing chunk is already starting at offset of 500. Your new chunk
should have the offset as 600501 .
Are you Unmarried? http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?4d
Register in India's No 1 Matrimony.
sending to informix-list
"Ravinder Bahadur" <firstname.lastname@example.org> wrote in message
> The existing chunk is already starting at offset of 500. Your new chunk
> sh...RE: Mirror / Raw device / Informix
This is a multi-part message in MIME format.
In order to use redundant drives on your server: in your
onconfig file, change MIRROR 0 to MIRROR 1, then bounce your
database. You may then use onspaces -m to mirror your dbspaces. Read
the manual first. For replication across servers, Informix has built in
high availability data replication (master - slave only) and enterprise
replication (can be configured in many ...Re: Start informix database #2
This is an example
export PATH INFORMIXDIR INFORMIXSERVER ONCONFIG
export PATH INFORMIXDIR INFORMIXSERVER ONCONFIG
--- madiego <email@example.com> wrote:
> I had an informix database in the unix server. The
> server has been
> restarted and now I can't start the database.
> I execute 'oninit' and only can started the default...RE: Raw or Buffered device? #2
My whole Disaster Recovery (sorry Business Continuity) plan is based on the
fact that I can take an archive to a new machine (same O/S, same Informix,
similar Processors but totally different disk arrangement (EMC compared to
ClarIIon) ), set up the existing chunk softlinks to new raw disk and restore
without thinking about it. The raw disk just needs to be the same size as
the existing and 660:informix:informix. I've done this on v5 and v7 for the
past 5 years and will be doing so again this week.
From: firstname.lastname@example.org [ma...Re: Re: IDS Support for KAIO on Linux kernel 2.6+ #2
We have announced that the next version of IDS (coming soon!!!!) will
support KAIO on Linux!
Please check the presentation:
Access the replay and view the presentations originally given on 01 Dec
ox.com> ...Re: Moving Informix TableSpaces between databases #2
I think your best bet would be to use HPL to unload data from the logged db
and load it into the non-logged db as long as they both have the same
ASDC, Chennai" To
s...RE: The old raw devices chestnut. #2
Oracle uses some offset when it placed data onto raw devices.
When You restore data previously kept on cooked files onto
raw devices, You need to copy files using this offset (smth like 500 kBytes
on Digital UNIX, may very on other platforms)
> Any of Oracle, Informix or DB2 will cope with this equally as well as if
> "cooked" disk. Informix will even let you restore a dbspace held oncooked
> chunks to be restored to a raw disk (or vice versa). The others may do
> although I think th...Re: Raw devices vs. Filesystems #2
No point to beating a dead horse (other than the sheer joy of the thing) since postgres does not have raw device support, but ...
raw devices, at least on solaris, are about 10 times as fast as cooked file systems for Informix. This might still be a gain for postgres' performance, but the portability issues remain.
raw device use in Informix is safer in terms of data because Informix does not ever have to use the regular file system and so issues of buffering and so on go away. My understanding -- fortunately not ever tried in the real world -- is that postgres' WAL log system ...RE: How long can an Informix database name be? #2
The database name on SE is limited to 10 characters. This is an
historical anomaly based on the fact that the database name was used as
the directory name where that database will be stored. Directory names
in early versions of unix were restricted to 14 characters, but that was
including any extension, and as informix used dbname.dbs that restricted
the database name to 10 characters. And beware - on some versions that
ran on DOS it was further restricted to 8 characters - but that's
From: owner-informix-list@...Re: raw vs. cooked files under linux #2
I would suggest that you pick SUSE SLES 9
This SUSE version works perfectly with IDS 10.
Please check the following link:
With IDS 10 you have the freedom of choice to use cooked or raw devices
This link should answer your raw device support question
Let me know if you have any additional questions.
IBM Informix Development Munich
81...Re: Informix and Linux opinions/who is running production #2
And... are there any linux-informix shop runing 4GL RDS applications on linux?
Which informix versions, which linux platform?
It seems to me that the answer to this question is NULL. (I hope I am wrong)
Mario R. Canto
Andrew Hamm wrote:
> Gary Quiring wrote:
> > I would like to know if we have any shops out here running IDS 9.x on
> > Linux in a production environment where you have at least 300+ users
> > connected at one time. We had a visit from our Informix var today and
> > they are trying to convince me that Linux on IBM hardware is more
...RE: Relocate Informix database from Raw slices to filesystem
In the past we have used Informix's internal mirroring capabilities to move to new disk arrays. This should also work to move from raw to cooked disks.
[mailto:email@example.com]On Behalf Of firstname.lastname@example.org
Sent: Monday, October 17, 2005 9:26 AM
Subject: Relocate Informix database from Raw slices to filesystem
Is there any way I can relocate my IDS 7.31 database from its raw
slices to the local filesystem...?
I can 'dd' the slices to files easily, but I need a w...Re: Naming Convention for Informix Database Objects #2
Obnoxio The Clown wrote:
> Christopher wrote:
>>Can anyone recommend a good naming convention for database objects in
>>Generally, I use my own variation on Hungarian, but I wondered if
>>there is an equivalent of the RVBA (also known as Leszynski/Reddick)
>>standard among Informix developers.
>>I would also be thrilled to find a write-up I can reuse or just plain
>>As an aside, this is to be implemented on IDS 9.4, so long identifiers
>>are not an issue....