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

Latest Activity

Fabrizio Napolitano commented on Yunfeng Sun's blog post Configure Federation Server ODBC Wrapper to Netezza
"Hi , very good article thank you.   Have you had any experiences in writing to Netezza through Federation Server? is there a way to use ODBC array insert functionality? to speed up inserts?   thanks for any comment Fabrizio"
Mar 15, 2011
Yunfeng Sun posted a blog post

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 ==>…See More
Nov 17, 2010
Yunfeng Sun posted a blog post

Configure Federation Server ODBC Wrapper to Netezza

System and SoftwareAIX 5.3.0.0InfoSphere Federation Server v9.7 fixpack 3 ODBC driver v4.5.4 provided by Netezza.IBM branded Datadirect ODBC driver manager 6.0Setup StepsConfigure connectivity from ODBC Driver to Netezza Server1. Copy Netteza driver to IBM branded Datadirect ODBC driver manager library directory2. Configure DSN(Netteza server information) in odbc.ini3. Use example program in IBM branded Datadirect ODBC driver manager to test the connectivity from ODBC to Netezza ServerConfigure…See More
Nov 15, 2010
Yunfeng Sun posted a blog post

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=42881ExplanationDBPARTITIONNUM don't support nickname column as argument.Check the document:…See More
Nov 2, 2010
Yunfeng Sun posted a blog post

Query Oracle nickname returns SQL1097N error

Problemselect * from ora_nickSQL1097N The node name was not found in the node directory.And there is following error in db2diag.log2010-10-21-18.43.05.633000-420 E44694087H664 LEVEL: ErrorPID : 2424 TID : 4780 PROC : db2syscs.exeINSTANCE: DB2 NODE : 000 DB : FEDDBAPPHDL : 0-145 APPID: *LOCAL.DB2.101022014258AUTHID : USEREDUID : 4780 EDUNAME: db2agent (FEDDB) 0FUNCTION: DB2 UDB, net8 wrapper, Net8_Connection::error_report, probe:30DATA #1 : String, 28 bytesOracle Error - Current UserDATA #2 :…See More
Oct 26, 2010
Yunfeng Sun posted a blog post

One case for SQL1101N error in Federation Server

Problem--login to system as user 1[root@aixdb2]# su - user1$ db2 connect to feddbCREATE WRAPPER "DRDA"LIBRARY 'libdb2drda.a'OPTIONS (DB2_FENCED 'N');CREATE SERVER "S"TYPE DB2/AIXVERSION '9.7'WRAPPER "DRDA"OPTIONS(DBNAME 'RDB');--define user mapping for user1.CREATE USER MAPPING FOR USER --> USER here means current userSERVER "S"OPTIONS(REMOTE_AUTHID 'ruser',REMOTE_PASSWORD 'password');CREATE NICKNAME nick1 FOR "S"."ruser"."t1";[root@aixdb2]# su - user2$ db2 connect to feddb$ db2 "select *…See More
Oct 23, 2010
Yunfeng Sun's blog post was featured

Create nickname to DB2/i table with number(38,0) column fails with SQL0901N error

Problem DATASD3 is cataloged DB2/i (DB2 AS400) database. db2 connect to DATASD3 user user1 using PASSWORDDatabase Connection InformationDatabase server = OS/400 5.4.0SQL authorization ID = USER1Local database alias = DATASD3 db2 "create table tn(c1 NUMERIC(38 , 0))"DB20000I The SQL command completed successfully.db2 "select * from tn "SQL30020N Execution of the command or SQL statement failed because of asyntax error in the communication data stream that will affect the successfulexecution of…See More
Oct 19, 2010
Yunfeng Sun posted a blog post

Create nickname to DB2/i table with number(38,0) column fails with SQL0901N error

Problem DATASD3 is cataloged DB2/i (DB2 AS400) database. db2 connect to DATASD3 user user1 using PASSWORDDatabase Connection InformationDatabase server = OS/400 5.4.0SQL authorization ID = USER1Local database alias = DATASD3 db2 "create table tn(c1 NUMERIC(38 , 0))"DB20000I The SQL command completed successfully.db2 "select * from tn "SQL30020N Execution of the command or SQL statement failed because of asyntax error in the communication data stream that will affect the successfulexecution of…See More
Oct 17, 2010
Yunfeng Sun posted blog posts
Oct 13, 2010
Yunfeng Sun posted a blog post

Executing packages get SQL0525N error after nickname drop and recreate

Notice:The content here is verified on DB2 v97fixpack 0.QuestionsThere are a number of changes (such as adding new columns) in the datasource tables. As a result, we must drop and recreate the nicknames for any tables included in the changes. Hence all of our dependent packages are getting set to VALID=NO resulting in -525 errors at execution time.SQL0525N The SQL statement cannot be executed because it was in error at bind time for section = section-number package = pkgschema.pkgname…See More
Oct 12, 2010
Yunfeng Sun posted a blog post

Does Federation Server support ORACLE Internet Directory LDAP Server?

QuestionNeed to know if I can configure Federation to use Oracle Internet Directory (OID) LDAP Server.Our Oracle Server is upgraded to 11g, the ONAME and TNSNAMES files will no longer be used on the machine that Federation server resides. Therefore OID will be installed astheir LDAP Server, and add the ONAMES and TNSNAMES files to the LDAPServer for all application to access. So any change is needed on configure Federation Server to use OID?AnswerFirst read the following document to understand…See More
Oct 8, 2010
Yunfeng Sun replied to mauro piva's discussion performance issues with postgres + jdbc + InfoSphere federation Server 9.7 in the group DB2 for Linux, UNIX, Windows
"-901 is a internal error in DB2 LUW - some error condition that DB2/Federation can not assign a proper SQL code. You need to contact IBM support resolve the problem. BTW, you may use Federation ODBC wrapper to connect to postgres . That could have…"
Oct 7, 2010
Yunfeng Sun's blog post was featured

Questions about Federation in DPF environment

Questions:We are installing federation server on a 40 node DPF (MPP) database. 1. Do I have to install federation on all of the nodes or just the coordinating node. 2. Do I need wrappers, servers, user mappings and nicknames on all of the nodes or just the coordinator node.Answers:1. Please install federation on all of the nodes because in a DPF(MPP) system, any partition could be potentially a coordinator where the application connect to and the SQL statement compiled. The SQL could be…See More
Sep 23, 2010
Yunfeng Sun posted a blog post

How to check Function Mapping with INFIX in system catalog view?

Question I create a function mapping WITH INFIX: CREATE FUNCTION SIMPLET1(timestamp, timestamp) RETURNS TIMESTAMP AS TEMPLATE NO EXTERNAL ACTION DETERMINISTIC;CREATE FUNCTION MAPPING MAPSIMPLET1 FOR SIMPLET1(TIMESTAMP,timestamp) SERVER S3 OPTIONS (REMOTE_NAME 'SIMPLET1') WITH INFIX;How do I know the Function Mapping with INFIX or not in the system catalog view ? I check SYSCAT.FUNCMAPPARMOPTIONS,SYSCAT.FUNCMAPOPTIONS,SYSCAT.FUNCMAPPINGS, but I can not find any option is related to…See More
Sep 16, 2010
Yunfeng Sun posted blog posts
Sep 15, 2010

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