IDUG Codeplace Library
Get the latest scripts, commands, tutorials and useful tips from your DB2 peers.To submit your own code to share on Codeplace, click here.
Click Here to view our full listing of Codeplace Files Available.
Non-Members may download a few of our more popular Codeplace files as samples (presented in their entirety). If you are not a member, please CLICK HERE for more information.
- DB2 Extract Database Size Information from UNIX List Commands
Have you ever run the db2 [call get_dbsize_info(?,?,?,0)] command to get the size of your DB2 LUW database and noticed that the size is much smaller than the space used on your UNIX file systems? Do you need to monitor database growth over time to help plan for future storage requirements? This article describes a script that will calculate the size of a DB2 LUW database on a UNIX server using UNIX commands that will give you a more accurate measure of the space used by the database. This script also stores this information in an operational table that you may use as part of your;DBA Monitoring Dash Board to help you monitor and manage space in relation to growth trends.
- REXX to interpret DBRM - exec
This is a major update to the DBRMMAP code originally written by Ron Root. This exec goes with the panel and messages from May 1 2008 in Code Place. It adds many enhancements to the ISPF handling (eg. enter DBRMMAP beside member in memberlist or enter TSO %DBRMMAP), corrects some errors, converts UTF-8 to EBCDIC for DB2 V8 or 9 members, shows contoken & converts it to a timestamp, can show long SQL statements, and shows new data types for DB2 9.
- Thread cancel stored procedures & ISPF v3
Thread cancel SP/ISPF panel. Users display active threads/issue a cancel. Display threads by SSID, connection, pgm, user id. token to 7 bytes, split MVS SSID. (UPDATED split MVS ssid from token field into own field, allow a full 8 char MVS ssid)
I recently sent you RUNSQL in XMIT unload format. Here it is again in a simple .txt file.
- Using the DB2 9 admin views to monitor your database
This is a set of SQL scripts that accompany Chris' IDUG Europe 2008 and IDUG NA 2008 presentation entitled 'Using the New Admin Views to Monitor Your Database. The files show you how to query the administrative views in DB2 9 with practical examples for monitoring the health and performance of your database.