物理ホスト --1. 実行エージェントmmm194が存在しないことを確認/opt/jp1ajs2/bin/ajsagtshow -l --2. エージェント自動定義機能の設定 /opt/jp1ajs2/bin/jajs_spmd_stop/opt/jp1ajs2/bin/jajs_spmd_status /opt/jp1ajs2/bin/jajs_config -k "[JP1_DEFAULT\J…

MySQL (5.6) select t1.table_name,t1.indkey,group_concat(index_name order by index_name) index_names, count(*) kensufrom (select table_name,index_name,group_concat(column_name order by seq_in_index) indkeyfrom information_schema.statisticsw…

MySQL (5.6) select object_name,index_namefrom performance_schema.table_io_waits_summary_by_index_usagewhere object_schema = 'test'and index_name is not nulland count_read = 0order by object_name,index_name; (8.0.18)select * from sys.schema…

MySQL (5.6) mysql test -s -N set sql_mode='PIPES_AS_CONCAT'; select 'select ''' || table_name || ',''||count(*) from ' || table_name || ';'from information_schema.tableswhere table_schema ='test'order by table_name; Oracle (12cR1) set head…

MySQL (5.6)drop table tab1;create table tab1(col1 int);insert into tab1 values(1);select * from tab1; pager cat /dev/nullnopager Oracle (12cR2) drop table tab1 purge;create table tab1(col1 int);insert into tab1 values(1);commit;select * fr…

物理ホスト (1) JP1/AJS3のトレースログファイルの拡張 /opt/jp1ajs2/bin/ajstrsetsz -F AJSROOT1/opt/jp1ajs2/bin/ajstrsetsz -F AJSROOT1 -s 204800/opt/jp1ajs2/bin/ajstrsetsz -F AJSROOT1 (2) キューレストレースログファイルの拡張※キューレスジョブ実…

MySQL (5.6) drop function fun1;delimiter //create function fun1(p1 integer)returns integerno sqlbegin declare ret int; set ret = p1; if ret = 0 then return ret; else signal sqlstate value '08S01' set message_text = 'an error occurred'; end…

MySQL (5.6) --データ準備 drop table tab1;drop table tab2; create table tab1(col11 int,col12 int);create table tab2(col21 int,col22 int); alter table tab1 add constraint cons1 primary key(col11);alter table tab2 add constraint cons2 primary…

MySQL (8.0.18) サポートしていない模様 Oracle (12cR1) DDL文(CREATE,ALTER,DROP,TRUNCATE等)データベース操作文(LOGON,LOGOFF等) https://docs.oracle.com/cd/E57425_01/121/LNPLS/triggers.htm#GUID-5DEA2CE5-D61C-4E27-A36E-73348D9F619B drop table tab…

MySQL (8.0.18)パラレル処理をサポートしていない Oracle (12cR1) --パラレル実行有効化alter session enable parallel dml; 【1】insert drop table tab1 purge;create table tab1(col1 int,col2 int); drop table tab2 purge;create table tab2(col1 int,c…

Ubuntu (16) apt updateapt install software-properties-commonapt-add-repository --yes --update ppa:ansible/ansibleapt install ansible ansible-playbook --version Debian (9) vim /etc/apt/sources.list deb http://ppa.launchpad.net/ansible/ansib…

MySQL (5.6) show binary logs; Oracle (12cR1) select * from v$log order by group#,thread#; select * from v$logfile order by group#,member; PostgreSQL https://tihiro.hatenablog.com/entry/2020/04/24/080849 (9.4)select pg_xlogfile_name( pg_cur…

Ubuntu (16) useradd -d /home/user01 -s /bin/bash user01passwd user01 chage -l user01 chage -M 99999 user01 Debian (9) useradd -d /home/user01 -s /bin/bash user01passwd user01 chage -l user01 chage -M 99999 user01 CentOS (7)useradd user01ec…

http://akiniwa.hatenablog.jp/entry/2014/04/08/220430 vim a.txt 20200601 AAA 1020200602 AAA 2020200603 AAA 3020200604 BBB 10020200605 BBB 12020200606 CCC 1020200607 CCC 1220200608 CCC 1220200609 DDD 300 vim a.awk { sum[$2]+=$3 count[$2]+=1 …

MySQL (5.6)status; Oracle (12cR1) alter session set nls_date_format='yyyy/mm/dd hh24:mi:ss'; select startup_time from v$instance; PostgreSQL (9.4) select pg_postmaster_start_time(); SQL Server (2014) select sqlserver_start_time from sys.dm…

MySQL (5.6) select @@read_only; Oracle (12cR1) select database_role from v$database; PostgreSQL (9.4) select setting from pg_settingswhere name like 'transaction_read_only'; SQL Server (2019) select is_primary_replicafrom sys.dm_hadr_datab…