DB2 -SQL1036C An I/O error occurred while accessing the database SQLSTATE=58030

I received the following error , when attempting to connect to a DB2 database db2 connect to MYDB SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030 #Checked in the db2diag.log file ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found." DIA8411C A file "" could not be found. Log file S0000478.LOG not found. Notes to solution 1) Verify if a log file is missing. Check the db2diag.log for the a related logging error (return code contains SQLO_FNEX). 2) If present, this error will contain the name of the missing log file. Take steps to locate the file in the active log path directory.... Read more →

How to Run script on Linux start with rc.local

A quick method to use for executing a script on Linux start. After all the other processes are started by the init command at boot time, the script is run on Red Hat based systems: /etc/rc.d/rc.local Add any extra script\commands references to this file. See Also db2start at start up on Linux Read more →

DB2 NEWLOGPATH

By default , when creating a new DB2 database , the Log path is on the same drive as the data files. To change the log path , configure the NEWLOGPATH database parameter db2 update db cfg for MYDB using NEWLOGPATH /newpath/ See Also OLTP performance checklist Read more →

DB2 - Uninstalling IBM Tivoli Monitoring for Databases

In large Tivoli environments – System Adminstrators prefer to manage the installation of the Monitoring Agents As a DBA you may need to exclude the ITMA from the DB2 server installation. Methods are: 1) To prevent the DB2 installer from installing ITMA in a response file installation, set INSTALL_ITMA to NO. 2) To uninstall: On Linux and UNIX operating systems: You can uninstall ITMA for DB2 by issuing the following command: DB2DIR/itma/bin/uninstall.sh REMOVE EVERYTHING DB2DIR represents the location where the DB2 copy of ITMA is installed. See Also Monitor DB2 instance status and database status Read more →

DB2 instance startup time

Q. How do I calculate the DB2 instance startup time ? I want to see the DB2 instance start time A. Use the dbm snapshot functionality. db2 get snapshot for dbm |grep Start Read More about the DB2 manager status DB2 manager status and get snapshot for dbm Read more →