hi
pl tell me how to create tablespace on raw device
i done following steps
in linux
my db2 v7.2 linux 6.2.

Step 1.

Bind an unused raw device node to this partition. This needs to be done every time the machine is rebooted, and requires root access. Use raw -a to see which raw device nodes are already in use:

# raw /dev/raw/raw1 /dev/sda6
/dev/raw/raw1: bound to major 8, minor 5

Step 2.

Set global read permissions on the raw device controller and the disk partition. Set global read and write permissions on the raw device:

# chmod a+r /dev/rawctl
# chmod a+r /dev/sda6
# chmod a+rw /dev/raw/raw1

Step 34.

Create the table space in DB2, specifying the raw device, not the disk partition. For example:

CREATE TABLESPACE dms1
MANAGED BY DATABASE
USING (DEVICE '/dev/raw/raw1' 11170736)

after running this the following error comming

CREATE TABLESPACE dms1 MANAGED BY DATABASE USING (DEVICE '/dev/raw/raw1' 11170736)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0298N Bad container path. SQLSTATE=428B2

pl tell me how create table space on raw device.

thank u
bye

Try this...

CREATE TABLESPACE dms1
MANAGED BY DATABASE
USING (DEVICE '/dev/raw/raw1/' 11170736)

...Hope this works.

Ram

If your raw device(s) do not have enough storage space then you also may get the bad container path error in DB2. Check with your Unix admin to ensure that the raw device(s) are readable and have enough space.

hi
now this error is comming .
while createing table space on raw device

create tablespace kalatab managed by database using (device '/dev/raw/raw1' 20480)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0902C A system error (reason code = "2") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005

thank u

What message do you get in your db2diag.log file ?

Change the DIAGLEVEL to 4 and retry to operation . You will get more dump messages

Cheers
Sathyaram

hi Sathyaram

i changed diaglevel to 4.
same error comming in command prompt.

in db2diag.log file 800 lines of error messge recorded.

i am sending u db2diag.log file .
Filesystem Size Used Avail Use% Mounted on
/dev/sda9 486M 125M 336M 27% /
/dev/sda5 5.8G 2.7G 2.8G 48% /Kalanjali
/dev/sda1 99M 5.8M 88M 6% /boot
/dev/sda6 6.1G 4.7M 5.8G 0% /db2temp
/dev/sda7 2.4G 2.0G 299M 87% /usr

raw /dev/raw/raw1 /dev/sda6
/dev/raw/raw1: bound to major 8, minor 5

chmod a+r /dev/rawctl
chmod a+r /dev/sda6
chmod a+rw /dev/raw/raw1


------------------------------
error message in log file
----------------------------
Container '/dev/raw/raw1' is different from specified size.
User: 5632000 Kb OS: 6498260 Kb. Extra storage is wasted.

DIA3801C A buffer pool logic error has occurred.

ZRC=0xFFFFF602

2003-12-23-19.19.48.079904 Instance:db2inst1 Node:000
PID:1364(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031223133726
buffer_pool_services sqlbDMSAddContainerRequest Probe:840 Database:TESTKALA
Error acquiring container 0 (/dev/raw/raw1) for tbsp 5. Rc = FFFFF602

2003-12-23-19.19.48.126174 Instance:db2inst1 Node:000
PID:1364(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031223133726
relation_data_serv sqlrr_signal_handler Probe:10 Database:TESTKALA
DIA7107I Execution of a component signal handling function has begun.
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 Data:Recursive dump_sect
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 Data:PACKAGE ENTRY
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 Data:USED_IN_UOW BIT VECTOR
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 DataECTION NUMBER
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 DataECTION DIR ENTRY
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 Data:cache cb

Data Title:section stmt PID:1364 Node:000
6372 6561 7465 2074 6162 6c65 7370 6163 create tablespac
6520 6b61 6c61 7461 6220 6d61 6e61 6765 e kalatab manage
6420 6279 2064 6174 6162 6173 6520 7573 d by database us
696e 6720 2864 6576 6963 6520 272f 6465 ing (device '/de
762f 7261 772f 7261 7731 2720 3134 3038 v/raw/raw1' 1408
3030 3029 000)

Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 Data:section stmt
003-12-23-19.19.48.131735 Instance:db2inst1 Node:000
PID:1364(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031223133726
relation_data_serv sqlrr_signal_handler Probe:20 Database:TESTKALA
DIA7108I Execution of a component signal handling function is complete.

2003-12-23-19.19.48.132100 Instance:db2inst1 Node:000
PID:1364(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031223133726
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:TESTKALA
DIA3801C A buffer pool logic error has occurred.

2003-12-23-19.19.48.132425 Instance:db2inst1 Node:000
PID:1364(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031223133726
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:TESTKALA
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFF602".

Data TitleQLCA PID:1364 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 1
sqlerrmc: 2
sqlerrp : sqlrlcts ?


PID:1364(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031223133726
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:TESTKALA
DIA3801C A buffer pool logic error has occurred.

ZRC=0xFFFFF602

2003-12-23-19.19.48.144024 Instance:db2inst1 Node:000
PID:1364(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031223133726
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:TESTKALA



2003-12-23-19.19.48.171588 Instance:db2inst1 Node:000
PID:1364(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031223133726
relation_data_serv sqlrr_signal_handler Probe:10 Database:TESTKALA
DIA7107I Execution of a component signal handling function has begun.
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 Data:Recursive dump_sect
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 Data:PACKAGE ENTRY
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 Data:USED_IN_UOW BIT VECTOR
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 DataECTION NUMBER
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 DataECTION DIR ENTRY
Dump File:/Kalanjali/db2inst1/sqllib/db2dump/1364.000 Data:cache cb


like this somany lines of error messages came.
nearly above 800 lines error messages came.

pl tell me how to avoid thsi error.

thank u