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)
delete in        -> 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 对象检查

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。