August 2009 Blog Posts (9)

Deadlocks

Commands which can save your ass ;)

db2 get snapshot for dynamic sql on dbname > dynsql_Prod.out
db2 get snapshot for locks on dbname > locks.out
db2 get snapshot for applications on dbname > app.out
db2 get snapshot for bufferpools on dbname > bufferpools.out

Added by Paweł Myrczek on August 26, 2009 at 9:00am — No Comments

Immediate Volunteer Opportunity at IDUG 2009 - Europe: Moderate a Session!!!

Go further... with your IDUG 2009 Europe Conference experience! Moderate a Session! Interested in volunteering to moderate a session at this year's conference? Session moderators are essential to the success of each and every IDUG conference and you can help. To become a moderator, after registering to attend the conference, simply go to the Personal Itinerary Builder on the Conference Scheduler page and login at the bottom of the page. Click on "Grid… Continue

Added by Aurora Dellanno on August 26, 2009 at 7:48am — No Comments

DB2 Express C and free fixpacks issue

This blog post was initially intended to be part of this thread on DB2 Express C forum but because my blog gets recently included in Planet DB2 blog aggregator i decided to make blog post instead.

I hear on… Continue

Added by Radim Kolar on August 17, 2009 at 6:03am — No Comments

Virtual Conference, Data Studio Chat, FYI - I also blog at Rav.Ahuja.ca

This post a melange of several topics ...

1. Anyone who attends conferences knows that attendance at most events has been dwindling this year. While there may be no substitute for in-person interactions, many online events are enjoying greater popularity, and some are coming close to simulating real-world conferences with booths, 1-1 chats, etc. The Data in Action Virtual Conference next week is a good example and is worth checking out. If you haven't registered yet, check out the… Continue

Added by Rav Ahuja on August 14, 2009 at 3:12pm — No Comments

DB2CE Auto commit OFF

บางครั้งมีความจำเป็นที่จะต้องทำงานผ่าน db2 command editor (db2ce)

ถ้าใครเคยใช้งาน tool ตัวนี้คงนึกภาพออกนะครับว่ามันไม่ง่ายเลยที่ใช้งาน

ไม่ว่าจะ ctrl+z เพื่อ undo ไม่ได้, ไม่มีสีสำหรับ syntax, ขึ้นบรรทัดใหม่โดยมีเว้นวรร

ก็ compile ไม่ผ่าน และอื่นๆอีกเยอะแยะมากมาย

วันนี้ผมมีความจำเป็นที่จะต้องรัน temporary table กับ procedure โดยที่ยังไม่ต้อง commit

ทำไงดีล่ะ -c ที่ใช้ใน db2cmd ก็ไม่ผ่านแหะ สุดท้ายได้วิธีดังนี้ครับ

update command options using c… Continue

Added by fuangwith on August 13, 2009 at 6:56am — 2 Comments

Migration to DB2 9.7 and compression

We migrated warehouse to DB2 9.7, because we heard lot of success stories related to DB2 9.7 compression. I was quite sceptic about it first, but after hearing more reports we finally decided to migrate too (from DB2 v8).

Data compression

We experimented a bit with partitioning tables (not DPF) and how partition size affects compression ratio. Answer is simple - larger partition size is better. Compression ratio increased slowly until it reached its maximum at about… Continue

Added by Radim Kolar on August 10, 2009 at 12:28pm — No Comments

CA IDUG Award for DB2

Dear DB2 colleagues,

While this announcement is about a prize sponsored by CA, it is a prize about DB2!

Consider Submitting for the CA IDUG Award for Outstanding Work in DB2: Great Prizes. Get Recognized.

September 11, 2009 deadline.

In conjunction with IDUG and four independent DB2 consultants, CA has opened the submissions process for the second presentation of this award for DB2. –Beware– This is not your typical vendor-driven award. It is open to… Continue

Added by Aurora Dellanno on August 10, 2009 at 10:51am — No Comments

Some strange issue in Redirected restore... part-1

Ok so here is the scenario..

- Have database1 in db2inst1

- Took a offline (cold) backup of database1

- did redirected restore to clone database1 in to database2 in same instance

- set tablespace containers, worked just fine , no errors.

- roll forward database to end of logs and complete , worked fine no errors

Now problem starts. When app folks told me they are missing some data, which was simply not visible to me because I did cold backup and then… Continue

Added by darshan on August 5, 2009 at 11:09pm — No Comments

The number of client connections is already equal to the maximum value defined in the system configuration file

If one or more applications are required to run concurrently, increase the value for max_connections. The new value takes effect after the next successful database manager start. If the value for max_connections is larger than the value for max_coordagents, the concentrator feature is turned on.

Priority of agents (AGENTPRI) = SYSTEM

Max number of existing agents (MAXAGENTS) = 400

Agent pool size (NUM_POOLAGENTS) = 200(calculated)

Initial number of agents in pool… Continue

Added by Paweł Myrczek on August 4, 2009 at 6:30am — No Comments