473,396 Members | 1,884 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,396 software developers and data experts.

Problem creating raw container on RedHat

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
2 2176

"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

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Support | last post by:
Hello, I am running RedHat & Apache. RedHat does not allow creating more that 32000 subdirectories in one folder due to #defined constant limitation in the core code. I need to display 47000...
1
by: Dave | last post by:
Hello All, I've created a problem by not reading instruction and now I don't know what to do :( I tried to install 9i on my redhat 9.0 box as myself without going thru the proper procedure of...
2
by: David Whitfield | last post by:
Hi All - I am an experienced ASP developer but am new to ASP.NET and the .NET framework and am trying to learn how to access datasets. When I try to build the following page, I get the errow...
4
by: Merlin | last post by:
Hi Imagine the following classes (A class diagram will help) BASE, A, B, C, D, E, F, G. A, B, C, D, G inherit from BASE. E, F inherit from D.
4
by: joetekubi | last post by:
hello all, while working with STL containers and various class composition, I can across a bug that I can't seem to find. When using a STL container in a derived class with composition,...
4
by: | last post by:
Hi, all: I have a RedHat 9 with gcc version 3.4.1, and I want to compile siph323csgw with ¡§make siph323csgw¡¨. But when I compile siph323csgw, I get this message: configure: creating...
0
by: uncensored | last post by:
Hello everyone, I'm fairly new at .Net and I have a repeater inside a repeater problem. I will attach my code to this message but basically what I am able to tell when I run my page it tells me...
3
by: mamoon | last post by:
Hi, I am using Redhat Enterprise Linux A4 since 2 yera. Here I am facing problem due to RAID problem. I am trying to install Redhat Enterprise A4 in new hard disk but it give error - An error has...
2
Chittaranjan
by: Chittaranjan | last post by:
Hi All, I have a big problem with my server and need some solutions to solve. I am working on PHP project and my code base had been set up on one of our RedHat server. I am not sure why in...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.