Skip to Content
author's profile photo Former Member
Former Member

Disp Work Process stoopes

Dear Sir,

we are runing windows 2008 with db2, now server is not getting up

disp+work process show stooped.

here is siap Log

=======================================================

Running with CLI driver.

C *** ERROR in DB6Connect[dbdb6.c, 1737] CON = 0 (BEGIN)

C &+ DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL30061N

The database alias or database name "DEV

C &+ " was not found at the remote node.

SQLSTATE=08004

C

&+

C

&+

C *** ERROR in DB6Connect[dbdb6.c, 1737] (END)

C *** ERROR => DbSlConnect to 'DEV' as 'sapdev' failed

===============================================================

while checking db connection i got below message.

_____________________________________________________________

db2 => connect to dev

SQL1013N The database alias name or database name "DEV" could not be

found.

SQLSTATE=42705

db2 =>

_________________________________________________________________

please advice how to correct this error.

Thanks & Regards,

Hiten Modi

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 08, 2011 at 06:50 AM

    Hi,

    The cause of your problem is that database has been deactivated. To activate the database follow the commands below.

    db2stop

    db2start

    db2 activate db DEV

    If this steps is successful, the problem is resolved.

    Regards,

    Deepak Kori

    Add a comment
    10|10000 characters needed characters exceeded

    • First uncatalog the TCP/IP node and the database ,then catalog it .

      Run the following as db2<sid> on the application server host.

      db2 UNCATALOG NODE NDE43ED6

      db2 uncatalog database DCS55718

      db2 catalog tcpip node NDE43ED6 remote <hostname_of_dbserver> server <port_number_on_db>

      db2 catalog database DEV at node NDE43ED6

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.