Sybase client tools

[Former Member]

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

[Former Member]

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

[Former Member]

This is what i see

[Former Member]

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

[crisnormand]

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

Cris

[dawn_kim]

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

[crisnormand]

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:

• SAP Service Marketplace
• Products
• Installation & Upgrade Guides
• SAP NetWeaver
• SAP NetWeaver 7.x (replace x with the version you want)
• Operations
• SAP DBA Guide: SAP Adaptive Server Enterprise ->  Chapter 7 DBA Cockpit

HTH

Cris