diff options
Diffstat (limited to 'source/configuration/modules/pmdb2diag.rst')
| -rw-r--r-- | source/configuration/modules/pmdb2diag.rst | 146 |
1 files changed, 146 insertions, 0 deletions
diff --git a/source/configuration/modules/pmdb2diag.rst b/source/configuration/modules/pmdb2diag.rst new file mode 100644 index 0000000..dc36977 --- /dev/null +++ b/source/configuration/modules/pmdb2diag.rst @@ -0,0 +1,146 @@ +************************************** +pmdb2diag: DB2 Diag file parser module +************************************** + +=========================== =========================================================================== +**Module Name:** **pmdb2diag** +**Authors:** Jean-Philippe Hilaire <jean-philippe.hilaire@pmu.fr> & Philippe Duveau <philippe.duveau@free.fr> +=========================== =========================================================================== + + +Purpose +======= + +The objective of this module is to extract timestamp, procid and appname form the log +lines without altering it + +The parser is acting after an imfile input. This implies that imfile must be configured +with needParse to setted to on. + +Compile +======= + +To successfully compile pmdb2diag module you need to add it via configure. + + ./configure --enable-pmdb2diag ... + +Configuration Parameters +======================== + +**Parser Name:** "db2.diag" + +The default value of parameter are defined with escapeLF on in imfile. + +timeformat +^^^^^^^^^^ + +.. csv-table:: + :header: "type", "mandatory", "format", "default" + :widths: auto + :class: parameter-table + + "string", "no", "see strptime manual","%Y-%m-%d-%H.%M.%S." + +Format of the timestamp in d2diag log included decimal separator between seconds and second fractions. + +timepos +^^^^^^^ + +.. csv-table:: + :header: "type", "mandatory", "format", "default" + :widths: auto + :class: parameter-table + + "integer", "no", ,"0" + +Position of the timestamp in the db2 diag log. + +levelpos +^^^^^^^^ + +.. csv-table:: + :header: "type", "mandatory", "format", "default" + :widths: auto + :class: parameter-table + + "integer", "no", ,"59" + +Position of the severity (level) in the db2 diag log. + +pidstarttoprogstartshift +^^^^^^^^^^^^^^^^^^^^^^^^ + +.. csv-table:: + :header: "type", "mandatory", "format", "default" + :widths: auto + :class: parameter-table + + "integer", "no", ,"49" + +Position of the prog related to the pid (form beginning to beginning) in the db2 diag log. + +Examples +======== + +Example 1 +^^^^^^^^^ + +This is the simplest parsing with default values + +.. code-block:: none + + module(load="pmdb2diag") + ruleset(name="ruleDB2" parser="db2.diag") { + ... do something + } + input(type="imfile" file="db2diag.log" ruleset="ruleDB2" tag="db2diag" + startmsg.regex="^[0-9]{4}-[0-9]{2}-[0-9]{2}" escapelf="on" needparse="on") + + +Example 2 +^^^^^^^^^ + +Parsing with custom values + +.. code-block:: none + + module(load="pmdb2diag") + parser(type="pmdb2diag" name="custom.db2.diag" levelpos="57" + timeformat=""%y-%m-%d:%H.%M.%S.") + ruleset(name="ruleDB2" parser="custom.db2.diag") { + ... do something + } + input(type="imfile" file="db2diag.log" ruleset="ruleDB2" tag="db2diag" + startmsg.regex="^[0-9]{4}-[0-9]{2}-[0-9]{2}" escapelf="on" needparse="on") + +DB2 Log sample +^^^^^^^^^^^^^^ + +.. code-block:: none + + 2015-05-06-16.53.26.989402+120 E1876227378A1702 LEVEL: Info + PID : 4390948 TID : 89500 PROC : db2sysc 0 + INSTANCE: db2itst NODE : 000 DB : DBTEST + APPHDL : 0-14410 APPID: 10.42.2.166.36261.150506120149 + AUTHID : DBUSR HOSTNAME: dev-dbm1 + EDUID : 89500 EDUNAME: db2agent (DBTEST) 0 + FUNCTION: DB2 UDB, relation data serv, sqlrr_dispatch_xa_request, probe:703 + MESSAGE : ZRC=0x80100024=-2146435036=SQLP_NOTA "Transaction was not found" + DIA8036C XA error with request type of "". Transaction was not found. + DATA #1 : String, 27 bytes + XA Dispatcher received NOTA + CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) + [0] 0x090000000A496B70 sqlrr_xrollback__FP14db2UCinterface + 0x11E0 + [1] 0x090000000A356764 sqljsSyncRollback__FP14db2UCinterface + 0x6E4 + [2] 0x090000000C1FAAA8 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x529C + [3] 0x0000000000000000 ?unknown + 0x0 + [4] 0x090000000C23D260 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1174 + [5] 0x090000000C23CE54 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xD68 + [6] 0x090000000D74AB90 @72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8 + [7] 0x090000000D74B6A0 @72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5F8 + [8] 0x090000000B8F85AC RunEDU__8sqeAgentFv + 0x48C38 + [9] 0x090000000B876240 RunEDU__8sqeAgentFv + 0x124 + [10] 0x090000000CD90DFC EDUDriver__9sqzEDUObjFv + 0x130 + [11] 0x090000000BE01664 sqloEDUEntry + 0x390 + [12] 0x09000000004F5E10 _pthread_body + 0xF0 + [13] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF |