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

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

Duration

2 days

Price

£ 1738

Audience

Database administrators

Prerequisites

Notions of Windows or UNIX system administration

Reference

BAS292-F

Sessions

Contact us for more informations about session date