ASE admin - monitor tools

[former_member801971]

Hi gurus

After some years I return to do admin SAP - Sybase ASE

I have an old version -8.6- of dbartisan, but can't connect to ASE instances because uses -X option. I tryed using net passwd encription and ssh option in this tool, but have error 1640 ASE requires encryption of the login passswd on the network

Sybase Central is not availbe to download

SAP Cockpit and SCC require flashplayer that is no more available, so can't be use

So, what admin tool can I use to ASE aministration - monitoring

[rsnit · Accepted solution]

hi Hugo,

did you tried to use isql? its sql connectiontool of ASE, so connectionstring should look like that (run it with user syb<sid>)

syb<sid> = OS User

sapsa = DB User

<host>:syb<sid> > isql -Usapsa -S<DBSID> -P<password> -w1024

its documented in 2007792 (its for unix but its smiliar to linux)

furthermore you can integrate your ase in dbacockpit of your abap system. there are also some predefined stored procedures available, but they are not mandatory for administring this "database"

br

robert

[former_member801971 · Accepted solution]

Hi Snit

In fact I am working with isql, but want a more robust aplication like was the one we have before, but SAP deprecated

isql sometimes is slower and the outputs are not formated

[prithvirajr]

Hi,

Tcode DBACOCKPIT? or have you tried installing and configuring AMC (Administration and Management console) as you rightly said Sybase cockpit is depreciated.

https://blogs.sap.com/2021/04/20/sap-ase-business-suite-amc-configuration/

Regards,

Prithviraj