Table space issue

[rahul_yedapally]

Hello ,

These two tablespace "saptools","sybmgmtdb", are running out of space Timebeing we have increased the space

But we need any standard solution to clean up these table space regularly

Can any one help on below issue

Thanks,

Rahul

[former_member187136]

Hey Rahul,

As you specified there is a space crunch in your setup. I am interested to know on which device you facing the issue (data device or log device) which can be found in your error_log.

If it is onto the data device, you may want to find out why the space gets filled up.

Example: Any problem in your job_scheduler will impact the "sybmgmtdb" database

If it is onto the log device, you may need to check the transactions that let the space to get eat-up.

Aah. I remember good write-up from my colleague, kindly refer this:

https://scn.sap.com/community/ase-custom-applications/blog/2013/06/05/ase-faq-my-transaction-log-fil...

Regards

Kiran K Adharapuram

[former_member187136]

Hi Rahul,

Hope you are from Oracle background

Can you provide me the below details from isql, I may help you..!!!

1> sp_helpdb saptools

2> go

1> sp_helpdb sybmgmtdb

2> go

1> sp_helpdevice

2> go

Regards

Kiran K Adharapuram

[Former Member]

Dear Rahul,

saptools and sybmgmtdb they aren't tablespaces or tables. They are system and user databases respectively in Sybase.

Is it the data or the log portion getting filled in regularly?  Assuming it id the log. I would suggest you to have "trunc log on chkpt" enabled for them. Secondly have a dedicated log device created for each of the database.

Regards,

Ajith Prabhakaran