SAP Knowledge Base Article - Preview

2625959 - Why does load database layout change after a dump and load? - ASE 15.5

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

SAP Adaptive Server Enterprise 15.7

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.