Transaction failed under DPF

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • VMK

    #1

    Transaction failed under DPF

    Hi guys,


    while creating tablespace at one of the participating node am facing
    the below error.

    db2 =CREATE TABLESPACE ts0401k IN DATABASE PARTITION GROUP dpg1
    PAGESIZE 4k MANAGED BY SYSTEM USING ('/dpf/data_4k') ON NODES(1)
    DB21034E The command was processed as an SQL statement because it was
    not a
    valid Command Line Processor command. During SQL processing it
    returned:
    SQL0903N COMMIT statement failed, transaction rolled back. Reason
    code: "2".
    SQLSTATE=40504


    ------------------------------------------------------------>>>

    When i execute the same for node(0) it works fine.

    db2 =CREATE TABLESPACE TBS04K IN DATABASE PARTITION GROUP DPG0
    PAGESIZE 4K MANAGED BY SYSTEM USING ('/dpf/data_4k/') ON NODES (0)
    DB20000I The SQL command completed successfully.




    The communication between the nodes successfull...
    Only when i try to create a tablespace or table on the node1 am facing
    the above error.


    Here is my environment for both the systems

    =============== =============== =============== =============== ===
    db2set -all
    [i] DB2COMM=tcpip
    [g] DB2ADMINSERVER= db2das
    =============== =============== =============== =============== ===

    =============== =============== =============== =============== ===
    db2 list node directory

    Node Directory

    Number of entries in the directory = 2

    Node 1 entry:

    Node name = DPF1
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = 192.168.10.2
    Service name = 50000

    Node 2 entry:

    Node name = DPF2
    Comment =
    Directory entry type = LOCAL
    Protocol = TCPIP
    Hostname = 192.168.10.3
    Service name = 50000
    =============== =============== =============== =============== ===

    =============== =============== =============== =============== ===
    db2nodes.cfg
    0 RH9-DPF-1 0
    1 RH9-DPF-2 0
    =============== =============== =============== =============== ===

    =============== =============== =============== =============== ===
    ..rhosts
    RH9-DPF-1 db2inst1
    RH9-DPF-2 db2inst1
    =============== =============== =============== =============== ===

    =============== =============== =============== =============== ===
    cat /etc/hosts
    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    # 127.0.0.1 RH9-DPF-1 localhost.local domain localhost
    192.168.10.2 RH9-DPF-1
    192.168.10.3 RH9-DPF-2
    =============== =============== =============== =============== ===

    =============== =============== =============== =============== ===
    db2 list dbpartitionnums

    DATABASE PARTITION NUMBER
    ----------------------------
    0
    1
    =============== =============== =============== =============== ===

    =============== =============== =============== =============== ===
    db2 list database partition groups

    DATABASE PARTITION GROUP
    ----------------------------
    DPG0
    DPG01
    DPG1
    IBMCATGROUP
    IBMDEFAULTGROUP
    =============== =============== =============== =============== ===




    Guys any clues ???

    Best regards
    VMK

Working...