Skip to content

Check the work

kayform edited this page Dec 10, 2020 · 2 revisions

1 repository

alter table tb_query_info rename to tb_query_info_bak;

create table tb_query_info ( reg_date character varying(8) not null, instance_id integer not null, dbid int8 not null, userid int8 not null, queryid character varying(41) not null, stmt_queryid int8, query text, collect_dt timestamp without time zone ) partition by list (reg_date);

create table tb_query_info_20201210 partition of tb_query_info for values in ('20201210');

alter table only tb_query_info_20201210 add constraint pk_tb_query_info_20201210 primary key (reg_date,instance_id, dbid, userid, queryid);

experdbma.sh 비교 app.xml 2개 비교 tb_query_info_date 데이터 수집 확인

트렌트 리스트 비활성(매니저) - 서버 : Time.report_period property 비활성화(comment out) 스냅샷 리포트 비활성화(?) - 서버 : task info에서 task 제거

-- class 변경시

1 repository

alter table tb_query_info rename to tb_query_info_bak;

create table tb_query_info ( reg_date character varying(8) not null, instance_id integer not null, dbid int8 not null, userid int8 not null, queryid character varying(41) not null, stmt_queryid int8, query text, collect_dt timestamp without time zone ) partition by list (reg_date);

create table tb_query_info_20201210 partition of tb_query_info for values in ('20201210'); alter table only tb_query_info_20201210 add constraint pk_tb_query_info_20201210 primary key (reg_date,instance_id, dbid, userid, queryid);

  • Agent HourlyBatchTask.class app.xml (비교 후에)
  • Manager DailyBatchTask.java app.xml (비교 후에)

temp

Clone this wiki locally