Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    6

    Question Unanswered: stripping hp rawdevice on informix

    hi,

    I use IDS 9.20 hpux 11.00 and i must reorganize data and indexes.
    I ve got new disk.

    Has anybody experience stripping with rawdevice ?
    Because I wonder if instead of spending time searching the good place for data,index, for tables among disk and interface card,
    I could use raw device stripped among disk.
    Creating 2 or 3 vg,
    creating logical volume ( not fs but raw device ) stripped across disk.
    Chunk on the logical volume
    Dbspace whith chunks of 2Go.

    With these, no need to fragment table by round robin, no need to search the better place to put data. A chunk is on multiple disks and interface cards.

    Can you tell me if i am rigth or not.
    Thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    It works, but I think you might have better performance using fragmentation over dbspaces.
    PDQ works fast, because every dbspace gets a thread!
    It can scan in parallel. If you just place your chunks on different disks, no parallel options are used.
    rws

  3. #3
    Join Date
    Oct 2002
    Posts
    6

    Smile

    Thanks you for your advice.
    I am going tu use benefits of fragmentation over dbspaces

Posting Permissions

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