Hi Dan,
I happened to read an old post of yours. I am in need of some help in
performance analysis of UV database running on AIX and tuning it. Can you
please help me?
G
Dan Fitzgerald wrote:
Look at nmon; I run it from cron, then email it to myself after midnight.
I also have bunches of
Perhaps some help...
Here is something from Rocket I just found:
http://www.rocketsoftware.com/u2/resources/media-casts/webinars/tuning-u2-on-unix.html
On Thu, Sep 15, 2011 at 9:32 AM, ggayathri ggayat...@in.ibm.com wrote:
Hi Dan,
I happened to read an old post of yours. I am in need of
Likewise, late in the day, but on UniVerse, to extract the (lowered) 2nd
value,
instead of:
TRANS('ORDERS', ORDKEY, LINES, 'X')*_; @_*1,1,2
do:
TRANS('ORDERS', ORDKEY, LINES, 'X')1,1,2
Reason:
Allows you to reference this I-descriptor from another I-descriptor
in the future.
Thanks for the info. Good to know.
On Thu, Sep 15, 2011 at 9:38 AM, Charles Stevenson stevenson.c...@gmail.com
wrote:
Likewise, late in the day, but on UniVerse, to extract the (lowered) 2nd
value,
instead of:
TRANS('ORDERS', ORDKEY, LINES, 'X')*_; @_*1,1,2
do:
TRANS('ORDERS',
On 15/09/11 14:38, Charles Stevenson wrote:
Allows you to reference this I-descriptor from another I-descriptor
in the future.
UV doesn't let you do that if there are multiple expressions
separated by semi-colons.
There is no good reason for that restriction other than internal,
Wait a minute... How do you point to the previous expression? @-1
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Thursday, September 15, 2011 9:05 AM
To: U2 Users List
Subject: Re: [U2] I-type
On the same topic, we are trying to return 5 million rows, but the select fails
at about 2 million rows.
Is there a limitation on how many rows can be returned through UniOleDB or
through the UniRPC service?
Uniiverse 10.2.4
AIX Unix 5.3
We have been using UniODBC to run our DTS jobs (to our
To expand and clarify
The first expression is 1
The second expression is 2
There are no negative values used
-Original Message-
From: Charles Stevenson stevenson.c...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thu, Sep 15, 2011 9:33 am
Subject: Re: [U2] I-type
Bob,
Here is an example.
Suppose US phone numbers stored as
123-456-7890 (area code 123)
or 123-4567 (area code 'unk'nown)
DICT ... AREA.CODE
01: I
02: PHONE; COUNT( @, '-' ); IF @ 1 THEN @1[ '-', 1, 1] ELSE 'unk'
same as
02: PHONE; COUNT( @1, '-' ); IF @2
The domain controller failed. The Backup took over.
Universe 10.3 appears to hang on login - just dead.
UniData on the same site (on another server) hangs for a moment and
'complains', but completes the login and runs correctly - so it appears that
it 'finds' the backup controller.
What's the
Local login script on Universe is doing something funky.
Try to connect using the Universe Shell application directly on the UV server
in the computer room, not locally from your PC
-Original Message-
From: David Wolverton dwolv...@flash.net
To: 'U2 Users List'
If I log into the actual server after logging in as a LOCAL user, the UV
Shell starts up.
If I log into the actual server after logging in as a DOMAIN user, the UV
Shell just hangs.
This is after MANY reboots, so I know the UniVerse services are cleanly
restarted.
-Original Message-
This is a wild guess... So my disclaimer is, Try at your own risk
Part of my hatred for Windows Active Directory resides with this very issue,
but, I digress...
I have seen servers and workstations not talk to the backup domain
controller before, especially after a primary domain controller
See, I would suspect something like this as well, but the %LOGONSERVER% is
'up', and Great Plains running on the same server as the UniVerse server is
working A-OK. (I hate the fact they have 3 different databases on this
machine, but it is illustrative that it's 'only UniVerse' as both the Great
Perhaps the Domain Controller that failed also had DNS running on it?
Perhaps its a DNS issue... you say one Unidata server takes a while and
finally logs in...
Another shot in the dark.
On Thu, Sep 15, 2011 at 1:15 PM, David Wolverton dwolv...@flash.net wrote:
See, I would suspect something
What exactly do you mean by the statement that uvshell hangs
Do you mean it opens the uvshell application but will not give you any message
at all? so its just a blank gray screen?
Or do you mean it won't even open the application window?
If you can run uvshell as a local user, can you LISTU
Correct -- the screen opens and what you would normally see next is the
UniVerse 'banner' - the cursor just blinks... Nothing.
But the 'shell screen' is 'open' and 'trying' to connect.
And for DNS -- if the other applications were 'dead' as well on the machine,
again, I'd suspect something
If you can get to TCL as a local user and cannot as a domain user, then I would
suggest a permissions setting is wrong.
Your domain user can't open some file that Universe is trying to open.
For example uvtemp or something, who knows.
The local user would most likely own all the files.
But go
Does this version of Universe pre-date the PDC emulator fix?
If not you will not be able to login to UniVerse if the database cannot
access the server with the PDC Emulator FSMO role.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
And I meant to add...
If the PDC emulator was on the other DC (which I would assume it is) and
you can't restore it you will have to seize the fsmo role.
It's pretty simple, but it's also a last resort type of a deal.
Instructions are here:
Yes - I guess that is the case -- they are not on 11.1, and just got word
that's where it's got fixed. The only choice under this release per the case
is to cease the domain controller. I think they meant 'seize' the
controller. [And I just notices that 'seize' violates the I before E rule,
by
21 matches
Mail list logo