Symptom
- Why does load database layout change after a dump and load?
- Loading a database from target to source
- sp_helpdb shows a different mapping in database between source and target
- Fragments on the database are combined
Source Database:
sp_helpdb <database>
go
name db_size owner dbid created durability status
--------------- ------------- -------- ---- ------------ ---------- --------------
<database> 48055.0 MB <owner> 24 Mar 29, 2018 full no options set
(1 row affected)
device_fragments size usage created free kbytes
------------------------------ ------------- -------------------- ------------------------- ----------------
data4 2007.0 MB data only Mar 29 2018 3:01AM 2045452
log1 290.0 MB log only Mar 29 2018 3:01AM not applicable
log1 325.0 MB log only Mar 29 2018 3:01AM not applicable
data4 1534.0 MB data only Mar 29 2018 3:01AM 1564680
data4 959.0 MB data only Mar 29 2018 3:02AM 978180
data4 1700.0 MB data only Mar 29 2018 3:02AM 1734000
data4 1024.0 MB data only Mar 29 2018 3:03AM 1044480
data4 2000.0 MB data only Mar 29 2018 3:03AM 2040000
data4 4096.0 MB data only Mar 29 2018 3:04AM 4177920
data4 1668.0 MB data only Mar 29 2018 3:05AM 1701360
data4 2332.0 MB data only Mar 29 2018 3:05AM 2378640
data4 5120.0 MB data only Mar 29 2018 3:06AM 5222400
data4 3454.0 MB data only Mar 29 2018 3:06AM 3523080
data4 1546.0 MB data only Mar 29 2018 3:07AM 1576920
data4 1772.0 MB data only Mar 29 2018 3:07AM 1807440
data4 1228.0 MB data only Mar 29 2018 3:07AM 1252560
data4 2000.0 MB data only Mar 29 2018 3:07AM 2040000
data4 6585.0 MB data only Mar 29 2018 3:08AM 6716700
data4 3415.0 MB data only Mar 29 2018 3:08AM 3483300
data4 5000.0 MB data only Mar 29 2018 3:09AM 5100000
Target Database:
sp_helpdb <database>
go
name db_size owner dbid created durability status
--------------- ------------- -------- ---- ------------ ---------- --------------
<database> 48055.0 MB <owner> 24 Mar 29, 2018 full no options set
(1 row affected)
device_fragments size usage created free kbytes
------------------------------ ------------- -------------------- ------------------------- ----------------
data4 2007.0 MB data only Mar 29 2018 3:12AM 66160
log1 290.0 MB log only Mar 29 2018 3:12AM not applicable
log1 325.0 MB log only Mar 29 2018 3:12AM not applicable
data4 12981.0 MB data only Mar 29 2018 3:12AM 1562196
data4 14224.0 MB data only Mar 29 2018 3:12AM 4633142
data4 9813.0 MB data only Mar 29 2018 3:12AM 4733248
data4 8415.0 MB data only Mar 29 2018 3:12AM 3988538
Read more...
Environment
Sybase Adaptive Server Enterprise (ASE) 15.5
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.