We recently have a disk crash, where we were running our SYBASE ASE 12.5 server, we had the dump files for databases and we could recover in other installed server, the issue is found out that we have the log and data spaces mixed on the same devices and we now have to be able to make dump of the transaction log, so I have to questions:
1. Is it possible to make dumps of the transaction under this database structure?
2. How does this strcuture affects the performance?
3. What detaled procedure should we follow in order to umix the log and data segments on same device?
I paste results for sysusages and helpdb:
dbid segmap lstart size vstart pad unreservedpgs crdate
------ ----------- ----------- ----------- ----------- ------ ------------- --------------------------
-
4 3 0 12800 33554432 (null) 0 Apr 7 2009 7:00AM
4 4 12800 3840 50331648 (null) 3825 Apr 7 2009 7:00AM
4 3 16640 28160 50362368 (null) 0 Apr 7 2009 7:00AM
4 3 44800 64000 67108864 (null) 24058 Apr 7 2009 7:00AM
4 3 108800 6400 570425344 (null) 6375 Apr 7 2009 7:00AM
4 4 115200 3840 570476544 (null) 3825 Apr 7 2009 7:00AM
7 3 0 25600 167772160 (null) 0 Apr 7 2009 6:26AM
7 4 25600 6400 184549376 (null) 6375 Apr 7 2009 6:26AM
7 3 32000 25600 184600576 (null) 0 Apr 7 2009 6:26AM
7 3 57600 64000 201326592 (null) 0 Apr 7 2009 6:26AM
7 3 121600 64000 218103808 (null) 0 Apr 7 2009 6:26AM
7 3 185600 6400 234881024 (null) 0 Apr 7 2009 6:26AM
7 4 192000 6400 234932224 (null) 6375 Apr 7 2009 6:26AM
7 3 198400 51200 234983424 (null) 0 Apr 7 2009 6:26AM
7 3 249600 12800 251658240 (null) 0 Apr 7 2009 6:26AM
7 4 262400 25600 251760640 (null) 25500 Apr 7 2009 6:26AM
7 3 288000 25600 251965440 (null) 0 Apr 7 2009 6:26AM
7 3 313600 64000 268435456 (null) 0 Apr 7 2009 6:26AM
7 3 377600 64000 285212672 (null) 0 Apr 7 2009 6:26AM
7 3 441600 102400 301989888 (null) 40020 Apr 7 2009 6:26AM
7 3 544000 15872 318767104 (null) 15810 Apr 7 2009 6:26AM
name db_size owner dbid created status
------------------------ ------------- ------------------------ ------ -------------- --------------------------
----------
----------
----------
----------
----------
----------
----------
------
cobis 1860.0 MB sa 4 Apr 01, 2009 select into/bulkcopy/pllsort, trunc log on chkpt
device_fragments size usage created free kbytes
--------------------------
---- ------------- -------------------- ------------------- --------------------------
----
cobis_dat 200.0 MB data only Apr 7 2009 7:00AM 128
cobis_dat1 440.0 MB data only Apr 7 2009 7:00AM 0
cobis_dat1 60.0 MB log only Apr 7 2009 7:00AM not applicable
cobis_dat2 1000.0 MB data only Apr 7 2009 7:00AM 364528
cobis_log1 100.0 MB data only Apr 7 2009 7:00AM 102000
cobis_log1 60.0 MB log only Apr 7 2009 7:00AM not applicable
--------------------------
----------
----------
----------
------
log only free kbytes = 122512
name db_size owner dbid created status
------------------------ ------------- ------------------------ ------ -------------- --------------------------
----------
----------
----------
----------
----------
----------
----------
------
cob_cartera 8748.0 MB sa 7 Apr 01, 2009 select into/bulkcopy/pllsort, trunc log on chkpt
device_fragments size usage created free kbytes
--------------------------
---- ------------- -------------------- ------------------- --------------------------
----
cob_cartera_dat 400.0 MB data only Apr 7 2009 6:26AM 0
cob_cartera_dat1 400.0 MB data only Apr 7 2009 6:26AM 0
cob_cartera_dat1 100.0 MB log only Apr 7 2009 6:26AM not applicable
cob_cartera_dat2 1000.0 MB data only Apr 7 2009 6:26AM 0
cob_cartera_dat3 1000.0 MB data only Apr 7 2009 6:26AM 0
cob_cartera_dat4 100.0 MB data only Apr 7 2009 6:26AM 0
cob_cartera_dat4 800.0 MB data only Apr 7 2009 6:26AM 0
cob_cartera_dat4 100.0 MB log only Apr 7 2009 6:26AM not applicable
cob_cartera_dat5 200.0 MB data only Apr 7 2009 6:26AM 0
cob_cartera_dat5 400.0 MB data only Apr 7 2009 6:26AM 0
cob_cartera_dat5 400.0 MB log only Apr 7 2009 6:26AM not applicable
cob_cartera_dat6 1000.0 MB data only Apr 7 2009 6:26AM 0
cob_cartera_dat7 1000.0 MB data only Apr 7 2009 6:26AM 0
cob_cartera_dat8 1600.0 MB data only Apr 7 2009 6:26AM 527104
cob_cartera_log 248.0 MB data only Apr 7 2009 6:26AM 252960
--------------------------
----------
----------
----------
------
log only free kbytes = 611968
Any help would be really appreciated
