HSM for database files!!

2011-06-22 Thread Mehdi Salehi
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

Re: HSM for database files!!

2011-06-22 Thread Steven Langdale
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

Re: HSM for database files!!

2011-06-22 Thread Grigori Solonovitch
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

Re: HSM for database files!!

2011-06-22 Thread Richard Sims
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.