RE: InValid Characters
select the file save the list create a work file edit the list delete the invalid keys from the list save the list get the list copy file 1 to work file clear file 1 copy workl to file1 all if i understood the problem bob -Original Message- From: Brutzman, Bill [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 22:50 To: 'U2 Users Discussion List' Subject: InValid Characters When I issue the following LIST command, there is are apparent bad characters, ascii box drawing characters. How can I clear them ? The two characters show up a single box below. Thus far, I have had no luck using EditPlus, HP-Unix vi, UniVerse Edit Up-Arrow mode, or UV.VI. I tried the ascii equivalents of the box characters per... DELETE PS ^210^201 Record ID ^210^201 not found. 0 records DELETEd. DELETE PS ^210 Record ID ^210 not found. The records for @ID 103662 and 101393 appear to be clean. DELETE PS ^D2 Record ID ^D2 not found. 0 records DELETEd. DELETE PS ^D2^C9 Record ID ^D2^C9 not found. 0 records DELETEd. Suggestions would be appreciated. --Bill --- LIST PS D.PS.. 103662 101393 101312 D.PS. 103662 NEXT.COMP.PN. PREV.COMP.PN. 103661 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. NEXT.COMP.PN. PREV.COMP.PN. QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. 101393 NEXT.COMP.PN. PREV.COMP.PN. 103626 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UV secondary index
Hello, I have distributed UV file with total size about 2.5Gb. I made secondary index CREATE. INDEX file field1 ... field6 BUILD.INDEX file field1 ... field6 After that, rows inserting takes very long time. (4000 rows. Server so busy, that other users can't do anything. If I removed index then inserting process is OK, but I need this index for reporting) Is it normal in UniVerse? How to avoid this problem? I use UniVerse 9.5.2 on AIX 5.2 Thanks, Margus Kandelin -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV secondary index
Two tricks to speed things up ... Firstly, would the NO.NULLS keyword speed things up? I'm guessing your fields can often be blank, and in this case you will have a single huge record knocking your index for six! Secondly, would the pause and resume indexing commands work? During the day, while the users are working, you pause index updates. At the end of the day (or whenever you need to run the reports) you resume indexing. Okay, it'll knacker the system while it sorts out the indices, but it'll be one short, concentrated hit. The you run your reports, disable indexing again, and let the users at it ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 February 2004 09:23 To: [EMAIL PROTECTED] Subject: UV secondary index Hello, I have distributed UV file with total size about 2.5Gb. I made secondary index CREATE. INDEX file field1 ... field6 BUILD.INDEX file field1 ... field6 After that, rows inserting takes very long time. (4000 rows. Server so busy, that other users can't do anything. If I removed index then inserting process is OK, but I need this index for reporting) Is it normal in UniVerse? How to avoid this problem? I use UniVerse 9.5.2 on AIX 5.2 Thanks, Margus Kandelin -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: uvsql
a. yes b. no c. yes and no d. yes Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Sunday, February 08, 2004 8:53 AM To: 'U2 Users Discussion List' Subject: RE: uvsql Barry, Just to eliminate the obvious: A) is your file pointer correct in the uvsql account? B) are there any indexes on the file that may be looking at the wrong location? C) are the DATA.30 and OVER.30 files set up with the same permissions? Is there any chance you might not be seeing the OVER.30? D) your UNIX cp included the .Type30 file. Brian Leach - Original Message - From: Barry Rogen [EMAIL PROTECTED] Date: Fri, 6 Feb 2004 07:59:32 -0500 To: [EMAIL PROTECTED] Subject: uvsql Question... I have a file, my live ORDER (type 30) file. Via unix, I copy this file to my test account - copy is fine, all records there - no problem If I take that same file, and move it to my uvsql account, all I get is a fraction of the file. I have tried this twice and got same results. Any ideas why this occurs and how I can get this file into the uvsql directory/account intact ? All comments appreciated, Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail message from PNY Technologies, Inc. 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. 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 [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Standard Deviation
Is there a Universe Basic command to calculate standard deviation? If not, does anyone have a sub? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Joseph Baker/Columbus/IBM is out of the office.
I will be out of the office starting February 9, 2004 and will not return until February 10, 2004. I will be out of the office February 9. Please leave me a voice mail message at (614) 659-7457 if your message is urgent. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Wintegrate message box
You could do it if your application has a single piece of code that handles the input of data, in this area you could have it loop and check for a message that needed to pop up when not getting characters. You may also be able to tap into the windows messenger service to send messages to users (on windows platforms). -- Bryan Charlie Rubeor wrote: Does anybody know if it is possible to send a wintegrate pop-up box to a different user, from either a unibasic program or a shell script? Specifically, if Fred is trying to access a record, which is locked by Barney, is it possible to have a pop-up box appear on Barney's screen? Currently, we send an email to Barney, which does not work well if Barney does not have his email client open. This is just one example. Our users are currently thinking up several more applications where they would like to do this, if it is possible. tia Charlie Rubeor Unix/Database Admin The Wiremold Company 800.338.1315 x3498 860.523.3690 fax À votre service -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV command failing mystery
We upgraded our system from a 16 processor AV2 to an 8 processor AV25000. Because each block of 4 cpus can only support 4gb of memory our upgrade was going to cut our memory in half. So, the main purpose of the changes was to cut the memory requirements of the universe lock tables. And in fact we successfully cut the per user memory usage in half. The other changes were made as part of the overall review of both uv.config and the kernel parameters prior to the upgrade. Because several people suggested that the semaphore and/or shared memory changes could be the cause of the problem I had them changed back to their original values yesterday. So far we have not had a failure, but its a little too soon to celebrate. Thanks for the advice on using the trace. I was not able to pick out the system calls and before I make another attempt I think I will wait and see if the weekends changes fixed the problem. If the problem is solved I will post in case someone else runs in the same problem in the future. Thanks, Vance Dailey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ken Wallis Sent: Sunday, February 08, 2004 7:52 PM To: 'U2 Users Discussion List' Subject: RE: UV command failing mystery From: Vance Dailey It was suggested that I try to run dg_strace. I ran it on one of the failing uv processes. It generated a 1mb file. I can see where it executes uvsh and It fails just after the 7th occurance of RUN APP.PROGS PACKAGE.INS. (The 7th run is just after the string SPECIAL.EDITOR.SELECT.DATA\OLONG.) I have no idea how to read this file but I thought it might help identify where the error occurred. I have included the very end of the output of dg_strace below: ... close(3)= 0 sigaction_svr3(SIGQUIT, {...}, {...}) = 1253 sigaction_svr3(SIGNULL, {...}, {0xc0a0d, [XCPU XFSZ], SA_RESTART|SA_SIGINFO}) = 2130681856 ... This tool seems to be showing you the system calls that uvsh is making and the values returned from them (the bit after the =). The section you have shown is simply the program trying to tidy up and exit after detecting something it didn't like. You'll need to look higher up in the output for a system call which seems to return an error code. Unfortunately, you need to know what sort of system calls should return 0 all the time and which ones regularly return other values. I think I'd be looking at calls to sem...() or shm...() functions that return non-zero and then using errmsg (if DG/UX has that, or vi-ing /usr/include/sys/errno.h if it doesn't) to see what the error numbers returned mean and man to interpret from that where the problem lies. I can't remember the exact numbers you quoted earlier, but certainly with your user counts I'd be very suspicious of the reductions you made to the semaphore kernel parameters. Just as a matter of interest, why were these reductions made? HTH, Ken -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
the systems I work on don't have EDIT-LIST, and I never think to change the punctuation and try the revised form of the commands - I grew up on EDIT-LIST and SAVE-LIST, etc. The ECL parser should accept the dashed versions of these commands. Any chance you have a VOC entry (or something in the global catalog) for EDIT-LIST or EDIT.LIST that's getting in the way? Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
MBSII or Profi'C
(sorry, last message had no subject... Resending.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn W. Paschal Sent: Sunday, February 08, 2004 4:27 PM To: [EMAIL PROTECTED] Subject: (no subject) Hello, group! Can anyone tell me if they have used or are using a product called Profi'C from MBSII.net? (It's an accounting package for UV) If so, can you give me a general overview... pros/cons... likes/dislikes... etc? Thanks, Glenn W. Paschal PasTech LLC Computer Consulting ph. (931) 526-9631 fx. (931) 526-9678 email. mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] web. http://www.pastech.net/ www.pastech.net -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Secondary Indices on Distributed Files
I've got a Distributed File that I'm trying to create indices on. Four of the fields are D-Types, and CREATE.INDEX runs fine for them. Three fields though, are I-Types (that are compiled and working), where CREATE.INDEX gives the following error: I-descriptor must be compiled before execution. I-descriptor must be compiled before execution. I-descriptor must be compiled before execution. Program *UVPRINTMSG: pc = 34, Variable previously undefined. Zero length string used. [00] All seven fields are working just fine as indices on the original file that was a Static Hashed file. I'm setting up the Distributed File to get around the 2GB limit issues. Does anyone know of any limitations putting secondary indices onto distributed files? Thanks! Gary Canedy --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
Tim, Thanks - I just looked at CTLGTB and there is an entry there for both. EDIT-LIST looks like this: M 0 @UDTHOME/SYS_BP EDIT-LIST root EDIT.LIST looks the same, but has EDIT.LIST instead of EDIT-LIST. In UDTHOME, we have a sys directory, which contains a SYS_BP file, which contains EDIT.LIST and EDIT_LIST, not EDIT-LIST. Does this indicate that one of my predecessors on these systems was getting adventuresome, or is this standard issue? Susan M. Lynch F.W. Davison Company, Inc. - Original Message - From: Timothy Snyder [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, February 09, 2004 11:51 AM Subject: Re: InValid Characters the systems I work on don't have EDIT-LIST, and I never think to change the punctuation and try the revised form of the commands - I grew up on EDIT-LIST and SAVE-LIST, etc. The ECL parser should accept the dashed versions of these commands. Any chance you have a VOC entry (or something in the global catalog) for EDIT-LIST or EDIT.LIST that's getting in the way? Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Batch Mode Scanners
Background info: We are considering the purchase of some type of handheld scanner that will save our outside sales force the paper-pencil solutions they are currently using. Our idea is to have them enter a customer account number, then scan barcodes affixed to bins where our product is kept, then enter a number which represents an inventory adjustment. When they get back to their desk, they would plug the scanner in and hit a key and the data would be read off the scanner and processed by our business application. question for the list: What types of products are available which are easily setup and don't cost a first born child. The ones I've been familiar with in the past are Telxon and Intermec, but for real-time telnet connectivity we use Symbol (PDT3146us) technology. Any quick responses that point me in the right direction will be greatly appreciated. -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: using locate in compound true/false statement
Dangerous syntax this pick style locate. It ooks like a function but it isn't. Actually it is a statement with THEN ELSE clauses. Once you realise that it's crystal clear . You can't write IF READ ... and you can't write IF LOCATE() ... but you can write WHILE READ and WHILE LOCATE() as you can with any statement with an ELSE clause. /Mats Glenn W. Paschal wrote: Actually, LOOP WHILE LOCATE is incorrect syntax, and will fail on compilation. You have to use the PICK flavor of LOCATE to do this. Still, you are correct in that LOOP WHILE LOCATE() works fine, but IF LOCATE() THEN will not compile. A side note, TRUE.FALSE.FLAG = LOCATE() also will not compile. However, if instead of using IF LOCATE() THEN, you simply use LOCATE() THEN it will work. I realize you were venting, and I must agree in part that it would appear to present somewhat of an inconsistency, but I can more see why IF LOCATE() would not work, than I can tell you why WHILE LOCATE() does work. I would have expected neither to work. H snip- -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
I tried to respond a while ago, but my message came back with The message's content type was not explicitly allowed. I'll try a different cut-and-paste approach. Hopefully this isn't a duplicate for anybody snip Susan Lynch [EMAIL PROTECTED] Thanks - I just looked at CTLGTB and there is an entry there for both. EDIT-LIST looks like this: M 0 @UDTHOME/SYS_BP EDIT-LIST root EDIT.LIST looks the same, but has EDIT.LIST instead of EDIT-LIST. In UDTHOME, we have a sys directory, which contains a SYS_BP file, which contains EDIT.LIST and EDIT_LIST, not EDIT-LIST. snip Susan, That all looks like what I'm seeing on a system here, and both EDIT-LIST and EDIT.LIST work fine. What platform, UDT release, etc. are you working with? Just for giggles, it may be interesting to create a synonym VOC entry for EDIT-LIST that looks like this: 1: S 2: EDIT.LIST If that works, it may help track this down. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [ADMIN] The aforementioned and promised NAG about OVERQUOTING
If you are replying to several points, do not top-post. This one really should be: Don't Top-Post, especially if the reply is already Right Posted. Here's two links: http://www.netmeister.org/news/learn2quote.html http://www.greenend.org.uk/rjk/2000/06/14/quoting with some explanations of why Netiquette is the way is it. They're targeted for Usenet, but a mailing list suffers from all the standard Usenet problems, and has the additional disadvantage of not having Reference: headers to thread by. Hopefully folks will see the reasons behind interleaved replies and trimming posts. Otherwise Cliff might have to wield his moderator power more forcefully. Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 503-905-8153 (eFax)| .=. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help wanted creating an efficient SELECT statement
At 05:26 + 2004/02/06, Marco Manyevere wrote: Short and easy to follow but N is not always numeric. You can add a regular old variable to hold all of the prefixes, use a LOCATE() to find the field number of the prefix and then use that to access the array N. Going through all this, might just make the I-Type the way to go. How often do you expect to have to do this sort? Is it something that will run in a batch or is it a request that a user will be sitting there waiting for a response? Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 503-905-8153 (eFax)| .=. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
Tim, UD 6.0.6 (but, if I remember correctly, this was true on the release 5 that we came from as well, and our standard policy is to uninstall and re-install Unidata for a new release, which should have replaced CTLGTB). This being my first experience with the Unidata flavor, I thought it was standard behavior - annoying but standard. So, rather than set up what I thought was a non-standard synonym (and have to set up on all the customer machines as well, if one of my colleagues started using it), I was just avoiding editing lists. The synonym entry in the VOC does work as expected. Susan M. Lynch F.W. Davison Company, Inc. - Original Message - From: Timothy Snyder [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, February 09, 2004 1:41 PM Subject: Re: InValid Characters I tried to respond a while ago, but my message came back with The message's content type was not explicitly allowed. I'll try a different cut-and-paste approach. Hopefully this isn't a duplicate for anybody snip Susan Lynch [EMAIL PROTECTED] Thanks - I just looked at CTLGTB and there is an entry there for both. EDIT-LIST looks like this: M 0 @UDTHOME/SYS_BP EDIT-LIST root EDIT.LIST looks the same, but has EDIT.LIST instead of EDIT-LIST. In UDTHOME, we have a sys directory, which contains a SYS_BP file, which contains EDIT.LIST and EDIT_LIST, not EDIT-LIST. snip Susan, That all looks like what I'm seeing on a system here, and both EDIT-LIST and EDIT.LIST work fine. What platform, UDT release, etc. are you working with? Just for giggles, it may be interesting to create a synonym VOC entry for EDIT-LIST that looks like this: 1: S 2: EDIT.LIST If that works, it may help track this down. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Batch Mode Scanners
I've had success with Hand Held Product's Dolphin 7200 batch scanner. The Dolphin is a very small, lightweight unit. The C language compiler in their development kit is easy to use and the kit has several templates which can be used to create applications like you apparently need. The unit runs a micro-DOS system. The Post Office uses these, which is testimony to their ruggedness. http://www.hhp.com/hhp/products/product.tpl?prodsku=8211202246993 Have used Intermec products in the past and they also performed well. Programmed their old 9440 handhelds using the proprietary IRL code to develop applications - not sure what they're using now. At 10:01 AM 2/9/2004, Karl L Pearson wrote: Background info: We are considering the purchase of some type of handheld scanner that will save our outside sales force the paper-pencil solutions they are currently using. Our idea is to have them enter a customer account number, then scan barcodes affixed to bins where our product is kept, then enter a number which represents an inventory adjustment. When they get back to their desk, they would plug the scanner in and hit a key and the data would be read off the scanner and processed by our business application. question for the list: What types of products are available which are easily setup and don't cost a first born child. The ones I've been familiar with in the past are Telxon and Intermec, but for real-time telnet connectivity we use Symbol (PDT3146us) technology. Any quick responses that point me in the right direction will be greatly appreciated. -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- Kent Walker - Datatel Analyst Information Technology - U.C. Hastings College of the Law 415-565-4635 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: UV secondary index
Margus, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, 9 February 2004 10:23 p.m. To: [EMAIL PROTECTED] Subject: UV secondary index Hello, I have distributed UV file with total size about 2.5Gb. I made secondary index CREATE. INDEX file field1 ... field6 BUILD.INDEX file field1 ... field6 This syntax creates builds six separate secondary index files, so that inserting a row in the main file will create probably between six and eighteen additional I/O operations to the multiple indices. Is this what you intended? If you actually wanted to create a single secondary index based on a concatenation of the first six fields, you need to create an I-type which does the concatenation, then index on the I-type. If you do need six separate secondary indices, maybe you need to look at where the index files are placed (different disk channel from main file,etc.) Another possibility is that the data is very 'clumpy' on one or more index fields, so that a large proportion of the records share the same value for that index. When UV comes to add a value to the index, it has to scan through a huge set of identical values and then put the new occurrence at the end: this gets exponentially slower. If the shared value is null, then re-creating your index/indices with NO.NULLS will help. If it's not null (maybe it's a month number, so all records fall into only twelve distinct values?), then you need to find some way of creating a more-unique (e.g. month and day) indexable value. HTH Mike After that, rows inserting takes very long time. (4000 rows. Server so busy, that other users can't do anything. If I removed index then inserting process is OK, but I need this index for reporting) Is it normal in UniVerse? How to avoid this problem? I use UniVerse 9.5.2 on AIX 5.2 Thanks, Margus Kandelin 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 [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Wintegrate message box
Many thanks! I am still having a little trouble with an extra carriage return, but I am able to use most of the code you sent from either unibasic or a posix script. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, February 07, 2004 1:40 AM To: U2 Users Discussion List Subject: Re: Wintegrate message box Sure,you could create a subroutine that writes a wintegrate script to their device... EQU ESC TO CHAR(27), SOH TO CHAR(1) EQU STX TO CHAR(2), CR TO CHAR(13) WSCRIPT=ESC:SOH:'Global SKS446=':QUOTE(MESSAGE):CR WSCRIPT:=ESC:SOH:'Global HScript=' WSCRIPT:='BStoAscii(`Loop\r' WSCRIPT:='Response = MessageBox(SKS446,' WSCRIPT:='Message from ':MYNAME WSCRIPT:=',MB_ICONASTERISK|MB_OKCANCEL|MB_DEFBUTTON2)\r' WSCRIPT:='Until Response = OK\r' WSCRIPT:='Repeat' WSCRIPT:='`)':CR WSCRIPT:=ESC:SOH:'Convert HScript,char(254),cr':CR WSCRIPT:=ESC:SOH:'Execute HScript': OPENSEQ TTYNAME TO TTY$FD THEN MAXN=LEN(WSCRIPT) FOR N=1 TO MAXN STEP 80 TEMP=WSCRIPT[N,80] WRITEBLK TEMP ON TTY$FD THEN WRITTEN=1 NEXT N CLOSESEQ TTY$FD One of the guru's on the list can probably come up with a better solution but this works pretty well for me. This is not the complete subroutine. Hope this helps ya. Scott Does anybody know if it is possible to send a wintegrate pop-up box to a different user, from either a unibasic program or a shell script? Specifically, if Fred is trying to access a record, which is locked by Barney, is it possible to have a pop-up box appear on Barney's screen? Currently, we send an email to Barney, which does not work well if Barney does not have his email client open. This is just one example. Our users are currently thinking up several more applications where they would like to do this, if it is possible. tia Charlie Rubeor Unix/Database Admin The Wiremold Company 800.338.1315 x3498 860.523.3690 fax À votre service -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Real Time Data Warehouse
So, I'm moving on from my encrypted database problem (that was put on hold) and now I have a new, interesting problem. I'm looking at a proposal that seems to demand a solution that is a cross between a data replication system and a data warehouse. The system needs to be able to Extract data from a feed up updates to specified Universe or jBASE files in real-time (once a minute, or so will suffice), do some Transformation on the data, then Load the data into a DB2 or SQL Server (not my implementation requirement... don't yell at me). During peak times, I'm supposing could be over a thousand updates per minute written to the data replication feed. I don't know if it's reasonable to expect this system to be able to handle that kind of throughput... that is to be determined. The rationale for the system is to allow people to use standard reporting, OLAP, and BI tools. In industry parlance, I think such a system is called a Real Time Data Warehouse (RTDW). So, here's where you can help... I'm brainstorming for design/implementation ideas. First, I'm trying to get the lay-of-the-land of tools and companies that can help with the ETL (Extract-Transform-Load) part of this project (is this what DataStage does?). Where do I look? Second, I'm searching for clever ideas about how to create and extract the data feed containing file updates -- such as leveraging UV-DR. I'd prefer to create the data replication feed in isolation from the ETL tool. Seeing as I'm a little lazy (and hoping we won't have to roll our own) I'd like to evaluate off-the-shelf solutions. TIA, Tom Firl Columbia Ultimate -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Tuning Tru64
Hello everybody, We are running Unidata 5.2 on AlphaServer ES45 Model 2 Operating System: Compaq Tru64 UNIX V5.1A If we run sys_check it returns following suggestions. Virtual Memory and Swap Operational: Check the values of ubc-maxpercent, ubc-minpercent, ubc-borrowpercent, vm-ubcdirtypercent, vm-ubcseqpercent, and vm-ubcseqstartpercent settings. One or more of these attributes is not set correctly. Virtual Memory and Swap Operational: Check the values of vm-page-free-target, vm-page-free-optimal, vm-page-free-min, and vm-page-free-reserved settings. One or more of these attributes is not set correctly. Current values for thiese parameters are ubc-maxpercent = 100, ubc-minpercent = 10, ubc-borrowpercent = 20, vm-ubcdirtypercent = 40, vm-ubcseqpercent = 10, and vm-ubcseqstartpercent = 50 vm-page-free-target = 768, vm-page-free-optimal = 394, vm-page-free-min = 20 , and vm-page-free-reserved = 10 Please give me some suggestion on these parameters. Have a wonderful time. Regards Kafsat Taiyus Network Administrator Retail Decisions Pty Ltd This email and any attachments are confidential and intended solely for the use of the person or entity to whom they are addressed. If you are not the intended recipient, please do not disclose, store, copy or take any action in reliance on it or them. If you have received this message in error, please tell us by reply email (or telephone + 61 (0) 3 9274 9100) and delete all copies on your system. Any opinion, advice or information in this email is not necessarily that of the owners or officers of this company. Please advise us immediately if you or your employer do not consent to email for messages of this type. Retail Decisions has taken reasonable precautions to ensure that any attachment to this email has been swept for viruses. However, we cannot accept any liability for any damage sustained as a result of software viruses, and would advise that you carry out your own virus checks before opening any attachment. Please note that communications sent by or to any person through our computer system may be viewed by other Retail Decisions employees or officers strictly in accordance with law. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Real Time Data Warehouse
Tom, Sixty to ninety days from now, I'll have a solution for you ::sigh:: I have the UniVerse side in my Tier I product (Zeus) but the SQL won't be until Tier II (in development) and I may or may not have the jBASE bits by then. You may want to look at writing a straight SQL read/write solution with UniVerse handling everything through phantoms. As to DataStage - we have a Stager or two on the list with us - I'm sure they'll be happy to respond. - Charles 'SQL is Dead, Dawn Said So, but I'm still adding it to my product' Barouch Tom Firl wrote: So, I'm moving on from my encrypted database problem (that was put on hold) and now I have a new, interesting problem. I'm looking at a proposal that seems to demand a solution that is a cross between a data replication system and a data warehouse. The system needs to be able to Extract data from a feed up updates to specified Universe or jBASE files in real-time (once a minute, or so will suffice), do some Transformation on the data, then Load the data into a DB2 or SQL Server (not my implementation requirement... don't yell at me). During peak times, I'm supposing could be over a thousand updates per minute written to the data replication feed. I don't know if it's reasonable to expect this system to be able to handle that kind of throughput... that is to be determined. The rationale for the system is to allow people to use standard reporting, OLAP, and BI tools. In industry parlance, I think such a system is called a Real Time Data Warehouse (RTDW). So, here's where you can help... I'm brainstorming for design/implementation ideas. First, I'm trying to get the lay-of-the-land of tools and companies that can help with the ETL (Extract-Transform-Load) part of this project (is this what DataStage does?). Where do I look? Second, I'm searching for clever ideas about how to create and extract the data feed containing file updates -- such as leveraging UV-DR. I'd prefer to create the data replication feed in isolation from the ETL tool. Seeing as I'm a little lazy (and hoping we won't have to roll our own) I'd like to evaluate off-the-shelf solutions. TIA, Tom Firl Columbia Ultimate -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: U2 System Guru
Convert the file to a Distributed File type where each part file can be up to 2GB. We had some distributed files with 40+ parts, yielding a 'logical' file of about 80GB. ken === In a message dated 2/9/2004 10:38:23 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Subj: U2 System Guru Date: 2/9/2004 10:38:23 PM Eastern Standard Time From: Phil Grant [EMAIL PROTECTED] To: [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] Sent from the Internet (Details) Hello all, A client of mine is looking for a Universe on NT system expert. He got into a situation where a file grow to 2GB. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Fred Finken is out of the office.
I will be out of the office starting 02/09/2004 and will not return until 02/23/2004. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Robert Ruschak is out of the office.
I will be out of the office starting 02/09/2004 and will not return until 02/12/2004. I will respond to your message when I return .Thank you -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users