Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2012
    Posts
    9

    SQL6073N Add Database Partition operation failed

    Hi,

    when i try to to Add Database Partition by use the IBM API within my code,
    then i get always the following message:
    "SQL6073N Add Database Partition operation failed. SQLCODE = "-1005"."

    I use the IBM API sqleaddn (AddNodeOptions_ptr, &sqlca); to add the database partition.

    please can you explain to me what the mean of SQLCODE = "-1005", and how can i solve this issue?

    Regards,
    Hussein

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Did you try looking up error SQL1005N?
    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
    Jul 2012
    Posts
    9
    Hi,

    is there a DB2 command that i can use it to attach database partition,
    instead of using IBM API sqleaddn function?

    Regards,
    Hussein

  4. #4
    Join Date
    Mar 2003
    Posts
    279
    Google for db2 attach partition

  5. #5
    Join Date
    Jul 2012
    Posts
    9
    i can't find the command that replace the API sqleaddn (AddNodeOptions_ptr, &sqlca) in google,
    please can you give me a command that do that?
    when i say command i mean commands like db2level, db2stop, ....

  6. #6
    Join Date
    Mar 2003
    Posts
    279
    Quote Originally Posted by hhatib View Post
    i can't find the command that replace the API sqleaddn (AddNodeOptions_ptr, &sqlca) in google,
    please can you give me a command that do that?
    when i say command i mean commands like db2level, db2stop, ....
    I'm not familiar with that API so I can't help you with that. What is it you are trying to do, and what platform/version are you using?

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The term attach has to do with DB2 table partitions, and not DB2 database partitions.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,361

Posting Permissions

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