473,399 Members | 4,177 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

db2 inplace reorg and log space

I changed my classic reorgs to inplace reorg on my siebel database
last weekend and ran into the log space getting full issue . This is
one of the command on my script :

reorg table SIEBEL.ASSET index SIEBEL.XASSET1 inplace;

I have two questions :

1. On the classic reorg, i know the indexes get rebuild. When I issue
the above command, will any of the indexes get rebuild ? If none of
the indexes are rebuild, then is the ASSET table be reorged in the
sequence of the fragmented XASSET1 index ?

2. Should I reorg all the indexes right after the reorg table is done
or can i do it in parrallel ?

3. If I have a huge table, does the reorg commit the changes often or
does 1 commit after the whole reorg. I ran out of all the Primary and
Sec. log. So am wondering how the logging in INPLACE reorg work

I will appreciate if anybody can give me some input to these
Thanks

Roger

Jun 19 '07 #1
0 2168

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

Similar topics

1
by: Anna Hutter | last post by:
Hello, this question is about DB2 UDB V8 and its inplace reorganisation. It seems that in small tables, an inplace reorg doesn´t start. Is there a limit in size of a table when a reorg starts?...
4
by: Lyn Duong | last post by:
Hi Something bizarrae is happening in my db2 udb on aix 8.1.4 database. I deleted all data from a particular database and to reclaim empty pages I have reorg'd and runstated all tables in this...
2
by: TomHorner | last post by:
I have several quick questions about reorg's, and a request (favor). 1. The documentation says that reorg "Reorganizes an index or a table" I cannot see how one would reorg ONE particular index...
13
by: Yuri | last post by:
We have an update sql that was running OK for several months completing in under 2 minutes . Yesterday something changed and we had to kill this update after it ran more than 6 hours. Update input...
2
by: sethwai | last post by:
Hi, I have a nightly script that executes inplace reorgs allow write access for several tables after a previous script does a large number of delete operations. It usually has been executing...
0
by: bwmiller16 | last post by:
Hi All - OSName: AIX NodeName: dr_aixdb01 Version: 5 Release: 3 dr_aixdb01$db2level DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL08027"
3
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...
0
by: mvsmsh | last post by:
Hi Listers , While REORG INPLACE WRITE ACCESS , large and frequently update table , previous' DBA got experience that all the program could not access the table during the last phase of the...
0
by: Jack Campbell | last post by:
I am currently running Q-Replication on one of my DB2 luw servers (unix). We currently run all our REORG's as classic (offline) each weekend. As our REORG window is to be removed, I need to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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...
0
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,...
0
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...
0
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...
0
agi2029
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,...

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.