DB2 – DBA Scripts

06 October,2012 by Tom Collins

There are powerful DBA scripts  for DBA in this post that will help you build a strong foundation in managing  DB2 Database Servers.  For other topics use the search

I’ll keep adding more DBA scripts to this post. Contact me  for any other DBA  scripts

 Last Updated 22nd January  2016


Force connections of a database in DB2

Linux - find largest files

Monitor DB2 instance status and database status

Command to see connection on a DB2 database - list applications

Linux server largest files

DB2 deactivate database

Linux Server OS information

DB2 instance startup time

DB2 – verify DB2 is available


DB2 - Backup all databases on Primary Server

DB2 – check backup command and contents of a database

Object Management

DB2 - table sizes

DB2 - truncate table

db2move to copy data between databases

DB2 table size shell script

DB2 table reorg and table truncate

Create a DDL on an existing DB2 table

Database size in DB2

DB2 health script

DB2 – COPY a table

DB2 – Managing Diagnostic Logs

How to check reclaimable space enabled on DB2 tablespace with MON_GET_TABLESPACE new

Dropping all tables from a DB2 schema new

Index management

DB2 - Statistics last time updated

Reorg table DB2

Performance Management

Querying Bufferpools DB2

Security Management

DB2 security audit

DB2 – Audit Failed logons

DB2 – Backup history



 Copyright c 2016 – +Jack Vamvas. All rights reserved. No

part of these scripts may be reproduced, translated, posted or shared in any

form, by any means.

The information provided in this post is provided "as is" with no implied

warranties or guarantees.



Author: Rambler(http://www.dba-db2.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on DB2 – DBA Scripts

Comments are moderated, and will not appear until the author has approved them.

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