Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

fullyMaterializeLobData value?

Does anyone know the fullyMaterializeLobData when you setup DB2 with Jazz? all the documents says it's false, what if i set it to true?
i read this http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0010279.htm
but don't quite understand.

0 votes



4 answers

Permanent link
That setting has to do with whether large blobs are read completely into
memory or streamed out of the DB. If you set
fullyMaterializeLobData=true, then you can easily run out of memory.

Did you find a problem with fullyMaterializeLobData=false?

-
Matt Lavin
Jazz Server Team


On Fri, 2009-02-06 at 18:17 +0000, mman wrote:
Does anyone know the fullyMaterializeLobData when you setup DB2 with
Jazz? all the documents says it's false, what if i set it to true?
i read this
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0010279.htm
but don't quite understand.

0 votes


Permanent link
But what's good about setting it to true? I have an Redhat box with 12G memory supporting for up to 250 users. Thank you

0 votes


Permanent link
I don't know of any reason to set it to true. It might be possible that
there is some use case where you would want a very particular behavior
from the LOB locators as described in the link you sent, but in RTC we
have designed and tested it to work with it set to false. In 2.0 it
will be hard-coded to false.

-
Matt Lavin
Jazz Server Team


On Fri, 2009-02-06 at 18:47 +0000, mman wrote:
But what's good about setting it to true? I have an Redhat box with
12G memory supporting for up to 250 users. Thank you

0 votes


Permanent link
Great! Thank you :D

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Feb 06 '09, 1:16 p.m.

Question was seen: 7,599 times

Last updated: Feb 06 '09, 1:16 p.m.

Confirmation Cancel Confirm