Problem SA MP with DB2 9.5
Dear All
Could you please help me support SA_MP share disk ?
./sapdb2policy.sh -f ~/samp_setup/sapdb2policy.conf -l ~/samp_setup/sapdb2policy.log -create
Start database server:
Database server on node node1 started!
Setup DB2 Cluster using db2haicu:
Generating db2haicu configuration file (/tmp/cluster_config.xml)
........... Finished!
Executing db2haicu at node node1 ... Finished with errors! RC=1
Setup failed with return code 20. Please look for problems in the log
file /root/samp_setup/sapdb2policy.log.
./sapdb2policy.sh -create finished on Fri Jul 23 21:29:16 ICT 2010
This is my db2dialog.
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:896
MESSAGE : ZRC=0x820000AB=-2113929045=SQLZ_RC_HA_INTERNAL "Internal SQLHA Error"
2010-07-24-14.11.21.796570+420 I397324E554 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:896
DATA #1 : String, 116 bytes
Error checking container 1 (/db2/PRD/sapdata2/db2prd/NODE0000/PRD/T0000034/C0000001.LRG) for tbsp 34. Rc = 820000AB
2010-07-24-14.11.21.797241+420 I397879E645 LEVEL: Warning
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetPolicy, probe:100
MESSAGE : ECF=0x900001F6=-1879047690=ECF_GENREG_NO_MATCHING_RECORD_FOUND
No matching record found
DATA #1 : String, 49 bytes
Could not get HA Policy Information from Sys file
DATA #2 : signed integer, 4 bytes
0
2010-07-24-14.11.21.797374+420 I398525E542 LEVEL: Warning
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetPolicyTypeFromSysFile, probe:400
MESSAGE : No matching instance record ... setting policy to none
DATA #1 : unsigned integer, 4 bytes
0
2010-07-24-14.11.21.797455+420 E399068E499 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaAmIinClusterEnvironment, probe:1100
MESSAGE : The policy could not be obtained from the sys file.
2010-07-24-14.11.21.797525+420 I399568E557 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:896
DATA #1 : String, 33 bytes
Cluster delete operation failed:
DATA #2 : String, 59 bytes
/db2/PRD/sapdata1/db2prd/NODE0000/PRD/T0000034/C0000002.LRG
2010-07-24-14.11.21.797613+420 I400126E489 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:896
MESSAGE : ZRC=0x820000AB=-2113929045=SQLZ_RC_HA_INTERNAL "Internal SQLHA Error"
2010-07-24-14.11.21.797698+420 I400616E554 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:896
DATA #1 : String, 116 bytes
Error checking container 2 (/db2/PRD/sapdata1/db2prd/NODE0000/PRD/T0000034/C0000002.LRG) for tbsp 34. Rc = 820000AB
2010-07-24-14.11.21.835601+420 I401171E645 LEVEL: Warning
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetPolicy, probe:100
MESSAGE : ECF=0x900001F6=-1879047690=ECF_GENREG_NO_MATCHING_RECORD_FOUND
No matching record found
DATA #1 : String, 49 bytes
Could not get HA Policy Information from Sys file
DATA #2 : signed integer, 4 bytes
0
2010-07-24-14.11.21.835747+420 I401817E542 LEVEL: Warning
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetPolicyTypeFromSysFile, probe:400
MESSAGE : No matching instance record ... setting policy to none
DATA #1 : unsigned integer, 4 bytes
0
2010-07-24-14.11.21.835830+420 E402360E499 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaAmIinClusterEnvironment, probe:1100
MESSAGE : The policy could not be obtained from the sys file.
2010-07-24-14.11.21.835902+420 I402860E557 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:896
DATA #1 : String, 33 bytes
Cluster delete operation failed:
DATA #2 : String, 59 bytes
/db2/PRD/sapdata3/db2prd/NODE0000/PRD/T0000035/C0000000.LRG
2010-07-24-14.11.21.835992+420 I403418E489 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:896
MESSAGE : ZRC=0x820000AB=-2113929045=SQLZ_RC_HA_INTERNAL "Internal SQLHA Error"
2010-07-24-14.11.21.836085+420 I403908E554 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:896
DATA #1 : String, 116 bytes
Error checking container 0 (/db2/PRD/sapdata3/db2prd/NODE0000/PRD/T0000035/C0000000.LRG) for tbsp 35. Rc = 820000AB
2010-07-24-14.11.21.836824+420 I404463E645 LEVEL: Warning
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetPolicy, probe:100
MESSAGE : ECF=0x900001F6=-1879047690=ECF_GENREG_NO_MATCHING_RECORD_FOUND
No matching record found
DATA #1 : String, 49 bytes
Could not get HA Policy Information from Sys file
DATA #2 : signed integer, 4 bytes
0
2010-07-24-14.11.21.836930+420 I405109E542 LEVEL: Warning
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetPolicyTypeFromSysFile, probe:400
MESSAGE : No matching instance record ... setting policy to none
DATA #1 : unsigned integer, 4 bytes
0
2010-07-24-14.11.21.837023+420 E405652E499 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaAmIinClusterEnvironment, probe:1100
MESSAGE : The policy could not be obtained from the sys file.
2010-07-24-14.11.21.837094+420 I406152E557 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:896
DATA #1 : String, 33 bytes
Cluster delete operation failed:
DATA #2 : String, 59 bytes
/db2/PRD/sapdata2/db2prd/NODE0000/PRD/T0000035/C0000001.LRG
2010-07-24-14.11.21.837182+420 I406710E489 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:896
MESSAGE : ZRC=0x820000AB=-2113929045=SQLZ_RC_HA_INTERNAL "Internal SQLHA Error"
2010-07-24-14.11.21.837267+420 I407200E554 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:896
DATA #1 : String, 116 bytes
Error checking container 1 (/db2/PRD/sapdata2/db2prd/NODE0000/PRD/T0000035/C0000001.LRG) for tbsp 35. Rc = 820000AB
2010-07-24-14.11.21.837956+420 I407755E645 LEVEL: Warning
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetPolicy, probe:100
MESSAGE : ECF=0x900001F6=-1879047690=ECF_GENREG_NO_MATCHING_RECORD_FOUND
No matching record found
DATA #1 : String, 49 bytes
Could not get HA Policy Information from Sys file
DATA #2 : signed integer, 4 bytes
0
2010-07-24-14.11.21.838060+420 I408401E542 LEVEL: Warning
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetPolicyTypeFromSysFile, probe:400
MESSAGE : No matching instance record ... setting policy to none
DATA #1 : unsigned integer, 4 bytes
0
2010-07-24-14.11.21.838140+420 E408944E499 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaAmIinClusterEnvironment, probe:1100
MESSAGE : The policy could not be obtained from the sys file.
2010-07-24-14.11.21.838210+420 I409444E557 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:896
DATA #1 : String, 33 bytes
Cluster delete operation failed:
DATA #2 : String, 59 bytes
/db2/PRD/sapdata1/db2prd/NODE0000/PRD/T0000035/C0000002.LRG
2010-07-24-14.11.21.838339+420 I410002E489 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:896
MESSAGE : ZRC=0x820000AB=-2113929045=SQLZ_RC_HA_INTERNAL "Internal SQLHA Error"
2010-07-24-14.11.21.838426+420 I410492E554 LEVEL: Error
PID : 29612 TID : 47342602414400PROC : db2sysc 0
INSTANCE: db2prd NODE : 000 DB : PRD
APPHDL : 0-741 APPID: *LOCAL.db2prd.100724071118
AUTHID : DB2PRD
EDUID : 34 EDUNAME: db2agent (PRD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:896
DATA #1 : String, 116 bytes
Error checking container 2 (/db2/PRD/sapdata1/db2prd/NODE0000/PRD/T0000035/C0000002.LRG) for tbsp 35. Rc = 820000AB
Thanks