Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012
    Posts
    177

    Unanswered: Issues with connecting the db2 database

    Hi all,

    In our setup db2v9.7 with fixpack 4

    Facing issues with connecting the database:
    ==================================

    Instance with the name of db2inst2 it contains four non-partitioned databases.

    I am able to connect the 3 databases perfectly.

    Database with the name of CN i am not able to connect, from the past days it went fine.

    SQL1013N The database alias name or database name "CN" could not be found.
    SQLSTATE=42705


    db2diag.log:
    =========

    Information in this record is only valid at the time when this file was
    created (see this record's time stamp)

    2012-11-21-17.32.44.366309+660 I1626E738 LEVEL: Warning
    PID : 32419 TID : 47752121674048PROC : db2sysc 0
    INSTANCE: db2inst2 NODE : 000
    APPHDL : 0-35384
    EDUID : 117 EDUNAME: db2agent () 0
    FUNCTION: DB2 UDB, Connection Manager, sqleUCgetDirInfo, probe:1012
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1013 sqlerrml: 2
    sqlerrmc: CN
    sqlerrp : SQLEUCCM
    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:

    2012-11-21-17.32.44.368901+660 I2365E738 LEVEL: Warning
    PID : 32419 TID : 47752121674048PROC : db2sysc 0
    INSTANCE: db2inst2 NODE : 000
    APPHDL : 0-35385
    EDUID : 117 EDUNAME: db2agent () 0
    FUNCTION: DB2 UDB, Connection Manager, sqleUCgetDirInfo, probe:1012
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1013 sqlerrml: 2
    sqlerrmc: CN
    sqlerrp : SQLEUCCM


    How can i able to connect the database?



    Thanks
    laxman..

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    is the db cataloged ? list db directory
    try list db directory on /xxxx and catalog db xx on /yyyy
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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