If you have any questions about the content of this page, please email DB2Request for clarification

DB2 is a relational data base and is the data base of choice at NWRDC.

DB2 can be accessed by

• Batch Jobs
• COBOL programs
• Easytrieve programs
• Batch TSO programs
• CICS applications
• Shadow Web applications (Neon Systems)
• Shadow Direct -ODBC connections (Neon Systems)
• DB2 Connect (IBM)
   

DB2 at NWRDC

• Current News (Current release, what’s new, what’s changing)
• Executing a Query from ISPF Edit
• Remote Access (getting connected via TCP/IP)
• Subsystems (what to set it to and when)
• Naming Conventions
• Bufferpool Management (recommendations for bufferpool assignments)
• Security
• Separation of test and production
• Version Notes
• Batch Procedures
• Backup and Recovery (DB2 log persistence and image copy responsibility)

DB2 Support Tools

TSO DB2 Panel

• Interactive Functions
  • SPUFI
  • DCLGEN
  • Program Preparation
  • Precompile
  • Bind/Rebind/Free
  • Run
  • DB2 Commands
  • Utilities
  • DB2I Defaults
     
• BMC Administrative Tools
  • ALTER
  • Catalog Manager
     
• R-TOOLS
  • ACCESS for DB2
  • MOVE for DB2
     
• QMF

Monitoring Tool

• TMON for DB2

Batch Procedures for DB2

 Please review the instructions documented in each procedure.