Usage of LOGVOLUME:
select * from show_stat_log
'LOG PAGES';' 580221'
'USED LOG PAGES';' 34311'
'USED LOG PAGES (%)';' 6'
'NOT SAVED LOG PAGES';' 34256'
'NOT SAVED LOG PAGES (%)';' 6'
'RESERVED REDO SIZE';' 290110'
'LOG SEGMENT SIZE';' 0'
'SAVEPOINTS';' 47704'
'CHECKPOINTS';' 26'
Should wor with ODBC too.
Regards, Klaus
|---------+------------------------------------>
| | Sven K�hler |
| | <[EMAIL PROTECTED]> |
| | Gesendet von: |
| | [EMAIL PROTECTED]|
| | erv.sap.com |
| | |
| | |
| | 21.07.2003 16:50 |
| | |
|---------+------------------------------------>
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| An: [EMAIL PROTECTED]
|
| Kopie:
|
| Thema: Re: LOG Backup...
|
>------------------------------------------------------------------------------------------------------------------------------|
> 2 - Can I check the log file usage with a SQL Statement (ODBC) ?
> 3 - Can I do a Log Backup with a SQL Statement(ODBC).?
i think both can only be done with the dbmcli.
> 5 - I Need to do a lot of inserts in a migration routine and this inserts
> are very slow( even slower than a Informix on a stone age machine)... Can
I
> Disable some feature or something else to acelerate this procedure ?
Put many inserts into one transactions. As Autocommit is on by default,
every insert statement will be committed. That's why it's so slow.
_______________________________________________
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
