Skip to Content
0
Former Member
Jul 24, 2010 at 06:04 PM

Problem SA MP with DB2 9.5

323 Views

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