by: Lara |
last post by:
Hello freaks,
we have many problems with our online reorg and no idea how to resolve
it.
We had to do an online reorg beacause of 24 h online business.
We start the reorg-statements (table by...
|
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...
|
by: andy.standley |
last post by:
Hi,
we are running DB2 V8.2 (8.1.0.80) on redhat linux and I am trying to
set the reorg to be online. I use the control center on the box - db2cc
and then configure automatic maintenance wizard -...
|
by: Rojo Royo |
last post by:
Hi,
I am using Q replication on a system 390 running DB2 version 7. When I
replicating data no problem and then suddenly someone does an online reorg,
my databases loses synchronization source...
|
by: Wasted Youth |
last post by:
I am having a problem in LUW. I submitted around 30 online reorgs. About half of them finished and the other half went into PAUSE status. My fellow DBA thinks it is a problem with running out of log...
|
by: laurenquantrell |
last post by:
I have a table with 6 million rows.
I'm trying to perform a group by query that incudes a row count of the
PK column:
SELECT COUNT(DataID) AS Cnt, Column1Name
FROM dbo.TableName
WHERE...
|
by: mike_dba |
last post by:
DB2 V8 FP14 on RedHat Linux
Single Partition Database
Tables with LOB data
Periodically, a large delete is performed by the application. I need
to perform a Reorg. The nature of my database...
|
by: jane |
last post by:
Hi,
Just wondering, is there any way to do the online reorg to use
temporary tablespace instead of tablespace table existed.
since that is really a waste to have some space allocated aside...
|
by: tg |
last post by:
I have been using the online reorg for over 2 years without any
problems. I have just encountered a log full condition after having
started the online reorg on the same table that I have been...
|
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: 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...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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,...
|
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...
|