Cluster Error SAP ECC EHP5 using DB2

[Former Member]

Hi, I´m installing SAP ECC EHP5 over Windows Server 2008 R2 in MSCS using DB2 as Database.

I follow the steps in the installation guide and the first node was sucessfully installed. My problem is that when I execute the second step of the installation (database installation), in the sub-step "Now cluster the database" , after installed the database in the second node and run the utility db2mscs the following error occurs when I tried to initialice the DB2 service:

"An error occurred while attemping to bring the resource ''DB2 Server' online"

Error code: 0x8007138f

The cluster resource could not be found

Could you please give any hint to continue the installation?

Thanks a lot.

Kind regards

[Former Member]

Hello,

Now when I tried to run the sapinst from the previous step. The sapinst failed in the following phase:

Update Database Registry

And in the db2set.log file the following error appears:

SQL0970N The system attempted to write to a read-only file.

I checked the share folders and it´s permissions and seems to be ok.

I really appreciated any help that you can give me.

Thanks a lot.

Kind Regards

[Former Member]

> Update Database Registry
> 
> And in the db2set.log file the following error appears:
> 
> SQL0970N  The system attempted to write to a read-only file.

Hello,

It seems it fails to write into some log files etc.

May be the problem is with the 'Share Resource' called db2dumpSID. I think log files in the shared path /db2/SID/db2dump are not accessible. Let's verify the permissions for this path/folder. And the drive is already shared ?

Thanks

[Former Member]

Hi,

In fact the problem was that the user db2 user and seems to be ok. And I installed the database software using the sapinst follow the installation guide.

Any idea about another thing to check???

Thanks a lot.

Kind Regards

[Former Member]

Hello,

Is the full log for this phase ? There might be some errors before these error lines.

Since the 'database' hasn't been created yet, so the 'SID' it is trying to search is may be the 'database instance'. Please check if db2 instance is already up or not. Also check once, db2 list db directory

Thanks

[Former Member]

Hello,

That is the full log for the file

invoke_db2sap.log

and the relevant information in the file

sapinst.log

If I run the following command that is the return:

db2 => list active databases

SQL1611W No data was returned by Database System Monitor

The service DB2<sid>-0 is up.

Thanks a lot.

Kind Regards

[Former Member]

Hello,

Check these two commands -

db2ilist -a

db2 list db directory

And what if you type, db2start

Thanks

[Former Member]

Hello,

These are the commands:

db2start

SQL1026N The database manager is already active

db2 => list db directory

SQL1057W The system database directory is empty. SQLSTATE=01606

Additionally in the sapinst.log I found the following warning:

WARNING 2011-10-14 15:40:02.130

Execution of the command "C:\db2\db2prd\db2_software\BIN\db2cmd.exe /C /w /i db2 -tvf invoke_db2sap.sql -r invoke_db2sap.res -z invoke_db2sap.out" finished with return code 4. Output:

And If I tried to run the commandin the console manually the following message appears:

UPDATE COMMAND OPTIONS USING S OFF

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING A OFF

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING X ON

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING O ON

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

UPDATE COMMAND OPTIONS USING N OFF

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

invoke db2sap

SQL1328N An implicit connection attempt failed. The database alias name or

database name "<sid>" was not found in the local database directory.

SQLSTATE=42705

TERMINATE

DB20000I The TERMINATE command completed successfully.

Thanks a lot.

Edited by: Esteban REyes on Oct 14, 2011 4:43 PM

[Former Member]

Not sure, I am running out of ideas right now.

Thanks

[Former Member]

Hi,

Before running db2mscs utility, try installing "db2 license" and then run the utility.

Regards.

Rajesh Narkhede

[Former Member]

Hello,

Thank you for your help.

Finally I found the solution.

I execute the command Catalog Database <sid> in a db2 console in the server, and then the installation continue.

Kind Regards

[Former Member]

Thanks a lot for posting the solution !

Best Regards

[Former Member]

Hello,

I re-checked the parameters in the db2mscs.eee file and ran again the db2mscs utility and now the service is working.

Now I´m going to continue with the installation process.

Thanks a lot

Kind Regards

[Former Member]

Hello,

Exactly at which step ?

2. While executing db2mscs utility under 'Configure the database for MSCS' ? Or

3. Create a share resource ?

After creation of resource db2dump<DBSID> manually, you need to put it online.

Thanks

[Former Member]

Hi, when I run the db2mscs utility. The utility finished but with the error that was unable to initialize the DB2 service, and If I tried to initialize the service using the Failover console the same error occurs.

Thanks a lot.

Kind Regards

[Former Member]

Hello,

Did you complete the information in db2mscs.eee file properly and used db2swtch utility ?

Thanks