How to create a Database in DB2 using command line processor on remote DB2 server?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Dayakar Reddy
    #1

    How to create a Database in DB2 using command line processor on remote DB2 server?

    Hi,

    we are trying to use CLP tool provided by DB2 client installer to create DB2 database.
    We followed the following steps
    1)Invoked command line processor (CLP)
    2) catalog tcpip node DB2_01 remote 10.134.5.10 server 50000
    3) create database mynewdb
    we are getting the below error message.
    SQL1096N The command is not valid for this node type.

    Thanks,
    Dayakar
    Tags: None
    • vijay2082
      New Member
      • Aug 2009
      • 112
      #2
      Hi Dayakar,

      You must have sysadm or sysctrl authority before using this command.

      Once your instance catalog is successful you need to attache to tthe instance using proper privilege before using the create database command :

      1)Invoked command line processor (CLP)
      2) db2 "catalog tcpip node DB2_01 remote 10.134.5.10 server 50000 "
      3) db2 terminate
      db2 list node directory

      above command should list your remote node
      4)db2 "attach to db2_01 user <userid> using <password>"
      This user must have either sysadm or sysctrl authority
      5) db2 "create database mynewdb"

      http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html


      Cheers, Vijay

        Comment

        Previous template Next
        Working...