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