4 task(s) are sleeping waiting for space to become available in the log segment for database sybmgmtdb

[adarsh_jainer]

Hi Team,

We are getting this details continuously in our database log.Is it related to saptools or any other db space. I have currently increaseed the saptools space to 500MB. Should i increase any other db space. Our SAP system is also getting slow. Please help its urgent.

Thanks&Regards,

Adarsh

[Former Member · Accepted solution]

Hi Adarsh,

Just increase your sap_log of your Sysbase DB. Do refer to attached thread for more reference on how to extend it.

Let us know if you need further inputs.

Regards,

Ram

[adarsh_jainer · Accepted solution]

Hi Ramakrsishna,

Thanks for your reply. I have increased my db log space to 100MB by using the below command, is the command correct?  Still i am getting same error. How much memory should i increase??

disk resize name="ABC_log_001", size="100M"

alter database ABC on ABC_log_001="100M"

go

Thanks&Regards,

Adarsh

[Former Member · Accepted solution]

Hi Adarsh,

do refer below thread for sizing of the tables and log sizes.

And refer below oss notes for same.

1687320 - SYB: 'saptools' database running out of space (2)

1615695 - SYB: 'saptools' database running out of space

also the command looks good and increase the log size say by 2gb. so that you wont see any issue if its Prod server.

Let me know if this helped you.

Regards,

Ram

[Former Member · Accepted solution]

Hello Adarsh,

Have you performed transactional log backup. if not take transactional backup and check again, before increasing.

Ideally ABC_log_001 size should be 10GB.

Regards

Anand

[adarsh_jainer · Accepted solution]

Hi Anand,

Thanks for your reply,

I have till date not took transactional log backup. I was told that if we take transaction log backup one we need to keep taking the backup once in 15 minutes everyday.Is it true?

And i have one more doubt, are you suggesting me to increase the MIP_log_001 to 10GB. I have no idea on that. How mch should i increase?

Thanks&Regards,

Adarsh

[Former Member · Accepted solution]

Dear Adarsh,

In your case you don't have to increase anything.

By default i guess your MIP_log_001 would be 10GB until unless you have opted for thoer values during installation.

Regarding frequency of Log backup, it purely depends on the system transactions.

15minutes transactional backup....That not true.

Perform following steps:-

Create two folders in E:Sybase/SID

1.Backups

2.log_archives

Goto E:/sybase/SID

execute---> SYBASE.BAT

isql -S<SID> -Usapsa -P<Password> -X

1> use master

2> go

1> sp_config_dump @config_name='<SID>DB',

2> @stripe_dir = 'E:\sybase\<SID>\Backups' ,

3> @compression = '101' ,

4> @verify = 'header'

5> go

1> sp_config_dump @config_name='<SID>LOG',

2> @stripe_dir = 'E:\sybase\<SID>\log_archives' ,

3> @compression = '101' ,

4> @verify = 'header'

5> go

For taking Full backup

isql -S<SID> -Usapsa -P<Password> -X

1> use master

2> go

1>dump database <SID> using config = '<SID>DB'

2>go

Similarly taking trasactional Backup

1> use master

2> go

1>dump transaction <SID> using config = '<SID>LOG'

2>go

Regards

Anand

[Former Member · Accepted solution]

@Anand,

Can you provide me with the location for this command/how to as i am also new to sybase and learning it slowly.

so it will be bit useful.

Thanks in advance for your help.

Regards,

ram

[Former Member · Accepted solution]

Hello Ramakrishna,

Please check following SAP note:-

1588316 - SYB: Configure automatic database and log backups

Regards

Anand

[former_member781151]

Hi All,

I have the same issue, and iam new to sybase database. could you please tell me what to do. i know sybase have different databases like with SID,MASTER,SYBMGMTDB ,,,,etc. now i have the same issue as above.

for which database sap_log should i increase. is it for SID Database or the one for the database name<sybmgmtdb> it is showing in the error log.

Please help. I have issue in prod db.

Thanks & Regards,

P Ramakrishna.

[Former Member]

Hello Adarsh,

where you able to resolve the issue.

Let us know if you have resolved it with solution.

Please close the thread if your query has been answered.

Regards

Anand