470,641 Members | 1,521 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

DB2 auto rebind lock-up

1
Hi all

I'm using DB2 V9.1.0 on SUSE Linux with kernel version 2.6.5.

In the system I'm working on, there are 2 stored procedures which perform simple selects through different views.

Those views are redefined (drop/create) periodically. DB2 rebinds the stored procedures that use the views, automatically.

The stored procedures are executed concurrently by another program. My problem is that the rebind operations seem to interfere with each other, causing a lockup. Neither can proceed.

With a long lock timeout (5 minutes) they'll wait the full 5 minutes, every time.

If I manually issue rebind commands for the stored procs, one after the other, the stored procs execute trouble-free when the program using them runs.

I'm seeing lock waits like this, from db2pd -locks wait

0x26218AE0 18 00000F00430024590100000052 Row ..X W 19 1 0 0x10 0x40000000 TbspaceID 0 TableID 15 PartitionID 0 Page 88356 Slot 67
0x26219B40 19 00000F00430024590100000052 Row ..U G 19 1 0 0x10 0x40000000 TbspaceID 0 TableID 15 PartitionID 0 Page 88356 Slot 67

The table with ID 15 in tablespace 0 is SYSIBM.SYSSECTION. It appears to be 2 locks on a row in that table that is at the center of the problem. But this is an operation under DB2's control.

Has anyone else seen lockups with automatic rebinds? Could this be a DB2 bug?

Thanks
Ben
Nov 2 '06 #1
0 1537

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by SKC | last post: by
1 post views Thread by pemigh | last post: by
2 posts views Thread by robert stearns | last post: by
1 post views Thread by Korara | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.