mxdbs db-add-storage
Syntax
mxdbs db-add-storage [-h | --help]
database_name
size
Description
The
mxdbs db-add-storage
sub-command adds storage to the specified database.
Parameters
database_name
- Specifies the name of the database.
size
- specifies the storage size in Gigabytes (GB) to be added to the database. The database size must be a numeric value between 1 and 102400.
Options
-h | --help
- Displays the help message and exits.
Considerations
- New volumes are not assigned if the requested additional storage can be accommodated from already associated data volumes.
- Newly assigned volumes to the database are added to the CQDs such as POS_LOCATIONS, SCRATCH_DISKS in the MXCS datasource associated with the database. The new volumes added to these CQDs will not be immediately available to the applications accessing the database. Applications must reconnect to use the newly assigned volumes for table or index partitions. Existing database objects will not use the added volumes. Use the MODIFY REPARTITION operation to extend existing database objects to all configured volumes.
- If enough volumes are not configured to meet the requested database size, an SQL error is returned and the operation fails.
- The Safeguard file-sharing group associated with the database is added to the Safeguard ACLs of the assigned volumes with create (C) permission. Users can use the assigned volumes for table or index partitions.
Example input and output
The following command adds extra storage to the database.
mxdbs db-add-storage db1 300
Hewlett Packard Enterprise NonStop(TM) SQL/MX DBS Client 3.5
(c) Copyright 2016 Hewlett Packard Enterprise Development LP.
db-add-storage command started.
--- mxdbs operation complete.
>>select * from db1.information_schema.db_storage;
STORAGE_VOLUME FULL_CAPACITY REQUESTED_CAPACITY RESERVED_CAPACITY IS_EXCLUSIVE
----------------- -------------------- -------------------- -------------------- ------------
\DEMOHOST.$SAS3 300000 202000 300000 Y
\DEMOHOST.$SWAPA 300000 198000 300000 Y
--- 2 row(s) selected.