Thomas Markus wrote: > Hi, > > I have a strange problem. I use sapdb 7.3.0.21 on linux and > connect via > jdbc. > > I created a db using create_demo_db.sh. > > I repeated following steps some times > - create a user devel as dba > - connect via devel and create some tables (about 100) > with some test > data (<10000 rows at all) > - do some selects > - connect as dba and drop user devel cascade > > after some times I can't connect. The program tries to connect and no > message and no error comes up. I tried to connect with xsql and xload > with same effect. The only way to kill the client is a hard kill. The > processes under vserver are still exists. The only way to > connect is via > dbmcli with user dbm. I can't drop that user devel. > Restarting DB has no effect. The only solution is to drop the > DB and to recreate. > > Whats my problem?
Because I'm sure not to understand exactly the situation you are in, some questions: - is user devel connected when you try to drop this user ? - the dropping of user devel succeded? - was dropping of user devel committed? - with which user do you try your subsequent connect, dba, devel or any other user? - how many sessions are active and how many sessions may be active at any one time (installation parameter MAXUSERTASKS) ? Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
