Teradata system dictionary Backup by Netvault

Database
Teradata Employee

Teradata system dictionary Backup by Netvault

Teradata system dictionary Backup by Netvault, is too slow. I have verified the log file, but I have not seen its taking alot much time on any specific object or getting delayed due to drive reading/writing. There isn't any reason found from log file. What could be the other reason, its size is 94 MB and its taking 3+ or 2.5+ hours .....

2 REPLIES

Re: Teradata system dictionary Backup by Netvault

Did you see in the 'backup options', how many sessions it is using .. n how streams is it using...

Enthusiast

Re: Teradata system dictionary Backup by Netvault

You should also check to see if your dictionary job is being blocked by other running jobs. We see this quite often and our normal dictionary backup of 45 minutes can end up taking up 2-3 hours or even reaching the timeout period and failing due to being blocked.