Log Parser for SAP IQ

[SybDBA]

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

[hans-juergen_schwindke]

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

[c_baker]

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

[SybDBA]

Hi ,

Thanks for your precious response.

Well you are right that we have DBA cockpit and SCC, but what about earlier versions if someone is using with extended support ?

Thanks & Regards

pankaj

[Former Member]

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