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 > CREATE TOOLS CATALOG (Hitting SQL30082N "PASSWORD MISSING")

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-22-10, 04:37
lsyeong lsyeong is offline
Registered User
 
Join Date: May 2010
Posts: 5
CREATE TOOLS CATALOG (Hitting SQL30082N "PASSWORD MISSING")

Good day guys,

Currently I am going to enable the Scheduler function in db2 by creating the tools catalog with command as below

CREATE TOOLS CATALOG <schema_name>USE EXISTING DATABASE <db_name>

It is working fine in my local PC but I am hitting below error in my Production DB server.

SQL30082N Security processing failed with reason "3" ("PASSWORD MISSING").
SQLSTATE=08001

I have tried few method including append "user <db_user> using <db_password>" follow by the command but still not able to fix it.

Thanks for reading and hope you guys can sheds some light on this issue

Regards,
Sean

Last edited by lsyeong; 07-22-10 at 04:45.
Reply With Quote
  #2 (permalink)  
Old 07-22-10, 10:37
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
According to the manual, you can only run this command against a local database.
Reply With Quote
  #3 (permalink)  
Old 07-27-10, 04:32
lsyeong lsyeong is offline
Registered User
 
Join Date: May 2010
Posts: 5
Thanks n_i for the infor. Anyway I have log in to that DB server which suppose the database should act as local DB. But still hitting the same issue ...... Any idea/suggestion to overcome this issue?

Thanks for reading .

Regards,

Sean
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