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

Start & Stop Wily Introscope

Login to the operating system. go to location - /usr/sap/ccms/apmintroscope/binStatus Check -./EMctrl.sh statusStart Wily Introscope -./EMctrl.sh startStop Wily Introscope -./EMctrl.sh stopIf stop command not working then kill the running wily introscope process.kill -9 PIDPID...

Wily Introscope Upgrade for Solution Manager (Linux)

To upgrade the existing Wily Introscope in your solution manager system. Please follow below steps,Download the latest Wily Introscope file from SAP software download center,https://launchpad.support.sap.com/#/softwarecenter---> SUPPORT PACKAGES & PATCHES ---> By Alphabetical Index (A-Z)---> S---> SAP SOLUTION MANAGER---> SAP SOLUTION MANAGER 7.2--->...

STMS configuration in single system with virtual system

You have 1 SAP system and you want to configure 3 or 2 system landscape in the STMS. Login to the 000 client with DDIC user and execute transaction code STMS. You will be prompt a box which asking to configure Transport Domain. Fill in the description and save. Now...

Delete SAP Client from OS Level

Instead of delete SAP client from SAP application level we can do the same from OS level as well. It is bit faster than application level. This may useful at sometime.1. Login to application server OS level with SIDADM User2. Go to location /usr/sap/trans/bin directory3....

Mass user deletion in SAP

We know mass user activities in SAP we are able to do using SU10 transaction code.But if we want to delete 1000 users at a single time it is difficult to enter the 1000 user name or upload from the clip board. In that situation we can use below option,Got to SU10 T-codeChoose multiple...

SAPOSCOL - Operating System Collector

Ø  What is SAPOSCOL ?SAPOSCOL is a stand-alone program that runs in the operating system background. It runs independently of SAP instances exactly once per monitored host. collects data about operating system resources like,Usage of virtualUsage physical memoryCPU...