Vikas

Mainframe DB2 DBA Training on z/OS - Starting new batch very soon



I am conducting a new batch for DB2 DBA Training on Mainframes z/OS very soon. Training will be given by Real Time Working Professional in Industry having Around 10 years of experience. I will provide live examples of production and test DB2 DBA issues.

Here are the list of topics covering.

DB2 Mainframe Database Administrator.
â?¢ Extensive experience in utilities and tools used for database monitoring (online performance monitors, reports, EXPLAIN, DB2 catalog queries) data movement and organization (LOAD, UNLOAD, REORG) data consistency utilities and catalog manipulation utilities (RUNSTATS, MODIFY, STOSPACE) etc.
â?¢ Highly involved in performance tuning like performing REORGS, RUNSTATS on the database tables frequently.
â?¢ Experience with DB2 utilities like Image Copy, DSN1COPY, Merge Copy, Check data on ZOS.
â?¢ Strong experience in creating DB2 database data objects like table spaces, tables, Views and Indexes.
â?¢ Experience using BMC tools.
â?¢ Having good experience in performance issues running STROBE reports.
â?¢ Having theoretical knowledge in IMS Databases.
â?¢ Proficient in daily support activities which include maintaining and testing backups, monitoring logs, monitoring thread activity, resolving job abends and scheduling administration activities.
â?¢ Expertise in application development support activities including database design optimizing SQL queries, building complex SQLs ,dynamic SQLs and triggers, effective binding of packages and plans, concurrency planning, data refreshing and database objects migration across regions.

Tools:

Omegamon, Mainview,Aptune, DB Tool Box.Change Manager.