Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    4

    Unanswered: create database on raw device

    Hi,



    I was wondering if it is possible to execute " CREATE DATABASE" against a raw device.

    e.g. db2 create database test on /dev/vgdb2/lv_test

    If you run this it comes back with "path does not exist"

    Does this mean you will always have to create the database on a filesystem ( dftdbpath) ?

    thx,

    Peter

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: create database on raw device

    I think the db has to be created on a filesystem directory only ..

    Need not be dftdbpath, it can be something else you specify ...

    Cheers

    Sathyaram

    Originally posted by pveck
    Hi,



    I was wondering if it is possible to execute " CREATE DATABASE" against a raw device.

    e.g. db2 create database test on /dev/vgdb2/lv_test

    If you run this it comes back with "path does not exist"

    Does this mean you will always have to create the database on a filesystem ( dftdbpath) ?

    thx,

    Peter

  3. #3
    Join Date
    May 2003
    Posts
    4

    Re: create database on raw device

    Ok,

    So the concept of running DB2 on raw devices is roughly create database on a filesystem and create all tablespaces on raw devices ?

    thx,

    Peter




    Originally posted by sathyaram_s
    I think the db has to be created on a filesystem directory only ..

    Need not be dftdbpath, it can be something else you specify ...

    Cheers

    Sathyaram

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: create database on raw device

    Yes ...

    When you create the database, all control files are created in the directory you mention in the create db ...

    You can have raw devices as DMS Tablespace containers ....

    It is a general recommendation to have Catalog and Temp Space on SMS Tablespaces, though you can have these as DMS raw ...

    HTH

    Cheers

    Sathyaram


    Originally posted by pveck
    Ok,

    So the concept of running DB2 on raw devices is roughly create database on a filesystem and create all tablespaces on raw devices ?

    thx,

    Peter

Posting Permissions

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