Re: [U2] Unidata RESIZE CONCURRENT
Try a different file, that A) you have just created and B) you know certainly is not being used. I don't think the bit is the issue here. I think that's just a message like can't GET the file -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Apr 22, 2013 6:49 pm Subject: [U2] Unidata RESIZE CONCURRENT I'm attempting some experiments with RESIZE CONCURRENT on Unidata 7.3.3 (RedHat) but failing miserably. I didn't think there was any configuration I needed to enable before using CONCURRENT, perhaps I'm misunderstanding the error message: :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT RESTORE H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. Resize Concurrent Continue/Restore failed because the RESIZE_CONCURRENT bit was not set on the file. I've read all the manuals and cannot find anything referencing the RESIZE_CONCURRENT bit. Any insight appreciated... -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ 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] Unidata RESIZE CONCURRENT
On 04/23/2013 12:04 PM, Wjhonson wrote: Try a different file, that A) you have just created and B) you know certainly is not being used. Same result. Created brand new file from scratch, copied 2000 records into it and attempted to resize: :CREATE.FILE JVB.RSZ 1029,1 :SELECT PERSON SAMPLE 2000 :COPY FROM PERSON TO JVB.RSZ :RESIZE JVB.RSZ 1237,1 CONCURRENT Resize Concurrent Continue/Restore failed because the RESIZE_CONCURRENT bit was not set on the file. Nobody could've been accessing this file other than me. To be clear - we're not running RFS or replication in our database. I don't think the bit is the issue here. I think that's just a message like can't GET the file OK, but I guess I'm confused. I thought that was the whole point of CONCURRENT - it could resize the file while others were accessing it. Are you claiming that RESIZE CONCURRENT must (initially) have exclusive access and then, while resizing, it's OK if others happen to access it? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata and Replication from AIX
Hello, I have a unidata database running on an IBM AIX... I want to do a live replication, but to a CentOS server. Is that possible? I am running version 7.2... does it require me to purchase another product? Or is this feature built in to unidata similarly to to something like mysql. Can I replicate to a the PE? Thanks, ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata RESIZE CONCURRENT
No I was thinking more along the lines of O/S level file permisisons. Which is why I had *you* create a new file, that way your permissions and its permissions would be known to match. -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Apr 23, 2013 10:27 am Subject: Re: [U2] Unidata RESIZE CONCURRENT On 04/23/2013 12:04 PM, Wjhonson wrote: Try a different file, that A) you have just created and B) you know certainly is not being used. Same result. Created brand new file from scratch, copied 2000 records into it and attempted to resize: :CREATE.FILE JVB.RSZ 1029,1 :SELECT PERSON SAMPLE 2000 :COPY FROM PERSON TO JVB.RSZ :RESIZE JVB.RSZ 1237,1 CONCURRENT Resize Concurrent Continue/Restore failed because the RESIZE_CONCURRENT bit was not set on the file. Nobody could've been accessing this file other than me. To be clear - we're not running RFS or replication in our database. I don't think the bit is the issue here. I think that's just a message like can't GET the file OK, but I guess I'm confused. I thought that was the whole point of CONCURRENT - it could resize the file while others were accessing it. Are you claiming that RESIZE CONCURRENT must (initially) have exclusive access and then, while resizing, it's OK if others happen to access it? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ 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] UD - Display Current Terminal Type
I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Display Current Terminal Type
!echo $TERM perhaps. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 5:12 PM To: U2 Mail List Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ 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.jpg] [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
Re: [U2] UD - Display Current Terminal Type
Ahh! 4 Dev (0)- !echo %TERM% wyse60 4 Dev (0)- BPTEST CRT SYSTEM(7) ; END Compiling Unibasic: SAVEDLISTS\BpTest_516680981 in mode 'p'. compilation finished ACTWY60 I ran the command TERM ACTWY60 when I logged in. I wonder why the difference? Thanks, Bill - Original Message - *From:* dda...@harriscomputer.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/23/2013 2:19 PM *Subject:* Re: [U2] UD - Display Current Terminal Type !echo $TERM perhaps. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 5:12 PM To: U2 Mail List Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ 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.jpg] [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
Re: [U2] UD - Display Current Terminal Type
TERM with no arguments will *display* your current settings, at the bottom of the display it will say 'wyse50' -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Mail List U2-users@listserver.u2ug.org Sent: Tue, Apr 23, 2013 2:11 pm Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ 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] UD - Display Current Terminal Type
In Unidata 6.1, TERM with no arguments gives me a brief syntax help message. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 23, 2013 2:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD - Display Current Terminal Type TERM with no arguments will *display* your current settings, at the bottom of the display it will say 'wyse50' -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Mail List U2-users@listserver.u2ug.org Sent: Tue, Apr 23, 2013 2:11 pm Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ 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] Unidata RESIZE CONCURRENT
On 04/22/2013 09:49 PM, Jeffrey Butera wrote: I'm attempting some experiments with RESIZE CONCURRENT on Unidata 7.3.3 (RedHat) but failing miserably. I didn't think there was any configuration I needed to enable before using CONCURRENT, perhaps I'm misunderstanding the error message: :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT RESTORE H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. Resize Concurrent Continue/Restore failed because the RESIZE_CONCURRENT bit was not set on the file. I determined that the problem is RESTORE. If we eliminate that keyword, RESIZE CONCURRENT works. :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. The temporary file for RESIZE is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP.resize. H08.FACULTY.WL.SNAP RESIZED from 3359 to 3593 I'm not yet sure of implications of not using RESTORE or CONTINUE, but I'm ok for now. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Display Current Terminal Type
Well, that doesn't work, which I tried originally as this is what other mvDbms products use (at least what I'm used to). UniData doesn't respond with the terminal type. 4 Dev (0)- TERM TERM parameters are all numeric: TERM A,B,C,D For the terminal A=number of characters in a line(132). B=number of lines per page(42). For the line printer C=number of characters in a line(146). D=number of lines per page(61). 4 Dev (0)- Bill Untitled Page - Original Message - *From:* bob_woodw...@k2sports.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/23/2013 2:48 PM *Subject:* Re: [U2] UD - Display Current Terminal Type In Unidata 6.1, TERM with no arguments gives me a brief syntax help message. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 23, 2013 2:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD - Display Current Terminal Type TERM with no arguments will *display* your current settings, at the bottom of the display it will say 'wyse50' -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Mail List U2-users@listserver.u2ug.org Sent: Tue, Apr 23, 2013 2:11 pm Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata RESIZE CONCURRENT
Jeff: Since the documentation says: RESTORE - If the system crashes or RESIZE CONCURRENT encounters an error, delete the temporary copy of the resized file and restore the original file before any resize operation took place. I'd guess the RESTORE keyword is putting something somewhere where you don't have permissions. Further documentation says: - - - - - - - - - - Recovering from a Concurrent Resize Error If the concurrent resizing process encounters an error, or the system crashes during the resize operation, complete the following steps to restore the file:- Resizes the file according to its actual size, thus correcting overflows. 1. Check and repair the physical integrity of the file, if necessary. For nonrecoverable files, use the guide utility to check if the file needs to be repaired. If so, use the fixfile command to repair the file. If the file is a recoverable file, restarting UniData after the system crash should automatically fix both the original file and the temporary copy of the file as it was being resized. 2. Execute the RESIZE CONCURRENT CONTINUE command against the file if you want the resize operation to continue to completion. Execute the RESIZE CONCURRENT RESTORE command against the file if you want to delete the temporary copy of the file and restore the original file before any resize operation took place. If you do not execute either of these options, the RESIZE CONCURRENT operation will fail and display an error message describing the reason for the failure. At this release, the guide utility has been enhanced to display a message indicating that the file is currently being resized. The message includes the number of groups that have been resized: - - - - - - - - - - I wonder what, and where, that is? Bill Untitled Page - Original Message - *From:* jbut...@hampshire.edu *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/23/2013 3:35 PM *Subject:* Re: [U2] Unidata RESIZE CONCURRENT On 04/22/2013 09:49 PM, Jeffrey Butera wrote: I'm attempting some experiments with RESIZE CONCURRENT on Unidata 7.3.3 (RedHat) but failing miserably. I didn't think there was any configuration I needed to enable before using CONCURRENT, perhaps I'm misunderstanding the error message: :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT RESTORE H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. Resize Concurrent Continue/Restore failed because the RESIZE_CONCURRENT bit was not set on the file. I determined that the problem is RESTORE. If we eliminate that keyword, RESIZE CONCURRENT works. :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. The temporary file for RESIZE is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP.resize. H08.FACULTY.WL.SNAP RESIZED from 3359 to 3593 I'm not yet sure of implications of not using RESTORE or CONTINUE, but I'm ok for now. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Display Current Terminal Type
On 23/04/13 22:12, Bill Haskett wrote: I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Dunno whether it works for UD, but the UV command is GET.TERM.TYPE. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Display Current Terminal Type
Thanks, but that's not it for UniData. Bill Untitled Page - Original Message - *From:* antli...@youngman.org.uk *To:* u2-users@listserver.u2ug.org *Date:* 4/23/2013 3:48 PM *Subject:* Re: [U2] UD - Display Current Terminal Type On 23/04/13 22:12, Bill Haskett wrote: I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Dunno whether it works for UD, but the UV command is GET.TERM.TYPE. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Display Current Terminal Type
GET.TERM.TYPE will display the terminal type, width and depth. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 5:12 PM To: U2 Mail List Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ 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] UD - Display Current Terminal Type
:GET.TERM.TYPE Not a verb GET.TERM.TYPE :version Module Name Version Licensed UniData RDBMS 7.3 Yes Connection Pooling... 7.3 Yes Device License... 7.3 Yes NFA.. 7.3 No RFS.. 7.3 No EDA.. 7.3 No 733 Bill Untitled Page - Original Message - *From:* tewhitm...@ratex.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/23/2013 5:11 PM *Subject:* Re: [U2] UD - Display Current Terminal Type GET.TERM.TYPE will display the terminal type, width and depth. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 5:12 PM To: U2 Mail List Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
