Skip to Content
0
Former Member
Oct 06, 2014 at 03:46 PM

Error during Ecc6 installation (Phase 14 database creation failed)

61 Views

Hi,

Phase 14 (During the database creation phase) error as below from Database.

Database : DB2 8.1

OS: Windows 2008 server 64bit



SQL0902C A system error (reason code = "") occurred. Subsequent

SQL statements cannot be processed. SQLSTATE=58005

Explanation:

A system error occurred.

User Response:

Record the message number (SQLCODE) and reason code in the

message.

If trace was active, invoke the Independent Trace Facility at

the operating system command prompt. Then contact your technical

service representative with the following information:

o Problem description

o SQLCODE and embedded reason code

o SQLCA contents if possible

o Trace file if possible.

Federated system users: isolate the problem to the data source

failing the request (refer to the problem determination guide to

determine which data source is failing to process the SQL

statement) and take the necessary diagnostic steps for that data

source. The problem determination procedures for data sources

vary, so refer to the applicable data source manuals.

sqlcode : -902

sqlstate : 58005

As well as Dialog shared below........

2014-10-06-17.27.34.017000+330 I1F933 LEVEL: Event

PID : 6052 TID : 5088 PROC : db2set.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, RAS/PD component, _pdlogInt, probe:120

START : New db2diag.log file

DATA #1 : Build Level, 144 bytes

Instance "DB2TRP" uses "64" bits and DB2 code release "SQL08025"

with level identifier "03060106".

Informational tokens are "DB2 v8.1.12.99", "s060429", "WR21370", FixPak "12".

DATA #2 : System Info, 1568 bytes

System: WIN32_NT SAPPRM Service Pack 1 6.0 AMD64 Family 6, model 26, stepping 5

CPU: total:16 online:16 Cores per socket:8 Threading degree per core:1

Physical Memory(MB): total:16373 free:14457 available:14457

Virtual Memory(MB): total:62868 free:75715

Swap Memory(MB): total:46495 free:61258

Information in this record is only valid at the time when this file was

created (see this record's time stamp)

2014-10-06-17.27.34.017000+330 I937F296 LEVEL: Event

PID : 6052 TID : 5088 PROC : db2set.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40

CHANGE : CFG DB2SET: DB2_WORKLOAD: From: "" To: "SAP"

2014-10-06-17.27.34.033000+330 I1235F298 LEVEL: Event

PID : 1816 TID : 1804 PROC : db2set.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40

CHANGE : CFG DB2SET: DB2COMM: From: "TCPIP" To: "TCPIP"

2014-10-06-17.27.34.064000+330 I1535F292 LEVEL: Event

PID : 6024 TID : 5948 PROC : db2set.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40

CHANGE : CFG DB2SET: DB2COUNTRY: From: "" To: "1"

2014-10-06-17.27.34.079000+330 I1829F341 LEVEL: Event

PID : 4152 TID : 3964 PROC : db2set.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40

CHANGE : CFG DB2SET: DB2ENVLIST: From: "" To: "INSTHOME SAPSYSTEMNAME dbs_db6_schema DIR_LIBRARY "

2014-10-06-17.27.34.111000+330 I2172F306 LEVEL: Event

PID : 4936 TID : 288 PROC : db2set.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40

CHANGE : CFG DB2SET: DB2_GRP_LOOKUP: From: ",TOKEN" To: "LOCAL"

2014-10-06-17.27.37.995000+330 I2480F1666 LEVEL: Event

PID : 508 TID : 4492 PROC : DB2START.EXE

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130

DATA #1 : String, 40 bytes

C:\PROGRA~1\IBM\SQLLIB\\bin\DB2STAR2.EXE

DATA #2 : Hexdump, 256 bytes

0x000000000012A8C0 : 433A 5C50 524F 4752 417E 315C 4942 4D5C C:\PROGRA~1\IBM\

0x000000000012A8D0 : 5351 4C4C 4942 5C5C 6269 6E5C 4442 3253 SQLLIB\\bin\DB2S

0x000000000012A8E0 : 5441 5232 2E45 5845 004E 4F4D 5347 0000 TAR2.EXE.NOMSG..

0x000000000012A8F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A900 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A910 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A920 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A930 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A940 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A950 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A960 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A970 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A980 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A990 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A9A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

0x000000000012A9B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2014-10-06-17.27.38.167000+330 I4148F319 LEVEL: Event

PID : 5632 TID : 6000 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30

CHANGE : CFG DBM: "Instance_Memory" <automatic> From: "20" To: "11704"

2014-10-06-17.27.38.182000+330 E4469F937 LEVEL: Warning

PID : 5632 TID : 6000 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, base sys utilities, LicCheckProcessors, probe:20

MESSAGE : ADM12017E The number of processors on this machine exceeds the

defined entitlement of "1" for the product "DB2 Enterprise Server

Edition". The number of processors on this machine is "2". You should

purchase additional processor based entitlements from your IBM

representative or authorized dealer and update your license using the

License Center or the db2licm command line utility. For more

information on updating processor based licenses, refer to the Quick

Beginnings manual for your platform. For more information on the

db2licm utility, refer to the DB2 Command Reference.

2014-10-06-17.27.39.259000+330 E5408F865 LEVEL: Event

PID : 5632 TID : 6000 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911

MESSAGE : ADM7513W Database manager has started.

START : DB2 DBM

DATA #1 : Build Level, 144 bytes

Instance "DB2TRP" uses "64" bits and DB2 code release "SQL08025"

with level identifier "03060106".

Informational tokens are "DB2 v8.1.12.99", "s060429", "WR21370", FixPak "12".

DATA #2 : System Info, 1568 bytes

System: WIN32_NT SAPPRM Service Pack 1 6.0 AMD64 Family 6, model 26, stepping 5

CPU: total:16 online:16 Cores per socket:8 Threading degree per core:1

Physical Memory(MB): total:16373 free:14418 available:14418

Virtual Memory(MB): total:62868 free:75575

Swap Memory(MB): total:46495 free:61157

2014-10-06-17.27.39.914000+330 I6275F408 LEVEL: Severe

PID : 5632 TID : 5720 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:20

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2014-10-06-17.27.39.929000+330 I6685F296 LEVEL: Severe

PID : 5632 TID : 5720 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000

MESSAGE : User ID

DATA #1 : Hexdump, 4 bytes

0x0000000005D7FA48 : 0000 0000 ....

2014-10-06-19.27.39.670000+330 I6983F408 LEVEL: Severe

PID : 5632 TID : 5720 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:20

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2014-10-06-19.27.39.733000+330 I7393F296 LEVEL: Severe

PID : 5632 TID : 5720 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000

MESSAGE : User ID

DATA #1 : Hexdump, 4 bytes

0x0000000005D7FA48 : 0000 0000 ....

2014-10-06-19.32.39.736000+330 I7691F408 LEVEL: Severe

PID : 5632 TID : 5720 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000

FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:20

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2014-10-06-19.32.39.799000+330 I8101F296 LEVEL: Severe

PID : 5632 TID : 5720 PROC : db2syscs.exe

INSTANCE: DB2TRP NODE : 000

MESSAGE : User ID

DATA #1 : Hexdump, 4 bytes

0x0000000005D7FA48 : 0000 0000 ....

Regards

Abhijit