STEP 1: Copy Source DB2 DataSets to Target DB2

Data d'actualització: 02/09/2011 10:46:16

Share with Facebook   Share with Delicious Share with GoogleShare with Meneame Share with Myspace Share with Digg Mail

ID: 25894
Creator: VIDAL I CANET, JOSEP LLUIS RSS vijo
URL: https://mmedia.uv.es/html5/u/vi/vijo/25894_ocpyren_ios.swf.mp4
Embed code:
<video poster="https://mmedia.uv.es/g?user=vijo&path=/odbclone/&name=ocpyren_ios.swf.flv&resource_id=25894" controls="" autoplay="" autobuffer="" controlslist="nodownload">
<source src="https://mmedia.uv.es/html5/u/vi/vijo/25894_ocpyren_ios.swf.mp4" type="video/mp4">
</video>
Category: Computer science RSS Computer science
Clasification Unesco: Technological sciences
Description: First of all, we execute REXX code to simulate DB workload. This workload consist in inserting on row per second in table sysadm.prv. Second, we stop TARGET (/-DBF STOP DB2) and delete all its datasets except the TARGET SDSN libraries and installation jobs . Finally, we proceed to COPY SOURCE datasets to TARGET DB2, while renaming HLQ (High Level Qualifier). The JCL that implements this is called CPYREN and is executed while source DB is up and running.
Labels: Online DB2 Z/OS Cloning clone subsystem LPAR
Resolution:  1024 x 1024  unknown
Score: Sense puntuacio (puntuar).
License CC: No asignada
Visits: 278

Regulation

Add comment
No comments
related videos

8.- Instalación zlinux. Instalación apt

En este paso se procede a descargar y instalar la herramienta apt de debian, necesaria para instalar paquetes de sw adicionales en el sistema.

STEP 1: Copy Source DB2 DataSets to Target DB2

First of all, we execute REXX code to simulate DB workload. This workload consist in inserting on row per second in table sysadm.prv. Second, we stop TARGET (/-DBF STOP DB2) and delete all its datasets except the TARGET SDSN libraries and installation jobs . Finally, we proceed to COPY SOURCE datasets to TARGET DB2, while renaming HLQ (High Level Qualifier). The JCL that implements this is called CPYREN and is executed while source DB is up and running.

STEP 2.2: Change Catalog STOGROUPs HLQ:

So, now we got both systems up and runing, but TARGET DB2 storage groups point to source HLQ. So we have to update TARGET DB2 catalog to point to new HLQ. To do this we use REXX code to select all storage groups and generate DDL to: 1.- Alter all depenent tablespaces and indexspaces to a temporal storage group -> SYSADM.TEMP.CHTSSGT 2.- Drop all storage groups -> SYSADM.TEMP.DROPSTO 3.- Create all storage groups with new HLQ (VCAT) -> SYSADM.TEMP.CREASTO 4.- Alter all depenent tablespaces and indexspaces to their original storages groups -> SYSADM.TEMP.CHTSSGO The JCLs that automates all this stuff are RENSTOGC (generates DDL to change STOGROUP VCAT) and ALTSTOG (executes it)

7.- Instalación zlinux. Instalación del BOS

Durante este paso instalaremos los paquetes básicos necesarios para correr una debian s/390 mínima.

STEP 3: Restart Target DB2

Finally, we RESTART TARGET DB2 and it's stopped databases.