Привет!

Есть проблема такая: делаю рестор базы с одного сервера на другой. ОС AIX.
Делаю так:
1. На исходной базе сделал полный бэкап offline
2. На целевой
RESTORE DATABASE MAXDB75 FROM '/opt/IBM/anonimizacjaSG/' TAKEN AT 20190507110626 ON '/home/ctginst1/' REDIRECT
db2 "SET STOGROUP PATHS FOR IBMSTOGROUP ON '/home/ctginst1/'"

DB20000I The SET STOGROUP PATHS command completed successfully.


db2 "SET TABLESPACE CONTAINERS FOR 0 USING (PATH '/home/ctginst1/ctginst1/NODE0000/MAXDB75/T0000000/C0000000.CAT')"

SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an
automatic storage table space. SQLSTATE=55061

если пропускаем переопределение tablespace то в конце получаем:
SQL1277W A redirected restore operation is being performed. During a table
space restore, only table spaces being restored can have their paths
reconfigured. During a database restore, storage group storage paths and DMS
table space containers can be reconfigured.
DB20000I The RESTORE DATABASE command completed successfully.

SQL0752N Connecting to a database is not permitted within a logical unit of
work when the CONNECT type 1 setting is in use.

что я делаю не так?

db2 connect to maxdb75
db2 force application all
db2 terminate
db2 backup db MAXDB75 to /attach/backup/prdclone/ compress
db2 backup db MAXDB75 online to /opt/IBM/anonimizacjaSG/ compress

на целевой:
db2 force application all
db2 deactivate db MAXDB75
db2 drop db MAXDB75
db2 terminate

далее команды из первого поста