AIX 5.3 Universe 10.2.4 300+ user license
Moved from older aix/universe 9.5 to current one in September 2008.
No index problems.
File contains 1.5 million records. key = company number * customer
number.xx.invoicenumber.invoicesubnumber.
so the key looks like
01*123456.IN.1123.2
For starters I'd try INVOICE = FIELD(@ID,'.',3,2)
ro...@optonline.net wrote:
AIX 5.3 Universe 10.2.4 300+ user license
Moved from older aix/universe 9.5 to current one in September 2008.
No index problems.
File contains 1.5 million records. key = company number * customer
Good day everyone!
I have a customer running U2 on W2K.
They are licensed for 29 users. They cannot log in because it is acting like
it's at the limit. If I do a LISTU, it shows 15 users logged in. If I run
the USERS command (or CRT SYSTEM(35)), it says there are 29 users logged in.
This
Try LIST FILE REQUIRE.INDEX WITH INVOICE EQ 1000123.2
The REQUIRE.INDEX sometimes throws an error message when there's a
problem that wouldn't otherwise be shown... although my experience is
with unidata, not universe.
Also your dict item has a couple of typos I think, it's a retype rather
than
We have had this problem here with users having multiple open sessions.
We are on HP-Ux with UniVerse.
--Bill
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
bpa...@serta.com
Sent: Wednesday, March 04, 2009 1:04 PM
To:
Shouldn't dictionary #2
Be FIELD(FIELD(@ID,'*',2),'.',3,2)
Instead of
FIELD(FIELD(@ID,'*',3),'.',2.2)
This will return
1123.2
Don't know why some selects worked.
Regards,
Kishor Parmar
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
On Universe
Try uvlictool clean_lic
Regards,
Kishor Parmar
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of bpa...@serta.com
Sent: 04 March 2009 18:04
To: u2-users@listserver.u2ug.org
Subject: [U2] User count not correct
Do you have anyone using ODBC on the database? I don't recall if it shows up
in a LISTU.
Drew
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of bpa...@serta.com
Sent: Wednesday, March 04, 2009 1:04 PM
To:
We run an IBM P570 with 12 processors running Universe 10.2.4, average of 400
users against at EMC DMX4500 disk array. 20 file systems with each about
45gb, 60-80% utilized striped across 94 disks.
We do tons of batch processing at night and our rate of data change is about
175GB an hour at
Yes, I was retyping, rather then cut and paste.
Actual ids are co*custno*type.invoicemain.invoicesub
Key INVOICE
01*165001*IN.0499906608.1 0499906608.1
dictionary = 0002: FIELD(FIELD(@ID,'*',3),'.',2,2)
old dictionary = 0002:
Is anyone else receiving 5 copies of each mail sent to the u2-users list ?
Last week I was only receiving 3 copies of each mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
If you haven't already, you might want to take a look at the topas command.
It'll give you an overall view of what's going on with the system, including
per/processor utilization, per/process information, and disk utilization
information. The h key while in the program provides a bit more
Roger,
Did you make sure all users and processes (phantoms too) were logged off
*before* you rebuilt the index?
Any user/process with that open file will continue to update using old
parameters until the file is re-opened after the re-index build.
That is the only time I've seen a difference in
No. I've only been getting 1 each.
-Original Message-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of Jacques G.
Sent: Wednesday, March 04, 2009 2:27 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Multiple email copies
Is
Roger,
Two possibilities occur to me:-
* How big is that Index file - it's not getting close to 2GB by any
chance?
* Maybe it's getting confused between numbers and strings somehow: would
something that works like SELECT FILE WITH :INVOICE EQ
0499906608.1 [You could make a new I-Type called
In addition to topas, IBM offers a monitoring tool called nmon, which is
downloadable off their site (somewhere). I find that I use the two in
combination with each other, depending on what I'm looking for.
Brian
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
No. There are no complicated users or processes. They're all straight UV
Telnet sessions.
Another reboot of the server resolved the issue, but now I'm curious if
anyone knows where the current count of users is stored - and if there's any
way to clean it up without having to go through a
ericro wrote:
snip
Does anyone have any tools, or know of any tools, similar to Oracle, that
can really give me insight into what's happening with a given user session
at any time? I know I can do port.status and find the address in the code
and see what's being executed at that time, but I
Yes top or topas is good for this as well as vmstat and the sar suite - what
you need to identify from each of these is where the bottleneck is - is it
that your cpu time is in wait on io ? if so you have a fileio issue which
could be lots of dynamic files splitting or lots of secondary overflow
Me too - just 1 copy.
Nancy Fisher
Peninsula Truck Lines, Inc
Auburn, Washington
253/929-2040
Visit our Website www.peninsulatruck.com
nan...@peninsulatruck.com
- Original Message -
From: George Gallen ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Sent: Wednesday, March 04,
We use topas, but do you have any techniques for analyzing individual user
sessions to understand what's going on within Universe/the OS/the disk?
Thanks.
Drew Henderson-2 wrote:
If you haven't already, you might want to take a look at the topas
command. It'll give you an overall view of
Of course, there are a lot of things to look at.
I think what you're looking for is svmon -U username. This will show you the
user's memory map. Svmon with no arguments shows you overall stats; one
thing to look for there is that there should be no pinned memory for UV;
Oracle needs pinned
M !
I am receiving 5 copies of each mail sent to the u2-users
list ? Last week I was only receiving 3 copies of each mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
In a prior release 10.0 or earlier, I encountered a problem that could
corrupt an index if a write was issued without an explicit readu preceding
it. I don't think IBM ever corrected that because writing without
explicitly locking is Bad Form.
If I remember, when process A holds a lock on a
From the UV account, go to DOS and cd to bin, then 'uvlictool clean_lic
-a'. That will reset them. Uvlictool by itself will show you what UV
thinks is currently active.
Mike Randall, MCP
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
What happens if a UV process shells out executes a shell script that, in
turn, invokes uv?
I don't think it increments the user count, but I'm not sure. I do know it
stomps all over the parent uv's printer segment, so it's generally not a
good idea.
And, yes, look up uvlictool. there are
Uvlictool shows the same number of licenses in use, while the ps command
shows multiple uv processes.
Drew
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Wednesday, March 04, 2009 4:40 PM
To:
Oh; you can also get a huge amount of nearly real-time info using truss -p
pid, but you need to speak systemCallese to understand it all.
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of ericro
Sent: Wednesday, March 04,
Straws readily accepted.
that index file is 'only' 127,590,400 bytes.
And the selects usually go SELECT FILE WITH INVOICE EQ 100016.2.
Really odd duck.
LIST FILE WITH INVOICE EQ 509010016.20 INVOICE BY INVOICE
FILEINV
01*261318*IN.509010016.20
Current problem.
when selecting for another item, i get 2, one of which is the 'unselected'
record that we have been looking for.
BEEN USING
SELECT FILE WITH INVOICE EQ 509010016.2 and get zero when no using NO.INDEX
if I switch to another invoice number
ED FILE.INDEX 509010016.20
3 lines long.
Sounds like a good start. I'm also wondering how the Universe config is
playing into things.
There are some parameters we've never changed, i.e. the scratch buffer
stuff, and others we have such as the lock parameters. We haven't changed
any of these in some time, but I'm wondering if we're
Yes, I still receiving multiple copies... :(
---
Diego
- Original Message
From: George Gallen ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
Sent: Wednesday, March 4, 2009 2:06:45 PM
Subject: RE: [U2] Multiple email copies
No. I've only
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of ericro
Sent: Wednesday, March 04, 2009 12:37 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Performance monitoring
We use topas, but do you have any
33 matches
Mail list logo
