Solved

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

Posted on 2011-03-01
6
1,130 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
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…

762 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now