Connect using a different port using a comma between the server name/IP and the port:
servername,port
or
serverIP,port
netstat - network statistics
netstat is a command displays statistics on all network activities.
main options:
-a Displays all active ports
-n Numerical display of addresses and port numbers
-o Displays the process identifiers (PID)
| grep 11753 - displays information only for IP 11753 (or other filter)
netstat -a -n | grep 11753
SAP (sybase) RS - some basic and useful scripts and queries
Select RS version
1. Login RS and run:
admin version
2. Without login:
cd $SYBASE/REP-16_0/bin/
repserver -v
A list of running / not running components
admin who
admin who_is_down
(Executed from RS)
Get the name and path of the RS log
admin log_name
(Executed from RS)
Information about databases and replication definitions
select * from rs_databases
select * from rs_subscriptions
select * from rs_publications
select * from rs_dbreps
exec rs_helpdb
exec rs_helprep
exec rs_helpsub
(Executed from RSSD databse)
sp_monitor - statistics about SAP ASE Server
sp_monitor displays statistics about SAP ASE Server.
It can run with few options:
1. General information about how busy the Server has been:
sp_monitor
go
2. Information about connections:
sp_monitor "connection"
go
sp_monitor "connection","diskio"
go
3. Information about statements:
sp_monitor "statement"
go
4. Information about the most recently run procedures:
sp_monitor "procedure"
go
* and more.....
More details in SAP site.