ChannelDB2

Yunfeng Sun's Blog – November 2010 Archive (3)

Difference of db2dj.ini, export, DB2LIBPATH and DB2ENVLIST

Here's the difference between export and db2dj.ini:

Normally when you an export an environment variable and then start a child process, the child process inherits all the environment variables that were exported to the parent process. See ==>…

Continue

Added by Yunfeng Sun on November 17, 2010 at 9:30pm — No Comments

Configure Federation Server ODBC Wrapper to Netezza

System and Software

AIX 5.3.0.0

InfoSphere Federation Server v9.7 fixpack 3

ODBC driver v4.5.4 provided by Netezza.

IBM branded Datadirect ODBC driver manager 6.0



Setup Steps



Configure connectivity from ODBC Driver to Netezza… Continue

Added by Yunfeng Sun on November 15, 2010 at 10:30pm — 1 Comment

How to use DBPARTITIONNUM against nickname?

Problem
"n1" is a nickname for DB2 LUW datasource:


db2 "select * from n1 where DBPARTITIONNUM(c1) = current node"
SQL0391N Invalid use of the row based function "SYSIBM.DBPARTITIONNUM".
SQLSTATE=42881


Explanation
DBPARTITIONNUM don't support nickname…
Continue

Added by Yunfeng Sun on November 2, 2010 at 4:30am — No Comments

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service