Skip to main content

Unix Script 2- Check Health of Rep Server

echo "Enter Server Name: \c"
read SERVER
echo "User Name : \c"
read User_Name
echo "Enter Passwd : \c"
read PASSWD

isql -U$User_Name -S$SERVER -P$PASSWD  -w2000

echo "############ Hello You Are Checking $SERVER Replicaiton Status ! ##########"
go
echo "#########################################################"
go
echo "Rep Server Health -Displays status information.Status is HEALTHY when all threads are running, otherwise SUSPECT."
go

admin health
go

echo "#########################################################"
go
echo "Displays the threads that are not running"
go

admin who_is_down
go

echo "#########################################################"
go
echo " Displays the state and amount of used space for disk partitions "
go
admin disk_space
go

echo "#########################################################"
go


echo "#########################################################"
go
echo " Displays status information about the transactions of each queue"
go
admin who,sqt
go

echo "#########################################################"
go


EOF

Comments

Post a Comment

Popular posts from this blog

How to set data cache,procedure cahe in ASE

1> sp_cacheconfig "default data cache","1G" 2> go Msg 10879, Level 16, State 1: Server 'SPICE_BIAPPS', Procedure 'sp_cacheconfig', Line 1167: The current 'max memory' value '58368', is not sufficient to change the size of cache 'default data cache' to '1G' (1048576 KB). 'max memory' should be greater than 'total logical memory' '579786' required for the configuration. (return status = 1) 1> sp_configure "max memory" 2> go Parameter Name Default Memory Used Config Value Run Value Unit Type ------------------------------ ----------- ----------- ------------ ------------ -------------------- ---------- max memory 58368 116736 58368 58368 memory pages(2k) dynamic (1 row affected) (return status = 0) 1> sp_configure "max memory","1G" 2>...
1 comment
Read more

Undocumented DBCC commands in ASE

Introduction Undocumented DBCC commands: • DBCC BUFFER • DBCC BYTES • DBCC DBINFO • DBCC DBTABLE • DBCC DES • DBCC HELP • DBCC IND • DBCC LOG • DBCC PAGE • DBCC PROCBUF • DBCC PRTIPAGE • DBCC PSS • DBCC RESOURCE • DBCC TAB Literature Introduction In this article I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 7.0 for administering and monitoring. DBCC is an abbreviation of a DataBase Consistency Checker. This is the description of DBCC from SQL Server Books Online: A statement used to check the logical and physical consistency of a database, check memory usage, decrease the size of a database, check performance statistics, and so on. Database consistency checker (DBCC) ensures the physical and logical consistency of a database, but is not corrective. Undocumented DBCC commands 1. DBCC BUFFER This command can be used to print buffer headers and pages from the buffer cache. Syntax: dbcc buffer ([dbid|dbname] ...
1 comment
Read more

Replication Server Quick Ref Guide

Replication Server Guide : • Replication Server Commands • ASE commands and system stored procedures • ASE RSSD stored procedures • RSSD tables • Replication Server System Functions • Troubleshooting Tips Abbreviations Some abbreviations which are used in this Quick Reference Guide: ASE Adaptive Server Enterprise DSI DataServer Interface - RS thread for a connection to a replicate database DIST Distributor - RS thread per primary database LTM Log Transfer Manager; synonym for RepAgent RS, RepServer Replication Server RepAgent Replication Agent (in primary dataserver) RepDef Replication Definition RSI Replication Server Interface - RS thread related to a route to another RepServer RSM Replication Server Manager (a DBA tool normally used in combination with Sybase Central) RSSD Replication Server System Database SQM Stable Queue Manager - RS thread managing a queue SQT Stable Queue Manager - RS thread assembling transactions Replication Server Commands The following commands can only be ...
Post a Comment
Read more