RE: [U2] [UV] Trigger(s) on distributed file
Off the top of my head - AND CHECK TO MAKE SURE... You can't create triggers (or indexes, or anything like that) on the master, because it only exists as a record in PARTFILES). But - and I'm pretty sure this is true of indices at least - if you try and create an index on the master, it will loop through the list of partfiles and create an index on each individual partfile. The same is likely to be true of triggers. Where this WILL bite you, is when you create a new partfile. By default, it won't have any indices, or triggers, or whatever. You'll need to add them to that partfile. So - the situation with indices (and probably triggers etc) is that creating them on the master is a legit thing to do. But under the covers it is actually doing it to each individual partfile. So when you add a new partfile, they won't get automatically added to the new partfile. Cheers, Wol -Original Message- From: Boydell, Stuart [mailto:[EMAIL PROTECTED] Sent: 21 June 2007 04:29 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Trigger(s) on distributed file Just to check as I couldn't find doco on it - Do I create triggers on each part of a DF? Or is there a way to have the trigger on the master? Cheers, 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 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] _PH_ ID
Is there a way for a phantom to know the _PH_ item that it's output is being redirected to? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out our FREE support forum at http://www.precisonline.com/forum/ http://www.PrecisOnline.com/forum/. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Trigger(s) on distributed file
I didnt attempt to create on the 'master' in universe 10. I wrote an application to find every pathname, created my own VOC from that location, and created the trigger on that name. My approach would also not have a trigger in place for an addition to the df. To the good, the application creates CREATEs and DROPs for each PATH denoted in a VOC item named INSTALL.FILE.NAME.FUNCTION, and DEINSTALL.file name.FUNCTION. I then combined them all, into a single CREATE and DROP paragraph accessible only to two users. john On 6/21/07, Anthony Youngman [EMAIL PROTECTED] wrote: Off the top of my head - AND CHECK TO MAKE SURE... You can't create triggers (or indexes, or anything like that) on the master, because it only exists as a record in PARTFILES). But - and I'm pretty sure this is true of indices at least - if you try and create an index on the master, it will loop through the list of partfiles and create an index on each individual partfile. The same is likely to be true of triggers. Where this WILL bite you, is when you create a new partfile. By default, it won't have any indices, or triggers, or whatever. You'll need to add them to that partfile. So - the situation with indices (and probably triggers etc) is that creating them on the master is a legit thing to do. But under the covers it is actually doing it to each individual partfile. So when you add a new partfile, they won't get automatically added to the new partfile. Cheers, Wol -Original Message- From: Boydell, Stuart [mailto:[EMAIL PROTECTED] Sent: 21 June 2007 04:29 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Trigger(s) on distributed file Just to check as I couldn't find doco on it - Do I create triggers on each part of a DF? Or is there a way to have the trigger on the master? Cheers, 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 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] _PH_ ID
The phantom's unix process id is a part of the _PH_ id. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Thursday, June 21, 2007 9:18 AM To: U2 List Subject: [U2] _PH_ ID Is there a way for a phantom to know the _PH_ item that it's output is being redirected to? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out our FREE support forum at http://www.precisonline.com/forum/ http://www.PrecisOnline.com/forum/. --- 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] _PH_ ID
Universe 10.x PHANTOM SQUAWK RUN JMRBP HI RUN_36022_14417 record has been created in the 'PH' file. Phantom process started with process ID 7408. On 6/21/07, Kevin King [EMAIL PROTECTED] wrote: Is there a way for a phantom to know the _PH_ item that it's output is being redirected to? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out our FREE support forum at http://www.precisonline.com/forum/ http://www.PrecisOnline.com/forum/. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] _PH_ ID
Not on my system, hpux 11 / uv10.1.8 -- Original message -- From: Cordes, Tom (contractor) [EMAIL PROTECTED] The phantom's unix process id is a part of the _PH_ id. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Thursday, June 21, 2007 9:18 AM To: U2 List Subject: [U2] _PH_ ID Is there a way for a phantom to know the _PH_ item that it's output is being redirected to? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out our FREE support forum at http://www.PrecisOnline.com/forum/. --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Can't get current working directory. ?
Hi all, Earlier this week I set out to replace a test account with a fresh copy of the live account (Unidata 6.1 on AIX 5.1). The Live account had grown more then I had anticipated and I found myself with a max'ed out /test file system. While preparing to restore from tape, we found we had a bad disc. We had another disc from a decommissioned box, created a new /test file system, and restored from tape there. The problem is I can not get to the colon prompt unless I'm logged in as root. I tried stripping the LOGIN paragraph down to just a couple of UDT.OPTIONS commands along with a DISPLAY statement so I can tell if the LOGIN paragraph was even run. 464 datateludt /test/coltest Can't get current working directory. It did not run the LOGIN paragraph??? We're not sure what else to look at. The system was rebooted this morning. The startud logs look fine. Looks like all permissions were preserved. Any suggestions? *---* Jon Wells Database Administrator Beloit College Information Technology Services Beloit, Wisconsin 608-363-2290[EMAIL PROTECTED] 608-363-2100(fax) *---* AIX 5.1.3 IBM RS6000 F50 UniData 5.1.35 *---* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] _PH_ ID
Is there a way for a phantom to know the _PH_ item that it's output is being redirected to? On UniData it's SYSTEM(48). Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Can't get current working directory. ?
Just a thought, but are the permissions of the directory rwxr-xr-x or something similar? If a directory doesn't have execute permissions, you can't CD to it. That's also true if the parent directories don't have execute permissions set. Karl quote who=Jon Wells Hi all, Earlier this week I set out to replace a test account with a fresh copy of the live account (Unidata 6.1 on AIX 5.1). The Live account had grown more then I had anticipated and I found myself with a max'ed out /test file system. While preparing to restore from tape, we found we had a bad disc. We had another disc from a decommissioned box, created a new /test file system, and restored from tape there. The problem is I can not get to the colon prompt unless I'm logged in as root. I tried stripping the LOGIN paragraph down to just a couple of UDT.OPTIONS commands along with a DISPLAY statement so I can tell if the LOGIN paragraph was even run. 464 datateludt /test/coltest Can't get current working directory. It did not run the LOGIN paragraph??? We're not sure what else to look at. The system was rebooted this morning. The startud logs look fine. Looks like all permissions were preserved. Any suggestions? *---* Jon Wells Database Administrator Beloit College Information Technology Services Beloit, Wisconsin 608-363-2290[EMAIL PROTECTED] 608-363-2100(fax) *---* AIX 5.1.3 IBM RS6000 F50 UniData 5.1.35 *---* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Can't get current working directory. ?
quote who='Jon Wells' date='Thursday 21 June 2007' Hi all, Earlier this week I set out to replace a test account with a fresh copy of the live account (Unidata 6.1 on AIX 5.1). The Live account had grown more then I had anticipated and I found myself with a max'ed out /test file system. While preparing to restore from tape, we found we had a bad disc. We had another disc from a decommissioned box, created a new /test file system, and restored from tape there. The problem is I can not get to the colon prompt unless I'm logged in as root. I tried stripping the LOGIN paragraph down to just a couple of UDT.OPTIONS commands along with a DISPLAY statement so I can tell if the LOGIN paragraph was even run. 464 datateludt /test/coltest Can't get current working directory. It did not run the LOGIN paragraph??? We're not sure what else to look at. The system was rebooted this morning. The startud logs look fine. Looks like all permissions were preserved. Any suggestions? When you readded the new disk and (presumably) recreated the /test filesystem on the new disk set, who owns it? We run everything under /datatel and ran out of space, so added a /datatel2 partition for a new account. I too did not realize when I created /datatel2 it was owned by root. You need to check ownerships on /test with the filesystem for /test NOT mounted. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 We don't have a lot of rules, but that's Hampshire... Bobbie Stuart --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] _PH_ ID
If your platform is unix, you could do something like this: COMMAND=/usr/sbin/fuser phpath/RUN* COMMAND='SH -C ':COMMAND:'' CRT COMMAND EXECUTE COMMAND CAPTURING RESULTS MORE=(RESULTS#'') LOOP WHILE MORE DO REMOVE LINE FROM RESULTS SETTING MORE FNAME=FIELDS(LINE,':',1) PIDS=OCONVS(EREPLACE(FIELDS(LINE,':',2),' ',@AM),'MCN') LOCATE(MYPID,PIDS;PTRX) ELSE PTRX=0 IF PTRX THEN PRINT FNAME MORE=0 END REPEAT I'd imagine this would be slow if the PH directory is large. If it were me, I'd probably capture the name from SQUAWK and feed it into the program. Just my 2 pennies. -- Original message -- From: Kevin King [EMAIL PROTECTED] Is there a way for a phantom to know the _PH_ item that it's output is being redirected to? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out our FREE support forum at http://www.PrecisOnline.com/forum/. --- 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] _PH_ ID
If the HI program has been cataloged, though, you can do PHANTOM HI And the first _ field of the id would then be HI instead of RUN. You can then use the program name to find the ID in the PH file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john reid Sent: Thursday, June 21, 2007 9:01 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] _PH_ ID Universe 10.x PHANTOM SQUAWK RUN JMRBP HI RUN_36022_14417 record has been created in the 'PH' file. Phantom process started with process ID 7408. On 6/21/07, Kevin King [EMAIL PROTECTED] wrote: Is there a way for a phantom to know the _PH_ item that it's output is being redirected to? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out our FREE support forum at http://www.precisonline.com/forum/ http://www.PrecisOnline.com/forum/. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Can't get current working directory. ?
Jon, The fact that you can get things to work as root, but not as other users, sounds like a permissions problem somewhere out in unix. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon Wells Sent: Thursday, June 21, 2007 9:10 AM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: [U2] Can't get current working directory. ? Hi all, Earlier this week I set out to replace a test account with a fresh copy of the live account (Unidata 6.1 on AIX 5.1). The Live account had grown more then I had anticipated and I found myself with a max'ed out /test file system. While preparing to restore from tape, we found we had a bad disc. We had another disc from a decommissioned box, created a new /test file system, and restored from tape there. The problem is I can not get to the colon prompt unless I'm logged in as root. I tried stripping the LOGIN paragraph down to just a couple of UDT.OPTIONS commands along with a DISPLAY statement so I can tell if the LOGIN paragraph was even run. 464 datateludt /test/coltest Can't get current working directory. It did not run the LOGIN paragraph??? We're not sure what else to look at. The system was rebooted this morning. The startud logs look fine. Looks like all permissions were preserved. Any suggestions? *---* Jon Wells Database Administrator Beloit College Information Technology Services Beloit, Wisconsin 608-363-2290[EMAIL PROTECTED] 608-363-2100(fax) *---* AIX 5.1.3 IBM RS6000 F50 UniData 5.1.35 *---* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] _PH_ ID
My apologies for not specifying Unidata, but yes, thank you Tim the answer is SYSTEM(48)! We have a winner, no more callers please. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out our FREE support forum at http://www.PrecisOnline.com/forum/. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Can't get current working directory. ?
I have seen this before. Usually one of 2 things. 1) Someone rm'ed the directory while you were still in it 2) You don't have correct permissions to the account directory I am guessing the latter since root appears to be fine. If you sure permissions are wide open on the directory, files and all subdirectories, you can check the VOC for corruption. -Doug At 09:10 AM 6/21/2007, Jon Wells wrote: 464 datateludt /test/coltest Can't get current working directory. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] _PH_ ID
UV doesn't have the name on SYSTEM(48). The phantom ID on our system is a combination of the program name, the time, and the date. You could build the ID in the program using SYSTEM(12) and DATE(). PH.ID = 'programname_':FIELD(SYSTEM(12),'.',1):'_':DATE() Or PH.ID = 'programname_'@TIME:'_':@DATE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 21, 2007 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] _PH_ ID If the HI program has been cataloged, though, you can do PHANTOM HI And the first _ field of the id would then be HI instead of RUN. You can then use the program name to find the ID in the PH file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john reid Sent: Thursday, June 21, 2007 9:01 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] _PH_ ID Universe 10.x PHANTOM SQUAWK RUN JMRBP HI RUN_36022_14417 record has been created in the 'PH' file. Phantom process started with process ID 7408. On 6/21/07, Kevin King [EMAIL PROTECTED] wrote: Is there a way for a phantom to know the _PH_ item that it's output is being redirected to? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out our FREE support forum at http://www.precisonline.com/forum/ http://www.PrecisOnline.com/forum/. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- 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] _PH_ ID
Hi Kevin. You could catch the output of PHANTOM SQUAWK XXPROCXX, and play with it... Regards Augusto Alonso - Original Message - From: Kevin King [EMAIL PROTECTED] To: U2 List u2-users@listserver.u2ug.org Sent: Thursday, June 21, 2007 3:17 PM Subject: [U2] _PH_ ID Is there a way for a phantom to know the _PH_ item that it's output is being redirected to? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out our FREE support forum at http://www.precisonline.com/forum/ http://www.PrecisOnline.com/forum/. --- 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] _PH_ ID
UV ...You could build the ID in the program using SYSTEM(12) and DATE(). PH.ID = 'programname_':FIELD(SYSTEM(12),'.',1):'_':DATE() Or PH.ID = 'programname_'@TIME:'_':@DATE Yeahbut, fire off 100 jobs of the same name WITHIN THE SAME SECOND and look at the games UV plays with the PH id! (Off-topic comment that will get me kicked to u2-community: So, along with the recent request for a program to trace who called it, we're asking for programs to be self-aware: Who am I?, Where did I come from?. Questions usually reserved for teenagers the pious, with the associated sentience meta-pondered by bio-ethicists. That's an artificially intelligent comment in at least two ways. Ok, Mr. Moderator, sir, I'll go quietly...) cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Can't get current working directory. ?
Hi Jeff, Here's what our file system looks like -- # / df -k Filesystem1024-blocks Free %UsedIused %Iused Mounted on /dev/hd4 122880 69976 44% 4040 7% / /dev/hd2 3997696 1074744 74%54030 6% /usr /dev/hd9var188416135664 28% 1052 3% /var /dev/hd3 2007040 19433924% 100 1% /tmp /dev/lv01 4931584 1143964 77%82665 7% /release /dev/lv04 9535488 2508596 74%24153 2% /live /dev/lv00 147456 39624 74% 402811% /home/staff /dev/lv0314024704 3821248 73% 119975 4% /reltest /proc - -- - - /proc /dev/lv0210027008 3770780 63%17208 1% /test From a ls -l -- drwxr-sr-x 4 sys sys 512 Dec 13 2004 live/ I believe test was @ 770 when we started looking at permissions :-/ . My SA was wondering about un-mounting /test. We tried to do that and smit will not allow it saying it is busy. We're not sure what it is that is tying '/test' up. We've been trying to find any pertinent notes from when we first created '/test' and have been coming up short. We will catch it in the morning (Friday) when we can have a quite system. Any more thoughts? Thanks, Jon At 10:34 AM 6/21/2007, Jeffrey Butera wrote: When you readded the new disk and (presumably) recreated the /test filesystem on the new disk set, who owns it? We run everything under /datatel and ran out of space, so added a /datatel2 partition for a new account. I too did not realize when I created /datatel2 it was owned by root. You need to check ownerships on /test with the filesystem for /test NOT mounted. -- Jeff Butera, Ph.D. *---* Jon Wells Database Administrator Beloit College Information Services ResourcesBeloit, Wisconsin 608-363-2290[EMAIL PROTECTED] 608-363-2100(fax) *---* Colleague 17 Benefactor 5.1 AIX 5.1.3IBM RS6000 F50UniData 6.1.11 *---* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Trigger(s) on distributed file
Just a point of technical correction. The master does exist as a physical file, type 27. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On 6/21/07 Anthony Youngman wrote: You can't create triggers (or indexes, or anything like that) on the master, because it only exists as a record in PARTFILES). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] snapshots, dynasets, cursors and unicode
We are running UV 10.0 with NLS. Using the IBM ODBC driver, we are getting an error stating that the odbc driver does not support dynasets. Is there another driver that we could use that would support dynasets? Or is it possible that NLS is not configured properly thus keeping the driver to respond to the dynaset request? Thanks for any information. Linda Law University of Georgia --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Can't get current working directory. ?
Just checked our records. After the restore and before we started mussing with permissions, a ls -l screen shot showed /test was @ 755, sys, sys which is what we see for the currently working just fine /live directory. Is there a difference between '/test' the directory and '/test' the mount point? I believe test was @ 770 when we started looking at permissions :-/ . *---* Jon Wells Database Administrator Beloit College Information Services ResourcesBeloit, Wisconsin 608-363-2290[EMAIL PROTECTED] 608-363-2100(fax) *---* Colleague 17 Benefactor 5.1 AIX 5.1.3IBM RS6000 F50UniData 6.1.11 *---* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Can't get current working directory. ?
Ah Ha!!! We were able to perform a umount /test, change permissions, and mount /test. It is now working :-) Thank you all for your help! *---* Jon Wells Database Administrator Beloit College Information Services ResourcesBeloit, Wisconsin 608-363-2290[EMAIL PROTECTED] 608-363-2100(fax) *---* Colleague 17 Benefactor 5.1 AIX 5.1.3IBM RS6000 F50UniData 6.1.11 *---* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe PE - Web Services
While we are waiting for an official version of UniVerse 10.2.4 we have been trying to get Web Services working in the downloadable PE version. We have created a Web Service but when we try to run it we are advised in the log that the license has expired. Is this not able to be used in the PE version or is there some way of extending the license? Any assistance would be appreciated. Regards, Sara Burns Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] A family trust can help you protect your assets if the unexpected happens. To find out how a family trust works and if one's right for you, call 0800 505 405. The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Trigger(s) on distributed file
Many thanks to the responants, I am just investigationg what is involved in converting a file to DF. So far: - Triggers are required on each part. You cannot create a trigger on the master and there is no similar functionality to the 'CREATE.INDEX' command on DFs. - BSCAN doesn't work - but SELECTINDEX does. - And a gotcha, if you artificially populate the parts contra to the DF algorithm (and possibly if you change it) You need to rebuild the indices. Cheers, 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 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] Universe PE - Web Services
Sara: I believe Web Services only works with a Connection Pool license. I had to purchase one for UD to test our the services. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Thursday, June 21, 2007 8:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe PE - Web Services While we are waiting for an official version of UniVerse 10.2.4 we have been trying to get Web Services working in the downloadable PE version. We have created a Web Service but when we try to run it we are advised in the log that the license has expired. Is this not able to be used in the PE version or is there some way of extending the license? Any assistance would be appreciated. Regards, Sara Burns Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Trigger(s) on distributed file
Stuart, Bscan will not work against the main file, but works on the individual files. Bernard Lubin Development Department Reynolds and Reynolds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Friday, 22 June 2007 2:06 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Trigger(s) on distributed file Many thanks to the responants, I am just investigationg what is involved in converting a file to DF. So far: - Triggers are required on each part. You cannot create a trigger on the master and there is no similar functionality to the 'CREATE.INDEX' command on DFs. - BSCAN doesn't work - but SELECTINDEX does. - And a gotcha, if you artificially populate the parts contra to the DF algorithm (and possibly if you change it) You need to rebuild the indices. Cheers, 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 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/