Hi,
Is is technically feasible to put the tablespace of a database on an
HSM-managed filesystem? For example, if there are some rarely-accesed huge
tables, is it possible/feasible to define their tablespace(s) on a disk
space that can be migrated to tape by HSM?
Thank you,
Mehdi
Is is technically feasible to put the tablespace of a database on an
HSM-managed filesystem? For example, if there are some rarely-accesed huge
tables, is it possible/feasible to define their tablespace(s) on a disk
space that can be migrated to tape by HSM?
Feasable, yes. Advisable, probably
for database files!!
Hi,
Is is technically feasible to put the tablespace of a database on an
HSM-managed filesystem? For example, if there are some rarely-accesed huge
tables, is it possible/feasible to define their tablespace(s) on a disk
space that can be migrated to tape by HSM?
Thank you,
Mehdi
For databases that are directly accessed by the user (rather than behind the
scenes by a background server) you could add an initialization script in front
of the access session, where the user would be aware that the database content
would have to be staged to disk before being usable.