Category Archives: DB2

Take DB2 offline backup when it’s part of DB2 HADR

DB2 SQL -1035 Error (SQL1035N) database is currently in use Submitted by Vikram Khatri on Fri, 2007-08-31 01:36. Did you get this DB2 SQL1035N error if you were trying to take offline backup? The error is obvious as someone is … Continue reading

Posted in DB2 | Leave a comment

DB2 usefull commands

Purpose Command Start and Stop DB2 server db2start and db2stop (db2stop force) Restart a database db2 restart db sample Start and Stop HADR for a db as primary db2 deactivate db sample db2 start hadr on db sample as primary … Continue reading

Posted in DB2, Linux | 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

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

SQL5043N Support for one or more communications protocols failed to start successfully

After configuring Tivoli Directory Server databases some time we get following exception in: /home/idsinst/sqllib/db2dump/db2diag.log /home/idsinst/sqllib/log/db2start.log SQL5043N  Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully. 1. In order to resolve the … Continue reading

Posted in DB2, Linux, TDS | Leave a comment

Install and configure PostgreSQL database

1. Run the installation file ./postgresql-8.4.4-1-linux.bin –mode text 2.Accept default values for installation / data directory and port number. While for Options type “176” i.e En_GB_utf8. 3. Type “y” for pl/pgsql template db. 4. After installation is completed, then edit … Continue reading

Posted in DB2, Linux | Leave a comment

SQL1015N: The database is inconsistent state SQLSTATE=55025

When you start the HADR database after power failure or abnormal termination of the database instance at primary node you might get the following error: SQL1015N: The database is inconsistent state SQLSTATE=55025 1. Make sure HADR is started on standby … Continue reading

Posted in DB2, Linux, WebSphere Portal | Leave a comment