Control Center - Discovery method fails...

ceinma · #1 (**permalink**) 07-20-10, 15:06

Hi ,

Linux OpenSuse 11.2
Server DB2 9.7.0.1 - host srvimartins
Client (full) DB2 9.7.0.2 - host note-cim

I'm trying configure the Control Center from the client by "discovery" button on my test environment.
When I try add a new system, clicking on discovery button, the server is found, but when I select it and click OK,
after a long wait the error bellow appear.
I'm trying figure out what happen ... unsuccessfully....

Code:

SQL22207N  The DB2 Administration server cannot execute the script at host "srvimartins". Reason code "4".


Explanation: 

The DB2 Administration Server failed to execute the script for one of
the following reasons: 
1. The user specified an existing script and the script does not exist.
2. The script working directory is invalid.
3. The last line of the script failed to run because a statement
   termination character could not be found.
4. A system error occurred while attempting to execute the script.

User response: 

Depending on the reason for the failure, attempt one of the following: 
1. Verify that the script specified exists on host "<hostname>" at the
   path provided.
2. Verify that the working directory is valid on host "<hostname>".
3. Verify the script contents and resubmit the request.
4. Refer to the DB2 Administration Server's First Failure Data Capture
   Log for additional information.

If you continue to receive this error message after attempting the
suggested response, refer to the DB2 Administration Server's First
Failure Data Capture Log for additional information or contact IBM
Support.

Trying to isolate the problem I install the db2 server on my note and try to add using the discovery method, but I got the same error.

This is the version installed on my note

Code:

Install Path                       Level   Fix Pack   Special Install Number   Install Date                  Installer UID 
---------------------------------------------------------------------------------------------------------------------
/media/hDADOS/db2/ibm/client/V9.7    9.7.0.2        2                            Wed Jul 14 16:06:49 2010 BRT             0 
/media/hDADOS/db2/ibm/db2/V9.7    9.7.0.1        1                            Mon Jul 19 16:39:52 2010 BRT             0

On my note, where I have the client and server installed, the logs of db2diag and dasdiag when the error occurred.
I not found anything useful here... but I'm just starting with db2 .. so...

Code:

db2note1@note-cim:~/sqllib/db2dump$ tail -n0 -f db2note1.nfy db2diag.log
==> db2note1.nfy <==

==> db2diag.log <==

2010-07-20-15.43.11.727909-180 I48672G729         LEVEL: Error
PID     : 6843                 TID  : 3031456624  PROC : db2dasstm
INSTANCE: db2note1             NODE : 000
FUNCTION: DB2 Tools, DB2 administration server, handleRunCmd, probe:90
DATA #1 : signed integer, 4 bytes
-25
CALLSTCK:
  [0] 0xB760A0FB /home/db2note1/sqllib//lib32/libdb2osse.so.1 + 0xB70FB
  [1] 0xB760B327 ossLog + 0x53
  [2] 0x0805374D _Z12handleRunCmdP17stmRequestContext. + 0xB95
  [3] 0x0805030E db2dasStmRequestDispatchThread + 0x5E
  [4] 0xB74B0C9A db2dasThreadMain + 0x2E
  [5] 0xB73A46E5 /lib/libpthread.so.0 + 0x56E5
  [6] 0x00000000 ?unknown + 0x0
  [7] 0x00000000 ?unknown + 0x0
  [8] 0x00000000 ?unknown + 0x0
  [9] 0x00000000 ?unknown + 0x0

/home/dasusr1/das/dump/db2dasdiag.log

Code:

2010-07-20-15.43.10.262111-180 I10460G218         LEVEL: Error
PID     : 27553                TID : 3018836848
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest, probe:90
DATA #1 : Sint32, 4 bytes
-4010

2010-07-20-15.43.10.262353-180 I10679G219         LEVEL: Error
PID     : 27553                TID : 3018836848
FUNCTION: DB2 Tools, DB2 administration server, handleStmRequest, probe:150
DATA #1 : Sint32, 4 bytes
-4010

2010-07-20-15.43.10.265118-180 I10899G388         LEVEL: Error
PID     : 6187                 TID : 3063262064
FUNCTION: DB2 Tools, DB2 administration server, db2dasKnownDscv, probe:96
DATA #1 : String, 141 bytes
Warning: DAS encountered problem when running the db2genp utility from
         the DB2 instance /home/db2user/sqllib of the version 9070002.
DATA #2 : Sint32, 4 bytes
-22205

2010-07-20-15.43.11.729727-180 I11288G389         LEVEL: Error
PID     : 6187                 TID : 3063262064
FUNCTION: DB2 Tools, DB2 administration server, db2dasKnownDscv, probe:96
DATA #1 : String, 142 bytes
Warning: DAS encountered problem when running the db2genp utility from
         the DB2 instance /home/db2note1/sqllib of the version 9070001.
DATA #2 : Sint32, 4 bytes
-22207

2010-07-20-15.43.11.729937-180 I11678G448         LEVEL: Error
PID     : 6187                 TID : 3063262064
FUNCTION: DB2 Tools, DB2 administration server, db2dasKnownDscv, probe:32
DATA #1 : String, 234 bytes
Info: There are '2' versions (V81FP8 or above) found on the system by discovery.
      Among these versions, the number of versions that successfully ran db2genp
      are '0'. For the possible error details, please see the log above.

Just a note, this last message, curiosity this occur too when I try add the instance on the server "srvimartins" where not have others installations.. only one...

ceinma · #2 (**permalink**) 07-20-10, 15:09

I forgot...

Before install the db2 server on my note, I try connect using the discovery method from a Windows Client and got the same error...

Internet Services

Web Development

Digital Marketing

Consumer Tech