Re: [U2] Regarding: use of I - Descriptor
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 have been planning on creating an I-Desc that uses a TRANS() function to look up the data and then building an index on that field. What sort of serious problems would I expect from indexing a TRANS() I-descriptor? John B. This message and all attachments are intended for the use of the individual or entity to whom or which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure. If the reader of this message is not the intended recipient or the agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify me immediately at the number listed above. U.S. export law as contained in the International Traffic In Arms Regulations (ITAR) and the Export Administration Regulations (EAR) may be applicable to any technical information submitted with this communication. This technical information is not to be placed in the public domain, exported from the U.S., or given to any foreign person in the U.S., without the prior, specific written authorization of TeligentEMS LLC and the U.S. Department of State or the U.S. Department of Commerce as applicable. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding: use of I - Descriptor
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 you had a SALES.ORDER file (primary) that stores the CUSTOMER.ID as one of its field. In the CUSTOMER file (secondary), you have a field called CREDIT.STATUS. Next, you have a translate from the SALES.ORDER file going to the CUSTOMER file to return the CREDIT.STATUS of the customer associated with the orders. No problem so far. Next, you add an alternate index to this translate. At that moment, everything is fine. However, if the CREDIT.STATUS for a customer changes, the alternate index (translate) in the SALES.ORDER file will not know there is a change! Any alternate indexes on the CUSTOMER file will be updated because the CUSTOMER file was written to disk. Since the SALES.ORDER file was not written to disk, its alternate indexes remain unchanged. Thus if you select all the SALES.ORDERs with the customer's CREDIT.STATUS = 1, you will get the orders whose CREDIT.STATUS WAS 1, but may not be any more. If you are confident that the value of the translate will not change, then you should be OK. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Bullard Sent: Thursday, June 28, 2012 7:31 AM To: U2 Users List Subject: Re: [U2] Regarding: use of I - Descriptor 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 have been planning on creating an I-Desc that uses a TRANS() function to look up the data and then building an index on that field. What sort of serious problems would I expect from indexing a TRANS() I-descriptor? John B. This message and all attachments are intended for the use of the individual or entity to whom or which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure. If the reader of this message is not the intended recipient or the agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify me immediately at the number listed above. U.S. export law as contained in the International Traffic In Arms Regulations (ITAR) and the Export Administration Regulations (EAR) may be applicable to any technical information submitted with this communication. This technical information is not to be placed in the public domain, exported from the U.S., or given to any foreign person in the U.S., without the prior, specific written authorization of TeligentEMS LLC and the U.S. Department of State or the U.S. Department of Commerce as applicable. ___ 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] Regarding: use of I - Descriptor
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 on a closed transaction. Brenda -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Bullard Sent: Thursday, June 28, 2012 7:31 AM To: U2 Users List Subject: Re: [U2] Regarding: use of I - Descriptor 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 have been planning on creating an I-Desc that uses a TRANS() function to look up the data and then building an index on that field. What sort of serious problems would I expect from indexing a TRANS() I-descriptor? John B. This message and all attachments are intended for the use of the individual or entity to whom or which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure. If the reader of this message is not the intended recipient or the agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify me immediately at the number listed above. U.S. export law as contained in the International Traffic In Arms Regulations (ITAR) and the Export Administration Regulations (EAR) may be applicable to any technical information submitted with this communication. This technical information is not to be placed in the public domain, exported from the U.S., or given to any foreign person in the U.S., without the prior, specific written authorization of TeligentEMS LLC and the U.S. Department of State or the U.S. Department of Commerce as applicable. ___ 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] Really trying to understand dynamic file sizing
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 sense on one particular file. So here's a FILE.STAT and ANALYZE.FILE of a file that I believe is in need of resizing and/or reconfiguring. I believe that if I can get some input on this file, I'll be able to apply that knowledge to my other files. First, I understand quite clearly that the modulo of 235889 is about half of what it should be, at least for a block size of 4096. Second, unless I'm doing something wrong, I computed my SPLIT LOAD to be 1, which just doesn't seem right. I'd like to resize this file this weekend and I know that if I do one thing incorrectly it could make my performance even worse. Any input would be greatly appreciated. File name(Dynamic File) = OH Number of groups in file (modulo) = 235889 Dynamic hashing, hash type= 0 Split/Merge type = KEYONLY Block size= 4096 File has 234167 groups in level one overflow. Number of records = 1387389 Total number of bytes = 2132217978 Average number of records per group = 5.9 Standard deviation from average = 1.6 Average number of bytes per group = 9039.1 Standard deviation from average = 9949.2 Average number of bytes in a record = 1536.9 Average number of bytes in record ID = 12.4 Standard deviation from average = 4009.7 Minimum number of bytes in a record = 659 Maximum number of bytes in a record = 2205579 Minimum number of fields in a record = 237 Maximum number of fields in a record = 414 Average number of fields per record = 328.3 Standard deviation from average = 32.0 Dynamic File name = OH Number of groups in file (modulo) = 235889 Minimum groups of file= 235889 Hash type = 0, blocksize = 4096 Split load = 10, Merge load = 5 Split/Merge type = KEYONLY Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com http://www.hubbardsupply.com Delivering Products, Services and Innovative Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding: use of I - Descriptor
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Bullard Sent: Thursday, June 28, 2012 4:31 AM To: U2 Users List Subject: Re: [U2] Regarding: use of I - Descriptor 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 have been planning on creating an I-Desc that uses a TRANS() function to look up the data and then building an index on that field. What sort of serious problems would I expect from indexing a TRANS() I-descriptor? John B. This message and all attachments are intended for the use of the individual or entity to whom or which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure. If the reader of this message is not the intended recipient or the agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify me immediately at the number listed above. U.S. export law as contained in the International Traffic In Arms Regulations (ITAR) and the Export Administration Regulations (EAR) may be applicable to any technical information submitted with this communication. This technical information is not to be placed in the public domain, exported from the U.S., or given to any foreign person in the U.S., without the prior, specific written authorization of TeligentEMS LLC and the U.S. Department of State or the U.S. Department of Commerce as applicable. ___ 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] Really trying to understand dynamic file sizing
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 record to a 12 character key and will you ever get enough keys into a group to cause a split? Maybe. But KEYDATA uses both the data and keys to figure out when to split. The only problem I have had using KEYDATA is if you have a meaningful key with separators like '#' in them. The hashing gets goofed up and I can get good distribution into groups. I get splitting but I end up having groups that never get anything in them. So I will have one group with 11 records and then 2 with zero bytes: 4 0 0 5 795 1 6 0 0 7 4888 9 8 0 0 9 669 1 10 0 0 11 598711 12 0 0 13 0 0 14 0 0 15 579511 16 0 0 17 1113 2 18 0 0 19 984216 I have one file that has nice numeric keys and KEYDATA works great: -rwxrwxr-x 1 root mcc 20 Jun 17 17:40 dat001 -rwxrwxr-x 1 root mcc 20 Jun 17 17:40 dat002 -rwxrwxr-x 1 root mcc 20 Jun 17 17:40 dat003 -rwxrwxr-x 1 root mcc 20 Jun 17 17:10 dat004 -rwxrwxr-x 1 root mcc 20 Jun 17 17:40 dat005 -rwxrwxr-x 1 5126 mcc 20 Jun 28 09:02 dat006 -rwxrwxr-x 1 30012mcc 20 Jun 17 17:46 dat007 -rwxrwxr-x 1 9421 mcc 20 Jun 17 17:46 dat008 -rwxrwxr-x 1 30334mcc 20 Jun 28 09:02 dat009 -rwxrwxr-x 1 30334mcc 20 Jun 17 16:16 dat010 -rw-rw-r-- 1 9319 mcc 20 Jun 17 17:40 dat011 -rwxrwxr-x 1 30334mcc 20 Jun 17 17:40 dat012 -rwxrwxr-x 1 30334mcc 20 Jun 17 17:40 dat013 -rwxrwxr-x 1 30334mcc 20 Jun 17 17:40 dat014 -rwxrwxr-x 1 30334mcc 941259776 Jun 28 09:02 dat015 -rwxrwxr-x 1 root mcc 194880 Jun 25 12:57 idx001 -rwxrwxr-x 1 root mcc 194880 Jun 17 17:10 idx002 -rwxrwxr-x 1 root mcc 194880 Jun 17 17:40 idx003 -rwxrwxr-x 1 root mcc 194880 Jun 25 12:57 idx004 -rwxrwxr-x 1 root mcc 194880 Jun 17 17:30 idx005 -rwxrwxr-x 1 root mcc 194880 Jun 17 17:24 idx006 -rwxrwxr-x 1 c00655 mcc 194880 Jun 17 17:40 idx007 -rwxrwxr-x 1 8575 mcc 194880 Jun 17 16:16 idx008 -rw-rw-rw- 1 udtcron mcc 194880 Jun 17 17:46 idx009 -rw-rw-rw- 1 30334mcc 194880 Jun 25 12:57 idx010 -rw-rw-rw- 1 30334mcc 194880 Jun 25 12:57 idx011 -rw-rw-rw- 1 udtcron mcc 1765761024 Jun 26 15:17 idx012 -rwxrwxr-x 1 root mcc 954723328 Jun 28 09:02 over001 I haven't had to do anything to this file for a couple of years. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Thursday, June 28, 2012 9:29 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Really trying to understand dynamic file sizing 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 sense on one particular file. So here's a FILE.STAT and ANALYZE.FILE of a file that I believe is in need of resizing and/or reconfiguring. I believe that if I can get some input on this file, I'll be able to apply that knowledge to my other files. First, I understand quite clearly that the modulo of 235889 is about half of what it should be, at least for a block size of 4096. Second, unless I'm doing something wrong, I computed my SPLIT LOAD to be 1, which just doesn't seem right. I'd like to resize this file this weekend and I know that if I do one thing incorrectly it could make my performance even worse. Any input would be greatly appreciated. File name(Dynamic File) = OH Number of groups in file (modulo) = 235889 Dynamic hashing, hash type= 0 Split/Merge type = KEYONLY Block size= 4096 File has 234167 groups in level one overflow. Number of records = 1387389 Total number of bytes = 2132217978 Average number of records per group = 5.9 Standard deviation from average = 1.6 Average number of bytes per group = 9039.1 Standard deviation from average = 9949.2 Average number of bytes in a record = 1536.9 Average number of bytes in record ID = 12.4 Standard deviation from average = 4009.7 Minimum number of bytes in a record = 659 Maximum
[U2] Problem running script from crontab
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 $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? 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] Regarding: use of I - Descriptor
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 file then reate 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 AG Consulting Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Bullard ent: Thursday, June 28, 2012 4:31 AM o: U2 Users List ubject: Re: [U2] Regarding: use of I - Descriptor You can even put alternate indexes on I-Desc, though this can lead to erious problems if you are indexing a translate. I read this comment (from an earlier thread on this list) and started orrying: I have a requirement to select records based on a field that is ot currently in the record. I have been planning on creating an I-Desc hat uses a TRANS() function to look up the data and then building an index n that field. What sort of serious problems would I expect from indexing a TRANS() -descriptor? John B. This message and all attachments are intended for the use of the individual r entity to whom or which it is addressed and may contain information that s privileged, confidential, and exempt from disclosure. If the reader of his message is not the intended recipient or the agent responsible for elivering the message to the intended recipient, you are hereby notified hat any dissemination, distribution, or copying of this communication is trictly prohibited. If you have received this e-mail in error, please otify me immediately at the number listed above. U.S. export law as contained in the International Traffic In Arms egulations (ITAR) and the Export Administration Regulations (EAR) may be pplicable to any technical information submitted with this communication. his technical information is not to be placed in the public domain, xported from the U.S., or given to any foreign person in the U.S., without he prior, specific written authorization of TeligentEMS LLC and the U.S. epartment of State or the U.S. Department of Commerce as applicable. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] Problem running script from crontab
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 UDTBIN=/usr/ud/bin export UDTBIN CMIHOME=/NTN/CMI/TRANS4M export CMIHOME PATH=$PATH:@UDTBIN export PATH cd /NTN/DATA/PRODUCTION $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem running script from crontab
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem running script from crontab
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Thursday, June 28, 2012 12:54 PM To: U2 Users List Subject: Re: [U2] Problem running script from crontab 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 UDTBIN=/usr/ud/bin export UDTBIN CMIHOME=/NTN/CMI/TRANS4M export CMIHOME PATH=$PATH:@UDTBIN export PATH cd /NTN/DATA/PRODUCTION $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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] Problem running script from crontab
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: [U2] Problem running script from crontab Sent by:u2-users-boun...@listserver.u2ug.org 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 UDTBIN=/usr/ud/bin export UDTBIN CMIHOME=/NTN/CMI/TRANS4M export CMIHOME PATH=$PATH:@UDTBIN export PATH cd /NTN/DATA/PRODUCTION $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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] Problem running script from crontab
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: Thursday, June 28, 2012 12:54 PM To: U2 Users List Subject: Re: [U2] Problem running script from crontab 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 UDTBIN=/usr/ud/bin export UDTBIN CMIHOME=/NTN/CMI/TRANS4M export CMIHOME PATH=$PATH:@UDTBIN export PATH cd /NTN/DATA/PRODUCTION $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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] Problem running script from crontab
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, June 28, 2012 9:19 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Problem running script from crontab 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 $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding: use of I - Descriptor
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 index data field that returns keys. Example: GET_KEYS_FROM_INDEX( KEYS, FILENAME, IDXDATA ) This program has a COMMON block that sets LAST.FILENAME and F.FILENAME open variable and checks to see if it needs to open the FILENAME. Then do a SELECTINDEX to an unused LIST and convert it to an MV list or you can step through the index to create a list of KEYS to return. Lastly create your I-Descriptor in file A calling the SUBR(GET_KEYS_FROM_INDEX, B, Cust_Nbr) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, June 28, 2012 9:34 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Regarding: use of I - Descriptor Could you expand on this? -Original Message- An alternative method is to create an index on the secondary file then reate 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem running script from crontab
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: U2-Users@listserver.u2ug.org Subject: [U2] Problem running script from crontab 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 $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? Charles Shaffer ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem running script from crontab
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 008: GN91ACC.X 009: SORT.TYPE 2 010: BASICTYPE 'p' 011: IF @USER.TYPE # 0 THEN GOTO EOJ 012: LOGON.DRIVER 013: EOJ: Bottom. *--: 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
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 minutes) apart. But they are empty. This means that something failed right off the bat right? 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
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 moving on. Thanks for your help everyone. 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
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 is feeding the responses to it. Working now. 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
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 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, June 28, 2012 11:38 AM To: U2 Users List Subject: Re: [U2] Problem running script from crontab 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 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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, June 28, 2012 9:19 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Problem running script from crontab 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 $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem running script from crontab
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 export UDTHOME UDTBIN=/usr/ud/bin export UDTBIN CMIHOME=/NTN/CMI/TRANS4M export CMIHOME PATH=$PATH:@UDTBIN export PATH cd /NTN/DATA/PRODUCTION $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? 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
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 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 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, June 28, 2012 11:38 AM To: U2 Users List Subject: Re: [U2] Problem running script from crontab 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 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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, June 28, 2012 9:19 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Problem running script from crontab 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 $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? 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-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] Problem running script from crontab
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
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 went fine. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, June 28, 2012 4:17 PM To: U2 Users List Subject: Re: [U2] Problem running script from crontab 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding: use of I - Descriptor
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 create a generic subroutine that takes in a filename and index data field that returns keys. Example: GET_KEYS_FROM_INDEX( KEYS, FILENAME, IDXDATA ) This program has a COMMON block that sets LAST.FILENAME and F.FILENAME open variable and checks to see if it needs to open the FILENAME. Then do a SELECTINDEX to an unused LIST and convert it to an MV list or you can step through the index to create a list of KEYS to return. Better still, use the BASIC READINDEX statement. Depending on the options, it will either return a list of all keys (values) in the index, or a list of all keys for a given index value. I know I wrote a generic routine some time back to do just that for a dictionary item. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem running script from crontab
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 from TCL. iirc it puts a header in the output file recording the fact that it's starting, which means the PHANTOM command itself even isn't getting a look-in. Can you get crontab to record the output as it fires up? Put an output redirect on the command? See if you're getting any errors to stderr? Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Really trying to understand dynamic file sizing
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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
