System copy error during create database

[rudi_adiwidjaja5]

Hi experts,

I am doing system copy from source system SAP NW 7.3, SUSE 11 SP2 X86 and DB2 10.5 FP3a to target system SUSE 11 SP3, powerlinux, and DB2 10.5 FP5. The import process was stopped during create database with the following messages:

ERROR 2015-06-17 09:12:50.693

MDB-01999  Error occured, first error is: <SQL0902C  A system error occurred. Subsequent SQL statements cannot be>

ERROR 2015-06-17 09:12:50.695

MUT-03025  Caught ESAPinstException in module call: .

ERROR 2015-06-17 09:12:50.898

FCO-00011  The step CreateDatabase with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|                                                                                    0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|cre                                                                                    atedbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_DB6_DB|ind|ind|ind|ind|db6|                                                                                    0|NW_DB6_CreateDb|ind|ind|ind|ind|NW_DB6_CreateDb|0|CreateDatabase was executed with                                                                                     status ERROR ( Last error reported by the step: Error occured, first error is: <SQL0902C  A system error occurred. Subsequent SQL statements cannot be >).

db2diag.log:

2015-06-17-09.12.50.548670+420 I183222A732      LEVEL: Error PID : 9482             TID : 17590093017568 PROC : db2sysc 0 INSTANCE: db2ap2           NODE : 000       DB   : AP2 APPHDL  : 0-15             APPID: *LOCAL.db2ap2.150617021250 AUTHID  : DB2AP2           HOSTNAME: powerlinux EDUID   : 24               EDUNAME: db2agent (AP2) 0 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:840 MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"       DIA8501C A buffer pool logic error has occurred. DATA #1 : <preformatted> Error acquiring container 0 (/db2/AP2/sapdata1/db2ap2/NODE0000/AP2/T0000000/C0000000.CAT) for tbsp 0.  Rc = 870F0002 2015-06-17-09.12.50.549427+420 I183955A3121     LEVEL: Severe PID : 9482             TID : 17590093017568 PROC : db2sysc 0 INSTANCE: db2ap2           NODE : 000       DB   : AP2 APPHDL  : 0-15             APPID: *LOCAL.db2ap2.150617021250 AUTHID  : DB2AP2           HOSTNAME: powerlinux EDUID   : 24               EDUNAME: db2agent (AP2) 0 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:0 DATA #1 : String, 18 bytes SQLB_CONTAINER_TAG DATA #2 : Hexdump, 512 bytes 0x00000FFF74487000 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487010 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487020 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487030 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487040 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487050 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487060 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487070 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487080 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487090 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF744870A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF744870B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF744870C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF744870D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF744870E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF744870F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487100 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487110 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487120 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000FFF74487130 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 2015-06-17-09.12.50.593922+420 I231016A574	LEVEL: Severe
PID	: 9482	TID : 17590093017568 PROC : db2sysc 0
INSTANCE: db2ap2	NODE : 000	DB   : AP2
APPHDL  : 0-15	APPID: *LOCAL.db2ap2.150617021250
AUTHID  : DB2AP2	HOSTNAME: powerlinux
EDUID   : 24	EDUNAME: db2agent (AP2) 0

FUNCTION: DB2 UDB, data management, sqldPoolCreate, probe:273

RETCODE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"

DIA8501C A buffer pool logic error has occurred.

2015-06-17-09.12.50.595068+420 I231591A572	LEVEL: Error
PID	: 9482	TID : 17590093017568 PROC : db2sysc 0
INSTANCE: db2ap2	NODE : 000	DB   : AP2
APPHDL  : 0-15	APPID: *LOCAL.db2ap2.150617021250
AUTHID  : DB2AP2	HOSTNAME: powerlinux
EDUID   : 24	EDUNAME: db2agent (AP2) 0

FUNCTION: DB2 UDB, base sys utilities, sqleStartDb, probe:38

RETCODE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"

DIA8501C A buffer pool logic error has occurred.

2015-06-17-09.12.50.596273+420 I232164A534	LEVEL: Severe
PID	: 9482	TID : 17590093017568 PROC : db2sysc 0
INSTANCE: db2ap2	NODE : 000	DB   : AP2
APPHDL  : 0-15	APPID: *LOCAL.db2ap2.150617021250
AUTHID  : DB2AP2	HOSTNAME: powerlinux
EDUID   : 24	EDUNAME: db2agent (AP2) 0

FUNCTION: DB2 UDB, base sys utilities, sqleStartDb, probe:40

DATA #1 : Hexdump, 4 bytes

0x00000FFF833E42A4 : 870F 0002

....

2015-06-17-09.12.50.599598+420 E232699A580	LEVEL: Info
PID	: 9482	TID : 17590093017568 PROC : db2sysc 0
INSTANCE: db2ap2	NODE : 000	DB   : AP2
APPHDL  : 0-15	APPID: *LOCAL.db2ap2.150617021250
AUTHID  : DB2AP2	HOSTNAME: powerlinux
EDUID   : 24	EDUNAME: db2agent (AP2) 0

FUNCTION: DB2 UDB, buffer pool services, sqlbCleanupBeforeTerm, probe:7955

DATA #1 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes

0000000000000001

DATA #2 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes

0000000000000001

2015-06-17-09.12.50.642057+420 E233280A520	LEVEL: Event
PID	: 9482	TID : 17590093017568 PROC : db2sysc 0
INSTANCE: db2ap2	NODE : 000	DB   :
APPHDL  : 0-15	APPID: *LOCAL.db2ap2.150617021250
AUTHID  : DB2AP2	HOSTNAME: powerlinux
EDUID   : 24	EDUNAME: db2agent (idle) 0

FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FreeResourcesOnDBShutdown, probe:15127

STOP

: DATABASE: AP2

: DEACTIVATED: NO

2015-06-17-09.12.50.642747+420 I233801A603	LEVEL: Severe
PID	: 9482	TID : 17590093017568 PROC : db2sysc 0
INSTANCE: db2ap2	NODE : 000	DB   :
APPHDL  : 0-15	APPID: *LOCAL.db2ap2.150617021250
AUTHID  : DB2AP2	HOSTNAME: powerlinux
EDUID   : 24	EDUNAME: db2agent (idle) 0

FUNCTION: DB2 UDB, base sys utilities, sqleCreateDb, probe:4470

MESSAGE : While creating database, error occured. Files and directories created

will be removed now.

DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes

-902

Please help, thank you in advance.

Regards,

Rudi

[former_member182657 · Accepted solution]

Hi Rudi,

FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:840
MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"

On more analysis suggest you to follow

IBM DB2 doesn't start on Linux - United States

& IBM IC95363: DB2 Windows MESSAGE : ZRC=0X870F0002=-2029060094=SQLO_BPSE &amp;quot;DEBUG LOGIC ERROR ...

seems relates with OS.

Regards,

[rudi_adiwidjaja5 · Accepted solution]

Hi Gaurav,

Thanks for your reply, however as written in the IBM APAR given, it is stated that such problem caused by program error and already fixed by higher FixPack (First Fixed in DB2 LUW v10.5 Fixpack 1), it is FixPack 5 already.

Any solution from SAP regarding this error message?

Regards,

Rudi

[manumohandas82 · Accepted solution]

Did you have any issues when you installed  DB2 10.5 FP5 on the target .

Can you check the logs from the /tm/ directory

Thanks ,

Manu

[rudi_adiwidjaja5 · Accepted solution]

Hi Manu,

DB2 installation has no issue.

Regards,

Rudi

[rudi_adiwidjaja5 · Accepted solution]

Any help/advise?

[rudi_adiwidjaja5 · Accepted solution]

I have resolved the problem by changing file system type for db2 data from XFS to EXT3, since DB2 LUW recommended EXT3 file system.

Regards,

Rudi

[former_member182657]

Hi rudi,

db2diag.log:



2015-06-17-09.12.50.548670+420 I183222A732      
LEVEL: Error


PID 
: 9482             
TID : 17590093017568 PROC : db2sysc 0


INSTANCE: db2ap2           
NODE : 000       
DB   : AP2


APPHDL  : 0-15             
APPID: *LOCAL.db2ap2.150617021250


AUTHID  : DB2AP2           
HOSTNAME: powerlinux


EDUID   : 24               
EDUNAME: db2agent (AP2) 0



FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:840
MESSAGE : ZRC=0x870F0002=-2029060094=SQLO_BPSE "Debug logic error detected"

Have a look with SAP Note   799799 - DB6: ZRC codes in the db2diag.log

& follow the solution from same.

Hope this will help you.

Good luck !!