DB2 Data Links Manager ºü¸¥ ½ÃÀÛ


DB2 Data Links Manager º¹±¸ ½Ã³ª¸®¿À

ÀÌ Àý¿¡´Â °¡´ÉÇÑ DB2 Data Links Manager ½ÇÆÐ ½Ã³ª¸®¿À¿Í º¹±¸¿¡ ÇÊ¿äÇÑ ´Ü°è°¡ ³ª¿­µÇ¾î ÀÖ½À´Ï´Ù. º¸´Ù ½¬¿î º¹±¸¸¦ À§ÇÑ ±ÇÀå ÇÁ·Î½Ãµà¾î¿¡ ´ëÇØ¼­´Â DB2 Data Links Manager ½Ã½ºÅÛ ¼³Á¤ ¹× ¹é¾÷ ±ÇÀå»çÇ׿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

´ÙÀ½ ½Ã³ª¸®¿À¿¡¼­´Â ´ÙÀ½°ú °°Àº ¿ë¾î ¹× ¿¹¸¦ »ç¿ëÇÒ °ÍÀÔ´Ï´Ù.

DLFS ÆÄÀÏ ½Ã½ºÅÛ
µî·ÏµÈ Á¢µÎºÎ(¿¹. /dlink)

DLFM ¹é¾÷ µð·ºÅ丮
ÆÄÀÏÀÌ ¹é¾÷µÈ µð·ºÅ丮(¿¹: /home/dlfm/dlfm_backup)

DLFM Ȩ µð·ºÅ丮
DLFM »ç¿ëÀÚ IDÀÇ È¨ µð·ºÅ丮(¿¹. /home/dlfm)

DLFM DB2 µ¥ÀÌÅͺ£À̽º
¸ðµç ¸ÞŸµ¥ÀÌÅͰ¡ Æ÷ÇÔµÈ DB2 µ¥ÀÌÅͺ£À̽º(DLFM_DB)

DB2 µ¥ÀÌÅͺ£À̽º
DATALINK µ¥ÀÌÅÍ À¯ÇüÀÌ Æ÷ÇÔµÈ µî·ÏµÈ µ¥ÀÌÅͺ£À̽º(¿¹. CROWN)

º¹±¸°¡ ÇÊ¿äÇÑ ±¸¼º¿ä¼Ò

´ÙÀ½ ±¸¼º¿ä¼Ò´Â DB2 Data Links ¼­¹ö ºØ±« ÈÄ º¹±¸°¡ ÇÊ¿äÇÒ °ÍÀÔ´Ï´Ù.

  1. DATALINK Ä÷³ÀÌ ÀÖ´Â Å×À̺íÀÌ Æ÷ÇÔµÈ DB2 µ¥ÀÌÅͺ£À̽º.
  2. DB2 Data Links Manager µ¥ÀÌÅͺ£À̽º(DLFM_DB).
  3. Data Links Filesystem Filter(DLFF).
  4. Data Links Manager¿¡ µî·ÏµÈ DB2 DLFF°¡ Á¦¾îÇÏ´Â ÆÄÀÏ ½Ã½ºÅÛ.
  5. DB2 Data Links Manager ¹é¾÷ µð·ºÅ丮

º¹±¸ ½Ã³ª¸®¿À

´ÙÀ½°ú °°Àº º¹±¸ ½Ã³ª¸®¿À¿¡´Â DB2 ³ëµå¿Í DB2 ÆÄÀÏ °ü¸® ÇÁ·Î±×·¥ ³ëµå ¸ðµÎ¿¡¼­ ¼öÇàµÉ Á¶ÀÛÀÌ ÇÊ¿äÇÕ´Ï´Ù.

DB2 µ¥ÀÌÅͺ£À̽º´Â ¸ðµç ¿¹¿¡¼­ "CROWN"À¸·Î Ç¥½ÃµÇ°í, DATALINK Ä÷³ÀÌ Æ÷ÇÔµÈ DB2 Å×À̺íÀº "DATALINKTABLE"·Î Ç¥½ÃµË´Ï´Ù.


½Ã³ª¸®¿À º¹±¸ ´Ü°è
DB2 µ¥ÀÌÅͺ£À̽º°¡ À¯½ÇµÇ¾ú°Å³ª ½Ç¼ö·Î »èÁ¦µÇ¾úÁö¸¸ DB2 ¹é¾÷ ¹× ·Î±× ÆÄÀÏÀº »ç¿ë°¡´ÉÇÕ´Ï´Ù.

ÀÌ ½Ã³ª¸®¿À¿¡¼­ DB2 µ¥ÀÌÅͺ£À̽º´Â DLFM ¼­¹ö¿¡¼­ »èÁ¦µÇÁö ¾Ê¾Ò½À´Ï´Ù.

  1. DB2 ¼­¹ö¿¡¼­, ¸ðµç Å×ÀÌºí »óŰ¡ Datalink_Reconcile_Not_Possible(DRNP)·Î µÇµµ·Ï ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
       db2 "restore database CROWN"
       db2 "rollforward database CROWN to end of logs and stop"
     
    
  2. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© µ¥ÀÌŸ ¸µÅ©°¡ ÀÖ´Â ¸ðµç Å×À̺íÀ» 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 ¹é¾÷ ¹× ·Î±× ÆÄÀÏÀº »ç¿ë°¡´ÉÇÕ´Ï´Ù.
  1. Á¶ÀÛÀÌ ¿Ï·áµÇ¾ú´ÂÁö È®ÀÎÇϰí, ÀÌ µ¥ÀÌÅͺ£À̽º¿Í ¿¬°üµÈ ¸ðµç ÆÄÀÏÀÇ ¸µÅ©°¡ ÇØÁ¦µÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ.
  2. 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¸¦ ÀÌÀü ´Ü°è¿¡¼­ ¹ß°ßµÈ °ª°ú °°µµ·Ï ¼³Á¤ÇϽʽÿÀ.

  3. DB2 ¼­¹ö¿¡¼­ ¸ðµç Å×ÀÌºí »óŰ¡ DRNP (Datalink_Reconcile_Not_Possible)°¡ µÇµµ·Ï ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
       db2 "restore database CROWN"
       db2 "rollforward database CROWN to end of logs and stop"
     
    
  4. 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 µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ ¹× ¸ðµç ·Î±× ÆÄÀÏÀº »ç¿ë°¡´ÉÇÕ´Ï´Ù.
  1. Data Links ¼­¹ö¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
       db2 "restore database dlfm_db"
       db2 "rollforward database dlfm_db to end of logs and stop"
    
  2. DB2 ¼­¹ö¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
       db2 "connect to CROWN"
       db2 "reconcile table DATALINKTABLE"
    

DLFM_DB µ¥ÀÌÅͺ£À̽º´Â À¯½ÇµÇ¾úÀ¸¸ç DFLM_DB µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ÀÌ »ç¿ë°¡´ÉÇÏÁö¸¸ ¸ðµç ·Îµå ÆÄÀÏÀÌ »ç¿ë°¡´ÉÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù.
  1. Data Links ¼­¹ö¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
       db2 "restore database dlfm_db"
       db2 "rollforward database dlfm_db to end of logs and stop"
     
    
  2. 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"
     
    
  3. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© 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 ÆÄÀÏ ½Ã½ºÅÛÀÌ À¯½ÇµÇ¾ú½À´Ï´Ù.
  1. ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼­ DLFS ÆÄÀÏ ½Ã½ºÅÛÀ» º¹¿øÇϽʽÿÀ.
  2. DB2 ¼­¹ö¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
       db2_recon_aid CROWN
    

DLFM ¹é¾÷ µð·ºÅ丮°¡ À¯½ÇµÇ¾ú½À´Ï´Ù. ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼­ DLFM ¹é¾÷ µð·ºÅ丮¸¦ º¹¿øÇϽʽÿÀ.
DLFS ÆÄÀÏ ½Ã½ºÅÛ°ú DLFM ¹é¾÷ µð·ºÅ丮°¡ À¯½ÇµÇ¾ú½À´Ï´Ù.
  1. ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼­ DLFM ¹é¾÷ µð·ºÅ丮¸¦ º¹¿øÇϽʽÿÀ.
  2. ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼­ DLFS ÆÄÀÏ ½Ã½ºÅÛÀ» º¹¿øÇϽʽÿÀ.
  3. DB2 ¼­¹ö¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
       db2_recon_aid CROWN
    

DLFM_DB µ¥ÀÌÅͺ£À̽º, DLFM ¹é¾÷ µð·ºÅ丮 ¹× DLFS ÆÄÀÏ ½Ã½ºÅÛÀÌ À¯½ÇµÇ¾úÀ¸³ª DLFM_DB µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ ¹× ¸ðµç ·Î±× ÆÄÀÏÀº »ç¿ë°¡´ÉÇÕ´Ï´Ù.
  1. Data Links ¼­¹ö¿¡¼­ ¸ðµç Å×À̺íÀÌ DRP (Datalink_Reconcile_Pending) »óŰ¡ µÇµµ·Ï ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
       db2 "restore database dlfm_db"
       db2 "rollforward database dlfm_db to end of logs and stop"
     
    
  2. ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼­ DLFM ¹é¾÷ µð·ºÅ丮¸¦ º¹¿øÇϽʽÿÀ.
  3. ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼­ DLFS ÆÄÀÏ ½Ã½ºÅÛÀ» º¹¿øÇϽʽÿÀ.
  4. DB2 ¼­¹ö¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
       db2_recon_aid CROWN
    

DLFM_DB, DLFS ÆÄÀÏ ½Ã½ºÅÛ ¹× DLFM ¹é¾÷ µð·ºÅ丮°¡ À¯½ÇµÇ¾ú½À´Ï´Ù. DLFM_DB µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷Àº »ç¿ë°¡´ÉÇÏÁö¸¸ ¸ðµç ·Î±× ÆÄÀÏÀÌ »ç¿ë°¡´ÉÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù.
  1. Data Links ¼­¹ö¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
       db2 "restore database dlfm_db"
       db2 "rollforward database dlfm_db to end of logs and stop"
    
  2. ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼­ DLFM ¹é¾÷ µð·ºÅ丮¸¦ º¹¿øÇϽʽÿÀ.
  3. ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼­ DLFS ÆÄÀÏ ½Ã½ºÅÛÀ» º¹¿øÇϽʽÿÀ.
  4. DB2 ¼­¹ö¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
       db2_recon_aid CROWN
    

DB2 µ¥ÀÌÅͺ£À̽º, DLFM_DB µ¥ÀÌÅͺ£À̽º, DLFS ÆÄÀÏ ½Ã½ºÅÛ ¹× DLFM ¹é¾÷ µð·ºÅ丮°¡ À¯½ÇµÇ¾úÁö¸¸ DLFM_DB µ¥ÀÌÅͺ£À̽ºÀÇ ¹é¾÷ ¹× ¸ðµç ·Î±× ÆÄÀÏÀÌ »ç¿ë°¡´ÉÇÕ´Ï´Ù.
  1. Data Links ¼­¹ö¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
       db2 "restore database dlfm_db"
       db2 "rollforward database dlfm_db to end of logs and stop"
    
  2. ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼­ DLFM ¹é¾÷ µð·ºÅ丮¸¦ º¹¿øÇϽʽÿÀ.
  3. ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥¿¡¼­ DLFS ÆÄÀÏ ½Ã½ºÅÛÀ» º¹¿øÇϽʽÿÀ.
  4. DB2 ¼­¹ö¿¡¼­ ¸ðµç Å×À̺íÀÌ DRNP (Datalink_Reconcile_Not_Possbile) »óŰ¡ µÇµµ·Ï ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
       db2 "restore database CROWN"
       db2 "rollforward database CROWN to end of logs and stop"
       db2 "connect to CROWN"
     
    
  5. 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) »óÅ·Π¸¸µéÁö ¸øÇÕ´Ï´Ù. ÀÌ·¯ÇÑ ¸ðµç Å×ÀÌºí¿¡ ´ëÇØ¼­´Â Á¶Á¤ À¯Æ¿¸®Æ¼¸¦ ¼öÇàÇϽʽÿÀ.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]