Shell Scripts to DB2

No albums or photos uploaded yet.

Script to Check if Instance is running — by Vinícius Perallis — last modified 2008-12-13 14:56

 

KSH Script to check the dabatase and tablespace size in DB2 Databases — by Vinícius Perallis — last modified 2009-01-21 11:12

To execute the script: ksh database_size.ksh <database_name> - or - ksh database_size.ksh <database_name> report (to send the output to report file)

Grant privileges for a user or group on a specified schema — by Vinícius Perallis — last modified 2009-01-20 15:21

 

KSH Script to force all applications from a specified database — by Vinícius Perallis — last modified 2009-01-23 11:26

When you need to force all applications from just one database,perform this script KSH Script to force all applications from a specified database

Clean up DB2 backup images from TSM — by Vinícius Perallis — last modified 2009-05-22 16:48

This script deletes backup images from TSM. The numbers of backups to keep in TSM Server is given in a command line as parameter when the script is executed. . The backups from currently month are not deleted. Script Syntax: ./clean_backups_fromtape.ksh <database name> <number of backup images>

Script to calculate all user schemas size under a specified database — by Felipe Alkain de Souza — last modified 2010-01-02 19:10

This script calculates the size of all user schemas under a specified database as the total database size as well. It's usefull when migrating schemas among different databases.

Script to identify and automatically extend tablespaces following user parameters — by Felipe Alkain de Souza — last modified 2010-08-06 17:15

This script check the tablespaces that crossed the threshold specified and extend them following the parameter passed during script triggering.

Check parameter value from all your db´s — by Olivier Windels — last modified 2010-02-09 13:23

This script allows you to check what are the current and delayed values of a single database configuration parameter. Just supply the name of the parameter when you run the script.

Check parameter value from all your db´s II — by Olivier Windels — last modified 2010-02-19 16:51

I encountered an issue when the Directory entry type was Remote... here is the fix. Just supply the name of the parameter when you run the script.

Update parameter value from all your db´s — by Olivier Windels — last modified 2010-02-19 16:54

Based on another script, this one can update a parameter value for all the db´s you have in a single instance. To run it, supply parameter name and value.

The recovery history file. — by Olivier Windels — last modified 2011-02-14 12:04

The recovery history file keeps track of many useful events. Use scripts or administrative views to export and format the data contained in this file for future use.