SV: [U2] mv.net versus Web DE

2007-11-29 Thread bjorn.eklund
Hi Martin,
we have switched from RedBack to mv.net. We gained performance and lowered our 
costs a bit.
Contact med off list if you want more details.

Bjvrn Eklund 

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Martin Hutchinson
Skickat: den 29 november 2007 15:26
Till: u2-users@listserver.u2ug.org
Dmne: [U2] mv.net versus Web DE


Hi,

Has anyone out there made comparisons between the different internet to 
U2 linking technologies? The 2 main ones appear to be Web DE (Redback as 
was) and mv.net (Uniobjects.net and connection pooling?), although I am 
sure there are others out there and if so I would like to hear about 
them. Any opinions on costs, useability etc would be welcome,

-- 
Martin Hutchinson
Technical Consultant
email : [EMAIL PROTECTED]


Web Control (UK) Ltd
Atlantic House,
Michigan Drive,
Tongwell,
Milton Keynes,
MK15 8HQ

T: +44(0)1908 216700 x4
F: +44(0)1908 216300

http://www.webcontrolltd.co.uk

Web Control (UK) Ltd is a company registered in England and Wales with company 
number 4118558. VAT number: 770 3363 38
---
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/


SV: [U2] U2 Silliness from a vendor

2007-11-26 Thread bjorn.eklund
Never heard of any other logs than RFS. (The Sun tech lives in the new 
millenium.)

Bad thing that RFS isn't mandatory when installing Unidata.

Bjvrn Eklund 

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Jeffrey Butera
Skickat: den 26 november 2007 15:02
Till: u2-users@listserver.u2ug.org
Dmne: [U2] U2 Silliness from a vendor


We've been having performance problems as of late which have been tracked down 
to disk IO.  When I was talking with our hardware vendor, he had one of his 
Sun techs with him where we had the following exchange:

Sun tech: Because of the inherent difference of random and sequential you want 
to ensure your archive/redo logs are on a different mount then your database 
files.

Me: Oh - we're not on Oracle.

Sun tech: Whatever the database, you've got archive/redo logs.

If we're not using RFS, can someone confirm that Unidata really doesn't have 
archive/redo logs - or am I just clueless.  I've been wrong before...

-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

"That's why you have two ears and one mouth - 
   use them accordingly." Mike Golic
---
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/


SV: [U2] Internal Cache in Unidata

2007-09-25 Thread bjorn.eklund
Jeff,
we are on Solaris 9 and Unidata 7.1.8 as well. We had huge performance 
improvment in overall performance when we raised the EXPBLKSIZE parameter in 
the udtconfig file. Unidata uses this buffer as a kind of cache if I understand 
it correct.

My 50 cent
Bjorn Eklund 

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Jeffrey Butera
Skickat: den 24 september 2007 19:01
Till: u2-users@listserver.u2ug.org
Dmne: Re: [U2] Internal Cache in Unidata


> It's interesting to note that your second of three queries changes
> drastically during the second invocation while the others remain the same.
>  Without knowing anything about your files or the dictionary items
> involved, I'm going to guess that XCDD.DIV involves one or more file
> translates. 

Nope.  For all three of those queries the fields are Data, single valued and 
indexed.  That's why I'm looking at this...



-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

"But Mom - Daddy knows everything."
Catherine Butera
---
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] [UD] [Solaris] Encrypt with RC5 algorihtm

2007-08-22 Thread bjorn.eklund
Hi all,
we have had a problem with the Unibasic ENCRYPT command when upgrading Unidata
from version 6.1.10 to 7.1.2.
The decryption stopped working after that we upgraded. Our program was unable
to display the correct data after the upgrade when we tried to decrypt.

We had to copy all encrypted data back to an old 6.1.10 version of Unidata to
be able to decrypt it. Then we could copy the unencrypted data back to the
server with 7.1.2 and encrypt the data again. Then everything worked fine.

Our investigations has found that the RC5 algorithm we are using has been
removed from the Unidata manual in version 7. It still works though. Does
anyone know what IBM has done and do you recommend us to change the RC5
algorithm to another?

TIA

Bjvrn Eklund
---
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

2007-08-16 Thread 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/


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

2007-08-16 Thread 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/


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

2007-08-14 Thread bjorn.eklund
Hi,
I'm evaluating the webservice api in Unidata. I've succesfully masterd the GET 
and POST methods but not the SOAP method. I've tried both to build the XML 
manually(SoapSetRequestContent) and SoapSetParameters with the same result.

The code looks like this:

  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"
  MethodParams = 
"Speed":@VM:"12":@VM:"xsd:double":@AM:"FromUnit":@VM:"milesPerhour":@AM:"ToUnit":@VM:"metersPerSecond"
  Timeout  = 3
  NameSpace= "http://www.webserviceX.NET/";

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

  Ret = SoapSetParameters(SoapReq, NameSpace, Method, MethodParams)
  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

The response header I get looks like this:
Connection}close~Date}Tue, 14 Aug 2007 07:31:06 GMT~Server}Mi
crosoft-IIS/6.0~X-Powered-By}ASP.NET~X-AspNet-Version}1.1.4322~Cache-Control}pri
vate, max-age=0~Content-Type}text/xml; charset=utf-8~Content-Length}369

The response data I get looks like this: 
http://schemas.xmlsoap.org/soap/envelope/"; xmlns:xsi="http://www.w3.org/2001/XM
LSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema";>http://www.webserviceX.NET/";>0

Anyone that uses this that can find my bug?

Thanks in advance
Bjvrn Eklund 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


SV: [U2] [UD 7.1] [Solaris 9]

2007-08-10 Thread bjorn.eklund
Thanks Tim and Brian,
We will have to go with the copy record by record as it seems.

Bjvrn Eklund 


-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Timothy Snyder
Skickat: den 9 augusti 2007 16:32
Till: u2-users@listserver.u2ug.org
Dmne: Re: [U2] [UD 7.1] [Solaris 9]


> I 'd like to
> copy 10 files from our production server to our test server. The problem 
is
> that NFA doesn't allow me to use the ECL command COPY

I've seen NFA users write their own copy utilities in UniBasic.  It really 
isn't any less efficient than the COPY command, since your bottleneck will 
be on the network more than anything you're doing on the hosts.  I 
envision a cataloged program called something like NFA.COPY that can take 
the same command-line parameters as the standard COPY command.  Naturally, 
you could work off of saved lists, and all of that good stuff.


> We are also implementing RFS so we can't use unix copy.

And you're right about recoverable files under RFS - please don't copy 
them at the UNIX level!  :-)  Actually, I'm not a fan of using O/S 
commands to copy database files unless it's done in a very controlled 
fashion.  And even then...

Tim Snyder
Consulting I/T Specialist
U2 Lab Services
Information Management, IBM Software Group
---
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/


SV: [U2] Large-scale scanner / OCR devices and interfaces to UniVerse {Unclassified}

2007-08-09 Thread bjorn.eklund
We have a product from Readsoft (www.readsoft.se) that scans invoices and 
converts these into a predefined file interface.

Bjvrn Eklund 

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] HENDERSON MIKE, MR
Skickat: den 9 augusti 2007 11:15
Till: u2-users@listserver.u2ug.org
Dmne: [U2] Large-scale scanner / OCR devices and interfaces to UniVerse
{Unclassified}


Folks,

We have some process improvement people who are keen to reduce manual
key-boarding effort by setting up some large-scale scanner / OCR devices
and interfacing them to our UniVerse systems.
[I'd rather avoid the paper forms altogether and get XML streams from
the document originators, but ...]

Anyone got any experience on this kind of gear?
I'm clueless about this (Google next, I guess), so ideas on brand names
etc would be helpful.

Thanks


Mike
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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UD 7.1] [Solaris 9]

2007-08-09 Thread bjorn.eklund
Hi,
are there any NFA users out there that can help me with an issue? I 'd like to
copy 10 files from our production server to our test server. The problem is
that NFA doesn't allow me to use the ECL command COPY. I don't want to run
through every file copying record by record since that will take some time and
it's not a neat solution. We are also implementing RFS so we can't use unix
copy. Does anyone have a way to solve this I'd be glad.

TIA

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


SV: [U2] UO.Net & Connection Pooling

2007-06-19 Thread bjorn.eklund
mv.net has it's own connection pooling, it doesn't use the built in connection 
pooling in the u2 products.

Bjvrn Eklund 


-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Hona, David S
Skickat: den 19 juni 2007 09:35
Till: u2-users@listserver.u2ug.org
Dmne: RE: [U2] UO.Net & Connection Pooling


Oops, pressed ENTER too soon, does your config file look something like
this? (Just checking!!)







Regards,
David


-Original Message-
From: Hona, David S 
Sent: Tuesday, June 19, 2007 5:21 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] UO.Net & Connection Pooling

 
I suppose the question is: does mv.NET use the Connection Pooling
mechanism. To which documentation do you refer to? If it is the UO.NET
documentation, then I guess it refers to you adding a reference to
UODOTNET, for it to work?



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Saturday, June 16, 2007 4:37 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UO.Net & Connection Pooling

I'm trying to figure out how to use UO.NET's connection pooling
mechanism.  I'm using mv.NET, which uses UO.NET as a connection method.
I've purchased a "Connection Pooling" license for UD v7.1.9 (Windows).
According to the documentation, "The following illustrates a
configuration file for connection pooling.  This configuration file is
named either app.config or web.config."
 

  

  
  






  
  

  

 
When I include this section of code into the .NET "web.config" file my
project won't compile due to "" being an "Unrecognized
configuration section."  I'm wondering if anyone can explain how all
this works together (and how to use it).
 
Thanks,
 
Bill
---
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-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


SV: [U2] Single Signon for U2 - Identity Management ?

2007-04-20 Thread bjorn.eklund
Sorry Baker, I have no experience with this. I 've just heard a sales person 
from Sun raising it to the skys.

Bjvrn Eklund 


-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Baker Hughes
Skickat: den 19 april 2007 20:46
Till: u2-users@listserver.u2ug.org
Dmne: RE: [U2] Single Signon for U2 - Identity Management ?


Thanks Bjorn,

Do you have any experience with this, with a MV DB server? 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, April 19, 2007 10:02 AM
To: u2-users@listserver.u2ug.org
Subject: SV: [U2] Single Signon for U2 - Identity Management ?

Sun has the Sun java System Identity Manager.

http://catalog.sun.com/productinfo.xml?site=SE_SWE&catalogue=FC&segment=
FC_R&item=FC_SC_CAT&group=2014&fid=5136&id=13394



-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Baker Hughes
Skickat: den 19 april 2007 15:49
Till: u2-users@listserver.u2ug.org
Dmne: [U2] Single Signon for U2 - Identity Management ?


You know how when you go to bed sometimes and your brain keeps thinking
about some problem...

I've been thinking this isn't possible in U2 environment, but sometime
during the night I resolved to ask the question.

Does anyone know of an Identity Management Suite that is U2 aware?  This
data security issue represents the next frontier for programmers, for
solution providers, for network analysts.  Who is the frontiersman in
the U2/MV space?

What we need - single signon and immediate access to those systems,
servers, storage that your identity allows.  Whatever you don't have
rights to, you can't see (an old Novell concept that Microslop still
doesn't get).

Does anyone know about an IDM solution that interoperates with the major
*nix OS's that U2 is ported to?

Thanks for any guidance.

-Baker
---
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-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/


SV: [U2] Single Signon for U2 - Identity Management ?

2007-04-19 Thread bjorn.eklund
Sun has the Sun java System Identity Manager.

http://catalog.sun.com/productinfo.xml?site=SE_SWE&catalogue=FC&segment=FC_R&item=FC_SC_CAT&group=2014&fid=5136&id=13394



-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Baker Hughes
Skickat: den 19 april 2007 15:49
Till: u2-users@listserver.u2ug.org
Dmne: [U2] Single Signon for U2 - Identity Management ?


You know how when you go to bed sometimes and your brain keeps thinking
about some problem...

I've been thinking this isn't possible in U2 environment, but sometime
during the night I resolved to ask the question.

Does anyone know of an Identity Management Suite that is U2 aware?  This
data security issue represents the next frontier for programmers, for
solution providers, for network analysts.  Who is the frontiersman in
the U2/MV space?

What we need - single signon and immediate access to those systems,
servers, storage that your identity allows.  Whatever you don't have
rights to, you can't see (an old Novell concept that Microslop still
doesn't get).

Does anyone know about an IDM solution that interoperates with the major
*nix OS's that U2 is ported to?

Thanks for any guidance.

-Baker
---
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/


SV: [U2] Large Unidata Windows Sites

2007-04-05 Thread bjorn.eklund
Hi Dave, 
I can't see the number of users nor that they are on Universe for Windows. If 
you have any more background info feel free to contact me offline.

Regards
Bjorn

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Dave R
Skickat: den 4 april 2007 18:26
Till: u2-users@listserver.u2ug.org
Dmne: Re: [U2] Large Unidata Windows Sites


http://www-306.ibm.com/software/success/cssdb.nsf/CS/GWAN-6J62TV?OpenDocument
&Site=corp
oops its UniVerse!


Dave R

e Fax (815)4259364
P.O. Box 17811, Irvine CA 92623-7811

-- George Land <[EMAIL PROTECTED]> wrote:
We have a customer running 250 users on UniData on Windows, have been for
three or four years.  I wouldn't have a concern installing a 400 user system
on new hardware, obviously it depends a little on the application but I
wouldn't see it as a problem.

George


On 30/3/07 19:11, "Moderator" <[EMAIL PROTECTED]> wrote:

> REPOSTED FOR NON-MEMBER: Bjvrn Eklund <[EMAIL PROTECTED]>
>
> Hi there,
> I'm curious if there are any large sites running Unidata on Windows out
there.
> With large I mean sites with more than 400 concurrent users. We are on
Solaris
> today but have trouble getting staff with Unix competence these days so we
are
> looking onto the possibility of moving to Windows 2003.
>
> TIA
>
> Bjvrn Eklund
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/

George Land
Chairman & Technical Director
APT Solutions Limited





**
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email in error please notify us immediately on +44
(01952) 214000 or at [EMAIL PROTECTED] . Please delete and
destroy any copies in any format of this email you may have received in error.
The recipient should note that the views contained or expressed within this
correspondence do not necessarily reflect those of APT Solutions Limited , it
subsidiaries, affiliates or associates. This email and any attachments are not
guaranteed to be free from so-called computer viruses and it is recommended
that you check for such viruses before down-loading it to your computer
equipment. It is the responsibility of the recipient to ensure that the onward
transmission, opening or use of this message or any attachments will not
adversely affect their systems or data.

Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3
3AB

Registation Number:- 2228445

Place of Registration: England & Wales
**
---
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-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


SV: [U2] [UD]file size limit

2006-08-04 Thread bjorn.eklund
Thanks Martin!

Regards
Bjvrn Eklund

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Martin Phillips
Skickat: den 3 augusti 2006 15:46
Till: u2-users@listserver.u2ug.org
Dmne: Re: [U2] [UD]file size limit


Hi Bjorn,

Sequential files are limited to 2Gb in Unidata and UniVerse.


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
---
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] [UD]file size limit

2006-08-03 Thread bjorn.eklund
Hi,
we are experiencing problems when we try to process a flat file that is larger
than 2GB. We use the Openseq  command to open the file and readseq to read
each line in the file. Is there a limitation in Unidata on processing larger
files than 2 GB?

We are on Solaris 8 and Unidata 6.1

ulimit -a gives us

[EMAIL PROTECTED] # ulimit -a
core file size (blocks) unlimited
data seg size (kbytes)  unlimited
file size (blocks)  unlimited
open files  2048
pipe size (512 bytes)   10
stack size (kbytes) 8192
cpu time (seconds)  unlimited
max user processes  29995
virtual memory (kbytes) unlimited


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


SV: [U2] Unidata, Unirpc and Windows XP home

2006-07-25 Thread bjorn.eklund
Martin,
for Uniobject .net I happen to know that you have to put the uonet.dll filen in 
the WINNT\assebly catalog. I don't know if this will help you but perhaps...

Regards
Bjorn

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Martin Scholl
Skickat: den 25 juli 2006 20:42
Till: u2-users@listserver.u2ug.org
Dmne: [U2] Unidata, Unirpc and Windows XP home


Hi,
I installed Unidata 6.0 PE on my laptop and get everything working, telnet,
UniAdmin, database service, but cannot connect with UniObjects.

The error is 'failed failed to pass the message to the slave correctly'
In the Event viewer I see an error for UniObject call :'There are no defined
services'
Then there is an information in the event log:' the description for event ID
(1000) in source (Ardent Uni RPC service) is not there

Does anyone know what is going on?  I had this working fine before and then
my laptop had a hard drive crash.

 

Martin Scholl
Pres. HIPAAsuite
18910 New Hampshire Ave
Brinklow, MD 20862
Phone: 301-924-5537
Fax: 301-570-0139
[EMAIL PROTECTED]
www.HIPAAsuite.com
---
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/


SV: [U2] Newest UV UniDebugger

2006-04-05 Thread bjorn.eklund
I have a similar problem. I have a support case with IBM on this right now. 
I'll get back when I have a solution

Bjvrn Eklund

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] leslie chamberlin
Skickat: den 5 april 2006 21:48
Till: Nick Cipollina; [EMAIL PROTECTED];
u2-users@listserver.u2ug.org
Dmne: RE: [U2] Newest UV UniDebugger


I've had the same problem with both setting the breakpoint and setting a
watch.

-Original Message-
From: Nick Cipollina [mailto:[EMAIL PROTECTED] 

I'm referring to when I set a breakpoint on a variable.  I've also
noticed that if you have a breakpoint set on a line, and you hit a
subroutine before the breakpoint.  It will blow right by that too.

Thanks,
 
Nick Cipollina
---
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/


SV: [U2] [UV:Redback] Automatic Garbage Collection not running

2006-03-21 Thread bjorn.eklund
Hi Adrian,
we restart RedBack every night when we do a snapshot for a backup procedure. 
Since we started with this the problem disappeared.

Not a good solution, I know, but since Redback doesn't support dbpause(being 
able to read from the database when the database is paused) we need to turn it 
of when taking the snapshot and that automatically handles our garbage 
collection problem...


-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Womack, Adrian
Skickat: den 21 mars 2006 09:15
Till: U2-Users@listserver.u2ug.org
Dmne: [U2] [UV:Redback] Automatic Garbage Collection not running


We recently ran into a problem where the garbage collection (GC) process
would no longer run (our WWSTATE file contained over a million records!,
and the application response time was abysmal).

There is a control record VERSION in the file WWCONTROL which contains a
date & time that GC is next due to run.

The date field was set to zero (meaning everyday) and the time field was
set to 86397 (23:59:57). According to the WWLOG file, the last completed
run of GC was at 22:59:57 (GC was set to run at the default value of
every 60 minutes).

It seems to me that there is probably a bug in the redback code that
determines whether it is time to run GC or not.

If the process doesn't run in the three seconds between 23:59:57 and
midnight, then the current time will never be after 23:59:57 and
therefore GC won't run - this seems to be the case for us.

Has anyone else come across this problem? And what was your solution?
I've heard of someone setting up a cron job to tidy up the WWSTATE file.

I've altered the GC parameters to run every 1 day instead of every 60
minutes. Hopefully this will fix the problem as the VERSION control
record now contains an actual date (tomorrow) instead of zero.

AdrianW


DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the 
intended recipient, please advise us by return e-mail immediately, and delete 
the e-mail and any attachments without using or disclosing the contents in any 
way. The views expressed in this e-mail are those of the author, and do not 
represent those of this company unless this is clearly indicated. You should 
scan this e-mail and any attachments for viruses. This company accepts no 
liability for any direct or indirect damage or loss resulting from the use of 
any attachments to this e-mail.
---
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/


SV: [U2] Discussion list archives?

2006-03-20 Thread bjorn.eklund
Hi,
I have the same problem, I found another url though

use http://search.gmane.org/ and enter gmane.comp.db.u2.general in the In 
Group-field.

Bjvrn Eklund

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Andy Pflueger
Skickat: den 20 mars 2006 19:48
Till: Joey Walter
Kopia: U2-Users@listserver.u2ug.org
Dmne: Re: [U2] Discussion list archives?


> I find that I can no longer get any search results via the site that used to
> host the archives for this discussion list at
>
> http://www.indexinfocus.com/
>
> Am I clueless? - wait, don't answer that - LOL. Maybe there is some cool new
> browser setting in Windows XP Pro which I just recently upgraded to that is
> 'helping me' by preventing access to the results?

I, too, have not been able to search the mailing list archives hosted
by indexinfocus.com...noticed it last week in fact just didn't think
to bring the topic to life on the list.
---
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/


SV: [U2] [u2][ud] Poor select performance

2006-03-03 Thread bjorn.eklund
John, here are som example keys:

   80-022169
 2934-021083
 2876-067779
 2678-029637
   11-009619
   11-017780
   11-034102
 4733-007068
4776-8482879
 4776-997639
   11-001458
 4797-000849
 4797-041654
 2903-041820
7085-000907
 4761-092588
 4759-000206
 1311-003714
 2948-610630
 1330-008116
2896-2791389
 2678-943669
 2678-951830
 2678-959991
 2678-968152
 9623-041705
 1880-171193
 4751-006084
 2790-094243
 4788-001341
 1392-007447
 1392-015608
   11-025941
 4797-009010

The I-desc looks like this:
FAKT.FINR   I   FIELD(@ID,'-',1)   4R S

The index looks like this:
Alternate Key Index Details for File FAKT_REG   Page   1

File..  FAKT_REG
Alternate key length..  20
Node/Block size...  4K
OV blocks.  1 (1 in use, 0 overflowed)
Indices...  5 (3 D-type)
Index updates.  Enabled, No updates pending

Index-Name..  F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr
FAKT.FINR V  NumYes   Yes Yes  Yes S   FIELD(@ID,'-',1) 


I've tried the index with "no nulls" also.


Then I use the following selection criteria:

:SELECT FAKT_REG WITH FAKT.FINR = 66



Bjvrn Eklund
Anknytning: 2088


-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] John Jenkins
Skickat: den 16 februari 2006 15:23
Till: u2-users@listserver.u2ug.org
Dmne: RE: [U2] [u2][ud] Poor select performance


Bjvrn

You should aim for a key structure that avoids "overloading" a single key
value with records and at the same time gives you a good hit rate.

Typical problem areas (though not yours in this case) are keys of 0 and 1,
or with high numbers of null (empty) string entries.

If you can post some example keys and selection criteria used we will see if
we can optimise it for you. At the moment I suspect it will be a composite
key manipulated in a virtual - but let's see some samples first.

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 15 February 2006 17:27
To: u2-users@listserver.u2ug.org
Subject: SV: [U2] [u2][ud] Poor select performance

Hi JayJay,
I guess you meant that I should create an index on the @id field. The keys
look like this 66-112. I'm not sure if you say I should try:

SELECT A_FILE WITH @ID <= '66-01' AND @ID >= '66-999'
 
PErhaps this is not what you mean since it's difficult to tell if 66-012
is bigger than 66-013. I've tried it but with less performance than my
original i-descriptor index.

Bjvrn Eklund
---
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/


SV: [U2] [u2][ud] Poor select performance

2006-02-15 Thread bjorn.eklund
Hi JayJay,
I guess you meant that I should create an index on the @id field. The keys look 
like this 66-112. I'm not sure if you say I should try:

SELECT A_FILE WITH @ID <= '66-01' AND @ID >= '66-999'
 
PErhaps this is not what you mean since it's difficult to tell if 66-012 is 
bigger than 66-013. I've tried it but with less performance than my 
original i-descriptor index.

Bjvrn Eklund

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] John Jenkins
Skickat: den 10 februari 2006 20:12
Till: u2-users@listserver.u2ug.org
Dmne: RE: [U2] [u2][ud] Poor select performance


Try building an index on the whole filed and using a RANGE selection ...
i.e. >=  and <= 

Let us know how it goes - it may do the job. Remember to use no.dups and
no.nulls for a bit more pep

(pattern matches can't use the index)

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 10 February 2006 13:09
To: u2-users@listserver.u2ug.org
Subject: [U2] [u2][ud] Poor select performance

Hi there,
we are having very slow respone times on a select statement. We have a file
with a total of 5 million records in where the key is like -nn. The
first part() is a customer number(numeric) and the second part(nn)
is
a sequential no. We have created an i-descriptor on the customer number,
FIELD(@ID,'-',1). On this i-descriptor we have put an index:

Index-Name..  F-type K-type Built Empties Dups In-DICT S/M
F-no/VF-expr
FAKT.FINR V  NumYes   Yes Yes  Yes S
FIELD(@ID,'-',1)

Selecting a customer with 570 000 records can take 30 seconds.
(example of statement SELECT A_FILE WITH FAKT.FINR = 66)

Selecting other indexed values in the same file which gives me 5 records out
of the 5 million is very very fast.

I've tried to rebuild.index with no improvment in performance. The file
doesen't show any sign of level 2 overflow.

I am single user on a powerful Sun server with SAN disks. We are on Solaris
8
and Unidata 6.1.10.

Shouldn't it be faster than this? Perhaps this is normal and we have to take
another approach to get the data we need?

Thanks in advance!

Bjorn Eklund
Faktab Finans AB
---
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-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


SV: [U2] [u2][ud] Poor select performance

2006-02-15 Thread bjorn.eklund
Sorry, that didn't help...

Thanks anyway
Bjvrn Eklund

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Perry Taylor
Skickat: den 10 februari 2006 15:07
Till: u2-users@listserver.u2ug.org
Dmne: RE: [U2] [u2][ud] Poor select performance


My experience is with UniVerse but I suspect it would suffer from the
same thing.  It's likely the problem is the high number of records per
customer number.  You might try indexing the entire key then doing a
select on the customer number portion.  Something like this maybe (not
sure of the UniData syntax) ...

CREATE.INDEX A_FILE @ID
BUILD.INDEX A_FILE @ID

SELECT A_FILE WITH @ID LIKE 66-...

OR

SELECT A_FILE WITH @ID MATCHING "'66-'1N0N"

Perry Taylor
www.zirmed.com 



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, February 10, 2006 6:09 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [u2][ud] Poor select performance

Hi there,
we are having very slow respone times on a select statement. We have a
file with a total of 5 million records in where the key is like
-nn. The first part() is a customer number(numeric) and the
second part(nn) is a sequential no. We have created an i-descriptor
on the customer number, FIELD(@ID,'-',1). On this i-descriptor we have
put an index:

Index-Name..  F-type K-type Built Empties Dups In-DICT S/M
F-no/VF-expr
FAKT.FINR V  NumYes   Yes Yes  Yes S
FIELD(@ID,'-',1)

Selecting a customer with 570 000 records can take 30 seconds.
(example of statement SELECT A_FILE WITH FAKT.FINR = 66)

Selecting other indexed values in the same file which gives me 5 records
out of the 5 million is very very fast.

I've tried to rebuild.index with no improvment in performance. The file
doesen't show any sign of level 2 overflow.

I am single user on a powerful Sun server with SAN disks. We are on
Solaris 8 and Unidata 6.1.10.

Shouldn't it be faster than this? Perhaps this is normal and we have to
take another approach to get the data we need?

Thanks in advance!

Bjorn Eklund
Faktab Finans AB
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health Information, 
any communications containing such material will be returned to the originating 
party with such advisement noted. If you are not the intended recipient, please 
contact the sender by reply e-mail and destroy all copies of the original 
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/


SV: [U2] CC encrypting for unidata

2006-02-14 Thread bjorn.eklund
Dana,
have a look at ENCRYPT() and DIGESET() functions in the manual.

/Bjvrn

-Ursprungligt meddelande-
Fren: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Dana Baron
Skickat: den 14 februari 2006 22:39
Till: u2-users@listserver.u2ug.org
Dmne: [U2] CC encrypting for unidata


Anyone have or know of software to encrypt credit card numbers in Unidata.
(Probably someone has already asked this on this list - sorry)

Dana Baron
System Manager
Smugglers' Notch Resort
---
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] [u2][ud] Poor select performance

2006-02-10 Thread bjorn.eklund
Hi there,
we are having very slow respone times on a select statement. We have a file
with a total of 5 million records in where the key is like -nn. The
first part() is a customer number(numeric) and the second part(nn) is
a sequential no. We have created an i-descriptor on the customer number,
FIELD(@ID,'-',1). On this i-descriptor we have put an index:

Index-Name..  F-type K-type Built Empties Dups In-DICT S/M
F-no/VF-expr
FAKT.FINR V  NumYes   Yes Yes  Yes S
FIELD(@ID,'-',1)

Selecting a customer with 570 000 records can take 30 seconds.
(example of statement SELECT A_FILE WITH FAKT.FINR = 66)

Selecting other indexed values in the same file which gives me 5 records out
of the 5 million is very very fast.

I've tried to rebuild.index with no improvment in performance. The file
doesen't show any sign of level 2 overflow.

I am single user on a powerful Sun server with SAN disks. We are on Solaris 8
and Unidata 6.1.10.

Shouldn't it be faster than this? Perhaps this is normal and we have to take
another approach to get the data we need?

Thanks in advance!

Bjorn Eklund
Faktab Finans AB
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/