The root reason is found, when unix adm remove the instance owner id from
local server and add it to LDAP, the SYSADM group for instance owner id
was lost. After unix adm fixed it, I am able to create the database.
Thank you everyone for your help!
Grace
"Suresh" <db2udbdba-ezmlmshield-x38744802.[Email address protected]
11/28/2006 06:11 PM
To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: RE: db2 installation
Try :
db2 "db2 attach to dbtstce1"
db2 "create database tstce"
Still getting same error ? :)
Suresh G.
"Grace" <db2udbdba-ezmlmshield-x3740299.[Email address protected]
11/28/2006 05:01 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: db2 installation
Yes, attach works.
$db2 attach to dbtstce1
Instance Attachment Information
Instance server = DB2/AIX64 8.2.0
Authorization ID = DBTSTCE1
Local instance alias = DBTSTCE1
"Suresh" <db2udbdba-ezmlmshield-x44387708.[Email address protected]
11/28/2006 05:59 PM
To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: RE: db2 installation
Can you try db2 "attach to dbtstce1" , did it work? :)
Suresh G.
"McClendon Rick "
<db2udbdba-ezmlmshield-x80543935.[Email address protected]
11/28/2006 04:53 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: db2 installation
Perhaps you have an underlying file system permission problem wherein
you cannot create the datasets required at DB creation time?
Just a guess here
-----Original Message-----
From: Grace
[mailto:db2udbdba-ezmlmshield-x29654631.[Email address protected]
Sent: Tuesday, November 28, 2006 5:51 PM
To: LazyDBA Discussion
Subject: Re: db2 installation
My id is in lower-case format.
Grace
"Suresh" <db2udbdba-ezmlmshield-x39353168.[Email address protected]
11/28/2006 05:47 PM
To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: Re: db2 installation
Looks strange...can you create a new user-id in lower-case, add it to
DB2IADM1 group, login as 'lower-case' id and try the command
again.....:)
Suresh G.
"Grace" <db2udbdba-ezmlmshield-x67141730.[Email address protected]
11/28/2006 04:42 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
Re: db2 installation
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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