DB2 Version 10.1 for Linux, UNIX, and Windows
DB2 Version 10.1 for Linux, UNIX, and Windows
SQL_STRUCTURE sqledbdescext
{
sqluint32 sqlPageSize;
struct sqleAutoStorageCfg *sqlAutoStorage;
struct SQLETSDESCEXT *sqlcattsext;
struct SQLETSDESCEXT *sqlusrtsext;
struct SQLETSDESCEXT *sqltmptsext;
void *reserved;
};
SQL_STRUCTURE sqleAutoStorageCfg
{
char sqlEnableAutoStorage;
char pad[3];
sqluint32 sqlNumStoragePaths;
char **sqlStoragePaths;
};
SQL_STRUCTURE SQLETSDESCEXT
{
sqlint64 sqlInitSize;
sqlint64 sqlIncreaseSize;
sqlint64 sqlMaximumSize;
char sqlAutoResize;
char sqlInitSizeUnit;
char sqlIncreaseSizeUnit;
char sqlMaximumSizeUnit;
};
SQL_STRUCTURE sqledboptions
{
void *piAutoConfigInterface;
sqlint32 restrictive;
void *reserved;
};| Field name | Data type | Description |
|---|---|---|
| SQLPAGESIZE | sqluint32 | Specifies the page size of the default buffer pool as well as the initial table spaces (SYSCATSPACE, TEMPSPACE1, USERSPACE1) when the database is created. The value given also represents the default page size for all future CREATE BUFFERPOOL and CREATE TABLESPACE statements. See the information that follows this table for values. |
| SQLAUTOSTORAGE | Pointer | A pointer to an automatic storage configuration structure. This pointer enables or disables automatic storage for the database. If a pointer is given, automatic storage may be enabled or disabled. If NULL, the default storage group is created and a single storage path is assumed with a value determined by the dbpath passed in, or the database manager configuration parameter, dftdbpath. |
| SQLCATTSEXT | Pointer | A pointer to an extended table space description control block (SQLETSDESCEXT) for the system catalog table space, which defines additional attributes to those found in SQLETSDESC. If NULL, the database manager determines the value of these attributes automatically (if relevant). |
| SQLUSRTSEXT | Pointer | A pointer to an extended table space description control block (SQLETSDESCEXT) for the user table space, which defines additional attributes to those found in SQLETSDESC. If NULL, the database manager determines the value of these attributes automatically (if relevant). |
| SQLTMPTSEXT | Pointer | A pointer to an extended table space description control block (SQLETSDESCEXT) for the system temporary table space, which defines additional attributes to those found in SQLETSDESC. If NULL, the database manager determines the value of these attributes automatically (if relevant). |
| RESERVED | Pointer | A pointer to a database options control block (sqledboptions). |
| Field name | Data type | Description |
|---|---|---|
| SQLENABLEAUTOSTORAGE | CHAR(1) | Specifies whether or not automatic storage is enabled for the database. See the information that follows this table for values. |
| SQLNUMSTORAGEPATHS | sqluint32 | A value indicating the number of storage paths being pointed to by the SQLSTORAGEPATHS array. If the value is 0, the SQLSTORAGEPATHS pointer must be NULL. The maximum number of storage paths is 128 (SQL_MAX_STORAGE_PATHS). |
| SQLSTORAGEPATHS | Pointer | An array of string pointers that point to storage paths. The number of pointers in the array is reflected by SQLNUMSTORAGEPATHS. Set SQLSTORAGEPATHS to NULL if there are no storage paths being provided (in which case, SQLNUMSTORAGEPATHS must be set to 0). The maximum length of each path is 175 characters. |
| Field name | Data type | Description |
|---|---|---|
| SQLINITSIZE | sqlint64 | Defines the initial size of each table space that uses automatic storage. This field is only relevant for regular or large automatic storage table spaces. Use a value of SQL_TBS_AUTOMATIC_INITSIZE for other table space types or if the intent is to have DB2 automatically determine an initial size. Note: The actual value used by the database manager may be slightly smaller or larger than what was specified. This action is taken to keep sizes consistent across containers in the table space and the value provided may not allow for that consistency. |
| SQLINCREASESIZE | sqlint64 | Defines the size that the database manager automatically increases the table space by when the table space becomes full. This field is only relevant for table spaces that have auto-resize enabled. Use a value of SQL_TBS_AUTOMATIC_INCSIZE if auto-resize is disabled or if the intent is to have the database manager determine the size increase automatically. Note: The actual value used by the database manager may be slightly smaller or larger than what was specified. This action is taken to keep sizes consistent across containers in the table space and the value provided may not allow for that consistency. |
| SQLMAXIMUMSIZE | sqlint64 | Defines the maximum size to which the database manager automatically increases the table space. Alternately, a value of SQL_TBS_NO_MAXSIZE can be used to specify that the maximum size is "unlimited", in which case the table space can grow to the architectural limit for the table space or until a "filesystem full" condition is encountered. This field is only relevant for table spaces that have auto-resize enabled. Use a value of SQL_TBS_AUTOMATIC_MAXSIZE if auto-resize is disabled or if the intent is to have the database manager determine the maximum size automatically. Note: The actual value used by the database manager may be slightly smaller or larger than what was specified. This action is taken to keep sizes consistent across containers in the table space and the value provided may not allow for that consistency. |
| SQLAUTORESIZE | CHAR(1) | Specifies whether auto-resize is enabled for the table space or not. See the information that follows this table for values. |
| SQLINITSIZEUNIT | CHAR(1) | If relevant, indicates whether SQLINITSIZE is being provided in bytes, kilobytes, megabytes, or gigabytes. See the information that follows this table for values. |
| SQLINCREASESIZEUNIT | CHAR(1) | If relevant, indicates whether SQLINCREASESIZE is being provided in bytes, kilobytes, megabytes, gigabytes, or as a percentage. See the information that follows this table for values. |
| SQLMAXIMUMSIZEUNIT | CHAR(1) | If relevant, indicates whether SQLMAXIMUMSIZE is being provided in bytes, kilobytes, megabytes, or gigabytes. See the information that follows this table for values. |