SQL Anywhere database - Problem with dbspace

Author

Problem with dbspace

Harry Schurink

2005-04-11, 7:23 am

(sorry for reposting, but i saw too late i selected the wrong newsgroup)

Hello,

We have a database with a second dbspace containing nothing but a table for
logging purposes.
The dbspace-file did get lost, so any command that involves this table
crashes the database. (unknown device error, or dbspace not fond)

We allready tried restoring older versions of this dbspace file and/or other
dbspace files, but ASA cannot be foold by this.
The contents of the dbspace file and/or table is not important.

Is there any way to drop this dbspace / table from the database so the
database can be used again?
(we plan to rebuild the database and reinstate the dbspace after that)

Using ASA 8.0.2.4229

TIA
Harry Schurink

Joshua Savill

2005-04-11, 9:23 am

Harry,

You can try to drop the dbspace with the DROP command. The quick test I ran
worked to drop the dbspace, even though the dbspace file couldn't be found.

Adaptive Server Anywhere SQL Reference Manual
4. SQL Statements
DROP statement

Online:
http://sybooks.sybase.com/onlineboo...1917;pt=51917#X

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Harry Schurink" < hFIRSTDOTschurinkATt
sdSECONDDOTnl> wrote in message
news:425a3a1e@forums
-1-dub...
> (sorry for reposting, but i saw too late i selected the wrong newsgroup)
>
> Hello,
>
> We have a database with a second dbspace containing nothing but a table
> for
> logging purposes.
> The dbspace-file did get lost, so any command that involves this table
> crashes the database. (unknown device error, or dbspace not fond)
>
> We allready tried restoring older versions of this dbspace file and/or
> other
> dbspace files, but ASA cannot be foold by this.
> The contents of the dbspace file and/or table is not important.
>
> Is there any way to drop this dbspace / table from the database so the
> database can be used again?
> (we plan to rebuild the database and reinstate the dbspace after that)
>
> Using ASA 8.0.2.4229
>
> TIA
> Harry Schurink
>
>
>

Harry Schurink

2005-04-11, 9:23 am

Hi Joshua

Thanks for your response.

As i wrote in the original message:
crashes the database. (unknown device error, or dbspace not found) <<<

So the drop command also crashes the databaserserver.
Off course that is the first command i tried.

Obviously there is a serious problem with this table and i am trying to find
a way to reload the database without "crashing it" while unloading

Harry

"Joshua Savill" <jsavill@ianywhere.com> schreef in bericht
news:425a806b@forums
-2-dub...[color=darkred]
> Harry,
>
> You can try to drop the dbspace with the DROP command. The quick test I
ran
> worked to drop the dbspace, even though the dbspace file couldn't be
found.
>
> Adaptive Server Anywhere SQL Reference Manual
> 4. SQL Statements
> DROP statement
>
> Online:
>
http://sybooks.sybase.com/onlineboo...1917;pt=51917#X
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
> "Harry Schurink" < hFIRSTDOTschurinkATt
sdSECONDDOTnl> wrote in message
> news:425a3a1e@forums
-1-dub...
>
>

Joshua Savill

2005-04-11, 8:24 pm

Harry,

I ran my test with 8.0.2.4454. When I retested DROP DBSPACE using 8.0.2.4229
I received a "permission denied" error. I suggest you attempt to drop the
dbspace using the latest build of 8.0.2. This may produce different results.
If the problem consists, then I recommend opening a technical support case.
If you do not have a support plan, there will be an fee involved for the
case.

To download the latest EBF go to:
http://www.ianywhere.com/support/sql_anywhere.html and select EBFs /
Patches.

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Harry Schurink" < hFIRSTDOTschurinkATt
sdSECONDDOTnl> wrote in message
news:425a8bb4$1@foru
ms-2-dub...
> Hi Joshua
>
> Thanks for your response.
>
> As i wrote in the original message:
> crashes the database. (unknown device error, or dbspace not found) <<<
>
> So the drop command also crashes the databaserserver.
> Off course that is the first command i tried.
>
> Obviously there is a serious problem with this table and i am trying to
> find
> a way to reload the database without "crashing it" while unloading
>
> Harry
>
> "Joshua Savill" <jsavill@ianywhere.com> schreef in bericht
> news:425a806b@forums
-2-dub...
> ran
> found.
> http://sybooks.sybase.com/onlineboo...1917;pt=51917#X
>
>

Jon Springs

2005-04-13, 8:23 pm

You need to drop the table within the dbspace before you can drop the
dbspace itself.

-----Jon-----

"Joshua Savill" <jsavill@ianywhere.com> wrote in message
news:425a9c7f$1@foru
ms-2-dub...
> Harry,
>
> I ran my test with 8.0.2.4454. When I retested DROP DBSPACE using
> 8.0.2.4229 I received a "permission denied" error. I suggest you attempt
> to drop the dbspace using the latest build of 8.0.2. This may produce
> different results. If the problem consists, then I recommend opening a
> technical support case. If you do not have a support plan, there will be
> an fee involved for the case.
>
> To download the latest EBF go to:
> http://www.ianywhere.com/support/sql_anywhere.html and select EBFs /
> Patches.
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
>
> "Harry Schurink" < hFIRSTDOTschurinkATt
sdSECONDDOTnl> wrote in message
> news:425a8bb4$1@foru
ms-2-dub...
>
>

Sponsored Links