How to Increase/Extend Data File(s) Size in Sybase IQ



Share this article :

Use below command to extend / increase the size of data files in Sybase IQ. Specifies the new size of the file in units of kilobytes (KB), megabytes (MB), gigabytes (GB), or terabytes (TB). The default is megabytes. You can increase the size of the dbspace only if the free list (an allocation map) has sufficient room and if the dbspace has sufficient reserved space.

ALTER DBSPACE [DATABASE_NAME]
ALTER FILE [DATA_FILE_NAME] ADD [HOW-MUCH-YOU-WANT]

##Example##
ALTER DBSPACE ITSITI
ALTER FILE DAARIS ADD 2GB

Reference

Sybase Infocenter

Related posts

Types of Database Space in Sybase IQ
How to Create Technical User in SAP IQ Cockpit
How to Change A User Password in Sybase IQ
How to Get Table Size in Sybase IQ
© 2018 ITsiti. All Rights Reserved
Powered by KEEM