473,327 Members | 2,012 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,327 software developers and data experts.

Blocked SYSIBM.SYSTABLES

Hello,

I have a user who regularly runs a query which blocks a lot of other
queries. The query is initiated from SSIS (SQL Server Integration
Services) on another host. The DB2 instance is version 8.1.

According to the user, the query doesn't perform any DROP TABLE/CREATE
TABLE/... DDL-like actions. But it seems to perform a RUNSTATS at the
time when I'm called for help.

At http://troels.arvin.dk/db/db2/locking/systables/ there's information
about the query blocking work for several others. The lock which seems to
cause trouble is this one:

Lock Name = 0x00000002000000000000000054
Lock Attributes = 0x00000002
Release Flags = 0xC0000000
Lock Count = 255
Hold Count = 0
Lock Object Name = 2
Object Type = Table
Tablespace Name = SYSCATSPACE
Table Schema = SYSIBM
Table Name = SYSTABLES
Mode = X

How to proceed? Is it RUNSTATS which locks SYSIBM.SYSTABLES? - If so: Is
there a way to decrease catalog locking in particular cases, and/or in
general?

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Jun 5 '07 #1
0 2741

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Patrick Finnegan | last post by:
DB2DART detects problems with SYSIBM.SYSSECTION and SYSIBM.SYSSTMT .. I cannot connect to or drop these tables(system objects). What are my options besides a db restore? Thanks in advance. ...
5
by: Andrew Werden | last post by:
I've inherited some code that calls SYSIBM.SQLPROCEDURES to validate user provided parameters and text prior to executing a stored procedure. This code was written on an early UDB release (V6?)...
9
by: Raquel | last post by:
When I create a package (by db2sqljcustomize command), the new package does not immediately appear in SYSIBM.SYSPLAN for that database. It appears after some time. Does anyone know when...
0
by: thijs.kupers | last post by:
Hello, I want to list all the user-tables of a DB2 database. I use the ADO-openSchema method (adSchemaTables), but I can't filter the systables out. Has someone any idea how to select only...
5
by: Mike Gemmell | last post by:
create table ppp ( t int ) @ create view v_ppp as select t from ppp @
3
by: Michael Rudolph | last post by:
Hi, at the moment i try to use the federated database feature (DB2/NT 8.2.3) to use a remote host db2 (DB2 OS/390 7.1.2). I am unsure what privileges are needed for the host db2 user. A...
8
by: dcruncher4 | last post by:
Can I get the equivalent information for the following commands using SYSCAT or SYSIBM tables. db2 list tablespace containers for 14 show detail db2 list history backup since 20061018 for...
0
by: cwahlmeier | last post by:
Suppose you have a table named TAB1. You create two mqt's, MQT1 and MQT2, that reference TAB1 in their definition. Why is it that while you issue a REFRESH TABLE MQT1, you cannot issue a DROP...
0
by: deangc | last post by:
We have a number of client installations where dynamic sql snapshots show that: CALL SYSIBM.SQLSTATISTICS(?,?,?,?,?,?) is the top consumer of CPU, usually by a wide margin. We regularly do...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
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)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.