ที่่ผ่านมาก็ดูแต่ certification roadmap ของ JAVA วันนี้เลยอยากรู้ว่า IBM DB2 เป็นอย่างไร
โดย ทั่วไปแล้วก็เหมือนกับ JAVA ครับคือมี 3 Level โดยต้องผ่าน fundamental เพื่อให้เข้าใจพื้นฐานการทำงานโดยทั่วไปของเค้าก่อน เมื่อได้ดูจากรูปข้างล่างคิดว่าคงอธิบายได้เข้าใจง่ายกว่าครับ
Added by fuangwith on April 21, 2009 at 1:56pm —
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
. 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 —
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 —
Added by agatha on April 14, 2009 at 10:41pm —
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 —
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 —
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 —
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 —
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… Continue
Added by Paweł Myrczek on April 8, 2009 at 1:00am —
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
Command: db2 RUNSTATS ON TABLE ABC.\"ABCDE_FGHIJKLM\" WITH DISTRIBUTION AND DETAILED INDEXES ALL ALLOW WRITE ACCESS
SQL2310N The utility could not generate statistics. Error "-930"… Continue
Added by Paweł Myrczek on April 7, 2009 at 4:15pm —
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 —
เมื่อพูดถึงเรื่อง dead lock หลายคนคงถอนหายใจเพราะเคยเจอกันมาบ้างไม่มากก็น้อย
ปัจจัยที่ทำให้เกิด dead lock ไม่ว่าจะบน client, server, windows app, web หรือแม้กระทั่ง database นั้น
การรอกันเพื่อใช้งานทรัพยากร์ สามารถดูตัวอย่างการเกิด deadlock ได้ที่… Continue
Added by fuangwith on April 3, 2009 at 2:30pm —
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 —
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 —
Added by scotthayes on March 29, 2009 at 6:51am —
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 —
ปกติถ้าเราจะ insert ข้อมูลลง database โดยเอาข้อมูลจาก
table อื่นมาก็มักจะใช้ insert ... select ... แบบนี้
เพราะเขียนสั้น ง่ายดี แต่ใน DB2 นั้นบางทีถ้าข้อมูลที่
select ขึ้นมานั้นมีปริมาณมากๆ อาจะไม่หมูอย่างทีคิดก็เป็นได้
เพราะการใช้ insert....select..... นั้นการทำงานดังรูป
Added by fuangwith on March 11, 2009 at 6:38am —
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 —
Added by sariosman on February 23, 2009 at 2:12am —
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 —