Database Management and Programing Article

  1øö 

  ݿ ý ݿ ε ͳ ݿ ־ ݿ Ӧ ε ͳ ݷ ֿ ã Դ فخم ݿ ε ͳ ŻĿġ £ 

  2Ӫ ε ͳ ݿ ʾ ý 

  2.1 Biao ݿ ռ ä 

  Õ ˼ 룬 ݿ ε ͳ ֱ ǣ º 

  rootdbs: informix ε ͳ ǽ һ ŻÄe1_1dbs4 Ϊ ˱ ڼ ǽ ȡ Ϊ yxroot £ 

  Ϊ º 

  # Ln / dev/re1_1dbs4 / dev / yx_root 

  # chown informix: informix / dev / yx_root 

  # chmod 664 / dev / yx_root 

  logdbs: informix ־ ǽ һ ŻÄe1_1dbs5 Ϊ ˱ ڼ ǽ ȡ Ϊ yx_log £ 

  Ϊ º 

  # Ln / dev/re1_1dbs5 / dev / yx_log 

  # chown informix: informix / dev / yx_log 

  # chmod 664 / dev / yx_log 

  workdbs: informixǽ һ ŻÄe1_1dbs0 ½ e1_1dbs3 Ϊ ˱ ڼ ǽ ȡ Ϊ yx_work £ 

  Ϊ º 

  # Ln / dev/re1_1dbs0 / dev/yx_dbs0 

  # Ln / dev/re1_1dbs1 / dev/yx_dbs1 

  # chown informix: informix / dev / yx_dbs? 

  # chmod 664 / dev / yx_dbs? 

  2.2 Informix ε ͳ à

  informix ε ͳ ļļ º 

  2.2.1 Informix ļ º start_yx ļ £ º 

  echo "start dbserver on yx" 

  INFORMIXDIR = / usr / informix 

  export INFORMIXDIR 

  TBCONFIG = tbconfig.yx 

  DBDATE = Y4MD / 

  PATH = $ PATH: $ INFORMIXDIR / bin:. 

  export PATH MAIL TBCONFIG 

  2.2.2 Informix ļ º $ INFORMIXDIR / etc / tbconfig.yx 

  $ Cd $ INFORMIXDIR / etc 

  $ Cp tbconfig.std tbconfig.yx 

  $ Vi tbconfig.yx 

  ޸ Ӧ ý: 

  ROOTPATH / dev / yx_root 

  ROOTSIZE 1000000 

  TAPEDEV / dev / null 

  PHYSFILE 100000 

  LOGSIZE 100000 

  LOGFILES 3 

  LOGSIZE 100000 

  MSGPATH / usr / informix / online_yx.log 

  CONSOLE / dev / console 

  SERVERNUM 0 

  DBSERVERNAME XXclic_yx 

  # ע: XX: ȡ 

  # Ý: fz ï: pt Ȫ Ý: qz Ý: zz Ò: ly 

  # ÷: sm ƽ: np Â: nd 

  USERS 300 

  TRANSACTIONS 300 

  LOCKS 200000 

  BUFFERS 20000 

  TBLSPACES 6000 

  LOGSMAX 60 

  2.2.3 Informix ļ º $ INFORMIXDIR / etc / sqlhosts.yx 

  Ļ ֻ ÚC / Sģ ʽ º ݿ õ ½ (Ô) 

  2.3 Informix ʼ º 

  1 ® ε ͳ º 

  Ôinformix û ¼ 

  º #.. / Start_yx 

  2 ® ʼ ݿ ε ͳ ø 

  º tbinit-i 

  3 ® ݿ ־ ͹ ø 

  tbspaces ¨ Cc ¨ Cd yx_log ¨ Cp / dev / yx_log ¨ Co 0 ¨ Cs 870000 

  tbspaces ¨ Cc ¨ Cd yx_work ¨ Cp / dev/yx_dbs0-o 0 ¨ Cs 2000000 

  tbspaces ¨ Ca yx_work ¨ Cp / dev/yx_dbs1-o 0 ¨ Cs 2000000 

  4 ® ƶ ݿ ε ͳ ־ μ ݿ ־ ø 

  a.Úlogdbs ߼ ־ ߼ ־ ȡ 600Mÿ ־ 100 MÖ6 £ º 

  $ Tbmode ¨ Csy 

  ظ ִ й ² 6Π

  $ Tbparams ¨ Ca ¨ Cd yx_log 

  b. ¼ ӵ ߼ ־ Ч 

  tbtape ¨ Cs # ÷ 0Ý 

  c.Ǩ ־־ Ï 

  tbmode ¨ Cl 

  ظ ִ й ² 3Π

  d. ɾ ýrootdbs ε ߼ ־ 

  tbtape ¨ Cs # ÷ 0Ý 

  tbparams ¨ Cd ¨ Cl 1-y 

  tbparams ¨ Cd ¨ Cl 2-y 

  tbparams ¨ Cd ¨ Cl 3 ¨ Cy 

  e.Ǩ ־ ½ logdbsÏ 

  tbparams ¨ Cp ¨ Cs 182000 ¨ Cd yx_log ¨ Cy 

  f. ָ Zhi 

  ޸ Ätbconfig.yxļþ, ² Ϊ: 

  TAPEDEV / dev/rct0 

  LTAPEDEV / dev/rct0 

  5 ® ݵ ݿ ݣ ø 

  dbimport ¨ Cd yx_work rhdb 

  6 ® Ӫ ε ͳ ݿ Զ ͣ ÷ 

  Զ ༭ / etc/rc2.d/S99startdbsļ У º 

  echo "start dbserver on yx" 

  DBDATE = Y4MD 

  TBCONFIG = tbconfig.yx 

  PATH = $ PATH: $ INFORMIXDIR / bin:. 

  export INFORMIXSERVER 

  export PATH MAIL TBCONFIG DBDATE 

  su informix-c "$ INFORMIXDIR / bin / tbinit" 

  echo "start dbsever on yx is over" 

  Զ ͣ ֹ ༭ / etc / shutdown.d / shut_dbsļ дУ º 

  echo "shut dbserver on yx" 

  DBDATE = Y4MD 

  TBCONFIG = tbconfig.yx 

  PATH = $ PATH: $ INFORMIXDIR / bin:. 

  export INFORMIXSERVER 

  export PATH MAIL TBCONFIG DBDATE 

  su informix-c "$ INFORMIXDIR / bin / tbmode-ky" 

  echo "shut dbsever on yx is over" 

  ² 2 ҳ: 1 [2] һҳ 

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.