Informix

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

    IBM Champion
    Posted Mon June 20, 2022 01:15 PM

    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




    ------------------------------
    TOM GIRSCH
    ------------------------------

    #Informix


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

    Posted Tue June 21, 2022 12:15 PM
    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
    ------------------------------



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

    IBM Champion
    Posted Fri July 08, 2022 12:32 PM

    From tech support:

    I opened the following defect and it is already fixed.IT41463 - QUERY ON COLUMNS SQL_HVAR_TYPE AND SQL_HVAR_DATA OF TABLE SYSSQLTRACE_HVAR SHOWS INVALID INFORMATIONThe fix of above defect will be included in 14.10.xC9 (This version is not available yet).



    ------------------------------
    TOM GIRSCH
    ------------------------------



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

    IBM Champion
    Posted Wed July 13, 2022 03:53 PM
    @Doug Lawry There is also a patch, 14.10.FC8X6, that you can ask for.


    ------------------------------
    TOM GIRSCH
    ------------------------------



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

    Posted Thu July 14, 2022 02:23 AM
    Thanks, Tom.

    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------