Archives of the TeradataForum
Message Posted: Thu, 26 May 2005 @ 09:42:04 GMT
| Subj: | | Re: TPump Rate Change Problem |
| |
| From: | | Victor Sokovin |
| | We're trying to get Tpump to accept a change of rate command issued by using the TpumpUpdateSelect macro. When I execute this macro I can
see on the sysadmin.tpumpstatustbl that the various columns have been changed, but there is no noticeable change to the speed at which the tpump
job runs. | |
Just wanted to check:
- Did you try to use the UserUpdateSelect macro? TpumpUpdateSelect seems to contain a typo in its definition in the manual. Perhaps
there is no typo on your system but it might be worth checking. In addition to the potential differences between the usual user and sysadmin
access etc.
- How about all the other parameters you submit: LogDB, LogTable and Import? Together with the User ID they should determine which
record will be updated in the table.
If you use a generic user name somebody else might be submitting TPump jobs in parallel with you so the Import value should be exactly
right. How do you figure out which record is yours in case you have multiple entries in TPumpStatusTbl? I know it is a pure speculation but
theoretically one user could update records of other users if they share the same TD User ID. This scenario does not contradict what you have
reported: you see changes in the table but no impact on your job.
Regards,
Victor
| 
