[root@newifx rpm]# ls | grep sysst
sysstat- 5 . 0 . 5 - 11 .rhel4.i386.rpm
[root@newifx rpm]# rpm -i sysstat- 5 . 0 . 5 - 11 .rhel4.i386.rpm
warning: sysstat- 5 . 0 . 5 - 11 .rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
[root@newifx rpm]# cd /
[root@newifx /]# sar -d  30 
Linux  2 . 6 . 9 - 42 .ELsmp (newifx)    05 / 27 / 2009 

[root@breezzx root]# dbschema -d breezz1 -t accounts

{ TABLE "informix".accounts row size =  416  number of columns =  52  index size =  123 
              }
create table "informix".accounts
  (
    fiaccount_id serial not null ,
    ficust_id integer,
    fibatch_id integer,
    fiprovider_id integer not null ,
    fitq_plan_id integer,
    fiagent_id integer,
    fscontrol char( 20 )
        default '' not null ,
    fsoldcontrol char( 20 )
        default '' not null ,
    fswebword char( 20 ),
    fswebshadow char( 22 ),
    fswebreply char( 4 ),
    fiwebsecurity smallint
        default  1 ,
    fipay_t_id integer,
    ficrcy_id integer,
    fxbalance decimal( 16 , 2 )
        default  0 . 00  not null ,
    fabal_dttm datetime year to second,
    fxcriticalblce decimal( 16 , 2 ),
    fxmonthtraffic decimal( 16 , 2 ),
    fxdaytraffic decimal( 16 , 2 ),
    fxmonthkbytes decimal( 16 , 3 ),
    fafirstcdr datetime year to second,
    falastcdr datetime year to second,
    fxprovbalance decimal( 16 , 2 ),
    faprovbal_dttm datetime year to second,
    fiacct_type_id integer
        default  100  not null ,
    fxodraft_lim decimal( 16 , 2 )
        default  0 . 00  not null ,
    fxodraft_fee decimal( 16 , 2 )
        default  0 . 00  not null ,
    fdstart_date date,
    fdclose_date date,
    fdexp_date date,
    fiacc_life_days integer,
    fdlast_recharge date,
    fdlast_payment date,
    fiacct_stat_id integer
        default  200  not null ,
    fxmin_traf_month decimal( 16 , 2 )
        default  0 . 00  not null ,
    fxmax_traf_daily decimal( 16 , 2 )
        default  0 . 00  not null ,
    fxmax_traf_month decimal( 16 , 2 ),
    fxmax_rech_month decimal( 16 , 2 )
        default  0 . 00  not null ,
    fxdiscount decimal( 16 , 2 )
        default  0 . 00 ,
    fxcreditlimit decimal( 16 , 2 )
        default  0 . 00 ,
    fxsubscript_fee decimal( 16 , 2 ),
    fidelv_id integer,
    fiserv_class_id integer
        default  100 ,
    filang_voice integer
        default  1  not null ,
    finum_style_id integer
        default  1 ,
    ficdrsecurity smallint,
    fivmail_setup_id integer,
    fiacct_postpaid smallint
        default  0  not null ,
    fxsec_deposit decimal( 16 , 2 )
        default  0 . 00  not null ,
    fiaccmaster integer,
    fxautorecharge decimal( 16 , 2 ),
    fsaccdesc char( 50 )
  );
revoke all on "informix".accounts from "public";



create index "informix".ix_acc_accmast on "informix".accounts
    (fiaccmaster) using btree ;
create unique index "informix".ix_acc_control on "informix".accounts
    (fscontrol,fiprovider_id) using btree ;
create index "informix".ix_acc_control_up on "informix".accounts
    ("informix".upper_my(fscontrol)) using btree ;
create index "informix".ix_acc_fcdr on "informix".accounts (fafirstcdr)
    using btree ;
create index "informix".ix_acc_rech on "informix".accounts (ficust_id,
    fdlast_recharge) using btree ;
create index "informix".ix_acc_startd on "informix".accounts (fdstart_date)
    using btree ;
create index "informix".ix_account_exp on "informix".accounts
    (fdexp_date) using btree ;
create unique index "informix".ix_accounts1 on "informix".accounts
    (fiaccount_id) using btree ;
alter table "informix".accounts add constraint primary key (fiaccount_id)
    constraint "informix".ct_accounts2  ;
alter table "informix".accounts add constraint (foreign key (ficust_id)
    references "informix".customers  constraint "informix".fk_accounts1);


alter table "informix".accounts add constraint (foreign key (fibatch_id)
    references "informix".batches  constraint "informix".fk_acc_batch);


alter table "informix".accounts add constraint (foreign key (fiprovider_id)
    references "informix".providers  constraint "informix".fk_accounts3);



create trigger "informix".ih_accounts insert on "informix".accounts
    referencing new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('insert' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,' ' ,' ' ,' ' ,' ' ));

create trigger "informix".dh_accounts delete on "informix".accounts
    referencing old as pre
    for each row
        (
        delete from "informix".phone_alias  where (fiaccount_id
    = pre.fiaccount_id ) ),
        (
        execute procedure "informix".ufwriterechist('delete' ,
    'accounts' ,pre.fiaccount_id ,pre.fscontrol ,' ' ,' ' ,' ' ,' ' ));

create trigger "informix".uh_accounts update of fiacct_type_id,
    fidelv_id on "informix".accounts referencing old as pre new
    as post
    for each row
        (
        { generic }
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,' ' ,' ' ,' ' ,' ' ));

create trigger "informix".uh_acc_cust_id update of ficust_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiCust_id' ,'Номер клиента'
     ,pre.ficust_id ,post.ficust_id ));

create trigger "informix".uh_acc_batch_id update of fibatch_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiBatch_id' ,'Системный номер партии карт'
     ,pre.fibatch_id ,post.fibatch_id ));

create trigger "informix".uh_acc_prov update of fiprovider_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufupdacc_prov('update' ,post.fiaccount_id
    ,pre.fiprovider_id ,post.fiprovider_id )),
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiProvider_id' ,'Провайдер'
     ,pre.fiprovider_id ,post.fiprovider_id ));

create trigger "informix".uh_acc_tplan update of fitq_plan_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufupdacc_tplan('update' ,
    post.fiaccount_id ,pre.fitq_plan_id ,post.fitq_plan_id )),
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiTq_plan_id' ,'Тарифный план'
     ,pre.fitq_plan_id ,post.fitq_plan_id ));

create trigger "informix".uh_acc_agent_id update of fiagent_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiAgent_id' ,'Агент'
     ,pre.fiagent_id ,post.fiagent_id ));

create trigger "informix".uh_acc_control update of fscontrol
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fsControl' ,'Контрольный идентификатор счета'
     ,pre.fscontrol ,post.fscontrol ));

create trigger "informix".uh_acc_oldctrl update of fsoldcontrol
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fsOldControl' ,'Контрольный идентификатор счета (старый вариант)'
     ,pre.fsoldcontrol ,post.fsoldcontrol ));

create trigger "informix".uh_acc_wwd update of fswebword on "informix"
    .accounts referencing old as pre new as post
    for each row
        when ((((pre.fswebword != post.fswebword ) OR ((pre.fswebword
    IS NULL ) AND (post.fswebword IS NOT NULL ) ) ) OR ((pre.fswebword
    IS NOT NULL ) AND (post.fswebword IS NULL ) ) ) )
            (
            execute procedure "informix".ufwriterechist('update'
     ,'accounts' ,post.fiaccount_id ,post.fscontrol ,'fsWebWord' ,'Пароль для Web'
     ,'xxxxxxxx' ,'xxxxxxxxxx' ));

create trigger "informix".uh_acc_wrp update of fswebreply on
    "informix".accounts referencing old as pre new as post
    for each row
        when ((((pre.fswebreply != post.fswebreply ) OR ((pre.fswebreply
    IS NULL ) AND (post.fswebreply IS NOT NULL ) ) ) OR ((pre.fswebreply
    IS NOT NULL ) AND (post.fswebreply IS NULL ) ) ) )
            (
            execute procedure "informix".ufwriterechist('update'
     ,'accounts' ,post.fiaccount_id ,post.fscontrol ,'fsWebReply' ,'Отзыв для Web'
     ,'xxxxxxxx' ,'xxxxxxxxxx' ));

create trigger "informix".uh_acc_websecur update of fiwebsecurity
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiWebSecurity' ,'Web изоляция счета: 0 - нет, 1 - да.'
     ,pre.fiwebsecurity ,post.fiwebsecurity ));

create trigger "informix".uh_acc_pay_type update of fipay_t_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiPay_t_id' ,'Тип оплаты'
     ,pre.fipay_t_id ,post.fipay_t_id ));

create trigger "informix".uh_acc_crcy update of ficrcy_id on
    "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiCrcy_id' ,'Валюта'
     ,pre.ficrcy_id ,post.ficrcy_id ));

create trigger "informix".uh_acc_crit_bal update of fxcriticalblce
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxCriticalBlce' ,'Критическая величина остатка на счете'
     ,pre.fxcriticalblce ,post.fxcriticalblce ));

create trigger "informix".uh_acc_odraftlim update of fxodraft_lim
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxODraft_lim' ,'Лимит овердрафта'
     ,pre.fxodraft_lim ,post.fxodraft_lim ));

create trigger "informix".uh_acc_odraftfee update of fxodraft_fee
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxODraft_fee' ,'Пеня за овердрафт'
     ,pre.fxodraft_fee ,post.fxodraft_fee ));

create trigger "informix".uh_acc_start_dt update of fdstart_date
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fdStart_date' ,'Дата открытия счета'
     ,pre.fdstart_date ,post.fdstart_date ));

create trigger "informix".uh_acc_close_dt update of fdclose_date
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fdClose_date' ,'Дата фактического закрытия счета'
     ,pre.fdclose_date ,post.fdclose_date ));

create trigger "informix".uh_acc_exp_dt update of fdexp_date
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fdExp_date' ,'Предписанная дата закрытия счета'
     ,pre.fdexp_date ,post.fdexp_date ));

create trigger "informix".uh_acc_lifedays update of fiacc_life_days
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiAcc_life_days' ,'Максимальное время жизни счета в днях'
     ,pre.fiacc_life_days ,post.fiacc_life_days ));

create trigger "informix".uh_acc_stat update of fiacct_stat_id
    on "informix".accounts referencing old as pre new as post
    for each row
        when (((post.fibatch_id >  0  ) AND (pre.fiacct_stat_id
    =  100  ) ) )
            (
            execute procedure "informix".ufaccactivate(post.fibatch_id
    ,post.fiaccount_id , 1  )),
        when (((post.fibatch_id >  0  ) AND (post.fiacct_stat_id
    =  100  ) ) )
            (
            execute procedure "informix".ufaccactivate(post.fibatch_id
    ,post.fiaccount_id ,- 1  )),
        when (((post.fiacct_stat_id =  200  ) AND (pre.fiacct_stat_id
    =  100  ) ) )
            (
            update "informix".acct_details set "informix".acct_details.fipin_active
    =  1  ,"informix".acct_details.fdactivation = TODAY  where ((fiaccount_id
    = post.fiaccount_id ) AND (fipin_active = - 1  ) ) ),
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiAcct_stat_id' ,'Состояние (статус) счета'
     ,pre.fiacct_stat_id ,post.fiacct_stat_id ));

create trigger "informix".uh_acc_min_t_mon update of fxmin_traf_month
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxMin_traf_month' ,
    'Минимально допустимый объем трафика за месяц' ,pre.fxmin_traf_month
    ,post.fxmin_traf_month ));

create trigger "informix".uh_acc_max_t_day update of fxmax_traf_daily
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxMax_traf_daily' ,
    'Максимально допустимый объем трафика за день' ,pre.fxmax_traf_daily
    ,post.fxmax_traf_daily ));

create trigger "informix".uh_accmaxtrmonth update of fxmax_traf_month
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxMax_traf_month' ,
    'Максимально допустимый объем трафика за месяц' ,pre.fxmax_traf_month
    ,post.fxmax_traf_month ));

create trigger "informix".uh_acc_max_r_mon update of fxmax_rech_month
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxMax_rech_month' ,
    'Максимально допустимая общая сумма пополнения счета за месяц' ,pre.fxmax_rech_month
    ,post.fxmax_rech_month ));

create trigger "informix".uh_acc_discount update of fxdiscount
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxDiscount' ,'Бонусная скидка с трафика'
     ,pre.fxdiscount ,post.fxdiscount ));

create trigger "informix".uh_acc_creditlim update of fxcreditlimit
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxCreditLimit' ,'Лимит кредита'
     ,pre.fxcreditlimit ,post.fxcreditlimit ));

create trigger "informix".uh_acc_subscrfee update of fxsubscript_fee
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxSubscript_fee' ,'Абонентская плата'
     ,pre.fxsubscript_fee ,post.fxsubscript_fee ));

create trigger "informix".uh_acc_servclass update of fiserv_class_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiServ_class_id' ,'Категория услуги'
     ,pre.fiserv_class_id ,post.fiserv_class_id ));

create trigger "informix".uh_acc_langvoice update of filang_voice
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiLang_voice' ,'Язык голосового меню'
     ,pre.filang_voice ,post.filang_voice ));

create trigger "informix".uh_acc_cdr_secur update of ficdrsecurity
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiCDRSecurity' ,'Уровень безопасности при записи CDR'
     ,pre.ficdrsecurity ,post.ficdrsecurity ));

create trigger "informix".uh_acc_voicemail update of fivmail_setup_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiVMail_setup_id' ,
    'Вариант настройки голосовой почты' ,pre.fivmail_setup_id ,post.fivmail_setup_id
    ));

create trigger "informix".uh_acc_postpaid update of fiacct_postpaid
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiAcct_postpaid' ,'Режим оплаты клиентского счета'
     ,pre.fiacct_postpaid ,post.fiacct_postpaid ));

create trigger "informix".uh_acc_sec_dep update of fxsec_deposit
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxSec_deposit' ,'сумма страхового депозита'
     ,pre.fxsec_deposit ,post.fxsec_deposit ));

create trigger "informix".uh_acc_master update of fiaccmaster
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiAccMaster' ,'Master Account'
     ,pre.fiaccmaster ,post.fiaccmaster ));

create trigger "informix".uh_acc_auto_rech update of fxautorecharge
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxAutoRecharge' ,'Сумма автоматического пополнения'
     ,pre.fxautorecharge ,post.fxautorecharge ));



[root@breezzx root]#

[root@newifx rpms]# dbschema -d breezz2 -t accounts

{ TABLE "informix".accounts row size =  416  number of columns =  52  index size =  123 
              }
create table "informix".accounts
  (
    fiaccount_id serial not null ,
    ficust_id integer,
    fibatch_id integer,
    fiprovider_id integer not null ,
    fitq_plan_id integer,
    fiagent_id integer,
    fscontrol char( 20 )
        default '' not null ,
    fsoldcontrol char( 20 )
        default '' not null ,
    fswebword char( 20 ),
    fswebshadow char( 22 ),
    fswebreply char( 4 ),
    fiwebsecurity smallint
        default  1 ,
    fipay_t_id integer,
    ficrcy_id integer,
    fxbalance decimal( 16 , 2 )
        default  0 . 00  not null ,
    fabal_dttm datetime year to second,
    fxcriticalblce decimal( 16 , 2 ),
    fxmonthtraffic decimal( 16 , 2 ),
    fxdaytraffic decimal( 16 , 2 ),
    fxmonthkbytes decimal( 16 , 3 ),
    fafirstcdr datetime year to second,
    falastcdr datetime year to second,
    fxprovbalance decimal( 16 , 2 ),
    faprovbal_dttm datetime year to second,
    fiacct_type_id integer
        default  100  not null ,
    fxodraft_lim decimal( 16 , 2 )
        default  0 . 00  not null ,
    fxodraft_fee decimal( 16 , 2 )
        default  0 . 00  not null ,
    fdstart_date date,
    fdclose_date date,
    fdexp_date date,
    fiacc_life_days integer,
    fdlast_recharge date,
    fdlast_payment date,
    fiacct_stat_id integer
        default  200  not null ,
    fxmin_traf_month decimal( 16 , 2 )
        default  0 . 00  not null ,
    fxmax_traf_daily decimal( 16 , 2 )
        default  0 . 00  not null ,
    fxmax_traf_month decimal( 16 , 2 ),
    fxmax_rech_month decimal( 16 , 2 )
        default  0 . 00  not null ,
    fxdiscount decimal( 16 , 2 )
        default  0 . 00 ,
    fxcreditlimit decimal( 16 , 2 )
        default  0 . 00 ,
    fxsubscript_fee decimal( 16 , 2 ),
    fidelv_id integer,
    fiserv_class_id integer
        default  100 ,
    filang_voice integer
        default  1  not null ,
    finum_style_id integer
        default  1 ,
    ficdrsecurity smallint,
    fivmail_setup_id integer,
    fiacct_postpaid smallint
        default  0  not null ,
    fxsec_deposit decimal( 16 , 2 )
        default  0 . 00  not null ,
    fiaccmaster integer,
    fxautorecharge decimal( 16 , 2 ),
    fsaccdesc char( 50 )
  );
revoke all on "informix".accounts from "public";



create index "informix".ix_acc_accmast on "informix".accounts
    (fiaccmaster) using btree ;
create unique index "informix".ix_acc_control on "informix".accounts
    (fscontrol,fiprovider_id) using btree ;
create index "informix".ix_acc_control_up on "informix".accounts
    ("informix".upper_my(fscontrol)) using btree ;
create index "informix".ix_acc_fcdr on "informix".accounts (fafirstcdr)
    using btree ;
create index "informix".ix_acc_rech on "informix".accounts (ficust_id,
    fdlast_recharge) using btree ;
create index "informix".ix_acc_startd on "informix".accounts (fdstart_date)
    using btree ;
create index "informix".ix_account_exp on "informix".accounts
    (fdexp_date) using btree ;
create unique index "informix".ix_accounts1 on "informix".accounts
    (fiaccount_id) using btree ;
alter table "informix".accounts add constraint primary key (fiaccount_id)
    constraint "informix".ct_accounts2  ;
alter table "informix".accounts add constraint (foreign key (ficust_id)
    references "informix".customers  constraint "informix".fk_accounts1);


alter table "informix".accounts add constraint (foreign key (fibatch_id)
    references "informix".batches  constraint "informix".fk_acc_batch);


alter table "informix".accounts add constraint (foreign key (fiprovider_id)
    references "informix".providers  constraint "informix".fk_accounts3);



create trigger "informix".ih_accounts insert on "informix".accounts
    referencing new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('insert' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,' ' ,' ' ,' ' ,' ' ));

create trigger "informix".dh_accounts delete on "informix".accounts
    referencing old as pre
    for each row
        (
        delete from "informix".phone_alias  where (fiaccount_id
    = pre.fiaccount_id ) ),
        (
        execute procedure "informix".ufwriterechist('delete' ,
    'accounts' ,pre.fiaccount_id ,pre.fscontrol ,' ' ,' ' ,' ' ,' ' ));

create trigger "informix".uh_accounts update of fiacct_type_id,
    fidelv_id on "informix".accounts referencing old as pre new
    as post
    for each row
        (
        { generic }
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,' ' ,' ' ,' ' ,' ' ));

create trigger "informix".uh_acc_cust_id update of ficust_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiCust_id' ,'Номер клиента'
     ,pre.ficust_id ,post.ficust_id ));

create trigger "informix".uh_acc_batch_id update of fibatch_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiBatch_id' ,'Системный номер партии карт'
     ,pre.fibatch_id ,post.fibatch_id ));

create trigger "informix".uh_acc_prov update of fiprovider_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufupdacc_prov('update' ,post.fiaccount_id
    ,pre.fiprovider_id ,post.fiprovider_id )),
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiProvider_id' ,'Провайдер'
     ,pre.fiprovider_id ,post.fiprovider_id ));

create trigger "informix".uh_acc_tplan update of fitq_plan_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufupdacc_tplan('update' ,
    post.fiaccount_id ,pre.fitq_plan_id ,post.fitq_plan_id )),
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiTq_plan_id' ,'Тарифный план'
     ,pre.fitq_plan_id ,post.fitq_plan_id ));

create trigger "informix".uh_acc_agent_id update of fiagent_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiAgent_id' ,'Агент'
     ,pre.fiagent_id ,post.fiagent_id ));

create trigger "informix".uh_acc_control update of fscontrol
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fsControl' ,'Контрольный идентификатор счета'
     ,pre.fscontrol ,post.fscontrol ));

create trigger "informix".uh_acc_oldctrl update of fsoldcontrol
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fsOldControl' ,'Контрольный идентификатор счета (старый вариант)'
     ,pre.fsoldcontrol ,post.fsoldcontrol ));

create trigger "informix".uh_acc_wwd update of fswebword on "informix"
    .accounts referencing old as pre new as post
    for each row
        when ((((pre.fswebword != post.fswebword ) OR ((pre.fswebword
    IS NULL ) AND (post.fswebword IS NOT NULL ) ) ) OR ((pre.fswebword
    IS NOT NULL ) AND (post.fswebword IS NULL ) ) ) )
            (
            execute procedure "informix".ufwriterechist('update'
     ,'accounts' ,post.fiaccount_id ,post.fscontrol ,'fsWebWord' ,'Пароль для Web'
     ,'xxxxxxxx' ,'xxxxxxxxxx' ));

create trigger "informix".uh_acc_wrp update of fswebreply on
    "informix".accounts referencing old as pre new as post
    for each row
        when ((((pre.fswebreply != post.fswebreply ) OR ((pre.fswebreply
    IS NULL ) AND (post.fswebreply IS NOT NULL ) ) ) OR ((pre.fswebreply
    IS NOT NULL ) AND (post.fswebreply IS NULL ) ) ) )
            (
            execute procedure "informix".ufwriterechist('update'
     ,'accounts' ,post.fiaccount_id ,post.fscontrol ,'fsWebReply' ,'Отзыв для Web'
     ,'xxxxxxxx' ,'xxxxxxxxxx' ));

create trigger "informix".uh_acc_websecur update of fiwebsecurity
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiWebSecurity' ,'Web изоляция счета: 0 - нет, 1 - да.'
     ,pre.fiwebsecurity ,post.fiwebsecurity ));

create trigger "informix".uh_acc_pay_type update of fipay_t_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiPay_t_id' ,'Тип оплаты'
     ,pre.fipay_t_id ,post.fipay_t_id ));

create trigger "informix".uh_acc_crcy update of ficrcy_id on
    "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiCrcy_id' ,'Валюта'
     ,pre.ficrcy_id ,post.ficrcy_id ));

create trigger "informix".uh_acc_crit_bal update of fxcriticalblce
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxCriticalBlce' ,'Критическая величина остатка на счете'
     ,pre.fxcriticalblce ,post.fxcriticalblce ));

create trigger "informix".uh_acc_odraftlim update of fxodraft_lim
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxODraft_lim' ,'Лимит овердрафта'
     ,pre.fxodraft_lim ,post.fxodraft_lim ));

create trigger "informix".uh_acc_odraftfee update of fxodraft_fee
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxODraft_fee' ,'Пеня за овердрафт'
     ,pre.fxodraft_fee ,post.fxodraft_fee ));

create trigger "informix".uh_acc_start_dt update of fdstart_date
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fdStart_date' ,'Дата открытия счета'
     ,pre.fdstart_date ,post.fdstart_date ));

create trigger "informix".uh_acc_close_dt update of fdclose_date
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fdClose_date' ,'Дата фактического закрытия счета'
     ,pre.fdclose_date ,post.fdclose_date ));

create trigger "informix".uh_acc_exp_dt update of fdexp_date
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fdExp_date' ,'Предписанная дата закрытия счета'
     ,pre.fdexp_date ,post.fdexp_date ));

create trigger "informix".uh_acc_lifedays update of fiacc_life_days
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiAcc_life_days' ,'Максимальное время жизни счета в днях'
     ,pre.fiacc_life_days ,post.fiacc_life_days ));

create trigger "informix".uh_acc_stat update of fiacct_stat_id
    on "informix".accounts referencing old as pre new as post
    for each row
        when (((post.fibatch_id >  0  ) AND (pre.fiacct_stat_id
    =  100  ) ) )
            (
            execute procedure "informix".ufaccactivate(post.fibatch_id
    ,post.fiaccount_id , 1  )),
        when (((post.fibatch_id >  0  ) AND (post.fiacct_stat_id
    =  100  ) ) )
            (
            execute procedure "informix".ufaccactivate(post.fibatch_id
    ,post.fiaccount_id ,- 1  )),
        when (((post.fiacct_stat_id =  200  ) AND (pre.fiacct_stat_id
    =  100  ) ) )
            (
            update "informix".acct_details set "informix".acct_details.fipin_active
    =  1  ,"informix".acct_details.fdactivation = TODAY  where ((fiaccount_id
    = post.fiaccount_id ) AND (fipin_active = - 1  ) ) ),
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiAcct_stat_id' ,'Состояние (статус) счета'
     ,pre.fiacct_stat_id ,post.fiacct_stat_id ));

create trigger "informix".uh_acc_min_t_mon update of fxmin_traf_month
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxMin_traf_month' ,
    'Минимально допустимый объем трафика за месяц' ,pre.fxmin_traf_month
    ,post.fxmin_traf_month ));

create trigger "informix".uh_acc_max_t_day update of fxmax_traf_daily
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxMax_traf_daily' ,
    'Максимально допустимый объем трафика за день' ,pre.fxmax_traf_daily
    ,post.fxmax_traf_daily ));

create trigger "informix".uh_accmaxtrmonth update of fxmax_traf_month
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxMax_traf_month' ,
    'Максимально допустимый объем трафика за месяц' ,pre.fxmax_traf_month
    ,post.fxmax_traf_month ));

create trigger "informix".uh_acc_max_r_mon update of fxmax_rech_month
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxMax_rech_month' ,
    'Максимально допустимая общая сумма пополнения счета за месяц' ,pre.fxmax_rech_month
    ,post.fxmax_rech_month ));

create trigger "informix".uh_acc_discount update of fxdiscount
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxDiscount' ,'Бонусная скидка с трафика'
     ,pre.fxdiscount ,post.fxdiscount ));

create trigger "informix".uh_acc_creditlim update of fxcreditlimit
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxCreditLimit' ,'Лимит кредита'
     ,pre.fxcreditlimit ,post.fxcreditlimit ));

create trigger "informix".uh_acc_subscrfee update of fxsubscript_fee
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxSubscript_fee' ,'Абонентская плата'
     ,pre.fxsubscript_fee ,post.fxsubscript_fee ));

create trigger "informix".uh_acc_servclass update of fiserv_class_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiServ_class_id' ,'Категория услуги'
     ,pre.fiserv_class_id ,post.fiserv_class_id ));

create trigger "informix".uh_acc_langvoice update of filang_voice
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiLang_voice' ,'Язык голосового меню'
     ,pre.filang_voice ,post.filang_voice ));

create trigger "informix".uh_acc_cdr_secur update of ficdrsecurity
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiCDRSecurity' ,'Уровень безопасности при записи CDR'
     ,pre.ficdrsecurity ,post.ficdrsecurity ));

create trigger "informix".uh_acc_voicemail update of fivmail_setup_id
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiVMail_setup_id' ,
    'Вариант настройки голосовой почты' ,pre.fivmail_setup_id ,post.fivmail_setup_id
    ));

create trigger "informix".uh_acc_postpaid update of fiacct_postpaid
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiAcct_postpaid' ,'Режим оплаты клиентского счета'
     ,pre.fiacct_postpaid ,post.fiacct_postpaid ));

create trigger "informix".uh_acc_sec_dep update of fxsec_deposit
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxSec_deposit' ,'сумма страхового депозита'
     ,pre.fxsec_deposit ,post.fxsec_deposit ));

create trigger "informix".uh_acc_master update of fiaccmaster
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fiAccMaster' ,'Master Account'
     ,pre.fiaccmaster ,post.fiaccmaster ));

create trigger "informix".uh_acc_auto_rech update of fxautorecharge
    on "informix".accounts referencing old as pre new as post
    for each row
        (
        execute procedure "informix".ufwriterechist('update' ,
    'accounts' ,post.fiaccount_id ,post.fscontrol ,'fxAutoRecharge' ,'Сумма автоматического пополнения'
     ,pre.fxautorecharge ,post.fxautorecharge ));



[root@newifx rpms]#

Percentages:
Data   87 . 94 
Btree  9 . 93 
Other  2 . 14 

Percentages:
Data   91 . 35 
Btree  8 . 57 
Other  0 . 08 

[root@breezzx root]# onstat -p
IBM Informix Dynamic Server Version  9 . 40 .UC6     -- On-Line -- Up 88 days 23:17:58 -- 636168 Kbytes

Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
 597        4087       633414214   100 . 00    9159       16761      51576      82 . 24 

[root@newifx /]# onstat -p
IBM Informix Dynamic Server Version  9 . 40 .UC6     -- On-Line -- Up 1 days 11:57:06 -- 695232 Kbytes

Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
 69098647   71964077   554046800   87 . 53     61346      482665     488571     87 . 44 

          Logical Drive :  0 ( Adapter:  0  ):  Status: OPTIMAL
        ---------------------------------------------------
        SpanDepth : 01      RaidLevel:  5   RdAhead : No  Cache: DirectIo
        StripSz   :064KB   Stripes  :  3   WrPolicy: WriteThru