Professional Web Applications Themes

DB2 raise SQL1013N error code when I want to connect to my DB - IBM DB2

Hi all: I issue the command "db2 connect to test user user_name using password", it's right. I issue the command "db2 connect to wasdb user user_name using password", DB2 raised the error code SQL1013N. Why??? I catalog the "test" alia using "db2 catalog db WASDBL as test on d:" command. I catalog the "WASDB" alia using CCA(Client Configuration Assistant) My ENV is as follows: OS: Windows 2000 Server DB2: 7.2 no FixPak C:\>db2 list db directory System Database Directory Number of entries in the directory = number_of_entries Database 1 entry: Database alias = test Database name = WASDBL Database drive ...

  1. #1

    Default DB2 raise SQL1013N error code when I want to connect to my DB


    Hi all:

    I issue the command "db2 connect to test user user_name using password",
    it's right.

    I issue the command "db2 connect to wasdb user user_name using
    password", DB2 raised the error code SQL1013N.



    Why???



    I catalog the "test" alia using "db2 catalog db WASDBL as test on
    d:" command.

    I catalog the "WASDB" alia using CCA(Client Configuration Assistant)



    My ENV is as follows:



    OS: Windows 2000 Server

    DB2: 7.2 no FixPak



    C:\>db2 list db directory



    System Database Directory



    Number of entries in the directory = number_of_entries



    Database 1 entry:



    Database alias = test

    Database name = WASDBL

    Database drive = D:\DB2

    Database release level = 9.00

    Comment =

    Directory entry type = Indirect

    Catalog node number = 0



    ...



    Database 4 entry:



    Database alias = WASDB

    Database name = WASDBL

    Node name = LOOPBACK

    Database release level = 9.00

    Comment =

    Directory entry type = Remote

    Catalog node number = -1



    ...





    C:\>db2 list node directory



    Node Directory



    Number of entries in the directory = 3



    Node 1 entry:



    Node name = DB2CTLSV

    Comment =

    Protocol = LOCAL

    Instance name = DB2CTLSV



    Node 2 entry:



    Node name = LOOPBACK

    Comment =

    Protocol = TCPIP

    Hostname = 127.0.0.1

    Service name = 55555



    Node 3 entry:



    Node name = PORTAL

    Comment =

    Protocol = TCPIP

    Hostname = 127.0.0.1

    Service name = 55555







    C:\>db2 get dbm cfg



    ...

    Diagnostic error capture level (DIAGLEVEL) = 4

    TCP/IP Service name (SVCENAME) = 55555

    ...



    C:\>netstat -an | find "50000"

    TCP 0.0.0.0:55555 0.0.0.0:0 LISTENING









    the content of db2diag.log is(my os is Chinese version)



    2003-09-11-08.46.44.390000 Instance:DB2 Node:000

    PID:1528(db2syscs.exe) TID:1664 Appid:none

    common_communication sqlcctcpconnr Probe:103

    DIA3421W "TCPIP" 衉议支持:“环境变量”值 "DB2SOSNDBUF" =
    "65536" 是

    "accepted"。



    2003-09-11-08.46.44.390001 Instance:DB2 Node:000

    PID:1528(db2syscs.exe) TID:1664 Appid:none

    common_communication sqlcctcpconnr Probe:108

    DIA3421W "TCPIP" 衉议支持:“环境变量”值 "DB2SORCVBUF" =
    "65536" 是

    "accepted"。



    Data Title:SQLCA PID:1528 TID:700 Node:000

    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1013 sqlerrml: 6

    sqlerrmc: WASDBL

    sqlerrp : SQLEDBCN

    sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000

    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000

    sqlwarn : (1) (2) (3) (4) (5) (6)

    (7) (8) (9) (10) (11)

    sqlstate:





    Data Title:DB2RA PID:1528 TID:700 Node:000

    5351 4c4a 5241 2020 6401 0000 0501 0100 SQLJRA d.......

    0300 1c00 8800 0000 0900 0000 f0fb f000 ........ .......

    0000 0000 0000 0000 0000 0000 0000 0000 ................

    0000 0000 0000 0000 0d00 0000 0400 0000 ................

    a881 b400 0000 0000 0100 0000 0000 0000 ................

    0600 0000 0100 0000 b581 b400 0000 0000 ................

    0000 0000 0000 0000 0000 0000 0000 0000 ................

    0000 0000 0000 0000 0000 0000 0000 0000 ................

    0400 0000 0200 0000 bb81 b400 0000 0000 ................

    0100 0000 0000 0000 0400 0000 0400 0000 ................

    bf81 b400 0000 0000 0100 0000 0000 0000 ................

    0800 0000 0100 0000 c381 b400 0000 0000 ................

    0000 0000 0000 0000 a800 0000 0c00 0040 ...............

    cb81 b400 0104 0000 0100 0080 7382 b400 ...........s...

    0000 0000 0000 0000 0000 0000 0000 0000 ................

    0000 0000 0000 0000 0400 0000 0200 0040 ...............

    7486 b400 0000 0000 0000 0000 0000 0000 t...............

    0000 0000 0100 0000 0000 0000 0200 0000 ................

    0300 0000 7886 b400 0000 0000 0000 0000 ....x...........

    0000 0000 0000 0000 0000 0000 0000 0000 ................

    0000 0000 0000 0000 0000 0000 0000 0000 ................

    0100 0000 0000 0000 0400 0000 0700 0000 ................

    7a86 b400 z...





    Thanks in advance!


    --
    Posted via [url]http://dbforums.com[/url]
    zhouhaiming Guest

  2. #2

    Default Re: DB2 raise SQL1013N error code when I want to connect to my DB


    C:\>db2ilist

    DB2CTLSV

    DB2





    C:\>netstat -an | find "55555"

    TCP 0.0.0.0:55555 0.0.0.0:0 LISTENING


    --
    Posted via [url]http://dbforums.com[/url]
    zhouhaiming Guest

  3. #3

    Default Re: DB2 raise SQL1013N error code when I want to connect to my DB


    I don't exactly know what you mean by

    DB2: 7.2 no FixPak,

    but if that is true, then probably should install the latest FP which is
    FP10. I don't know if it will fix the problem you are having, or whether
    there is a solution without the fixpak, but that is a pretty old release
    if you don't have any fixpaks installed. Fixpaks can be downloaded for
    free at the IBM website.


    --
    Posted via [url]http://dbforums.com[/url]
    Marcus_A Guest

Similar Threads

  1. Error on connect to FMS
    By ynykon in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: May 15th, 12:58 PM
  2. Template error code 3 + Error Accessing files..
    By Kenny Tew in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: June 30th, 04:17 AM
  3. Error when trying to connect a SQL DB in CF MX7
    By tee4 in forum Coldfusion Database Access
    Replies: 3
    Last Post: April 5th, 12:00 PM
  4. Error Trying to connect
    By James Jones in forum ASP Database
    Replies: 16
    Last Post: January 23rd, 10:32 AM
  5. Replies: 2
    Last Post: July 16th, 12:53 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139