The tool to view the persistent data on log or data volumes is x_diagnose.
But you cannot view the log volumes in online/warm mode.
A very short description to use:
call x_diagnose
=> PROT FILENAME: diag.prt
press enter
=> menu with ... 3 TYPEBUF ....
choose number 3 for the tool typebuf
=> DEVSPACE/INPUTFILE :
type in one of your logdevice files
=> menu with ... 6 SCAN ...
choose number 6 for scan options
=> menu with ... H = logentry (header only) ...
type in the letters 'fh' and press enter
=> you are again in menu with ... 6 SCAN ...
choose number 2 to scan a range of log pages
=> FROM PAGE NO 0 TO PAGE NO 0
type <tab> and give a page number (e.g.: 500) for the "TO PAGE NO"
=> press enter until you find logapges with output like that
...
6613 (#584) trans155/115 create_table nokey TABID 0-78
6669 (#585) trans155/115 upd_statistic
6725 (#586) trans155/115 insert SYS1CAT
key(12): 00000000 00000078 00010001
7021 (#587) trans155/116 insert TABID 0-78
key(9): 00FFFE00 00000000 01
...
TABID 0-78 defines a table with its internal id. In the view TABLES you can find the
name to this id.
=> select tablename from tables where tableid = '0000000000000078'
kind regards
Uwe
> -----Original Message-----
> From: Bittermann Alex [mailto:[EMAIL PROTECTED]
> Sent: Mittwoch, 11. Juni 2003 10:53
> To: '[EMAIL PROTECTED]'
> Subject: Diagnosis on logs
>
>
> Hi
>
> we are running SAP DB 7.3 for a SAP 6.20 System
>
> Now our logs increases 1,5 Megabyte per Minute, which is in
> my opinion a bit
> too much.
>
> We suggest there is a problem in our programs, so is there
> any possibility
> to check which tables in the database are logged?
>
> mit freundlichen Gr��en / with kind regards
>
> Alex Bittermann
> <<...OLE_Obj...>> -Basisadministration
> <mailto:[EMAIL PROTECTED]>
> <http://www.a-weber.de>
> <<...OLE_Obj...>> <<...OLE_Obj...>>
> _________________________________________________
> The information contained in this message may be CONFIDENTIAL and
> is intended for the addressee only. Any unauthorised use,
> dissemination
> of the information or copying of this message is prohibited.
> If you are not
> the addressee, please notify the sender immediately by return
> e-mail and
> delete this message. Thank you for your cooperation. We do not accept
> any warranty concerning errors, viruses, interception or interference.
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
