Re: [U2] keeping track of opened files
The nearest is to execute PORT.STATUS PORT nn FILEMAP Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: 05 March 2012 22:27 To: dgr...@dagconsulting.com; U2 Users List Subject: Re: [U2] keeping track of opened files On unidata, system(50) gives you a list of the names of files that have been opened, but doesn't give you the file pointer variables that they have been opened into. On universe there isn't an equivalent system() function that I can see. On Mar 5, 2012, at 2:07 PM, David A. Green wrote: Look at SYSTEM(50) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: Monday, March 05, 2012 11:42 AM To: U2 Users List Subject: [U2] keeping track of opened files So the guru question is: Does either universe or unidata provide a way to get a list of opened files from some internal list or pool? I don't think so. Your application will need to keep track of each file as it opens them. Somewhere there's a universe technical bulletin that describes a method for this. you use a named common which contains 2 arrays, one for file names, and one for file pointers. When you want to open a file, you LOCATE into the name array and use the associated file pointer if found. If not, you open the file and add the name and pointer to the array. On Mar 5, 2012, at 12:57 PM, Wjhonson wrote: I have to guess that the OP really wanted something like N.FILE = CUSTOMER; GOSUB CHECK.IF.FILE.IS.OPEN IF ERROR.FILE THEN OPEN N.FILE TO F.FILE ELSE do something here END ELSE IS.OPEN = TRUE END CHECK.IF.FILE.IS.OPEN: some function which checks if N.FILE exists in some rotating pool of FILE(MAXFILES) if so return file variable pointer set in F.FILE else set error flag in ERROR.FILE RETURN Of course the pseudo code above has to be filled in with appropriate site specific code Here we use a subroutine FILE.OPEN whose pool of open files lives in global named common I really think that is what the OP was after -Original Message- From: David Wolverton dwolv...@flash.net To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Mon, Mar 5, 2012 9:51 am Subject: Re: [U2] Hello In that case, where every file is named FILE in your programs, but you ant to make sure FILE is opened against CUSTOMER, I would guess you would o this: IF (FILEINFO(FILE, 0) = 0) THEN OPEN 'CUSTOMER' TO FILE ELSE END ND ELSE IF FILEINFO(FILE,17) # CUSTOMER THEN CLOSE FILE OPEN 'CUSTOMER' TO FILE ELSE END END ND David W. Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Monday, March 05, 2012 11:06 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] Hello don't think this will work. n your example John, you need to know the file variable assigned to the ile. o F (FILEINFO(CUSTOMER,0)=0) THEN OPEN CUSTOMER TO CUSTOMER ELSE... But you can't use FILEINFO to check CUSTOMER, only to check CUSTOMER. o you can't tell if a file is opened already and to what file variable. ou can only tell if a certain file variable is opened. -Original Message- rom: Israel, John R. johnisr...@daytonsuperior.com o: 'U2 Users List' u2-users@listserver.u2ug.org ent: Mon, Mar 5, 2012 7:56 am ubject: Re: [U2] Hello assume you have some way of knowing what files you want. o something like: F (FILEINFO(yourfilename, 0) = 0) THEN PEN yourfilename ... D ohn Original Message- om: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] Behalf Of Dave Laansma nt: Monday, March 05, 2012 10:38 AM : U2 Users List bject: Re: [U2] Hello kay, I've got a pretty simple question ... ow do I get a list of all files that are currently OPEN so I know whether I ed to open a given file again? incerely, vid Laansma Manager bbard Supply Co. rect: 810-342-7143 fice: 810-234-8681 x: 810-234-6142 w.hubbardsupply.com elivering Products, Services and Innovative Solutions Original Message- om: u2-users-boun...@listserver.u2ug.org ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug nt: Monday, March 05, 2012 10:32 AM : U2 Users List bject: [U2] Hello s the list alive ? Haven't seen anything for a week. __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2-Users Digest, Vol 35, Issue 4
___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users End of U2-Users Digest, Vol 35, Issue 4 *** Message: 15 We have a phantom that runs for months at a time that transfers every record from every file to another server via NFA. Anyway as we open each file we check to see if it is in our array, if it isn't we insert it into an array. (using a LOCATE into an DIMENSIONED array of 1000) (as the max you can open is 944 in Unidata). Additionally every night at 2am we clean out the array and run an internal routine that CLOSE each of the files in the DIMENSIONED ARRAY, nulling out the variable and also using the CLEARCOMMON - in order to not keep chewing up memory. Additionally since we are writing between 2 or more servers we use the FILEINFO(F.FILENAME,17) command to make sure the file is still open and readable. We have been using this method for over 20 years and it works very well. Nick ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Indexing I-Desc
I have a select that is taking too long. Many of the fields are I-Descs. Some are extracting a piece of info from the file, some are translates to other files, and some are running subroutines. I understand that danger of indexing a translate or subroutine (if the source data changes, the index is not updated). However, I am toying with the idea of building a new I-desc that in some way combines the data in the core file itself. For example, if I need F11 F20[4,1] and F40, make an I-desc that combines these and then index that I-desc. Just as a sanity check, does this sound like a reasonable thing to do so that I can at least grab a subset of the data I need prior to actually plowing through the translates and subroutines? John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing I-Desc
as long as the data truly resides in the file then you should be fine example I F11:*:F20[1,4]:*:F40 etc Rich Israel, John R. wrote: I have a select that is taking too long. Many of the fields are I-Descs. Some are extracting a piece of info from the file, some are translates to other files, and some are running subroutines. I understand that danger of indexing a translate or subroutine (if the source data changes, the index is not updated). However, I am toying with the idea of building a new I-desc that in some way combines the data in the core file itself. For example, if I need F11 F20[4,1] and F40, make an I-desc that combines these and then index that I-desc. Just as a sanity check, does this sound like a reasonable thing to do so that I can at least grab a subset of the data I need prior to actually plowing through the translates and subroutines? John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing I-Desc
As long as all the data comes from the record and/or id itself, you should be fine. You can get into trouble if it comes from another record in the same file or another file entirely, although it can be done if the other file contains stable data - a word index for example, where you have a secondary file that contains words that are not included in the index, and the list is updated with all the dependent indices as part of a maintenance routine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, March 06, 2012 1:41 PM To: 'U2 Users List' Subject: [U2] Indexing I-Desc I have a select that is taking too long. Many of the fields are I-Descs. Some are extracting a piece of info from the file, some are translates to other files, and some are running subroutines. I understand that danger of indexing a translate or subroutine (if the source data changes, the index is not updated). However, I am toying with the idea of building a new I-desc that in some way combines the data in the core file itself. For example, if I need F11 F20[4,1] and F40, make an I-desc that combines these and then index that I-desc. Just as a sanity check, does this sound like a reasonable thing to do so that I can at least grab a subset of the data I need prior to actually plowing through the translates and subroutines? John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe 10.2 to 11.1
All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.2 to 11.1
Harold, I just did this upgrade about a week ago.. it was super easy. I actually went from 10.1.18 to 11.1.1 and the transition was smooth but there were a couple things to note: 1) Install Universe 11.x under the 'modify' setting. 2) The file paths are diff (c:\ibm\uv vs. c:\u2\uv), so agree to have the files MOVED from one to the other (during install). [make sure permissions allow this on the folder] 3) run UPDATE.ACCOUNT (UniVerse command) in each of the UniVerse accounts, then update the VOC when it asks you to. Cost = 1 day of my time Time = 2 hours (most of the time spent was getting the UniVerse license) 11.1.1 has been perfect for me so far and I have not had 1 hiccup as a result of the upgrade. Here is a writeup done by one user: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Here was my post from the other week: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Chris Date: Tue, 6 Mar 2012 11:34:31 -0800 From: harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.2 to 11.1 All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.2 to 11.1
Here is the writeup from one user (who upgraded to 11.1): http://nebula-rnd.com/blog/tech/mv/2011/04/u2upgrade2.html Chris From: cjausti...@hotmail.com To: u2-users@listserver.u2ug.org Date: Tue, 6 Mar 2012 14:03:56 -0600 Subject: Re: [U2] Universe 10.2 to 11.1 Harold, I just did this upgrade about a week ago.. it was super easy. I actually went from 10.1.18 to 11.1.1 and the transition was smooth but there were a couple things to note: 1) Install Universe 11.x under the 'modify' setting. 2) The file paths are diff (c:\ibm\uv vs. c:\u2\uv), so agree to have the files MOVED from one to the other (during install). [make sure permissions allow this on the folder] 3) run UPDATE.ACCOUNT (UniVerse command) in each of the UniVerse accounts, then update the VOC when it asks you to. Cost = 1 day of my time Time = 2 hours (most of the time spent was getting the UniVerse license) 11.1.1 has been perfect for me so far and I have not had 1 hiccup as a result of the upgrade. Here is a writeup done by one user: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Here was my post from the other week: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Chris Date: Tue, 6 Mar 2012 11:34:31 -0800 From: harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.2 to 11.1 All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing I-Desc
Sounds good. Thanks guys John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Tuesday, March 06, 2012 1:51 PM To: U2 Users List Subject: Re: [U2] Indexing I-Desc As long as all the data comes from the record and/or id itself, you should be fine. You can get into trouble if it comes from another record in the same file or another file entirely, although it can be done if the other file contains stable data - a word index for example, where you have a secondary file that contains words that are not included in the index, and the list is updated with all the dependent indices as part of a maintenance routine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, March 06, 2012 1:41 PM To: 'U2 Users List' Subject: [U2] Indexing I-Desc I have a select that is taking too long. Many of the fields are I-Descs. Some are extracting a piece of info from the file, some are translates to other files, and some are running subroutines. I understand that danger of indexing a translate or subroutine (if the source data changes, the index is not updated). However, I am toying with the idea of building a new I-desc that in some way combines the data in the core file itself. For example, if I need F11 F20[4,1] and F40, make an I-desc that combines these and then index that I-desc. Just as a sanity check, does this sound like a reasonable thing to do so that I can at least grab a subset of the data I need prior to actually plowing through the translates and subroutines? John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.2 to 11.1
Thanks Chris. The link you have is to a user (Tony Gravagno) updating the PE edition. My application is Universe running over hpux so it's a little different setting. I'm looking for anyone who has done 10.2 to 11.1 in that setting (or with o/s linux which would be quite similar). But I think doing the PE11 download is a nice idea and will try it. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, March 06, 2012 12:05 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe 10.2 to 11.1 Here is the writeup from one user (who upgraded to 11.1): http://nebula-rnd.com/blog/tech/mv/2011/04/u2upgrade2.html Chris From: cjausti...@hotmail.com To: u2-users@listserver.u2ug.org Date: Tue, 6 Mar 2012 14:03:56 -0600 Subject: Re: [U2] Universe 10.2 to 11.1 Harold, I just did this upgrade about a week ago.. it was super easy. I actually went from 10.1.18 to 11.1.1 and the transition was smooth but there were a couple things to note: 1) Install Universe 11.x under the 'modify' setting. 2) The file paths are diff (c:\ibm\uv vs. c:\u2\uv), so agree to have the files MOVED from one to the other (during install). [make sure permissions allow this on the folder] 3) run UPDATE.ACCOUNT (UniVerse command) in each of the UniVerse accounts, then update the VOC when it asks you to. Cost = 1 day of my time Time = 2 hours (most of the time spent was getting the UniVerse license) 11.1.1 has been perfect for me so far and I have not had 1 hiccup as a result of the upgrade. Here is a writeup done by one user: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Here was my post from the other week: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Chris Date: Tue, 6 Mar 2012 11:34:31 -0800 From: harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.2 to 11.1 All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.2 to 11.1
I just went from 10.3.4 on AIX 5.3, to 11.1.4 on Red Hat 6.2 Most of the pain was the operating system conversion and new hardware. The actual Universe stuff was pretty painless. We've only been live for a few days, so I have not had time to play with any new stuff. We had to rebuild our globally cataloged stuff, but, we had the source code. We had to transfer over items from UV.ACCOUNTS file. We had to upgrade all the VOC's, but, they have command line utility that you can write a BASIC program to do that if you want. -The utility is called = /usr/uv/bin/updaccount -Someone on the list had a utility to run this in every account. -I think all you need to do is, loop through the UV.ACCOUNTS file and run this command on every account Oh yes, and then if you have a file called 'ORDER' (I mean, who would write a business application with a file called ORDER!!!- note the sarcasm), then you have to put those file pointers back, because the upgrade utility will wipe them out. Just look in TEMP of the account and you will find the VOC items replaced by the upgrade utility. Oh yeah and then we have to run format.conv on every file and object code to bit swap them from AIX to Linux, but, again, if you aren't changing OS's, you don't need to worry about that. Again, another BASIC program to write. Thats all I can remember, as I haven't slept much in the past week... On Tue, Mar 6, 2012 at 3:05 PM, Chris Austin cjausti...@hotmail.com wrote: Here is the writeup from one user (who upgraded to 11.1): http://nebula-rnd.com/blog/tech/mv/2011/04/u2upgrade2.html Chris From: cjausti...@hotmail.com To: u2-users@listserver.u2ug.org Date: Tue, 6 Mar 2012 14:03:56 -0600 Subject: Re: [U2] Universe 10.2 to 11.1 Harold, I just did this upgrade about a week ago.. it was super easy. I actually went from 10.1.18 to 11.1.1 and the transition was smooth but there were a couple things to note: 1) Install Universe 11.x under the 'modify' setting. 2) The file paths are diff (c:\ibm\uv vs. c:\u2\uv), so agree to have the files MOVED from one to the other (during install). [make sure permissions allow this on the folder] 3) run UPDATE.ACCOUNT (UniVerse command) in each of the UniVerse accounts, then update the VOC when it asks you to. Cost = 1 day of my time Time = 2 hours (most of the time spent was getting the UniVerse license) 11.1.1 has been perfect for me so far and I have not had 1 hiccup as a result of the upgrade. Here is a writeup done by one user: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Here was my post from the other week: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Chris Date: Tue, 6 Mar 2012 11:34:31 -0800 From: harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.2 to 11.1 All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.2 to 11.1
Oh yes and do yourself a favor and create yourself a symlink: /usr/ibm/uv to /usr/uv That way you can avoid any nuisances with Rocket changing the path name on you. On Tue, Mar 6, 2012 at 3:21 PM, John Thompson jthompson...@gmail.comwrote: I just went from 10.3.4 on AIX 5.3, to 11.1.4 on Red Hat 6.2 Most of the pain was the operating system conversion and new hardware. The actual Universe stuff was pretty painless. We've only been live for a few days, so I have not had time to play with any new stuff. We had to rebuild our globally cataloged stuff, but, we had the source code. We had to transfer over items from UV.ACCOUNTS file. We had to upgrade all the VOC's, but, they have command line utility that you can write a BASIC program to do that if you want. -The utility is called = /usr/uv/bin/updaccount -Someone on the list had a utility to run this in every account. -I think all you need to do is, loop through the UV.ACCOUNTS file and run this command on every account Oh yes, and then if you have a file called 'ORDER' (I mean, who would write a business application with a file called ORDER!!!- note the sarcasm), then you have to put those file pointers back, because the upgrade utility will wipe them out. Just look in TEMP of the account and you will find the VOC items replaced by the upgrade utility. Oh yeah and then we have to run format.conv on every file and object code to bit swap them from AIX to Linux, but, again, if you aren't changing OS's, you don't need to worry about that. Again, another BASIC program to write. Thats all I can remember, as I haven't slept much in the past week... On Tue, Mar 6, 2012 at 3:05 PM, Chris Austin cjausti...@hotmail.comwrote: Here is the writeup from one user (who upgraded to 11.1): http://nebula-rnd.com/blog/tech/mv/2011/04/u2upgrade2.html Chris From: cjausti...@hotmail.com To: u2-users@listserver.u2ug.org Date: Tue, 6 Mar 2012 14:03:56 -0600 Subject: Re: [U2] Universe 10.2 to 11.1 Harold, I just did this upgrade about a week ago.. it was super easy. I actually went from 10.1.18 to 11.1.1 and the transition was smooth but there were a couple things to note: 1) Install Universe 11.x under the 'modify' setting. 2) The file paths are diff (c:\ibm\uv vs. c:\u2\uv), so agree to have the files MOVED from one to the other (during install). [make sure permissions allow this on the folder] 3) run UPDATE.ACCOUNT (UniVerse command) in each of the UniVerse accounts, then update the VOC when it asks you to. Cost = 1 day of my time Time = 2 hours (most of the time spent was getting the UniVerse license) 11.1.1 has been perfect for me so far and I have not had 1 hiccup as a result of the upgrade. Here is a writeup done by one user: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Here was my post from the other week: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Chris Date: Tue, 6 Mar 2012 11:34:31 -0800 From: harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.2 to 11.1 All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.2 to 11.1
Thanks - well written! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Tuesday, March 06, 2012 12:21 PM To: U2 Users List Subject: Re: [U2] Universe 10.2 to 11.1 I just went from 10.3.4 on AIX 5.3, to 11.1.4 on Red Hat 6.2 Most of the pain was the operating system conversion and new hardware. The actual Universe stuff was pretty painless. We've only been live for a few days, so I have not had time to play with any new stuff. We had to rebuild our globally cataloged stuff, but, we had the source code. We had to transfer over items from UV.ACCOUNTS file. We had to upgrade all the VOC's, but, they have command line utility that you can write a BASIC program to do that if you want. -The utility is called = /usr/uv/bin/updaccount -Someone on the list had a utility to run this in every account. -I think all you need to do is, loop through the UV.ACCOUNTS file and run this command on every account Oh yes, and then if you have a file called 'ORDER' (I mean, who would write a business application with a file called ORDER!!!- note the sarcasm), then you have to put those file pointers back, because the upgrade utility will wipe them out. Just look in TEMP of the account and you will find the VOC items replaced by the upgrade utility. Oh yeah and then we have to run format.conv on every file and object code to bit swap them from AIX to Linux, but, again, if you aren't changing OS's, you don't need to worry about that. Again, another BASIC program to write. Thats all I can remember, as I haven't slept much in the past week... On Tue, Mar 6, 2012 at 3:05 PM, Chris Austin cjausti...@hotmail.com wrote: Here is the writeup from one user (who upgraded to 11.1): http://nebula-rnd.com/blog/tech/mv/2011/04/u2upgrade2.html Chris From: cjausti...@hotmail.com To: u2-users@listserver.u2ug.org Date: Tue, 6 Mar 2012 14:03:56 -0600 Subject: Re: [U2] Universe 10.2 to 11.1 Harold, I just did this upgrade about a week ago.. it was super easy. I actually went from 10.1.18 to 11.1.1 and the transition was smooth but there were a couple things to note: 1) Install Universe 11.x under the 'modify' setting. 2) The file paths are diff (c:\ibm\uv vs. c:\u2\uv), so agree to have the files MOVED from one to the other (during install). [make sure permissions allow this on the folder] 3) run UPDATE.ACCOUNT (UniVerse command) in each of the UniVerse accounts, then update the VOC when it asks you to. Cost = 1 day of my time Time = 2 hours (most of the time spent was getting the UniVerse license) 11.1.1 has been perfect for me so far and I have not had 1 hiccup as a result of the upgrade. Here is a writeup done by one user: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Here was my post from the other week: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Chris Date: Tue, 6 Mar 2012 11:34:31 -0800 From: harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.2 to 11.1 All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to
Re: [U2] Universe 10.2 to 11.1
Some time ago we upgraded our development server to 11.1.1 (hpux) and ran into a couple of bugs involving indexes. Our development server is currently on 11.1.3 with those bugs completely wiped out. We haven't yet been able (schedule-wise, etc.) to get our production server updated, so it is still running 10.3.2. Our sys admin isn't here at the moment, but didn't report any extra difficulties or delays compared to any previous upgrades. Best Regards, Richard Lewis On Tue, Mar 6, 2012 at 12:34 PM, Oaks, Harold harold.o...@clark.wa.govwrote: All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] keeping track of open files
am i missing something here or what?? you would first have to have an idea as the variable that a file has been opened to determine if it is open. without knowing this, all else is worthless. so you find out a file is open, without the file variable you can't do anything anyway. maybe you have to go thru the program and analysis all the file i/o to see what variables are used, and then you can determine if it is open. of course, if the opened file is passed as an argument to a subroutine, who knows if they called it the same in the sub. good luck jay ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
