Skip to Content
avatar image
Former Member

How collect batches from ASE Sybase 15.7

Hi!

I need to collect all batch for the certain user, and at the same time without missing any batch.

I know that for this purpose it is possible to use mon tables, but in that case I all the same will pass a part of batch.

Whether there is an opportunity to collect all batch for specific login?

SAP ASE 15.7

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 13, 2017 at 05:09 PM

    If your auditing is turned on just capture the "cmdtxt" for that login.

    Otherwise get the SPID (for the batch).

    With sa or sso role you can trace (record) a SPID's communication into an output file.

    The syntax to enable tracing is:

    set tracefile <em>file_name</em> [off] [for <em>spid]</em>
    

    The syntax to disable tracing is:

    set tracefile off [for spid]

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Avinash Kothare

      When we worked with jdbc driver in ASE we have LWP procedure with name "create proc jtds000002"

      And it's created on tempdb!

      We can't use options "exec_procedure" on tempdb.

      And we don't know name procedure because it's random created when programm worked.