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
History, versions and licenses of DB2-UDB
Other products in the UDB range
Choice of platform (Windows / Linux / Unix or Z / OS)
Roles and stakeholders of a database
Other concurrent systems
Installation and minimal configuration
Active DB2-UDB components
Primary users and access rights
Tablespace systems, instances and databases : definition, type, characteristics
Tables, views, indexes and schemas
SQL language; DB2 standards and features
Multiple joins, stored procedures
Elements of time optimization for queries
Wizards, Help and Information Center
Administration
tools available Scripting tools
Users and security: authentication modes, accounts, roles, permissions
Various automation of administration tasks
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
5 days
Price
£ 2599
Audience
Database administrators
Prerequisites
Notions of Windows or UNIX system administration
Reference
BAS291-F
Sessions
Contact us for more informations about session date