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.
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