ChannelDB2

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

Yunfeng Sun's Friends

  • zenjinquan
  • Xie Zhipeng
  • david t

Yunfeng Sun's Groups

Gifts Received

Gift

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
Company:
...
Platforms of Interest:
Linux/UNIX/Windows

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

Continue

Configure Federation Server ODBC Wrapper to Netezza

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

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

How to use DBPARTITIONNUM against nickname?

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

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

Query Oracle nickname returns SQL1097N error

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

Problem


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


And there is following error in db2diag.log


2010-10-21-18.43.05.633000-420…
Continue

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:
http://www.channeldb2.com/video

If you haven't done so already, you may want to download DB2 Express-C:
http://www.channeldb2.com/page/download-now

Or get the free DB2 book:
http://www.channeldb2.com/page/free-book

Cheers!
 
 
 

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service