{Blocked Content} RE: {Blocked Content} RE: [U2] UD: Using indexes in UniQuery

[colin.alfke]

Warning: This message has had one or more attachments removed
Warning: (not named).
Warning: Please read the "AngelicHost-Attachment-Warning.txt" attachment(s)
for more information.

That is strange. I only have a couple of other ideas:
1. try !GUIDE GLPOST -O to see what it thinks of the file. Perhaps a different
block size would help.
2. I'm betting that index is huge. Perhaps it's the overhead of Windows
looking at such a large file. What if you removed the large index and simply
tried an index on clientno? You could also try adding the clientno index
before removing your other large index. Just to see.
3. Check the release notes - perhaps there is an issue with indices in your
version
4. Contact IBM support - that's why you're paying them the big bucks :-)

hth
Colin Alfke
Calgary Canada




From: Bill Haskett

Colin:

There's something wrong here.  Here's what I get when I do some selects:

A non-indexed select.

4 Demo (0)-> .X3-1
TIME
13:29:28 Aug 16 2007

SELECT GLPOST WITH CLIENTNO = "605"

33137 records selected to list 0.

TIME
13:29:33 Aug 16 2007

4 Demo (0)>> CLEARSELECT


Supposedly an indexed select.

4 Demo (0)-> .X2,4,2
TIME
13:30:40 Aug 16 2007

SELECT GLPOST WITH INDEX_2 = "0605]"

33137 records selected to list 0.

TIME
13:30:57 Aug 16 2007

4 Demo (0)>> CLEARSELECT


So, I deleted the index and recreated (and rebuilt) them.  Then I tried again
running
all the commands one right after another:

4 Demo (0)-> .X9,11,9,8,9,10,9,8
TIME
13:38:16 Aug 16 2007

SELECT GLPOST WITH CLIENTNO = "605"

33137 records selected to list 0.

TIME
13:38:21 Aug 16 2007

CLEARSELECT
TIME
13:38:21 Aug 16 2007

SELECT GLPOST WITH INDEX_2 = "0605]"

33137 records selected to list 0.

TIME
13:38:38 Aug 16 2007

CLEARSELECT
4 Demo (0)->


As you can see, the supposed index select is significantly slower than the
regular
select.  Checking the file I get:

4 Demo (0)-> FILE.STAT GLPOST

 13:40:07 Aug 16 2007
FILE   MOD OV HTY   ITEMS   BYTES MNI/G MXI/G MNB/I MXB/I
GLPOST   20543 1494   0 1227419 113228292 16455
137

   ------ ---
 220371227419 113228292


...so I don't think it is a file issue.

This appears to be a pretty significant problem.  I didn't really notice this
during
the six months of testing because the machine was so fast, as is UD.  But now,
in
production, we're getting some slowness the users are noticing.

Bill
This is a message from the MailScanner E-Mail Virus Protection Service
--
The original e-mail attachment "winmail.dat"
was believed to be infected by a virus and has been replaced by this warning
message.

If you wish to receive a copy of the *infected* attachment, please
e-mail helpdesk and include the whole of this message
in your request. Alternatively, you can call them, with
the contents of this message to hand when you call.

At Thu Aug 16 22:23:29 2007 the virus scanner said:
   Could not parse Outlook Rich Text attachment

Note to Help Desk: Look on the AngelicHost MailScanner in
/home/virtual/site2/fst/var/spool/mail.quarantine/20070816 (message
l7H5NO0J010250).
--
Postmaster
MailScanner thanks transtec Computers for their support
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Sacred Licence Seat - A Challenge

[Jeff Marcos]

Why don't you investigate "device licensing"?

This allows users to have up to 10 connections per device while only
taking up one licence.



Regards,

Jeff Marcos





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee
Sent: Friday, 17 August 2007 12:23 PM
To: u2-users@listserver.u2ug.org
Cc: [EMAIL PROTECTED]
Subject: [U2] Sacred Licence Seat - A Challenge



Does anyone have a way to set one licence seat as sacred?







There are 15 users in the organization and 20 licences for UniVerse.

But users will open more than one session if they can.  We need one

licence always available for when an internet connection is made.







How do we keep one unused?



Is there a UniVerse setting that prevents a seat from being taken

locally?



Has someone out there done this?  Would you like to share the technique?







Any suggestions?











Jeffrey Lee

Senior Analyst/Programmer







IT Vision Australia Pty Ltd (ABN: 34 309 336 904)

PO Box 881, Canning Bridge WA 6153

Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153

P:  (08) 9315 7000F: (08) 9315 7088

W: http://www.itvision.com.au 

___







NOTICE : This e-mail and any attachments are intended for the

addressee(s) only and may

contain confidential or privileged material. Any unauthorised review,

use, alteration,

disclosure or distribution of this e-mail (including any attachments) by

an unintended recipient

is prohibited. If you are not the intended recipient please contact the

sender as soon as

possible by return e-mail and then delete both messages.

___

---

u2-users mailing list

u2-users@listserver.u2ug.org

To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Sacred Licence Seat - A Challenge {Unclassified}

[HENDERSON MIKE, MR]

Jef,

In the LOGIN Paragraph in VOC run a program that, if the number of users
logged in - in SYSTEM(35) - is more than the # sessions limit passed in
on the command line, and this is a TELNET login, then an information
screen is displayed, and the program chains "OFF".

The number is passed in on the command line, so you can change it on the
fly quite easily.
In your case, it would be one less than the number of licenses.



Regards


Mike


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee
Sent: Friday, 17 August 2007 2:23 p.m.
To: u2-users@listserver.u2ug.org
Cc: [EMAIL PROTECTED]
Subject: [U2] Sacred Licence Seat - A Challenge

Does anyone have a way to set one licence seat as sacred?



There are 15 users in the organization and 20 licences for UniVerse.
But users will open more than one session if they can.  We need one
licence always available for when an internet connection is made.



How do we keep one unused?

Is there a UniVerse setting that prevents a seat from being taken
locally?

Has someone out there done this?  Would you like to share the technique?



Any suggestions?





Jeffrey Lee
Senior Analyst/Programmer



IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning
Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA,
6153
P:  (08) 9315 7000F: (08) 9315 7088
W: http://www.itvision.com.au 
___

The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Sacred Licence Seat - A Challenge

[Hona, David S]

How are your users and the "internet connection" connecting to UV?
Telnet client, UVCS, etc?
What OS and UV version?

David


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee
Sent: Friday, August 17, 2007 12:23 PM
To: u2-users@listserver.u2ug.org
Cc: [EMAIL PROTECTED]
Subject: [U2] Sacred Licence Seat - A Challenge

Does anyone have a way to set one licence seat as sacred?



There are 15 users in the organization and 20 licences for UniVerse.
But users will open more than one session if they can.  We need one
licence always available for when an internet connection is made.



How do we keep one unused?

Is there a UniVerse setting that prevents a seat from being taken
locally?

Has someone out there done this?  Would you like to share the technique?



Any suggestions?





Jeffrey Lee
Senior Analyst/Programmer



IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning
Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA,
6153
P:  (08) 9315 7000F: (08) 9315 7088
W: http://www.itvision.com.au 
___



NOTICE : This e-mail and any attachments are intended for the
addressee(s) only and may
contain confidential or privileged material. Any unauthorised review,
use, alteration, disclosure or distribution of this e-mail (including
any attachments) by an unintended recipient is prohibited. If you are
not the intended recipient please contact the sender as soon as possible
by return e-mail and then delete both messages.
___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Sacred Licence Seat - A Challenge

[Jef Lee]

Does anyone have a way to set one licence seat as sacred?



There are 15 users in the organization and 20 licences for UniVerse.
But users will open more than one session if they can.  We need one
licence always available for when an internet connection is made.



How do we keep one unused?

Is there a UniVerse setting that prevents a seat from being taken
locally?

Has someone out there done this?  Would you like to share the technique?



Any suggestions?





Jeffrey Lee
Senior Analyst/Programmer



IT Vision Australia Pty Ltd (ABN: 34 309 336 904)
PO Box 881, Canning Bridge WA 6153
Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153
P:  (08) 9315 7000F: (08) 9315 7088
W: http://www.itvision.com.au 
___



NOTICE : This e-mail and any attachments are intended for the
addressee(s) only and may
contain confidential or privileged material. Any unauthorised review,
use, alteration,
disclosure or distribution of this e-mail (including any attachments) by
an unintended recipient
is prohibited. If you are not the intended recipient please contact the
sender as soon as
possible by return e-mail and then delete both messages.
___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] what files does a user have open

[Norman, David \(SAAS\)]

> Date: Wed, 15 Aug 2007 19:08:52 +
> From: [EMAIL PROTECTED]
> Subject: [U2] [UV] what files does a user have open
>
> Hi all,
>
> UV10.1.8
> PICK FORMAT
> HPUX 11
>
> How do I go about seeing what files a user has open?
>
> Thanks

>From your UniVerse home account:
PORT.STATUS PID  FILEMAP

David Norman
Senior Software Engineer
SA Ambulance Service
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
* fax +61 8 8271 4844
* [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: {Blocked Content} RE: [U2] UD: Using indexes in UniQuery

[Allen E. Elwood]

I've seen the same type of corruption of the x_ files.  In very early
releases we had to go to the os level to delete the x_ file and then copy
and rename *any* x_ from a different file to the desired file and
rebuild

However, I've never seen an index that would work from within a program that
would not work from a Uniquery...

Allen from HOT, Smokey and muggy SoCalUsa

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, August 16, 2007 12:39
To: u2-users@listserver.u2ug.org
Subject: RE: {Blocked Content} RE: [U2] UD: Using indexes in UniQuery


I knew the index dictionary was virtual - I was wondering if the
clientno etc were maybe translates or something else that that the
select query might use to invalidate the index. I think the only trouble
we ever had with UD indices what that it wasn't actually built - but
your list.index showed it as being built.

Never really had to test if the index was used - it was always way
faster. It would be interesting to know how long an un-indexed select
would take on the two boxes.

The only thing I've had to do with and index is delete and re-create it.
Make sure you DELETE-INDEX GLPOST ALL, then make sure the X_GLPOST file
has been removed. Then re-create and re-build the index - making sure no
one is accessing the file at the time. I have seen an index that was
created while the file was actively being updated do some strange
things.

hth
Colin Alfke
Calgary Canada
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: {Blocked Content} RE: [U2] UD: Using indexes in UniQuery

[Bill Haskett]

Colin:

There's something wrong here.  Here's what I get when I do some selects:

A non-indexed select.

4 Demo (0)-> .X3-1
TIME
13:29:28 Aug 16 2007

SELECT GLPOST WITH CLIENTNO = "605"

33137 records selected to list 0.

TIME
13:29:33 Aug 16 2007

4 Demo (0)>> CLEARSELECT


Supposedly an indexed select.

4 Demo (0)-> .X2,4,2
TIME
13:30:40 Aug 16 2007

SELECT GLPOST WITH INDEX_2 = "0605]"

33137 records selected to list 0.

TIME
13:30:57 Aug 16 2007

4 Demo (0)>> CLEARSELECT 


So, I deleted the index and recreated (and rebuilt) them.  Then I tried again 
running
all the commands one right after another:

4 Demo (0)-> .X9,11,9,8,9,10,9,8
TIME
13:38:16 Aug 16 2007

SELECT GLPOST WITH CLIENTNO = "605"

33137 records selected to list 0.

TIME
13:38:21 Aug 16 2007

CLEARSELECT
TIME
13:38:21 Aug 16 2007

SELECT GLPOST WITH INDEX_2 = "0605]"

33137 records selected to list 0.

TIME
13:38:38 Aug 16 2007

CLEARSELECT
4 Demo (0)->


As you can see, the supposed index select is significantly slower than the 
regular
select.  Checking the file I get:

4 Demo (0)-> FILE.STAT GLPOST

 13:40:07 Aug 16 2007
FILE   MOD OV HTY   ITEMS   BYTES MNI/G MXI/G MNB/I MXB/I
GLPOST   20543 1494   0 1227419 113228292 16455   
137

   ------ ---
 220371227419 113228292


...so I don't think it is a file issue.

This appears to be a pretty significant problem.  I didn't really notice this 
during
the six months of testing because the machine was so fast, as is UD.  But now, 
in
production, we're getting some slowness the users are noticing.

Bill

>-Original Message-
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] On Behalf Of 
>[EMAIL PROTECTED]
>Sent: Thursday, August 16, 2007 12:39 PM
>To: u2-users@listserver.u2ug.org
>Subject: RE: {Blocked Content} RE: [U2] UD: Using indexes in UniQuery
>
>I knew the index dictionary was virtual - I was wondering if the
>clientno etc were maybe translates or something else that that the
>select query might use to invalidate the index. I think the 
>only trouble
>we ever had with UD indices what that it wasn't actually built - but
>your list.index showed it as being built.
>
>Never really had to test if the index was used - it was always way
>faster. It would be interesting to know how long an un-indexed select
>would take on the two boxes.
>
>The only thing I've had to do with and index is delete and 
>re-create it.
>Make sure you DELETE-INDEX GLPOST ALL, then make sure the X_GLPOST file
>has been removed. Then re-create and re-build the index - 
>making sure no
>one is accessing the file at the time. I have seen an index that was
>created while the file was actively being updated do some strange
>things.
>
>hth
>Colin Alfke
>Calgary Canada
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: {Blocked Content} RE: [U2] UD: Using indexes in UniQuery

[colin.alfke]

I knew the index dictionary was virtual - I was wondering if the
clientno etc were maybe translates or something else that that the
select query might use to invalidate the index. I think the only trouble
we ever had with UD indices what that it wasn't actually built - but
your list.index showed it as being built.

Never really had to test if the index was used - it was always way
faster. It would be interesting to know how long an un-indexed select
would take on the two boxes.

The only thing I've had to do with and index is delete and re-create it.
Make sure you DELETE-INDEX GLPOST ALL, then make sure the X_GLPOST file
has been removed. Then re-create and re-build the index - making sure no
one is accessing the file at the time. I have seen an index that was
created while the file was actively being updated do some strange
things.

hth
Colin Alfke
Calgary Canada

-Original Message-
From: Bill Haskett

Colin:

The dictionary is virtual.  It's code is:

002: OCONV( CLIENTNO, 'MR%4' ) : YRMO_PSTD : OCONV( ACCTNO, 'MR%6' ) :
OCONV( @ID, 'MR%8' )

CLIENTNO, YRMO_PSTD, and ACCTNO are [D]irect dictionaries with no
conversions (just raw data).

How does one go about testing if indexing is used in a query?  I'm sure
it's not, for this query, because of the time differences between D3 (on
an old P-III) and UD (on a new Xeon); D3 being much faster on an index
select.

The output looks like:

060520030800307000583056

When I use a SETINDEX, READXFWD, READXBCK in BASIC I get to the top and
bottom instantaneously.  So, I'm thinking a SELECT using the index
should also be almost instantaneous for such a relatively small number
of items.

Thanks,

Bill

>-Original Message-
>From: colin.alfke
>
>Bill;
>
>Any chance that any of the parts of the index are translated or does a 
>subroutine call?
>
>I always had more trouble with D3 indices than with UD. We don't use 
>sort.type
>2 though. A quick test showed no difference though. I also liked the 
>thought that it may be trying to use a pattern match than a string.
>
>HTH
>Colin Alfke
>Calgary Canada
>
>
>
>From:  Bill Haskett
>
>
>>>
>>>I forgot to add:
>>>
>>>UD v7.1.9
>>>SORT.TYPE = 2  (forced to do this because of improper sorting in 
>>>SORT.TYPE 0)
>>>
>>>Bill
>>>  _
>>>
>>>From: Bill Haskett >>Sent: Wednesday, August 15, 2007 12:25 PM
>>>
>>>I'm having difficulty ensuring the indexes are used in UniQuery.  In 
>>>D3, if I do the
>>>following:
>>>
>>>26 Demo (0)-> SELECT GLPOST WITH INDEX_2 = "0605]"
>>>
>>>[4041] 21791 items selected.
>>>
>>>...it would always use the index if one existed.  I knew the
>>index was
>>>used because the selected message didn't include the " out of {n} 
>>>items." string appended to the end (e.g. "[404] 21791 items selected
>>out of 884083 items.").
>>>
>>>On an old P3 server, running D3, with 50 people on it, 512Mb memory 
>>>(shared by Linux), this took about 9 seconds.  On a new Intel Xeon 
>>>server, running UniData,
>>with
>>>5 people on it, 2Gb memory, Windows 2K3, this took about 19 seconds.
>>>
>>>In UniData, I notice some selects are taking significantly
>>longer than
>>>in D3.  I've properly indexed the file, I can test that
>>indexing works
>>>by using a BASIC program than does the usual SETINDEX, READXFWD, 
>>>READXBCK, etc.  The index looks
>>>like:
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] User activity - SOX compliance

[Bartman, George]

David wrote:

What exactly were you trying to do? The whole idea of putting remote
items and using a security subroutine was designed to be as transparent
as possible.

We didn't actually use remote items just changed the VOC items to use
our new programs.  We did this because we needed to compare the before
and after images and then write the differences to our audit log file.
We didn't think the remote pointer would work since we needed to do some
before and after work around the actual command.  Most of our problems
revolved around the COPY, COPYI, etc commands (we run PICK flavor
accounts).  Our application uses different syntaxes of all the commands
we need to monitor.  Needless to say we had difficulty programming for
all of them since some of what they use isn't even documented in the UV
manuals.  The software vendor also supports D3 sites so getting them to
change would also be "fun".  Also one more thing to note here is that we
only monitor our financial files, not everything, and we only care about
users in TCL that are going around the business application to make
changes.

I really appreciate all the help so far and I want to thank everyone for
all the replies.  They have given me some more ideas/options to pass
along to the director and VP types.

/begin rant/  I really wish I still worked for a private company /end
rant/

George Bartman
Lead UniVerse DBA
Omnicare, Inc.
Office: (614) 652-3288
E-Mail: [EMAIL PROTECTED]
 

-- NOTICE --
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material, the disclosure of which is governed by applicable law. 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 destroy the materials contained in this
message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: {Blocked Content} RE: [U2] UD: Using indexes in UniQuery

[Bill Haskett]

Colin:

The dictionary is virtual.  It's code is:

002: OCONV( CLIENTNO, 'MR%4' ) : YRMO_PSTD : OCONV( ACCTNO, 'MR%6' ) : OCONV( 
@ID,
'MR%8' )

CLIENTNO, YRMO_PSTD, and ACCTNO are [D]irect dictionaries with no conversions 
(just
raw data).

How does one go about testing if indexing is used in a query?  I'm sure it's 
not, for
this query, because of the time differences between D3 (on an old P-III) and UD 
(on a
new Xeon); D3 being much faster on an index select.

The output looks like:

060520030800307000583056

When I use a SETINDEX, READXFWD, READXBCK in BASIC I get to the top and bottom
instantaneously.  So, I'm thinking a SELECT using the index should also be 
almost
instantaneous for such a relatively small number of items.

Thanks,

Bill

>-Original Message-
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] On Behalf Of 
>[EMAIL PROTECTED]
>Sent: Wednesday, August 15, 2007 10:00 PM
>To: u2-users@listserver.u2ug.org
>Subject: {Blocked Content} RE: [U2] UD: Using indexes in UniQuery
>
>Warning: This message has had one or more attachments removed
>Warning: (not named).
>Warning: Please read the "AngelicHost-Attachment-Warning.txt" 
>attachment(s)
>for more information.
>
>Bill;
>
>Any chance that any of the parts of the index are translated or does a
>subroutine call?
>
>I always had more trouble with D3 indices than with UD. We 
>don't use sort.type
>2 though. A quick test showed no difference though. I also 
>liked the thought
>that it may be trying to use a pattern match than a string.
>
>HTH
>Colin Alfke
>Calgary Canada
>
>
>
>From:  Bill Haskett
>
>
>>>
>>>I forgot to add:
>>>
>>>UD v7.1.9
>>>SORT.TYPE = 2  (forced to do this because of improper sorting in
>>>SORT.TYPE 0)
>>>
>>>Bill
>>>  _
>>>
>>>From: Bill Haskett >>Sent: Wednesday, August 15, 2007 12:25 PM
>>>
>>>I'm having difficulty ensuring the indexes are used in UniQuery.  In
>>>D3, if I do the
>>>following:
>>>
>>>26 Demo (0)-> SELECT GLPOST WITH INDEX_2 = "0605]"
>>>
>>>[4041] 21791 items selected.
>>>
>>>...it would always use the index if one existed.  I knew the
>>index was
>>>used because the selected message didn't include the " out of {n}
>>>items." string appended to the end (e.g. "[404] 21791 items selected
>>out of 884083 items.").
>>>
>>>On an old P3 server, running D3, with 50 people on it, 512Mb memory
>>>(shared by Linux), this took about 9 seconds.  On a new Intel Xeon
>>>server, running UniData,
>>with
>>>5 people on it, 2Gb memory, Windows 2K3, this took about 19 seconds.
>>>
>>>In UniData, I notice some selects are taking significantly
>>longer than
>>>in D3.  I've properly indexed the file, I can test that
>>indexing works
>>>by using a BASIC program than does the usual SETINDEX, READXFWD,
>>>READXBCK, etc.  The index looks
>>>like:
>This is a message from the MailScanner E-Mail Virus Protection Service
>--
>The original e-mail attachment "winmail.dat"
>was believed to be infected by a virus and has been replaced 
>by this warning
>message.
>
>If you wish to receive a copy of the *infected* attachment, please
>e-mail helpdesk and include the whole of this message
>in your request. Alternatively, you can call them, with
>the contents of this message to hand when you call.
>
>At Wed Aug 15 21:46:42 2007 the virus scanner said:
>   Could not parse Outlook Rich Text attachment
>
>Note to Help Desk: Look on the AngelicHost MailScanner in
>/home/virtual/site2/fst/var/spool/mail.quarantine/20070815 (message
>l7G4kcx4003633).
>--
>Postmaster
>MailScanner thanks transtec Computers for their support
>---
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] User activity - SOX compliance

[D]

If you use our free Eclipse base editor called XLr8Editor, it will capture
the changes made to the programs, procs, paragraphs, and the like.  We will
be releasing a version of the XLr8Editor that will integrate with CVS
(version system) in next few months, so you won't have to think about your
changes.

On you files, you would have to add our subroutine call either as a trigger
on the files you are monitoring or change the programs to call it directly.
This subroutine captures the before and after images. With today's prices on
hard drivers have one or two 900 gig hard drives with this audit trail is
very economical.  We have web base tool for inquiring into the file and
rolling back changes, if need be.

Regards,
Doug
www.u2logic.com


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bartman, George
Sent: Wednesday, August 15, 2007 2:29 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] User activity - SOX compliance

All,



   I'm faced with a task of finding the means to monitor all user
activity that results in a database change.  Does anyone know of an
application that we can plug in to UniVerse to accomplish this?



We are running a mix of UniVerse releases mostly centered on 10.1.20 for
our HP/UX PA-RISC boxes and on 10.1.24 for our HP/UX itanium boxes.



Any help is greatly appreciated,



George Bartman

Lead UniVerse DBA

Omnicare, Inc.

E-Mail: [EMAIL PROTECTED]



-- NOTICE --
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material, the disclosure of which is governed by applicable law. 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 destroy the materials contained in this
message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] mvEnterprise to UniVerse Account Restore

[bpaige]

"Has anyone had experience with account restores from mvEnterprise to
UniVerse on AIX?"

Ross, We are in the middle of that conversion now.  We received a partial
tool from IBM, which we then modified to work with mvE.  We have a whole
procedure written to go with it, based on our environment.

Email me directly, and I can get you all of the info.

Brian

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

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
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] User activity - SOX compliance

[Stephen O'Neal]

George asked "We tried to modify the actual commands like COPY, ED, etc to 
replace
them with Remote items but our software vendor uses different syntaxes
for all the commands we wanted to monitor.  This we used in a limited
production test that had some less than desired results (read
catastrophic failure) that we had to pull out and are very leery to try
again."

Answer: Sentry from Fitzgerald & Long.  http://fitzlong.com/

At your service,
   Steve

   Stephen M. O'Neal
   U2 Lab Services Sales Specialist
   Information Management, IBM Software Group
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

SV: [U2] [UD7.1] [Solaris 9]SOAP calls

[bjorn.eklund]

Thanks Brian, 
It works!
Even though the solution had looked more appealing with SoapSetParameters...

stupid me thinking SOAP and XML was some kind of standard


Bjvrn Eklund 


-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Brian Leach
Skickat: den 16 augusti 2007 12:31
Till: u2-users@listserver.u2ug.org
Dmne: RE: [U2] [UD7.1] [Solaris 9]SOAP calls


Bjorn

The problem is that the remote service doesn't understand the way UniVerse
is qualifying the method.

The packet generated using SoapSetRequestParameters has the method name
qualified thus:

http://www.webserviceX.NET/";
soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/";>

That service only understands it as:

http://www.webserviceX.NET/";
soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/";>

I guess it's really a limitation on the remote service.

You can get round it the more painful way by using SoapSetRequestContent :

  ret = SOAPSetDefault("VERSION","1.1")
  IF ret <> 0 THEN
 STOP "FEL I SOAP SetDefault ":Ret
  END

  URL  = "http://www.webservicex.net/ConvertSpeed.asmx?wsdl";
  SoapAction   = "http://www.webserviceX.NET/ConvertSpeed";
  Method   = "ConvertSpeed"
  Timeout  = 3
  NameSpace= "http://www.webserviceX.NET/";

  Ret = SoapCreateRequest(URL, SoapAction, SoapReq)
  IF Ret <> 0 THEN
 STOP "FEL I SOAP REQUEST ":Ret
  END

  Content = \http://schemas.xmlsoap.org/soap/envelope/";
xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance";
xmlns:xsd="http://www.w3.org/1999/XMLSchema";>http://www.webserviceX.NET/";
soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/";>{SPEED}milesPerhourmetersPersecond\
  
  Content = Change(Content, "{SPEED}", 12)
  Ret = SoapSetRequestContent(SoapReq, Content, 1)
  
  IF Ret <> 0 THEN
 STOP "FEL I SOAP SetParam ":Ret
  END

  Ret = SoapSubmitRequest(SoapReq, Timeout, RespHeaders, RespData,
SoapStatus)
  IF Ret <> 0 THEN
 STOP "FEL I SOAP SubmitReq ":Ret
  END

  PRINT "Resp status : ":SoapStatus
  PRINT "Response headers : ":RespHeaders
  PRINT "Response data : ":RespData

Brian
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UD7.1] [Solaris 9]SOAP calls

[Brian Leach]

Bjorn

The problem is that the remote service doesn't understand the way UniVerse
is qualifying the method.

The packet generated using SoapSetRequestParameters has the method name
qualified thus:

http://www.webserviceX.NET/";
soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/";>

That service only understands it as:

http://www.webserviceX.NET/";
soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/";>

I guess it's really a limitation on the remote service.

You can get round it the more painful way by using SoapSetRequestContent :

  ret = SOAPSetDefault("VERSION","1.1")
  IF ret <> 0 THEN
 STOP "FEL I SOAP SetDefault ":Ret
  END

  URL  = "http://www.webservicex.net/ConvertSpeed.asmx?wsdl";
  SoapAction   = "http://www.webserviceX.NET/ConvertSpeed";
  Method   = "ConvertSpeed"
  Timeout  = 3
  NameSpace= "http://www.webserviceX.NET/";

  Ret = SoapCreateRequest(URL, SoapAction, SoapReq)
  IF Ret <> 0 THEN
 STOP "FEL I SOAP REQUEST ":Ret
  END

  Content = \http://schemas.xmlsoap.org/soap/envelope/";
xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance";
xmlns:xsd="http://www.w3.org/1999/XMLSchema";>http://www.webserviceX.NET/";
soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/";>{SPEED}milesPerhourmetersPersecond\
  
  Content = Change(Content, "{SPEED}", 12)
  Ret = SoapSetRequestContent(SoapReq, Content, 1)
  
  IF Ret <> 0 THEN
 STOP "FEL I SOAP SetParam ":Ret
  END

  Ret = SoapSubmitRequest(SoapReq, Timeout, RespHeaders, RespData,
SoapStatus)
  IF Ret <> 0 THEN
 STOP "FEL I SOAP SubmitReq ":Ret
  END

  PRINT "Resp status : ":SoapStatus
  PRINT "Response headers : ":RespHeaders
  PRINT "Response data : ":RespData

Brian
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Re: U2 Users Digest V1 #1808

[Russ DeWitt]

I will be out of the office on vacation Thursday 8/16 thru Friday 8/24.
During this time I will NOT have limited access to email. If you need to
contact me, please try me on my cell phone. 631 680-0691

Thanks,

Russ
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

SV: [U2] [UD7.1] [Solaris 9]SOAP calls

[bjorn.eklund]

Thanks Gerry,
I'll test this!

- adds namespace to method tags but not parameter tags
  Solution : add option to prefix parameter names with 'ns1:'

- uses incorrect enc/env prefixes for soap version 1.2
  Solution : always use version 1.1

- parameters exceeding 16K get trashed using SoapSetParameters
  Solution : create entire soap request ( xml ) and use
SoapSetRequestContent

- extract return value

Gerry
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Using callHttp POST with XML data.

[Symeon Breen]

Hi Stuart - I have run callhttp to post large xml data to webservices and had 
several running at the same time, but not using LIST TOXML we just generate the 
xml ourselves.


Rgds
Symeon

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: 16 August 2007 01:20
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Using callHttp POST with XML data.

I'm just wondering if anyone else has had any issues using callhttp() to
POST data (UV 10.0.7).
We have a process which does LIST TOXML and posts the several MB result
to a web service. I can reliably cause it to fail by running another
completely separate process which also does a LIST TOXML.
We're about to upgrade UV so it's not a big issue (if it goes away) but
I'm curious if anyone else has seen it happen and better yet found a
solution?
Cheers,
Stuart Boydell

 
**
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] User activity - SOX compliance

[Hona, David S]

You mentioned your replaced certain verbs with a remote items and that
it failed. 

What exactly were you trying to do? The whole idea of putting remote
items and using a security subroutine was designed to be as transparent
as possible. 


Regards,
David


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bartman, George
Sent: Thursday, August 16, 2007 7:34 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] User activity - SOX compliance

I guess I should have elaborated on the ideas we had any why we didn't
think they would work.  Here is what we tried and or thought about:

We tried to modify the actual commands like COPY, ED, etc to replace
them with Remote items but our software vendor uses different syntaxes
for all the commands we wanted to monitor.  This we used in a limited
production test that had some less than desired results (read
catastrophic failure) that we had to pull out and are very leery to try
again.

We are also a heavy user of UV/Net and the creation of triggers would
prevent us from using some of our toolset.

Before we tried something ourselves again I was asked to see if a vendor
has something specifically for this.  I didn't see anything good on the
U2 business partner list so I figured I'd post the request here.

George Bartman
Lead UniVerse DBA
Omnicare, Inc.
Office: (614) 652-3288
E-Mail: [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/