TSM DB2 Warning Performance issue

[cnukvd100]

Hi ,

We are having a big performance issue with OnDemand .
I could see some warnings in DB2 logs . what is this warnings means .
what action we can take?

Please reply if any one knows about it.

2014-02-08-07.49.27.317000+060 E58724F800 LEVEL: Warning
PID : 7240 TID : 8208 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ARCHIVE
APPHDL : 0-132 APPID: *LOCAL.DB2.140207222515
AUTHID : ODADMIN HOSTNAME: localhost
EDUID : 8208 EDUNAME: db2agent (ARCHIVE) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:1660
MESSAGE : ADM1822W The active log is being held by dirty pages. This is not
an error, but database performance may be impacted. If possible,
reduce the database work load. If this problem persists, either
decrease the SOFTMAX and/or increase the NUM_IOCLEANERS DB
configuration parameters.

2014-02-08-07.52.02.863000+060 I59526F474 LEVEL: Info
PID : 7240 TID : 5184 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: localhost
EDUID : 5184 EDUNAME: db2logmgr (ARCHIVE) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
DATA #1 : <preformatted>
Completed archive for log file S0000624.LOG to TSM chain 0 from G:\DB2\NODE0000\SQL00001\LOGSTREAM0000\.

2014-02-08-07.57.11.950000+060 E60002F800 LEVEL: Warning
PID : 7240 TID : 8248 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ARCHIVE
APPHDL : 0-157 APPID: *LOCAL.DB2.140207222540
AUTHID : ODADMIN HOSTNAME: localhost
EDUID : 8248 EDUNAME: db2agent (ARCHIVE) 0
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:1660
MESSAGE : ADM1822W The active log is being held by dirty pages. This is not
an error, but database performance may be impacted. If possible,
reduce the database work load. If this problem persists, either
decrease the SOFTMAX and/or increase the NUM_IOCLEANERS DB
configuration parameters.


Thanks
Srinivas

 

[moon-buddy]

Read this link

Connect to db2 from the OS the DB2 user:

- db2 connect to tsmdb1 (enter)
- db2 set schema tsmdb1 (enter)

- db2 get database config show detail

Look for: Number of asynchronous page cleaners - the value should be AUTOMATIC; if not change it:

- db2 update database config using NUM_IOCLEANERS automatic

Exit out of DB2 and restart the TSM server.

 

[cnukvd100]

Thank you for your reply.

The DB2 configuration is AUTOMATIC for NUM_IOCLEANERS .
There is another service which is trying to do some database inserts continuously, I guess that is causing the issue.

how to find the most executed query or currently running query on DB2?

Thanks
-Srinivas