Skip to main content

Posts

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 "############...
Post a Comment
Read more
Recent posts

Unix Script 1- to find the Zombee process and send email

#################################################################################################### # Script  - CATCHZ.ksh # Author  - Amol P Ingle # Date    - 5/24/2018 # Version - 1.0 # # Purpose - when stack trace with infected 11 hits ASE dataserver it will check #           1. Check Zombie process #              -if Zombie process came in then will send alert message to DBA Team #               with DBA Page to On-call DBA #              - even if zombie process not in server and infected message comes in errorlog then- #           2. Will check health of the ASE dataserver and send an email to DBA team #           3. Will check message with shutdown as well and if comes then will #              Alert email message t...
Post a Comment
Read more

Automatic Recovery in ASE

Automatic Recovery Automatic recovery is a process the server’s executes during every startup to ensure that each database is restored to a consistent state. It happen every time the server is started Transaction A transaction is a logical unit of one or more Transact-SQL statements Consistent State All committed transactions are reflected on the database device Any transaction that was not committed is not reflected on the database device(s) Syslogs ( transaction log ) Typically the whole row is recorded in the transaction log. ‘selects’ are not recorded in the log b’ cos the don’t modify the database. Transaction log pages and their corresponding data pages are processed in the data cache Data cache Data cache is a portion of Adaptive Server memory where data, index and log pages currently in use by the server are held. When pages are not in use by the server, they are stored in the disk. When any modification is made the corresponding page (data, log or index ) is brought into the c...
Post a Comment
Read more

Sybase IQ material - Quick Ref

Contents IQ 12.6 Commands IQ 12.6 Datatypes IQ 12.6 Functions IQ 12.6 System Procedures IQ 12.6 Catalogue Procedures IQ 12.6 Multiplex System Procedures IQ 12.6 ASE Compatibility System Procedures IQ 12.6 ASE Compatibility Catalogue Procedures IQ 12.6 Extended Procedures IQ 12.6 General Database Options IQ 12.6 T-SQL Compatibility Options IQ 12.6 DBISL Options IQ 12.6 Server Properties IQ 12.6 Database Properties IQ 12.6 Commands Two styles of commenting; the same as in ASE :- /* a comment between delimiters on one or more lines */ -- a comment until the end of this line ALLOCATE DESCRIPTOR descriptor-name [ WITH MAX { integer | host-variable } ] ^ALTER DBSPACE dbspace-name { READWRITE | READONLY | RELOCATE | SIZE dbspace-size [ KB | MB | GB | TB | PAGES ] | ADD dbspace-size [ KB | MB | GB | TB | PAGES ] } ALTER EVENT event-name [ DELETE TYPE | TYPE event-type ] { WHERE { trigger-condition | NULL } | { ADD | [ MODIFY ] | DELETE } SCHEDULE schedule-spec } [ ENABLE | DISABLE ] [ [ MODIFY...
Post a 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