• 1 reply
  • Latest Post - ‏2011-12-21T13:04:53Z by BinLv
847 Posts

Pinned topic ITCAM for DB2 - diaglog

‏2011-12-14T12:12:42Z |
My ITCAM for DB2 agent(version for windows only; DB2 9.5 and 9.7) is running on non-Administrator os user. It is running OK, read all data from database but doesn't read data from diaglog.
In logs I notice that agent create file tmpmdl_ and CandleDb2Version in directory C:\WINDOWS\system32 (or C:\WINDOWS\SysWOW64 - 64bit )(user has only read and execute privileges).
Agent read diaglog when I add "write" permission on system32 folder but this is reconcilable with our security and I can't use this solution.

Maybe someone know
  • is it any possibility to change localization these files?
  • why these files are created in this localization?
I also notice that old tmpmdl_ files are not deleted and new files are created each time when agent was restarted.

Logs belowe:
(Wednesday, December 14, 2011, 9:18:37 AM-{8D34}kbbssge.c,52,"BSS1_GetEnv") KUD_DIAGLOG_TAILCOUNT="1000"
(Wednesday, December 14, 2011, 9:18:37 AM-{8D34}kumplmet.c,241,"KUMP_LoadMetafile") _***Error: Open failed for temporary metafile <C:\WINDOWS\system32\tmpmdl_1323850718_36148_1>, ErrorText <Input/output error>_
(Wednesday, December 14, 2011, 9:18:37 AM-{8D34}kum0c2up.c,49,"KUM0_ConvertStringToUpper") ***** Input string is NULL
(Wednesday, December 14, 2011, 9:18:37 AM-{8D34}kumpmsio.c,145,"KUMP_OpenMetaFile") *** Unable to open metafile .\work\ - Errno 2, ErrorText <No such file or directory>
(Wednesday, December 14, 2011, 9:18:37 AM-{8D34}kumpmsio.c,199,"KUMP_OpenMetaFile") *** Unable to open metafile .\work\.MDL - Errno 3, ErrorText <No such process>
(Wednesday, December 14, 2011, 9:18:37 AM-{8D34}kum0nmsg.c,377,"KUM0_NLS2_Message") Could not find any kumpmsg resource bundles in directory .\rb. Error <U_MISSING_RESOURCE_ERROR>
(Wednesday, December 14, 2011, 9:18:37 AM-{8D34}kumpcadm.c,515,"KUMP_ConstructApplDataModel") *** Unable to open MetaFile
(Wednesday, December 14, 2011, 9:18:37 AM-{8D34}kumplmet.c,391,"KUMP_LoadMetafile") ***Error: Failed to load metafile
(Wednesday, December 14, 2011, 9:18:37 AM-{8D34}kuddlagt.cpp,690,"kud00_kuddiaglog_agent::startDiagLogMonitor") KUMP_LoadMetafile failed, return code is: 9
(Wednesday, December 14, 2011, 9:18:37 AM-{8D34}kbbssge.c,52,"BSS1_GetEnv") ATTRLIB="C:\IBM\ITM\TMAITM6\ATTRLIB"
(Wednesday, December 14, 2011, 9:18:38 AM-{8D34}kglatram.c,380,"atrmgr_finish_building_volume") active vol <NULL> new vol <19D7AA8> file count <9> attr count <3886>
(Wednesday, December 14, 2011, 9:18:38 AM-{8D34}kbbssge.c,52,"BSS1_GetEnv") KBB_SIG1="-dumpoff -asyncoff"
  • BinLv
    4 Posts

    Re: ITCAM for DB2 - diaglog

    These tmpmdl_ files are created as the content of mdl to parse the db2diag.log. These files are created at temp directory. I think two ways to check your problem.
    1)Maybe you could check the environment variable setting of your db2 agent instance. If any setting point to "C:\WINDOWS\system32" (or C:\WINDOWS\SysWOW64 - 64bit )
    2)add KBB_RAS1 trace ERROR (UNIT:KUM ALL),to trace if any directories match our result "C:\WINDOWS\system32" (or C:\WINDOWS\SysWOW64 - 64bit )