SAP大量提示等待更新及大量后台日志如何处理
SAP 大量提示等待更新 及大量后台日志如何处理
sap大量提示 等待更新,sm50中更新进程运行时间很长,通过sm13 goto-》administration of update system 查看更新状态为inacitve 点击右边按钮 激活更新状态。 系统表空间不足,导致更新失败。扩展表空间后激活
如图所示: 故障原因:因srm上线,在生产机中后台测试运行RPODDELVRY
结果测试运行中没有输入“输入日期”,导致产生大量的测试运行的后台作业日
志,每五分钟运行1次后台作业,每个后台作业产生1万多页的物料凭证信 息,
占用大量lobsegment 空间, 'SYS_LOB0000161351C00006$$ ‘这个一天扩张140G。导致表空间被占满。
查询这个'SYS_LOB0000161351C00006$$再哪个表里面用下面的sql
SQL>
SQL> select owner,table_name from dba_lobs where
'SYS_LOB0000161351C00006$$' in
(segment_name,index_name);
OWNER TABLE_NAME
------------------------------ ------------------------------ SAPSR3 TST03
处理后台日志
1. Delete any objects that are no longer required. Spool objects that are no longer required can be deleted using spool administration.
-> Tools -> Administration
-> Spool -> Spool administration (Transaction SPAD)
-> Delete obsolete spool requests.
2. Delete job logs no longer required using report RSBTCDEL
3. TemSe consistency check
Transaction SP12 (menu path see above)
-> TemSe database -> Consistency check
As a result, the system displays a list with the inconsistencies.
4. Spool consistency check
Transaction SPAD (menu path, see above)
-> Consistency check (as of Release 4.X: Administration ->
-> Consistency check of spool database
做了上面4步,清理就完成了,下面第5步是定义后台任务每天定时清理。
可以再SP12中看到TEMSE中那块的数据占用的比较大
5. You should run the following reports daily:
RSPO0041 需要变式打印池清理,删除打印请求(or RSPO1041),可以采用变式
SAP&001,要注意确认的数量要大些
deletes too many spool requests without displaying it in the log
RSBTCDEL 需要变式 to delete old TemSe objects,参数方面注意一下NOTE
568690
delete scheduled jobs regularly although the entered minimum age is not yet reached
RSPO1043 (在后台进行数据一致性检查,打印相关)需要变式
Inconsistencies in spool requests should be found and deleted using RSPO0043(假脱机连续性检查,只能显示) or Transaction SPAD
RSTS0020 for the TEMSE consistency check.类似SP12 #只能显示
RSTS0030 Temse 对象检查