Skip to Content
avatar image
Former Member

Control file in db2 as in oracle

Hi Experts,

Does control file or similar to control file exists in DB2 LUW as in oracle?

If not, how DB2 reads its files (container, logfiles, etc) location during db2start?

If any container file gets corrupted at OS level, giving Disk I/O error. will DB2 start?

Regards,

Bhishm

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 11, 2015 at 01:34 AM

    Hello Bhishm,

    There is no central 'control file' existing in IBM DB2 on LUW.

    It has separate files which stores relevant information. e.g. log control file, history file and etc.

    It depends. In some cases, DB will shutdown only when it accesses the corrupted page. In some cases, DB can't be brought up due to the corruption during the crash recovery. There are other various cases.

    Regards
    Maria

    Add comment
    10|10000 characters needed characters exceeded