SAP Knowledge Base Article - Preview

2004659 - REORGCK_ALL fails due to missing authorizatios for SAP<SID>

Symptom

  • REORGCHK_ALL job fails with a similar exception from the REORGCHK job log file:

    "Job started
    Step 001 started (program RSDBAJOB, variant &0000000000002, user ID YCF)Reorgck_All:REORGCHK for all Tables
    Object : Method call GET_SNAPSHOT failed with return code = ADBC error
    Reorgck_All:REORGCHK failed."
  • SM21 log reports the error "SQL0551N "SAP<SID>" does not have the required authorization or privilege to perform operation "........" on object "SYSTOOLSTMPSPACE" when the job is scheduled".


Read more...

Environment

DB2 databases for Linux, Unix and Windows

Product

SAP NetWeaver 7.0

Keywords

 SYSTOOLSTMPSPACE, SQL0551N , KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.