Results 1 to 2 of 2

Thread: DB snapshot

  1. #1
    Join Date
    Aug 2016
    Posts
    55
    Provided Answers: 2

    Unanswered: DB snapshot

    Hi,

    Database was created with stogroup in home path.

    added stogroup , alter tablespace to use new stogroup and dropped the home path stogroup

    snapshot of database shows DB pending and other new stogroup path as Not IN USE

    the database is working fine, tablespace all are normal

    --------------------------

    Number of automatic storage paths = 6
    Automatic storage path = /udb/db2inst1/dbpath1
    Node number = 0
    State = Drop Pending
    File system ID = 64775
    Storage path free space (bytes) = 6798704640
    File system used space (bytes) = 398188544
    File system total space (bytes) = 7264002048
    Automatic storage path = /udb/db2inst1/data
    Node number = 0
    State = Not In Use
    File system ID = 64776
    Storage path free space (bytes) = 399940837376
    File system used space (bytes) = 22682656768
    File system total space (bytes) = 422623494144
    Automatic storage path = /udb/db2inst1/data01
    Node number = 0
    State = Not In Use
    File system ID = 64777
    Storage path free space (bytes) = 399940837376
    File system used space (bytes) = 22682656768
    File system total space (bytes) = 422623494144
    Automatic storage path = /udb/db2inst1/data02
    Node number = 0
    State = Not In Use
    File system ID = 64778
    Storage path free space (bytes) = 400735019008
    File system used space (bytes) = 21888475136
    File system total space (bytes) = 422623494144
    Automatic storage path = /udb/db2inst1/data03
    Node number = 0
    State = Not In Use
    File system ID = 64779
    Storage path free space (bytes) = 400735019008
    File system used space (bytes) = 21888475136
    File system total space (bytes) = 422623494144
    Automatic storage path = /udb/db2inst1/data04
    Node number = 0
    State = Not In Use
    File system ID = 64780
    Storage path free space (bytes) = 200105218048
    File system used space (bytes) = 11139518464
    File system total space (bytes) = 211244736512


    regards
    paul

  2. #2
    Join Date
    Jan 2017
    Posts
    2
    Hi Paul,

    try to rebalance the tablespaces of whom you have changed the storage group. this will move over all pages to new storage group and will cause high I/O load (be carefull on production system).

    kind regards

    Quote Originally Posted by mpaul View Post
    Hi,

    Database was created with stogroup in home path.

    added stogroup , alter tablespace to use new stogroup and dropped the home path stogroup

    snapshot of database shows DB pending and other new stogroup path as Not IN USE

    the database is working fine, tablespace all are normal

    --------------------------

    Number of automatic storage paths = 6
    Automatic storage path = /udb/db2inst1/dbpath1
    Node number = 0
    State = Drop Pending
    File system ID = 64775
    Storage path free space (bytes) = 6798704640
    File system used space (bytes) = 398188544
    File system total space (bytes) = 7264002048
    Automatic storage path = /udb/db2inst1/data
    Node number = 0
    State = Not In Use
    File system ID = 64776
    Storage path free space (bytes) = 399940837376
    File system used space (bytes) = 22682656768
    File system total space (bytes) = 422623494144
    Automatic storage path = /udb/db2inst1/data01
    Node number = 0
    State = Not In Use
    File system ID = 64777
    Storage path free space (bytes) = 399940837376
    File system used space (bytes) = 22682656768
    File system total space (bytes) = 422623494144
    Automatic storage path = /udb/db2inst1/data02
    Node number = 0
    State = Not In Use
    File system ID = 64778
    Storage path free space (bytes) = 400735019008
    File system used space (bytes) = 21888475136
    File system total space (bytes) = 422623494144
    Automatic storage path = /udb/db2inst1/data03
    Node number = 0
    State = Not In Use
    File system ID = 64779
    Storage path free space (bytes) = 400735019008
    File system used space (bytes) = 21888475136
    File system total space (bytes) = 422623494144
    Automatic storage path = /udb/db2inst1/data04
    Node number = 0
    State = Not In Use
    File system ID = 64780
    Storage path free space (bytes) = 200105218048
    File system used space (bytes) = 11139518464
    File system total space (bytes) = 211244736512


    regards
    paul

Posting Permissions

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