RE: [U2] [UV] using distributed files with multi level data files possible?
Mike... Wow, the 64bit is an easy solution. I tried something with either the create-file or the resize command 6 months ago and it failed with my conclusion at the time that it must not be supported on our windows 2003 platform. Yesterday I used the create file with the 64bit option and it worked fine. Thanks for the tip! Stuart, thanks for the reminder on how to share dictionaries easily on universe. -Troy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Troy, You _can_ use 64-bit files on 32-bit Windows 2003 Server, NTFS is quite happy with files over 2GB. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart I'd do something like this paragraph (not tested...) but it should create the parts and update them to all point to the same dictionary. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [SPAM] - RE: [U2] [UV] using distributed files with multi level data files possible? - Email has different SMTP TO: and MIME TO: fields in the email addresses
I concur I use 64bit files for anything over 2 gig now and I am on a 32 bit Windows 2003 server -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Wednesday, October 15, 2008 9:56 AM To: u2-users@listserver.u2ug.org Subject: [SPAM] - RE: [U2] [UV] using distributed files with multi level data files possible? - Email has different SMTP TO: and MIME TO: fields in the email addresses Mike... Wow, the 64bit is an easy solution. I tried something with either the create-file or the resize command 6 months ago and it failed with my conclusion at the time that it must not be supported on our windows 2003 platform. Yesterday I used the create file with the 64bit option and it worked fine. Thanks for the tip! Stuart, thanks for the reminder on how to share dictionaries easily on universe. -Troy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Troy, You _can_ use 64-bit files on 32-bit Windows 2003 Server, NTFS is quite happy with files over 2GB. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart I'd do something like this paragraph (not tested...) but it should create the parts and update them to all point to the same dictionary. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] using distributed files with multi level data files possible?
We decided to try (64bit Type30 on 64bit OS) part files on a couple of large transaction files because it made archiving easier for us. We could just drop off a chunk at a time. However, we've since discovered that part files can't be used with SBClient SmartQuery because it uses S/REFORMAT verb. As far as I know we haven't had any problems with UVNet on 64bit dynamic files on our (thirty) 2 bit Windows platforms. Stuart -Original Message- We have a few distributed files on UV 10.1.18 on Windows 2003 32 bit. 64 bit files would be better but I thought there were limitations in their use on a 32 bit OS, especially with DYNAMIC files? I seem to remember from the UV internals course that UV/Net can have problems accessing the file. Does this ring a bell with anyone? ** 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 communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] using distributed files with multi level data files possible? {Unclassified}
UV/Net doesn't handle Distributed Files (32- or 64-bit) - it's a published 'feature'. You have to refer to the individual part files. Actually, that seems like a good Better-and-Better submission ... Regards Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Thursday, 16 October 2008 11:26 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] using distributed files with multi level data files possible? We decided to try (64bit Type30 on 64bit OS) part files on a couple of large transaction files because it made archiving easier for us. We could just drop off a chunk at a time. However, we've since discovered that part files can't be used with SBClient SmartQuery because it uses S/REFORMAT verb. As far as I know we haven't had any problems with UVNet on 64bit dynamic files on our (thirty) 2 bit Windows platforms. Stuart -Original Message- We have a few distributed files on UV 10.1.18 on Windows 2003 32 bit. 64-bit files would be better but I thought there were limitations in their use on a 32 bit OS, especially with DYNAMIC files? I seem to remember from the UV internals course that UV/Net can have problems accessing the file. Does this ring a bell with anyone? The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] using distributed files with multi level data files possible? {unclassified}
Troy, You _can_ use 64-bit files on 32-bit Windows 2003 Server, NTFS is quite happy with files over 2GB. I would describe multi-level files as an 'old' way of getting some of the same functionality as you get with UV Distributed files. You could have STOCK,HIST1 and STOCK,HIST2 ... if you wanted to keep more History. Or maybe STOCK,HIST06 STOCK,HIST07 STOCK,HIST08 for 2006, 2007 2008? If you want to use Distributed Files, I think you'll have to lose the multi-level concept. Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Tuesday, 14 October 2008 10:36 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] [UV] using distributed files with multi level data files possible? Running Universe 10.0.17 on Windows Server 2003 32bit: Can I create a distributed file for a data file that is part of shared dictionary (ie a multi-level data file)? I can't seem to get the syntax right. Here is the scenario. We have a large stock file with current transactions called STOCK that contains about 2 years of transactions and a growing history file with data copied from STOCK,STOCK to STOCK,HIST on a semi-annual basis. We've had to limit this STOCK,HIST file to about 2 years because of the 2GB limit. We are on Windows Server 2003 32bit and cannot create 64bit files, so I'd like to implement a distributed file for this STOCK,HIST and copy in about 4 to 6gb of older (offline) history data into it. Since the records are pure numeric and sequential I was going to create 10 part files and use the partitioning algorithm as INTERNAL @ID[LEN(@ID),1]+1. What would be my steps and syntax to do this? From my research, I have been successful at using DEFINE.DF, etc to do this at the primary datafile level like STOCK (aka STOCK,STOCK) but not when I reference a sub data file off of STOCK (like STOCK,HIST) it blows up. Sample below using similar names: Creating the files work fine: :CREATE-FILE TEST.STOCK 1,1 101,1 :CREATE-FILE TEST.STOCK.HIST.PART1 1,1 101,1 Then using the following to associate TEST.STOCK,HIST with the first part file fails: :DEFINE.DF DATA TEST.STOCK,HIST ADDING TEST.STOCK.HIST.PART1 1 INTERNAL @ID[LEN(@ID),1]+1 I get: DICT and PDICT are not legal keywords with multilevel DATA files. File not created. If I leave out 'DATA' above, no difference. All of the existing applications software and dictionaries reference STOCK (comma) HIST or I'd just rewrite this as a new data file like STOCK (DOT) HIST and be done. This may end up being the work-around if this just won't work. Either multi level data files are not supported or I'm not getting the syntax correct. Any help would be much appreciated! -Troy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] using distributed files with multi level data files possible?
I'd do something like this paragraph (not tested...) but it should create the parts and update them to all point to the same dictionary. 0001 PA 0002 CREATE.FILE DICT TEST.SHARED.DICT 3 0003 CREATE.FILE DATA TEST.P01 DYNAMIC 0004 CREATE.FILE DATA TEST.P02 DYNAMIC 0005 0006 DISPLAY UPDATING PART.FILES MAP DYNAMIC 0007 DEFINE.DF TEST _ 0008 TEST.P01 1 _ 0009 TEST.P02 2 _ 0010 INTERNAL IF @ID MATCH '0N' THEN 1 ELSE 2 0011 * update voc back to shared dict pointer 0012 UPDATE VOC SET F3 = 'D_TEST.SHARED.DICT' 0013 WHERE @ID IN ('TEST','TEST.P01','TEST.P02'); -Original Message- Can I create a distributed file for a data file that is part of shared dictionary (ie a multi-level data file)? ** 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 communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/