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

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

You May Also Like

Leave a Reply?