View Only
  • 1.  "Data Not Available" in syssqltrace_hvar

    IBM Champion
    Posted 11 days ago

    Hive mind!

    I'm trying to trace errors in a session using syssqltrace, syssqltrace_iter and syssqltrace_hvar. But when I query syssqltrace_hvar, I always get this:

    sql_hvar_type unknown
    sql_hvar_data <Data Not Available>

    How can I fix this so that I see the actual data? I have the following setup:

    SQLTRACE level=high,ntraces=2000000,size=16,mode=global

    The query is being run by user informix, so I wouldn't think UNSECURE_ONSTAT should be relevant.

    This used to work, in some previous release of 14.10 (I'm presently on 14.10.FC7W1)

    Thanks in advance for any insight,

    - TJG


  • 2.  RE: "Data Not Available" in syssqltrace_hvar

    Posted 10 days ago
    Hi Tom.

    Same for me: it's fine in 14.10.FC3 but broken in 14.10.FC8. Let us know the IBM defect number when you get to that stage!

    Doug Lawry
    Oninit Consulting