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
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