|
|
|
Forum Member
 
Group: Forum Members
Last Login: 9/26/2008 8:52:45 AM
Posts: 32,
Visits: 46
|
|
We recently upgraded from V2R5 to V2R6 and I noticed that when running Fastload and FastExport scripts, it is asking for the user password NUMEROUS times (I do not pass my password within the script).
It appeared to be asking for a password for the initial logon, and then for each session as defined in the script, and then again before logging off. I always set SESSIONS to 4, and it is asking for a password up to 8 times until the script completes.
Obviously, this is annoying, as one mistype and the script fails.
Has anyone encountered this before?
Here is an example script:
.logtable DM.ACLTemp_log;
.logon TDATABOX1/USERID;
.begin export sessions 4;
.export outfile
o:\fastexport\export.txt
Mode record format text;
Select prodid (char (11))
,prodcode (char (6))
From TRAINING.PRODUCT_HELD
;
.end export;
.logoff;
I find this quite odd! I just tested it again, and indeed it was 7 password requests. It pauses after the first one, then requests 2 through 6 just pop up one after the other. The remainder of the script runs, and then before it logs off, it asks for the password again.
Is there perhaps a flag for load jobs for explicit logging or something like that?
Any help would be appreciated.
Andrew
Andrew C. Livingston
Teradata Certified Professional and Trainer
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/26/2008 8:52:45 AM
Posts: 32,
Visits: 46
|
|
Hello!
I've had 741 views to this post, but no one has replied. Has no one encountered this problem before?
Thanks!
Andrew
Andrew C. Livingston
Teradata Certified Professional and Trainer
|
|
|
|