If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > ERROR just after installing DB2 ----plzzzzzzzzzzzzzzz help

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-17-07, 08:18
hi.som23 hi.som23 is offline
Registered User
 
Join Date: Sep 2007
Posts: 2
ERROR just after installing DB2 ----plzzzzzzzzzzzzzzz help

I installed DB2yesterday.
The server started but then when I clicked on the control center view the following error was given...

SQL1032N No start database manager command was issued.
SQLSTATE=57019


Explanation:

The start database manager command has not been processed. It
must be processed before a stop database manager, any SQL
statement, or utility can be issued.

The command cannot be processed.

User Response:

Issue a start database manager command and resubmit the current
command.

If using multiple logical nodes, ensure the DB2NODE environment
variable is set correctly. The DB2NODE environment variable
indicates the node the application will attempt to connect to.
DB2NODE must be set to the node number of one of the nodes
defined on the same host as the application.

sqlcode : -1032

sqlstate : 57019












After clicking on the create database option the following error comes


Federated system users: this situation can also be detected by
the data source.

User Response:

Log on as a user with the correct authority and retry the failed
command or operation. Correct authorities may include SYSADM,
SYSCTRL, SYSMAINT, and DBADM. DBADM is granted on databases and
all other authorities are determined by membership in the groups
defined in the database manager configuration (eg. if
sysctrl_group in the database manager configuration file is
defined as 'beatles', then you must belong to the group 'beatles'
to have SYSCTRL authority). Refer to the Command Reference or
the SQL Reference for the listing of required authorities for the
attempted command or operation.

If you are using Kerberos authentication in a Windows
environment, ensure that you log on to the machine using a domain
account. Only domain users can use Kerberos authentication in a
Windows 2000 environment.

If you are using LDAP support, ensure that you or the DB2
Connect gateway has the authority to perform the CATALOG DATABASE,
NODE and DCS DATABASE commands. Invoke the command "UPDATE DBM
CFG USING CATALOG_NOAUTH YES" at the client or the gateway to
correct the problem.

Federated system users: if necessary isolate the problem to the
data source rejecting the request (see the problem determination
guide for procedures to follow to identify the failing data
source) and ensure that the authorization id specified has the
proper authority on that data source.

Contact the System Administrator for authority request
assistance. Do not attempt to execute the command without
appropriate authorization.
Reply With Quote
  #2 (permalink)  
Old 09-17-07, 08:34
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
go to command window and issue
db2start
__________________
Rahul Singh
Certified DB2 9 DBA / Application Developer
Reply With Quote
  #3 (permalink)  
Old 09-17-07, 11:53
jsmit jsmit is offline
Registered User
 
Join Date: Mar 2007
Posts: 35
Quote:
Originally Posted by rahul_s80
go to command window and issue
db2start
I had this problem before, you have userid problem, the userid that you install db2 do not have proper permission or is not member of of right group or .....

hopefuly it was helpful, if you resolved that let us know wht did you do
Reply With Quote
  #4 (permalink)  
Old 09-17-07, 12:00
jsmit jsmit is offline
Registered User
 
Join Date: Mar 2007
Posts: 35
Quote:
Originally Posted by jsmit
I had this problem before, you have userid problem, the userid that you install db2 do not have proper permission or is not member of of right group or .....

hopefuly it was helpful, if you resolved that let us know wht did you do

somthing else, if you working in Windows platform please notice that the domain you login to your computer is the same that you install the db2?
Reply With Quote
  #5 (permalink)  
Old 09-18-07, 06:52
hi.som23 hi.som23 is offline
Registered User
 
Join Date: Sep 2007
Posts: 2
doesnt help

Quote:
Originally Posted by rahul_s80
go to command window and issue
db2start
first of all thanx for taking out time to reply!!!!!

Actually the server seems that it has started coz it is green in color in the systray... I have tried db2start in command window...it didnt help...
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On