Re: [U2] Regarding: use of I - Descriptor

2012-06-28 Thread John Bullard
You can even put alternate indexes on I-Desc, though this can lead to serious problems if you are indexing a translate. I read this comment (from an earlier thread on this list) and started worrying: I have a requirement to select records based on a field that is not currently in the record. I

Re: [U2] Regarding: use of I - Descriptor

2012-06-28 Thread Israel, John R.
Keep in mind that the index gets updated when the PRIMARY file gets written to disk. If the value of the translate changes (because the secondary file gets updated), the index will still be loaded with the old value. This is not a bug. That is just the way it works. For example, let's say

Re: [U2] Regarding: use of I - Descriptor

2012-06-28 Thread Brenda Ives
The danger in using an index on a translated field is if that data changes in the translated record, the index won't be updated. I have used indices on translated fields before with no problems. However, they were fields that would never change, such as a person's SSN, the amount of a payment

[U2] Really trying to understand dynamic file sizing

2012-06-28 Thread Dave Laansma
I've only got a handful of dynamic files but of course they're huge and have a big impact on our daily and monthly processing. I'd REALLY like to understand the tuning mechanisms for these files, specifically SPLIT/MERGE. The formulas that I got on previous responses just don't seem to make

Re: [U2] Regarding: use of I - Descriptor

2012-06-28 Thread David A. Green
An alternative method is to create an index on the secondary file then create an I-Desc SUBR to access that index from the primary file. Be sure to setup some COMMON variables to only OPEN the secondary file once. David A. Green (480) 813-1725 DAG Consulting -Original Message- From:

Re: [U2] Really trying to understand dynamic file sizing

2012-06-28 Thread Baakkonen, Rodney A (Rod) 46K
Sorry I don't have time to really dive into this. A lot of the documentation are things that work most of the time. But sizing dynamic files is more art than science some times. But just looking at your stats, KEYDATA might be an option as well. You have a pretty high ratio of bytes per

[U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
Having a problem running a Unix script from the crontab. We use Redhat and Unidata 7.1 This script runs fine from command line UDTHOME=/NTN/CMI export UDTHOME UDTBIN=/usr/ud/bin export UDTBIN CMIHOME=/NTN/CMI/TRANS4M export CMIHOME PATH=$PATH:@UDTBIN export PATH cd /NTN/DATA/PRODUCTION

Re: [U2] Regarding: use of I - Descriptor

2012-06-28 Thread Wjhonson
Could you expand on this? -Original Message- From: David A. Green dgr...@dagconsulting.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Jun 28, 2012 8:26 am Subject: Re: [U2] Regarding: use of I - Descriptor An alternative method is to create an index on the secondary

Re: [U2] Problem running script from crontab

2012-06-28 Thread Jeff Schasny
Are you running it at the command line as the same user that it runs under in cron? charles_shaf...@ntn-bower.com wrote: Having a problem running a Unix script from the crontab. We use Redhat and Unidata 7.1 This script runs fine from command line UDTHOME=/NTN/CMI export UDTHOME

Re: [U2] Problem running script from crontab

2012-06-28 Thread Tony Gravagno
Every time I see something like this it's a permissions issue. From: Charles_Shaffer This script runs fine from command line... But when it is run by the cron it doesn't seem to run ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] Problem running script from crontab

2012-06-28 Thread George Gallen
Make sure any commands referenced in your script, use the full pathname. I've had problems sometimes Where the process doesn't have the same path names as when I tested it. Ex. Instead of cp , use /bin/cp Sudo has this issue as well George -Original Message- From:

Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
Jeff Are you running it at the command line as the same user that it runs under in cron? Yes I am. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 06/28/2012 11:54 AM Subject:Re:

Re: [U2] Problem running script from crontab

2012-06-28 Thread Israel, John R.
Each user CAN have their own crontab. Login as this user and manually step through each command in your script and see where it falls apart. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent:

Re: [U2] Problem running script from crontab

2012-06-28 Thread Larry Hiscock
Do you have LOGIN paragraph in your VOC file? If you do, make sure you test @USER.TYPE and bypass anything that might require a prompt. We run a dozen different cron jobs multiple times per day on SCO UD 6. Larry Hiscock Western Computer Services -Original Message- From:

Re: [U2] Regarding: use of I - Descriptor

2012-06-28 Thread David A. Green
Sure, Let's say you have a file B that has a customer number in the data and not the key. And you want to build a link from file A that also has a customer number in the data. You would build an index on file B for customer number. Then create a generic subroutine that takes in a filename and

Re: [U2] Problem running script from crontab

2012-06-28 Thread Colin Alfke
The phantom command will run your login paragraph. Is it setup to allow this process to go through? There should be something in the _PH_ file/folder for when the cron fired off. hth Colin -Original Message- From: Charles_Shaffer Sent: June 28, 2012 10:19 AM To:

Re: [U2] Problem running script from crontab

2012-06-28 Thread Bill Haskett
SCO!? Bill - Original Message - *From:* lar...@wcs-corp.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 6/28/2012 10:27 AM *Subject:* Re: [U2] Problem running script from crontab Do you have LOGIN

Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
lARRY Do you have LOGIN paragraph in your VOC file? Yes and it looks like this. :AE VOC LOGIN Top of LOGIN in VOC, 13 lines, 195 characters. *--: P 001: PA 002: UDT.OPTIONS 82 ON 003: UDT.OPTIONS 43 ON 004: UDT.OPTIONS 43 OFF 005: UDT.OPTIONS 19 ON 006: UDT.OPTIONS 22 ON 007: SP-ASSIGN Q1 HS

Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
John Each user CAN have their own crontab. Login as this user and manually step through each command in your script and see where it falls apart. JRI I am using our master user cmi. When I log in as cmi and type in the command that is in the crontab entry, from cmi's home directory, it runs

Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
The phantom command will run your login paragraph. Is it setup to allow this process to go through? There should be something in the _PH_ file/folder for when the cron fired off. hth Colin This is interesting. There are files being created in the _PH_ directory for each run (they are 10

Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
Bill, RedHat Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
I rewrote the script to use our in-house methods and now it is working. #!/bin/ksh echo `date` FILES_LOG/ReqImp.LOG . /usr/local/set_udt_environ.scr cd /NTN/DATA/PRODUCTION $UDTBIN/udtEODFILES_LOG/ReqImp.LOG PHANTOM REQIMPORT_MA bye EOD Still not sure why it was failing before, but I am

Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
If this was UniVerse, I would check the VOC LOGIN paragraph and make sure it's not invoking a menu (or something) requiring an Input Mark It is interesting that you said that. The program that the script is calling does exactly that. It is calling menu programs from an ERP package and it

Re: [U2] Problem running script from crontab

2012-06-28 Thread Larry Hiscock
LOL ... what can I say. It's an older system that hasn't been updated in a while. We have a RedHat upgrade planned somewhere out on the horizon, but in this economy? Ptt... Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Problem running script from crontab

2012-06-28 Thread Mark Eastwood
If this was UniVerse, I would check the VOC LOGIN paragraph and make sure it's not invoking a menu (or something) requiring an Input Mark Having a problem running a Unix script from the crontab. We use Redhat and Unidata 7.1 This script runs fine from command line UDTHOME=/NTN/CMI

Re: [U2] Problem running script from crontab

2012-06-28 Thread George Gallen
Which version of RH? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Thursday, June 28, 2012 3:33 PM To: 'U2 Users List' Subject: Re: [U2] Problem running script from crontab LOL ... what can I

Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
George. RedHat 6. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Problem running script from crontab

2012-06-28 Thread George Gallen
Sorry, I was asking Larry. Not sure if UD scales as well as UV, however, the UV we originally loaded on RH 7.2, installed just fine When we upgraded to RH 9.0, and also has been running just dandy when we upgraded to RHEL 5. So, it's just hardware costs now.and time to make sure it all

Re: [U2] Regarding: use of I - Descriptor

2012-06-28 Thread Wols Lists
On 28/06/12 18:30, David A. Green wrote: Sure, Let's say you have a file B that has a customer number in the data and not the key. And you want to build a link from file A that also has a customer number in the data. You would build an index on file B for customer number. Then

Re: [U2] Problem running script from crontab

2012-06-28 Thread Wols Lists
On 28/06/12 19:03, charles_shaf...@ntn-bower.com wrote: This is interesting. There are files being created in the _PH_ directory for each run (they are 10 minutes) apart. But they are empty. This means that something failed right off the bat right? Looks like it. Run the PHANTOM command

Re: [U2] Really trying to understand dynamic file sizing

2012-06-28 Thread Doug Averch
Here is the math from how I read the manual on KEYONLY Split/Merge. 4096 (Group Size from Guide) -32 (Unidata Overhead from documentation) 4064 (Usable Space) 6(Keys per group from Guide) 13 (Key size from Guide) = 78 (Key size on average) 6(Keys per Group from Guide) 8

Re: [U2] Really trying to understand dynamic file sizing

2012-06-28 Thread Doug Averch
On Thu, Jun 28, 2012 at 6:50 PM, Doug Averch dave...@gmail.com wrote: 126/4064 (Correction, too late to be working on this) 1 (Correction average Load before split) And that matches your numbers Regards, Doug www.u2logic.com