Trafodion 不挂断后台运行sql小技巧

Trafodion可以使用sqlci -i执行一个sql脚本，如下

[trafodion@n13 ~]$ cat test1.sql set schema seabase; set statistics on; select current_timestamp from dual; [trafodion@n13 ~]$ sqlci -i test1.sql EsgynDB Advanced Conversational Interface 2.2.2 Copyright (c) 2015-2017 Esgyn Corporation >>set schema seabase; --- SQL operation complete. >>set statistics on; >>select current_timestamp from dual; (EXPR) -------------------------- 2017-04-14 09:10:51.228357 --- 1 row(s) selected. Start Time 2017/04/14 09:10:51.217906 End Time 2017/04/14 09:10:51.231441 Elapsed Time 00:00:00.013535 Compile Time 00:00:00.010302 Execution Time 00:00:00.003171 --- SQL operation complete. >>exit;

Linux中一个命令nohup，用于不挂断的执行一个脚本，关于nohup介绍，请参考：http://linux.101hacks.com/unix/nohup-command/

用nohup结合sqlci -i可以实现不挂断地后台运行Trafodion脚本，这种场景特别适合用于在人休息的时候让系统持续不间断地工作（如大批量地加载数据、更新统计信息等）

[trafodion@n13 ~]$ nohup sqlci -i test1.sql >> test1.log & [1] 5684 [trafodion@n13 ~]$ nohup: ignoring input and redirecting stderr to stdout [1]+ Done nohup sqlci -i test1.sql >> test1.log [trafodion@n13 ~]$ cat test1.log EsgynDB Advanced Conversational Interface 2.2.2 Copyright (c) 2015-2017 Esgyn Corporation >>set schema seabase; --- SQL operation complete. >>set statistics on; >>select current_timestamp from dual; (EXPR) -------------------------- 2017-04-14 09:14:11.978387 --- 1 row(s) selected. Start Time 2017/04/14 09:14:11.967923 End Time 2017/04/14 09:14:11.981184 Elapsed Time 00:00:00.013261 Compile Time 00:00:00.010320 Execution Time 00:00:00.002880 --- SQL operation complete. >>exit; End of MXCI Session