Results 1 to 2 of 2

Thread: Partition Fail

  1. #1
    Join Date
    Sep 2003
    Location
    Hong Kong
    Posts
    2

    Unanswered: Partition Fail

    Hi All,

    DB2 v8.1 Fixpack 2 on AIX 5

    I have been trying to create DB partition and alwyas fail.
    The commands:
    1) db2start add dbpartitionnum HOSTNAME aixhost PORT 1 WITHOUT TABLESPACES
    or
    2) db2 add dbpartitionnum WITHOUT TABLESPACES

    The first command gives me "SQL6030N START or STOP DATABASE MANAGER failed. Reason code 5", while the second one gives "SQL6073N Add Node operation failed. SQLCODE = -1032".
    The content of my db2nodes:
    0 aixhost 0
    1 aixhost 1

    And both db2start and db2stop commands run succesfully.

    I have already spent so moch time on this trying everything suggested in manuals, forums, etc. But somehow no luck.

    Could anyone please help?

    Thanks,
    dd_aw

  2. #2
    Join Date
    Sep 2003
    Location
    Hong Kong
    Posts
    2

    Re: Partition Fail

    Just to update:
    I finally managed to create the partition, by first dropping the database. I don't why, but at least I can continue my work.

    Thanks,
    dd_aw


    Originally posted by dd_aw
    Hi All,

    DB2 v8.1 Fixpack 2 on AIX 5

    I have been trying to create DB partition and alwyas fail.
    The commands:
    1) db2start add dbpartitionnum HOSTNAME aixhost PORT 1 WITHOUT TABLESPACES
    or
    2) db2 add dbpartitionnum WITHOUT TABLESPACES

    The first command gives me "SQL6030N START or STOP DATABASE MANAGER failed. Reason code 5", while the second one gives "SQL6073N Add Node operation failed. SQLCODE = -1032".
    The content of my db2nodes:
    0 aixhost 0
    1 aixhost 1

    And both db2start and db2stop commands run succesfully.

    I have already spent so moch time on this trying everything suggested in manuals, forums, etc. But somehow no luck.

    Could anyone please help?

    Thanks,
    dd_aw

Posting Permissions

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