dba-db2.com

Full list of articles posted


January 19, 2017 Restore a DB2 LUW database without a DB2 backup copy from filesystem backup

January 05, 2017 Methods to find TSAMP error details and return codes

January 02, 2017 Database Self-Tuning

December 28, 2016 Top 10 visited pages on dba-db2.com for 2016

November 12, 2016 Notes on DB2 LUW archive log and BACKUP command

October 17, 2016 How TO troubleshoot ADM8010E Backup was unable to copy requested log file

September 21, 2016 HOW TO clear inactive DB2 LUW transaction log files

August 30, 2016 Troubleshoot Long running sql statements with LONG_RUNNING_SQL view

August 26, 2016 How to write a DB2 loop with INSERT

August 17, 2016 How to set up Avamar and DB2 backup object retention

July 13, 2016 ADM5530W - NOT LOGGED INITIALLY

June 07, 2016 How to create a copy of a DB2 database table

May 23, 2016 How to put TSAMP into maintenance mode

May 16, 2016 The case of the missing numeric ip format in TSM TCPCLIENTADDRESS

May 04, 2016 The great Windows or Linux debate for DB2 LUW

April 28, 2016 How to redirect zip to another folder

March 29, 2016 DB2 fix : SQL0575N View or materialized query table cannot be used because it has been marked inoperative

March 16, 2016 How to reconfigure DB2 after a Windows Hostname change

March 15, 2016 Avamar avtar command option cheat sheet

March 10, 2016 DB2 fix - SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.

February 25, 2016 SQL0670N - The row length of the table exceeded a limit of "32677" bytes

February 22, 2016 Real world experience is the DBA king

February 17, 2016 How to add Virtual IP address to existing Tivoli Storage Automation via db2haicu

February 13, 2016 10 most popular posts for dba-db2.com for 2015

February 04, 2016 How to view harvested user defined storage resources for TSAMP

February 03, 2016 How to remove a TSA peer domain

January 29, 2016 How to customise TSAMP start and stop scripts to make monitoring agents cluster aware

January 21, 2016 TSAMP maintenance and diagnostics

January 20, 2016 How to backup the TSA SAMP policy details

January 19, 2016 DB2 fix : ADM4500W A package cache overflow condition has occurred.

December 30, 2015 TSAMP Cheat Sheet for DBA managing DB2 clustering

December 11, 2015 Extract DB2 create database ddl using db2look and -createdb switch

November 12, 2015 DB2 move fenced user home directory

November 02, 2015 How to find the DB2 installation path using db2ls

October 07, 2015 How to change the DB2 Version from ESE to WSE

September 24, 2015 SQL0286N A table space could not be found with a page size of at least 32768

September 18, 2015 ADM11001E DB2 did not create a memory segment for running fenced routines

September 02, 2015 How to grant privileges for a windows username on a new schema

July 06, 2015 DIA8400C A bad page was encountered

June 19, 2015 Will Leap Second crash DB2?

May 18, 2015 How to monitor table reorgs with db2pd -reorgs

May 01, 2015 How to use DB2 COUNT_BIG

April 23, 2015 Delete first 1000 rows in a DB2 table using FETCH FIRST

April 19, 2015 SQL30082N – ROOT CAPABILITY REQUIRED

April 18, 2015 Application first database second

April 08, 2015 How to protect DB2 against External Attack

March 14, 2015 How to read db2detaileventlock event monitor trace file

February 01, 2015 db2pd troubleshooting guide

January 31, 2015 How to get the DB2 server instance owner

January 30, 2015 How Get IP Address of connections to DB2 server

January 19, 2015 DB2 Security Policy

January 17, 2015 Check DB2 instance status

January 15, 2015 How to get the DB2 database connection count

December 31, 2014 Top 10 most active posts for DBA-DB2.com in 2015

December 30, 2014 Linux swap space and DB2

November 04, 2014 Db2adutl – delete FULL backups older than X days

September 28, 2014 How to prepare a Database audit

September 27, 2014 Shellshock resources

September 19, 2014 How to check reclaimable space enabled on DB2 tablespace with MON_GET_TABLESPACE

September 12, 2014 Best of DBA-DB2 com

September 11, 2014 How to generate db2support files

September 08, 2014 How to display DB2 db2diag.log appended records using follow parameter

August 03, 2014 How to redirect a REORG to another drive

July 30, 2014 How to terminate a DB2 backup

July 22, 2014 How to get the DB2 database free space?

June 13, 2014 How to check DB2 SYSADM or SYSCTRL authorization for a user with AUTH_LIST_AUTHORITIES_FOR_AUTHID

June 02, 2014 How To get the column definitions of the DB2 Monitor table functions

May 24, 2014 DB2 How To get View definition

May 07, 2014 How to Troubleshoot - SQL1226N due to many db2agent processes attached to the instance

April 02, 2014 Current_timestamp minus days

March 13, 2014 ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225".

March 05, 2014 Dropping all tables from a DB2 schema

February 14, 2014 DB2 read-only clause and performance

January 30, 2014 Cron schedule for the first Sunday of every month

December 31, 2013 Top 5 DB2 posts for 2013

November 14, 2013 Last time DB2 REORG was executed

November 01, 2013 Out of Office Message for DBA

October 14, 2013 Linux top greater than 100 percent - CPU

September 26, 2013 DB2 TOOLS CATALOG – Is it required?

August 20, 2013 Manage DB2 backups retention policy

August 13, 2013 SQL2025N An IO error -50 occurred on media TSM

July 27, 2013 Compare DDL of 2 databases in DB2

July 18, 2013 How to find the db2 database create date

July 16, 2013 DB2 database hangs on db2 connect - use db2pd to troubleshoot

July 15, 2013 Useradd in Linux - Not copying any file from skel directory into it

June 28, 2013 Move DB2 schema objects to another schema using ADMIN_COPY_SCHEMA

June 21, 2013 Changing DB2 database pagesize

June 11, 2013 ADM5500W DB2 is performing lock escalation

May 28, 2013 Uptime of DB2 LUW

May 20, 2013 How to list UDF in DB2

May 18, 2013 List DB2 table columns and unique constraints

May 03, 2013 Backup Retention Policy

April 19, 2013 SQL Parser

April 16, 2013 SQL1042C An unexpected system error occurred. SQLSTATE=58004

April 10, 2013 Commands to check for read only Linux file system

April 09, 2013 Deciding to reorg DB2 tables with overflow value

March 30, 2013 DIA3208E Error encountered in TCP/IP protocol support

March 29, 2013 Reduce the size of the DB2 LRG file

March 28, 2013 DB2 Total Sorts - overflows – improve performance

March 26, 2013 SQL20169W The buffer pool is not started

March 23, 2013 DB2 block all connections to a database - svcename

February 21, 2013 Maximum connections allowed on a DB2 database - MAXAPPLS and MAX_COORDAGENTS

February 01, 2013 Db2 reduce tablespace with ALTER TABLESPACE REDUCE

January 14, 2013 DB2 – How to check if autoresize is enabled

November 30, 2012 DB2 - Collecting data for database performance problems

October 17, 2012 DB2 - SQL1035N The database is currently in use

October 16, 2012 DB2 – Redirect Restore

October 09, 2012 DB2 – How to manage backup failures

October 06, 2012 DB2 – DBA Scripts

September 27, 2012 SQL2161N A damaged recovery history file could not be fixed.

September 17, 2012 DB2 - SQL1762N Unable to connect to database because there is not enough

August 27, 2012 DB2 - Drop the DB2DETAILDEADLOCK event monitor

August 25, 2012 DB2 – How to pscp from the command line

August 18, 2012 Copyright-Disclaimer

August 01, 2012 DB2 – Backup history

July 17, 2012 DB2 - SQL2428N The BACKUP did not complete because one or more of the requested log files could not be retrieved.

July 13, 2012 DB2 – Audit Failed logons

July 10, 2012 DB2 – 10 Top Skills for Architects

July 06, 2012 Faster DB2 on Twitter

June 27, 2012 The Backup failed

June 25, 2012 How to monitor a DB2 REORG

June 22, 2012 DB2 LUW TRUNCATE TABLE

June 20, 2012 How to fix DIA8052C the Event Monitor has reached its file capacity

June 19, 2012 DB2 Tuning Toolkit – db2exfmt

June 18, 2012 Database will come up with hidden buffer pools

June 15, 2012 DB2 Tuning Toolkit – DB2 Design advisor - Ddb2advis

June 14, 2012 DB2 Query Tuning – db2expln

June 13, 2012 How to monitor a deadlock in DB2

June 11, 2012 DBA Ignorance , complacency and arrogance experiment

June 09, 2012 SQL1427N An instance attachment does not exist

June 07, 2012 Database Tuning for complex sql queries

June 01, 2012 ADM1847W Failed to retrieve log file

May 30, 2012 How to check for DB2 Direct IO and FILE SYSTEM CACHING

May 09, 2012 How to use Db2adutl delete logs

May 04, 2012 Running a Java Program from Command Prompt

May 01, 2012 SQL0911N Reason Code 68 The current transaction has been rolled back because of a deadlock or timeout

April 26, 2012 SQLUV_IO_ERROR 25 IO error encountered

April 24, 2012 Troubleshooting DB2 Return Codes, failed to archive log and SQLUV_INIT_FAILED

April 23, 2012 Failed to archive log file and db2 online backup

April 20, 2012 DB2 LOGINDEXBUILD

April 12, 2012 SQL2563W The restore process has completed successfully

April 04, 2012 DB2 and vSphere 4 limit of 8 vCPU

April 02, 2012 DB2 – Managing Diagnostic Logs

March 29, 2012 How to uninstall DB2

March 28, 2012 nmon - tuning and benchmark tool

March 26, 2012 Linux multipath command

March 23, 2012 Troubleshooting SQL2219N and reason code 9

March 20, 2012 Troubleshooting ADM13001E IBMOSauthclient and db2secGetDefaultLoginContext

March 05, 2012 DB2 – check backup command and contents of a database

February 27, 2012 DB2 SORTHEAP and pinned pages

February 19, 2012 DB2 Incremental Restore

February 18, 2012 DB2 - Real time monitoring of DB2 backup and restore

February 13, 2012 DB2 – verify DB2 is available

February 01, 2012 DB2 – error messages

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

January 27, 2012 DB2 – Run script on Linux start

January 26, 2012 DB2 NEWLOGPATH

January 25, 2012 DB2 - Uninstalling IBM Tivoli Monitoring for Databases

January 23, 2012 DB2 instance startup time

January 20, 2012 DB2 – GET DATABASE MANAGER CONFIGURATION

January 19, 2012 DB2 – COPY a table

January 17, 2012 ADM4000W and catalogcache_sz

January 13, 2012 DB2 SET CURRENT SCHEMA

January 13, 2012 DB2 SET CURRENT SCHEMA

January 12, 2012 SQL1279W Some indexes may not have been recreated

January 10, 2012 DB2 security audit

January 09, 2012 DB2 – db2sysc and instance status

January 07, 2012 DB2 – Restore database from a ONLINE backup

January 06, 2012 DB2 and Linux IO testing tools

January 05, 2012 DB2 9.5 installation notes

January 04, 2012 Database Tuning overview – Access Path Tuning

January 03, 2012 Websphere Portal and DB2 tuning

January 01, 2012 Querying Bufferpools DB2

January 01, 2012 DBA – Become a better DB2 DBA

December 26, 2011 Top 10 DB2 Posts for 2011

December 19, 2011 DB2 Tuning Tables

December 12, 2011 DB2 MAXFILOP

December 08, 2011 DB2 DB2_RR_TO_RS environment variable

December 03, 2011 DB2 SQL2033N and TSM reason code 106

November 30, 2011 DB2 Database code set

November 24, 2011 TADDM and DB2 discovery

November 23, 2011 Linux Server OS information

November 16, 2011 DBA secrets to stress reduction

November 14, 2011 Analyzing a DB2 trap file

November 12, 2011 DIAGLEVEL db2

November 10, 2011 How to set dbm cfg to empty value

November 07, 2011 Storage Monitoring : a quick guide

October 22, 2011 User Devices and Database Servers

October 12, 2011 DB2 health script

October 08, 2011 Plink and DB2

September 26, 2011 Iometer and Linux

September 24, 2011 How to report a DB2 performance problem

September 23, 2011 Display Linux CPU information

September 21, 2011 My company owns no IT assets

September 19, 2011 POC

September 15, 2011 DBA personality Traits

September 10, 2011 Database Tuning overview –Storage Tuning

September 03, 2011 DB2 process model

August 23, 2011 DB2 HADR and HADR_PEER_WINDOW settings

August 19, 2011 Data centre management for database servers

August 16, 2011 10x DBA

August 15, 2011 DB2 event monitor and snapshot monitor

August 12, 2011 DB2 instance won't start and db2 fault monitor

August 11, 2011 Database Tuning overview – Buffer Tuning

August 09, 2011 Catalog the database and rename database

August 08, 2011 Yum clean all

August 02, 2011 DB2 - ADMIN_DROP_SCHEMA to drop a schema

August 01, 2011 Database tuning and Operating System Tuning

July 30, 2011 Frequently Asked Questions

July 27, 2011 db2start at start up on Linux

July 26, 2011 DB2 PRUNE HISTORY

July 25, 2011 ADM6044E - DMS Container Space Full

July 21, 2011 List table constraints in DB2

July 20, 2011 How to grant select privileges on all tables for DB2

July 19, 2011 Database Tuning overview – Hardware Tuning

July 18, 2011 Performance Tuning series – Performance Stack

July 16, 2011 DB2 deactivate database

July 14, 2011 Database Tuning as a process and automation

July 13, 2011 Indexes in DB2

July 11, 2011 DB2 list schemas of a database

July 10, 2011 SQL30081N - ipclean and DB2

July 07, 2011 10 biggest DBA concerns

July 06, 2011 SQL5043N Support for one or more communications protocols failed to start successfully.

July 05, 2011 Database Tuning – Five Basic Principles according to Shasha

July 04, 2011 OLTP performance checklist

July 03, 2011 Database Architect versus Data Architect

July 02, 2011 Shared memory set problem on DB2

June 27, 2011 Software unit testing and DB2 sql loop test code

June 25, 2011 DB2 9 Fundamentals Certification

June 24, 2011 Data Center Migration , Database Servers and data migration planning

June 23, 2011 Database size in DB2

June 22, 2011 Advice for IT consultants

June 20, 2011 DB2 manager status and get snapshot for dbm

June 19, 2011 Reorg table DB2

June 17, 2011 Windows Server Uptime and Net Statistics Server

June 14, 2011 DB2 software requirements gathering for a new server

June 09, 2011 Create a DDL on an existing DB2 table

June 08, 2011 DB2 backup online summary

June 02, 2011 Data Centre management and database server migration planning

May 29, 2011 DBA Interview Questions and Answers – DB2 Security Management

May 26, 2011 Linux GET command returning a web page by default

May 24, 2011 DBA Interview Question and Answers for DB2

May 24, 2011 DBA Interview Questions and Answers – DB2 Server Operations

May 20, 2011 DB2 table reorg and table truncate

May 19, 2011 DB2 database design : physical design is important

May 17, 2011 ANE4007E and delete locked files

May 16, 2011 DB2 table size shell script

May 05, 2011 Linux server largest files

April 28, 2011 DB2 - SQL2033N and TSM reason code: 610

April 07, 2011 Vi : modes,open,quit ,help

March 31, 2011 How to use large BLOB/CLOB in HADR

March 08, 2011 Tivoli Storage Automation for Multiplatforms(SA MP) and the shared disk approach

February 23, 2011 DB2 Version 9.7 Documentation

February 18, 2011 DB2 - SQL1051N while Redirected Restore

February 09, 2011 DB2 logging factors and mincommit

February 04, 2011 DB2 Database Administration Server (DAS) Notes

February 02, 2011 DB2 Used Space and REORG

January 28, 2011 DB2 restore over existing database

January 24, 2011 Synchronous statistics collections

January 21, 2011 DB2 mysql export as output

January 19, 2011 DB2 extend database server capacity

January 15, 2011 DB2 enforcing business rules on data

January 12, 2011 DB2 Linux history command

January 10, 2011 DB2 and TSM Cross-node recovery

January 08, 2011 DB2 query processing order

January 06, 2011 Command to see connection on a DB2 database - list applications

January 05, 2011 Mysql connect details for Linux using Putty

January 03, 2011 DB2 Instance Memory and dbptnmem

January 01, 2011 DB2 SQL2413N - Online backup is not allowed

December 31, 2010 DB2 USERSPACE1 is full

December 30, 2010 DB2 V95 uninstall itma

December 05, 2010 DB2Autostart and DB2 fault monitor controller command

October 29, 2010 SQL0293N Error accessing a table space container. SQLSTATE=57048 and LinuxSheild

October 16, 2010 SQL0964C The transaction log for the database is full.

September 25, 2010 DB2 - Statistics last time updated

September 11, 2010 DB2 Database objects overviews

August 29, 2010 DB2 - A Security Primer

July 31, 2010 Quest 3.5.2 crashing DB2 9.5

July 17, 2010 Generate a key pair with ssh-keygen on Linux

July 09, 2010 db2move to copy data between databases

July 07, 2010 SQL0286N A default table space could not be found

July 05, 2010 Linux useradd not creating password

June 23, 2010 Name change from quickdb2.com to dba-db2.com

June 22, 2010 DIA8309C Log file was full and DB2 IMPORT

May 28, 2010 Monitor DB2 instance status and database status

May 24, 2010 TSM backup client configuration for DB2 on Linux

May 24, 2010 db2diag.log file delete on Linux and DB2

May 16, 2010 No memory available in Application Heap

May 16, 2010 Euro symbol and DB2 database codeset

March 27, 2010 Contact me Jack Vamvas

March 27, 2010 TSM losing connection with DB2

March 20, 2010 DM1823E - Log file has reached its saturation point

March 20, 2010 DB2 Indoubt transactions

March 20, 2010 ADM1823E active log file full

February 09, 2010 DB2 - truncate table

January 30, 2010 Trace sql statements in DB2 database

January 30, 2010 DB2 - table sizes

January 30, 2010 Linux - find largest files

January 12, 2010 DB2 Health Monitor-Monitor Heap Utilization

January 06, 2010 SQL1768N Unable to start HADR. Reason code = "1".

January 06, 2010 setuid for root and db2start

August 03, 2009 Force connections of a database in DB2

June 09, 2009 Current version of DB2 installed

April 21, 2009 DB2 - Backup all databases on Primary Server

March 20, 2009 How to run a sql script from Putty for DB2

January 09, 2009 Rename a DB2 database

December 20, 2008 DB21034E - Alter Table problem

December 20, 2008 ADM12017E - db2 license - add processor

December 20, 2008 db2diag.log file filling

November 21, 2008 Locate the DB2 connection port number on Linux

September 06, 2008 DB2 links


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright