ÀÌ Àý¿¡´Â °¡´ÉÇÑ DB2 Data Links Manager ½ÇÆÐ ½Ã³ª¸®¿À¿Í º¹±¸¿¡ ÇÊ¿äÇÑ ´Ü°è°¡
³ª¿µÇ¾î ÀÖ½À´Ï´Ù. º¸´Ù ½¬¿î º¹±¸¸¦ À§ÇÑ ±ÇÀå ÇÁ·Î½Ãµà¾î¿¡ ´ëÇØ¼´Â
DB2 Data Links Manager ½Ã½ºÅÛ ¼³Á¤ ¹× ¹é¾÷ ±ÇÀå»çÇ׿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
´ÙÀ½°ú °°Àº º¹±¸ ½Ã³ª¸®¿À¿¡´Â DB2 ³ëµå¿Í DB2 ÆÄÀÏ °ü¸® ÇÁ·Î±×·¥ ³ëµå ¸ðµÎ¿¡¼
¼öÇàµÉ Á¶ÀÛÀÌ ÇÊ¿äÇÕ´Ï´Ù.
DB2 µ¥ÀÌÅͺ£À̽º´Â ¸ðµç ¿¹¿¡¼ "CROWN"À¸·Î Ç¥½ÃµÇ°í, DATALINK Ä÷³ÀÌ Æ÷ÇÔµÈ
DB2 Å×À̺íÀº "DATALINKTABLE"·Î Ç¥½ÃµË´Ï´Ù.
½Ã³ª¸®¿À
| º¹±¸ ´Ü°è
|
DB2 µ¥ÀÌÅͺ£À̽º°¡ À¯½ÇµÇ¾ú°Å³ª ½Ç¼ö·Î »èÁ¦µÇ¾úÁö¸¸ DB2 ¹é¾÷ ¹× ·Î±× ÆÄÀÏÀº
»ç¿ë°¡´ÉÇÕ´Ï´Ù.
|
ÀÌ ½Ã³ª¸®¿À¿¡¼ DB2 µ¥ÀÌÅͺ£À̽º´Â DLFM ¼¹ö¿¡¼ »èÁ¦µÇÁö ¾Ê¾Ò½À´Ï´Ù.
- DB2 ¼¹ö¿¡¼, ¸ðµç Å×ÀÌºí »óŰ¡
Datalink_Reconcile_Not_Possible(DRNP)·Î µÇµµ·Ï ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "restore database CROWN"
db2 "rollforward database CROWN to end of logs and stop"
- ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© µ¥ÀÌŸ ¸µÅ©°¡ ÀÖ´Â ¸ðµç Å×À̺íÀ» DRP(Datalink_Reconcile_Pending)
»óÅ·ΠÇϽʽÿÀ.
db2 set integrity for <table> datalink reconcile pending
db2 set integrity for <table> datalink reconcile pending immediate unchecked
db2 reconcile <table>
|
DB2 µ¥ÀÌÅͺ£À̽º°¡ ¸í½ÃÀûÀ¸·Î »èÁ¦µÇ¾úÁö¸¸ DB2 ¹é¾÷ ¹× ·Î±×
ÆÄÀÏÀº »ç¿ë°¡´ÉÇÕ´Ï´Ù.
|
- Á¶ÀÛÀÌ ¿Ï·áµÇ¾ú´ÂÁö È®ÀÎÇϰí, ÀÌ µ¥ÀÌÅͺ£À̽º¿Í ¿¬°üµÈ ¸ðµç ÆÄÀÏÀÇ
¸µÅ©°¡ ÇØÁ¦µÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ.
- Data Links ¼¹ö¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "connect to dlfm_db"
db2 "select dbid, dbname, dbinst, hostname from dfm_dbid"
db2 "update dfm_dbid set action=5 where dbid=x'35B3D7BE0006BF7B'"
dbid¸¦ ÀÌÀü ´Ü°è¿¡¼ ¹ß°ßµÈ °ª°ú °°µµ·Ï ¼³Á¤ÇϽʽÿÀ.
- DB2 ¼¹ö¿¡¼ ¸ðµç Å×ÀÌºí »óŰ¡ DRNP
(Datalink_Reconcile_Not_Possible)°¡
µÇµµ·Ï ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "restore database CROWN"
db2 "rollforward database CROWN to end of logs and stop"
- 3´Ü°è¿¡¼ DRNP »óÅ¿¡ ÀÖ´Â °¢ Å×ÀÌºí¿¡ ´ëÇØ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 set integrity for <table> datalink reconcile pending
db2 set integrity for <table> datalink reconcile pending immediate unchecked
db2 reconcile <table>
|
DLFM_DB µ¥ÀÌÅͺ£À̽º´Â À¯½ÇµÇ¾úÀ¸³ª DLFM_DB µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ ¹×
¸ðµç ·Î±× ÆÄÀÏÀº »ç¿ë°¡´ÉÇÕ´Ï´Ù.
|
- Data Links ¼¹ö¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "restore database dlfm_db"
db2 "rollforward database dlfm_db to end of logs and stop"
- DB2 ¼¹ö¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
db2 "connect to CROWN"
db2 "reconcile table DATALINKTABLE"
|
DLFM_DB µ¥ÀÌÅͺ£À̽º´Â À¯½ÇµÇ¾úÀ¸¸ç DFLM_DB µ¥ÀÌÅͺ£À̽ºÀÇ
¹é¾÷ÀÌ »ç¿ë°¡´ÉÇÏÁö¸¸ ¸ðµç ·Îµå ÆÄÀÏÀÌ »ç¿ë°¡´ÉÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù.
|
- Data Links ¼¹ö¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "restore database dlfm_db"
db2 "rollforward database dlfm_db to end of logs and stop"
- DB2 ¼¹ö¿¡¼ ¸ðµç Å×ÀÌºí »óŰ¡
DRP(Datalink_Reconcile_Pending)·Î µÇµµ·Ï ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "connect to CROWN"
db2 "restore database dlfm_db"
db2 "rollforward database dlfm_db to end of logs and stop"
- ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© Data Links°¡ ÀÖ´Â ¸ðµç Å×À̺íÀ» DRP »óÅ·ΠÇϽʽÿÀ.
db2 set integrity for <table> datalink reconcile pending
db2 set integrity for <table> datalink reconcile pending immediate unchecked
db2 reconcile <table>
|
DLFS ÆÄÀÏ ½Ã½ºÅÛÀÌ À¯½ÇµÇ¾ú½À´Ï´Ù.
|
- ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼ DLFS ÆÄÀÏ ½Ã½ºÅÛÀ» º¹¿øÇϽʽÿÀ.
- DB2 ¼¹ö¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
db2_recon_aid CROWN
|
DLFM ¹é¾÷ µð·ºÅ丮°¡ À¯½ÇµÇ¾ú½À´Ï´Ù.
| ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼ DLFM ¹é¾÷ µð·ºÅ丮¸¦ º¹¿øÇϽʽÿÀ.
|
DLFS ÆÄÀÏ ½Ã½ºÅÛ°ú DLFM ¹é¾÷ µð·ºÅ丮°¡
À¯½ÇµÇ¾ú½À´Ï´Ù.
|
- ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼ DLFM ¹é¾÷ µð·ºÅ丮¸¦ º¹¿øÇϽʽÿÀ.
- ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼ DLFS ÆÄÀÏ ½Ã½ºÅÛÀ» º¹¿øÇϽʽÿÀ.
- DB2 ¼¹ö¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
db2_recon_aid CROWN
|
DLFM_DB µ¥ÀÌÅͺ£À̽º, DLFM ¹é¾÷ µð·ºÅ丮 ¹× DLFS ÆÄÀÏ ½Ã½ºÅÛÀÌ
À¯½ÇµÇ¾úÀ¸³ª DLFM_DB µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ ¹× ¸ðµç ·Î±× ÆÄÀÏÀº
»ç¿ë°¡´ÉÇÕ´Ï´Ù.
|
- Data Links ¼¹ö¿¡¼ ¸ðµç Å×À̺íÀÌ DRP
(Datalink_Reconcile_Pending) »óŰ¡ µÇµµ·Ï ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "restore database dlfm_db"
db2 "rollforward database dlfm_db to end of logs and stop"
- ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼ DLFM ¹é¾÷ µð·ºÅ丮¸¦ º¹¿øÇϽʽÿÀ.
- ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼ DLFS ÆÄÀÏ ½Ã½ºÅÛÀ» º¹¿øÇϽʽÿÀ.
- DB2 ¼¹ö¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
db2_recon_aid CROWN
|
DLFM_DB, DLFS ÆÄÀÏ ½Ã½ºÅÛ ¹× DLFM ¹é¾÷ µð·ºÅ丮°¡
À¯½ÇµÇ¾ú½À´Ï´Ù.
DLFM_DB µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷Àº »ç¿ë°¡´ÉÇÏÁö¸¸
¸ðµç ·Î±× ÆÄÀÏÀÌ »ç¿ë°¡´ÉÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù.
|
- Data Links ¼¹ö¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "restore database dlfm_db"
db2 "rollforward database dlfm_db to end of logs and stop"
- ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼ DLFM ¹é¾÷ µð·ºÅ丮¸¦ º¹¿øÇϽʽÿÀ.
- ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼ DLFS ÆÄÀÏ ½Ã½ºÅÛÀ» º¹¿øÇϽʽÿÀ.
- DB2 ¼¹ö¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
db2_recon_aid CROWN
|
DB2 µ¥ÀÌÅͺ£À̽º,
DLFM_DB µ¥ÀÌÅͺ£À̽º,
DLFS ÆÄÀÏ ½Ã½ºÅÛ ¹×
DLFM ¹é¾÷ µð·ºÅ丮°¡ À¯½ÇµÇ¾úÁö¸¸ DLFM_DB µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ ¹× ¸ðµç ·Î±× ÆÄÀÏÀÌ
»ç¿ë°¡´ÉÇÕ´Ï´Ù.
|
- Data Links ¼¹ö¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "restore database dlfm_db"
db2 "rollforward database dlfm_db to end of logs and stop"
- ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼ DLFM ¹é¾÷ µð·ºÅ丮¸¦ º¹¿øÇϽʽÿÀ.
- ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼ DLFS ÆÄÀÏ ½Ã½ºÅÛÀ» º¹¿øÇϽʽÿÀ.
- DB2 ¼¹ö¿¡¼ ¸ðµç Å×À̺íÀÌ DRNP
(Datalink_Reconcile_Not_Possbile) »óŰ¡
µÇµµ·Ï ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "restore database CROWN"
db2 "rollforward database CROWN to end of logs and stop"
db2 "connect to CROWN"
- 4´Ü°è¿¡¼ DRNP »óÅ¿¡ ÀÖ´Â °¢ Å×ÀÌºí¿¡ ´ëÇØ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© DNP »óŰ¡
µÇµµ·Ï ÇϽʽÿÀ.
db2 set integrity for <table> datalink reconcile pending
db2 set integrity for <table> datalink reconcile pending immediate unchecked
db2 reconcile <table>
ÁÖ: | ƯÁ¤ ½ÃÁ¡À¸·ÎÀÇ ·Ñ Æ÷¿öµå´Â recovery = no·Î
Á¤ÀÇµÈ ¸ðµç DATALINK Ä÷³À» DRP(Datalink_Reconcile_Pending)
»óÅ·Π¸¸µéÁö ¸øÇÕ´Ï´Ù. ÀÌ·¯ÇÑ
¸ðµç Å×ÀÌºí¿¡ ´ëÇØ¼´Â Á¶Á¤ À¯Æ¿¸®Æ¼¸¦ ¼öÇàÇϽʽÿÀ.
|
|