RE: [U2] RE: Switching from D3 to U2
-Original Message- From: MAJ So what's the number one reason for switching from D3 to U2? Not to create an onslaught of replies, but I've worked on many MV platforms and have my opinions on each. Because our VAR told use they wouldn't support their product on D3 any longer. grin === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Real programmers don't document. Documentation is for simps who can't read the listings or the object deck. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] problem calling program from shell script
Thank you to those who proposed ideas. The issue appears to be something in the vendor code over which I have no control. Working with vendor now. Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Does UniVerse work with clusters of Unix machines?
UniVerse release 10.1.12 I am not using UV Transaction Logging or Replication. I'd like to be able to hook our IBM P570 and P650, and a Linux PC together, and have one instance of UniVerse using all computers, balancing the load between them, and sharing files and accounts between them (e.g. LOGTO P570 or LOGTO P650). I've never heard of IBM's HACMP clustering software. I will look into it. Thanks for the info. -- Louie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV phantoms
I've got a paragraph (UniVerse, Pick flavor) I run every night that copies all phantoms 3 days or older to a PH.BAK file, in case I want them later, a painless way to keep the PH file cleaned out. SELECT PH WITH DATE LT THREE.DAYS.AGO OR WITH (DATE = THREE.DAYS.AGO AND TIME LT 08:00:00pm) SAVE.LIST PH.CLEANUP GET.LIST PH.CLEANUP IF @SYSTEM.RETURN.CODE LT 1 THEN GO NO.RECORDS COPY PH DATA (PH.BAK DATA GET.LIST PH.CLEANUP IF @SYSTEM.RETURN.CODE LT 1 THEN GO NO.RECORDS [I know, overkill, but I like to be sure...] DELETE PH ... LIST DICT PH DATETIMETHREE.DAYS.AGO DICT PH01:24:23pm 04 Feb 2008 Page1 Field. Type Field Conversion.. Column. Output Depth Name.. Field. Definition... Code Heading Format Assoc.. Number DATE I FIELD(@ID,_ D2/ 10RS ,3) THREE.DAYS.AGO I @DATE - 3 D11RS TIME I FIELD(@ID,_ MTHS 10RS ,2) 3 records listed. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
After you issue the dbpause, drop to aix as root and do a few sync commands, thusly: # sync cr # sync cr # sync cr I usually give it a few seconds in between issuing the commands, but when I script it, it's sync; sync; sync, so there's probably no reason to wait in between. This flushes all pending writes to persistent memory (for our purposes, disk). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Monday, February 04, 2008 3:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects error 30105 Unable to load subroutine on server
In message [EMAIL PROTECTED], David Jordan [EMAIL PROTECTED] writes Hi Wol UniObjects does not like returning unassigned variables, it causes a fatal. In the unibasic subroutine, you could check if the parameter is unassigned and set it to before returning. Thanks - that's a good thing to know. But it's not the case here. The error is that the subroutine never gets called, if I've got it right. Certainly, none of the DataBasic code seems to run (almost the first thing it does is write diagnostic tracking stuff to a file, and that never happens). And all the arguments are assigned in my VB app before I call it, so they should still be assigned when it returns :-) Thanks, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
I tried suspend the other day and was surprised to find that if you suspended the database while a lock was present it preserved the lock making it stop a copy waiting for the lock to be released. This is on UV 10.1.12. So I'm not surprised that it could cause other problems. You need to get everyone to stop updating and releasing all locks before setting the suspend. Jerry Banker -Original Message- From: Louie Bergsagel [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 2:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
Louie, After you suspend the database, you need to do an AIX sync in order to flush any writes that are still sitting in memory. That resolved a similar issue for us. HTH Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Monday, February 04, 2008 2:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: PCL: command
hello, how do you write multiple PCL command in one program, I have a program that I need to write a compress 8pt arial narrow and another font within the same letter. Right now I am using esc(s20H and the printout compress it but the height stayed so I have a visible space between lines. any ideas would be greatly appreciated. thanks! Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
Louie Bergsagel wrote: I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ If you are using jfs2 filesystems you can create snapshots (man snapshot) then copy from the snapshot to your other system. I recommend rsync for the copy also if you wanted to avoid NFS. You should still quiesce the database, though. But it would reduce your downtime to seconds, potentially. It boils down to this... stopud (or dbpause) create snapshots mount snapshots startud (or dbresume) copy at your leisure remove snapshots I've never used dbpause, probably because the thought of many many transactions being buffered until dbresume scares me. Louis --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: PCL: command
David, For commands with the same prefix (2 characters after ESC), change the last character to lower case in all commands except the last. In any case there shouldn't be a problem just concatenating the commands. Most printer manufacturers have downloadable manuals which include PCL defintions - if not refer to HP, who invented it! Francis - Original Message - From: david yu [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 05, 2008 12:12 PM Subject: [U2] Re: PCL: command hello, how do you write multiple PCL command in one program, I have a program that I need to write a compress 8pt arial narrow and another font within the same letter. Right now I am using esc(s20H and the printout compress it but the height stayed so I have a visible space between lines. any ideas would be greatly appreciated. thanks! Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
If business data integrity is a major concern, then you also need to ensure you business processing is complete and (ideally) - shutdown the UniVerse environment prior to any manipulation of UV database files using third-party/OS tools (rm, cp, rcp, scp, mv, tar, etc, etc). For high-availability systems, stopping UV isn't an feasible option for daily snapshot backups. Caution needs to be exercised at the target end (for your backup) as well. Especially if you're overwritting existing disk backups which may be in use, etc. Then you will get logical file corruptions, especially if dealing with open dynamic files. Hence, extreme care is need for the backup and restore of dynamic files. Also be aware that UniVerse files with indices need to have 'SET.INDEX' run against them post-restore (if in a complete different path), if you're going to access the backup version (and want to use the correct index AND stop corrupt of your live version if co-located on the same host:)). Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Tuesday, February 05, 2008 8:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer After you issue the dbpause, drop to aix as root and do a few sync commands, thusly: # sync cr # sync cr # sync cr I usually give it a few seconds in between issuing the commands, but when I script it, it's sync; sync; sync, so there's probably no reason to wait in between. This flushes all pending writes to persistent memory (for our purposes, disk). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Monday, February 04, 2008 3:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer I'm trying to copy UniVerse files (all types) from one computer to another using an NFS mount and the Unix cp command, but am getting damaged files because they are in use. They are large files, between 4 and 22 gigs, some hashed, some dynamic, some directories. I tried to suspend UniVerse and then copy one file or directory, then unsuspend, but that hasn't helped. I am wondering if I need to pause a minute or so between the suspend (uv -admin -L) and the copy? In other words, is suspend immediate, or does it finish all the current writes and then pause? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV Linux under FreeBSD?
Gabriel Green wrote: Has anyone successfully installed UV Linux under FreeBSD using FreeBSD's Linux ABI emulation layer? --GG I've been trying w/ NetBSD, but currently have problems with Shared Memory allocation. Louis --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: PCL: command
I'm surprised someone in any MV hasn't submitted a comprehensive PCL.INCLUDE that would help many of these requests. I have one that I use for 60% of what I need (pitch, orientation, typefaces, some line graphics and other simple functions) but I'm sure there could be a greatest hits INCLUDE that has the advanced stuff as well. My 1 cent Mark Johnson - Original Message - From: david yu [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 04, 2008 9:12 PM Subject: [U2] Re: PCL: command hello, how do you write multiple PCL command in one program, I have a program that I need to write a compress 8pt arial narrow and another font within the same letter. Right now I am using esc(s20H and the printout compress it but the height stayed so I have a visible space between lines. any ideas would be greatly appreciated. thanks! Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Fw: [U2] Re: PCL: command - addendum
Should have mentioned you drop the ESC prefix on commands after the first. - Original Message - From: Francis Bennett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 05, 2008 3:18 PM Subject: Re: [U2] Re: PCL: command David, For commands with the same prefix (2 characters after ESC), change the last character to lower case in all commands except the last. In any case there shouldn't be a problem just concatenating the commands. Most printer manufacturers have downloadable manuals which include PCL defintions - if not refer to HP, who invented it! Francis - Original Message - From: david yu [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 05, 2008 12:12 PM Subject: [U2] Re: PCL: command hello, how do you write multiple PCL command in one program, I have a program that I need to write a compress 8pt arial narrow and another font within the same letter. Right now I am using esc(s20H and the printout compress it but the height stayed so I have a visible space between lines. any ideas would be greatly appreciated. thanks! Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Switching from D3 to U2
Doesn't sound like a real useful reason for the rest of us. Thanks Mark Johnson - Original Message - From: Norman Morgan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 04, 2008 10:13 AM Subject: RE: [U2] RE: Switching from D3 to U2 -Original Message- From: MAJ So what's the number one reason for switching from D3 to U2? Not to create an onslaught of replies, but I've worked on many MV platforms and have my opinions on each. Because our VAR told use they wouldn't support their product on D3 any longer. grin === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Real programmers don't document. Documentation is for simps who can't read the listings or the object deck. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/