Skip to Content
0
Former Member
Feb 04, 2010 at 06:26 PM

R3trans -d shows "Could not check DB2 collating sequence."

107 Views

But, when I check the system, I have it.

I was doing the system copy of ecc60 ehp1 with database backup/restore

I tried two different SID TR2 and TR3 and both fails during R3trans -d

with same error.

       Database Configuration for Database tr3

 Description                                   Parameter   Current Value              Delayed Value
 ---------------------------------------------------------------------------------------------------------------
 Database configuration release level                    = 0x0c00
 Database release level                                  = 0x0c00

 Database territory                                      = en_US
 Database code page                                      = 1208
 Database code set                                       = UTF-8
 Database country/region code                            = 1
 Database collating sequence                             = IDENTITY_16BIT             IDENTITY_16BIT            
 Alternate collating sequence              (ALT_COLLATE) =                                                      
 Number compatibility                                    = OFF
 Varchar2 compatibility                                  = OFF
 Database page size                                      = 16384                      16384                     

 Dynamic SQL Query management           (DYN_QUERY_MGMT) = DISABLE                    DISABLE                   

 Discovery support for this database       (DISCOVER_DB) = ENABLE                     ENABLE                    

 Restrict access                                         = NO
 Default query optimization class         (DFT_QUERYOPT) = 5                          5                         
 Degree of parallelism                      (DFT_DEGREE) = 1                          1                         
 Continue upon arithmetic exceptions   (DFT_SQLMATHWARN) = NO                         NO                        
 Default refresh age                   (DFT_REFRESH_AGE) = 0                          0                         
 Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM                     SYSTEM                    
 Number of frequent values retained     (NUM_FREQVALUES) = 10                         10                        
 Number of quantiles retained            (NUM_QUANTILES) = 20                         20                        

 Decimal floating point rounding mode  (DECFLT_ROUNDING) = ROUND_HALF_EVEN            ROUND_HALF_EVEN           

 Backup pending                                          = NO

 Database is consistent                                  = YES
 Rollforward pending                                     = NO
 Restore pending                                         = NO

 Multi-page file allocation enabled                      = YES

 Log retain for recovery status                          = NO
 User exit for logging status                            = YES

 Self tuning memory                    (SELF_TUNING_MEM) = ON (Active)                ON                        
 Size of database shared memory (4KB)  (DATABASE_MEMORY) = 345600                     345600                    
 Database memory threshold               (DB_MEM_THRESH) = 10                         10                        
 Max storage for lock list (4KB)              (LOCKLIST) = AUTOMATIC(4470)            AUTOMATIC(4470)           
 Percent. of lock lists per application       (MAXLOCKS) = AUTOMATIC(98)              AUTOMATIC(98)             
 Package cache size (4KB)                   (PCKCACHESZ) = AUTOMATIC(27575)           AUTOMATIC(27575)          
 Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(1124)            AUTOMATIC(1124)           
 Sort list heap (4KB)                         (SORTHEAP) = AUTOMATIC(224)             AUTOMATIC(224)            

 Database heap (4KB)                            (DBHEAP) = AUTOMATIC(25000)           AUTOMATIC(25000)          
 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = 2560                       2560                      
 Log buffer size (4KB)                        (LOGBUFSZ) = 1024                       1024                      
 Utilities heap size (4KB)                (UTIL_HEAP_SZ) = 10000                      10000                     
 Buffer pool size (pages)                     (BUFFPAGE) = 10000                      10000                     
 SQL statement heap (4KB)                     (STMTHEAP) = 5120                       5120                      
 Default application heap (4KB)             (APPLHEAPSZ) = AUTOMATIC(4096)            AUTOMATIC(4096)           
 Application Memory Size (4KB)             (APPL_MEMORY) = AUTOMATIC(40016)           AUTOMATIC(40016)          
 Statistics heap size (4KB)               (STAT_HEAP_SZ) = AUTOMATIC(15000)           AUTOMATIC(15000)          

 Interval for checking deadlock (ms)         (DLCHKTIME) = 10000                      10000                     
 Lock timeout (sec)                        (LOCKTIMEOUT) = 3600                       3600                      

 Changed pages threshold                (CHNGPGS_THRESH) = 40                         40                        
 Number of asynchronous page cleaners   (NUM_IOCLEANERS) = AUTOMATIC(3)               AUTOMATIC(3)              
 Number of I/O servers                   (NUM_IOSERVERS) = AUTOMATIC(5)               AUTOMATIC(5)              
 Index sort flag                             (INDEXSORT) = YES                        YES                       
 Sequential detect flag                      (SEQDETECT) = YES                        YES     
 Default prefetch size (pages)         (DFT_PREFETCH_SZ) = 32                         32                        

 Track modified pages                         (TRACKMOD) = YES                        YES                       

 Default number of containers                            = 1                          1                         
 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 2                          2                         

 Max number of active applications            (MAXAPPLS) = AUTOMATIC(40)              AUTOMATIC(40)             
 Average number of active applications       (AVG_APPLS) = AUTOMATIC(3)               AUTOMATIC(3)              
 Max DB files open per application            (MAXFILOP) = 61440                      61440                     

 Log file size (4KB)                         (LOGFILSIZ) = 16380                      16380                     
 Number of primary log files                (LOGPRIMARY) = 20                         20                        
 Number of secondary log files               (LOGSECOND) = 40                         40                        
 Changed path to log files                  (NEWLOGPATH) =                                                      
 Path to log files                                       = /db2/TR3/sapdata5/db2tr3/NODE0000/SQL00001/SQLOGDIR/ /db2/TR3/sapdata5/db2tr3/NODE0000/SQL00001/SQLOGDIR/
 Overflow log path                     (OVERFLOWLOGPATH) =                                                      
 Mirror log path                         (MIRRORLOGPATH) =                                                      
 First active log file                                   = S0000050.LOG               S0000050.LOG              
 Block log on disk full                (BLK_LOG_DSK_FUL) = YES                        YES                       
 Block non logged operations            (BLOCKNONLOGGED) = NO                         NO                        
 Percent max primary log space by transaction  (MAX_LOG) = 0                          0                         
 Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0                          0                         
 Group commit count                          (MINCOMMIT) = 1                          1                         
 Percent log file reclaimed before soft chckpt (SOFTMAX) = 300                        300                       
 Log retain for recovery enabled             (LOGRETAIN) = OFF                        OFF                       
 User exit for logging enabled                (USEREXIT) = OFF                        OFF                       

 HADR database role                                      = STANDARD                   STANDARD                  
 HADR local host name                  (HADR_LOCAL_HOST) =                                                      
 HADR local service name                (HADR_LOCAL_SVC) =        
HADR remote host name                (HADR_REMOTE_HOST) =                                                      
 HADR remote service name              (HADR_REMOTE_SVC) =                                                      
 HADR instance name of remote server  (HADR_REMOTE_INST) =                                                      
 HADR timeout value                       (HADR_TIMEOUT) = 120                        120                       
 HADR log write synchronization mode     (HADR_SYNCMODE) = NEARSYNC                   NEARSYNC                  
 HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0                          0                         

 First log archive method                 (LOGARCHMETH1) = DISK:/export/TR2/log_archive/ DISK:/export/TR2/log_archive/
 Options for logarchmeth1                  (LOGARCHOPT1) =                                                      
 Second log archive method                (LOGARCHMETH2) = OFF                        OFF                       
 Options for logarchmeth2                  (LOGARCHOPT2) =                                                      
 Failover log archive path                (FAILARCHPATH) =                                                      
 Number of log archive retries on error   (NUMARCHRETRY) = 5                          5                         
 Log archive retry Delay (secs)         (ARCHRETRYDELAY) = 20                         20                        
 Vendor options                              (VENDOROPT) =                                                      
 Auto restart enabled                      (AUTORESTART) = ON                         ON                        
 Index re-creation time and redo index build  (INDEXREC) = SYSTEM                     SYSTEM (RESTART)          
 Log pages during index build            (LOGINDEXBUILD) = OFF                        OFF                       
 Default number of loadrec sessions    (DFT_LOADREC_SES) = 1                          1                         
 Number of database backups to retain   (NUM_DB_BACKUPS) = 12                         12                        
 Recovery history retention (days)     (REC_HIS_RETENTN) = 60                         60                        
 Auto deletion of recovery objects    (AUTO_DEL_REC_OBJ) = OFF                        OFF          
 TSM management class                    (TSM_MGMTCLASS) =                                                      
 TSM node name                            (TSM_NODENAME) =                                                      
 TSM owner                                   (TSM_OWNER) =                                                      
 TSM password                             (TSM_PASSWORD) =                                                      

 Automatic maintenance                      (AUTO_MAINT) = ON                         ON                        
   Automatic database backup            (AUTO_DB_BACKUP) = OFF                        OFF                       
   Automatic table maintenance          (AUTO_TBL_MAINT) = ON                         ON                        
     Automatic runstats                  (AUTO_RUNSTATS) = ON                         ON                        
       Automatic statement statistics  (AUTO_STMT_STATS) = OFF                        OFF                       
     Automatic statistics profiling    (AUTO_STATS_PROF) = OFF                        OFF                       
       Automatic profile updates         (AUTO_PROF_UPD) = OFF                        OFF                       
     Automatic reorganization               (AUTO_REORG) = OFF                        OFF                       
 Enable XML Character operations        (ENABLE_XMLCHAR) = YES                        YES                       
 WLM Collection Interval (minutes)     (WLM_COLLECT_INT) = 0                          0                         


Edited by: Chun Sei on Feb 4, 2010 7:26 PM