Everything for SAP Hana / Basis /Technology / BO / BW

When this error start showing you that means you don't have space to be utilized by DB for data storage or even for log purpose. so you can't alter database size. You need to initialize some spare disk. > disk init name=sybase_disk,physname="D:\sybase_test_database\data\sybase.dat",skip_alloc="true",size="10G"

How to increase size of Sybase database on UNIX platforms ?Posted by Sybase Admin  Issue  I have problem in size of database because the free space of the database is less than specific percentage of total space. Cause Users used to update in the database and that lead to increase used space of this database Solution I)                Increase size of  database by creating new data file and log file ü  First we need to know the sequence of the exiting data and log files of this database to specify the name new files isql  -U  -P  // used to access sql  1>   sp_helpdb  DBname 2>   go ü  second we need to create the defined data file 1>   disk init name =”name of new data file” , physname =”destination path/name of data file” ,size=” desired space M” 2>   go ü  Third we need to create the defined log file 1>   disk in...