Monthly Archives: October 2010

LDAP / TDS commands

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 … Continue reading

Posted in TDS | Leave a comment

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

Run the following DB2 DBM cfg command to resolve the above issue: db2 update dbm cfg using NUMDB 12 REFERENCES: 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

Posted in DB2 | Leave a comment

Configure FTP Server in linux

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 … Continue reading

Posted in Linux | Leave a comment

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

I run the following command to resolve the issue: db2 rollforward db sample to end of logs and complete

Posted in DB2 | Leave a comment