I tried doing the next steps: step 1) <activate the parseid (as user "dba")> dbmcli -u dba,dba -d MYDB -uUTL dbmcli on MYDB>util_execute diagnose parseid on
step 2) <run one class java with "select...from...where...order" (as user"osvaldo")> D:\>java -classpath .;sapdbc.jar SapDBPru step 3) <on the SQL Studio> select * from sysparseid step 4) dbmcli -u dba,dba -d MYDB -uUTL dbmcli on MYDB>util_execute diagnose parseid off But I don't can see the statements on the "sysparseid". Am I missing something? How should I to connect in the SQL Studio (which user of database)? Should I to activate other "diagnose" ? Thank you. -----Mensaje original----- De: PUB: Becker, Holger [mailto:[EMAIL PROTECTED]] Enviado el: Monday, June 17, 2002 8:26 AM Para: '[EMAIL PROTECTED]' CC: [EMAIL PROTECTED] Asunto: RE: sql statements Osvaldo DEMIERRE wrote > How is possible the view of SQL statements of the users in the Database? > (like "V$SQLTEXT" of Oracle). > Is there trace with storage of parsed SQL statements in SapDB? How? With the dbmcli command "util_execute diagnose parseid on" you could enable such a command trace. All newly executed commands are stored in the table sysparseid. But it's only intended for diagnose purpose because this table growth endlessly and could fill up the database. Moreover the sysparseid table is from type temp and lost its content at restart time. With "util_execute diagnose parseid off" you switch it off again. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
