Resources

SubtopicFile
CSNTEP2  Details
statistic  Details
Check DB2 LUW invalid package  Details
DB2ClearOS - The All in One DB2 Express-C Web Stack Appliance.  Details
SQL One Liners  Details
Tuning with Virtual Indexes - A Brute-Force-Appoach  Details
test for DB2 Analytics Accelerator  Details
RI Relations  Details
luw  Details
Cross Platform DB2 in the Big Data World  Details
Cross Platform Difference between two timestamps in seconds  Details
Cross Platform More fun with Dates  Details
Cross Platform Pig Query  Details
Cross Platform Random Query  Details
Cross Platform Reporting tools evaluation form  Details
Cross Platform Generating different `current timestamps` in a single Statement  Details
Cross Platform Using Handlers in SQL SP  Details
Cross Platform Triggers to Implement Foreign Key Constraint Checking and Cascading Updates  Details
Cross Platform Numeric Formatter (add`s commas in number)  Details
Cross Platform JCC Trace Analyser  Details
DB2 for LUW Script to aid in identifying possible redundant indexes in a database  Details
DB2 for LUW Runstats information for range-partitioned tables & their indexes and statistical views  Details
DB2 for LUW DubuntuX - All in one DB2 Stack  Details
DB2 for LUW Lock wait analysis: using db2pd  Details
DB2 for LUW Script to check the space , take Backup and copy to another server and delete Old Backups  Details
DB2 for LUW Packet sniffing the DRDA protocol  Details
DB2 for LUW Checking Utility Calls in ETL Tools  Details
DB2 for LUW Checking Utility Calls in ETL Tools  Details
DB2 for LUW DB2 Extract Database Size Information from UNIX List Commands  Details
DB2 for LUW Using the DB2 9 admin views to monitor your database  Details
DB2 for LUW DB2 Backup Environment Script as part of a Disaster Recovery Plan  Details
DB2 for LUW DB2 Table Load and Index Build Information from DB2 Diagnostic Log File - STMM info too  Details
DB2 for LUW Who owns locks  Details
DB2 for LUW EU 2004: Monitoring Your Database with just SQL Scripts - the scripts  Details
DB2 for LUW admin and monitoring scripts  Details
DB2 for LUW Compression estimator - DB2 for LUW users working with v7 or v8  Details
DB2 for LUW Creating a \hot\" backup server"""  Details
DB2 for LUW DB2 LUW Runstats  Details
DB2 for LUW Diagnostic_Utility  Details
DB2 for LUW DB2 Backup Report  Details
DB2 for LUW db2list_candidate_tablespaces_for_conversion.ksh  Details
DB2 for LUW Readable High2Key and Low2Key  Details
DB2 for LUW db2list_candidate_tables_for_compression.ksh  Details
DB2 for LUW Finding application using maximum log space  Details
DB2 for LUW Force applications to specified Authentication ID  Details
DB2 for LUW List Tablespace Usage Information  Details
DB2 for LUW Space monitoring in DB2 AIX  Details
DB2 for LUW Fun with Recursive SQL  Details
DB2 for LUW List Tablespace Container Information  Details
DB2 for LUW Purging of data based on colname and date  Details
DB2 for LUW copying and pruning logs using scp and perl  Details
DB2 for LUW Time Delay in SQL  Details
DB2 for LUW Used pages for DMS tablespaces  Details
DB2 for LUW Store Tablespace Info in a table  Details
DB2 for LUW Force Connected applications  Details
DB2 for LUW DB2 for LUW : date format  Details
DB2 for LUW UDF to generate a table from a comma-separated list of values  Details
DB2 for LUW Listing the DB2 Isolation level special register  Details
DB2 for LUW Change the input string to Title Case  Details
DB2 for LUW DDL for storing extracted db2audit information  Details
DB2 for LUW Display Node.dcs & DB directory in Tab form PERL  Details
DB2 for LUW procedural SQL in triggers on AIX  Details
DB2 for LUW DB2 LUW WLM - Quick Tips - SQL Select Statements and db2pd utility to capture SQL  Details
DB2 for LUW Reorganize partitioned table script  Details
DB2 for LUW db2perf_wait.db2 - show DB2 LUW wait time percentage breakdown  Details
DB2 for LUW Script to find the High Impact SQL's in the database which are CPU Bound and IO Bound  Details
DB2 for LUW Script to Monitor the Table and Index Scans in the database  Details
DB2 for LUW Some helpful DB2 LUW sql and db2cos script discussion  Details
DB2 for LUW Script to find out the Long Running SQL's in the database  Details
DB2 for LUW Script to Check the Log Utilization space in the database  Details
DB2 for LUW DB2 LUW - (MS Windows) PowerShell Script for Generating and Executing Runstats  Details
DB2 for LUW DB2 LUW - (MS Windows) PowerShell Script for Generating and Executing Runstats  Details
DB2 for LUW DB2 LUW - (MS Windows) PowerShell Script for Generating and Executing Runstats  Details
DB2 for z/OS RXSQL: Process SQL file input from a file with LRECL > 72  Details
DB2 for z/OS REXX to interpret DBRM - exec  Details
DB2 for z/OS RUNSQL  Details
DB2 for z/OS Thread cancel stored procedures & ISPF v3  Details
DB2 for z/OS Unload JCL example from imagecopy (V7)  Details
DB2 for z/OS Rexx Unload and Load Program  Details
DB2 for z/OS REXX exec to find DB2 precompiler timestamps in load modules - Enterprise PL/I only  Details
DB2 for z/OS RUNSQL - advanced diagnostics and tracing for DSNREXX  Details
DB2 for z/OS Z/OS DB2LOOK  Details
DB2 for z/OS Assembler program to extract IFCID data from SMF records  Details
DB2 for z/OS Another DBRM interpreter - V8 ready  Details
DB2 for z/OS Space calculation spreadsheet  Details
DB2 for z/OS REXX to Create a DSNTIJUZ Zparm job from active Zparms  Details
DB2 for z/OS Table of WLM Classification Codes  Details
DB2 for z/OS Explain Comparison DB2 V8 NFM  Details
DB2 for z/OS REXX to interpret DBRM - panel: update  Details
DB2 for z/OS DB2 for zOS Explain Compare  Details
DB2 for z/OS Customize Explain for your application  Details
DB2 for z/OS Clone of DSNTEP2 that supports report width up to 4000 bytes  Details
DB2 for z/OS Painlessly call DSNTIAR from Rexx  Details
DB2 for z/OS List active thread & cancel  Details
DB2 for z/OS Returns a list of all libraries in the Z/OS LinkList  Details
DB2 for z/OS TSO Clear Screen Rtn  Details
DB2 for z/OS list DSNWZP output (dsnZPARM/HDECP)  Details
DB2 for z/OS Automatic JCL creation for GRANT+SYNONYM+BIND statements before a DB2 table DROP-CREATE event  Details
DB2 for z/OS REXX to interpret DBRM - messages  Details
DB2 for z/OS REXX routine to build VSAM DEL/DEF  Details
DB2 for z/OS Describe Table for DB2 z/OS  Details
DB2 for z/OS DB2 Row Numbers for Z/OS, OS/390 (Versions 6, 7, and 8)  Details
DB2 for z/OS IFI READS Cobol UDF  Details
DB2 for z/OS Automated Image Copies  Details
DB2 for z/OS Returns a List of all libraries that are APF Authorized  Details
DB2 for z/OS Check your package sizes in the SPT01 before going to V8  Details
DB2 for z/OS SSID Validation Routine  Details
DB2 for z/OS Cobol Program that will compare V7 Plan Table rows to V8 Plan Table Rows  Details
DB2 for z/OS Cleanup of DB2 Plan_table  Details
DB2 for z/OS Fixes for ODOT's DB2;DBA's Assistant (previous version)  Details
DB2 for z/OS SQL Checker  Details
DB2 for z/OS VARCHAR column placement guidelines to minimize logging  Details
DB2 for z/OS WLM Command Stored Procedure Panel  Details
DB2 for z/OS Read & Analyze SYSSUMRY FILE FROM DSN1LOGP  Details
DB2 for z/OS Table access analysis  Details
DB2 for z/OS DESCribe Trigger definition  Details
DB2 for z/OS REXX DB2 processor  Details
DB2 for z/OS V7-Views on V8-catalog  Details
DB2 for z/OS DB2TOKEN  Details
DB2 for z/OS REXX CLIST to interpret a DBRM  Details
DB2 for z/OS REXX to update DSNTIJNE sizing  Details
DB2 for z/OS REXX exec to check consistency tokens  Details
DB2 for z/OS Totals the space used by a list of datasets  Details
DB2 for z/OS Check for completion of archive log  Details
DB2 for z/OS recommendations for the various online reorg parms  Details
DB2 for z/OS REXX to restore a (dropped) TS from a Full Copy  Details
DB2 for z/OS WAITFOR REXX  Details
DB2 for z/OS Display Plan table results in batch  Details
DB2 for z/OS new version of DSN1COPY  Details
DB2 for z/OS Sample DDL for a DSN_STATEMENT_TABLE  Details
DB2 for z/OS DB2 Subsystem Menu  Details
DB2 for z/OS SQL to show which Package assigned with which Plan  Details
DB2 for z/OS Retrieve file information using the CSI  Details
DB2 for z/OS Read SYSLGRNX Directory using SAS  Details
DB2 for z/OS List Tables in a subsystem  Details
DB2 for z/OS MVS Wait module for -911/-904 situations  Details
DB2 for z/OS edit macro  Details
DB2 for z/OS insert DB2 source code for Declare, Fetch, Insert, Delete, Update, Select statements at Cobol source code.  Details
DB2 for z/OS Generate alters to resize TS & IX  Details
DB2 for z/OS REXX to find bad package binds from bind job listing  Details
DB2 for z/OS V7 version of the Cat/Dir REORG JCL and other helpful JCLs  Details
DB2 for z/OS Insight/DB2 trace-request into a DB2 table  Details
DB2 for z/OS Sub-System ID w/Package name report with access type  Details
DB2 for z/OS Kill distributed threads accessing a TS (-partition)  Details
DB2 for z/OS z/OS v8 - bit data in sysstmt  Details
DB2 for z/OS Drop Tablespace(s) with very low catalog contention  Details
DB2 for z/OS Rexx to interpret DBRM - panel and message  Details
DB2 for z/OS SQL Processor (like DSNTIAD w/twist)  Details
DB2 for z/OS REXX ISO and DB2 dates  Details
DB2 for z/OS Soundex sql funtion in DB2 Version 7  Details
DB2 for z/OS Managing DB2 for Z/OS through the WAP and Web Environments  Details
DB2 for z/OS Homogeneous System Copy JCL  Details
DB2 for z/OS SSID Library Assignment  Details
DB2 for z/OS Edit macro for incrementing a value  Details
DB2 for z/OS Wait for no active Utilties Then Term. STOPPED Utilities. REXX  Details
DB2 for z/OS UPDATED - query to list OBIDs by database  Details
DB2 for z/OS Plan purge REXX  Details
DB2 for z/OS query and manipulate to know the order in which the trigger is created  Details
DB2 for z/OS REXX to interpret DBRM - exec  Details
DB2 for z/OS REXX to interpret DBRM - exec  Details
DB2 for z/OS ODOT's "DB2 DBA's Assistant" plus "CRM ISPF Productivity Tool"  Details
DB2 for z/OS SQL to show number of levels of RI in a database schema  Details
DB2 for z/OS Generating subsytem Zparms report thru DSN8ED7  Details
DB2 for z/OS Menu of DB2 subsystems  Details
DB2 for z/OS DB2 ZPARM Listing  Details
DB2 for z/OS DB2 ZPARM Listing  Details
DB2 for z/OS CTE to get the total # of objects in a subsystem  Details
DB2 for z/OS RTS Tablespace Capacity Report  Details
DB2 for z/OS Sort tape datasets by physical sequence  Details
DB2 for z/OS Initialize RTS from DB2 Catalog for DB2 V8 NF mode and above  Details
DB2 for z/OS REXX to find subsystem wide allocated space for DB2 z/OS  Details
DB2 for z/OS Rexx to decode DB2 statistics (SMF100)  Details
DB2 for z/OS Rexx to decode DB2 statistics (SMF100)  Details
DB2 for z/OS Sample rexx code to decode DB2 accounting (SMF 101)  Details
DB2 for z/OS DB2 z/OS Catalog,Directory and SYSXSR documentation builder  Details
DB2 for z/OS Initialize RTS from DB2 Catalog for DB2 V8 NF mode and above  Details
DB2 for z/OS Derive DB2 Dataset Names from the Catalog  Details
DB2 for z/OS ALTER TABLE ALTER PARTITION ENDING AT (Date sequence)  Details
DB2 for z/OS COPY TABLE GRANTS SQL  Details
DB2 for z/OS COPY TABLE GRANTS SQL  Details
DB2 for z/OS HEX2DEC  Details
DB2 for z/OS ALTER TABLE ALTER PARTITION ENDING AT (Date sequence)  Details
DB2 for z/OS BIT2NUM  Details
DB2 for z/OS HEX2BIT  Details
DB2 for z/OS DT2B2DT  Details
DB2 for z/OS SQL to extract low2key & high2key values for DECIMAL data  Details
DB2 for z/OS REXX Program to Retry EXCHANGE CLONE TABLE a Configurable number of times  Details

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.