does anybody know where stmmlog directory locates (db2 v9.5)? trying to find a better way of monitoring params changes than submitting 'db2 get db cfg show detail command > file' every 15 mins. thanks

should be in the same dir where you have your db2diag.log. look for stmmlog dir

/sqllib/db2dump/stmmlog>

TIP: curious where your db2diag log file is?
Type "db2diag -A". A new log file will be created and the old one is renamed (timestamp added). The output of the command shows the path

Another spin on the stmmlog directory.

Another DBA has created a db for him self to play with. Turned on STMM and now it is flooding db2diag.log with junk complaining about this directory.

2009-10-01-10.36.29.667840-300 E611798522A652 LEVEL: Warning (OS)
PID : 4821160 TID : 1 PROC : db2stmm (XXXXXX) 1
INSTANCE: userid NODE : 001 DB : XXXXXX
APPHDL : 1-1114 APPID: *N0.aaaaaa.090928030149
AUTHID : userid
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:100
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
CALLED : OS, -, unspecified_system_function
OSERR : EACCES (13) "Permission denied"
DATA #1 : File name, 17 bytes
/jhdfjhl/stmmlog

This directory is not there. I have searched documentation and the only refferences to it in there is this directory is used to store changes done by STMM. Does one need to create this directory first? Or does it mean that instance has no write access to create this directory?

0x840F0001 maps to:
SQL0970N The system attempted to write to a read-only file

sqlomkdirp - this is supposed to create a dir. The error is coming back from the OS. So, it looks like AUTHID "userid" doesn't have enough permission to create a dir. Try creating stmmlog using the instance owner id (if it doesn't exist) and give userid permission to write to it.