RE: [U2] UV 10.1.2 bug
Karl This sounds like an index "overload" issue - check NO.NULLS and for overloads. I have seen similar problems with extreme overload on a file with 99%+ of all the records with the same key (and yes - it was NULL). If there is stuff you do NOT want to index and it is not NULL then consider a virtual to return NULL (string) if it is not something you are interested in and use NO.NULLS. Indexes help on equalities and ranges - not on inequalities and pattern matches (unless you create virtuals and index the result of the virtual e.g. IF A matches "1N0N3A4X'.'" THEN "1" ELSE "0" (though this is a bad example with a Boolean result). Remember also that indexes should not be used with external lookups (e.g. TRANSlates) - I;m sure we've all been there one time or another - not a good idea unless the data is static (no - REALLY static). Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 18 January 2005 19:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV 10.1.2 bug Okay, tested the process against the file with no indexes. It ran in 19 minutes. it was taking hours before. I didn't save a copy of LIST.INDEX FILE ALL DETAIL but it did have some very skewed groups, as I watched it scroll by. But mostly it looked very even... I've never seen this behavior before, however, and am still perplexed. Karl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV 10.1.2 bug
I've seen this kind of thing when an index of a sparsely populated field was created without the NO.NULLS option. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ [EMAIL PROTECTED] wrote: Okay, tested the process against the file with no indexes. It ran in 19 minutes. it was taking hours before. I didn't save a copy of LIST.INDEX FILE ALL DETAIL but it did have some very skewed groups, as I watched it scroll by. But mostly it looked very even... I've never seen this behavior before, however, and am still perplexed. Karl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
Okay, tested the process against the file with no indexes. It ran in 19 minutes. it was taking hours before. I didn't save a copy of LIST.INDEX FILE ALL DETAIL but it did have some very skewed groups, as I watched it scroll by. But mostly it looked very even... I've never seen this behavior before, however, and am still perplexed. Karl > >>> Sounds like the kind of thing that would happen if the file >>> had a lot of overflow. >>> >> >> Or a very badly designed index, or trigger. >> >> Any of those possible? >> >> Brian > > We don't have any triggers on those files. There are no indexes on one of > the files and the other one has 5 indexes. Come to think of it, I've not > tested the file with no indexes because they became corrupt a few days ago > and I removed all of them and forgot to re-add them over the weekend. > > I'll have to check the process on that file again and see what happens > without the indexes. > > Karl > > >> >>> -Original Message- >>> From: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED] Behalf Of >>> [EMAIL PROTECTED] >>> Sent: Monday, January 17, 2005 12:10 PM >>> To: u2-users@listserver.u2ug.org >>> Subject: [U2] UV 10.1.2 bug >>> >>> >>> I'm seeing (another) bug in UV 10.1.2. Apparently, deleting >>> items from files is taking up to 1 second per delete when >>> done programatically, ie: >>> >>> DELETE FILE,KEY >>> >>> I'm waiting for an upgrade to 10.1.4. Has anyone else noticed >>> this problem? >>> >>> Thanks, >>> >>> -- >>> Karl L. Pearson >>> Director of IT, >>> ATS Industrial Supply >>> Direct: 801-978-4429 >>> Toll-free: 800-789-9300 1,29 >>> Fax: 801-972-3888 >>> http://www.atsindustrial.com >>> [EMAIL PROTECTED] >>> --- >>> u2-users mailing list >>> u2-users@listserver.u2ug.org >>> To unsubscribe please visit http://listserver.u2ug.org/ >>> --- >>> u2-users mailing list >>> u2-users@listserver.u2ug.org >>> To unsubscribe please visit http://listserver.u2ug.org/ >> --- >> u2-users mailing list >> u2-users@listserver.u2ug.org >> To unsubscribe please visit http://listserver.u2ug.org/ >> > > > -- > Karl L. Pearson > Director of IT, > ATS Industrial Supply > Direct: 801-978-4429 > Toll-free: 800-789-9300 1,29 > Fax: 801-972-3888 > http://www.atsindustrial.com > [EMAIL PROTECTED] > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
>> Sounds like the kind of thing that would happen if the file >> had a lot of overflow. >> > > Or a very badly designed index, or trigger. > > Any of those possible? > > Brian We don't have any triggers on those files. There are no indexes on one of the files and the other one has 5 indexes. Come to think of it, I've not tested the file with no indexes because they became corrupt a few days ago and I removed all of them and forgot to re-add them over the weekend. I'll have to check the process on that file again and see what happens without the indexes. Karl > >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] Behalf Of >> [EMAIL PROTECTED] >> Sent: Monday, January 17, 2005 12:10 PM >> To: u2-users@listserver.u2ug.org >> Subject: [U2] UV 10.1.2 bug >> >> >> I'm seeing (another) bug in UV 10.1.2. Apparently, deleting >> items from files is taking up to 1 second per delete when >> done programatically, ie: >> >> DELETE FILE,KEY >> >> I'm waiting for an upgrade to 10.1.4. Has anyone else noticed >> this problem? >> >> Thanks, >> >> -- >> Karl L. Pearson >> Director of IT, >> ATS Industrial Supply >> Direct: 801-978-4429 >> Toll-free: 800-789-9300 1,29 >> Fax: 801-972-3888 >> http://www.atsindustrial.com >> [EMAIL PROTECTED] >> --- >> u2-users mailing list >> u2-users@listserver.u2ug.org >> To unsubscribe please visit http://listserver.u2ug.org/ >> --- >> u2-users mailing list >> u2-users@listserver.u2ug.org >> To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
> Sounds like the kind of thing that would happen if the file > had a lot of overflow. > Or a very badly designed index, or trigger. Any of those possible? Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Monday, January 17, 2005 12:10 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] UV 10.1.2 bug > > > I'm seeing (another) bug in UV 10.1.2. Apparently, deleting > items from files is taking up to 1 second per delete when > done programatically, ie: > > DELETE FILE,KEY > > I'm waiting for an upgrade to 10.1.4. Has anyone else noticed > this problem? > > Thanks, > > -- > Karl L. Pearson > Director of IT, > ATS Industrial Supply > Direct: 801-978-4429 > Toll-free: 800-789-9300 1,29 > Fax: 801-972-3888 > http://www.atsindustrial.com > [EMAIL PROTECTED] > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
Definitely looks like overflow - what does an ANALYZE.FILE tell you? --- also what is the physical file structure (O.S level files and sizes). One other possibility - is there a horrendously large indexed entry (like 10's of K multivalues or similar) ? - let's take a look at LIST.INDEX ALL DETAIL. and a check on triggers wouldn't hurt either. Regards JayJay I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from files is taking up to 1 second per delete when done programatically, ie: DELETE FILE,KEY I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this problem? Thanks, -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
Could they be hashing very badly? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January 17, 2005 2:30 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV 10.1.2 bug > Sounds like the kind of thing that would happen if the file had a lot of > overflow. That's what I would have thought, too. However, I'm seeing this on files that have recently been resized to about 10% larger than current need for growth. AND they aren't that big. 30,000 items in one case; 418,000 in another. Karl > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Monday, January 17, 2005 12:10 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] UV 10.1.2 bug > > > I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from > files is taking up to 1 second per delete when done programatically, ie: > > DELETE FILE,KEY > > I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this > problem? > > Thanks, > > -- > Karl L. Pearson > Director of IT, > ATS Industrial Supply > Direct: 801-978-4429 > Toll-free: 800-789-9300 1,29 > Fax: 801-972-3888 > http://www.atsindustrial.com > [EMAIL PROTECTED] > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
> Sounds like the kind of thing that would happen if the file had a lot of > overflow. That's what I would have thought, too. However, I'm seeing this on files that have recently been resized to about 10% larger than current need for growth. AND they aren't that big. 30,000 items in one case; 418,000 in another. Karl > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Monday, January 17, 2005 12:10 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] UV 10.1.2 bug > > > I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from > files is taking up to 1 second per delete when done programatically, ie: > > DELETE FILE,KEY > > I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this > problem? > > Thanks, > > -- > Karl L. Pearson > Director of IT, > ATS Industrial Supply > Direct: 801-978-4429 > Toll-free: 800-789-9300 1,29 > Fax: 801-972-3888 > http://www.atsindustrial.com > [EMAIL PROTECTED] > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 bug
Sounds like the kind of thing that would happen if the file had a lot of overflow. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January 17, 2005 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.1.2 bug I'm seeing (another) bug in UV 10.1.2. Apparently, deleting items from files is taking up to 1 second per delete when done programatically, ie: DELETE FILE,KEY I'm waiting for an upgrade to 10.1.4. Has anyone else noticed this problem? Thanks, -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 ?
Yo Mats! The funny thing is that our system used to do that too, ie >ACCT> when we were on 10.0.x Of course, that was before we "downgraded" to 10.1.2 -Original Message- From: Mats Carlid [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 November, 2004 3:11 PM To: [EMAIL PROTECTED] Subject: Re: [U2] UV 10.1.2 ? >> And I ran a program with ASSIGN 'Hi>' TO SYSTEM(4002) >> and it orudced the expected prompt but the select prompt became >> '>Hi>' - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 ?
I've occasionally seen references in this list to UniVerse SYSTEM() function arguments for which I can't find any documentation, e.g., 4001, 4002, 1005, 9001. Can anyone point me to where I might find any documentation on SYSTEM() arguments that are not documented in the Basic Commands Reference? (I'm running UV 10.1.3 on Windows.) TIA, Steve Johnson -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: Thursday, November 11, 2004 5:11 AM To: [EMAIL PROTECTED] Subject: Re: [U2] UV 10.1.2 ? Dennis Bartlett wrote: >Hi Mats > >Our system prompt displays the full account name and not just a ">" > >eg >KO.OP> > >To do this we have a small proggie > >0001: ASSIGN 1 TO SYSTEM(4001) >0002: ASSIGN @LOGNAME:">" TO SYSTEM(4002) > >I did a test using UVPROMPT to see if it would return the >> for >selects but alas! no luck... > > > And I ran a program with ASSIGN 'Hi>' TO SYSTEM(4002) and it orudced the expected prompt but the select prompt became '>Hi>' But that's on uv10.0.smthg so that's history for you ... -- mats --- 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/
RE: [U2] UV 10.1.2 ?
Our >> disappeared after upgrading last week. I just commented out the ASSIGN . . . 4001/2 lines and now both > and >> appear as expected. However, the uvlictool issue is a show-stopper, so I'll be upgrading to 10.1.4 as soon as I can get my hands on it... Karl > Hi Mats > > Our system prompt displays the full account name and not just a ">" > > eg > KO.OP> > > To do this we have a small proggie > > 0001: ASSIGN 1 TO SYSTEM(4001) > 0002: ASSIGN @LOGNAME:">" TO SYSTEM(4002) > > I did a test using UVPROMPT to see if it would return the >> for selects > but alas! no luck... > > -Original Message- > From: Mats Carlid [mailto:[EMAIL PROTECTED] > Sent: Thursday, 11 November, 2004 10:54 AM > To: [EMAIL PROTECTED] > Subject: Re: [U2] UV 10.1.2 ? > > Did You by chance have a > > UV.PROMPT > >> ... > > in the login paragraph in the uv account ?? > > -- mats > > > > Dennis Bartlett wrote: > >>We're on AIX 5.2 UV 10.1.2... >> >>when we upgraded >> - we lost the >> one usually gets when having a select list > active ... >> - uvlictool no longer just cleans locks - it completely loses > all >>trace of logged in users >> >>The lictool thang only becomes an issue at crisis time, but the missing > >>chevrons (">>") often catch us out waiting forever for a list to >>complete when it has already done so (instead of showing >>, it merely >>has a blank line) >> >>We're seriously looking at going 10.1.4 which supposedly (do I sound >>cynical? sorry!) fixes the lictool thang... (if we can get such a beast > >>in South Africa!) >> >> >> >>[snip] >> >> >>>Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there >>>any known gotchas with this combination that I should prepare for, or >>>avoid by holding out for 10.1.4 or newer? >>> >>>Thanks, >>> >>>- -- >>>Karl L. Pearson >>> >>> >> >> >>- >>GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS >> >>Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH >>Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, > >>JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, >>Sekr/Secr: E van Niekerk. >> >>Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: >>http://www.gwk.co.za/DisclaimerVrywaring.asp >>This e-mail is subjected to the disclaimer that can be viewed at: >>http://www.gwk.co.za/DisclaimerVrywaring.asp >>--- >>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/ > > > - > GWK BEPERK/LIMITED (REG: 1997/022252/06) > POSBUS 47 PO BOX 8730 > DOUGLAS > > Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, > JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, > WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, > Sekr/Secr: E van Niekerk. > > Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: > http://www.gwk.co.za/DisclaimerVrywaring.asp > This e-mail is subjected to the disclaimer that can be viewed at: > http://www.gwk.co.za/DisclaimerVrywaring.asp > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV 10.1.2 ?
Dennis Bartlett wrote: Hi Mats Our system prompt displays the full account name and not just a ">" eg KO.OP> To do this we have a small proggie 0001: ASSIGN 1 TO SYSTEM(4001) 0002: ASSIGN @LOGNAME:">" TO SYSTEM(4002) I did a test using UVPROMPT to see if it would return the >> for selects but alas! no luck... And I ran a program with ASSIGN 'Hi>' TO SYSTEM(4002) and it orudced the expected prompt but the select prompt became '>Hi>' But that's on uv10.0.smthg so that's history for you ... -- mats --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 ?
Hi Mats Our system prompt displays the full account name and not just a ">" eg KO.OP> To do this we have a small proggie 0001: ASSIGN 1 TO SYSTEM(4001) 0002: ASSIGN @LOGNAME:">" TO SYSTEM(4002) I did a test using UVPROMPT to see if it would return the >> for selects but alas! no luck... -Original Message- From: Mats Carlid [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 November, 2004 10:54 AM To: [EMAIL PROTECTED] Subject: Re: [U2] UV 10.1.2 ? Did You by chance have a UV.PROMPT > >> ... in the login paragraph in the uv account ?? -- mats Dennis Bartlett wrote: >We're on AIX 5.2 UV 10.1.2... > >when we upgraded > - we lost the >> one usually gets when having a select list active ... > - uvlictool no longer just cleans locks - it completely loses all >trace of logged in users > >The lictool thang only becomes an issue at crisis time, but the missing >chevrons (">>") often catch us out waiting forever for a list to >complete when it has already done so (instead of showing >>, it merely >has a blank line) > >We're seriously looking at going 10.1.4 which supposedly (do I sound >cynical? sorry!) fixes the lictool thang... (if we can get such a beast >in South Africa!) > > > >[snip] > > >>Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there >>any known gotchas with this combination that I should prepare for, or >>avoid by holding out for 10.1.4 or newer? >> >>Thanks, >> >>- -- >>Karl L. Pearson >> >> > > >- >GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS > >Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH >Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, >JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, >Sekr/Secr: E van Niekerk. > >Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: >http://www.gwk.co.za/DisclaimerVrywaring.asp >This e-mail is subjected to the disclaimer that can be viewed at: >http://www.gwk.co.za/DisclaimerVrywaring.asp >--- >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/ - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV 10.1.2 ?
Did You by chance have a UV.PROMPT > >> ... in the login paragraph in the uv account ?? -- mats Dennis Bartlett wrote: We're on AIX 5.2 UV 10.1.2... when we upgraded - we lost the >> one usually gets when having a select list active ... - uvlictool no longer just cleans locks - it completely loses all trace of logged in users The lictool thang only becomes an issue at crisis time, but the missing chevrons (">>") often catch us out waiting forever for a list to complete when it has already done so (instead of showing >>, it merely has a blank line) We're seriously looking at going 10.1.4 which supposedly (do I sound cynical? sorry!) fixes the lictool thang... (if we can get such a beast in South Africa!) [snip] Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there any known gotchas with this combination that I should prepare for, or avoid by holding out for 10.1.4 or newer? Thanks, - -- Karl L. Pearson - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- 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/
RE: [U2] UV 10.1.2 ?
We're on AIX 5.2 UV 10.1.2... when we upgraded - we lost the >> one usually gets when having a select list active ... - uvlictool no longer just cleans locks - it completely loses all trace of logged in users The lictool thang only becomes an issue at crisis time, but the missing chevrons (">>") often catch us out waiting forever for a list to complete when it has already done so (instead of showing >>, it merely has a blank line) We're seriously looking at going 10.1.4 which supposedly (do I sound cynical? sorry!) fixes the lictool thang... (if we can get such a beast in South Africa!) [snip] > > Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there > any known gotchas with this combination that I should prepare for, or > avoid by holding out for 10.1.4 or newer? > > Thanks, > > - -- > Karl L. Pearson - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 ?
With ya there too. Unfortunately, we had to upgrade both at the same time. AIX from 4.3.2 to 5.2, and UV from 9.5.1.1 to 10.1.0 AIX seems stable enough so far, but we did hit a problem at 10.1 with SELECT BY of an I-Type that used IF-THEN-ELSE logic (using IF @RECORD), calling a SUBR (on the ELSE) that opened files to Common. It would abort with 'Read Operation Failure' even though the files were structurally okay. We heard of another client with something similar whose SELECT would hang. Turns out a new parameter, UVTSORT in uvconfig was the culprit (defaulting to 1 for Multi-Threaded Sorts). We set it to '0' and the problem went away. We're just realizing though that for this to work, we also need to be at release 10.1.4 (not sure about 10.1.2) which was done on our test box, still waiting to upgrade production. So far we have dodged the double-upgrade bullet. Would be interested in knowing of any other little 'gotchas' that people have run into. Gary |-+--> | | "Michael Polak"| | | <[EMAIL PROTECTED]>| | | Sent by: | | | [EMAIL PROTECTED]| | | er.u2ug.org| | | | | | | | | 11/06/2004 11:52 AM| | | Please respond to | | | u2-users | | | | |-+--> >| | | | To: <[EMAIL PROTECTED]> | | cc: | | Subject: RE: [U2] UV 10.1.2 ? | >| -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karl, We in the same boat, and looking to upgrade between Christmas and New Year. We are doing the Universe upgrade first, shaking that out for a while, then will upgrade AIX to 5.3. Lesson 1 from school or hard knocks Never do multiple upgrades at the same time unless you have to. Mike - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, November 05, 2004 4:58 PM To: [EMAIL PROTECTED] Subject: [U2] UV 10.1.2 ? Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there any known gotchas with this combination that I should prepare for, or avoid by holding out for 10.1.4 or newer? Thanks, - -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] - --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -BEGIN PGP SIGNATURE- Version: PGP 8.1 iQA/AwUBQY0BM7Ast3KQK8kYEQJuNwCeJPEw5uLXvUsM6Z4LqWKM7oaoa/4AoPCq oqgSJpExy6Pp0qA1yI9cXaio =OcWC -END PGP SIGNATURE- --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 ?
We upgraded to UV 10.1.2 while on AIX 4.3.3 and a week later upgraded to AIX 5.1 - we did not experience any problems with the AIX 4.3.3/UV 10.1.2 combination, though that's an admittedly short time. Don -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Saturday, November 06, 2004 7:58 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UV 10.1.2 ? > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > Karl, > > We in the same boat, and looking to upgrade between Christmas and New > Year. > > > We are doing the Universe upgrade first, shaking that out for a while, > then > will upgrade AIX to 5.3. > > Lesson 1 from school or hard knocks Never do multiple upgrades at the > same time unless you have to. Having worked for vars and having done literally hundreds of upgrades of both OS and DBMS, I agree whole heartedly. Let there be at least 2 weeks, after all the bugs are worked out, before doing the second upgrade. There is one major problem with this when one works for an organization that doesn't do regular upgrades: Sometimes one can't be upgraded without doing the other at the same time because of compatibility issues. Karl > > Mike > > - -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Friday, November 05, 2004 4:58 PM > To: [EMAIL PROTECTED] > Subject: [U2] UV 10.1.2 ? > > Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there any > known gotchas with this combination that I should prepare for, or avoid by > holding out for 10.1.4 or newer? > > Thanks, > > - -- > Karl L. Pearson > Director of IT, > ATS Industrial Supply > Direct: 801-978-4429 > Toll-free: 800-789-9300 1,29 > Fax: 801-972-3888 > http://www.atsindustrial.com > [EMAIL PROTECTED] > - --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > > -BEGIN PGP SIGNATURE- > Version: PGP 8.1 > > iQA/AwUBQY0BM7Ast3KQK8kYEQJuNwCeJPEw5uLXvUsM6Z4LqWKM7oaoa/4AoPCq > oqgSJpExy6Pp0qA1yI9cXaio > =OcWC > -END PGP SIGNATURE- > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ** Confidentiality: This message and any attachments are for the addressee only and may contain privileged or confidential information. If you have received this in error, please notify me immediately and permanently delete the message and any prints or other copies. Thank you. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 ?
> -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > Karl, > > We in the same boat, and looking to upgrade between Christmas and New > Year. > > > We are doing the Universe upgrade first, shaking that out for a while, > then > will upgrade AIX to 5.3. > > Lesson 1 from school or hard knocks Never do multiple upgrades at the > same time unless you have to. Having worked for vars and having done literally hundreds of upgrades of both OS and DBMS, I agree whole heartedly. Let there be at least 2 weeks, after all the bugs are worked out, before doing the second upgrade. There is one major problem with this when one works for an organization that doesn't do regular upgrades: Sometimes one can't be upgraded without doing the other at the same time because of compatibility issues. Karl > > Mike > > - -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Friday, November 05, 2004 4:58 PM > To: [EMAIL PROTECTED] > Subject: [U2] UV 10.1.2 ? > > Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there any > known gotchas with this combination that I should prepare for, or avoid by > holding out for 10.1.4 or newer? > > Thanks, > > - -- > Karl L. Pearson > Director of IT, > ATS Industrial Supply > Direct: 801-978-4429 > Toll-free: 800-789-9300 1,29 > Fax: 801-972-3888 > http://www.atsindustrial.com > [EMAIL PROTECTED] > - --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > > -BEGIN PGP SIGNATURE- > Version: PGP 8.1 > > iQA/AwUBQY0BM7Ast3KQK8kYEQJuNwCeJPEw5uLXvUsM6Z4LqWKM7oaoa/4AoPCq > oqgSJpExy6Pp0qA1yI9cXaio > =OcWC > -END PGP SIGNATURE- > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 ?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karl, We in the same boat, and looking to upgrade between Christmas and New Year. We are doing the Universe upgrade first, shaking that out for a while, then will upgrade AIX to 5.3. Lesson 1 from school or hard knocks Never do multiple upgrades at the same time unless you have to. Mike - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, November 05, 2004 4:58 PM To: [EMAIL PROTECTED] Subject: [U2] UV 10.1.2 ? Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there any known gotchas with this combination that I should prepare for, or avoid by holding out for 10.1.4 or newer? Thanks, - -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] - --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -BEGIN PGP SIGNATURE- Version: PGP 8.1 iQA/AwUBQY0BM7Ast3KQK8kYEQJuNwCeJPEw5uLXvUsM6Z4LqWKM7oaoa/4AoPCq oqgSJpExy6Pp0qA1yI9cXaio =OcWC -END PGP SIGNATURE- --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV 10.1.2 ?
I guess we are just slow to adopt new technology. Var-driven mostly. All our apps are green-screen still. > AIX 4.3.3? > Why not 5.x? > > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, November 05, 2004 4:58 PM > Subject: [U2] UV 10.1.2 ? > > >> Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there >> any >> known gotchas with this combination that I should prepare for, or avoid >> by >> holding out for 10.1.4 or newer? >> >> Thanks, >> >> -- >> Karl L. Pearson >> Director of IT, >> ATS Industrial Supply >> Direct: 801-978-4429 >> Toll-free: 800-789-9300 1,29 >> Fax: 801-972-3888 >> http://www.atsindustrial.com >> [EMAIL PROTECTED] >> --- >> 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/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV 10.1.2 ?
AIX 4.3.3? Why not 5.x? - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 05, 2004 4:58 PM Subject: [U2] UV 10.1.2 ? > Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there any > known gotchas with this combination that I should prepare for, or avoid by > holding out for 10.1.4 or newer? > > Thanks, > > -- > Karl L. Pearson > Director of IT, > ATS Industrial Supply > Direct: 801-978-4429 > Toll-free: 800-789-9300 1,29 > Fax: 801-972-3888 > http://www.atsindustrial.com > [EMAIL PROTECTED] > --- > 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/