Archives of the TeradataForum

Message Posted: Tue, 11 Aug 2015 @ 13:56:53 GMT

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

<-- Anonymously Posted: Tuesday, August 11, 2015 09:37 -->

Hi,

Generally, a 2646 error means the target database has run out of space.

We don't have PDCR at our site so I am not sure which tables are being copied but, I assume that it is the DBQL tables. This query will show how many GB are in the DBC.DBQL% tables:

     select sum(currentperm)/1024/1024/1024
     from dbc.tablesize
     where databasename = 'dbc'
     and tablename like 'dbql%'

This query will show you how much space is available in the target database.

     sel sum(maxperm)/1024/1024/1024 as Space_Allocated_GB , sum(currentperm)/1024/1024/1024
     as Space_Used_GB
     ,sum(maxperm)/1024/1024/1024- sum(currentperm)/1024/1024/1024 as Space_Available_GB from
     dbc.diskspace where databasename = ''

Make sure that the target PDCR database has enough space to hold the DBQL data being copied over. Teradata Administrator has a nice facility for moving space.

Good luck.

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