If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > compress yes for temporarily table --> automatic implemented?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: May 2012
Posts: 155
compress yes for temporarily table --> automatic implemented?

Hallo everyone,

if I am creating a session table with command DECLARE GLOBAL TEMPORARY TABLE, and I want to implement row compression, do I have to explicitely COMPRESS YES ?

I am really not sure, because in the manual:
Code:
the row compression for temporarily table is automatically activated from DB2 Storage Optimization
Thank you for the advice.

Regards,
Ratna
Reply With Quote
  #2 (permalink)  
Old
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,378
Quote:
Originally Posted by ratnalein View Post
I am really not sure, because in the manual:
So, you don't believe what the manual says? Did you find the COMPRESS option in the DECLARE GLOBAL TEMPORARY TABLE statement description?
__________________
---
"It does not work" is not a valid problem statement.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Nov 2009
Posts: 14
Hi


For your question regarding compression... from db2 9.7 we can use create global temporary table CGTT which has compression enabled by default.

From the manual

"Table compression is on by default for CGTT (if you purchase the option)."

DGTT (Declare Global temporary tables) doesn't have compression enabled and you cannot enable with compress yes. I haven't seen an option in the syntax for declare global temporary table. Hope this helps.
Reply With Quote
  #4 (permalink)  
Old
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,378
Quote:
Originally Posted by surgeon View Post

DGTT (Declare Global temporary tables) doesn't have compression enabled
Wrong.

But then again, if one doesn't believe what the manual says...

Quote:
Originally Posted by The fine manual
Data row compression is enabled for a declared temporary table. When the database manager determines that there is a performance gain, table row data including XML documents stored inline in the base table object will be compressed. However, data compression of the XML storage object of a declared temporary table is not supported.
Index compression is enabled for indexes that are created on declared temporary tables.
__________________
---
"It does not work" is not a valid problem statement.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On