Well, that's what I like about this list. You learn something new every day. After seeing Ray's post (he is exactly right) I tested this circumstance with a modulo 1 file, and yes it happens as described. You cannot readu or write a record in the affected group because of the group lock asserted by the LIST command. Weird. I had never heard of nor seen this before. Obviously that's why the PAKTIME parameter was introduced...
Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Thursday, November 11, 2004 12:25 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Universe SHOW Command and Group Locks If you're part way through a group with a LIST (or other query, including SHOW) a group latch is held indicating that it's not desirable for the group to be updated. This can be important if the group is heavily overflowed. After a certain amount of time (configured by the PAKTIME tuneable - PAK stands for "press any key"), the group latch is released. You can ameliorate your situation by reducting PAKTIME from its default of five minutes to, say, one or two minutes, which should be long enough for most folks to inspect a screen full of information. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
