RE: [U2] LIST DICT FILE Depth and Assoc

2006-05-17 Thread Stuart . Boydell
John, If Design Bais is riding on the back of SB+ field definitions then you may be able to use D/I types. SB+ can be set to create and maintain D & I types by setting DMCONT SB.CONTROL<34,1> = 1 ([EMAIL PROTECTED]<34,1>). At last look there was a bug in the UV version of SB.FD

RE: [U2] LIST DICT FILE Depth and Assoc

2006-05-17 Thread Kevin King
System Builder (that is, SB+) will not let you modify a dictionary with it's Field Definition tool if it wasn't created in SB+ or converted into that format. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Beha

Re: [U2] [UV] Active Directory, RHEL 4 integration and issues with UV

2006-05-17 Thread Craig Bennett
Phil, Has anyone configured their RHEL 4.0 system to authenticate against their active directory, to hopefully overcome the administration cost of maintaining both Linux and Windows security. I haven't done this but I do recall an issue last year on the mailing list where uniobjects would

Re: [U2] LIST DICT FILE Depth and Assoc

2006-05-17 Thread John Kent
Stuart, it just so happens that Design Bais will convert D types to A types when you modify anything that is not confined to their extended dictionary. Maybe System Builder does the same thing ? Hence you can end up loosing certain dict info such as S/M, SQL settings and Value marks in the

[U2] [UV] Active Directory, RHEL 4 integration and issues with UV

2006-05-17 Thread phil walker
Has anyone configured their RHEL 4.0 system to authenticate against their active directory, to hopefully overcome the administration cost of maintaining both Linux and Windows security. If so, what issues did you have with regarding to: a) telnet or ssh connectivity b) samba connectivity c) UniOb

RE: [U2] [UV] Upgrading to UV10.1.x - UVTSORT Config parameter

2006-05-17 Thread John Jenkins
Ray There were some problems with UVTSORT and I think they were all addressed from 10.1.7 (not sure which version you are on). The release notes state: 7295It the null value was the first character in a record and UVTSORT was enabled, SSELECT statement with a BY clause may have behaved incor

RE: [U2] [UV] Solaris Compatiblity?

2006-05-17 Thread Nick Cipollina
Solaris is all we use here. We have quite a few servers running Solaris and Universe. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, May 17, 2006 1:06 PM To: 'u2-users@listserver.u2ug.org' Subjec

RE: [U2] UV LOGON question

2006-05-17 Thread Jerry Banker
Tom, Maybe this is what you are looking for. @TTY will equal a lower case 'phantom' for phantom jobs. We use this to keep phantoms from going through our login program. All of the output from the commands in a phantom can be found in the &PH& file with the program name with date and time as the key

RE: [U2] Backup Question

2006-05-17 Thread Timothy Snyder
[EMAIL PROTECTED] wrote on 05/17/2006 02:04:35 PM: > Seems like there should be a market for a product that can do online > backups of unidata like uvbackup does for universe or the FILE-SAVE does > for pick. I'm not so sure of that. Even when I'm setting up users on UniVerse, I never use uvbac

RE: [U2] Backup Question

2006-05-17 Thread Ron Sharcott
Compaq Tru64 UNIX V5.1A UNIDATA 6.0.11 Datatel's Colleague on Envision 4.7.18 Ron Sharcott (3635) -Original Message- From: Tom Dodds [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 17, 2006 10:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Backup Question What platform are y

RE: [U2] [UV] Solaris Compatiblity?

2006-05-17 Thread george r smith
Is that on Sparc or the x86 box. As of last month Unidata was only available on the Sparc grs > -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Barry Brevik > Sent: Wednesday, May 17, 2006 12:49 PM > To: u2-users@listserver.u2ug.org > Subject

Re: [U2] UV LOGON question

2006-05-17 Thread John Hester
Tom Dodds wrote: One of the problems is that the LOGON does not populate the @tty variable with PHANTOM or LOGON or anything else that we can find. When using LOGON, the value of @TTY will be the actual unix level device file name defined in the &DEVICE& record that is the target of the LOGON

RE: [U2] Backup Question

2006-05-17 Thread phil walker
>> I have a client that only does backup once a week. I feel this is a >> dangerous situation and would like to suggest they look for an alternative. >> I believe that they could mirror the live system, stop the mirror, >> backup this copy and then restart and resync the mirror. >The problem wi

RE: [U2] Backup Question

2006-05-17 Thread Dave S
I don't see what this issue is. There are many robust backup programs that can be used in various O/S environments. You should only backup the system when there is no activity on the system. Otherwise you will not get a clean backup. [EMAIL PROTECTED] wrote: Seems like there should

RE: [U2] [UV] Solaris Compatiblity?

2006-05-17 Thread Bertrand, Ron
Running Universe Ver 10.0.3 on SunOS 5.8. Works just fine! Ron Bertrand ISD/LIS Group Health Coop 206-901-4519 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, May 17, 2006 10:06 AM To: 'u2-users@listserver.u2ug.org' Subjec

Re: [U2] UV LOGON question

2006-05-17 Thread Roger Glenfield
And you checked that the 'main' and/or current account doesn't have a proc stored in the MD called EOD.REPORT.25? Have you tried something like PHANTOM EOD.REPORT.25? And any chance that the printer settings are also in the proc, so you don't have to worry about the @tty settings? Or if the

RE: [U2] Backup Question

2006-05-17 Thread u2
Seems like there should be a market for a product that can do online backups of unidata like uvbackup does for universe or the FILE-SAVE does for pick. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Robert DunnMiller > Sent: Wednesday, May 17, 2

[U2] Mark Shannon/Australia/IBM is out of the office.

2006-05-17 Thread Mark Shannon
I will be out of the office starting 18/05/2006 and will not return until 23/05/2006. If you need assistance with U2 matters, please email [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Solaris Compatiblity?

2006-05-17 Thread Barry Brevik
>Does UniVerse run on Solaris? Yes, quite well. Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Backup Question

2006-05-17 Thread Brad Davis
I would use a file b file backup - you need to check out how reliable Unidata's back up is: however, I've never seen anyone use the Unidata or Universe backup utilities. You could also use something like NSI or XOSoft. However, they do not understand U2 file structures, so you have to be able to

Re: [U2] UV LOGON question

2006-05-17 Thread karlp
> We are migrating a company from an UltPlus system to UniVerse. We are > running UniVerse 10.1.11 on AIX 5.3.3. The UniVerse is running Pick > flavor. > > The legacy application relays heavily on the use of "LOGON port [command]" > processes. So if you say LOGON 92 EOD.REPORT.25, the system wi

RE: [U2] Backup Question

2006-05-17 Thread Tom Dodds
What platform are you running on and what database? Tom Dodds [EMAIL PROTECTED] 513-563-2800 Cincinnati Office 708-234-9608 Chicago Office 630-235-2975 Anywhere Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Sharcott Sent: Wednesday, May 17, 2

RE: [U2] Backup Question

2006-05-17 Thread Robert DunnMiller
There is not a UniData backup utility like UniVerse does. Every site that I have been involved with uses o/s level backups. There is a need to quiesce the database before breaking the mirror for backups. dbpause will force all writes to disk and will inhibit writes to the datafiles in the database

[U2] UV LOGON question

2006-05-17 Thread Tom Dodds
We are migrating a company from an UltPlus system to UniVerse. We are running UniVerse 10.1.11 on AIX 5.3.3. The UniVerse is running Pick flavor. The legacy application relays heavily on the use of "LOGON port [command]" processes. So if you say LOGON 92 EOD.REPORT.25, the system will start the

[U2] [UV] Solaris Compatiblity?

2006-05-17 Thread Brutzman, Bill
I am considering Sun's Solaris to run a hot-spare-backup-x86 server. Our main box is HP-Ux. Does UniVerse run on Solaris? I have not yet asked IBM about licensing issues. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Backup Question

2006-05-17 Thread jbutera
Ron Sharcott wrote: One thing that we have been looking at is DBPAUSE. The problem being that anything running is left to finish. Not a good pause in my book. But the interesting suggestion is the fsclone command in UNIX. This has been reported to us that it could allow us to do an initial backu

RE: [U2] Backup Question

2006-05-17 Thread u2
Does unidata have a backup utility at all, or are all backups done at the os level? Unidata DOES have journaling. I don't know how much overhead that adds to the system, but it could be worth looking into. If you go the mirroring route, you would still have to stop the database before breaking the

RE: [U2] Multiple Data Files

2006-05-17 Thread Bill Haskett
Charles: Just a note about UniData... They do allow multi-level files. The data files are within the directory structure of the dictionary. It looks like the following on Windows: - Account - FileName FileName FileName_1 FileName_2 D_FileName The (VOC) entry for FileName is:

RE: [U2] Backup Question

2006-05-17 Thread Ron Sharcott
We're looking at restructuring our backups also. Our current mess includes 3, 2-hour backups overlapping over 4.5 hours. Considering that these are all taken from the original... This is bad. One thing that we have been looking at is DBPAUSE. The problem being that anything running is left to fini

RE: [U2] Backup Question

2006-05-17 Thread Robert Paterson
OK - assuming they are on a late enough version of UniData, the best way is to use the dbpause to pause the updates, then backup - yes using mirrors would make that an easier process - then dbresume. If they are not on a late enough version, then get them to upgrade... (Late enough in my view would

RE: [U2] Backup Question

2006-05-17 Thread Dave S
1. Stop unidata telnet service. 2. Kill any users logged on 3. Backup the system 4. Start unidata telnet service. This is what we do and have been doing for many years. You should back up the server each day. Bob Hite <[EMAIL PROTECTED]> wrote: Sorry, Unidata files Backup take

[U2] UV - Distributed files

2006-05-17 Thread Jerry Banker
Since you seem to know a little about distributed (as opposed to multi-data files), I have a question. What do you do with year 2000? I've recently gotten into distributed files and was wondering how others treat year 0 records. Can there be a part number 0? -Original Message- From: [EMAIL

RE: [U2] Backup Question

2006-05-17 Thread Bob Hite
Sorry, Unidata files Backup takes about 2 hours. They are really 24/7. With the exception of Friday 3-5AM. It also seems that between those hours, every day, the system is at it quietest. I don't know what they are using at this point. But, I am asking now. I am just trying to help. This system

RE: [U2] Backup Question

2006-05-17 Thread u2
Universe or unidata? How long does their weekly backup take? Are they really 24x7, or do they shut down for the backup? How do they currently do the backup? Uvbackup? Cpio? How much of their data is outside of u2 on unix files? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMA

Re: [U2] Backup Question

2006-05-17 Thread u2
[EMAIL PROTECTED] wrote: > Hello all, > > > > I have a client that only does backup once a week. I feel this is a > dangerous situation and would like to suggest they look for an alternative. > I believe that they could mirror the live system, stop the mirror, backup > this copy and then resta

RE: [U2] Backup Question

2006-05-17 Thread Robert Paterson
One question that needs answering first though is are they using UniData or UniVerse? This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must

RE: [U2] Multiple Data Files

2006-05-17 Thread Stevenson, Charles
> From: [EMAIL PROTECTED] > > I suspect that the Ron is talking about distributed files.. And I suspect you are not an old Pickie! And I suspect you are not the only non-old-Pickie who is unfamiliar with this. (triple negative there). I consider myself an old Primate, not a Pickie, but I had

[U2] Backup Question

2006-05-17 Thread Bob Hite
Hello all, I have a client that only does backup once a week. I feel this is a dangerous situation and would like to suggest they look for an alternative. I believe that they could mirror the live system, stop the mirror, backup this copy and then restart and resync the mirror. What I don't k

RE: [U2] LIST DICT FILE Depth and Assoc

2006-05-17 Thread Stevenson, Charles
>FYI - "LIST DICT" uses an I-type to interrogate the dictionary field; >if you're brave (!!)) you can change this in DICT.DICT to report >anything you like. There's also a PICK.DICT defined in uvhome: >CT VOC DICT.PICK DICT.PICK 0001 F 0002 /dbms/uv/DICT.PICK 0003 /dbms/u

RE: [U2] Multiple Data Files

2006-05-17 Thread Stevenson, Charles
> From: Ron Hutchings > I came to the Pick world by way of Prime Information through > Universe with the Prime Flavor. I am currently working on an > implementation of Universe with the Pick flavor. I have come > across examples of Multiple Data Files in the application and > am having a diff

RE: [U2] Multiple Data Files

2006-05-17 Thread Ron Hutchings
NO, I used distributed files effectively in a previous implementation. Mark captured the essence of what I am seeing in this implementation. The suggestion of control/config/catchall files in this structure makes some sense to keep a handle on this. The implementation I am using is not shari

RE: [U2] Multiple Data Files

2006-05-17 Thread asvin . dattani
I suspect that the Ron is talking about distributed files.. Ron - this is a mechanism where you can split the data over several individual part files, but still be able to see it all together as one logical file. This means that you can open the file as a whole, and read records or select

[U2] Kevin Drury/Denver/IBM is out of the office.

2006-05-17 Thread Kevin Drury
I will be out of the office starting 05/17/2006 and will not return until 05/23/2006. I will not be picking up email or checking voice mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] LIST DICT FILE Depth and Assoc

2006-05-17 Thread Stuart . Boydell
John, Yep, I think you're probably right about A-types being inherently MV. According to the documentation I mentioned before (which you read of-course ;) the S/M in an `A' type dictionary is only relevant to SQL statements and not Retrieve. So unless your front-end can inter