Question Re: Sybase client tools in Technology Q&A

Sybase client tools

Former Member — Wed, 04 Nov 2015 05:54:44 GMT

Can someone confirm that Sybase Central is not part of SAP on ASE installation. What client tools are generally used to monitor, administer DB's. I know DBACOCKPIT can be used to monitor but how about administration. Is SAP planning a brtools equivalent in the coming months or is the ISQL only way to administer. Is Sybase control center the recommended path by SAP to administer Sybase currently and going forward. I am still doing my ground work and need your inputs to better approach our transition into Sybase.

Also I dont see DBACOCKPIT guides under operations for 7.3/7.31/7.4. I only see security and IQ guides. Any pointers here are appreciated as well.

Regards

Kalyan

Re: Sybase client tools

dawn_kim — Wed, 04 Nov 2015 13:33:33 GMT

Hi,

They pulled Sybase Central from SDK 15.7 SP100 and higher.
Please note there is no longer a PC-Client for ASE either in the ASE 16.x version.
Ref: http://scn.sap.com/docs/DOC-56188

When you get ASE installation there is a tool called SCC (Sybase Control Center)
You can use isql or DBISQL (Interactive SQL which can be used as a gui form.

Someone else needs to tell you about DBACOCKPIT and what it can all do.

Thanks,
Dawn Kim

Re: Sybase client tools

crisnormand — Wed, 04 Nov 2015 13:51:50 GMT

Hello,

Just as information, SDK and PC client don't apply when talking about SAP ASE in a Business Suite environment.

We have our own client package names DBCLNTxx where xx is the version.

Regarding DBA Cockpit, it is the recommended way to administer and monitor SAP ASE for Business Suite and the guide is available from Marketplace:

HTH

Cris

Re: Sybase client tools

Former Member — Wed, 04 Nov 2015 14:01:29 GMT

Thank you Dawn and Cris for taking time out and responding.

Cris,

I have gone through the operations section on NW 7.4(link attached)

https://websmp108.sap-ag.de/operationsnw74

I however cannot see the attached guide.

SAP DBA Guide: SAP Adaptive Server Enterprise

I only see one for SAP on SAP IQ and security guide for ASE.

Does this mean this guide is withdrawn and published else where. Can you advise.

Regards

Kalyan

Re: Sybase client tools

crisnormand — Wed, 04 Nov 2015 14:48:48 GMT

This is what I see when clicking on the link you pasted above:

Cris

Re: Sybase client tools

Former Member — Wed, 04 Nov 2015 14:57:28 GMT

Really strange, I am using a S-User which has access to download Sybase software and i can download all the other guides with the operations section. For some reason, this seems to be only available to SAP as we get "Error Message - Access denied. I have downloaded Sybase software directly so its not an authorization issue perse. I even asked a colleague who has a different S-User ID, he too reports the same. If you are from SAP, can you check if the guide is available for download for customers and partners or is it only internal to SAP

Regards

Kalyan

Re: Sybase client tools

Former Member — Wed, 04 Nov 2015 15:05:16 GMT

This is what i see