All if "il problemo persiste" then the problem persists and try this.
On a command line:
db2start
db2 drop db SAMPLE
If you get error saying it can't find the db or the directory then:
db2 list db directory
If the db SAMPLE does not show, then:
db2 list db directory on (the path or drive you created it on)
If it does not ist then it means there is no trace of the db in that
instance's directory. Could it be you created it in another instance?
Search for a file called "SQLDBDIR". It will be in a directory also
called SQLDBDIR which will be in the following path:
X:\instancename\SQLDBDIR\SQLDBDIR where X is the drive you installed on.
If you edit this, some info is in binary, and find the SAMPLE name, then
look at the instancename, it'S the one that owns the db.
If you do not find the SAMPLE name anywhere then you should be able to
create the SAMPLE db by going to a command line and do:
db2sampl
If none of this works, then I do not know what to do!!!!
Regards, Pierre.
Ale wrote:
Grazie, ma purtroppo li problema persiste!
"Pierre Saint-Jacques" <ps********@videotron.ca> ha scritto nel messaggio
news:3F**************@videotron.ca...
My Italian is not as good as the latin I learned at school or the French
that I speak but..
I think that when you "eliminato" the SAMPLE db you ran into problems,
so do on a command line:
db2start
db2 uncatalog db SAMPLE
db2 terminate
db2 list db directory
(the SAMPLE db should not list) If it does
db2 list db directory on <pat or drive>
(the SAMPLE db should not list)
If either command shows the SAMPLE db, then:
db2 catalog db on <path or drive>
db2 terminate
db2 drop db SAMPLE (If that works you're fine) If not because it does
not find the db, then:
db2 uncatalog db SAMPLE
db2 terminate.
All should now be fin and you can run the db2sampl command to recreate.
HTH, Pierre.
Ale wrote:
Ciao a tutti.
Ho eliminato il database di esempio SAMPLE(non cancellato). Ora lo
voglio
reinstallare ma durante l'installazione mi da il seguente errore:
nella finestra con scritto SQL1005N c'è scritto :
"Gli alias "SAMPLE" del database già esistono nel catalogo database
locale o
di sistema.
SQL1013N Il nome alias di un database o il nome del database "SAMPLE"
non è
stato trovato.
SQLSTATE=42705.
___________
Cosa dovrei fare ?
é come se ci fossero rimasti delgi elementi del DB SAMPLE, ma non so
dove.
GRAZIE
--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
