By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,190 Members | 1,469 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,190 IT Pros & Developers. It's quick & easy.

Problem creating raw container on RedHat

P: n/a
DB2 UDB v8.1 on RedHat 7.3

I'm sure I'm being a Bozo but ...

CREATE REGULAR TABLESPACE NEIL_1 PAGESIZE 4 K MANAGED BY DATABASE USING
( DEVICE '/dev/sdb2' 5120 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.33 BUFFERPOOL IBMDEFAULTBP DROPPED TABLE RECOVERY OFF

is failing with
User Response:
Specify another container location or change the container to
make it acceptable to DB2 (such as changing file permissions) and
try again.
sqlcode : -298
sqlstate : 428B2

I really can't figure out why. Can anyone show me the light please?

[db2inst1@seymour tmp]$ ls -l /dev/sdb2
brwxrwxrwx 1 db2inst1 db2grp1 8, 18 Apr 11 2002 /dev/sdb2

thanks
Neil
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Neil Truby" <ne********@ardenta.com> wrote in message
news:bu************@ID-162943.news.uni-berlin.de...
DB2 UDB v8.1 on RedHat 7.3

I'm sure I'm being a Bozo but ...

CREATE REGULAR TABLESPACE NEIL_1 PAGESIZE 4 K MANAGED BY DATABASE USING ( DEVICE '/dev/sdb2' 5120 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.33 BUFFERPOOL IBMDEFAULTBP DROPPED TABLE RECOVERY OFF

is failing with
User Response:
Specify another container location or change the container to
make it acceptable to DB2 (such as changing file permissions) and
try again.
sqlcode : -298
sqlstate : 428B2

I really can't figure out why. Can anyone show me the light please?

[db2inst1@seymour tmp]$ ls -l /dev/sdb2
brwxrwxrwx 1 db2inst1 db2grp1 8, 18 Apr 11 2002 /dev/sdb2

thanks
Neil


You may want to try using /dev/rsdb2 instead.

DMS-managed "device" containers must be raw devices (hence the 'r' prefix),
not character devices.

--
Matt Emmerton
Nov 12 '05 #2

P: n/a

"Matt Emmerton" <me******@yahoo.com> wrote in message
news:LO*******************@news01.bloor.is.net.cab le.rogers.com...

You may want to try using /dev/rsdb2 instead.

DMS-managed "device" containers must be raw devices (hence the 'r' prefix), not character devices.


Yes, of course. I'd forgotten to bind a raw device to the block device
first.
Thanks very much.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.