Universitat de València - Servidor Multimedia de Aula Virtual

STEP 2.2: Change Catalog STOGROUPs HLQ:

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

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: Original Resolution 1024 x 1024 Ratio Resolution unknown
Puntuación: Sense puntuacio (puntuar).
Licencia CC: No asignada
Visitas: 710

Regulación

Añadir comentario

No hay comentarios

Vídeos Relacionados

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)

Persistent Sessions

Demo sobre persistència de sessions. En el cluster de la gestió acadèmica s'aturen tots els nodes. Posteriorment, s'alça un i es comprova que les dades de la sessió es recuperen sense problemes.

1.- Instalación zlinux. Introducción

Pasos preliminares a la instalación. Descargar el runtime necesario (zlinux.tgz) con dispositivos emulados y configuraciones necesarias para la instalación de debian en arquitectura s390 emulada (Hercules).

6.- Instalación zlinux. Configuración DASD

En este paso vamos a configurar los volumenes que utilizaremos para el root file system de la debian s390 y el volumen para la paginación del 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.