Applications Performance

Data d'actualització: 12/04/2012 05:51:40

Compartir en Facebook   Compartir en Delicious Compartir en GoogleCompartir en Meneame Compartir en Myspace Compartir en Digg Enviar por correo

ID: 28860
Creador: VIDAL I CANET, JOSEP LLUIS RSS vijo
URL: https://mmedia.uv.es/html5/u/vi/vijo/28860_App_performance_ii.mp4
Código de inserción:
<video poster="https://mmedia.uv.es/g?user=vijo&path=/db2_perf/&name=App_performance_ii.mp4&resource_id=28860" controls="" autoplay="" autobuffer="" controlslist="nodownload">
<source src="https://mmedia.uv.es/html5/u/vi/vijo/28860_App_performance_ii.mp4" type="video/mp4">
</video>
Categoría: Sin categorizar RSS Sin categorizar
Clasificación Unesco: Sin categorizar
Descripción: How application design can affect performance
Etiquetas:
Resolucion:  1440 x 1046  unknown
Puntuación: Sense puntuacio (puntuar).
Licencia CC: No asignada
Visitas: 649

Regulación

Añadir comentario
No hay comentarios
Vídeos Relacionados

STEP 2.1 Change log inventory HLQ:

This is automated with job RBLDLOGI which prints DBF.BSDS01 log inventory, reads its output (SYSADM.TEMP.PRNTBSDS) and generates a JOB (SYSADM.TEMP.JU004) to: 1.-) Change BSDS HLQ 2.-) Delete LOGCOPIES with source HLQ 3.-) Create new LOGCOPIES with target HLQ and START/END RBAs taken from log inventory output. At this point we can start target system.Target DB2 subsystem is started in MAINTENACE MODE: /-DBF START DB2 ACCESS(MAINT)

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.

Persistència Sessions Automatrícula

Persistència Sessions Automatrícula davant del reinici escalonat del cluster J2EE on està desplegada

STEP 4: Clone checking

Finally, we compare rows from the table that was been modified while source DB2 was clonned. Josep Vidal - System Programmer. For more questions you can reach me at: josepvidalcanet@gmail.com .

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)