RE: [U2] UD Backups - DBPAUSE for UniVerse? {Unclassified}
Better still... The U2UG are launching a Wiki Real Soon Now (we've already got it on the site, we're getting user feedback on the one we've chosen). There are a couple of annoyances though, so we're not done with the final decision. However An article on different ways of doing backups would make an ideal collaborative posting... Regards Brian Unfortunately, that's one of many omissions of the manuals and online help...I wonder if they have a dedicated resource for this task of keeping the manuals up-to-date and useful. Perhaps someone would like to volunteer to document and then submit a list of 'known errors and omissions' for the UniVerse documentation set? Then it can be submitted to IBM? Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Friday, July 06, 2007 6:30 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Backups - DBPAUSE for UniVerse? {Unclassified} Ah, yes there it is in the User Reference, like you said Mark. BUT, on 10.1 anyway, * 'SUSPEND.FILES' is not in the Index of the User Reference, you have to search the document to find it. * When you do find it, it doesn't say whether the Dynamic / Type 30 file headers (or anything else) are flushed to disk when you SUSPEND.FILES ON, and * The documentation for uv -admin [options] lists the effects of the options but not what the switch settings are that you would have to use to invoke the options All in all, not amongst IBM's best documentation efforts Regards Mike --- 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] UD Phantom Credentials
We run a main phantom that spawns off (EXECUTEs) other phantoms based on items in a service configuration file. This program wakes up every minute, scans the service file for anything that needs to be run this minute, EXECUTEs a phantom to run the configured command, then goes back to sleep for another minute; and so forth and so on. I log into UD as an administrator and phantom off this main program, manually, each time UD starts. It's been working in our test environment for about three months now. Two weeks ago I noticed the phantom looked like: 1 Top of wphaskett78241_3872 in _PH_, 6 lines, 165 characters. *--: P 001: System error 85 has occurred. 002: 003: The local device name is already in use. 004: 005: ...DTA.SERVICE is now starting at 21:44:01 Jul 05 2007... 006: ...now opening DTA system files... Bottom. A look at Google tells me this is some kind of drive mapping problem associated with a possible conflict with non-administrator users and the net use command. It so happens that I've mapped an ftp server's drive onto the UD server (Windows) as the N:\ drive. To get UniData to use this shared directory, on the other server, I have to insert !net use N: \\sftpserver\ftpdir {password} /user:{sftpserver\userid} ...into the LOGIN paragraph (it appears this has to be run at each invocation of a UD shell, aka UD login). I then create a (VOC) entry: Top of FTPFILE in VOC, 3 lines, 26 characters. *--: P 001: DIR 002: N:\{Name} 003: D_VOC Bottom. ...so UD programs can access the files that are SFTP'd into our network. In addition, a phantom executed from the main phantom runs properly. Is this one of those phantoms from phantoms problems? Any help would be appreciated. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: U2 Users Digest V1 #1733
[SJ] Thanks to everyone for the answers about creating files on Universe. I needed the syntax in both flavors (didn't even realize they were different) and now I'm all set. This is such a great list! Susan Joslyn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Phantom Credentials
Ouch !!! I can tell you WHAT is happening. How you solve it is a policy issue, not a technical issue. Basically, drive mappings are system-wide, not user-related. If you have multiple processes/users all wanting their own unique drive mappings, sorry it's not going to happen! We had this exact problem - our backup script on our servers had its own drive mappings. Our dear consultant (until we screamed at him once we realised what was happening) had this nasty habit of (a) using our server as his personal workstation, and (b) forgetting to log off. The ramifications were many and annoying, including such things as failed backups... Anyways. You have to have a policy saying that either (a) THIS is the set of drive mappings on the server and THEY MUST NOT CHANGE, OR (b) every process needs to set its own drive mappings on login, and every process needs to be aware of every other process that does this to avoid a collision, and no users are to leave the console logged in to mess things up. Your call ... Oh - by the way - stick a net use disconnect whatever the syntax is before every connect. That way, at least if there's no-one logged in holding the drive, you'll get rid of whatever setting it's been left at. Otherwise, if they did a remember this setting, your process will load their mapping, then your explicit mapping will fail with drive letter already in use. Cheers, Wol -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: 06 July 2007 09:56 To: u2-users@listserver.u2ug.org Subject: [U2] UD Phantom Credentials A look at Google tells me this is some kind of drive mapping problem associated with a possible conflict with non-administrator users and the net use command. It so happens that I've mapped an ftp server's drive onto the UD server (Windows) as the N:\ drive. To get UniData to use this shared directory, on the other server, I have to insert !net use N: \\sftpserver\ftpdir {password} /user:{sftpserver\userid} ...into the LOGIN paragraph (it appears this has to be run at each invocation of a UD shell, aka UD login). I then create a (VOC) entry: --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Backups - DBPAUSE for UniVerse?
This is one of many reasons to do all reading and writing to the database by using subroutines built on the database. -Original Message- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Thursday, July 05, 2007 8:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Backups - DBPAUSE for UniVerse? If you want incomplete updates in your database backup, then continue without pausing your database updates... :) Since BASIC applications don't timeout in database read/write operations, it's not really an issue. As for being a 'feature' it is sort of like the scenairo you get with a record update lock contention issue, except with no clause to handle the 'pause'.. Therefore you application would just wait until it's update is serviced...external applications using APIs are a different kettle of fish. So the 'feature' bit being it's transparent to your application. It is what you want with legacy applications of all sorts of vintage. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, July 06, 2007 10:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Backups - DBPAUSE for UniVerse? Stephen: Is this kind of bogus or kind of a feature. Considering all the different ways connections can be made to the dbms, all kinds of software would/could be failing if backups are done during a dbpause timeframe. :-( So it really does mean backups have to be very complex with RAID configurations and implementations. 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 Phantom Credentials
Why not just replace the drive mapping with a UNC path? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, July 06, 2007 7:04 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Phantom Credentials Ouch !!! I can tell you WHAT is happening. How you solve it is a policy issue, not a technical issue. Basically, drive mappings are system-wide, not user-related. If you have multiple processes/users all wanting their own unique drive mappings, sorry it's not going to happen! We had this exact problem - our backup script on our servers had its own drive mappings. Our dear consultant (until we screamed at him once we realised what was happening) had this nasty habit of (a) using our server as his personal workstation, and (b) forgetting to log off. The ramifications were many and annoying, including such things as failed backups... Anyways. You have to have a policy saying that either (a) THIS is the set of drive mappings on the server and THEY MUST NOT CHANGE, OR (b) every process needs to set its own drive mappings on login, and every process needs to be aware of every other process that does this to avoid a collision, and no users are to leave the console logged in to mess things up. Your call ... Oh - by the way - stick a net use disconnect whatever the syntax is before every connect. That way, at least if there's no-one logged in holding the drive, you'll get rid of whatever setting it's been left at. Otherwise, if they did a remember this setting, your process will load their mapping, then your explicit mapping will fail with drive letter already in use. Cheers, Wol -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: 06 July 2007 09:56 To: u2-users@listserver.u2ug.org Subject: [U2] UD Phantom Credentials A look at Google tells me this is some kind of drive mapping problem associated with a possible conflict with non-administrator users and the net use command. It so happens that I've mapped an ftp server's drive onto the UD server (Windows) as the N:\ drive. To get UniData to use this shared directory, on the other server, I have to insert !net use N: \\sftpserver\ftpdir {password} /user:{sftpserver\userid} ...into the LOGIN paragraph (it appears this has to be run at each invocation of a UD shell, aka UD login). I then create a (VOC) entry: --- 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] Tony Jones/WA/QBE/Insurance is out of the office.
Maybe he should have said he would be out from 14430 to 14435. This is the u2 list after all. __ From: Ron Sharcott [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] Tony Jones/WA/QBE/Insurance is out of the office. Date: Thu, 5 Jul 2007 10:04:11 -0700 The US? Metric? Maybe in science but think back to the recent lost satellite that was caused by an error between standard and metric because metric was assumed by everyone except the vendor for a part. If the red on that image is supposed to be countries that use metric then someone is pulling your leg. Invert the colours and you might get countries that use metric. Personally, I think that the dates should be standardized to YY/MM/DD. It makes sense to show general to most specific. Look at mailing addresses and you see the same issue. Country on the last line when maybe it should be first? Ron Sharcott (3635) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Thursday, July 05, 2007 9:44 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Tony Jones/WA/QBE/Insurance is out of the office. I will be out of the office starting 04/07/2007 and will not return until 09/07/2007. five months? :-) Clearly, he's using European-style (or should I just say non-American) dates. The USA leads the way in other innovations too: http://upload.wikimedia.org/wikipedia/commons/1/17/Metric_system.png (The funny thing is, the US really is an innovator. Go figure.) --- 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/ _ Missed the show? Watch videos of the Live Earth Concert on MSN. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV install - internal vs. external
As part of our DR configuration, our database is loaded on an external RAID array. We have the ability, should one server crash, to present the disks to other servers and be back up and running. The question has arisen as to whether we should do the same with UV itself. Currently, it is loaded on an internal drive, and therefore has to be loaded on any failover machine. If we load it on an external drive, we would be able to present that disk to a failover machine along with the database. This would also allow us to only have to do UV maintenance updates, mods, etc.) in one place and not have to worry about keeping multiple servers in synch. The down side is that it appears that when UV installs, it doesn't put EVERYTHING into /usr/ibm/uv (or whatever directory you choose for the install). For example, the uv.rc script gets installed into /etc, and the /etc/inittab file is modified to call it. Our concern is that there are other pieces strewn throughout unix that would be missing if we didn't actually do the install on every server. Does anyone know if there are other pieces of UV that don't go into the install directory - or if this is the only one? Thanks! Brian Brian F. Paige Serta International [EMAIL PROTECTED] Direct line: 847-747-0451 Internal extension: 2051 Fax: 847-747-0551 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 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] UV install - internal vs. external
There are files at the root filesystem: /.uvhome /.unishared /.uvdlls The spooler typically installs into: /usr/spool/uv The spooler area could be moved elsewhere if you modify uvhome/uvconfig I think that might be it, including the files that start UV (/etc/inittab) or /etc/init.d depending on your release. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 06, 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV install - internal vs. external As part of our DR configuration, our database is loaded on an external RAID array. We have the ability, should one server crash, to present the disks to other servers and be back up and running. The question has arisen as to whether we should do the same with UV itself. Currently, it is loaded on an internal drive, and therefore has to be loaded on any failover machine. If we load it on an external drive, we would be able to present that disk to a failover machine along with the database. This would also allow us to only have to do UV maintenance updates, mods, etc.) in one place and not have to worry about keeping multiple servers in synch. The down side is that it appears that when UV installs, it doesn't put EVERYTHING into /usr/ibm/uv (or whatever directory you choose for the install). For example, the uv.rc script gets installed into /etc, and the /etc/inittab file is modified to call it. Our concern is that there are other pieces strewn throughout unix that would be missing if we didn't actually do the install on every server. Does anyone know if there are other pieces of UV that don't go into the install directory - or if this is the only one? Thanks! Brian Brian F. Paige Serta International [EMAIL PROTECTED] Direct line: 847-747-0451 Internal extension: 2051 Fax: 847-747-0551 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] OverQuoting, Subscribing, and Other Periodic Messages
All, If you are reading this list through Nabble, Indexfocus, GMane, or any other third party, and want to get a direct feed, you can subscribe using the information found here: http://listserver.u2ug.org/. If you are already subscribed, thank you for your support. If you are already subscribed and contribute to the discussions, thank you doubly for your active contribution to our community. If you are already subscribed and forget to trim excess quotes when responding, we are begging you to remember. Seriously, this has an adverse effect on people with slow connections and makes the Digest version of the mail much harder to read. - Charles Barouch, One of the Many People Who Try to Keep Things Running --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV install - internal vs. external
To be sure, I would take a snapshot of the system before the install, then another after the install and do a diff on the to snaps. That should tell you the story. Like so. cd /;find . -print /tmp/file_list_b4_uv_install Install Universe cd /;find . -print /tmp/file_list_after_uv_install diff /tmp/file_list_b4_uv_install /tmp/file_list_after_uv_install -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, July 06, 2007 9:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV install - internal vs. external As part of our DR configuration, our database is loaded on an external RAID array. We have the ability, should one server crash, to present the disks to other servers and be back up and running. The question has arisen as to whether we should do the same with UV itself. Currently, it is loaded on an internal drive, and therefore has to be loaded on any failover machine. If we load it on an external drive, we would be able to present that disk to a failover machine along with the database. This would also allow us to only have to do UV maintenance updates, mods, etc.) in one place and not have to worry about keeping multiple servers in synch. The down side is that it appears that when UV installs, it doesn't put EVERYTHING into /usr/ibm/uv (or whatever directory you choose for the install). For example, the uv.rc script gets installed into /etc, and the /etc/inittab file is modified to call it. Our concern is that there are other pieces strewn throughout unix that would be missing if we didn't actually do the install on every server. Does anyone know if there are other pieces of UV that don't go into the install directory - or if this is the only one? Thanks! Brian Brian F. Paige Serta International [EMAIL PROTECTED] Direct line: 847-747-0451 Internal extension: 2051 Fax: 847-747-0551 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Phantom Credentials
David: Because a UNC path doesn't work for me; even when I mapped it like: FTPFILE 001 DIR 002 \\ftpserver\ftproot\mydir 003 D_VOC Colin Alfke suggested I change it to: FTPFILE 001 DIR 002 \\ftpserver\E$\ftproot\mydir 003 D_VOC ...but this doesn't fully work. For instance, an sftp script run, as a phantom, from a phantom shows the following errors: - - - - - - - - - - - - - - - - - - - - Ftp process starting at 00:09:03 Jul 06 2007 E:\UDAccounts\Hamsftpc -profile=E:\Backups\Scripts\CabHam.tlp -cmdFile=\\ftpserver\E$\ftproot\Ham\CCC_20070706000900.txt Bitvise Tunnelier 4.22 - sftpc, a command line SFTP client. Copyright (C) 2000-2006 by Bitvise Limited. Portions Copyright (C) 1995-2003 by Wei Dai. ERROR: Reading command file specified with -cmdFileReading command file specified with - parameter failed: Error opening file '\ftpserver\E$\ftproot\Ha m\CAB_20070706000900.txt' - CreateFile() failed with the following error: Windows error 3: The system cannot find the path specified. USAGE: sftpc [EMAIL PROTECTED]:port] OR -profile=file [-host=host] - - - - - - - - - - - - - - - - - - - - The only way I've found to resolve this is to map a drive from the UD server to the SFTP server via Windows explorer, then net use ... in the LOGIN paragraph (I've added the /persistent:no flag), then set the (VOC) pointer for FTPFILE like: FTPFILE 001 DIR 002 N:\mydir 003 D_VOC This is very convoluted, and, as a partial solution, not exactly what I expected. But I can't seem to find an otherwise clean solution that works. We're only mapping one drive (N:) for the sftp directories. I can't reverse the mapping because the SFTP software doesn't allow the use of network shares. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Friday, July 06, 2007 6:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Phantom Credentials Why not just replace the drive mapping with a UNC path? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, July 06, 2007 7:04 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Phantom Credentials Ouch !!! I can tell you WHAT is happening. How you solve it is a policy issue, not a technical issue. Basically, drive mappings are system-wide, not user-related. If you have multiple processes/users all wanting their own unique drive mappings, sorry it's not going to happen! We had this exact problem - our backup script on our servers had its own drive mappings. Our dear consultant (until we screamed at him once we realised what was happening) had this nasty habit of (a) using our server as his personal workstation, and (b) forgetting to log off. The ramifications were many and annoying, including such things as failed backups... Anyways. You have to have a policy saying that either (a) THIS is the set of drive mappings on the server and THEY MUST NOT CHANGE, OR (b) every process needs to set its own drive mappings on login, and every process needs to be aware of every other process that does this to avoid a collision, and no users are to leave the console logged in to mess things up. Your call ... Oh - by the way - stick a net use disconnect whatever the syntax is before every connect. That way, at least if there's no-one logged in holding the drive, you'll get rid of whatever setting it's been left at. Otherwise, if they did a remember this setting, your process will load their mapping, then your explicit mapping will fail with drive letter already in use. Cheers, Wol -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: 06 July 2007 09:56 To: u2-users@listserver.u2ug.org Subject: [U2] UD Phantom Credentials A look at Google tells me this is some kind of drive mapping problem associated with a possible conflict with non-administrator users and the net use command. It so happens that I've mapped an ftp server's drive onto the UD server (Windows) as the N:\ drive. To get UniData to use this shared directory, on the other server, I have to insert !net use N: \\sftpserver\ftpdir {password} /user:{sftpserver\userid} ...into the LOGIN paragraph (it appears this has to be run at each invocation of a UD shell, aka UD login). I then create a (VOC) entry: --- 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] Broadcasting messages
We want to send messages to the users when we need to shut the system down. We tried MESSAGE from Universe, but it displayed the message at the cursor position and doesn't refresh the screen. We've turned off UNIX messages because the users were getting all kinds of messages that were doing the same thing. Anyone know of a way to send messages out to all logged in users so that it shows up on a specific line of the screen? -- Pamela J Robbins New Bolton Center Senior Programmer AnalystSchool of Veterinary Medicine [EMAIL PROTECTED] University of Pennsylvania 610-925-6438 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Phantom Credentials
Do you have the AllowNFS flag set or are you using uvnet? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, July 06, 2007 11:34 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Phantom Credentials David: Because a UNC path doesn't work for me; even when I mapped it like: FTPFILE 001 DIR 002 \\ftpserver\ftproot\mydir 003 D_VOC Colin Alfke suggested I change it to: FTPFILE 001 DIR 002 \\ftpserver\E$\ftproot\mydir 003 D_VOC ...but this doesn't fully work. For instance, an sftp script run, as a phantom, from a phantom shows the following errors: - - - - - - - - - - - - - - - - - - - - Ftp process starting at 00:09:03 Jul 06 2007 E:\UDAccounts\Hamsftpc -profile=E:\Backups\Scripts\CabHam.tlp -cmdFile=\\ftpserver\E$\ftproot\Ham\CCC_20070706000900.txt Bitvise Tunnelier 4.22 - sftpc, a command line SFTP client. Copyright (C) 2000-2006 by Bitvise Limited. Portions Copyright (C) 1995-2003 by Wei Dai. ERROR: Reading command file specified with -cmdFileReading command file specified with - parameter failed: Error opening file '\ftpserver\E$\ftproot\Ha m\CAB_20070706000900.txt' - CreateFile() failed with the following error: Windows error 3: The system cannot find the path specified. USAGE: sftpc [EMAIL PROTECTED]:port] OR -profile=file [-host=host] - - - - - - - - - - - - - - - - - - - - The only way I've found to resolve this is to map a drive from the UD server to the SFTP server via Windows explorer, then net use ... in the LOGIN paragraph (I've added the /persistent:no flag), then set the (VOC) pointer for FTPFILE like: FTPFILE 001 DIR 002 N:\mydir 003 D_VOC This is very convoluted, and, as a partial solution, not exactly what I expected. But I can't seem to find an otherwise clean solution that works. We're only mapping one drive (N:) for the sftp directories. I can't reverse the mapping because the SFTP software doesn't allow the use of network shares. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Friday, July 06, 2007 6:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Phantom Credentials Why not just replace the drive mapping with a UNC path? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, July 06, 2007 7:04 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Phantom Credentials Ouch !!! I can tell you WHAT is happening. How you solve it is a policy issue, not a technical issue. Basically, drive mappings are system-wide, not user-related. If you have multiple processes/users all wanting their own unique drive mappings, sorry it's not going to happen! We had this exact problem - our backup script on our servers had its own drive mappings. Our dear consultant (until we screamed at him once we realised what was happening) had this nasty habit of (a) using our server as his personal workstation, and (b) forgetting to log off. The ramifications were many and annoying, including such things as failed backups... Anyways. You have to have a policy saying that either (a) THIS is the set of drive mappings on the server and THEY MUST NOT CHANGE, OR (b) every process needs to set its own drive mappings on login, and every process needs to be aware of every other process that does this to avoid a collision, and no users are to leave the console logged in to mess things up. Your call ... Oh - by the way - stick a net use disconnect whatever the syntax is before every connect. That way, at least if there's no-one logged in holding the drive, you'll get rid of whatever setting it's been left at. Otherwise, if they did a remember this setting, your process will load their mapping, then your explicit mapping will fail with drive letter already in use. Cheers, Wol -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: 06 July 2007 09:56 To: u2-users@listserver.u2ug.org Subject: [U2] UD Phantom Credentials A look at Google tells me this is some kind of drive mapping problem associated with a possible conflict with non-administrator users and the net use command. It so happens that I've mapped an ftp server's drive onto the UD server (Windows) as the N:\ drive. To get UniData to use this shared directory, on the other server, I have to insert !net use N: \\sftpserver\ftpdir {password} /user:{sftpserver\userid} ...into the LOGIN paragraph (it appears this has to be run at each invocation of a UD shell, aka UD login). I then create a (VOC) entry: --- 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
RE: [U2] Broadcasting messages
Depends on what you have available. - If your users on on PC's, then you can use windows messaging system - If your users are running a terminal emulator, there are some that allow you to update the title line - If you are running SB+ on top of UV or UD, then you can use the office send message tool - Some terminal types and support a 25th status line that can also be used for programmatically displaying a message. Your application you are running would have to have a way to display the message a the appropriate point. HTH Rod Hills -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pamela J Robbins Sent: Friday, July 06, 2007 9:37 AM To: u2-users@listserver.u2ug.org Subject: [U2] Broadcasting messages We want to send messages to the users when we need to shut the system down. We tried MESSAGE from Universe, but it displayed the message at the cursor position and doesn't refresh the screen. We've turned off UNIX messages because the users were getting all kinds of messages that were doing the same thing. Anyone know of a way to send messages out to all logged in users so that it shows up on a specific line of the screen? -- Pamela J Robbins New Bolton Center Senior Programmer AnalystSchool of Veterinary Medicine [EMAIL PROTECTED] University of Pennsylvania 610-925-6438 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ___ This e-mail and any attachments are for the sole use of the intended recipient(s) and may contain privileged and confidential information. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient(s), please contact the sender by reply e-mail and destroy all copies of the original message. Thank you. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Phantom Credentials
David: No. I'm using UD instead of UV. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Friday, July 06, 2007 10:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Phantom Credentials Do you have the AllowNFS flag set or are you using uvnet? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, July 06, 2007 9:34 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Phantom Credentials David: Because a UNC path doesn't work for me; even when I mapped it like: FTPFILE 001 DIR 002 \\ftpserver\ftproot\mydir 003 D_VOC Colin Alfke suggested I change it to: FTPFILE 001 DIR 002 \\ftpserver\E$\ftproot\mydir 003 D_VOC ...but this doesn't fully work. For instance, an sftp script run, as a phantom, from a phantom shows the following errors: - - - - - - - - - - - - - - - - - - - - Ftp process starting at 00:09:03 Jul 06 2007 E:\UDAccounts\Hamsftpc -profile=E:\Backups\Scripts\CabHam.tlp -cmdFile=\\ftpserver\E$\ftproot\Ham\CCC_20070706000900.txt Bitvise Tunnelier 4.22 - sftpc, a command line SFTP client. Copyright (C) 2000-2006 by Bitvise Limited. Portions Copyright (C) 1995-2003 by Wei Dai. ERROR: Reading command file specified with -cmdFileReading command file specified with - parameter failed: Error opening file '\ftpserver\E$\ftproot\Ha m\CAB_20070706000900.txt' - CreateFile() failed with the following error: Windows error 3: The system cannot find the path specified. USAGE: sftpc [EMAIL PROTECTED]:port] OR -profile=file [-host=host] - - - - - - - - - - - - - - - - - - - - The only way I've found to resolve this is to map a drive from the UD server to the SFTP server via Windows explorer, then net use ... in the LOGIN paragraph (I've added the /persistent:no flag), then set the (VOC) pointer for FTPFILE like: FTPFILE 001 DIR 002 N:\mydir 003 D_VOC This is very convoluted, and, as a partial solution, not exactly what I expected. But I can't seem to find an otherwise clean solution that works. We're only mapping one drive (N:) for the sftp directories. I can't reverse the mapping because the SFTP software doesn't allow the use of network shares. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Friday, July 06, 2007 6:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Phantom Credentials Why not just replace the drive mapping with a UNC path? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, July 06, 2007 7:04 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Phantom Credentials Ouch !!! [snipped] Basically, drive mappings are system-wide, not user-related. If you have multiple processes/users all wanting their own unique drive mappings, sorry it's not going to happen! We had this exact problem - our backup script on our servers had its own drive mappings. Our dear consultant (until we screamed at him once we realised what was happening) had this nasty habit of (a) using our server as his personal workstation, and (b) forgetting to log off. The ramifications were many and annoying, including such things as failed backups... Anyways. You have to have a policy saying that either (a) THIS is the set of drive mappings on the server and THEY MUST NOT CHANGE, OR (b) every process needs to set its own drive mappings on login, and every process needs to be aware of every other process that does this to avoid a collision, and no users are to leave the console logged in to mess things up. Your call ... Oh - by the way - stick a net use disconnect whatever the syntax is before every connect. That way, at least if there's no-one logged in holding the drive, you'll get rid of whatever setting it's been left at. Otherwise, if then did a remember this setting, your process will load their mapping, then your explicit mapping will fail with drive letter already in use. Cheers, Wol -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: 06 July 2007 09:56 To: u2-users@listserver.u2ug.org Subject: [U2] UD Phantom Credentials A look at Google tells me this is some kind of drive mapping problem associated with a possible conflict with non-administrator users and the net use command. It so happens that I've mapped an ftp server's drive onto the UD server (Windows) as the N:\ drive. To get UniData to use this shared directory, on the other server, I have to insert !net use N: \\sftpserver\ftpdir {password} /user:{sftpserver\userid} ...into the LOGIN paragraph (it appears this has to be run at each invocation of a UD shell, aka UD login). I then create a (VOC) entry: --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Tony Jones/WA/QBE/Insurance is out of the office.
In message [EMAIL PROTECTED], Ron Sharcott [EMAIL PROTECTED] writes The US? Metric? Maybe in science but think back to the recent lost satellite that was caused by an error between standard and metric because metric was assumed by everyone except the vendor for a part. If the red on that image is supposed to be countries that use metric then someone is pulling your leg. Invert the colours and you might get countries that use metric. Personally, I think that the dates should be standardized to YY/MM/DD. It makes sense to show general to most specific. Look at mailing addresses and you see the same issue. Country on the last line when maybe it should be first? Why general to specific? Why not most important to least important? As I see it, we have the ISO way - your recommendation - which goes from most significant to least, and increments right-to-left. Then there's the European way - most important first - which increments from left to right. Lastly, the Americans have to be random, and increment from the centre out :-) Cheers, 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] Broadcasting messages
Unix has the wall command to send a message to all terminals - but - I don't think you can position/format the message (and it's been many years since I used it). Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop.
In message [EMAIL PROTECTED], Cliff Bennett [EMAIL PROTECTED] writes Hi Dave, I'm not sure what is the purpose of lines 9 and 10 (assigning values to FILE.NAME and F.NAME). F.NAME can be undefined until the OPEN statement places the file descriptor into it. I know you cannot have a MV list of file descriptors. Each must be a full variable. If you really want a list, you can use a subscripted array instead of a dynamic array. You could then use MATREAD to load the INV.FILES() array, place the -INV suffix on each element and then open the files to a subscripted F.NAME() array. This looks to me like it's just a test that the files can be opened ... The OPEN statement is reusing the same variable every time, so in order to open file 2 it's closing file 1, etc etc etc. Cheers, Wol Regards, Cliff - Original Message - From: Dave R To: u2-users@listserver.u2ug.org Sent: Thursday, July 05, 2007 1:47 PM Subject: [U2] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop. I am trying to open a group of files from a list of files in the table file. Does anyone know how to make the constant in the open file statement work. I get the good old IMPROPER DATA TYPE error message when I try to read the file I opened with the code. In the mean time I will open each file separately . Thanks Dave. OPEN 'TABLE'TO F.TABLE ELSE STOP 201,'TABLE' READV INV.FILES FROM F.TABLE ,INVENTORY-FILES,1 ELSE CRT; CRT CANT FIND TABLE 'INVENTORY-FILES'; RETURN END CONVERT ',' TO @VM IN INV.FILES FDC = DCOUNT(INV.FILES,@VM) FOR F = 1 TO FDC FILENAME = INV.FILES1,F:-INV FILE.NAME = INV.FILES1,F F.NAME = 'F.':FILE.NAME OPEN FILENAME TO F.NAME ELSE STOP 201, FILENAME NEXT F * -- 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] Broadcasting messages
We use SecureCrt as a terminal emulator (VT100). Rod Hills wrote: Depends on what you have available. - If your users on on PC's, then you can use windows messaging system - If your users are running a terminal emulator, there are some that allow you to update the title line - If you are running SB+ on top of UV or UD, then you can use the office send message tool - Some terminal types and support a 25th status line that can also be used for programmatically displaying a message. Your application you are running would have to have a way to display the message a the appropriate point. HTH Rod Hills -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pamela J Robbins Sent: Friday, July 06, 2007 9:37 AM To: u2-users@listserver.u2ug.org Subject: [U2] Broadcasting messages We want to send messages to the users when we need to shut the system down. We tried MESSAGE from Universe, but it displayed the message at the cursor position and doesn't refresh the screen. We've turned off UNIX messages because the users were getting all kinds of messages that were doing the same thing. Anyone know of a way to send messages out to all logged in users so that it shows up on a specific line of the screen? -- Pamela J Robbins New Bolton Center Senior Programmer AnalystSchool of Veterinary Medicine [EMAIL PROTECTED] University of Pennsylvania 610-925-6438 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Broadcasting messages
I know you said you've turned off unix messages, but we use a scripted 'wall' command. You can't specify where it shows up on the screen, but it's always in the bottom few lines. depending on how long the message text is. Brad Schrag InfoLease Development 651-205-3074 RiverBank / EP-MN-BGF The answer to life, the universe and everything [EMAIL PROTECTED] wrote on 07/06/2007 11:36:37 AM: We want to send messages to the users when we need to shut the system down. We tried MESSAGE from Universe, but it displayed the message at the cursor position and doesn't refresh the screen. We've turned off UNIX messages because the users were getting all kinds of messages that were doing the same thing. Anyone know of a way to send messages out to all logged in users so that it shows up on a specific line of the screen? -- 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] Broadcasting messages
If you are on a *NIX environment, you can use the write all command. Logged on as root, it will send a message to any session. The down side is that it is not very pretty ... but it does get the message through. syntax: write all cr text text ctlD -or- write all /text_in_file.da HTH Robert We want to send messages to the users when we need to shut the system down... mail2web.com What can On Demand Business Solutions do for you? http://link.mail2web.com/Business/SharePoint --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop.
No, it looks like he is trying to assign a name to a variable and then using that variable to hold the opened file which is illegal in the language. It may be possible with literal equates but I doubt it. The reason for the data type error is because the variable F.NAME was already defined as the variable F.:INV.FILES1,F and then he tries opening a file using that variable to hold the file variable: OPEN FILENAME TO F.NAME ELSE STOP 201, FILENAME -Original Message- From: Anthony W. Youngman [mailto:[EMAIL PROTECTED] Sent: Friday, July 06, 2007 1:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop. In message [EMAIL PROTECTED], Cliff Bennett [EMAIL PROTECTED] writes Hi Dave, I'm not sure what is the purpose of lines 9 and 10 (assigning values to FILE.NAME and F.NAME). F.NAME can be undefined until the OPEN statement places the file descriptor into it. I know you cannot have a MV list of file descriptors. Each must be a full variable. If you really want a list, you can use a subscripted array instead of a dynamic array. You could then use MATREAD to load the INV.FILES() array, place the -INV suffix on each element and then open the files to a subscripted F.NAME() array. This looks to me like it's just a test that the files can be opened ... The OPEN statement is reusing the same variable every time, so in order to open file 2 it's closing file 1, etc etc etc. Cheers, Wol Regards, Cliff - Original Message - From: Dave R To: u2-users@listserver.u2ug.org Sent: Thursday, July 05, 2007 1:47 PM Subject: [U2] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop. I am trying to open a group of files from a list of files in the table file. Does anyone know how to make the constant in the open file statement work. I get the good old IMPROPER DATA TYPE error message when I try to read the file I opened with the code. In the mean time I will open each file separately . Thanks Dave. OPEN 'TABLE'TO F.TABLE ELSE STOP 201,'TABLE' READV INV.FILES FROM F.TABLE ,INVENTORY-FILES,1 ELSE CRT; CRT CANT FIND TABLE 'INVENTORY-FILES'; RETURN END CONVERT ',' TO @VM IN INV.FILES FDC = DCOUNT(INV.FILES,@VM) FOR F = 1 TO FDC FILENAME = INV.FILES1,F:-INV FILE.NAME = INV.FILES1,F F.NAME = 'F.':FILE.NAME OPEN FILENAME TO F.NAME ELSE STOP 201, FILENAME NEXT F * -- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV install - internal vs. external
I'd recommend installing UniVerse on a static file system on each server independently. Your data files are on a mountable file system on the RAID or SAN. Safe / robust - and it would avoid some of the issues you may hit with the new UniVerse licensing model in 10.2. Please check whether you need to buy a separate UniVerse copy or whether it's deep-discounted or free (depends on your usage re:HOT/WARM/COLD standby). You need controls to make sure that you don't grab your data files off a running UniVerse instant if you don't mean to, and also (even more importantly) that you don't rip them away - run - and put them back - without stopping the original instance. STONITH is a useful acronym to remember. (Shoot The Other Node In The Head). I would ALWAYS heavily script this scenario. When done correctly it's robust, if you get it wrong . well. Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Broadcasting messages
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pamela J Robbins Sent: Friday, July 06, 2007 11:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Broadcasting messages We use SecureCrt as a terminal emulator (VT100). You could try embedding the necessary cursor control characters in the message, but that will also likely reposition the cursor to wherever the message appears on the screen. If you have Samba installed and have the smblclient piece (I think this might be linux only, though) you might try something like: echo UniVerse Shutdown Warning | smbclient -M $MACHINE_NAME That will cause a popup message to appear in Windows. Of course you'll have to do this for every user's machine, and this assumes they're all on a PC and not a dumb terminal. I think for this to work on XP you need to have the Windows Messenger service installed and running. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/