cancel
Showing results for 
Search instead for 
Did you mean: 

DB24 - How to see the execution of statistics

Former Member
0 Kudos

SAP 4.7 6.20 Oracle 10g - Windows Server 2008

We are working in an archive project and I was told to run statistics for the table COBK.

I started transaction DB20, I wrote the name of the table, and in Menu Statistics, I started the option Create Statistics...

I received a message that the operation was started...

But when I enter in transaction DB24, in all operations and performance tabs, I don't see the process executing...

I only see some processes which were finished before the start of my db20.

It's the first time I use this transaction.

How can I check if the process is really executing ?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

In db20 enter the table COBK and do refresh. Check the date and time when last refresh ran.

The entry should be shown in db24 or you can also check in DB14 (BTW both are same).

Former Member
0 Kudos

If I refresh db20 for table COBK, I see an old date for Last Refresh Run ( October,19).

In DB24, there is nothing.

In DB14, BRCONNECT, there is nothing.

Nothing in SM66, ST22, SM21.

So maybe there are 2 options :

1) The procedure was not finished.

2) The procedure never started.

By reading my first text, did I execute the procedure correctly in DB20 ?

Former Member
0 Kudos

yes, nothing wrong in the process you have followed. If you have access to OS level, then you can also perform the same using brtools.

Former Member
0 Kudos

I was reading in Internet some possibilities...

Could I execute in sqlplus : UPDATE STATISTICS COBK WITH FULLSCAN ?

Does it have the same result of db20 ?

Eduardo

Former Member
0 Kudos

Yes should not be any problem, also you can use the brtools to update one single table stats, see help.sap.com/erp2005_ehp_04/helpdata/EN/88/fce73a86e99c77e10000000a114084/frameset.htm

Former Member
0 Kudos

In fact, I still don't know why, but db20 is not working here.

I've found some material about brtools and it has worked fine.

Thanks for your help.

Eduardo

Former Member
0 Kudos

DB20 should work, not sure whats wrong. Have you tried to execute the same in other systems?

Answers (0)