The Db2 restore utility can be used to restore the database from a backup image taken at the specified date and time. The restore utility uses a separate portion of database global memory called the utility heap to write the data from the backup image to the Db2 table spaces. The Db2 restore utility can be invoked using the RESTORE DATABASE command, and the basic syntax for this command is as follows:
RESTORE [DATABASE | DB] [DatabaseAlias]<USER [UserName] <USING [Password]>><REBUILD WITH [TABLESPACE ([TbspNames])] |[ALL TABLESPACES IN [DATABASE | IMAGE]]<EXCEPT TABLESPACE ([TbspNames])>>[TABLESPACE ([TbspNames]) <ONLINE> |HISTORY FILE <ONLINE>> |COMPRESSION LIBRARY <ONLINE>> |LOGS <ONLINE>]<INCREMENTAL <AUTO | AUTOMATIC ...
