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