sybase:CREATE or ALTER DATABASE failed because the device 'default' has no space available either for log or for data.




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"

Comments

  1. 21st Century Software SolutionsAugust 28, 2014 at 2:14 AM

    sybase online training| sybase training| call us+ ...
    www.21cssindia.com/courses/sybase-online-training-159.html
    sybase training,introduction to sybase,employee training, sybase online training e-learning,sybase tutorial,online course.Many more… | Call Us +917386622889
    Visit: http://www.21cssindia.com/courses.html

    ReplyDelete
  2. 21st Century Software SolutionsOctober 8, 2014 at 1:34 AM

    Sybase Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/sybase-online-training-159.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, If you’re serious about a career in IT, 21st Century would like to provide you a guidance don’t hesitate to organize a free demo session. For any further information regarding the courses once go through our website Visit: http://www.21cssindia.com | Call Us +917386622889 - +919000444287 - contact@21cssindia.com

    ReplyDelete

Post a Comment

Popular posts from this blog

Hana XS Engine Troubleshooting

Overview:  HANA 2.0 is having XSA as base for many application like HANA cockpit, WEB IDE, Big Data Hub to name a few. You are lucky if you get it through for installation but sometimes you are stuck with few issues which you keep trying to solve , you don find solution. This Blog identifies and help you solve few of them. Getting a guide is very easy. But troubleshooting in real world might make your head spin. So sharing my experience. XX will represent the instance no. used in this blog. Error:  Adding role ‘xs_worker’ failed: Check /var/tmp latest update folder and it will mention the file name which contains more details. It should be with name like hdbmodify_addlocalroles.log. and Reason :  FAIL: process hdbxscontroller HDB XS Controller not running Sub Reason:   Could not startup the controller components: SAP WebDispatcher failed to bind application port (already occupied). Route to application will be unavailable. Restarting the...
Read more

Check Users Locked or deactivated in Hana or Hana Studio

Check Users; select * from users where user_deactivated= ‘TRUE’; Deactive hana user We can use the following SQL query to DEACTIVATE HANA DB user ; ALTER USER DEACTIVATE USER NOW; Example ; alter user HanaUser deactivate user now; To activate the user again we can use the below SQL query ; ALTER USER ACTIVATE USER NOW; Example ; alter user Hanauser activate user now;
Read more

Hana ini file location

The ini files are stored at the following default location on the server: /hana/shared/$SID/global/hdb/custom/config. File Details /usr/sap/ /HDB /exe/config Default values (not to be adjusted) /usr/sap/ /SYS/global/hdb/custom/config/ .ini Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on all hosts /usr/sap/ /SYS/global/hdb/custom/config/global.ini Valid for all services on all hosts /usr/sap/ /HDB / / .ini Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on a specific host /usr/sap/ /HDB / /global.ini Valid for all services on a specific host
Read more