on 12-08-2011 6:39 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
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
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
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
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
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
hi
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
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
hi
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
Hi Modi
please read the below links may help you. i will suggest to get the help from basis consultant.
Thanks
Sadiq
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.