Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: PDCR Daily_DBQL step 120 error T2646
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019