Topic
2 replies Latest Post - ‏2007-05-08T10:34:05Z by zhengzwang
zhengzwang
zhengzwang
2 Posts
ACCEPTED ANSWER

Pinned topic How to modify the db2j.storage.pageCacheSize property of the cloudscape of WAS6.0?

‏2007-04-29T15:37:19Z |
I want to adjust the cloudscape accompanying WebSphere Application Server v6.0 to support relatively bigger BLOB processing. I know that increasing the db2j.storage.pageCacheSize property value can accomplish this (referencing http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408bradbury/#cs_OutOfMem).

I tried many approaches. Since db2j.storage.pageCacheSize is a system-wide (or say static) property, it must be set in the db2j.properties file or passed as a java argument. But WAS does not utilize the system properties. Trying to add it in the cview's System -> Properties tab will result in java.lang.ArrayIndexOutOfBoundsException. I searched through the cloudscape folder (under the WAS6 installation directory) by text, and found that the only places where db2j.storage.pageCacheSize resides are inside some java classes.

Is it possible to change the db2j.storage.pageCacheSize property to impact the embedded cloudscape instance in the running WAS application server?
Updated on 2007-05-08T10:34:05Z at 2007-05-08T10:34:05Z by zhengzwang
  • Stan
    Stan
    267 Posts
    ACCEPTED ANSWER

    Re: How to modify the db2j.storage.pageCacheSize property of the cloudscape of WAS6.0?

    ‏2007-04-30T16:04:01Z  in response to zhengzwang
    Hi -

    Add the property to the db2j.properties file in the cloudscape sub-folder of the Application Server directory. You will need to restart the server for the change to take effect.
    • zhengzwang
      zhengzwang
      2 Posts
      ACCEPTED ANSWER

      Re: How to modify the db2j.storage.pageCacheSize property of the cloudscape of WAS6.0?

      ‏2007-05-08T10:34:05Z  in response to Stan
      Thanks. It works.