ChannelDB2

Yunfeng Sun's Blog – September 2010 Archive (5)

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

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service