?
Solved

DMS tablespace not showing space increase. after EXTENDing.  Anyone know why?

Posted on 2011-03-01
6
Medium Priority
?
1,196 Views
Last Modified: 2012-06-27
Hello all,
I have a very critical need to increase space for a Production tablespace.  Before I did EXTEND tablspace containers, here's what I have:
                          BEFORE EXTEND
db2 LIST TABLESPACE CONTAINERS FOR 405 SHOW DETAIL

 db2 LIST TABLESPACE CONTAINERS FOR 405 SHOW DETAIL

            Tablespace Containers for Tablespace 405

 Container ID                         = 0
 Name                                 = /db2cont1/TBSPACE_00206
 Type                                 = File
 Total pages                          = 64
 Useable pages                        = 48
 Accessible                           = Yes
 Container ID                         = 1
 Name                                 = /db2cont2/TBSPACE_00206
 Type                                 = File
 Total pages                          = 64
 Useable pages                        = 48
 Accessible                           = Yes
 Container ID                         = 2
 Name                                 = /db2cont3/TBSPACE_00206
 Type                                 = File
 Total pages                          = 64
 Useable pages                        = 48
 Accessible                           = Yes

I then issued the following alter command:

db2 "ALTER TABLESPACE TBSPACE_01026 EXTEND (ALL 2880)"
DB20000I  The SQL command completed successfully

I then did a list tablespace show detail and found that the Total pages, Useable pages remains the same.
What's wrong with my effort? Am I missing something?
Please help, this is rather urgent as it is with production hence my generous point.

Thanks all

Okonita
0
Comment
Question by:Okonita001
  • 4
  • 2
6 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 35012870
are you by any chance use automatic storage tablespaces?
0
 

Author Comment

by:Okonita001
ID: 35013890
No, I don't think so but I will check on that. Auto storage will not allow you to extend manually or has that changed?
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 35013926
it wont allow
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 

Author Comment

by:Okonita001
ID: 35014403
So, how is the storage increase refreshed? stop the /start the tablespace? That will be bad for OLTP 24/7 operations and I don't think IBM will allow that kind of constraint. What can I do to resolve this short of creating a similar table unload reload, drop old and rename new to original after increasing storage in the new. That will make me cry!!

Thanks
0
 

Accepted Solution

by:
Okonita001 earned 0 total points
ID: 35015515
Momi_sabaq,

I dug in a little bit into the book and found the solution - it was staring me in the eye all along. Just add some more containers or resize all containers.
Thanks for chipping in...alwaya pleasure to talk with you.

Okonita001
0
 

Author Closing Comment

by:Okonita001
ID: 35107003
dug in a little bit into the book and found the solution - it was staring me in the eye all along. Just add some more containers or resize all containers.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Considering today’s continual security threats, which affect Information technology networks and systems worldwide, it is very important to practice basic security awareness. A normal system user can secure himself or herself by following these simp…
In the below post we have mentioned the best hosting type for startups. Also, check out some of the superlative web hosting companies that are proposing affordable web hosting solutions to host your startup website.
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question