Steps to backup the DB2 database -

All Programes->IBM DB2 DB2COPY1 (Default)-> Command Window – Administrator
run “db2” command

• CONNECT TO STOREDB

• QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS

• CONNECT RESET

• BACKUP DATABASE STOREDB TO "C:\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING

• CONNECT TO STOREDB

• UNQUIESCE DATABASE

• CONNECT RESET

Steps to restore the DB2 database -

• Copy ‘STOREDB.0.DB2.DBPART000.20161014120608.001’  it onto your C drive e.g. C:\Backups

• All Programes->IBM DB2 DB2COPY1 (Default)-> Command Window – Administrator

• run “db2” command

• It’s worth making sure all db2 connections are terminated via this command:

• force application all

• Then :

• RESTORE DATABASE STOREDB FROM C:\Backups\ TAKEN AT 20161014120608