Skip to Content

Log Parser for SAP IQ

Hi Gurus,

Greeting of the day !!!😊

Can we implement something like "Log Parser in MSSQL" for SAP IQ/ASE ??

OR

Is there something like that in Sybase IQ/ASE about which I am unknown ?

As this will be very helpful in monitoring as well as troubleshooting specially for the DBAs.

Justification : As I know MSSQL is copied version of Sybase ASE, so most of the things will remain same.

I need your opinions, suggestions and advises on this point.

Thanks & Regards

pankaj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 18, 2016 at 01:27 PM

    Hi Pankaj,

       For Sybase ASE -- I think you are looking for this dbcc command --

    dbcc log ( [dbid][, objid][, pagenum][, rownum][, nrecords][, type], print

       But pity, the output is really hard to read. 😔

    Regards

    Eisen

    Add comment
    10|10000 characters needed characters exceeded

  • May 18, 2016 at 01:28 PM

    IQ shares no heritage with ASE.  LogParser will probably not even work on ASE as the products diverged long ago.

    What are you trying to do?  Auditing, performance, etc?

    To start monitoring IQ, I would suggest beginning with IQ Cockpit.

    Chris

    Add comment
    10|10000 characters needed characters exceeded

  • May 18, 2016 at 02:31 PM

    Hi Pankaj,

    if you want to use SQL in ASE you can use the MDA table monErrorLog

    select * from master..monErrorLog

    Here you have to parse for some keywords. A good starting point for those could be the following two scripts as they also grep for keywords.

    I know two file based solutions. One can be found on Rob Verschoor's website Tool for automatically checking the ASE errorlog

    And the other one is in an old ASE manual "How to Monitor the Error Log"

    These work for ASE but you can change the keywords so that it will can be used for IQ as well.

    All these solutions have in common that you have to trigger their execution with a scheduling tool.

    Or maybe in your company you have any other file checking tool.

    Best regards,

    Juergen

    Add comment
    10|10000 characters needed characters exceeded