Monitor DB2 instance status and database status

Platform : Shell script & DB2 v9.1 , 9.5 , Linux A simple shell script that returns: database status instance status last backup The column headers are created :Server,Instance,Database,DB_Status,Lats_backup,instance_status The next line establishes a process exists for that instance , you may need to consider what value you use for $User on that line. That's what I'm using as the input for the instance name .If the process exists the instance is available The script iterates through all databases in a DB2 instance .A connect is created to derive value for last backup , then disconnect. The database status is... Read more →

TSM backup client configuration for DB2 on Linux

1. A functioning TSM client and server must be installed and configured. In addition, the TSM client API must be installed on each DB2® server. 2. Set the environment variables used by the TSM client API: DSMI_DIR Identifies the user-defined directory path where the API trusted agent file (dsmtca) is located. DSMI_CONFIG Identifies the user-defined directory path to the dsm.opt file, which contains the TSM user options. Unlike the other two variables, this variable should contain a fully qualified path and file name. DSMI_LOG Identifies the user-defined directory path where the error log (dsierror.log) will be created. Note: In a... Read more →

db2diag.log file delete on Linux and DB2

I've been running this code via a cron job on Linux, which handles removing db2diag files , up to 3 days old. db2diag -A find db2_instance_home/db2dump -mtime +3 -exec rm -f {} \; On some servers there is a requirement to archive the db2diag file , which I add a "cp" command prior to the above Read more →

No memory available in Application Heap

The plaform used in the diagnosis for the No memory available in Application Heap Red Hat Linux 4.6 DB2 9.1.04 ESE 32 bit Websphere Business Monitor The problem was identified as users attempted to log on to business space. The logon was successfull but no widgets were returning. The following error message was extracted from the db2diag.log of the DB2 server instance 2010-05-06-13.18.38.713664+060 I19708680G531 LEVEL: Error PID : 26600 TID : 3085903552 PROC : db2agent (MYDB) 0 INSTANCE: db2myInstance NODE : 000 DB : MYDB APPHDL : 0-273 APPID: 10.110.221.80.6330.100506030314 AUTHID : db2myInstance FUNCTION: DB2 UDB, access plan manager, sqlra_load_var,... Read more →

Euro symbol and DB2 database codeset

This problem of Euro symbol was diagnosed on this platform: Red Hat Linux 4.6 DB2 V9.5.0.0 Database Database territory = US Database code page = 1208 Database code set = UTF-8 A developer outlined a problem where: When euro symbol was inserted - it converts as 3 characters . Therefore if a varchar(50) column is defined , and a euro exists , it will attempt to store 52 characters .and throws a TRUNCATE error The Problem was confirmed via creating a test table in MYDB called "mytesttable". Note: Database code set = UTF-8 Executed an INSERT statement : INSERT INTO... Read more →