Error during Ecc6 installation (Phase 14 database creation failed)

[Former Member]

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

[Former Member]

Hi,

Add DB2 User ID in Windows admin group and try stoping and starting database.

Check no db2 related processes are running before resuming the process in SAPINST.

For the other error try using the SAPINST tool from the media files or upgrade the existings one.

IMP:

DB2 8.1 is out of support for WINDOWS 2008 server. Use higher DB2 version than 8

[Former Member]

Hi,

i did above this but problem is same. So we have decided that windows 2003 is the supportable operating system with this database so again we are back with the supportable operating system with database. Thanks to all

Regards

Abhijit

[Sriram2009]

Hi Abhijit

DB2 8.1 not support Windows 2008 server you have to select DB2 version 9.5 & above, DB2 8.1 version supported only windows 2003  Could you check the SAP PM link

https://service.sap.com/sap/support/pam?hash=s%3DSAP%2520ECC%25206.0%26o%3Dmost_viewed%257Cdesc%26st...

Regards

SS

[Former Member]

Hi Abhijit,

For your DB creation error , refer to below link , if it is helpful

http://www.dbforums.com/showthread.php?1698986-Database-Create-Error

Check if antivirus installed has included your DB2 directories starting with /db2/***

Br Vaibhav

[Former Member]

Hi Abhijit,

Ensure that all files are allowed both read and write access.

Check for unnecessary blank spaces within the specified filename.

Also check the user and its roles.

Regards,

Prithviraj.

[Former Member]

Hi Prithviraj,

Thanks for replying but all files are allowed both read & write access in the server. last, i got this note 1480906 where is mentioned some prerequisite before installing Ecc6 on this server. i checked this note & while i started following error as below.

SAPinst is getting started.

Please be patient ...

MessageLib: error: unexpected element 'map_errno_to_exitcode' (content model: children) [vc: element valid] entity=file://F:/INStupdated/Inst.Master_6.20_6.40_based_products_/IM_WINDOWS_X86_64/SAPINST/NT/AMD64/messages.xml in line 7, 24

guiengine: login in process.

WARNING (CCancelOverwriteDialogModifier::getText()): no message dictionary available...

MessageLib: error: unexpected element 'map_errno_to_exitcode' (content model: children) [vc: element valid] entity=file://C:/Program Files/sapinst_instdir/PRC_SERVICE/messages.xml in line 7, 24

ERROR Error while loading messages into message dictionary; check your message path.

Exit status of child: 1

Regards

Abhijit