The tablespace data is not collected by default because the stored procedure needs a specific name of the database. When the stored procedure isn't available then the specific databases need to be added when creating agent (or by editing agent properties).
The following query can be used to check if the stored procedure is available on the host server. There should be rows in the result.
select segment
from dbo.systhresholds
where proc_name = 'sp_dbxt_extend_db'
To add the specific databases in the agent properties.
- Go to Administration | Agents | Agent Status
- Select a Sybase agent
- Click Edit Properties
- Click the link to edit the private properties for the agent
- Scroll down to Table Space Management
- Click the Clone button to clone the property
- Enter a name into the popup for the agent
- Click the OK button
- In the pulldown, choose that agent name
- Click the edit button
- Click the add row button
- Add a database name, threshold mb, and number of top tables
- Click the Save button
- Click the Save button
- Deactivate the agent
- Reactivate the agent
- Wait a couple of minutes
- Check the panel