Cant delete volume. Unexpected error 9407...it says I have a snapshot??

[Former Member]

Hi All:

I had a snapshot. I am trying to delete a db_volume (I have too many volumes and the used space means I can get rid of a few volumes).

When I try to from dbmcli, it says :

ERR

-24988,ERR_SQL: SQL error

-9407,System error: unexpected error

Drop data volume failed - a snapshot exists

But I have already deleted the snapshot and none exists according to me and the dbm gui tool. I have tried recycling all the states and restarting the whole OS but still same error.

Please help.

Thanks

Tony

[Former Member]

hi Tony,

What is the DB version you are running?

Can you try:

1. Create a new (temporary) snapshot.

2. Delete this new snapshot.

3. Drop data volume.

BR,

Junco

[Former Member]

Hi,

Please check SAP note 1037594.

Regards,

Sachin Rane.

[Former Member]

This note is not applicable to an erroneous snapshot volume.

Any other suggestions?

T.

[former_member229109]

Hello Tony Mirag,

-> What is the version of the database?

-> Please update the thread with output of the following commands:

A) dbmcli db_enum

B) dbmcli u2013d <SID> -u <DBM-user>,<pwd>

<enter>

dbmcli on <SID>>param_getvolsall

<enter>

dbmcli on <SID>>exit

-> If you have the database version higher as 7.7.04, please update with output of the SQL statement u201Cselect * from snapshotsu201D.

Thank you and best regards, Natalia Khlopina

[Former Member]

UseMirroredLog NO

MaxLogVolumes 2

MaxDataVolumes 11

LogVolumeName001 819200 F E:\sapdb\ZUL\saplog\DISKL001

DataVolumeName0001 640000 F E:\sapdb\ZUL\sapdata\DISKD0001

DataVolumeName0002 640000 F E:\sapdb\ZUL\sapdata\DISKD0002

DataVolumeName0003 640000 F E:\sapdb\ZUL\sapdata\DISKD0003

DataVolumeName0004 640000 F E:\sapdb\ZUL\sapdata\DISKD0004

DataVolumeName0005 640000 F E:\sapdb\ZUL\sapdata\DISKD0005

DataVolumeName0006 640000 F E:\sapdb\ZUL\sapdata\DISKD0006

DataVolumeName0007 640000 F E:\sapdb\ZUL\sapdata\DISKD0007

DataVolumeName0008 640000 F E:\sapdb\ZUL\sapdata\DISKD0008

DataVolumeName0009 640000 F E:\sapdb\ZUL\sapdata\DISKD0009

dbmcli on zul>db_enum

OK

ZUL C:\Program Files\sdb\ZUL 7.7.06.09 fast offline

ZUL C:\Program Files\sdb\ZUL 7.7.06.09 slow offline

I have already tried to do a new snapshot, then deleted it and re-attempted the db_dropvolume.....still same error.

the select * from snapshots give me an empty table. (If I try the temporary creation of a snapshot then it does give me the one row coming back but after I delete this it comes back with no rows found.....but the volume dropping is still not successful with the same error)

[former_member229109]

Hello Tony,

-> As you could see the SAP notes, you are SAP customer. Correct?

Did you create the SAP message, where this issue was reported?

-> Did you drop the snapshot when the database was online?

See the SAP note 1366747.

Could you stop the database with db_offline then start the database with db_online dbm command,

then try to delete the last datavolume after the database was restarted successfuly.

Thank you and best regards, Natalia Khlopina

Edited by: Natalia Khlopina on Jun 10, 2010 10:17 AM

[Former Member]

Natalia:

I tried the offline and online cycle with no effect. I then DB backed up and restored. after that it allowed me to delete the volumes.

Quick q: is it possible to restore to 7 volumes (instead of the 9 it had when I backed it up)? If so how? Because that would have prevented me from having to post restore delete the volume.

(I did try to adjust the maxdatavolumes but that didnt help)

T.

[former_member229109]

Hello Tony,

I got this question from you:

u201CI tried the offline and online cycle with no effect. I then DB backed up and restored. after that it allowed me to delete the volumes.

Quick q: is it possible to restore to 7 volumes (instead of the 9 it had when I backed it up)? If so how? Because that would have prevented me from having to post restore delete the volume.

(I did try to adjust the maxdatavolumes but that didnt help)u201D

-> it possible to restore to 7 volumes, itu2019s dependent on the size of the databackup

For example, connect to the database using DBMGUI ->

Top menu u2013> Instance -> Initialize -> Initialize instance with use current parameters

& when you come to Volumes configuration delete the last two data volumes, they will deleted from param config file, then Next and Create instance for recovery. Continue with recovery.

-> I recommend to create the SAP message to check the issue with deletion of the datavolume after the snapshot was dropped.

Did you drop the snapshot when the database was online?

-> Donu2019t decrease the maxdatavolumes, keep it as number of the existed datavolumes + 5 or 10 to be able to add the datavolume online to solve the DB FULL issue.

Regards, Natalia Khlopina

[Former Member]

Natalia:

I did not attempt to drop while online (i think its not possible via dbmgui....grayed out).

Thanks for all the help. I still dont know what the original corruption was, but happy to have it solved.

T.