Re: Common Universe/Unidata files
This file would be accessed by quite a number of programs, many times during a day. Thanks, everyone. You have given us some excellent options to consider. Randal -Original Message- From: Timothy Snyder <[EMAIL PROTECTED]> Sent: Feb 25, 2004 3:45 PM To: U2 Users Discussion List <[EMAIL PROTECTED]> Subject: Re: Common Universe/Unidata files Randal, With half a million records, I strongly agree that you don't want to put this in a directory file. Without knowing more about what you're doing, I'd be inclined to set up a hashed file stored in either UniVerse or UniData (flip a coin). Then you could put together a socket client/server setup to handle updates from the other side. That could be set up with the appropriate rules to handle locking and anything else that may be required to properly negotiate updates. You might need to pass around some other information, such the next key, etc., but it shouldn't be too bad. Is this something that would need to be accessed from many programs, or just a few? How frequently would the file be accessed and updated? Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services Office (717) 545-6403 (rolls to cell phone) [EMAIL PROTECTED] Randal LeBlanc wrote on 02/25/2004 02:49:10 PM: > We have separate applications running on Universe and Unidata. The > apps run on separate > aix servers. > We would like to create a common file that can be accessed by both > applications > but are not sure of the best approach to take. > Any suggestions??-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Common Universe/Unidata files
I suppose switching one of the machines to the other database is not an option? >>> [EMAIL PROTECTED] 02/26/04 09:20AM >>> This file would be accessed by quite a number of programs, many times during a day. Thanks, everyone. You have given us some excellent options to consider. Randal -Original Message- From: Timothy Snyder <[EMAIL PROTECTED]> Sent: Feb 25, 2004 3:45 PM To: U2 Users Discussion List <[EMAIL PROTECTED]> Subject: Re: Common Universe/Unidata files Randal, With half a million records, I strongly agree that you don't want to put this in a directory file. Without knowing more about what you're doing, I'd be inclined to set up a hashed file stored in either UniVerse or UniData (flip a coin). Then you could put together a socket client/server setup to handle updates from the other side. That could be set up with the appropriate rules to handle locking and anything else that may be required to properly negotiate updates. You might need to pass around some other information, such the next key, etc., but it shouldn't be too bad. Is this something that would need to be accessed from many programs, or just a few? How frequently would the file be accessed and updated? Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services Office (717) 545-6403 (rolls to cell phone) [EMAIL PROTECTED] Randal LeBlanc wrote on 02/25/2004 02:49:10 PM: > We have separate applications running on Universe and Unidata. The > apps run on separate > aix servers. > We would like to create a common file that can be accessed by both > applications > but are not sure of the best approach to take. > Any suggestions??-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.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
RE: Common Universe/Unidata files
Sorry I do not have more time to look into this myself, but have you looked at OFS (Open File System) on Unidata. http://www-306.ibm.com/software/data/u2/pubs/library/52unidata/Ofnf.pdf A good question is to ask if anyone has set up this type of connection. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Randal LeBlanc Sent: Wednesday, February 25, 2004 12:49 PM To: [EMAIL PROTECTED] Subject: Common Universe/Unidata files We have separate applications running on Universe and Unidata. The apps run on separate aix servers. We would like to create a common file that can be accessed by both applications but are not sure of the best approach to take. Any suggestions?? Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.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
RE: Common Universe/Unidata files
Mike, I have not looked into it, but I will. Thanks, Randal -Original Message- From: Mike Rajkowski <[EMAIL PROTECTED]> Sent: Feb 26, 2004 9:03 AM To: U2 Users Discussion List <[EMAIL PROTECTED]> Subject: RE: Common Universe/Unidata files Sorry I do not have more time to look into this myself, but have you looked at OFS (Open File System) on Unidata. http://www-306.ibm.com/software/data/u2/pubs/library/52unidata/Ofnf.pdf A good question is to ask if anyone has set up this type of connection. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Randal LeBlanc Sent: Wednesday, February 25, 2004 12:49 PM To: [EMAIL PROTECTED] Subject: Common Universe/Unidata files We have separate applications running on Universe and Unidata. The apps run on separate aix servers. We would like to create a common file that can be accessed by both applications but are not sure of the best approach to take. Any suggestions?? Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.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 Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Common Universe/Unidata files
Donald, I has been considered and is a possibility. -Original Message- From: Donald Kibbey <[EMAIL PROTECTED]> Sent: Feb 26, 2004 8:33 AM To: [EMAIL PROTECTED] Subject: Re: Common Universe/Unidata files I suppose switching one of the machines to the other database is not an option? >>> [EMAIL PROTECTED] 02/26/04 09:20AM >>> This file would be accessed by quite a number of programs, many times during a day. Thanks, everyone. You have given us some excellent options to consider. Randal -Original Message- From: Timothy Snyder <[EMAIL PROTECTED]> Sent: Feb 25, 2004 3:45 PM To: U2 Users Discussion List <[EMAIL PROTECTED]> Subject: Re: Common Universe/Unidata files Randal, With half a million records, I strongly agree that you don't want to put this in a directory file. Without knowing more about what you're doing, I'd be inclined to set up a hashed file stored in either UniVerse or UniData (flip a coin). Then you could put together a socket client/server setup to handle updates from the other side. That could be set up with the appropriate rules to handle locking and anything else that may be required to properly negotiate updates. You might need to pass around some other information, such the next key, etc., but it shouldn't be too bad. Is this something that would need to be accessed from many programs, or just a few? How frequently would the file be accessed and updated? Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services Office (717) 545-6403 (rolls to cell phone) [EMAIL PROTECTED] Randal LeBlanc wrote on 02/25/2004 02:49:10 PM: > We have separate applications running on Universe and Unidata. The > apps run on separate > aix servers. > We would like to create a common file that can be accessed by both > applications > but are not sure of the best approach to take. > Any suggestions??-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.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 Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Common Universe/Unidata files
> We have separate applications running on Universe and Unidata. > The apps run on separate > aix servers. > We would like to create a common file that can be accessed by > both applications > but are not sure of the best approach to take. > Any suggestions?? > UniObjects for Java? A UOJ session on the UV box does the reads and writes to the UD box and/or visa-versa. -- Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Common Universe/Unidata files
In a message dated 2/25/2004 2:49:10 PM Eastern Standard Time, [EMAIL PROTECTED] writes: > We have separate applications running on Universe and Unidata. The apps run on > separate > aix servers. > We would like to create a common file that can be accessed > by both applications > but are not sure of the best approach to take. > Any suggestions?? > > > Randal LeBlanc > JCL Associates, Inc. Randal I can think of two ways to do this right off. 1) A file that is defined as a directory to both Universe and Unidata. Of course one or the other server would have to be mounted on the other's filesystem in order to "see" this alien directory. (Please forgive me if my nomenclauture is incorrect). If you are concerned about a single directory having hundreds of thousands of files in it, cannot they be defined as dynamic (Unidata) or distributed (Universe) directory structures? I.E. one directory with hundreds of subdirectories (or as many as you wish) each of which have hundreds or thousands of files in them. To Unidata and/or Universe, it should see this huge structure as one "file". Right? 2) Have the file be native to one system and setup a phantom on that system that wakes every five seconds, minute, or whatever and looks for something to "do". The other system then, writes out updates to a "waiting" area and trips a flag for the first system to "do" something. When the phantom wakes up, it sees the flag, grabs the update and updates the file. The second method works just fine if the file in question is some sort of log type file. Not as well if its not, but its still possible to fudgilate the systems to work. I remember setting up a interactive, multi-user, multi-computer type update like this years ago to allow an ADDS to update files on an Ulimate using Mentor/Link and set of fancy schmancy (technical term) set of routines to co-ordinate the lock tables. Most multi-computer schemes require operating systems from the same vendor, but with six months and a lot of free time and code that negotiates the first four or so layers for you, you can do it yourself... Will "My bank account says it's better to over-engineer" Johnson Fast Forward Technologies -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Common Universe/Unidata files
Randal, With half a million records, I strongly agree that you don't want to put this in a directory file. Without knowing more about what you're doing, I'd be inclined to set up a hashed file stored in either UniVerse or UniData (flip a coin). Then you could put together a socket client/server setup to handle updates from the other side. That could be set up with the appropriate rules to handle locking and anything else that may be required to properly negotiate updates. You might need to pass around some other information, such the next key, etc., but it shouldn't be too bad. Is this something that would need to be accessed from many programs, or just a few? How frequently would the file be accessed and updated? Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services Office (717) 545-6403 (rolls to cell phone) [EMAIL PROTECTED] Randal LeBlanc wrote on 02/25/2004 02:49:10 PM: > We have separate applications running on Universe and Unidata. The > apps run on separate > aix servers. > We would like to create a common file that can be accessed by both > applications > but are not sure of the best approach to take. > Any suggestions??-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Common Universe/Unidata files
Unfortunately, there is no hashed file that can be common to both UniVerse and UniData. You may want to explore some sort of duplicate file with 2 way updates. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Randal LeBlanc Sent: Wednesday, February 25, 2004 3:13 PM To: U2 Users Discussion List Subject: Re: Common Universe/Unidata files Rich, Thanks for the reply. Yes, that is a possibility. However, the file will be very large (over 500,000 records) and I am concerned about performance with an aix directory structure. -Original Message- From: "Richard A. Wilson" <[EMAIL PROTECTED]> Sent: Feb 25, 2004 12:08 PM To: U2 Users Discussion List <[EMAIL PROTECTED]> Subject: Re: Common Universe/Unidata files without getting into odbc etc. is record locking required control file kind of data can you set the file up as type 19 under universe and dir under unidata Rich Randal LeBlanc wrote: > We have separate applications running on Universe and Unidata. The > apps run on separate aix servers. We would like to create a common > file that can be accessed by both applications but are not sure of the > best approach to take. Any suggestions?? > > > Randal LeBlanc > JCL Associates, Inc. > [EMAIL PROTECTED] > www.jclinc.com -- Richard A. Wilson Lakeside Systems -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Common Universe/Unidata files
Rich, Thanks for the reply. Yes, that is a possibility. However, the file will be very large (over 500,000 records) and I am concerned about performance with an aix directory structure. -Original Message- From: "Richard A. Wilson" <[EMAIL PROTECTED]> Sent: Feb 25, 2004 12:08 PM To: U2 Users Discussion List <[EMAIL PROTECTED]> Subject: Re: Common Universe/Unidata files without getting into odbc etc. is record locking required control file kind of data can you set the file up as type 19 under universe and dir under unidata Rich Randal LeBlanc wrote: > We have separate applications running on Universe and Unidata. The apps run on > separate > aix servers. > We would like to create a common file that can be accessed by both applications > but are not sure of the best approach to take. > Any suggestions?? > > > Randal LeBlanc > JCL Associates, Inc. > [EMAIL PROTECTED] > www.jclinc.com -- Richard A. Wilson Lakeside Systems -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Common Universe/Unidata files
without getting into odbc etc. is record locking required control file kind of data can you set the file up as type 19 under universe and dir under unidata Rich Randal LeBlanc wrote: We have separate applications running on Universe and Unidata. The apps run on separate aix servers. We would like to create a common file that can be accessed by both applications but are not sure of the best approach to take. Any suggestions?? Randal LeBlanc JCL Associates, Inc. [EMAIL PROTECTED] www.jclinc.com -- Richard A. Wilson Lakeside Systems -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
