Hi again, I tried the command, but no luck:
Here are two screen-shots of the DB in DBMGUI, one where it is "busy" and the menu entries are unavailable, and the other after it times out, and you can't even GET a context menu: http://aoi.atari-source.com/~nsilva/shots/20030310_sapdb_stuck_db.png http://aoi.atari-source.com/~nsilva/shots/20030310_sapdb_stuck_db_2.png (look at DB 'lc01', this database was created as instance type LVC, dba/dba dbm/dbm, with the DBMGUI instwiz, and froze in the "initializing" stage. ) C:\a0003340\Program Files\SAPDB\depend\pgm>dbmcli -d lc01 -u dbm,dbm db_drop Error! Connection failed to node (local) for database lc01: ERR_USRFAIL: user authorization failed C:\a0003340\Program Files\SAPDB\depend\pgm>dbmcli -s -d LC01 db_drop ERR -24941,ERR_NEEDLOGON: DBM Server logon required C:\a0003340\Program Files\SAPDB\depend\pgm>dbmcli -d lc01 -u dba,dba db_drop ERR -24960,ERR_DBRUN: database is running C:\a0003340\Program Files\SAPDB\depend\pgm>dbmcli -d lc01 -u dba,dba db_offline I guess this one logs in! This hangs, sitting there for 10 minutes so far... I think there should be an easy way to force-drop a failed or corrupted DB from DBMGUI, and at least DBMCLI. I don't know why the instwiz failed, I think I made enough dev/log space in this case. I did manage to successfully create a lvc instance using a modified copy of the create_demo_db script. Probably also the instwiz should enforce some minimum size constraints on the DB creation dev/log space to prevent users from creating databases too small for the system tables. (running 7.4.0.14 on win2k) Thank you, Noah Silva IS&T - Programmer Analyst (215) 419 - 7916 "Bloom, Jon, KE3Z" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/10/2003 12:58 PM To: [EMAIL PROTECTED] cc: Subject: Re: 2qs: dropping half-made DBs and alternative authentication Try using the -s option to dbmcli. (Assuming you're running dbmcli on the host that contains the database instance.) Like so, IIRC: dbmcli -s -d dbname db_drop Jon On Mon, 10 Mar 2003 11:56:10 -0500 "Noah J SILVA" <[EMAIL PROTECTED]> wrote: > Hi, > > The problem with the following technique you listed is that it requires > the dbm login to be working on the database you want to drop, which > won't work if the DB is only partly created. > > Thank you, > Noah Silva > IS&T - Programmer Analyst > (215) 419 - 7916 > > > > > > "Edo Bezemer" <[EMAIL PROTECTED]> > 03/10/2003 11:43 AM > > > To: "Noah J SILVA" <[EMAIL PROTECTED]>, > <[EMAIL PROTECTED]> cc: > Subject: RE: 2qs: dropping half-made DBs and alternative > authentication > > > Hi > I only can give an answer on your first question. > I do it as shown below (Win2000!): > > > dbmcli -d %SID% -u dbm,dbm db_offline > NUL > dbmcli -d %SID% -u dbm,dbm db_drop > NUL > > Check the registry after and delete all that garbage. > > Cheers > > Edo Bezemer > > > > -----Original Message----- > From: Noah J SILVA [mailto:[EMAIL PROTECTED] > Sent: Montag, 10. M�rz 2003 16:27 > To: '[EMAIL PROTECTED]' > Subject: 2qs: dropping half-made DBs and alternative authentication > > Hi, > > I have two quick questions: > > 1.) I am somehow sure I have seen this answered before, but I was unable > > to find it on the mailing list archives (Maybe it should be added to the > > help?) If you create a DB and it fails for one reason or another (no > dba > passwd, not enough space for system tables, etc.). How can you drop the > > DB if you are unable to log into it? > > 2.) I was asked by people here to verify wether or not SAPDB is able to > use LDAP or w2k ActiveDirectory Authentication instead of it's internal > authentication mechanisms. Of course they would like this to avoid > duplicating administrative overhead, and to prevent users from having to > > remember multiple passwords. Unfortinately, I assume this would be > listed > in the documentation if it were possible. > > Thank you, > Noah SILVA > IS&T - Programmer Analyst > Atofina Chemicals (a division of the Total Fina Elf group) > (215) 419 - 7916 > > _______________________________________________ > 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 > _______________________________________________ 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
