cancel
Showing results for 
Search instead for 
Did you mean: 

Problem SA MP with DB2 9.5

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Dear Steffen Siegmund

I open message for SAP. But SAP still pending.

Thanks

Former Member
0 Kudos

Dear Steffen Siegmund

I use new tool but It still problem.

cat /root/samp_setup/sapdb2cluster.log

db2haicu is collecting information on your current setup. This step may take some time as db2haicu will need to activate all databases for the instance to discover all paths ...

SQL1345N Execution failed due to a cluster manager error that will not affect the successful execution of subsequent SQL statements. SQLSTATE=58038

\n--- db2haicu - log file (end) ---

\nERROR: () : Finished with errors! RC=1

Thanks

0 Kudos

Hi,

could you open a SAP message with OS access and a description of the cluster?

Best regards,

Steffen

Former Member
0 Kudos

Dear Steffen Siegmund

Could you please help me document this document sapdb2cluster.sh.

With new version sapdb2cluster.sh which is supported DB2 9.7 ???

Thanks

Former Member
0 Kudos

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.

Thanks

0 Kudos

Hi,

please see SAP Note 960843. The new version of sapdb2cluster was published which is much more convenient.

Best regards,

Steffen