473,730 Members | 2,058 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Stripe sets, high watermark and restores

Hi,

I have some questions related to stripe sets that I'm hoping someone here
can answer.

1) What happens to stripe sets when doing a database restore? Do they stay
as is?

2) What happens to stripe sets when doing a redirect database restore? Will
a new tablespace map be created by this and thus override the existing
stripe sets?

3) From my current understanding, if I add a new stripe set the extent
numbering starts from the last extent in the previous stripe. So when data
is added it will still continue from the lowest available extent and go up
correct? And thus my new new stripe set will not receive data until the
lowest extent number available falls within this new stripe set correct?

4) Now if I have 1 stripe set which is 20MB (STRIPE 1), then I add another
stripe set of 10MB (STRIPE 2) and I load 25MB worth of data into this
tablespace. If I then increase STRIPE 1 (by extending the containers or
adding new containers to it) with 20MB. What will happen with the extent
numbering? Will this added on space in STRIPE 1 continue it's extent
numbering with the last extent number of STRIPE 2? So that for example I
have something like:

Before increasing STRIPE 1:
STRIPE 1: Extent 1 -> Extent 40
STRIPE 2: Extent 41 -> Extent 61

After increasing STRIPE 1:
STRIPE 1: Extent 1 -> Extent 40
STRIPE 1: Extent 62 -> Extent 102
STRIPE 2: Extent 41 -> Extent 61

Or will the extent number change so that I end up with:
STRIPE 1: Extent 1 -> Extent 40
STRIPE 1: Extent 41 -> Extent 81
STRIPE 2: Extent 82 -> Extent 102

In which case, the data that used to be between extent 41 and 61 is now
sitting between extent 82 and 102. If this is the case, then my high
watermark thus increases as well correct?
Thanks for the insight.
Nov 12 '05 #1
1 4092
See below in your note ###########

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Erik Hendrix" <he**********@h otmail.com> a écrit dans le message de news:
1120171052.7703 4d4a14585d7e548 c8865f3eeed5a@t eranews...
Hi,

I have some questions related to stripe sets that I'm hoping someone here
can answer.

1) What happens to stripe sets when doing a database restore? Do they stay
as is? ########### Yes. Restore brings the data in the same place it lifted it
from, For one, that way, the indexes do not have to be rebuilt in a restore
as the ponters have not moved. The data page is placed in its original
"relative" place (how far from pade 0 of the tablespace) 2) What happens to stripe sets when doing a redirect database restore?
Will
a new tablespace map be created by this and thus override the existing
stripe sets? ########### A redirected restore builds new containers. Each new container
must be as big as the high water mark of the old ones. The data within the
high water mark returns in the same "relative" place as where it was lifted
from. Stripe sets and maps could change as you could redirect and add one or
more NEW containers.
3) From my current understanding, if I add a new stripe set the extent
numbering starts from the last extent in the previous stripe. So when data
is added it will still continue from the lowest available extent and go up
correct? And thus my new new stripe set will not receive data until the
lowest extent number available falls within this new stripe set correct? ########### Adding as new stripe set is: alter tablespace.... begin new
stripe set...
You typically do that because you have no more space in the containers, you
need to add some and you do not want to rebalance. This makes the space
immediately available. If you space left in the old containers, I believe
db2 will use that before using the new stripe set, so you are correct.
If you use: alter tablespace ...
4) Now if I have 1 stripe set which is 20MB (STRIPE 1), then I add another
stripe set of 10MB (STRIPE 2) and I load 25MB worth of data into this
tablespace. If I then increase STRIPE 1 (by extending the containers or
adding new containers to it) with 20MB. What will happen with the extent
numbering? Will this added on space in STRIPE 1 continue it's extent
numbering with the last extent number of STRIPE 2? So that for example I
have something like: ########### If you add a new stripe, it must be defined in a new container.
No rebalance should happen.
As you extend Container 0 by ADD TO STRIPESET 1, you cause a rebalance of
the tablespace, so I believe that your Map and stripes will be different.
See following discussion in Docs. at:
http://publib.boulder.ibm.com/infoce...oc/welcome.htm
and look for: How containers are added.... in the search results column on
the left.
HTH, Pierre.
Before increasing STRIPE 1:
STRIPE 1: Extent 1 -> Extent 40 In Container 0
STRIPE 2: Extent 41 -> Extent 61 In Container 1, added with ..begin new
stripe set..

After increasing STRIPE 1: ############ No, I believe this is what
willhappen
STRIPE 1: Extent 1 -> Extent 40 STRIPE 1: Extent 1 ->
Extent 40, in Container 0
STRIPE 1: Extent 62 -> Extent 102 STRIPE 1: Extent 62 ->
Extent 102 in Container 1
STRIPE 2: Extent 41 -> Extent 61

Or will the extent number change so that I end up with:
STRIPE 1: Extent 1 -> Extent 40
STRIPE 1: Extent 41 -> Extent 81
STRIPE 2: Extent 82 -> Extent 102

In which case, the data that used to be between extent 41 and 61 is now
sitting between extent 82 and 102. If this is the case, then my high
watermark thus increases as well correct?
Thanks for the insight.


Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3745
by: Kevin McDaniel | last post by:
I was wondering if anyone has heard of problems with the Export utility writing dump files on stripe-sets. I'm not sure if the stripe-set is configured correctly or not, but everytime I place my dump file on this set, I can't import it. I always get errors/crashes. I appreciate your help. Cheers. Kevin
1
2361
by: Jordan Peterson | last post by:
I'm trying to put a vertical blue stripe with a black border on this page that will remain colored even if the page is scrolled in the UA. http://maba.org/new/homeproducts/ As you can see, the stripe is there, but Gecko only draws it for the initial viewport and chops it off if one scrolls down. MSIE stops drawing the background color at the end of the last link on the left side. I've messed around with the stylesheet to no end, and...
2
1840
by: xixi | last post by:
hi, i would like to choose dms type tablespace for the user data , the server is db2 udb v8.1 on windows 64 bit, the volume created is use stripe type, so it will cross the data on two different disk with same logical volume , is this help for performance, will this cause problem if we need to restore in different server without multiple disk ?
2
3121
by: p175 | last post by:
Hi folks, I've tried reading just about every post I can on raid stiping / extent size etc and I'm just getting myself more confused than ever. Here's my situation. On a Windows Server 2000 standard edition system with only 1gb ram using UDB 8.2.3 Enterprise, I have an existing database that uses two raid arrays striped with 8kb. Presently the tablespaces have a default extent of 24, default prefetch of 48 .
1
2161
by: unerwartet | last post by:
Hi, I want to access the high-watermark-vector of a specific domain controller in the active directory from c#. But I do not know how to achieve this. I tried it with: LDAP://CN=TheDomainController,OU=Domain Controllers,DC=my,DC=domain,DC=net
3
4098
by: alexhguerra | last post by:
hello folks anyone knows how to reset tablespace high watermarks counters? thanks alexandre
9
5870
by: Chuck Anderson | last post by:
Is it possible to overlay a transparent watermark on an image - dynamically? I'd like the result to look like this example: <http://www.cycletourist.com/temp/photo.php> That is a bit of overkill, but you can see what I mean. The watermark image (a png image) is included separately below the photo. I tried using a class from phpclasses.org <http://www.phpclasses.org/browse/package/1580.html...
0
2212
by: =?Utf-8?B?S2Vycnk=?= | last post by:
Hi all -- I am a long-time C programmer and "medium-time" C++ programmer, but am brand new to C#. I am creating a simple app using C# and I need help. The app will display a "watermark" on the screen at certain times. When the watermark is visible, it will be on top of all other applications. To get the look I wanted, I created a simple form, imported a bitmap image as the background to the form, and set the opacity to 15%. I set...
5
4155
by: Mark A | last post by:
I have an OLTP database that has a tablespace that will start out at about 1 TB, but may grow to 75 TB's in size over the next 5 years. When I add new containers (on a new mount point), I want to use the BEGIN NEW STRIPE SET command to avoid rebalancing. Anyone know the maximum number of STRIPE SET's that can be created for a tablespace.
0
8940
marktang
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...
0
8770
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9440
Oralloy
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...
0
9299
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
4541
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4800
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3251
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2710
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2174
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.