RE: [U2] UV 10.1.2 bug

2005-01-18 Thread John Jenkins
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

2005-01-18 Thread Clifton Oliver
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

2005-01-18 Thread karlp
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

2005-01-18 Thread karlp

>> 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

2005-01-18 Thread Brian Leach
> 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

2005-01-17 Thread John Jenkins
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

2005-01-17 Thread Ed Clark
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

2005-01-17 Thread karlp

> 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

2005-01-17 Thread Ed Clark
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 ?

2004-11-11 Thread Dennis Bartlett
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 ?

2004-11-11 Thread artifex7-u2uglist
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 ?

2004-11-11 Thread karlp
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 ?

2004-11-11 Thread Mats Carlid
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 ?

2004-11-11 Thread Dennis Bartlett
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 ?

2004-11-11 Thread Mats Carlid
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 ?

2004-11-10 Thread Dennis Bartlett
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 ?

2004-11-08 Thread gcanedy
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 ?

2004-11-08 Thread Bausili, Don
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 ?

2004-11-06 Thread karlp

> -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 ?

2004-11-06 Thread Michael Polak
-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 ?

2004-11-06 Thread karlp
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 ?

2004-11-06 Thread Scott Richardson
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/