I have both domino and db2 up and running, no errors reported. Server is enabled for DB2 and the domino database was successfully created.
The trouble starts with DB2 access.
I get SQL0443N Routine “DOMINO.UDFADMIN” (specific name “SQL090507235837802”) has returned an error SQLSTATE with diagnostic text “Error 258 : NotesInit failed.”
Test DB2 Access from domino administrator reports one error: DB2 Access admin returned error.
I’ve double checked OS accounts, access server.id and installation paths. DB2 Access Server (das/ads) is specified in Trusted Servers.
I was not able to find any documentation regarding SQLSTATE=04096, or Error 258.
I also tried DB2 Express-C - same results.
Could this be a DB2 server version problem (I am going to try 9.1 fp5) ?
db2diag.log does report only one warning
STMM Sort Memory Tuning cannot be activated because the Database Manager Configuration Parameter SHEAPTHRES is not set to 0.
but I’ve tried that.
Console log form server startup:
2009/05/08 01:17:16 Recovery Manager: Restart Recovery complete. (0/0 databases needed full/partial recovery)
2009/05/08 01:17:21 The map for DB2 errors was successfully created.
–CLI ERROR--------------
2009/05/08 01:17:22 A DB2 Access Error occurred. Server log will contain more information.: 04096 - [IBM][CLI Driver][DB2/LINUX] SQL0443N R
outine “DOMINO.UDFADMIN” (specific name “SQL090507235837802”) has returned an error SQLSTATE with diagnostic text “Error 258 : NotesInit failed.”. SQLSTATE=0
4096 - *LOCAL.db2inst1.090507231723(server)
2009/05/08 01:17:22 DB2NSFInit Error Checking/Updating UDF Version.: DB2 Access admin returned error.
–CLI ERROR--------------
2009/05/08 01:17:22 A DB2 Access Error occurred. Server log will contain more information.: 04096 - [IBM][CLI Driver][DB2/LINUX] SQL0443N R
outine “DOMINO.UDFADMIN” (specific name “SQL090507235837802”) has returned an error SQLSTATE with diagnostic text “Error 258 : NotesInit failed.”. SQLSTATE=0
4096 - *LOCAL.db2inst1.090507231723(server)
–CLI ERROR--------------
2009/05/08 01:17:22 A DB2 Access Error occurred. Server log will contain more information.: 04096 - [IBM][CLI Driver][DB2/LINUX] SQL0443N R
outine “DOMINO.UDFADMIN” (specific name “SQL090507235837802”) has returned an error SQLSTATE with diagnostic text “Error 258 : NotesInit failed.”. SQLSTATE=0
4096 - *LOCAL.db2inst1.090507231729(server)
db2 info:
DB2 Server: Enabled
DB2 Server: Connected
DB2 Server Name: Local
DB2 Port Number:
DB2 Version: v9.5.0
DB2 Directory:
DB2 Instance: db2inst1
DB2 Database: domino
Default Datastore: NSF
Connections: 4
MAX NSFs per Group: 10
DB2 Compression Threshold: 983,040
Schema Version: 18
DB2 Access: Enabled
DB2 Access Server: das/ads
DB2 Access Path: /home/db2inst1/sqllib/function
DB2 Access Server Version: n/a
DB2 Access Server Build: un
DB2 Access Server User: un
Enable Default Query View User: Not Enabled
Default Query View User Name:
2009/05/08 12:42:51 A DB2 Access Error occurred. Server log will contain more information.: 04096 - [IBM][CLI Driver][DB2/LINUX] SQL0443N Routine “DOMINO.UDFADMIN” (specific name “SQL090507235837802”) has returned an error SQLSTATE with diagnostic text “Error 258 : NotesInit failed.”. SQLSTATE=04096 - *LOCAL.db2inst1.090507231731(server)
2009/05/08 12:42:51 domino/ads A DB2 Access Error occurred. Server log will contain more information.: 04096 - [IBM][CLI Driver][DB2/LINUX] SQL0443N Routine “DOMINO.UDFADMIN” (specific name “SQL090507235837802”) has returned an error SQLSTATE with diagnostic text “Error 258 : NotesInit failed.”. SQLSTATE=04096 - *LOCAL.db2inst1.090507231723(server)
and, in case i’ts needed, console log after DB2 enablement:
Lotus Domino (r) Server, Release 8.5, December 05, 2008
Copyright (c) IBM Corporation 1987, 2008. All Rights Reserved.
Restart Analysis (0 MB): 100%
2009/05/07 23:38:32 Recovery Manager: Restart Recovery complete. (0/0 databases needed full/partial recovery)
2009/05/07 23:38:32 Attaching to DB2 Instance ‘db2inst1’ with username ‘notes’…
2009/05/07 23:38:32 Creating DB2 database ‘domino’ in DB2 Instance ‘db2inst1’ with username ‘notes’…
2009/05/07 23:38:51 DB2 database domino successfully created with codepage/territory (UTF-8/US).
2009/05/07 23:38:52 Warning: Modifying DB2 database manager configuration parameters for optimization…
2009/05/07 23:38:52 Updating DB2 database configuration parameters for optimization…
2009/05/07 23:39:16 The map for DB2 errors was successfully created.
2009/05/07 23:39:17 Event Monitor started