This is the output from dbm cfg:
SYSADM group name (SYSADM_GROUP) = DB2IADM1

I checked smit, my instance owner DBTSTCE1 belongs to group DB2IADM1.

What else?

Thanks,
Grace






"Suresh" <db2udbdba-ezmlmshield-x11313947.[Email address protected]
11/28/2006 05:37 PM


To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: Re: db2 installation


Check the value of SYSADM_GROUP

db2 "get dbm cfg"|grep SYSADM_GROUP

Make sure you update this parameter with the group you belong to, restart
DB2 and try your command again :)

Suresh G.




"Grace" <db2udbdba-ezmlmshield-x24991736.[Email address protected]
11/28/2006 04:27 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
db2 installation






Hi,

I installed DB2 V8.2 on AIX 5.3, and create an instance.

Then I loged on as instance owner DBTSTCE1 and run create database
command: create database tstce
I got the following error message

SQL1092N "DBTSTCE1" does not have the authority to perform the requested
command.

What is the problem?

Thank you very much for your help!

Grace


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or
use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and
notify us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves
the right to retrieve and read any message created, sent and received.
Kohl's reserves the right to monitor messages to or from authorized Kohl's
Associates at any time
without any further consent.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page