Forums | Admin

Discussion Forums: help

Start New Thread Start New Thread

 

By: Jeff Rule
RE: New 1.5.0 driver setup [ reply ]  
2009-09-14 19:17
Thanks for the quick and concise reply!

By: Praveen Devarao
RE: New 1.5.0 driver setup [ reply ]  
2009-09-14 05:17
Hi Jeff,

Setting of applheapsz to AUTOMATIC will do fine. This is because the database manager will use the amount of memory as required. Given that the memory usage for appl_heapsz is limited by appl_memory ensure appl_memory is also set to automatic or to a value equal to or more than 1024.

Check this link to see how the parameters applheapsz and appl_memory is related http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.config.doc/doc/r0000265.html

If a user does not want to set the value of applheapsz to AUTOMATIC but want to explicitly specify a value, then 1024 is the minimum recommended value, hence the documentation.

Coming to the next setting, patch2 = 58 still holds good. This is set to avoid getting a DateTime field overflow error. Say for instance you have a column of type date, but in your Rails application you are passing a timestamp, 18.days.ago, to be inserted then setting of patch2 58 will ensure that a proper value is inserted into the column i.e just the date part.

Let me know if you require more details.

Thanks

Praveen

By: Jeff Rule
New 1.5.0 driver setup [ reply ]  
2009-09-14 02:21
I am using the new 1.5.0 version of the ibm_db driver. Looking at the read me I had a couple of questions.

1) Is it still necessary to update db cfg to APPLHEAPSZ 1024 with db2 9.5. or Does the AUTOMATIC feature take care of this?

2) Is it still necessary to set cli cfg as such
db2 UPDATE CLI CFG FOR SECTION COMMON USING PATCH2 58

Some of this documenation seems a bit out of date and may not be relevant for recent releases of DB2...

I am using db2 LUW connecting to db2 9.5 databases

In case it makes a difference I am using a couple of different db configurations...

Development is: Windows XP Pro Client -> Windows XP Pro DB
Production is: linux client -> linux DB.

development instance info...

$ db2level

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09054" with
level identifier "06050107".
Informational tokens are "DB2 v9.5.400.576", "s090429", "WR21449", and Fix Pack
"4".

Product is installed at "D:\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1".

And DB CFG AS FOLLOWS...

db2 get db cfg | grep -i APPLHEAPSZ
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(512)


Production instance info baiscally the same but it is using fix pack 3a rather the FP 4 and is Linux rather then Windows.

$ db2level
DB21085I Instance "q3gmiflp" uses "64" bits and DB2 code release "SQL09053"
with level identifier "06040107".
Informational tokens are "DB2 v9.5.0.3", "special_21393", "MI00269_21393", and
Fix Pack "3a".
Product is installed at "/opt/ibm/db2/V9.53AS".

[q3gmiflp@qa3-db201 ~]$ db2 get db cfg show detail| grep -i applheapsz
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(512) AUTOMATIC(512)