Re: 7.22 onstat -u flags
On Wed, 12 Mar 1997, Allen W. Jantzen wrote:
} Well, I finally moved my production db to 7.22 from 5.03. After
} (finally) remembering to do an UPDATE STATISTICS and tuning
} the parameters, things seem OK, but a bit slower than ver 5..
}
} My question: the onstat -u output has a "Y" in the first slot of the
} flags column for _all_ my client processes almost all the time.
}
} The doc just says that a "Y" means that the process is waiting on a
} condition. What condition????
}
} Does it mean waiting in the sense that it is being held up by
} something, or waiting in the sense that it is idle and has nothing to
} do??
}
} It is normal to see all these all these "Y"'s in the first flag slot??
} Or should this slot be empty most of the time??
My observation is that for processes not owned by user informix,
the Y flag is almost always on. When it isn't the user is in the midst
of a search that is ongoing. The others are in 4ge programs which
are not executing any SQL at the time.
Hope this helps
--
Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523,
USofA; 970-491-1244 FAX 970-491-4100 cwoodall@vth1.vth.colostate.edu
"There is no 'maybe' in Boolean algebra."
--
}
} Any help appreciated.
} A perplexed DBA
}
} Please reply to allenj@ndr.com
}