Archives of the TeradataForum

Message Posted: Wed, 29 Jan 2014 @ 22:27:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Sravan,

So, If I acquire check point/(lock), from then on, databases will be available for WRITE and READ for other users, right?

MB -

Once checkpoint is taken, then the tables are fully usable. Be conscious of capacity needs to capture any data changes whilst the backups are taking place - both DBC (transient journals are used to capture the changes as I found out to my cost once resusage had been disabled) and the database being backed up are impacted (changes logged in database space)

What if a user has already write locked a table/(database), My backup user should wait until the lock is released?

MB -

The checkpoint on the DB would wait until it can take it's lock.

My client has a requirement that tables should be available all time as they run the batch loads 24*7. How can we achieve this?

MB -

The push here should be getting a reliable RPO - hence a need to put a line in the sand (stopping batch for checkpoint) so you know where all your backups will restore. This is a common problem where the request is for 24x7 usage, but presuming the backups are taken for application support/DR scenario, then I always push back on RPO.

Regards,

Martin Barrow
Lead DBA, PHI IT - EDWBI BAU Support

	<Prev	Next>		<<First	<Prev	Next>	Last>>