ChannelDB2

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

How to resolve SQL0552N error for NNSTAT?

Problem


db2 => connect to feddb


Database Connection Information…


Continue

Added by Yunfeng Sun on September 15, 2010 at 3:30am — No Comments

What privileges will be needed for NNSTAT?

1. For v91 and V95 , A temporary tablespace (WRAPPER1) will be created.
The privilege of "create user temporary tablespace" will be need
If error reported, one option is to bind the db2stats.bnd by a dbadm user again or grant SYSCTRL or SYSADM authority)




2. NNSTAT has 2 methods to update the nickname's statistics:
2.1 For catalog-based method, NNSTAT will create temp nickname to get the statistics, and drop them…
Continue

Added by Yunfeng Sun on September 15, 2010 at 3:30am — No Comments

InfoSphere Federation Server Documents

InfoSphere Federation Server V9.7 infocenter:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp

InfoSphere Federation Server V9.5 infocenter:

-https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp

WebSphere Federation Server V9.1…

Continue

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

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service