Question Re: Disp Work Process stoopes in Technology Q&A

Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 06:39:39 GMT

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 *** 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

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 06:50:16 GMT

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

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 07:45:01 GMT

i have try this but didn't work.

please check below message.

________________________________________________________________________

E:\db2\db2dev\db2_software\BIN>db2stop

12/08/2011 13:12:21 0 0 SQL1064N DB2STOP processing was successful.

SQL1064N DB2STOP processing was successful.

E:\db2\db2dev\db2_software\BIN>startdb2

'startdb2' is not recognized as an internal or external command,

operable program or batch file.

E:\db2\db2dev\db2_software\BIN>db2start

12/08/2011 13:12:33 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

E:\db2\db2dev\db2_software\BIN>db2 activate db DEV

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

SQLSTATE=42705

________________________________________________________

Regards,

Hiten

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 07:57:03 GMT

Hi,

Could you check that any drive is full and is out of space ?

If yes, what are the folders inside that drive.

Regards,

Deepak Kori

Re: Disp Work Process stoopes

former_member182505 — Thu, 08 Dec 2011 08:17:03 GMT

Hi please try this

db2stop

db2 terminate

db2start

db2 connect

db2 activate db DEV

Thanks

Sadik

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 08:27:08 GMT

E:\db2\db2dev\db2_software\BIN>db2stop

12/08/2011 13:53:38 0 0 SQL1064N DB2STOP processing was successful.

SQL1064N DB2STOP processing was successful.

sadik & deepak,

there is enough space in server.

please find below message i got after executing command

______________________________________________________________________

E:\db2\db2dev\db2_software\BIN>db2 treminate

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

E:\db2\db2dev\db2_software\BIN>dbstart

'dbstart' is not recognized as an internal or external command,

operable program or batch file.

E:\db2\db2dev\db2_software\BIN>db2start

12/08/2011 13:54:19 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

E:\db2\db2dev\db2_software\BIN>db2 connect

SQL1024N A database connection does not exist. SQLSTATE=08003

E:\db2\db2dev\db2_software\BIN>db2 activate db DEV

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

SQLSTATE=42705

E:\db2\db2dev\db2_software\BIN>

_______________________________________

Regards,

Hiten

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 08:30:45 GMT

Hi,

Have you checked your DB2INSTANCE settings? (DB2INSTANCE is an environment variable.)

Please check the valud of DB2INSTANCE before you execute "db2 list db directory"".

(Example)

C:\Program Files\IBM\SQLLIB\BIN>set DB2INSTANCE

DB2INSTANCE=DB2

And how many instances do you have? Do you see 3 instances listed when executing db2ilist?

(Example)

C:\Documents and Settings\Administrator>db2ilist

DB2_01

Regards,

Deepak Kori

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 08:43:37 GMT

Deepak,

DB2INSTANCE=DB2DEV

while executing db2list i got below message

__________________________________________

E:\db2\db2dev\db2_software\BIN>db2 list

SQL0104N An unexpected token "END-OF-STATEMENT" was found following "LIST".

Expected tokens may include: "ACTIVE". SQLSTATE=42601

___________________________________________

Regards,

HIten

Re: Disp Work Process stoopes

former_member182505 — Thu, 08 Dec 2011 08:58:46 GMT

don't make space in db2list.command

thanks

sadiq

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 09:17:32 GMT

sadik,

can't execute db2list command.

___________________________________________________________

E:\db2\db2dev\db2_software\BIN>db2 list

SQL0104N An unexpected token "END-OF-STATEMENT" was found following "LIST

Expected tokens may include: "ACTIVE". SQLSTATE=42601

E:\db2\db2dev\db2_software\BIN>db2list

'db2list' is not recognized as an internal or external command,

operable program or batch file.

______________________________

Regards,

Hiten

Re: Disp Work Process stoopes

former_member182505 — Thu, 08 Dec 2011 09:21:14 GMT

use db2ilist

Thanks

sadiq

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 09:23:30 GMT

hi,

received below out put

E:\db2\db2dev\db2_software\BIN>db2ilist

DB2DEV

Re: Disp Work Process stoopes

former_member182505 — Thu, 08 Dec 2011 09:37:26 GMT

Run CATALOG DATABSASE command from DB2 CLP.

please send the output of db2 list db directory also.

please use the command db2_kill and try again.

also please update your FP if possible and try,

thanks

sadiq

Edited by: sadiq iqbal on Dec 8, 2011 10:41 AM

Edited by: sadiq iqbal on Dec 8, 2011 10:43 AM

Edited by: sadiq iqbal on Dec 8, 2011 10:48 AM

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 10:03:34 GMT

Hi,

Please share output of following commands

db2 list db directory

db2 list node directory

Regards,

Deepak Kori

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 10:12:53 GMT

sadik,

what is FP?.

i got below out put while executing command which suggest by you

db2 => list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = DB2DEV

Database name = DCS55718

Node name = NDE43ED6

Database release level = d.00

Comment =

Directory entry type = Remote

Authentication = SERVER

Catalog database partition number = -1

Alternate server hostname =

Alternate server port number =

db2 => CATALOG DATABSASE

SQL0104N An unexpected token "DATABSASE" was found following "CATALOG".

Expected tokens may include: "DATABASE". SQLSTATE=42601

C:\Users\devadm>db2_kill

SQL1092N "DEVADM " does not have the authority to perform the requested comman

d or operation.

Regards,

Hiten

Re: Disp Work Process stoopes

former_member182505 — Thu, 08 Dec 2011 10:19:37 GMT

with db2 list db diroctroy command

Database alias = DB2DEV

Database name = DCS55718

Node name = NDE43ED6

are showing incorrect .

please set it properly and check.

its should look like..

db2 list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = HSB

Database name = HSB

Local database directory = /db2/HSB/sapdata1

Database release level = d.00

Comment = SAP database HSQ

Directory entry type = Indirect

Catalog database partition number = 0

Alternate server hostname =

Alternate server port number =

Thanks

Sadiq

Re: Disp Work Process stoopes

Former Member — Thu, 08 Dec 2011 10:39:26 GMT

hi sadik,

can u please guide me, how to change directory parameter which u suggest.

because i m new to db2

thanks & Regards,

Hiten

Re: Disp Work Process stoopes

former_member182505 — Thu, 08 Dec 2011 11:32:37 GMT

Hi Modi

please read the below links may help you. i will suggest to get the help from basis consultant.

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0001941.htm

http://publib.boulder.ibm.com/infocenter/reqpro/v7r1m0/index.jsp?topic=/com.ibm.rational.reqpro.install_upgrade.doc/topics/db2_def_alias.html

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0001961.htm

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/start/t0005622.htm

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0001936.htm

Thanks

Sadiq

Re: Disp Work Process stoopes

former_member189725 — Thu, 08 Dec 2011 11:48:21 GMT

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