Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012
    Posts
    26

    partitioned database

    i have partitioned database with 3 partition. one is where we do all the admin work. now i am new at db2 so can any one please explain me how can i view all tablespaces with select commend and how can i view the size also? please help

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,361
    Try the following command:

    rah "db2pd -alldbp -d <db name> -tab"

    alldbp = alldbpartitionnums
    tab = tablespaces

Posting Permissions

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