WebSphere Issues


LDAP / TDS commands

Filed under: TDS — Ishtiaque @ 6:47 am

1. Search:

  • All LDAP entries on non-SSL port:

/<ldap_install>/bin/ldapsearch -b dc=ibm,dc=com cn=* (OR cn=Ishtiaque*)

  • All LDAP entries on SSL port:

/<ldap_install>/bin//bin/ldapsearch -Z -K <ldap_install>/etc/key.kdb -P ssl_password -b dc=ibm,dc=com cn=*

Note: LDAP server must be configured on SSL port, while key.kdb and ssl_password are default ldap cert db and it’s password respectively.

  • LDAP server with a bind user :

/<ldap_install>/bin/ldapsearch -b dc=ibm,dc=com -s one objectclass=* -D  “uid=wpsbind,cn=users,dc=ibm,dc=com” -w password

  • Search a particular user:

/<ldap_install>/bin/ldapsearch -b dc=ibm,dc=com -D “cn=root” -w password “cn=myuserid”

4. Delete: a user

/<ldap_install>/bin/idsldapmodify -D cn=root -w passw0rd -f /tmp/deleteUser.ldif

dn: cn=test123,cn=users,o=tst,c=com
changetype: delete

5. Modify: Add a user into a group

/<ldap_install>/bin/idsldapmodify -D cn=root -w passw0rd -f /tmp/modifyUser.ldif

dn: cn=wpsContentAdministrators,cn=groups,o=tst,c=com
changetype: modify
add: uniqueMember
uniqueMember: uid=wpsadmin,cn=users,o=tst,c=com

6. Create: new user:

/<ldap_install>/bin/ldapadd -D cn=root -w passw0rd -f /tmp/addUser.ldif

dn: cn=tst123,cn=users,o=tst,c=com
objectClass: top
objectClass: person
objectClass: organizationalPerson
objectClass: inetOrgPerson
objectClass: ePerson
cn: eservicetestuser
cn: tst123
sn: eservicetestuser
uid: tst123

7. Export all users:

/sbin/idsdb2ldif -I ldapdb2 -o /tmp/all.ldif -W /tmp/output.log

  • Export all users in a specified branch:

/sbin/idsdb2ldif -I ldapdb2 -s o=ibm,c=us -o /tmp/all.ldif

  • Export specified user:

/sbin/idsdb2ldif -I ldapdb2 -s cn=test,o=ibm,c=us -o /tmp/all.ldif

9. Import all users:

/sbin/idsldif2db -I ldapdb2 -i /tmp/all.ldif -W /tmp/output.log

10. Start and Stop commands:

  • Find status of the server:

– /opt/IBM/ldap/V6.3/bin/ibmdirctl -D cn=root -w password status

  • Stop the server:

– /opt/IBM/ldap/V6.3/sbin/ibmslapd -I ldapdb2 -k

– /opt/IBM/ldap/V6.3/bin/ibmdirctl -D cn=root -w password stop

– /opt/IBM/ldap/V6.3/sbin/idsdiradm -k (Admin instance)

  • Start the server:

– /opt/IBM/ldap/V6.3/sbin/ibmslapd -I ldapdb2

– /opt/IBM/ldap/V6.3/bin/ibmdirctl -D cn=root -w password start

– /opt/IBM/ldap/V6.3/sbin/idsdiradm (Admin instance)

11. Enable traces during Startup:

– /opt/IBM/ldap/V6.3/sbin/ldtrc info

– /opt/IBM/ldap/V6.3/sbin/ldtrc on

– ibmslapd -I ldapdb2 -n -h 65535 2>&1 | tee /tmp/slapd_trace.out (start the server in debug mode)

– /opt/IBM/ldap/V6.3/sbin/ldtrc off

12. List instances

-/opt/IBM/ldap/V6.3/sbin/idsilist -a


SQL1041N: The maximum number of concurrent databases have already been started, SQLSTATE=57032

Filed under: DB2 — Ishtiaque @ 7:19 am

Run the following DB2 DBM cfg command to resolve the above issue:

db2 update dbm cfg using NUMDB 12


1. http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.messages.sql.doc/doc/msql01041n.html

2. http://www-01.ibm.com/support/docview.wss?rs=&context=SW000&q1=%2Btechnotes+%2BTransferring+%2BDerby+%2Bto+%2BOracle&q2=-redbooks+-developerworks&uid=swg21313407&loc=en_US&cs=utf-8&cc=us&lang=all


Configure FTP Server in linux

Filed under: Linux — Ishtiaque @ 6:58 am

1. Create a new user and set it’s password by running the following commands:

useradd ftpupload

passwd ftpupload

Note: ftp published directory would be the user home directory. So change the user home directory as appropriate.

3. Edit the file /etc/vsftpd/vsftpd.conf and  add the following line at the end of file:


3. Add the user ftpupload in the file /etc/vsftpd/user_list

4. Optionally you may comment the line anonymous_enable=YES in the vsftpd.conf to deny access for anonymous users.



SQL1117N A connection to or activation of database “sample” cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019

Filed under: DB2 — Ishtiaque @ 10:13 am

I run the following command to resolve the issue:

db2 rollforward db sample to end of logs and complete

Blog at WordPress.com.