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