#DateWhereItemComment
503 Sep 2013 @ 04:24 PDTcarrie's blogEliminating Unplanned Delays Within Load Utility JobsHello Carrie, 1. I am a little confused with the picture showing that the 'write to restart log' sqls getting classified into the wd-short-qry and what was explained above "Subsequent...
421 Aug 2013 @ 05:22 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Also the jobs where I am seeing lesser sessions are actually from the same client running 13.10 TTU and hitting TD14 database. Like I explained above its a logging issue, I even scanned the ETL JOB...
321 Aug 2013 @ 05:20 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Thanks Carrie for your response. What I researched so far is the SESSIONINFO is not getting all of the utility sessions logged though the LOGONOFF logs all sessions(matches to viewpoint). Its so we...
221 Aug 2013 @ 09:54 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Carrie, I think I had issue in my PDCR table that showed high number of sessions. Not that I look at the session count again, the rule is working fine for allocating max of 64 sessions. But I do s...
120 Aug 2013 @ 10:10 PDTcarrie's blogUtility Session Management - It's Inside the Database in Teradata 13.10! (UPDATED)Hello Carrie, We did all changes as suggested in this article, We are now in TD14.0.3 database versions and we flipped the DBScontrol internal parameter 198(DISABLETDWMSESSIONS) to FALSE so that t...