Re: raw devices in linux (O_DIRECT)
Hi, On Thursday 03 March 2005 18:45, you wrote: > Hi, > > 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-3.3.4.2.i386.rpm which include the right link to libstdc++.so.5. If you install the package you can resolve the dependency clean. Andreas > > - 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 options enabled so I don't think IBM > will be interested in this solution. > > + The advantage of O_DIRECT is you dont need to make the association > with the /dev/raw devices and rawio will be always in effect, also KAIO is > enabled by default with rawdevices. > > + The workaround is make a new linux-util and kernel package with raw > enabled. > > I'll make my custom kernel and try. > sending to informix-list sending to informix-list ...

Re: raw devices in linux (O_DIRECT) #5
Hi, 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 version 2.6.x. IBM Informix Dynamic Server supports Kernel Asynchronous I/O (KAIO) on character devices (a.k.a. raw devices) and block devices. It is enabled 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 libaio.so library is required, regardless of the distribution or kernel level. At the time of writing, IBM Informix Dynamic Server requires a minimum of libaio 0.3.96-3. ------------------------------------------------------- Where the last paragraph is exactly what Sandor has pasted into the e-mail before. Which information do you think is missing ? Can you be more specific ? Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 04.03.2005 16:22:59: > Hi Sandor: > > Without the library libaio I got > > 08:32:46 libaio.so.1: cannot open shared object file: No such file or > directory > 08:32:46 Please install libaio package. See machine notes. > 08:32:46 Warning: Kernel Asynchronous I/O is disabled. > > After installing the libr...

Re: raw devices in linux (O_DIRECT) #4
Hi Andreas, Andreas Breitfeld escribi�: > Hi, > > On Thursday 03 March 2005 18:45, you wrote: > >>Hi, >> >>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-3.3.4.2.i386.rpm which include the > right link to libstdc++.so.5. If you install the package you can resolve the > dependency clean. > > Andreas > With this package works perfectly Thanks sending to informix-list ...

Re: raw devices in linux (O_DIRECT) #3
Hi Sandor: Without the library libaio I got 08:32:46 libaio.so.1: cannot open shared object file: No such file or directory 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 32768 [root@tina ~]# onstat -g iov IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 01:21:20 -- 1799820 Kbytes AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors kio 0 i 0.0 119 119 0 0 275 0.4 0 kio 1 i 0.0 195 185 10 0 502 0.4 0 kio 2 i 0.0 40 23 17 0 170 0.2 0 msc 0 i 0.0 13 0 0 0 14 0.9 0 aio 0 i 0.0 161 16 8 0 161 1.0 0 aio 1 i 0.0 2 0 0 0 3 0.7 0 aio 2 i 0.0 0 0 0 0 1 0.0 0 pio 0 i 0.0 1 0 0 0 2 0.5 0 pio 1 i 0.0 0 0 0 0 1 0.0 0 lio 0 i 0.0 0 0 0 0 1 0.0 0 There is no more information on release notes but machine notes mention the support of KAIO in kerne...

Re: raw devices in linux (O_DIRECT) #2
Hi Fernando, I have some information regarding the O_DIRECT flag. IDS V10 detects automatically that it runs on Linux Kernel 2.6 and if KAIO is enabled then it turns on the O_DIRECT flag! To enable KAIO: The libaio.so library is required, regardless of the distribution or kernel level. At the time of writing, IBM Informix Dynamic Server V10.0 requires a minimum of libaio 0.3.96-3. Please also read the release notes for more information! bye Sandor IBM Informix Development Munich Information Management Hollerithstra�e 1 81829 Munich Germany Fernando Ortiz <fortiz@lacorona. com.mx> To Sent by: "Informix-Discussion E-List owner-informix-li (E-mail)" <informix-list@iiug.org> st@iiug.org cc Subject 03.03.2005 18:45 raw devices in linux (O_DIRECT) ...

raw devices in linux (O_DIRECT)
Hi, 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 options enabled so I don't think IBM will be interested in this solution. + The advantage of O_DIRECT is you dont need to make the association with the /dev/raw devices and rawio will be always in effect, also KAIO is enabled by default with rawdevices. + The workaround is make a new linux-util and kernel package with raw enabled. I'll make my custom kernel and try. sending to informix-list ...

RE: Mirror / Raw device / Informix
This is a multi-part message in MIME format. ------_=_NextPart_001_01C6153D.0A4774A2 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Muthana- 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 different ways). Both are free in enterprise edition. High availability requires an additional license for workgroup edition. Enterprise replication is not allowed in workgroup edition. For documentation, see: http://www.ibm.com/software/data/informix/pubs/library =20 --EEM =20 -----Original Message----- From: Muthana.AL-Temimi@tu-harburg.hamburg.de [mailto:Muthana.AL-Temimi@tu-harburg.hamburg.de]=20 Sent: Monday, January 09, 2006 10:06 AM To: informix-list@iiug.org Cc: m.al@tuhh.de Subject: Mirror / Raw device / Informix =20 Dear IIUG, =20 I would like to ask if I can do a mirror of my database which is installed on raw device into the 2 server by using mirror technology. I heart that this solution won't work with Informix but I'm not sure therefore I asked the questi...

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. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of mccmx@hotmail.com Sent: Monday, October 17, 2005 9:26 AM To: informix-list@iiug.org 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 way of telling Informix the new location of the chunks. This seems straigtforward for the rootdbs (which is defined in onconfig), but what about the other chunks..? I want to avoid unloading and reloading the data. All I want to do is move the physical chunks.. onstat -d: Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 2 days 14:38:28 -- 40768 Kbytes Dbspaces address number flags fchunk nchunks flags owner name c04a150 1 1 1 1 N informix rootdbs c04a618 2 1 2 1 N informix logicdbs c04a6d8 3 1 3 1 N informix procdbs 3 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname c04a210 1 1 50 400000 278361 PO- /dev/rdsk/c1t6d0s4 c04a458 2 2 50 200000 134867 P...

Binding raw devices in Linux kernel 2.6
Hi, I'm trying to port an old program compiled on kernel 2.4, onto kernel 2.6. I've using a Mandriva 2009.1 box as my development PC. I've managed to get the program to build properly once I've gotten the necessary libraries, and it also runs. However, one of the first things that the program does is to bind the raw devices(already set up as separate logical partitions within the drive as /dev/sdaN) to /dev/rawN, in order to access them later directly. To do so, the first thing that it does is to open /dev/rawctl with the following code: [code] if ((master_fd = open("/...

RE: raw vs. cooked files under linux #6
When you compare cooked versus raw here, are you focusing on Linux only, or talking about this in general - other Unix platforms as well ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Data Goob Sent: 11 May 2005 03:08 PM To: informix-list@iiug.org Subject: Re: raw vs. cooked files under linux If you are in a slow-change environment raw-files are not a bad thing. They create extra problems on the management side that cooked files do not. Fast-changing environments create more demand on your time so why put yourself into extra work with raw files? They don't give you enough of a difference in performance to really warrant them unless you are really demanding that extra 10%. Cooked files are also also more flexible on backups, you can back the dbspaces up with a regular backup tool or use the Informix backup tools, but raw files will have to be backed up with Informix tools only. SLES9 is quite a sea change from SLES8, and you could probably get away without SLES and go with the workstation Pro 9.3 if you are on a budget. SLES has better support for SCSI than the workstation versions and you must buy support or the online update doesn't work. It's an enterprise lock-in you might not need so try before you buy. SLES9 can be downloaded for trial, so give it a spin. You should be able to download IDS 10 for trial as well, thus no out of pocket to try it before pay...

Re: Informix and Linux opinions/who is running production #6
I know a few, but they are using Hydra from Querix. On 12 Feb 2004 at 15:16, Mario Canto wrote: > 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...

RE: [SPAM] Re: Informix for linux
Because the IIUG server was out due to power from the hurricane that hit the East Coast of the United States The IIUG server is now back up and running At 09:16 PM 5/27/2003 -0400, Rob Vorbroker wrote: >ikke - I'm cc'ing this to the webmaster@iiug.org. >His name is Stuart Litel and once you know him...well. > >Perhaps he can figure out why you haven't recieved a >confirmation email in 3 days. Please remember that >everyone who is on the IIUG BoD or other committees >are volunteers. (: Kinda like IBM/Informix Marketing >I guess. LOL...

Re: Relocate Informix database from Raw slices to filesystem #4
True there are issues but it's a easy solution to the problem, gets round the 'can not rename chunks' issue, no need to hassle about mirroring etc But the original post said going to internal disks so there will not be a name clash. On 10/17/05, Paul Watson <pwatson@irace.com> wrote: > > On 17 Oct 2005 15:26:36 -0700, david@smooth1.co.uk <david@smooth1.co.uk> > wrote: > > > > > > Paul Watson wrote: > > > If the device is 'not going to exist anymore' why not dd the data from > > the > > > old slice to the internal disk and then > > > just link the 'not going to exist anymore device' to the new location > > > > > > > > > > > > I'm guess this a Solaris platform..and then someone runs devfsadm that > > rebuilds /dev and removes your links! > > > > Or someone adds a new device and Solaris wants to use that name! > > > > Bad idea to store stuff under /dev. That directory is for the OS > > to control not you. > > > > If you are running on IDS 9.40 or IDS 10 then ontape has the ability to > > rename chunks during a restore. > > > > http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0405fan/ > > > > > > > > > -- > Paul Watson > Tel: +44 7818 003457 > Fax: +44 1436 678693 > ...

Re: Relocate Informix database from Raw slices to filesystem #3
If the device is 'not going to exist anymore' why not dd the data from the old slice to the internal disk and then just link the 'not going to exist anymore device' to the new location On 10/17/05, Fernando Nunes <spam@domus.online.pt> wrote: > > Clive Eisen wrote: > > mccmx@hotmail.com wrote: > > > >> > >> I don't neccesarily need to move them off raw slices, but I do need to > >> move them to different slices. This is because I am moving the > >> database from SAN storage to internal disks... So ultimately > >> /dev/rdsk/c1d6d0s4 (and s5 and s6) wont exist anymore. > >> > >> So I need a way of relocating the data to a new slice or a filesystem > >> file. I suspect the process will be t > >> > > You can, in an unsupported environment, binary edit the rootdbs > > as the path to the other chunks is held there > > But the new paths would need to have the same length... > That's why you should never use physical names. Always use symbolic > links to the real devices... > > In this circunstances I don't see how an unload/reload can be avoided... > > > Regards. > > > -- Paul Watson Tel: +44 7818 003457 Fax: +44 1436 678693 sending to informix-list Paul Watson wrote: > If the device is 'not going to exist anymore' why not dd the data from the ...

Re: Relocate Informix database from Raw slices to filesystem #2
Why pay someone ??? It's a trivial task On 10/17/05, Neil Truby <neil.truby@ardenta.com> wrote: > > <mccmx@hotmail.com> wrote in message > news:1129561344.240798.314750@g49g2000cwa.googlegroups.com... > > 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 > knows > what they're doing to do this for you. > > -- > Neil Truby t:01932 724027 > Director m:07798 811708 > Ardenta Limited e:neil.truby@ardenta.com > > > > -- Paul Watson Tel: +44 7818 003457 Fax: +44 1436 678693 sending to informix-list ...

RE: Relocate Informix database from Raw slices to filesystem #5
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of mccmx@hotmail.com Sent: Tuesday, October 18, 2005 3:59 AM To: informix-list@iiug.org Subject: Re: Relocate Informix database from Raw slices to filesystem Funnily enough, your idea to create a soft link in /dev from the old device to the new device/location is exactly what I was planning to do if I couldn't find a 'better' solution. Based on this thread, I may well have to go down that route... My Informix knowledge is very limited....!?! What I will probably do is: 1. create the soft link from /dev to get informix up and running on a different machine. 2. On this new machine: Add a mirror chunk to each dbspace and drop the original mirror to effectively relocate the databse to the filesystem. If I have no joy with step 2, I will run with the soft link from /dev. This will have to be documented well so that if someone destroys /dev (through devfsadm or similar) then the links can be recreated easily. Its not ideal but its preferable to unloading and reloading the whole database, which has its own risks. Thanks for the advice.. Matt onbar has a -rename option... sending to informix-list ...

RE: Re: Informix and SQL Server #6
we have a similar situation, we have not installed any unix odbc drivers on our unix machine, this is what i do, which works pretty well, - created import dts package to pull the informix tables in sqlserver with the following settings for Data Source "OLE DB Provider for ODBC Driver" on windows (not on unix) and used informix odbc driver which i believe comes with the sqlserver engine - run the dts package just before running the query the dts import packages pulls informix data and loads it to the sqlserver database at the rate of around 3000 rows/second (which is not too...

RE: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux
David Williams wrote > > "Andy Kent" <andykent.bristol@virgin.net> wrote in message > news:a3525a11.0401080308.64a1ed12@posting.google.com... > > Why ever would you want to run a cold restore unattended? > > > > Great laxative ... > > > > To create a reporting database once per week... > > Once all the ontape stuff is finished don't forget to > > a) Sit in a loop running onstat - and check the return > code each time.Wait for the server to reach quiescent > mode. This can take 45 mins. >...

Re: hi Cant load informix online 5.2 on linux -8 ( rpm file) #6
hello friends. How are you. As i said. I did open and loaded the rpm file into /opt/infomix directory. and then copied the all contents to /usr/infomrix directory. From /usr/infomix i run from root . / installonline and the online started installion with some warnings and finally displayed the messaged that installation comeplete sucessfully. But when logingin into usr/infomix bu user infomrix. i cannt run any command like tbmonitor. dbaccess etc. it gives me the errore messeager like " SEGMENTATION FAULT" AND DO NOTHING., wHAT IS THIS. as the installion di...

RE: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux #2
Christian Knappke wrote > > "Colin Bull" <c.bull@videonetworks.com> 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: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux #3
Thanks a lot ! My problem was the fact that I tried to restore on a Linux machine a backup made on a UNIX machine. The INFORMIX server version was the same. The problem was the OS, in fact. Backup with ontape is recommended only when the restore is made on the same machine. Carmen ----- Original Message ----- From: "S.Dhayanidhi" <sdhaya@hotmail.com> To: <informix-list@iiug.org> Sent: Monday, January 12, 2004 6:35 AM Subject: Re: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux > Here is my cute little code.. for u...

Re: Re: Informix and Linux opinions/who is running production
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. Nice behaviour. Pete _________________________________________________________________ Tired of 56k? Get a FREE BT Broadband connection http://www.msn.co.uk/specials/btbroadband sending to informix-list ...

Getting name of device which is bind to raw device if i have raw device name
Hi Can any one tell me Ihave a raw device is bind to a logical volume How to get the logical volume name from the name of the raw device Thanks , Sachin sachin wrote: > > Hi > Can any one tell me > Ihave a raw device is bind to a logical volume > How to get the logical volume name from the name of the raw device That is imposible. You can get the device number by using the RAW_GETBIND ioctl (like raw -q does). But there is no way to get the device name from the device number (other than searching through all of /dev and hoping to find the right nod...

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