PQ66035: FOR EVERY START OF WEBSPHERE THERE IS AN ADDITIONAL ENTRY IN EJSADMIN.LOCK_TABLE TABLE AND ADMIN DB2 IS ON OS/390 REMOTELY. | |||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||
![]() APAR status Closed as program error. Error description Problem: Customer is having a WAS4.0 1 AE on AIX and Admin repository is on DB2 with OS/390 remotely. When ever customer restarts WAS , they see that there is an additional entry in repository EJSADMIN.LOCK_TABLE table. . Cause : It seems the DDL for the admin repository for DB2/390 is called db2390.sql in the bin directory in the WebSphere install. As it turns out, the DDL is missing the primary key clause on the definition for the LOCK_TABLE. n Addnl error: Another customer noted the unique index for the EJSADMIN.LOCK_TABLE is missing. Here is the missing entry: CREATE TYPE 2 UNIQUE INDEX EJSADMIN.LCK_IX ON EJSADMIN.LOCK_TABLE ( NAME );Local fix WorkAround : There is no work around.Problem summary **************************************************************** * USERS AFFECTED: For WebSphere Application Server 4.0 users * * having DB2 installed on a 390 system * **************************************************************** * PROBLEM DESCRIPTION: For every start of WebSphere there is * * an additional entry in * * EJSADMIN.LOCK_TABLE * **************************************************************** * RECOMMENDATION: * **************************************************************** The DDL for the admin repository for DB2/390 is called db2390.sql in the bin directory. As it turns out, the DDL is missing the primary key clause on the definition for the LOCK_TABLE. Another error: the unique index for LOCK_TABLE is missing too.Problem conclusion The new ddl (db2390.sql) has added primary key on LOCK_TABLE to avoid additional entry existing in LOCK_TABLE. The new ddl has also created UNIQUE INDEX on LOCK_TABLE to resolve UNIQUE INDEX missing problem.Temporary fix Have posted the efix on the wasdoc0\apars\PQ66035. Wait for res ponse.Comments
APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
SRLS
|
Document Information |
Product categories: Software > Application Servers >
Distributed Application & Web Servers > WebSphere Application
Server > General
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ66035
IBM Group: Software Group
Modified date: Oct 17, 2002
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.