AW: Accounting + SYSACCOUNT

JUNG, Christian wrote:

> Hi!
> 
> Today I found an interesting table:
> 
> <DBA>.SYSACCOUNT
> 
> It holds some nice information like user name, session ID, CPU time,
> connect
> date & time and so on. But it doesn't contain any records. A quick
search
> on
> google and a deeper look in the documentation did not succeed. I only
> found
> this sentence in the description of "RELEASE":
> 
> ---8<---
> If the accounting function in the database system is activated,
> information
> on the session is added to the table SYSACCOUNT.
> ---8<---
> 
> Anyway: I found in some documentation for Adabas D, that it is
possible to
> turn on accounting with xcontrol (an Adabas D tool for
administration).
> Was
> this feature removed from SAP DB/MaxDB or is there a way to enable it
via
> SQL-statement or dbmcli?
> 

This feature was removed from MaxDB. The table had to remain a little
bit longer because of tools which may ask for it and then remained a
little bit too long and does not exist any more starting with version
7.6.

For doing account for some tables, triggers may help filling a private
table.

Elke
SAP Labs Berlin

> Thanks for your help!
> 
> 
> Greets
> Christian Jung
> 
> phone: +49 6898/10-4987
> fax: +49 6898/10-54987
> http://www.saarstahl.de
> 
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/maxdb?unsub=elke.zabach@xxxxxxx


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx