DB2 z/OS   DB2 LUW
z/OS CICS VTAM

DB2 LUW

Home

Kleines Beispiel um eine HADR Datenbank anzulegen !
Ist ein Beispiel zum testen, die beiden Datenbanken werden auf einem Rechner angelegt.

rem Step 1: Create 2 DB2 Instances

db2icrt HADRPRIM
db2icrt HADRSEQ


rem Step 1: Create 2 DB2 Instances

db2icrt HADRPRIM
db2icrt HADRSEQ


rem Step 2: Configure Instance 1 TCPIP service port fuer instance 1 ist 50100

SET DB2INSTANCE=HADRPRIM
db2stop
db2set DB2COMM=tcpip

db2 update dbm cfg using SVCENAME 50100
db2 update dbm cfg using DFTDBPATH D:\Databases1
db2 update dbm cfg using SYSADM_GROUP DB2ADMNS
db2 update dbm cfg using SYSCTRL_GROUP DB2ADMNS
db2 update dbm cfg using SYSMAINT_GROUP DB2ADMNS
db2 update dbm cfg using SYSMON_GROUP DB2ADMNS
db2start

db2 create db HADRDB

db2 update alternate server for database HADRDB using hostname localhost port 50200

db2 update db cfg for HADRDB using hadr_local_host localhost
db2 update db cfg for HADRDB using hadr_local_svc 50001
db2 update db cfg for HADRDB using hadr_remote_host localhost
db2 update db cfg for HADRDB using hadr_remote_svc 50001
db2 update db cfg for HADRDB using hadr_remote_inst HADRSEQ
db2 update db cfg for HADRDB using hadr_syncmode SYNC
db2 update db cfg for HADRDB using hadr_timeout 120
db2 update db cfg for HADRDB using LOGINDEXBUILD on
db2 update db cfg for HADRDB using INDEXREC RESTART
db2 update db cfg for HADRDB using LOGRETAIN on


db2stop
db2start


db2 BACKUP DB HADRDB TO d:\dbbackup


rem Step 2: Configure Instance 2 TCPIP service port fuer instance 1 ist 50200

SET DB2INSTANCE=HADRSEQ
db2stop
db2set DB2COMM=tcpip
db2 update dbm cfg using SVCENAME 50200
db2 update dbm cfg using DFTDBPATH D:\Databases2
db2 update dbm cfg using SYSADM_GROUP DB2ADMNS
db2 update dbm cfg using SYSCTRL_GROUP DB2ADMNS
db2 update dbm cfg using SYSMAINT_GROUP DB2ADMNS
db2 update dbm cfg using SYSMON_GROUP DB2ADMNS
db2start


rem Restore den backup HADRDB fuer Standby DB

db2 RESTORE DB HADRDB FROM d:\dbbackup


Rem Configure the HADR settings fuer Seq DB in STANDBY

db2 update alternate server for database HADRDB using hostname localhost port 50100
db2 update db cfg for HADRDB using hadr_local_host localhost
db2 update db cfg for HADRDB using hadr_local_svc 50001
db2 update db cfg for HADRDB using hadr_remote_host localhost
db2 update db cfg for HADRDB using hadr_remote_svc 50001
db2 update db cfg for HADRDB using hadr_remote_inst HADRPRIM
db2 update db cfg for HADRDB using hadr_syncmode SYNC
db2 update db cfg for HADRDB using hadr_timeout 120
db2stop
db2start



Rem Start HADR Standby DB IN HADRSEQ Standby als erste starten !

SET DB2INSTANCE=HADRSEQ
db2 START HADR ON DB HADRDB AS STANDBY


rem Start HADR Primary DB IN HADRPRIM

SET DB2INSTANCE=HADRPRIM
db2 START HADR ON DB HADRDB AS PRIMARY

rem Take over Primary Role zur Standby Instance

SET DB2INSTANCE=HADRSEQ
db2 TAKEOVER HADR ON DB HADRDB


REM Take back the Primary Role von Standby Instance

SET DB2INSTANCE=HADRPRIM
db2 TAKEOVER HADR ON DB HADRDB

rem Stop the HADR service auf Primary DB

SET DB2INSTANCE=HADRPRIM
db2 STOP HADR ON DB HADRDB


Rem Stop the HADR service auf Standby DB

SET DB2INSTANCE=HADRSEQ
db2 deactivate db HADRDB
db2 STOP HADR ON DB HADRDB