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

Monday, June 5th

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, June 5th
- 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.

Saturday, June 10th

NWRDC Facility Electrical Work
- Calendar: NWRDC Maintenance
- Start date: Saturday, June 10th
- Start time: 07:30am
- End time: 01:00pm
- Northwest Regional Data Center (NWRDC) would like to inform you of upcoming maintenance:Service(s): NWRDC Facility Electrical WorkMaintenance Start Time: Saturday, June 10, 2023 – 0730 (ET)Maintenance End Time: Saturday, June 10,2023 – 1300 (ET) Service Availability: No downtime Expected Details: Customer electrical installation and removal of deactivated cables. Questions?We're 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.

Monday, June 12th

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, June 12th
- 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, June 19th

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, June 19th
- 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, June 26th

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, June 26th
- 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.

Tuesday, June 27th

NWRDC Policy Board Meeting
- Calendar: NWRDC Meetings
- Where: FLVC Auditorium - 1753 W Paul Dirac Dr, Tallahassee, FL 32310
- Start date: Tuesday, June 27th
- Start time: 10:00am
- End time: 03:00pm
- Quarterly 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, July 3rd

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, July 3rd
- 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, July 10th

Mainframe IPL
- Calendar: NWRDC Maintenance
- Where: NWRDC
- Start date: Monday, July 10th
- 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.