dbTalk Databases Forums  

Auto Resize while REORG

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


Discuss Auto Resize while REORG in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Pierre StJ
 
Posts: n/a

Default Auto Resize while REORG - 11-01-2011 , 01:46 PM






DB2 V9R7.3
DB is automated storage
Does autoresize happen when running reorg offline with no tempspace
assigned?
If container cannot hold the copy of the table when reorg is launched
is it autoresized with warning message or does the command fail?
Thanks, Pierre.

Reply With Quote
  #2  
Old   
Frederik Engelen
 
Posts: n/a

Default Re: Auto Resize while REORG - 11-03-2011 , 03:14 AM






On 1 nov, 20:46, Pierre StJ <p.stjacq... (AT) videotron (DOT) ca> wrote:
Quote:
DB2 V9R7.3
DB is automated storage
Does autoresize happen when running reorg offline with no tempspace
assigned?
If container cannot hold the copy of the table when reorg is launched
is it autoresized with warning message or does the command fail?
Thanks, Pierre.
I'm pretty sure it is resized but if you already have the knowledge to
ask that question it should be trivial for you to test that behaviour.
Just let us know afterwards, ok?

--
Frederik Engelen

Reply With Quote
  #3  
Old   
Pierre StJ
 
Posts: n/a

Default Re: Auto Resize while REORG - 11-04-2011 , 02:04 PM



On Nov 3, 5:14*am, Frederik Engelen <engelenfrede... (AT) gmail (DOT) com> wrote:
Quote:
On 1 nov, 20:46, Pierre StJ <p.stjacq... (AT) videotron (DOT) ca> wrote:

DB2 V9R7.3
DB is automated storage
Does autoresize happen when running reorg offline with no tempspace
assigned?
If container cannot hold the copy of the table when reorg is launched
is it autoresized with warning message or does the command fail?
Thanks, Pierre.

I'm pretty sure it is resized but if you already have the knowledge to
ask that question it should be trivial for you to test that behaviour.
Just let us know afterwards, ok?

--
Frederik Engelen
Thanks Frederic. I thought the same but could not verify or test.
I'll do so soon and will post results.
Regards, Pierre.

Reply With Quote
  #4  
Old   
Helmut Tessarek
 
Posts: n/a

Default Re: Auto Resize while REORG - 11-04-2011 , 06:41 PM



Quote:
DB2 V9R7.3
DB is automated storage
Does autoresize happen when running reorg offline with no tempspace
assigned?
If container cannot hold the copy of the table when reorg is launched
is it autoresized with warning message or does the command fail?
Thanks, Pierre.
The tablespace containers will automatically resize.

--
Helmut K. C. Tessarek
DB2 Performance and Development
IBM Toronto Lab

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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.