Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 126

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 127

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 126

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 127

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 126

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 127

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 126

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 127

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 126

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 127

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 126

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 127

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 126

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 127

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 126

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/acratrai/public_html/wp-content/themes/_classes/LandingPage.php on line 127
DB2 Data Base Administration

DB2 Data Base Administration

Course Title: DB2 Data Base Administration

Course#: DB13T

Duration: 5 days

Overview:

The student will learn how to normalize a relational database, and how to define DB2 objects, including Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, and Aliases. The student will also develop a proficiency in loading, modifying, backing up, recovering, and tuning DB2 Data bases, using DB2 utilities, services aids, and catalog tables.

Topics:

  • DB2 architecture
  • Data base design
  • Entity / Relationship Model
  • Normalization
  • Primary and foreign keys
  • DB2 objects
  • Creating Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, Synonyms, and Aliases
  • VSAM file allocation
  • Referential integrity
  • DB2 catalog tables
  • Space estimates
  • Loading and unloading tables
  • Reorganizing table spaces
  • Backup and recovery
  • Data base tuning
  • Application tuning
  • Data Security
  • Distributed processing

Exercises:

There are ten machine exercises, and two paper exercises.

Audience:

Experienced DB2 programmers and Data Base Analysts who will design and implement DB2 Data Bases.

Prerequisites:

The student entering this course should be familiar with DB2 concepts, have a basic proficiency with SQL data manipulation verbs, have experience in using ISPF/PDF, and should be able to code JCL to run simple batch jobs.






















All Contents Copyright © 2009 | Powered By KickMy.com