SBL-DBC-00103: The DB2 database cannot be accessed.Maybe the server is down or the database that the server uses is incorrect or defective.

Applies to:

Siebel System Software - Version: 7.5.3 [16157] and later   [Release: V7 and later ]
IBM AIX on POWER Systems (64-bit)

Product Release: V7 (Enterprise)

Version: 7.5.3 [16157] NLD Fin Svcs

Database: IBM DB2/UDB 7.2

Application Server OS: IBM AIX 5L 5.1

Database Server OS: IBM AIX 5L 5.1



This document was previously published as Siebel SR 38-1309804437.

Symptoms

Customer reported the following:

We experience thin client login problems on one of the servers. Siebel has been reinstalled as well as the eapps and the IHS server. An attempt to login still fails with the following error:



GenericLog      GenericLog      0       2004-05-24 18:03:53      ERROR   1800: [SWSE] Could not get an anon session...



GenericLog      GenericLog      0       2004-05-24 18:03:53      DEBUG   1800: [SWSE] Ending critical region   [ /fins_nld/anonSessionLock ] 0x30404978.



GenericLog      GenericLog      0       2004-05-24 18:03:53      ERROR   1800: [SWSE] Set Error Response (User: Session: Error: 00028356 Message: The DB2 database cannot be opened. Maybe the server is shutydownor the database has errors.Speak to your system administrator.(SBL-DBC-00103))



GenericLog      GenericLog      0       2004-05-24 18:03:53      ERROR   1800: [SWSE] [IBM][CLI Driver][DB2] SQL0102N The string constant beginning with "$(CurrentSQLID)" is too long. SQLSTATE=54002

Cause

DSCurrentSQLID set to $(CurrentSQLID)

Solution

For the benefit of other users:



The named subsystem ServerDataSrc had the parameter DSCurrentSQLID set to $(CurrentSQLID). Once this was changed to SSEROLE the problem was solved