Cannot Start the DB2 Instance after Config Change

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dond
    New Member
    • Dec 2013
    • 1

    Cannot Start the DB2 Instance after Config Change

    Hi All,
    I changed the log file size in the DB without calculating the real server space. Now the DB will not startup.

    Log File Size is given below,

    [xxxxx@xxxxxxx ~]$ db2 get db cfg for rcb |grep 'LOG'
    Catalog cache size (4KB) (CATALOGCACHE_S Z) = 300
    Log buffer size (4KB) (LOGBUFSZ) = 2159
    Log file size (4KB) (LOGFILSIZ) = 100000
    Number of primary log files (LOGPRIMARY) = 50
    Number of secondary log files (LOGSECOND) = 24


    We cannot add more server space to the location of the log since the DB is down. Also I dont know wether its possible to edit the cnfg file directly via vi.

    Has any one been in this situ before? Please help.
  • Anas Mosaad
    New Member
    • Jan 2013
    • 185

    #2
    Although you should not but you may consider looking at the SQLDBCONF file.

    For more details please check http://pic.dhe.ibm.com/infocenter/db.../t0005086.html

    Comment

    Working...