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 > urgent connection problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-30-04, 01:43
shedb shedb is offline
Registered User
 
Join Date: Dec 2003
Posts: 78
urgent connection problem

on unix db2 v7.2 fixpack 10a server, we have a connection gateway to host database.

we uncataloged it , using the command:
db2 uncatalog db mvs
db2 terminate
then recatalogued it: using the command:
db2 catalog db mvs at node mvsnode
db2 terminate


we db2stopped/started several times, however, when we try to connect to mvs, it gives the error below:
SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004

(it is not a real username, password problem, because when it is, it will give some error like below:
SQL30082N Attempt to establish connection failed with security reason "15"
("PROCESSING FAILURE"). SQLSTATE=08001 )


this problem has happened on several servers:
whether we change the node name or not, when we uncatalog-catalog db, it says :
SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004

(the connection definiton works on other servers, & there is no firewall issue)
what can we do?
Reply With Quote
  #2 (permalink)  
Old 11-30-04, 02:25
shedb shedb is offline
Registered User
 
Join Date: Dec 2003
Posts: 78
hi,
i solved my problem,
tnx all
Reply With Quote
  #3 (permalink)  
Old 02-21-05, 04:14
shedb shedb is offline
Registered User
 
Join Date: Dec 2003
Posts: 78
hi,
i received an email through dbforums page asking how i solved this problem.
here is how i managed it:

>db2 uncatalog db mvs
>db2 terminate
(then i learned i should catalog it as below:
1)first catalog node (if not catalogued before)
>db2 catalog tcpip node MVSNODE remote x.x.x.x(ip_number is written) server xxx(port_number is written)
2)then i should catalog dcs (used for mvs databases)
>db2 catalog dcs database MVS as DBMVS
(here DBMVS is the real name of db at mvs side, and MVS is the alias of the target database)
3)then catalog the database
>db2 catalog database MVS as MVS at node MVSNODE authentication dcs
>db2 terminate


this should work, bys
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