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