db2setup À¯Æ¿¸®Æ¼°¡ ½Ã½ºÅÛ¿¡ DB2 Data Links ManagerÀÇ ¼³Ä¡¸¦ ¿Ï·áÇßÀ¸¸é, ½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮ÀÇ ³»¿ëÀ» ³ª¿ÇÏ¿© DLFM_DB µ¥ÀÌÅͺ£À̽º°¡ ¿Ã¹Ù·Î ÀÛ¼º ¹× īŻ·Î±×È µÇ´ÂÁö È®ÀÎÇØ¾ß ÇÕ´Ï´Ù. ÀÌ µ¥ÀÌÅͺ£À̽º°¡ Á¸ÀçÇÏ´ÂÁö È®ÀÎÇßÀ¸¸é, ÀÀ±Þ º¹±¸¸¦ µ½°í µ¥ÀÌÅÍ ¹«°á¼ºÀ» º¸È£Çϱâ À§ÇØ ¹é¾÷ ¹× º¹±¸ ½ºÅ°¸¶¸¦ ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.
DLFM_DB µ¥ÀÌÅͺ£À̽º°¡ ¿Ã¹Ù·Î ÀÛ¼º ¹× īŻ·Î±×ȵǾú´ÂÁö È®ÀÎÇϽʽÿÀ.
. INSTHOME/sqllib/db2profile (bash, Bourne ¶Ç´Â Korn ½©ÀÇ °æ¿ì) source INSTHOME/sqllib/db2cshrc (C ½©ÀÇ °æ¿ì)
¿©±â¼ INSTHOMEÀº ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ È¨ µð·ºÅ丮ÀÔ´Ï´Ù.
db2 list database directory
ÀÌ ¸í·ÉÀº ´ÙÀ½°ú À¯»çÇÑ Ãâ·ÂÀ» ¸®ÅÏÇÕ´Ï´Ù.
½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 µð·ºÅ丮 ³» Ç׸ñÀÇ ¼ö = 1 µ¥ÀÌÅͺ£À̽º 1 Ç׸ñ: µ¥ÀÌÅͺ£À̽º º°¸í = DLFM_DB µ¥ÀÌÅͺ£À̽º À̸§ = DLFM_DB Áö¿ª µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 = /home/dlfm µ¥ÀÌÅͺ£À̽º ¸±¸®½º ·¹º§ = 9.00 ÁÖ¼® = µð·ºÅ丮 Ç׸ñ À¯Çü = °£Á¢ (1) īŻ·Î±× ³ëµå ¹øÈ£ = 0
DCE-DFS ȯ°æÀÇ DLFM ¼¹ö ³ëµå¿¡¼ db2 list database directory ¸í·ÉÀº À§ÀÇ ¿¹¿Í À¯»çÇÑ Ãâ·ÂÀ» ¸®ÅÏÇÕ´Ï´Ù. DLFM Ŭ¶óÀÌ¾ðÆ® ³ëµå¿¡¼ ÀÌ ¸í·ÉÀº µð·ºÅ丮 Ç׸ñ À¯ÇüÀÌ ¿ø°ÝÀ̶ó´Â Á¡À» Á¦¿ÜÇϰí À§ÀÇ ¿¹¿Í À¯»çÇÑ Ãâ·ÂÀ» ¸®ÅÏÇÕ´Ï´Ù. ÀÌ µ¥ÀÌÅͺ£À̽º°¡ ¾øÀ¸¸é, Data Links ¼¹ö¿¡¼ DB2 µ¥ÀÌÅͺ£À̽º ÀÛ¼º ¹× »èÁ¦¸¦ ÂüÁ¶ÇϽʽÿÀ.
DATALINK °ªÀÌ º¹±¸¿ëÀ¸·Î Á¤ÀÇµÈ DATALINK Ä÷³ÀÌ ÀÖ´Â Å×ÀÌºí¿¡ »ðÀ﵃ ¶§¸¶´Ù, Data Links ¼¹ö¿¡ ÀÖ´Â ÇØ´ç DATALINK ÆÄÀÏÀÌ ¾ÆÄ«ÀÌºê ¼¹ö·Î ¹é¾÷µÇµµ·Ï ½ºÄÉÁìµË´Ï´Ù. ÇöÀç, ¾ÆÄ«ÀÌºê ¼¹ö·ÎÀÇ ÆÄÀÏ ¹é¾÷À» À§ÇØ Áö¿øµÇ´Â µÎ °¡Áö ¿É¼ÇÀº µð½ºÅ© º¹»ç(±âº» ¹æ¹ý)¿Í Tivoli Storage ManagerÀÔ´Ï´Ù. ÇâÈÄ DB2 Data Links Manager ¸±¸®½º´Â ´ÙÀ½ º¥´õÀÇ ¹é¾÷ ¸Åü¿Í ¼ÒÇÁÆ®¿þ¾îµµ Áö¿øÇÒ °ÍÀÔ´Ï´Ù.
DB2 ¼¹ö¿¡ backup ¸í·ÉÀÌ ÀÔ·ÂµÈ °æ¿ì, µ¥ÀÌÅͺ£À̽ºÀÇ ¸µÅ©µÈ ÆÄÀÏÀÌ Data Links ¼¹ö¿¡¼ DLFM_BACKUP_DIR_NAME ·¹Áö½ºÆ®¸® º¯¼ö°¡ ÁöÁ¤ÇÏ´Â µð·ºÅ丮·Î ¹é¾÷µË´Ï´Ù.
ÀÌ ·¹Áö½ºÆ®¸® º¯¼öÀÇ ±âº» ¼³Á¤Àº ¹é¾÷ µð·ºÅ丮¸¦ INSTHOME/dlfm_backupÀ¸·Î ¼³Á¤ÇÏ´Â °ÍÀÔ´Ï´Ù. ¿©±â¼ INSTHOMEÀº DB2 Data Links Manager °ü¸®ÀÚÀÇ È¨ µð·ºÅ丮ÀÔ´Ï´Ù.
DCE-DFS ȯ°æ¿¡¼, ÀÌ ·¹Áö½ºÆ®¸® º¯¼öÀÇ ±âº» ¼³Á¤Àº ¹é¾÷ µð·ºÅ丮¸¦ /:/dlfm_backup·Î ¼³Á¤ÇÏ´Â °ÍÀÔ´Ï´Ù. ÀÌ µð·ºÅ丮´Â DFS ÆÄÀÏ ¼¼Æ®¿©¾ß ÇÕ´Ï´Ù. DFS ȯ°æ¿¡¼ÀÇ µð½ºÅ© ¹é¾÷À» À§ÇÑ ¼º´É Çâ»ó¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
DLFM_BACKUP_DIR_NAME ·¹Áö½ºÆ®¸® º¯¼ö¸¦ º¯°æÇÏ·Á¸é db2set ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
¿¹¸¦ µé¾î, ¹é¾÷ ÆÄÀÏÀÌ /home/backup µð·ºÅ丮¿¡ ÀúÀåµÇµµ·Ï DLFM_BACKUP_DIR_NAME ·¹Áö½ºÆ®¸® º¯¼ö¸¦ ¼³Á¤ÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
mkdir /home/backup chown dlfmid.dlfmgroup /home/backup db2set DLFM_BACKUP_TARGET=LOCAL db2set DLFM_BACKUP_DIR_NAME=/home/backup dlfm stop dlfm startDLFM_BACKUP_DIR_NAME ·¹Áö½ºÆ®¸® º¯¼ö¿¡ ÀÇÇØ ÁöÁ¤µÈ À§Ä¡¸¦ º¯°æÇϱâ·Î ÇÑ °æ¿ì, ÁöÁ¤µÈ µð·ºÅ丮°¡ Data Links Filesystem Filter »ç¿ë ÆÄÀÏ ½Ã½ºÅÛ¿¡ À§Ä¡ÇÏÁö ¾Êµµ·Ï ÇØ¾ß Çϸç ÁöÁ¤µÈ µð·ºÅ丮¿¡ ¹é¾÷ ÆÄÀÏ¿ë Çʼö °ø°£ÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
NFS ¸¶¿îÆ®µÈ µð·ºÅ丮´Â ÁöÁ¤ÇÏÁö ¾Ê´Â °ÍÀÌ ÁÁ½À´Ï´Ù. NFS ¸¶¿îÆ®µÈ µð·ºÅ丮¸¦ ÁöÁ¤ÇÒ °æ¿ì, ÀÌ ÆÄÀÏ ¼¹ö¿¡¼ ·çÆ® ±ÇÇÑÀ» °®´Â ¸ðµç »ç¿ëÀÚ À̸§ÀÌ ÀÌ ¸¶¿îÆ®µÈ µð·ºÅ丮¿¡ ´ëÇÑ ÀÐ±â ¹× ¾²±â ¾×¼¼½º ±ÇÇÑÀ» °®´ÂÁö È®ÀÎÇϽʽÿÀ. ÀÌ µð·ºÅ丮°¡ NFS ¸¶¿îÆ® ¹× ³»º¸³»±âµÈ ¸Ó½Å¿¡ DB2 Data Links Manager °ü¸®ÀÚÀÇ »ç¿ëÀÚ À̸§µµ Á¸ÀçÇØ¾ß ÇÕ´Ï´Ù.
¾ÆÄ«ÀÌºê ¼¹ö·Î¼ Tivoli Storage Manager¸¦ »ç¿ëÇÏ·Á¸é, ´ÙÀ½°ú °°ÀÌ ¼öÇàÇϽʽÿÀ.
(Bash, Bourne ¶Ç´Â Korn ½©ÀÇ °æ¿ì) export DSMI_DIR=/usr/lpp/tsm/bin export DSMI_CONFIG=$HOME/tsm/dsm.opt export DSMI_LOG=$HOME/dldump export PATH=$PATH:/usr/lpp/tsm/bin (C ½©ÀÇ °æ¿ì) setenv DSMI_DIR /usr/lpp/tsm/bin setenv DSMI_CONFIG ${HOME}/tsm/dsm.opt setenv DSMI_LOG ${HOME}/dldump setenv PATH=${PATH}:/usr/lpp/tsm/bin
ÁÖ:
¾ÆÄ«ÀÌºê ¼¹ö·Î¼ XBSA ÀúÀ念¿ª °ü¸® ÇÁ·Î±×·¥À» »ç¿ëÇÏ·Á¸é,
(bash, Bourne ¶Ç´Â Korn ½©ÀÇ °æ¿ì) export NSR_SERVER=fully_qualified_server_hostname (C ½©ÀÇ °æ¿ì) setenv NSR_SERVER=fully_qualified_server_hostname
ÁÖ: | ¶óÀ̺귯¸® À̸§Àº ¶óÀ̺귯¸®¿¡ ÀÖ´Â »ç¿ëÇÒ °øÀ¯ ¿ÀºêÁ§Æ®µµ ÁöÁ¤Çؾß
ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, Legato¸¦ ÀÌ¿ëÇÏ¿©,
db2set DLFM_BACKUP_TARGET_LIBRARY=/usr/lib/libxdb2.a(bsashr10.0) ÇÊ¿äÇÑ Æ¯Á¤ ¼³Á¤°ªÀº XBSA º¥´õ¿¡ ¹®ÀÇÇϽʽÿÀ. |
Data Links Manager ¼¹ö¿¡¼ ´ÙÀ½ÀÇ ´Ü°è¸¦ ¼öÇàÇÏ¿© ¼³Ä¡¸¦ ¿Ï·áÇϽʽÿÀ.
stop.dfs all start.dfs all
Data Links Manager Ŭ¶óÀÌ¾ðÆ®¿¡¼´Â ´ÙÀ½ÀÇ ´Ü°è¸¦ ¼öÇàÇÏ¿© ¼³Ä¡¸¦ ¿Ï·áÇϽʽÿÀ.
stop.dfs all start.dfs all
ÀÌÁ¦ DB2 Data Links Manager ȯ°æÀ» ¼³Á¤ÇÏ°í ¼³Ä¡¸¦ È®ÀÎÇÒ Áغñ°¡ µÇ¾ú½À´Ï´Ù. AIX¿¡¼ ¼³Ä¡ È®Àο¡¼ ÀÚ¼¼ÇÑ »çÇ×À» ÂüÁ¶ÇϽʽÿÀ.