SAP Knowledge Base Article - Preview

2506196 - DB6: SQL20288N error in Runstat_All job

Symptom

You schedule the 'RUNSTATS and REORGCHK for all tables' job in DBA Planning Calendar.
You find the following error:

Runstat_All:
SQL statement runstats on table SYSIBM."SYN171287110559682605_/BIC/EABCDEF001" on all columns
with distribution and unsampled detailed indexes all allow write access set profile none failed with SQL error 20288

SQL20288N  Statistics could not be updated for the object.
Object name: "SYN171287110559682605_/BIC/EABCDEF001".
Object type: "ASM TABLE".
Reason code: "1".


Read more...

Environment

SAP on IBM DB2 for Linux, UNIX, and Windows
Database version is 10.5 or higher

Keywords

SQL20288N, 20288, Runstat_All, runstats , KBA , sql20288n , BC-DB-DB6-CCM , CCMS/Database Monitors , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.