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 this. About
6 months beck, in my previous engagement, the system architect asked
if this was possible. I told him offhand that it is and that I 'll
confirm from IBM. Had opened a PMR with IBM regarding the same and the
techrep replied the same thing as Felix notes. That it is possible,
but has its open issues and performance problems. After hearing this,
the architect abandoned the idea.
I think the reason why the architect asked the question in the first
place was that he wanted to have a standard operating environment for
applications and for databases that meant working with only one (or
worst case two) code base (version). Well, there were so many versions
in the company (from v7.1 to v8.2 FP14) because there were so many
different packaged applications with their own requirements. Even
generic 3-tier webapps sometimes had their specific environment
requirements. It is almost impossible to always have one version (and
one code base) for all applications. Sure it creates a nightmare for
the DBA to manage all that, but we take the reasons behind it with a
grain of salt and live with it.
One other reason he was so excited with NFS mounted code base was
because, apparently the then Oracle DBA had informed him that its
seamless and without-problems in Oracle. Don't know how right he was.
Cheers
~sanjuro