How would I find the block size on a W2K Server?
Everything seems to revolve around block size. I know we've been over this a thousand times, but I'm trying to make sure (coz I'm being hounded to "prove" my theories) I've been using 2k as a general rule-of-thumb (on W2k & NT), but have now been informed (albeit wrongly perhaps) that Pick is 2k, UniVerse may be different, W2K may be different, RAID may be different, SCSI may be different, etc and I'm to back up with "facts" what I've been doing. A CHKDSK on the server says 2048. The net is a myriad of transfer rates, and specific apps doing their own thing... So -what defines block size (app,disk,scsi,raid,???) in terms of resizing? Thanks for any pointers dennis -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Pre variable assignment and memory fragmentation
Hi Marco, You don't say if you are running UV or UD, but here is my guess for UV. >I would like to understand the impact on memory fragmentation of repetitively DIMing an array or even doing a >plain string assignment (with no change in size) e.g: Assuming you are running in an account flavour which allows you to reDIM an array, I don't think the DIM per se will have any affect unless you changes the size or number of dimensions of the array (since array contents are preserved, which I presume is done in place). Even then, I don't think you will have much control over memory fragmentation as UV will allocate storage to each array element only when you assign something to it (I would expect even MAT ARRAY = "" to use a separate memory allocation request for each element, since each is a separate UniVerse variable unlike array allocation in C, where you allocate the entire array and then index into it at element length offsets). Practical experience with reassigning strings suggests that the same memory is used for each assignment unless more memory is required, so I wouldn't expect more memory to be allocated for no matter how many times you repeat it: D.LINE = STR("=",132) I sometimes use this fact when processing large amounts of data into a known length output by preallocating the output variable and then placing my output into it: eg: BUFFERLEN = 2048 OUTDATA = STR(BYTE(0), BUFFERLEN) POS = 1 ... SOMEDATALEN = BYTELEN(SOMEDATA) OUTDATA[POS, SOMEDATALEN] = SOMEDATA POS += SOMEDATALEN ... IF POS LT BUFFERLEN THEN OUTPUT[POS, -1] = "" END So my conclusion is probably little or none, you should be more worried about allocating strings little bits at a time. But I have been horribly, embarrasingly wrong about things before this (just this morning in fact) :) HTH, Craig -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Pre variable assignment and memory fragmentation
Hi All, In response to a message I posted recently, many users expressed strong opinion against the pre-assignment (or "declaration") of variables at the top of a subroutine. Although I dont normally do this in my programs I would like to understand the impact on memory fragmentation of repetitively DIMing an array or even doing a plain string assignment (with no change in size) e.g: SUBROUTINE ABC FOR I = 1 TO 100 ... GOSUB PROCESS NEXT RETURN PROCESS: DIM A(10) D.LINE = STR("=",132) RETURN As opposed to: SUBROUTINE ABC DIM A(100) D.LINE = STR("=",132) FOR I = 1 TO 100 . GOSUB PROCESS NEXT RETURN PROCESS: RETURN - Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: File permissions problem with UniObjects for Java
Apologies for the delay. Wendy I had this same problem a while back. From memory the reason it works at the colon prompt but not from uniobjects it the umask. When you run udt it inherits it's umask from your environment. On linux I have a unidata.sh file in /etc/profile.d which sets it to 002 and the files will be created as rw-rw-r--. Other responses have explained how the umask works. A uniobjects session inherits it's environment from the unirpcd which in turn inherits this from the startud and startunirpcd. If you grep umask in $UDTBIN/startud you will find "umask 022". As Charlie mentioned, the simplest fix is to alter $UDTBIN/startunirpcd so unirpcd inherits the umask you want. HTH Adrian -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Terminology
I'm on the wrong side of the world, but IIRC DataFlo is a product, like InfoFlo - these days out of the Epicore stable I'd imagine SLA would be a "Service Level Agreement" and OLA would be an "Operational Level Agreement", both relating (more or less) to the uptime & availability of a system Ross Ferris Stamina Software Visage – an Evolution in Software Development >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >Behalf Of Mark Johnson >Sent: Tuesday, 16 March 2004 12:56 PM >To: [EMAIL PROTECTED] >Subject: Terminology > >Dear all: > >I'm not familiar with the following as referred to by MV: SLA and OLA >metrics. > >Also, what is Dataflo. My guess is it may be a 4GL or it could be a 3.5GL >like Eclipse. > >thanks. >-- >u2-users mailing list >[EMAIL PROTECTED] >http://www.oliver.com/mailman/listinfo/u2-users > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.622 / Virus Database: 400 - Release Date: 13/03/2004 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.622 / Virus Database: 400 - Release Date: 13/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Terminology
Dear all: I'm not familiar with the following as referred to by MV: SLA and OLA metrics. Also, what is Dataflo. My guess is it may be a 4GL or it could be a 3.5GL like Eclipse. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Installing universe as uvadm
(sorry about the duplication. Hit the wrong key) EV Note down current permissions chmod 777 / /var/spool install chmod back again Glenn's methodology seems a good one.Though I did not install it that way (for 'historical' reasons ie I did not have root access). However, when upgrading to 10.0.17 on HP the process fails when connected as uvadm so I had to use root (and select the option which says retain uvadm as the administrator). Why not try out whatever variations? Its easy enough to blow away the install and try a different install methodology. Hth t -Original Message- From: Williams, Trevor Sent: 16 March 2004 9:29 am To: 'U2 Users Discussion List' Subject:RE: Installing universe as uvadm EV Note down current permissions chmod 777 / /var/spool install chmod back again Glenn's -Original Message- From: Evgenios Charalambus [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 9:44 pm To: U2 Users Discussion List Subject:RE: Installing universe as uvadm How to the change permissions on / and /var/spool as needed? The way I thought it, is the following: I should put the uvadm user in system group. Give full access to to group system on / Give full access to system group on to /var/spool Is this correct? [EMAIL PROTECTED] wrote: EC Change permissions on / and /var/spool Install Change permissions back t -Original Message- From: Evgenios Charalambus [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 3:11 pm To: Discussion Universe Subject: Installing universe as uvadm I am trying to install UNIVERSE 9.5 as uvadm user on AIX 5. The installation fails because of wrong permissions. The manual mentios that the uvadm user must have write permission on the root (/) directory. How can this be acomplished? Is the security of the system compomised by allowing uvadm to write on (/)? Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users 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 [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users 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 in
RE: Installing universe as uvadm
EV Note down current permissions chmod 777 / /var/spool install chmod back again Glenn's -Original Message- From: Evgenios Charalambus [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 9:44 pm To: U2 Users Discussion List Subject:RE: Installing universe as uvadm How to the change permissions on / and /var/spool as needed? The way I thought it, is the following: I should put the uvadm user in system group. Give full access to to group system on / Give full access to system group on to /var/spool Is this correct? [EMAIL PROTECTED] wrote: EC Change permissions on / and /var/spool Install Change permissions back t -Original Message- From: Evgenios Charalambus [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 3:11 pm To: Discussion Universe Subject: Installing universe as uvadm I am trying to install UNIVERSE 9.5 as uvadm user on AIX 5. The installation fails because of wrong permissions. The manual mentios that the uvadm user must have write permission on the root (/) directory. How can this be acomplished? Is the security of the system compomised by allowing uvadm to write on (/)? Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users 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 [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users 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 [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Suppressing detail in UniObjects command
> DET.SUPP is not a valid attribute. > > Any ideas? This works perfectly from the udt prompt. Try ID.SUP & DET.SUP (just one 'P'). ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Suppressing detail in UniObjects command
Hey Nick, What you NEED to use is DET.SUP and not DET.SUPP (please notice only one "P"). The error is trying to tell it does not understand DET.SUPP I think. Lembit Pirn was on the right track! Regards, T. - Original Message - From: "Nick Southwell" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Tuesday, March 16, 2004 4:18 AM Subject: RE: Suppressing detail in UniObjects command Cheers, I'll give that a try! Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 17:16 To: [EMAIL PROTECTED] Subject: RE: Suppressing detail in UniObjects command Yes, it sounds like you use the "P"ick style by either turning UDT.OPTIONS 2 ON or with ECLTYPE P for your "regular" sessions. I believe UniObjects defaults to ECLTYPE U. I haven't tried in a UniObjects session to change the ECLTYPE - you just need to learn the "U" type syntax which is somewhat different but has much more power. Check the online help for list and sort for the basic syntax. If you want to "test" your commands at TCL you can simply use the lower case list or sort to force UniData to use the "U" type command parser. hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-Original Message- >From: Nick Southwell [mailto:[EMAIL PROTECTED] >Sent: Monday, March 15, 2004 9:38 AM >To: U2 Users Discussion List >Subject: RE: Suppressing detail in UniObjects command > > >Sooo.. > >Coming from a very small Unidata background sounds like you're saying I >need to set my ECL type within the Uniobjects session? > >Thanks > >Nick -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- 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
Win 2K and UV 9.5.2.1r6-1
Hello group, Does anyone know if UV 9.5.2.1r6-1 is compatible with Windows 2000 Server? We are currently running this UV version on NT with service pack 4. Regards, Dan Jorgenson SICK, Inc. 6900 West 110th Street Bloomington, MN 55438 USA Direct: 952-829-4732 Fax: 952-941-9287 http://www.sick.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Strange results from I Descriptor
Maybe creating indices on your PROV.DIR.DB file for the MAMSI field is the way to go. Then selectindex to do your processing. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis Sent: Monday, March 15, 2004 4:40 PM To: U2 Users Discussion List Subject: RE: Strange results from I Descriptor Don't do a select (or any query statement) within an I-descriptor subroutine that gets called from query. That's what the message means. Even if it did work it would be a dog. If I need to do something like this in UniData I use the UniBasic index commands like SETINDEX READFWD, etc and create an index on the other file. Indices are different on Universe, but there are commands to access them in basic. From: [EMAIL PROTECTED] on behalf of Gordon Glorfield Sent: Mon 3/15/2004 3:56 PM To: U2 Users List ([EMAIL PROTECTED]) Subject: Strange results from I Descriptor UV 10.0.8 I am trying to create an I-Descriptor that calls a subroutine. The subroutine does a select on another file. When the select is executed I get this error: "Non-SQL re-entrant query calls are not allowed." I'm clueless as to what is wrong. Any hints would be greatly appreciated. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. __ Our company accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 11/29/2003 ACE Software, LLC -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Strange results from I Descriptor
Don't do a select (or any query statement) within an I-descriptor subroutine that gets called from query. That's what the message means. Even if it did work it would be a dog. If I need to do something like this in UniData I use the UniBasic index commands like SETINDEX READFWD, etc and create an index on the other file. Indices are different on Universe, but there are commands to access them in basic. From: [EMAIL PROTECTED] on behalf of Gordon Glorfield Sent: Mon 3/15/2004 3:56 PM To: U2 Users List ([EMAIL PROTECTED]) Subject: Strange results from I Descriptor UV 10.0.8 I am trying to create an I-Descriptor that calls a subroutine. The subroutine does a select on another file. When the select is executed I get this error: "Non-SQL re-entrant query calls are not allowed." I'm clueless as to what is wrong. Any hints would be greatly appreciated. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. __ Our company accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 11/29/2003 ACE Software, LLC -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Strange results from I Descriptor
Yes, I'm doing that. Here is the code for the subroutine: SUBROUTINE FIND.TERM.DIR (RESULT) COMMON /FIND.TERM.DIR/ F.DIR, THIS.ACCT * MOD1 03/15/2004 GJG Change to use select rather than trust PROV<71>. * IF THIS.ACCT # @WHO THEN OPEN 'PROV.DIR.DB' TO F.DIR ELSE PRINT "CANNOT OPEN PROV.DIR.DB" RETURN END [EMAIL PROTECTED] END * RESULT="" *MOD1* [EMAIL PROTECTED]<71> @SELECTED = 0 SEL.LIT = 'SELECT PROV.DIR.DB WITH X.MAMSI.ID EQ "':@ID:'" TO 2' PERFORM SEL.LIT ;* READ RCD FROM F.DIR,D.ID THEN IF RCD<28>#"" THEN RESULT="1" EXIT END ELSE LOCATE @ID IN RCD<52> SETTING POS THEN IF RCD<54,POS>#"" THEN RESULT="1" EXIT END END END END NEXT IDX * RETURN Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Monday, March 15, 2004 4:25 PM To: 'U2 Users Discussion List' Subject: RE: Strange results from I Descriptor Not sure what you are doing but since it's in an i-descriptor and being used as part of another listing, I'd use numbered selects in my subroutine to make sure it doesn't bump heads with the current listing that's using the i-descriptor. HTH Mike R. [snip] Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Strange results from I Descriptor
Not sure what you are doing but since it's in an i-descriptor and being used as part of another listing, I'd use numbered selects in my subroutine to make sure it doesn't bump heads with the current listing that's using the i-descriptor. HTH Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon Glorfield Sent: Monday, March 15, 2004 3:56 PM To: U2 Users List ([EMAIL PROTECTED]) Subject: Strange results from I Descriptor UV 10.0.8 I am trying to create an I-Descriptor that calls a subroutine. The subroutine does a select on another file. When the select is executed I get this error: "Non-SQL re-entrant query calls are not allowed." I'm clueless as to what is wrong. Any hints would be greatly appreciated. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- 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
Strange results from I Descriptor
UV 10.0.8 I am trying to create an I-Descriptor that calls a subroutine. The subroutine does a select on another file. When the select is executed I get this error: "Non-SQL re-entrant query calls are not allowed." I'm clueless as to what is wrong. Any hints would be greatly appreciated. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How do I copy Unix files > 2 gig
> There should be a file under /etc somewhere (/etc/security/limits on AIX) > named limits, or something similar, in which a parameter (on AIX, it's > fsize) defines that limit. Change it to a larger number, or on many unices a > "-1" means no limit. Or if you just want to do it ONCE, try the "ulimit" command - on AIX, "ulimit unlimited" -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Installing universe as uvadm
Actually, you don't really INSTALL as non-root. The idea of uvadm is that it is an ADMINISTRATOR, thus, your initial root install sets the product up so that internally uvadm can administer all facets of the product without the need of su-ing to root. The fact remains that you still need to INSTALL as root, since there are certain things that need touching, ie. /.uvhome, /etc/services, /etc/rc.X directories, etc. The DataStage version I now work with DOES allow complete non-root installation (no longer uses /.uvhome or touches system files) by ANY user (no uvadm limitation) as well as allowing multiple versions (even the same version!) to run on a single server, as I have rewritten all that so root is no longer necessary. So, install AS root, but designate uvadm as your administrator. Hope this helps. At 02:11 AM 03/15/2004, you wrote: I am trying to install UNIVERSE 9.5 as uvadm user on AIX 5. The installation fails because of wrong permissions. The manual mentios that the uvadm user must have write permission on the root (/) directory. How can this be acomplished? Is the security of the system compomised by allowing uvadm to write on (/)? Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- 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: How do I copy Unix files > 2 gig
There should be a file under /etc somewhere (/etc/security/limits on AIX) named limits, or something similar, in which a parameter (on AIX, it's fsize) defines that limit. Change it to a larger number, or on many unices a "-1" means no limit. "Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them?" - H.H. the Dalai Lama "When buying & selling are controlled by legislation, the first thing to be bought & sold are the legislators" - P.J. O'Rourke Dan Fitzgerald From: George Gallen <[EMAIL PROTECTED]> Reply-To: U2 Users Discussion List <[EMAIL PROTECTED]> To: 'U2 Users Discussion List' <[EMAIL PROTECTED]> Subject: RE: How do I copy Unix files > 2 gig Date: Mon, 15 Mar 2004 12:25:33 -0500 what about using tar? cd destination ; tar cvf - /sourcetreename | tar xvf - I think the above will work. George >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Monday, March 15, 2004 12:14 PM >To: [EMAIL PROTECTED] >Subject: How do I copy Unix files > 2 gig > > >Hi all, > >How do I go about copying a file that is > 2 gig? I had no >idea that this would be a problem when I decided to let one of >my data files extend beyond the 2 gig limit with the 64 bit >option. The man pages for "cp" do not mention any size >limitations. What am I missing? > >As always, thanks a bunch for the help, > >Scott >-- >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 _ FREE pop-up blocking with the new MSN Toolbar get it now! http://clk.atdmt.com/AVE/go/onm00200415ave/direct/01/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe Sockets Interface
There's a files area? -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Saturday, March 13, 2004 4:53 AM To: U2 Users Discussion List Subject: RE: Universe Sockets Interface However, the attachment gets stripped. How about sending it to the moderator to put into the files area? - Original Message - From: Jeff Schasny <[EMAIL PROTECTED]> Date: Fri, 12 Mar 2004 14:28:23 -0700 To: U2 Users Discussion List <[EMAIL PROTECTED]> Subject: RE: Universe Sockets Interface > Ok, so maybe I AM replying to the list :) -- 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: Linux kernel params
http://www.greenwoodsoftware.com/less/ Just make a link called "pg" to less or more, more or less... :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stu Glancy Sent: Monday, March 15, 2004 11:48 AM To: U2 Users Discussion List Subject: RE: Linux kernel params Do you have a source for pg. Our admin guy couldn't find one. Stu Glancy Asset Management Outsourcing, Inc. Senior Analyst/DBA 770-792-3907 > I think on linux they're different programs, and pg may not be > installed (but it can be installed) > > [EMAIL PROTECTED] john]$ ls -shil `which more less` > 2015305 28K -rwxr-xr-x1 root root 26K Feb 24 2003 > /bin/more > 344104 136K -rwxr-xr-x1 root root 130K Feb 4 2003 > /usr/bin/less > > On Fri, 12 Mar 2004, Anthony Youngman wrote: > >> Minor nitpick ... >> >> In linux, I think you'll find "more" is a link to "less". Either >> that, or you'll find the behaviour of the program changes depending >> which name it is called by, and "less" has the better set of options >> :-) >> >> Cheers, >> Wol >> >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] >> On Behalf Of Stu Glancy >> Sent: 11 March 2004 21:11 >> To: U2 Users Discussion List >> Subject: Re: Linux kernel params >> >> We are doing similar from HP-UX to Linux 9 (kernel 2.4.20-28.9bigmem) >> and UV 10.0.O to UV 10.1 and found that APP.PROGS LIST.SP.CONF uses >> unix command "pg" which does not exist in linux Red Hat. We did a >> work around by creating a link from pg to more. This has been >> reported to IBM and is in engineering as ECase 6621. >> >> Stu Glancy >> Asset Management Outsourcing, Inc. >> Senior Analyst/DBA >> 770-792-3907 >> >> > We are in the process of migrating our Universe app from an HP-UX >> system >> > to a >> > RedHat Linux (8.0) system. There did not appear to be any >> recommended >> > o/s >> > changes in the docs (although I did change the max number of open >> files). >> > >> > Does anyone have any suggested changes? >> > >> > Thanks, >> > Drew >> > >> > -- >> > -- >> > Drew Henderson "There are two types of people >> - >> > Dir. for Computer Center Operations those who do the work and >> those >> > [EMAIL PROTECTED] who take the credit. Try to >> be >> > in the first group, there is >> > 110 Ginger Hall less competition." >> > Morehead State University Indira Ghandi >> > Morehead, KY 40351 >> > Phone: 606/783-2445 Fax: 606/783-5078 >> > --- >> > --- >> > >> > >> > -- >> > 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How do I copy Unix files > 2 gig
what about using tar? cd destination ; tar cvf - /sourcetreename | tar xvf - I think the above will work. George >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Monday, March 15, 2004 12:14 PM >To: [EMAIL PROTECTED] >Subject: How do I copy Unix files > 2 gig > > >Hi all, > >How do I go about copying a file that is > 2 gig? I had no >idea that this would be a problem when I decided to let one of >my data files extend beyond the 2 gig limit with the 64 bit >option. The man pages for "cp" do not mention any size >limitations. What am I missing? > >As always, thanks a bunch for the help, > >Scott >-- >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: Suppressing detail in UniObjects command
Cheers, I'll give that a try! Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 17:16 To: [EMAIL PROTECTED] Subject: RE: Suppressing detail in UniObjects command Yes, it sounds like you use the "P"ick style by either turning UDT.OPTIONS 2 ON or with ECLTYPE P for your "regular" sessions. I believe UniObjects defaults to ECLTYPE U. I haven't tried in a UniObjects session to change the ECLTYPE - you just need to learn the "U" type syntax which is somewhat different but has much more power. Check the online help for list and sort for the basic syntax. If you want to "test" your commands at TCL you can simply use the lower case list or sort to force UniData to use the "U" type command parser. hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-Original Message- >From: Nick Southwell [mailto:[EMAIL PROTECTED] >Sent: Monday, March 15, 2004 9:38 AM >To: U2 Users Discussion List >Subject: RE: Suppressing detail in UniObjects command > > >Sooo.. > >Coming from a very small Unidata background sounds like you're saying I >need to set my ECL type within the Uniobjects session? > >Thanks > >Nick -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Suppressing detail in UniObjects command
Yes, it sounds like you use the "P"ick style by either turning UDT.OPTIONS 2 ON or with ECLTYPE P for your "regular" sessions. I believe UniObjects defaults to ECLTYPE U. I haven't tried in a UniObjects session to change the ECLTYPE - you just need to learn the "U" type syntax which is somewhat different but has much more power. Check the online help for list and sort for the basic syntax. If you want to "test" your commands at TCL you can simply use the lower case list or sort to force UniData to use the "U" type command parser. hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-Original Message- >From: Nick Southwell [mailto:[EMAIL PROTECTED] >Sent: Monday, March 15, 2004 9:38 AM >To: U2 Users Discussion List >Subject: RE: Suppressing detail in UniObjects command > > >Sooo.. > >Coming from a very small Unidata background >sounds like you're saying I need to set my >ECL type within the Uniobjects session? > >Thanks > >Nick -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
How do I copy Unix files > 2 gig
Hi all, How do I go about copying a file that is > 2 gig? I had no idea that this would be a problem when I decided to let one of my data files extend beyond the 2 gig limit with the 64 bit option. The man pages for "cp" do not mention any size limitations. What am I missing? As always, thanks a bunch for the help, Scott -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Linux kernel params
Do you have a source for pg. Our admin guy couldn't find one. Stu Glancy Asset Management Outsourcing, Inc. Senior Analyst/DBA 770-792-3907 > I think on linux they're different programs, and pg may not be installed > (but > it can be installed) > > [EMAIL PROTECTED] john]$ ls -shil `which more less` > 2015305 28K -rwxr-xr-x1 root root 26K Feb 24 2003 > /bin/more > 344104 136K -rwxr-xr-x1 root root 130K Feb 4 2003 > /usr/bin/less > > On Fri, 12 Mar 2004, Anthony Youngman wrote: > >> Minor nitpick ... >> >> In linux, I think you'll find "more" is a link to "less". Either that, >> or you'll find the behaviour of the program changes depending which >> name >> it is called by, and "less" has the better set of options :-) >> >> Cheers, >> Wol >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> On Behalf Of Stu Glancy >> Sent: 11 March 2004 21:11 >> To: U2 Users Discussion List >> Subject: Re: Linux kernel params >> >> We are doing similar from HP-UX to Linux 9 (kernel 2.4.20-28.9bigmem) >> and >> UV 10.0.O to UV 10.1 and found that APP.PROGS LIST.SP.CONF uses unix >> command "pg" which does not exist in linux Red Hat. We did a work >> around >> by creating a link from pg to more. This has been reported to IBM and >> is >> in engineering as ECase 6621. >> >> Stu Glancy >> Asset Management Outsourcing, Inc. >> Senior Analyst/DBA >> 770-792-3907 >> >> > We are in the process of migrating our Universe app from an HP-UX >> system >> > to a >> > RedHat Linux (8.0) system. There did not appear to be any >> recommended >> > o/s >> > changes in the docs (although I did change the max number of open >> files). >> > >> > Does anyone have any suggested changes? >> > >> > Thanks, >> > Drew >> > >> > -- >> > -- >> > Drew Henderson "There are two types of people >> - >> > Dir. for Computer Center Operations those who do the work and >> those >> > [EMAIL PROTECTED] who take the credit. Try to >> be >> > in the first group, there is >> > 110 Ginger Hall less competition." >> > Morehead State University Indira Ghandi >> > Morehead, KY 40351 >> > Phone: 606/783-2445 Fax: 606/783-5078 >> > -- >> > >> > >> > -- >> > 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
RE: UV 10.1.0 on Linux
I've found that when installing UniVerse on Linux, you have to edit a few things before it's "happy". Others have mentioned the uv.load and cpio issue, I've also found that you should look in the following files and make sure they have the right info. .unishared -- This is at the root level of the machine. It tells UniVerse where the shared directory is. .uvhome -- This is off the root level of the machine and is simply a pointer to the UniVerse install directory. These files are within the home directory pointed to by .uvhome. .profile -- I think this is just an example of what to put in your profile. I hope it's just an example, because it still makes reference to "ardent" (who are they???) :-) .uvrcloc -- This is where you can tell UniVerse to look for uv.rc. Just edit the directory within to match your system. Check this file first if UniVerse won't start. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe Sockets Interface
Even though you thought you were replying off line, I'm interested. Somehow the attachments didn't make it. Would you please resend them. Stu Glancy Asset Management Outsourcing, Inc. Senior Analyst/DBA 770-792-3907 > I'm replying off list. > > The attached subroutines can be called to establish, read and write to > socket connections. > > 1) run the SOCKET.ACCEPT.CONNECT on the server side to establish a > "listener" and return a socket handle to the controling process. > 2) run SOCKET.OPEN on the client side to establish a connection to the > remote server and return a socket handle to the controling process. > > 3 Use SOCKET.READ and SOCKET.WRITE as required to transmit data > > > > -Original Message- > From: Matt Sedlak (EL) [mailto:[EMAIL PROTECTED] > Sent: Friday, March 12, 2004 1:39 PM > To: [EMAIL PROTECTED] > Subject: Universe Sockets Interface > > > Does anyone have a solid working example of a Universe Basic program that > uses the Sockets Interface to communicate between two machine? > > > > Matt > > > > -- > 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
RE: Suppressing detail in UniObjects command
Sooo.. Coming from a very small Unidata background sounds like you're saying I need to set my ECL type within the Uniobjects session? Thanks Nick -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 16:30 To: 'U2 Users Discussion List' Subject: RE: Suppressing detail in UniObjects command Sounds like your ECL type is set differently for your login and Objects sessions. Remember, UniObjects doesn't run LOGIN. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell > Sent: 15 March 2004 16:15 > To: U2 Users Discussion List > Subject: Suppressing detail in UniObjects command > > Trying to run the command > > SORT FILE WITH ACTION-CODE = "NAG" BY WEB-IND BREAK-ON WEB-IND TOTAL > CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP > > via a vb6 program using Uniobjects. > > objCommand.Text = "SORT DTA WITH ACTION-CODE = 'NAG' BY WEB-IND > BREAK-ON WEB-IND TOTAL CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP" > objCommand.Exec > > The program returns immediately with CommandStatus = 0 Error = 0 and > response > > DET.SUPP is not a valid attribute. > > Any ideas? This works perfectly from the udt prompt. > > Thanks > > Nick > > This correspondence is confidential and is solely for the intended > recipient(s). If you are not the intended recipient, you must not use, > disclose, copy, distribute or retain this message or any part of it. > If you are not the intended recipient please delete this > correspondence from your system and notify the sender immediately. > > No warranty is given that this correspondence is free from any virus. > In keeping with good computer practice, you should ensure that it is > actually virus free. E-mail messages may be subject to delays, > non-delivery and unauthorised alterations therefore, information > expressed in this message is not given or endorsed by Open and Direct > Group Limited unless otherwise notified by our duly authorised > representative independent of this message. > > Open and Direct Group Limited is a limited company registered in > United Kingdom under number 4390810 whose registered office is at 10 > Norwich Street, London, EC4A 1BD > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > > __ > __ > This email was checked by MessageLabs SkyScan before entering > Microgen. 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 correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Suppressing detail in UniObjects command
It produces output with just ID.SUPP but same error with DET.SUPP on its own. Thanks Nick -Original Message- From: Lembit Pirn [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 16:31 To: U2 Users Discussion List Subject: Re: Suppressing detail in UniObjects command Have You tried with DET.SUP ? Just idea, synonyms. Lembit Pirn 7+7 Software Tondi 1 Tallinn 11313 Estonia +372 65 66 232 [EMAIL PROTECTED] - Original Message - From: "Nick Southwell" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Monday, March 15, 2004 6:15 PM Subject: Suppressing detail in UniObjects command > Trying to run the command > > SORT FILE WITH ACTION-CODE = "NAG" BY WEB-IND BREAK-ON WEB-IND TOTAL > CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP > > via a vb6 program using Uniobjects. > > objCommand.Text = "SORT DTA WITH ACTION-CODE = 'NAG' BY WEB-IND > BREAK-ON WEB-IND TOTAL CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP" > objCommand.Exec > > The program returns immediately with CommandStatus = 0 > Error = 0 and response > > DET.SUPP is not a valid attribute. > > Any ideas? This works perfectly from the udt prompt. > > Thanks > > Nick > > This correspondence is confidential and is solely for the intended > recipient(s). If you are not the intended recipient, you must not use, > disclose, copy, distribute or retain this message or any part of it. If you > are not the intended recipient please delete this correspondence from your > system and notify the sender immediately. > > No warranty is given that this correspondence is free from any virus. In > keeping with good computer practice, you should ensure that it is actually > virus free. E-mail messages may be subject to delays, non-delivery and > unauthorised alterations therefore, information expressed in this message is > not given or endorsed by Open and Direct Group Limited unless otherwise > notified by our duly authorised representative independent of this message. > > Open and Direct Group Limited is a limited company registered in United > Kingdom under number 4390810 whose registered office is at 10 Norwich > Street, London, EC4A 1BD > > -- > 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 This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Suppressing detail in UniObjects command
Sounds like your ECL type is set differently for your login and Objects sessions. Remember, UniObjects doesn't run LOGIN. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell > Sent: 15 March 2004 16:15 > To: U2 Users Discussion List > Subject: Suppressing detail in UniObjects command > > Trying to run the command > > SORT FILE WITH ACTION-CODE = "NAG" BY WEB-IND BREAK-ON > WEB-IND TOTAL CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP > > via a vb6 program using Uniobjects. > > objCommand.Text = "SORT DTA WITH ACTION-CODE = 'NAG' BY > WEB-IND BREAK-ON WEB-IND TOTAL CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP" > objCommand.Exec > > The program returns immediately with CommandStatus = 0 Error > = 0 and response > > DET.SUPP is not a valid attribute. > > Any ideas? This works perfectly from the udt prompt. > > Thanks > > Nick > > This correspondence is confidential and is solely for the > intended recipient(s). If you are not the intended recipient, > you must not use, disclose, copy, distribute or retain this > message or any part of it. If you are not the intended > recipient please delete this correspondence from your system > and notify the sender immediately. > > No warranty is given that this correspondence is free from > any virus. In keeping with good computer practice, you > should ensure that it is actually virus free. E-mail messages > may be subject to delays, non-delivery and unauthorised > alterations therefore, information expressed in this message > is not given or endorsed by Open and Direct Group Limited > unless otherwise notified by our duly authorised > representative independent of this message. > > Open and Direct Group Limited is a limited company registered > in United Kingdom under number 4390810 whose registered > office is at 10 Norwich Street, London, EC4A 1BD > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > > __ > __ > This email was checked by MessageLabs SkyScan before entering > Microgen. 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
Re: Suppressing detail in UniObjects command
Have You tried with DET.SUP ? Just idea, synonyms. Lembit Pirn 7+7 Software Tondi 1 Tallinn 11313 Estonia +372 65 66 232 [EMAIL PROTECTED] - Original Message - From: "Nick Southwell" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Monday, March 15, 2004 6:15 PM Subject: Suppressing detail in UniObjects command > Trying to run the command > > SORT FILE WITH ACTION-CODE = "NAG" BY WEB-IND BREAK-ON WEB-IND TOTAL > CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP > > via a vb6 program using Uniobjects. > > objCommand.Text = "SORT DTA WITH ACTION-CODE = 'NAG' BY WEB-IND > BREAK-ON WEB-IND TOTAL CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP" > objCommand.Exec > > The program returns immediately with CommandStatus = 0 > Error = 0 and response > > DET.SUPP is not a valid attribute. > > Any ideas? This works perfectly from the udt prompt. > > Thanks > > Nick > > This correspondence is confidential and is solely for the intended > recipient(s). If you are not the intended recipient, you must not use, > disclose, copy, distribute or retain this message or any part of it. If you > are not the intended recipient please delete this correspondence from your > system and notify the sender immediately. > > No warranty is given that this correspondence is free from any virus. In > keeping with good computer practice, you should ensure that it is actually > virus free. E-mail messages may be subject to delays, non-delivery and > unauthorised alterations therefore, information expressed in this message is > not given or endorsed by Open and Direct Group Limited unless otherwise > notified by our duly authorised representative independent of this message. > > Open and Direct Group Limited is a limited company registered in United > Kingdom under number 4390810 whose registered office is at 10 Norwich > Street, London, EC4A 1BD > > -- > 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
Suppressing detail in UniObjects command
Trying to run the command SORT FILE WITH ACTION-CODE = "NAG" BY WEB-IND BREAK-ON WEB-IND TOTAL CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP via a vb6 program using Uniobjects. objCommand.Text = "SORT DTA WITH ACTION-CODE = 'NAG' BY WEB-IND BREAK-ON WEB-IND TOTAL CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP" objCommand.Exec The program returns immediately with CommandStatus = 0 Error = 0 and response DET.SUPP is not a valid attribute. Any ideas? This works perfectly from the udt prompt. Thanks Nick This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV 10.1.0 on Linux
On Mon, Mar 15, 2004 at 03:45:39PM +1300, Phil Walker wrote: > All, > > I know this question has been asked before, but is UniVerse supported on > versions of Linux other than Redhat, such as Debian, SUSE etc? I imagine it > is not hard to get working, but would IBM then regard it as being certified? I install uv 10.0.9 on Debian (woody) routinely. The install script (specifically the cpio command) needs to be edited beforehand, and I have to create directory links for /etc/rc.d and /usr/spool/uv. After that, it runs fine. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Help Needed regarding performance improvement of delete query
I have a client that needs roughly 250,000 items removed monthly from a file containing 5-6 million records. Since there is no need to use the keys (records) for any other purpose except for deleting because they are old, a standard data/basic SELECT statement is just about as fast as you can get. It isn't encumbered by the number of selected keys as it's not retaining them for any purpose. This simple program looks like this: OPEN "MASTER" TO F.MASTER ELSE STOP OPEN "REFERENCE" TO F.REFERENCE ELSE STOP DEL.DTE=ICONV("01/02/2003","D") SELECT F.MASTER 10 READNEXT ID ELSE STOP READV DTE FROM F.MASTER, ID, 5 ELSE GOTO 10 IF DTE GT DEL.DATE THEN GOTO 10 DELETE F.MASTER, ID DELETE F.REFERENCE, ID GOTO 10 END Of course if there's additional use for the deleted keys, then use another approach. my 1 cent. - Original Message - From: "ashish ratna" <[EMAIL PROTECTED]> To: "Anthony Youngman" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 15, 2004 7:55 AM Subject: RE: Help Needed regarding performance improvement of delete query Hi Wol, The scenario is that- We have a master file having more than 3-4 million records and have corresponding reference file which contains reference data for this master file. Now we start our purge program which selects records from master file on the basis of date. Corresponding data should be deleted from the other file (reference file). For this requirement we have adopted the approach that- select the record from master file on the basis of date. Save the list of these records, then on the basis of this list select the records from reference file. Issue is that this list contains more than 0.5 million and I want to take few (say 10,000 at a time) record ids from this list for further processing. Any pointers for this problem will be very helpful. Thanks in advance. Ashish. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 4:50 PM To: ashish ratna Subject: RE: Help Needed regarding performance improvement of delete query Ahhh I thought you were selecting records and deleting them. So the first thousand would have disappeared, and you would obviously get a different thousand next time round because the first lot would have gone :-) Sounds like that's not the case. In that case, do you have a field that is repeated across many records, but where each individual value (or range of values) wouldn't return too big a bunch of records? Or do you have a numeric id - you could declare an index on that ... Let's take that numeric id idea - and then you'll have to build on it for yourself. Declare an i-descriptor as @ID[3]. That logically partitions your file into a thousand pieces. Declare an index on this. The first term in your select will then be "WITH IDESC EQ whatever-number-you-want". That'll reduce the load on the database for each pass, you'll just need to wrap it in a loop where "whatever-number" goes from 0 to 999 Actually, what I would probably do is declare my i-descriptor as INT(@ID/30) and then run this purge daily with "whatever-number" as today's day. Obviously, it'll do nothing on the 31sts, and in March it'll do two month's work on the 29th and 30th, but you've reduced the "hit" on the system considerably. Without knowing what you're doing in more detail, it's difficult to give you any proper advice, but certainly I'll try and think of any tips that you can build upon, like this. But you need to work out what's right for you :-) NB Any reason for taking this off the mailing list? By all means cc it to me, but if you keep it on the list there are other people who may be able to help too - I'm very good at overviews, but I fall short on the logic - I think there is a way to get the next thousand records, but I haven't got a clue what the syntax is ... Cheers, Wol -Original Message- From: ashish ratna [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 10:33 To: Anthony Youngman Subject: RE: Help Needed regarding performance improvement of delete query Hi, Thanks for the nice suggestions. I have another question that, using SAMPLE once I process 1000 records (using SAMPLE 1000), how can I select next 1000 records in next run (i.e. 1001 to 2000 records and so on)? I was trying few combinations but didn't succeeded. Can you tell me the syntax for that? Thanks again. Regards, Ashish. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: Monday, March 15, 2004 2:32 PM To: U2 Users Discussion List Subject: RE: Help Needed regarding performance improvement of delete query This might help speed things up a bit ... Firstly, of course, is your file properly sized? Secondly, (and in this case you will need to run the SELECT / DELETE sequence several times) try putting a SAMPLE 1000 (or whatever number makes sense) at the end of your select. Basically, this will mean that the SELEC
RE: Installing universe as uvadm
How to the change permissions on / and /var/spool as needed? The way I thought it, is the following: I should put the uvadm user in system group. Give full access to to group system on / Give full access to system group on to /var/spool Is this correct? [EMAIL PROTECTED] wrote: EC Change permissions on / and /var/spool Install Change permissions back t -Original Message- From: Evgenios Charalambus [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 3:11 pm To: Discussion Universe Subject: Installing universe as uvadm I am trying to install UNIVERSE 9.5 as uvadm user on AIX 5. The installation fails because of wrong permissions. The manual mentios that the uvadm user must have write permission on the root (/) directory. How can this be acomplished? Is the security of the system compomised by allowing uvadm to write on (/)? Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users 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 [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Help Needed regarding performance improvement of delete query
Oh, by the way Don't forget to use "fuser" in unix or the equalivant on Bill Gates' machines in order to verify that you truly do have "exclusive access rights"; otherwise, no worky. - Original Message - From: Mike Masters To: U2 Users Discussion List Sent: Monday, March 15, 2004 8:24 AM Subject: Re: Help Needed regarding performance improvement of delete query I forgot to mention why. U2 definately prefers ADDing records instead of DELETing records.. any day. - Original Message - From: ashish ratna To: Anthony Youngman Cc: [EMAIL PROTECTED] Sent: Monday, March 15, 2004 7:55 AM Subject: RE: Help Needed regarding performance improvement of delete query Hi Wol, The scenario is that- We have a master file having more than 3-4 million records and have corresponding reference file which contains reference data for this master file. Now we start our purge program which selects records from master file on the basis of date. Corresponding data should be deleted from the other file (reference file). For this requirement we have adopted the approach that- select the record from master file on the basis of date. Save the list of these records, then on the basis of this list select the records from reference file. Issue is that this list contains more than 0.5 million and I want to take few (say 10,000 at a time) record ids from this list for further processing. Any pointers for this problem will be very helpful. Thanks in advance. Ashish. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 4:50 PM To: ashish ratna Subject: RE: Help Needed regarding performance improvement of delete query Ahhh I thought you were selecting records and deleting them. So the first thousand would have disappeared, and you would obviously get a different thousand next time round because the first lot would have gone :-) Sounds like that's not the case. In that case, do you have a field that is repeated across many records, but where each individual value (or range of values) wouldn't return too big a bunch of records? Or do you have a numeric id - you could declare an index on that ... Let's take that numeric id idea - and then you'll have to build on it for yourself. Declare an i-descriptor as @ID[3]. That logically partitions your file into a thousand pieces. Declare an index on this. The first term in your select will then be "WITH IDESC EQ whatever-number-you-want". That'll reduce the load on the database for each pass, you'll just need to wrap it in a loop where "whatever-number" goes from 0 to 999 Actually, what I would probably do is declare my i-descriptor as INT(@ID/30) and then run this purge daily with "whatever-number" as today's day. Obviously, it'll do nothing on the 31sts, and in March it'll do two month's work on the 29th and 30th, but you've reduced the "hit" on the system considerably. Without knowing what you're doing in more detail, it's difficult to give you any proper advice, but certainly I'll try and think of any tips that you can build upon, like this. But you need to work out what's right for you :-) NB Any reason for taking this off the mailing list? By all means cc it to me, but if you keep it on the list there are other people who may be able to help too - I'm very good at overviews, but I fall short on the logic - I think there is a way to get the next thousand records, but I haven't got a clue what the syntax is ... Cheers, Wol -Original Message- From: ashish ratna [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 10:33 To: Anthony Youngman Subject: RE: Help Needed regarding performance improvement of delete query Hi, Thanks for the nice suggestions. I have another question that, using SAMPLE once I process 1000 records (using SAMPLE 1000), how can I select next 1000 records in next run (i.e. 1001 to 2000 records and so on)? I was trying few combinations but didn't succeeded. Can you tell me the syntax for that? Thanks again. Regards, Ashish. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: Monday, March 15, 2004 2:32 PM To: U2 Users Discussion List Subject: RE: Help Needed regarding performance improvement of delete query This might help speed things up a bit ... Firstly, of course, is your file properly sized? Secondly, (and in this case you will need to run the SELECT / DELETE sequence several times) try putting a SAMPLE 1000 (or whatever number makes sense) at the end of your select. Basically, this will mean that the SELECT runs until it finds that number of records and t
RE: UV 10.1.0 on Linux
I have installed it onto SuSE and Gentoo. Aside from the uv.load script needing a bit of tweaking, it works just fine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil Walker Sent: Sunday, March 14, 2004 9:46 PM To: U2 Users Discussion List Subject: UV 10.1.0 on Linux All, I know this question has been asked before, but is UniVerse supported on versions of Linux other than Redhat, such as Debian, SUSE etc? I imagine it is not hard to get working, but would IBM then regard it as being certified? Regards, Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. infocusp limited is not responsible for any changes made to this message and / or any attachments after sending by infocusp limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment -- 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: Help Needed regarding performance improvement of delete query
I forgot to mention why. U2 definately prefers ADDing records instead of DELETing records.. any day. - Original Message - From: ashish ratna To: Anthony Youngman Cc: [EMAIL PROTECTED] Sent: Monday, March 15, 2004 7:55 AM Subject: RE: Help Needed regarding performance improvement of delete query Hi Wol, The scenario is that- We have a master file having more than 3-4 million records and have corresponding reference file which contains reference data for this master file. Now we start our purge program which selects records from master file on the basis of date. Corresponding data should be deleted from the other file (reference file). For this requirement we have adopted the approach that- select the record from master file on the basis of date. Save the list of these records, then on the basis of this list select the records from reference file. Issue is that this list contains more than 0.5 million and I want to take few (say 10,000 at a time) record ids from this list for further processing. Any pointers for this problem will be very helpful. Thanks in advance. Ashish. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 4:50 PM To: ashish ratna Subject: RE: Help Needed regarding performance improvement of delete query Ahhh I thought you were selecting records and deleting them. So the first thousand would have disappeared, and you would obviously get a different thousand next time round because the first lot would have gone :-) Sounds like that's not the case. In that case, do you have a field that is repeated across many records, but where each individual value (or range of values) wouldn't return too big a bunch of records? Or do you have a numeric id - you could declare an index on that ... Let's take that numeric id idea - and then you'll have to build on it for yourself. Declare an i-descriptor as @ID[3]. That logically partitions your file into a thousand pieces. Declare an index on this. The first term in your select will then be "WITH IDESC EQ whatever-number-you-want". That'll reduce the load on the database for each pass, you'll just need to wrap it in a loop where "whatever-number" goes from 0 to 999 Actually, what I would probably do is declare my i-descriptor as INT(@ID/30) and then run this purge daily with "whatever-number" as today's day. Obviously, it'll do nothing on the 31sts, and in March it'll do two month's work on the 29th and 30th, but you've reduced the "hit" on the system considerably. Without knowing what you're doing in more detail, it's difficult to give you any proper advice, but certainly I'll try and think of any tips that you can build upon, like this. But you need to work out what's right for you :-) NB Any reason for taking this off the mailing list? By all means cc it to me, but if you keep it on the list there are other people who may be able to help too - I'm very good at overviews, but I fall short on the logic - I think there is a way to get the next thousand records, but I haven't got a clue what the syntax is ... Cheers, Wol -Original Message- From: ashish ratna [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 10:33 To: Anthony Youngman Subject: RE: Help Needed regarding performance improvement of delete query Hi, Thanks for the nice suggestions. I have another question that, using SAMPLE once I process 1000 records (using SAMPLE 1000), how can I select next 1000 records in next run (i.e. 1001 to 2000 records and so on)? I was trying few combinations but didn't succeeded. Can you tell me the syntax for that? Thanks again. Regards, Ashish. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: Monday, March 15, 2004 2:32 PM To: U2 Users Discussion List Subject: RE: Help Needed regarding performance improvement of delete query This might help speed things up a bit ... Firstly, of course, is your file properly sized? Secondly, (and in this case you will need to run the SELECT / DELETE sequence several times) try putting a SAMPLE 1000 (or whatever number makes sense) at the end of your select. Basically, this will mean that the SELECT runs until it finds that number of records and then stops. So each sequence won't load the system so badly. Creating a huge select list will stress your ram badly ... looping through this sequence won't stress the system so badly, though you really do need to use indices to reduce the stress even more ... Create an index on various fields that you're using as your select criteria. If you're selecting old records, then you need to select on date, and this really will make life both easy and fast. The more closely you can guarantee that a select, acting on a single index, will pick up only
Re: Help Needed regarding performance improvement of delete query
Folks, It's a real nightmare when you have to purge +2gig files, eh? They can run for weeks and have your users complaining that entire week too. Nag.. nag..nag... Simple solution: Backup entire data file to media. Select what you want to KEEP and move those records to a temp file. Clearfile in a basic program or delete old data file. Rename temp file or copy records back to original data file. If you have a exclusive access window, this is a piece of cake; otherwise, you have to become more creative and carve out your own customized exclusive access window on the fly and use a whole host of mirrors hoping the phone doesn't ring with your fingerprints all over a potiential mess --- just in case you get distracted and mis-shuffle the deck :p) Bram - Original Message - From: ashish ratna To: Anthony Youngman Cc: [EMAIL PROTECTED] Sent: Monday, March 15, 2004 7:55 AM Subject: RE: Help Needed regarding performance improvement of delete query Hi Wol, The scenario is that- We have a master file having more than 3-4 million records and have corresponding reference file which contains reference data for this master file. Now we start our purge program which selects records from master file on the basis of date. Corresponding data should be deleted from the other file (reference file). For this requirement we have adopted the approach that- select the record from master file on the basis of date. Save the list of these records, then on the basis of this list select the records from reference file. Issue is that this list contains more than 0.5 million and I want to take few (say 10,000 at a time) record ids from this list for further processing. Any pointers for this problem will be very helpful. Thanks in advance. Ashish. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 4:50 PM To: ashish ratna Subject: RE: Help Needed regarding performance improvement of delete query Ahhh I thought you were selecting records and deleting them. So the first thousand would have disappeared, and you would obviously get a different thousand next time round because the first lot would have gone :-) Sounds like that's not the case. In that case, do you have a field that is repeated across many records, but where each individual value (or range of values) wouldn't return too big a bunch of records? Or do you have a numeric id - you could declare an index on that ... Let's take that numeric id idea - and then you'll have to build on it for yourself. Declare an i-descriptor as @ID[3]. That logically partitions your file into a thousand pieces. Declare an index on this. The first term in your select will then be "WITH IDESC EQ whatever-number-you-want". That'll reduce the load on the database for each pass, you'll just need to wrap it in a loop where "whatever-number" goes from 0 to 999 Actually, what I would probably do is declare my i-descriptor as INT(@ID/30) and then run this purge daily with "whatever-number" as today's day. Obviously, it'll do nothing on the 31sts, and in March it'll do two month's work on the 29th and 30th, but you've reduced the "hit" on the system considerably. Without knowing what you're doing in more detail, it's difficult to give you any proper advice, but certainly I'll try and think of any tips that you can build upon, like this. But you need to work out what's right for you :-) NB Any reason for taking this off the mailing list? By all means cc it to me, but if you keep it on the list there are other people who may be able to help too - I'm very good at overviews, but I fall short on the logic - I think there is a way to get the next thousand records, but I haven't got a clue what the syntax is ... Cheers, Wol -Original Message- From: ashish ratna [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 10:33 To: Anthony Youngman Subject: RE: Help Needed regarding performance improvement of delete query Hi, Thanks for the nice suggestions. I have another question that, using SAMPLE once I process 1000 records (using SAMPLE 1000), how can I select next 1000 records in next run (i.e. 1001 to 2000 records and so on)? I was trying few combinations but didn't succeeded. Can you tell me the syntax for that? Thanks again. Regards, Ashish. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: Monday, March 15, 2004 2:32 PM To: U2 Users Discussion List Subject: RE: Help Needed regarding performance improvement of delete query This might help speed things up a bit ... Firstly, of course, is your file properly sized? Secondly, (and in this case you will need to run the SELECT / DELETE sequence several times) try putting a SAMPLE 1000 (or whatever number makes sense) at the end of your sel
Re: Help Needed regarding performance improvement of delete query
Great points from Wol, as always. What kind of /tmp disk space do you have on this system? (Assuming that /tmp is where UV does some of it's SELECT scratch pad intermediate writing when processing large queries, consult your sites actual uvconfig for all of your actual values...). If this /tmp is small, single physical disk, or heavily fragmented, this would also contribute to poor query runtime performance. Ditto on your system's swap space, which should be at least 2X physical memory. Wol's approach of breaking down the query into selecting smaller groups of data is a great one. Chip away at the stone, methodically, consistently, and constantly. What platform is this on? What OS version? What UV Version? How much memory & disk space? How much /tmp and swap space? Are you running this query with other users on the system, who may be also trying to access the files this query is working with? Are you runing this at night when it might conflict with a backup operation? More food for thought. Regards, Scott - Original Message - From: "Anthony Youngman" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Monday, March 15, 2004 4:02 AM Subject: RE: Help Needed regarding performance improvement of delete query This might help speed things up a bit ... Firstly, of course, is your file properly sized? Secondly, (and in this case you will need to run the SELECT / DELETE sequence several times) try putting a SAMPLE 1000 (or whatever number makes sense) at the end of your select. Basically, this will mean that the SELECT runs until it finds that number of records and then stops. So each sequence won't load the system so badly. Creating a huge select list will stress your ram badly ... looping through this sequence won't stress the system so badly, though you really do need to use indices to reduce the stress even more ... Create an index on various fields that you're using as your select criteria. If you're selecting old records, then you need to select on date, and this really will make life both easy and fast. The more closely you can guarantee that a select, acting on a single index, will pick up only or mostly records that you are going to delete, the better. That will SERIOUSLY reduce the time taken and the performance hit. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ashish ratna Sent: 15 March 2004 08:25 To: [EMAIL PROTECTED] Subject: Help Needed regarding performance improvement of delete query Hi All, We are working for purging of old data from the database. But we are facing performance problems in this. We are using select query which is created dynamically on the basis of number of records. We want to know if there is any limit for size of query in Universe. Although in universe help pdf it is mentioned that there is no limit for the length of select query. But when we run the program on the file with records more than 0.5 million it gave the error- "Pid 14433 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. Memory fault(coredump)" If there is no limitation on the size of query then please suggest some other possible solution which can help us reducing the time of query and completing the process successfully without giving the error. Thanks in advance. Regards, Ashish. *** 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help Needed regarding performance improvement of delete query
Hi Wol, The scenario is that- We have a master file having more than 3-4 million records and have corresponding reference file which contains reference data for this master file. Now we start our purge program which selects records from master file on the basis of date. Corresponding data should be deleted from the other file (reference file). For this requirement we have adopted the approach that- select the record from master file on the basis of date. Save the list of these records, then on the basis of this list select the records from reference file. Issue is that this list contains more than 0.5 million and I want to take few (say 10,000 at a time) record ids from this list for further processing. Any pointers for this problem will be very helpful. Thanks in advance. Ashish. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 4:50 PM To: ashish ratna Subject: RE: Help Needed regarding performance improvement of delete query Ahhh I thought you were selecting records and deleting them. So the first thousand would have disappeared, and you would obviously get a different thousand next time round because the first lot would have gone :-) Sounds like that's not the case. In that case, do you have a field that is repeated across many records, but where each individual value (or range of values) wouldn't return too big a bunch of records? Or do you have a numeric id - you could declare an index on that ... Let's take that numeric id idea - and then you'll have to build on it for yourself. Declare an i-descriptor as @ID[3]. That logically partitions your file into a thousand pieces. Declare an index on this. The first term in your select will then be "WITH IDESC EQ whatever-number-you-want". That'll reduce the load on the database for each pass, you'll just need to wrap it in a loop where "whatever-number" goes from 0 to 999 Actually, what I would probably do is declare my i-descriptor as INT(@ID/30) and then run this purge daily with "whatever-number" as today's day. Obviously, it'll do nothing on the 31sts, and in March it'll do two month's work on the 29th and 30th, but you've reduced the "hit" on the system considerably. Without knowing what you're doing in more detail, it's difficult to give you any proper advice, but certainly I'll try and think of any tips that you can build upon, like this. But you need to work out what's right for you :-) NB Any reason for taking this off the mailing list? By all means cc it to me, but if you keep it on the list there are other people who may be able to help too - I'm very good at overviews, but I fall short on the logic - I think there is a way to get the next thousand records, but I haven't got a clue what the syntax is ... Cheers, Wol -Original Message- From: ashish ratna [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 10:33 To: Anthony Youngman Subject: RE: Help Needed regarding performance improvement of delete query Hi, Thanks for the nice suggestions. I have another question that, using SAMPLE once I process 1000 records (using SAMPLE 1000), how can I select next 1000 records in next run (i.e. 1001 to 2000 records and so on)? I was trying few combinations but didn't succeeded. Can you tell me the syntax for that? Thanks again. Regards, Ashish. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: Monday, March 15, 2004 2:32 PM To: U2 Users Discussion List Subject: RE: Help Needed regarding performance improvement of delete query This might help speed things up a bit ... Firstly, of course, is your file properly sized? Secondly, (and in this case you will need to run the SELECT / DELETE sequence several times) try putting a SAMPLE 1000 (or whatever number makes sense) at the end of your select. Basically, this will mean that the SELECT runs until it finds that number of records and then stops. So each sequence won't load the system so badly. Creating a huge select list will stress your ram badly ... looping through this sequence won't stress the system so badly, though you really do need to use indices to reduce the stress even more ... Create an index on various fields that you're using as your select criteria. If you're selecting old records, then you need to select on date, and this really will make life both easy and fast. The more closely you can guarantee that a select, acting on a single index, will pick up only or mostly records that you are going to delete, the better. That will SERIOUSLY reduce the time taken and the performance hit. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ashish ratna Sent: 15 March 2004 08:25 To: [EMAIL PROTECTED] Subject: Help Needed regarding performance improvement of delete query Hi All, We are working for purging of old data from the database. But we are facing performance problems in this. We are using s
RE: Mvquery Client Not Responding
Will et al, I don't mind answering mvQuery questions - but I would rather they were asked in the appropriate place. Otherwise a) we don't build up our support knowledgebase and b) if I'm onsite, nobody from Microgen is going to reply (I'm the only one who keeps this list open). How would you feel if the list ended up being used to ask support questions for all third party vendor products - a nice thread on Masterpack currency handling or option valuations in the DS trading applications?... An occasional question doesn't hurt - it's a good product and we've got nothing to hide - but I just want to clarify where these things should be sent. Lol Brian Leach > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, March 13, 2004 12:06 AM > Subject: Re: Mvquery Client Not Responding > > > > In a message dated 3/11/2004 8:12:17 AM Pacific Standard Time, > > [EMAIL PROTECTED] writes: > > > > > > > 1. Please do not post mvQuery questions to this list. > Either send them > to > > > your mvQuery supplier, or to mvquery support. > > > > I'm going to buy mvQuery just so I can post twelve > questions a day on it > to > > this list. > > Will > > -- > > u2-users mailing list > > [EMAIL PROTECTED] > > http://www.oliver.com/mailman/listinfo/u2-users 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
RE: Help Needed regarding performance improvement of delete query
This might help speed things up a bit ... Firstly, of course, is your file properly sized? Secondly, (and in this case you will need to run the SELECT / DELETE sequence several times) try putting a SAMPLE 1000 (or whatever number makes sense) at the end of your select. Basically, this will mean that the SELECT runs until it finds that number of records and then stops. So each sequence won't load the system so badly. Creating a huge select list will stress your ram badly ... looping through this sequence won't stress the system so badly, though you really do need to use indices to reduce the stress even more ... Create an index on various fields that you're using as your select criteria. If you're selecting old records, then you need to select on date, and this really will make life both easy and fast. The more closely you can guarantee that a select, acting on a single index, will pick up only or mostly records that you are going to delete, the better. That will SERIOUSLY reduce the time taken and the performance hit. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ashish ratna Sent: 15 March 2004 08:25 To: [EMAIL PROTECTED] Subject: Help Needed regarding performance improvement of delete query Hi All, We are working for purging of old data from the database. But we are facing performance problems in this. We are using select query which is created dynamically on the basis of number of records. We want to know if there is any limit for size of query in Universe. Although in universe help pdf it is mentioned that there is no limit for the length of select query. But when we run the program on the file with records more than 0.5 million it gave the error- "Pid 14433 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. Memory fault(coredump)" If there is no limitation on the size of query then please suggest some other possible solution which can help us reducing the time of query and completing the process successfully without giving the error. Thanks in advance. Regards, Ashish. *** 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
Help Needed regarding performance improvement of delete query
Hi All, We are working for purging of old data from the database. But we are facing performance problems in this. We are using select query which is created dynamically on the basis of number of records. We want to know if there is any limit for size of query in Universe. Although in universe help pdf it is mentioned that there is no limit for the length of select query. But when we run the program on the file with records more than 0.5 million it gave the error- "Pid 14433 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. Memory fault(coredump)" If there is no limitation on the size of query then please suggest some other possible solution which can help us reducing the time of query and completing the process successfully without giving the error. Thanks in advance. Regards, Ashish. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Installing universe as uvadm
EC Change permissions on / and /var/spool Install Change permissions back t -Original Message- From: Evgenios Charalambus [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 3:11 pm To: Discussion Universe Subject:Installing universe as uvadm I am trying to install UNIVERSE 9.5 as uvadm user on AIX 5. The installation fails because of wrong permissions. The manual mentios that the uvadm user must have write permission on the root (/) directory. How can this be acomplished? Is the security of the system compomised by allowing uvadm to write on (/)? Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users 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 [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV 10.1.0 on Linux
Dunno about 10.1 ... but 10.0 will not install on SuSE/intel without manually tweaking the install script. The install breaks almost instantly, and the daemon setup also doesn't work. That said, those two glitches are pretty easy to get round :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil Walker Sent: 15 March 2004 03:07 To: U2 Users Discussion List Subject: RE: UV 10.1.0 on Linux David, We have been running UV9.6 and UV 10.0 for a while on a non-Redhat distribution of Linux with at hardened kernel and have had no known problems ;-). But we are in the process of planning for an upgrade to 10.1.0 (although I see 10.1.1 is now out) and I am wondering what we should do. I doubt UV takes advantage of any Redhat specific features but you never know. Cheers, Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. infocusp limited is not responsible for any changes made to this message and / or any attachments after sending by infocusp limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Logan, David (SST - Adelaide) Sent: Monday, March 15, 2004 3:50 PM To: U2 Users Discussion List Subject: RE: UV 10.1.0 on Linux Hi Phil, I am not too sure about the UV certication but for Informix IBM certify to a certain release of glibc etc. so it doesn't matter which release you wish to use just make sure your libraries are the correct level. I would presume UV will be pretty similar, perhaps Leroy or Wally could shed some light as to what libraries and what release levels it requires? Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil Walker Sent: Monday, 15 March 2004 1:16 PM To: U2 Users Discussion List Subject: UV 10.1.0 on Linux All, I know this question has been asked before, but is UniVerse supported on versions of Linux other than Redhat, such as Debian, SUSE etc? I imagine it is not hard to get working, but would IBM then regard it as being certified? Regards, Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. infocusp limited is not responsible for any changes made to this message and / or any attachments after sending by infocusp limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment -- 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 *** 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