Uptime of DB2 LUW

How can you find the uptime of DB2 LUW ? Checking the uptime for DB2 LUW is achieved through the command line processor (CLP).Issue this command through the CLP. I normally use Putty as a client to access the CLP db2pd - --sample output Database Partition 0 -- Active -- Up 27 days 18:27:05 --For partitioned DB2 instances db2pd –alldbpartitionnums --For partitioned DB2 instances over a number of physical machines db2_all ‘db2pd –‘ Read Also on Windows Server and snapshot monitor Windows Server Uptime and Net Statistics Server - DBA DB2 DB2 event monitor and snapshot monitor - DBA DB2... Read more →

How to list UDF in DB2

UDF in DB2 . How can I view details on user defined functions? To view user defined functions - UDF in DB2– use the SYSCAT.ROUTINES catalog view to return a full list of user defined functions including – scalar function , table function, sourced function, method and procedure. The example query returns Functions (routinetype = ‘F’ ) and User Defined\SQL Bodied (origin in ('U', 'Q') select r.routinename as FunctionName, r.text as FunctionBody from syscat.routines r where r.routinetype = 'F' and r.origin in ('U', 'Q') Read More DB2 list schemas of a database DB2 SET CURRENT SCHEMA - DBA DB2 ADMIN_DROP_SCHEMA... Read more →

List DB2 table columns and unique constraints

How can I list the DB2 table columns and unique constraints? To list DB2 table columns and constraints use one of these methods – using syscat.columns , describe or db2look --Method 1 – query syscat.columns select colname from syscat.columns where tabname='ADDRESS' --Method 2 – use the describe command describe table dbo.address --Method 3 –use db2look db2look -e –d dbname –t tablename Read More DB2 - Collecting data for database performance problems - DBA DB2 DB2 – COPY a table - DBA DB2 DB2 Tuning Toolkit – DB2 Design advisor - Ddb2advis - DBA DB2 Read more →

Backup Retention Policy

Creating a backup and restore policy based on service level agreements, Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) is a critical part of DBA work. Another long-term but important Backup and Restore component is devising a Backup Retention Policy. A Backup Retention Policy is defined as a set of rules outlining the steps of how long to retain a backup and the process of purging. The broad categories influencing the Backup Retention Policy are based on : Legal\Compliance, Recovery Points and Cost. As a first step identify a list of use cases within the organization. It is important... Read more →