# US 12,182,154 B2 · Cloning database system on VSAM based dataset > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 12,182,154 B2 - Document ID: US12182154B2 - Status: Granted - Kind: B2 - Application number: 18/064,461 - Filed: 2022-12-12 - Published: 2024-06-13 - Granted: 2024-12-31 - Earliest claimed: 2022-12-12 - Assignees: Kyndryl, Inc. - Applicants: Kyndryl, Inc. - Inventors: Rodolfo Ferraz Nogueira; Juscelino Candido; Samir de Andrade Yaki; Jorge Augusto Senger; Fabio Torres Das Candeias - Web page: https://patentgrep.com/patent/US12182154B2 ## CPC - G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses} - G06F 16/2365: {Ensuring data consistency and integrity} - G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract A method for database cloning is provided. The method initiates an outage-free backup of a production database of a source database system using a point-in-time copy technology which copies both data and object structure. The method executes a cloning command to open a dialog panel menu receiving as input a subsystem name used to generate a set of database restore jobs. The method executes the set of database restore jobs to clone data into a transient area. The method uses a copy management service to activate replication of the data from the source database system created using the copy technology to a target database system. The method exports a file catalog associated with the source database system to the target database system. The method executes a script to rename files according to specifications of the target database system and the file catalog. ## Claims ### Claim 1 A computer-implemented method for database cloning, comprising: initiating an outage-free backup of a production database of a source database system using a predetermined point-in-time copy technology which copies both data and object structure, responsive to a request to perform a clone of the source database system while allowing data access to the source database system; executing a predetermined cloning command to open a dialog panel menu receiving as input a subsystem name used to generate a set of database restore jobs; executing the set of database restore jobs to clone data into a predetermined transient area while allowing data access to the source database system, the set of database restore jobs including at least three Hierarchical Storage Manager (HSM) commands, the at least three HSM commands comprising a first HSM command to restore a file from a copy pool storage group, a second HSM command to make the file ready to be sent to the predetermined transient area, and a third HSM command to validate executions of the first and second commands; using a predetermined copy management service to activate replication of the data from the source database system created using the predetermined point-in-time copy technology to a target database system; exporting a file catalog associated with the source database system to the target database system; and executing a predetermined script to rename files according to specifications of the target database system and the file catalog while allowing data access to the source database system. ### Claim 2 (depends on 1) The computer-implemented method of claim 1, wherein executing the set of database restore jobs comprises creating a storage group for the predetermined transient area in both the source database system and the target database system. ### Claim 3 (depends on 1) The computer-implemented method of claim 1, wherein the predetermined transient area has a memory size equal to or greater than a size of respective storage groups for the predetermined transient area in both the source database system and the target database system. ### Claim 4 (depends on 1) The computer-implemented method of claim 1, further comprising creating a physical connection between storage areas of the source database system and the target database system responsive to respective storage areas of the systems residing in different storage boxes. ### Claim 5 (depends on 1) The computer-implemented method of claim 1, wherein the three HSM commands are executed in a loop for all of the files to be transferred from the source database system to the target database system. ### Claim 6 (depends on 1) The computer-implemented method of claim 1, further comprising setting respective work areas in the source database system and the target database system to copy from and to, respectively, wherein files are copied from a work area of the source database system to the predetermined transient area and from the predetermined transient area to a work area of the target database system. ### Claim 7 (depends on 1) The computer-implemented method of claim 1, wherein the subsystem name specifies a name of respective work areas in both the source database system and the target database system. ### Claim 8 (depends on 1) The computer-implemented method of claim 1, wherein the source database system comprises Virtual Storage Access Method (VSAM) data. ### Claim 9 (depends on 1) The computer-implemented method of claim 1, wherein data from the predetermined transient area is cloned using Secure File Transfer Protocol (SFTP). ### Claim 10 (depends on 1) The computer-implemented method of claim 1, wherein the method is a time scheduled method for automatic cloning. ### Claim 11 (depends on 1) The computer-implemented method of claim 1, wherein the predetermined transient area is comprised in a system selected from the group consisting of the source database system and the target database system. ### Claim 12 (depends on 1) The computer-implemented method of claim 1, wherein the predetermined transient area is comprised in a database cloning system separate from and operatively connected to both the source database system and the target database system. ### Claim 13 A computer program product for database cloning, the computer program product comprising a non-transitory computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computer to cause the computer to perform a method comprising: initiating, by a hardware processor of the computer, an outage-free backup of a production database of a source database system using a predetermined point-in-time copy technology which copies both data and object structure, responsive to a request to perform a clone of the source database system while allowing data access to the source database system; executing, by the hardware processor, a predetermined cloning command to open a dialog panel menu receiving as input a subsystem name used to generate a set of database restore jobs, the set of database restore jobs including at least three Hierarchical Storage Manager (HSM) commands, the at least three HSM commands comprising a first HSM command to restore a file from a copy pool storage group, a second HSM command to make the file ready to be sent to the predetermined transient area, and a third HSM command to validate executions of the first and second commands; executing, by the hardware processor, the set of database restore jobs to clone data into a predetermined transient area while allowing data access to the source database system; using, by the hardware processor, a predetermined copy management service to activate replication of the data from the source database system created using the predetermined point-in-time copy technology to a target database system; exporting, by the hardware processor, a file catalog associated with the source database system to the target database system; and executing, by the hardware processor, a predetermined script to rename files according to specifications of the target database system and the file catalog while allowing data access to the source database system. ### Claim 14 (depends on 13) The computer program product of claim 13, wherein the three HSM commands are executed in a loop for all of the files to be transferred from the source database system to the target database system. ### Claim 15 (depends on 13) The computer program product of claim 13, wherein the subsystem name specifies a name of respective work areas in both the source database system and the target database system. ### Claim 16 (depends on 13) The computer program product of claim 13, wherein the source database system comprises Virtual Storage Access Method (VSAM) data. ### Claim 17 (depends on 13) The computer program product of claim 13, wherein data from the predetermined transient area is cloned using Secure File Transfer Protocol (SFTP). ### Claim 18 A computer processing system for database cloning, comprising: a memory device for storing program code; and a processor device, operatively coupled to the memory device, for running the program code to: initiate an outage-free backup of a production database of a source database system using a predetermined point-in-time copy technology which copies both data and object structure, responsive to a request to perform a clone of the source database system while allowing data access to the source database system; execute a predetermined cloning command to open a dialog panel menu receiving as input a subsystem name used to generate a set of database restore jobs, the set of database restore jobs including at least three Hierarchical Storage Manager (HSM) commands, the at least three HSM commands comprising a first HSM command to restore a file from a copy pool storage group, a second HSM command to make the file ready to be sent to the predetermined transient area, and a third HSM command to validate executions of the first and second commands; execute the set of database restore jobs to clone data into a predetermined transient area while allowing data access to the source database system; use a predetermined copy management service to activate replication of the data from the source database system created using the predetermined point-in-time copy technology to a target database system; export a file catalog associated with the source database system to the target database system; and execute a predetermined script to rename files according to specifications of the target database system and the file catalog while allowing data access to the source database system. ### Claim 19 (depends on 1) The computer-implemented method of claim 1, wherein executing the set of database restore jobs to clone data into a predetermined transient area comprises cloning data to a plurality of offline disks in the predetermined transient area.