<div>
That's what I was afraid of...ok thanks
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I have a DB2 VSAM dataset that our MODIFY utility had removed the SYSCOPY entry and I am not able to restore the regular method. But I still have the physical VSAM dataset and I want to use the dataset to restore the tablespace(s). Can someone share the step-wise JCL to complete this recovery?<br />
<br />
Thanks
</div>
</div>


Hi all,

I have a DB2 VSAM dataset that our MODIFY utility had removed the SYSCOPY entry and I am not able to restore the regular method. But I still have the physical VSAM dataset and I want to use the dataset to restore the tablespace(s). Can someone share the step-wise JCL to complete this recovery?

Thanks

How to restore/recover DB2 tablespaces with only VSAM dataset &amp; no SYSCOPY/backup entry found.

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

A mainframe operating system is networking software infrastructure that allows a mainframe computer to run programs, connect linked machines, and process complex numerical and data-driven tasks. Modern mainframe design is generally defined by redundant internal engineering, extensive input-output facilities, strict backward compatibility with older software, high hardware and computational utilization rates and high stability and reliability. Well-known operating systems include IBM z/OS, z/VM, zTPF, z/VSE, OS/390, and their predecessors, along with MCP for Unisys ClearPath, and NonStop OS/Guardian on HP/Tandem, and questions regarding the IBM midrange operating system called IBM i, OS/400, and i5/OS.

Mainframe OS

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.

How to restore/recover DB2 tablespaces with only VSAM dataset &amp; no SYSCOPY/backup entry found.

How to restore/recover DB2 tablespaces with only VSAM dataset & no SYSCOPY/backup entry found.