RE: Setting up SQL step 1
Well, 9.5 is a VMark product ... I'm not surprised IBM said the documentation doesn't exist. As we know from the licencing fiasco, the chain of control somewhere there went down the pan ... it's changed hands three times since then and somebody probably mislaid it somewhere ... I've probably got 9.5 docu somewhere if you know what you want - but it'll be the CD version, and I know for a fact that the electronic docu at the time was incomplete... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 17 March 2004 19:40 To: U2 Users Discussion List Subject: Re: Setting up SQL step 1 Good news (I think) From what I learned - the admin user is set up when you load the operating system . I was told that if I re-installed my latest upgrade tape that I could update the user at that time. I never was able to find any of this documentation on this - and when I asked IBM, since I was running 9.5 they conveniently told me that this documentation no longer existed - go figure. *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Setting up SQL step 1
upgrade, upgrade, upgrade. You think maybe somewhere along the path between 9.5 and 10.1 the SQL setup and operation was improved just a tad? Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP [EMAIL PROTECTED] 03/18/04 06:25AM Well, 9.5 is a VMark product ... I'm not surprised IBM said the documentation doesn't exist. As we know from the licencing fiasco, the chain of control somewhere there went down the pan ... it's changed hands three times since then and somebody probably mislaid it somewhere I've probably got 9.5 docu somewhere if you know what you want - but it'll be the CD version, and I know for a fact that the electronic docu at the time was incomplete... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 17 March 2004 19:40 To: U2 Users Discussion List Subject: Re: Setting up SQL step 1 Good news (I think) From what I learned - the admin user is set up when you load the operating system . I was told that if I re-installed my latest upgrade tape that I could update the user at that time. I never was able to find any of this documentation on this - and when I asked IBM, since I was running 9.5 they conveniently told me that this documentation no longer existed - go figure. *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[OT] RE: Setting up SQL step 1
snip upgrade, upgrade, upgrade. You think maybe somewhere along the path between 9.5 and 10.1 the SQL setup and operation was improved just a tad? Don Kibbey /snip please feel free to do so. My experience with this specific issue revealed that it has stayed unchanged and I get the impression that it is not going to improve. Add to this the fact that I do not need to add the misery of new release undocumented features. dan who wishes for the return of the good old days when releases were every couple of years but 99% bug free plocinik Note: Effective February 2, 2004, Arnold Porter became a limited liability partnership with the name Arnold Porter LLP. Please change your records accordingly. The addresses, telephone and fax numbers, and e-mail addresses of the firm and attorneys have not changed. -- This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete it from his or her computer. -- Daniel Plocinik [EMAIL PROTECTED] Arnold Porter LLP Telephone: 202-274-7639 555 Twelfth Street, NW Fax:202-942-5999 Washington, DC 20004-1202 For more information about Arnold Porter LLP, click here: http://www.arnoldporter.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [OT] RE: Setting up SQL step 1
Well, that's a hearty pat on the back for all those old timers out there who worked on UniVerse during the VMark days. Still, better to upgrade (IMHO). Afterall, why not add some excitement to your life and chase some new features instead of the same old ones you already know how to deal with! Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP [EMAIL PROTECTED] 03/18/04 09:26AM LOL... love this one. At 09:23 AM 03/18/2004, you wrote: snip upgrade, upgrade, upgrade. You think maybe somewhere along the path between 9.5 and 10.1 the SQL setup and operation was improved just a tad? Don Kibbey /snip please feel free to do so. My experience with this specific issue revealed that it has stayed unchanged and I get the impression that it is not going to improve. Add to this the fact that I do not need to add the misery of new release undocumented features. dan who wishes for the return of the good old days when releases were every couple of years but 99% bug free plocinik Note: Effective February 2, 2004, Arnold Porter became a limited liability partnership with the name Arnold Porter LLP. Please change your records accordingly. The addresses, telephone and fax numbers, and e-mail addresses of the firm and attorneys have not changed. -- This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete it from his or her computer. -- Daniel Plocinik [EMAIL PROTECTED] Arnold Porter LLP Telephone: 202-274-7639 555 Twelfth Street, NW Fax:202-942-5999 Washington, DC 20004-1202 For more information about Arnold Porter LLP, click here: http://www.arnoldporter.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [OT] RE: Setting up SQL step 1
I do agree that IBM has made a decent effort at keeping UV viable, and that is a very nice thing indeed. Some of us put in a LOT of ourselves to get it where it was at 9.6. I believe that upgrading is a good thing too, although only if undocumented features are kept at a minimum. At 09:43 AM 03/18/2004, you wrote: Well, that's a hearty pat on the back for all those old timers out there who worked on UniVerse during the VMark days. Still, better to upgrade (IMHO). Afterall, why not add some excitement to your life and chase some new features instead of the same old ones you already know how to deal with! Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP [EMAIL PROTECTED] 03/18/04 09:26AM LOL... love this one. At 09:23 AM 03/18/2004, you wrote: snip upgrade, upgrade, upgrade. You think maybe somewhere along the path between 9.5 and 10.1 the SQL setup and operation was improved just a tad? Don Kibbey /snip please feel free to do so. My experience with this specific issue revealed that it has stayed unchanged and I get the impression that it is not going to improve. Add to this the fact that I do not need to add the misery of new release undocumented features. dan who wishes for the return of the good old days when releases were every couple of years but 99% bug free plocinik Note: Effective February 2, 2004, Arnold Porter became a limited liability partnership with the name Arnold Porter LLP. Please change your records accordingly. The addresses, telephone and fax numbers, and e-mail addresses of the firm and attorneys have not changed. -- This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete it from his or her computer. -- Daniel Plocinik [EMAIL PROTECTED] Arnold Porter LLP Telephone: 202-274-7639 555 Twelfth Street, NW Fax:202-942-5999 Washington, DC 20004-1202 For more information about Arnold Porter LLP, click here: http://www.arnoldporter.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Setting up SQL step 1
In a message dated 3/18/2004 3:26:32 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Sent: 17 March 2004 19:40 To: U2 Users Discussion List Subject: Re: Setting up SQL step 1 Good news (I think) From what I learned - the admin user is set up when you load the operating system . I was told that if I re-installed my latest upgrade tape that I could update the user at that time. I never was able to find any of this documentation on this - and when I asked IBM, since I was running 9.5 they conveniently told me that this documentation no longer existed - go figure. Okay remember that on the test server I had said the two UV_USERS were NT Authority\System and Primo\Administrator. The test server is Tregundo and Primo is another server. So now on the test server, we reinstalled Universe 10 and this time it created two UV_USERS as NT Authority\System and Tregundo\Administrator. Now logging on as administrator I was able to GRANT CONNECT to Will.Johnson and also GRANT DBA to Will.Johnson So it seems like two things. One when it was setup initially maybe the server names were subsequently changed and two this was enough to confuse the hell out of SQL. Reinstalling, like you suggested, just reinstalls the UV account, doesn't overwrite files in other accounts and so that worked out fine. And it fixed the UV_USERS file. Another thing I found out was that, only in one obscure location in the documentation (and NOT in the online HELP command documentation) it states that a TRIGGER program must be globally catalogued. I think it also says it can be normally (but not locally) catalogued but that didn't seem to work. On a PICK flavor account you cannot, as far as I could figure globally catalog. I tried what the documentation said and it didn't work. So I had to log to uv, create a Q pointer to the BASIC program file on the other account, then globally catalog it. Also in order for changes to your trigger to take affect you have to DROP TRIGGER, then globally catalog, the CREATE TRIGGER once more. Will battle scarred Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Setting up SQL step 1
Manuals, etc., for UniVerse 9.5, 9.6 and 10.0 are all on the IBM website. Also UniData 5.2 and 6.0. Start at http://www-306.ibm.com/software/data/u2/pubs/library/ - Original Message - From: Anthony Youngman [EMAIL PROTECTED] Date: Thu, 18 Mar 2004 12:07:03 - To: U2 Users Discussion List [EMAIL PROTECTED] Subject: RE: Setting up SQL step 1 Why might I have the 9.5 docu? Because we're still running it :-( It's all very well, but there is some truth in the old adage if it aint broke, don't fix it. Cheers, Wol -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Setting up SQL step 1
Good news (I think) From what I learned - the admin user is set up when you load the operating system . I was told that if I re-installed my latest upgrade tape that I could update the user at that time. I never was able to find any of this documentation on this - and when I asked IBM, since I was running 9.5 they conveniently told me that this documentation no longer existed - go figure. Okay it sounds like this might be related. On machine 1 which is called PRIMO the UV_USERS file says the user is OSP\Administrator While on machine 2 which is called TREGUNDO the UV_USERS file says the user is PRIMO\Administrator. So I would guess that possibly based on what you said, if I reinstall the upgrade tape on TREGUNDO maybe it will helpfully ask me what the admin user is and I either: 1) I can say TREGUNDO\Administrator or 2) I can say just Adminstrator and it will put the TREGUNDO (domain name) part in front for me. I did try logging on AS PRIMO\Administrator with the explicit domain name as part of the login and it still didn't work. But at least this other idea is a possibility. Maybe one of the things the board should ask is for IBM to assign a helpdesk person TO this list :) Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Setting up SQL step 1
Will, I missed what you were trying to do. Still some people here who might be able to help if we knew the question. At 02:39 PM 03/17/2004, you wrote: Good news (I think) From what I learned - the admin user is set up when you load the operating system . I was told that if I re-installed my latest upgrade tape that I could update the user at that time. I never was able to find any of this documentation on this - and when I asked IBM, since I was running 9.5 they conveniently told me that this documentation no longer existed - go figure. Okay it sounds like this might be related. On machine 1 which is called PRIMO the UV_USERS file says the user is OSP\Administrator While on machine 2 which is called TREGUNDO the UV_USERS file says the user is PRIMO\Administrator. So I would guess that possibly based on what you said, if I reinstall the upgrade tape on TREGUNDO maybe it will helpfully ask me what the admin user is and I either: 1) I can say TREGUNDO\Administrator or 2) I can say just Adminstrator and it will put the TREGUNDO (domain name) part in front for me. I did try logging on AS PRIMO\Administrator with the explicit domain name as part of the login and it still didn't work. But at least this other idea is a possibility. Maybe one of the things the board should ask is for IBM to assign a helpdesk person TO this list :) Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Setting up SQL step 1
Will, I just set up a PE version and found out that who ever is logged in when you do the update gets assigned. You are not prompted - it just assigns it to that domain \ user name. Hope this helps. dan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] (U2 Users Discussion List) [EMAIL PROTECTED] cc: ver.com Subject: Re: Setting up SQL step 1 03/17/2004 02:39 PM Please respond to U2 Users Discussion List Good news (I think) From what I learned - the admin user is set up when you load the operating system . I was told that if I re-installed my latest upgrade tape that I could update the user at that time. I never was able to find any of this documentation on this - and when I asked IBM, since I was running 9.5 they conveniently told me that this documentation no longer existed - go figure. Okay it sounds like this might be related. On machine 1 which is called PRIMO the UV_USERS file says the user is OSP\Administrator While on machine 2 which is called TREGUNDO the UV_USERS file says the user is PRIMO\Administrator. So I would guess that possibly based on what you said, if I reinstall the upgrade tape on TREGUNDO maybe it will helpfully ask me what the admin user is and I either: 1) I can say TREGUNDO\Administrator or 2) I can say just Adminstrator and it will put the TREGUNDO (domain name) part in front for me. I did try logging on AS PRIMO\Administrator with the explicit domain name as part of the login and it still didn't work. But at least this other idea is a possibility. Maybe one of the things the board should ask is for IBM to assign a helpdesk person TO this list :) Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Note: Effective February 2, 2004, Arnold Porter became a limited liability partnership with the name Arnold Porter LLP. Please change your records accordingly. The addresses, telephone and fax numbers, and e-mail addresses of the firm and attorneys have not changed. -- This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete it from his or her computer. -- Daniel Plocinik [EMAIL PROTECTED] Arnold Porter LLP Telephone: 202-274-7639 555 Twelfth Street, NW Fax:202-942-5999 Washington, DC 20004-1202 For more information about Arnold Porter LLP, click here: http://www.arnoldporter.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Setting up SQL step 1
Will, According to the manual, you'd first grant CONNECT privileges, then you can grant DBA. Not sure why it says the admin id isn't an SQL user. On NT it should default to the administrator you installed with. At 02:56 PM 03/17/2004, you wrote: Glenn, et al. I have a client who has never used SQL and I want to use it for something. So I tried to create a schema and it says Will.Johnson is not an SQL user. Ok so I tried to create myself as a user while logged in as administrator And it says TREGUNDO\Administrator is not an SQL user. In UV_USERS it says PRIMO\Administrator has DBAuth set to YES So I tried to login as PRIMO\Administrator and then Grant DBA to Will.Johnson and it says PRIMO\Administrator is not an SQL user Even though that is the name in UV_Users But then again I've never tried to use SQL before. Ultimately I want to create a trigger on a certain file and to do that it appears I need to be an SQL user. Because I tried to do it and it says I'm not an SQL user. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Setting up SQL step 1
I have a client who has never used SQL on their system and I'd like to set it up. It is a Universe 10.0 on Windows setup. When I look at UV_Users I see two users one is NT Authority/System and the other is OSP/administrator My first question is: Is there really a windows login called System ? Can a person log in as system? I have tried various ways to log in as administrator and cannot seem to let it GRANT DBA to Will.Johnson whenever I try it just complains that administrator is not an SQL user or something like that. So what could be wrong? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users