CAI_F_DB_045 The Database Journal File is full
search cancel

CAI_F_DB_045 The Database Journal File is full

book

Article ID: 43700

calendar_today

Updated On:

Products

Unicenter Job Management Option

Issue/Introduction

CAI_F_DB_045 The Database Journal File is full.           

Resolution

Stop JMO auto submission with: cautil stop autosub    

-  unishutdown all                                                                                                                                                                                                        
-  backup cashdb : tar cvf /path/cashdb.tar $CAIGLBL0000/sche/bin            
    (see location of cashdb files in file $CA_DB/manager/calnm/cadb)                   
- Get the current number of pages with: 

        . cadb_just cashdb  

                                                                                                                   
- increase the number of pages ( ex : set 8000 pages ) with next command                                                                                                         
         . cadb_fjrn cashdb 8000  

         . reply Y to next prompt

                                                                   
  If this command fails, run he following procedure:                    
  sql                                                                    
  SQL: start db cashdb new journal pages=8000;                           
       terminate db;                                                     
       quit;      

   - Get the new number of pages with: 

        . cadb_just cashdb     

                                                                                                             
- If everything is fine, start Unicenter with 'unistart all'                                                          
- cautil start autosub    

- Ensure Archive mode is OFF with these steps:

                                               
-  caidbck cashdb |grep Archive

            DBname: CASHDB  User mode: MULTI  Archive mode OFF  Production mode: ON

Otherwise set it to OFF with these steps:

      sql                                                                  
       connect to cashdb;                                                
       rollback archive set archive off;                                 
       release;                                                          
       quit;