Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Cleaning up INDX table

Former Member

‎2008 Dec 04 6:56 AM

0 Likes
1,753

Hello Gurus,

Is there a way to trace the origin of records created in table INDX?

Currently there are 5 million records in INDX in our production system and I'm looking for ways to cleanup this table. Most of these recs do not have anything in field 'PGMID' and I'm not sure if we can trace the source where the recs are being generated.

Also, do you think it's an acceptable approach to just delete older records in order to trim the table?

Thanks. Hope to get some suggestions & insights from you all.

Hello Gurus,

Is there a way to trace the origin of records created in table INDX?

Currently there are 5 million records in INDX in our production system and I'm looking for ways to cleanup this table. Most of these recs do not have anything in field 'PGMID' and I'm not sure if we can trace the source where the recs are being generated.

Also, do you think it's an acceptable approach to just delete older records in order to trim the table?

Thanks. Hope to get some suggestions & insights from you all.

Reply
1 REPLY 1
Read only

Former Member

‎2008 Dec 04 7:04 AM

0 Likes
979

Hi

To the best of my knowledge the records into INDX table are inserted when we use KEY words like SET PARAMETER GET PARAMETER of IMPORT EXPORT

this might be the origin

regarding the clean up let us look forward for the experts guidence

regards

Ramchander Rao.K