Error SQL1105 "Can't allocate space for object..." - SAP ASE

One of following errors can be observed:Error 1105 Can't allocate space for object '<object_name>' in database 'saptools' because 'default' segment is full/has no free extentsError 1105 Can't allocate space for object 'syslogs' in database 'saptools' because 'logsegment' is full/has no free extentsError SQL1105 "Can't allocate space for object..." "Identify the...

How to disable Transaction log on Sybase ASE

During Execution phase of an upgrade, when you ae performing archiving activities on Development or Quality system but you don't have enough space for keeping transaction data or because of some specific reason if you want to disable the trans log on your Sybase system you can follow this option.This is not recommended on Production systems because as the transaction...

How to 'lock' and 'unlock' 'sa' login - SAP ASE

Following errors  facing while login to isql in sybase DB with 'sa' account .*  unable to connect as user 'sa'*  ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.*  isql -Usa -SSID -X   Msg 4002, Level 14, State 1:   Server 'SID'   :Login failed.   CT-LIBRARY error:For...

How to take database backup in Sybase ASE

Database Backup commands :-Login to Sybase Database as SYBSID user> isql  -Usapsa -PXXX -SSID   -X> go> use master> go> dump database <SID> to "<directory> "> goDatabase backup with compress option:-Login to Sybase Database as SYBSID user> isql -Usapsa -PXXX -SSID -X> go> use master> go> dump database <SID> to "<directory>"...

Reset sa, sapsa passwords in Sybase ASE

If you don't know the database user passwords in sybase, this post describe the password reset process.For resetting the DB user password do the following the activities first,* Shutdown the  Database system* Edit the 'RUN_SID' fileRUN_SID' File location-Unix     -...

Adding & resizing Datafile in Sybase ASE

Displays information about all the devices on Adaptive Server:>  sp_helpdevice>  goDisplays information about any devices on Adaptive Server:>  sp_helpdevice [device name]> go New Data file addition command :-> use master> go> disk init name='SID_data_XX', phyname="Location\file name', szie = "Size in mb', directio='true'> goafter added...