Professional Web Applications Themes

DB2 for OS/390 SMF record type 102 - IBM DB2

Hi, I am trying to ize 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...

  1. #1

    Default DB2 for OS/390 SMF record type 102

    Hi,
    I am trying to ize 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. #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

Similar Threads

  1. [11004] Valid name, no data record of requested type -ASPMAIL
    By Don Pacino in forum Dreamweaver AppDev
    Replies: 0
    Last Post: March 16th, 04:08 PM
  2. Functions that return RECORD type
    By Craig Bryden in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: January 14th, 09:29 AM
  3. Find record w/ conditions met in the same child record
    By Thomas Berg in forum FileMaker
    Replies: 2
    Last Post: October 21st, 05:01 AM
  4. Stop adding record in subform after record count = 1
    By Charlie in forum Microsoft Access
    Replies: 0
    Last Post: July 31st, 10:42 AM
  5. Replies: 6
    Last Post: July 22nd, 01:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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