ChannelDB2

October 2010 Blog Posts (10)

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

Personal data could become commodity

I think this should be a reality.
Companies that want to make use of the personal information people put online should pay for it, the US Consumer Electronics Association (CEA)
has said.
http://www.bbc.co.uk/news/technology-11571513

Added by Jeffrey P. Hebert on October 19, 2010 at 3:38pm — No Comments

What software application gets hacked the most?

Oracle's Java framework has surpassed Adobe applications as the most
attacked software package, according to a Microsoft researcher who
warned she was seeing “an unprecedented wave of Java exploitation.”
http://www.theregister.co.uk/2010/10/19/unprecedented_java_exploits/

Folks ought to consider DB2 more.

Added by Jeffrey P. Hebert on October 19, 2010 at 3:30pm — 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

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service