Yunfeng Sun's Blog (15)

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

Query Oracle nickname returns SQL1097N error

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

Added by Yunfeng Sun on October 26, 2010 at 10:30am — No Comments

One case for SQL1101N error in Federation Server

Problem

--login to system as user 1

[root@aixdb2]# su - user1

$ db2 connect to feddb

CREATE WRAPPER "DRDA"

LIBRARY 'libdb2drda.a'

OPTIONS (DB2_FENCED 'N'

);

CREATE SERVER "S"

TYPE DB2/AIX

VERSION '9.7'

WRAPPER "DRDA"

OPTIONS

(DBNAME…

Continue

Added by Yunfeng Sun on October 23, 2010 at 6:13am — No Comments

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 PASSWORD

Database Connection Information…

Continue

Added by Yunfeng Sun on October 17, 2010 at 10:00pm — No Comments

Which db2fmp is for Federation?

Question

If a wrapper is created in fenced mode, the fenced library will be loaded into db2fmp process. But there are many db2fmp in my system, how can I know which db2fmp is used by Federation?

Answer

On UNIX/Linux , first use the "ps" to find all db2fmp process ID, then use the…

Continue

Added by Yunfeng Sun on October 13, 2010 at 9:22pm — No Comments

ETNTE statement reports -1476/30080 error instead of warning

Question

I'm using ETNTE( Error Tolerant Nested Table…

Continue

Added by Yunfeng Sun on October 13, 2010 at 8:00am — No Comments

Executing packages get SQL0525N error after nickname drop and recreate

Notice:

The content here is verified on DB2 v97fixpack 0.

Questions

There are a number of changes (such as adding new columns) in the…

Continue

Added by Yunfeng Sun on October 12, 2010 at 6:00am — No Comments

Does Federation Server support ORACLE Internet Directory LDAP Server?

Question

Need 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 as

their LDAP Server, and add the ONAMES and TNSNAMES files to the LDAP

Server for all application to access.

So any change is…

Continue

Added by Yunfeng Sun on October 8, 2010 at 4:37am — No Comments

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…

Continue

Added by Yunfeng Sun on September 16, 2010 at 10:30am — No Comments

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…

Continue

Added by Yunfeng Sun on September 15, 2010 at 4:00am — No Comments