Skip to Content
0
Former Member
Dec 17, 2013 at 04:56 PM

Runstats on one table

275 Views


I decided I wanted to run "runstats" for one object but with "HIGH" degree of SAMPLE ... which should be 100%.

Selected DBA planning Calendar->Update Stats for one SAP Object->entered table name, clicked High and Execute and then Execute Immediate

Runstats ran ok via stored proc ...

Then I double clicked SUCCESS (GReen) job in Calendar, then DSNACCMO Result (which was showing High and Execute in grey out .... now the issues

Utility Statements shows the below, what I cannot fathom out is why my sample 100 shows in the utility statements at the top, but it is not used in the actual runstats .. if you look down the utility output you see the last statements are "sample 010", I cannot for the life of me work out what SAP is doing.... has anybody seen this? It is like SAP has some other profile it is pulling in .. or am I missing something here?

thanks Leslie

Utiltity output

20131217154852 RST 10 0 RUNSTATS TABLESPACE &OBJECT.

20131217154852 RST 10 1 TABLE(ALL)

20131217154852 RST 10 2 SAMPLE(100)

20131217154852 RST 10 3 INDEX(ALL KEYCARD)

20131217154852 RST 10 4 SHRLEVEL CHANGE

20131217154852 RST 10 5 HISTORY ALL

20131217154852 RST 11 0 RUNSTATS TABLESPACE &OBJECT.

20131217154852 RST 11 1 TABLE(ALL)

20131217154852 RST 11 2 USE PROFILE

20131217154852 RST 11 3 SAMPLE(100)

20131217154852 RST 11 4 SHRLEVEL CHANGE

20131217154852 RST 15 0 RUNSTATS TABLESPACE &OBJECT.

20131217154852 RST 15 1 INDEX(ALL)

20131217154852 RST 15 2 SHRLEVEL CHANGE

20131217154852 RST 15 3 HISTORY ALL

20131217154852 RST 18 0 MODIFY STATISTICS TABLESPACE &OBJECT.

20131217154852 RST 18 1 DELETE ALL

20131217154852 RST 18 2 AGE(0000000060)

20131217154852 RST 19 0 MODIFY STATISTICS INDEX &OBJECT.

20131217154852 RST 19 1 DELETE ALL

20131217154852 RST 19 2 AGE(0000000060)

20131217154852 RST 20 0 MODIFY STATISTICS INDEXSPACE &OBJECT.

20131217154852 RST 20 1 DELETE ALL

20131217154852 RST 20 2 AGE(0000000060)

20131217154852 RST 101 0 RUNSTATS INDEX(&OBJECT.)

20131217154852 RST 101 1 SHRLEVEL CHANGE

20131217154852 RST 101 2 HISTORY ALL

20131217154852 RST 102 0 LISTDEF IX_IN_IS

20131217154852 RST 102 1 INCLUDE INDEXSPACE &OBJECT.

20131217154852 RST 102 2 RUNSTATS INDEX

20131217154852 RST 102 3 LIST IX_IN_IS

20131217154852 RST 102 4 SHRLEVEL CHANGE

20131217154852 RST 900.000 0 RUNSTATS TABLESPACE &OBJECT.

20131217154852 RST 900.000 1 PART 1 FORCEROLLUP YES

20131217154852 RST 900.000 2 TABLE(SAPR3."/BI0/SCLR_DOC_NO") SAMPLE 010

20131217154852 RST 900.000 3 COLUMN(ALL)

20131217154852 RST 900.000 4 HISTORY ALL

20131217154852 RST 900.000 5 SHRLEVEL CHANGE

Output

20131217154852 RST 0 1 1DSNU000I 351 15:48:54.92 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = BP05098602000001

20131217154852 RST 0 2 DSNU1045I 351 15:48:55.10 DSNUGTIS - PROCESSING SYSIN AS UNICODE UTF-8

20131217154852 RST 0 3 0DSNU050I 351 15:48:55.11 DSNUGUTC - RUNSTATS TABLESPACE "DSN09677"."FBI0FSCL" PART 1 FORCEROLLUP YES TABLE(

20131217154852 RST 0 4 SAPR3."/BI0/SCLR_DOC_NO") SAMPLE 10 COLUMN(ALL) HISTORY ALL SHRLEVEL CHANGE

20131217154852 RST 0 5 DSNU610I -QBP1 351 15:48:58.21 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR DSN09677.FBI0FSCL SUCCESSFUL

20131217154852 RST 0 6 DSNU610I -QBP1 351 15:48:58.27 DSNUSUPT - SYSTABSTATS CATALOG UPDATE FOR SAPR3./BI0/SCLR_DOC_NO SUCCESSFUL

20131217154852 RST 0 7 DSNU610I -QBP1 351 15:48:58.32 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR SAPR3./BI0/SCLR_DOC_NO SUCCESSFUL

20131217154852 RST 0 8 DSNU610I -QBP1 351 15:48:58.36 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR SAPR3./BI0/SCLR_DOC_NO SUCCESSFUL

20131217154852 RST 0 9 DSNU610I -QBP1 351 15:48:58.43 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR SAPR3./BI0/SCLR_DOC_NO SUCCESSFUL

20131217154852 RST 0 10 DSNU610I -QBP1 351 15:48:58.50 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR DSN09677.FBI0FSCL SUCCESSFUL

20131217154852 RST 0 11 DSNU620I -QBP1 351 15:48:58.50 DSNUSEF2 - RUNSTATS CATALOG TIMESTAMP = 2013-12-17-15.48.55.122607

20131217154852 RST 0 12 DSNU010I 351 15:48:58.50 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0

20131217154852 RST 1 1 1DSNU000I 351 15:49:07.32 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = BP05098601000001

20131217154852 RST 1 2 DSNU1045I 351 15:49:07.46 DSNUGTIS - PROCESSING SYSIN AS UNICODE UTF-8

20131217154852 RST 1 3 0DSNU050I 351 15:49:07.47 DSNUGUTC - MODIFY STATISTICS TABLESPACE "DSN09677"."FBI0FSCL" DELETE ALL AGE(60)

20131217154852 RST 1 4 DSNU1300I -QBP1 351 15:49:07.50 DSNUMSTA - MODIFY STATISTICS HAS COMPLETED SUCCESSFULLY

20131217154852 RST 1 5 DSNU010I 351 15:49:07.50 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0