DB2 Backup Restore

Restore steps: Enter the database after the database is created
1, restore DB tsmesdb from D:\ICSS\dbData in D:\ICSS\dbData into Tsmesdb redirect2, List tablespaces3、Settablespace containers for 4using (path "D:\DB2\NODE0000\TSMESDB\mycontainer")4、Settablespace containers for 5using (path "D:\DB2\NODE0000\TSMESDB\mytemp")5、RESTOREDB TsmesdbContinue

Grammar:

Restore DB database Name the path that is stored after the restore (taken at timestamp) on the restore file path into the database name redirect

View Space

Set Container path

Set Temp file path

Continue restore

If it is a non-administrator account, then you have to re-authorize the user, or do not do any action

If Windows is not enabled administrator need to enable and set a password and then log on to the Administrator user to authorize other users

Adminitrator enabled such as:

Login to Administrator and use open Db2cmd to authorize users who need authorization

= Grant  on Database  to User UserCount  db20000i the  SQL command completed successfully.   = Grant  on Database  to User UserCount  db20000i the  SQL command completed successfully.   = quit  

First restore DB2 data, Pit point: Using the WIN10 network user, not the admin account, resulting in no db2admin permissions

DB2 Backup Restore