Skip to Content
0
Jun 17, 2015 at 03:09 AM

System copy error during create database

228 Views

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