Áú»¢¶Ä²©

1 §³§à§Ù§Õ§Ñ§ß§Ú§Ö §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç

§°§Ò§Ù§à§â

§¢§Ñ§Ù§Ñ §Õ§Ñ§ß§ß§í§ç Áú»¢¶Ä²© §Õ§à§Ý§Ø§ß§Ñ §Ò§í§ä§î §ã§à§Ù§Õ§Ñ§ß§Ñ §Ó §á§â§à§è§Ö§ã§ã§Ö §å§ã§ä§Ñ§ß§à§Ó§Ü§Ú Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ §Ú§Ý§Ú §á§â§à§Ü§ã§Ú.

§¿§ä§à§ä §â§Ñ§Ù§Õ§Ö§Ý §á§â§Ö§Õ§Ý§Ñ§Ô§Ñ§Ö§ä §Ú§ß§ã§ä§â§å§Ü§è§Ú§Ú §Õ§Ý§ñ §ã§à§Ù§Õ§Ñ§ß§Ú§ñ §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç Áú»¢¶Ä²©. §°§ä§Õ§Ö§Ý§î§ß§í§Û §ã§Ü§â§Ú§á§ä §ã§ç§Ö§Þ§í §á§à§ã§ä§Ñ§Ó§Ý§ñ§Ö§ä§ã§ñ §Õ§Ý§ñ §Ü§Ñ§Ø§Õ§à§Û §á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§Þ§à§Û §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç.

UTF-8 §ñ§Ó§Ý§ñ§Ö§ä§ã§ñ §Ö§Õ§Ú§ß§ã§ä§Ó§Ö§ß§ß§à§Û §Ü§à§Õ§Ú§â§à§Ó§Ü§à§Û, §Ü§à§ä§à§â§Ñ§ñ §á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§ä§ã§ñ Áú»¢¶Ä²©. §°§ß§Ñ, §Ü§Ñ§Ü §Ú§Ù§Ó§Ö§ã§ä§ß§à, §â§Ñ§Ò§à§ä§Ñ§Ö§ä §Ò§Ö§Ù §Ü§Ñ§Ü§Ú§ç-§Ý§Ú§Ò§à §á§â§à§Ò§Ý§Ö§Þ §ã §Ò§Ö§Ù§à§á§Ñ§ã§ß§à§ã§ä§î§ð. §±§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§Ú §Õ§à§Ý§Ø§ß§í §Ù§ß§Ñ§ä§î, §é§ä§à §ã§å§ë§Ö§ã§ä§Ó§å§ð§ä §Ú§Ù§Ó§Ö§ã§ä§ß§í§Ö §á§â§à§Ò§Ý§Ö§Þ§í §ã §Ò§Ö§Ù§à§á§Ñ§ã§ß§à§ã§ä§î§ð §á§â§Ú §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ß§Ú§Ú §ß§Ö§Ü§à§ä§à§â§í§ç §Õ§â§å§Ô§Ú§ç §Ü§à§Õ§Ú§â§à§Ó§à§Ü.

MySQL

§¥§Ý§ñ §ß§à§â§Þ§Ñ§Ý§î§ß§à§Û §â§Ñ§Ò§à§ä§í Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ §ã MySQL §Ò§Ñ§Ù§à§Û §Õ§Ñ§ß§ß§í§ç §ä§â§Ö§Ò§å§ð§ä§ã§ñ §Ü§à§Õ§Ú§â§à§Ó§Ü§Ñ utf8 §Ú utf8_bin §ä§Ú§á §ã§â§Ñ§Ó§ß§Ö§ß§Ú§ñ.

shell> mysql -uroot -p<§á§Ñ§â§à§Ý§î>
       mysql> create database zabbix character set utf8 collate utf8_bin;
       mysql> grant all privileges on zabbix.* to zabbix@localhost identified by '&±ô³Ù;§á§Ñ§â§à§Ý§î&²µ³Ù;';
       mysql> quit;

§¦§ã§Ý§Ú §Ó§í §Ú§ã§á§à§Ý§î§Ù§å§Ö§ä§Ö §á§Ñ§Ü§Ö§ä§í Áú»¢¶Ä²© §á§â§à§Õ§à§Ý§Ø§Ú§ä§Ö §à§Ù§ß§Ñ§Ü§à§Þ§Ý§Ö§ß§Ú§Ö §ã §Ú§ß§ã§ä§â§å§Ü§è§Ú§ñ§Þ§Ú §Õ§Ý§ñ Debian/Ubuntu §Ú§Ý§Ú RHEL/CentOS, §é§ä§à§Ò§í §Ú§Þ§á§à§â§ä§Ú§â§à§Ó§Ñ§ä§î §Õ§Ñ§ß§ß§í§Ö §Ó §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç.

shell> cd database/mysql
       shell> mysql -uzabbix -p<§á§Ñ§â§à§Ý§î> zabbix < schema.sql
       # §à§ã§ä§Ñ§ß§à§Ó§Ú§ä§Ö§ã§î §Ù§Õ§Ö§ã§î, §Ö§ã§Ý§Ú §Ó§í §ã§à§Ù§Õ§Ñ§Ö§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Õ§Ý§ñ Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú
       shell> mysql -uzabbix -p<§á§Ñ§â§à§Ý§î> zabbix < images.sql
       shell> mysql -uzabbix -p<§á§Ñ§â§à§Ý§î> zabbix < data.sql

PostgreSQL

§µ §Ó§Ñ§ã §Õ§à§Ý§Ø§ß§Ñ §Ò§í§ä§î §Ò§Ñ§Ù§Ñ §Õ§Ñ§ß§ß§í§ç §ã §á§â§Ñ§Ó§Ñ§Þ§Ú §ã§à§Ù§Õ§Ñ§ß§Ú§ñ §à§Ò§ì§Ö§Ü§ä§à§Ó §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç. §³§Ý§Ö§Õ§å§ð§ë§Ñ§ñ §Ü§à§Þ§Ñ§ß§Õ§Ñ §Ü§à§Þ§Ñ§ß§Õ§ß§à§Û §à§Ò§à§Ý§à§é§Ü§Ú §ã§à§Ù§Õ§Ñ§ã§ä zabbix. §©§Ñ§Õ§Ñ§Û§ä§Ö §á§Ñ§â§à§Ý§î §á§â§Ú §á§à§ñ§Ó§Ý§Ö§ß§Ú§Ú §Ù§Ñ§á§â§à§ã§Ñ §Ú §Ù§Ñ§ä§Ö§Þ §á§à§Ó§ä§à§â§Ú§ä§Ö §ï§ä§à§ä §á§Ñ§â§à§Ý§î (§à§Ò§â§Ñ§ä§Ú§ä§Ö §Ó§ß§Ú§Þ§Ñ§ß§Ú§Ö, §é§ä§à §ã§ß§Ñ§é§Ñ§Ý§Ñ §Ó§à§Ù§Þ§à§Ø§ß§à §å §Ó§Ñ§ã §Ò§å§Õ§Ö§ä §Ù§Ñ§á§â§à§ê§Ö§ß §á§Ñ§â§à§Ý§î §Õ§Ý§ñ sudo):

shell> sudo -u postgres createuser --pwprompt zabbix

§´§Ö§á§Ö§â§î §Þ§í §ß§Ñ§ã§ä§â§à§Ú§Þ §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç zabbix (§á§à§ã§Ý§Ö§Õ§ß§Ú§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â) §ã §â§Ñ§ß§Ö§Ö §ã§à§Ù§Õ§Ñ§ß§ß§í§Þ §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§Ö§Þ §Ó §Ü§Ñ§é§Ö§ã§ä§Ó§Ö §Ó§Ý§Ñ§Õ§Ö§Ý§î§è§Ñ (-O zabbix) §Ú §Ú§Þ§á§à§â§ä§Ú§â§å§Ö§Þ §Ú§Ù§ß§Ñ§é§Ñ§Ý§î§ß§å§ð §ã§ç§Ö§Þ§å §Ú §Õ§Ñ§ß§ß§í§Ö (§á§â§Ö§Õ§á§à§Ý§Ñ§Ô§Ñ§Ö§ä§ã§ñ, §é§ä§à §Ó§í §ß§Ñ§ç§à§Õ§Ú§ä§Ö§ã§î §Ó §Ü§à§â§ß§Ö§Ó§à§Û §á§Ñ§á§Ü§Ö §Ú§ã§ç§à§Õ§ß§í§ç §Ü§à§Õ§à§Ó Áú»¢¶Ä²©):

shell> sudo -u postgres createdb -O zabbix -E Unicode -T template0 zabbix

§¦§ã§Ý§Ú §Ó§í §Ú§ã§á§à§Ý§î§Ù§å§Ö§ä§Ö §á§Ñ§Ü§Ö§ä§í Áú»¢¶Ä²© §á§â§à§Õ§à§Ý§Ø§Ú§ä§Ö §à§Ù§ß§Ñ§Ü§à§Þ§Ý§Ö§ß§Ú§Ö §ã §Ú§ß§ã§ä§â§å§Ü§è§Ú§ñ§Þ§Ú §Õ§Ý§ñ Debian/Ubuntu §Ú§Ý§Ú RHEL/CentOS, §é§ä§à§Ò§í §Ú§Þ§á§à§â§ä§Ú§â§à§Ó§Ñ§ä§î §Õ§Ñ§ß§ß§í§Ö §Ó §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç.

shell> cd database/postgresql
       shell> cat schema.sql | sudo -u zabbix psql zabbix
       # §à§ã§ä§Ñ§ß§à§Ó§Ú§ä§Ö§ã§î §Ù§Õ§Ö§ã§î, §Ö§ã§Ý§Ú §Ó§í §ã§à§Ù§Õ§Ñ§Ö§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Õ§Ý§ñ Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú.
       shell> cat images.sql | sudo -u zabbix psql zabbix
       shell> cat data.sql | sudo -u zabbix psql zabbix

TimescaleDB

§®§í §á§â§Ö§Õ§á§à§Ý§Ñ§Ô§Ñ§Ö§Þ, §é§ä§à §â§Ñ§ã§ê§Ú§â§Ö§ß§Ú§Ö TimescaleDB §å§Ø§Ö §å§ã§ä§Ñ§ß§à§Ó§Ý§Ö§ß§à §Ó §Ò§Ñ§Ù§Ö §Õ§Ñ§ß§ß§í§ç (§ã§Þ§à§ä§â§Ú§ä§Ö ).

§²§Ñ§ã§ê§Ú§â§Ö§ß§Ú§Ö TimescaleDB §ä§Ñ§Ü§Ø§Ö §Õ§à§Ý§Ø§ß§à §Ò§í§ä§î §Ó§Ü§Ý§ð§é§Ö§ß§à §Õ§Ý§ñ §Ü§à§ß§Ü§â§Ö§ä§ß§à§Û §¢§¥, §é§ä§à§Ò§í §ï§ä§à §ã§Õ§Ö§Ý§Ñ§ä§î §Ó§í§á§à§Ý§ß§Ú§ä§Ö:

echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbix

§£§í§á§à§Ý§ß§Ö§ß§Ú§Ö §ï§ä§à§Û §Ü§à§Þ§Ñ§ß§Õ§í §ä§â§Ö§Ò§å§Ö§ä §á§â§Ú§Ó§Ú§Ý§Ö§Ô§Ú§Ú §Ñ§Õ§Þ§Ú§ß§Ú§ã§ä§â§Ñ§ä§à§â§Ñ §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç.

§³§Ü§â§Ú§á§ä timescaledb.sql §â§Ñ§Ù§Þ§Ö§ë§Ö§ß §Ó database/postgresql. §¿§ä§à§ä §ã§Ü§â§Ú§á§ä §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§à §Ó§í§á§à§Ý§ß§Ú§ä§î §á§à§ã§Ý§Ö §ä§à§Ô§à, §Ü§Ñ§Ü §ã§à§Ù§Õ§Ñ§ß§Ñ §à§Ò§í§é§ß§Ñ§ñ §Ò§Ñ§Ù§Ñ §Õ§Ñ§ß§ß§í§ç PostgreSQL §ã §Ú§Ù§ß§Ñ§é§Ñ§Ý§î§ß§í§Þ§Ú §Õ§Ñ§ß§ß§í§Þ§Ú schema/data (§ã§Þ§à§ä§â§Ú§ä§Ö §â§Ñ§Ù§Õ§Ö§Ý §Ó§í§ê§Ö):

cat timescaledb.sql | sudo -u zabbix psql zabbix

§°§Ò§â§Ñ§ä§Ú§ä§Ö §Ó§ß§Ú§Þ§Ñ§ß§Ú§Ö, §é§ä§à §ã§Ü§â§Ú§á§ä timescaledb.sql §Ù§Ñ§Õ§Ñ§Ö§ä §ã§Ý§Ö§Õ§å§ð§ë§Ú§Ö §á§Ñ§â§Ñ§Þ§Ö§ä§â§í §á§â§à§è§Ö§ã§ã§å §à§é§Ú§ã§ä§Ü§Ú §Ú§ã§ä§à§â§Ú§Ú (§ã §¡§Õ§Þ§Ú§ß§Ú§ã§ä§â§Ú§â§à§Ó§Ñ§ß§Ú§Ö ¡ú §°§Ò§ë§Ú§Ö ¡ú §°§é§Ú§ã§ä§Ü§Ñ §Ú§ã§ä§à§â§Ú§Ú):

• §±§Ö§â§Ö§à§á§â§Ö§Õ§Ö§Ý§Ú§ä§î §á§Ö§â§Ú§à§Õ §ç§â§Ñ§ß§Ö§ß§Ú§ñ §Ú§ã§ä§à§â§Ú§Ú §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Õ§Ñ§ß§ß§í§ç
• §±§Ö§â§Ö§à§á§â§Ö§Õ§Ö§Ý§Ú§ä§î §á§Ö§â§Ú§à§Õ §ç§â§Ñ§ß§Ö§ß§Ú§ñ §Õ§Ú§ß§Ñ§Þ§Ú§Ü§Ú §Ú§Ù§Þ§Ö§ß§Ö§ß§Ú§ñ §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Õ§Ñ§ß§ß§í§ç

§£ §ã§Ý§å§é§Ñ§Ö §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ß§Ú§ñ §à§é§Ú§ã§ä§Ü§Ú §Ú§ã§ä§à§â§Ú§Ú §ã §á§Ñ§â§ä§Ú§è§Ú§à§ß§Ú§â§à§Ó§Ñ§ß§Ú§Ö§Þ §Õ§Ý§ñ §Ú§ã§ä§à§â§Ú§Ú §Ú §Õ§Ú§ß§Ñ§Þ§Ú§Ü§Ú §Ú§Ù§Þ§Ö§ß§Ö§ß§Ú§Û §à§Ò§Ö §ï§ä§Ú §à§á§è§Ú§Ú §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§à §Ñ§Ü§ä§Ú§Ó§Ú§â§à§Ó§Ñ§ä§î. §ª§Þ§Ö§Ö§ä§ã§ñ §Ó§à§Ù§Þ§à§Ø§ß§à§ã§ä§î §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ä§î TimescaleDB §á§Ñ§â§ä§Ú§è§Ú§à§ß§Ú§â§à§Ó§Ñ§ß§Ú§Ö §ä§à§Ý§î§Ü§à §Õ§Ý§ñ §Õ§Ú§ß§Ñ§Þ§Ú§Ü§Ú §Ú§Ù§Þ§Ö§ß§Ö§ß§Ú§Û (§å§ã§ä§Ñ§ß§à§Ó§Ú§Ó §ß§Ñ§ã§ä§â§à§Û§Ü§å §±§Ö§â§Ö§à§á§â§Ö§Õ§Ö§Ý§Ú§ä§î §á§Ö§â§Ú§à§Õ §ç§â§Ñ§ß§Ö§ß§Ú§ñ §Õ§Ú§ß§Ñ§Þ§Ú§Ü§Ú §Ú§Ù§Þ§Ö§ß§Ö§ß§Ú§ñ §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Õ§Ñ§ß§ß§í§ç) §Ú§Ý§Ú §ä§à§Ý§î§Ü§à §Õ§Ý§ñ §Ú§ã§ä§à§â§Ú§Ú (§±§Ö§â§Ö§à§á§â§Ö§Õ§Ö§Ý§Ú§ä§î §á§Ö§â§Ú§à§Õ §ç§â§Ñ§ß§Ö§ß§Ú§ñ §Ú§ã§ä§à§â§Ú§Ú §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Õ§Ñ§ß§ß§í§ç).

Oracle

§®§í §á§à§Ý§Ñ§Ô§Ñ§Ö§Þ, §é§ä§à §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§î zabbix §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç §ã §á§Ñ§â§à§Ý§Ö§Þ §á§Ñ§â§à§Ý§î §å§Ø§Ö §ã§å§ë§Ö§ã§ä§Ó§å§Ö§ä §Ú §Ú§Þ§Ö§Ö§ä §á§â§Ñ§Ó§Ñ §ß§Ñ §ã§à§Ù§Õ§Ñ§ß§Ú§Ö §à§Ò§ì§Ö§Ü§ä§à§Ó §Ó ORCL §ã§Ý§å§Ø§Ò§Ö, §â§Ñ§ã§á§à§Ý§à§Ø§Ö§ß§ß§à§Û §ß§Ñ §ç§à§ã§ä §ã§Ö§â§Ó§Ö§â§Ö §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç Oracle c shell §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§Ö§Þ §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§î, §Ü§à§ä§à§â§í§Û §Ú§Þ§Ö§Ö§ä §Õ§à§ã§ä§å§á §Ó §á§Ñ§á§Ü§å /tmp. Áú»¢¶Ä²© §ä§â§Ö§Ò§å§Ö§ä §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Ó §À§ß§Ú§Ü§à§Õ §Ü§à§Õ§Ú§â§à§Ó§Ü§Ö §Ú §ß§Ñ§è§Ú§à§ß§Ñ§Ý§î§ß§å§ð §Ü§à§Õ§Ú§â§à§Ó§Ü§å UTF8. §±§â§à§Ó§Ö§â§î§ä§Ö §ä§Ö§Ü§å§ë§Ú§Ö §ß§Ñ§ã§ä§â§à§Û§Ü§Ú:

sqlplus> select parameter,value from v$nls_parameters where parameter='NLS_CHARACTERSET' or parameter='NLS_NCHAR_CHARACTERSET';

§¦§ã§Ý§Ú §Ó§í §ã§à§Ù§Õ§Ñ§Ö§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Õ§Ý§ñ Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â§Ñ §Ó§Ñ§Þ §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§à §á§à§Þ§Ö§ã§ä§Ú§ä§î §Ü§å§Õ§Ñ-§ä§à §Ú§Ù§à§Ò§â§Ñ§Ø§Ö§ß§Ú§ñ §ß§Ñ §ç§à§ã§ä §ã Oracle §Ú§Ù §Ú§ã§ç§à§Õ§ß§í§ç §Ü§à§Õ§à§Ó Áú»¢¶Ä²©. §³§Ü§à§á§Ú§â§å§Û§ä§Ö §Ú§ç §Ó /tmp/zabbix_images §á§Ñ§á§Ü§å §ß§Ñ §ç§à§ã§ä§Ö §ã Oracle:

shell> cd /§á§å§ä§î/§Ü/§Ú§ã§ç§à§Õ§ß§í§Þ/§Ü§à§Õ§Ñ§Þ/zabbix
       shell> ssh user@oracle_host "mkdir /tmp/zabbix_images"
       shell> scp -r misc/images/png_modern user@oracle_host:/tmp/zabbix_images/

§´§Ö§á§Ö§â§î §á§à§Õ§Ô§à§ä§à§Ó§î§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç:

shell> cd /§á§å§ä§î/§Ü/§Ú§ã§ç§à§Õ§ß§í§Þ/§Ü§à§Õ§Ñ§Þ/zabbix/database/oracle
       shell> sqlplus zabbix/§á§Ñ§â§à§Ý§î@oracle_host/ORCL
       sqlplus> schema.sql
       # §à§ã§ä§Ñ§ß§à§Ó§Ú§ä§Ö§ã§î §Ù§Õ§Ö§ã§î, §Ö§ã§Ý§Ú §Ó§í §ã§à§Ù§Õ§Ñ§Ö§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Õ§Ý§ñ Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú
       sqlplus> images.sql
       sqlplus> data.sql

§´§Ö§á§Ö§â§î §Ó§â§Ö§Þ§Ö§ß§ß§å§ð §á§Ñ§á§Ü§å §Þ§à§Ø§ß§à §å§Õ§Ñ§Ý§Ú§ä§î:

shell> ssh user@oracle_host "rm -rf /tmp/zabbix_images"

IBM DB2

shell> db2 "create database zabbix using codeset utf-8 territory us pagesize 32768"
       shell> cd database/ibm_db2
       shell> db2batch -d zabbix -f schema.sql
       # §à§ã§ä§Ñ§ß§à§Ó§Ú§ä§Ö§ã§î §Ù§Õ§Ö§ã§î, §Ö§ã§Ý§Ú §Ó§í §ã§à§Ù§Õ§Ñ§Ö§ä§Ö §Ò§Ñ§Ù§å §Õ§Ñ§ß§ß§í§ç §Õ§Ý§ñ Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú
       shell> db2batch -d zabbix -f images.sql
       shell> db2batch -d zabbix -f data.sql -l ';;'

§£§Ö§Ò-§Ú§ß§ä§Ö§â§æ§Ö§Û§ã Áú»¢¶Ä²© §Ú§ã§á§à§Ý§î§Ù§å§Ö§ä §å§ã§Ý§à§Ó§Ú§ñ OFFSET §Ú LIMIT §Ó SQL §Ù§Ñ§á§â§à§ã§Ñ§ç. §¹§ä§à§Ò§í §à§ß§Ú §â§Ñ§Ò§à§ä§Ñ§Ý§Ú, IBM DB2 §ã§Ö§â§Ó§Ö§â §Õ§à§Ý§Ø§Ö§ß §Ú§Þ§Ö§ä§î §á§Ö§â§Ö§Þ§Ö§ß§ß§å§ð DB2_COMPATIBILITY_VECTOR §Ù§Ñ§Õ§Ñ§ß§ß§å§ð §Ù§ß§Ñ§é§Ö§ß§Ú§Ö§Þ 3. §£§í§á§à§Ý§ß§Ú§ä§Ö §ã§Ý§Ö§Õ§å§ð§ë§å§ð §Ü§à§Þ§Ñ§ß§Õ§å §á§Ö§â§Ö§Õ §Ù§Ñ§á§å§ã§Ü§à§Þ §ã§Ö§â§Ó§Ö§â§Ñ §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç:

shell> db2set DB2_COMPATIBILITY_VECTOR=3

SQLite

§ª§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ß§Ú§Ö SQLite §á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§ä§ã§ñ §ä§à§Ý§î§Ü§à §ß§Ñ Áú»¢¶Ä²© §á§â§à§Ü§ã§Ú!

shell> cd database/sqlite3
       shell> sqlite3 /var/lib/sqlite/zabbix.db < schema.sql

§£§Ö§â§ß§å§ä§î§ã§ñ §Ó §â§Ñ§Ù§Õ§Ö§Ý §å§ã§ä§Ñ§ß§à§Ó§Ü§Ú.