PQ56439: ADMIN SERVER IS TRYING TO CREATE EXISTING TABLE AND THROWS ERROR"CREATE TABLE FOR USER AWDEV" ON OBJECT "AWDEV.DOMAIN_TMPTBL"

 A fix is available

System Management Component Cumulative Fix for 4.0.2/4.0.3/4.0.4 /4.0.5



APAR status
Closed as program error.

Error description
cust do not want to give the permission to the "dbuser" in
admin.config to create the tables.Cust is using db2390.sql
(<was_root>/bin/db2390.sql) to create the tables.but it
did not create AWDEV.DOMAIN_TMPTBL  table.
it seems this db2390.sql is not a complete one.
.
Sean Lee/New York/IBM@IBMUS ( from design centre )
and  Ping Wang/Austin/IBM@IBMUS  (from wl3sm team )
provided  a new db2390.sql  for
testing purpose (this is available on wasdoc0/wasus/79595344000/
.
This new db2390.sql created the AWDEV.DOMAIN_TMPTBL  .
now the table is existing  but when we start the admin server ,
the admin server trying to create
the same table again and giving following exceptions
 COM.ibm.db2.jdbc.DB2Exception:
 [IBM][CLI Driver][DB2] SQL0551N
 "NVISWAS" does not have the privilege to perform operation
 "CREATE TABLE FOR USER AWDEV" on object
"AWDEV.DOMAIN_TMPTBL" SQLSTATE=42501
.
Note: Sean Lee/New York/IBM@IBMUS ( from design centre )  and
Ping Wang/Austin/IBM@IBMUS (from wl3sm)are familiar with this
PMR
Local fix Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server Advanced        *
*                 Edition 4.01 and 4.02 users with DB2 390     *
*                 as admin repository                          *
****************************************************************
* PROBLEM DESCRIPTION: User cannot create DB2 390 tables.      *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Missing one entry in DB2 390 table creation script for domain
temporary table.
Problem conclusion
Modified DB2 390 table creation script to add missing table.
Temporary fix Comments
APAR information
APAR number PQ56439
Reported component name WEBSPHERE AES N
Reported component ID 5630A2301
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-01-08
Closed date 2002-01-31
Last modified date 2002-01-31

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
ADMINSVR          

SRLS

Fix information
Fixed component name WEBSPHERE AES N
Fixed component ID 5630A2301

Applicable component levels
R400 PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ56439
IBM Group: Software Group
Modified date: Jan 31, 2002