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...

Sybase DB Restore with Full Backup

Follow below steps to restore Sybase DB with a Full Backup Simple steps to restore your DB with a up-to-date full backup in the case of a emergency situation 1. Stop SAP Application & DB 2. Go to the below location, Windows - <Drive>:\sybase\SID\ASE-16_0\install  Unix        -   /sybase/SID/ASE-16_0/install 3. Database need...

Use the ONLINE DATABASE command to bring this database online; ASE will not bring it online automatically

After Sybase DB restore below message showing Use the ONLINE DATABASE command to bring this database online; ASE will not Bring it online automatically or SAP application cannot connect to the Business Suite ASE. [ASE Error SQL950][SAP][ASE ODBC Driver][Adaptive Server...

Database in use. A user with System Administrator (SA) role must have exclusive use of database to run load

Facing the below error while doing the backup recovery in Sybase ASE Database in use.  A user with System Administrator (SA) role must have exclusive use of database to run load. Reason :- The Database must...

Database Option 'trunc log on chkpt' turned off / Dump transaction is not possible on database in ASE

While tacking log backup in Sybase ASE the following errors may showing, Database Option 'trunc log on chkpt' turned off for Database 'SID' or Dump transaction is not possible on database Error Screens :- Solution :- This is because of the parameter sp_dboption...

ASE has run out of LOCKS - Export/Import or SPAM/SAINT Error

Sometimes will face the below errors while doing Export/Import, SPAM/SAINT or upgrade actvity in SAP with Sybase ASE.You will face dump like below,Or if you check DB log (SID.log), You can find the below error messages,ASE has run out of LOCKS. Re-run your command when there are...