List of things / options tat can be checked through db13

[Former Member]

Hello Experts,

when i see transaction db13 ,there is long list of things and options that can be checked through it, What does CheckDB , Next Extent and Update statistics options do and check there?

Also plz tell abt the various options that can be checked there including details in it.

Requested to revert at earliest. Points guaranteed.

regards,

Somya

[Former Member]

Hi Somya,

Following link might be of help to you

"http://help.sap.com/saphelp_47x200/helpdata/EN/f3/899b3c4d4d8d15e10000000a114084/content.htm"

Padmaja

[Former Member]

Hello Padmaji and Ganesh,

Padmaji : I wld appreciate if u could give me detailed info urself .

ganesh : if u could detail it ,it sahll be helpful.

Regards,

Somya

[former_member204746]

Somya, RTFM !

[Former Member]

Hi Somya,

DB13 is DB planning Calender to perform different types of DB activities.

Some jobs are to perform Database Backup and some jobs are database housekeeping jobs.

1. Check and update optimizer statistics

Checks and, if necessary, updates either all tables or tables of the specified tablespaces

2. Adapt next extents

Adapts the values for the NEXTEXTENT of all tables or tables of the specified tablespace

3. Check database

Checks the database system

4. Verify database

Verifies the database

5. Cleanup logs

Cleans up the database logs

****Reward points if Helpful*****

Regards,

Ganesh