The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.Blogs
Blogs
Matching:
tablespace
X
X
| Display: |
DB2 : Identify tables consuming most space in a tablespace
It is easily possible to identify the amount of space consumed by tables in a given tablespace. This is required when size of tables increases to reach the size limit or makes tablespaces have unequal data distribution which might eventually lead to bad...
from Blog: Thoughts from Support
Modified on by Priyanka Joshi
|
|
Hands-on example for online tablespace restore and rollforward
In some customer's cases, I faced the situation that some customers wanted to restore and rollforward a specific tablespace from backup image due to the file system corruption on container files of that tablespace. Plus, they ask for the access to tables...
from Blog: Thoughts from Support
|
|
When will be free pages available from Rebalance process?
We need to wait for Rebalance to complete in order to use free pages for container involved. We can't make the Rebalanced page "free" when Rebalance is still in progress. Example: Two containers 0, 1, each container/file size...
from Blog: Thoughts from Support
|
|
How to compress the ITCAM Managing Server octigate database tables to get back more disk space. Community Blog
NoelLewis
Tags:
disk
export
space
how-to
schema
server
managing
ibm-blog
tablespace
compress
noellewis
db2
ddl
7,029 Views
If you've been using the ITCAM Managing Server to view data from your monitored Data Collectors over few years now, its likely that some of your tables in the octigate database may be heavily used. This can lead to large amounts of table space usage over...
from Blog: Application Performance Management
Modified on by NoelLewis
|
|
Handling large DB tables in BPM
BinHu
Tags:
business
business_process
table
manager
tablespace
db
process
hwm
bpm
bpmcoaching
lsw_managed_asset_data
tables
ibm-blog
sql
bpmdb
13,286 Views
Introduction Sometimes the BPMDB (Business Process Manager database) will occupy a large amount of disk space. If this space is too large, you have several ways to check the database size and tune up your Database. This article describe the situation when...
Modified on by Paula Jones
|
|
Why a tablespace is being marked offline during rollfowrad, after a DB2 database restore is done
Biswarup(Bis)Mukherjee
Tags:
rollforward
sql3799w
tablespace
restore
sql2036
offline
db2
12,581 Views
One reason why a tablespace might get marked offline after a db2 database restore might be due to issues with tablespace container filesystem or, anything related to access to filesystem containing containers of the...
from Blog: Thoughts from Support
|
|
What is the recommended method to migrate Classic Partitioned Table Spaces to Partitioned By Range Table Spaces? Community Blog
DB2forz/OSUtilitiesDevelopment
Tags:
migrating
tablespace
z/os
utilities
universal
pbr
db2
table
18,050 Views
Universal Table Spaces were introduced in DB2 for z/OS V9 and comprise of two new types: Partitioned By Range and Partitioned By Growth. Universal Partitioned By Range table spaces are a strategic table space type which will, over time, replace...
from Blog: DB2 for z/OS Utilities Development
Modified on by DB2forz/OSUtilitiesDevelopment
|
|
Modifying the Data Layout to Improve Database Performance
By reconfiguring the out-of-the-box data layout, you can optimize the database I/O and have a big impact on performance and concurrency. Reconfiguring the data layout means moving certain tables to different containers, and with new buffer pool configurations....
from Blog: CSE-WebSphere Commerce
|
|
Taking Advantage of Relational Technology - Part 2
This is a continuation of last week's post . Avoid Inappropriate Tablespace Scans There are many DB2 access paths available. The most expensive of these is a tablespace scan because it causes DB2 to scan all the entries of a table to...
from Blog: DB2 Performance Tuning
Modified on by DaveBeulke
|
|
Tablespace I/O Stats(disk i/o)
udbpros-shashimannepalli
Tags:
i/o
writes
udb
containers
tablespace
luw
seconds
db2
1 Comment
9,847 Views
There are multiple ways of getting the tablespace I/O Stats from a db2 udb luw database. Getting the delta information is the tricky part, one of the ways of getting this info Tested in a DB2 UDB LUW V9.5 Database. 1. Create a table like this create...
from Blog: DB2 UDB LUW--Adminstration-Tips
|
|
Skipping Tablespaces while doing Restore
udbpros-shashimannepalli
Tags:
udb
tempspace
luw
restore
db2
syscatspace
drop
backup
tablespace
pending
tablespaces
mannepalli
shashi
3 Comments
13,785 Views
DB2 UDB LUW Restore Command can be used to RESTORE A Set of Tablespaces from a Backup Image which has been Created by DB2 Backup Utility. Skipping Some Tablespace as part of the Restore, is needed in some Scenario's. For example you are trying to Restore a...
from Blog: DB2 UDB LUW--Adminstration-Tips
|
|
Susan Lawson on DB2 Night Show – Monday June 13
On Monday’s DB2Night Show, join host Klaas Brant and special guest Susan Lawson as they talk about DB2 10 Table Spaces new options and migration considerations . This will take place live from the SQL Adria Conference in Dubrovnik Croatia. Susan will cover...
from Blog: Keep on Learning
|
