Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Db2: Database Administration - Linux

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



MFRDB44

Db2: Database Administration - Linux
DURATION: 4 days

FEE: $1,980

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Programmer
  • Database Administrator
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Database Administration Tasks
      • Create databases, tables, indexes, and aliases.
      • Alter a table and recreate an index.
      • Configure communication protocols to use with the DAS: Db2 Administration Server service and Db2 instances.
      • Create the necessary userids and groups.
      • Define an instance at installation time.
      • Increase the volume space associated with a tablespace.
      • Improve performance, update statistics, and reorganize the data.
      • Run the utilities: REORG, RUNSTAT, STOSTAT, COPY, and CHECK.
    2. Db2 Instance Creation
      • Configure the database instance.
      • Create a DAS: Db2 Administration Server.
      • Configure TCP/IP communications for the Db2 instance.
    3. Populating Databases
      • Exporting data from the database.
      • Importing data from files into database tables.
      • Loading data from files into database tables.
    4. Logical Design for Supporting Concurrency
      • Setting isolation levels.
      • Handling deadlocks.
    5. Recovery
      • Backing up a database.
      • Restoring a table.
    6. File System and Db2
      • Check the file system caching status.
    7. Authorization
      • Create users and group for application developers.
      • Create users and groups for application users.
    8. Operating System Functions
      • Collect information about the database.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.