Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2012
    Posts
    23

    Unanswered: DB2 ERROR while taking db2look

    Hi,

    In my environment we are using DB2 V10.1 with RHEL 6.
    In this environment i have one database when i am using db2look for full database it is showing the error.
    the command which i used was db2look -d claim -e -a -m -l -x -o claim.ddl
    and i found the below error.

    ERROR:

    -- Generate statistics for all creators
    -- Creating DDL for table(s)
    -- Running db2look in mimic mode


    SQL0811N The result of a scalar fullselect, SELECT INTO statement, or VALUES
    INTO statement is more than one row. SQLSTATE=21000


    Please do the needful ASAP.....

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Open a PMR with IBM.

    Andy

  3. #3
    Join Date
    Aug 2012
    Posts
    23

    Db2

    Could you please suggest me is there any other way to resolve this issue without contacting IBM and for taking the DDL's of database.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You are having a problem with db2look, a tool written and supported by IBM. But you want someone else to fix it for you????

    Andy

Posting Permissions

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