Results 1 to 2 of 2

Thread: db2 partition

  1. #1
    Join Date
    Jul 2005
    Posts
    19

    Unanswered: db2 partition

    Iam into setting up db2 partition (either db2 v8 and above or db2 v9). (LUW)
    Can anyone give me the following?

    * Installation on windows
    * Installation on unix (any flavour)
    * Any documents that you can direct me. (any links, pdf's etc)

    Do let me know, that will be much help to me.
    thanks

  2. #2
    Join Date
    Apr 2008
    Posts
    39
    Try the following steps

    Setting up DPF environment on Windows machines:
    1. CREATE MPP INSTANCE
    db2icrt MPP -s ese -u administrator,mypasswd -r 50000,50004
    Format: db2icrt <instance-name> -s <type of instance which is ese for DPF> -u username,password -r <starting port number>,<ending port number>
    These port numbers should not be listed in services file.
    2. set DB2INSTANCE=MPP
    Set it the instance just created;
    3. Run following commands to create 3 nodes:
    db2ncrt /n:1 /u:<username>,<passwd> /i:MPP /p:1
    db2ncrt /n:2 /u:<username>,<passwd> /i:MPP /p:2
    db2ncrt /n:3 /u:<username>,<passwd> /i:MPP /p:3
    4. db2 terminate
    5. db2stop force
    6. db2start
    This will show 3 nodes started successfully.

    Thanks,
    Madhavi

Posting Permissions

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