Description

This internship will allow you to discover DB2-UDB in a Windows or Linux environment and will provide you with the necessary knowledge to be able to develop and ensure a first level of administration.

Who is this training for ?

For whom ?

All people required to develop or manage the UDB database at level 1.

Prerequisites

Know how to use the basic functions of an operating system.

Training objectives

Discover DB2-UDB< /a> in Windows environment

Provide the necessary knowledge to be able to develop and ensure a first level of administration

Working with UDB in a Linux< environment /a>/Unix

Training program

• Rappel's sur DB2 UDB
  • - Windows and Linux/Unix environments versus Z/OS
  • - Presentation of DB2 UDB
  • - The different editions of DB2
  • - Run Time Environment (RTE)
  • - Other products in the UDB range
  • - Architecture example
  • - Administrative tools
  • - Installed services
  • - Components of DB2 UDB
  • - The Control Center
  • - Client Configuration Wizard
  • - The Command Center
  • - The script management center
  • - The help and information center
  • - The logbook
  • - Command Line Processor
  • - Help
• Items
  • - Object hierarchy
  • - Systems
  • - Instances
  • - Database
  • - Tablespace
  • - Tablespace type
  • - Characteristics of user tablespaces
  • - Creation from the control center
  • - Data types
  • - DATE ​​and data TIME
  • - Terminology
  • - Creation from the control center
  • - Index. Creation from the control center
  • - General diagram
  • - UDB object naming rules
  • - Limits
• Installation et configuration
  • - User management with UDB
  • - The DBADM authority
  • - Other database users
  • - Granting and withdrawing rights : GRANT and REVOKE instructions
  • - At the database, schema, tables or views level
  • - Configuration of stations in a Windows environment
  • - Server and client workstation
  • - System architecture
• Import and export utilities
  • - Presentation
  • - File types. WSF, DEL, ASC, IXF file
  • - IMPORT, EXPORT and control center utilities
• Recovery utilities
  • - Presentation
  • - Definitions
  • - Logging. Circular and linear logging
  • - The BACKUP utility. Use. Syntax. Parameters
  • - Backup image
  • - BACKUP and Advanced Backup Center
  • - The RESTORE utility. Use, syntax, parameters
  • - RESTORE and Control Center. Advanced backup
  • - The ROLLFORWARD utility. Usage, syntax.
  • - ROLLFORWARD and control center
• Base Tracking Utilities
  • - Maintenance
  • - The RUNSTATS and REORGCHK commands