Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Posts
    3

    Question Unanswered: DB2 error message SQL1096N

    a remote employee installed DB2 (8.1 EEE) on his
    workstation. I do not know what responces he used on
    the install, but I beleive all the defaults.

    After installing I instructed him to bring up the
    Command Line Processor and enter a "CREATE DATABASE"
    (to a local drive) command. He did this by "copy-n-paste"
    from a text file I sent him, so I am sure the syntax is correct on the statement. However, he gets the following
    error:

    SQL1096N The command is not valid for this node type.

    What might have he done wrong (or missed) on the install to
    get this error message?? (I am able to create the database
    successfully on my machine.)

    Thanks,
    K

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I assume you mena DB2 ESE. There is no EEE in 8.1.

    What operating system was it installed on?

    Did he try to create a database using the Control Center, or create the sample database in DB2 First Start?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2005
    Posts
    3
    Yes, sorry, DB2 ESE 8.1
    I have asked him to run the db2level and db2licm -l commands and send me the
    output but he has not yet done that.

    He is probably running Windows 2000 (not server) but possibly might have Windows XP.

    No, I do not believe he tried the sample. I know he did not use the command center, as I instructed him to use the Command Line Processor.

    K.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    The other possibility is that he has installed a client and not a database server...

    Ask him for the file names in sqllib/cfg directory ..

    db2ese.lvl should be present if he has installed the server ..


    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Feb 2005
    Posts
    3

    thank you, it was client only!

    Thank you for the pointers. Turns out the remote employee did only install
    the client code.

    K.

Posting Permissions

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