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.
CONTENT AND OBJECTIVES:
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.
Db2 Instance Creation
Configure the database instance.
Create a DAS: Db2 Administration Server.
Configure TCP/IP communications for the Db2 instance.
Exporting data from the database.
Importing data from files into database tables.
Loading data from files into database tables.
Logical Design for Supporting Concurrency
Setting isolation levels.
Backing up a database.
Restoring a table.
File System and Db2
Check the file system caching status.
Create users and group for application developers.
Create users and groups for application users.
Operating System Functions
Collect information about the database.
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.