Db2

HCL Domino Domino Forum
1

I followed the instruction here diligently for setting DB2

Setting up NSFDB2, Domino 8.0 using DB2 Enterprise Server 9.1 as the datastore

Reference #: 7010958

However, I encountered this error :-

06/29/2008 02:56:25 PM Attaching to DB2 Instance ‘DB2’ with username ‘DominoDB2User’…

06/29/2008 02:56:26 PM Creating DB2 database ‘DOMINO’ in DB2 Instance ‘DB2’ with username ‘DominoDB2User’…

06/29/2008 02:56:26 PM DB2NSFInit Error creating DB2 database DOMINO sqlcode=-1092.: Failed creating DB2 Database.

06/29/2008 02:56:26 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: Failed creating DB2 Database.

06/29/2008 02:56:27 PM A RM error occurred.: An error occurred accessing the db2 datasource.

06/29/2008 02:56:27 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

06/29/2008 02:56:27 PM Event Monitor started

06/29/2008 02:56:27 PM Warning: All Domino Domain Monitoring probes are disabled resulting in the loss of valuable diagnostic information. Please configure DDM probes in events4.nsf. Assess DDM reports in ddm.nsf.

I re-installed it again and again but the error re-appear again. Did I do something wrongly. Pls help.

2

Subject: Response

This error can occur when the Domino server is started after configuring it for DB2 for the first time.This occurs because Domino is trying to create the DB2 database under the authority of the account that started the Domino server. It should be creating the database under the authority of the DB2 account specified when enabling the server for DB2. This has been reported to quality engineering via SPR: JRED76ALP9

Workarounds currently are:

  1. Add your OS account to the DB2 group that has SYSADM access to the DB2 server, and start Domino as an Application. This will create the DB2 database with the authority of your OS account.

  2. Set the parameter catalog_noauth to YES on the DB2 server. You can do so by typing this command at the DB2 CLP: update dbm cfg using CATALOG_NOAUTH YES

3

Subject: Response

Thanks. I follow your step and this is the output log. Pls help.

02/08/2008 04:34:58 PM Attaching to DB2 Instance ‘DB2’ with username ‘DominoDB2User’…

02/08/2008 04:34:58 PM Creating DB2 database ‘DOMINO’ in DB2 Instance ‘DB2’ with username ‘DominoDB2User’…

02/08/2008 04:34:58 PM DB2NSFInit Error creating DB2 database DOMINO sqlcode=-1092.: Failed creating DB2 Database.

02/08/2008 04:34:58 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: Failed creating DB2 Database.

02/08/2008 04:34:59 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:34:59 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:34:59 PM Event Monitor started

02/08/2008 04:34:59 PM Warning: All Domino Domain Monitoring probes are disabled resulting in the loss of valuable diagnostic information. Please configure DDM probes in events4.nsf. Assess DDM reports in ddm.nsf.

02/08/2008 04:34:59 PM Lotus Domino (r) Server started, running Release 8.0.1

02/08/2008 04:34:59 PM Server started on physical node DELL

02/08/2008 04:34:59 PM The Console file is D:\IBM\Lotus\Domino\data\IBM_TECHNICAL_SUPPORT\console.log

02/08/2008 04:34:59 PM Console Logging is ENABLED

02/08/2008 04:35:00 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:00 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:00 PM 0 duplicate PUIDs found while initializing Domino Domain Monitoring

02/08/2008 04:35:00 PM Database Replicator started

02/08/2008 04:35:00 PM Replicator is set to Ignore Database Quotas

02/08/2008 04:35:00 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:00 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:00 PM Database Server started

02/08/2008 04:35:00 PM Calendar Connector started

02/08/2008 04:35:00 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:00 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:00 PM LDAP Server: Starting…

02/08/2008 04:35:00 PM LDAP Server: Serving directory names.nsf in the myorg.com.sg Internet domain

02/08/2008 04:35:00 PM LDAP Schema: Started loading…

02/08/2008 04:35:01 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM Schedule Manager started

02/08/2008 04:35:01 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM SchedMgr: Informational: Schedule Manager is responsible for the busytime database on this server.

02/08/2008 04:35:01 PM Mail Router started for domain DOMAINX

02/08/2008 04:35:01 PM Router: Internet SMTP host dell in domain myorg.com.sg

02/08/2008 04:35:01 PM SchedMgr: Validating schedule database

02/08/2008 04:35:01 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM Agent Manager started

02/08/2008 04:35:01 PM SchedMgr: Done validating schedule database

02/08/2008 04:35:01 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM Rooms and Resources Manager started

02/08/2008 04:35:01 PM RnRMgr: Informational: Schedule Manager is responsible for the busytime database on this server.

02/08/2008 04:35:01 PM RnRMgr: Validating schedule database

02/08/2008 04:35:01 PM RnRMgr: Done validating schedule database

02/08/2008 04:35:01 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM Index update process started

02/08/2008 04:35:01 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM A RM error occurred.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM Unable to initialize DB2 services. DB2-based NSF databases will be unusable.: An error occurred accessing the db2 datasource.

02/08/2008 04:35:01 PM LDAP Schema: Finished loading

4

Subject: Response

Please follow these steps:

  1. Shut down Domino

  2. Change the Domino service to disabled.

  3. Add your administrator account (whatever account you are currently logged into Windows as on the server) to your DB2DOM group (or whatever you called it).

  4. Launch the Domino Server, this should create the DB2 database without error.

  5. After Domino has completely loaded, shut down Domino.

  6. Change the Domino service to automatic.

  7. Launch Domino.