在多个数据库实例中共享相同的只读数据库空间

Share the same read-only dbspace in multiple database instances

We have the following scenario:

  • There is a large amount of data which is only required for reference. This reference data is relevant for different user groups working of different databases.
  • The data is basically another partition to the existing tables.
  • There are multiple databases where that data would be beneficial.
  • We would like to share the information read-only between the databases, to avoid redundand copies.
  • The database system is SAP ASE 16.

Question: I would like to use the partitions from DB XL in read-only mode for both DB01 and DB02. Is there a way to do that?


Illustration

DB 01: valA valB valC

DB 02: valD valE valF

DB XL: val1 val2 val3
       val4 val5 val6
       ...
       val100000 val100001 val100002

Is there a way to mount the files from DB XL such that the user sees the following in DB01 and DB02? That is like this:

DB 01: valA valB valC
       val1 val2 val3
       val4 val5 val6
       ...
       val100000 val100001 val100002


DB 02: valD valE valF
       val1 val2 val3
       val4 val5 val6
       ...
       val100000 val100001 val100002