Archives of the TeradataForum
Message Posted: Tue, 11 Aug 2015 @ 13:56:53 GMT
<-- Anonymously Posted: Tuesday, August 11, 2015 09:37 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|