DB2 for OS/390 SMF record type 102

Ask a Question related to IBM DB2, Design and Development.

  1. #1

    Default DB2 for OS/390 SMF record type 102

    Hi,
    I am trying to analize SMF record type 102 produced by DB2 audit trace
    class 2.
    When I look at a dump of the record I see the jobname that issued the
    SQL statement and the strings "TSO" or "BATCH" at the last part of the
    record but I don't find how to map these fields. I scanned SDSNMACS
    library but can't find any DSECT that maps the jobname.
    Thank you for your help,
    Michael
    Michael Cohen Guest

  2. Similar Questions and Discussions

    1. How can i retrieve record ONLY From 300 - 400 in amillion Record Table?
      HI all Thanks for your time.. I have a question here.. How can i retrieve record ONLY From XXX - XXX in a million Record Table? eg. I have a...
    2. [11004] Valid name, no data record of requested type -ASPMAIL
      hello, I am getting the following error message Valid name, no data record of requested type when i run the following ASP MAIL script, why?...
    3. Functions that return RECORD type
      Hi I come from a MS-SQL background and am trying to figure out what is wrong with the function below:...
    4. Stop adding record in subform after record count = 1
      Can someone help in in what to put after the THEN statment to allow one entry if the Record count is =>1 in the Before insert or should I set the...
    5. Error when trying to add an Access DB Record containing a Long Integer type field using OLEDB in ADO.Net
      Hi All, I am trying to add a record to a datatable that is connected to an Access database. I had no trouble with string and date fields, but...
  3. #2

    Default Re: DB2 for OS/390 SMF record type 102

    I see 190 bytes of data in an SMF 102 IFCID 0350 (SQL statement) right after the Header (QWHS). I can see a userid and 'TSO'. I cannot find a mapping? Have you found out what this information is and how it is mapped?
    DickM is offline Junior Member
    Join Date
    Sep 2011
    Location
    Albuquerque
    Posts
    1

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139