ibmslapd does not start up after migration because of an existing table in DB2

Troubleshooting

Problem

After completing migration, and starting up ibmslapd, errors may occur because of errors in DB2.

Symptom

Errors similar to the following will show up in ibmslapd.log at startup after the migration:

11/13/08 19:45:28 GLPRDB001E Error code -1 from function:" SQLExecDirect" CREATE TABLE INSTLDAP.SIMPLIFY_RESIZING_ATTRIBUTES_secDN (EID INTEGER NOT NULL, SECDN VARCHAR(1000) NOT NULL, SECDN_T VARCHAR(240) NOT NULL , RSECDN_T VARCHAR(240) NOT NULL ) .
11/13/08 19:45:28 GLPRDB084E Failed to complete the internal data migration.
11/13/08 19:45:28 GLPSRV064E Failed to initialize be_config.
11/13/08 19:45:28 GLPSRV040E Error encountered. Server starting in configuration only mode.

Diagnosing The Problem

A number of things to complete a migration are done when ibmslapd starts up the first time after the migration. Error conditions in DB2 can cause this to fail. For example, the following errors can occur in the db2cli.log:

SQL0964C The transaction log for the database is full. SQLSTATE=57011 The transaction log for the database is full. SQLSTATE=57011

This can happen if the database is very large. See this technote for resolving issues with transaction log space:

Fixing an "SQL0964C Transaction log for database is full" error

However, if a more drastic error like:

SQL0968C The file system is full. SQLSTATE=57011

shows up in the db2cli.log, more needs to be done to allow ibmslapd to complete the migration, and may require the involvement of a DB2 DBA or DB2 Support..

Resolving The Problem

To resolve this, do the following:

1) Do a database backup, or export the existing SIMPLIFY_RESIZING_ATTRIBUTES_SECDN data to a file:

db2 export to resize-secdn.ixf of IXF "select * from SIMPLIFY_RESIZING_ATTRIBUTES_SECDN"

This is just a precaution to preserve the current state of the database

2) Drop the SIMPLIFY_RESIZING_ATTRIBUTES_SECDN table

3) Increase transaction log file size if necessary

4) Restart ibmslapd, so it can continue to complete the internal database migration.

[{"Product":{"code":"SSVJJU","label":"IBM Security Directory Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.0;6.1;6.2;6.3;6.3.1;6.4;8.0;8.0.1","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Historical Number

36588;033;000

Product Synonym

ITDS;TDS;Secureway;IDS;LDAP;Secureway Directory Server;Directory Server;SWD

Was this topic helpful?

Document Information

Modified date:
16 June 2018

UID

swg21375531

Tips