PQ56439: ADMIN SERVER IS TRYING TO CREATE EXISTING TABLE AND THROWS ERROR"CREATE TABLE FOR USER AWDEV" ON OBJECT "AWDEV.DOMAIN_TMPTBL" | |||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||
![]() 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 PMRLocal 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 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 #: PQ56439
IBM Group: Software Group
Modified date: Jan 31, 2002
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.