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 for Me (Login required).

Search for additional results

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