Re: onstat -g ses

dalink@west.com wrote: > > I have been building an index on an integer field for the 36 hrs on a > table with 63 million row which is fragmented round robin on 28 > fragments. The index is fragmented by expression on 28 dbspaces by > expression mod(acct_num,28) = 0.... > > I am trying to monitor its progress and have been using onstat -g ses > <sessid> but I can't find any documentation on the thread names and > status. I see psortpro threads occasionally. I am running Online version > 7.22 UC2 on 8 processor AIX system with 1 gig of RAM. Any and all help is > appreciated. Try xtree - it's a motif graphical representation of what's going on. Also, look at PSORT_NPROCS environment variable. Controls number of sort threads, and can really speed things up. -- Vic Goldberg Manager, Database Administration Team Cornell Information Technologies (607) 254-7441 (voice) (607) 255-6982 (fax)