Local migration from TDS 6.3 to SDS 6.4

Answer

Local migration from TDS 6.3 to SDS 6.4

Scenario:
---------------
1. I have a current TDS 6.3 Instance server:

Name: test4mig
Version: 6.3
Location: /home/test4mig
Description: IBM Tivoli Directory Server Instance V6.3
IP Addresses: All available
Port: 3389
Secure Port: 3636
Admin Server Port: 3544
Admin Server Secure Port: 3545
Type: Directory Server


2. I verify that LDAP 6.3 Instance server is working successfully also
stop/start work successfully.


3. Current DB2 level of the LDAP 6.3 Instance:
# cat /home/test4mig/idsslapd-test4mig/etc/ldapdb.properties
currentDB2InstallPath=/opt/IBM/tdsV6.3db2
currentDB2Version=9.7.0.10


4. Global DB2 level of TDS 6.3
# cat /opt/IBM/ldap/V6.3/etc/ldapdb.properties
currentDB2InstallPath=/opt/IBM/tdsV6.3db2
currentDB2Version=9.7.0.10



*** Then -
1. Install the following on the local machine:
- DB2 V10.5.05 for SDS 6.4
- GSKIT 8.0.50.44
- SDS 6.4 then upgrade to 6.4.0.3


2. Check Global DB2 level of SDS 6.4
# cat /opt/IBM/ldap/V6.4/etc/ldapdb.properties
currentDB2InstallPath=/opt/IBM/sdsV6.4db2
currentDB2Version=10.5.0.5



Perform Local Migration from TDS 6.3 to SDS 6.4 for the instance
------------------------------------------------------------------------------------
** The migration will migrate the LDAP instance:
- From TDS 6.3 to SDS 6.4


1. Create a directory called: ldapsaveconf
# mkdir /home/test4mig/ldapsaveconf


2. Change mode for this directory:
# chmod g+w /home/test4mig/ldapsaveconf


3. Chown for this directory:
# chown test4mig:dbsysadm /home/test4mig/ldapsaveconf


4. Run migbkup of SDS 6.4 as below:
# cd /opt/IBM/ldap/V6.4/sbin
# ./migbkup /home/test4mig/idsslapd-test4mig /home/test4mig/ldapsaveconf
>> Backing up schema and configuration files .....
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.ibm.at .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.ibm.oc .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.system.at .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.system.oc .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.user.at .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.user.oc .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.modifiedschema .
Copying: file /home/test4mig/idsslapd-test4mig/logs/perftune_stat.log .
Copying: file /home/test4mig/idsslapd-test4mig/etc/ibmslapd.conf .
Copying: file /home/test4mig/idsslapd-test4mig/etc/perftune_input.conf .
Copying: file /home/test4mig/idsslapd-test4mig/etc/ibmslapdcfg.ksf .
Copying: file /home/test4mig/idsslapd-test4mig/etc/ibmslapddir.ksf .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.config.at .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.config.oc .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.ldapsyntaxes .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.matchingrules .

** NOTE ** -> 2 new files are created under: /home/test4mig/ldapsaveconf/etc
db2info
platforminfo

# cat db2info
>>
#version of db2 used by backed up server
currentDB2InstallPath=/opt/IBM/tdsV6.3db2
currentDB2Version=9.7.0.10


# cat platforminfo
>>
osName=AIX
processorArch=powerpc


5. Migrate the TDS 6.3 instance:
(idsimigr takes care of all V3 files including V3.modifiedschema) and make sure
to source the db2profile before running idsimigr

# cd /opt/IBM/ldap/V6.4/sbin
# ./idsimigr -I test4mig -n
>> GLPMIG035I Files in backup directory, '/home/test4mig/idsslapd-test4mig', are determined to be of version, '6.3'. Migration will continue based on this migration path.
Backing up schema and configuration files .....
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.ibm.at .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.ibm.oc .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.system.at .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.system.oc .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.user.at .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.user.oc .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.modifiedschema .
Copying: file /home/test4mig/idsslapd-test4mig/logs/perftune_stat.log .
Copying: file /home/test4mig/idsslapd-test4mig/etc/ibmslapd.conf .
Copying: file /home/test4mig/idsslapd-test4mig/etc/perftune_input.conf .
Copying: file /home/test4mig/idsslapd-test4mig/etc/ibmslapdcfg.ksf .
Copying: file /home/test4mig/idsslapd-test4mig/etc/ibmslapddir.ksf .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.config.at .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.config.oc .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.ldapsyntaxes .
Copying: file /home/test4mig/idsslapd-test4mig/etc/V3.matchingrules .
GLPMIG037I The DB2 database instance, 'test4mig', from the backed up configuration file has been found on the system. The information for this database instance will be preserved in the migrated configuration file.
GLPMIG038I The database, 'ldapdb', from the backed up configuration file has been found on the system. The information for this database will be preserved in the migrated configuration file.
GLPWRP123I The program '/opt/IBM/ldap/V6.4/sbin/64/idsicrt' is used with the following arguments 'idsimigr -I test4mig -n'.
You have chosen to perform the following actions:

GLPICR013I The directory server instance's port will be set to '3389'.
GLPICR014I The directory server instance's secure port will be set to '3636'.
GLPICR015I The directory instance's administration server port will be set to '3544'.
GLPICR016I The directory instance's administration server secure port will be set to '3545'.
GLPICR019I The description will be set to: 'IBM Security Directory Server Instance V6.4'.
GLPICR021I Database instance 'test4mig' will be configured.
GLPMIG028I Migrating schema and configuration files from version '6.3' to version '6.3.1'.
GLPMIG018I Successfully migrated the schema files from version '6.3' to version '6.3.1'.
GLPMIG025I Successfully migrated the configuration file from version '6.3' to version '6.3.1'.
GLPMIG028I Migrating schema and configuration files from version '6.3.1' to version '6.4'.
GLPMIG018I Successfully migrated the schema files from version '6.3.1' to version '6.4'.
GLPMIG036W The log file name and path information from the backed up configuration file will not be preserved by migration. Log file names and paths will be updated to be specific for a directory server instance.
GLPMIG025I Successfully migrated the configuration file from version '6.3.1' to version '6.4'.
GLPICR052I Creating DB2 instance link for directory server instance: 'test4mig'.
GLPICR053I Created DB2 instance link for directory server instance: 'test4mig'.
GLPICR133I Setting the DB2 registry for database instance 'test4mig' to allow DB2 SELECTIVITY.
GLPICR134I The DB2 registry for database instance 'test4mig' has been set to allow DB2 SELECTIVITY.
GLPMIG070I Migrating services associated with the directory server instance 'test4mig'.
GLPICR118I Creating runtime executable for directory server instance: 'test4mig'.
GLPICR119I Created runtime executable for directory server instance: 'test4mig'.
GLPMIG071I Successfully migrated the services associated with the directory server instance 'test4mig'.
GLPCTL074I Starting admin server for directory server instance: 'test4mig'.
GLPCTL075I Started admin server for directory server instance: 'test4mig'.
GLPMIG027I Successfully migrated the directory server instance, 'test4mig', to version '6.4'.
GLPDBM054I Directory server install location is '/opt/IBM/ldap/V6.4'.
GLPDBM065I Directory server instance repository file '/opt/IBM/ldap/idsinstinfo/idsinstances.ldif'.
GLPDBM055I Directory instance name is 'test4mig'.
GLPDBM067I Directory instance location is '/home/test4mig'.
GLPDBM061I The directory server instance version check succeeded.
GLPDBM069I Directory instance server configuration file is '/home/test4mig/idsslapd-test4mig/etc/ibmslapd.conf'.
GLPDBM071I Directory instance 'test4mig' is running as a '64' bit application.
GLPDBM057I Found the DB2 instance name 'test4mig' from the directory server instance configuration file.
GLPDBM059I Found the DB2 database name 'ldapdb' from the directory server instance configuration file.
GLPDBM082I Directory instance specific ldapdb.properties file '/home/test4mig/idsslapd-test4mig/etc/ldapdb.properties'.
GLPDBM073I DB2 install location from the ldapdb.properties file is '/opt/IBM/tdsV6.3db2'.
GLPDBM088I DB2 install version from the ldapdb.properties file is '9.7.0.10'.
GLPDBM063I DB2 initial version check succeeded.
GLPDBM052I Found DB2 version V10.5.0.5 in the location specified by the -N option.

GLPDBM020I Starting the pre-migration tasks.
GLPDBM012W The DB2 database manager is already active.
GLPDBM026I The DB2 terminate succeeded.
GLPDBM024I The DB2 force application all succeeded.
GLPDBM017I The DB2 stop database manager command succeeded.
GLPDBM022I Successfully updated the DB2 instance width space to 64 bits.
GLPDBM010I The DB2 start database manager command succeeded.
GLPDBM013I The DB2 list database directory command succeeded.
GLPDBM015I The DB2 connect to database command succeeded.
GLPDBM042I DB2 rebind packages completed successfully.
GLPDBM028I The DB2 update DBM CFG succeeded.
GLPDBM026I The DB2 terminate succeeded.
GLPDBM024I The DB2 force application all succeeded.
GLPDBM017I The DB2 stop database manager command succeeded.
GLPDBM021I Pre-migration tasks completed successfully.

GLPDBM030I Starting the migration task.
GLPDBM032I DB2 instance migration succeeded.
GLPDBM010I The DB2 start database manager command succeeded.
GLPDBM034I DB2 database migration succeeded for database 'ldapdb'.
GLPDBM026I The DB2 terminate succeeded.
GLPDBM024I The DB2 force application all succeeded.
GLPDBM017I The DB2 stop database manager command succeeded.
GLPDBM031I Migration task completed successfully.

GLPDBM040I Starting the post-migration task.
GLPDBM042I DB2 rebind packages completed successfully.
GLPDBM010I The DB2 start database manager command succeeded.
GLPDBM028I The DB2 update DBM CFG succeeded.
GLPDBM013I The DB2 list database directory command succeeded.
GLPDBM015I The DB2 connect to database command succeeded.
GLPDBM026I The DB2 terminate succeeded.
GLPDBM024I The DB2 force application all succeeded.
GLPDBM017I The DB2 stop database manager command succeeded.
GLPDBM079I Update operation for '/home/test4mig/idsslapd-test4mig/etc/ldapdb.properties' file for the directory server instance succeeded.
GLPDBM041I Post-migration task completed successfully.

GLPDBM081I The idsdbmigr tool ran successfully, execution log is '/var/idsldap/V6.4/idsdbmigr.log'.


6. Check if the LDAP instance "test4mig" is successfully migrated:
# /opt/IBM/ldap/V6.4/sbin/idsilist -a

Name: test4mig
Version: 6.4
Location: /home/test4mig
Description: IBM Security Directory Server Instance V6.4
IP Addresses: All available
Port: 3389
Secure Port: 3636
Admin Server Port: 3544
Admin Server Secure Port: 3545
Type: Directory Server

** NOTE **
- All ports are the same as the LDAP 6.3 Instance
- Instance was successfully migrated from TDS 6.3 to SDS 6.4


7. Start ibmslapd for the LDAP Instance:
# cd /opt/IBM/ldap/V6.4/sbin
# ./idsslapd -I test4mig
>> works


8. Verify new SDS 6.4 instance server.
# cd /opt/IBM/ldap/V6.4/bin
# ./idsldapsearch -p 3389 -D cn=root -w secret -b o=ibm,c=us objectclass=*
>> works


9. Now - Check DB2 level of the LDAP Instance:
# cat /home/test4mig/idsslapd-test4mig/etc/ldapdb.properties
currentDB2InstallPath=/opt/IBM/sdsV6.4db2
currentDB2Version=10.5.0.5


10. Check current database for LDAP instance:
# su - test4mig
$ db2 list db directory

System Database Directory
Number of entries in the directory = 2

Database 1 entry:

Database alias = LDAPDB
Database name = LDAPDB
Local database directory = /home/test4mig
Database release level = 10.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = LDAPDB2B
Database name = LDAPDB
Local database directory = /home/test4mig
Database release level = 10.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

$ db2 connect to ldapdb

Database Connection Information

Database server = DB2/AIX64 10.5.5
SQL authorization ID = TEST4MIG
Local database alias = LDAPDB

>> Database was migrated to DB2 V10.5.5


11. Check current ibmslapd.conf of LDAP Instance:
# cd /home/test4mig/idsslapd-test4mig/etc
# cat ibmslapd.conf
>>
# IBM Directory Server Configuration File Version 6.4 for AIX
#
# See the "Configuration Schema" appendix in the
# IBM Directory Server Version 6.4 Installation and
# Configuration for Multiplatforms Guide.
#

charset: ISO-8859-1
version: 1

dn: cn=Configuration
cn: Configuration
ibm-slapdAdminDN: cn=root
ibm-slapdAdminGroupEnabled: true
ibm-slapdAdminPW: {AES256}HBEZGYqYBE4ZUEPyCkf+1Q==
ibm-slapdCryptoSync: s31zJO9CF3sbkI50
ibm-slapdDerefAliases: always
ibm-slapdPort: 30389
ibm-slapdPtaEnabled: false
# ibm-slapdPwEncryption must be one of:
# none/aes128/aes192/aes256/crypt/sha/ssha/md5/
# sha224/sha256/sha384/sha512/ssha224/ssha256/ssha384/ssha512
ibm-slapdPwEncryption: aes256
ibm-slapdServerBackend: RDBM
ibm-slapdServerId: 45082640-cbe7-1034-960f-ad4e2baf0202
ibm-slapdSizeLimit: 500
ibm-slapdStartupTraceEnabled: false
ibm-slapdSupportedWebAdmVersion: 3.0
ibm-slapdTimeLimit: 900
ibm-slapdTraceMessageLevel: 0xFFFF
ibm-slapdTraceMessageLog: /home/test4mig/idsslapd-test4mig/logs/traceibmslapd.log
ibm-slapdVersion: 6.4
:
------------

>> The local migration from TDS 6.3 to SDS 6.4 for the LDAP instance was successfully.