如果存储池中包含条目,可从存储池中的可用空间创建存储空间或块。
先决条件:存储池中必须包含条目(目录、熟文件或原始设备)。
要从存储池创建存储空间或块,请执行以下操作:
EXECUTE FUNCTION task("create dbspace from storagepool", "space_name", "size", "page_size", "mirroring_flag", "first_extent", "next_extent");
EXECUTE FUNCTION task("create tempdbspace from storagepool", "space_name", "size", "page_size");
EXECUTE FUNCTION task("create blobspace from storagepool", "space_name", "size", "page_size", "mirroring_flag",);
EXECUTE FUNCTION task("create sbspace from storagepool", "space_name", "size", "log_flag", "mirroring_flag",);
EXECUTE FUNCTION task("create tempsbspace from storagepool", "space_name", "size",);
EXECUTE FUNCTION task("create chunk from storagepool", "space_name", "size",);
以下命令创建名为 blobspace1 的镜像 Blob 空间。新 Blob 空间的大小为 100 千兆字节,Blob 页大小为 100 页。
EXECUTE FUNCTION task("create blobspace from storagepool", "blobspace1", "100 GB", "100", "1");
以下命令向名为 logdbs 的数据库空间添加块。新块的大小为 200 兆字节。
EXECUTE FUNCTION task("create chunk from storagepool", "logdbs", "200 MB");