Northwest Regional Data Center

The Ultimate Solution to Simplify Your Data Center

DB2 on zOS

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

 

VENDOR  
IBM

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)
  • FOCUS (IBI)
  • IWay (IBI)

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

R-TOOLS

CA-Insight

 

Batch Procedures for DB2

Procedure Description
DSNUPROC Generalized Utility execution
QMF QMF batch procedure execution

 Please review the instructions documented in each procedure.