SAP Knowledge Base Article - Preview

1998529 - SQL0727N, SQL0104N errors involving SYSTOOLS.ADMIN and SYSIBM.SYSDUMMY1

Symptom

  • SQL0727N sql errors show up in the developer traces or the system log linked to SYSTOOLS.ADMIN procedures (such as SYSTOOLS.ADMIN_TASK_STATUS or SYSTOOLS.ADMIN_TASK_LIST):
  • SQL0727N  An error occurred during implicit action type "3"
  • SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "DB2<SID>". Operation: "SELECT". Object: "SYSTOOLS.ADMINTASKS".
  • SQL0104N An unexpected token "." was found following "FROM SYSIBM". Expected tokens may include: "FROM"
 


Read more...

Environment

Db2 LUW 9.5, 9.7, 10.1, 10.5, 11.1, 11.5

Product

SAP Solution Manager 7.1

Keywords

SYSTOOLS.ADMINTASKS  SYSTOOLS.ADIMINTASKSTATUS  implicit, DBAcockpit, system copy, refresh, db6adm, sap connect,

MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view SYSTOOLS.ADMIN_TASK_STATUS
, KBA , BC-DB-DB6-DBA , Database Administration , 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.