Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311

    Unanswered: Control Center - Discovery method fails...

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

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •