发布时间：2015-02-17 10:32:09
The test process as following :--create a test partition tablecreate table test_part3(id number,aaa varchar2(30),bbb varchar2(30),date1 date default sysdate,name1 varchar2(25),name2 varchar2(25),name3 varchar2(25),name4 varchar2(25),name.........【阅读全文】
发布时间：2015-02-11 16:50:23
netezza command manual: nz_genstats当表没有记录的时候,Statistics Status 也会显示Unavailable.[nz@hlixau1105 log]$ nz_genstats -full db_name test_t1Database: db_name# Tables: 1 # Table Name .........【阅读全文】
发布时间：2015-02-11 14:10:04
Netezza -- join columns of the 2 table should be same dataType , or there will be data distribution or broadcastcreate table test_a (id int) distribute on (id);create table test_b (id char(10)) distribute on (id);insert into test_a values (1001);insert into test_b values (.........【阅读全文】
发布时间：2015-02-09 12:14:24
oem 12 Chttp://www.oracle.com/technetwork/oem/grid-control/downloads/linuxx8664soft-085949.htmlhttp://oracle-base.com/articles/12c/cloud-control-12cr2-installation-on-oracle-linux-5-and-6.phphttp://www.askmaclean.com/archives/%E5%9C%A8oel-5%E4%B8%8A%E5%BF%AB%E9%80%9F%E9%83%A8%E7%BD%B2e.........【阅读全文】
发布时间：2015-02-09 10:52:16
NPS 7.X Managing WorkloadsConcurrent Jobs : netezza 的并发数默认是 48 ,可以更改这个默认值 重启 nzsystem resume 生效 Netezza imposes a limit on the number of concurrent jobs that can run on the system at one time. The limit is controlled by the system registry setting gkMaxConcurrent, .........【阅读全文】
