MAX DB database size increases to 92%

[Former Member]

Hi All,

We are using maxdb database for BI production server, But problem is, database size increases to 92%.

Please help me to reduce the data base size.

Regards

Kemparaju

[JPReyes]

Well... thats what databases do, they grow!... is there a particular issue that makes you think that the DB should be shrinked/reorganized??... otherwise simply extend the tablespaces.

Regards

JUan

[Former Member]

Hi,

Thanks for reply, I have deleted spool requests, dump errors and background process lists like wise any other things i can remove that means deleted things should not affect for any other things.

thanks and regards

Kemparaju

[JPReyes]

I'm sorry but you need to do some reading... deleting a few entries from some tables via cleanup jobs is helpful but it will not reduce the size of the database considerably.... You simply need to acommodate enough space to project the growth of your database.

Regards

Juan

[Former Member]

Hi,

Please can you give me some suggestions for, How to accommodate the space to database.

Thanks and Regards

Kemparaju

[JPReyes]

You can do that using the MaxDB database manager

That information is widely available, please do some research before posting

Read the "Rules of Engagement"

Regards

Juan

[Former Member]

Hi,

i have increases the volume size now it is ok.

Thanks and regards

Kemparaju