473,231 Members | 1,309 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,231 software developers and data experts.

DB2 UDB V8 inplace reorg

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? How can I be
sure that a reorg has successfully finished?

I found three methods to watch if an asynchronous reorg has finished:
a) db2 "select * from table(sysproc.snapshot_tbreorg('reo_test',0))
as t"
b) db2 get snapshot for tables on reo_test
c) db2 list history reorg all for db reo_test

Now I´ve started a reorg on a table but I can´t find out if this reorg
has finished although it tells me the reorg has started:

DB20000I The REORG command completed successfully.
DB21024I This command is asynchronous and may not be effective
immediately.
TIA
Anna
Nov 12 '05 #1
1 5273
Hi Anna,

Yes, the reorg will not run on tables that are less than 3 pages in
size. I think something is put to the history file when this happens.

Anna Hutter wrote:
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? How can I be
sure that a reorg has successfully finished?

I found three methods to watch if an asynchronous reorg has finished:
a) db2 "select * from table(sysproc.snapshot_tbreorg('reo_test',0))
as t"
b) db2 get snapshot for tables on reo_test
c) db2 list history reorg all for db reo_test

Now I´ve started a reorg on a table but I can´t find out if this reorg
has finished although it tells me the reorg has started:

DB20000I The REORG command completed successfully.
DB21024I This command is asynchronous and may not be effective
immediately.
TIA
Anna

Nov 12 '05 #2

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

Similar topics

27
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...
9
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...
1
by: hikums | last post by:
1. I did a reorgchk, and found that F2 on table and F4 on index indicates a reorg is necessary. 2. Did a reorg. 3. Again I do a reorgchk, the report is the same as in Step 1 4. I do a...
16
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 -...
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...
2
by: aj | last post by:
DB2 LUW v8.2 FP 14 RHAS 2.1 I'm confused about the NOTRUNCATE TABLE option of the REORG TABLE INPLACE command. In my mind, truncating the table means that you delete all rows that it has - why...
0
by: Roger | last post by:
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...
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: mvsmsh | last post by:
Hi listers , Has anyone met REORG INPLACE error -964 " The transaction log for the database is full " ? I wonder , why REORG INPLACE error -964 even if archive successful ? We're...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.