From: poornima ponnuswamy [mailto:[EMAIL PROTECTED]
Hello, a devspace is a object which uses the database to store data on the disk. > Hello, > Then later the database crashed and I restored to the > previous version and when I try to add the devspace > > ./dbmcli on gabesdb>db_adddevspace DATA > /usr/sapdb/complete F 100000 > OK You have defined your second data devspace. It is the file /usr/sapdb/complete. But did you really want to use /usr/sapdb/complete? I saw in the dbm.prt you have already defined /usr/sapdb/complete as location for a backup medium. > but when I try to do this > > /dbmcli on gabesdb>db_adddevspace DATA DAT_001 F 40000 > ERR > -24988,ERR_SQL: sql error > -914,New DEVSPACE not accessible This is normal, because your first data devspace already uses the file DAT_001 in the rundirectory. You cannot use the same file twice. > And this is the result of > ./dbmcli on gabesdb>param_getdevsall > OK > LOG_MIRRORED NO > MAXARCHIVELOGS 2 > MAXDATADEVSPACES 11 > ARCHIVE_LOG_001 20000 F LOG_001 > DATADEV_0001 20000 F DAT_001 > DATADEV_0002 100000 F /usr/sapdb/complete Here you will see one log devspace. The file LOG_001 ind the rundirectory. You will see also two datadevspaces. The file DAT_001 in the rundirectory and the file /usr/sapdb/complete. Were is the problem? Bernd -- SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
