teradata connetor issue

iskapalli · Post by **iskapalli** » Thu Feb 17, 2011 3:32 am

Hi, my job design is sequential -> transformer -> teradata connector stage.
my source file contains 13,00,000 records.

it is running more than one hour.

Please find the properties which I have given.

table action- truncate
load- update(multi load)
access method- bulk

array size- 10
record count -100

Please let me know why it is takeing this much time.

iskapalli · Post by **iskapalli** » Thu Feb 17, 2011 3:41 am

moe information
pTD_SYNC_ID = 1
pTD_SYNC_POLL = 5
pTD_SYNC_TIMEOUT = 1800
pTD_CHECK_TIMEOUT = 0
pTD_END_TIMEOUT = 0
pTD_PROGRESS = 0
pTD_SESSMAX = 8
pTD_SESSMIN = 0
pTD_SLEEP = 0
pTD_TENACITY = 0
pTD_ARRAYSIZE = 10
pTD_RECORDCOUNT = 100
pNUMROWS = 50000000
pTD_ERROR_LIMIT = 0

PaulVL · Post by **PaulVL** » Fri Feb 18, 2011 10:30 am

Have you spoken with your Teradata DBA?

zaino22 · Post by **zaino22** » Tue Mar 08, 2011 8:29 am

you should check if it is loading very slow OR not loading at all by checking the current log. Because knowing where the problem can help you resolve the issue faster. If the table is not loading at all, there could be locking issue.