Changing wrong Sybase device physical name (drop or recreate)

[former_member94745]

Hi gurus, Is it possible and safe to change a database device physical name (In this device physical name accidentally had a space, the system after this reason did not recognize the device)

Could anyone write how to safely dump or recreate new device for ASE db (with same device physical name) ?

I have found SAP solution https://launchpad.support.sap.com/#/notes/0002645986

but maybe anyone knows another ways (without server restart) ?

It will be great to see steps of procedure

Thanks a lot

[eidahanafiahahmad]

Hi,

Do I need to set the traceflag 3608 to the RUN_file server before starting ASE and also option -m to prevent a transaction to occur when changing a path for device as per note 1992521?

And for which user do I need to execute the SQL? sapsa?

Regards,

Dafi

[jong-un_seo]

Hi 0020300184,

You can rename the physical device name as following steps.

1.shutdown all services on the ASE server.
2.set 'allow updates to system tables' parameter to 1.

use master
go

sp_configure 'allow updates to system tables', 1
go

begin tran
go

update sysdevices set phyname="<new physical name>" where name='<logical name>'
go

3.At terminal session

3.1.move to the directory of the physical device which you want to change its name and rename it

mv "the wrong physical device name" "new physical name"

"new physical name" is the same name which you updated at step#2.

4.At isql session shut down the ASE server with nowait option and then restart it.
shutdown with nowait
go

--start the ASE server and then check the error log file whether the device is initialized correctly.

5.disable 'allow updates to system tables' parameter

sp_configure 'allow updates to system tables', 0
go

Best regards,
Jongun