STEP 2.2: Change Catalog STOGROUPs HLQ:

ID: 25889
Creador: VIDAL I CANET, JOSEP LLUIS 
URL: https://mmedia.uv.es/html5/u/vi/vijo/25889_chmetadata_catalog.swf.mp4
Código de inserción:
<video poster="https://mmedia.uv.es/g?user=vijo&path=/odbclone/&name=chmetadata_catalog.swf.flv&resource_id=25889" controls="" autoplay="" autobuffer="" controlslist="nodownload">
<source src="https://mmedia.uv.es/html5/u/vi/vijo/25889_chmetadata_catalog.swf.mp4" type="video/mp4">
</video>
Categoría: Tecnología
Clasificación Unesco: Ciencias tecnológicas
Descripción: 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)
Etiquetas: Online DB2 Z/OS Cloning clone subsystem LPAR
Resolucion:  1024 x 1024  unknown
Puntuación: Sense puntuacio (puntuar).
Licencia CC: No asignada
Visitas: 826