Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-03-01
6
Medium Priority
?
1,189 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
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…
Suggested Courses

670 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