reorg pending table

#1

9.5 LUW

Is it possible to determine whether a table is in reorg pending state,
if so how? (before one encounters either SQL0668N or SQL20054N)

/Lennart

#2

On May 5, 10:55*am, Lennart Jonsson <erik.lennart.jons... (AT) gmail (DOT) com>
wrote:

Quote:

9.5 LUW

Is it possible to determine whether a table is in reorg pending state,
if so how? (before one encounters either SQL0668N or SQL20054N)

This is what I answered to a similar question back in 2007:

----

Try the ADMINTABINFO Administrative View:

select TABSCHEMA, TABNAME
from SYSIBMADM.ADMINTABINFO
where REORG_PENDING = 'Y'

Described in the Information Center: http://tinyurl.com/3aqkes

---

HTH
Jeroen

#3

On May 5, 11:24*am, The Boss <nlt... (AT) baasbovenbaas (DOT) demon.nl> wrote:

Quote:

On May 5, 10:55*am, Lennart Jonsson <erik.lennart.jons... (AT) gmail (DOT) com
wrote:

9.5 LUW

Is it possible to determine whether a table is in reorg pending state,
if so how? (before one encounters either SQL0668N or SQL20054N)

This is what I answered to a similar question back in 2007:

----

Try the ADMINTABINFO Administrative View:

select TABSCHEMA, TABNAME
from SYSIBMADM.ADMINTABINFO
where REORG_PENDING = 'Y'

Described in the Information Center:http://tinyurl.com/3aqkes

---

In addition to that:
Leon Katsnelson wrote a nice article covering this admin view:
http://freedb2.com/2008/07/15/everyt...where-to-look/

--
Jeroen

#4

On 2010-05-05 11:34, The Boss wrote:

Quote:

On May 5, 11:24 am, The Boss <nlt... (AT) baasbovenbaas (DOT) demon.nl> wrote:
On May 5, 10:55 am, Lennart Jonsson <erik.lennart.jons... (AT) gmail (DOT) com
wrote:

9.5 LUW

Is it possible to determine whether a table is in reorg pending state,
if so how? (before one encounters either SQL0668N or SQL20054N)

This is what I answered to a similar question back in 2007:

----

Try the ADMINTABINFO Administrative View:

select TABSCHEMA, TABNAME
from SYSIBMADM.ADMINTABINFO
where REORG_PENDING = 'Y'

Described in the Information Center:http://tinyurl.com/3aqkes

---

In addition to that:
Leon Katsnelson wrote a nice article covering this admin view:
http://freedb2.com/2008/07/15/everyt...where-to-look/

Excellent, thanks

/Lennart

Quote:

--
Jeroen

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

reorg pending table

comp.databases.ibm-db2 comp.databases.ibm-db2

reorg pending table - 05-05-2010 , 03:55 AM

Re: reorg pending table - 05-05-2010 , 04:24 AM

Re: reorg pending table - 05-05-2010 , 04:34 AM

Re: reorg pending table - 05-05-2010 , 05:16 AM