DBC Diskspace,

Database
Enthusiast

DBC Diskspace,

We have load jobs running in the night. DBC diskspace getting filled rapidly. I can see it in the view point, it raises from 11% to 80 %. or some time it reaches 100 % and all the jobs get failed. My question is, IS DBC Diskspace filling is normal ?. is there a way to reduce it to keep the jobs running.

4 REPLIES
Teradata Employee

Re: DBC Diskspace,

Most likely, this is due to WAL space (DBC.TransientJournal) holding uncommited insert / update / delete information, in case a transaction aborts.

Perhaps you need to commit / checkpoint more frequently, or do more "bulk" operations versus transactions that contain multiple reqeusts.

Teradata Employee

Re: DBC Diskspace,

Or maybe DBC is simply sized too small for your workload. What fraction of total system PermSpace is DBC MaxPerm?

Enthusiast

Re: DBC Diskspace,

475G in 80 TB system.

Senior Apprentice

Re: DBC Diskspace,

Wow, less than 1 percent for dbc, that's definitely way too low.

What's the % perm space in use?