Re: [U2] [UV] Essbase or other BI

2010-03-03 Thread Boydell, Stuart
While I completely agree that U2 is totally flexible and easy to interface with 
- even though U2 is multidimensional it is not an OLAP or BI system. BI 
solutions are specifically designed to crunch data into a form that will return 
(usually aggregated) answers across millions of rows in milliseconds.
ie What were sales figures for New South Wales in December, for 2007,2008 & 
2009?
A user on our BI system (MS SSAS) can drag & drop that query and have it 
answered in a few seconds. The user can add and change filters and parameters 
on the fly (which categories performed, how much is still outstanding) and the 
cube will respond instantly. 

Much of this speed is due to several hours nightly processing which pre-builds 
the data into optimised aggregates. But it is also the fact that the DBMS 
itself is highly optimised for the task of data analysis.

I just don't think you'd get the RIGHT performance from U2 if you tried to 
replicate what the BI systems do - U2 is designed for more generalised 
information and reporting (pun intended).

Cheers,
Stuart Boydell 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Thursday, 4 March 2010 12:16
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Essbase or other BI


 
> From: Brian F. Paige

> 1. Does Essbase integrate with U2?

As I've mentioned in my blog and in forums, U2 can connect to
anything - don't let anyone convince you otherwise.  One of the
biggest things holding the MV market back is that even people who
use and love the platform have an overwhelming tendency to wonder
whether the system can actually do things that are advertised
elsewhere.  Sure it can!

The primary concern for integrating U2 to anything else is how
fast you need transaction data reflected in the new environment.
That determines whether an interface will be online, offline, or
near-line, and that narrows down your selection of tools to be
used for integration.

For anyone who's curious, here's info on Essbase:
http://en.wikipedia.org/wiki/Essbase
Side note: What's more interesting to me is how this is defined
emphatically as "a multidimensional database management system
(MDBMS)", and this page
http://en.wikipedia.org/wiki/Multidimensional_database
simply redirects to Online Analytical Processing unless you stop
it from doing so.  (MV Marketing people should get some clues
here... the rest of the world equates MultiDimensional to OLAP
while most people in our market don't use the term OLAP in
relation to their MV/MD DBMS.)

Anyway ... what I get from wikipedia is that Essbase really is
nothing more than a database, novel to relational folks but
nothing unusual to us.  So Essbase Analytics is a pretty GUI on
top of a system just like what you have now, just marketed as
something special.  (Perhaps MV Marketing people will find
another clue there.)  The important thing is not Essbase itself,
but what the pretty GUI provides.  And that leads us to an
evaluation of functionality...


> 2. What other packages are out there that would be comparable?

What I recommend is that you define specific goals for reporting
and then decide if you need extended reporting tools or if you
need Business Intelligence.  For MV-centric tools you'll find
products like MITS from MITS, Informer from Entrinsik, Velocity
from Tantiva, DeepSee from InterSystems, and Viságe from Stamina.
Some of these are for BI and others reporting...

In addition to the more common mainstream offerings, many people
like Jasper Reports, but (arguably) that's not BI.  I have been
very impressed by ClickView and some of our colleagues are
integrating MV with it.  I'd welcome an opportunity to do so as
well.  You may also get what you need using off-the shelf
development tools like Telerik Reporting (for less than 1k plus
development time compared to 50-100k just to start working with
some of the others).

You'll find many discussions on reporting and BI in the archive
for this forum, and in comp.databases.pick.  Here is a link to
one such thread:
http://tinyurl.com/ydx52rd
Google using query:
  group:comp.databases.pick
and terms like mits, entrinsik, reporting, etc.  Example:
  group:comp.databases.pick mits
  group:comp.databases.pick reporting

HTH

BTW, I used to contract for Serta Corporate back in the early
90's when they were running on Microdata.  Fond memories...

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula R&D provides Pick/MultiValue products
worldwide, and provides related development services
remove.pleaseNebula-RnD.com/blog
Visit PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

**
This email message and any f

Re: [U2] [UV] Essbase or other BI

2010-03-03 Thread FFT2001
In a message dated 3/3/2010 5:15:44 PM Pacific Standard Time, 
3xk547...@sneakemail.com writes:


> Side note: What's more interesting to me is how this is defined
> emphatically as "a multidimensional database management system
> (MDBMS)", and this page
> http://en.wikipedia.org/wiki/Multidimensional_database
> simply redirects to Online Analytical Processing unless you stop
> it from doing so.>>>


I've now updated it so it redirs direct to the subsection instead of the 
top of the page.

Will Johnson
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Essbase or other BI

2010-03-03 Thread Tony Gravagno
 
> From: Brian F. Paige

> 1. Does Essbase integrate with U2?

As I've mentioned in my blog and in forums, U2 can connect to
anything - don't let anyone convince you otherwise.  One of the
biggest things holding the MV market back is that even people who
use and love the platform have an overwhelming tendency to wonder
whether the system can actually do things that are advertised
elsewhere.  Sure it can!

The primary concern for integrating U2 to anything else is how
fast you need transaction data reflected in the new environment.
That determines whether an interface will be online, offline, or
near-line, and that narrows down your selection of tools to be
used for integration.

For anyone who's curious, here's info on Essbase:
http://en.wikipedia.org/wiki/Essbase
Side note: What's more interesting to me is how this is defined
emphatically as "a multidimensional database management system
(MDBMS)", and this page
http://en.wikipedia.org/wiki/Multidimensional_database
simply redirects to Online Analytical Processing unless you stop
it from doing so.  (MV Marketing people should get some clues
here... the rest of the world equates MultiDimensional to OLAP
while most people in our market don't use the term OLAP in
relation to their MV/MD DBMS.)

Anyway ... what I get from wikipedia is that Essbase really is
nothing more than a database, novel to relational folks but
nothing unusual to us.  So Essbase Analytics is a pretty GUI on
top of a system just like what you have now, just marketed as
something special.  (Perhaps MV Marketing people will find
another clue there.)  The important thing is not Essbase itself,
but what the pretty GUI provides.  And that leads us to an
evaluation of functionality...


> 2. What other packages are out there that would be comparable?

What I recommend is that you define specific goals for reporting
and then decide if you need extended reporting tools or if you
need Business Intelligence.  For MV-centric tools you'll find
products like MITS from MITS, Informer from Entrinsik, Velocity
from Tantiva, DeepSee from InterSystems, and Viságe from Stamina.
Some of these are for BI and others reporting...

In addition to the more common mainstream offerings, many people
like Jasper Reports, but (arguably) that's not BI.  I have been
very impressed by ClickView and some of our colleagues are
integrating MV with it.  I'd welcome an opportunity to do so as
well.  You may also get what you need using off-the shelf
development tools like Telerik Reporting (for less than 1k plus
development time compared to 50-100k just to start working with
some of the others).

You'll find many discussions on reporting and BI in the archive
for this forum, and in comp.databases.pick.  Here is a link to
one such thread:
http://tinyurl.com/ydx52rd
Google using query:
  group:comp.databases.pick
and terms like mits, entrinsik, reporting, etc.  Example:
  group:comp.databases.pick mits
  group:comp.databases.pick reporting

HTH

BTW, I used to contract for Serta Corporate back in the early
90's when they were running on Microdata.  Fond memories...

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula R&D provides Pick/MultiValue products
worldwide, and provides related development services
remove.pleaseNebula-RnD.com/blog
Visit PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Decoding URL in UniBasic

2010-03-03 Thread Dan McGrath
Hi Charles,

Just to add to Doug, I'll assume you are encoding '\' as '\\' well?
Otherwise you would have no way to send the string '\"' without it being
(incorrectly) decoded as just '"'.

If this is the case, don't forget to SWAP '\\' with '\' before you fix
up the rest.

So it should look something like:

VALUE = CHANGE(VALUE,'\\','\')
VALUE = CHANGE(VALUE,'\"','"')
VALUE = CHANGE(VALUE,"\'","'")


Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug
Sent: Thursday, 4 March 2010 10:48 AM
To: 'U2 Users List'
Subject: Re: [U2] Decoding URL in UniBasic

Hi Charles:

Try: 

VALUE = CHANGE(VALUE,'\"','"') 

Regards,
Doug
www.u2logic.com
"XLr8Editor for U2"

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Wednesday, March 03, 2010 3:03 PM
To: U2 Users List
Subject: [U2] Decoding URL in UniBasic

I just ran into something that I'm surprised I haven't run into before. 
I'm passing some data into a UniBasic subroutine from PHP using
UniObjects
for Java.  When the string contains a single quote or a double quote, it

is being escaped.  It is sent as   5" Ring  but arrives as 5\" Ring.

I am encoding it in JavaScript and decoding it in PHP before using
UniObjects for Java to send it to the UniBasic subroutine.

If I don't decode it in PHP and send it through encoded, is there a way
to
decode it in UniBasic?  Unidata 7.1.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__
###
The information transmitted in this message and attachments (if any) is 
intended only
for the person or entity to which it is addressed. The message may contain 
confidential
and/or privileged material.  Any review, retransmission, dissemination or other 
use of
or taking of any action in reliance upon this information by persons or 
entities other
than the intended recipient is prohibited.  If you received this in error, 
please
contact the sender and delete the material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or 
distribute
the information contained in this e-mail and any attached files with the 
permission of IMB.
###
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Decoding URL in UniBasic

2010-03-03 Thread Doug
Hi Charles:

Try: 

VALUE = CHANGE(VALUE,'\"','"') 

Regards,
Doug
www.u2logic.com
"XLr8Editor for U2"

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Wednesday, March 03, 2010 3:03 PM
To: U2 Users List
Subject: [U2] Decoding URL in UniBasic

I just ran into something that I'm surprised I haven't run into before. 
I'm passing some data into a UniBasic subroutine from PHP using UniObjects
for Java.  When the string contains a single quote or a double quote, it 
is being escaped.  It is sent as   5" Ring  but arrives as 5\" Ring.

I am encoding it in JavaScript and decoding it in PHP before using
UniObjects for Java to send it to the UniBasic subroutine.

If I don't decode it in PHP and send it through encoded, is there a way to
decode it in UniBasic?  Unidata 7.1.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] AUTOLOGOUT

2010-03-03 Thread Leroy Dreyfuss
Hi Marc,

AUTOLOGOUT is session based. Onceit is executed it remains in effect
regardless of where the user navigates.

Also, the session must be waiting for input from the user for the
logout counter to begin. Once the user enters someting as input, the
counter stops and starts over only at the next input.

Cheers,

LeRoy

Sent from my iPhone 3Gs

On 03 Mar 2010, at 8:03 PM, "Caminiti, Marc"  wrote:

> Have a quick couple of questions on the AUTOLOGOUT function.   This is
> on Red Hat Enterprise Server 5.3, Universe 10.2.7.  Is the AUTOLOGOUT
> function a global setting, or can we use this in just 1 account?  For
> example, we have 2 accounts, PROD and DEV.  If we put AUTOLOGOUT 15 in
> the DEV account, will those people that go to the DEV account be the
> only ones affected by it?  Also, if we have a select or program that
> is
> running that takes greater than the "15" minutes in the AUTOLOGOUT,
> will
> it kill the process, or wait until it is finished, then start the 15
> minutes idle time?
>
>
>
> Thanks in advance
>
> marc
>
>
>
> Marc Caminiti
>
> IS Manager
>
> Nashbar Direct, Inc
>
> 6103 State Route 446
>
> Canfield, OH 44406
>
> 330.533.1989, ext 336
>
> 330.702.9733, fax
>
>
>
> All generalisations are dangerous, even this one.
>
>
>
>
>
> CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain
> confidential information that is legally privileged. The information
> is solely for the use of the intended recipient(s). Any disclosure,
> copying, distribution, or other use of this information is strictly
> prohibited. If you have received this e-mail in error, please notify
> the sender by return e-mail and delete this message.
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

To read FRSTIA's disclaimer for the e-mail go to http://www.frstia.co.za/
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Decoding URL in UniBasic

2010-03-03 Thread Charles_Shaffer
I just ran into something that I'm surprised I haven't run into before. 
I'm passing some data into a UniBasic subroutine from PHP using UniObjects 
for Java.  When the string contains a single quote or a double quote, it 
is being escaped.  It is sent as   5" Ring  but arrives as 5\" Ring.

I am encoding it in JavaScript and decoding it in PHP before using 
UniObjects for Java to send it to the UniBasic subroutine.

If I don't decode it in PHP and send it through encoded, is there a way to 
decode it in UniBasic?  Unidata 7.1.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] Essbase or other BI

2010-03-03 Thread bpaige
Greetings, all!

We have some new financial folks who think Essbase is the be-all, end-all of
financial reporting.  We're a 100% UV shop, and we really don't have
experience in any type of external reporting functionality yet.  I have two
general questions:

1. Does Essbase integrate with U2?
2. What other packages are out there that would be comparable?

No one has said anything about trying to force us into using Essbase, but we
want to be able to talk intelligently about it when it comes up in
discussions/meetings.  We're going into it with open minds - maybe it is
something we would want to use.  We just don't know enough to know.

I have contacted Oracle to try to get some information, but that was humorous
to say the least.  At this point, they might "get back to me in 2-4 business
days".  I have also started working with a VAR to see if we can get a dog and
pony just for information gathering purposes.

I figured I'd ask here as well to see if anyone out there has some real-world
info/experience they'd be willing to pass along.

Thanks!!

Brian F. Paige
Manager of Systems Operations
Serta International
bpa...@serta.com


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _

The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material not 
intended for Public use.  
Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is 
strictly prohibited. If you received this communication in error, please notify 
the sender and delete the material from any and all computers or devices.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Examples of working ENCRYPT function?

2010-03-03 Thread Kevin King
That's good to know Larry, thanks.   Yeah, must be AIX.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Examples of working ENCRYPT function?

2010-03-03 Thread Larry Hiscock
FWIW, your program compiled & ran fine on UD 6.1 running on SCO OSR5.0.7, with 
the following output:

STATUS= 0
RESULT= _53↨%N`Tf¶&j¶l
RESULTLOC = 1

Or the following, when I changed CRYPT.ACTION to 2:

RUN TEST.BP TEST.CRYPT
STATUS= 0
RESULT= X7WzlyXOYNTmlKZqlGw=
RESULTLOC = 1


It must be an AIX issue.

Larry Hiscock
Western Computer Services
http://www.wcs-corp.com


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Wednesday, March 03, 2010 11:38 AM
To: U2 Users List
Subject: Re: [U2] Examples of working ENCRYPT function?

Oh Larry, absolutely.  My test program was just to see if I could get any
results.  On 7.1, yes.  Pre-7.1, no.  So at this point I'm just chalking it
up to IBM putting out a turd in Unidata 6.  Not like the documentation for
this stuff has been the model of accuracy anyway.  I would just prefer that
going forward, Rocket document current and working features, not something
that might come into the product a couple years later.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UD] Enable Break Key From Separate Port

2010-03-03 Thread Kevin King
Wally, once again you are my hero.  Thanks, man!
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Examples of working ENCRYPT function?

2010-03-03 Thread Kevin King
Oh Larry, absolutely.  My test program was just to see if I could get any
results.  On 7.1, yes.  Pre-7.1, no.  So at this point I'm just chalking it
up to IBM putting out a turd in Unidata 6.  Not like the documentation for
this stuff has been the model of accuracy anyway.  I would just prefer that
going forward, Rocket document current and working features, not something
that might come into the product a couple years later.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Examples of working ENCRYPT function?

2010-03-03 Thread Larry Hiscock
Kevin,

Your key isn't really a key -- RC4 is a 128 bit encryption algorithm, which
requires a 128 bit key.  If you change the KEY.ACTION to 2 (generate a real
key from the passphrase), you should get different results.  You can (and
should) use a long passphrase made up of pseudo-random numbers, upper- and
lower-case letters and symbols to make your encryption more difficult to
crack.

You can also set CRYPT.ACTION to 2 to have the ENCRYPT() function base64
encode the result, so that it's safe to store in the database.  Otherwise,
you could end up with attribute, value or sub-value marks in your encrypted
string.  Use CRYPT.ACTION = 4 to base64 decode before decrypting.

Larry Hiscock
Western Computer Services
http://www.wcs-corp.com


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Tuesday, March 02, 2010 7:57 AM
To: U2 Users List
Subject: Re: [U2] Examples of working ENCRYPT function?

Here's my code to date:

*
* Test Encryption Program
*
ALGORITHM= 'rc4'
CRYPT.ACTION = 1
TEXT = 'THIS IS A TEST'
TEXT.LOC = 1
KEY  = 'ABCDEFG'
KEY.LOC  = 1
KEY.ACTION   = 1
SALT = ''
IV   = ''
RESULT   = ''
RESULTLOC= 1
STATUS = ENCRYPT(ALGORITHM, CRYPT.ACTION, TEXT, TEXT.LOC, KEY, KEY.LOC,
KEY.ACTION, SALT, IV, RESULT, RESULTLOC)
PRINT 'STATUS= ' : STATUS
PRINT 'RESULT= ' : RESULT
PRINT 'RESULTLOC = ' : RESULTLOC
STOP
END

And here's what it shows:

> RUN USER-FORMS TEST.ENCRYPT

STATUS= 1
RESULT=
RESULTLOC = 1

What am I missing?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Examples of working ENCRYPT function?

2010-03-03 Thread Colin Alfke
A simple cut'n'paste of your code on UD 7.1.6 windows gives this:
STATUS= 0
RESULT= njץCﮥ#¼hP!
RESULTLOC = 1

So your code isn't missing anything - it's something in the environment.

P.S. the help encrypt does say "Both salt and IV must be provided in
hexadecimal format."

Hth
Colin Alfke
Calgary, Canada

-Original Message-
From: Kevin King

Here's my code to date:

*
* Test Encryption Program
*
ALGORITHM= 'rc4'
CRYPT.ACTION = 1
TEXT = 'THIS IS A TEST'
TEXT.LOC = 1
KEY  = 'ABCDEFG'
KEY.LOC  = 1
KEY.ACTION   = 1
SALT = ''
IV   = ''
RESULT   = ''
RESULTLOC= 1
STATUS = ENCRYPT(ALGORITHM, CRYPT.ACTION, TEXT, TEXT.LOC, KEY, KEY.LOC,
KEY.ACTION, SALT, IV, RESULT, RESULTLOC)
PRINT 'STATUS= ' : STATUS
PRINT 'RESULT= ' : RESULT
PRINT 'RESULTLOC = ' : RESULTLOC
STOP
END

And here's what it shows:

> RUN USER-FORMS TEST.ENCRYPT

STATUS= 1
RESULT=
RESULTLOC = 1

What am I missing?


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UniVerse on Windows 2003 Server - Environment

2010-03-03 Thread Bill Haskett
When you experience the slowdown, check the Task Manager.  It is likely 
you'll see something bad there.  If not, you should get the 
"sysinternals" code "procmon" and "diskmon".  They'll help too, if the 
problem isn't with the CPU usage.


Actually, it's pretty interesting what one finds running on servers 
these days.  :-)


Bill


Mike Roosa said the following on 3/2/2010 5:37 AM:

There are a couple of other applications on that server and I did disable
MySQL yesterday.  The other one is NiceLabel but I can't just disable that
as we are using it to handle printing labels all day long.  The plan is to
start with MySQL and see if that helps. It's really no longer used (at least
that's what they tell us) but the service was still running.

Thanks.

On Mon, Mar 1, 2010 at 7:14 PM, Bill Haskett  wrote:

  





Mike:

You might look for things like SQL Server, Anti-Virus, and other software
that does things every day.  I've run into installations where SQL Server
was installed as some kind of administration tool.  Something fired off
every hour in SQL Server which brought to (almost) a complete halt telnet
responsiveness for several minutes.   Once this was identified, I had to
identify this since the administrator couldn't, and put off then
responsiveness was very acceptable.

Windows is very tricky when the dbms is loaded onto a multi-use server
(I'm sure the same is true in Linux/Unix).

HTH,

Bill


Mike Roosa said the following on 3/1/2010 10:50 AM:

  

We are running UniVerse on Windows 2003 Server in a virtualized
environment.
 99% of the time the system runs great and we have no issues, however,
about
once a day or every other day during the busiest time, we have a period
of
2-3 minutes where the server slows down and basically quits responding.
 Without us taking any action the system begins responding normally again
and we usually make it through that day without issue.

We typically have around 85 users on the system at one time sometimes
that
gets up closer to 95 or 100 but not often.  I have noticed certain
processes
that definitely cause the issue like running winmsd from the command line
or
renaming a directory on the server.  Since I know these processes cause
the
issue I don't do that during the day.  Obviously there are other
processes
that also can cause issues for us.

We have worked with our vendor and Rocket and the latest we've gotten
from
them is that our server is under-resourced.  While that very well could
be
true, we want to do a little more research first and reach out to other
Windows/UniVerse users to see what hardware they are running and if
anyone
is in a virtualized environment.

Any help we can get would be appreciated.

Thanks
Mike Roosa
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users




___
  

U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
  

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Examples of working ENCRYPT function?

2010-03-03 Thread Kevin King
Bob, I modified my routine to use the same values as your subroutine, and at
least on this Unidata box, still no love.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Examples of working ENCRYPT function?

2010-03-03 Thread Kevin King
I should also mention that the client has confirmed OpenSSL is on the box,
and I've tried the key both in plaintext (as shown) and also O-converted via
MX, same results.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Examples of working ENCRYPT function?

2010-03-03 Thread Kevin King
Here's my code to date:

*
* Test Encryption Program
*
ALGORITHM= 'rc4'
CRYPT.ACTION = 1
TEXT = 'THIS IS A TEST'
TEXT.LOC = 1
KEY  = 'ABCDEFG'
KEY.LOC  = 1
KEY.ACTION   = 1
SALT = ''
IV   = ''
RESULT   = ''
RESULTLOC= 1
STATUS = ENCRYPT(ALGORITHM, CRYPT.ACTION, TEXT, TEXT.LOC, KEY, KEY.LOC,
KEY.ACTION, SALT, IV, RESULT, RESULTLOC)
PRINT 'STATUS= ' : STATUS
PRINT 'RESULT= ' : RESULT
PRINT 'RESULTLOC = ' : RESULTLOC
STOP
END

And here's what it shows:

> RUN USER-FORMS TEST.ENCRYPT

STATUS= 1
RESULT=
RESULTLOC = 1

What am I missing?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] AUTOLOGOUT

2010-03-03 Thread Caminiti, Marc
Have a quick couple of questions on the AUTOLOGOUT function.   This is
on Red Hat Enterprise Server 5.3, Universe 10.2.7.  Is the AUTOLOGOUT
function a global setting, or can we use this in just 1 account?  For
example, we have 2 accounts, PROD and DEV.  If we put AUTOLOGOUT 15 in
the DEV account, will those people that go to the DEV account be the
only ones affected by it?  Also, if we have a select or program that is
running that takes greater than the "15" minutes in the AUTOLOGOUT, will
it kill the process, or wait until it is finished, then start the 15
minutes idle time?

 

Thanks in advance

marc

 

Marc Caminiti

IS Manager

Nashbar Direct, Inc

6103 State Route 446

Canfield, OH 44406

330.533.1989, ext 336

330.702.9733, fax

 

All generalisations are dangerous, even this one.

 



CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain 
confidential information that is legally privileged. The information is solely 
for the use of the intended recipient(s). Any disclosure, copying, 
distribution, or other use of this information is strictly prohibited. If you 
have received this e-mail in error, please notify the sender by return e-mail 
and delete this message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Examples of working ENCRYPT function?

2010-03-03 Thread Kevin King
Larry: This is a customer box, and I don't know if it's there or not, but
I'll check.  It has to have OpenSSL to work?

Bob: So is it true the KEY has to be in hex?  I knew the IV and salt were
hex but ... the key also?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UD] Enable Break Key From Separate Port

2010-03-03 Thread Wally Terhune
$UDTBIN/udtbreakon
Haven't played with this in decades...

>From the UniData Commands Reference:
udtbreakon
Syntax
udtbreakon pid
Description
The system-level udtbreakon command enables the interrupt key from another 
port. With this capability, users can enter the UniBasic debugger to terminate 
a program that may be stuck in a loop. pid represents the udt process id on 
another port for which you enable the interrupt key.
Use this command at the system prompt, or use the ECL ! (bang) command to 
execute this command from the ECL (colon) prompt.Tip: Use the LISTUSER command 
to find the process ID for which you intend to enable the interrupt key. The 
process ID for the UniData session is shown in the USRNBR column.
Related Commands
ON.BREAK, PTERM -BREAK ON

Wally Terhune
U2 Support Architect
Rocket Software
4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA
Tel: +1.720.475.8055
Email: wterh...@rs.com
Web: www.rocketsoftware.com/u2


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Wednesday, March 03, 2010 9:55 AM
To: U2 Users List
Subject: [U2] [UD] Enable Break Key From Separate Port

This will likely get me branded as a crackpot (like it wasn't already a
question?) but is there a way on Unidata (from version 6-->) to enable the
break key from a remote port?  Here's the situation:

I have some customers that disable the break key for everyone who logs in.
I, of course, forget about this until AFTER launching a report that takes
for-freakin'-ever to run.  At that moment, I would sincerely love to be able
to enable the break key on that port.

Possible?

-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Spectrum

2010-03-03 Thread Kevin King
Spectrum is just over a month away.  Who's in?

-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UD] Enable Break Key From Separate Port

2010-03-03 Thread Kevin King
This will likely get me branded as a crackpot (like it wasn't already a
question?) but is there a way on Unidata (from version 6-->) to enable the
break key from a remote port?  Here's the situation:

I have some customers that disable the break key for everyone who logs in.
I, of course, forget about this until AFTER launching a report that takes
for-freakin'-ever to run.  At that moment, I would sincerely love to be able
to enable the break key on that port.

Possible?

-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UniVerse on Windows 2003 Server - Environment

2010-03-03 Thread Holt, Jake
Have you checked the physical server itself to make sure there are no
resource intensive events around the time it fails?  One of our EDI
applications services running in a virtual server will hang when a
backup/hardware intensive event is triggered on the physical server.

I am glad to hear you guys are having success with UniVerse on a virtual
server, we're planning on moving to a virtual environment this year
(probably a 2003 virtual server running on a physical 2008 server).



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Roosa
Sent: Tuesday, March 02, 2010 7:38 AM
To: U2 Users List
Subject: Re: [U2] UniVerse on Windows 2003 Server - Environment

There are a couple of other applications on that server and I did
disable
MySQL yesterday.  The other one is NiceLabel but I can't just disable
that
as we are using it to handle printing labels all day long.  The plan is
to
start with MySQL and see if that helps. It's really no longer used (at
least
that's what they tell us) but the service was still running.

Thanks.

On Mon, Mar 1, 2010 at 7:14 PM, Bill Haskett 
wrote:

>
>
>
>
>> Mike:
>>
>> You might look for things like SQL Server, Anti-Virus, and other
software
>> that does things every day.  I've run into installations where SQL
Server
>> was installed as some kind of administration tool.  Something fired
off
>> every hour in SQL Server which brought to (almost) a complete halt
telnet
>> responsiveness for several minutes.   Once this was identified, I had
to
>> identify this since the administrator couldn't, and put off then
>> responsiveness was very acceptable.
>>
>> Windows is very tricky when the dbms is loaded onto a multi-use
server
>> (I'm sure the same is true in Linux/Unix).
>>
>> HTH,
>>
>> Bill
>>
>>

>> Mike Roosa said the following on 3/1/2010 10:50 AM:
>>
>>> We are running UniVerse on Windows 2003 Server in a virtualized
>>> environment.
>>>  99% of the time the system runs great and we have no issues,
however,
>>> about
>>> once a day or every other day during the busiest time, we have a
period
>>> of
>>> 2-3 minutes where the server slows down and basically quits
responding.
>>>  Without us taking any action the system begins responding normally
again
>>> and we usually make it through that day without issue.
>>>
>>> We typically have around 85 users on the system at one time
sometimes
>>> that
>>> gets up closer to 95 or 100 but not often.  I have noticed certain
>>> processes
>>> that definitely cause the issue like running winmsd from the command
line
>>> or
>>> renaming a directory on the server.  Since I know these processes
cause
>>> the
>>> issue I don't do that during the day.  Obviously there are other
>>> processes
>>> that also can cause issues for us.
>>>
>>> We have worked with our vendor and Rocket and the latest we've
gotten
>>> from
>>> them is that our server is under-resourced.  While that very well
could
>>> be
>>> true, we want to do a little more research first and reach out to
other
>>> Windows/UniVerse users to see what hardware they are running and if
>>> anyone
>>> is in a virtualized environment.
>>>
>>> Any help we can get would be appreciated.
>>>
>>> Thanks
>>> Mike Roosa
>>> ___
>>> U2-Users mailing list
>>> U2-Users@listserver.u2ug.org
>>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>>
>>>
>> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Microsoft SQL Server Driver Support

2010-03-03 Thread jpb-u2ug
The U2 team at Rocket Software announces a renewed focus on improving SQL
interfaces to the UniData and UniVerse data servers.


Microsoft SQL Server Driver Support


Starting with the November release of UniData on Windows, the Rocket U2 team
will deliver and support the Microsoft SQL Server driver for External
Database Access (EDA) on Windows platforms. The same driver is available now
in the Early Adopter release of UniVerse 11.

To obtain the SQL Server driver for EDA, contact u2as...@rs.com. Please tell
us what database you're using when you do so. External Database Access (EDA)
is required in order to use the SQL Server Driver. EDA is available for
Workgroup and Server edition and is included with Enterprise edition of the
databases.


Common Mapping Tool and Schema Generator


In addition, we are in the early planning stages for an improved, common
mapping tool and schema generator for fully describing the U2 data model in
order to generate SQL and EDA schemas. This new tool will provide a modern,
extensible interface for both initial mapping as well as updating of
schemas. This tool, with its associated APIs, will improve deployment of ISV
solutions to end customer sites thereby saving time and speeding time to
market.

This tool will be available with UniVerse 11.1 and in a UniData 7.3 release
to follow.

 

Jerry Banker

UV Project Leader

Senior Programmer Analyst

IBM Certified Solutions Expert

Administration and Development

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Interesting interview with Susie

2010-03-03 Thread Brian Leach
All
 
Here is an interesting interview with Susie about how things are now with U2
and Rocket. 
It's given by Elkie Holland of Prospectus:
 
http://www.prospectus.co.uk/t/SusieSiegesmundMarch10.htm
 
Brian
 
 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users