Unix Technical Forum

Online Reorg of LOB data

This is a discussion on Online Reorg of LOB data within the DB2 forums, part of the Database Server Software category; --> DB2 V8 FP14 on RedHat Linux Single Partition Database Tables with LOB data Periodically, a large delete is performed ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 01:48 PM
mike_dba
 
Posts: n/a
Default Online Reorg of LOB data

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 prevents me from
obtaining an off-hours window for the Reorg. Can I reclaim space for
LOB data ON-LINE while read/write activity is occurring? For OFFLINE
reorg, I have previously issued the LONGLOBDATA keyword. It doesn't
look to be available for ONLINE reorg. If not, how does one go about
it.

Thanks in advance for your input

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 01:49 PM
mike_dba
 
Posts: n/a
Default Re: Online Reorg of LOB data

Anyone have any comments ? Thank you.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 01:49 PM
Serge Rielau
 
Posts: n/a
Default Re: Online Reorg of LOB data

mike_dba wrote:
> Anyone have any comments ? Thank you.

Not supported.

You're welcome
Serge


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:40 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com