The ScopeSET Support and Community Portal
         
View all tags
Tags:    No tags associated yet.

Symptom

No Sybase connection possible, the following type of errors appear in the Sybase error log:

00:00000:00022:2008/09/03 08:29:23.60 server  Space available in the log segment has fallen critically low in database 'tempdb'.  All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:00000:00017:2008/09/03 08:29:23.67 server  Error: 2812, Severity: 16, State: 5
00:00000:00017:2008/09/03 08:29:23.69 server  Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

Solution

A reboot of the Sybase server will usually clean the tempdb. If this happens frequently, we recommend to increase the size of the tempdb.

Start (isql) and run the following command:

1> alter database tempdb on default = 10
2> go
Furthermore, make sure you run "Perform Manager Maintenance" from the desktop's Admin menu frequently. Depending on overall activity, weekly or monthly at least.