7 or above) to copy the volumes on which the. You can use as many, or as few pipes as you wish. The online BACKUP SYSTEM utility invokes z/OS DFSMShsm (Version 1 Release. Note that the backup needs to run in a different shell session as the Db2 CLP can't run two things using the same CLP backend process.Īlso note that if you are not the instance owner, you will need to chmod o+w the pipesĪlso, you could of course ssh the piped data to another machine! And it works for online backups too (above is an offline backup) + Done db2 restore database test from /tmp/pipe1, /tmp/pipe2 into test2 The timestamp for this backup image is : 20180815161749ĭB20000I The RESTORE DATABASE command completed successfully. $ db2 backup database test to /tmp/pipe1, /tmp/pipe2īackup successful. DB2 12 introduces the following enhancements for backup and recovery utilities: Sequential image copy enhancements Copy support for FASTREPLICATION.
$ db2 restore database test from /tmp/pipe1, /tmp/pipe2 into test2 &
Allows the use of the RECOVER utility on.
#Icopy in db2 zos full#
This is another example of copying a database, this time using named pipes to avoid landing the backup image onto the file-system $ db2 create database test The COPY YES attribute has the following features: Allows DB2 full image copies and concurrent copies to be taken. CA Quick Copy for DB2 for z/OS creates fast, consistent and accurate DB2 image copies without impacting data availability. With DB2 9, the COPY utility uses an MRU algorithm for the management of the buffer pool usage, therefore limiting the impact on concurrently running online.
0 kommentar(er)
