UDB 7.2 AIX - catalog contention

Paul Ealey

UDB 7.2 AIX - catalog contention
We're getting catalog contention on sysibm.sysplan in production. However I
can't find any documentation relating to catalog contention. Can someone
tell me where UDB-AIX catalog contention is described please?

Thanks.
Paul.

Paul Ealey
EDS Work and Pensions
Development DBA Team
NW / NE & Scotland Solution Centres
U Block, Government Buildings
Moorland Road, Lytham St Annes
Lancashire, FY8 3ZZ, UK
mobile: 07790 494 055
e-mail: [login to unmask email]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of ali hasnain
Sent: 06 January 2004 20:35
To: [login to unmask email]
Subject: MIGRATION FROM UDB7.1 TO UDB7.2

Hi;

I'm working on DB2 UDB NT v7.2. My database was
created in v 7.1 before. I resotred the backup image
on 7.2. Do i require to migrate it on 7.2?

I'm getting some problems in some functions like
DECRYPT_CHAR when working in 7.2 in older versioned
database. When i create new database in 7.2 it works
but don't work at the database i created ver 7.1.
Do i require to migrate it on 7.2?

From
Ali Hasnain

__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can
be reached at [login to unmask email] Find out the latest on IDUG
conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Wayne Driscoll

Re: UDB 7.2 AIX - catalog contention
(in response to Paul Ealey)
Paul,
Catalog contention should be researched the same as any other lock
contention. Are you seeing deadlock timeouts or just long waits?
SYSPLAN will be exclusivly locked during binds and by any process
issuing DDL that would cause a plan or package to be marked invalid.
Wayne Driscoll
Sr. Software Developer
Quest Software
[login to unmask email]
NOTE: All opinions are strictly my own. EMail Address in sig must be
modified.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Ealey, Paul M
Sent: Tuesday, January 20, 2004 4:22 AM
To: [login to unmask email]
Subject: [DB2-L] UDB 7.2 AIX - catalog contention


We're getting catalog contention on sysibm.sysplan in production.
However I can't find any documentation relating to catalog contention.
Can someone tell me where UDB-AIX catalog contention is described
please?

Thanks.
Paul.

Paul Ealey
EDS Work and Pensions
Development DBA Team
NW / NE & Scotland Solution Centres
U Block, Government Buildings
Moorland Road, Lytham St Annes
Lancashire, FY8 3ZZ, UK
mobile: 07790 494 055
e-mail: [login to unmask email]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of ali hasnain
Sent: 06 January 2004 20:35
To: [login to unmask email]
Subject: MIGRATION FROM UDB7.1 TO UDB7.2

Hi;

I'm working on DB2 UDB NT v7.2. My database was
created in v 7.1 before. I resotred the backup image
on 7.2. Do i require to migrate it on 7.2?

I'm getting some problems in some functions like
DECRYPT_CHAR when working in 7.2 in older versioned
database. When i create new database in 7.2 it works
but don't work at the database i created ver 7.1.
Do i require to migrate it on 7.2?

From
Ali Hasnain

__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

------------------------------------------------------------------------
----
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". If you will be out of the office,
send the SET DB2-L NOMAIL command to [login to unmask email] The
IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm