ChannelDB2

September 2010 Blog Posts (11)

IBM DB2 9.7 for Oracle Professional @ Thailand

วันที่ 20-21 กันยายน 2553 ที่ผ่านมาได้มีโอกาสเข้าร่วม Bootcamp: IBM DB2 9.7 for Oracle Professional ที่ IBM Thailand มาครับ งานนี้ฟรีครับ ประทับใจมากครับตั้งแต่เรื่องของกินยังเรื่องสอบ cert. ครับ
ฟังๆไปเหมือนง่ายจะไม่น่าสนใจสำหรับชาว ChannelDB2 เ่ท่าไหร่เพราะน่าจะเชียวชาญคล่องแคล่วกับ DB2 กันอยู่แล้ว แต่ก็ขอเอามาเล่าให้ฟังว่า งานนี้เค้า compare DB2 กับ Oracle ในหลายๆมุม โดยเฉพาะเรื่องโครงสร้าง แต่ไม่เน้นไปว่าอะไรดีอะไรไม่ดี วิทยากรเค้าบอกว่าเอามาเปรียบเทียบกันไม่ได้ แหม..…
Continue

Added by fuangwith on September 22, 2010 at 2:48pm — 3 Comments

Oracle database crashes JPMorgan Chase web site

Last week, over 16 million customers of America’s second largest bank were unable to access their accounts or process online payments for a good part of the week. Angry customers, hit by late charges for

scheduled payments that didn’t go out, are venting their frustrations on

Twitter.

The site first went down Monday and came back up after a 24 hour

complete blackout but many customers say connectivity was…

Continue

Added by Jeffrey Hebert on September 20, 2010 at 3:01pm — 1 Comment

InfoSphere Change Data Capture V6.5 released for real-time data integration

From the IBM Press release : "InfoSphere Change

Data Capture V6.5 and InfoSphere Change Data Delivery V6.5 introduce

new capabilities that continue to extend and improve real-time data integration

across heterogeneous environments. These advancements include enhanced monitoring,

debugging, and improved multibyte character set (MBCS) configuration. InfoSphere Change

Data Capture V6.5 also helps address the need for increasing data volumes

by providing performance… Continue

Added by gstef on September 20, 2010 at 11:07am — 1 Comment

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

Guide on Installation of DB2 9.7.2 Steps

Hello Readers,

This is for those who are new to DB2 9 or DB2 9.7.2 Beginners.

This blog explain the installation of IBM DB2 9.7.2 step by step.

The… Continue

Added by Rakesh Tiwari on September 11, 2010 at 9:00am — 4 Comments

Disaster Recovery, High Availability, and Continuous Availability - What's the Difference?

Last month I posted a video that gave a brief overview of how data replication is used for continuous availability. I then got ask why I used the term continuous availability instead of high availability or disaster recovery. "What's the difference?" Well, while these solutions have a lot of overlap and can usually be built from some of the same components, they can have different objectives. Different objects can…
Continue

Added by david t on September 7, 2010 at 12:30am — 1 Comment

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

Featured Downloads

Try BLU Acceleration on Cloud

© 2017   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service