# 5.9 version (8/14/97)
# Swatch configuration file for constant monitoring
# 
# First have all the ignored lines:

# (from nightly processing)
# ignore tables with keyword table names 
/dbo.ErrorMessages|dbo.severity/	ignore
/dbo.io_error_code|dbo.io_incident_error_type/	ignore
/dbo.io_errors|dbo.io_error_constants/		ignore
/dbo.mis_error/		ignore
/dbo.errorlog/	ignore
/dbo.Error2/	ignore

# (from Dbcc checking)
# ignore spurrious allocation Dbcc errors
# ignore the DBCC status lines containing word error
# Ignore dbcc checktable messages containing keyword names
/Msg 2521|Msg 2540|Msg 2541/	ignore
/Msg 2546|Msg 7939|Msg 7940|Msg 7949/	ignore
/printed error/		ignore
/TABLE|Checking/		ignore

# (from datatools log checking)
# ignore select messages containing word error
# 5700 messages are Open client informational, 3216 informational
# 4207, 4221 come with other lines...ignore these
# datatools prints like 4 lines for each message...don't need them all
# 4205 comes on Degas for gqlreport...don't need to see it.
# Msg 0 informative! ignore it!
/colid|c.error/	ignore
/m.error/	ignore
/Msg 5701|Msg 3216/	ignore
/Msg 4207|Msg 4221/	ignore
/SYBMSG 4221/	ignore
/msgno=/	ignore
/DB-library/	ignore
/API/		ignore
/Open Server/	ignore
/db_err_handler/	ignore
/non-logged/	ignore
/Msg 4205|SYBMSG 4205/	ignore
/Msg 0/		ignore

# (from errorlog checking)
# ignore Msg 1608; client disconnect msg
# ignore various messages that appear in Errorlog along with other error msgs.
# Ignore network errors...can't really do anything about them
# ignore end of dump tran with no_log warning message
# ignore crimson dumping messages on tables that don't matter
# ignore backup server msgs telling of char set conversion
# ignore some messages in 605 info section...don't need to know twice
# ignore 1105s...always accompanied by more informative msg
# ignore 2812: mistyped stored procedure name
/Error: 1608/		ignore
/ERROR CAUSED/		ignore
/lasterror|preverror/	ignore
/errorlog.prod11|errorlog_CC/	ignore
/prod11_backup.errorlog/	ignore
/errorlog_crimson_dev|errorlog_cimp/	ignore
/errorlog.isd_devel|errorlog.prod/	ignore
/peter.errorlog|prod11.errorlog/	ignore
/prod.errorlog|CC_BACKUP.errorlog/	ignore
/new_crimson.errorlog/		ignore
/dstartio/ 		ignore
/NO_LOG was/	ignore
/gqlreportdb with NO_LOG/	ignore
/tempdb with NO_LOG/	ignore
/iso_1/		ignore
/transient|OCCURRED/	ignore
/DB-LIBRARY/	ignore
/Error: 1105/	ignore
/Error: 2812/	ignore

#########################################################################

# Sybase Errorlog, Backuplog conditions

/Recovery complete/ 	mail=Server Started/completed recovery

/stack trace/ 	mail=Stack trace
/infected with 11/ 	mail=Memory infected with 11 
/SQL causing error/ 	mail=Stack trace!
/bufunhash|Bufunhash/	mail=Buffer Cache problem
/Error: 605/	mail=605 MAJOR PROBLEMS
/ERROR 605/	mail=605 MAJOR PROBLEMS
/Fatal/		mail=Fatal Server error

/Unable to write/	mail=log full
/LCT/		mail=LCT fired!
/still open/	mail=Backup problem
/dump xact/	mail=xact dump w/ nolog
/Error: 4207|Error: 4221|Error: 4225/	mail=Dump Tran problem
/Error: 4216|Error: 4204/	mail=Dump Tran problem
/Error: 4208/	mail=Dump Tran problem
/Error: 7235/	mail=Backup problem
/number 20018|number 20019/	mail=Backup problem
/number 20109/		mail=Backup problem
/Error: 840/	mail=Fatal: Device not started
/Error: 3414/	mail=Fatal: database wont recover
/Error: 7105/	mail=Page allocation error

# all kernel messages below
/ueshutdown/ 	mail=Server shutdown
/udactivate/ 	mail=error starting virtual device
/udstartio/	mail=error starting virtual device
/sddone|dcreate/ 	mail=scsi disk error or device full
/dbsspacket|udfree/ 	mail=scsi disk error or device full
/nopen/ 	mail=too many open files
/nclose|nconnect/ 	mail=strange tcp errors
/ninitconn_free/ 	mail=strange tcp error
/kdconfig|kiconfig/ 	mail=Server cannot restart
/basis_dlock/ 	mail=Server cannot restart
/os_detach_region/ 	mail=Server cannot restart 
/dbsopen/	mail=File write problem
/nrpacket/	mail=Connection timed out
/timeslice/	mail=strange server problem

# Datatools errors
/\[ERROR\]/	mail=Misc Datatools problem
/Unable/	mail=Datatools backup failed
/signal=15/	mail=Datatools backup failed
#/SYBMSG 8009/	mail=Datatools backup fail
#/SYBMSG 407402/	mail=Datatools backup fail
#/SYBMSG/	mail=Misc Datatools problem
#/Msg 208|Msg 407402/	mail=Datatools Backup problem
#/Msg 8009/	mail=Datatools connectivity problem

# DBCC output messages
/Msg/		mail=DBCC Error encountered

# Last chance generic SQL Server messages
/error|severity/	mail=Misc Server error
/Error|ERROR/	mail=Misc Server error
/Fail/ 		mail=Connectivity Error
/Error: 1601/	mail=User connection problems
/closetable/	mail=server error
/Terminating/	mail=Backupserver shutdown

# Update statistics/sp_recompile conditions
/Sybase message/	mail=Nightly Maintenance Error occurred
/Severity/	mail=Nightly Maintenance Error occurred