You can’t do it that way with DB2; you want to investigate
DSN1COPY for laying down a DB2 COPY dataset in a different
tablespace. It used to have a lot of limitations, so you’ll
want to read the fine print.
That said, some of the third-party vendors may have offerings which
can do this (recover a DB2 COPY dataset to a tablespace other than
From: Oleg Dayneko [mailto:[login to unmask email]
Sent: Monday, January 28, 2019 8:28 AM
To: [login to unmask email]
Subject: [DB2-L] - DB2v10.1 for ZOS. How to restore data from SLB
into new table?
I understand from experience that it would be very useful to be
able to restore a table space from a copy to a new table space in a
new table. Often, programmers are asked not to clean the data of
the damaged table, but to restore it to a new table.
I have only BACKUP SYSTEM(SLB) on volumes or DUMP on tapes.
Can I restore the data to the new table with utility restore?
For example(Allow to restore data only in corrupt table):
//RECOVER EXEC DSNUPROC,SYSTEM=DBT1,
//DSNUPROC.SYSUT1 DD DSN=SORTTEST.SYSUT1,
//DSNUPROC.SYSIN DD *
RECOVER TABLESPACE MYDB2.MYTS1
REBUILD INDEX(ALL) TABLESPACE MYDB2.MYTS1
Any help would be appreciated!
-----End Original Message-----
**This e-mail, including any attachments, may be confidential,
privileged, or otherwise legally protected. It is intended only for
the addressee. If you received this e-mail in error or from someone
who was not authorized to send it to you, do not disseminate, copy,
or otherwise use this e-mail or its attachments. Please notify the
sender immediately by reply e-mail and delete the e-mail from your