DB2 UDB for z/OS and OS/390 V7 Database Administration Workshop

course content details

	CF830 to CF840 transition

transition from CF830 to CF840

	LOAD and REBUILD INDEX performance and availability

	apply performance feature SORTKEYS for LOAD and REBUILD INDEX
	build indexes in parallel during LOAD and REBUILD INDEX
	establish inline statistics during LOAD and REBUILD INDEX
	load partitions for a partitioned table space in parallel
	use the availability feature for LOAD: Online LOAD (SHRLEVEL, CHANGE, RESUME, and YES)

	Exercise 1 - LOAD and REBUILD INDEX performance and availability

	enable parallelism for loading data and building indexes
	explain benefits of online LOAD

	REORG and UNLOAD performance and availability

	apply the performance features for REORG: SORTDATA, NOSYSREC, and SORTKEYS
	build indexes in parallel during REORG
	use the availability features for REORG: Read-only Online REORG (SHRLEVEL REFERENCE), Full Online REORG (SHRLEVEL CHANGE)
	establish inline statistics during REORG
	rebalance partitions of a partitioned table space
	explain the performance and availability features of UNLOAD

	Exercise 2 - REORG and UNLOAD performance and availability

	rebalance partitions of a partitioned table space
	perform an online REORG with SHRLEVEL CHANGE

	Generic utility jobs

	provide reusable list definitions for use by the DB2 utilities
	use list definitions in utility control statements and understand how they expand
	describe the concept and working of templates replacing utility Dataset Definition (DD) statements
	use templates in utility jobs to simplify Job Control Language (JCL)
	use templates together with list definitions
	use the OPTIONS utility control statement to control execution parameters for utility jobs

	Exercise 3 - generic utility jobs

	create reusable list definitions for use by DB2 utilities
	use list definitions in utility control statements and understand how they expand
	create templates for dynamic allocation of utility data sets
	use templates in utility jobs to simplify JCL
	use templates together with list definitions
	use OPTIONS control statement to control execution parameters for utility jobs

	Program preparation and use of packages

	exercise steps required to prepare and execute a DB2 program
	learn what the collections are and how to use them
	resolve the most common SQLCODE-805 errors
	learn how to access different tables or views at execution time without changing the program
	learn how to handle mirror tables
	learn concepts of package versioning

	Exercise 4 - program preparation and use of packages

	identify steps necessary to run a program in DB2 environment
	prepare a program for execution using provided jobs
	use qualifier in the bind process to determine which table or view the program accesses
	switch between different tables or views by changing the collection
	resolve normal occurrences of SQLCODE -805
	explain when automatic REBINDS are necessary

	User-defined Distinct Types (UDT), User-Defined Functions (UDF) and stored procedures

	implement and maintain UDTs
	implement and maintain UDFs
	implement and maintain stored procedures

	Exercise 5 - UDFs

perform the database administration tasks required to support UDF

	Triggers

perform those database administration task which relate to the implementation and maintenance of triggers

	Exercise 6 - triggers

	define triggers to meet specific business requirements
	verify that the defined triggers behave as you intended

	Large objects

perform those database administration task which relate to the implementation and maintenance of large objects

	Exercise 7 - large objects

	define DB2 objects to store large objects
	load large objects using the LOAD utility
	describe the statistics gathered by the RUNSTATS utility for large objects

	Performance-related topics

	explain good performance
	evaluate how table implementation impacts performance
	explain the basics of the queuing theory
	discover hot spots and cool them

	Locking

	choose the appropriate LOCKSIZE
	explain lock escalation
	describe when locks are taken and when they are released