learning_sybase
asked on
how is this line getting into error log of sybase
Hi,
I have a database A which is now 85% full , i want to know how is this line coming in the errorlog for this database A:
server background task message: Error: 1, Severity: 50, The default segment on A database is now 80 percent
I also have a database B, which is 90% full but no such warning is coming in errorlog for B, i want to understand how this works.
This is not coming through sp_thresholdaction because inside that stored proc the comment is different.
Please advise
I have a database A which is now 85% full , i want to know how is this line coming in the errorlog for this database A:
server background task message: Error: 1, Severity: 50, The default segment on A database is now 80 percent
I also have a database B, which is 90% full but no such warning is coming in errorlog for B, i want to understand how this works.
This is not coming through sp_thresholdaction because inside that stored proc the comment is different.
Please advise
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i can see these 2 thresholds in my database :
EXEC sp_addthreshold 'fmr_reference','default', 158720,'sp _threshold action'
EXEC sp_addthreshold database_name_A ,'default',317440,'sp_thre sholdactio n'
and still my database got full 100% and no warning in errorlog...i am confused ??
Also whenever i increase the data segment space (add more space to my database) do i need to reset the thresholds each time ??
EXEC sp_addthreshold 'fmr_reference','default',
EXEC sp_addthreshold database_name_A ,'default',317440,'sp_thre
and still my database got full 100% and no warning in errorlog...i am confused ??
Also whenever i increase the data segment space (add more space to my database) do i need to reset the thresholds each time ??
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
..
ASKER
i checked and i found few more sp_thresh_....stored procs in sybsytemprocs database, so that means they must be getting called.
Other queries:
1. what is the default setting for a new database created? are there any thresholds created for default and log segments, if yes then why in my case default segment got 100% full without giving any warning in the error log?
2. what is the formula to calculate the values for sp_thresholdaction