How to set up Automatic Table Maintenance(ATM) for SAP ASE

[Abhishek_Panda]

Implement the latest version of these two notes in sequence, 1668882 and then 2293673. 

Download the instbaldr.sql file attached to this SAP Note:##2502193 and uncompress it
>> Stop Job scheduler and then Execute the script (from the same drive where the you save the above instbaldr.sql file) with isql as user sapsa e.g.

To stop Job Scheduler:
isql -Usapsa -S<SID> -X
use sybmgmtdb
go
sp_sjobcontrol @name=NULL, @option="stop_js"
go

isql -Usapsa -X -S<sapsid> -w999 -i instbaldr.sql

Once the above script executed, please run below command.

use saptools
go

SP_BALDR_ACTIVATE
go

To start Job Scheduler:

use sybmgmtdb

go

sp_sjobcontrol @name=NULL, @option="start_js"

go

select * from master..sysprocesSEP where program_name like 'JS Agent%' or cmd = 'JOB SCHEDULER'

use saptools

go

select [KEY], [VALUE] from DBH_CONFIG where [KEY] like 'BALDR%'

go

Adjust below SAP Parameters and restart SAP

SAP profile parameters are required to configure HTTP(S) ports, timeouts and SSO  tickets. Call transaction RZ10 and ensure the following profile parameters are set as follows:
login/create_sso2_ticket = 2
login/accept_sso2_ticket = 1
icm/server_port_0 = PROT=HTTP,PORT=80$$,PROCTIMEOUT=600,TIMEOUT=600
icm/server_port_1 = PROT=HTTPS,PORT=443$$,PROCTIMEOUT=600,TIMEOUT=600

Generation of the Web Dynpro Runtime:
Call transaction SGEN
Select 'Generation of Web Dynpros'
Choose 'Continue'
Select software component 'SAP_BASIS'
Choose 'Continue'
Choose 'Continue'
Choose 'Start Job Directly'
1. Call transaction SICF_INST.
2. Enter 'WEB DYNPRO ABAP' as technical name.
3. Choose 'Execute'.
4. Enter 'WEB DYNPRO DBA COCKPIT' as technical name.
5. Choose 'Execute'.
Activate all NWBC ICF services - Tx SICF - Service Name - NWBC - F8 - Actvate all services

Start Transaction SICF.
Go to default_host → sap → public → bc → uics.
Activate service UICS and its sub-nodes (which can be located under node UICS).
With this, you should be able to access the DBACOCKPIT in web browser mode and schedule the ATM window. Although its still alright, but you can still go to the respective ATM template profiles and customize the various thresholds and schedule them as per the business requirements if necessary. 

#SAP# SYBASE#ASE#DBACOCKPIT#ATM#ABAP