Filip Sergeys wrote : >Hello,
>What is the correct sequence of commands to use vtrace >I used the methods described on >www.mysql.com/products/maxdb/pdf/opensupport_eng.pdf page 24 >and >http://sapdb.2scale.net/moin.cgi/VTrace >and >http://lists.mysql.com/maxdb/18645 >but neither gave me luck >dbmcli -d <dbname> -u <dbm,dbm> util_execute diagnose vtrace default on >=> works >execute some sql => OK :) >dbmcli -d <dbname> -u <dbm,dbm> sql_execute vtrace => error > -24988,ERR_SQL: sql error > -3005,Invalid SQL statement >dbmcli -d <dbname> -u <dbm,dbm> -uSQL -c sql_execute vtrace => error > -24988,ERR_SQL: sql error > -3005,Invalid SQL statement >dbmcli -d <dbname> -u <dbm,dbm> trace_prot akb => haven't got this far >or is it >dbmcli -d <dbname> -u <dbm,dbm> trace_prot abknx >or is it (mailing list archive) >xkernprot -f knltrace akbm in the run directory of the database >./dbmgetf -d <dbname> -u <dbm,dbm> -k ?????? -f <localfile> or is this >step not necessary anymore. >The DB is Maxdb7.5 on suse9 Please use the following sequence : dbmcli -d <dbname> -u <dbm,dbm> util_execute diagnose vtrace default on ... your sql commands dbmcli -d <dbname> -u <dbm,dbm> trace_flush dbmcli -d <dbname> -u <dbm,dbm> trace_prot abkx You hopefully will find the file <dbname>.prt in the rundirectory of your database. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
