473,324 Members | 2,002 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

DB2 on Network Mounted Filesystems (Linux) ...

Hi,

Please don't throw your hands up immediately and quote me "this is not
supported" etc ....

I have a "temporary need" to move our DEVELOPMENT databases off our
SAN and onto an NFS filesystem mounted from another machine.
- The Sys. Admin guys want to do some SAN reorganisations.

I am wondering the following, any input/thoughts welcomed

1. Will the database even start/activate when filesystem is NFS
mounted?

2. Should I mitigate some on the potential inherent crash recovery
issues by
ensuring the recovery logs at least are on local disks, or doesn't
this really buy anything i.e I'm still just as vulnerable?

3. The performance hit of remote disks we can take, it is database
corruptions I would really like to avoid, anything else I could do to
reduce the risk?
- e.g I'm intending to take many more online backups through the
day,
in case required.

Many thanks.

Paul.
Nov 12 '05 #1
4 1389
aj
Under Linux Red Hat at least, we have had many, many very strange
issues w/ NFS. From really goofy stuff like date/time stamps
being wrong to java class files somehow getting partially (yes,
partially) cached by NFS - a new class file would be on an NFS-mounted
filesystem that is part of the CLASSPATH, and some parts of the new
class file could be seen by the java runtime, but others couldn't.

Unless you have no other choice, I would **not** recommend mixing
NFS w/ DB2 DMS or SMS containers...

aj

Paul Reddin wrote:
Hi,

Please don't throw your hands up immediately and quote me "this is not
supported" etc ....

I have a "temporary need" to move our DEVELOPMENT databases off our
SAN and onto an NFS filesystem mounted from another machine.
- The Sys. Admin guys want to do some SAN reorganisations.

I am wondering the following, any input/thoughts welcomed

1. Will the database even start/activate when filesystem is NFS
mounted?

2. Should I mitigate some on the potential inherent crash recovery
issues by
ensuring the recovery logs at least are on local disks, or doesn't
this really buy anything i.e I'm still just as vulnerable?

3. The performance hit of remote disks we can take, it is database
corruptions I would really like to avoid, anything else I could do to
reduce the risk?
- e.g I'm intending to take many more online backups through the
day,
in case required.

Many thanks.

Paul.

Nov 12 '05 #2
I know you don't want to hear it, but the fact of the matter remains that
NAS is not supported - meaning it will not work - and for extremely good
reasons. Blocking your ears won't change reality.

"Paul Reddin" <pa**@abacus.co.uk> wrote in message
news:1f**************************@posting.google.c om...
Hi,

Please don't throw your hands up immediately and quote me "this is not
supported" etc ....

I have a "temporary need" to move our DEVELOPMENT databases off our
SAN and onto an NFS filesystem mounted from another machine.
- The Sys. Admin guys want to do some SAN reorganisations.

I am wondering the following, any input/thoughts welcomed

1. Will the database even start/activate when filesystem is NFS
mounted?

2. Should I mitigate some on the potential inherent crash recovery
issues by
ensuring the recovery logs at least are on local disks, or doesn't
this really buy anything i.e I'm still just as vulnerable?

3. The performance hit of remote disks we can take, it is database
corruptions I would really like to avoid, anything else I could do to
reduce the risk?
- e.g I'm intending to take many more online backups through the
day,
in case required.

Many thanks.

Paul.

Nov 12 '05 #3
Thanks for that.

It was just the sort of feedback I was looking for.
I know of other things that are unsupported, but do work,
but this one looks like one to particularly stay away from.

Unfortunately, the alternative of cloning the DB server involves
other complications too, not least moving RH to SLES - hence my
desire to keep the server code where it was and only move the data.

Thanks again.

Paul.
Nov 12 '05 #4
Ian
Mark Yudkin wrote:
I know you don't want to hear it, but the fact of the matter remains that
NAS is not supported - meaning it will not work - and for extremely good
reasons. Blocking your ears won't change reality.


That's not correct. Certain NAS devices _are_ supported (NetApp Filer
comes to mind). I have worked at more than one client site using
Filers for DB2 UDB with large databases, up to 1Tb. Of course these
NAS devices are optimized for high-traffic NFS and CIFS, and you have
to know what you're doing to configure the client (DB2 server) properly.

That's not to say that the OP's question about running DB2 on an NFS
filesystem served from a RedHat box is a good idea, though.


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Read Roberts | last post by:
I wrote my own directory browser in order to get around a bug where tkFileDialog.askdirectory() can't handle non-ascii paths. However, I have a problem where I call os.listdir() on a mapped...
3
by: garabik-news-2005-05 | last post by:
Hi all, I am trying to port my (linux) program to MacOSX, and I need to get a list of mounted filesystems. Under linux, it was easy, I was parsing /etc/mtab (or /proc/mounts), this works also on...
4
by: KimHoon | last post by:
I want to know how to check if USB port is mounted... I programmed some sources , which run to read data-files in usb storage. And I have no input systems; no keyboard, no mouse, no touchpad...
29
by: Tola | last post by:
In my case of study, my teacher gave me a project, after I analysed the problem I found that I had to used open the file on the other machine? Please help? Thank you in advance. Tola CHROUK
6
by: Hans Stoessel | last post by:
Hi I have a C application on a Windows PC who shoul delete files on a Sun which is in the same network. I try this with the 'remove' command, e.g. remove(\\Sun\Temp\File.jpg). But this doesn't...
5
by: Mike McIntyre [MVP] | last post by:
I am working on an issue where and ASP.NET web application on one computer (A) needs to access files on a network mapped drive (B). This application uses as DSN on (A) that maps a proprietory...
6
by: tendim | last post by:
G'day group. Currently our organization us using VB6 based applications, and I am trying to push forward and migrate some of the smaller things to VB.NET, eventually migrating all applications...
11
by: RoB | last post by:
Hi all, I'm coming from the Informix world and I have a customer using DB2 8.2.3 for Linux on Red Hat Enterprise ES. The customer is performing filesystem backups of the containers etc every...
1
by: Sanjuro | last post by:
Recently read an article by Felix Lee: Setting up DB2 for UNIX and Linux on NFS mounted file systems ( http://tinyurl.com/yuxbk3 ). I was wondering why would anyone want to setup things like...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.