SV: [U2] mv.net versus Web DE
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
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
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
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
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
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
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]
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}
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]
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
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 ?
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 ?
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
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
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
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
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
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
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?
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
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
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
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
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
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/