create sbspace from storagepool argument: Create an sbspace from the storage pool (SQL administration API)

Use the create sbspace from storagepool argument with the admin() or task() function to create an sbspace from an entry from the storage pool.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--"--create -+-------------+--sbspace from storagepool--"------>
              '-unencrypted-'                                

>--,--"sbspace"--,--"initial_chunk_size"--+--------------------------------------------+-->
                                          '-,--"logging_flag"--+---------------------+-'   
                                                               '-,--"mirroring_flag"-'     

>--)--;--------------------------------------------------------><

Element Description Key Considerations
sbspace The name of the sbspace. The sbspace name must be unique and cannot exceed 128 bytes. It must begin with a letter or underscore and must contain only letters, numbers, underscores, or the $ character.
initial_chunk_size The size, in kilobytes, of the initial chunk of the new sbspace. See admin() and task() Argument Size Specifications.
logging_flag Either:
  • 1 = logging
  • 0 = no logging
The logging flag is optional. However if you specify 1 for mirroring, you must also specify a logging flag.
mirroring_flag Either:
  • 1 = mirroring
  • 0 = no mirroring
The mirroring flag is optional.

Use the create unencrypted sbspace from storagepool argument to create an unencrypted sbspace when encryption is enabled by the DISK_ENCRYPTION configuration parameter.

Examples

The following command creates a mirrored and logged sbspace named sbspace1. The new sbspace has a size of 240 megabytes.

EXECUTE FUNCTION task("create sbspace from storagepool", "sbspace1",
 "240 MB", "1", "1");

The following command creates an unmirrored and unlogged sbspace named sbspace2. This sbspace has a size of 5 gigabytes.

EXECUTE FUNCTION task("create sbspace from storagepool", "sbspace2", "5 GB");

Copyright© 2019 HCL Technologies Limited