I am doing some POC with both TPT and ARCMAIN.
My understanding is that ARCMAIN will consume more system resources compared to TPT.
Please confirm. what is the advantage of TPT over ARCMAIN.
which is advisable ?
To be honest this sounds a little bit like comparing 'apples to oranges'. TPT and ARC are typically used in completely different circumstances and for different purposes.
The only valid comparison (in my opinion) is to compare TPT Extract with ARC. At least both are extracting data from a Teradata system.
Even if this is what you're doing then which is more/least cost effective will depend on what your're doing. Some thoughts:
The above considerations could mean that one method uses much more or fewer resources than the other.
It also depends on how you want to use the output from either of the above methods.
Does that give you some pointers?
Thanks dave. make sense. Also I heard like there are more chances ARCMAIN will degrade system performance . I am not sure whether this is correct statement or not.
Is this True. Any thoughts ?
Again I think it depends on what you're doing.
If you tell ARC to archive a multi-billion row table then yes, other concurrent processes will probably be impacted. If ARC is just archiving a 20 row reference table then that shouldn't be a problem.
Conversely, I'm sure I could write a TPT extract script which really impacts concurrent users on the system