Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1193
  • Last Modified:

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

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
Okonita001
Asked:
Okonita001
  • 4
  • 2
1 Solution
 
momi_sabagCommented:
are you by any chance use automatic storage tablespaces?
0
 
Okonita001Author Commented:
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
 
momi_sabagCommented:
it wont allow
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
Okonita001Author Commented:
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
 
Okonita001Author Commented:
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
 
Okonita001Author Commented:
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now