Hello Craig,

you wrote :
> I am having problems with SQL Studio locking up when I do the 
> following:
> 
> 1.  Select VIEW | DIRECT SQL AUTOCOMMIT OFF
> 2.  Perform a series of updates or inserts
> 3.  Perform a select on the affected table without committing 
> or rolling back
> 
> If I commit or rollback the transaction, then it doesn't lock up.
> I am running your latest (?) 7.3 on Windows XP.

could you provide some more information , i.e.

- the definitions of the tables which are involved
- how many rows these tables contain
- how many and what updates/inserts you did perform
- the select statement in question
- what hardware you are running on (physical mem, cpu speed)
- log and data space sizes of the db instance you use.

regards,

Markus Stausberg
SAP Labs Berlin

 
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to