Hi-
I'm having a rather strange problem attempting to create a database.
We're attempting to move a database from attached SCSI storage to SAN
storage, and when I attempt to create the database using the SAN mount
point as the database directory, I get a SQL1031N error. However, it
is only happening on SAN LUNs mounted underneath directories on root.
Our sysadmin decided he did not want to mess up his pretty root
directory with mount points, so he created a directory off root to put
all of the database mount points in, called "db2data". Each LUN from
the SAN was then mounted to a subdirectory under db2data:
/db2data/db1 = mount for database #1
/db2data/db2 = mount for database #2
When I attempt to create a database under this directory:
"CREATE DATABASE DB1 ON /db2data/db1 ..."
I get a SQL1031N error. I am able, however, to create the database in
the instance home directory, which IS mounted directly off the root
directory, in /db2ihome, so:
"CREATE DATABASE DB1 ON /dbihome/instance1 ..."
works just fine.
This does not seem to be a permissions issue, because I am able to
create directories, files, and tablespaces in the /db2data/db1 mount
point. My hypothesis is that DB2 requires the mount point for the
database home directory to be mounted directly off root. If anyone has
any insight, I'd appreciate it.
Thanks,
Todd McNeill