ibm db2

Goals


- Perform any schemas and queries on DB2-UDB

- Know the main functions of the server

- Install, maintain, administer and optimize a DB2 UDB server

Program

DB2-UDB installation and general maintenance reminders
Presentation of an existing database

Presentation
Formats used: WSF, DEL, ASC, IXF files
Commands available and supervision by the control center

Presentation of the recovery unit
Logs (circular / linear logging )
Backup: images, installation and configuration of the BACKUP tool
The RESTORE and ROLLFORWARD utilities: use, optimization

Performance monitoring (RUNSTATS)
Server maintenance (REORGCHK)
Observation of limits and general optimization

Duration

2 days

Price

£ 1111

Audience

Everyone

Prerequisites

DB2 administration concepts

Reference

BAS293-F

Sessions

Contact us for more informations about session date