DB2 – DBA Scripts

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

Troubleshooting

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

Backup\Restore

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.