Re: [U2] Universe command that shows available shared memory

2011-02-15 Thread Tony Gravagno
From:Marc A Hilbert Is there a command that I can execute from TCL in universe (Windows 10.1.18) that indicates total available shared memory? If you have PowerShell loaded, shell from TCL or BASIC to execute this: (Single command broken into multiple lines for readability) Powershell

Re: [U2] UniVerse/SQL: This EVAL field requires a qualifying file name

2011-02-15 Thread rayw
It does wherever the column reference is or may be ambiguous (or wherever the query parser assumes it may be ambiguous!). Try this. SELECT A.field1, B.field2, EVAL B.'TESTING' AS field3 FROM table1 A, table2 B WHERE A.KeyField = B.KeyField; -Original Message- From: Shane

Re: [U2] Universe Books?

2011-02-04 Thread Manu Fernandes
Hi, Try with the beginning : Universe System Description by Universe's editor : http://www.rocketsoftware.com/u2/products/universe/resources/technical-manuals/sysdesc-v11r1.pdf Sometime return to the base is usefull. Manu -Message d'origine- De :

Re: [U2] Universe Books?

2011-02-04 Thread Tony Gravagno
I'm trying to find books http://www.pickwiki.com/cgi-bin/wiki.pl?Getting_Started It would help if people added their wisdom about reading resources to that page. Free and Open Source is such a fickle concept. Everyone wants it but so few want to support it. T

Re: [U2] Universe Books?

2011-02-03 Thread Dan McGrath
Brian Leach has some. http://www.brianleach.co.uk/pages/books.htm -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Michael McGlothlin Sent: Friday, 4 February 2011 10:31 AM To: U2 Users List Subject: [U2] Universe

Re: [U2] Universe Books?

2011-02-03 Thread fft2001
Yes give me fifteen minutes, I'm building the list now. -Original Message- From: Michael McGlothlin micha...@plumbersstock.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Feb 3, 2011 3:31 pm Subject: [U2] Universe Books? I'm trying to find books on Universe but

Re: [U2] Universe Books?

2011-02-03 Thread fft2001
Okay Michael go here http://knol.google.com/k/pick-universe-unidata-resources#view near the bottom of the page there is a heading Other Media and I've listed three books there on Pick -Original Message- From: Michael McGlothlin micha...@plumbersstock.com To: U2 Users List

Re: [U2] Universe Books?

2011-02-03 Thread Bill Brutzman
The book to get is Malcolm Bull's The Pick Programming Language, Chapman Hall, London, (c) 1994, ISBN 0 412 46660 0. Also, there are some outstanding resources at www.brianleach.co.uk folder tab Books. --Bill - Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Universe Books?

2011-02-03 Thread DavidJMurray (mvdbs.com)
Since no one else mentioned them, Rocket Software does have all the manuals online as PDF's. http://www.rocketsoftware.com/u2/resources/technical-resources Cheers, djm - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context:

Re: [U2] Universe and AIX 5.3

2011-01-22 Thread Doug
Hi: According the Universe availability matrix 10.1.12 was the first release that supported AIX 5.3. Generally, we have found on our AIX customer that the binaries on AIX have not changed significantly to cause any problems. However, Universe 10.1 was released in 2004 and is quite old. You can

Re: [U2] Universe in the cloud??

2010-12-21 Thread Symeon Breen
You can certainly host at most data centres/hosting providers many supply just the os and you can install whatever db you like, some just supply the hardware, you can also go the colo route whre they look after the infrastructure and you supply the box. As for cloud – I don’t think there

Re: [U2] Universe in the cloud??

2010-12-21 Thread Eric Rosenzweig
-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, December 21, 2010 1:11 AM To: 'U2 Users List' Subject: Re: [U2] Universe in the cloud?? You can certainly host at most data centres/hosting providers many supply just the os and you

Re: [U2] Universe in the cloud??

2010-12-20 Thread George Gallen
Isn't Space the largest implementation of the Universe in the Clouds? Are you looking for a hosting company (like Rackspace) that will house Universe? If so, I'd imagine IBM has some hosting server hosting facilities, and AiX is their thing -Original Message- From:

Re: [U2] Universe in the cloud??

2010-12-20 Thread Wols Lists
On 20/12/10 19:30, George Gallen wrote: Isn't Space the largest implementation of the Universe in the Clouds? Are you looking for a hosting company (like Rackspace) that will house Universe? If so, I'd imagine IBM has some hosting server hosting facilities, and AiX is their thing I'd

Re: [U2] Universe in the cloud??

2010-12-20 Thread Dan Fitzgerald
I like the new IBM Blade Center H's. You can mix some scarily powerful AIX blades in the same enclosure as linux windoze blades, and it's all dynamically virtual, running under PowerVM. I was going to replace a pair of p570's with the new p750 express's, but with even the lower end (JS23; you

Re: [U2] Universe in the cloud??

2010-12-20 Thread Boydell, Stuart
IBM have a cloud offering http://www.ibm.com/ibm/cloud/ with support for AIX. -Original Message- Does anyone know of a large implementation of Universe in the cloud? We're currently on an IBM P570 with 16cpu and 32gb of RAM. We're looking to upgrade to a 48 processer box with 192gb

Re: [U2] universe SQL sort speed with mv associations?

2010-12-17 Thread Shane Ricciardi
Boydell, Stuart Stuart.Boydell at spotless.com.au writes: Hmm, I just tried the 2 different selects ... order by f1,f2 ... and order by @id,f1,f2 on one of my files with 27000 items/ 15 exploded rows and there was no appreciable difference between the 2. The select took only about a 2

Re: [U2] universe SQL sort speed with mv associations?

2010-12-16 Thread John Jenkins
What's the volume here? Adding the ORDER BY clause will cause the data to be pre-processed before the result set starts to get returned. Also, if you ignore how long it takes to *start* returning the result set, how do the two compare in returning the *complete* result set? Regards JayJay

Re: [U2] universe SQL sort speed with mv associations?

2010-12-16 Thread Shane Ricciardi
John Jenkins u2guru at btinternet.com writes: What's the volume here? Adding the ORDER BY clause will cause the data to be pre-processed before the result set starts to get returned. Also, if you ignore how long it takes to *start* returning the result set, how do the two compare in

Re: [U2] universe SQL sort speed with mv associations?

2010-12-16 Thread FFT2001
A simple select runs through the file and immediately begins to return results, in the order the file in actually laid down on disk. It's very fast. Anytime you sort, the system, has to create a workspace to sort in, and then start adding and re-arranging elements as it encounters them. It

Re: [U2] universe SQL sort speed with mv associations?

2010-12-16 Thread Boydell, Stuart
I'm not sure if it makes any difference but what if you try SELECT FIELD1, FIELD2, FIELD3, FIELD4 FROM TABLE_THE.ASSOC WHERE FIELD3 = '01/01/2010' ORDER BY @ID,FIELD1,FIELD2,FIELD3,FIELD4; This would (theoretically) only have to explode/sort the MVs within an item, not against the whole table

Re: [U2] universe SQL sort speed with mv associations?

2010-12-16 Thread Boydell, Stuart
Of Boydell, Stuart Sent: Friday, 17 December 2010 11:26 To: U2 Users List Subject: Re: [U2] universe SQL sort speed with mv associations? I'm not sure if it makes any difference but what if you try SELECT FIELD1, FIELD2, FIELD3, FIELD4 FROM TABLE_THE.ASSOC WHERE FIELD3 = '01/01/2010' ORDER

Re: [U2] UniVerse on Unix - enabling SSL

2010-11-12 Thread Dean
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Michael Pflugfelder Sent: 08 November 2010 18:56 To: U2 Users List Subject: Re: [U2] UniVerse on Unix - enabling SSL Dean, I seem to remember that I had to manually create the inetd or xinetd (if linux) configuration

Re: [U2] UniVerse on Unix - enabling SSL

2010-11-12 Thread Dean
2010 18:50 To: U2 Users List Subject: Re: [U2] UniVerse on Unix - enabling SSL Dean, There are couple of things you can do. 1. Verify the uvtelnetd service is listening to the SSL port that you are connecting to. 2. Make sure to refresh the inetd (or xinetd) daemon to re-read the configuration after

Re: [U2] UniVerse On RedHat?

2010-11-09 Thread inquieti
Hi Bill Just to add my twopence worth:- 1 RedHat is excellent but it's best to use the Enterprise version or you may run into problems (ran out of inodes on the normal version) 2 It's always best to re-compile and re-catalog anyway. Also, you will need to fnuxi the files beforehand. 3 Went from

Re: [U2] UniVerse On RedHat?

2010-11-08 Thread George Gallen
-Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, November 05, 2010 5:59 PM To: U2 Users List Subject: [U2] UniVerse On RedHat? 0. We are considering migrating from HP-Ux to RedHat.

Re: [U2] UniVerse on Unix - enabling SSL

2010-11-08 Thread Dean Napper
I should add that I've opened port 992 on the firewall as well. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dean Napper Sent: 08 November 2010 15:32 To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse on Unix

Re: [U2] UniVerse On RedHat?

2010-11-08 Thread Drew William Henderson
-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, November 08, 2010 8:40 AM To: U2 Users List Subject: Re: [U2] UniVerse On RedHat? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill

Re: [U2] UniVerse on Unix - enabling SSL

2010-11-08 Thread Carl Dula
UniAdmin normally uses port 31438 as the default. Assuming you know this and did not change it, then your firewall must have port forwarding enabled to go from the WAN address you are using at port 992, to the LAN address of the server with uv at port 31438. Depending upon the type firewall

Re: [U2] UniVerse on Unix - enabling SSL

2010-11-08 Thread Dean Napper
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Carl Dula Sent: 08 November 2010 16:22 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse on Unix - enabling SSL UniAdmin normally uses port 31438 as the default. Assuming you know this and did not change it, then your

Re: [U2] UniVerse on Unix - enabling SSL

2010-11-08 Thread Carl Dula
@listserver.u2ug.org Sent: Monday, November 08, 2010 11:21 AM Subject: RE: [U2] UniVerse on Unix - enabling SSL UniAdmin normally uses port 31438 as the default. Assuming you know this and did not change it, then your firewall must have port forwarding enabled to go from the WAN address you are using at port 992

Re: [U2] UniVerse on Unix - enabling SSL

2010-11-08 Thread Rajesh Menon
Dean, There are couple of things you can do. 1. Verify the uvtelnetd service is listening to the SSL port that you are connecting to. 2. Make sure to refresh the inetd (or xinetd) daemon to re-read the configuration after adding the SSL services. 3. Start the uvtelnetd service using the '-d3'

Re: [U2] UniVerse on Unix - enabling SSL

2010-11-08 Thread Michael Pflugfelder
-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dean Napper Sent: Monday, November 08, 2010 11:47 AM To: 'U2 Users List' Subject: Re: [U2] UniVerse on Unix - enabling SSL Hi Carl, Thanks for the info but I have UniAdmin working on its default port. That part

Re: [U2] UniVerse on Unix - enabling SSL

2010-11-08 Thread Symeon Breen
I usually configure unix and not u2 for ssh/ssl connectivity. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dean Napper Sent: 08 November 2010 15:32 To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse on Unix - enabling SSL

Re: [U2] UniVerse On RedHat?

2010-11-06 Thread Boydell, Stuart
Using AIX to Fedora for development. Copy prod (aix) to dev (fed) from time to time. 1 - (fedora) excellect 2 - no 3 - no 4 - Fedora is the bleeding edge / techy / non certified / free version of RedHat. I imagine that the stable/certified RedHat version is also excellent. 5 - no 6 - File

Re: [U2] UniVerse On RedHat?

2010-11-06 Thread Manu Fernandes
Hi group, hi bill, My company is a software house, Linux RH is the dev-plateform and the primary platform of our deployment. Rocket/U2 certifies under RH and RH Enterprise, but UV run perfectly on Fedora release too. We run with RH from years without problem. If you choose Enterprise, you get

Re: [U2] UniVerse On RedHat?

2010-11-05 Thread Drew William Henderson
-Original Message- From: Bill Brutzman bi...@hkmetalcraft.com Sent: Friday, November 05, 2010 5:59 PM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] UniVerse On RedHat? 0. We are considering migrating from HP-Ux to RedHat. 1. How is RedHat? It's been quite a few years

Re: [U2] UniVerse On RedHat?

2010-11-05 Thread Clive Hills
The utility is called fnuxi. Clive ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniVerse On RedHat?

2010-11-05 Thread Wols Lists
On 05/11/10 22:21, Drew William Henderson wrote: -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com Sent: Friday, November 05, 2010 5:59 PM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] UniVerse On RedHat? 0. We are considering migrating from HP-Ux to

Re: [U2] UniVerse On RedHat?

2010-11-05 Thread jpb-u2ug
I've never moved UV from HP-Ux to Red Hat but I have worked on both. We went from a Sun Risc system to Red Hat on Intel and, like Drew said, you would have to do recompiling of programs and I-descriptors, and either uvbackup/uvrestore or fnuxi the files. If you use any operating system scripts or

Re: [U2] UniVerse DOS Command - Batch File Error

2010-11-02 Thread Robert Houben
If your batch file is named myfile.bat, then try executing the DOS command cmd.exe /c myfile.bat. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 12:35 PM To: 'U2 Users

Re: [U2] UniVerse DOS Command - Batch File Error {Unclassified}

2010-11-02 Thread HENDERSON MIKE, MR
Don, The DOS command is pretty badly broken, particularly if you need to try to use a quoted string with embedded spaces (e.g. '... C:\Program Files\MyApp\AppName.exe ...'). After I bitched about it, a new GCI function UVRunCommand was introduced (in 10.0 IIRC). You need code like this

Re: [U2] UniVerse DOS Command - Batch File Error - Found word(s) list error in the Text body

2010-11-02 Thread Mark Eastwood
Permissions? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 3:33 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse DOS Command - Batch File Error - Found word(s) list

Re: [U2] UniVerse DOS Command - Batch File Error

2010-11-02 Thread Bob Woodward
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 4:05 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse DOS Command - Batch File Error Yes. I've actually moved the .bat file to the C:\ root directory and tested it there as well

Re: [U2] UniVerse DOS Command - Batch File Error

2010-11-02 Thread Don P. Nagai
...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Tuesday, November 02, 2010 4:12 PM To: U2 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error Something I've run into before is location of the TEMP directory. I had a C:\tmp but was pointed to C:\TEMP in the environment variables

Re: [U2] UniVerse DOS Command - Batch File Error

2010-11-02 Thread Don P. Nagai
Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error Rather than double clicking to run the bat, have you tried opening a dos command prompt (Start Run cmd) and then cd'ing to the directory the batch file is in and running the bat from there, as this should keep the window open

Re: [U2] UniVerse DOS Command - Batch File Error unclassified

2010-11-02 Thread MACK ANDREW, MR
November 2010 12:22 p.m. To: 'U2 Users List' Subject: Re: [U2] UniVerse DOS Command - Batch File Error Thank you. I'll give this a try right after testing to see if the Temp folder issue has an impact. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] UniVerse Licensing UpDate

2010-10-08 Thread John Hester
Does that mean you have to buy standard UV seats for a cold-spare where a UV instance isn't actively running? I hope that's not the case. Our management isn't going to go for a 100% price hike next time we upgrade our hardware. -John -Original Message- From:

Re: [U2] UniVerse Licensing UpDate

2010-10-08 Thread Bill Brutzman
Of John Hester Sent: Friday, October 08, 2010 2:08 PM To: U2 Users List Subject: Re: [U2] UniVerse Licensing UpDate Does that mean you have to buy standard UV seats for a cold-spare where a UV instance isn't actively running? I hope that's not the case. Our management isn't going to go for a 100

Re: [U2] UniVerse Global Cataloging

2010-10-08 Thread Rick Nuckolls
Bill, Normally, during an upgrade of Universe, the catalog space is preserved, with updates for the Universe provided subroutines. You did not specify which platform, but it would be critical that you do any copy using the underlying OS command rather than a UV COPY, which could corrupt the

Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key

2010-08-07 Thread Hona, David
The most common problems with conversions to new versions of UV is that the UVCONFIG parameters are not aligned to what they were under the previous release and/or what is appropriate for the new OS and UV version. Where applicable you must also ensure if you are re-hosting (ie., different

Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key

2010-08-05 Thread Wols Lists
On 05/08/10 00:24, Aramaies wrote: Good Day, We are in the process of upgrading from Universe 9.6 to 10.3, and we have noticed that the system performance is degraded when we use an I-Type dictionary with subroutine calls, and the item is also an alternate key. It seems that the report

Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key

2010-08-05 Thread David Wolverton
-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, August 05, 2010 10:23 AM To: U2 Users List Subject: Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key On 05/08/10 00:24

Re: [U2] Universe Triggers

2010-08-02 Thread Boydell, Stuart
FYI the best doco on using triggers is in Chapter 5 of the Universe SQL Reference pdf. It's pretty comprehensive. Regards. -Original Message- AIX 5.3 UV 10.2Universe I want to put a trigger on a file to send an email message then a new item is written. I have read the (very

Re: [U2] Universe Triggers

2010-08-01 Thread Jeff Schasny
. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, July 30, 2010 12:47 PM To: U2 Users List Subject: Re: [U2] Universe Triggers Thank you all

Re: [U2] Universe Triggers

2010-07-31 Thread David A. Green
...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, July 30, 2010 12:47 PM To: U2 Users List Subject: Re: [U2] Universe Triggers Thank you all. After much putzing with the various parts involved it is beginning to look like my original plan of having an email message sent when someone adds a new record

Re: [U2] Universe Triggers

2010-07-30 Thread Barry Rutherford
Your subroutine has to be globally cataloged - nothing else will work. The syntax of the create trigger that works for me is this: CREATE TRIGGER BEFORE_INSERT BEFORE INSERT ON (FILE NAME) FOR EACH ROW CALLING *(subroutine name) BEFORE_INSERT - name I gave my trigger - can be anything you want

Re: [U2] Universe Triggers

2010-07-30 Thread Israel, John R.
Subject: Re: [U2] Universe Triggers Thank You. Now I need to drop the trigger and re create it. What is the drop trigger syntax? Is all this actually documented somewhere? Barry Rutherford wrote: Your subroutine has to be globally cataloged - nothing else will work. The syntax of the create

Re: [U2] Universe Triggers

2010-07-30 Thread Jeff Schasny
Thank You. Now I need to drop the trigger and re create it. What is the drop trigger syntax? Is all this actually documented somewhere? Barry Rutherford wrote: Your subroutine has to be globally cataloged - nothing else will work. The syntax of the create trigger that works for me is this:

Re: [U2] Universe Triggers

2010-07-30 Thread Jeff Schasny
So far so good. Trigger installed. Trigger blows up. My trigger program calls the *MAIL.SEND routine (which works when called from other programs in this account) which is apparently blowing up when attempting to write an item to the current directory (UFD) at line 214. Anyone have a guess on

Re: [U2] Universe Triggers

2010-07-30 Thread Mark Eastwood
Before any WRITE, you must do a READU first Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, July 30, 2010 11:47 AM To: U2 Users List Subject: Re: [U2] Universe Triggers So far so

Re: [U2] Universe Triggers

2010-07-30 Thread Henry Unger
Lock the record before you write it. Henry Unger Sent from my iPad On Jul 30, 2010, at 2:47 PM, Jeff Schasny jscha...@gmail.com wrote: So far so good. Trigger installed. Trigger blows up. My trigger program calls the *MAIL.SEND routine (which works when called from other programs in this

Re: [U2] Universe Triggers

2010-07-30 Thread Jeff Schasny
Thank you all. After much putzing with the various parts involved it is beginning to look like my original plan of having an email message sent when someone adds a new record to this file is not to be. Apparently executing an SH verb in a trigger program is not going to happen (Verb SH

Re: [U2] Universe Triggers

2010-07-30 Thread Robert Porter
How real-time does it need to be? Could you write them to a queue file and have a small batch process pick them up and email them? Rob Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any

Re: [U2] Universe Triggers

2010-07-30 Thread Mark Eastwood
] On Behalf Of Jeff Schasny Sent: Friday, July 30, 2010 12:47 PM To: U2 Users List Subject: Re: [U2] Universe Triggers Thank you all. After much putzing with the various parts involved it is beginning to look like my original plan of having an email message sent when someone adds a new record

Re: [U2] Universe Triggers

2010-07-30 Thread Barry Rutherford
Subject: Re: [U2] Universe Triggers Thank you all. After much putzing with the various parts involved it is beginning to look like my original plan of having an email message sent when someone adds a new record to this file is not to be. Apparently executing an SH verb in a trigger program

Re: [U2] Universe Triggers

2010-07-30 Thread Jeff Schasny
] On Behalf Of Jeff Schasny Sent: Friday, July 30, 2010 3:47 PM To: U2 Users List Subject: Re: [U2] Universe Triggers Thank you all. After much putzing with the various parts involved it is beginning to look like my original plan of having an email message sent when someone adds a new record

Re: [U2] Universe Triggers

2010-07-30 Thread Henry Unger
I was wondering if that's what you're up to. I'm not at my computer, but try PHANTOMing it. Henry Unger Sent from my iPad On Jul 30, 2010, at 3:48 PM, Jeff Schasny jscha...@gmail.com wrote: Thank you all. After much putzing with the various parts involved it is beginning to look like my

Re: [U2] Universe Triggers

2010-07-30 Thread phil walker
- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Barry Rutherford Sent: Saturday, 31 July 2010 8:01 a.m. To: U2 Users List Subject: Re: [U2] Universe Triggers Have the subroutine that's called from your trigger routine write a record

Re: [U2] Universe Triggers

2010-07-30 Thread Neil Richards
To: U2 Users List Subject: Re: [U2] Universe Triggers Thank You. Now I need to drop the trigger and re create it. What is the drop trigger syntax? Is all this actually documented somewhere? Barry Rutherford wrote: Your subroutine has to be globally cataloged - nothing else will work. The syntax

Re: [U2] Universe: AE just ... disappears?

2010-07-14 Thread Brett Callacher
Which version of Windows is this? We have had a number of strange problems with Windows 2008 R2 - these all resolved to use of UAC which is turned on by default. Kevin King precisonl...@gmail.com wrote in message news:aanlktiklo_vayllx_pahiuxw9ot3gtlkezhnp4hsk...@mail.gmail.com... We have

Re: [U2] Universe: AE just ... disappears?

2010-07-13 Thread FFT2001
Comparing the stability of UV with the instability of Windows, I think your problem lies elsewhere. By the way catalog pointers can disappear if someone (or someTHING) does a Decatalog. I've seen cases where programmers write routines to decatalog which works and then try to recatalog the

Re: [U2] Universe: AE just ... disappears?

2010-07-13 Thread Tom Whitmore
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Tuesday, July 13, 2010 8:29 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe: AE just ... disappears? Comparing the stability of UV with the instability of Windows, I think your problem lies elsewhere

Re: [U2] Universe and stripped drives

2010-04-29 Thread asvin . dattani
...@listserver.u2ug.org Apr 28 2010 19:15 Mail Size: 10755 Please respond to U2 Users List u2-users@listserver.u2ug.org To U2 Users List u2-users@listserver.u2ug.org cc Subject Re: [U2] Universe and stripped drives Entity Investment Banking Europe - IBEU Do you do a dbpause at all during

Re: [U2] Universe and stripped drives

2010-04-29 Thread Anthony W. Youngman
In message 6d57ef06d84b5541af530227504bb68f5c4f4ef...@34093-mbx-c06.mex07a.mlsrvr.c om, George Gallen ggal...@wyanokegroup.com writes This I will have to look into. Right now I'm deciding if I want to setup the partitions in an LVM or not. To follow up a little further, look at log-based file

Re: [U2] Universe and stripped drives

2010-04-28 Thread bradley . schrag
I am not a disk guy, but striping has provided significant performance gains for. Separating the busiest files from everything else can also help a lot; it keeps your busiest files from dragging down the rest of the system/account. If you're on *nix, you can do some very creative things like

Re: [U2] Universe and stripped drives

2010-04-28 Thread Dave Laansma
My opinion is to stripe all your data over as many drives as possible. Regarding mirroring, I would suggest a third mirror. The third mirror can be broken anytime during the day and used for backup, then 're-sync'd.' This configuration provides for minimum data loss due to (the number one cause

Re: [U2] Universe and stripped drives

2010-04-28 Thread George Gallen
28, 2010 1:12 PM To: U2 Users List Subject: Re: [U2] Universe and stripped drives I am not a disk guy, but striping has provided significant performance gains for. Separating the busiest files from everything else can also help a lot; it keeps your busiest files from dragging down the rest

Re: [U2] Universe and stripped drives

2010-04-28 Thread George Gallen
drives - diffenent controllers). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Wednesday, April 28, 2010 1:16 PM To: U2 Users List Subject: Re: [U2] Universe and stripped drives My opinion

Re: [U2] Universe and stripped drives

2010-04-28 Thread Dan Fitzgerald
If you create 2 stripes, will you have 2 disk controllers? If not, I don't see much difference between the two. I'd be more concerned with file sizing, and using indices rather than sequential searches, and other tuning techniques (read-ahead parameters, file caching, fs buffering, etc.). One

Re: [U2] Universe and stripped drives

2010-04-28 Thread Dave Laansma
Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, April 28, 2010 1:28 PM To: U2 Users List Subject: Re: [U2] Universe and stripped drives

Re: [U2] Universe and stripped drives

2010-04-28 Thread Anthony W. Youngman
In message 6d57ef06d84b5541af530227504bb68f5c4f4ef...@34093-mbx-c06.mex07a.mlsrvr.c om, George Gallen ggal...@wyanokegroup.com writes I planned on doing this as well. There will be 3 system drives which I'm going to put some of our busy temp files. How much ram have you got? How big are your

Re: [U2] Universe and stripped drives

2010-04-28 Thread Dan Fitzgerald
In most unixes, you can do it at the OS level. From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Date: Wed, 28 Apr 2010 12:27:34 -0500 Subject: Re: [U2] Universe and stripped drives interesting idea. Wonder if our RAID controller can do a 3 way mirror? I'll have to check

Re: [U2] Universe and stripped drives

2010-04-28 Thread Jeff Schasny
In their UniVerse High Availability Executive Overview IBM suggested Raid 1 + 0 for production data partitions. See the page from the document here: http://www.schasny.com/stuff/ or the whole document here: http://www.schasny.com/stuff/ha.pdf George Gallen wrote: We are in the process of

Re: [U2] Universe and stripped drives

2010-04-28 Thread Robert Porter
Many 'nix systems not longer require breaking mirrors for backups... We haven't broken a mirror for backups since the late 90s. HP-UX and Linux for example. A MUCH better option is using logical volumes (and yes, you can still mirror and stripe) as well and use filesystem snapshots to backup.

Re: [U2] Universe and stripped drives

2010-04-28 Thread Brutzman, Bill
I am filled with wonder for the salesman who sells striping of solid-state server drives. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, April 28, 2010 12:47 PM To: U2 Users

Re: [U2] Universe and stripped drives

2010-04-28 Thread Baakkonen, Rodney A (Rod) 46K
Do you do a dbpause at all during this snapshot process? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Wednesday, April 28, 2010 1:09 PM To: U2 Users List Subject: Re: [U2] Universe

Re: [U2] Universe and stripped drives

2010-04-28 Thread George Gallen
, just some error messages. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Wednesday, April 28, 2010 2:12 PM To: U2 Users List Subject: Re: [U2] Universe and stripped drives I am filled

Re: [U2] Universe and stripped drives

2010-04-28 Thread George Gallen
:09 PM To: U2 Users List Subject: Re: [U2] Universe and stripped drives Many 'nix systems not longer require breaking mirrors for backups... We haven't broken a mirror for backups since the late 90s. HP-UX and Linux for example. A MUCH better option is using logical volumes (and yes, you can

Re: [U2] Universe and stripped drives

2010-04-28 Thread Glen Batchelor
...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, April 28, 2010 2:21 PM To: U2 Users List Subject: Re: [U2] Universe and stripped drives I considered adding a few SSD to our server, but given they 'wear' out faster with increased writes

Re: [U2] Universe and stripped drives

2010-04-28 Thread Robert Porter
: Wednesday, April 28, 2010 1:09 PM To: U2 Users List Subject: Re: [U2] Universe and stripped drives Many 'nix systems not longer require breaking mirrors for backups... We haven't broken a mirror for backups since the late 90s. HP-UX and Linux for example. A MUCH better option is using logical

Re: [U2] Universe and stripped drives

2010-04-28 Thread George Gallen
Users List' Subject: Re: [U2] Universe and stripped drives Look at EasyCo's MFT. I'm still trying to sort out drive-specific issues, but initial performance benchmarks are just awesome. We have 4 OCZ Vertex Turbo 60GB drives in softRAID level 5. The restructuring of the block writes

Re: [U2] Universe and stripped drives

2010-04-28 Thread Robert Porter
-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Wednesday, April 28, 2010 2:09 PM To: U2 Users List Subject: Re: [U2] Universe and stripped drives Many 'nix systems not longer require breaking mirrors for backups... We haven't

Re: [U2] UniVerse Programmer Job Opening

2010-04-23 Thread fft2001
Before y'all ask, Orbit Irrigantion is located in Bountiful, Utah 84011 I just know you're all gonna ask in like two seconds. Will the faux mind reader Johnson -Original Message- From: Bryan Evans melbryev...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent:

Re: [U2] UniVerse Programmer Job Opening

2010-04-23 Thread McGowan, Ian
Before everyone piles in, those candidates who cannot figure out which continent this job is offered on need not apply.. :-) Ian McGowan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bryan Evans Sent: Friday,

Re: [U2] UniVerse Slow - Fixed

2010-03-11 Thread David A Barrett
Bill, File MESSAGES Type= 2 Modulo= 1 Sep= 1 Coming across one of these in a system I'm working on always steams me. It has to be one of silliest and most easily avoidable time-bombs people can set in a system. The difference between a modulo 11 and a modulo 1 file on performance is

Re: [U2] UniVerse Slow - Fixed

2010-03-11 Thread Brutzman, Bill
@listserver.u2ug.org Subject: Re: [U2] UniVerse Slow - Fixed Bill, File MESSAGES Type= 2 Modulo= 1 Sep= 1 Coming across one of these in a system I'm working on always steams me. It has to be one of silliest and most easily avoidable time-bombs people can set in a system. The difference

Re: [U2] UniVerse Slow - Fixed

2010-03-11 Thread Dan Fitzgerald
...@hkmetalcraft.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Slow - Fixed Dave: Thanks for pointing this out. It happened to me because I have a habit of grabbing the first example out of the UniVerse Reference Manual. I just marked up my copy. Upon seeing this post

Re: [U2] UniVerse Slow - Fixed

2010-03-10 Thread Symeon Breen
So after all that it was file sizing which should really be one of the first things you check Lol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: 09 March 2010 23:08 To: U2 Users List

Re: [U2] UniVerse on Windows 2003 Server - Environment

2010-03-08 Thread Anthony W. Youngman
In message 4b8d4c38.3010...@advantos.net, Bill Haskett wphask...@advantos.net writes When you experience the slowdown, check the Task Manager. It is likely you'll see something bad there. If not, you should get the sysinternals code procmon and diskmon. They'll help too, if the problem

<    1   2   3   4   5   6   7   8   9   10   >