topic Re: GLPCA table indexing issue in Application Development and Automation Discussions

GLPCA table indexing issue

Former Member — Thu, 14 May 2009 21:03:52 GMT

Hi,

We have changed the index 3 on the table GLPCA and transported the same. Now we are trying the activate the index and arrange the records for the change. The job started for the same and it is continuing to run since 3 hours.

Is there a way we could know how many entries are available in GLPCA and estimate the time.

Is there a tcode in SAP that would give the number of entries in GLPCA . The option SE11 -

> Number of entries is going to dump. So we need some other option.

Regards,

Prabaharan

Moderator message - Moved to the correct forum

Edited by: Rob Burbank on May 14, 2009 5:08 PM

Re: GLPCA table indexing issue

Former Member — Thu, 14 May 2009 21:07:43 GMT

First of all - you have created and activated the index, but have you created it in the database?

Rob

Re: GLPCA table indexing issue

ThomasZloch — Thu, 14 May 2009 21:24:35 GMT

Check wether tx DB20 tells you the number of records.

Thomas

Re: GLPCA table indexing issue

Former Member — Fri, 15 May 2009 19:05:01 GMT

We created the index in SAP. We are trying to activate the same in the Database and the job is running for long.

Regards,

Prabaharan

Re: GLPCA table indexing issue

Former Member — Fri, 15 May 2009 19:08:10 GMT

Hi ,'

check the index it is using in DB05 ..

if the program in not using the right index..

try to force the index by using Index Hint..

check if the Index is not active properly and if u want to force the index in the program using index hint..

the program goes to dump..

first try to activate the index in background..through ..go to table--select the index ~~>utilites~~>datatbase utility--

-->activate and adjust data base in background...

Regards,

Prabhudas

Re: GLPCA table indexing issue

Former Member — Fri, 15 May 2009 19:12:28 GMT

Did you activate the index in SE14?? Did you update the statistics for the table after the index was created?

Rob

Edited by: Rob Burbank on May 15, 2009 3:17 PM

Re: GLPCA table indexing issue

Former Member — Fri, 16 Oct 2009 15:36:38 GMT

It was a helpful answer.