Yunfeng Sun
  • Male
  • Beijing
  • China, mainland
Share on Facebook Share on Facebook Share

Yunfeng Sun's Friends

  • zenjinquan
  • Xie Zhipeng
  • david t

Yunfeng Sun's Groups

Gifts Received


Yunfeng Sun has not received any gifts yet

Give a Gift


Yunfeng Sun's Page

Profile Information

Full Name:
Yunfeng SUN
Job Title:
Software Engineer
Platforms of Interest:

Yunfeng Sun's Blog

Difference of db2dj.ini, export, DB2LIBPATH and DB2ENVLIST

Posted on November 17, 2010 at 9:30pm 0 Comments

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 ==>…


Configure Federation Server ODBC Wrapper to Netezza

Posted on November 15, 2010 at 10:30pm 1 Comment

System and Software


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

How to use DBPARTITIONNUM against nickname?

Posted on November 2, 2010 at 4:30am 0 Comments

"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".

DBPARTITIONNUM don't support nickname…

Query Oracle nickname returns SQL1097N error

Posted on October 26, 2010 at 10:30am 0 Comments


select * from ora_nick
SQL1097N The node name was not found in the node directory.

And there is following error in db2diag.log


Comment Wall (1 comment)

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

At 7:43am on August 17, 2010, Leons Petrazickis said…
Welcome to ChannelDB2. We are glad to see you joining the DB2 community online. Feel free to check out the many videos on ChannelDB2:

If you haven't done so already, you may want to download DB2 Express-C:

Or get the free DB2 book:


Try BLU Acceleration on Cloud

© 2016   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service