Solved

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

Posted on 2011-03-01
6
1,158 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Test the speeds on my PC Drives 12 71
physical security query stockroom concern 8 77
Increase DSNRO value on vsphere 6.0 1 39
Extending VM Disk to be larger than 2 TB ? 11 100
Lets start to have a small explanation what is VAAI(vStorage API for Array Integration ) and what are the benefits using it. VAAI is an API framework in VMware that enable some Storage tasks. It first presented in ESXi 4.1, but only after 5.x sup…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
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…
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…

761 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