db02 showing old values

[Former Member]

Hi All,

Two days back we increased the tablesapce PSAPSR3 but today when we checked the db02 ,its not getting updated. Same for database size.Current database size is more that 800 GB but in DB02 it is still showing 640 GB.

What could be the reason behind this??

If SAPOSCOL is the reason then from whr I can check the same at SAP GUI level.

Regards,

Prashant

[Former Member · Accepted solution]

schedule Check and update optimizer statistics or Check database from db13 as regular backgroud job every day

this will update db02

Samrat

[Former Member]

Hi Prashant

The following are the details on SAP Standard Jobs

Job name | Program | Variant | Repeat interval

-

---

SAP_REORG_JOBS | RSBTCDEL2 | yes | daily

SAP_REORG_SPOOL | RSPO0041/1041 | yes | daily

SAP_REORG_BATCHINPUT | RSBDCREO | yes | daily

SAP_REORG_ABAPDUMPS | RSSNAPDL | yes | daily

SAP_REORG_JOBSTATISTIC | RSBPSTDE | yes | monthly

SAP_COLLECTOR_FOR_JOBSTATISTIC | RSBPCOLL | no | daily

SAP_COLLECTOR_FOR_PERFMONITOR | RSCOLL00 | no | hourly

SAP_COLLECTOR_FOR_NONE_R3_STAT | RSN3_STAT_ | no | hourly

COLLECTOR

SAP_REORG_PRIPARAMS | RSBTCPRIDEL | no | monthly

SAP_REORG_XMILOG | RSXMILOGREORG | yes | weekly

SAP_CCMS_MONI_BATCH_DP | RSAL_BATCH_ ..| no | hourly

TOOL_DISPATCHING

SAP_SPOOL_CONSISTENCY_CHECK | RSPO1043 | yes | daily

SAP_REORG_ORPHANED_JOBLOGS | RSTS0024 | yes | weekly

In any case, refer to Note 48400 regarding the spool and TemSe Consistency check.

Check the following link for more:

http://www.saptechies.com/standard-jobs-reorganization-jobs/

and

http://www.learnbasis.com/sap/index.php?option=com_documan&task=cat_view&gid=14&Itemid=20&mosmsg=Youaretryingtoaccessfromanon-authorizeddomain.+%28www.google.co.in%29

I hope this helps

Regards

Chen

[Former Member]

Prashant,

Please check your standard background jobs are running or not. Also you can check/start/stop saposcol from ST06.

Hope this helps.

Manoj

[Former Member]

Hi,

Could you please let me know the standard job which I need to check?

Regards,

Prashant

[Former Member]

Prashant,

check the link. You will find the job names and how to check.

[]

Manoj