3285950 - Missing user segments when data/log is remapped at load time - SAP ASE 16.0

• User-defined segments missing in sysusages after a load database.
• Example: A database that contained some user-defined segments was dumped
• A database was created for it to be loaded into.
  
  The original database mapping looked like this:
  

  dbid  lstart     end     size      segmap loc    vdevno      device
  ----- ---------- ------- --------- ------ ------ ----------- -----
      4          0   12799     12800      3      0           2 ldev1
      4      12800   25599     12800      4      0           4 ldev3
      4      25600   28159      2560      8      0           3 ldev2
      4      28160   30719      2560     16      0           3 ldev2
      4      30720   43519     12800      4      0           4 ldev3
      4      43520   51199      7680     32      0           3 ldev2

• After the dump was loaded, the user-defined segments (segmap values 16 and 32) don't appear in the target disk map:

  dbid  lstart     end     size      segmap loc    vdevno      device
  ----- ---------- ------- --------- ------ ------ ----------- ------
      4         0    12799     12800      3      0           2 ldev1
      4     12800    25599     12800      4      0           4 ldev3
      4     25600    30719      5120      3      0           2 ldev1
      4     30720    43519     12800      4      0           4 ldev3
      4     43520    51199      7680      3      0           2 ldev1

• But if the same dump is loaded again, the segmap values are restored correctly.

SAP Adaptive Server Enterprise (ASE) 16

CR736604, CR#736604, 736604, sysusages, segmap, mapping, remapping, user-defined, segments , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed