All Blog Posts (286)

DB2 Certification roadmap

ที่่ผ่านมาก็ดูแต่ certification roadmap ของ JAVA วันนี้เลยอยากรู้ว่า IBM DB2 เป็นอย่างไร

โดย ทั่วไปแล้วก็เหมือนกับ JAVA ครับคือมี 3 Level โดยต้องผ่าน fundamental เพื่อให้เข้าใจพื้นฐานการทำงานโดยทั่วไปของเค้าก่อน เมื่อได้ดูจากรูปข้างล่างคิดว่าคงอธิบายได้เข้าใจง่ายกว่าครับ

ref:… Continue

Added by fuangwith on April 21, 2009 at 1:56pm — No Comments

How long it takes to insert 1M rows into DB2?

Many times people ask me if DB2 will be fast enough for their application. They are usually most worried about INSERT performance. Often acceptable performance means ability to insert 1k rows per second. Can DB2 do that? To get decent insert performance from DB2 you must turn

autocommit off and use

prepared statement. This is pretty simple to do and DB2 can insert that way about 5k rows per second into moderate sized (about 1GB) table. Its slightly faster (7k rows per… Continue

Added by Radim Kolar on April 19, 2009 at 9:01am — No Comments

IDUG Europe 2009 - presentation grid

Dear friend of IDUG Europe 2009, The IDUG 2009 Europe conference will feature over 100 hours of peer-reviewed technical presentations, written and delivered by the most sought-after DB2 experts in the world: DB2 Gold Consultants, vendor experts, IBM Distinguished Engineers, IBM Fellows, IBM Vice Presidents, and most importantly, DB2 users worldwide. the call for abstracts brought around 500 presentations to choose from, and the grid will be developed… Continue

Added by Aurora Dellanno on April 15, 2009 at 1:28pm — No Comments

NEW: DB2 on Campus Quarterly Newsletter

See: NEW: DB2 on Campus Quarterly Newsletter

Added by agatha on April 14, 2009 at 10:41pm — No Comments

Presentation at SF RUG

I had the opportunity to present along with Kevin Poole at the San Francisco regional user group at San Ramon. We filled the entire day with 4 presentations and a sponsored lunch:

- Expert Tools to Advise you with DB2 for z/OS

- SQL Tuning for Everyone: Using DB2 Optimization Service Center

- Effective backup and recovery for DB2 on z/OS with Utilities/Tools

- Using Fast Replication for Improved DB2 Data Accessibility

We had over 40 attendees and received great… Continue

Added by Jay Bruce on April 10, 2009 at 3:41pm — No Comments

Expert Tools Presentation at IDUG Denver

I'll be at Denver to present Expert Tools to Advise You with DB2 for z/OS on Wednesday at 2:45 to 3:45 in rm 113.

I hope to see you all there. Leave a response on this blog if you want to touch base with me.

Added by Jay Bruce on April 9, 2009 at 9:46pm — No Comments


Some time ago IBM published the information that the DB2 version 8.2 will not be supported after the 30 April 2009.

All existing databases should be migrated to the latest DB2 version 9.5

Sometimes there are problems. Recently I migrated one server on which I had a few instances.

There was a problem with one instance.

A process db2start2 used from 30 to 40% of the resources.

In the logs there is information to increase CATALOGCACHE_SZ DB… Continue

Added by Paweł Myrczek on April 8, 2009 at 6:46am — No Comments

syscatspace, check and increase the size

There comes a moment when I need to enlarge the space for the syscatspace.

We get an alert that the space is used in almost 100%.

And what then?

It all depends on the management system have taken.

In DB2 8.x you can choose the SMS and DMS.

In the first case, the space will always be used at 100%, the operating system itself will increase in the volume measure of the data.

When we are dealing with a DMS can be established to develop options that the… Continue

Added by Paweł Myrczek on April 8, 2009 at 3:40am — No Comments

problems with the performance,

Sometimes there is a problem with the performance of certain applications to appeal to the resources collected in db2.

Response time increases in application performance decreases.

Then you must review the contents of the file and locate the error nfy even like this:

ADM4500W A package cache overflow condition has occurred. There is no error

but this indicates that the package cache has exceeded the configured maximum

size. If this condition persists, you…

Added by Paweł Myrczek on April 8, 2009 at 1:00am — No Comments

runstats - SQL2310N The utility could not generate statistics. Error "-930" was returned

From time to time I meet with the following problem related to the implementation of current administrative tasks.

One of the most popular error is:

SQL2310N The utility could not generate statistics. Error "-930" was returned



SQL2310N The utility could not generate statistics. Error "-930"…

Added by Paweł Myrczek on April 7, 2009 at 4:15pm — No Comments



I would like to create my own blog, where I will be publishing solutions to various problems related to the DB2 version 8.x and 9.5.

It will be a mixture of information from different fields of knowledge and level of advancement. From the trivial, the more complex, such as tuning of databases.

I can not guarantee the regularity of entries, but that's beside the point.
Waiting for any comments.

Have a good read :)

Added by Paweł Myrczek on April 7, 2009 at 3:50pm — No Comments

How to find out the SQL statements causing db2 deadlock?

เมื่อพูดถึงเรื่อง dead lock หลายคนคงถอนหายใจเพราะเคยเจอกันมาบ้างไม่มากก็น้อย

ปัจจัยที่ทำให้เกิด dead lock ไม่ว่าจะบน client, server, windows app, web หรือแม้กระทั่ง database นั้น

ล้วนเกิดจากการที่ชุดคำสั่งตั้งแต่สองชุดขึ้นไปใช้ทรัพยากรณ์ในระบบร่วมกันโดยขาดการควบคุมที่ดี จึงก่อให้เกิด

การรอกันเพื่อใช้งานทรัพยากร์ สามารถดูตัวอย่างการเกิด deadlock ได้ที่… Continue

Added by fuangwith on April 3, 2009 at 2:30pm — 6 Comments

You do not want to be an Einstein to Innovate:

What is Difference between ‘Invention’ and ‘Discovery’?

If I throw this question to you all; I can expect, at least 80% of people will give right answer. The expectation is high, because in schools or in colleges we have been educated about the invention, discovery and its differences. Now, if I put this question, what is the difference between invention and innovation? How many of us will answer correctly?

The Answer - Invention is bringing an idea to practical or… Continue

Added by Vinod Kumar A on April 3, 2009 at 4:51am — No Comments

So the machine came. Now the only challenge left is getting everything that was supposed to be included.

So the machine came. Now the only challenge left is getting everything that was supposed to be included. Continue

Added by Roger Miller on March 30, 2009 at 7:24pm — No Comments

The PureXML Challenge - TURKEY

IBM Turk University Relations Team is running project very successfully. 1100 student registered, 150 teams are competing from different universities and different cities all over Turkey.

April 1st, they will submit final reports and 25th of April, Top 10 teams will be presenting their project to committee. Then on 27th of April,

Award Ceremony will take place!

We run this challenge under the name GREAT MINDS , last year we had the first challenge and we had 1300+… Continue

Added by Jale on March 28, 2009 at 11:56am — No Comments


ปกติถ้าเราจะ insert ข้อมูลลง database โดยเอาข้อมูลจาก

table อื่นมาก็มักจะใช้ insert ... select ... แบบนี้

เพราะเขียนสั้น ง่ายดี แต่ใน DB2 นั้นบางทีถ้าข้อมูลที่

select ขึ้นมานั้นมีปริมาณมากๆ อาจะไม่หมูอย่างทีคิดก็เป็นได้

เพราะการใช้ นั้นการทำงานดังรูป


วันนี้ผมเลยขอแนะนำการ… Continue

Added by fuangwith on March 11, 2009 at 6:38am — No Comments

Final call for presentations: IDUG Europe 2009

Presenting at IDUG 2009 - Europe gives you the opportunity to share your experiences, challenges and fresh approaches with hundreds of fellow DB2 professionals from around the world. Submit your intent to present at IDUG 2009 - Europe, 5-9 October in Rome, Italy by this Friday 27 February and as an added bonus, those selected to present technical sessions at IDUG 2009 - Europe receive a complimentary conference registration (value = EUR 1950). IDUG is… Continue

Added by Aurora Dellanno on February 24, 2009 at 9:05am — No Comments

İts delicious


Added by sariosman on February 23, 2009 at 2:12am — No Comments

Attempt to create the database "SAMPLE" failed.

I installed DB2 Express-C in my computer running in Windows Vista Home Premium OS. But as I run First Steps and install SAMPLE database, I encountered this error Attempt to create the database "SAMPLE" failed.
SQL5005C System Error.
Please help. Thanks!

Added by Roel Sarsaba on February 13, 2009 at 10:41am — 2 Comments

Monthly Archives












Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service