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
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
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
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
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:
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
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
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
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
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
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:
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:
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:
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:
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
28 matches
Mail list logo