Re: UV Crash on W2K3

[FFT2001]

In a message dated 4/16/2004 3:38:16 PM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> 1.is this a problem with PROCS - does anyone else run a UniVerse system
> on NT which relies on PROCS to launch several layers of programs?

Sara can you explain this more? Perhaps with an example of exactly what you 
mean?
Thanks
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Database decoupling (Was: Future of U2)

[Dawn M. Wolthuis]

I wouldn't consider using 1NF data for new web services efforts if you don't
have to -- why to mess around with mapping to and from flat tables?  U2 is
still old technology but in some ways it is closer to new technology than
the brittle RDBMS solutions that are fading (maybe not fast, but SQL is now
in the bucket with COBOL -- lots of it out there so it isn't going away, but
not where I would put any new dollars).  --dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Daly, Mark
Sent: Friday, April 16, 2004 12:10 PM
To: 'U2 Users Discussion List'
Subject: RE: Database decoupling (Was: Future of U2)

Well no, not really. I was thinking more in the line of "New application
development that would like to provide the ability to utilize modern
Internet protocols". A web presence would be included in that - but was
actually furthest from my mind.

B2B interaction for example. Or even internal application integration. Being
able to publish web services etc. etc.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 16, 2004 11:28 AM
To: [EMAIL PROTECTED]
Subject: Re: Database decoupling (Was: Future of U2)


In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> Without this ability, I see no reason why anyone would commence new 
> application development on the U2 platform. Since you will always 
> require another application server (Websphere, Tomcat, Bea, Jboss, 
> etc.) to talk to the U2 server, that would in-turn interact with the 
> database.
> 

I'm sure Mark you mean "New application development that must have a web 
presence".  Unless you feel that all application development must have a web

presence.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: PI Open is going away

[Bruce Nichol]

At 23:18 16/04/04, you wrote:

> Funny that... I was only thinking the other day that I should throw
>  out my ICL 1900 COBOL and PLAN Manuals!!! :-)
Don;t start me on that nostalgia!  I was an operating system developer with
ICL all those years ago.
Ah! Another Leo, eh??

Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


--
Incoming mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 262.8.3 - Release Date: 15/04/04
Regards,

Bruce Nichol
Talon Computer Services
ALBURYNSW 2640
Australia
Tel: +61 (0)411149636
Fax: +61 (0)260232119
If it ain't broke, fix it till it is! 

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 262.8.3 - Release Date: 15/04/04
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: PI Open is going away

[Bruce Nichol]

Goo'day, Martin,

At 18:53 16/04/04, you wrote:

I was one of the two technical managers for the development of PI/open.
It's always sad watching a product that you worked on be put into
retirement.
Perhaps I can now throw out my collection of PI/open manuals.
And stop telling QM users "That's how it's done in PI/open, so that's how 
we're doing it here!!!" ???   ~8^))


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


--
Incoming mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 262.8.3 - Release Date: 15/04/04
Regards,

Bruce Nichol
Talon Computer Services
ALBURYNSW 2640
Australia
Tel: +61 (0)411149636
Fax: +61 (0)260232119
If it ain't broke, fix it till it is! 

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 262.8.3 - Release Date: 15/04/04
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Crystal Reports

[djordan]

Take the Lead

If they have SQL Server already, build a mini datawarehouse that you
populate Daily, and then set up the new Report Services of SQL Server
which is a free add on to SQL Server 2000.  In somes ways it has some
better features than Crystal reports.   It gives your system a fresh
face for little work and will keep the MV system in the organisation.

Crystal Reports is a good tool, but when it comes to complex reports, I
can quicker write a Basic Program to achieve the result than a good
Crystal Reports programmer will achieve the results.  The big thing for
you is the user just wants to feel in control of data access and this
can be achieved in a number of ways even if it is a perception.

Regards

David Jordan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Mark Johnson
Sent: Saturday, 17 April 2004 4:51 AM
To: U2 Users Discussion List
Subject: Crystal Reports


One of my clients wants to connect Crystal Reports to their UD database
to apparently give greater access to the data that they sometimes deem
as hidden and only accessable through me.

This client converted to Great Plains 6 weeks ago (SQL based) and their
CR experts were struggling with duplicating some of the more mundane
reports that already exist in UD. A monthly sales tax summary (by
jurisdiction) took the GP guy 3 days futzing with CR using GP's data.

How much trouble are they going to get in trying to use MV'd data from
the UD system (ODBC) if they have so much trouble with more 'normalized'
data. Everyone seems to think that CR is a magic pill and once attached
to a SQL database, the sophisticated reports simply roll off.

I'm trying to strongly propose a data warehouse concept whereby the
day's sales data gets exported and updated into their prior application
for the sake of the multitude of existing, proven reports in MV. If
these guys took 3 days for a simple tax report, how can CR fabricate
temporary tables for the sake of these consolidated sophisticated MV
reports?

I'm just interested in hearing of some experiences. This client is too
stubborn to go back from GP and may even disregard their entire MV
system completely. I really have nothing to lose if I insult them. 

Thanks in advance.

-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Performance Degraded running u10.0.0 in Aix 5.2 ML 2

[Sara Burns]

We upgraded UniVerse 10.0.11 from AIX 4.3.3 to AIX 5.2 last October.  We
also run Oracle and Vantive on the same box.  One thing we have found is
that we need to have at least twice the amount of Paging Space as real
memory.  If the free Paging Space gets down to zero the machine dies a
horrible death.
 
As I understand it with AIX the data is first written to the Paging Space
then to memory - rather unusual.  So if your Paging Space is low then you
may be doing a lot of swapping out to somewhere else.  After the upgrade we
noticed that the batch processes were faster but we did notice a degradation
in the user interface for Oracle / Vantive although not noticeable with
UniVerse.
 
When you run topas check to see if there are any processes consuming large
amounts of cpu constantly.  One of our non-UniVerse applications suffers
from run-aways and we see them consuming one cpu each constantly.
Fortunately we have 4 cpus so can live with these run-aways (as we cannot
remove them without dropping multiple users in critical applications).  If
you get more run-aways AIX will drop their priority so this will become less
obvious - but it will affect all users of the machine.
 
It is not common to have UniVerse run-aways but we have seen it
infrequently.  If you see a process consuming high cpu look at it in
PORT.STATUS to see what it is doing.  Check you are not using PORT.STATUS
for any utilities that run often.  This can have a major effect on the
performance of the machine.  Also topas has an effect as well.
 
We are not running any ML patches on our production machine as neither ML1
nor ML2 are compatible with one of our other applications - the one that
runs away.  
Generally we are very pleased with the performance on AIX - only management
wants us to move from this platform.
 
Our approx specs are p660, 4 cpu, 6Gb RAM, 12Gb Paging Space
Universe 10.0.11, 320 users
Oracle 9.2 - usually about 600 oracle processes
Vantive 9 - 100 processes each with up to 5 threads
 
Sara Burns
 
Sara Burns (SEB) 
Development Team Leader

Public Trust 
Phone: +64 (04) 474-3841 (DDI) 

Mobile: 027 457 5974
<  mailto:[EMAIL PROTECTED]>

Information contained in this communication is confidential. If you are not
the intended recipient the information should not be used, disclosed, copied
or commercialised. The information is not necessarily the views nor the
official communication of Public Trust. No guarantee or representation is
made that the communication is free of errors, virus or interference.

 
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UV Crash on W2K3

[Sara Burns]

This is our first attempt at running our application on a Windows platform.
Previously we have run on UniData on Sequent then converted to UniVerse on
Sequent.  Currently running UniVerse on AIX 5.2.  The conversion from
Sequent to AIX required the Little / Big Endian swap and going back to Intel
requires that swap again.  We believe we have done that and to prove it have
run uvbackup over all files and recompiled all the programs.
 
I am beginning to think this may not be W2K3 as late yesterday we copied our
files to my old NT4 (SP6a) workstation and installed the UV 10.0.10 PE
version.  This gave the same results.
 
I have two thoughts - 
1.is this a problem with PROCS - does anyone else run a UniVerse system
on NT which relies on PROCS to launch several layers of programs?
2.our application is riddled with calls to the shell.  We have created
an item in the VOC to convert sh -c to DOS /c  -  might this be causing
problems.  We know there is a lot of work to convert all those shell
commands, but we just expected them to fail - not to cause wholesale
corruption.  On the original PDC version we installed the Unix for Windows
Service and things seemed to be working reasonably well.  Prior to that when
a shell script was found it would just freeze.
 
I believe we are seeing corruption of the session workspace.  This is
demonstrated by the loss of the correct @ACCOUNT or @LOGNAME and we have
also seen what appeared to still be a healthy session suddenly unable to
find a program in the VOC although it had been running it only minutes
before.  Simply recataloging the program made it available again. 
 
My biggest problem is - how do I get evidence to trace what is happening as
it is random.  
 
Any thoughts would be appreciated.  I get the digest so direct emails to me
at this address or [EMAIL PROTECTED] 
would be appreciated
Sara Burns
 
Sara Burns (SEB) 
Development Team Leader

Public Trust 
Phone: +64 (04) 474-3841 (DDI) 

Mobile: 027 457 5974
<  mailto:[EMAIL PROTECTED]>

Information contained in this communication is confidential. If you are not
the intended recipient the information should not be used, disclosed, copied
or commercialised. The information is not necessarily the views nor the
official communication of Public Trust. No guarantee or representation is
made that the communication is free of errors, virus or interference.

 
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Crystal Reports

[Tony Gravagno]

Mark, it's interesting to see this project unfold, please do keep us up on
events there.

(Ready for some acronym soup?)  Crystal Reports is heavily tied to .NET
these days.  Microsoft has selected CR for integration with Great Plains, so
there is a high level of commitment to the CR/GP/.NET links.  It shouldn't
be a problem to create a middle-tier which interfaces data from both GP and
UD into CR via ADO.NET.ADO.NET is _not_ ADO, which was basically
supposed to be an upgrade to ODBC.  In addition to other things, ADO.NET is
really a data hub which allows you to create a source-independent set of
tables and relations.  The end result is that CR doesn't know or care where
the data is coming from, it comes from an ADO.NET data model.  How you get
the data into ADO.NET is up to you.

My recommendation is to take a look at the Pick Data Provider .NET from
Raining Data, another product which has endorsement from Microsoft.  Pricing
is very reasonable, it's stable, well documented and supported.  Since there
are questions about other interfaces working with U2 from .NET, like RBO's,
UniObjects, UniODBC, etc, it seems reasonable to choose a connectivity
module that was written for the purpose.  Using technology that is endorsed
by Microsoft from end to end should give you some political leverage as
well, since that seems to be a priority with management there.

[Ad] Here at Nebula R&D, we can prototype a report on a T&M basis, even
going all the way back and forth between GP, MV, and CR.  I honestly have no
idea how long it would take without looking at this closer, but the tools
are available, we have everything here, it's just a matter of connecting the
dots.  (Nebula R&D is an authorized Raining Data reseller and MSDN Universal
Developer.)  If you'd like to contract for more specific work, we now have
highly qualified people available to do this sort of work (MS MVP/MSDE
trainer/developers), and we'll be happy to take a back seat and let you get
the glory as projects are completed.

Good luck.
Tony
[EMAIL PROTECTED]
949-380-1668


>-Original Message-
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
>Sent: Friday, April 16, 2004 11:51 AM
>To: U2 Users Discussion List
>Subject: Crystal Reports
>
>
>One of my clients wants to connect Crystal Reports to their UD 
>database to apparently give greater access to the data that 
>they sometimes deem as hidden and only accessable through me.
>
>This client converted to Great Plains 6 weeks ago (SQL based) 
>and their CR experts were struggling with duplicating some of 
>the more mundane reports that already exist in UD. A monthly 
>sales tax summary (by jurisdiction) took the GP guy 3 days 
>futzing with CR using GP's data.
>
>How much trouble are they going to get in trying to use MV'd 
>data from the UD system (ODBC) if they have so much trouble 
>with more 'normalized' data. Everyone seems to think that CR 
>is a magic pill and once attached to a SQL database, the 
>sophisticated reports simply roll off.
>
>I'm trying to strongly propose a data warehouse concept 
>whereby the day's sales data gets exported and updated into 
>their prior application for the sake of the multitude of 
>existing, proven reports in MV. If these guys took 3 days for 
>a simple tax report, how can CR fabricate temporary tables for 
>the sake of these consolidated sophisticated MV reports?
>
>I'm just interested in hearing of some experiences. This 
>client is too stubborn to go back from GP and may even 
>disregard their entire MV system completely. I really have 
>nothing to lose if I insult them. 
>
>Thanks in advance.
>
>-- 
>u2-users mailing list
>[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
>

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Crystal Reports

[alfkec]

We spent a fair bit of time building our schema so that the data appears to
be in 1nf for Crystal to understand it. We've made some reports out of it
that are pretty impressive and would have required a number of basic
routines and some "work" files to create.

They will be able to get the reports out of Crystal. Perhaps you need
different experts. Depending on how much work it is to import the data back
into UD that may be a very good (but likely interim) fix. It would allow
them to get the reports they are used to relatively quickly and allow them
time to build the reports in Crystal using the "live" data. remind them over
how long you've been building and tweaking those reports and they may start
to understand that it will take a while to get them done in Crystal.

The one thing that you can do with the ODBC "view" is build a lot of
"virtual" dicts. For example you can have a "CLIENT_NAME" field in your
INVOICE table that actually pulls the name using the CLIENT_ID from the
CLIENT file so you don't need to setup the joins for the report. 

Good luck
-- 
Colin Alfke
Calgary, Alberta Canada

"Just because something isn't broken doesn't mean that you can't fix it"

Stu Pickles


>-Original Message-
>From: Mark Johnson [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 16, 2004 12:51 PM
>To: U2 Users Discussion List
>Subject: Crystal Reports
>
>
>One of my clients wants to connect Crystal Reports to their UD 
>database to apparently give greater access to the data that 
>they sometimes deem as hidden and only accessable through me.
>
>This client converted to Great Plains 6 weeks ago (SQL based) 
>and their CR experts were struggling with duplicating some of 
>the more mundane reports that already exist in UD. A monthly 
>sales tax summary (by jurisdiction) took the GP guy 3 days 
>futzing with CR using GP's data.
>
>How much trouble are they going to get in trying to use MV'd 
>data from the UD system (ODBC) if they have so much trouble 
>with more 'normalized' data. Everyone seems to think that CR 
>is a magic pill and once attached to a SQL database, the 
>sophisticated reports simply roll off.
>
>I'm trying to strongly propose a data warehouse concept 
>whereby the day's sales data gets exported and updated into 
>their prior application for the sake of the multitude of 
>existing, proven reports in MV. If these guys took 3 days for 
>a simple tax report, how can CR fabricate temporary tables for 
>the sake of these consolidated sophisticated MV reports?
>
>I'm just interested in hearing of some experiences. This 
>client is too stubborn to go back from GP and may even 
>disregard their entire MV system completely. I really have 
>nothing to lose if I insult them. 
>
>Thanks in advance.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Crystal Reports

[Mike Randall]

Crystal is indeed a very fine product.  It is a banded report writer with a
multitude of programmability.   Multivalued data is indeed a pain in the
neck.   Normalize the data 1st and you'll find Crystal a joy to use with
output, features and polish that MV can't come close to.  The 'problems'
that your users are facing can be addressed with Crystal code (VB syntax or
Crystal's scripting syntax).  After using it a while, you'll never want to
go back...

Mike R. 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mark Johnson
Sent: Friday, April 16, 2004 2:51 PM
To: U2 Users Discussion List
Subject: Crystal Reports

One of my clients wants to connect Crystal Reports to their UD database to
apparently give greater access to the data that they sometimes deem as
hidden and only accessable through me.

This client converted to Great Plains 6 weeks ago (SQL based) and their CR
experts were struggling with duplicating some of the more mundane reports
that already exist in UD. A monthly sales tax summary (by jurisdiction) took
the GP guy 3 days futzing with CR using GP's data.

How much trouble are they going to get in trying to use MV'd data from the
UD system (ODBC) if they have so much trouble with more 'normalized' data.
Everyone seems to think that CR is a magic pill and once attached to a SQL
database, the sophisticated reports simply roll off.

I'm trying to strongly propose a data warehouse concept whereby the day's
sales data gets exported and updated into their prior application for the
sake of the multitude of existing, proven reports in MV. If these guys took
3 days for a simple tax report, how can CR fabricate temporary tables for
the sake of these consolidated sophisticated MV reports?

I'm just interested in hearing of some experiences. This client is too
stubborn to go back from GP and may even disregard their entire MV system
completely. I really have nothing to lose if I insult them. 

Thanks in advance.

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UV to Text Conversion Standard?

[alfkec]

I've done lots of tables in UniData with VM levels of data. We only have a
couple of files that have SVM level data - a co-worker of mine set at least
one up that was working with Crystal reports.

For the multi-values it simply keeps the information that it needs to access
it as part of the primary key. I would think that it simply does the same
with subvalues.

You just appear to have a lot more tables and some of them have some pretty
funky primary keys. 

hth
-- 
Colin Alfke
Calgary, Alberta Canada

"Just because something isn't broken doesn't mean that you can't fix it"

Stu Pickles


>-Original Message-
>From: Geoffrey Mitchell [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 16, 2004 12:06 PM
>To: U2 Users Discussion List
>Subject: Re: UV to Text Conversion Standard?
>
>
>To my knowledge, no.  Not in Universe anyway.  I *think* (from 
>the docs,
>I've never played with it) that UniData has a way to map sub-values to
>ODBC/JDBC, but UniVerse does not.  Multivalues work fine, but 
>it doesn't
>go any lower than that.
>
>Best answer: don't use sub-values.  They're evil, anyway.
>
>On Fri, 2004-04-16 at 12:48, [EMAIL PROTECTED] wrote:
>
>> Thank you, but what is the exact method to do this?
>> I have never seen a "view of SVM level data" that actually works.
>> Using ODBC or any other tool
>> And by "works" I mean that it understands the relationship 
>of the SVM data to the VM data and the relationship of that to 
>the AM data and properly processes table-in-a-table 
>configurations for editing, etc.
>> 
>> It's one thing to use BY-EXP to understand VM level tables, 
>but can you really use some tool to understand SVM embedded 
>data at that second table level?
>> Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: PI Open is going away

[Randy Styka]

>how many people on the list are still using PI Open. Anyone care to
>sound off?

We have two customers on PI/Open, both on EXL325 boxes.  Both are
migrating away and will be off within a year (except that they
both told me that they'd be off each of the last three years).

Randy

+-+
| Computronics   Randy Styka, [EMAIL PROTECTED] |
| 4N165 Wood Dale Road   Phone:  630/941-7767 |
| Addison, Illinois  60101 USA   Fax:630/941-7714 |
+-+
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Crystal Reports

[Mark Johnson]

One of my clients wants to connect Crystal Reports to their UD database to apparently 
give greater access to the data that they sometimes deem as hidden and only accessable 
through me.

This client converted to Great Plains 6 weeks ago (SQL based) and their CR experts 
were struggling with duplicating some of the more mundane reports that already exist 
in UD. A monthly sales tax summary (by jurisdiction) took the GP guy 3 days futzing 
with CR using GP's data.

How much trouble are they going to get in trying to use MV'd data from the UD system 
(ODBC) if they have so much trouble with more 'normalized' data. Everyone seems to 
think that CR is a magic pill and once attached to a SQL database, the sophisticated 
reports simply roll off.

I'm trying to strongly propose a data warehouse concept whereby the day's sales data 
gets exported and updated into their prior application for the sake of the multitude 
of existing, proven reports in MV. If these guys took 3 days for a simple tax report, 
how can CR fabricate temporary tables for the sake of these consolidated sophisticated 
MV reports?

I'm just interested in hearing of some experiences. This client is too stubborn to go 
back from GP and may even disregard their entire MV system completely. I really have 
nothing to lose if I insult them. 

Thanks in advance.

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: PI Open is going away

[Lance J. Andersen]

Like when PI 5.4 was supposed to come out with Relational features and 
then we backed them out of the release?



Results wrote:

PI/Open-ers,
   I'd like to write a 'memorial' article for Database Trends 
acknowledging the PI and Prime contributions to the community as a 
whole. Would a few of you be willing to write up some brief paragraphs 
on things like:
   "So I said to Mike, we'll call them "I Descriptors" and he said it 
would never catch on..."

   In other words, I'd like to collect some personal stories about how 
these functions came about. If I get enough (and enough variety) I'll 
present it to my editors. Contributions to: [EMAIL PROTECTED]

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: PI Open is going away

[Results]

PI/Open-ers,
   I'd like to write a 'memorial' article for Database Trends 
acknowledging the PI and Prime contributions to the community as a 
whole. Would a few of you be willing to write up some brief paragraphs 
on things like:
   "So I said to Mike, we'll call them "I Descriptors" and he said it 
would never catch on..."

   In other words, I'd like to collect some personal stories about how 
these functions came about. If I get enough (and enough variety) I'll 
present it to my editors. Contributions to: [EMAIL PROTECTED]

--
Sincerely,
 Charles Barouch
 www.KeyAlly.com
 [EMAIL PROTECTED]


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UV to Text Conversion Standard?

[Geoffrey Mitchell]

To my knowledge, no.  Not in Universe anyway.  I *think* (from the docs,
I've never played with it) that UniData has a way to map sub-values to
ODBC/JDBC, but UniVerse does not.  Multivalues work fine, but it doesn't
go any lower than that.

Best answer: don't use sub-values.  They're evil, anyway.

On Fri, 2004-04-16 at 12:48, [EMAIL PROTECTED] wrote:

> Thank you, but what is the exact method to do this?
> I have never seen a "view of SVM level data" that actually works.
> Using ODBC or any other tool
> And by "works" I mean that it understands the relationship of the SVM data to the VM 
> data and the relationship of that to the AM data and properly processes 
> table-in-a-table configurations for editing, etc.
> 
> It's one thing to use BY-EXP to understand VM level tables, but can you really use 
> some tool to understand SVM embedded data at that second table level?
> Will
> 
> 
> In a message dated 4/16/2004 1:03:17 PM Eastern Daylight Time, [EMAIL PROTECTED] 
> writes:
> 
> > Will,
> > 
> > I'm not sure if this is what you're asking but all it does is create a
> > "virtual" view of the data into 1nf tables that Excel (in this case) sees
> > and understands.
> > 
> > Note: I have only done this with UniData and D3 and I know UniVerse does it
> > a little differently.
> > 
> > -- 
> > Colin Alfke
> > Calgary, Alberta Canada
> > 
> > "Just because something isn't broken doesn't mean that you can't fix it"
> > 
> > Stu Pickles
> > 
> > 
> > >-Original Message-
> > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > >Sent: Friday, April 16, 2004 9:26 AM
> > >To: [EMAIL PROTECTED]
> > >Subject: Re: UV to Text Conversion Standard?
> > >
> > >
> > >In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time, 
> > >[EMAIL PROTECTED] writes:
> > >
> > >
> > >> You can use the UniVerse ODBC Driver to pull the data from 
> > >UniVerse to
> > >> Excel, using correct dictionaries UniVerse will normalise 
> > >the data and sort
> > >> out the VM and SVM for you.
> > >
> > >Jonathan can you give a exact method for "sorting of 
> > SVM's" 
> > >within Universe 
> > >using an ODBC (or really any tool).
> > >I am not aware of this
> > >Thank you
> > >Will
> > -- 
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.oliver.com/mailman/listinfo/u2-users

-- 
Geoffrey Mitchell   314-684-1062
Programmer/Analyst  [EMAIL PROTECTED]
Knights Direct
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Database decoupling (Was: Future of U2)

[FFT2001]

   I'm just not seeing a great demand for this sort of thing from the majority 10 to 
100 user businesses that typically utilize multi-value products.  I mean some of my 
clients, and myself are only just NOW playing with Triggers and transaction sets.  
Most application are very business oriented, and even getting them up and running with 
FTPing a product list to a web page, or browsing documentation in HTML or PDF format 
is a major leap forward.
   Not saying all businesses are this way.  But I'm saying I don't think that is where 
most of the traditional multi-value market is focused.
Will


In a message dated 4/16/2004 1:09:48 PM Eastern Daylight Time, [EMAIL PROTECTED] 
writes:

> Well no, not really. I was thinking more in the line of "New application
> development that would like to provide the ability to utilize modern
> Internet protocols". A web presence would be included in that - but was
> actually furthest from my mind.
> 
> B2B interaction for example. Or even internal application integration. Being
> able to publish web services etc. etc.
> 
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Friday, April 16, 2004 11:28 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Database decoupling (Was: Future of U2)
> 
> 
> In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, 
> [EMAIL PROTECTED] writes:
> 
> 
> > Without this ability, I see no reason why anyone would commence new 
> > application development on the U2 platform. Since you will always 
> > require another application server (Websphere, Tomcat, Bea, Jboss, 
> > etc.) to talk to the U2 server, that would in-turn interact with the 
> > database.
> > 
> 
> I'm sure Mark you mean "New application development that must have a web 
> presence".  Unless you feel that all application development must have a web
> 
> presence.
> Will
> -- 
 
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UV to Text Conversion Standard?

[FFT2001]

Thank you, but what is the exact method to do this?
I have never seen a "view of SVM level data" that actually works.
Using ODBC or any other tool
And by "works" I mean that it understands the relationship of the SVM data to the VM 
data and the relationship of that to the AM data and properly processes 
table-in-a-table configurations for editing, etc.

It's one thing to use BY-EXP to understand VM level tables, but can you really use 
some tool to understand SVM embedded data at that second table level?
Will


In a message dated 4/16/2004 1:03:17 PM Eastern Daylight Time, [EMAIL PROTECTED] 
writes:

> Will,
> 
> I'm not sure if this is what you're asking but all it does is create a
> "virtual" view of the data into 1nf tables that Excel (in this case) sees
> and understands.
> 
> Note: I have only done this with UniData and D3 and I know UniVerse does it
> a little differently.
> 
> -- 
> Colin Alfke
> Calgary, Alberta Canada
> 
> "Just because something isn't broken doesn't mean that you can't fix it"
> 
> Stu Pickles
> 
> 
> >-Original Message-
> >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> >Sent: Friday, April 16, 2004 9:26 AM
> >To: [EMAIL PROTECTED]
> >Subject: Re: UV to Text Conversion Standard?
> >
> >
> >In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time, 
> >[EMAIL PROTECTED] writes:
> >
> >
> >> You can use the UniVerse ODBC Driver to pull the data from 
> >UniVerse to
> >> Excel, using correct dictionaries UniVerse will normalise 
> >the data and sort
> >> out the VM and SVM for you.
> >
> >Jonathan can you give a exact method for "sorting of 
> SVM's" 
> >within Universe 
> >using an ODBC (or really any tool).
> >I am not aware of this
> >Thank you
> >Will
> -- 
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users 
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Database decoupling (Was: Future of U2)

[Daly, Mark]

Well no, not really. I was thinking more in the line of "New application
development that would like to provide the ability to utilize modern
Internet protocols". A web presence would be included in that - but was
actually furthest from my mind.

B2B interaction for example. Or even internal application integration. Being
able to publish web services etc. etc.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 16, 2004 11:28 AM
To: [EMAIL PROTECTED]
Subject: Re: Database decoupling (Was: Future of U2)


In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> Without this ability, I see no reason why anyone would commence new 
> application development on the U2 platform. Since you will always 
> require another application server (Websphere, Tomcat, Bea, Jboss, 
> etc.) to talk to the U2 server, that would in-turn interact with the 
> database.
> 

I'm sure Mark you mean "New application development that must have a web 
presence".  Unless you feel that all application development must have a web

presence.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Database decoupling (Was: Future of U2)

[Daly, Mark]

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 16, 2004 11:28 AM
To: [EMAIL PROTECTED]
Subject: Re: Database decoupling (Was: Future of U2)


In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> Without this ability, I see no reason why anyone would commence new 
> application development on the U2 platform. Since you will always 
> require another application server (Websphere, Tomcat, Bea, Jboss, 
> etc.) to talk to the U2 server, that would in-turn interact with the 
> database.
> 

I'm sure Mark you mean "New application development that must have a web 
presence".  Unless you feel that all application development must have a web

presence.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UV to Text Conversion Standard?

[alfkec]

Will,

I'm not sure if this is what you're asking but all it does is create a
"virtual" view of the data into 1nf tables that Excel (in this case) sees
and understands.

Note: I have only done this with UniData and D3 and I know UniVerse does it
a little differently.

-- 
Colin Alfke
Calgary, Alberta Canada

"Just because something isn't broken doesn't mean that you can't fix it"

Stu Pickles


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 16, 2004 9:26 AM
>To: [EMAIL PROTECTED]
>Subject: Re: UV to Text Conversion Standard?
>
>
>In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time, 
>[EMAIL PROTECTED] writes:
>
>
>> You can use the UniVerse ODBC Driver to pull the data from 
>UniVerse to
>> Excel, using correct dictionaries UniVerse will normalise 
>the data and sort
>> out the VM and SVM for you.
>
>Jonathan can you give a exact method for "sorting of SVM's" 
>within Universe 
>using an ODBC (or really any tool).
>I am not aware of this
>Thank you
>Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Jbase handles multivalue on RDBMS

[Tom Firl]

> > And for the not so faint of heart, jBASE provides the capability to roll
> > your own driver(s) to transform your MV database definition into the
relational
> > database without using the jEDI development kit.
> >
> > Tom Firl
> > Columbia Ultimate
>
> And I can use my shoe as a hammer, but of course it doesn't work so well
that
> way.

The drivers can be written in BASIC... so any programmer can do it.  But, in the 
context of using DB2 (or some other relational database) as the application's primary 
data store, writing those drivers in C or C++ will probably yield a little better 
throughput.  You also don't get the other bells and whistles included in the jEDI 
development kit.

Tom Firl
Columbia Ultimate 
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Jbase handles multivalue on RDBMS

[Scott Richardson]

Guess that depends on your shoe.
;^)>

- Original Message - 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 16, 2004 11:38 AM
Subject: Re: Jbase handles multivalue on RDBMS


> In a message dated 4/15/2004 9:53:43 AM Pacific Daylight Time,
> [EMAIL PROTECTED] writes:
>
>
> > And for the not so faint of heart, jBASE provides the capability to roll
> > your own driver(s) to transform your MV database definition into the
relational
> > database without using the jEDI development kit.
> >
> > Tom Firl
> > Columbia Ultimate
>
> And I can use my shoe as a hammer, but of course it doesn't work so well
that
> way.
> Will
> -- 
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: RedBack from .net

[Tony Evans]

David and Graham,

Thanks for mentioning the U2 & .NET white paper.  It was encouraging to see
that IBM is still developing U2.  The code examples listed in the white
paper were almost identical to the code I had written to access a RedBack
object and call its methods through the OleDb provider.  Unfortunately, I
get the same results as I had gotten originally.  The call comes back with
the schema of all the properties (including any custom properties that I
pass to the method), but no data.

We're currently running RedBack 4.1.3.2.

I've had success using regular ADO (via COM interop) to call an RBO, so I
think that's my best option until IBM releases the next version of RedBack.

Is there a list to which I can subscribe to receive announcements of U2
product releases/updates?  We purchased our U2 products through a reseller
(Jenkon) and IBM won't allow me to access the U2TechConnect site.

Thanks,
-Tony

Tony Evans
Web Developer
Richmont

-Original Message-
From: djordan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 15, 2004 7:28 AM
To: 'U2 Users Discussion List'
Subject: RE: RedBack from .net

Graham 

There is a white paper on U2 & .Net on the IBM U2 web page.  This had
some references on how to use Redback with .Net

Regards
David Jordan
Managing Consultant
[EMAIL PROTECTED]

Dacono Holdings Pty Ltd
Business & Technology Consulting
PO Box 909
Lane Cove 
NSW 2066
Australia
Ph 61 2 9418 8329
Fax 61 2 9427 2371
www.dacono.com.au 

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, 15 April 2004 5:55 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RedBack from .net


Tony 

RedBack 4.1 is not compliant with .net I have had limited success, see
sample code : 


Dim oRead As New REDPAGESLib.RedObject 
Try 
oRead.Open2("ACCOUNT", "MODULE:OBJECT") 
oRead.Property("PROPERTY").Value = "" 
oRead.CallMethod("METHOD") 
Catch 
Dim theErr = Err.Description 
End Try 
Dim b = oRead.Property("PROPERTY").Value 


New version of RedBack out end of this month which is compliant with
.net 
Regards 

Graham 


Can anyone share any experience they've had calling a RedBack RBO from
.NET? 

I've tried the following methods: 

1. OleDbConnection to the RedPages OLE DB Provider: results in an error
when 
trying to call the RBO's .Create() method. 

2. ADODB Connection (via COM Interop) to the RedPages OLE DB Provider: 
retrieves the schema (all the property names), but no data, and does not

return any error messages. 

3. RedObject (via COM Interop to RedPages.dll): I can't set any property

values for method calls, so this doesn't work at all. 

Does anyone have any other ideas? 

Any help would be greatly appreciated. 








This email may contain information which is privileged or confidential.
If you are not the intended recipient of this email, please notify the
sender immediately and delete it without reading, copying, storing,
forwarding or disclosing its contents to any other person Thank you

Check us out at http://www.btsyntegra.com



-- 
u2-users mailing list
[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Jbase handles multivalue on RDBMS

[FFT2001]

In a message dated 4/15/2004 9:53:43 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> And for the not so faint of heart, jBASE provides the capability to roll 
> your own driver(s) to transform your MV database definition into the relational 
> database without using the jEDI development kit.
> 
> Tom Firl
> Columbia Ultimate

And I can use my shoe as a hammer, but of course it doesn't work so well that 
way.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UV to Text Conversion Standard?

[FFT2001]

In a message dated 4/15/2004 6:12:27 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> Will - your posting mentioned CONVERT(VM,"|", mydata) - my version of UV
> does not seem to like that.

Jim, Excel CAN read comma delimited data.  Ask again why the requirement for 
fixed length?  Excel DOES NOT NEED fixed length :)

Ok now having said that.  Type HELP BASIC CONVERT to see what options you 
have and what the syntax is for your version.

Barring that, presumably you are using UV 8.0 or lower or something...
Then you can achieve the same result with a loop on
WhereVM = INDEX(MYSTRING,@VM,1)
mystring = mystring[1,wherevm-1]:",":mystring[wherevm+1,len(mystring)]
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Database decoupling (Was: Future of U2)

[FFT2001]

In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> Without this ability, I see no reason why anyone would commence new
> application development on the U2 platform. Since you will always require
> another application server (Websphere, Tomcat, Bea, Jboss, etc.) to talk to
> the U2 server, that would in-turn interact with the database. 
> 

I'm sure Mark you mean "New application development that must have a web 
presence".  Unless you feel that all application development must have a web 
presence.
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: UV to Text Conversion Standard?

[FFT2001]

In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> You can use the UniVerse ODBC Driver to pull the data from UniVerse to
> Excel, using correct dictionaries UniVerse will normalise the data and sort
> out the VM and SVM for you.

Jonathan can you give a exact method for "sorting of SVM's" within Universe 
using an ODBC (or really any tool).
I am not aware of this
Thank you
Will
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: UniVerse vs Progress Performance

[Brutzman, Bill]

I thought that Progress lives as more-or-less a traditional SQL database.

Please clarify...What is special about Progress ?

--Bill

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Installation unirpc

[David Beahm]

First off, try killing iptables.  Even if you tell RH9 that you don't 
want a firewall, it still installs it and can cause this type of trouble.

HTH,
David Beahm
Christophe Marchal wrote:
Hello,

I have installed universe 10.0 on a redhat 9. It works well on a telnet, 
unirpc daemon is running but I could not established an ODBC connection.
Some knows what should be configure on the new server to get odbc works ?

thanks for help,
Christophe
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

[Anthony Youngman]

Why?

He's got 4Gb of ram. If he overflows that by JUST ONE BYTE, if he was
running linux his performance would *collapse*.

If you do not have twice ram as swap, you only need to use ONE BYTE of
swap space and the linux algorithm will shit itself trying to cope. The
algorithm does not work very well if it doesn't have enough disk space,
and that's where the "twice swap" rule came from. So it's a very old
unix algorithm ... which is why I suspect AIX might suffer similarly.

Cheers,
Wol 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Steve Ferries
Sent: 16 April 2004 14:45
To: U2 Users Discussion List
Subject: RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

HI All,

Before doubling you swap space, check to see how much you are using at
your busy times. We have an 8 Gig system, and a 6 Gig pool:

Page Space  Physical Volume   Volume GroupSize   %Used  Active  Auto
Type
paging00hdisk1rootvg6144MB   2 yes   yes
lv

Everyone into the pool!

Regards,

Steve Ferries
Vice President, Information Technologies
Total Credit Recovery Limited





-Original Message-
From: Anthony Youngman [

mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 9:31 AM
To: U2 Users Discussion List
Subject: RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2


Okay, it's AIX not linux, but I've just noticed that RAM = swap.

You are an ABSOLUTE FOOL if you do that on linux. Maybe (or maybe not)
the same applies to AIX - quite likely since they are both nixen and
probably manage memory similiarly.

Double swap space to 8Gb and see if that improves matters.

Oh - and if you don't believe me, a "swap = ram" configuration will
CRASH the early vanilla 2.4 kernels and that's 2002 vintage.

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [
 mailto:[EMAIL PROTECTED]
On Behalf Of Scott Richardson
Sent: 16 April 2004 14:06
To: U2 Users Discussion List
Subject: Re: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

Performance of UV applications on various Operating Systems
is not rocket science. Perhaps better described as large, nasty
tight onions that need peeling, one layer at a time, and
understanding what each peeled layer is doing and why.
Once this knowledge is acquired and understood, a plan can
be built and executed to attack/resolve the problem.

Are users logging out/off when they're done using the system,
or when they've completed some large tasks or operations?
How often is the system rebooted?
RAID 5 file systems can slow down IO.
We'll need specifics on file system setup and parameters.
How many users? What are these users doing?
Have you got everyone and their siblings all running SELECT and
SORT operations all the time? Data Entry out the wazoo?

How big are the files, and how are they sized? How frequently
does data change in the files, (grow, shrink, etc...)

How big is your /tmp file system, and what kind of file system,
and where is it physically located?? Provide it it's own file system,
on it's own disk or disk set, (i.e. not the same disks where other
activity is going on).

4GB of RAM, yet only 4 GB paging/swap space?
Where is this swap paging space, (i.e. what disks?)

"topas" may be fine for quick and dirty analysis and understanding,
but using it extensively can help contribute to performance problems.

You need to configure and tune the platform, the OS, the UV DB,
the IO sub-system,  the applications, the users, and the
administration/operations, and thenensure they're all coordinated
with each other, to maximize platform performance.

To find, (and therefore address & resolve), the root causes of what
is happening here, you need to profile the platform using something
such as the DPMonitor, (extremely low-overhead monitoring Agent)
and display/crunch the performance metrics on another platform,
(i..e. a Windows Performance Explorer Console). Using this method,
you'll be able completely profile the entire platform, (OS and
applications),
around the clock, and then easily dial into specific timeframes where
problems are occurring, and fully understand exactly what is happening
and learn why it is happening, so it can be addressed and resolved,
and measure the progress along the entire way.

The DPMonitor is available with a free 10 day evaluation license where
it
will track system-wide performance metrics. Fully licensed version will
track individual processes that you select, or all processes if you so
desire. When you monitor all of the processes, you can quickly and
easily identify processes deserving further analysis, and stop tracking
processes that are not casuing any problems. More information on the
DPMonitor can be found at   http://www.deltek.us
and the DPMonitor
can be downloaded right off the website. If you're short on memory,
DPMonitor will allow you to see how much memory you will need to
allow the system to ru

RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

[Steve Ferries]

HI All,

Before doubling you swap space, check to see how much you are using at your busy 
times. We have an 8 Gig system, and a 6 Gig pool:

Page Space  Physical Volume   Volume GroupSize   %Used  Active  Auto  Type
paging00hdisk1rootvg6144MB   2 yes   yeslv

Everyone into the pool!

Regards,

Steve Ferries
Vice President, Information Technologies
Total Credit Recovery Limited





-Original Message-
From: Anthony Youngman [   mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 9:31 AM
To: U2 Users Discussion List
Subject: RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2


Okay, it's AIX not linux, but I've just noticed that RAM = swap.

You are an ABSOLUTE FOOL if you do that on linux. Maybe (or maybe not)
the same applies to AIX - quite likely since they are both nixen and
probably manage memory similiarly.

Double swap space to 8Gb and see if that improves matters.

Oh - and if you don't believe me, a "swap = ram" configuration will
CRASH the early vanilla 2.4 kernels and that's 2002 vintage.

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [   mailto:[EMAIL PROTECTED]
On Behalf Of Scott Richardson
Sent: 16 April 2004 14:06
To: U2 Users Discussion List
Subject: Re: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

Performance of UV applications on various Operating Systems
is not rocket science. Perhaps better described as large, nasty
tight onions that need peeling, one layer at a time, and
understanding what each peeled layer is doing and why.
Once this knowledge is acquired and understood, a plan can
be built and executed to attack/resolve the problem.

Are users logging out/off when they're done using the system,
or when they've completed some large tasks or operations?
How often is the system rebooted?
RAID 5 file systems can slow down IO.
We'll need specifics on file system setup and parameters.
How many users? What are these users doing?
Have you got everyone and their siblings all running SELECT and
SORT operations all the time? Data Entry out the wazoo?

How big are the files, and how are they sized? How frequently
does data change in the files, (grow, shrink, etc...)

How big is your /tmp file system, and what kind of file system,
and where is it physically located?? Provide it it's own file system,
on it's own disk or disk set, (i.e. not the same disks where other
activity is going on).

4GB of RAM, yet only 4 GB paging/swap space?
Where is this swap paging space, (i.e. what disks?)

"topas" may be fine for quick and dirty analysis and understanding,
but using it extensively can help contribute to performance problems.

You need to configure and tune the platform, the OS, the UV DB,
the IO sub-system,  the applications, the users, and the
administration/operations, and thenensure they're all coordinated
with each other, to maximize platform performance.

To find, (and therefore address & resolve), the root causes of what
is happening here, you need to profile the platform using something
such as the DPMonitor, (extremely low-overhead monitoring Agent)
and display/crunch the performance metrics on another platform,
(i..e. a Windows Performance Explorer Console). Using this method,
you'll be able completely profile the entire platform, (OS and
applications),
around the clock, and then easily dial into specific timeframes where
problems are occurring, and fully understand exactly what is happening
and learn why it is happening, so it can be addressed and resolved,
and measure the progress along the entire way.

The DPMonitor is available with a free 10 day evaluation license where
it
will track system-wide performance metrics. Fully licensed version will
track individual processes that you select, or all processes if you so
desire. When you monitor all of the processes, you can quickly and
easily identify processes deserving further analysis, and stop tracking
processes that are not casuing any problems. More information on the
DPMonitor can be found at   http://www.deltek.us and the 
DPMonitor
can be downloaded right off the website. If you're short on memory,
DPMonitor will allow you to see how much memory you will need to
allow the system to run as fast as it can, given how you're running it.
If you need tuning of OS or UV parameters, or other things that ay be
playing contributing factor/roles, the DPMonitor will clearly point this
out,
grahically, so that anyone can plainly see what is happening.

Once you make any changes, you'll be able to monitor, and measure,
any differences, consistently, and prove whether or not you have
improved, or detrimented, your cause. Best of all, you'll be able to
show, prove, and justify to  management what you're doing, and
why, and show them what it will take to get the problems addressed
and resolved, positively, without question.

Hope this helps.  I know the DPMonitor can & will help.
I have used it pers

RE: PI Open is going away

[Derek Falkner]

Well, I'm hanging on to my Leo III docs - just waiting for someone to
come up with an emulator for the intel platform! CLEO anyone? The
System/4 stuff went ages ago.

Derek Falkner
Kingston, Ontario, Canada

 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Keith Upton
> Sent: April 16, 2004 9:19 AM
> To: U2 Users Discussion List
> Subject: RE: PI Open is going away
> 
> 
> I was at Hoskyns, did a bit of gin for George II+... or our version of
> it!
> 
> -Original Message-
> From: Martin Phillips [mailto:[EMAIL PROTECTED] 
> Sent: 16 April 2004 14:19
> To: U2 Users Discussion List
> Subject: Re: PI Open is going away
> 
> > Funny that... I was only thinking the other day that I should throw
> >  out my ICL 1900 COBOL and PLAN Manuals!!! :-)
> 


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Jbase handles multivalue on RDBMS

[Dennis Bartlett]

For what it's worth the Revelation / Arev / OpenInsight
crowd have a
thing called "Bonding" where in you can create a bond with
another
database structure, and natively list/sort/query that
database. Bundled
with Arev comes Dbase / Ascii bonds. I don't know what comes
with OI,
but I believe you get bonds for all manner of database(s).

As far as I remember, the emphasis is on data movement
_from_ the other
data structure, altho' it handles creation of data within
that
structure, but only within the rules of that structure - ie
you can't
create multivalues within a normalised base, and it's up to
your
programming to convert mv files into flat form based files.

The best people to ask about this sorta thing have got to be
Sprezzatura
(Andrew McAuley and co) at www.sprezzatura.co.uk

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
On Behalf Of Dawn M. Wolthuis
Sent: 15 April 2004 02:04
To: 'U2 Users Discussion List'
Subject: RE: Jbase handles multivalue on RDBMS


Do you know if there is a flavor of the type-it-in
multivalue query
language (e.g. UniQuery) that can be executed against data
stored in
Oracle, DB2, SQL Server, etc?  I know that DataBASIC can be
with jBASE
and ONGroup, for example.

--dawn

Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
On Behalf Of djordan
Sent: Thursday, April 15, 2004 12:27 AM
To: 'U2 Users Discussion List'
Subject: Jbase handles multivalue on RDBMS

Hi Steve

Just to correct you, jbase does not require you to move to
1NF files to
run on an RDBMS.  Jbase will port multi dimensional data
across to an
RDBMS and automatically handle the conversion to multiple
tables
invisible to the application.  The issue is in the quality
of the
dictionary, like lengths and data types that RDBMS do not
handle
breaking the rules.  Jbase does handle a lot of these issues
and I would
assume IBM will incorporate that in U2.  Also in such an
environment you
would not move all your files over to an RDBMS, it would
make sense to
leave work files and control files in Universe which are
usualy the
worst offenders.  If you wish to make your application
portable in a
future environment like this, look at SQLising your files
including
multivalues and starting cleaning your data as this will be
your biggest
issue, not multivalues.

Just another point, jbase does the same for Cache, which is
another
multi-dimensional database, although not PICK.

Regards

David Jordan

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
On Behalf Of Steve Mayo
Sent: Thursday, 15 April 2004 4:01 AM
To: U2 Users Discussion List
Subject: RE: The future of U2


The way that jBase handles the problem is by requiring the
database be
flattened out (i.e., no multivalues) and strict data typing.
This is of
course the standard with 1NF databases. Unfortunately for
most of us, it
means a complete redesign of the existing mv database
structure. Over
the past several years, all new systems that I have
developed have used
1NF. Still most of the data still uses multivalues and would
take years
to convert. :-)

Steve

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

[Anthony Youngman]

Okay, it's AIX not linux, but I've just noticed that RAM = swap.

You are an ABSOLUTE FOOL if you do that on linux. Maybe (or maybe not)
the same applies to AIX - quite likely since they are both nixen and
probably manage memory similiarly.

Double swap space to 8Gb and see if that improves matters.

Oh - and if you don't believe me, a "swap = ram" configuration will
CRASH the early vanilla 2.4 kernels and that's 2002 vintage.

Cheers,
Wol 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Scott Richardson
Sent: 16 April 2004 14:06
To: U2 Users Discussion List
Subject: Re: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

Performance of UV applications on various Operating Systems
is not rocket science. Perhaps better described as large, nasty
tight onions that need peeling, one layer at a time, and
understanding what each peeled layer is doing and why.
Once this knowledge is acquired and understood, a plan can
be built and executed to attack/resolve the problem.

Are users logging out/off when they're done using the system,
or when they've completed some large tasks or operations?
How often is the system rebooted?
RAID 5 file systems can slow down IO.
We'll need specifics on file system setup and parameters.
How many users? What are these users doing?
Have you got everyone and their siblings all running SELECT and
SORT operations all the time? Data Entry out the wazoo?

How big are the files, and how are they sized? How frequently
does data change in the files, (grow, shrink, etc...)

How big is your /tmp file system, and what kind of file system,
and where is it physically located?? Provide it it's own file system,
on it's own disk or disk set, (i.e. not the same disks where other
activity is going on).

4GB of RAM, yet only 4 GB paging/swap space?
Where is this swap paging space, (i.e. what disks?)

"topas" may be fine for quick and dirty analysis and understanding,
but using it extensively can help contribute to performance problems.

You need to configure and tune the platform, the OS, the UV DB,
the IO sub-system,  the applications, the users, and the
administration/operations, and thenensure they're all coordinated
with each other, to maximize platform performance.

To find, (and therefore address & resolve), the root causes of what
is happening here, you need to profile the platform using something
such as the DPMonitor, (extremely low-overhead monitoring Agent)
and display/crunch the performance metrics on another platform,
(i..e. a Windows Performance Explorer Console). Using this method,
you'll be able completely profile the entire platform, (OS and
applications),
around the clock, and then easily dial into specific timeframes where
problems are occurring, and fully understand exactly what is happening
and learn why it is happening, so it can be addressed and resolved,
and measure the progress along the entire way.

The DPMonitor is available with a free 10 day evaluation license where
it
will track system-wide performance metrics. Fully licensed version will
track individual processes that you select, or all processes if you so
desire. When you monitor all of the processes, you can quickly and
easily identify processes deserving further analysis, and stop tracking
processes that are not casuing any problems. More information on the
DPMonitor can be found at http://www.deltek.us and the DPMonitor
can be downloaded right off the website. If you're short on memory,
DPMonitor will allow you to see how much memory you will need to
allow the system to run as fast as it can, given how you're running it.
If you need tuning of OS or UV parameters, or other things that ay be
playing contributing factor/roles, the DPMonitor will clearly point this
out,
grahically, so that anyone can plainly see what is happening.

Once you make any changes, you'll be able to monitor, and measure,
any differences, consistently, and prove whether or not you have
improved, or detrimented, your cause. Best of all, you'll be able to
show, prove, and justify to  management what you're doing, and
why, and show them what it will take to get the problems addressed
and resolved, positively, without question.

Hope this helps.  I know the DPMonitor can & will help.
I have used it personally, numerous times, to peel many a complex onion,
understand what is exactly going on, find out why, and then put together
and executed plans that have successfully addressed and resolved similar
problems and streamlined operations moving forward saving many a
business significant time, frustration, and money, and then ensured that
any & all operations moving forward were done from a pro-active,
knowing ahead of time manner, rather than fire-fighting problems on a
continual basis. If you want something done, why not do it right, once?
Stop beating your head against the onion wall! Work smarter!
Let the DPMonitor be your detailed, EKG-like instrument to cut to
the heart of your complex application server p

Re: UniVerse vs Progress Performance

[Scott Richardson]

Sounds like something is not tuned properly somewhere.
Another Onion that needs a damn good peeling!

Download the DPMonitor on both of these puppies,
and then you can realistically compare volumes of I/O,
volumes of CPU, volumes of memory, etc... in an "apples to apples"
sort of comparison of sorts.

Once you have it peeled and profiled, you will then have the
technology required to put it all back together properly, so that
it will scream like a "raped-ape" as they say.

Not only that - you can monitor what ever changes you make
along the way and clearly see if they help, or hurt your cause, and why.

See my other reply to the "Performance Degraded..." thread.

When you peel all the layers off these tight, nasty onions, and
understand what's going on at all the different levels - it make it easy
to identify, address & resolve these problems - and monitor them
proactively going forward as changes occur, growth/shrinkage happens,
or additional processes / users come into the mix.

UV applications, properly tuned and configured on their platform, should
run extremely well, price/performance-wise.

Been there, done that.
Many times over.

Sincere Regards,
Scott Richardson
Senior Systems Engineer / Consultant
Marlborough, MA 01752
Email: [EMAIL PROTECTED]
Web: http://home.comcast.net/~CheetahFTL/CC/CheetahFTL_1.htm
eFax: 208-445-1259



- Original Message - 
From: "Ross Ferris" <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Friday, April 16, 2004 12:48 AM
Subject: RE: UniVerse vs Progress Performance


Probably need to see Progress running on the IBM under AIX - or UV on Intel
chip with same OS to make significant comparison; even neglecting just WHAT
is going on under the hood  could have been 400+ users doing 'nothing'

Ross Ferris
Stamina Software
Visage - an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of Dawn M. Wolthuis
>Sent: Friday, 16 April 2004 1:36 PM
>To: 'U2 Users Discussion List'
>Subject: RE: UniVerse vs Progress Performance
>
>I'm curious if there is a follow up on this?  Is it a database tuning
>issue?
>Indexing?  Memory?  ...
>
>Thanks.  --dawn
>
>Dawn M. Wolthuis
>Tincat Group, Inc.
>www.tincat-group.com
>
>Take and give some delight today.
>
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of André Nel
>Sent: Tuesday, March 23, 2004 3:07 AM
>To: [EMAIL PROTECTED]
>Subject: FW: UniVerse vs Progress Performance
>
>
>
>Hi All
>
>Visited a  neighbouring company (same line of business as ours) running 430
>users on a Compaq Proliant box with SCO Openserver 5 and Progress version
>9.1c as database. Application is in-house. At the time of my visit the CPU
>usage was constantly running at 80%. No problems being experienced with
>users complaining the system is slow etc.
>
>The server spec is as follows:
>
>2x intel pentium III xeon 500Mhz processors
>1.8GB RAM
>Smart Array 3200 controller
>Compaq Fast SCSI-2 controller
>10x 18.2 GB Ultra SCSI-2 drives (8 drives are RAID 1, other 2 RAID 0) and 5
>drives on Ultra 2 controller and 5 drives on Ultra 3 Controller
>2x 10/100 Tx Ethernet controllers
>
>We are running AIX v5.1 with Maintainance Level 3 and UniVerse 10.0.7 (190
>users) on a p620 box with the following specs:
>
>System Model: IBM,7025-6F1
>Machine Serial Number: 6577ABA
>Processor Type: PowerPC_RS64-III
>Number Of Processors: 2
>Processor Clock Speed: 602 MHz
>CPU Type: 64-bit
>Kernel Type: 32-bit
>LPAR Info: -1 NULL
>Memory Size: 4096 MB
>Good Memory Size: 4096 MB
>Paging 3072MB
>Firmware Version: IBM,M2P01208
>
>Our box is struggling with the 190 users. File types are T30. All our lines
>are minimum 64K diginet.
>
>Comparing the 2 boxes, the amount of users on each box, any reason why we
>are struggling with the 190 users? The transaction volumes of the company
>running 430 users are considerably higher than ours?
>
>Any comments please
>
>Thanks
>
>André
>
>
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>--
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.658 / Virus Database: 421 - Release Date: 9/04/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.658 / Virus Database: 421 - Release Date: 9/04/2004

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: PI Open is going away

[Keith Upton]

I was at Hoskyns, did a bit of gin for George II+... or our version of
it!

-Original Message-
From: Martin Phillips [mailto:[EMAIL PROTECTED] 
Sent: 16 April 2004 14:19
To: U2 Users Discussion List
Subject: Re: PI Open is going away

> Funny that... I was only thinking the other day that I should throw
>  out my ICL 1900 COBOL and PLAN Manuals!!! :-)

Don;t start me on that nostalgia!  I was an operating system developer
with
ICL all those years ago.

Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


This e-mail and any attachments are confidential and intended solely for the use of 
the addressee only. If you have received this message in error, you must not copy, 
distribute or disclose the contents; please notify the sender immediately and delete 
the message.
This message is attributed to the sender and may not necessarily reflect the view of 
Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis 
Perkins may not be concluded by means of e-mail communication.
E-mail transmissions are not secure and Travis Perkins accepts no responsibility for 
changes made to this message after it was sent. Whilst steps have been taken to ensure 
that this message is virus free, Travis Perkins accepts no liability for infection and 
recommends that you scan this e-mail and any attachments.
Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone 
Road, Northampton, NN5 7UG.

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: PI Open is going away

[Martin Phillips]

> Funny that... I was only thinking the other day that I should throw
>  out my ICL 1900 COBOL and PLAN Manuals!!! :-)

Don;t start me on that nostalgia!  I was an operating system developer with
ICL all those years ago.

Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

[Scott Richardson]

Performance of UV applications on various Operating Systems
is not rocket science. Perhaps better described as large, nasty
tight onions that need peeling, one layer at a time, and
understanding what each peeled layer is doing and why.
Once this knowledge is acquired and understood, a plan can
be built and executed to attack/resolve the problem.

Are users logging out/off when they're done using the system,
or when they've completed some large tasks or operations?
How often is the system rebooted?
RAID 5 file systems can slow down IO.
We'll need specifics on file system setup and parameters.
How many users? What are these users doing?
Have you got everyone and their siblings all running SELECT and
SORT operations all the time? Data Entry out the wazoo?

How big are the files, and how are they sized? How frequently
does data change in the files, (grow, shrink, etc...)

How big is your /tmp file system, and what kind of file system,
and where is it physically located?? Provide it it's own file system,
on it's own disk or disk set, (i.e. not the same disks where other
activity is going on).

4GB of RAM, yet only 4 GB paging/swap space?
Where is this swap paging space, (i.e. what disks?)

"topas" may be fine for quick and dirty analysis and understanding,
but using it extensively can help contribute to performance problems.

You need to configure and tune the platform, the OS, the UV DB,
the IO sub-system,  the applications, the users, and the
administration/operations, and thenensure they're all coordinated
with each other, to maximize platform performance.

To find, (and therefore address & resolve), the root causes of what
is happening here, you need to profile the platform using something
such as the DPMonitor, (extremely low-overhead monitoring Agent)
and display/crunch the performance metrics on another platform,
(i..e. a Windows Performance Explorer Console). Using this method,
you'll be able completely profile the entire platform, (OS and
applications),
around the clock, and then easily dial into specific timeframes where
problems are occurring, and fully understand exactly what is happening
and learn why it is happening, so it can be addressed and resolved,
and measure the progress along the entire way.

The DPMonitor is available with a free 10 day evaluation license where it
will track system-wide performance metrics. Fully licensed version will
track individual processes that you select, or all processes if you so
desire. When you monitor all of the processes, you can quickly and
easily identify processes deserving further analysis, and stop tracking
processes that are not casuing any problems. More information on the
DPMonitor can be found at http://www.deltek.us and the DPMonitor
can be downloaded right off the website. If you're short on memory,
DPMonitor will allow you to see how much memory you will need to
allow the system to run as fast as it can, given how you're running it.
If you need tuning of OS or UV parameters, or other things that ay be
playing contributing factor/roles, the DPMonitor will clearly point this
out,
grahically, so that anyone can plainly see what is happening.

Once you make any changes, you'll be able to monitor, and measure,
any differences, consistently, and prove whether or not you have
improved, or detrimented, your cause. Best of all, you'll be able to
show, prove, and justify to  management what you're doing, and
why, and show them what it will take to get the problems addressed
and resolved, positively, without question.

Hope this helps.  I know the DPMonitor can & will help.
I have used it personally, numerous times, to peel many a complex onion,
understand what is exactly going on, find out why, and then put together
and executed plans that have successfully addressed and resolved similar
problems and streamlined operations moving forward saving many a
business significant time, frustration, and money, and then ensured that
any & all operations moving forward were done from a pro-active,
knowing ahead of time manner, rather than fire-fighting problems on a
continual basis. If you want something done, why not do it right, once?
Stop beating your head against the onion wall! Work smarter!
Let the DPMonitor be your detailed, EKG-like instrument to cut to
the heart of your complex application server performance problems,
identify them, and help you to resolve them, quickly and easily.


Been there, done that.
Many times over.

Sincere Regards,
Scott Richardson
Senior Systems Engineer / Consultant
Marlborough, MA 01752
Email: [EMAIL PROTECTED]
Web: http://home.comcast.net/~CheetahFTL/CC/CheetahFTL_1.htm
eFax: 208-445-1259

- Original Message - 
From: "Foo Chia Teck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 16, 2004 2:22 AM
Subject: Performance Degraded running u10.0.0 in Aix 5.2 ML 2


Hi,

We are facing performance degraded when running Universe 10.0.0 in AIX 5L
5.2.

A bit intro on hardware specs. We are using pSeries 650 running o

RE: UV Crash on W2K3

[alfkec]

Interesting. I'm seeing a similar error on W2K with UD6.0.12 when we have
the prompt login path ticked in the telnet config in UniAdmin. Occasionally
when logging in and entering a new path we get an error. 

I'd be interested to know what the resolution is.

Thanks
-- 
Colin Alfke
Calgary, Alberta Canada

"Just because something isn't broken doesn't mean that you can't fix it"

Stu Pickles


>-Original Message-
>From: Sara Burns [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 15, 2004 6:03 PM
>To: '[EMAIL PROTECTED]'
>Subject: UV Crash on W2K3
>
>
>We are starting testing our application on W2K3 and getting unexplained
>problems.  It is proving difficult to isolate the exact cause 
>but we are
>starting to see some trends.  The result is the session 
>crashing with the
>following general message in the Event Log
> 
>Universe error; Unhandled exception raised at address 0x77bd4528
>Access violation Attempted to read from address 0x00d8 
>Binary data is processor CONTEXT structure
> 
>Sometimes the address to be read is 0x
> 
>So far we have found that it is very much less likely to occur 
>if we do a
>LOGTO DEV rather than logging on directly to DEV.
> 
[snip]
> 
>Sara Burns
> 
>Sara Burns (SEB) 
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: PI Open is going away

[Lance J. Andersen]

Martin,

I did the same recently.  Not only did i retire my PI/Open  docs but all 
of my old PI material dating back to my days prior to working at Prime 
when I was at Standard Data Systems, one of the original PI dealers . 

However the memories will always be with me...

-Lance

Martin Phillips wrote:

I was one of the two technical managers for the development of PI/open.
It's always sad watching a product that you worked on be put into
retirement.
Perhaps I can now throw out my collection of PI/open manuals.

Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
 

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Installation unirpc

[Christophe Marchal]

Hello,

I have installed universe 10.0 on a redhat 9. It works well on a telnet, 
unirpc daemon is running but I could not established an ODBC connection.
Some knows what should be configure on the new server to get odbc works ?

thanks for help,
Christophe
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: U2 Personal Editions

[Anthony Youngman]

For SuSE, I had to remove all the options to cpio.

Note also, that when it tries to set up the daemon to autostart on boot,
that fails also because SuSE uses a different /etc/rc.d setup. That
needs manually fixing, because you can't run uv as a user unless uvd is
running.

Cheers,
Wol 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of [EMAIL PROTECTED]
Sent: 07 April 2004 22:28
To: U2 Users Discussion List
Subject: RE: U2 Personal Editions

For Debian, i had to remove the "c" option from the "taperead='cpio
-ivc..."
line.  Somewhere along the way, i must have installed
compress/uncompress,
so that wasn't an issue.

Now, if i can figure out why my xterm gets clobbered when i start uv as
root.
Something wrong with the emulation somewhere.  Seems to work ok as a
normal
user.  There must be something in the admin menu that messes it up.

Charles Hawkins
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users






This transmission is intended for the named recipient only. It may contain private and 
confidential information. If this has come to you in error you must not act on 
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, 
or show it to anyone. Please e-mail the sender to inform us of the transmission error 
or telephone ECA International immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong 
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.



--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: PI Open is going away

[Anthony Youngman]

Ummm... My wife will murder me for this ... but I'd love to have a copy
(we've lost a lot of ours). Scan them or whatever. If I'm up your way
for some reason (I go up the M1 regularly, but have my wife with me ...)
I'd relieve you of them.

Cheers,
Wol

-Original Message-
From: Martin Phillips [mailto:[EMAIL PROTECTED] 
Sent: 16 April 2004 09:54
To: U2 Users Discussion List
Subject: Re: PI Open is going away

I was one of the two technical managers for the development of PI/open.
It's always sad watching a product that you worked on be put into
retirement.

Perhaps I can now throw out my collection of PI/open manuals.

Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


This e-mail and any attachments are confidential and intended solely for
the use of the addressee only. If you have received this message in
error, you must not copy, distribute or disclose the contents; please
notify the sender immediately and delete the message.
This message is attributed to the sender and may not necessarily reflect
the view of Travis Perkins plc or its subsidiaries (Travis Perkins).
Agreements binding Travis Perkins may not be concluded by means of
e-mail communication.
E-mail transmissions are not secure and Travis Perkins accepts no
responsibility for changes made to this message after it was sent.
Whilst steps have been taken to ensure that this message is virus free,
Travis Perkins accepts no liability for infection and recommends that
you scan this e-mail and any attachments.
Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge
Way, Harlestone Road, Northampton, NN5 7UG.

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users






This transmission is intended for the named recipient only. It may contain private and 
confidential information. If this has come to you in error you must not act on 
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, 
or show it to anyone. Please e-mail the sender to inform us of the transmission error 
or telephone ECA International immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong 
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.



--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: PI Open is going away

[Anthony Youngman]

I'm planning (when I get the chance) to resurrect the EXL7330 in my
garage. And the reason I salvaged it from work is that it has PI/Open on
it ...

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Jeff Fitzgerald
Sent: 15 April 2004 21:34
To: 'U2 Users Discussion List'
Subject: RE: PI Open is going away

Clif,

We're using PI/Open on our HP for a subset of our accounting
data.
We also have a copy of PI/Open 3.2 running on an old Prime/EXL - the
MIPS
based box that Prime used to sell!  We may even have a copy of PI/PC
around
somewhere.

Jeff Fitzgerald
Fitzgerald & Long, Inc. 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On
Behalf Of Clifton Oliver
Sent: Thursday, April 15, 2004 1:08 PM
To: U2 Users Discussion List
Subject: Re: PI Open is going away

As one of the engineers of the original Prime INFORMATION, I am curious
how
many people on the list are still using PI Open. Anyone care to sound
off?

-- 

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Apr 15, 2004, at 12:10, Jerry Banker wrote:

> The DB2 IMS Today newsletter has the following announcement.
>
> U2 Product Lifecycle Announcement
>
>   Effective October 1, 2004, IBM will withdraw from marketing the
>   programs noted below.  If available, their replacement products are
>   listed in the second column:
>
>   PI/Open

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users






This transmission is intended for the named recipient only. It may contain private and 
confidential information. If this has come to you in error you must not act on 
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, 
or show it to anyone. Please e-mail the sender to inform us of the transmission error 
or telephone ECA International immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong 
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.



--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

RE: PI Open is going away

[Keith Upton]

Funny that... I was only thinking the other day that I should throw out
my ICL 1900 COBOL and PLAN Manuals!!! :-)

-Original Message-
From: Martin Phillips [mailto:[EMAIL PROTECTED] 
Sent: 16 April 2004 09:54
To: U2 Users Discussion List
Subject: Re: PI Open is going away

I was one of the two technical managers for the development of PI/open.
It's always sad watching a product that you worked on be put into
retirement.

Perhaps I can now throw out my collection of PI/open manuals.

Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


This e-mail and any attachments are confidential and intended solely for the use of 
the addressee only. If you have received this message in error, you must not copy, 
distribute or disclose the contents; please notify the sender immediately and delete 
the message.
This message is attributed to the sender and may not necessarily reflect the view of 
Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis 
Perkins may not be concluded by means of e-mail communication.
E-mail transmissions are not secure and Travis Perkins accepts no responsibility for 
changes made to this message after it was sent. Whilst steps have been taken to ensure 
that this message is virus free, Travis Perkins accepts no liability for infection and 
recommends that you scan this e-mail and any attachments.
Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone 
Road, Northampton, NN5 7UG.

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: PI Open is going away

[Martin Phillips]

I was one of the two technical managers for the development of PI/open.
It's always sad watching a product that you worked on be put into
retirement.

Perhaps I can now throw out my collection of PI/open manuals.

Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Re: PI Open is going away

[pwk_u2]

Working for Prime in Copenhagen from 1984 to 1992 supporting PI I
certainly remember these international events.

It's fun to see the names popping up on this list, it brings along a lot
of fine memories, including that I owe Lance a beer next time we met. It
never happened, but the memories...

Thanks PI for at very fine part of my working life.

Med venlig hilsen  (Best Regards)

-Paul

> I remember the Prime Information release 6 (and first official GCI) in
> Copenhagen - Dennis Beldotti arranging?
>
> Remember the fun !*! With !AMLC and it's handy way of writing to absolute
> memory addresses (gosh - and you didn't want those disk drives did you
> !?)
>
> Was anyone else there? - Bent Pristed was the head boy there then I thik
> and
> we were pushing out Viewbase on Primenet
>
> Memories eh? The passing of an age.
>
> Regards
>
> JayJay

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users