473,288 Members | 1,750 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,288 software developers and data experts.

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 1641

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

Similar topics

8
by: Steven Burn | last post by:
I'm curious, I've written a very simple PIS (personal info store) that allows one to store whatever they wish..... the problem is, when one deletes an entry, the auto-numbering isn't corrected to...
4
by: tchangmian | last post by:
Hi, I would like to create an auto-lock out module where users are unable to continue login attempt after 3-5 unsuccessful logins. In addition, the user account are automatically suspended after...
1
by: Dale Franklin | last post by:
This should be a rather ROUTINE procedure for you DBAs. I keep hearing at technical conferences and user groups the phrase "then rebind all your plans and packages" (after reorg, load, &...
2
by: SKC | last post by:
Platform : Solaris UDB : version 7.2 FP9 DB2RBIND PACKAGE SCHEMA.PACKAGE fails with SQL0029N error. When I issue, "db2rbind DBNAME all", it is successfull. Can anyone help me understand...
5
by: Phil Latio | last post by:
I have 2 virtually identical tables and wish to move data between them. Basically one table is called "live_table" and the other is named "suspended_table" and the only difference is that the...
1
by: pemigh | last post by:
In a prior posting (too old to reply directly), Jim Devenish described exactly what my client has seen, both in terms of AutoExpand behaving oddly and the way that caps lock relates to the...
2
by: john | last post by:
Is it true that if I split my access database in backend and frontend and I implement custom auto increment for the ID fields, that my database is ready to be used in a multi-user environment? I...
1
by: datapro01 | last post by:
Running DB2 8.2.5 and version 9 with fixpack2 on AIX 5.3 supporting both SAP netweaver and non-SAP applications. In implementing auto-reorg and auto-runstats, what is the guidance regarding...
1
by: Laurence | last post by:
Hi, DB2/400 seems not able to auto-rollback one of transactions while dead- lock occurred. I called the procecure QSYS.CREATE_SQL_SAMPLE for creating sample database, and used ISQL (STRSQL)...
2
by: robert stearns | last post by:
When I use LOCK TABLE ... COMMIT, must I also use odbc_autocommit(dbConn, FALSE)? In other words will auto commit prematurely defeat the LOCK TABLE?
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.