Topic
3 replies Latest Post - ‏2007-02-21T20:13:04Z by SystemAdmin
SystemAdmin
SystemAdmin
17917 Posts
ACCEPTED ANSWER

Pinned topic SQL1024n, SQLSTATE=08003

‏2007-02-19T18:04:20Z |
Hello!

We are newbees and have a problem with setting up the DB2. We followed the manual installation guide on the IBM homepage: Configuring DB2-Server after Manual installation. We want to define the configuration of the tcp/ip communication protocolls and enter the following command in the DB2:

db2set DB2COMM=tcpip

Then we get the following error-message:

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003

Operating system: Debian Linux
Logged-In: Instance owner
Need more data?

Thanks in advance!

Greetz
Nordevil
Updated on 2007-02-21T20:13:04Z at 2007-02-21T20:13:04Z by SystemAdmin
  • DB2ROX
    DB2ROX
    4 Posts
    ACCEPTED ANSWER

    Re: SQL1024n, SQLSTATE=08003

    ‏2007-02-19T18:21:10Z  in response to SystemAdmin
    Set the variable DB2COMM to be TCPIP globally for all instances pertaining to a particular installation:
    db2set -g DB2COMM=TCPIP
    Set the variable DB2COMM to be only TCPIP for instance MYINST:
    db2set -i MYINST DB2COMM=TCPIP

    Please look at the different options available for db2set command on IBM DB2 help site - http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0002025.htm?resultof=%22%64%62%32%73%65%74%22%20
  • SystemAdmin
    SystemAdmin
    17917 Posts
    ACCEPTED ANSWER

    Re: SQL1024n, SQLSTATE=08003

    ‏2007-02-19T18:24:39Z  in response to SystemAdmin
    <Frank.Bahlmann@gmx.de> wrote in message
    news:1735444522.1171908297207.JavaMail.wassrvr@ltsgwas009.sby.ibm.com...
    > Hello!
    >
    > We are newbees and have a problem with setting up the DB2. We followed the
    > manual installation guide on the IBM homepage: Configuring DB2-Server
    > after Manual installation. We want to define the configuration of the
    > tcp/ip communication protocolls and enter the following command in the
    > DB2:
    >
    > db2set DB2COMM=tcpip
    >
    > Then we get the following error-message:
    >
    > DB21034E The command was processed as an SQL statement because it was not
    > a
    > valid Command Line Processor command. During SQL processing it returned:
    > SQL1024N A database connection does not exist. SQLSTATE=08003
    >
    > Operating system: Debian Linux
    > Logged-In: Instance owner
    > Need more data?
    >
    > Thanks in advance!
    >
    > Greetz
    > Nordevil

    Make sure you are not in the db2 command line processor,

  • SystemAdmin
    SystemAdmin
    17917 Posts
    ACCEPTED ANSWER

    Re: SQL1024n, SQLSTATE=08003

    ‏2007-02-21T20:13:04Z  in response to SystemAdmin
    Thank you very much for your help!
    Now the DB2 is running properly!
    Thanks!