Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2007
    Posts
    265

    Unanswered: db2look command error

    Hi,

    We have a server with 64-BIT 8.1 FP 18 DB2 UDB on Linux ( CentOS) and I'm having a problem with the db2look command --. when I give it to see the definition of a table I get this error --

    db2look -d dbname -t site -e -x -o site.ddl
    -- No userid was specified, db2look tries to use Environment variable USER
    -- USER is: DB2INST1
    -- The db2look utility will consider only the specified tables
    -- Creating DDL for table(s)
    -- Output is sent to file: site.ddl
    SQL0007N The character "\" following "HIJKLMNOPQRSTUVWXYZ[" is not valid.
    SQLSTATE=42601


    Any idea how I can fix this? Thanks!!
    Edit/Delete Message
    Last edited by db2user24; 06-01-11 at 11:46.

  2. #2
    Join Date
    Sep 2006
    Posts
    105
    You need to specify -z schema name in your db2look command.

  3. #3
    Join Date
    Nov 2007
    Posts
    265
    thanks, i tried it with -z and still get the same error, any other ideas?

  4. #4
    Join Date
    Sep 2006
    Posts
    105
    db2look -d dbname -z schemaname -t tablename -l -e -a -x -o o/pfilename

    Please do check the DB2 Manuals for the command.( for options)

  5. #5
    Join Date
    Nov 2007
    Posts
    265
    thx, i tried that and it still fails.. I don't think there is anything wrong with the command itself.. but maybe I'm missing some packages..has anyone else seen this before?

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What's the output from:

    env | grep LANG
    db2 get db cfg for <db name> | grep code

  7. #7
    Join Date
    Nov 2007
    Posts
    265
    Quote Originally Posted by BELLO4KA View Post
    What's the output from:

    env | grep LANG
    db2 get db cfg for <db name> | grep code

    Hi, this is what I get --



    env | grep LANG
    LANG=en_US.UTF-8


    db2 get db cfg for dbname | grep code
    Database code page = 819
    Database code set = ISO8859-1
    Database country/region code = 1

  8. #8
    Join Date
    Nov 2007
    Posts
    265
    Also, thought I would add that I tried it without the -t option and it worked just fine --

    this works : db2look -d dbname -e -x -o site.ddl

Posting Permissions

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