November 15, 2017 12:40 PM
(in response to Nadir Doctor)
None of the table spaces has file system cache On. I am
something to do with Raw devices attached to the server.
On Wed 15. Nov 2017 at 15:23, Nadir Doctor
<[login to unmask email]> wrote:
> Hi Prashant,
> You can use db2look with the layout option to confirm if any
> are using filesystems with caching turned on - note that those
> lob's which aren't inlined will need caching to be on.
> Sample command: db2look -d <db_name> -l -o
> Best Regards,
> On Wed, Nov 15, 2017 at 5:50 AM, Prashant Shettar
<[login to unmask email]>
>> Hello Everyone,
>> We are running multi partition database on RHEL 6.9.
>> workload, database is running out of main memory and stops
>> when I looked at the memory usage during the incident,
memory used by db2
>> was much less.Cache memory used was the culprit. Cache
memory increased to
>> the level of main memory.
>> I am suspecting some process is caching data too much. Can
>> help me to track / check which filesystems or device has
>> enabled at the operating system level?
>> I am using db2 V9.7 fp6.
>> -----End Original Message-----