?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
???? V8.2 ??? ??? 3?? ????, HADR ??? ??? ?? ????? ?????.
??? ??? ??? ??? ?? ????? XpertMon ? ??? ????.
?? ??? ??? ???, ???? ?? ?? ???? ??? ????? ??? ??????.
???? ????? ?????.
High Availability Disaster Recovery
HADR ???
HADR ? ??? ??????, Fixpak 7?? ??? ?????.
??? ???, ?? ???? ?? ??????? ?? ???? ????
????? ?? ????. ??? AIX? HACMP ? Solaris? Sun Cluster? ??
???? ???? ???? ?? ????. HACMP? HADR? ?? ?????.
??? ?? ??? HACMP? ?? ???, ??? HADR? ????? ???? ???.
?? HADR? ?? ??? ??? ?? ????.
??? ?????? HADR? ?????? ??? ???? HACMP? ??? ??? ???? ?? ???.
HADR ??? ??
HADR??? sync / nearsync / async ? ??? ??? ??? ????.
- sync ?? : primary ????? ??? ??? ???? ????, ?????
standby ????? ???? ????? ??? ???? ??
- near sync ?? : standby ???? ??? ?? ??? ? (????? ???? ?? ??)
?? ???? primary ???? ??? ?? ????? sync ??? ??.
- async ?? : primary ???? ??? standby ???? ?????? ??
????? ???? ??, TCPIP ??? log ??? ????? ??.
??? ?? ??? ??? ???? primary ???? ??? standby ????? ??? ?
????? ??? ??? ??? ? ???? ?? ????.
?? ??? ??? ???? ???? sync ??? ???? ? ????.
??? ? ?? standby ???? ???? ???, ????? ??? ??? ??? ???.
???? ????? sync ????? primary ???? standby ??????? ???
??? ?? ???? ????? ??? ???? ?????.
async ??? ???? ?, primary ???? ??? ?? ??? standby ???? ????
???? ??? ??? ????? ???.
HADR ?? ??
? / ?? ???? ?? ????? ???? ???.
?? ?? ??????? HADR? ???? ????.
Window ? AIX, AIX? Sun? ?? Window200? Window2003 ? ??? ???? ????.
??? ?? ?? ??? ???.
HADR ?? ??
??? ????? ???? ??? ? ???, ???? ????? ???????.
??? ??? ????.
- ? ??????? ????? archive? ??
- ? ???????? ?????? ????? ??
- ? ?????? ??
- ????? ?? ????? ??
- ?? ???? ?????? ?? (roll forward ???)
- ? ??????? HADR ???? ??
- ?? ??????? HADR ???? ??
- ?????? ??? ?? ??
- ? ???? ??? ?? ??
- ? ???? ??(alternative) ?? ??
- ?? ????? HADR ??
- ? ????? HADR ??
??? 12??? HADR? ??? ? ????.
HADR ?? ??
- ? ???
- ??? ? : SY1
- DB ? : DB1
- Instance? : DB2
- ???? : 50000
- ?? ???
- ??? ? : SY2
- Instance? : DB2
- ???? : 50000
HADR ?? 1??
? ??????? ????? archive? ???? ?? ?????? ?????
??? ?? ?????. circular ??? ????? ??? ?? HADR? ??? ? ????.
>db2 update db cfg for DB1 using logretain on
>db2 update db cfg for DB1 using logindexbuild on
>db2 update db cfg for DB1 using indexrec restart
|
SY1?? ? ??????? ??????.
>db2 backup db DB1 to fs1
|
SY2? ??????? ?????. SY1?? SY2? ????? ?????,
SY2?? SY1?
? ??? ? ??? ???. ??? ?? ??? ??? ????.
>db2 restore db DB1 from fs1 replace history file
|
SY1? UDF? stored procedure? SY2? ?????.
? ?? ??? ? ??????? UDF? stored procedure? ????? ?? ????
?? ???????? ?? ??? ???? ? ??? ???.
SY2? ??? ??????? SY1? ???? ???.
>db2 catalog tcpip node hm remote ipaddr-of-SY2 server 50000 remote_instance DB2
>db2 catalog db DB1 as DB1R at node hm
|
HADR ?? 2??
?/?? ??????? HADR ?????? ????? ?????.
- HADR_LOCAL_HOST - ?? ???? ?? IP Address
- HADR_LOCAL_SVC - ?? HADR ????? TCP ??? ??/????
- HADR_REMOTE_HOST - ??? ???? ?? IP Address
- HADR_REMOTE_SVC - ??? HADR ????? TCP ??? ??/????
- HADR_REMOTE_INST - ??? ??? ???? ??
- HADR_SYNCMODE - ??? ??
- HADR_TIMEOUT - ??? ???? ?? HADR ????? ???? ??(?)
HADR ?? 3??
?/?? ??????? ?????? ?????.
?? ??? ?? HADR_LOCAL_SVC, HADR_REMOTE_SVC ? ??? ??? ?????.
?? ??? ??? ?? ???? ??? ????? ?? ??? ??? ????? ???.
? ???? ??(alternative) ??? ?????.
>db2 update alternate server for database DB1 using hostname ip-addr port 50000
|
SY1 ??? ip-addr ? SY2? IP ??? ????, SY2??? SY1? IP ??? ?????.
HADR ??
?? ????? HADR? ?????.
>db2 start hadr on database DB1 as standby
|
? ????? HADR? ?????.
>db2 start hadr on database DB1 as primary
|
HADR ?? ??
HADR? ??? get snapshot ???? ??? ? ????.
snapshot ??? ??? ??? HADR ??? ????.
HADR Status
Role = Primary
State = Peer
Synchronization mode = Nearsync
Connection status = Connected , xxxxxxxx
Heartbeats missed = 0
Local Host = yyyyyyyyy
Local Service = DB2_HADR1
Remote Host = zzzzzzzzz
Remote Service = DB2_DADR2
Remote Instance = DB2
timeout(seconds) = 120
Primary log position(file, page, LSN) = S0000000.LOG, 0, 00000000007D0000
Standby log position(file, page, LSN) = S0000000.LOG, 0, 00000000007D0000
Log gap running average(bytes) = 0
|
?? ? ????? ???? update ? ?? ??? ??? ?? ????? ?????.
FailOver ??
?? ??? ? ???? ?? ??? ?? ??(failover)? ??? ?? ?? ????.
?? ?? TAKEOVER HADR ???? ??? ??? ? ????.
??? ??? ??? ?? ?? ???(SY2)?? ??? ?? ???? ???.
>db2 takeover hadr on db DB1
|
? ???? ?? get snapshot ??? ???? SY2? ? ????? SY1? ???????
?? ?? ?? ? ? ????.
?? SY1?? ???? ?????? ????? ????(failover) ?? ??? ??? ????.
??? ACR? ???? ??, ??? ???? ?? ?? ? ??? ?? ???
??? ????, ??? ???? user ID? password? ???? ??? ?????.
?? SY1? DB1? ??? ?????? select ?? TAKEOVER HADR ??? ???
??? ????, ???????? SY2? ??????? ???? ?? connect ???
??? ?? ?? select ?? ?? ??? ???.
????????? SQL30108N ???(?? ?? ? ??? ??? ??)? ????,
?? ???? ??? select ?? ?? ?? ? ?? ???? ????? ???.**
? ???? ?????? ??? SY1? ?? ????, SY2? ? ?? ???.
- ??? TAKE OVER HADR ??? ???? ?????.
?? ????? ???? ?? ? ???? SY2?? TAKEOVER HADR ??? ???? ???.
??? ??? ??(? ??? - SY1, ?? ??? - SY2)?? ???? ???.
?? SY1? ??? ?????? ??? ???? ??? ????? ????? ????.
?? ????? ???? TAKEOVER HADR ??? ???? ??,
BY FORCE ??? ?? ??? ???.
BY FORCE ??? ?? ??? ?? ?????? ? ????? ???????
??? ? ??? ???? ?? ??? ???? ???.
??? SY1? ??? ??? ??? ?? ? ? ??. ??? BY FORCE ??? ?????.
?? TAKEOVER HADR ??? BY FORCE ?? ?? ?????,
??? ???? ?? ? ? ??? ????? ???.
? ???? ??? ???? ?? ? ???? ???? ?? ? ????
TAKEOVER HADR ??? ????? ? ????? ???? ???? ?? ???
?? ?? ????. ??? ??? ? ??? ????.
? ???? ????? ??? ????? ??? ??? ??? ?? ????
? ???? ??? ???? ? ?? ???? ???? ?????.
??? ?????? ? ????? ????(?-?? ????? ?? ????)? ?????.
?? ????? TAKEOVER HADR ??? ???? SY2? ??? ? ????????
?????. ??? SY1? ? ???????? ???? ????.
?? 2?? ? ??????? ??? ?? ???? ????? ?? ?? ?? ??? ???.
?? ??? TAKEOVER HADR ??? ???? ???? ?? ?????.
??? ??? ?? ? ???? ?? ??? ???? ?? ??? 2?? ? ???????
?? ??? ???? ????? ?? ????.
BY FORCE ??? ????, SY1? ???? ?? ??(standby)??? ????.
??? SY1? ? ???? ??? ??? ?? ?? ??????? ???? ???? ???.
HADR ??? ??? ?, ?????? ??????? ???? ?? ?????.
??? ?????? ???? ?? ? ?? ????.
??? get snapshot ??? LOG GAP ?? ???? ???? ?? ?????.
?? ? ???????? COPY NO ???? ?? ??? ???? ?? ?????????
???? ??? ?????. ??? COPY YES ??? ???? ???.
?? ????? COPY NO ???? ????? ???? ????
DB2_LOAD_COPY_NO_OVERRIDE ?? ??? ????? ??? ??????.
? ????? ??? COPY NO ??? ???? ?? ?? COPY YES? ???? ???.
COPY YES ???? ? ????? ????? ???? ???, ?? ???? ????
? ????? ?????? ??? ??? ????.
??? ??? ??? ?? ??????? ?? ???? ??? ??? ??? ?
?? ???? ??? ????? ?????.
?? ?? ?????? ??? ???? ??? ?? ???? ??? ?????
??????? ????. ??? ?? ??? ????? ???? ??? ??? ? ????.
???? ? ????????? ????? ???? ???? ???.
? ???? UDF? stored procedure? ???? ???? ??? ???? ???.
?? ??? ??? ?? ??? ??? ?? UDF? stored procedure? ??? ? ????.
?? ?? UDF? stored procedure? ?? ??? ??? ?? ????,
? ???????? ?? ??? ?? ?? ???? ? ??? ??? ??? ??
????? ??? ??? ??? HADR? ?? ?? ??? ????? ????.
XpertMon for DB2 UDB V2
DB ???
Tel : 02-2108-1458
Fax : 02-2108-1459
Mobile : 011-896-6545
E-mail : hjlee@iteg.co.kr
URL : http://iteg.co.kr