netezzaperformance server s8opublibfp.boulder.ibm.com/epubs/pdf/c4310520.pdf · 2015. 3. 10. ·...

IBM InfoSphere DataStage andQualityStageV11.3

NetezzaPerformance Server,S8O

SC43-1052-00

��

"

Z9C>JO0d'VDz7.0,kDAZ 653D:ywMLj;PDE"#

© Copyright IBM Corporation 2005, 2014.

?<

Z 1 B dCT Netezza }]bDCJ . . 1dCT Netezza }]bDCJ . . . . . . . . . 1Z Linux M UNIX OdCT Netezza }]bDCJ . . . . . . . . . . . . . . . . . 1Z Microsoft Windows OdCT Netezza }]bDCJ . . . . . . . . . . . . . . . . 2

hCb7673d? . . . . . . . . . . . . 3Z dsenv D~PhCb7673d? . . . . . 3Z Windows PhCb7673d? . . . . . . 4

(}9C ISA Lite $_bT}]b,S . . . . . 5

Z 2 B Netezza Enterprise WN . . . . 7XZ Netezza Performance Server 8000 . . . . . . 70k=( . . . . . . . . . . . . . . . 7CZCJ Netezza Performance Server DM'zSZ 8\'VDYw53r=( . . . . . . . . . 9

Netezza Enterprise WND$w== . . . . . . . 99C Netezza Enterprise WN . . . . . . . . . 10Hvu~ . . . . . . . . . . . . . . 10Netezza enterprise WNYw . . . . . . . . 129C Netezza Enterprise WN+}]4k NetezzaPerformance Server . . . . . . . . . . . 139C Netezza Enterprise WNS NetezzaPerformance Server PA!}] . . . . . . . 21Netezza enterprise WND}]`M . . . . . . 25

Z 3 B Netezza connector . . . . . . 299C Netezza connector hFw5 . . . . . . . 29<k Netezza *}] . . . . . . . . . . 30Netezza j6 . . . . . . . . . . . . . 30

'VDV{`k . . . . . . . . . . . . 31(e Netezza connector w5 . . . . . . . . 32

JOoO . . . . . . . . . . . . . . . 47

Z 4 B 73d?:Netezza Connector 51CC_GUARDIUM_EVENTS . . . . . . . . . 51CC_IGNORE_TIME_LENGTH_AND_SCALE . . . . 51CC_MSG_LEVEL . . . . . . . . . . . . 51CC_NZ_LOG_LEVEL . . . . . . . . . . . 51CC_TRUNCATE_STRING_WITH_NULL . . . . . 52CC_TRUNCATE_NSTRING_WITH_NULL . . . . 52CC_USE_EXTERNAL_SCHEMA_ON_MISMATCH . . 52TMPDIR . . . . . . . . . . . . . . . 52

=< A. z7(z&\!n . . . . . . . 53

=< B. A.|nPo( . . . . . . . . 55

=< C. gNA.o(< . . . . . . . . 57

=< D. *5 IBM . . . . . . . . . . 59

=< E. CJz7D5 . . . . . . . . . 61

=< F. a)PXz7D5D4! . . . . 63

ywMLj . . . . . . . . . . . . . 65

w} . . . . . . . . . . . . . . . . 69

© Copyright IBM Corp. 2005, 2014 iii

iv Netezza Performance Server ,S8O

Z 1 B dCT Netezza }]bDCJ

*dCT Netezza }]bDCJ,Xk20}]bM'zb,"+b)Q20bD76

|(Zb7673d?P#PXhC73d?D|`E",kNDhC73d?D`

Xwb#

}L

1. 20}]bM'zb#

2. dCT Netezza }]bDCJ#

dCT Netezza }]bDCJ*dCT Netezza }]bDCJ,Xk20MdC Netezza ODBC }/Lr,"4(

}]4#

Z Linux M UNIX OdCT Netezza }]bDCJ*dCT Netezza }]bDCJ,XkZ .odbcinst.ini D~P8(N}TdC Netezza

ODBC }/Lr,9Xk^D .odbc.ini D~TdC}]4#

*<.0

v 20M'zb#

XZKNq

g{fZ .odbcinst.ini dCD~,G4IT^D`,D~#g{;PVP

.odbcinst.ini dCD~,G4IT9C odbcinst.ini.sample T4( .odbcinst.ini

dCD~#Zs`}!0P,IT9C odbcinst.ini.sample D~DZ],x;xPN

N|D#+G,ZTB!0P,Xk|DdCD~:

v g{zDM'z53dC*9C Netezza ODBC }/Lr.bD ODBC }/Lr,

"Rz*Lx9Cb) ODBC }/Lr,kp^D .odbcinst.ini D~PDVPu

?#Z .odbcinst.ini D~DVPZ])2,mS Netezza ODBC }/LrDu?#

v g{ZM'z53O20K Netezza M'zm~M Netezza ODBC }/Lr,kl

iGqdCK N e t e z z a O D B C }/Lr#g{4dC,k+u?mS=

.odbcinst.ini D~DVPZ])2#

g{w?<(}g,/home/myname)PQfZ .odbc.ini dCD~,kli|Gq|

,*CJD Netezza h8}]4Du?#g{;|,,k+ odbc.ini.sample D~D

Z]4F=VP .odbc.ini dCD~D)2#;*^DD~PDNNVPu?#

g{}Z Linux O9C .odbc.ini dCD~D InfoSphere® Information Server f>,

kZCdCD~yZDD~PP4({E4ST7# Netezza ,Sw}7KP:

1. T InfoSphere DataStage®\m1m]G<#

2. *|D InfoSphere Information Server D20?<,kdkTB|n:cd /opt/IBM/

InformationServer/Server/DSEngine#

3. *4({E4S,kdkTB|n:ln -s .odbc.ini odbc.ini#

© Copyright IBM Corp. 2005, 2014 1

}L

1. 9CzDC'j6M\kG<#

2. dC Netezza ODBC }/Lr:

a. 4F /usr/local/nz/lib/odbcinst.ini.sample D~DZ]#

b. y]hs^DdCu?# I/ Netezza 53\m1,TliGqXk*zD2

0^DNNX(dCu?#

c. +D~mf* .odbcinst.ini#

3. dC Netezza h8}]4:

a. + odbc.ini.sample D~DZ]4F=w?<(}g,/home/myname),"+d

X|{* .odbc.ini#

b. I!: *+ Netezza }]4mS=VP .odbc.ini D~P,k+y>D~P

[NZSQL] sDPmS=VP .odbc.ini D~#Z [ODBC Data Sources] ?VP,

+ NZSQL = NetezzaSQL mS=}]4{FDPmP#

c. #f"XUD~#

4. hC73d?:

export ODBCINI=path_to_odbc.ini_fileexport NZ_ODBC_INI_PATH=location_of_odbc.ini_file

":g{Q+ Netezza u?mS=VP odbc.ini D~,kvhC NZ_ODBC_INI_PATHd?#

5. *XBt/~qw}fM ASB zmLr,kdkTB|n:

cd Install_directory/Server/DSEngine/bin./uv -admin -stop./uv -admin -startcd Install_directory/ASBNode/bin. ./NodeAgents_env_DS.sh./NodeAgents.sh stopAgent./NodeAgents.sh start

Z Microsoft Windows OdCT Netezza }]bDCJg{ InfoSphere Information Server Z Microsoft Windows Yw53OKP,G4Xk

Z20 Netezza ODBC }/Lrs4(MdC}]4#

*<.0

v 20}]bM'zb#

v Z 64 ; Windows FczO,7#KP 32 ;f>D Microsoft ODBC }]4\m

w C:\Windows\SysWOW64\odbcad32.exe,r* InfoSphere Information Server G 32

;&CLr#g{KP 64 ;f>D ODBC \mw&CLr,G4 Netezza ,Sw

^(R=8(D}]4{F#g{1!ivB^((}“D~”K%CJ ODBC \m

w&CLr,k9C Windows J4\mw4CJC&CLr#

– Z 32 ; Windows O,+Z C:\Windows\System32 ?<P20 32 ;}/Lr#

– Z 64 ; Windows O,IT,120 32 ;M 64 ;}/Lr# 32 ;}/Lr

20Z C:\Windows\SysWOW64 ?<P,64 ;f>20Z C:\Windows\System32 ?

<P#

2 Netezza Performance Server ,S8O

}L

1. 4(}]4:

a. y]Yw534PTB3nYw:

v Z 32 ; Windows 53O,%w*< > XFfe > \m$_ > }]4

(ODBC)#

v Z 64 ; Windows 53O,9CJ4\mw/@A C:\Windows\SysWOW64\

odbcad32.exe#

b. Z“53 DSN”3fO,%wmS#

c. Z“4(B}]4”3fO,+ NetezzaSQL !w*hCd}]4D}/Lr,;s%wjI#

2. dC ODBC }/Lr:

a. Z“Netezza ODBC }/LrhC”3fO,8(PX}]4Dj8E"#

b. Z~qwVNP,8( ODBC }/Lr,S=D Netezza 53Dwz{r IP X

7#

c. *bT,S,k8(C'{M\k,;s%wbT,S#

hCb7673d?

*+73d?&C=n?PDyPw5,kZ InfoSphere DataStage M QualityStage®

Administrator P(eC73d?#Zn?6prw56p*b7673d?M7673

d?8(D5+7S=b)d?DVP535P#

XZKNq

}g,Y(?< /opt/branded_odbc/lib 8(*n?6pDb7673d?D5#?<

/opt/IBM/InformationServer/Server/branded_odbc/lib(|,;Z;,;CD`,

b)Q;ZZYw536pr dsenv E>P(eDb76P#ZKivB,1w5KP

1,a0k?< /opt/IBM/InformationServer/Server/branded_odbc/lib PDb,r

*K?<Z*b7673d?(eD5PvVZ?< /opt/branded_odbc/lib .0#

b7673d?D{F!vZYw53#

Yw53 b7673d?

Microsoft Windows PATH

HP-UX SHLIB_PATH

IBM® AIX® LIBPATH

d{\'VD Linux M UNIX Yw53T0

HP-IA

LD_LIBRARY_PATH

Z Linux r UNIX Yw53O,ITZ dsenv E>P8(73d?#Windows Yw

53OD InfoSphere Information Server 20;|( dsenv E>#

Z dsenv D~PhCb7673d?Z Linux r UNIX Yw53O,ITZ dsenv E>P8(b7673d?#g{73

d?Z dsenv E>P8(,|G+&CZ InfoSphere Information Server }fBKPD

yP InfoSphere DataStage n?#

Z 1 B dCT Netezza }]bDCJ 3

*<.0

20M'zb#

}L

1. T DataStage \m1C'm](g{zG9C1!{F20D,r* dsadm)G<#

2. 8] IS_install_path/Server/DSEngine/dsenv E># IS_install_path G InfoSphere

Information Server 20?<(g{G9C1!7620D,r* /opt/IBM/

InformationServer)#

3. r* dsenv E>#

4. +|,M'zbD?<D76mS=b7673d?#

5. 9C|BD dsenv D~hC73#

. ./dsenv

6. (}dkTB|nXBt/ InfoSphere Information Server }f:

bin/uv –admin –stopbin/uv –admin –start

7. IC root C'X(,1S9C su |n,r_g{ DataStage \m1C'Z sudoers

PmP,G49C sudo |n#

sudo su - root

8. (}dkTB|nP;= ASB zmLrw?<:

cd Install_directory/ASBNode/bin

9. (}dkTB|nXBt/ ASB zmLrxL:

./NodeAgents.sh stopAgent

./NodeAgents.sh start

a{

XBt/ ASB zmLrxLs,InfoSphere Information Server ~qh*s<;VS1

d4"aB~#

Z Windows PhCb7673d?Z Windows Yw53O,b76M PATH 73d?yI PATH 73d?m>#*9

InfoSphere Information Server }fM ASB zmLrxL\;lb=73d?PD|D,

b)|DXkZ536pxP,"RXkXBt/ InfoSphere Information Server }f#

*<.0

20M'zb#

}L

1. *`- PATH 5373d?,k%w_653hCPD73d?,;s!q PATH#

2. %w`-,;s8(|,M'zbD?<D76#

3. %w“7(”#

4. XBt/ InfoSphere Information Server }f#

5. XBt/ ASB zmLrxL#


(}9C ISA Lite $_bT}]b,S("k}]bD,Ss,(}KP IBM Support Assistant (ISA) Lite for InfoSphere Infor-

mation Server $_4bT}]b,S#

PX ISA Lite $_D|`E",kNDPX20i$MJOoODwb#

Z 1 B dCT Netezza }]bDCJ 5

Z 2 B Netezza Enterprise WN

Netezza Enterprise WNG;v}]bWN#(}9C Netezza Enterprise WN,IT+

z?}]4k Netezza Performance Server 8000#

Z9C IBM InfoSphere DataStage +}]4k= Netezza 1,zITS,S!n/O

PxP!q#TZs`}w5,k9C Netezza Connector WN,k Netezza Enter-

prise WN`H,CWN\;a)|CD&\MT\#

g{P9C Netezza Enterprise WNDw5*9C,Sw,k9C“,Sw(F$_”(

Fw5T9C,Sw#

XZ Netezza Performance Server 8000Netezza Performance Server 8000 Gs56}]bh8#

BfG Netezza Performance Server Dw*&\MEc:

v Netezza Performance Server G(E*zcrZ6}]bD51L5G\ (BI) M5q

VvT\hsxhFD#

v (}9C Netezza Performance Server,MI{CICD*E=j<M.[i~#

v Netezza Performance Server 'V9Cj< SQL i/D BI,rxWZ9C#zIT

KPT:Xpi/,x^h<\5lD}]b\m1kTyPI\Di/4w{}

]b#

*{C Netezza Performance Server,k9CICD0k=(M\'VDM'zSZ#

0k=(

+}]4k Netezza Performance Server P=Vfz=(:b?mM nzload#

BfPvKb=V0k=(.dDw*nl:

m 1. Netezza Enterprise WNPD0k=(

b?m nzload

b?mG Netezza Enterprise WNZ}]bP4

(DY1m#bVm|,IC(gV{N=D

}],(g{*:E#g{!qbV0k=

(,G4}]4PD}]+(}b?m0k=

Netezza Performance Server PD?jm#

nzload G;vCZ+}]0k Netezza Perfor-

mance Server D(C>z5CLr#1!iv

B,Netezza Enterprise WNa9CbV0k=

(#

14mP|,1!5R}]ICId`kq=

(g UTF-8 M LATIN9)1,k9Cb?m0

k=(#

1}]IC;BD$(e`kq=R4mP4

|,NN1!51,k9C nzload 0k=(#


m 1. Netezza Enterprise WNPD0k=( (x)

b?m nzload

(}9C CREATE EXTERNAL TABLE |

n,IT+ Netezza }]bD}]4k;tZ

}]bDb?4r+b)}]SCb?4P}

%#b?m0k=((}TB 3 v|n45

V:

v CREATE TABLE:'V4mP?vPD1!5#

v SELECT:Sb?mA!}]#

v INSERT:bMD>5"7(*9CDdkq=#

nzload |nG;v ASCII q=Dz?}]0k

Lr,<ZlY0k}]",1t!vmsD

r;w7DZ]#nzload |n*sz8(D>

q="a?F#V;BT#

!\ nzload |nI?jmD#=}/,+|a

vTyP1!5f6#

b?m0k=(9C INSERT od40k}

]#*4P INSERT |n,;h DML X(

(CREATE TABLE"SELECT M INSERT X

()#

*9C nzload 0k=(,h*kT?jmD

CREATE TABLE M LOAD X(#

TZb?m0k=(,aZ Netezza Perfor-

mance Server 53D .../tmp ?<P4(U>D~#

TZ nzload 0k=(,aZM'z53D .../tmp ?<P4(U>D~#

":19C nzload 0k=(1,k7#4#=3rk?jmD#=3r`,#

CZCJ Netezza Performance Server DM'zSZIBM InfoSphere DataStage v'VT&Z Netezza ~qwDM'zSZ,}g,ODBC

Driver V2.05#ODBC Driver V2.05 {O ODBC 3.0 f6#

IT9CBfPvDM'zSZCJ Netezza Performance Server#

":CJ Netezza Performance Server 1h* ODBC }/Lr#

v CJ Netezza Performance Server 1yhDM'z:

– ODBC M'zSZ:*CJ Netezza Performance Server,Xk20 ODBC M'

zSZ#ODBC M'zJm&CLrMCZ9(&CLrD$_CJ SQL }]

b#

– Netezza M'zSZ:g{*9C nzload 0k=(+}]0k Netezza Perfor-

mance Server,G4Xk20 Netezza M'z#

v CZCJ Netezza Performance Server DI!M'z:

– Microsoft Windows M'zSZ:Windows M'zI NzAdmin(;VyZ GUI

D$_)iI#zIT9C Windows M'zSZ4KP53M}]bYw#

– Web M'zSZ:Web M'zI Webadmin(;VyZ/@wD\mw$_)i

I#zIT9C Web M'zSZ(}#CD Web /@w4`X"\m Netezza

Performance Server 53#

– Linux r Solaris M'zr|nPgf:zIT9C Linux r Solaris M'z4

dk SQL od#Linux r Solaris M'zr|nPgf9a)K;vS<,dP

|, Linux r Solaris M'z53M Netezza |nPgf|n5XDa{/,z

I9CCS<4\m53M}]b#

– JDBC M'zSZ:JDBC M'zJm Java™ LrCJ SQL }]b#


\'VDYw53r=(

zITS}ZKP\'V=(D53,S= Netezza Performance Server#

\'VDYw53r=(|(:

v IBM AIX 6.1

v HP-UX (PA-RISC) 11.0

v Red Hat Linux AS 3.0

v SunOS 5.10

v Microsoft Windows 2008 Server 0|_f>

Netezza Enterprise WND$w==Netezza Enterprise WNG;vAM4DWN#

4WNaS}]4!vz?}],;s+b)}]4k Netezza Performance Server P

8(D?jm#Netezza Enterprise WNDdk}]4ITGm;v}]bWNMzID

D~H#IT9CTB=VICD0k=(.;+}]4k Netezza Performance Server:

b?mr nzload#PX0k=(Dj8E",kND0k=(?V#fsD8v?V+

j8hvgN!q0k=(#

BfD<VpT>K9Cb?mM nzload 0k=(D Netezza Enterprise WN$wwL:

Z 2 B Netezza Enterprise WN 9

AWNaS Netezza Performance Server D8(?jmPRvz?}],;s+b)}

]4k}]4rm;v}]bWN#

9C Netezza Enterprise WNZ9C Netezza Enterprise WN.0,h*Hi$Hvu~#

z9+Kb=gN+ Netezza Enterprise WNmS=w5P#

Hvu~

*9C Netezza Enterprise WN+}]4k Netezza Performance Server,Xk20yh

Di~#;s,XkJ1XdCCWNM53#

20MdCyhDi~

Z20yhD Netezza ~qwMM'zm~.s,Xk9C odbc.ini D~dC}]4#

XZKNq

BfPvK20MdChs:

}L

1. 20 Netezza ~qwMM'z#Netezza Enterprise WN'V Netezza Server 2.05 Patch

4 M|_f>#g{*9C nzload 0k=(,G4Xk20 Netezza M'z#

2. 20MdC Netezza Performance Server a)D nzload 5CLrM ODBC }/L

r#Netezza Enterprise WN9CC ODBC }/Lr4lw?jmrD~D*}]#

7#20C ODBC }/LrD 2.05 f>#C}/Lr{O 3.0 ODBC f6#

3. 7#Z UNIX 53O20"dC DataDirect D ODBC }/Lr\mw#

4. q!kT Netezza Performance Server P?jmDT= LOAD X(#

":PX20MdCOvi~Dj8E"roz,kNDm~f=DD5#

5. Z $DSHOME P4( odbc.ini D~#*4( odbc.ini D~,XkHdC;Z$DSHOME PD .odbc.ini D~,=(GmSX*DE",g}]b{F"wz{

"C'{M\k#PXdC .odbc.ini D~Dj8E",kNDZ UNIX =(Od


C}]4?V#;s,+ .odbc.ini D~DZ]4F=;Z`,;CD odbc.ini D~#r_,IT4(8r .odbc.ini D~Dm4S#

6. J1XhCC'(eD73d?M#f73d?#Bma)KPXgNhCC'(

eD73d?M#f73d?DE"#

m 2. Netezza Enterprise WND73d?

73d? `M hC hv/?D >}

NETEZZA C'(e $NETEZZA 8( Netezza w?< $export NETEZZA=/disk3/

Netezza

NZ_ODBC_INI

_PATH

C'(e $NZ_ODBC

_INI_PATH

8r .odbc.ini D~yZD;C#bG

UNIX 53yhDX

(d?#

$DSHOME/.odbc.ini

APT_DEBUG

_MODULE_NAMES

C'(e $APT_DEBUG

_MODULE_NAMES

r!4TX(#iD

wT{"

o d b c s t m t o d b c e n v

n z e t w r i t e o p" n z u t i l s"

nzwriterep M nzetsubop

PATH #f NETEZZA/bin ;JC ;JC

LIBPATH/

LD_LIBRARY_PATH/

SHLIB_PATH

#f N E T E Z Z A / l i b r

NETEZZA/lib64

;JC ;JC

APT_NETEZZA

_LOAD_FILES

C'(e $APT_NETEZZA

_LOAD_FILES

Netezza U>/msD~D;C

/home/dsadm/nzlogs

APT_TMPDIR C'(e $APT_TMPDIR Netezza U>/msD~D;C

/home/dsadm/nzlogs

APT_NZ_UNIQUE_

KEY_NOT_

ALLOWED

C'(e $APT_NZ_UNIQUE

_KEY_NOT_

ALLOWED

2G<NC'gfP

8(D(;|

APT_NZ_UNIQUE

_KEY_NOT_

ALLOWED=1

a{

Xky]53OKPD=(4hC PATH/LIBPATH/LD_LIBRARY_PATH/

SHLIB_PATH#k9CBmPa)DE"4hC PATH/LIBPATH/LD_LIBRARY_PATH/

SHLIB_PATH#

m 3. X(=(D73d?

=( *hCD73d?

Microsoft Windows PATH

IBM AIX LIBPATH

Solaris M Linux LD_LIBRARY_PATH

HP-UX SHLIB_PATH

v 20 Netezza M'z.s,k|B .../etc/hosts D~#Xk9C Netezza ~qwM

IP X7E"4|BCD~#*9C|na>{CJCD~,k9C etc/hosts |nP#

Z Windows zwP,CD~;Z Windows/system32/drivers/etc P#

":zIT!q(} IBM InfoSphere DataStage !Cer9C|na>{4dC

Netezza Enterprise WN#>wbvhvKgN9C InfoSphere DataStage !Ce4d


CCWN#PX9C|na>{4dCCWNDj8E",kND6IBM InfoSphereDataStage and QualityStage "Pw5_6*"_8O7#

dC}]4

*K\;9C Netezza Enterprise WN,XkJ1XdC}]4#

XZKNq

z+(}TBZ]4KbgN* Microsoft Windows M UNIX dC}]4#

Z Windows =(OdC}]4:XZKNq

Z@fO,%w*< > XFfe > \m$_ > }]4 (ODBC)#

Z“ODBC }]4\mw”T0rP,mSBD}]4{F#*mSBD}]4{F,k

S“4(B}]4”T0rP!qJ1D ODBC }/Lr,;shC`&DN}#

hCN}1,k7#e};A!n#1!ivB,C!n;!P#

Z UNIX =(OdC}]4:XZKNq

*Z UNIX zwO* Netezza Enterprise WNdC}]4{F,XkZ $DSHOME P

4("dC odbc.ini D~#k+TBu?mS= .odbc.ini D~P#

[ODBC Data Sources]NZSQL = NetezzaSQL[NZSQL]Driver = /usr/local/nz/lib/libnzodbc.soDescription = NetezzaSQL ODBCServername = 127.0.0.1Port = 5480Database = devUsername = guestPassword = passwordReadOnly = falseShowSystemTables = falseLegacySQLTables = falseLoginTimeout = 0QueryTimeout = 0DateFormat = 1NumericAsChar = falseSQLBitOneZero = falseStripCRLF = falsesecurityLevel = preferredUnSecuredcaCertFile =

J1XhCC'(eD73d?M#f73d?#

Netezza enterprise WNYw

zIT9C Netezza enterprise WN44PTByPD}]bYw:

v S Netezza Performance Server A!}]#

v 9C nzload rb?m+}]4k Netezza Performance Server#

v |B/|Bek?jmPD}]#


AYw

&ZA!==D Netezza enterprise ICZS Netezza Performance Server PA!m#

B<G;v|,&ZA!==D Netezza enterprise WNDy> InfoSphere DataStage w

5#

4Yw

Z4k==B9C Netezza enterprise WN4PTB|BekYw:+G<ekb?}

]4mP,Sb?}]4mP>}G<#

|B/>}/|BekYwZ upsert ==B9C Netezza Enterprise WNI4P upsert Yw#

upsert Yw|(:

v |Bb?}]4mPDG<#

v >}b?}]4mPDG<#

v |BG<"+dekb?}]4m#

v >}G<"+dekb?}]4m#

9C Netezza Enterprise WN+}]4k Netezza PerformanceServer

*+}]4k Netezza Performance Server,Xk9CICDOE!n4(w5,;s*

Netezza Enterprise WN0ddk4ShC`&DtT#

XZKNq

z+(}TBZ]4KbgN9CICD!n+}]4k Netezza Performance Server#

hCdk4SDtT

Z“WN”!n(O* Netezza Enterprise WNhCtT#

XZKNq

Netezza Enterprise WN;P;vdk4S,CZ+}]4k;vmP#

1Z IBM InfoSphere DataStage !CeP+w Netezza Enterprise WN<j1,aT>

;vT0r#CT0r+T>=v!n(:WNMdk#1!ivB,“dk”!n(

&Zn/4,,C!n(T>“dk”3f#

zIT9C%w“WN”!n(14=D“WN”3f4hC Netezza Enterprise WND#f

tT#PXhCK`tTDj8E",kNDhC Netezza Enterprise WNDtT?V#

zIT9CC3f4hCdk4SDtT,T7(+}]4k Netezza Performance Server

D==#zIT4PBPNq4hCdk4SDtT:

v 8( Netezza Enterprise WNDhv

v hC Netezza Enterprise WNDtT

v 8(+k}]DVxE"

v 8(+k}]DP(e


v 8(dk4SD:ehC

8( Netezza Enterprise WNDhv:XZKNq

9C“dk”3fOD“#f”!n(I8(dk4SDhv#bGI!&\#

hC Netezza Enterprise WNDtT:XZKNq

1!ivB,“dk”3fOD“tT”!n(&Zn/4,#Z“tT”!n(B,z+4

=;vtTPm,dPDtTQ;V* 3 v`p:?j",SM!n#*`-3;t

T,kSCPmP!qCtT#z+ZtTPmTDVNP4=PXy!tTDE

"#kDATBZ],TKbgNhCb)tT#ZKbgNhCb)tT.0,X

kHKb;BU>D~#

U>D~

*KbZNN}]bYwZd"zDmsT0b)YwI&kq,Xki$U>D

~#*KcZiRU>D~,kTb?mM nzload =(DU>D~|{<(gBy>:

v Netezza msU>D~+y]4EH63r(eD APT_NETEZZA_LOAD_FILES r

APT_TMPDIR 73d?4k3v?<#1!ivB,msU>D~+4k Netezza

Performance Server D .../tmp ?<P#b?m0k=(DU>D~{F*:

– NZORCH.<1dAG >_<VxE>.<}]b{F>.nzlog M

– NZORCH.<1dAG >_<VxE>.<}]b{F>.nzbad

v TZ nzload 0k=(,aZM'zzwD .../tmp ?<P4(U>D~#nzload 0

k=(DU>D~*:

– <}]b{F>.<m{F>.<1dAG.p<VxE>.log M

– <}]b{F>.<m{F>.<1dAG.p<VxE>.bad

?j

ZC`pB,Xk8(BP!nD5:

v 0k=(

v m

v 4k=(

v 4k==

Bf+j8hvb)tT#

v 0k=(

8(G*9C nzload 5CLr9G*9Cb?m44k}]#1!0k=(*

nzload#g{z_PkT Netezza Performance Server PD?jmDT= LOAD X

("RZ53P20K Netezza M'z,G4IT9C nzload#qr,&C!q ET(b?m)0k=(#ET 0k=(;*sz_PkT?jmD C R E A T E

TABLE"SELECT M INSERT X(#


":1KPmSKIC ET 0k=(D Netezza Enterprise WNDw51,aZ

Netezza Performance Server D /tmp ?<P(x;G InfoSphere DataStage ~qw

P)4(U>D~#

v m

8(zk*4k}]DmD{F#k9CTBN;=(,TZCVNP8(m{

F:

– =( 1:Z“tT”3fR`DmVNPdkm{F#

– =( 2:ekZ{D5w*w5N}#%w“tT”3fnR`D8k4%,;s%

wekw5N}#

K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g

{#{*Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5t

T”T0rP4(J1D73d?#

(}9C IBM InfoSphere DataStage and QualityStage Administrator M'z,9

I*n?PDyPw54(n?6N}#

v 4k=(

a)K;vCZ+}]4k?jmrZ?jmP|B/|Bek/>}}]D!n#

g{!q4k=( = 4k,G4zIT!q9C>zz? nzload 5CLrr9Cb

?m40k}]#

– 4k==:8( Netezza enterprise WN&gN+}]4k Netezza Performance

Server#zITSTB!nP!q:

- 7S:7SyPP#

- 4(:4(Bm#

- f;:f;VPmrf;VPmPDyPP#g{Cm;fZ,G4+4(B

m#g{?jmfZ,G4+>}Cm"4(Bm#

- XO:XOVPmPDG<#

g{!q4k=( = |B,G4aT>|B==!n#g{!q|B== = |B"

|B;sekr>};sek,r“?j”`pB;aYT>4k==#

– |B==:a)K;vCZy]iO|Z?jmP|B(|B== = |B)G<

"|B;sek(|B== = |Bek)G<">}G<r>};sekG<D

!n#k8(TB5:

- |P:!qXk;S*|RtZiO|;?VD|P{F#

":g{iO||,`v|P,G4&!q;,D|P#g{y!|PX4,

G4 Netezza Performance Server aT>;ums{","R;axP|B#

- (;|P:!q*w*(;|DP#(;|P&CG;vUZ/1d"1dAG

rrE (int/bigint) P#z&Zdk Dataset P*yPG<8((;5#(;|

P;&GiO|D;?V,R;&!qiO|PD|Pw*(;|#Xk*(

;|P8(5#+G,zIT9C APT_NZ_UNIQUE_KEY_NOT_ALLOWED 7

3d?42GC!n#g{hCKC!n,G4|B1;a<G<NC'gf

Oy8(D(;|P#;PZ|B Netezza }]bPDm1Ea<GiO|PD

P#


- I|BDP:!qdk Dataset Ph*|BDP#

":kp!qQ!w|Pr(;|PDP#

- Y1$wm:8(Y1$wmD{F#1!ivB,Y1$wmGI Netezza

Performance Server PD Netezza Enterprise Edition |BekWN44(D#

- >}$wm:!q True I>}Cm0T&DP#!q False I#tCm0T&DP#

,S

ZC`pB,Xk8(BP5:

v }]4:8(}]4D{F#

v }]b:g{9C nzload 0k=(,G4k8(h*,SD?j}]bD{F#k

7#dkD{Fk}]4P8(D}]b{F`,#qr,;a4k}]#g{9

C ET 0k=(,G4;h*}]b{F#bGr* ET 0k=(9C ODBC

DataDirect }/Lr#

":g{za)D}]bj8E";}7,G4zaU=/(#

v \k:8(CZ,S}]bD\k#

v ~qw:8(Z+}]0k Netezza Performance Server 1*9CD~qwD{F#

v ;,}]bPD$wm (TWT):1!5* False#!q True T9C?jm}]b.bDd{}]bPDY1$wm (TWT)#"b,b)}]bXk;Z,;om

Netezza ~qwO#

v TWT }]b:8(h*9CD TWT }]bD{F#

v C':8(CZ,S}]4DC'{#

*8(OvVND5,k9CTBN;=(:

v =( 1:Z“tT”3fR`D`&VNPdkJ1D5#}g,1!q“}]4”1,

ITZT>ZC3fR`D}]4VNP1SdkZ{D}]4{F#

v =( 2:ekZ{D5w*w5N}#%w“tT”3fnR_D8k4%,;s%w

ekw5N}#

K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g{

#{*Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”T

0rP4(J1D73d?#

!n

ZC`pB,Xk8(BP!nD5:

v XOP{F

v r*|n

v XU|n

v >};%dP

v (g{

v Netezza 0k!n


1!ivB,!n`pBavVXU|nMXOP{FVN#I(}“tT”3fRB

GT>DI)mSDtTPm4mSOfa0Dd{tT#Bf+hvOvw!n#

v XOP{F

KVN*I!VN#!q“True”I+P{FXO* Netezza Enterprise WNJmDs!#!q“False”I{9XOVN{F#

v r*|n

KVN*I!VN#kZ%}EP8(J1D|n#Zr*4m.0,Netezza Enter-

prise WNaZyP&mZcOTC|nxPo(Vv"KPC|n#

*8(r*|nD5,k9CTBN;=(:

– =( 1:Z“tT”3fR`Dr*|nVNPdk|n#

– =( 2:ekZ{D5w*w5N}#%w“tT”3fnR_D8k4%,;s%

wekw5N}#



T”T0rP4(J1D73d?#

v XU|n

KVN*I!VN#kZ%}EP8(J1D|n#Z&mCCm.s,Netezza

Enterprise WNaZyP&mZcOTC|nxPo(Vv"KPC|n#

*8(XU|nD5,k9CTBN;=(:

– =( 1:Z“tT”3fR`DXU|nVNPdk|n#


wekw5N}#



T”T0rP4(J1D73d?#

g{8(DXU|n'\,+"zB|ms#Cms+G<Z $DSHOME BD`

&U>D~P#;x,491i/'\1,z}Z4(Dw5D4,ZU>D~

PT+T>* OK#zXki4U>D~T7(i/GqI&#

":w5YwDU>D~;Z $DSHOME P#

v >};%dP

KVN*I!VN#!q“True”IC Netezza Enterprise WN>}kz!q7SDm

DP;%dDyPP#>};%dDP1,z;aU=NN/({"#1!5*

False#g{#tC1!5,G4ZKP1zaU=/({",xRw52+U9#

v (g{

ZCVNP8(VN5rPD(g{#k7#ZCVNP8( ASCII V{#1!(g

{* @#I9C}Uq(“ ”)M,V{(“-”)TbDNN ASCII V{#,V{Q

CwUZ/1d/1dAGD(g{#

*8((g{,k9CTBN;=(:


– =( 1:Z“tT”3fR`D(g{VNPdkZ{D ASCII V{#


wekw5N}#



T”T0rP4(J1D73d?#

":g{!q ET 0k=(,G4 Netezza Enterprise WN+kTQ4PD?vY

w4(b?m#g{4R=b)m,G4+ZU>D~PG<ms,xRCWN

a"T>}4R=Dm#;x,y"zDms;ah9z4(w5#(g{+Z

<NC'gfPxP,$,T'Vrsf]T#

v Netezza 0k!n:C!nICZ8(Z1!ivB ET r nzload 0k=(4a0

D0k!n#0k!na1S+]= nzload 5CLrr ET#

":g{0k=( = nzload,G4kp9CTB0k!n:

– -u

– -pw

– -db

– -df

– -1f

– -bf

– -t

– -delim

– -escapeChar

– -boolStyle

– -encoding

– -nullValue

– -maxErrors

g{0k=( = ET,G4kp9CTB0k!n:

– remotesource

– delimiter

– ignorezero

– ctrlchars

– escapechar

– logDir

– boolStyle

– encoding

– nullValue

Bmc\K Netezza Enterprise WNDtT#


m 4. ?jtT

tT I)!qD5 1!5 GqXh?

0k=( v nzload

v ET

;JC G

m ;JC ;JC G

4k== v 7S

v 4(

v f;

v XO

7S G

|B== TZ|B== = |B/|B;sek:

v (;|P

v |P

v I|BDP

v Y1$wm

v >}$wm

TZ|B== = >}/>};sek:

v |P

v Y1$wm

v >}$wm

True G

m 5. ,StT

tT I)!qD5 1!5 GqXh?

}]4 ;JC ;JC G

}]b ;JC ;JC v G(g{0k=(

* nzload)

v q(g{0k=(

* ET)

\k ;JC ;JC G

~qw ;JC ;JC G

;,}]bPDY1

$wm (TWT)

True/False False v G(g{>}$w

m* True)

v q(g{>}$w

m* False)

TWT }]b ;JC ;JC G

C' ;JC ;JC G

m 6. !ntT

tT I)!qD5 1!5 GqXh?

XOP{F v True

v False

False q


m 6. !ntT (x)

tT I)!qD5 1!5 GqXh?

XU|n ;JC ;JC q

>};%dP True M False False q

Create od ;JC ;JC q

r*|n ;JC ;JC q

(g{ ;JC @ q

Netezza 0k!n ;JC ;JC q

8(+k}]DVxE":

XZKNq

9C“Vx”!n(I8(Z++k}]4k}]b.0gNTb)}]xPVx#

8(+k}]DP(e:

XZKNq

9C“P”!n(I8(+k}]+4k=dPDmDP(e#

8(dk4SD:ehC:

XZKNq

9C“_6”!n(I|Ddk4SD1!:ehC#

hC Netezza Enterprise WNDtTzXkhCtTE\9C Netezza Enterprise WN#

XZKNq

!q“WN”!n(T8(PXCWND#fE"#J1XhCCWNDtT|(:

v 8( Netezza Enterprise WNDhv#

v 8( Netezza Enterprise WNDKP==#

v 8( Netezza Enterprise WNDV{/3d#

TB8v?Vj8hvKOvNq#

8( Netezza Enterprise WNDhv#

bGI!&\#k9C“#f”!n(,Tdk Netezza Enterprise WNDhv#

8( Netezza Enterprise WNDKP==#

*8( Netezza Enterprise WNDKP==,Xk9C“_6”!n(J1XhCTBw

n:

v 4P==:IT+ Netezza Enterprise WNhC*T"P==r3r==4P#Z"

P==B,+IdCD~P8(DICZcy]9C“_6”!n(8(DyPZc

<x4&m*0kD}]#1!ivB,Netezza Enterprise WNT"P==KP#

Z3r==B,w<Zca&m*0kD}]#


v iO==:1!ivB,iO==;hC*T/#(}9CCT/==,Netezza

Enterprise WN+O""PWNyyZDwVd{WN,Sx9b)"PWNZ,;x

LPKP(0aG Netezza Enterprise WN'Vb)"PWN)#

v dCD~:9CC!nI!qMhCJ1DdCD~#*hCdCD~,XkhC

BP!n#

– ZcXMJ4<x#!qC!nI"P4Pzy8(DZcXMJ4X#

– Zc3d<x#!qC!nI"P4PQ(eDZc3dPDZc#zIT(}

1SZZc3d<xVNPdkZc}4(eZc3d#r_,%w/@ [...] 4%,TS“ICZc...”0ZP!qZc"SPmP!qJ1DZc#

8( Netezza Enterprise WNDV{/3d#

v1Z53OtCK NLS(>XoT'V)1,EaZ“WN”3fOT>“NLS 3d”!

n(#9C NLS 3dI(e Netezza Enterprise WNDV{/3d#*(eV{/3

d,k9CTBN;=(:

v =( 1:Z3d{FVNPdkZ{D3d{F#

v =( 2:S3d{FPmP!qJ1D3d(g{P)#

v =( 3:ekZ{D5w*w5N}#%w“tT”3fR`D8k4%,;s%we

kw5N}#



0rP4(J1D73d?#

9C=( 2 a2G10}Z9CDn?rw5D1!V{/3d#

9C Netezza Enterprise WNS Netezza Performance ServerPA!}]

9C Netezza Enterprise WNS Netezza Performance Server PA!}]#

XZKNq

4(;vw5,;s* Netezza Enterprise WN0ddv4ShC`&DtT#

hCdv4SDtT

Z“dv”3fOhCdv4SDtT#

XZKNq

Netezza Enterprise WNP;vdv4S,CZ+}]Ak;vmP#

1Z IBM InfoSphere DataStage !CeP+w Netezza Enterprise WN<j1,aT>

;vT0r#CT0r+T>=v!n(:WNMdv#1!ivB,“dv”!n(

&ZtC4,,C!n(T>“dv”3f#

kZ“dv”3fOhCCZXFS Netezza Performance Server PA!}]D==Dt

T#zIT4PBPNq4hCdv4S:

v 8( Netezza Enterprise WNDhv

v hC Netezza Enterprise WNDtT


v 8(+v}]DP(e

v 8(dv4SD:ehC

8( Netezza Enterprise WNDhv:XZKNq

9C“dv”3fOD“#f”!n(I8(dv4SDhv#bGI!&\#

hC Netezza Enterprise WNDtT:XZKNq

1!ivB,“dv”3fOD“tT”!n(&ZtC4,#Z“tT”!n(B,z+4

=;vtTPm,dPDtTQ;V* 3 v`p:4",SM!n#*`-3;tT,

kSCPmP!qCtT#z+ZtTPmTDVNP4=PXy!tTDE"#

U>D~

*KbZNN}]bYwZd"zDmsT0b)YwI&kq,Xki$U>D

~#*KcZiRU>D~,kTb?mM nzload =(DU>D~|{<(gBy>:

v Netezza msU>D~+y]4EH63r(eD APT_NETEZZA_LOAD_FILES r

APT_TMPDIR 73d?4k3v?<#1!ivB,msU>D~+4k Netezza

Performance Server D .../tmp ?<P#b?m0k=(DU>D~{F*:

– NZORCH.<1dAG >_<VxE>.<}]b{F>.nzlog M

– NZORCH.<1dAG >_<VxE>.<}]b{F>.nzbad

4

ZC`pB,Xk8(BP!nD5:

v A!=(

v m

Bf+j8hvb)tT#

v A!=(

8(gNA!}]#zIT9C Table 5CLr"T/zID SQL odrC'(e

D SQL od#1!5* Table#

v m

8(*SPA!}]DmD{F#

– Z“tT”3fR`DmVNPdkm{F#

– ek5w*w5N}#%w“tT”3fnR`D8k4%,;s%wekw5N

}#


{**Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”

T0rP4(J1D73d?#

(}9C IBM InfoSphere DataStage and QualityStage Administrator M'z,9

I*n?PDyPw54(n?6N}#


,S

ZC`pB,Xk8(BP5:

v }]4:8(}]4D{F#

v }]b:8(h*,SD?j}]bD{F#dkD{FXkk}]4P8(D}

]b{F`,#qr,;aA!}]#

v \k:8(CZ,S}]bD\k#

v ~qw:8(Z+}]i!= Netezza Performance Server 1*9CD~qwD{F#

v C':8(CZ,S}]4DC'{#

*8(OvVND5,k9CTBN;=(:

v Z“tT”3fR`D`&VNPdkJ1D5#}g,1!q“}]4”1,ITZ

T>ZC3fR`D}]4VNP1SdkXhD}]4{F#

v ekXhD5w*w5N}#%w“tT”3fnR_D8k4%,;s%wekw

5N}#


**Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”T0

rP4(J1D73d?#

!n

k8(TBI!tTD5:

v r*|n

v XU|n

v (g{

v r*|n

kZ%}EP8(J1D|n#Zr*4m.0,Netezza Enterprise WNaZyP&

mZcOTC|nxPo(Vv"KPC|n#

*8(r*|nD5,k9CTBN;=(:

– Z“tT”3fR`Dr*|nVNPdk|n#

– ekXhD5w*w5N}#%w“tT”3fnR_D8k4%,;s%wek

w5N}#



T0rP4(J1D73d?#

v XU|n

kZ%}EP8(J1D|n#Z&mCCm.s,Netezza Enterprise WNaZyP

&mZcOTC|nxPo(Vv"KPC|n#

*8(XU|nD5,k9CTBN;=(:

– Z“tT”3fR`DXU|nVNPdk|n#


– ekXhD5w*w5N}#%w“tT”3fnR`D8k4%,;s%w“ek

w5N}”#



T0rP4(J1D73d?#

g{8(DXU|n'\,+"z;IV4ms#Cms+G<Z $DSHOME B

D`&U>D~P#;x,491i/'\1,z}Z4(Dw5D4,ZU>

D~PT+T>* OK#zXki4U>D~T7(i/GqI&#

v (g{

k8( ASCII V{TCwVN5rPD(g{#1!(g{* @#I9C}Uq(“

”)M,V{(“-”)TbDNN ASCII V{#

*8((g{,k9CTBN;=(:

– Z“tT”3fR`D“(g{”VNPdkXhD ASCII V{#

– ekXhD5w*w5N}#%w“tT”3fnR`D8k4%,;s%w“ek

w5N}”#



T0rP4(J1D73d?#

":(g{+Z<NC'gfPxP,$,T'Vrsf]T#

8(+v}]DP(e:

XZKNq

9C“P”!n(I8(+v}]+Ak=dPDmDP(e#

8(dv4SD:ehC:

XZKNq

9C“_6”!n(I|Ddv4SD1!:ehC#

hC Netezza Enterprise WNDtT:

zXkhCtTE\9C Netezza Enterprise WN#

XZKNq

!q“WN”!n(T8(PXCWND#fE"#J1XhCCWNDtT|(:

v 8( Netezza Enterprise WNDhv#

v 8( Netezza Enterprise WNDKP==#

v 8( Netezza Enterprise WNDV{/3d#

TB8v?Vj8hvKOvNq#

8( Netezza Enterprise WNDhv#

bGI!&\#k9C“#f”!n(,Tdk Netezza Enterprise WNDhv#


8( Netezza Enterprise WNDKP==#

*8( Netezza Enterprise WNDKP==,Xk9C“_6”!n(J1XhCTBw

n:

v 4P==:IT+ Netezza Enterprise WNhC*T"P==r3r==4P#Z"

P==B,+IdCD~P8(DICZcy]9C“_6”!n(8(DyPZc

<x4&m*0kD}]#1!ivB,Netezza Enterprise WNT"P==KP#

Z3r==B,w<Zca&m*0kD}]#

v iO==:1!ivB,iO==;hC*T/#(}9CCT/==,Netezza

Enterprise WN+O""PWNyyZDwVd{WN,Sx9b)"PWNZ,;x

LPKP(0aG Netezza Enterprise WN'Vb)"PWN)#

v dCD~:9CC!nI!qMhCJ1DdCD~#*hCdCD~,XkhC

BP!n#

– ZcXMJ4<x#!qC!nI"P4Pzy8(DZcXMJ4X#

– Zc3d<x#!qC!nI"P4PQ(eDZc3dPDZc#zIT(}

1SZZc3d<xVNPdkZc}4(eZc3d#r_,%w/@ [...] 4%,TS“ICZc...”0ZP!qZc"SPmP!qJ1DZc#

8( Netezza Enterprise WNDV{/3d#

v1Z53OtCK NLS(>XoT'V)1,EaZ“WN”3fOT>“NLS 3d”!

n(#9C NLS 3dI(e Netezza Enterprise WNDV{/3d#*(eV{/3

d,k9CTBN;=(:

v =( 1:Z3d{FVNPdkZ{D3d{F#

v =( 2:S3d{FPmP!qJ1D3d(g{P)#

v =( 3:ekZ{D5w*w5N}#%w“tT”3fR`D8k4%,;s%we

kw5N}#



0rP4(J1D73d?#

9C=( 2 a2G10}Z9CDn?rw5D1!V{/3d#

Netezza enterprise WND}]`MTZA!"4kM|B/|BekYw,Netezza enterprise WN'VTB}]`M#

A!YwD}]`M

Netezza Performance Server"ODBC M Orchestrate PD,Hn'V`V Netezza AW

N}]`M#

m 7. Netezza A!WN}]`M

Netezza SQL `M ODBC SQL `M Orchestrate }]`M

INTEGER SQLINT4 Int32

BIGINT SQLINT8 Int64

SMALLINT SQLINT2 Int16


m 7. Netezza A!WN}]`M (x)


NUMERIC SQLNumeric (p, s) decimal (p, s)

Decimal SQLDECIMAL decimal (p, s)

Real SQLFLT4 decimal (p, s)

Double SQLFLT8 decimal (p, s)

Char (n) SQLCHARACTER (n) string (n)

Varchar (n) SQLCHARACTER (n) string (max=n)

Nchar (n) SQLNCHAR ustring (n)

Nvarchar (n) SQLNCHAR ustring (max=n)

Date SQLCHARACTER Date

Time SQLCHARACTER Time

Timestamp SQLCHARACTER Timestamp (n)

BOOLEAN SQLCHAR (1) char (1)

4kYwD}]`M

Netezza Performance Server"ODBC M Orchestrate PD,Hn'V;) Netezza 4W

N}]`M#

m 8. Netezza 4kWN}]`M
















|B/|BekYwD}]`MNetezza Update WN'V`V NetezzaSQL }]`M(g INTEGER M BIGINT)#

Bmc\K Netezza Performance Server"ODBC M Orchestrate }]`M.dD;T;

3d#


m 9. Netezza |B/|BekYwD}]`M
















Text SQLText ;JC


Z 3 B Netezza connector

IZ Netezza connector DfZ,IBM InfoSphere Information Server $_IT,S Netezza

}]b,+}]b*}]<k= InfoSphere Information Server *}]f"bP,"C

J}]bPD}]#,Swa)hFw519C Netezza }]D%;=(#

zIT9C Netezza connector 4PTBYw:

v A!"4k"iR Netezza }]bmPD}]#

v 4(">}MXOm#

v 4P#fiRM!hiRYw#

v +TB*}]<kw5P:

– mMP(e

– Netezza }]bDPm

– m

– S<

– }]bp{

v &myP Netezza }]`M(1ddt`M}b)#

v &m>XoT}]#

9C Netezza connector hFw5zIT9C IBM Netezza connector *"A!"4kM0k}]Dw5,T0+;vw

5PDi~f"Zf"bPTcZm;vw5P4C#

*<.0

i$CZ,S Netezza }]bDC'{Gq_P4Pw5*sDYwyhD(^MX

(#

}L

1. S Netezza 4<k*}]#

2. (e Netezza connector w5#

3. *+ Netezza Connector WNhC*A! Netezza mPD}]:

a. + Netezza connector dC*4#

b. hCdv4SODP(e

c. (e}]A!DC(tT#

d. I!: (e}]Vx==#

4. *+ Netezza Connector WNhC*r Netezza mP4k}]:

a. + Netezza connector dC*?j#

b. hCdv4SODP(e,g{P4*4S8(P(eD0#

c. (e}]4kDC(tT#

d. I!: (e}]Vx==#


5. 9C}C4SiR}]#

6. `k"KPw5#

<k Netezza *}]Z9C Netezza ,SwA/4riR}].0,ITH9C InfoSphere Metadata Asset

Manager <km> Netezza }]4PmMS<D*}]#;sa+<kD*}]#fZ

*}]f"bP#

*<.0

v Z Linux M UNIX OrZ Windows O,y]h*dCT Netezza }]bDCJ#

v 7#TBP}]bTs_P SELECT X(:

– _T_ATTRIBUTE

– _T_CONSTRAINT

– _T_CONST_REFATTR

– _T_CONST_RELATTR

– _T_DESCRIPTION

– _T_OBJECT

– _V_DATABASE

– _V_OBJ_RELATION

– _V_RELATION_COLUMN

– _V_SYNONYM

– _V_VIEW

XZKNq

(}9C Netezza ,Sw,IT<kXZTBJz`MD*}]:

v |, Netezza }]bDwz#

v }]b#

v }]b#=#

v }]bm"53mMS<#yP<kDm<T}]bmDN=f"Z*}]f"b

P#

v }]bP#

}L

9C InfoSphere Metadata Asset Manager <k*}]# PX9C InfoSphere Metadata

Asset Manager <k*}]D|`E",kND IBM Knowledge Center r IBM

InfoSphere Information Server Guide to Managing Common Metadata PD*zz7D

5#

Netezza j6Z Netezza connector P,j6zmZwVm{FtTPdkDm{F,rZV/dk

D SQL odP}CDm{F#j69m>mP#


Netezza 'V|{j6D SQL 1999 (e,|Gn`I|, 128 vVZ#j6P=V

`M:

v #f

v (g

Netezza connector 'Vm{FtTMC'(eDodPD#fj6M(gj6#

#fj6

#fj6xVs!4,Ts4DN=f"Z}]bP##fj6XkTV8*7;|

GD*7;\*}V"B._r@*{E##fj69;\G SQL #tV#Netezza ?

<PD`kIC UTF-8;NNT>D`k+!vZM'z##fj6;\|,TBn:

v V8(NNV8m,x;v^Z-!V8m)

v tZ(}gUo=Y{tZ)

v sNDV

v .xF}V

v B._

v @*{E

(gj6

(gj6C+}E(p,w*Xb<Gn#|GGxVs!4D#Netezza 53;a+(

gj6*;*1!53s!4,2;+CZ(pV{.D+}E#fZ}]bP#(

gj6IT+`,DV8"tZ"sNDV".xF}V"B._w*#fj6|,

Z+}EP,+|9IT|,Uq"XbV{(}g,VEMYVE)T0 SQL #t

X|V#(gj6ITTNNV8"}Vr{E*7#

}C}]bTs

Netezza 'V=6M}6|{#

=6|{CZ}C,;}]bPDTs#}g schema.object-name#

}6|{CZ}C,;om Netezza ~qwOm;v}]bPDTs#}g database-

name.schema.object-name#

9'VYG}6q=#}g database-name..object-name#ZbVivB,58#={

F"hC*10#={F#

":g}]bCJ'Vv^ZA!Yw#Netezza ;'V^D;,}]bPDm#

'VDV{`k

InfoSphere DataStage >XoT'V (NLS) 9z\;9C Unicode V{/&mT>Xo

Tm>D}]#i$?jFczDYw53Gq9C\'VDV{`k#

Netezza ~qw'VTB=VV{`k:

v Latin-9 - CHAR M VARCHAR

v UTF-8 - NCHAR M NVARCHAR

Z 3 B Netezza connector 31

;\xPdC#(}\@rD~"MrSU}]1,9C`,D`k#

(e Netezza connector w5(} Netezza connector,9C InfoSphere DataStage and QualityStage Designer M'z

(ew5#

}L

1. S Designer M'zP,!qK%ODD~ > B(#

2. Z“B(”0ZP,!q"Pw5r~qww5<j,;s%w7(#

3. Z!CeK%PhFwM'zDs_,!q}]b`p#

4. R=IC}]bPmPD Netezza connector,;s%wrB}7Ti4ICDWN#

5. + Netezza Connector WN<jO/=w5hF-<O#

6. dkr^DTBtT:

v Netezza Connector WNr4SD{F:^D,Swr4SD1!{F#zn`

ITdk 255 vV{#mb,z2ITZw5hF-<P^DWNr4SD{

F#

v hv:dkWNr4SDI!hv#

7. %w#f#

B;=v24

(etTT+ Netezza connector w*49C#

A!}]

*9C Netezza connector A! Netezza mPD}],zh*+ Netezza connector d

C*+}]w*44&m#Netezza connector KP SQL od,"+a{5X*cPr

|`P#w*4,,Swi!rA!b? Netezza }]4D}]#

B<T>9C Netezza connector A!}]D>}#ZK}P,Netezza connector

Netezza_Connector_1 A!4T Netezza ~qwD}],;s sequential file WN+

d4k Sequential_File_3 D~#dC Netezza connector A!}]1,;4(;vd

v4S DSoutputLink(gB<y>),|+ Netezza_Connector_1 PDP+d=Sequential_File_3 P#


+ Netezza connector dC*4:

(}+ Netezza connector dC*+}]w*44&m,zIT9C Netezza Connector

WNA!}]#

}L

1. Zw5hF-<O,+w Netezza Connector WN<j#

2. %wdv!n(,;s!q*`-Ddv4S# (}`-dv4S,+ Netezza Con-

nector WNhC*4#

3. !qtT!n(#

4. Z,S?V,8((",Sh*9CD}]4"}]b"C'{M\k#

5. %w#fT#f8(D,ShC#

hCP(e:

zIT9C`FD=(*AYwM4YwhCP(e#9IT(FPxq"#fP(

eT8sC,T0Sf"b0kQ$(eDP(e#

}L

1. Zw5hF-<O,+w Netezza connector <j#

2. ZWN`-wP,!qdv!n(rdk!n(#

3. ZP!n(O,^DPxqT8(*(eD*}]#

a. ZxqZR|%w,"SK%P!qtT#

b. Z“xqtT”0ZP,!qk*T>DtTT0tTDT>3r#;s,%w

7(#

4. 9CTB=(.;4dkmDP(e:

!n hv

=( 1 1. ZP{FPPD`&%*qZ+w,"d

kP{F#

2. TZPPD?v%*q,Z%*qZ+w

"!qyh!n#

3. ZhvPPD`&%*qZ+w,"dk

hv#

< 1. A!}]>}


!n hv

=( 2 1. Z%*qZR|%w,;sSK%P!q

"4`-#

2. Z“`-P*}]”0ZP,dkP*}]#

5. *Z`vP.d2m*}],k!q*2m*}]DwP#

a. R|%w"!q+%5#

b. Z“+%P5”0ZP,!qzk*!(DP2mDtT#

6. *Zf"bP+P(e#f*m(e,k%w#f#

a. Z“#fm(e”0ZPdkJ1DE",;s%w7(#

b. Z“+m(emf*”0ZP,!qzk*CZ#fm(eDD~P,;s%w

#f#

7. *Sf"b0kP(e,%w0k#

a. Z“m(e”0ZP,!qzk*0kDm(e,;s%w7(#

b. Z“!qP”0ZP,9C=r4%+PSICPPmPF/=!(PPmP#

%w7(#

(eA!}]DtT:

zXk(}(eC(tT,dC Netezza connector A!}]1Zw5PDYw==#

*<.0

zXk* Netezza connector dC;v}]b,S(w*4)#

}L


2. %wdv!n(,;s!q*`-Ddv4S#

3. %wtT!n(#

4. ZtT!n(D9Civ?V,8(,SwZw5PgNKP#

a. ZzI SQL VNP8(Gq*ZKP1zI SQL od#

b. ZmVN,8(k*A!Dm#

c. ZtCS}EDj6VNP,8(GI#t DDL M DML odPyPTs{F

Ds!4# 1!5*q#

d. Z Before/After SQL odVN,8(GqZ}]&m.0/.sKP SQL o

d#

5. %w7(T#fywD|D#

Vx}]Tc Netezza connector "PA!}]:

zXk+ Netezza connector dC*4P"PA!;1!ivB,,Sw43rKP#

"PA!8+}].V*}]S/s,(};,D&mZc,1A!}]#Netezza con-

nector 'V#}Vx#(}#}Vx,akTXb Netezza P datasliceid +#}mo=mS= WHERE Sd,TZ&mZc.dV<P#PXVxdCM_-ZcD|`E

",kND6"Pw5*"_8O7#


XZKNq

}L


2. S4SB-PmP!q}C4S(vJC#fiR),;s+iR`M!*#f;

r_!qk*dC*"PA!Ddv4S#

3. +tCVxA!hC*G#

4. %w7(#

a{

KPKw51,SELECT odPD WHERE Sd^D*5XI?v&mZcA!DP

S/#

>}

g{P 4 v&mZc,?v&mZcP<P SELECT od,G4aT>gBZ]:

SELECT col1, col2 FROM table WHERE mod(datasliceid,4)=0SELECT col1, col2 FROM table WHERE mod(datasliceid,4)=1SELECT col1, col2 FROM table WHERE mod(datasliceid,4)=2SELECT col1, col2 FROM table WHERE mod(datasliceid,4)=3

g{z9CC'(eD SQL,"R,SwT"P==A!,G4zPpN7#J1DV

x#*K(zb;}L,,Sw(eK=v<;{TZKP1C5J5f;:

<;{ hv 3rKP1D5

[[node-count]] &mZcD\}#C<;{m>

Netezza connector WND"PT6p,

d5HZ&mZc}#

1

[[node-number]] 10&mZcDSc*<Dw}#}

g,P 4 v&mZc,&mZcw}

* 0"1"2"3#

0

zIT9C<;{ZzD SQL odP4(VxSd#}g:

SELECT * FROM table WHERE mod(datasliceid,[[node-count]])=[[node-number]]

[[node-count]] f;*&mZc\},[[node-number]] f;*10&mZcDSc*<

Dw}#

":datasliceid PGX(Z?vmDXb Netezza P,|;aT/|(ZS<P,g

{h*D0,Xkw7XmS=S<i/D!qPmP#

dC#fiRYw:

}]bWNA!D}]ITw* Lookup WND}C}]#1!ivB,+C}C}]

qd{}C4S;y0kZfP#14P#fiRYw1,Netezza connector lwyP

G<,"Jm Lookup WN&mG<#

*<.0

zXkWH4(;viRYww5#9XkZ Lookup WNDdkMdvWNP(eP#


}L

1. +w Netezza Connector WNTr*4StT0Z#

2. SiR`MB-PmP,!q#f#

3. %wP!n(,"(ek*Sk,Sw,SD}]b9CDP#

4. dCtT!n(ODtT#

a. (e"bT,S?VD,StT#

b. ZC(?V,zIT8(G9CT/zID SQL od9GC'(eD SQL o

d#+zI SQL 8(*Grq#

v g{+zI SQL8(*G,rh*8(m{F,;sZ Lookup WN!qP

!n(PD|P#*8(|P,I+yhDPSw4SO/=}C4S#k

!hiRYwPlwDG<`4,KdCb6Ealwm`G<#

v g{+zI SQL8(*q,rh*Z Lookup WN!qP!n(PD|P#

*8(|P,I+yhDPSw4SO/=}C4S#8(!qodtT#

Z!qodtTPdkTBq=D SELECT od:select * from

table_name#k!hiRYwPlwDG<`4,KdCb6Ealwm`

G<#

c. I!: dCtT!n(ODNNd{tT#

5. %w7(I#f|D#

6. *+dk4S3d=dv4S,IT+w Lookup WNTr*WN`-w#

a. +dk4SPDPO/r4F=dv4SP,T+PmS=dv4S

b. (}%wK%PD<x<j,(eiR'\DNNu~#

c. *iR'\P!qOJD5,"%w7(#g{!q\x,rw5dCPXk

|,\x4SM?jWN,T6qb)G<#

7. %w7(#

8. #f"`k"KPCw5#

dC!hiRYw:

}]bWNA!D}]ITw* Lookup WND}C}]#1!ivB,+C}C}]

qd{}C4S;y0kZfP#g{+ Netezza connector dC*1Sw*}C4S

,S= Lookup WN,zIT+ Netezza connector D iR`MtTdC*“!h”,"

kTiRmP?v+kDPr}]b"Mvp SQL od#

*<.0

zXk4(;viRYww5#

XZKNq

g{;vWNDdkP}?66!Z}]bmPD}CP}?(1:100 rTO),zI

T+ Netezza connector dC*4P!hiRYw,"kTiRmP?v+kDPr}

]b"Mvp SQL od#ZiRYww5P,,SwSUdkWNDG<,;s,S

w1STb?J44PiRYw#;s,,Sw+zIdvG<#

;PZ"Pw5PIT9C!hiR=(#


}L

1. +w Netezza Connector WNTr*4StT0Z#

2. !qiR`MB-Pm,!q!h#

3. %wP!n(,"(ek*Sk,Sw,SD}]b9CDP#

4. dCtT!n(ODtT#

a. (e"bT,S?VD,StT#

b. ZC(?V,zIT8(G9CT/zID SQL od9GC'(eD SQL o

d#+zI SQL 8(*Grq#

v g{+zI SQL8(*G,rh*8(m{FMP!n(PD|Pj8E"#

v g{+zI SQL8(*q,rh*8(!qodtT#Z SELECT odD

select ?V,Pvz#{5X=w5DP#(#CPmaMP!n(PDP%

d#g{CPmkP;%d,G4zh*Zdk3fDtT!n(P!qJ

1D #=-wtT,T5VZ{DP*#TBo(G SELECT odDZ;?

V>}:select Field001,Field002,Field003#

c. ZtT!n(P8(m{F,;s8( WHERE SdT4PiR#WHERE Sd

sfD|PXk|,%J ORCHESTRATE,xRP{F*7XkmS;vdc#

ORCHESTRATE ITGs4r!4V8,}g:ORCHESTRATE.Field001# TB

S E L E C T odG W H E R E SdD;v}7o(>}: s e l e c t

Field001,Field002,Field003 from MY_TABLE where ORCHESTRATE.Field001 =

Field001#X|J ORCHESTRATE .sDP{F&Ck“P”!n(PDP{F

%d#g{CPmkP;%d,G4zh*Zdk3fDtT!n(P!qJ

1D #=-wtT,T5VZ{DP*#

d. I!: dCtT!n(ODNNd{tT#

5. %w7(I#f|D#

6. *+dk4S3d=dv4S,IT+w Lookup WNTr*WN`-w#

a. +dk4SPDPO/r4F=dv4SP,T+PmS=dv4S

b. (}%wK%PD<x<j,(eiR'\DNNu~#

c. *iR'\P!qOJD5,"%w7(#g{!q\x,rw5dCPXk

|,\x4SM?jWN,T6qb)G<#

7. %w7(#

8. #f"`k"KPCw5#

4k}]

*9C Netezza connector +}]4k Netezza m,zh*+ Netezza connector dC

*+}]w*?j4&m#Netezza connector KP SQL od",Sb? Netezza }]

4,,1y]*sek"|Br>}}]#

B<T>9C Netezza connector 4k}]D>}#ZKivB,Sequential File WNA

! Sequential_File_1 D~PD}],;s Netezza C

onnector WNy]h*T Netezza }]bD}]4Pek"|Br>}Yw#


+ Netezza connector dC*?j:

(}+ Netezza connector dC*+}]w*?j4&m,zIT9C Netezza connec-

tor WN4k}]#

}L

1. Zw5hF-<O,+w Netezza Connector WN<j#

2. %wdk!n(,;s!q*`-Ddk4S# (}`-dk4S,+ Netezza Con-

nector WNdC*?j#

3. !qtT!n(#

4. Z,S?V,8((",Sh*9CD}]4"}]b"C'{M\k#

5. 8( TWT 9C%@,S,TmwGqk*9C%@,S"Z%@D}]bP|,Y1$wm (TWT) Mb?m (ET)#

6. %w#fT#f8(D,ShC#

hCP(e:

zIT9C`FD=(*AYwM4YwhCP(e#9IT(FPxq"#fP(

eT8sC,T0Sf"b0kQ$(eDP(e#

}L


2. ZWN`-wP,!qdv!n(rdk!n(#

3. ZP!n(O,^DPxqT8(*(eD*}]#

a. ZxqZR|%w,"SK%P!qtT#

b. Z“xqtT”0ZP,!qk*T>DtTT0tTDT>3r#;s,%w

7(#

4. 9CTB=(.;4dkmDP(e:

< 2. 4k}]>}


!n hv

=( 1 1. ZP{FPPD`&%*qZ+w,"d

kP{F#

2. TZPPD?v%*q,Z%*qZ+w

"!qyh!n#

3. ZhvPPD`&%*qZ+w,"dk

hv#

=( 2 1. Z%*qZR|%w,;sSK%P!q

"4`-#

2. Z“`-P*}]”0ZP,dkP*}]#

5. *Z`vP.d2m*}],k!q*2m*}]DwP#

a. R|%w"!q+%5#

b. Z“+%P5”0ZP,!qzk*!(DP2mDtT#

6. *Zf"bP+P(e#f*m(e,k%w#f#

a. Z“#fm(e”0ZPdkJ1DE",;s%w7(#

b. Z“+m(emf*”0ZP,!qzk*CZ#fm(eDD~P,;s%w

#f#

7. *Sf"b0kP(e,%w0k#

a. Z“m(e”0ZP,!qzk*0kDm(e,;s%w7(#

b. Z“!qP”0ZP,9C=r4%+PSICPPmPF/=!(PPmP#

%w7(#

dCX4P&m:

Netezza connector (}}Kdk}]PDX4P";ek?jmP;fZDP4&mX

4P#zITdC,Sw4liX4P#,Sw9CnbD SQL _-4lbX4P#

XZKNq

,Sw4|5TPxPVi,"y] ROWID PD5TdEr#n|mSDP_POs

ROWID 5#1EPK?v|iOPDPTs,,Swa!qdP;viO"}Ktd

`iO#19C(;|PhC*G1,,Swa9C8(PTzf ROWID#

}L

1. +w Connector WN<jTr*,SwtT#

2. !qdk!n(#

3. !qtT!n(#

4. 8(4k==!n#

5. +liX4P!nhC*G#

6. +X4PYw!nhC*}K# ,Sw;*?v|iO#t;P"}Ktd`P#

1C!nhC*'\1,g{lb=NNX4P,G4w5'\#


a{

Bmc\KtCX4P&m1;,4k==BD,SwP*:

4k== P*

ek !q?v|iODZ;P,vTd`P#g{

?jmP;P|,G4+eky!P#qr,

;I!Yw#

|B !q?v|iODns;P,vTd`P#g

{?jmPfZ%dP,G4+9Cy!P|

B?jm#qr,;I!Yw#

>} P*4Dd#+>}yP%dP#

|B;sek |B:!q?v|iODns;P,vT

d`P#g{?jmPfZ%dP,G4

+9Cy!P|B?jm#qr,;I!

Yw#

ek:!q?v|iODns;P,vT

d`P#g{?jmP;P|,G4+e

ky!P#qr,;I!Yw#

>};sek >}:P*4Dd#+>}yP%dP#

ek:!q?v|iODns;P,vT

d`P#+y!Pek?jm#

YwP y]YwPD5Md{rX,+dkPpVI

iTZ;, SQL odP4P#byM\7#a

{kTnuD+k3r?N&C;P1C=D

a{`,#

dCG<Er:

1!ivB,Netezza connector ;4w73rr?jmekG<#zITtCG<Er

tT8(;vr`v3rP#

XZKNq

G<Er!nICZek"|Bsek">}sekMYwP4k==#tCG<&

m!ns,G<ZS TWT ek=?jm0axPEr#

}L

1. +w Connector WN<jTr*,SwtT#

2. !qdk!n(#

3. !qtT!n(#

4. 8(4k==!n#

5. g{!qKek4k==,G4+1Sek!nhC*q#

6. +tCG<Er!nhC*G#

7. !qP{FtT,;s%w!qP4%T8(Z;v3r|PD{F# Z;v|t

TaT/tC"RGXhD#

8. SPmP!qz*DP#


":zXkAY(e4SOD;vPT9C!nz'

9. I!: R|%w|[1],!qmStT5,;smSd{|P#

10. R|%w|[n]tT(dP,n 8*>}D|Dw},;s!q}%tT5T>}

|#

(e4k}]DtT:

zXkdC4k}]1 Netezza connector Zw5PDYw==#

*<.0

zXk* Netezza connector dC;v}]b,S(w*?j)#

}L


2. %wdk!n(,;s!q*`-Ddk4S#

3. %wtT!n(#

4. ZtT!n(D9Civ?V,8(,SwZw5PgNKP#

a. 8(4k==#

b. Zm{FVNP,8(CZ4k}]D SQL odP9CD?jmD{F# Kt

TGXhtT#zIT9C4(rf;mYwZKP14(m#m{CZzI

}](eoT(DDL)od#zXk+KP1zI4(/>}/XOodtT8(*G,TZKP1zI DDL od#zXk+KP1zI4(/>}/XOodtT8(*q,T9CC'(eD DDL od#

c. ZzI SQL VNP8(Gq*ZKP1zI SQL od#

d. ZtCS}EDj6VNP,8(GI#t DDL M DML odPyPTs{F

Ds!4# 1!5*q#

e. Z SQL VNP,8(OJD SQL od#

f. ZmYwVNP,8(mD4(==,rZVP?jmP`-rekPD=

=#

g. Z Before/After SQL odVN,8(GqZ}]&m.0/.sKP SQL o

d#

5. %w7(#

*4YwxP}]Vx:

zITZ+}]4k Netezza }]b.0,8(VxrU/+k}]D==#z9IT

8(4k}].0&T}]xPEr#

*<.0

VxrU/`MDICT!vZz+ Netezza connector w5hF*"PKP==9G

3rKP==#

v g{+ Netezza Connector WNhC*"PKP==,rVx`MPmIC#g{S

CPmP!q3V=(,G4C=(+2GNN10Vx=(#

v g{+ Netezza Connector WNhC*3rKP==R0;vWNhC*"PKP=

=,rU/`MPmIC#


}L


2. ZWN`-wDsOG,!q*`-Ddk4S#

3. %wVx!n(#

4. SVx`M/U/`MPmP!qVx`M#!qk*4k}]DVxrU/=(`

M#%wVx`MPmT_DtT<j,T8(yhD}]b"5}Mm#

5. %w7(#

9C%@}]bPDY1$wm4P|BekYw:

Netezza connector 'VZm;v}]bP|,Y1$wm (TWT) D&\#*4PNN

|BekYw,Netezza connector Z4P SQL od.0,9CY1$wm (TWT) U

/dk}]#

g{Z%@D}]bPEkY1$wm,rIT=c,$MUd\m#Netezza P;v^

F,4;\|Dm;v}]bPDm,rK19Cb?m1,,Sw9C%@D,S

4kY1$wm#g{+dk,StT TWT 9C%@,S8(*G"dCN},rC&\;$n#g{tC,,Sw+("m;v,S,"9CC,S4r TWT 4k}

]#

|BekYw

*4PNN|BekYw(|B">}"ek;s|B"|B;sekr>};se

k),,SwZ4P SQL od.0,9CY1$wm (TWT) U/dk}]#Xp1

`v&mZcq!}]1,9C TWT IT7#|BekodC=I$bDa{#B<

5w|BekYw:

,Swr;v_LPD\@4kdk}](|MNN|BP),"Zm;v_LP4

P INSERT od(= TWT P),}g:

INSERT INTO TemporaryWorkTable SELECT * FROM ExternalTable

��

��

Netezza ��

�� 2

Netezza Connector

�� 1

��

SQL ��

��

��

�� INSERT

�� UPSERT

��

< 3. upsert Yw


,Sw*?v&mZc4(;v|{\@M;vb?m#&mZcD}?I APT dC

D~P(eD_-Zc}?v(#;s,Swr*|{\@"*<Zm;v_LP4

P INSERT od(1=&mjyP}]*9)#;\&mZcP`Y,,Sw<4(;

v TWT#;s,Sw+dk}]4k\@P#g{;fZdk}],r,Sw+XU\

@,SxjI INSERT odD4P,x,Swa;Bq#1yP&mZc<ek= TWT

Ps,,SwS4PwxL4P|Bekod#

9C}C4SiR}]

zIT(}+ Netezza Connector WN4S= Lookup WND}C4S,9C IBM

Netezza connector 1SiR Netezza mPD}]# Lookup WNG;v&mWN#CZ

iRSd{ITdv}]D"Pw5WNA!=ZfPD Dataset#zIT8(?v}C

4SDu~,TcZzcu~1WNvTC}C4S4PiRYw#

XZKNq

}C4Sm>miRYw#zIT+}C4Sw* Lookup WNDdk4SMd{`M

WN(}g Netezza Connector WN)Ddv4S49C#

}L

1. Zw5hF-<O,+ Netezza connector <jM Lookup WN<jO=w5hF-<O# (Lookup WN;Z!CeK%D&m`pB#)

2. (}+4SS Netezza Connector WNO/= Lookup WN,,Sb=vWN#

3. R|%wC4S,"SK%P!q*;*}C# _d*i_,Tm>K4SG;v

}C4S#

4. (}+w Netezza connector <j,r* Netezza Connector WN`-w#

5. ZWN`-wP,(eWND}]b,SE",;s(e}C4SDAYw# jI

1,%w7(#

6. +iR`M!*#fr!h#

7. (}+w Lookup WN<jTr* Lookup WN`-w#

8. (e Lookup WNDiRYw# `-ws0qT>dk4S,R0qT>dv4

S#b)0qBfT>Kb)4SD*}]#TZ4Tw4SD4 Dataset D?uG

<,Lookup WNTC}C4S,SD?viRm4PmiRYw#miRyZ;i

iR|PD5(?vm;i)#

9. %w7(#

hF1Z,SwPzI SQL odzIT+,SwdC*ZhF1* SQL odtTzI SQL odD>#

*<.0

4(+,Sww*4r?j|,Dw5#

XZKNq

zvI*Z“9(”PmP_PzI SQL od!nDodtTzI SQL odD>#

":Z3)ivB,,Swh*;v,S4zI SQL od#4a)C'{M\kRh

*,S1,I}ZKP ASB zmLr~qDC'(",S#


}L

1. +ww5-<OD,SwTr*WN`-w#

2. Z<=wP,%wdvrdk4S,_e!vZzy4(Dw5`M#

3. +KP1zI SQL hC*q#

4. Zm{FtTP* SQL oddkm{F#

5. kT?jOBDPDw5(dk4S),!qz*Z4==tTPzIDod`

M#

6. ZP3fO,(e*Z SQL odP9CDP#

7. %wtT!n(#

8. %wkodtTX*D9(4%,"SPmP!qzI SQL od#

":zI SQL od!nvICZC,Sw'VZhF1zIDod#Z3)ivB,

,SwvI'VZKP1Dw54PZdzI SQL#

9. %w7(T#fw5#

ZhF1i$,SwPD SQL odzIr`4 SQL ods,ITZw5hFZdi$Kod#

XZKNq

zvI*Z“9(”PmP_P“i$ SQL”!nDodtTi$ SQL odD>#

":Z3)ivB,,Swh*;v,S4i$ SQL od#4a)C'{M\kRh

*,S1,I}ZKP ASB zmLr~qDC'(",S#

}L

1. #fw5#

2. %wkodtTX*D9(4%,"!qi$ SQL#v1odtT|,51,EatC“i$ SQL”!n,"RK!nvICZ?j RDBMS 'Vi$Dod#

a{

,Sw(}9Cd'VD RDBMS $`k SQL od4i$Kod#g{ SQL |,m

s,G4aT>ms{"#

}]`M*;

IBM InfoSphere DataStage 'V;i;,Z Netezza SQL }]`MD SQL }]`M#

(} Netezza connector <k*}]r9C Netezza connector A!}]1,Netezza Con-

nector WN+ Netezza }]`M*;* InfoSphere DataStage }]`M#`4,1(}

Netezza connector +}]4k ?j Netezza m1,InfoSphere DataStage }]`M+*

;* Netezza }]`M#

}]`MS Netezza *;* DataStage:

A!}]1,Netezza Connector WN+ Netezza }]`M*;* InfoSphere DataStage

}]`M#


,y,(} Netezza connector <k*}]s,Netezza }]`M2+*;* IBM

InfoSphere DataStage }]`M#BmT> Netezza }]`MM InfoSphere DataStage }

]`M.dD3dfr#

m 10. Netezza }]`M0dT&D InfoSphere DataStage }]`M

Netezza }]`M InfoSphere DataStage }]`M(SQL `M)

BYTEINT TinyInt

SMALLINT SmallInt

INT Integer

BIGINT BigInt

NUMERIC(p, s) Numeric

FLOAT(p) Float

REAL Real

DOUBLE PRECISION Double

CHAR(n) Char

VARCHAR(n) VarChar

NCHAR(n) NChar

NVARCHAR(n) NVarChar

BOOLEAN Bit

DATE Date

TIME Time

TIME WITH TIME ZONE

":5X;x1xE"D TIME WITH TIME

ZONE 5#

VarChar

TIMESTAMP TimeStamp

INTERVAL

":^(Sb?m0k INTERVAL }]`M#

VarChar

ROWID BigInt

TRANSACTION ID BigInt

DATASLICE Integer

(}Z*}]<kZd!q+ XML Pw* LOB !n,IT+ XML }]`M<k*

LOB#XML PITm>*NNV{."ustring r LOB }]`M#

}]`MS DataStage *;* Netezza:

Z4k}]1,Netezza Connector WNa+ InfoSphere DataStage }]`M*;*

Netezza }]`M#

Z;)ivB,;\<7X5VS InfoSphere DataStage }]`M= Netezza }]`M

D*;#

BmT> InfoSphere DataStage }]`MM Netezza }]`M.dD3dfr#


m 11. InfoSphere DataStage }]`M0dT&D Netezza }]`M

InfoSphere DataStage }]`M(SQL `M) Netezza }]`M

Bit BOOLEAN r BOOL

Char CHAR(64000)"CHAR(n)"NCHAR(16000)

"NCHAR(n)

VarChar V A R C H A R ( 6 4 0 0 0 ) " V A R C H A R ( n )

"NVARCHAR(16000)"NVARCHAR(n)

LongVarChar V A R C H A R ( 6 4 0 0 0 ) " V A R C H A R ( n )

"NVARCHAR(16000)"NVARCHAR(n)

NChar NCHAR(16000)"NCHAR(n)

NVarChar NVARCHAR(16000)"NVARCHAR(n)

LongNVarChar NVARCHAR(16000)"NVARCHAR(n)

Binary ;\'V

VarBinary ;\'V

LongVarBinary ;\'V

Decimal NUMERIC(p)"NUMERIC(p, s)

Double DOUBLE PRECISION r FLOAT(15)

Float REAL r FLOAT(6)"FLOAT(p)

Real REAL r FLOAT(6)

TinyInt BYTEINT

SmallInt SMALLINT

Integer INT

BigInt BIGINT

Numeric NUMBER(38,0)"NUMBER(p, 0)"NUMBER

(38, s)"NUMBER(p, s)

Date DATE

Time TIME(<U|("k)

Timestamp TIMESTAMP(<U|("k)

Unknown VARCHAR(64000)

`k"KP Netezza connector w5+ Netezza connector w5`kIIwH"KPDI4PE>#

}L

1. Z InfoSphere DataStage and QualityStage Designer M'zO,r*k*`kDw5#

2. %w`k4%#

3. g{“`k4,”xrT>ms,k`-Cw5Tbvms#bvmss,%wXB

`k4%#

4. g{w5`kI&,r%wKP4%,"8(w5KP!n:

a. y]h*dkw5N}#

b. %wi$4%i$w5Gq+I&KP,K}L5JO;aT}]xPi!"

*;r4Yw#

c. %wKP4%T}]xPi!"*;r4Yw#


5. *i4i$rKPw5Da{:

a. Z Designer M'zP,!q$_ > KP8>wr* Director M'z#

b. Z“4,”PP,i$w5GqQ(}i$rI&jI#

c. g{w5ri$'\,k!qi4 > U>T7(NNKP1Jb#

6. g{w5fZKP1Jb,k^}Jb"XB`k"i$(I!),;sKPw

5,1=w5I&jI#

JOoO

9C Netezza connector }LP,zI\av=;)ms,(}JOoOMw{tTr

dCD5IhT^}#

,Sms

zI\av=TB,Sms:

m 12. ,Sms

ms`M msj8E" JOoOj8E"

^(0k ODBC

}/Lr

KP Netezza connector DataStage w5

r*}]<kr<r_4Pi4}]

1,zI\av=TBms:9C DSN

NZSQL T testuser C'm],S=}

]b t e s t d b '\#-r:

[ S Q L C O D E = I M 0 0 3 ] [ N a t i v e = 0 ]

[DataDirect][ODBC lib] ^(0k8

(D}/Lr

ms-rI\gB:

v Z Windows 64 ;O20K 64 ;

f>D Netezza }/Lr#b;\

KP,r* Information Server G

Windows OD 32 ;&CLr#

v Z Unix O4}7hCbQw76#

TZ Windows 64 ;53PDms:

1. 7# 32 ;M 64 ;}/Lr<Q

20#

2. 7#9C 32 ;f>D}]4

(ODBC) (eK DSN#32 ;f>

D O d b c a d 3 2 . e x e D~;Z

%systemdrive%\Windows\SysWoW64

D~PP#*Kb Windows 64 ;

OD DSN `XJbD|`j8E

",kNDTBDB: h t t p : / /

support.microsoft.com/kb/942976

TZ U n i x 53ODms,k+

Netezza ODBC }/Lr?< (<nz-

odbc-home>/lib64) |(Z76Qw7

3d?P#

Z AIX 53O,g{}7hCbQw

76sT;"zms,G4zXk*

= Netezza ODBC }/Lr?<

(<nz-odbc-home>/lib64) B"4(T

B{E4S(y]zDhC,I\h

* root C'X():

cd <nz-odbc-home>/lib64ln -s libnzodbc.a libnzodbc.so


http://support.microsoft.com/kb/942976

http://support.microsoft.com/kb/942976

m 12. ,Sms (x)


}]4{F

(DSN) ;}7


r*}]<kr<r_4Pi4}]

1,zI\av=TBms:9C DSN


]b t e s t d b '\#-r:

[ S Q L C O D E = I M 0 0 2 ] [ N a t i v e = 0 ]

[DataDirect][ODBC lib] }]4{F

R;="R48(1!}/Lr

Z U n i x 53O,g{

NZ_ODBC_INI_PATH 4}7hC,z

I\av=TBms:9C DSN NZSQL

T testuser C'm],S=}]b

t e s t d b '\#-r:

[SQLCODE=HY000][Native=33] ~qw

M/rKZtT*U

TZ Windows 53ODms,kt/

}]4 (ODBC) "li DSN {F#

TZ MDI Mi4}],kliCZK

P ASBAgent ~qDJ'#g{

ASBAgent ~qZ53J'BKP,G

4 DSN {FXk(e*53 DSN#

qr,53 DSN MC' DSN <IT

9C#InfoSphere DataStage w5IT

CJ53 DSN MC' DSN#

TZ Unix 53ODms,zXk7#

DSN s!4%d#mk7# ODBCINI

M NZ_ODBC_INI_PATH 73d?hC

}7#ODBCINI Xk8r}7D

odbc.ini D~;NZ_ODBC_INI_PATH

XkhC*}7D odbc.ini D~yZ

D?<#

C'{ /\kJ

b


r*}]<kr<r_4Pi4}]

1,zI\av=TBms:9C DSN


]b t e s t d b '\#-r:

[SQLCODE=28000][Native=24]

“testuser1”C'D\kO$'\

ki$Zw5/MDI r<PGq}7d

kC'{/\kiO#mk7#8(D

C'_P,S=y!}]bD}7(

^#

@p=Jb g{ Netezza ~qw&Z@p=D#$

B"RZzKP Netezza connector w

5r*}]<kr<r_4Pi4}

].04xPO$,G4zI\av

=TBms#9C DSN NZSQL T

testuser C'm],S=}]b

t e s t d b '\#-r:

[ S Q L C O D E = H Y 0 0 0 ] [ N a t i v e = 0 ]

[DataDirect][ODBC lib] Unicode *

;wXOV{

ZKP Netezza connector w5r*}

]<kr<r_4Pi4}].0r

@p=O$#


KP1ms

Netezza connector I&,S= Netezza ~qws,zI\av=TBms:

m 13. KP1ms


#=-wJb 1. nbD4SP

KP Netezza connector w51,z

I\av=TBms:test_table

mPR;=TBdk4SP:col2

2. nbDmP

KP Netezza connector w51,z

I\av=TBms:dk4S#

=PR;=TBP:4T

test_table mD COL2

1w5}C?jmrY1$wmP;

fZDP1,a"znbD4SPm

s#zXk7#zDw5Mm_P`

,DP,r_IT(}+,Swt

T:#=-w → ;%dD4SPYw

hC*>},+,SwdC*>}n

bP#

1?jmrY1$wPD;vr`v

PZ4S#=PR;=1,a"zn

bmPms#zXk7#zDw5M

m_P`,DP,r_IT(}+,

SwtT:#=-w → ;%dDmP

YwhC*vTIUrvTyP,8

>,SwvTnbP#g{nbP;

I*Ur;_P1!5,G4w5T

PI\'\#

Y1$wm

(TWT) ;Z%

@}]bP

Z%@}]bP9CVPY1$wm

1,Netezza connector w5I\'\,

msgB:

R;= twttable m

zXk7#8(K}7D TWT {F,

g{x(j<{F,G4{FDyP

?V<}7#mk7#,SwtTk

T TWT 9C%@,ShC*G,"RStThC*}75#


Z 4 B 73d?:Netezza Connector

Netezza Connector WN9CTB73d?#

CC_GUARDIUM_EVENTShCC73d?T8(,SwGq+ InfoSphere DataStage OBDE"(fx InfoSphere

Guardium Database Activity Monitor#

1C73d?D5QhC1,,Swa+ InfoSphere DataStage OBDE"(}g,}

ZKPWNDwz"n?"w5{"WN{MZcj6)(fx InfoSphere Guardium

Database Activity Monitor#1C73d?Q(e"RhC*NN51,Z("u<,S

.s,,Swa+OBDE"(fx Guardium ~qw#

1C73d?4(e1,,Sw;a"T+OBDE"(fx Guardium ~qw#C7

3d?DhCJCZw5PDyP}]b,Sw#

CC_IGNORE_TIME_LENGTH_AND_SCALEhCC73d?T|D"P-<O,SwDP*#

1C73d?hC* 1 1,T"P}fKPD,SwavT1dAGP8(D$HM!

};#}g,1C73d?D54hC1,"Rg{1dAGPD$H* 26,!};*

6,G4"P-<OD,Swa+1dAGS*"kVfJ#1C73d?D5hC* 1

1,}G49Z1dAGPD$H* 26 R!};* 6 DivBT;hCK"k)9t

T,qr"P-<OD,Sw;a+1dAGSw*_P"kVfJ#

CC_MSG_LEVELhCC73d?T8(,SwZU>D~P(fD{"DnMOXT#

9C1!5 3 1,N<{"M|_OXTD{"a(fAU>D~#

TBPm|,P'D5:

v 1 - zY

v 2 - wT

v 3 - N<

v 4 - /f

v 5 - ms

v 6 - B|

CC_NZ_LOG_LEVELhCC73d?T8(,SwZU>D~P(fD{"DnMOXT#


9C1!5 3 1,N<{"M|_OXTD{"a(fAU>D~#TBPm|,P'

D5:

v 1 - zY

v 2 - wT

v 3 - N<

v 4 - /f

v 5 - ms

v 6 - B|

C73d?k CC_MSG_LEVEL 73d?`,,+G|v0l Netezza Connector {"#

CC_TRUNCATE_STRING_WITH_NULLhCC73d?TXO|,V{. 0x00 DV{.}]#

1C73d?D5QhC,"Rdk}]|,UV{1,aT 0x00 XOdk}],"

*zd`V{.#K73d?JCZ Char"VarChar M LongVarChar InfoSphere

DataStage `MDVN#

CC_TRUNCATE_NSTRING_WITH_NULLhCC73d?TXO|,V{. 0x00 DV{.}]#

1C73d?D5QhC,"Rdk}]|,UV{1,aT 0x00 XOdk}],"

*zd`V{.#

CC_USE_EXTERNAL_SCHEMA_ON_MISMATCH1#=;%d1,hCC73d?T9Cb?#=,x;G9ChF#=#

C#=CZ#=-w#1C73d?D5QhC1,P*#V;d,"R;aSIf

>|DP*#

TMPDIRhCC73d?T8(?<,Tc Netezza Connector ZdP4(8(D\@Tk Linux

r UNIX Yw53OD Netezza xP(E#

Cd?98(yPYw53O Netezza U>D~D?<#


=< A. z7(z&\!n

zITq!PX IBM z7D(z&\!n4,DE"#

IBM InfoSphere Information Server z7#iMC'gf";j+'V(z&\!n#

PX IBM z7D(z&\!n4,DE",kND;ZTBx7D IBM z7(z&

\!nE":http://www.ibm.com/able/product_accessibility/index.html#

ICJD5

IBM Knowledge Center a)KkTz7D_P(z&\!nDD5#IBM Knowledge

Center Ts`} Web /@wPIi4D XHTML 1.0 q=JVCD5#IZ IBM

Knowledge Center 9C XHTML,rKzIZ/@wPhCT>W!n#b9Jmz9

CA;JAwMd{(z<uCJD5#

9T PDF D~N=a)K IBM Knowledge Center ZDD5,xb) PDF D~";

_8j{D(z&\!n#

IBM M(z&\!n

kND IBM Human Ability and Accessibility Center,Tq!PX IBM T(z&\!

nDP5D|`E"#


http://www.ibm.com/able/product_accessibility/index.html

http://www.ibm.com/able

=< B. A.|nPo(

>D59CXbV{4(e|nPo(#

TBXbV{(eK|nPo(:

[ ] j6I!Td?#4T=(E(pDTd?GXhD#

... 8>zIT*0fDTd?8(`v5#

| 8>%bE"#zIT9CVt{s`rR`DTd?#z;\Z%v|nP

,19Cb=vTd?#

{ } 1h*;i%bTd?PD3;vTd?1,Tbi%bTd?xP(g#g

{Td?I!,G4T=(E ([ ]) +b)Td?(p#

":

v ;vTd?PDnsV{}G 256 v#

v T%}Er+}E(p_P6kUqDTd?5#

}g:

wsetsrc[-S server] [-l label] [-n name] source

source Td?G wsetsrc |nyhD(;Td?#x=(EDd{Td?mwb)T

d?I!#

wlsac [-l | -f format] [key... ] profile

ZK>}P,-l M -f q=Td?%bRI!#profile Td?GXhD#key Td?I

!#zZ key Td?sD!TE (...) m>IT8(`v|{F#

wrb -import {rule_pack | rule_set}...

ZK>}P,rule_pack M rule_set Td?%b,+GXk8(dP;vTd?#mb,

!TE (...) m>IT8(`vfr|rfr/#


=< C. gNA.o(<

TBfrJCZKE"P9CDo(<:

v Ss=R"SO=BXPD76A!o(<#9CTB<(:

– >>--- {Emwo(<*<#

– ---> {Emwo(<ZB;PLx#

– >--- {Emwo(<SO;P#

– --->< {Emwo(<ax#

v XhnT>Z.=P(w76)O#

�� required_item ��

v I!nT>Zw76B=#

�� required_itemoptional_item

��

g{I!nT>Zw76O=,G4Cn;0lo(*XD4P,vCZIAT#

��optional_item

required_item ��

v g{ITS=nr|`nPxP!q,G4b)na91T>ZQ;P#

g{Xk!qdP;vn,G4Q;D3vnaT>Zw76O#

�� required_item required_choice1required_choice2

��

g{!q3vnGI!D,G4{vQ;aT>Zw76B=#

�� required_itemoptional_choice1optional_choice2

��

g{3vnG1!n,G4|aT>Zw76O=,d`!naT>Zw76B

=#

��default_choice

required_itemoptional_choice1optional_choice2

��

v ZwPO=5XAs`D}7mwIX4Dn#


�� required_item � repeatable_item ��

g{X4}7|,:E,G4XkT:E4VtX4n#

�� required_item �

,

repeatable_item ��

;ZQ;O=DX4}7mwITX4Q;PDn#

v P1,Xk+;E<pVI,N#o(,Nkwo(<V*T>,+G&+b),

NZ]Sw;Z<Dw76O4A!#

�� required_item fragment-name ��

Fragment-name:

required_itemoptional_item

v X|V0dnLu4(g{JC)Ts4T>#d44XkkT>Dj+;B#

v d?+?T>*!41eV8(}g,column-name)#m>C'a)D{Fr5#

v g{Z<PDwX|V0N}.d4T>NNjc{E,G4&AYT;vUq4

Vtb)X|VMN}#

v j+4<Py>,dkjc{E"(E"cuKc{Md{{E#

v E"Tx(ED}VN=T>,}g (1)#


=< D. *5 IBM

zIT*5 IBM q!M''V"m~~q"z7E"M#fE"#2ITr IBM a

)Tz7MD5D4!#

BmPvKM''V"m~~q"`5T0z7Mbv=8E"DJ4#

m 14. IBM J4

J4 hvM;C

IBM Support Portal zIZTBX7!qPK$Dz7Mwb4(

F'VE":www.ibm.com/support/entry/portal/

S o f t w a r e / I n f o r m a t i o n _ M a n a g e m e n t /

InfoSphere_Information_Server

m~~q zIZ;ZTBX7Dbv=8>cOiRP

Xm~" I T M5qI/~qDE":

www.ibm.com/businesssolutions/

vT/~q (}Z;ZTBX7D“vT/~q”>cO4

(J',zIT\mzcT:X(<u'Vh

s"8r IBM Web >cME"D4S:

www.ibm.com/account/

`5kO$ zIZTBX7KbPX<u`5ML}~q

DE",b)~qG(*vK"+>M+2z

9q!",$ME/ IT <\xhFD:http://

www.ibm.com/training

IBM zm zIT(}TB>c*5 IBM zmTKbwV

bv=8:www.ibm.com/connect/ibm/us/en/


http://www.ibm.com/support/entry/portal/Software/Information_Management/InfoSphere_Information_Server



http://www.ibm.com/businesssolutions/

http://www.ibm.com/account/

http://www.ibm.com/training

http://www.ibm.com/training

http://www.ibm.com/connect/ibm/us/en/

=< E. CJz7D5

D5T`Vq=a):*z IBM Knowledge Center"I!D>X20DE"PD,T

0 PDF i.#zIT1SSz7M'zgfCJ*zr>X20Doz#

IBM Knowledge Center nJZiR InfoSphere Information Server DnBE"#IBM

Knowledge Center |,s`}z7gfDoz,T0W~PyPz7#iDj{D5#

zI(}Q20Dz7r_S Web /@wr* IBM Knowledge Center#

CJ IBM Knowledge Center

P`V==ICJ*zD5:

v %wM'zgfROGPDoz4S#

v 4 F1 |#(#,4 F1 |ar*hvKC'gf10OBDDwb#

":F1 |Z Web M'zP;pwC#

v Z Web /@wPdkX7,}g,1z4G<=Cz71#

dkTBX7TCJ InfoSphere Information Server D5DyPf>:

http://www.ibm.com/support/knowledgecenter/SSZJPZ/

g{z#{CJX(wb,kZ URL P9Cz7j6"D5e~{FMwb768

(f>E#}g,KwbD 11.3 f>D URL gBy>#(⇒ {E8>PLx):

http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/⇒com.ibm.swg.im.iis.common.doc/common/accessingiidoc.html

a>:

C*6PD9P;vrL URL:

http://ibm.biz/knowctr

*8(X(z73f"f>rwbDrL URL,kZrL URL Mz7j6.d9C

.E (#)#}g,yP InfoSphere Information Server D5DrL URL GTB URL:

http://ibm.biz/knowctr#SSZJPZ/

Kb,TOwbDrL URL(4(T"|LD URL)*TB URL(⇒ {E8>P

Lx):

http://ibm.biz/knowctr#SSZJPZ_11.3.0/com.ibm.swg.im.iis.common.doc/⇒common/accessingiidoc.html

|Doz4ST}C>X20DD5

IBM Knowledge Center |,D5DnBf>#+G,IT+D5D>Xf>w*E"

PD20,"+oz4SdC*8rKE"PD#g{zDs54a)TrXxDC

J,G4>XE"PDa\PC#


9CE"PD20|f=D208>E"4+d20=y!FczO#20"t/E

"PDs,ITZ~qcFczO9C iisAdmin |nT|Dz7 F1 Moz4Sy}

CDD5;C#(⇒ {E8>PLx):

WindowsIS_install_path\ASBServer\bin\iisAdmin.bat -set -key ⇒com.ibm.iis.infocenter.url -value http://<host>:<port>/help/topic/

AIX LinuxIS_install_path/ASBServer/bin/iisAdmin.sh -set -key ⇒com.ibm.iis.infocenter.url -value http://<host>:<port>/help/topic/

dP,<host> G20E"PDDFczD{F,<port> GE"PDDKZE#1!K

ZEG 8888#}g,Z9C1!KZD{* server1.example.com DFczO,URL

5+* http://server1.example.com:8888/help/topic/#

q! PDF M2=4D5v PDF D~i.IZ_q!,"ISTB'VD5CJ:https://www.ibm.com/support/

docview.wss?uid=swg27008803&wv=1#

v 2ITZ_):r(}z1XD IBM zm):2=4q=D IBM vfo#*Z_

):vfo,kCJ;Z http://www.ibm.com/e-business/linkweb/publications/servlet/

pbi.wss D IBM vfoPD#


https://www.ibm.com/support/docview.wss?uid=swg27008803&wv=1

https://www.ibm.com/support/docview.wss?uid=swg27008803&wv=1

http://www.ibm.com/e-business/linkweb/publications/servlet/pbi.wss

http://www.ibm.com/e-business/linkweb/publications/servlet/pbi.wss

=< F. a)PXz7D5D4!

zITa)PX IBM D5DPozD4!#

zD4!+PzZ IBM a)_J?DE"#zIT9CTBN;=(4a)b{:

v *a)PXZ IBM Web >cOP\D IBM Knowledge Center PwbDb{,k

G<"(}%wCwbW?DmSb{4%4mSb{#TbV==a;Db{I

)+Zi4#

v *+PX IBM Knowledge Center PwbDb{"Mx IBM "9d{NNK<^(

i4Cb{,kG<"%w IBM Knowledge Center W?D4!4S#

v 9C www.ibm.com/software/awdtools/rcf/ ODZ_A_b{m4"Mb{#

v (}r [email protected] "MgSJ~4"Mb{#k|,z7D{F"z7

Df>E,T0JOD{FMiE(g{IC)#g{zTX(D>"mb{,k

"wZ]D;C(}g,jb"m`Er3k)#


http://www.ibm.com/software/awdtools/rcf/

ywMLj

>E"G*Z@za)Dz7M~q`4D#IBM I\Td{oTa)>JO#+G,

I\h*z5PCoTDz7rz7f>D1>E\xPCJ#

yw

IBM I\Zd{zRrXx;a)>D5PV[Dz7"~qr&\XT#PXz10

yZxrDz7M~qDE",krz1XD IBM zmI/#NNT IBM z7"L

rr~qD}C"GbZw>r5>;\9C IBM Dz7"Lrr~q#;*;V8

IBM D*6z(,NN,H&\Dz7"Lrr~q,<ITzf IBM z7"Lrr

~q#+G,@@Mi$NNG IBM z7"Lrr~q,rIC'TP:p#

IBM +>I\Q5Pr}Zjkk>D5Z]PXDwn({#a)>D5"4ZhC

'9Cb)({DNNmI#zITCif==+mIi/Dy:

IBM Director of Licensing

IBM Corporation

North Castle Drive

Armonk, NY 10504-1785 U.S.A.

PX+VZV{/ (DBCS) E"DmIi/,kkzyZzRrXxD IBM *6z(

?E*5,rCif==+i/Dy:

Intellectual Property Licensing

Legal and Intellectual Property Law

IBM Japan Ltd.

19-21, Nihonbashi-Hakozakicho, Chuo-ku

Tokyo 103-8510, Japan

>un;JC"zrNNbyDunk1X(I;;BDzRrXx:INTERNA-

TIONAL BUSINESS MACHINES CORPORATION“4V4”a)>vfo,;=PNN

V`D(^[Gw>D9G5,D)#$,|(+;^Z5,DPXGV("JzM

JCZ3VX(C>D#$#3)zRrXxZ3);WP;Jmb}w>r5,D

#$#rK>unI\;JCZz#

>E"PI\|,<u=f;;<7DX=r!"ms#K&DE"+(Z|D;b

)|D+`k>vfoDBf>P#IBM ITf1T>JOPhvDz7M/rLrxP

DxM/r|D,x;mP(*#

>E"PTG IBM Web >cDNN}C<;G*K=cp{Ea)D,;TNN==

d1TG) Web >cD#$#G) Web >cPDJO;G IBM z7JOD;?V,

9CG) Web >cx4DgU+IzTPP##

IBM IT4|O*J1DNN==9CrV"zya)DNNE"x^kTzP#NN

pN#


>LrD;mI=g{*KbPXLrDE"To=gB?D:(i)JmZ@"4(

DLrMd{Lr(|(>Lr).dxPE";;,T0(ii)JmTQ-;;DE

"xP`%9C,kkBPX7*5:

IBM Corporation

J46A/G4

555 Bailey Avenue

San Jose, CA 95141-1003 U.S.A.

;*qXJ1Du~Mun,|(3)iNBD;(}?D6Q,<IqCb=fD

E"#

>JOPhvDmILr0dyPICDmIJOyI IBM @] IBM M'-i"IBM

zJm~mI-irNN,H-iPDuna)#

K&|,DNNT\}]<GZ\X73PbCD#rK,Zd{Yw73PqCD

}]I\aPwTD;,#P)b?I\GZ*"6D53OxPD,rK;#$k

;cIC53OxPDb?a{`,#Kb,P)b?G(}Fcx@FD#5Ja

{I\aPnl#>D5DC'&1i$dX(73DJC}]#

f0G IBM z7DE"ISb)z7D)&L"dvf5wrd{I+*qCDJO

Pq!#IBM ;PTb)z7xPbT,2^(7OdT\D+7T"f]TrNNd

{XZG IBM z7Dyw#PXG IBM z7T\DJb&1rb)z7D)&La

v#

yPXZ IBM 44=rrbrDyw<If1|DrUX,x;mP(*,|Gvv

m>K?jMb8xQ#

>E"vCZf.D?D#ZyhvDz7OP.0,K&DE"aP|D#

>E"|,ZU#5qYwP9CD}]M(fD>}#*K!I\j{X5wb)

>},>}PI\a|(vK"+>"7FMz7D{F#yPb){V<Gi9

D,tV5znP5J5qs59CD{VMX7kK`F,?tIO#

f(mI:

>E"|(4oTN=Dy>&CLr,b)y>5w;,Yw=(OD`L=(#

g{G*4UZ`4y>LrDYw=(OD&CLr`LSZ(API)xP&CLr

D*""9C"-zrV"*?D,zITNNN=Tb)y>LrxP4F"^D

"V",x^kr IBM 6Q#b)>}"4ZyPu~Bw+fbT#rK,IBM ;

\##r5>b)LrDI?T"I,$Tr&\#y>Lr<G“4V4”a)D,

;=PNNV`D#$#TZ9CKy>Lry}pDNNp5,IBM +;P#pN#

2b)y>LrD?]=4rdNN?VrNN\zz7,<Xk|(gBf(y

w:

©(s+>D{F)(j)#K?VzkGy] IBM +>Dy>Lr\zv4D#©

Copyright IBM Corp. (dkj]). All rights reserved.

g{z}Zi4>E"Dm=4,<,MJ+<}I\^(T>#


~=_T"bBn

IBM m~z7(|,m~4~qbv=8(“m~z7”))I\a9C cookie rd{

<uU/z79CE",TozDFnUC'ei"(FknUC'D;%rCZd

{?D#Zm`ivB,m~z7;aU/vKIj6E" (PII)#RGD3)m~z7

ITozzU/vKIj6E" (PII)#g{Km~z79C cookie 4U/vKIj6

E" (PII),G4PXCz79C cookie DX(E"gByv#

y]?pDdC,Km~z7I9Ca0rVC cookie#g{4Pvz7ri~,G4

Cz7ri~;a9C cookie#

m 15. InfoSphere Information Server z7Mi~9C cookie

z7#i i~r&\?~

yCD cookie `M U/K}] }]C> {C cookie

NN(tZ

InfoSphere Informa-

tion Server 20)

InfoSphere Informa-

tion Server Web X

F(

v a0

v VC

C'{ v a0\m

v O$

^({C

NN(tZ

InfoSphere Informa-

tion Server 20)

InfoSphere Metadata

Asset Managerv a0

v VC

^vKIj6E"

(PII)v a0\m

v O$

v v?C'WCT

v %cG<dC

^({C

I n f o S p h e r e

DataStage

Big Data File WN v a0

v VC

v C'{

v }V){

v a0j6

v a0\m

v O$

v %cG<dC

^({C

I n f o S p h e r e

DataStage

XML WN a0 Z?j6 v a0\m

v O$

^({C

I n f o S p h e r e

DataStage

IBM InfoSphere

D a t a S t a g e a n d

QualityStage Opera-

tions Console

a0 ^vKIj6E"

(PII)v a0\m

v O$

^({C

InfoSphere Data

Click

InfoSphere Informa-

tion Server Web X

F(

v a0

v VC

C'{ v a0\m

v O$

^({C

InfoSphere Data

Quality Console

a0 ^vKIj6E"

(PII)v a0\m

v O$

v %cG<dC

^({C

I n f o S p h e r e

QualityStage Stan-

dardization Rules

Designer

InfoSphere Informa-

tion Server Web X

F(

v a0

v VC

C'{ v a0\m

v O$

^({C

InfoSphere Informa-

tion Governance

Catalog

v a0

v VC

v C'{

v Z?j6

v wD4,

v a0\m

v O$

v %cG<dC

^({C

ywMLj 67

m 15. InfoSphere Information Server z7Mi~9C cookie (x)

z7#i i~r&\?~

yCD cookie `M U/K}] }]C> {C cookie

InfoSphere Informa-

tion Analyzer

I n f o S p h e r e

D a t a S t a g e M

Q u a l i t y S t a g e

Designer M'zP

D Data Rules WN

a0 a0j6 a0\m ^({C

g{*Cm~z7?pDdCrza)Kw*M'(} cookie Md{<uU/nUC'

vKIj6E"D\&,z&CTPwsPXK`}]U/JCDNN(ID(Ib

{,|(Gqh*"vyw0wC,b#

PX+|( cookie ZZDwV<uCZb)C>D|`E",kND IBM D~=_T

(x7* http://www.ibm.com/privacy)M IBM DZ_~=yw(x7* http://

www.ibm.com/privacy/details)Pjb*“Cookies, Web Beacons and Other Technolo-

gies”D?VT0“IBM Software Products and Software-as-a-Service Privacy Statement”(x

7* http://www.ibm.com/software/info/product-privacy)#

Lj

IBM"IBM UjM ibm.com® G International Business Machines Corp Z+rm`>(

xrZ"aDLjr"aLj#d{z7M~q{FI\G IBM rd{+>DLj#

I B M LjD10PmITZ W e b Oq!,x7*:w w w . i b m . c o m / l e g a l /

copytrade.shtml#

BPwnGd{+>DLjr"aLj:

Adobe G Adobe Systems Incorporated Z@zM/rd{zRrXxD"aLj#

Intel M Itanium G Intel Corporation rdS+>Z@zMd{zRrXxDLjr"

aLj#

Linux G Linus Torvalds Z@zM/rd{zRrXxD"aLj#

Microsoft"Windows M Windows NT G Microsoft Corporation Z@zM/rd{zR

rXxDLj#

UNIX G The Open Group Z@zMd{zRrXxD"aLj#

Java MyPyZ Java DLjMUjG Oracle M/rdX*z9DLjr"aLj#

United States Postal Service 5PTBLj:CASS"CASS Certified"DPV"LACSLink"

ZIP"ZIP + 4"ZIP Code"Post Office"Postal Service"USPS T0 United States Postal

Service#IBM Corporation G United States Postal Service DG@< DPV M LACSLink

mI$VP_#

d{+>"z7r~q{FI\Gd{+>DLjr~qjG#


http://www.ibm.com/privacy

http://www.ibm.com/privacy/details

http://www.ibm.com/privacy/details

http://www.ibm.com/software/info/product-privacy

http://www.ibm.com/legal/copytrade.shtml

http://www.ibm.com/legal/copytrade.shtml

w}

[A]20MdChs 10

[B]>XoT'V(NLS) 31

m 15, 22

;,}]bPDY1$wm (TWT) 16

[C]Yw53/=( 9

iRYw 43

z7(z&\!n

(z&\!n 53

z7D5

CJ 61

[D]r*|n 17, 23

(g{ 17, 24

(ew5 32

A 10

AYw 13

hCP(e 33, 38

8(}]Vx 35

AWN 9

A!=( 22

A!}] 21

A}]`M 25

[F](Iyw 65

CJ(

Netezza }]b 2

~qw 16, 23

[G]Ev 7

|BekYw

Y1$wm 42

|B/>}/|BekYw 13

XU|n 17, 23

[H]73d?

Neteeza Connector 51

[J]WNYw

hCP(e 33, 38

XOP{F 17

[K]M'zSZ 8

M''V

*5 59

[L],S 16, 23

P(e

hC (setting up) 33, 38

[M]\k 16, 23

|n

o( 55

|nPo(

<( 55

?j 14

[P]dC 35

G<Er 40

dC}]4 12

[R]U>D~ 14, 22

m~~q

*5 59

[S]>};%dP 17

Lj

Pm 65

hF1~q

ZhF1zI SQL od 43

ZhF1i$ SQL od 44

hC73d? 11

hCtT 13, 20, 21, 24

9CU>D~ 18

dv4S 21

}]

A! 33

}]b 16, 23

}]`M 26

<k}] 45

A!}] 45

4k}] 45

0k}] 45

DataStage 45

Netezza 45

}]4 16, 23

4( 1, 2

tT

(e 41

[T]XbV{

Z|nPo(P 55

[W]b?m 7

b?m$wwL 9

*}]bhC73d?

hC 3, 4

[X]Hvu~ 10, 12

4Yw 13

(etT 41

hCP(e 33, 38

8(}]Vx 41

4WN 9

4k=( 15

4k}] 13

4}]`M 26

!n 16, 23


[Y]i$(validation)

KP 46

}C4S 43

3d

}]`M 45

C' 16, 23

o(

|nP 55

4 22

*}]

<k 30

[Z]'V

M' 59

8( Netezza Enterprise WNDhv 20,

24

8( Netezza Enterprise WND4P==

20, 25

8( Netezza Enterprise WNDV{/3d

21, 25

0k=( 7, 9, 10, 14

V{`k 31

w5

`k"KP 46

CCC_NZ_LOG_LEVEL 73d? 51

Ddsenv E> 4

LLinux 1

NNetezza 10

Netezza j6

#fj6 31

(gj6 31

Netezza *}]

<k 30

Netezza connector

`k"KPw5 46

#fiR 35

AYw

(etT 34

A!}] 32

Netezza connector (x)

CJ 32

Ev 29

JOoO 47

dCX4P&m 39

dC*?j 38

dC*4 33

}]`M 44

!hiR

Yw 36

4k}] 37

QVx}] 35

Zw5P9C 29

Netezza Enterprise WN 7, 9, 10, 12, 13,

20, 21, 24

Netezza ODBC }/Lr

dC 1

Netezza Performance Server 7, 8, 9, 10,

13, 21, 25, 26

Netezza Performance Server 8000 7

Netezza Update WN 26

Netezza Upsert WN 26

nzload 7

nzload $wwL 10

OODBC }/Lr

dC 1, 2

TTMPDIR 73d? 51

TWT }]b 16

Uupsert Yw 13

WWeb >c

G IBM 57

Windows OD}]4

4( 2

Windows OD ODBC }/Lr

dC 2


��

Printed in China

SC43-1052-00

netezzaperformance server s8opublibfp.boulder.ibm.com/epubs/pdf/c4310520.pdf · 2015. 3. 10. ·...

Documents