Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    78

    Unanswered: 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?

  2. #2
    Join Date
    Dec 2003
    Posts
    78
    hi,
    i solved my problem,
    tnx all

  3. #3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •