RE: IDX-SYSCOLUMNS too long

I saw that SYSCOLUMNS (Qsys2) view pointed on
QSYS.QADBIFLD and last week we do a reclaim sotage.

Is reclaim storage (with *dbxref) the origin of this long rebuild ?

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]De la part de Stephane Leon
Envoyé : lundi, 12. mai 2003 10:46
À : Midrange-L
Objet : IDX-SYSCOLUMNS too long


hello,

When i start odbc from sun station to as400,
a job  QRWTSRVR is running in qsyswrk sub sys.
At the beginning it re index syscolumns
This process run less the 1 or 2 mn.
We don't use this connection since months.
Friday i start the sun station and from 10 am to 6 pm
the job QRWTSRVR was running with the funcion in wrkactjob
IDX-SYSCOLUMN.

Today i start the sun station again and since 3 hours it
continue with the same job.
 QRWTSRVR     QUSER       PJ     33,3  IDX-SYSCOLUMNS   RUN

When this job will be ending ?

Any ideas ?

Thanks.