STAGEBLOB, an Optical Subsystem configuration parameter
The STAGEBLOB configuration parameter identifies the blobspace that is to be used as a staging area for TEXT or BYTE data that is retrieved from the Optical Subsystem, and it activates the Optical Subsystem.
If the configuration file does not list the STAGEBLOB parameter, the Optical Subsystem does not recognize the optical-storage subsystem.
The structure of
the staging-area blobspace is the same as all other database server
blobspaces. When the database server administrator creates the staging
area, it consists of only one chunk, but you can add more chunks as
desired. You cannot mirror the staging-area blobspace. The optimal
size for the staging-area blobspace depends on the following factors:
- The frequency of simple-large-object storage
- The frequency of simple-large-object retrieval
- The average size of the simple large object to be stored
To calculate the size of the staging-area blobspace, you must estimate the number of simple large objects that you expect to reside there simultaneously and multiply that number by the average simple-large-object size.