DB2 on zOS

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

Vendor	Documentation
IBM	DB2 V10 for z/OS
	Batch Procedures for DB2

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 (Progress Software)
Shadow Direct -ODBC connections (Progress Software)
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

Batch Procedures for DB2

Procedure	Description
DSNUPROC	Generalized Utility execution
QMF	QMF batch procedure execution

Please review the instructions documented in each procedure.

NWRDC Maintenance and Meetings Calendar

Tomorrow

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, October 2nd
- Start time: 02:00am
- End time: 06:00am
- Mainframe system time begins at 2:00AM Monday mornings. The system is shutdown to a minimal state to allow for a pristine snapshot of all DASD volumes. Maintenance and upgrades are typically scheduled during this time as well. An IPL is performed before production services are made available by 6:00AM.
- Click for details on Google calendar.

Wednesday, October 4th

NWRDC BaaS Maintenance in Atlanta
- Calendar: NWRDC Maintenance
- Start date: Wednesday, October 4th
- Start time: 09:00am
- End time: 08:00pm
- Northwest Regional Data Center (NWRDC) would like to inform you upcoming BaaS maintenanceService(s): Atlanta Backup and Recovery ServicesMaintenance Start Time: Wednesday, October 4, 2023 0900 (ET)Maintenance End Time: Wednesday, October 4, 2023 2000 (ET)Service Availability: Atlanta BaaS Service InterruptionDetails: We will be performing a hardware upgrade to the Data Domain in Atlanta. During the maintenance, this Atlanta Data Domain and Atlanta Backup and Recovery Services will be offline, and there will be no backup or recovery activities possible for the Atlanta Avamar or Atlanta Networker during the upgrade. We will make our best effort to keep the outage as short as possible. We thank you for your patience as we work to improve Backup and Recovery services at the data center. Questions?We are here to help. If you experience issues after the maintenance has concluded or have any questions, please contact the NWRDC Operations Team at (850) 645-3500, it_support@nwrdc.fsu.edu.
- Click for details on Google calendar.

Friday, October 6th

NWRDC Policy Board Meeting
- Calendar: NWRDC Meetings
- Start date: Friday, October 6th
- Start time: 02:00pm
- End time: 04:00pm
- Meeting of the NWRDC Policy Board. If you are interested in attending this meeting, please contact kate_wasson@nwrdc.fsu.edu.
- Click for details on Google calendar.

Monday, October 9th

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, October 9th
- Start time: 02:00am
- End time: 06:00am
- Mainframe system time begins at 2:00AM Monday mornings. The system is shutdown to a minimal state to allow for a pristine snapshot of all DASD volumes. Maintenance and upgrades are typically scheduled during this time as well. An IPL is performed before production services are made available by 6:00AM.
- Click for details on Google calendar.

Monday, October 16th

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, October 16th
- Start time: 02:00am
- End time: 06:00am
- Mainframe system time begins at 2:00AM Monday mornings. The system is shutdown to a minimal state to allow for a pristine snapshot of all DASD volumes. Maintenance and upgrades are typically scheduled during this time as well. An IPL is performed before production services are made available by 6:00AM.
- Click for details on Google calendar.

Monday, October 23rd

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, October 23rd
- Start time: 02:00am
- End time: 06:00am
- Mainframe system time begins at 2:00AM Monday mornings. The system is shutdown to a minimal state to allow for a pristine snapshot of all DASD volumes. Maintenance and upgrades are typically scheduled during this time as well. An IPL is performed before production services are made available by 6:00AM.
- Click for details on Google calendar.

Monday, October 30th

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, October 30th
- Start time: 02:00am
- End time: 06:00am
- Mainframe system time begins at 2:00AM Monday mornings. The system is shutdown to a minimal state to allow for a pristine snapshot of all DASD volumes. Maintenance and upgrades are typically scheduled during this time as well. An IPL is performed before production services are made available by 6:00AM.
- Click for details on Google calendar.

Monday, November 6th

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, November 6th
- Start time: 02:00am
- End time: 06:00am
- Mainframe system time begins at 2:00AM Monday mornings. The system is shutdown to a minimal state to allow for a pristine snapshot of all DASD volumes. Maintenance and upgrades are typically scheduled during this time as well. An IPL is performed before production services are made available by 6:00AM.
- Click for details on Google calendar.