|
by: Raquel |
last post by:
This question if for UDB on LUW. Suppose I take regular database
backups of my database
Monday: database backup <ts1>
Tuesday: Tablespace reorged and imagecopied <ts2>
Friday: database restored and roll-forwarded to a timestamp <ts3> on
Wednesday.
Now my question is: because the entire database is being
roll-forwarded, I suppose the database roll forward operation will
|
by: GB |
last post by:
Hi All,
I would like to optimize my reorgs.
Here are several ways to shorten reorgs or keep data online during reorgs:
- db2 reorg has some shrlevel option: reference or change
- db2 v7 has an option for reorganizing everything but not the blob's
- third party tools like bmc reorg plus
- others ?
|
by: derekbarrett |
last post by:
Hi all,
Our business is in manufacturing, and we are running SAP on DB2 8.1,
planning on upgrading to 8.2.2 within a couple of months. We are
running operations 24/7, so are looking for ways to reduce our
maintenance impact to our users. Our users hit some specific SAP tables
very heavily, and concurrently, so even doing an online REORG causes
some system slowdown. We are looking for ways to reduce these slowdown
times, because even...
|
by: kartic_s |
last post by:
he brief explanation of the problem is,
After DB2 maintenance window performance has gone down, it takes some hours to retrieve the data.
We have provided some table spaces to Reorg/Runstat during the maintenance window .
After REORG some of the tablespaces, the performance is very slow .This is really strange because no code changes has been involved and also nothing was changed, it's just a Reorg of some tablespaces.
I think this...
|
by: dunleav1 |
last post by:
I have a many row and many column table that is in a 16K page size.
I have four indexes on the table.
I am running row compression on the table.
The table does not have a primary key.
The table does not have a clustered index.
I ran a reorg on the table and the indexes.
I ran runstats on the table and the indexes after the reorg.
Three indexes on the table have an index cluster ratios of 99,99,100
respectively.
The fourth index has a...
|
|
by: saidev |
last post by:
Hi Team,
In our production env we are encountering a issue with the reorg and overall application perforamnce as well. Application with some level of concurrency goes into lock contention and overall application performance. During one of the biggest table reorg only took 7 hour to finish its table and indexes. Total rows into that table is 100 mil and approx size of the table is 11 GB. I have done reorg against the same table in...
|
by: Ah Yu (Quentin) |
last post by:
Hi,
Does anyone know how to run a reorg job with limited impact to system
performance? When my reorg job is running, I cannot see "get
utilities" give result entry related to the reorg job and hence I
cannot set UTIL_IMPACT_PRIORITY to reorg job.
I can make another job runstat command directly with parameter
UTIL_IMPACT_PRIORITY for limiting system performance impact. Does
UTIL_IMPACT_PRIORITY only support runstat, backup utilities?
|
by: lfhenry |
last post by:
Hi,
I would like to reorg my HADR DB. I know the IBM HADR recommendation
is to use inplace. I made reorg a while back and got some serious
locks happening. We are a 24 hour operation.
My first priority is to not have any locks/minize my lock problems, i
am not so worried about performance (logging) as i will run the online
reorg during the midnight hours.
I want to run this reorg as i've noticed that my DB space usage has
been increasing...
|
by: antonyrajeshi |
last post by:
Hi
Environment: DB2 v9.5 Workgroup edition on Windows 2003. the tablespaces are in a SAN storage.
I am processing about 10 million records in one maintable and about 12 million in another in my database. Data is being gradually added to these tables. There are some SQL procedures that work on these tables and populate other set of tables (some of which could have as many records as these main tables).I have noticed a drastic slowness in the...
|
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: 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...
|
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: 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: 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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
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...
|