RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly
Does the same thing happen when you use SELECT filename SAVING [UNIQUE] field NO.NULLS? I'm not on Unidata so I can't try it. Universe doesn't have the BSELECT command. @SYSTEM.RETURN.CODE only returns 0 on a select so we use @SELECTED which does return the full amount in the select list. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 25, 2007 4:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly My apologies for the poor job I did posting this. I sent it before I had completed the subscribe procedures. I blame it on my vacation. :-) Because of my mistake, I didn't get the replies. I had to get them from the list archive. Here are my replies to the replies: To Dave Davis, who said, If you were curious about the number of customers queried couldn't you just do a SELECT CUSTOMER first? I agree. Or, if you had done a previous select to whittle down the list, you'd already know how many records would be queried for the BSELECT. To David A. Green, who said, SYSTEM(11) returns number of items in the active select list. I think we should leave the @SYSTEM.RETURN.CODE as the number of records selected. @SYSTEM.RETURN.CODE is NOT the number of records selected. That is the problem. It is the number of records queried/polled, not the number of items returned in the select list. Those numbers will not be the same for a multivalued attribute or if the attribute is null and UDT.OPTION 59 is ON. Try this and see if you feel the same way about @SYSTEM.RETURN.CODE: EXECUTE 'UDT.OPTIONS 59 ON' CMD1 = 'BSELECT CUSTOMER WITH @ID GE 200 TAPES_RENTED' CRT CMD1 EXECUTE CMD1 IF @SYSTEM.RETURN.CODE GT 0 THEN CMD2 = 'DELETE TAPES' CRT ; CRT CMD2 EXECUTE CMD2 END SYSTEM(11) is our workaround. But it is a pain because: A) It is non-standard, i.e. not necessary for other SELECTs. B) It is not what the documentation says. BASR.pdf states that @SYSTEM.RETURN.CODE will contain the number of items in the select list. C) If the program reports errors, it must first check @SYSTEM.RETURN.CODE, and if okay then check SYSTEM(11). -Original Message- From: Moderator [mailto:[EMAIL PROTECTED] Sent: Friday, June 22, 2007 6:15 PM To: u2-users@listserver.u2ug.org; Dean Armbruster - 0018 HQ Subject: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly REPOSTED FOR NON-MEMBER ADDRESS: [EMAIL PROTECTED] I'd looking for feedback on @SYSTEM.RETURN.CODE as returned from BSELECT of a multivalue attribute. Run the following basic code in the UniData demo account: CMD = 'BSELECT CUSTOMER TAPES_RENTED' CRT CMD EXECUTE CMD CRT '@SYSTEM.RETURN.CODE = ':@SYSTEM.RETURN.CODE CLEARSELECT When I run it, I get: BSELECT CUSTOMER TAPES_RENTED 36 records selected to list 0. @SYSTEM.RETURN.CODE = 29 Note that 29 is the number of records in CUSTOMER; 36 is then number of items in the returned active select list. The questions: Is there any way a program could depend on @SYSTEM.RETURN.CODE being incorrect some of the time? Would anyone want @SYSTEM.RETURN.CODE to be the number records polled and not number of items in the returned list, even if the number of items returned is 0? IBM case #423086*USA UniData 6.1.18 HP-UX 11.11 ECLTYPE P UDT.OPTIONS 59 ON Dean Armbruster System Analyst Wolseley North American Division * 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1(757) 989-2839 * F: +1(757)989-2801 --- 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: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly
What are you trying to say here? You don't make sense (sorry). Not knowing UD, I have to be careful here, but if I'm selecting BY.EXP a multi-value field, I would NOT expect the number of records selected to be the same as the number of items in the select list. I'm getting the impression that @SYSTEM.RETURN.CODE *IS* the number of records selected. Thing is, you're asking it to count records multiple times if the same record appears multiple times in the select list. Let's say we have 10 records, half of them with two items in an MV field, and the rest with just one. Am I correct in thinking that, if you do a SELECT BY.EXP, the @SYSTEM.RETURN.CODE is 10, the number of *records* selected, while SYSTEM(11) is 15, the number of *items* in the select list? Hope this clarifies things :-) Cheers, Wol -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 26 June 2007 14:24 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly To David A. Green, who said, SYSTEM(11) returns number of items in the active select list. I think we should leave the @SYSTEM.RETURN.CODE as the number of records selected. @SYSTEM.RETURN.CODE is NOT the number of records selected. That is the problem. It is the number of records queried/polled, not the number of items returned in the select list. Those numbers will not be the same for a multivalued attribute or if the attribute is null and UDT.OPTION 59 is ON. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD Backups
I've been testing NTBackup recently. There are some significant time delays in backuping up a UD system vs a plain Windows system. All servers run Windows 2003 Server Standard, updated several weeks ago. One server is an IIS web server using .NET while the other is a UniData server. There's not a lot of data so the time differences are pretty significant. Here's some info: ..now pausing the UniData dbms on Mon 06/25/2007 at 23:30:00.53 DBpause successful. ..now starting Windows NTBackup on Mon 06/25/2007 at 23:30:00.56 ..now resuming the UniData dbms on Mon 06/25/2007 at 23:52:02.06 DBresume successful. ..zipping (RAR) is now starting on Mon 06/25/2007 at 23:52:02.13 ..now ftp'ing files to storage server on Tue 06/26/2007 at 0:32:58.08 sftp put *.rar - remote /AsiAsp2/Asp2_20070625.rar OK Uploaded 160247944 bytes, 16 seconds, 9751593 bytes/second sftp quit The non-UD server shows: ..now starting Windows NTBackup on Mon 06/25/2007 at 22:55:01.28 ..zipping (RAR) is now starting on Mon 06/25/2007 at 22:59:34.23 ..now sftp'ing backup to ASI web server on Mon 06/25/2007 at 23:37:07.40 sftp put *.rar - remote /netdrive/archive/Ht1_20070625.rar OK Uploaded 989484797 bytes, 118 seconds, 8360665 bytes/second sftp quit As can be seen, the 160MB NTBackup is taking 22 minutes on the UD machine and only 4 minutes for the 990MB backup on the IIS/.NET machine. I'm guessing it has something to do with files in use. We really don't want UD shutdown for 22 minutes. When it starts growing we're going to have a real problem. Can anyone recommend a fast backup/compression product for a reasonable price? Thanks, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Backups
1. How big is the data? 2. How about (OS) copying to disk and then to a portable hard-drive or burn to DVD? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett Sent: Tuesday, June 26, 2007 12:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] UD Backups I've been testing NTBackup recently. There are some significant time delays in backuping up a UD system vs a plain Windows system. All servers run Windows 2003 Server Standard, updated several weeks ago. One server is an IIS web server using .NET while the other is a UniData server. There's not a lot of data so the time differences are pretty significant. Here's some info: ..now pausing the UniData dbms on Mon 06/25/2007 at 23:30:00.53 DBpause successful. ..now starting Windows NTBackup on Mon 06/25/2007 at 23:30:00.56 ..now resuming the UniData dbms on Mon 06/25/2007 at 23:52:02.06 DBresume successful. ..zipping (RAR) is now starting on Mon 06/25/2007 at 23:52:02.13 ..now ftp'ing files to storage server on Tue 06/26/2007 at 0:32:58.08 sftp put *.rar - remote /AsiAsp2/Asp2_20070625.rar OK Uploaded 160247944 bytes, 16 seconds, 9751593 bytes/second sftp quit The non-UD server shows: ..now starting Windows NTBackup on Mon 06/25/2007 at 22:55:01.28 ..zipping (RAR) is now starting on Mon 06/25/2007 at 22:59:34.23 ..now sftp'ing backup to ASI web server on Mon 06/25/2007 at 23:37:07.40 sftp put *.rar - remote /netdrive/archive/Ht1_20070625.rar OK Uploaded 989484797 bytes, 118 seconds, 8360665 bytes/second sftp quit As can be seen, the 160MB NTBackup is taking 22 minutes on the UD machine and only 4 minutes for the 990MB backup on the IIS/.NET machine. I'm guessing it has something to do with files in use. We really don't want UD shutdown for 22 minutes. When it starts growing we're going to have a real problem. Can anyone recommend a fast backup/compression product for a reasonable price? Thanks, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Backups
I admit I don't know anything about NTBackup but over the years I have seen enough backups to wonder if your data is of a different type. Any backup will run slower if it has to open and close a lot of small files as opposed to large files. Is it possible that the UD server as several type 19 files with many small records and the other has large files. Are you using the PE version for this test because you don't seem to have much data if you aren't? -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 11:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] UD Backups I've been testing NTBackup recently. There are some significant time delays in backuping up a UD system vs a plain Windows system. All servers run Windows 2003 Server Standard, updated several weeks ago. One server is an IIS web server using .NET while the other is a UniData server. There's not a lot of data so the time differences are pretty significant. Here's some info: ..now pausing the UniData dbms on Mon 06/25/2007 at 23:30:00.53 DBpause successful. ..now starting Windows NTBackup on Mon 06/25/2007 at 23:30:00.56 ..now resuming the UniData dbms on Mon 06/25/2007 at 23:52:02.06 DBresume successful. ..zipping (RAR) is now starting on Mon 06/25/2007 at 23:52:02.13 ..now ftp'ing files to storage server on Tue 06/26/2007 at 0:32:58.08 sftp put *.rar - remote /AsiAsp2/Asp2_20070625.rar OK Uploaded 160247944 bytes, 16 seconds, 9751593 bytes/second sftp quit The non-UD server shows: ..now starting Windows NTBackup on Mon 06/25/2007 at 22:55:01.28 ..zipping (RAR) is now starting on Mon 06/25/2007 at 22:59:34.23 ..now sftp'ing backup to ASI web server on Mon 06/25/2007 at 23:37:07.40 sftp put *.rar - remote /netdrive/archive/Ht1_20070625.rar OK Uploaded 989484797 bytes, 118 seconds, 8360665 bytes/second sftp quit As can be seen, the 160MB NTBackup is taking 22 minutes on the UD machine and only 4 minutes for the 990MB backup on the IIS/.NET machine. I'm guessing it has something to do with files in use. We really don't want UD shutdown for 22 minutes. When it starts growing we're going to have a real problem. Can anyone recommend a fast backup/compression product for a reasonable price? Thanks, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe Phantom
Hello, Is it possible to issue a phantom from OS? I have an automatic process that runs at various intervals, but we are low on licenses so sometimes the process fails. I'm on Windows Universe 10.2 Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Phantom from DOS
The best way to do that is to build a paragraph or sentence that kicks off the phantom then run it from the dos prompt. Example: The paragraph in the VOC file would be: TEST.PARA 0001: PA 0002: PHANTOM TEST.PROGRAM 0003: Q From the DOS prompt change to the Universe account and start the phantom: cd \testaccount \ibm\uv\bin\uv test.para -Original Message- From: David Ward [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 12:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] Phantom from DOS Is it possible to start a phantom from the DOS prompt? I'm running Universe/10.2 Thanks --- 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] Phantom from DOS
But this will still consume a license upon entry until the phantom is issued. I thought there used to be a way to phantom directly, no?? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, June 26, 2007 1:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Phantom from DOS The best way to do that is to build a paragraph or sentence that kicks off the phantom then run it from the dos prompt. Example: The paragraph in the VOC file would be: TEST.PARA 0001: PA 0002: PHANTOM TEST.PROGRAM 0003: Q From the DOS prompt change to the Universe account and start the phantom: cd \testaccount \ibm\uv\bin\uv test.para -Original Message- From: David Ward [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 12:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] Phantom from DOS Is it possible to start a phantom from the DOS prompt? I'm running Universe/10.2 Thanks --- 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] Phantom from DOS
That would work and I have done this in the past, However that would still use a universe licence for the second it took to start the phantom and exit so if you had no licences left at that time the process would not start and so the phantom would not run ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: 26 June 2007 19:13 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Phantom from DOS The best way to do that is to build a paragraph or sentence that kicks off the phantom then run it from the dos prompt. Example: The paragraph in the VOC file would be: TEST.PARA 0001: PA 0002: PHANTOM TEST.PROGRAM 0003: Q From the DOS prompt change to the Universe account and start the phantom: cd \testaccount \ibm\uv\bin\uv test.para -Original Message- From: David Ward [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 12:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] Phantom from DOS Is it possible to start a phantom from the DOS prompt? I'm running Universe/10.2 Thanks --- 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] Universe Phantom
Is it possible to issue a phantom from OS? I have several jobs that are run through the Windows scheduler. Simply set up a batch file, and schedule the job to execute the batch file. Sample batch file: echo start UniVerse End Of Day job cd IBM\uv bin\uvsh.exe RUN UVSOURCE END.OF.DAY echo finished with End Of Day Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Phantom from DOS
Is it possible to start a phantom from the DOS prompt? I'm running Universe/10.2 Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Phantom
That would use up the license for the length of the process. The only way to not use an additional license is to run a phantom from a process that is already using a license. If your business is this tight on licenses I would suggest you buy more. If your processes aren't running you're out of business. What's that worth to you? -Original Message- From: Kryka, Richard [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 1:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom Is it possible to issue a phantom from OS? I have several jobs that are run through the Windows scheduler. Simply set up a batch file, and schedule the job to execute the batch file. Sample batch file: echo start UniVerse End Of Day job cd IBM\uv bin\uvsh.exe RUN UVSOURCE END.OF.DAY echo finished with End Of Day Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- 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] Universe Phantom
These are all good suggestions, but the issue is I cannot tell if the job failed due to an out of licenses condition. In the old days it was easy, if the process was not attached to a terminal device, it was construed as a phantom and didn't consume a license. (or at least that's the way I remember it). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kryka, Richard Sent: Tuesday, June 26, 2007 1:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom Is it possible to issue a phantom from OS? I have several jobs that are run through the Windows scheduler. Simply set up a batch file, and schedule the job to execute the batch file. Sample batch file: echo start UniVerse End Of Day job cd IBM\uv bin\uvsh.exe RUN UVSOURCE END.OF.DAY echo finished with End Of Day Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- 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] UD Backups
Bill: The UD backup was only 160MB for the test. I suspect it will get to the size of the .NET backup (1GB) within six to twelve months. We'd like all of this to be scripted, as the servers are administered remotely. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, June 26, 2007 10:45 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UD Backups 1. How big is the data? 2. How about (OS) copying to disk and then to a portable hard-drive or burn to DVD? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett Sent: Tuesday, June 26, 2007 12:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] UD Backups I've been testing NTBackup recently. There are some significant time delays in backuping up a UD system vs a plain Windows system. All servers run Windows 2003 Server Standard, updated several weeks ago. One server is an IIS web server using .NET while the other is a UniData server. There's not a lot of data so the time differences are pretty significant. Here's some info: ..now pausing the UniData dbms on Mon 06/25/2007 at 23:30:00.53 DBpause successful. ..now starting Windows NTBackup on Mon 06/25/2007 at 23:30:00.56 ..now resuming the UniData dbms on Mon 06/25/2007 at 23:52:02.06 DBresume successful. ..zipping (RAR) is now starting on Mon 06/25/2007 at 23:52:02.13 ..now ftp'ing files to storage server on Tue 06/26/2007 at 0:32:58.08 sftp put *.rar - remote /AsiAsp2/Asp2_20070625.rar OK Uploaded 160247944 bytes, 16 seconds, 9751593 bytes/second sftp quit The non-UD server shows: ..now starting Windows NTBackup on Mon 06/25/2007 at 22:55:01.28 ..zipping (RAR) is now starting on Mon 06/25/2007 at 22:59:34.23 ..now sftp'ing backup to ASI web server on Mon 06/25/2007 at 23:37:07.40 sftp put *.rar - remote /netdrive/archive/Ht1_20070625.rar OK Uploaded 989484797 bytes, 118 seconds, 8360665 bytes/second sftp quit As can be seen, the 160MB NTBackup is taking 22 minutes on the UD machine and only 4 minutes for the 990MB backup on the IIS/.NET machine. I'm guessing it has something to do with files in use. We really don't want UD shutdown for 22 minutes. When it starts growing we're going to have a real problem. Can anyone recommend a fast backup/compression product for a reasonable price? Thanks, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Phantom from DOS
Try: \usr\ibm\uv\bin\uv phantom xxx where xxx is whatever you're trying to run as a phantom. This works in unix, but I'm not 100% sure if it'll work in DOS. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Tuesday, June 26, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Phantom from DOS But this will still consume a license upon entry until the phantom is issued. I thought there used to be a way to phantom directly, no?? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, June 26, 2007 1:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Phantom from DOS The best way to do that is to build a paragraph or sentence that kicks off the phantom then run it from the dos prompt. Example: The paragraph in the VOC file would be: TEST.PARA 0001: PA 0002: PHANTOM TEST.PROGRAM 0003: Q From the DOS prompt change to the Universe account and start the phantom: cd \testaccount \ibm\uv\bin\uv test.para -Original Message- From: David Ward [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 12:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] Phantom from DOS Is it possible to start a phantom from the DOS prompt? I'm running Universe/10.2 Thanks --- 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/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 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/
RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly
SELECT with the SAVING keyword, with or without NO.NULLS, returned the correct value in @SYSTEM.RETURN.CODE, in my tests. I don't know or have Universe, so I could be wrong, but it appears you have an implied BSELECT, as demonstrated with the SAVING keyword. A BSELECT is, as quoted from the UniData UniQuery doc: BSELECT filename ['record_IDs'][selection_criteria] attribute [attribute...] The UniQuery BSELECT command retrieves data from a file into an active select list. Unlike the SELECT command, which retrieves only record IDs, BSELECT builds a list of the attributes you name in the UniQuery statement. You must name at least one attribute in the statement. In UniData, you can also do an implied BSELECT by following the same syntax as BSELECT in a SELECT command. UniData does not have @SELECTED. @SYSTEM.RETURN.CODE is normally an error code (if negative) or the number of items in the select list (if non-negative) for any executed UniQuery commands dealing with select lists. It is misbehaving for BSELECT. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, June 26, 2007 9:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly Does the same thing happen when you use SELECT filename SAVING [UNIQUE] field NO.NULLS? I'm not on Unidata so I can't try it. Universe doesn't have the BSELECT command. @SYSTEM.RETURN.CODE only returns 0 on a select so we use @SELECTED which does return the full amount in the select list. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 25, 2007 4:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly My apologies for the poor job I did posting this. I sent it before I had completed the subscribe procedures. I blame it on my vacation. :-) Because of my mistake, I didn't get the replies. I had to get them from the list archive. Here are my replies to the replies: To Dave Davis, who said, If you were curious about the number of customers queried couldn't you just do a SELECT CUSTOMER first? I agree. Or, if you had done a previous select to whittle down the list, you'd already know how many records would be queried for the BSELECT. To David A. Green, who said, SYSTEM(11) returns number of items in the active select list. I think we should leave the @SYSTEM.RETURN.CODE as the number of records selected. @SYSTEM.RETURN.CODE is NOT the number of records selected. That is the problem. It is the number of records queried/polled, not the number of items returned in the select list. Those numbers will not be the same for a multivalued attribute or if the attribute is null and UDT.OPTION 59 is ON. Try this and see if you feel the same way about @SYSTEM.RETURN.CODE: EXECUTE 'UDT.OPTIONS 59 ON' CMD1 = 'BSELECT CUSTOMER WITH @ID GE 200 TAPES_RENTED' CRT CMD1 EXECUTE CMD1 IF @SYSTEM.RETURN.CODE GT 0 THEN CMD2 = 'DELETE TAPES' CRT ; CRT CMD2 EXECUTE CMD2 END SYSTEM(11) is our workaround. But it is a pain because: A) It is non-standard, i.e. not necessary for other SELECTs. B) It is not what the documentation says. BASR.pdf states that @SYSTEM.RETURN.CODE will contain the number of items in the select list. C) If the program reports errors, it must first check @SYSTEM.RETURN.CODE, and if okay then check SYSTEM(11). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly
The @SYSTEM.RETURN.CODE you describe is the same as it was on PI which also didn't have an @SELECTED. At least I don't remember one. Of course they didn't have a BSELECT either. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 2:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly SELECT with the SAVING keyword, with or without NO.NULLS, returned the correct value in @SYSTEM.RETURN.CODE, in my tests. I don't know or have Universe, so I could be wrong, but it appears you have an implied BSELECT, as demonstrated with the SAVING keyword. A BSELECT is, as quoted from the UniData UniQuery doc: BSELECT filename ['record_IDs'][selection_criteria] attribute [attribute...] The UniQuery BSELECT command retrieves data from a file into an active select list. Unlike the SELECT command, which retrieves only record IDs, BSELECT builds a list of the attributes you name in the UniQuery statement. You must name at least one attribute in the statement. In UniData, you can also do an implied BSELECT by following the same syntax as BSELECT in a SELECT command. UniData does not have @SELECTED. @SYSTEM.RETURN.CODE is normally an error code (if negative) or the number of items in the select list (if non-negative) for any executed UniQuery commands dealing with select lists. It is misbehaving for BSELECT. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, June 26, 2007 9:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly Does the same thing happen when you use SELECT filename SAVING [UNIQUE] field NO.NULLS? I'm not on Unidata so I can't try it. Universe doesn't have the BSELECT command. @SYSTEM.RETURN.CODE only returns 0 on a select so we use @SELECTED which does return the full amount in the select list. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 25, 2007 4:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly My apologies for the poor job I did posting this. I sent it before I had completed the subscribe procedures. I blame it on my vacation. :-) Because of my mistake, I didn't get the replies. I had to get them from the list archive. Here are my replies to the replies: To Dave Davis, who said, If you were curious about the number of customers queried couldn't you just do a SELECT CUSTOMER first? I agree. Or, if you had done a previous select to whittle down the list, you'd already know how many records would be queried for the BSELECT. To David A. Green, who said, SYSTEM(11) returns number of items in the active select list. I think we should leave the @SYSTEM.RETURN.CODE as the number of records selected. @SYSTEM.RETURN.CODE is NOT the number of records selected. That is the problem. It is the number of records queried/polled, not the number of items returned in the select list. Those numbers will not be the same for a multivalued attribute or if the attribute is null and UDT.OPTION 59 is ON. Try this and see if you feel the same way about @SYSTEM.RETURN.CODE: EXECUTE 'UDT.OPTIONS 59 ON' CMD1 = 'BSELECT CUSTOMER WITH @ID GE 200 TAPES_RENTED' CRT CMD1 EXECUTE CMD1 IF @SYSTEM.RETURN.CODE GT 0 THEN CMD2 = 'DELETE TAPES' CRT ; CRT CMD2 EXECUTE CMD2 END SYSTEM(11) is our workaround. But it is a pain because: A) It is non-standard, i.e. not necessary for other SELECTs. B) It is not what the documentation says. BASR.pdf states that @SYSTEM.RETURN.CODE will contain the number of items in the select list. C) If the program reports errors, it must first check @SYSTEM.RETURN.CODE, and if okay then check SYSTEM(11). --- 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] Universe Phantom
These are all good suggestions, but the issue is I cannot tell if the job failed due to an out of licenses condition. I concur with prior respondents - if it is mission-critical, buy more licenses. The issue for me (and anyone who knows more can correct me) is that you are allowed 10 sessions from one workstation (or server) and these 10 sessions consume one license. So if you have several batch jobs that run concurrently during the day, they are just one license. Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Backups
Jerry: It's a licensed UD Server version w/40 licenses. It's moving into low production mode at the moment until we resolve all of the wrinkles associated with a conversion. It doesn't have a lot of files in each account but new ASP accounts have little data and older ones have a fair amount of data. The files are reasonably sized and there's nothing, that I know of, that's unusual about them. On a development server, basically the same amount of data is backed up by NTBackup in five minutes; but that still seems too long. There are several UniObjects connections to both UD servers from mv.NET and DesignBais (in the case of the development server). Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, June 26, 2007 11:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Backups I admit I don't know anything about NTBackup but over the years I have seen enough backups to wonder if your data is of a different type. Any backup will run slower if it has to open and close a lot of small files as opposed to large files. Is it possible that the UD server as several type 19 files with many small records and the other has large files. Are you using the PE version for this test because you don't seem to have much data if you aren't? -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 11:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] UD Backups I've been testing NTBackup recently. There are some significant time delays in backuping up a UD system vs a plain Windows system. All servers run Windows 2003 Server Standard, updated several weeks ago. One server is an IIS web server using .NET while the other is a UniData server. There's not a lot of data so the time differences are pretty significant. Here's some info: ..now pausing the UniData dbms on Mon 06/25/2007 at 23:30:00.53 DBpause successful. ..now starting Windows NTBackup on Mon 06/25/2007 at 23:30:00.56 ..now resuming the UniData dbms on Mon 06/25/2007 at 23:52:02.06 DBresume successful. ..zipping (RAR) is now starting on Mon 06/25/2007 at 23:52:02.13 ..now ftp'ing files to storage server on Tue 06/26/2007 at 0:32:58.08 sftp put *.rar - remote /AsiAsp2/Asp2_20070625.rar OK Uploaded 160247944 bytes, 16 seconds, 9751593 bytes/second sftp quit The non-UD server shows: ..now starting Windows NTBackup on Mon 06/25/2007 at 22:55:01.28 ..zipping (RAR) is now starting on Mon 06/25/2007 at 22:59:34.23 ..now sftp'ing backup to ASI web server on Mon 06/25/2007 at 23:37:07.40 sftp put *.rar - remote /netdrive/archive/Ht1_20070625.rar OK Uploaded 989484797 bytes, 118 seconds, 8360665 bytes/second sftp quit As can be seen, the 160MB NTBackup is taking 22 minutes on the UD machine and only 4 minutes for the 990MB backup on the IIS/.NET machine. I'm guessing it has something to do with files in use. We really don't want UD shutdown for 22 minutes. When it starts growing we're going to have a real problem. Can anyone recommend a fast backup/compression product for a reasonable price? Thanks, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Backups
Bill-- I presume that UniData invokes an NT service that could be disabled in an VB Script. The files could then be copied. Check out... VB Script, Step By Step, Ed Wilson, Microsoft Press, 2007. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly
BY.EXP does not factor in. This is about BSELECT, regardless of BY.EXP use. @SYSTEM.RETURN.CODE is not supposed to be the number of *records* selected. It is supposed to be the number of items in the select list. From the UniData UniBasic Commands Reference (BASR.pdf), Appendix B: ECL @SYSTEM.RETURN.CODE Values The following table describes the possible @SYSTEM.RETURN.CODE values for various ECL commands. Command Success Return Value - - BSELECT The number of items in the select list. What I'm saying: Watch out! @SYSTEM.RETURN.CODE for BSELECT is not what the documentation says it is. Your list may not have the number of entries indicated. Your list may even be empty even though @SYSTEM.RETURN.CODE is greater than zero. IBM is reluctant to change this behavior for fear that some application somewhere may be relying on @SYSTEM.RETURN.CODE being incorrect. How an application can rely on something that is never always correct nor always incorrect is beyond me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, June 26, 2007 10:12 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly What are you trying to say here? You don't make sense (sorry). Not knowing UD, I have to be careful here, but if I'm selecting BY.EXP a multi-value field, I would NOT expect the number of records selected to be the same as the number of items in the select list. I'm getting the impression that @SYSTEM.RETURN.CODE *IS* the number of records selected. Thing is, you're asking it to count records multiple times if the same record appears multiple times in the select list. Let's say we have 10 records, half of them with two items in an MV field, and the rest with just one. Am I correct in thinking that, if you do a SELECT BY.EXP, the @SYSTEM.RETURN.CODE is 10, the number of *records* selected, while SYSTEM(11) is 15, the number of *items* in the select list? Hope this clarifies things :-) Cheers, Wol -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 26 June 2007 14:24 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly To David A. Green, who said, SYSTEM(11) returns number of items in the active select list. I think we should leave the @SYSTEM.RETURN.CODE as the number of records selected. @SYSTEM.RETURN.CODE is NOT the number of records selected. That is the problem. It is the number of records queried/polled, not the number of items returned in the select list. Those numbers will not be the same for a multivalued attribute or if the attribute is null and UDT.OPTION 59 is ON. --- 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] UD Backups
Bill: I have the entire backup process scripted and the main script is called from a configured Windows scheduled task. Nothing about the backup process is done from within UD. We have a VB script included, called by this main backup script, that deletes old backup files older than the number of days passed in via the command line. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, June 26, 2007 1:16 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UD Backups Bill-- I presume that UniData invokes an NT service that could be disabled in an VB Script. The files could then be copied. Check out... VB Script, Step By Step, Ed Wilson, Microsoft Press, 2007. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Phantom
David Ward wrote: Hello, Is it possible to issue a phantom from OS? I have an automatic process that runs at various intervals, but we are low on licenses so sometimes the process fails. I'm on Windows Universe 10.2 This is a slightly different approach to your inquiry: I wrote MVExec to execute an MV command from any Windows box on your network, not just the OS prompt on the DBMS localhost. Target DBMS can be on *nix as well as Windows. MVExec is free for anyone using mv.NET. Complete documentation and code samples are in an associated README doc. Contact me for a free trial of mv.NET if you're interested. Tony Gravagno Nebula Research and Development TG@ remove.anti.spam.text.pleaseNebula-RnD.com Get mvExec here: http:// removethisNebula-RnD.com/freeware/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Phantom
Thanks Tony, but I think if I resolve the device license issue, that will resolve the issue. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Tuesday, June 26, 2007 3:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom David Ward wrote: Hello, Is it possible to issue a phantom from OS? I have an automatic process that runs at various intervals, but we are low on licenses so sometimes the process fails. I'm on Windows Universe 10.2 This is a slightly different approach to your inquiry: I wrote MVExec to execute an MV command from any Windows box on your network, not just the OS prompt on the DBMS localhost. Target DBMS can be on *nix as well as Windows. MVExec is free for anyone using mv.NET. Complete documentation and code samples are in an associated README doc. Contact me for a free trial of mv.NET if you're interested. Tony Gravagno Nebula Research and Development TG@ remove.anti.spam.text.pleaseNebula-RnD.com Get mvExec here: http:// removethisNebula-RnD.com/freeware/ --- 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] Universe Phantom
David, What I did was to write a Master Scheduler Program that runs as a phantom and phantoms off the background processes when it is their time. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Tuesday, June 26, 2007 12:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom These are all good suggestions, but the issue is I cannot tell if the job failed due to an out of licenses condition. In the old days it was easy, if the process was not attached to a terminal device, it was construed as a phantom and didn't consume a license. (or at least that's the way I remember it). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kryka, Richard Sent: Tuesday, June 26, 2007 1:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom Is it possible to issue a phantom from OS? I have several jobs that are run through the Windows scheduler. Simply set up a batch file, and schedule the job to execute the batch file. Sample batch file: echo start UniVerse End Of Day job cd IBM\uv bin\uvsh.exe RUN UVSOURCE END.OF.DAY echo finished with End Of Day Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- 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] Universe Phantom
Assuming your licensing is correct...What are you using to connect? You must use one of IBM's telnet clients; Dynamic Connect, Wintegrate, SB client. Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Thanks Dave, but I still think getting device licensing working is the way to go (maybe). I've reinstalled my license on the test system, but I can still only telnet up to the user count, rather than the device count. Has anyone else experienced this issue on UV10.2.0 on windows? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Phantom
Ah, that must be it then. I was just using windows telnet. Thanks Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood Sent: Tuesday, June 26, 2007 5:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom Assuming your licensing is correct...What are you using to connect? You must use one of IBM's telnet clients; Dynamic Connect, Wintegrate, SB client. Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Thanks Dave, but I still think getting device licensing working is the way to go (maybe). I've reinstalled my license on the test system, but I can still only telnet up to the user count, rather than the device count. Has anyone else experienced this issue on UV10.2.0 on windows? --- 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] Universe Phantom
Ive been thru all this before, there are three type of licenses you get from ibm, server , small business( not sure if that is the right name, but only allows up 33 users) and enterprise. If you have the server version, you only get a one to one license, every connection uses a license. The other two products allow up to 10 connections per device, and btw accuterm supports the device licensing also. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe Phantom
Ive been thru all this before, there are three type of licenses you get from ibm, server , small business( not sure if that is the right name, but only allows up 33 users) and enterprise. If you have the server version, you only get a one to one license, every connection uses a license. The other two products allow up to 10 connections per device, and btw accuterm supports the device licensing also. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe Phantom
Ive been thru all this before, there are three type of licenses you get from ibm, server , small business( not sure if that is the right name, but only allows up 33 users) and enterprise. If you have the server version, you only get a one to one license, every connection uses a license. The other two products allow up to 10 connections per device, and btw accuterm supports the device licensing also. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
{Blocked Content} RE: [U2] UD Backups
Warning: This message has had one or more attachments removed Warning: (not named). Warning: Please read the AngelicHost-Attachment-Warning.txt attachment(s) for more information. Bill; How long does the backup take on the server if you shutdown UD first? Just trying to rule out a problem with NTBackup before getting carried away. Do you have transaction processing? DBPause waits for any writes to complete before it actually stops anything. It may wait for the entire transaction. Along that line - would there be anything else that may be holding up DBPause? To answer your question - we've mostly used Backup Exec (there were some issues with older versions of UD). We don't have anything critical running overnight so we usually leave UD running and set the backup open files and backup without a lock options set. Not sure if it's any faster (I think NTBackup is a pared down version of Backup Exec). We've also had clients use Arcserve successfully, and we even have one client that backs up to a server on the NET (don't remember what that product is called). hth Colin Alfke Calgary Canada sorry list - I haven't been able to turn off rich-text e-mails with this version of Outlook Web Access :-( From: Bill Haskett Bill: I have the entire backup process scripted and the main script is called from a configured Windows scheduled task. Nothing about the backup process is done from within UD. We have a VB script included, called by this main backup script, that deletes old backup files older than the number of days passed in via the command line. Bill This is a message from the MailScanner E-Mail Virus Protection Service -- The original e-mail attachment winmail.dat was believed to be infected by a virus and has been replaced by this warning message. If you wish to receive a copy of the *infected* attachment, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Tue Jun 26 16:19:00 2007 the virus scanner said: Could not parse Outlook Rich Text attachment Note to Help Desk: Look on the AngelicHost MailScanner in /home/virtual/site2/fst/var/spool/mail.quarantine/20070626 (message l5QNIvYF027208). -- Postmaster MailScanner thanks transtec Computers for their support --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Phantom
Thanks Dave, but I still think getting device licensing working is the way to go (maybe). I've reinstalled my license on the test system, but I can still only telnet up to the user count, rather than the device count. Has anyone else experienced this issue on UV10.2.0 on windows? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David A. Green Sent: Tuesday, June 26, 2007 4:42 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom David, What I did was to write a Master Scheduler Program that runs as a phantom and phantoms off the background processes when it is their time. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Tuesday, June 26, 2007 12:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom These are all good suggestions, but the issue is I cannot tell if the job failed due to an out of licenses condition. In the old days it was easy, if the process was not attached to a terminal device, it was construed as a phantom and didn't consume a license. (or at least that's the way I remember it). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kryka, Richard Sent: Tuesday, June 26, 2007 1:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom Is it possible to issue a phantom from OS? I have several jobs that are run through the Windows scheduler. Simply set up a batch file, and schedule the job to execute the batch file. Sample batch file: echo start UniVerse End Of Day job cd IBM\uv bin\uvsh.exe RUN UVSOURCE END.OF.DAY echo finished with End Of Day Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Phantom
It would seems that my version supports it as the input allows it to be set to 10. Actually, when the license was originally setup, there was a notification that the device license was lower than allowed (e.g 0). The tech support rep said that device licensing was supported on my version, but if plain ol telnet doesn't work, it doesn't solve my problem and I'll be forced to alternative measures... Thanks Lloyd -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lloyd Cottrell Sent: Tuesday, June 26, 2007 6:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Phantom Ive been thru all this before, there are three type of licenses you get from ibm, server , small business( not sure if that is the right name, but only allows up 33 users) and enterprise. If you have the server version, you only get a one to one license, every connection uses a license. The other two products allow up to 10 connections per device, and btw accuterm supports the device licensing also. --- 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] Universe Phantom
David: Device licensing is an extra cost on U2 Server edition. It's free on Workgroup (less than 25 licenses) and Enterprise editions. It only works if you're using an IBM product or AccuTerm or, maybe, some other MV emulator. I think David is right about the master phantom. I've written one too. It's probably not as good as others but it does get the job done. If you're interested I'll post it. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Tuesday, June 26, 2007 3:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom Thanks Dave, but I still think getting device licensing working is the way to go (maybe). I've reinstalled my license on the test system, but I can still only telnet up to the user count, rather than the device count. Has anyone else experienced this issue on UV10.2.0 on windows? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David A. Green Sent: Tuesday, June 26, 2007 4:42 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom David, What I did was to write a Master Scheduler Program that runs as a phantom and phantoms off the background processes when it is their time. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Tuesday, June 26, 2007 12:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom These are all good suggestions, but the issue is I cannot tell if the job failed due to an out of licenses condition. In the old days it was easy, if the process was not attached to a terminal device, it was construed as a phantom and didn't consume a license. (or at least that's the way I remember it). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe PE - Web Services
Can IBM web services handle getting passed an xml document, such as a sales order? The example provided in the 'hard to find' knowledgebase using two number to be multiplied is very simplistic...and I was wondering how you would use then to process incoming sales orders. Cheers, Phil. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 22 June 2007 7:46 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe PE - Web Services Sara The web services require a pooled connection licence. Which is, unfortunately, not available with PE. Grrr Though I have to say, when I finally got to play with the IBM web services I've found them disappointing, particularly in the lack of data types. Maybe someone who can afford them now can tell me if they've extended that. I rolled my own a couple of years back (mvSOAP), then mothballed them when I heard IBM were bringing their own out. But I'm considering blowing the dust off them again - support for doc and RPC modes, standard data types, control over multivalues, reusable templates and basic validation were all in there, and fast. Brian While we are waiting for an official version of UniVerse 10.2.4 we have been trying to get Web Services working in the downloadable PE version. We have created a Web Service but when we try to run it we are advised in the log that the license has expired. Is this not able to be used in the PE version or is there some way of extending the license? Any assistance would be appreciated. Regards, Sara Burns Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] A family trust can help you protect your assets if the unexpected happens. To find out how a family trust works and if one's right for you, call 0800 505 405. The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- 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] Universe Phantom
I'm doing this on my test box right now and it is workgroup WG WINDOWS XPPRO UV. I don't see that it works even when I write a quickie Uniobjects wrapper. Interesting. I'll follow up with ibm support and see what the deal is. Thanks everyone. I'll post the outcome whatever it may be. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, June 26, 2007 8:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom David: Device licensing is an extra cost on U2 Server edition. It's free on Workgroup (less than 25 licenses) and Enterprise editions. It only works if you're using an IBM product or AccuTerm or, maybe, some other MV emulator. I think David is right about the master phantom. I've written one too. It's probably not as good as others but it does get the job done. If you're interested I'll post it. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Tuesday, June 26, 2007 3:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom Thanks Dave, but I still think getting device licensing working is the way to go (maybe). I've reinstalled my license on the test system, but I can still only telnet up to the user count, rather than the device count. Has anyone else experienced this issue on UV10.2.0 on windows? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David A. Green Sent: Tuesday, June 26, 2007 4:42 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom David, What I did was to write a Master Scheduler Program that runs as a phantom and phantoms off the background processes when it is their time. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Tuesday, June 26, 2007 12:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom These are all good suggestions, but the issue is I cannot tell if the job failed due to an out of licenses condition. In the old days it was easy, if the process was not attached to a terminal device, it was construed as a phantom and didn't consume a license. (or at least that's the way I remember it). --- 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/