Express C v9.1
I'm having a hell of a job trying to reduce the highwater mark for
various tablespaces in Express C. DB2MART advises to reorg several
tables with LONGLOBDATA and to disconnect, reconnect between each step,
but the tablespace snapshot is still showing a highwater mark as
follows.
Total number of pages = 2560000
Number of usable pages = 2559960
Number of used pages = 166368
Number of pending free pages = 75744
Number of free pages = 2317848
High water mark (pages) = 2559960
Current tablespace size (bytes) = 10485760000
Maximum tablespace size (bytes) = NONE
Increase size (bytes) = AUTOMATIC
Time of last successful resize =
Last resize attempt failed = No
Rebalancer Mode = No Rebalancing
Minimum Recovery Time =
Number of quiescers = 0
Number of containers = 1
I've followed the DB2MART instructions to the letter, reorgs seem to
work fine, where am I going wrong ya think ?
Thanks for the help 8 7415
Did you include the LONGLOBDATA keyword in your reorg command? It should
significantly increase the reorg time. See details in the Command
Reference manual under REORG INDEXES/TABLE.
It would have been helpful if you'd included the reorg command with your
original post.
Phil Sherman
p175 wrote:
Express C v9.1
I'm having a hell of a job trying to reduce the highwater mark for
various tablespaces in Express C. DB2MART advises to reorg several
tables with LONGLOBDATA and to disconnect, reconnect between each step,
but the tablespace snapshot is still showing a highwater mark as
follows.
Total number of pages = 2560000
Number of usable pages = 2559960
Number of used pages = 166368
Number of pending free pages = 75744
Number of free pages = 2317848
High water mark (pages) = 2559960
Current tablespace size (bytes) = 10485760000
Maximum tablespace size (bytes) = NONE
Increase size (bytes) = AUTOMATIC
Time of last successful resize =
Last resize attempt failed = No
Rebalancer Mode = No Rebalancing
Minimum Recovery Time =
Number of quiescers = 0
Number of containers = 1
I've followed the DB2MART instructions to the letter, reorgs seem to
work fine, where am I going wrong ya think ?
Thanks for the help
Yes I did Phil and the following the command I entered in all cases:
DB2 REORG TABLE DB2ADMIN.ABC LONGLOBDATA RESETDICTIONARY
Total number of pages = 2560000
Number of usable pages = 2559960
Number of used pages = 166368
Number of pending free pages = 75744
Number of free pages = 2317848
High water mark (pages) = 2559960
The fact that you have a non-zero number of pending-free pages suggests
that you havent completely deactivated/reactivated the database. It
wouldnt suprise me if the HWM is in one of those pending free extents.
When you disconnected/reconnected to the db, was the another active
session? The suggestion to bounce your connection is intended to ensure
that there arent any active transactions in the db.
jsoh
I know thats weird, as I am the only user and I was watching the
deallocation - reallocation of bp memory etc as the connections bounced
just to make sure. I just can't figure why it won't work, it's
bizzarre. If I re-run the DB2DART program afterwards, it is no longer
listing the tables that have been reorg'd so that seems to be working.
I'm getting the highwater mark from a snapshot I run after the DB2DART
process, so is there anything I should be doing differently there
perhaps ?
I've also checked the consistency flag after deactivating and it is set
to yes so it appears everything should be fine. I have no idea why
there would be pending pages.
Here's a listing from DB2DART *after* having run a job that included
all the recommendations. What I don't understand is the highwater mark
does't correspond to step 1 and subsequent tables. It starts with
listing 106665 extents, but in step 1 says that the current is 6161 and
reduces this by the dat object size in subsequent steps.
Obviously what I need is to reclaim the 101176 extents below HWM.
--------------------------------------------------------------------------------------------
Highwater Mark: 2559960 pages, 106665 extents (extents #0 - 106664)
Lower highwater mark processing - phase start.
Current highwater mark: 106664
Desired highwater mark: 0
Number of used extents in tablespace: 5489
Number of free extents below original HWM: 101176
Number of free extents below desired HWM: 0
Number of free extents below current HWM: 101176
Step #1: Object ID = 274
=Offline REORG of this table using the LONGLOBDATA option (do not
specify a temporary tablespace).
Table: DB2ADMIN.T1
DAT object size: 440
INX object size: 0
XDA object size: 0
LF object size: 0
LOB object size: 0
LOBA object size: 0
BMP object size: 0
Total size of object parts: 440
Minimum number of extents that will move by this operation: 440
Current highwater mark: 6161
Desired highwater mark: 0
Number of used extents in tablespace: 5489
Number of free extents below original HWM: 101176
Number of free extents below desired HWM: 0
Number of free extents below current HWM: 673
Step #2: Object ID = 526
=Offline REORG of this table using the LONGLOBDATA option (do not
specify a temporary tablespace).
Table: DB2ADMIN.T2
DAT object size: 430
INX object size: 0
XDA object size: 0
LF object size: 0
LOB object size: 0
LOBA object size: 0
BMP object size: 0
Total size of object parts: 430
Minimum number of extents that will move by this operation: 430
Current highwater mark: 5673
Desired highwater mark: 0
Number of used extents in tablespace: 5489
Number of free extents below original HWM: 101176
Number of free extents below desired HWM: 0
Number of free extents below current HWM: 185
Step #3: Object ID = 260
=EXPORT all data from table, drop the table, disconnect, reconnect,
recreate the table, and LOAD the data back into the table.
Table: DB2ADMIN.T3
DAT object size: 265
INX object size: 0
XDA object size: 0
LF object size: 0
LOB object size: 0
LOBA object size: 0
BMP object size: 0
Total size of object parts: 265
Minimum number of extents that will move by this operation: 265
Current highwater mark: 5488
Desired highwater mark: 0
Number of used extents in tablespace: 5489
Number of free extents below original HWM: 101176
Number of free extents below desired HWM: 0
Number of free extents below current HWM: 0
Final highwater mark: Extent #5488 (5489 extents, 131736 pages).
** This cannot be lowered further as there are not enough free extents
to move the object holding the highwater mark.
Lower highwater mark processing - phase end.
Highwater mark processing - phase end.
Here's a listing from DB2DART *after* having run a job that included
all the recommendations. What I don't understand is the highwater mark
does't correspond to step 1 and subsequent tables. It starts with
listing 106665 extents, but in step 1 says that the current is 6161 and
reduces this by the dat object size in subsequent steps.
Obviously what I need is to reclaim the 101176 extents below HWM.
Frankly, I'm a little confused by all the data that your dumping out -
I really dont have a clear idea whats going on.
Have you tried running db2dart with the option which prints out each
extent in the tablespace, its free/used status, and which object owns
it, if its in use? I believe its /LHWM - dont have the docs in front of
me at the moment.
Its possible that the HWM is being held up by a system page that cant
be moved - but I would have thought that dart would have mentioned
that.
jsoh This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Larry Woods |
last post by:
I am losing Session variables, but only those that are set in the page
previous to a redirect to a secure page.
Anyone seen ANY situation where Session variables just "disappear?"
Note that...
|
by: Andrew Mogford |
last post by:
Hi,
We have moved a web site from a development server running Windows 2000 and
IIS 5 to a Windows 2003 server running IIS 6.0
Now the asp pages do not work correctly. For example,...
|
by: mairhtin o'feannag |
last post by:
Hello,
I have a tablespace striped across three drives, call them 1,2,3, just to
be clever. :) I allocated a lot more space (DMS) than I should have,
since I didn't know a way to estimate the...
|
by: Greg Merideth |
last post by:
I've written a basic windows service to provide some helper xml functions for
my web methods and even thou the service is only about 1k lines long with 1
timer, its mem usage is 10m and its vm mem...
|
by: foldface |
last post by:
Hi
Anyone got any general tips on reducing complexity on 'bigish'
pages?
I'm thinking here of a page with a number of usercontrols, all posting
back,
dynamic controls being added, having...
|
by: Mark B |
last post by:
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight.
They couldn't get the server working again so they...
|
by: Patrick |
last post by:
I have a tablespace that contains the LOB data for 3 tables which exist
in other tablespaces. Even after reorging the LOB tablespace with the
LONG option, the high water mark is still too high. I...
|
by: derekdeben |
last post by:
Hi,
I created a report that groups on week ending dates and has a total for each date and a grand total for the month. However, The report is 13 pages long with many blank pages since I said...
|
by: markla |
last post by:
Hi,
I have an EDM model, which I'm rendering using DynamicData pages.
I need to add a derived/calculated field.
For example, in a "Person" entity, I have LastName and FirstName. I need to...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |