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  7462 
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 OTHER session variables are still intact !?!
TIA,
Larry Woods
|
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, request.form() no
longer returns data from the calling form.
I have turned web services extensions on to allow active server pages.
The pages do work to some extent, I can even setup a connection to a
database and retrieve stored procedure parameters, but...
|
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 space required (long story, but
the original space was in one huge tablespace for all tables ((35 million
row tables)) and I needed to segregate them out into separate tablespaces
for backup and restore purposes.
So I allocated, like 4 million...
|
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 usage is 14! The same code written
as a program that requires you to click on the menu options to fire off the
events takes up 4/9mb.
I've seen examples where calling SetProcessWorkingSetSize(hWnd, -1, -1); does
the same thing as minimizing a...
|
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 UserControls with similiar logic
but
completely different GUIs, etc
The only worthwhile tip I can think of is this. If you have a page
| | |
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 transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.
That was a week ago.
Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.
|
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 want to be able
to shrink the tablespace below the current high water mark and return
the excess space back to the filesystem. Is there another way to lower
the HWM without exporting the data to another tablespace, dropping and
recreating the...
|
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 "no" to visible detail. How do I change the report to print everything on one page. It should fit but the hidden detail is forcing multiple pages.
Thanks in advance,
Derek
|
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
add a derived field FullName (being LastName + ", " + FirstName)
I have tried adding the FullName field to Person's EDM partial class, and
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
