Results 1 to 5 of 5

Thread: help needed

  1. #1
    Join Date
    Nov 2013
    Posts
    23

    Unanswered: help needed

    When I try to run the db2advis the following error msg is displayed.

    --Cannot continue because another concurrent db2advis
    -- execution under the same userID was found. The other
    -- run must complete before a new run can be started.
    -- If you previously had db2advis executions that have
    -- abnormally failed, there may be residual rows
    -- in the ADVISE_INSTANCE table that are preventing you
    -- from running db2advis now. You can update these rows
    -- by running the UPDATE command below:
    --
    -- ** WARNING:** ONLY RUN THIS COMMAND WHEN YOU ARE CERTAIN
    -- THERE ARE NO OTHER DB2ADVIS EXECUTIONS RUNNING UNDER
    -- THE SAME USERID!-
    -- UPDATE "DB2INST1".ADVISE_INSTANCE SET STATUS = 'UNKNOWN'
    -- WHERE STATUS = 'STARTED';

    How to resolve this issue.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    read your message and execute as requested
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Nov 2013
    Posts
    23
    Hi Guy,
    am getting the following error when i run the update advise.instance syntax
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0206N "UNKNOWN" is not valid in the context where it is used.
    SQLSTATE=42703



    also what are the options i have to kill the other "db2advis run" under my userid?

  4. #4
    Join Date
    Nov 2013
    Posts
    23
    i mean how can i make certain that there "ARE CERTAIN
    -- THERE ARE NO OTHER DB2ADVIS EXECUTIONS RUNNING UNDER
    -- THE SAME USERID!- i.e my id.

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    SQL0206N "UNKNOWN" is not valid i
    without ' is is handled as column name
    it is indicated : set status='UNKNOWN'
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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