Results 1 to 6 of 6

Thread: tables space

  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Unanswered: tables space

    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

  2. #2
    Join Date
    Nov 2003
    Location
    California,USA
    Posts
    72

    Re: tables space

    Originally posted by jagan_5378
    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

  3. #3
    Join Date
    May 2003
    Posts
    369

    also check this

    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.

  4. #4
    Join Date
    Nov 2003
    Posts
    68
    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

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Nov 2003
    Posts
    68
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •