Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: where is stmmlog directory ?

    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
    Last edited by MarkhamDBA; 04-30-09 at 16:51.
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    should be in the same dir where you have your db2diag.log. look for stmmlog dir

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    /sqllib/db2dump/stmmlog>
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  4. #4
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    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

  5. #5
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    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?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •