MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

question regarding BLOB storage utilization

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
vmbigot
Beginner


Joined: 17 Jun 2004
Posts: 36
Topics: 14
Location: westminster, california
PostPosted: Mon Nov 06, 2006 5:21 pm    Post subject: question regarding BLOB storage utilization Reply with quote
We are creating tables with BLOB columns along with the appropriate AUX table for each BLOB column. For example, we have defined a BLOB column as 2K in size. See below for the base and AUX table DDL:

Code:

CREATE TABLE FDBMD.TESTIMAGE                                       
    (IMAGE_ID           INTEGER GENERATED BY DEFAULT AS IDENTITY   
                       (START WITH 0          ,                     
                        INCREMENT BY 1        ,                     
                        CYCLE                 ,                     
                        MINVALUE -2147483648  ,                     
                        MAXVALUE  2147483647) ,                     
     IMAGE_B            BLOB(2K)              ,                     
     PRIMARY KEY (IMAGE_ID))                                       
       IN FDBMD.FTSBLOB                                             
       ;                                                           


Code:

CREATE AUX TABLE FDBMD.TESTIMAGE_IMAGEB                 
       IN FDBMD.FTSBLOBA                                 
           STORES FDBMD.TESTIMAGE                       
           COLUMN IMAGE_B                               
       ;                                                 


When using Control Center to look at the columns for the base and AUX table, we see column IMAGE_B in the base table FDBMD.TESTIMAGE defined at 2048 bytes. We see column IMAGE_B in AUX table FDBMD.TESTIMAGE_IMAGEB also defined at 2048 bytes.

The question is this. Does DB2 allocate 2048 bytes for each column in the base table and the AUX table or is one a pointer to the other? Or are we completely off base here!?! Question Question
_________________
Inside every older man is a young boy asking this question. What the heck happened?!?
Back to top
View user's profile Send private message
mayuri
Beginner


Joined: 26 Aug 2006
Posts: 17
Topics: 4
PostPosted: Fri Nov 17, 2006 6:04 am    Post subject: Reply with quote
hi

hope this link helps you

http://www.dbazine.com/db2/db2-mfarticles/mullins-lobs

Mayuri
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group