epcim
10/20/2015 - 10:30 AM

db2_recovery_full.txt.howto.md

db2 recovery from full backup

  1. z prikazove radky spustit db2 command line

    db2cmd

  2. obnova db

    db2 restore database lpczcmp user icmadmin using ********* use tsm

  3. posunuti transkaci do posledni dobre transakce (ve vasem pripade tenhle datum u posledni zalohy, kdyz udelate novou, tak to zmenite)

    db2 rollforward database lpczcmp user icmadmin using ********* to 2008-11-19-13.00.00

  4. uzavreni DB modu rollforward a prevedeni na active

    db2 rollforward database lpczcmp user icmadmin using ******** complete

  5. test db spojeni

    db2 connect to lpczcmp user icmadmin using *******

  6. disconnect

    db2 connect reset