SAP startup failure after DB2 upgrade 9.5 to 9.7

[Former Member]

Hi All,

We have upgraded DB2 Database from 9.5 to 9.7 in Development system.We are unable to stsart the SAP.Please find trans.log details below.

Checking db Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

***********************************************************************

• This is Saposcol Version COLL 20.95 700 - AIX v11.15 5L-64 bit 080317

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 8912994) is already running .....

************************************************************************

saposcol already running

ABAP Database db must be started on remote server

-

---

4 ETW000 [dev trc ,00000] (0.274) DB6: DROP INDEX on virtual table ignored (note 1514380) 30 0.008760

4 ETW000 [dev trc ,00000] (0.277) DB6: FOR ALL ENTRIES statement with SUBSTITUTE LITERALS (note 1520152)

4 ETW000 41 0.008801

4 ETW000 [dev trc ,00000] (0.279) DB6: SQL0301N after LONG to LOB conversion (note 1524339) 25 0.008826

4 ETW000 [dev trc ,00000] Supported features: 22 0.008848

4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 35 0.008883

4 ETW000 [dev trc ,00000] ..done 118 0.009001

4 ETW000 [dev trc ,00000] DB2 library successfully loaded DB2 library '/home/fbeadm/sqllib/lib64/libdb2.a(shr_64.o)' successfully loaded

4 ETW000 13885 0.022886

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 25 0.022911

4 ETW000 [dev trc ,00000] Running with CLI runtime client libraries. 6880 0.029791

4 ETW000 [dev trc ,00000] Fri Jan 20 15:35:34 2012 611496 0.641287

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1786] CON = 0 (BEGIN) 104 0.641391

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated

4 ETW000 49 0.641440

4 ETW000 [dev trc ,00000] &+ file system. SQLSTATE=58031

4 ETW000 42 0.641482

4 ETW000 [dev trc ,00000] &+

4 ETW000 41 0.641523

4 ETW000 [dev trc ,00000] &+

4 ETW000 42 0.641565

4 ETW000 [dev trc ,00000] &+

4 ETW000 68 0.641633

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1786] (END) 26 0.641659

4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'FBE' as 'sapfbe' failed 86 0.641745

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'FBE'"

-

---

Could you please help into this issue?

Regrads,

Mani

[Former Member]

Hi,

Download the latest kernel on database independent from service market place for ur platform

and then restart... it may work out....

thanks and regards,

santosh

[Former Member]

Please check my earlier post and let us know what the commands result in.

Regards,

Sai

[Former Member]

Hi All,

Please find command results below.

db2fbe> db2 list database directory

System Database Directory

Number of entries in the directory = 2

Database 1 entry:

Database alias = PRDL

Database name = FBE

Local database directory = /db2/FBE

Database release level = d.00

Comment =

Directory entry type = Indirect

Catalog database partition number = 0

Alternate server hostname =

Alternate server port number =

Database 2 entry:

Database alias = FBE

Database name = FBE

Local database directory = /db2/FBE

Database release level = d.00

Comment =

Directory entry type = Indirect

Catalog database partition number = 0

Alternate server hostname =

Alternate server port number =

db2fbe> db2 list node directory

SQL1027N The node directory cannot be found.

Regrads,

Mnai

[former_member182505]

hi

please check

SQL1027N

The node directory cannot be found.

Explanation

The list node directory command cannot be processed because the node directory could not be found.

The command cannot be processed.

User response

Issue a CATALOG NODE command with the appropriate parameters and resubmit the current command.

Please maintain Separate entries in both systems in db2nodes.cfg. then copy one directory from node a (db2 directory).

Thanks

Sadiq

[Former Member]

Hello,

Are you able to see that all the services have started?

Since this is Development system on AIX i believe you have DB+CI on same system/node.

Try starting the database alone first and see if it starts.

For the error you are getting, execute the following commands and see what is listed.

db2 list database directory

db2 list node directory

Please check what each of the command reports and check if this directory exists or

is mounted and has sufficient permissions.

Make sure you have run the scripts db6_update_db or db6_update_client attached to

SAP Note 1365982.

Read the SAP Note 1332109 - DB6: Upgrade to Version 9.7 of DB2 and check if you have missed anything.

Additionally, check SAP Note 1329179 - DB6: DB2 V9.7 Standard Parameter Settings

Regards,

Sai

[Former Member]

Hi,

Can you check db2nodes.cfg for hostnames and IP address ? Use the service IP address in db2nodes.cfg and check.

Thanks,

Arjun

[Former Member]

Hi All,

Still, I am facing the same problem while starting SAP.Please find trans.log details below.

fbeadm> R3trans -d

This is R3trans version 6.14 (release 700 - 19.01.11 - 11:44:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'FBE'"

R3trans finished (0012).

4 ETW000 [dev trc ,00000] (0.279) DB6: SQL0301N after LONG to LOB conversion (note 1524339) 25 0.008826

4 ETW000 [dev trc ,00000] Supported features: 22 0.008848

4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 35 0.008883

4 ETW000 [dev trc ,00000] ..done 118 0.009001

4 ETW000 [dev trc ,00000] DB2 library successfully loaded DB2 library '/home/fbeadm/sqllib/lib64/libdb2.a(shr_64.o)' successfully loaded

4 ETW000 13885 0.022886

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 25 0.022911

4 ETW000 [dev trc ,00000] Running with CLI runtime client libraries. 6880 0.029791

4 ETW000 [dev trc ,00000] Fri Jan 20 15:35:34 2012 611496 0.641287

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1786] CON = 0 (BEGIN) 104 0.641391

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated

4 ETW000 49 0.641440

4 ETW000 [dev trc ,00000] &+ file system. SQLSTATE=58031

4 ETW000 42 0.641482

4 ETW000 [dev trc ,00000] &+

4 ETW000 41 0.641523

4 ETW000 [dev trc ,00000] &+

4 ETW000 42 0.641565

4 ETW000 [dev trc ,00000] &+

4 ETW000 68 0.641633

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1786] (END) 26 0.641659

4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'FBE' as 'sapfbe' failed 86 0.641745

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'FBE'"

fbeadm>

Regrads,

Mani

[Former Member]

1). Check the permissions of /var/db2/global.reg file. Also, you can try command 'db2iupdt instance_name to update the permission problems. Command should be executed by root user. db2iupdt program should exist in DB2DIR.

2). please verify if /db2/<SID> is accessible by db2sid user or not. Check the permission and owner/group of the directory

3). Can you run below commands: (Please issue as db2<db2sid>)

db2 "list db directory"

db2 "list db directory on <db_path>"

db2 "list node directory"

Can you uncatalog and catalog the DB again.

Then once again an instance update (db2iupdt).

4). Stop DB and restart the server and try again

Thanks,

Arjun

[Former Member]

Hi All,

Thanks for your replies.

I have login db2<sid> user .I am unable to see any file under /db2/db2sid.I able see the list of file under /db2/db2fse as a root user.

Please let me know,How to reslove this issue?

Regrads,

Mani

[Former Member]

Did you try command 'db2iupdt instance_name to update the permission problems ?

[Former Member]

Hi All,

I have executed 'db2iupdt instance_name command succssfully under root user.But still i am unable to see any file under db2<sid> user.I am able to see all the file under root user.

Please help us to reslove this issue.

Regrads,

Mani

[Former Member]

Hello Mani,

Can you provide us the steps taken care so far as part of 9.7 upgrade?

Thanks,

Siva Kumar

[Former Member]

Hi All.

Please find db2diag.log error information below.

DIA3208E Error encountered in TCP/IP protocol support. TCP/IP

function "accept". Socket was "7". Errno was "9".

Regrads,

Mani

[Former Member]

Set the DB2 Registry variable DB2TCPCONNMGRS db2set -i <instancename> DB2TCPCONNMGRS=1

You must then restart the database instance.

Did you Check the note Note 448832 - DB6: DIA3208 Error encountered in TCP/IP protocol support ?

[Former Member]

Hi All,

I have login through db2<sid> user and executed ls -ltr not showed any files in /db2/FBE filesystem.But i have given du -g* .It showing each file size in GB. I have checked permission everything fine.

Please let me know is this problem in AIX filesystem level?

Regrads,

Mani

[Former Member]

Set the DB2 Registry variable DB2TCPCONNMGRS db2set -i <instancename> DB2TCPCONNMGRS=1

You must then restart the database instance.

Did you Check the note Note 448832 - DB6: DIA3208 Error encountered in TCP/IP protocol support ?

Thanks,

Arjun

[former_member189725]

I think setting up the new client connectivity from DB2 runtime client to DB2 CLI driver would help.

Follow this SDN guide to change the setting for DB2 client.

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0e7a584-332b-2b10-0f98-ecbb7405054c]

[Former Member]

Hi All,

Stll showing same error.

59 0.636520

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated

4 ETW000 49 0.636569

4 ETW000 [dev trc ,00000] &+ file system. SQLSTATE=58031

Regrads,

Mani

[Former Member]

Hi All,

It showing sid<adm> instant of db2<sid>.Please help us.

sidadm> db2level

DB21085I Instance "sidadm" uses "64" bits and DB2 code release "SQL09074" with

level identifier "08050107".

Informational tokens are "DB2 v9.7.0.4", "s110330", "IP23236", and Fix Pack

"4".

Product is installed at "/home/fbeadm/sqllib".

Regrads,

Mani

[Former Member]

Hi All,
> 
> It showing sid<adm>  instant of db2<sid>.Please help us.
> 
> sidadm> db2level
> DB21085I  Instance "sidadm" uses "64" bits and DB2 code release "SQL09074" with
> level identifier "08050107".
> Informational tokens are "DB2 v9.7.0.4", "s110330", "IP23236", and Fix Pack
> "4".
> Product is installed at "/home/fbeadm/sqllib".

I think this should be at /db2/db2fbe/db2_software

[Former Member]

Hello Mani,

Have you updated DB instance after upgrade?

Thanks,

Siva Kumar