How to change the physical device path in ASE

1> select db_name(a.dbid) as database_name , a.segmap, b.name as dev_name, b.phyname from sysusages a, sysdevices b where b.phyname like '%test%' and a.vstart=b.low
2>
database_name segmap dev_name phyname
---------------- ----------- --------------------- -------------------------------------------------------------------------------------------------------------------------------
mydb 3 mydb_test_dev01 /SybaseDevices/sybase/ASESERVER.mydb_test.dev01.dat
mydb 4 mydb_test_dev02 /SybaseDevices/sybase/ASESERVER.mydb_test.dev02.dat
mydb 3 mydb_test_dev03 /SybaseDevices/sybase/ASESERVER.FwpPLonSpt.dev03.dat
mydb 3 mydb_test_dev04 /SybaseDevices/sybase/ASESERVER.mydb_test.dev04.dat
mydb 3 mydb_test_dev05 /SybaseDevices/sybase/ASESERVER.mydb_test.dev05.dat
mydb 3 mydb_test_dev06 /SybaseDevices/sybase/ASESERVER.mydb_test_dev06.dat
mydb 4 mydb_test_dev07 /SybaseDevices/sybase/ASESERVER.mydb_test_dev09.dat
mydb 3 mydb_test_dev08 /SybaseDevices/sybase/ASESERVER.mydb_test_dev10.dat
Please check this :
Mirror the device which you want to change:
1
1> sp_configure 'disable disk mirroring'
2>
Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------ ----------- ----------- ------------ ----------- -------------------- ----------
disable disk mirroring 1 0 1 1 switch static
(1 row affected)
(return status = 0)
1>
1> sp_configure 'disable disk mirroring',0
2>
Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------ ----------- ----------- ------------ ----------- -------------------- ----------
disable disk mirroring 1 0 0 1 switch static
(1 row affected)
Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect.
Changing the value of 'disable disk mirroring' does not increase the amount of memory Adaptive Server uses.
(return status = 0)
RECYCLED THE SERVER
1> disk mirror
2> name='mydb_test_dev07',
3> mirror='/SybaseDevices/sybase/ASESERVER.mydb_test_dev09.dat'
4>
Creating the physical file for the mirror...
Starting Dynamic Mirroring of 179200 pages for logical device 'mydb_test_dev07'.
512 pages mirrored...
1024 pages mirrored...
1536 pages mirrored...
2048 pages mirrored...
2560 pages mirrored...
3072 pages mirrored...
3584 pages mirrored...
Remove the primary side of mirror and retain the secondary :
disk mirror
name='mydb_test_dev08',
mirror='/SybaseDevices/sybase/ASESERVER.mydb_test_dev10.dat'
1> disk mirror
2> name='mydb_test_dev08',
3> mirror='/SybaseDevices/sybase/ASESERVER.mydb_test_dev10.dat'
4>
Creating the physical file for the mirror...
Starting Dynamic Mirroring of 256000 pages for logical device 'mydb_test_dev08'.
512 pages mirrored...
1024 pages mirrored...
1536 pages mirrored...
2048 pages mirrored...
2560 pages mirrored...
3072 pages mirrored...
3584 pages mirrored...
4096 pages mirrored...
4608 pages mirrored...
1> select name,phyname,mirrorname from sysdevices where phyname like '%Spt%'
2>
name phyname mirrorname
------------------------------ --------------------------------------------------------------- ----------------------------------------------------------------
mydb_test_dev01 /SybaseDevices/sybase/ASESERVER.mydb_test.dev01.dat NULL
mydb_test_dev02 /SybaseDevices/sybase/ASESERVER.mydb_test.dev02.dat NULL
mydb_test_dev03 /SybaseDevices/sybase/ASESERVER.FwpPLonSpt.dev03.dat NULL
mydb_test_dev04 /SybaseDevices/sybase/ASESERVER.mydb_test.dev04.dat NULL
mydb_test_dev05 /SybaseDevices/sybase/ASESERVER.mydb_test.dev05.dat NULL
mydb_test_dev06 /SybaseDevices/sybase/ASESERVER.mydb_test_dev06.dat NULL
mydb_test_dev07 /SybaseDumps/sybase/ASESERVER.mydb_test_dev07.dat /SybaseDevices/sybase/ASESERVER.mydb_test_dev09.dat
mydb_test_dev08 /SybaseDumps/sybase/ASESERVER.mydb_test_dev08.dat /SybaseDevices/sybase/ASESERVER.mydb_test_dev10.dat
1> disk unmirror
2> name='mydb_test_dev08',
3> side="primary",
4> mode=remove
5>
1>
select name,phyname,mirrorname from sysdevices where phyname like '%test%'
2>
name phyname mirrorname
------------------------------ -------------------------------------------------------------- ---------------
mydb_test_dev01 /SybaseDevices/sybase/ASESERVER.mydb_test.dev01.dat NULL
mydb_test_dev02 /SybaseDevices/sybase/ASESERVER.mydb_test.dev02.dat NULL
mydb_test_dev03 /SybaseDevices/sybase/ASESERVER.mydb_test.dev03.dat NULL
mydb_test_dev04 /SybaseDevices/sybase/ASESERVER.mydb_test.dev04.dat NULL
mydb_test_dev05 /SybaseDevices/sybase/ASESERVER.mydb_test.dev05.dat NULL
mydb_test_dev06 /SybaseDevices/sybase/ASESERVER.mydb_test_dev06.dat NULL
mydb_test_dev07 /SybaseDevices/sybase/ASESERVER.mydb_test_dev09.dat NULL
mydb_test_dev08 /SybaseDevices/sybase/ASESERVER.mydb_test_dev10.dat NULL