SAP Sybase ASE - How to Add Server Entry in Interfaces File Through DSCP

SAP Sybase ASE – How to Add Server Entry in Interfaces File Through DSCP

As you know interface file holds details of servers where Sybase ASE can connect to, here we are talking about server level, we shall cover details about client side in different post. A typical interface file contains server name(could be anything as per your choice), IP or hostname of the server and port number, which is used while configuring SAP Sybase ASE. Below is an example of interface file:

master tcp ether hostname 5000
query tcp ether hostname 5000

master tcp ether hostname 5001
query tcp ether hostname 5001

By default(unless changed), port number for Sybase ASE will be 5000 and for backup service, it would be 5001. Its worth to understand here that, errorlog will have same name as server_name mentioned in the interafces file. So, the errorlog and backup log file name will be server_name.log and server_name_BS.log respectively.

Lets see how to add an entry in the interfaces file using dscp command:

Please note that we need to start with open command before issuing add server command. Here last line confirms that Test_Demo_Post entry has been added into our interfaces file, used port number is 50000 instead of default port number 5000. We can cross check the entry as below:

The last entry is the one that we have added as per first screenshot, I have kept other two entry for you to understand that, at least there should be two entry for the Sybase ASE service to work – one for ASE and the other one for Backup service. As you can see, port number is very important, without which ASE service/backup service may not start. List all is the command that we use for listing all the entries in interfaces file.

Please leave your comment if you liked this post or have any feedback.

Leave a Comment

Your email address will not be published. Required fields are marked *