1 - How Can I "Put many inserts into one transactions." (ODBC) ? 2 - Can I Turn Off AutoCommit using ODBC ?
Tanks, Jo�o "Klaus Zimmermann KLZI" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > > 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
