REORGANIZE DATABASE

[Former Member]

Hi

How to reorganize database using brtools. please guid me.

Thanks & Regards

Siva

[Former Member]

Dear

go with following note

541538 - FAQ: Reorganizations

646681 - Reorganizing tables with BRSPACE

shailesh Tiwari

[Former Member]

Hi

How to reduce MAXBYTES using brtools. I ams using ECC 6, KERNAL 700 , SUPPORT PACK LEVEL 114.

Please guide me.

Thanks & Regards

Siva

[fidel_vales]

Hi,

I wonder <b>why</b> do you want to reorganize the <b>complete</b> database.

Most of the cases it is a complete waste of time.

And if you do NOT know HOW to do it, probably it is even more.

Is there a "real" reason why you want to do it or do you feel it would be better to spend x hours/days doing it

[Former Member]

Hi,

Because some warnings are there like CRITICAL_TABLESPACE. thats why i want to plan reorganize.

Thanks & Regards

Siva

[fidel_vales]

O_o

Lets take a look at the note 849484 "New CRITICAL_TABLESPACE check condition in BRCONNECT":

<quote>

<i><b>This condition is processed if there are several Autoextend files of a tablespace on the same disk. The system then checks whether there is sufficient free space on this hard disk to extend these files to the maximum size (max_extn). </b></i>

</quote>

Trying to solve this issue with reorganizing the database is nonsense!

There is no need to reorganize the database for this item!

Please, read it again, slowly, 3 times ( or more if needed ) and try to explain to someone that does not know anything about IT ( your Manager for example ) what it means. Afterwards, you will realize why it does not make sense.

If <b>you</b> still have issues understanding, then I'll try to explain it.

[Former Member]

Hi Fidel,

Thanks for your advise,

I didn't understand the problem my hard disk has so much space but why they gave warning.

Please explain more briefly how to do it.

Thanks & Regards

Siva

[fidel_vales]

I'll try.

Lets make a picture.

You have a HD (filesystem), 200 GB Free

You put there a tablespace. PSAPEXAMPLED

This tablespace has 3 datafiles. They are created 2 GB each.

At this moment you have 3 GB used -> 197 Gb Free. Clear, isn't it?

But BRCONNECT takes a closer look.

The 3 datafiles are autoextend. This means that, when the objects on the tablespace need to allocate more space and the datafile is full, the datafile will increase the size.

In general, you put a limit to this growth, you do not want the datafiles to grow more than the size of the hard drive(filesystem).

So, Lets assume that the 3 datafiles are AUTOEXTEND. And the MAXSIZE of each datafile is 100GB

The current situation that BRCONNECT sees is:

HD(filesystem) -> 200 GB space, 197 free

3 Datafiles

current size 3 GB

MAXIMUM SIZE 300 GB

MAXIMUM SIZE >> HD(filesystem) available space --> Warning --> CRITICAL SPACE

Reorganizing the database here is a waste of time, if the datafiles are created with the same characteristics on the same filesystem.

You only have to restrict the MAXSIZE of the datafiles ( or change teh autoexted to noautoextend )

Note -> this is an operation that takes "minutes" ( look at the BRCONNECT alert, find the files, check the maxsize, compare with the available space on the disk/filesystem, decice the action, perform the action ) compared with the hours/days that can take the database reorganization

Message was edited by:

Fidel Vales

[Former Member]

Thank you Fidel,

Which is the best option MAXSIZE or AUTOEXTENDEDOFF.

Thanks & Regards

Siva

[fidel_vales]

There is no Good/Bad answer for that.

It totally depends on the DB administrator, on how it monitors the system and "preferences" or Company politcies.

[Former Member]

Thank you,

how to restrich MAXSIZE using brtools.

could you please advise me.

Thanks

siva

[fidel_vales]

You should

- check the documentation

- Check the brtools, it is very intuitive:

- Start brtools

- 2 - Space management

- 5 - Alter data file

At this point you can fill the points 2 3 4:

2 - Database user/password (user) ... [sapr3/***]

3 ~ Alter data file action (action) . [autoext]

4 ~ Tablespace names (tablespace) ... [PSAPBLABLAD]

You choose continue and BRSPACE is started

Select the option 3 ( default one in this case )

3 = Maintain autoextend

you are presented with the list of files for the tablespace selected.

You choose one and change the data there, in your case it would be option 5

Maximum file size in MB (maxsize) ....... []

[Former Member]

Hi Siva,

You can do reorganization using brspace directly or using brtools. Please read these note and it will help you to perform this action.

646681

541538

Thanks

Prince Jose

[Former Member]

see please the following SAP Notes:

541538 - FAQ: Reorganizations

646681 - Reorganizing tables with BRSPACE

Best regards

Baran

[Former Member]

you can reorganise tables, indexes and tablespaces. For Index rebuild see please the SAP note:

332677 - Reorganizing degenerated Indexes